基于Java语言的体育管理系统2设计源码

package com.yangli.service.Impl.FunctionBar; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.yangli.entity.FunctionBar.SportRace; import com.yangli.entity.FunctionBar.SportRacePrize; import com.yangli.entity.FunctionBar.SysDictData; import com.yangli.entity.PersonalPage.SportTeam; import com.yangli.entity.PersonalPage.SportTeamUser; import com.yangli.entity.RaceApplication.SportRaceApplication; import com.yangli.entity.RaceApplication.SportRaceDept; import com.yangli.entity.ResponseResult; import com.yangli.entity.SysDept; import com.yangli.entity.SysUser; import com.yangli.mapper.FunctionBar.SportRaceMapper; import com.yangli.mapper.FunctionBar.SportRacePrizeMapper; import com.yangli.mapper.FunctionBar.SysDictDataMapper; import com.yangli.mapper.PersonalPage.SportTeamMapper; import com.yangli.mapper.PersonalPage.SportTeamUserMapper; import com.yangli.mapper.RaceApplication.SportRaceApplicationMapper; import com.yangli.mapper.RaceApplication.SportRaceDeptMapper; import com.yangli.mapper.SysDeptMapper; import com.yangli.mapper.SysUserMapper; import com.yangli.service.FunctionBar.SportRaceService; import com.yangli.util.GetUserIdUtil; import com.yangli.vo.*; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.core.context.SecurityContextHolder; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.time.LocalDateTime; import java.time.ZoneId; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Objects; /** * -- IntelliJ IDEA * * @author yangli * @date 2024/5/1 18:23 * @email 488281804@qq.com * @since JDK1.8 */ @Service public class SportRaceServiceImpl implements SportRaceService { @Resource private SportRaceMapper sportRaceMapper; @Autowired private SysDeptMapper sysDeptMapper; @Autowired private SportRaceDeptMapper sportRaceDeptMapper; @Autowired private SysDictDataMapper sysDictDataMapper; @Autowired private SportRaceApplicationMapper sportRaceApplicationMapper; @Autowired private SysUserMapper sysUserMapper; @Resource private SportTeamUserMapper sportTeamUserMapper; @Resource private SportTeamMapper sportTeamMapper; @Resource private SportRacePrizeMapper sportRacePrizeMapper; @Override public boolean addSportRace(SportRace sportRace) { return sportRaceMapper.addSportRace(sportRace); } @Override public Integer getKey() { return sportRaceMapper.getKey(); } @Override public boolean updateSportRace(SportRace sportRace) { return sportRaceMapper.updateSportRace(sportRace); } @Override public SportRace getSportRaceById(long raceId) { return sportRaceMapper.getSportRaceById(raceId); } @Override public List<SportRace> getSportRaceByPlaceId(String place) { return sportRaceMapper.getSportRaceByPlaceId(place); } @Override public List<SportRace> getSportRaceByCreateBy(String create_by) { return sportRaceMapper.getSportRaceByCreateBy(create_by); } //汪 @Override public ResponseResult getScoreBoardList(listQuery lq) { if(Objects.isNull(lq.getKey())){ return ResponseResult.fail(); } Integer page = lq.getPage(); Integer limit = lq.getLimit(); lq.setPage((page-1)*limit); //获取整个学校的积分榜 if(lq.getDept().equals(0L)){ return ResponseResult.success(getscoreBoardVosList(lq),200L); } //获取当前登录用户 Long userId = GetUserIdUtil.GetUserId(SecurityContextHolder.getContext().getAuthentication()); //获取个人部门积分榜 lq.setDept(userId); return ResponseResult.success(getscoreBoardVosList(lq),200L); } public List<ScoreBoardVo> getscoreBoardVosList(listQuery lq){ List<ScoreBoardVo> scoreBoardVosList = new ArrayList<>(); List<SysUser> userByIntegral = sysUserMapper.getUserByIntegral(lq); for (SysUser user : userByIntegral) { ScoreBoardVo scoreBoardVo = new ScoreBoardVo(); BeanUtils.copyProperties(user,scoreBoardVo); SysDept sysDept = sysDeptMapper.selectOne(new LambdaQueryWrapper<SysDept>().eq(SysDept::getDeptId, user.getDeptId())); scoreBoardVo.setDept(sysDept.getDeptName()); scoreBoardVosList.add(scoreBoardVo); } return scoreBoardVosList; } @Override public ResponseResult getSportRace(listQuery lq) { if(Objects.isNull(lq)){ return ResponseResult.fail(); } Integer page = lq.getPage(); Integer limit = lq.getLimit(); lq.setPage((page-1)*limit); LambdaQueryWrapper<SportRace> sportRaceLambdaQueryWrapper = new LambdaQueryWrapper<>(); sportRaceLambdaQueryWrapper.orderBy(true,lq.isSort(),SportRace::getApplicationStart); List<SportRace> sportRaceList = sportRaceMapper.selectList(sportRaceLambdaQueryWrapper); if(Objects.isNull(sportRaceList)){ return ResponseResult.fail(); } return ResponseResult.success(getSportRaceVo(sportRaceList),200L); } @Override public ResponseResult Search(listQuery lq) { if(Objects.isNull(lq.getKey())){ return ResponseResult.fail(); } List<SportRace> sportRaceList = new ArrayList<>(); //完整的比赛名搜索 SportRace sportRace = sportRaceMapper.selectOne(new LambdaQueryWrapper<SportRace>().eq(SportRace::getTitle, lq.getKey())); if(!Objects.isNull(sportRace)) { sportRaceList.add(sportRace); return ResponseResult.success(getSportRaceVo(sportRaceList),200L); } //模糊搜索 List<SportRace> sportRaceList1 = sportRaceMapper.selectList(new LambdaQueryWrapper<SportRace>() .like(SportRace::getTitle, lq.getKey()) .orderBy(true, lq.isSort(), SportRace::getApplicationStart) ); if(!Objects.isNull(sportRaceList1)) return ResponseResult.success(getSportRaceVo(sportRaceList1),200L); return ResponseResult.fail(); } public List<SportRaceVo> getSportRaceVo(List<SportRace> sportRaceList){ List<SportRaceVo> sportRaceVoList = new ArrayList<>(); if(sportRaceList.isEmpty()){ return null; } for (SportRace sportRace : sportRaceList) { SportRaceVo sportRaceVo =new SportRaceVo(); BeanUtils.copyProperties(sportRace,sportRaceVo); sportRaceVo.setDept(getSysDeptVo(sportRace)); SysDictData sysDictData = sysDictDataMapper.selectOne(new LambdaQueryWrapper<SysDictData>() .eq(SysDictData::getDictValue, sportRaceVo.getPlace()) .eq(SysDictData::getDictType,"sport_place_list") ); sportRaceVo.setPlace(sysDictData.getDictLabel()); sportRaceVoList.add(sportRaceVo); } return sportRaceVoList; } //获取组织名字 public List<SysDeptVo> getSysDeptVo(SportRace sportRace){ List<SysDeptVo> sysDeptVoList = new ArrayList<>(); List<SportRaceDept> sportRaceDepts = sportRaceDeptMapper.selectList(new LambdaQueryWrapper<SportRaceDept>() .eq(SportRaceDept::getRaceId, sportRace.getRaceId())); if(sportRaceDepts.isEmpty()) return null; for (SportRaceDept sportRaceDept : sportRaceDepts) { SysDept sysDept = sysDeptMapper.selectOne(new LambdaQueryWrapper<SysDept>() .eq(SysDept::getDeptId, sportRaceDept.getDeptId())); SysDeptVo sysDeptVo = new SysDeptVo(); BeanUtils.copyProperties(sysDept,sysDeptVo); sysDeptVoList.add(sysDeptVo); } return sysD