From 7a33c5b558e7e4ab5760261accbd32c7f2056c4a Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期一, 23 九月 2024 19:16:13 +0800 Subject: [PATCH] 大屏分离平台在线和考核成绩接口 --- ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java | 67 ++++++++++++++++++++++++++------- 1 files changed, 52 insertions(+), 15 deletions(-) diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java index 4a3be48..c48bde7 100644 --- a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java +++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckScoreServiceImpl.java @@ -3,6 +3,7 @@ import annotation.DataScope; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; +import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ycl.platform.base.CheckIndex; import com.ycl.platform.domain.dto.CheckResultExportDTO; @@ -10,11 +11,9 @@ import com.ycl.platform.domain.dto.CheckScoreIndexDTO; import com.ycl.platform.domain.dto.ScoreIndexDTO; import com.ycl.platform.domain.entity.*; +import com.ycl.platform.domain.query.DashboardQuery; import com.ycl.platform.domain.vo.*; -import com.ycl.platform.mapper.CheckRuleMapper; -import com.ycl.platform.mapper.CheckScoreMapper; -import com.ycl.platform.mapper.CheckTemplateMapper; -import com.ycl.platform.mapper.CheckTemplateRuleMapper; +import com.ycl.platform.mapper.*; import com.ycl.platform.service.ICheckIndexCarService; import com.ycl.platform.service.ICheckIndexFaceService; import com.ycl.platform.service.ICheckIndexVideoService; @@ -27,6 +26,7 @@ import com.ycl.utils.SecurityUtils; import com.ycl.utils.StringUtils; import constant.CheckConstants; +import enumeration.general.AreaDeptEnum; import enumeration.general.PublishType; import jakarta.servlet.http.HttpServletResponse; import lombok.extern.slf4j.Slf4j; @@ -40,6 +40,7 @@ import java.io.IOException; import java.math.BigDecimal; import java.math.RoundingMode; +import java.net.InetAddress; import java.text.SimpleDateFormat; import java.time.LocalDateTime; import java.util.*; @@ -71,7 +72,8 @@ private ICheckIndexVideoService indexVideoService; @Autowired private ISysDeptService deptService; - + @Autowired + private PlatformMapper platformMapper; /** * 鏌ヨ鑰冩牳绉垎鎸囨爣 @@ -174,8 +176,8 @@ } } //鍒嗘暟淇濈暀涓�浣嶅皬鏁� - checkScores.stream().forEach(item ->item.setScore(item.getScore().setScale(1,RoundingMode.HALF_UP))); - return checkScores.stream().collect(Collectors.groupingBy(CheckScore::getDeptId)); + checkScores.stream().forEach(item -> item.setScore(item.getScore().setScale(1, RoundingMode.HALF_UP))); + return checkScores.stream().collect(Collectors.groupingBy(CheckScore::getDeptId)); } private void getCheckScore(CheckScore checkScore, Calendar calendar) { @@ -220,7 +222,7 @@ } List<CheckScore> checkScores = scoreMapper.selectCheckScoreList(checkScore); //鍒嗘暟淇濈暀涓�浣嶅皬鏁� - checkScores.stream().forEach(item ->item.setScore(item.getScore().setScale(1,RoundingMode.HALF_UP))); + checkScores.stream().forEach(item -> item.setScore(item.getScore().setScale(1, RoundingMode.HALF_UP))); return checkScores.stream().collect(Collectors.groupingBy(CheckScore::getDeptId)); } @@ -236,7 +238,7 @@ //鍖哄幙鍙兘鐪嬪凡鍙戝竷 roleControl(checkScore); List<CheckScore> scoreList = scoreMapper.selectCheckScoreList(checkScore); - scoreList.stream().forEach(item ->item.setScore(item.getScore().setScale(1,RoundingMode.HALF_UP))); + scoreList.stream().forEach(item -> item.setScore(item.getScore().setScale(1, RoundingMode.HALF_UP))); return scoreList; } @@ -318,10 +320,16 @@ checkIndexCar.setQuarter(exportDTO.getQuarter()); checkIndexCar.setDeptId(exportDTO.getDeptId()); checkIndexCar.setDeptIds(exportDTO.getDeptIds()); - checkIndexCar.setExamineTags(exportDTO.getExamineTags()); //鏉冮檺鎺у埗 鍙兘鏌ョ湅宸插彂甯� roleControl(checkIndexCar); - List<CheckIndexCar> checkIndexCars = indexCarService.selectCheckIndexCarList(checkIndexCar); + List<CheckIndexCar> checkIndexCars = new ArrayList<>(); + for (Integer examineTag : exportDTO.getExamineTags()) { + checkIndexCar.setExamineTag(Short.valueOf(examineTag + "")); + if (examineTag == 0) { + checkIndexCar.setExamineTagQuery(1); + } + checkIndexCars.addAll(indexCarService.selectCheckIndexCarList(checkIndexCar)); + } //璁$畻骞冲潎鍊兼斁鍦╡xcel鏈�鍚� if (exportDTO.getAverage() != null && exportDTO.getAverage() && !CollectionUtils.isEmpty(checkIndexCars)) { //鍏堝尯鍒嗚�冩牳鏍囩锛屽啀鍖哄垎鍖哄幙 @@ -360,10 +368,16 @@ checkIndexFace.setQuarter(exportDTO.getQuarter()); checkIndexFace.setDeptId(exportDTO.getDeptId()); checkIndexFace.setDeptIds(exportDTO.getDeptIds()); - checkIndexFace.setExamineTags(exportDTO.getExamineTags()); //鏉冮檺鎺у埗 鍙兘鏌ョ湅宸插彂甯� roleControl(checkIndexFace); - List<CheckIndexFace> checkIndexFaces = indexFaceService.selectCheckIndexFaceList(checkIndexFace); + List<CheckIndexFace> checkIndexFaces = new ArrayList<>(); + for (Integer examineTag : exportDTO.getExamineTags()) { + checkIndexFace.setExamineTag(Short.valueOf(examineTag + "")); + if (examineTag == 0) { + checkIndexFace.setExamineTagQuery(1); + } + checkIndexFaces.addAll(indexFaceService.selectCheckIndexFaceList(checkIndexFace)); + } //璁$畻骞冲潎鍊兼斁鍦╡xcel鏈�鍚� if (exportDTO.getAverage() != null && exportDTO.getAverage() && !CollectionUtils.isEmpty(checkIndexFaces)) { //鍏堝尯鍒嗚�冩牳鏍囩锛屽啀鍖哄垎鍖哄幙 @@ -402,10 +416,16 @@ checkIndexVideo.setQuarter(exportDTO.getQuarter()); checkIndexVideo.setDeptId(exportDTO.getDeptId()); checkIndexVideo.setDeptIds(exportDTO.getDeptIds()); - checkIndexVideo.setExamineTags(exportDTO.getExamineTags()); //鏉冮檺鎺у埗 鍙兘鏌ョ湅宸插彂甯� roleControl(checkIndexVideo); - List<CheckIndexVideo> checkIndexVideos = indexVideoService.selectCheckIndexVideoList(checkIndexVideo); + List<CheckIndexVideo> checkIndexVideos = new ArrayList<>(); + for (Integer examineTag : exportDTO.getExamineTags()) { + checkIndexVideo.setExamineTag(Short.valueOf(examineTag + "")); + if (examineTag == 0) { + checkIndexVideo.setExamineTagQuery(1); + } + checkIndexVideos.addAll(indexVideoService.selectCheckIndexVideoList(checkIndexVideo)); + } //璁$畻骞冲潎鍊兼斁鍦╡xcel鏈�鍚� if (exportDTO.getAverage() != null && exportDTO.getAverage() && !CollectionUtils.isEmpty(checkIndexVideos)) { //鍏堝尯鍒嗚�冩牳鏍囩锛屽啀鍖哄垎鍖哄幙 @@ -506,6 +526,23 @@ return scoreMapper.calculate(startDate, endDate, category); } + //澶у睆灞曠ず鑰冩牳寰楀垎 + @Override + public Map<String, Map<String, Object>> dashboard(DashboardQuery dashboardQuery) { + Date now = new Date(); + dashboardQuery.setStartTime(DateUtils.getMouthStart(now)); + dashboardQuery.setEndTime(DateUtils.getMouthEnd(now)); + List<CheckScore> dashboard = scoreMapper.dashboard(dashboardQuery); + Map<String, Map<String, Object>> resultMap = new HashMap<>(); + + for (CheckScore checkScore : dashboard) { + Map<String, Object> map = new HashMap<>(); + map.put("score", checkScore.getScore().setScale(2,RoundingMode.HALF_UP)); + resultMap.put(checkScore.getDeptName(), map); + } + return resultMap; + } + // /** // * 鏂板鑰冩牳绉垎 // * -- Gitblit v1.8.0