保誠-保戶業務員媒合平台
究查 | 歷程 | 修補檔 | 提交 | 提交差異 | 忽略空白
HelenHuang
2022-01-14 9f843e9978cc4bff79e515a6ab929154d904fa46 
 pamapi/src/main/java/com/pollex/pam/repository/AppointmentRepository.java


@@ -1,6 +1,7 @@


package com.pollex.pam.repository;




import java.util.List;


import java.util.Optional;




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


import org.springframework.stereotype.Repository;


@@ -12,4 +13,7 @@




   List<Appointment> findByAgentNo(String agentNo);




    List<Appointment> findByAgentNoAndCustomerId(String agentNo, Long customerId);




    Optional<Appointment> findTopByAgentNoAndCustomerIdOrderByAppointmentDateDesc(String agentNo, Long customerId);


}