From 6a3591c42a84b36d24d75f4584f0eeb145bb4de7 Mon Sep 17 00:00:00 2001
From: “linengliang” <vanSuperEnergy@163.com>
Date: 星期五, 15 三月 2024 15:00:24 +0800
Subject: [PATCH] xg

---
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java |  328 ++++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 281 insertions(+), 47 deletions(-)

diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java
index a604a67..ce24a6a 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java
@@ -3,6 +3,8 @@
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
+import com.baomidou.mybatisplus.core.toolkit.StringUtils;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
 import io.swagger.annotations.Api;
@@ -21,14 +23,11 @@
 import org.jeecg.common.system.vo.LoginUser;
 import org.jeecg.common.util.oConvertUtils;
 import org.jeecg.modules.eam.entity.*;
-import org.jeecg.modules.eam.service.ICalibrationOrderDetailService;
-import org.jeecg.modules.eam.service.ICalibrationOrderReportService;
-import org.jeecg.modules.eam.service.ICalibrationOrderService;
-import org.jeecg.modules.eam.service.IEamEquipmentService;
+import org.jeecg.modules.eam.service.*;
 import org.jeecg.modules.eam.vo.CalibrationOrderPage;
-
-//import org.jeecg.modules.system.service.IUploadRelaService;
-//import org.jeecg.modules.system.service.IUploadService;
+import org.jeecg.modules.eam.vo.SysFileNameVo;
+import org.jeecg.modules.system.entity.SysDepart;
+import org.jeecg.modules.system.service.ISysDepartService;
 import org.jeecgframework.poi.excel.ExcelImportUtil;
 import org.jeecgframework.poi.excel.def.NormalExcelConstants;
 import org.jeecgframework.poi.excel.entity.ExportParams;
@@ -45,6 +44,8 @@
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 import java.io.IOException;
+import java.time.LocalDate;
+import java.time.ZoneId;
 import java.util.*;
 import java.util.concurrent.atomic.AtomicReference;
 import java.util.stream.Collectors;
@@ -69,12 +70,27 @@
     private ICalibrationOrderReportService calibrationOrderReportService;
     @Autowired
     private IEamEquipmentService equipmentService;
+
+    @Autowired
+    private IPrecisionParametersTemplateDetailService precisionParametersTemplateDetailService;
+
+    @Autowired
+    private ITechnologyStatusService technologyStatusService;
+
+    @Autowired
+    private ISysFileNameService sysFileNameService;
+
+    @Autowired
+    private ISysDepartService sysDepartService;
 //    @Autowired
 //    private IUploadRelaService uploadRelaService;
 //    @Autowired
 //    private IUploadService uploadService;
 
     private ISysBaseAPI  sysBaseApi;
