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 | 60 +++++++++++++++++++++++++++++++++++++----------------------- 1 files changed, 37 insertions(+), 23 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 e8012fe..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; @@ -12,10 +13,7 @@ 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; @@ -28,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; @@ -41,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.*; @@ -72,7 +72,8 @@ private ICheckIndexVideoService indexVideoService; @Autowired private ISysDeptService deptService; - + @Autowired + private PlatformMapper platformMapper; /** * 鏌ヨ鑰冩牳绉垎鎸囨爣 @@ -319,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)) { //鍏堝尯鍒嗚�冩牳鏍囩锛屽啀鍖哄垎鍖哄幙 @@ -361,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)) { //鍏堝尯鍒嗚�冩牳鏍囩锛屽啀鍖哄垎鍖哄幙 @@ -403,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)) { //鍏堝尯鍒嗚�冩牳鏍囩锛屽啀鍖哄垎鍖哄幙 @@ -509,22 +528,17 @@ //澶у睆灞曠ず鑰冩牳寰楀垎 @Override - //TODO:鑰冭檻limit bug - public Map<String, List<Map<String, Object>>> dashboard(DashboardQuery dashboardQuery) { + 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, List<Map<String, Object>>> resultMap = new HashMap<>(); + Map<String, Map<String, Object>> resultMap = new HashMap<>(); for (CheckScore checkScore : dashboard) { - List<Map<String, Object>> list = new ArrayList<>(); Map<String, Object> map = new HashMap<>(); - map.put("value",checkScore.getScore()); - if(dashboardQuery.getDataScope() ==1) { - map.put("name", "鐪佸巺寰楀垎"); - }else { - map.put("name", "鍖哄幙寰楀垎"); - } - list.add(map); - resultMap.put(checkScore.getDeptName(),list ); + map.put("score", checkScore.getScore().setScale(2,RoundingMode.HALF_UP)); + resultMap.put(checkScore.getDeptName(), map); } return resultMap; } -- Gitblit v1.8.0