레거시 Repository 코드 리팩토링 (with. Spring Data, 변경 감지, 엔티티 조회)

@Repository @RequiredArgsConstructor public class AgentRepository { private final EntityManager em; // save public void save(Agent agent) { em.persist(agent); } // find public Agent findById(Long id) { return em.find(Agent.class, id); } public List<Agent> findByCode(String code) { return em.createQuery("select a from Agent a where a.code =:code", Agent.class) .setParameter("code", code) .getResultList(); } public List<Agent> findAll() { return em.createQuery("select a from Agent a", Agent.class).getResultList(); } public List<Agent> findAllByNameDESC() { return em.createQuery("select a from Agent a order by a.name desc ", Agent.class).getResultList(); } }

public interface AgentRepository extends JpaRepository<Agent, Long> { // 나머지는 JpaRepository 인터페이스에 이미 정의되어 있어서 별도로 정의할 필요조차 없음 // 커스텀 쿼리 메서드들만 정의 (메서드 이름을 통해 쿼리를 정의함) List<Agent> findByCode(String code); List<Agent> findAllByOrderByNameDesc(); }

// 리포지토리 @Override @Modifying public void updateScheduleComplete(Long scheduleId, Complete complete) { em.createQuery("update Schedule schedule set schedule.complete = : complete where schedule.id = : schedule_id") .setParameter("schedule_id", scheduleId) .setParameter("complete", complete) .executeUpdate(); }

// 서비스 @Transactional public void cancelSchedule(Long scheduleId, String comment) { Schedule findSchedule = findById(scheduleId); findSchedule.cancel(comment); } // 도메인 public void cancel(String comment) { this.cancel_comment = comment; this.complete = Complete.cancel; }

// 리포지토리 public List<ScheduleByDateResponse> findAllByDate(LocalDate date) { // TODO: 도메인 변경 전부터 애초에 빨간줄 떴음. 동작은 하지만 픽스 필요. return em.createQuery( "select new fis.iluvit.admin.domain.schedule.dto.ScheduleByDateResponse(" + "s.id, a.a_code, a.name, c.id, c.name, c.address, c.tel, s.estimate_num, s.new_cnt, s.visitDate, " + "s.visitTime, s.center_etc, s.agent_etc, s.modified_info, s.total_etc, s.call_check, s.call_check_info, s.accept, s.cancel_comment, s.complete, s.modifiedStaffName, " + "h.newChildCnt+h.newDementiaCnt+h.newDisabledCnt, h.changedChildCnt, h.newChildCnt+h.newDementiaCnt+h.newDisabledCnt+h.changedChildCnt)" // TODO: 레거시가 객체를 사용하지 않고 dto 직접 조회 방식이 채택되어 있어서 transient 값을 사용하지 못하고 직접 더해줬음. 개선 필요함 + " from Schedule s " + " join s.agent a" + // " join s.user u" + " join s.center c" + " left join headcount h on s.id = h.schedule.id" + " where s.visitDate = :date and s.valid = true" + " order by a.name desc, s.visitTime", ScheduleByDateResponse.class) .setParameter("date", date) .getResultList(); } // 서비스 public List<ScheduleByDateResponse> selectDate(LocalDate date) { return scheduleRepository.findAllByDate(date); }

// 리포지토리 public List<Schedule> findAllByDate(LocalDate date) { return em.createQuery( "select s" + " from Schedule s " + " join s.agent a" + " join s.center c" + " left join headcount h on s.id = h.schedule.id" + " where s.visitDate = :date and s.valid = true" + " order by a.name desc, s.visitTime", Schedule.class) .setParameter("date", date) .getResultList(); } // 서비스 public List<ScheduleByDateResponse> selectDate(LocalDate date) { List<Schedule> scheduleList = scheduleRepository.findAllByVisitDate(date); return scheduleList.stream() .map(ScheduleByDateResponse::from) .toList(); } // dto public class ScheduleByDateResponse { private Long schedule_id; // 스케쥴 id private String a_code; // 현장요원 코드 private Integer totalNewCnt; private Integer totalChangedCnt; private Integer totalCnt; ... public static ScheduleByDateResponse from(Schedule schedule) { return ScheduleByDateResponse.builder() .schedule_id(schedule.getId()) .a_code(schedule.getAgent().getA_code()) .a_name(schedule.getAgent().getName()) .center_id(schedule.getCenter().getId()) .c_name(schedule.getCenter().getName()) .c_address(schedule.getCenter().getAddress()) .c_ph(schedule.getCenter().getTel()) .estimated_cnt(schedule.getEstimate_num()) .new_cnt(schedule.getNew_cnt()) .visit_date(schedule.getVisitDate()) .visit_time(schedule.getVisitTime()) .center_etc(schedule.getCenter_etc()) .agent_etc(schedule.getAgent_etc()) .modified_info(schedule.getModified_info()) .total_etc(schedule.getTotal_etc()) .call_check(schedule.getCall_check()) .call_check_info(schedule.getCall_check_info()) .accept(schedule.getAccept()) .cancel_comment(schedule.getCancel_comment()) .complete(schedule.getComplete()) .modifiedStaffName(schedule.getModifiedStaffName()) .totalNewCnt(schedule.getNewChild()) // transient 값 .totalChangedCnt(schedule.getModChild()) // transient 값 .totalCnt(schedule.getTotalChild()) // transient 값 .build(); }

// 리포지토리 List<Schedule> findAllByVisitDate(LocalDate visitDate); // 서비스, dto는 그대로