库存管理-自动补货功能

yaowanxin

2025-09-23 85e776fef3b261b0141325a7744937d3cf603679

库存管理-自动补货功能

 src/main/java/com/ruoyi/procurementrecord/dto/ProcurementPageDtoCopy.java

@@ -43,6 +43,11 @@
     */
    @Excel(name = "待出库数量")
    private BigDecimal inboundNum0;
    /**
     * 出库数量
     */
    @Excel(name = "出库数量")
    private BigDecimal totalInboundNum;

    /**
     * 最低库存数量

 src/main/java/com/ruoyi/procurementrecord/service/impl/ProcurementRecordServiceImpl.java

@@ -431,7 +431,8 @@
            BigDecimal totalInboundNum = collect1.stream()
                    .map(ProcurementRecordOut::getInboundNum)
                    .reduce(BigDecimal.ZERO, BigDecimal::add);

            // 出库数量 = 总数量 - 待出库数量
            dto.setTotalInboundNum(totalInboundNum);
            // 待出库数量 = 总数量 - 已出库数量
            dto.setInboundNum0(dto.getInboundNum().subtract(totalInboundNum));
        }

 src/main/resources/mapper/procurementrecord/ProcurementRecordMapper.xml

@@ -98,6 +98,7 @@
        t1.inbound_batches,
        t1.inbound_num,
        t1.inbound_num as inboundNum0,
        t1.inbound_num as totalInboundNum,
        t1.create_time,
        t1.update_time,
        t1.create_by