提交订单首页查询条件

guoyujie

2025-09-08 febd32fb0a69a579184b2d341e498fa224f1da05

提交订单首页查询条件

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

@@ -9,7 +9,10 @@
    left join pp.reporting_work as b
    on a.reporting_work_id = b.reporting_work_id
    left join patch_log as c
    on a.reporting_work_id = c.reporting_work_id and a.process_id = c.process_id and a.order_number = c.order_sort
    on a.reporting_work_id = c.reporting_work_id
           and a.process_id = c.process_id
           and a.order_number = c.order_sort
           and a.technology_number = c.technology_number
    WHERE a.process_id = #{processId}
    <if test="needOrderNumber!=null">
    and a.order_number = #{orderNumber}
@@ -25,7 +28,7 @@
                           SELECT REGEXP_SUBSTR(#{behindProcess}, '[^,]+', 1, n) AS process
                           FROM cte
                           WHERE REGEXP_SUBSTR(#{behindProcess}, '[^,]+', 1, n) IS NOT NULL)
    and c.review_status = 0
    and ifnull(c.review_status,0) = 0

</select>
    <select id="getNotReview">