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