From 57945f688fd21076e36ab5332028c8b4a6dcf59c Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期四, 04 九月 2025 16:37:31 +0800 Subject: [PATCH] 同步密网设备管理代码 --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java index efe21a9..0b25e95 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java @@ -8,7 +8,9 @@ import org.jeecg.common.api.vo.Result; import org.jeecg.common.system.query.QueryGenerator; import org.jeecg.common.aspect.annotation.AutoLog; +import org.jeecg.modules.eam.entity.EamSparePartInventory; import org.jeecg.modules.eam.entity.EamSpareParts; +import org.jeecg.modules.eam.service.IEamSparePartInventoryService; import org.jeecg.modules.eam.service.IEamSparePartsService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; @@ -37,6 +39,9 @@ @Resource private IEamSparePartsService eamSparePartsService; + @Autowired + private IEamSparePartInventoryService eamSparePartInventoryService; + /** * 鍒嗛〉鍒楄〃鏌ヨ * @@ -55,6 +60,16 @@ QueryWrapper<EamSpareParts> queryWrapper = QueryGenerator.initQueryWrapper(eamSpareParts, req.getParameterMap()); Page<EamSpareParts> page = new Page<EamSpareParts>(pageNo, pageSize); IPage<EamSpareParts> pageList = eamSparePartsService.page(page, queryWrapper); + for (EamSpareParts record : pageList.getRecords()) { + QueryWrapper<EamSparePartInventory> wrapper = new QueryWrapper<>(); + wrapper.eq("spare_part_id",record.getId()).select("sum(inventory) as inventory"); + EamSparePartInventory one = eamSparePartInventoryService.getOne(wrapper); + if(one == null){ + record.setTotalQuantity("0"); + }else{ + record.setTotalQuantity(one.getInventory().toString()); + } + } return Result.OK(pageList); } -- Gitblit v1.9.3