src/main/java/com/ruoyi/procurementrecord/pojo/ProcurementRecord.java
@@ -13,7 +13,7 @@ * @author :yys * @date : 2025/7/7 14:25 */ @TableName("procurement_record") @TableName("procurement_record_storage") @Data @Builder public class ProcurementRecord { @@ -27,11 +27,6 @@ * 产品信息表id */ private Integer salesLedgerProductId; /** * 采购分类（1-入库 2-出库） */ private Integer procurementCategory; /** * 入库批次 src/main/java/com/ruoyi/procurementrecord/service/impl/ProcurementRecordServiceImpl.java
@@ -120,13 +120,11 @@ for (Details detail : procurementDto.getDetails()) { // 查询采购入库数量 LambdaQueryWrapper<ProcurementRecord> procurementRecordLambdaQueryWrapper = new LambdaQueryWrapper<>(); procurementRecordLambdaQueryWrapper.eq(ProcurementRecord::getSalesLedgerProductId, detail.getId()) .eq(ProcurementRecord::getProcurementCategory, 1); procurementRecordLambdaQueryWrapper.eq(ProcurementRecord::getSalesLedgerProductId, detail.getId()); Long aLong = procurementRecordMapper.selectCount(procurementRecordLambdaQueryWrapper); ProcurementRecord.ProcurementRecordBuilder procurementRecordBuilder = ProcurementRecord.builder() .salesLedgerProductId(detail.getId()) .procurementCategory(1) .inboundBatches(aLong.equals(0L) ? "第1批次" : "第"+ (aLong + 1) + "批次") .inboundNum(detail.getInboundQuantity()) .createDate(LocalDateTime.now()) src/main/resources/mapper/procurementrecord/ProcurementRecordMapper.xml
@@ -19,7 +19,7 @@ t3.inbound_num as quantityStock from purchase_ledger t1 left join sales_ledger_product t2 on t1.id = t2.sales_ledger_id left join procurement_record t3 on t2.id = t3.sales_ledger_product_id left join procurement_record_storage t3 on t2.id = t3.sales_ledger_product_id where t1.purchase_contract_number = #{req.purchaseContractNumber} <if test="req.id != null and req.id != ''"> and t3.id = #{req.id} @@ -44,7 +44,7 @@ t1.inbound_num, t1.create_date, t1.create_by from procurement_record t1 from procurement_record_storage t1 left join sales_ledger_product t2 on t2.id = t1.sales_ledger_product_id left join purchase_ledger t3 on t3.id = t2.sales_ledger_id <where> @@ -72,7 +72,7 @@ t1.inbound_num, t1.create_date, t1.create_by from procurement_record t1 from procurement_record_storage t1 left join sales_ledger_product t2 on t2.id = t1.sales_ledger_product_id left join purchase_ledger t3 on t3.id = t2.sales_ledger_id </select>
