修改mes下发工程lowe内外面字段

廖井涛

2025-09-16 de898d48257e54f476359518d6419ddc5e2f36a8

修改mes下发工程lowe内外面字段

 north-glass-erp/src/main/resources/mapper/pp/GlassOptimize.xml

@@ -1790,7 +1790,9 @@
            opd.process_id as flowCardId,
            od.order_id as orderNumber,
            opd.order_sort as productSortNumber,
            IF(LOCATE('中空', ogd.process ) > 0, JSON_UNQUOTE(JSON_EXTRACT(pd.separation, "$.lowE")), 0) as hollowCombineDirection,
            IF(LOCATE('中空', ogd.process ) > 0 and LOCATE('#', pd.separation ),
               REPLACE(JSON_UNQUOTE(JSON_EXTRACT(pd.separation, "$.lowE")),'#',''),
               0) as hollowCombineDirection,
            opd.o_width as width,
            opd.o_height as height,
            op.glass_thickness as thickness,