From 854856127101ea6cbbc261db46cb06ac141d6ab0 Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期四, 25 七月 2024 10:50:27 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamEquipmentController.java | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 59 insertions(+), 0 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 6b0ee06..3a07433 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 @@ -159,6 +159,9 @@ if(StringUtils.isNotBlank(equipment.getEquipmentCategoryId())){ queryWrapper.eq("equipment_category_id",equipment.getEquipmentCategoryId()); } + if(StringUtils.isNotBlank(equipment.getWorkCenterId())){ + queryWrapper.eq("work_center_id",equipment.getWorkCenterId()); + } queryWrapper.isNull("line_id"); queryWrapper.eq("status","1"); queryWrapper.eq("del_flag",0); @@ -252,6 +255,29 @@ } + @ApiOperation(value="mom_eam_equipment-鍒嗛〉鍒楄〃鏌ヨ", notes="mom_eam_equipment-鍒嗛〉鍒楄〃鏌ヨ") + @GetMapping(value = "/queryEquipmentList") + public Result<IPage<Equipment>> queryEquipmentList(Equipment equipment, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + HttpServletRequest req) { + QueryWrapper<Equipment> queryWrapper = new QueryWrapper<>(); + if(StringUtils.isNotBlank(equipment.getNum())){ + queryWrapper.like("num",equipment.getNum()); + } + if(StringUtils.isNotBlank(equipment.getName())){ + queryWrapper.like("name",equipment.getName()); + } + queryWrapper.eq("use_id",equipment.getUseId()); + queryWrapper.eq("del_flag",0); + queryWrapper.orderByDesc("create_time"); + + Page<Equipment> page = new Page<Equipment>(pageNo, pageSize); + IPage<Equipment> pageList = equipmentService.page(page, queryWrapper); + return Result.OK(pageList); + } + + /** * 璁惧淇濅慨 鑾峰彇璁惧鍒楄〃缁勪欢 * qsw 2023-7-14 @@ -266,6 +292,22 @@ QueryWrapper<Equipment> queryWrapper = QueryGenerator.initQueryWrapper(equipment, req.getParameterMap()); Page<Equipment> page = new Page<Equipment>(pageNo, pageSize); IPage<Equipment> pageList = equipmentService.getEquipmentList(page, equipment); + return Result.OK(pageList); + } + + /** + * 璁惧淇濅慨 鑾峰彇璁惧鍒楄〃缁勪欢 + * qsw 2023-7-14 + */ + @GetMapping(value = "/getEquipmentTZList") + @PermissionData + public Result<IPage<Equipment>> getEquipmentTZList(Equipment equipment, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + HttpServletRequest req) { + QueryWrapper<Equipment> queryWrapper = QueryGenerator.initQueryWrapper(equipment, req.getParameterMap()); + Page<Equipment> page = new Page<Equipment>(pageNo, pageSize); + IPage<Equipment> pageList = equipmentService.getEquipmentTZList(page, equipment); return Result.OK(pageList); } @@ -1008,5 +1050,22 @@ } return Result.ok(equipmentListAllStandards); } + @GetMapping(value = "/planEquipmentList") + @PermissionData + public Result<IPage<Equipment>> planEquipmentList(Equipment equipment, + @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.orderByAsc("next_third_maintenance_time"); + //濡傛灉startTime鍜宔ndTime涓嶄负绌猴紝鍒欐煡璇笅娆′笁淇濇椂闂村湪杩欎釜鏃堕棿娈靛唴鐨勮澶� + if(equipment.getStartTime()!=null && equipment.getEndTime()!=null){ + queryWrapper.between("next_third_maintenance_time",equipment.getStartTime(),equipment.getEndTime()); + } + Page<Equipment> page = new Page<Equipment>(pageNo, pageSize); + IPage<Equipment> pageList = equipmentService.page(page, queryWrapper); + return Result.OK(pageList); + } } -- Gitblit v1.9.3