From 3d63e7c025d5d8164df640d7c947e601c149e951 Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期一, 21 七月 2025 14:12:52 +0800 Subject: [PATCH] art: 技术状态鉴定工单-定时任务生成 --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamInspectionOrderController.java | 342 ++++++++++---------------------------------------------- 1 files changed, 63 insertions(+), 279 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamInspectionOrderController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamInspectionOrderController.java index c5a3769..7fd0901 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamInspectionOrderController.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamInspectionOrderController.java @@ -3,6 +3,7 @@ import cn.hutool.core.collection.CollectionUtil; import com.alibaba.fastjson.JSONObject; import com.alibaba.fastjson.parser.Feature; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.fasterxml.jackson.core.JsonProcessingException; @@ -15,10 +16,12 @@ import org.jeecg.common.system.base.controller.JeecgController; import org.jeecg.common.util.TranslateDictTextUtils; import org.jeecg.modules.eam.constant.BusinessCodeConst; +import org.jeecg.modules.eam.constant.InspectionItemCategroyEnum; import org.jeecg.modules.eam.constant.InspectionStatus; import org.jeecg.modules.eam.constant.OrderCreationMethodEnum; import org.jeecg.modules.eam.entity.EamInspectionOrder; import org.jeecg.modules.eam.entity.EamInspectionOrderDetail; +import org.jeecg.modules.eam.entity.EamMaintenanceStandardDetail; import org.jeecg.modules.eam.request.EamInspectionBatchApprovalRequest; import org.jeecg.modules.eam.request.EamInspectionOrderQuery; import org.jeecg.modules.eam.request.EamInspectionOrderRequest; @@ -27,16 +30,13 @@ import org.jeecg.modules.eam.vo.InspectionVo; import org.jeecg.modules.flowable.domain.vo.WorkTaskDataVo; import org.jeecg.modules.system.service.ISysBusinessCodeRuleService; -import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; +import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; -import java.util.ArrayList; -import java.util.Arrays; -import java.util.List; -import java.util.Map; +import java.util.*; /** * @Description: 鐐规宸ュ崟 @@ -49,15 +49,16 @@ @RequestMapping("/eam/eamInspectionOrder") @Slf4j public class EamInspectionOrderController extends JeecgController<EamInspectionOrder, IEamInspectionOrderService> { - @Autowired + + @Resource private IEamInspectionOrderService eamInspectionOrderService; - @Autowired + @Resource private ISysBusinessCodeRuleService businessCodeRuleService; - @Autowired + @Resource private ObjectMapper objectMapper; - @Autowired + @Resource private TranslateDictTextUtils translateDictTextUtils; - @Autowired + @Resource private IEamInspectionOrderDetailService eamInspectionOrderDetailService; /** @@ -69,14 +70,12 @@ * @param req * @return */ - //@AutoLog(value = "鐐规宸ュ崟-鍒嗛〉鍒楄〃鏌ヨ") @ApiOperation(value = "鐐规宸ュ崟-鍒嗛〉鍒楄〃鏌ヨ", notes = "鐐规宸ュ崟-鍒嗛〉鍒楄〃鏌ヨ") @GetMapping(value = "/list") public Result<IPage<EamInspectionOrder>> queryPageList(EamInspectionOrderQuery query, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) { -// QueryWrapper<EamInspectionOrder> queryWrapper = QueryGenerator.initQueryWrapper(eamInspectionOrder, req.getParameterMap()); Page<EamInspectionOrder> page = new Page<EamInspectionOrder>(pageNo, pageSize); IPage<EamInspectionOrder> pageList = eamInspectionOrderService.queryPageList(page, query); return Result.OK(pageList); @@ -109,8 +108,7 @@ String codeSeq = businessCodeRuleService.generateBusinessCodeSeq(BusinessCodeConst.INSPECTION_ORDER_CODE_RULE); eamInspectionOrderRequest.setOrderNum(codeSeq); eamInspectionOrderRequest.setCreationMethod(String.valueOf(OrderCreationMethodEnum.MANUAL)); - eamInspectionOrderService.addInspectionOrder(eamInspectionOrderRequest); - return Result.OK("娣诲姞鎴愬姛锛�"); + return eamInspectionOrderService.addInspectionOrder(eamInspectionOrderRequest); } /** @@ -282,7 +280,6 @@ * @param id * @return */ - //@AutoLog(value = "鐐规宸ュ崟-閫氳繃id鏌ヨ") @ApiOperation(value = "鐐规宸ュ崟-閫氳繃id鏌ヨ", notes = "鐐规宸ュ崟-閫氳繃id鏌ヨ") @GetMapping(value = "/queryById") public Result<?> queryById(@RequestParam(name = "id", required = true) String id) { @@ -300,6 +297,7 @@ translateDictTextUtils.translateField("inspectionStatus", eamInspectionOrder.getInspectionStatus(), item, "inspection_status"); translateDictTextUtils.translateField("confirmUser", eamInspectionOrder.getConfirmUser(), item, "sys_user,realname,username"); translateDictTextUtils.translateField("confirmDealType", eamInspectionOrder.getConfirmDealType(), item, "approved_rejected"); + translateDictTextUtils.translateField("equipmentCode", eamInspectionOrder.getEquipmentId(), item, "eam_equipment,id,equipment_code"); return Result.OK(item); } catch (JsonProcessingException e) { return Result.error("鏁版嵁杞瘧澶辫触锛�"); @@ -332,277 +330,63 @@ } /** - * 鎶ヨ〃浣跨敤 qsw - * 2025-6-19 + * 瀵煎嚭鑾峰彇鍩烘湰淇℃伅 + * @param equipmentCode 缁熶竴缂栫爜 + * @param inspectionDate 鏃ユ湡 + * @return */ - @GetMapping("/findInspectionResult") - public JSONObject findInspectionResult(@RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, - @RequestParam(name = "pageSize", defaultValue = "1000") Integer pageSize, - @RequestParam Map<String, Object> params) { - - String equipmentId = (String)params.get("equipmentId"); - String inspectionDate = (String)params.get("inspectionDate"); - - List<InspectionVo> inspectionVos = new ArrayList<>(); - List<Map<String, Object>> inspectionStandard = eamInspectionOrderService.findInspectionStandard(equipmentId); - for (Map<String, Object> map : inspectionStandard) { - List<InspectionVo> dayInspectionResult = eamInspectionOrderService.findInspectionResult(equipmentId,(String)map.get("itemDemand"),inspectionDate); - InspectionVo inspectionVo = new InspectionVo(); - inspectionVo.setInspectionContent((String)map.get("itemDemand")); - Object seq = map.get("seq"); - inspectionVo.setSeq(seq.toString()); - for (InspectionVo vo : dayInspectionResult) { - if("1".equals(vo.getDayTime())){ - inspectionVo.setDay1(vo.getInspectionResult()); - continue; - }else if("2".equals(vo.getDayTime())){ - inspectionVo.setDay2(vo.getInspectionResult()); - continue; - }else if("3".equals(vo.getDayTime())){ - inspectionVo.setDay3(vo.getInspectionResult()); - continue; - }else if("4".equals(vo.getDayTime())){ - inspectionVo.setDay4(vo.getInspectionResult()); - continue; - }else if("5".equals(vo.getDayTime())){ - inspectionVo.setDay5(vo.getInspectionResult()); - continue; - }else if("6".equals(vo.getDayTime())){ - inspectionVo.setDay6(vo.getInspectionResult()); - continue; - }else if("7".equals(vo.getDayTime())){ - inspectionVo.setDay7(vo.getInspectionResult()); - continue; - }else if("8".equals(vo.getDayTime())){ - inspectionVo.setDay8(vo.getInspectionResult()); - continue; - }else if("9".equals(vo.getDayTime())){ - inspectionVo.setDay9(vo.getInspectionResult()); - continue; - }else if("10".equals(vo.getDayTime())){ - inspectionVo.setDay10(vo.getInspectionResult()); - continue; - }else if("11".equals(vo.getDayTime())){ - inspectionVo.setDay11(vo.getInspectionResult()); - continue; - }else if("12".equals(vo.getDayTime())){ - inspectionVo.setDay12(vo.getInspectionResult()); - continue; - }else if("13".equals(vo.getDayTime())){ - inspectionVo.setDay13(vo.getInspectionResult()); - continue; - }else if("14".equals(vo.getDayTime())){ - inspectionVo.setDay14(vo.getInspectionResult()); - continue; - }else if("15".equals(vo.getDayTime())){ - inspectionVo.setDay15(vo.getInspectionResult()); - continue; - }else if("16".equals(vo.getDayTime())){ - inspectionVo.setDay16(vo.getInspectionResult()); - continue; - }else if("17".equals(vo.getDayTime())){ - inspectionVo.setDay17(vo.getInspectionResult()); - continue; - }else if("18".equals(vo.getDayTime())){ - inspectionVo.setDay18(vo.getInspectionResult()); - continue; - }else if("19".equals(vo.getDayTime())){ - inspectionVo.setDay19(vo.getInspectionResult()); - continue; - }else if("20".equals(vo.getDayTime())){ - inspectionVo.setDay20(vo.getInspectionResult()); - continue; - }else if("21".equals(vo.getDayTime())){ - inspectionVo.setDay21(vo.getInspectionResult()); - continue; - }else if("22".equals(vo.getDayTime())){ - inspectionVo.setDay22(vo.getInspectionResult()); - continue; - }else if("23".equals(vo.getDayTime())){ - inspectionVo.setDay23(vo.getInspectionResult()); - continue; - }else if("24".equals(vo.getDayTime())){ - inspectionVo.setDay24(vo.getInspectionResult()); - continue; - }else if("25".equals(vo.getDayTime())){ - inspectionVo.setDay25(vo.getInspectionResult()); - continue; - }else if("26".equals(vo.getDayTime())){ - inspectionVo.setDay26(vo.getInspectionResult()); - continue; - }else if("27".equals(vo.getDayTime())){ - inspectionVo.setDay27(vo.getInspectionResult()); - continue; - }else if("28".equals(vo.getDayTime())){ - inspectionVo.setDay28(vo.getInspectionResult()); - continue; - }else if("29".equals(vo.getDayTime())){ - inspectionVo.setDay29(vo.getInspectionResult()); - continue; - }else if("30".equals(vo.getDayTime())){ - inspectionVo.setDay30(vo.getInspectionResult()); - continue; - }else if("31".equals(vo.getDayTime())){ - inspectionVo.setDay31(vo.getInspectionResult()); - continue; - } - } - inspectionVos.add(inspectionVo); - } - JSONObject jsonObject = new JSONObject(); - jsonObject.put("data",inspectionVos); - return jsonObject; + @GetMapping("/exportInsOrderBaseInfo") + public JSONObject exportInspectionOrderBaseInfo(@RequestParam(name = "equipmentCode", required = true) String equipmentCode, + @RequestParam(name = "inspectionDate", required = false) String inspectionDate) { + return eamInspectionOrderService.exportInspectionOrderBaseInfo(equipmentCode, inspectionDate); } /** - * 鎶ヨ〃浣跨敤 qsw - * 2025-6-19 + * 鏃ョ偣妫�椤瑰垪琛� + * @param equipmentCode 缁熶竴缂栫爜 + * @param inspectionDate 鏃ユ湡 + * @return */ - @GetMapping("/findInspectionUser") - public JSONObject findInspectionUser(@RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, - @RequestParam(name = "pageSize", defaultValue = "1000") Integer pageSize, - @RequestParam Map<String, Object> params) { - - String equipmentId = (String)params.get("equipmentId"); - String inspectionDate = (String)params.get("inspectionDate"); - - List<InspectionVo> inspectionVos = new ArrayList<>(); - List<InspectionVo> inspectionUser = eamInspectionOrderService.findInspectionUser(equipmentId,inspectionDate); - InspectionVo inspectionVo = new InspectionVo(); - for (InspectionVo vo : inspectionUser) { - if("1".equals(vo.getDayTime())){ - inspectionVo.setOperator1(vo.getOperator()); - inspectionVo.setConfirmUser1(vo.getConfirmUser()); - continue; - }else if("2".equals(vo.getDayTime())){ - inspectionVo.setOperator2(vo.getOperator()); - inspectionVo.setConfirmUser2(vo.getConfirmUser()); - continue; - }else if("3".equals(vo.getDayTime())){ - inspectionVo.setOperator3(vo.getOperator()); - inspectionVo.setConfirmUser3(vo.getConfirmUser()); - continue; - }else if("4".equals(vo.getDayTime())){ - inspectionVo.setOperator4(vo.getOperator()); - inspectionVo.setConfirmUser4(vo.getConfirmUser()); - continue; - }else if("5".equals(vo.getDayTime())){ - inspectionVo.setOperator5(vo.getOperator()); - inspectionVo.setConfirmUser5(vo.getConfirmUser()); - continue; - }else if("6".equals(vo.getDayTime())){ - inspectionVo.setOperator6(vo.getOperator()); - inspectionVo.setConfirmUser6(vo.getConfirmUser()); - continue; - }else if("7".equals(vo.getDayTime())){ - inspectionVo.setOperator7(vo.getOperator()); - inspectionVo.setConfirmUser7(vo.getConfirmUser()); - continue; - }else if("8".equals(vo.getDayTime())){ - inspectionVo.setOperator8(vo.getOperator()); - inspectionVo.setConfirmUser8(vo.getConfirmUser()); - continue; - }else if("9".equals(vo.getDayTime())){ - inspectionVo.setOperator9(vo.getOperator()); - inspectionVo.setConfirmUser9(vo.getConfirmUser()); - continue; - }else if("10".equals(vo.getDayTime())){ - inspectionVo.setOperator10(vo.getOperator()); - inspectionVo.setConfirmUser10(vo.getConfirmUser()); - continue; - }else if("11".equals(vo.getDayTime())){ - inspectionVo.setOperator11(vo.getOperator()); - inspectionVo.setConfirmUser11(vo.getConfirmUser()); - continue; - }else if("12".equals(vo.getDayTime())){ - inspectionVo.setOperator12(vo.getOperator()); - inspectionVo.setConfirmUser12(vo.getConfirmUser()); - continue; - }else if("13".equals(vo.getDayTime())){ - inspectionVo.setOperator13(vo.getOperator()); - inspectionVo.setConfirmUser13(vo.getConfirmUser()); - continue; - }else if("14".equals(vo.getDayTime())){ - inspectionVo.setOperator14(vo.getOperator()); - inspectionVo.setConfirmUser14(vo.getConfirmUser()); - continue; - }else if("15".equals(vo.getDayTime())){ - inspectionVo.setOperator15(vo.getOperator()); - inspectionVo.setConfirmUser15(vo.getConfirmUser()); - continue; - }else if("16".equals(vo.getDayTime())){ - inspectionVo.setOperator16(vo.getOperator()); - inspectionVo.setConfirmUser16(vo.getConfirmUser()); - continue; - }else if("17".equals(vo.getDayTime())){ - inspectionVo.setOperator17(vo.getOperator()); - inspectionVo.setConfirmUser17(vo.getConfirmUser()); - continue; - }else if("18".equals(vo.getDayTime())){ - inspectionVo.setOperator18(vo.getOperator()); - inspectionVo.setConfirmUser18(vo.getConfirmUser()); - continue; - }else if("19".equals(vo.getDayTime())){ - inspectionVo.setOperator19(vo.getOperator()); - inspectionVo.setConfirmUser19(vo.getConfirmUser()); - continue; - }else if("20".equals(vo.getDayTime())){ - inspectionVo.setOperator20(vo.getOperator()); - inspectionVo.setConfirmUser20(vo.getConfirmUser()); - continue; - }else if("21".equals(vo.getDayTime())){ - inspectionVo.setOperator21(vo.getOperator()); - inspectionVo.setConfirmUser21(vo.getConfirmUser()); - continue; - }else if("22".equals(vo.getDayTime())){ - inspectionVo.setOperator22(vo.getOperator()); - inspectionVo.setConfirmUser22(vo.getConfirmUser()); - continue; - }else if("23".equals(vo.getDayTime())){ - inspectionVo.setOperator23(vo.getOperator()); - inspectionVo.setConfirmUser23(vo.getConfirmUser()); - continue; - }else if("24".equals(vo.getDayTime())){ - inspectionVo.setOperator24(vo.getOperator()); - inspectionVo.setConfirmUser24(vo.getConfirmUser()); - continue; - }else if("25".equals(vo.getDayTime())){ - inspectionVo.setOperator25(vo.getOperator()); - inspectionVo.setConfirmUser25(vo.getConfirmUser()); - continue; - }else if("26".equals(vo.getDayTime())){ - inspectionVo.setOperator26(vo.getOperator()); - inspectionVo.setConfirmUser26(vo.getConfirmUser()); - continue; - }else if("27".equals(vo.getDayTime())){ - inspectionVo.setOperator27(vo.getOperator()); - inspectionVo.setConfirmUser27(vo.getConfirmUser()); - continue; - }else if("28".equals(vo.getDayTime())){ - inspectionVo.setOperator28(vo.getOperator()); - inspectionVo.setConfirmUser28(vo.getConfirmUser()); - continue; - }else if("29".equals(vo.getDayTime())){ - inspectionVo.setOperator29(vo.getOperator()); - inspectionVo.setConfirmUser29(vo.getConfirmUser()); - continue; - }else if("30".equals(vo.getDayTime())){ - inspectionVo.setOperator30(vo.getOperator()); - inspectionVo.setConfirmUser30(vo.getConfirmUser()); - continue; - }else if("31".equals(vo.getDayTime())){ - inspectionVo.setOperator31(vo.getOperator()); - inspectionVo.setConfirmUser31(vo.getConfirmUser()); - continue; - } - } - inspectionVos.add(inspectionVo); -// } - JSONObject jsonObject = new JSONObject(); - jsonObject.put("data",inspectionVos); - return jsonObject; + @GetMapping("/exportInsOrderDetailList") + public JSONObject exportInspectionOrderDetailList(@RequestParam(name = "equipmentCode", required = true) String equipmentCode, + @RequestParam(name = "inspectionDate", required = false) String inspectionDate) { + return eamInspectionOrderService.exportInspectionOrderDetailList(equipmentCode, inspectionDate); } + /** + * 鏃ョ偣妫�璐d换浜哄垪琛� + * @param equipmentCode 缁熶竴缂栫爜 + * @param inspectionDate 鏃ユ湡 + * @return + */ + @GetMapping("/exportInsOrderDetailUserList") + public JSONObject exportInspectionOrderDetailUserList(@RequestParam(name = "equipmentCode", required = true) String equipmentCode, + @RequestParam(name = "inspectionDate", required = false) String inspectionDate) { + return eamInspectionOrderService.exportInspectionOrderDetailUserList(equipmentCode, inspectionDate); + } + /** + * 鍛ㄧ偣妫�椤瑰垪琛� + * @param equipmentCode 缁熶竴缂栫爜 + * @param inspectionDate 鏃ユ湡 + * @return + */ + @GetMapping("/exportWeekInsDetailList") + public JSONObject exportWeekInsDetailList(@RequestParam(name = "equipmentCode", required = true) String equipmentCode, + @RequestParam(name = "inspectionDate", required = false) String inspectionDate) { + return eamInspectionOrderService.exportWeekInsDetailList(equipmentCode, inspectionDate); + } + + /** + * 鍛ㄧ偣妫�璐d换浜哄垪琛� + * @param equipmentCode 缁熶竴缂栫爜 + * @param inspectionDate 鏃ユ湡 + * @return + */ + @GetMapping("/exportWeekInsOrderDetailUserList") + public JSONObject exportInspectionOrder(@RequestParam(name = "equipmentCode", required = true) String equipmentCode, + @RequestParam(name = "inspectionDate", required = false) String inspectionDate) { + return eamInspectionOrderService.exportWeekInsOrderDetailUserList(equipmentCode, inspectionDate); + } } -- Gitblit v1.9.3