From 7fe7b6182c2d407d28c2c9da1c070c3ce964e3e7 Mon Sep 17 00:00:00 2001
From: zhuguifei <zhuguifei@zhuguifeideiMac.local>
Date: 星期二, 20 五月 2025 10:49:14 +0800
Subject: [PATCH] 1.移动端添加自定义navbar导航栏

---
 eims/ruoyi-modules/lb-eims/src/main/java/org/dromara/eims/service/impl/EimsInspectStServiceImpl.java |  116 ++++++++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 105 insertions(+), 11 deletions(-)

diff --git a/eims/ruoyi-modules/lb-eims/src/main/java/org/dromara/eims/service/impl/EimsInspectStServiceImpl.java b/eims/ruoyi-modules/lb-eims/src/main/java/org/dromara/eims/service/impl/EimsInspectStServiceImpl.java
index dc31019..0f7a628 100644
--- a/eims/ruoyi-modules/lb-eims/src/main/java/org/dromara/eims/service/impl/EimsInspectStServiceImpl.java
+++ b/eims/ruoyi-modules/lb-eims/src/main/java/org/dromara/eims/service/impl/EimsInspectStServiceImpl.java
@@ -2,6 +2,7 @@
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import org.dromara.common.core.constant.DictConstants;
+import org.dromara.common.core.utils.DateUtils;
 import org.dromara.common.core.utils.MapstructUtils;
 import org.dromara.common.core.utils.StringUtils;
 import org.dromara.common.mybatis.core.page.TableDataInfo;
@@ -10,8 +11,10 @@
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import lombok.RequiredArgsConstructor;
+import org.dromara.eims.domain.EimsEqu;
 import org.dromara.eims.domain.EimsInspectRecord;
 import org.dromara.eims.domain.vo.EimsInspectRecordVo;
+import org.dromara.eims.mapper.EimsEquMapper;
 import org.dromara.eims.mapper.EimsInspectRecordMapper;
 import org.springframework.stereotype.Service;
 import org.dromara.eims.domain.bo.EimsInspectStBo;
@@ -21,6 +24,8 @@
 import org.dromara.eims.service.IEimsInspectStService;
 
 import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.time.LocalTime;
 import java.time.ZoneId;
 import java.time.temporal.TemporalAdjusters;
 import java.util.*;