+
+    @Autowired
+    private IAreaService areaService;
     /**
      * 鍒嗛〉鍒楄〃鏌ヨ
      *
@@ -457,37 +473,41 @@
             String managementMode = record.getManagementMode();
             String equipmentId = record.getEquipmentId();
             Equipment equipment = equipmentService.getById(equipmentId);
+            String useId = equipment.getUseId();
+            SysDepart depart = sysDepartService.getById(useId);
             if(equipment != null){
                 record.setEquipmentNum(equipment.getNum());
                 record.setEquipmentName(equipment.getName());
                 record.setEquipmentModel(equipment.getModel());
                 record.setEquipmentSpecification(equipment.getSpecification());
+                record.setEquipmentImportance(equipment.getEquipmentImportanceId());
+                record.setUseDepartName(ObjectUtils.isNotNull(depart)?depart.getDepartName():"");
             }
-            List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(equipmentId);
-            record.setPrecisionParameterList(precisionParameterList);
-            if("4".equals(status)){
-                if("data".equals(managementMode)){
-                    List<CalibrationOrderDetail> calibrationOrderDetails = calibrationOrderDetailService.lambdaQuery()
-                            .eq(CalibrationOrderDetail::getCalibrationOrderId, id)
-                            .eq(CalibrationOrderDetail::getJudgmentResult, "fail")
-                            .eq(CalibrationOrderDetail::getDelFlag,"0").list();
-                    if(calibrationOrderDetails.size()>0){
-                        record.setCalibrationResult("寮傚父");
-                    }else{
-                        record.setCalibrationResult("姝e父");
-                    }
-                }else{
-                    List<CalibrationOrderReport> calibrationOrderReports = calibrationOrderReportService.lambdaQuery()
-                            .eq(CalibrationOrderReport::getCalibrationOrderId, id)
-                            .eq(CalibrationOrderReport::getJudgmentResult, "fail")
-                            .eq(CalibrationOrderReport::getDelFlag, "0").list();
-                    if(calibrationOrderReports.size()>0){
-                        record.setCalibrationResult("寮傚父");
-                    }else{
-                        record.setCalibrationResult("姝e父");
-                    }
-                }
-            }
+//            List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(equipmentId);
+//            record.setPrecisionParameterList(precisionParameterList);
+//            if("4".equals(status)){
+//                if("data".equals(managementMode)){
+//                    List<CalibrationOrderDetail> calibrationOrderDetails = calibrationOrderDetailService.lambdaQuery()
+//                            .eq(CalibrationOrderDetail::getCalibrationOrderId, id)
+//                            .eq(CalibrationOrderDetail::getJudgmentResult, "fail")
+//                            .eq(CalibrationOrderDetail::getDelFlag,"0").list();
+//                    if(calibrationOrderDetails.size()>0){
+//                        record.setCalibrationResult("寮傚父");
+//                    }else{
+//                        record.setCalibrationResult("姝e父");
+//                    }
+//                }else{
+//                    List<CalibrationOrderReport> calibrationOrderReports = calibrationOrderReportService.lambdaQuery()
+//                            .eq(CalibrationOrderReport::getCalibrationOrderId, id)
+//                            .eq(CalibrationOrderReport::getJudgmentResult, "fail")
+//                            .eq(CalibrationOrderReport::getDelFlag, "0").list();
+//                    if(calibrationOrderReports.size()>0){
+//                        record.setCalibrationResult("寮傚父");
+//                    }else{
+//                        record.setCalibrationResult("姝e父");
+//                    }
+//                }
+//            }
         }
         return Result.OK(pageList);
     }
@@ -502,16 +522,24 @@
         for (CalibrationOrderDetail calibrationOrderDetail : calibrationOrderDetails) {
             calibrationOrderDetailService.removeById(calibrationOrderDetail);
         }
-        List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(calibrationOrder.getEquipmentId());
-        CalibrationOrderDetail calibrationOrderDetail = null;
-        for (Map<String, Object> map : precisionParameterList) {
-            calibrationOrderDetail = new CalibrationOrderDetail();
+//        addAndEdit(calibrationOrder);
+        return Result.OK("缂栬緫鎴愬姛!");
+    }
+
+    private void addAndEdit(@RequestBody CalibrationOrder calibrationOrder) {
+        String precisionParametersTemplateId = calibrationOrder.getCalibrationOrderUda1();
+        List<PrecisionParametersTemplateDetail> precisionParametersTemplateDetails = precisionParametersTemplateDetailService
+                .list(new QueryWrapper<PrecisionParametersTemplateDetail>()
+                        .eq("precision_parameters_template_id",precisionParametersTemplateId)
+                        .eq("del_flag",0));
+        for (PrecisionParametersTemplateDetail precisionParametersTemplateDetail : precisionParametersTemplateDetails) {
+            CalibrationOrderDetail calibrationOrderDetail = new CalibrationOrderDetail();
             calibrationOrderDetail.setCalibrationOrderId(calibrationOrder.getId());
-            calibrationOrderDetail.setEquipmentPrecisionParametersId((String)map.get("id"));
-            calibrationOrderDetail.setPrecisionParametersId((String)map.get("precisionParametersId"));
+            calibrationOrderDetail.setCalibrationOrderDetailUda1(precisionParametersTemplateDetail.getId());
+            calibrationOrderDetail.setPrecisionParametersId(precisionParametersTemplateDetail.getPrecisionParametersId());
+            calibrationOrderDetail.setSort(precisionParametersTemplateDetail.getSort());
             calibrationOrderDetailService.save(calibrationOrderDetail);
         }
-        return Result.OK("缂栬緫鎴愬姛!");
     }
 
     /**
@@ -523,16 +551,24 @@
     public Result<String> addNew(@RequestBody CalibrationOrder calibrationOrder) {
         calibrationOrder.setStatus("1");
         calibrationOrderService.save(calibrationOrder);
-        List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(calibrationOrder.getEquipmentId());
-        CalibrationOrderDetail calibrationOrderDetail = null;
-        for (Map<String, Object> map : precisionParameterList) {
-            calibrationOrderDetail = new CalibrationOrderDetail();
-            calibrationOrderDetail.setCalibrationOrderId(calibrationOrder.getId());
-            calibrationOrderDetail.setEquipmentPrecisionParametersId((String)map.get("id"));
-            calibrationOrderDetail.setPrecisionParametersId((String)map.get("precisionParametersId"));
-            calibrationOrderDetailService.save(calibrationOrderDetail);
+
+        String equipmentId = calibrationOrder.getEquipmentId();
+        Equipment equipment = equipmentService.getById(equipmentId);
+        String equipmentImportance = equipment.getEquipmentImportanceId();
+        if("D".equals(equipmentImportance)){
+            this.createTechnologyStatus(calibrationOrder);
         }
+
+//        addAndEdit(calibrationOrder);
         return Result.OK("娣诲姞鎴愬姛锛�");
+    }
+
+    void createTechnologyStatus(CalibrationOrder calibrationOrder){
+        List<SysFileNameVo> sysFileName = sysFileNameService.getSysFileName("9");
+        TechnologyStatus technologyStatus = new TechnologyStatus();
+        technologyStatus.setOrderId(calibrationOrder.getId());
+        technologyStatus.setReceipts(sysFileName.get(0).getReceipts());
+        technologyStatusService.save(technologyStatus);
     }
 
     /**
@@ -598,4 +634,202 @@
         calibrationOrderService.removeById(id);
         return Result.OK("鍒犻櫎鎴愬姛!");
     }
+    @GetMapping(value = "/listByMainId")
+    public Result<IPage<CalibrationOrderDetail>> listByMainId(CalibrationOrderDetail calibrationOrderDetail,
+                                                                                                    @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
+                                                                                                    @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
+                                                                                                    HttpServletRequest req) {
+        QueryWrapper<CalibrationOrderDetail> queryWrapper = QueryGenerator.initQueryWrapper(calibrationOrderDetail, req.getParameterMap());
+        Page<CalibrationOrderDetail> page = new Page<CalibrationOrderDetail>(pageNo, pageSize);
+        IPage<CalibrationOrderDetail> pageList = calibrationOrderDetailService.pageList(page,calibrationOrderDetail.getCalibrationOrderId());
+        return Result.OK(pageList);
+    }
+    @RequestMapping(value = "/saveFinal", method = {RequestMethod.PUT, RequestMethod.POST})
+    public Result<String> saveFinal(@RequestBody CalibrationOrder calibrationOrder) {
+        calibrationOrder.setCalibrationTime(new Date());
+        calibrationOrder.setStatus("5");
+        if(StringUtils.isNotBlank(calibrationOrder.getEquipmentId())){
+            String equipmentId = calibrationOrder.getEquipmentId();
+            Equipment equipment = equipmentService.getById(equipmentId);
+            if(ObjectUtils.isNotNull(equipment)){
+                LocalDate currentDate = LocalDate.now();
+                // 娣诲姞缁存姢鍛ㄦ湡鐨勬棩鏈�
+                String checkPeriod = equipment.getCheckPeriod();
+                if(StringUtils.isNotBlank(checkPeriod)){
+                    LocalDate dateAfter30Days = currentDate.plusDays(Integer.parseInt(checkPeriod));
+                    Date result = Date.from(dateAfter30Days.atStartOfDay(ZoneId.systemDefault()).toInstant());
+                    equipment.setTechnologyStatus(calibrationOrder.getCalibrationOrderUda6());
+                    equipment.setTechnologyStatusQualificationTime(new Date());
+                    equipment.setNextTechnologyStatusQualificationTime(result);
+                }else {
+                    return Result.error("璇ヨ澶囧皻鏈淮鎶ゆ瀹氬懆鏈燂紝璇峰厛缁存姢妫�瀹氬懆鏈�");
+                }
+
+                // 杞崲涓簀ava.util.Date
+                equipmentService.updateById(equipment);
+            }
+
+
+        }
+        calibrationOrderService.updateById(calibrationOrder);
+        return Result.OK("缂栬緫鎴愬姛!");
+    }
+
+    /**
+     *棣栭〉鍏徃绾� 鎶�鏈姸鎬佹暟閲忕粺璁�
+     * qsw 2024-3-13
+     */
+    @GetMapping("getFactoryEquipmentTechnologyStatusList")
+    public Result<?> getFactoryEquipmentTechnologyStatusList() {
+        List<Map<String, Object>> list = calibrationOrderService.getFactoryEquipmentTechnologyStatusList();
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉鍏徃绾� 璁惧鎶ヤ慨鎯呭喌缁熻
+     * qsw 2024-3-13
+     */
+    @GetMapping("getFactoryReportRepairEquipmentList")
+    public Result<?> getFactoryReportRepairEquipmentList() {
+        List<Map<String, Object>> list = calibrationOrderService.getFactoryReportRepairEquipmentList();
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉鍏徃绾� 鏈湀涓変繚璁″垝
+     * qsw 2024-3-14
+     */
+    @GetMapping("getFactoryThisMonthMaintenanceList")
+    public Result<?> getFactoryThisMonthMaintenanceList() {
+        List<Map<String, Object>> list = calibrationOrderService.getFactoryThisMonthMaintenanceList();
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉鍏徃绾� 涓嬫湀涓変繚璁″垝
+     * qsw 2024-3-14
+     */
+    @GetMapping("getFactoryNextMonthMaintenanceList")
+    public Result<?> getFactoryNextMonthMaintenanceList() {
+        List<Map<String, Object>> list = calibrationOrderService.getFactoryNextMonthMaintenanceList();
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉鍏徃绾� 鏈湀涓変繚瀹屾垚鏁伴噺
+     * qsw 2024-3-14
+     */
+    @GetMapping("getFactoryThisMonthMaintenanceFinishList")
+    public Result<?> getFactoryThisMonthMaintenanceFinishList() {
+        List<Map<String, Object>> list = calibrationOrderService.getFactoryThisMonthMaintenanceFinishList();
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉鍏徃绾� 涓嬩笅鏈堜笁淇濊鍒�
+     * qsw 2024-3-14
+     */
+    @GetMapping("getFactoryNextNextMonthMaintenanceList")
+    public Result<?> getFactoryNextNextMonthMaintenanceList() {
+        List<Map<String, Object>> list = calibrationOrderService.getFactoryNextNextMonthMaintenanceList();
+        return Result.ok(list);
+    }
+
+
+    /**
+     *棣栭〉锛堜簩绾ч〉闈級鎶�鏈姸鎬佹暟閲忕粺璁�
+     * qsw 2024-3-13
+     */
+    @GetMapping("getEquipmentTechnologyStatusList")
+    public Result<?> getEquipmentTechnologyStatusList(@Param("factoryNum") String factoryNum) {
+        List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list();
+        List<Map<String, Object>> list;
+        if(areaList.size()>0){
+            list = calibrationOrderService.getEquipmentTechnologyStatusList(areaList.get(0).getId());
+        }else{
+            list = null;
+        }
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉锛堜簩绾ч〉闈級璁惧鎶ヤ慨鎯呭喌缁熻
+     * qsw 2024-3-13
+     */
+    @GetMapping("getReportRepairEquipmentList")
+    public Result<?> getReportRepairEquipmentList(@Param("factoryNum") String factoryNum) {
+        List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list();
+        List<Map<String, Object>> list;
+        if(areaList.size()>0){
+            list = calibrationOrderService.getReportRepairEquipmentList(areaList.get(0).getId());
+        }else{
+            list = null;
+        }
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚璁″垝
+     * qsw 2024-3-14
+     */
+    @GetMapping("getThisMonthMaintenanceList")
+    public Result<?> getThisMonthMaintenanceList(@Param("factoryNum") String factoryNum) {
+        List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list();
+        List<Map<String, Object>> list;
+        if(areaList.size()>0){
+            list = calibrationOrderService.getThisMonthMaintenanceList(areaList.get(0).getId());
+        }else{
+            list = null;
+        }
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉锛堜簩绾ч〉闈級涓嬫湀涓変繚璁″垝
+     * qsw 2024-3-14
+     */
+    @GetMapping("getNextMonthMaintenanceList")
+    public Result<?> getNextMonthMaintenanceList(@Param("factoryNum") String factoryNum) {
+        List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list();
+        List<Map<String, Object>> list;
+        if(areaList.size()>0){
+            list = calibrationOrderService.getNextMonthMaintenanceList(areaList.get(0).getId());
+        }else{
+            list = null;
+        }
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉锛堜簩绾ч〉闈級涓嬩笅鏈堜笁淇濊鍒�
+     * qsw 2024-3-14
+     */
+    @GetMapping("getNextNextMonthMaintenanceList")
+    public Result<?> getNextNextMonthMaintenanceList(@Param("factoryNum") String factoryNum) {
+        List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list();
+        List<Map<String, Object>> list;
+        if(areaList.size()>0){
+            list = calibrationOrderService.getNextNextMonthMaintenanceList(areaList.get(0).getId());
+        }else{
+            list = null;
+        }
+        return Result.ok(list);
+    }
+
+    /**
+     *棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚瀹屾垚鏁伴噺
+     * qsw 2024-3-14
+     */
+    @GetMapping("getThisMonthMaintenanceFinishList")
+    public Result<?> getThisMonthMaintenanceFinishList(@Param("factoryNum") String factoryNum) {
+        List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list();
+        List<Map<String, Object>> list;
+        if(areaList.size()>0){
+            list = calibrationOrderService.getThisMonthMaintenanceFinishList(areaList.get(0).getId());
+        }else{
+            list = null;
+        }
+        return Result.ok(list);
+    }
+
 }

--
Gitblit v1.9.3