fix: 发货库存状态与冻结绑定

gongchunyi

6 小时以前 05e8f3f0f41731f2da0161a36d9dd7e2346983bb

fix: 发货库存状态与冻结绑定

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

@@ -8,12 +8,13 @@
        SELECT
        T1.*,
        CASE
        WHEN (IFNULL(t2.qualitity, 0) - IFNULL(t2.locked_quantity, 0)) >= IFNULL(T1.quantity, 0) THEN 1
        WHEN (IFNULL(t2.qualitity, 0) - IFNULL(t2.locked_quantity, 0) + IFNULL(t3.frozen_quantity, 0)) >= IFNULL(T1.quantity, 0) THEN 1
        ELSE 0
        END as has_sufficient_stock
        FROM
        sales_ledger_product T1
        LEFT JOIN stock_inventory t2 ON T1.product_model_id = t2.product_model_id
        LEFT JOIN sales_ledger_product_frozen t3 ON T1.id = t3.sales_ledger_product_id
        <where>
            <if test="salesLedgerProduct.salesLedgerId != null">
                AND T1.sales_ledger_id = #{salesLedgerProduct.salesLedgerId}