保誠-保戶業務員媒合平台
wayne
2022-01-24 bd94a3d7572bcb3d87e3a0c89cb764e873e8b4a8
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
package com.pollex.pam.repository;
 
import java.util.List;
 
import com.pollex.pam.domain.Appointment;
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.AppointmentCustomerView;
 
@Repository
public interface AppointmentCustomerViewRepository extends JpaRepository<AppointmentCustomerView, Long>{
    List<AppointmentCustomerView> findByAgentNo(String agentNo);
    List<AppointmentCustomerView> findByAgentNoAndCustomerId(String agentNo, Long customerId);
    List<AppointmentCustomerView> findAllByCommunicateStatusAndStatus(ContactStatusEnum contactStatus, AppointmentStatusEnum status);
}