[update] 修正滿意度評分在沒有撈到任何評分紀錄時，不可直接set 0進顧問的分數中

wayne

2022-02-16 3c94dc06c3b99e7fc430e68ee2ce4a6cf2cd422c

 pamapi/src/main/java/com/pollex/pam/repository/SatisfactionRepository.java

@@ -17,9 +17,9 @@

   List<Satisfaction> findByAgentNoAndType(String agentNo, SatisfactionTypeEnum type);

   List<Satisfaction> findByCustomerIdAndType(Long customerId, SatisfactionTypeEnum type);
   List<Satisfaction> findByCustomerId(Long customerId);

   Optional<Satisfaction> findOneByAppointmentId(Long appointmentId);
   Optional<Satisfaction> findOneByAppointmentIdAndType(Long appointmentId, SatisfactionTypeEnum type);

    List<Satisfaction> findAllByStatusAndType(SatisfactionStatusEnum status, SatisfactionTypeEnum type);

@@ -27,5 +27,5 @@
            + " 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);
}