import org.springframework.data.jpa.repository.JpaRepository;

public interface ElderlyRepository extends JpaRepository<Elderly, Long> {
}
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.Date;
import java.util.List;

public interface AssessmentRepository extends JpaRepository<Assessment, Long> {
@Query("SELECT a FROM Assessment a WHERE a.elderly.id = :elderlyId AND a.assessmentDate BETWEEN :startDate AND :endDate")
List findByElderlyIdAndAssessmentDateRange(@Param("elderlyId") Long elderlyId, @Param("startDate") Date startDate, @Param("endDate") Date endDate);
}
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class ElderlyService {
@Autowired
private ElderlyRepository elderlyRepository;

public Elderly saveElderly(Elderly elderly) {
    return elderlyRepository.save(elderly);
}

public List<Elderly> getAllElderly() {
    return elderlyRepository.findAll();
}

}
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;

@Service
public class AssessmentService {
@Autowired
private AssessmentRepository assessmentRepository;

public Assessment saveAssessment(Assessment assessment) {
    return assessmentRepository.save(assessment);
}

public List<Assessment> getAssessmentsByElderlyIdAndDateRange(Long elderlyId, Date startDate, Date endDate) {
    return assessmentRepository.findByElderlyIdAndAssessmentDateRange(elderlyId, startDate, endDate);
}

}
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/elderly")
public class ElderlyController {
@Autowired
private ElderlyService elderlyService;

@PostMapping("/register")
public Elderly registerElderly(@RequestBody Elderly elderly) {
    return elderlyService.saveElderly(elderly);
}

@GetMapping("/all")
public List<Elderly> getAllElderly() {
    return elderlyService.getAllElderly();
}

}
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.Date;
import java.util.List;

@RestController
@RequestMapping("/assessment")
public class AssessmentController {
@Autowired
private AssessmentService assessmentService;

@PostMapping("/save")
public Assessment saveAssessment(@RequestBody Assessment assessment) {
    return assessmentService.saveAssessment(assessment);
}

@GetMapping("/query")
public List<Assessment> queryAssessments(@RequestParam Long elderlyId, @RequestParam Date startDate, @RequestParam Date endDate) {
    return assessmentService.getAssessmentsByElderlyIdAndDateRange(elderlyId, startDate, endDate);
}

}