售后率计算

Cui Zhi Feng

2024-09-26 4483b4ef337172a8d1522b63e57c9fbd3b38b468

售后率计算

 src/main/resources/mapper/payment/OrderItemSalesMapper.xml

@@ -147,7 +147,7 @@
    </select>

    <select id="getSupplierSalesCount" resultType="java.lang.Integer">
        SELECT count(1)
        SELECT count(distinct si.order_id)
        FROM t_order_item_sales si
        join t_order_item oi on oi.id = si.order_item_id
        WHERE oi.deleted = 0
@@ -155,7 +155,7 @@
    </select>

    <select id="getPartnerSalesCount" resultType="java.lang.Integer">
        SELECT count(1)
        SELECT count(distinct si.order_id)
        FROM t_order_item_sales si
        join t_order o on si.order_id = o.id
        WHERE o.deleted = 0