From 653489f1b4430678b4a197046b7e73b37b682ff6 Mon Sep 17 00:00:00 2001
From: qushaowei <qushaowei@163.com>
Date: 星期四, 22 五月 2025 17:46:03 +0800
Subject: [PATCH] 备件管理、备件库存管理
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java | 11 +++++++++++
1 files changed, 11 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..377f682 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,12 @@
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);
+ record.setTotalQuantity(one.getInventory().toString());
+ }
return Result.OK(pageList);
}
--
Gitblit v1.9.3