新增加接口

puzhibing

2024-02-28 025bfd05c4f4337db4c5582426057e846ce4bed0

 cloud-server-communityWorldCup/src/main/java/com/dsh/communityWorldCup/service/impl/WorldCupCompetitorServiceImpl.java

@@ -1,10 +1,27 @@
package com.dsh.communityWorldCup.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.dsh.communityWorldCup.entity.WorldCupCompetitor;
import com.dsh.communityWorldCup.feignclient.account.AppUserClient;
import com.dsh.communityWorldCup.feignclient.account.StudentClient;
import com.dsh.communityWorldCup.feignclient.account.model.AppUser;
import com.dsh.communityWorldCup.feignclient.account.model.TStudent;
import com.dsh.communityWorldCup.feignclient.competition.ParticipantClient;
import com.dsh.communityWorldCup.feignclient.competition.model.Participant;
import com.dsh.communityWorldCup.feignclient.other.StoreClient;
import com.dsh.communityWorldCup.mapper.WorldCupCompetitorMapper;
import com.dsh.communityWorldCup.model.EntrantRank;
import com.dsh.communityWorldCup.model.EntrantRankVo;
import com.dsh.communityWorldCup.service.IWorldCupCompetitorService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.math.BigDecimal;
import java.math.MathContext;
import java.math.RoundingMode;
import java.util.List;
import java.util.Map;

/**
 * @author zhibing.pu
@@ -12,4 +29,91 @@
 */
@Service
public class WorldCupCompetitorServiceImpl extends ServiceImpl<WorldCupCompetitorMapper, WorldCupCompetitor> implements IWorldCupCompetitorService {

    @Resource
    private StudentClient studentClient;

    @Resource
    private ParticipantClient participantClient;

    @Resource
    private AppUserClient appUserClient;





    /**
     * 获取参赛人员名次信息
     * @param entrantRank
     * @return
     */
    @Override
    public EntrantRankVo getEntrantRank(EntrantRank entrantRank) {
        EntrantRankVo entrantRankVo = new EntrantRankVo();
        if(entrantRank.getIsStudent() == 0){
            //参赛人员
            Participant participant = participantClient.getParticipant(entrantRank.getId());
            entrantRankVo.setName(participant.getName());
        }else{
            //学员
            TStudent tStudent = studentClient.queryById(entrantRank.getId());
            entrantRankVo.setName(tStudent.getName());
        }
        //全国排名---直接数据库分组查询后排序
        entrantRankVo.setNationalRank(0);
        List<Map<String, Object>> mapList = this.baseMapper.getNumberOfGamesRanked(null);
        for (int i = 0; i < mapList.size(); i++) {
            Map<String, Object> map = mapList.get(i);
            Integer participantType = Integer.valueOf(map.get("participantType").toString());
            Integer participantId = Integer.valueOf(map.get("participantId").toString());
            Integer num = Integer.valueOf(map.get("num").toString());
            if(null != participantId && participantId.equals(entrantRank.getId()) && participantType.equals(entrantRank.getIsStudent())){
                entrantRankVo.setNationalRank(i + 1);
            }
        }
        /**
         * 城市排名
         * 1、先查询出当前用户对应的城市
         * 2、再根据城市查询对应的所有人员
         * 3、再根据查询出来的参赛人分组查询出参赛次数后排序
         */
        entrantRankVo.setCityRank(0);
        AppUser appUser = appUserClient.getAppUser(entrantRank.getAppUserId());
        entrantRankVo.setCityName(appUser.getCity());
        List<Integer> appUserIds = appUserClient.getAppUserIds(appUser.getCityCode());
        List<Map<String, Object>> mapList1 = this.baseMapper.getNumberOfGamesRanked(appUserIds);
        for (int i = 0; i < mapList1.size(); i++) {
            Map<String, Object> map = mapList1.get(i);
            Integer participantType = Integer.valueOf(map.get("participantType").toString());
            Integer participantId = Integer.valueOf(map.get("participantId").toString());
            Integer num = Integer.valueOf(map.get("num").toString());
            if(null != participantId && participantId.equals(entrantRank.getId()) && participantType.equals(entrantRank.getIsStudent())){
                entrantRankVo.setCityRank(i + 1);
            }
        }
        QueryWrapper<WorldCupCompetitor> wrapper = new QueryWrapper<>();
        if(entrantRank.getIsStudent() == 0){
            wrapper.eq("participantType", 2);
        }else{
            wrapper.eq("participantType", 1);
        }
        int win = this.count(wrapper.eq("participantId", entrantRank.getId()).eq("matchResult", 1));
        entrantRankVo.setWin(win);

        wrapper = new QueryWrapper<>();
        if(entrantRank.getIsStudent() == 0){
            wrapper.eq("participantType", 2);
        }else{
            wrapper.eq("participantType", 1);
        }
        int lose = this.count(wrapper.eq("participantId", entrantRank.getId()).eq("matchResult", -1));
        entrantRankVo.setLose(lose);
        if((win + lose) == 0){
            entrantRankVo.setWinRate(0D);
        }else{
            entrantRankVo.setWinRate(new BigDecimal(win).divide(new BigDecimal(win + lose), new MathContext(4, RoundingMode.HALF_EVEN)).multiply(new BigDecimal(100)).doubleValue());
        }
        return entrantRankVo;
    }
}