备件管理、备件库存管理

qushaowei

2025-05-22 653489f1b4430678b4a197046b7e73b37b682ff6

 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);
    }