From 43761042988ab4940f5e04e8c8b1cf7e51dd3029 Mon Sep 17 00:00:00 2001
From: “linengliang” <vanSuperEnergy@163.com>
Date: 星期一, 04 九月 2023 17:02:56 +0800
Subject: [PATCH] 设备台账

---
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java |  120 +++++++++++++++++++++++++++++++++++++++++++++---------------
 1 files changed, 90 insertions(+), 30 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 3a960a8..4e74994 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
@@ -185,6 +185,8 @@
 												   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
 												   HttpServletRequest req) {
 		 QueryWrapper<Equipment> queryWrapper = QueryGenerator.initQueryWrapper(equipment, req.getParameterMap());
+		 queryWrapper.eq("status","1");
+		 queryWrapper.eq("del_flag",0);
 		 Page<Equipment> page = new Page<Equipment>(pageNo, pageSize);
 		 IPage<Equipment> pageList = equipmentService.page(page, queryWrapper);
 		 return Result.OK(pageList);
@@ -356,7 +358,7 @@
     //@RequiresPermissions("org.jeecg.modules.demo:mom_eam_equipment:exportXls")
     @RequestMapping(value = "/exportXls")
     public ModelAndView exportXls(HttpServletRequest request, Equipment equipment) {
-        return super.exportXls(request, equipment, Equipment.class, "mom_eam_equipment");
+        return super.exportXls(request, equipment, Equipment.class, "璁惧鍙拌处瀵煎嚭");
     }
 
 //    /**
@@ -535,34 +537,92 @@
 				 for(int i = 0;i<list.size();i++){
                      EquipmentImportVo equipmentImportVo = list.get(i);
 					 EquipmentCategory equipmentCategory = equipmentCategoryService.getOne(new QueryWrapper<EquipmentCategory>().eq("name",equipmentImportVo.getEquipmentCategoryName()),false);
-                     if(
-                     		StringUtils.isBlank(equipmentImportVo.getNum())
-									|| StringUtils.isBlank(equipmentImportVo.getName())
-									|| StringUtils.isBlank(equipmentImportVo.getUseId())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentUda1())
-									|| StringUtils.isBlank(equipmentImportVo.getManageId())
-									|| StringUtils.isBlank(equipmentImportVo.getTeamId())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentImportanceId())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentCategoryName())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentStatus())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentUda3())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentUda5())
-									|| StringUtils.isBlank(equipmentImportVo.getEquipmentUda2())
-									|| StringUtils.isBlank(equipmentImportVo.getLeaveFactoryDate())
-									|| StringUtils.isBlank(equipmentImportVo.getProjectApprovalNo())
-									|| StringUtils.isBlank(equipmentImportVo.getFundSource())
-									|| StringUtils.isBlank(equipmentImportVo.getAcceptanceCheckDate())
-									|| StringUtils.isBlank(equipmentImportVo.getLeaveFactoryDate())
-									|| StringUtils.isBlank(equipmentImportVo.getFactoryNo())
-									|| StringUtils.isBlank(equipmentImportVo.getConstructorId())
-									|| StringUtils.isBlank(equipmentImportVo.getSourceCountry())
-									|| StringUtils.isBlank(equipmentImportVo.getModel())
-									|| StringUtils.isBlank(equipmentImportVo.getSpecification())
-									|| StringUtils.isBlank(equipmentImportVo.getGpo())
-					 ){
-						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:鏁版嵁鏈夋湭濉」,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+                     if(StringUtils.isBlank(equipmentImportVo.getNum())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:缁熶竴缂栫爜缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
 						 exceptionNum++;
-					 }else if(ObjectUtils.isNull(equipmentCategory))
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getName())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鍚嶇О缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getUseId())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:浣跨敤閮ㄩ棬缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getEquipmentUda1())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:宸ュ尯缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getManageId())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:缁存姢閮ㄩ棬缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getTeamId())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:缁翠慨鐝粍缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getEquipmentImportanceId())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:ABC鏍囪瘑缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getEquipmentCategoryName())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鍒嗙被缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getEquipmentStatus())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鐘舵�佺己澶�,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     //闈炲繀濉」
+//                     else if(StringUtils.isBlank(equipmentImportVo.getEquipmentUda5())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:鍔熻兘浣嶇疆缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getLocation())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:瀹夎浣嶇疆缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getLeaveFactoryDate())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:鍑哄巶鏃ユ湡缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getProjectApprovalNo())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:绔嬮」鍗″彿缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getFundSource())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璧勯噾鏉ユ簮缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getAcceptanceCheckDate())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:楠屾敹鏃ユ湡缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getLeaveFactoryDate())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:鍑哄巶鏃ユ湡缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if(StringUtils.isBlank(equipmentImportVo.getFactoryNo())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:鍑哄巶缂栧彿缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+//                     else if( StringUtils.isBlank(equipmentImportVo.getConstructorId())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璧勪骇鍒堕�犲晢缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getModel())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鍨嬪彿缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+                     else if(StringUtils.isBlank(equipmentImportVo.getSpecification())){
+						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧瑙勬牸缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+						 exceptionNum++;
+					 }
+//					 else if(StringUtils.isBlank(equipmentImportVo.getGpo())){
+//						 exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璁惧鍔熺巼缂哄け,璇峰~鍐欏繀濉」鍚庡啀瀵煎叆;";
+//						 exceptionNum++;
+//					 }
+					 else if(ObjectUtils.isNull(equipmentCategory))
 					       {
 							  exceptionInfo = exceptionInfo+"绗�"+(i+2)+"琛屽鍏ュけ璐�,鍘熷洜:璇ヨ澶囨墍灞炵被鍒笉瀛樺湪锛岃鍏堢淮鎶よ澶囩被鍒�;";
 							  exceptionNum++;
@@ -592,12 +652,12 @@
 									 .setEquipmentUda3(equipmentImportVo.getEquipmentUda3())
 									 .setEquipmentUda4(equipmentImportVo.getEquipmentUda4())
 									 .setEquipmentUda5(equipmentImportVo.getEquipmentUda5())
-									 .setLocation(equipmentImportVo.getEquipmentUda2())
+									 .setLocation(equipmentImportVo.getLocation())
 									 .setLastVerificationDate(equipmentImportVo.getLeaveFactoryDate())
 									 .setProjectApprovalNo(equipmentImportVo.getProjectApprovalNo())
 									 .setFundSource(equipmentImportVo.getFundSource())
 									 .setAcceptanceCheckDate(equipmentImportVo.getAcceptanceCheckDate())
-									 .setFactoryNumber(equipmentImportVo.getFactoryNo())
+									 .setFactoryNumber(equipmentImportVo.getFactoryNumber())
 									 .setConstructorId(equipmentImportVo.getConstructorId())
 									 .setSourceCountry(equipmentImportVo.getSourceCountry())
 									 .setModel(equipmentImportVo.getModel())

--
Gitblit v1.9.3