maven
昨天 3faae0563d4bf5a2139c6d8aac3b1e2ec952adf9
yys  退货详情返回产品单位
已修改1个文件
1 ■■■■ 文件已修改
src/main/resources/mapper/procurementrecord/ReturnSaleProductMapper.xml 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/procurementrecord/ReturnSaleProductMapper.xml
@@ -13,6 +13,7 @@
    <select id="listReturnSaleProductDto" resultType="com.ruoyi.procurementrecord.dto.ReturnSaleProductDto">
        SELECT slp.product_category                                         as product_name,
               slp.specification_model                                      as model,
               slp.unit                                      as unit,
               rsp.*,
               GREATEST(slp.quantity - COALESCE(rs.total_return_num, 0), 0) AS un_quantity,
               COALESCE(rs.total_return_num, 0)                             AS total_return_num