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.*;
|
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.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author zhibing.pu
|
* @Date 2024/2/19 15:47
|
*/
|
@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;
|
}
|
|
|
/**
|
* 获取比赛记录
|
* @param matchRecord
|
* @return
|
*/
|
@Override
|
public MatchRecordVo getMatchRecord(MatchRecord matchRecord) {
|
matchRecord.setIsStudent(matchRecord.getIsStudent() == 0 ? 2 : 1);
|
int pageNo = (matchRecord.getPageNo() - 1) * matchRecord.getPageSize();
|
matchRecord.setPageNo(pageNo);
|
MatchRecordVo matchRecordVo = new MatchRecordVo();
|
int count = this.count(new QueryWrapper<WorldCupCompetitor>().eq("participantId", matchRecord.getId())
|
.eq("participantType", matchRecord.getIsStudent()));
|
matchRecordVo.setTotalSession(count);
|
List<MatchRecordList> matchRecord1 = this.baseMapper.getMatchRecord(matchRecord);
|
matchRecordVo.setList(matchRecord1);
|
return matchRecordVo;
|
}
|
|
|
/**
|
* 获取参赛排名
|
* @param worldCupRank
|
* @return
|
*/
|
@Override
|
public List<WorldCupRankVo> getWorldCupRank(WorldCupRank worldCupRank) {
|
worldCupRank.setIsStudent(worldCupRank.getIsStudent() == 0 ? 2 : 1);
|
List<Integer> appUserIds = null;
|
if(worldCupRank.getRadius() == 2){
|
AppUser appUser = appUserClient.getAppUser(worldCupRank.getAppUserId());
|
appUserIds = appUserClient.getAppUserIds(appUser.getCityCode());
|
}
|
List<Map<String, Object>> lists = this.baseMapper.getWorldCupRank(worldCupRank, appUserIds);
|
List<WorldCupRankVo> list = new ArrayList<>();
|
for (int i = 0; i < lists.size(); i++) {
|
Map<String, Object> map = lists.get(i);
|
Integer participantType = Integer.valueOf(map.get("participantType").toString());
|
Integer participantId = Integer.valueOf(map.get("participantId").toString());
|
Integer appUserId = Integer.valueOf(map.get("appUserId").toString());
|
Integer totalSession = Integer.valueOf(map.get("totalSession").toString());
|
Double winRate = Double.valueOf(map.get("winRate").toString());
|
//自己排名在20内的标识
|
boolean b = false;
|
if(i <= 19){
|
WorldCupRankVo worldCupRankVo = new WorldCupRankVo();
|
worldCupRankVo.setTotalSession(totalSession);
|
worldCupRankVo.setWinRate(winRate);
|
//学员
|
if(participantType == 1){
|
TStudent tStudent = studentClient.queryById(participantId);
|
worldCupRankVo.setAvatar(tStudent.getHeadImg());
|
String name = tStudent.getName();
|
if(name.length() > 2){
|
name = name.charAt(0) + "*" + name.substring(2);
|
}else{
|
name = name.charAt(0) + "*";
|
}
|
worldCupRankVo.setName(name);
|
}
|
//参赛人员
|
if(participantType == 2){
|
AppUser appUser1 = appUserClient.getAppUser(appUserId);
|
Participant participant = participantClient.getParticipant(participantId);
|
worldCupRankVo.setAvatar(appUser1.getHeadImg());
|
String name = participant.getName();
|
if(name.length() > 2){
|
name = name.charAt(0) + "*" + name.substring(2);
|
}else{
|
name = name.charAt(0) + "*";
|
}
|
worldCupRankVo.setName(name);
|
|
}
|
if(worldCupRank.getIsStudent().equals(participantType) && worldCupRank.getId().equals(participantId)){
|
worldCupRankVo.setOneself(1);
|
b = true;
|
}else{
|
worldCupRankVo.setOneself(0);
|
}
|
|
list.add(worldCupRankVo);
|
}
|
//排名20内，且包含自己直接返回
|
if(i == 19 && b){
|
break;
|
}
|
//排名前20的数据添加完成后且包含自己，需要将自己找出来后添加到21位
|
if(i > 19 && !b){
|
if(worldCupRank.getIsStudent().equals(participantType) && worldCupRank.getId().equals(participantId)){
|
WorldCupRankVo worldCupRankVo = new WorldCupRankVo();
|
worldCupRankVo.setTotalSession(totalSession);
|
worldCupRankVo.setWinRate(winRate);
|
//学员
|
if(participantType == 1){
|
TStudent tStudent = studentClient.queryById(participantId);
|
worldCupRankVo.setAvatar(tStudent.getHeadImg());
|
String name = tStudent.getName();
|
if(name.length() > 2){
|
name = name.charAt(0) + "*" + name.substring(2);
|
}else{
|
name = name.charAt(0) + "*";
|
}
|
worldCupRankVo.setName(name);
|
}
|
//参赛人员
|
if(participantType == 2){
|
AppUser appUser1 = appUserClient.getAppUser(appUserId);
|
Participant participant = participantClient.getParticipant(participantId);
|
worldCupRankVo.setAvatar(appUser1.getHeadImg());
|
String name = participant.getName();
|
if(name.length() > 2){
|
name = name.charAt(0) + "*" + name.substring(2);
|
}else{
|
name = name.charAt(0) + "*";
|
}
|
worldCupRankVo.setName(name);
|
|
}
|
worldCupRankVo.setOneself(1);
|
list.add(worldCupRankVo);
|
break;
|
}
|
}
|
}
|
return list;
|
}
|
}
|