@@ -37,6 +42,7 @@
 public class EimsInspectStServiceImpl implements IEimsInspectStService {
 
     private final EimsInspectStMapper baseMapper;
+    private final EimsEquMapper equMapper;
     private final EimsInspectRecordMapper recordMapper;
 
     /**
@@ -47,7 +53,73 @@
      */
     @Override
     public EimsInspectStVo queryById(Long id){
-        return baseMapper.selectVoById(id);
+        EimsInspectStVo stVo = baseMapper.selectVoById(id);
+        if(stVo!=null&&stVo.getEquId()!=null){
+            EimsEqu eimsEqu = equMapper.selectById(stVo.getEquId());
+            stVo.setEquName(eimsEqu.getEquName());
+            stVo.setAssetNo(eimsEqu.getAssetNo());
+        }
+        // fillStDataSingle(stVo);
+        return stVo;
+    }
+
+    @Override
+    public EimsInspectStVo queryByStId(String stId) {
+        QueryWrapper<EimsInspectSt> queryWrapper = new QueryWrapper<>();
+        queryWrapper.eq("st_id", stId);
+        EimsInspectStVo stVo = baseMapper.selectVoOne(queryWrapper);
+        if(stVo!=null&&stVo.getEquId()!=null){
+            EimsEqu eimsEqu = equMapper.selectById(stVo.getEquId());
+            stVo.setEquName(eimsEqu.getEquName());
+            stVo.setAssetNo(eimsEqu.getAssetNo());
+        }
+        // fillStDataSingle(stVo);
+        return stVo;
+    }
+
+
+    /**
+     *
+     * @param stVo type Day-鏃ヨ鍥� Month-鏈堣鍥�
+     * @param
+     */
+    private void fillStDataSingle(EimsInspectStVo stVo) {
+
+            LambdaQueryWrapper<EimsInspectRecord> recordLqw = Wrappers.lambdaQuery();
+            recordLqw.eq(EimsInspectRecord::getEquId, stVo.getEquId());
+            LocalDate planTime = stVo.getPlanTime().toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
+            // 鏈堣鍥炬煡璇㈣寖鍥�
+            LocalDate startOfMonth = planTime.with(TemporalAdjusters.firstDayOfMonth());
+            LocalDate endOfMonth = planTime.with(TemporalAdjusters.lastDayOfMonth());
+
+            // 鏃ヨ鍥炬煡璇㈣寖鍥�
+            if(stVo.getType().equals("Day")){
+                recordLqw.between(EimsInspectRecord::getPlanTime, planTime, planTime);
+            }else {
+                //  鏈堣鍥炬煡璇㈣寖鍥�
+                recordLqw.between(EimsInspectRecord::getPlanTime, startOfMonth, endOfMonth);
+            }
+
+
+            // 鎵ц鏌ヨ
+            List<EimsInspectRecordVo> recordList = recordMapper.selectVoList(recordLqw);
+            // TODO 鏍规嵁瀛楀吀eims_inspect_status
+            Map<String, Long> cMap = recordList.stream()
+                .filter(order -> List.of("0", "1").contains(order.getStatus()))
+                .collect(Collectors.groupingBy(EimsInspectRecordVo::getStatus, Collectors.counting()));
+            // TODO 鏍规嵁瀛楀吀eims_inspect_result
+            Map<String, Long> rMap = recordList.stream()
+                .filter(order ->order.getInspResult()!=null && List.of("1", "2").contains(order.getInspResult()))
+                .collect(Collectors.groupingBy(EimsInspectRecordVo::getInspResult, Collectors.counting()));
+
+            stVo.setRecordCount(recordList.size());
+            stVo.setUnCheckCount(cMap.getOrDefault("0", 0L).intValue());
+            stVo.setCheckCount(cMap.getOrDefault("1", 0L).intValue());
+
+            stVo.setNormalNum(rMap.getOrDefault("1", 0L).intValue());
+            stVo.setAbNormalNum(rMap.getOrDefault("2", 0L).intValue());
+
+
     }
 
     /**
@@ -59,23 +131,29 @@
      */
     @Override
     public TableDataInfo<EimsInspectStVo> queryPageList(EimsInspectStBo bo, PageQuery pageQuery) {
+        bo.setType(bo.getViewMode());
         // 鏈堣鍥�
-        if(bo.getViewMode().equals("Month")){
+//        if(bo.getViewMode().equals("Month")){
             QueryWrapper<EimsInspectSt> qw = buildWrapper(bo);
             Page<EimsInspectStVo> result = baseMapper.selectInspStList(pageQuery.build(), qw);
             // 濉厖鏁版嵁
-            fillStData(result);
+            fillStData(result,bo.getViewMode());
             return TableDataInfo.build(result);
             // 鏃ヨ鍥�
-        }else if(bo.getViewMode().equals("Day")){
-            Page<EimsInspectStVo> result = recordMapper.selectInspRecordDayList(pageQuery.build(), buildGroupWrapper(bo));
-            return TableDataInfo.build(result);
-        }
+//        }else if(bo.getViewMode().equals("Day")){
+//            Page<EimsInspectStVo> result = recordMapper.selectInspRecordDayList(pageQuery.build(), buildGroupWrapper(bo));
+//            return TableDataInfo.build(result);
+//        }
 
-       return null;
+//       return null;
     }
 
-    private void fillStData(Page<EimsInspectStVo> result) {
+    /**
+     *
+      * @param result
+     * @param type Day-鏃ヨ鍥� Month-鏈堣鍥�
+     */
+    private void fillStData(Page<EimsInspectStVo> result,String type) {
         List<EimsInspectStVo> records = result.getRecords();
         for (int i = 0; i < records.size(); i++) {
             EimsInspectStVo stVo = records.get(i);
@@ -84,9 +162,19 @@
             LambdaQueryWrapper<EimsInspectRecord> recordLqw = Wrappers.lambdaQuery();
             recordLqw.eq(EimsInspectRecord::getEquId, stVo.getEquId());
             LocalDate planTime = stVo.getPlanTime().toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
+            // 鏈堣鍥炬煡璇㈣寖鍥�
             LocalDate startOfMonth = planTime.with(TemporalAdjusters.firstDayOfMonth());
             LocalDate endOfMonth = planTime.with(TemporalAdjusters.lastDayOfMonth());
-            recordLqw.between(EimsInspectRecord::getPlanTime, startOfMonth, endOfMonth);
+
+            // 鏃ヨ鍥炬煡璇㈣寖鍥�
+            if(type.equals("Day")){
+                recordLqw.between(EimsInspectRecord::getPlanTime, planTime, planTime);
+            }else {
+            //  鏈堣鍥炬煡璇㈣寖鍥�
+                recordLqw.between(EimsInspectRecord::getPlanTime, startOfMonth, endOfMonth);
+            }
+
+
             // 鎵ц鏌ヨ
             List<EimsInspectRecordVo> recordList = recordMapper.selectVoList(recordLqw);
             // TODO 鏍规嵁瀛楀吀eims_inspect_status
@@ -96,7 +184,7 @@
             // TODO 鏍规嵁瀛楀吀eims_inspect_result
             Map<String, Long> rMap = recordList.stream()
                 .filter(order ->order.getInspResult()!=null && List.of("1", "2").contains(order.getInspResult()))
-                .collect(Collectors.groupingBy(EimsInspectRecordVo::getStatus, Collectors.counting()));
+                .collect(Collectors.groupingBy(EimsInspectRecordVo::getInspResult, Collectors.counting()));
 
             stVo.setRecordCount(recordList.size());
             stVo.setUnCheckCount(cMap.getOrDefault("0", 0L).intValue());
@@ -157,6 +245,12 @@
         qw.like(StringUtils.isNotBlank(bo.getTitle()), "st.title", bo.getTitle());
         qw.like(StringUtils.isNotBlank(bo.getEquName()), "equ.equ_name", bo.getEquName());
         qw.like(StringUtils.isNotBlank(bo.getAssetNo()), "equ.asset_no", bo.getAssetNo());
+        if(bo.getPlanTime()!=null&&bo.getViewMode() != null && bo.getViewMode().equals("Day")){
+            qw.eq("DATE_FORMAT(st.plan_time, '%Y-%m-%d')", DateUtils.parseDateToStr(DateUtils.YYYY_MM_DD,bo.getPlanTime()));
+        }else if(bo.getPlanTime()!=null&&bo.getViewMode() != null && bo.getViewMode().equals("Month")){
+            qw.eq("DATE_FORMAT(st.plan_time, '%Y-%m')",  DateUtils.parseDateToStr(DateUtils.YYYY_MM,bo.getPlanTime()));
+        }
+        qw.eq( "st.type", bo.getType());
         qw.between(params.get("beginPlanTime") != null && params.get("endPlanTime") != null,
             "st.plan_time", params.get("beginPlanTime"), params.get("endPlanTime"));
         qw.eq(bo.getInspUser() != null, "st.maint_user", bo.getInspUser());

--
Gitblit v1.9.3