Merge branch 'Phase3' of https://192.168.0.10:8443/r/pcalife/PAM into Phase3

Mila

2022-01-20 7fcdb8eab75295661e4450614474e3c5a35bec94

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

@@ -20,6 +20,7 @@
   Optional<Satisfaction> findOneByAppointmentId(Long appointmentId);

   @Query(value = "SELECT avg(score) FROM satisfaction where agent_no=:agent_no"
         + " and score is not null"
         , nativeQuery = true)
   Float getAgentScoreAvg(@Param("agent_no") String agentNo);
}