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; import com.pollex.pam.domain.Appointment; @Repository public interface AppointmentRepository extends JpaRepository{ List findByAgentNo(String agentNo); List findByAgentNoAndCustomerId(String agentNo, Long customerId); Optional findTopByAgentNoAndCustomerIdOrderByAppointmentDateDesc(String agentNo, Long customerId); List findAllByCommunicateStatusAndStatus(ContactStatusEnum contactStatus, AppointmentStatusEnum status); }