fix: 更新查询逻辑以支持产品型号的批号匹配，调整配置文件以更改文件路径和数据库设置

yuan

昨天 d404864e22a98cf1a81177041a264ed31aa56222

fix: 更新查询逻辑以支持产品型号的批号匹配，调整配置文件以更改文件路径和数据库设置

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

@@ -71,6 +71,7 @@
                                AND sir.record_id = slp.sales_ledger_id
                                AND (
                                    (sir.batch_no IS NOT NULL AND sir.batch_no LIKE CONCAT('%-', slp.id))
                                    OR (sir.batch_no IS NOT NULL AND sir.batch_no LIKE CONCAT('%-', slp.product_model_id, '-%'))
                                    OR (sir.batch_no IS NULL AND sir.product_model_id = slp.product_model_id)
                                )
                            WHERE sir.approval_status = 1

 src/main/resources/mapper/sales/SalesLedgerProductMapper.xml

@@ -80,6 +80,7 @@
                AND sir.record_id = slp.sales_ledger_id
                AND (
                    (sir.batch_no IS NOT NULL AND sir.batch_no LIKE CONCAT('%-', slp.id))
                    OR (sir.batch_no IS NOT NULL AND sir.batch_no LIKE CONCAT('%-', slp.product_model_id, '-%'))
                    OR (sir.batch_no IS NULL AND sir.product_model_id = slp.product_model_id)
                )
            WHERE sir.approval_status = 1