parent: a5f2db96 | 补丁 | 提交 | ignore whitespace
guoyujie
2025-08-08 9cf6783836fcee8afd5519b7bde82e10eadec4df 
Merge branch 'master' of http://10.153.19.25:10101/r/ERP_override
1个文件已修改
4 ■■■■■ 已修改文件
north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 north-glass-erp/src/main/resources/mapper/pp/FolwCard.xml


@@ -1680,7 +1680,7 @@




    <select id="getDetailListRefund">


        select fc.order_number,


               concat(round(ogd.child_width), "*", round(ogd.child_height))   as child_width,


               concat(IF(ROUND(ogd.child_width, 1) = FLOOR(ogd.child_width), FLOOR(ogd.child_width), ROUND(ogd.child_width, 1)), "*", IF(ROUND(child_height, 1) = FLOOR(child_height), FLOOR(child_height), ROUND(child_height, 1)))   as child_width,


               sum(pl.patch_num)                                                 as quantity,


               round(ogd.total_area, 2)                                       as total_area,


               od.perimeter,


@@ -1772,7 +1772,7 @@




    <select id="getDetailListLikeRefund">


        select fc.order_number,


               concat(round(ogd.child_width), "*", round(ogd.child_height))   as child_width,


               concat(IF(ROUND(ogd.child_width, 1) = FLOOR(ogd.child_width), FLOOR(ogd.child_width), ROUND(ogd.child_width, 1)), "*", IF(ROUND(child_height, 1) = FLOOR(child_height), FLOOR(child_height), ROUND(child_height, 1)))   as child_width,


               pl.patch_num                                                   as quantity,


               round(ogd.total_area, 2)                                       as total_area,


               od.perimeter,