| | |
| | | |
| | | List<Satisfaction> findByAgentNoAndType(String agentNo, SatisfactionTypeEnum type); |
| | | |
| | | List<Satisfaction> findByCustomerIdAndType(Long customerId, SatisfactionTypeEnum type); |
| | | List<Satisfaction> findByCustomerId(Long customerId); |
| | | |
| | | Optional<Satisfaction> findOneByAppointmentIdAndType(Long appointmentId, SatisfactionTypeEnum type); |
| | | |
| | |
| | | + " and agent_no=:agent_no" |
| | | + " and score is not null" |
| | | , nativeQuery = true) |
| | | Float getAgentScoreAvg(@Param("agent_no") String agentNo); |
| | | Optional<Float> getAgentScoreAvg(@Param("agent_no") String agentNo); |
| | | } |