fix(purchase): 修复采购台账库存入库记录查询逻辑

云

2026-06-01 3f064b2ef3368351fafd17d626a9a53fe23313c3

fix(purchase): 修复采购台账库存入库记录查询逻辑

- 修改了库存入库记录的关联条件，支持多种记录类型('6', '10')
- 将审批状态条件从stock_in_record表改为quality_inspect表的检验状态
- 确保只有已检验通过的记录被纳入采购台账数量统计

 src/main/resources/mapper/purchase/PurchaseLedgerMapper.xml

@@ -82,13 +82,13 @@
                                   sir.stock_in_num
                            FROM stock_in_record sir
                            INNER JOIN quality_inspect qi
                                ON TRIM(sir.record_type) = '10'
                                ON TRIM(sir.record_type) IN ('6', '10')
                                AND sir.record_id = qi.id
                            INNER JOIN sales_ledger_product slp
                                ON slp.type = 2
                                AND slp.sales_ledger_id = qi.purchase_ledger_id
                                AND slp.product_model_id = qi.product_model_id
                            WHERE sir.approval_status = 1
                            WHERE qi.inspect_state = 1
                        ) rel
                        GROUP BY rel.sales_ledger_product_id
                    ) approved_qty ON approved_qty.sales_ledger_product_id = slp.id