From d10ee39ef95eb2442902e36dd36b1683cbd10af6 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期四, 06 三月 2025 15:10:03 +0800
Subject: [PATCH] art: 项目性维修-详情页面-附件，设备状态，技术状态不展示问题修改, 设备选择过滤，只能选择用户范围内的设备信息
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java | 105 +++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 94 insertions(+), 11 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java
index 3a07433..7d881d7 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java
@@ -1,6 +1,7 @@
package org.jeecg.modules.eam.controller;
import java.util.Arrays;
+import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
@@ -35,7 +36,9 @@
import org.jeecg.common.system.base.controller.JeecgController;
import org.jeecg.modules.system.entity.SysDepart;
+import org.jeecg.modules.system.entity.SysUser;
import org.jeecg.modules.system.service.ISysDepartService;
+import org.jeecg.modules.system.service.ISysUserService;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.springframework.beans.factory.annotation.Autowired;
@@ -123,7 +126,8 @@
@Autowired
private IMaintenanceStandardService maintenanceStandardService;
-
+ @Autowired
+ private ISysUserService sysUserService;
/**
@@ -158,6 +162,10 @@
}
if(StringUtils.isNotBlank(equipment.getEquipmentCategoryId())){
queryWrapper.eq("equipment_category_id",equipment.getEquipmentCategoryId());
+ }
+ List<String> userWorkCenterIds = getUserWorkCenterIds();
+ if(CollectionUtils.isNotEmpty(userWorkCenterIds)) {
+ queryWrapper.in("work_center_id",userWorkCenterIds);
}
if(StringUtils.isNotBlank(equipment.getWorkCenterId())){
queryWrapper.eq("work_center_id",equipment.getWorkCenterId());
@@ -218,7 +226,7 @@
if(StringUtils.isNotBlank(equipment.getName())){
queryWrapper.like("name",equipment.getName());
}
- queryWrapper.eq("equipment_status","1");
+// queryWrapper.eq("equipment_status","1");
queryWrapper.in("technology_status","qualified","limitedUse");
queryWrapper.eq("status","1");
queryWrapper.eq("del_flag",0);
@@ -242,7 +250,7 @@
if(StringUtils.isNotBlank(equipment.getName())){
queryWrapper.like("name",equipment.getName());
}
- queryWrapper.eq("equipment_status","1");
+// queryWrapper.eq("equipment_status","1");
queryWrapper.in("technology_status","qualified","limitedUse");
queryWrapper.in("equipment_importance_id","A","B","C");
queryWrapper.eq("status","1");
@@ -305,9 +313,41 @@
@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
@RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
HttpServletRequest req) {
- QueryWrapper<Equipment> queryWrapper = QueryGenerator.initQueryWrapper(equipment, req.getParameterMap());
+ //QueryWrapper<Equipment> queryWrapper = QueryGenerator.initQueryWrapper(equipment, req.getParameterMap());
Page<Equipment> page = new Page<Equipment>(pageNo, pageSize);
IPage<Equipment> pageList = equipmentService.getEquipmentTZList(page, equipment);
+ List<Equipment> list = pageList.getRecords();
+ list.forEach(equip -> {
+ String id = equip.getId();
+ List<DailyInspectionStandard> dailyInspectionStandards = dailyInspectionStandardService.lambdaQuery()
+ .eq(DailyInspectionStandard::getEquipmentId, id)
+ .eq(DailyInspectionStandard::getVersionStatus, "2")
+ .list();
+ if (dailyInspectionStandards.size() > 0) {
+ equip.setYseNoInspectionStandard("0");
+ } else {
+ equip.setYseNoInspectionStandard("1");
+ }
+ List<MaintenanceStandard> maintenance2Standards = maintenanceStandardService.lambdaQuery()
+ .eq(MaintenanceStandard::getEquipmentId, id)
+ .eq(MaintenanceStandard::getMaintenanceType, "2")
+ .eq(MaintenanceStandard::getVersionStatus, "2").list();
+ if (maintenance2Standards.size() > 0) {
+ equip.setYseNoMaintenance2Standard("0");
+ } else {
+ equip.setYseNoMaintenance2Standard("1");
+ }
+
+ List<MaintenanceStandard> maintenance3Standards = maintenanceStandardService.lambdaQuery()
+ .eq(MaintenanceStandard::getEquipmentId, id)
+ .eq(MaintenanceStandard::getMaintenanceType, "3")
+ .eq(MaintenanceStandard::getVersionStatus, "2").list();
+ if (maintenance3Standards.size() > 0) {
+ equip.setYseNoMaintenance3Standard("0");
+ } else {
+ equip.setYseNoMaintenance3Standard("1");
+ }
+ });
return Result.OK(pageList);
}
@@ -667,13 +707,17 @@
EquipmentImportVo equipmentImportVo = list.get(i);
String equipmentCategoryName = equipmentImportVo.getEquipmentCategoryName();
String useId = equipmentImportVo.getUseId();
- String areaId = equipmentImportVo.getFactoryModelId();
+ String workCenterId = equipmentImportVo.getWorkCenterId();//涓績
+ String areaId = equipmentImportVo.getFactoryModelId();//宸ュ尯
+ String productionId = equipmentImportVo.getAreaId();//宸ユ
String manageId = equipmentImportVo.getManageId();
String constructorId = equipmentImportVo.getConstructorId();
String teamId = equipmentImportVo.getTeamId();
String propertyStatus = equipmentImportVo.getPropertyStatus();
String abc = equipmentImportVo.getEquipmentImportanceId();
- if(StringUtils.isBlank(equipmentImportVo.getNum())){
+ Date thirdMaintenanceTime = equipmentImportVo.getThirdMaintenanceTime();
+ Date technologyStatusQualificationTime = equipmentImportVo.getTechnologyStatusQualificationTime();
+ if(StringUtils.isBlank(equipmentImportVo.getNum())){
exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:缁熶竴缂栫爜缂哄け,璇峰～鍐欏繀濉」鍚庡啀瀵煎叆;";
exceptionNum++;
continue;
@@ -698,13 +742,18 @@
exceptionNum++;
continue;
}
- else if(StringUtils.isBlank(equipmentImportVo.getModel())){
- exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鍨嬪彿缂哄け,璇峰～鍐欏繀濉」鍚庡啀瀵煎叆;";
+// else if(StringUtils.isBlank(equipmentImportVo.getModel())){
+// exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鍨嬪彿缂哄け,璇峰～鍐欏繀濉」鍚庡啀瀵煎叆;";
+// exceptionNum++;
+// continue;
+// }
+ else if(StringUtils.isBlank(useId)){
+ exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:浣跨敤閮ㄩ棬缂哄け,璇峰～鍐欏繀濉」鍚庡啀瀵煎叆;";
exceptionNum++;
continue;
}
- else if(StringUtils.isBlank(useId)){
- exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:浣跨敤閮ㄩ棬缂哄け,璇峰～鍐欏繀濉」鍚庡啀瀵煎叆;";
+ else if(StringUtils.isBlank(workCenterId)){
+ exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:涓績缂哄け,璇峰～鍐欏繀濉」鍚庡啀瀵煎叆;";
exceptionNum++;
continue;
}
@@ -790,6 +839,18 @@
exceptionNum++;
continue;
}
+ //涓績
+ Area workCenterArea = areaService.getOne(new QueryWrapper<Area>().eq("name",workCenterId.trim()).eq("del_flag",0));
+ if(ObjectUtils.isNotNull(workCenterArea)){
+ equipment.setWorkCenterId(workCenterArea.getId());
+// }else if(ObjectUtils.isNotNull(area1)) {
+// equipment.setFactoryModelId(area1.getId());
+ }else {
+ exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:涓嶅瓨鍦ㄨ涓績,璇风淮鎶や腑蹇冩暟鎹悗鍐嶅鍏�;";
+ exceptionNum++;
+ continue;
+ }
+ //宸ュ尯
Area area = areaService.getOne(new QueryWrapper<Area>().eq("name",areaId.trim()).eq("del_flag",0));
Area area1 = areaService.getOne(new QueryWrapper<Area>().eq("num",areaId.trim()).eq("del_flag",0));
if(ObjectUtils.isNotNull(area)){
@@ -801,6 +862,13 @@
exceptionNum++;
continue;
}
+
+ //宸ユ
+ Area productionArea = areaService.getOne(new QueryWrapper<Area>().eq("name",productionId.trim()).eq("del_flag",0));
+ if(ObjectUtils.isNotNull(productionArea)){
+ equipment.setAreaId(productionArea.getId());
+ }
+
SysDepart manage = departService.getOne(new QueryWrapper<SysDepart>().eq("depart_name",manageId.trim()).eq("del_flag",0));
if(ObjectUtils.isNotNull(manage)){
equipment.setManageId(manage.getId());
@@ -883,12 +951,14 @@
.setSourceCountry(equipmentImportVo.getSourceCountry())
.setModel(equipmentImportVo.getModel())
.setSpecification(equipmentImportVo.getSpecification())
- .setPropertyStatus(equipmentImportVo.getPropertyStatus())
+ .setPropertyStatus("normal")
.setWarrantyStart(equipmentImportVo.getWarrantyStart())
.setWarrantyEnd(equipmentImportVo.getWarrantyEnd())
.setIsLineEquip("no")
.setIsLine("no")
.setNextTechnologyStatusQualificationTime(equipmentImportVo.getNextTechnologyStatusQualificationTime())
+ .setThirdMaintenanceTime(equipmentImportVo.getThirdMaintenanceTime())
+ .setTechnologyStatusQualificationTime(equipmentImportVo.getTechnologyStatusQualificationTime())
.setGpo(equipmentImportVo.getGpo());
if(equipmentCategory.getEquipmentCategoryUda1().equals("weldingMachine")){
equipment.setCheckPeriod(365*3+"");
@@ -1068,4 +1138,17 @@
return Result.OK(pageList);
}
+ private List<String> getUserWorkCenterIds(){
+ LoginUser user= (LoginUser) SecurityUtils.getSubject().getPrincipal();
+ SysUser sysUser = sysUserService.getById(user.getId());
+ String areaId = sysUser.getAreaId();
+ List<String> workCenterIds = null;
+ if(StringUtils.isNotBlank(areaId)){
+// strings = new ArrayList<>();
+ String[] split = areaId.split(",");
+ workCenterIds = Arrays.asList(split);
+ }
+ return workCenterIds;
+ }
+
}
--
Gitblit v1.9.3