From c7c826f8302134f6fcf4a583a392a55300463c4f Mon Sep 17 00:00:00 2001 From: HelenHuang <LinHuang@pollex.com.tw> Date: 星期一, 24 一月 2022 10:25:31 +0800 Subject: [PATCH] Update#134504 修改 [約訪中 - 新舊排序] 樣式 --- pamapi/src/main/java/com/pollex/pam/repository/AppointmentRepository.java | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diff --git a/pamapi/src/main/java/com/pollex/pam/repository/AppointmentRepository.java b/pamapi/src/main/java/com/pollex/pam/repository/AppointmentRepository.java index 245fde3..fe01955 100644 --- a/pamapi/src/main/java/com/pollex/pam/repository/AppointmentRepository.java +++ b/pamapi/src/main/java/com/pollex/pam/repository/AppointmentRepository.java @@ -1,7 +1,10 @@ package com.pollex.pam.repository; import java.util.List; +import java.util.Optional; +import com.pollex.pam.enums.AppointmentStatusEnum; +import com.pollex.pam.enums.ContactStatusEnum; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.stereotype.Repository; @@ -12,4 +15,9 @@ List<Appointment> findByAgentNo(String agentNo); + List<Appointment> findByAgentNoAndCustomerId(String agentNo, Long customerId); + + Optional<Appointment> findTopByAgentNoAndCustomerIdOrderByAppointmentDateDesc(String agentNo, Long customerId); + + List<Appointment> findAllByCommunicateStatusAndStatus(ContactStatusEnum contactStatus, AppointmentStatusEnum status); } -- Gitblit v1.8.0