销售退货详情中已退货数量、未退货数量展示有误

huminmin

2026-04-29 40d999aed00f135c27155071a62e1a8a1ae7b7ba

销售退货详情中已退货数量、未退货数量展示有误

 src/main/resources/mapper/procurementrecord/ReturnSaleProductMapper.xml

@@ -21,12 +21,12 @@
                 LEFT JOIN return_management rm ON rm.id = rsp.return_management_id
                 LEFT JOIN shipping_info si ON si.id = rm.shipping_id
                 LEFT JOIN sales_ledger_product slp ON si.sales_ledger_product_id = slp.id and slp.type = 1
                 LEFT JOIN (SELECT return_sale_ledger_product_id,

                                   SUM(num) AS total_return_num
                            FROM return_sale_product
                            WHERE 1 = 1 and return_management_id != #{returnManagementId}
                            GROUP BY return_sale_ledger_product_id) rs ON rs.return_sale_ledger_product_id = slp.id
                 LEFT JOIN (SELECT rsp.return_sale_ledger_product_id,
                                   SUM(rsp.num) AS total_return_num
                            FROM return_sale_product rsp
                            LEFT JOIN return_management rm2 ON rm2.id = rsp.return_management_id
                            WHERE rm2.status != 0
                            GROUP BY rsp.return_sale_ledger_product_id) rs ON rs.return_sale_ledger_product_id = slp.id
        where rm.id =#{returnManagementId}
    </select>
    <select id="listReturnSaleProduct" resultType="com.ruoyi.procurementrecord.dto.ReturnSaleProductDto">
@@ -36,4 +36,4 @@
        where rsp.return_management_id = #{returnManagementId}
    </select>

</mapper>
</mapper>