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