保誠-保戶業務員媒合平台
wayne
2022-01-22 1c6e23bc27415c655418618ca4eea4f36f69f0e0
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;
@@ -13,4 +16,8 @@
   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);
}