[update] [todo 136031] 諮詢度表現，提供前端該顧問所有預約單數量以及近一個月的預約單數量

wayne

2022-03-01 fa782dca2a00e9a4a48c5b3588f5eb3b47af93cf

 pamapi/src/main/java/com/pollex/pam/service/ConsultantService.java

@@ -6,8 +6,8 @@
import com.pollex.pam.domain.Consultant;
import com.pollex.pam.domain.CustomerFavoriteConsultant;
import com.pollex.pam.domain.Satisfaction;
import com.pollex.pam.enums.ConsultantStatusEnum;
import com.pollex.pam.enums.ContactStatusEnum;
import com.pollex.pam.enums.LoginResult;
import com.pollex.pam.repository.ConsultantRepository;
import com.pollex.pam.repository.CustomerFavoriteConsultantRepository;
import com.pollex.pam.repository.SatisfactionRepository;
@@ -30,15 +30,16 @@
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.math.BigDecimal;
import java.time.Instant;
import java.util.Comparator;
import java.util.List;
import java.util.Objects;
import java.util.Optional;
import java.util.stream.Collectors;

import static com.pollex.pam.consts.SeniorityQueryConst.*;
import static com.pollex.pam.enums.ContactStatusEnum.*;

@Service
@@ -58,9 +59,6 @@

    @Autowired
    AppointmentService appointmentService;

    @Autowired
    LoginRecordService loginRecordService;

    @Autowired
    AppointmentCustomerViewMapper appointmentCustomerViewMapper;
@@ -152,6 +150,7 @@
    public List<ConsultantDTO> getRecommendConsultantList() {
        return consultantRepository.findAllByRecommendIsTrue()
            .stream()
            .filter(consultant -> consultant.getStatus() == ConsultantStatusEnum.AVAILABLE)
            .map(consultantMapper::toDto)
            .collect(Collectors.toList());
    }
@@ -159,8 +158,61 @@
    public List<ConsultantDTO> strictQueryConsultant(StrictQueryConsultantParam param) {
        return consultantRepository.findAll(ConsultantQuerySpec.getStrictQuerySpec(param))
            .stream()
            .map(consultantMapper::toDto)
            .map(consultant -> {
                int suitabilityScore = getStrictQuerySuitabilityScore(param, consultant);

                ConsultantDTO dto = consultantMapper.toDto(consultant);
                dto.setSuitability(suitabilityScore);

                return dto;
            })
            .collect(Collectors.toList());
    }

    private int getStrictQuerySuitabilityScore(StrictQueryConsultantParam param, Consultant consultant) {
        final float QUERY_AVG_SCORE_OFFSET = 0.5f;
        Float queryAvgScore = param.getAvgScore() - QUERY_AVG_SCORE_OFFSET;
        String querySeniority = param.getSeniority();
        List<String> queryRequirements = param.getRequirements();

        int score = 0;
        if(isConsultantGreaterThanScore(queryAvgScore, consultant.getAvgScore())) {
            score += 30;
        }

        if(isConsultantInSeniority(querySeniority, consultant.getSeniorityYear())) {
            score += 20;
        }

        if(isAllRequirementsIncludeConsultant(queryRequirements, consultant.getExpertise())) {
            score += 50;
        }

        return score;
    }

    private boolean isAllRequirementsIncludeConsultant(List<String> queryRequirements, String consultantExpertise) {
        return queryRequirements
            .stream()
            .allMatch(queryRequirement -> consultantExpertise.matches(".*"+queryRequirement+".*"));
    }

    private boolean isConsultantInSeniority(String querySeniority, Long consultantSeniorityYear) {
        switch (querySeniority == null ? "" : querySeniority) {
            case YOUNG:
                return consultantSeniorityYear < 5;
            case SENIOR:
                return consultantSeniorityYear > 5;
            case UNLIMITED:
            case "":
                return true;
            default:
                return false;
        }
    }

    private boolean isConsultantGreaterThanScore(Float queryAvgScore, Float consultantAvgScore) {
        return Objects.isNull(queryAvgScore) || queryAvgScore < consultantAvgScore;
    }

    public List<ConsultantDTO> fastQueryConsultant(FastQueryConsultantParam param) {
@@ -172,25 +224,22 @@

    public ConsultantDetailDTO getConsultantDetail(String agentNo) {
        Consultant consultant = consultantRepository.findOneByAgentNo(agentNo).orElseThrow(ConsultantNotFoundException::new);
        ConsultantDetailDTO consultantDetailDTO = consultantMapper.toDetailDto(consultant);

        loginRecordService.findLatestLoginRecord(agentNo, LoginResult.SUCCESS)
                .ifPresent(loginRecord -> consultantDetailDTO.setLatestLoginTime(loginRecord.getLoginDate()));

        return consultantDetailDTO;
        return consultantMapper.toDetailDto(consultant);
    }

    @Transactional
    public void addConsultantToCustomList(AddConsultantParam param) {
        List<String> agentNoList = param.getAgentNoList();
        List<Consultant> consultants = consultantRepository.findAllByAgentNoIn(agentNoList);
        Long userId = SecurityUtils.getCustomerDBId();

        consultants.forEach(consultant -> {
        param.getConsultantList().forEach(addConsultantData -> {
            Consultant consultant = consultantRepository.findOneByAgentNo(addConsultantData.getAgentNo()).orElseThrow(ConsultantNotFoundException::new);
            boolean isConsultantInList = customerFavoriteConsultantRepository.findOneByCustomerIdAndConsultant(userId, consultant).isPresent();

            if(!isConsultantInList) {
                CustomerFavoriteConsultant customerFavoriteConsultant = new CustomerFavoriteConsultant();
                Optional<Instant> createdTime = Optional.ofNullable(addConsultantData.getCreatedTime());

                customerFavoriteConsultant.setCreatedDate(createdTime.orElse(Instant.now()));
                customerFavoriteConsultant.setConsultant(consultant);
                customerFavoriteConsultant.setCustomerId(userId);

@@ -200,7 +249,6 @@
                log.info("The consultant is in customer favorite list! customId = {}, consultant AgentNo = {}", userId, consultant.getAgentNo());
            }
        });

    }

   public List<AppointmentCustomerViewDTO> getMyAppointment() {
@@ -306,17 +354,18 @@
    }

   public void setConsultantAvgScore(Satisfaction satisfaction) {
      float avgScore = getAgentAvgScore(satisfaction.getAgentNo());
      Consultant consultant = consultantRepository.findOneByAgentNo(satisfaction.getAgentNo())
            .get();
      consultant.setAvgScore(avgScore);
      consultantRepository.save(consultant);
      Optional<Float> avgScore = getAgentAvgScore(satisfaction.getAgentNo());

        if(avgScore.isPresent()) {
            BigDecimal bigDecimal = BigDecimal.valueOf(avgScore.get());

            Consultant consultant = consultantRepository.findOneByAgentNo(satisfaction.getAgentNo()).get();
            consultant.setAvgScore(bigDecimal.setScale(1, BigDecimal.ROUND_HALF_UP).floatValue());
            consultantRepository.save(consultant);
        }
   }

   public float getAgentAvgScore(String agentNo) {
      Float avgScore = satisfactionRepository.getAgentScoreAvg(agentNo);
      if(avgScore==null)return 0;
      BigDecimal bigDecimal = new BigDecimal(avgScore);
      return avgScore = bigDecimal.setScale(1,BigDecimal.ROUND_HALF_UP).floatValue();
   public Optional<Float> getAgentAvgScore(String agentNo) {
      return satisfactionRepository.getAgentScoreAvg(agentNo);
   }
}