Merge branch 'master' of http://10.153.19.25:10105/r/ERP_override
| | |
| | | |
| | | productAbbreviation:'اختصار المنتج', |
| | | productDuplication:'تكرار المنتج', |
| | | default:'默认' |
| | | } |
| | | }, |
| | | order:{ |
| | |
| | | archRise:'拱高', |
| | | qr1Local:'二维码1位置', |
| | | qr2Local:'二维码2位置', |
| | | default:'默认' |
| | | |
| | | |
| | | }, |
| | | |
| | |
| | | |
| | | productAbbreviation:'Product abbreviation', |
| | | productDuplication:'Product repetition', |
| | | default:'默认' |
| | | } |
| | | }, |
| | | order:{ |
| | |
| | | archRise:'拱高', |
| | | qr1Local:'二维码1位置', |
| | | qr2Local:'二维码2位置', |
| | | default:'默认' |
| | | |
| | | }, |
| | | |
| | |
| | | |
| | | productAbbreviation:'제품명 축약', |
| | | productDuplication:'제품 중복', |
| | | default:'默认' |
| | | } |
| | | }, |
| | | order:{ |
| | |
| | | xMargin:'X축 여백', |
| | | yMargin:'Y축 여백', |
| | | location:'상표 위치', |
| | | sort:'유리 굽힘 방지' |
| | | |
| | | sort:'유리 굽힘 방지', |
| | | archRise:'拱高', |
| | | qr1Local:'二维码1位置', |
| | | qr2Local:'二维码2位置', |
| | | default:'默认' |
| | | }, |
| | | |
| | | workOrder:{ |
| | |
| | | archRise:'拱高', |
| | | qr1Local:'二维码1位置', |
| | | qr2Local:'二维码2位置', |
| | | default:'默认' |
| | | |
| | | }, |
| | | |
| | |
| | | |
| | | productAbbreviation:'产品简称', |
| | | productDuplication:'产品重复', |
| | | default:'默认' |
| | | } |
| | | }, |
| | | order:{ |
| | |
| | | archRise:'拱高', |
| | | qr1Local:'二维码1位置', |
| | | qr2Local:'二维码2位置', |
| | | default:'默认' |
| | | |
| | | }, |
| | | |
| | |
| | | FROM pp.damage_details as a |
| | | 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 |
| | | WHERE a.process_id = #{processId} |
| | | <if test="needOrderNumber!=null"> |
| | | and a.order_number = #{orderNumber} |
| | | </if> |
| | | and a.technology_number =#{technologyNumber} |
| | | and a.breakage_quantity>0 |
| | | and a.patch_status=0 |
| | | and b.reviewed_state>=0 |
| | | and b.this_process in (WITH RECURSIVE cte AS ( |
| | | SELECT 1 AS n |
| | |
| | | SELECT REGEXP_SUBSTR(#{behindProcess}, '[^,]+', 1, n) AS process |
| | | FROM cte |
| | | WHERE REGEXP_SUBSTR(#{behindProcess}, '[^,]+', 1, n) IS NOT NULL) |
| | | and c.review_status = 0 |
| | | |
| | | </select> |
| | | <select id="getNotReview"> |
| | | select a.* |
| | | select a.*,ifnull(c.review_status,0) as reviewed_state |
| | | from damage_details as a |
| | | left join 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 |
| | | and a.technology_number = c.technology_number |
| | | where a.process_id=#{processId} |
| | | and b.reviewed_state>=0 |
| | | <if test="orderNumber!= null"> |
| | | <if test="orderNumber!= null || orderNumber!=''"> |
| | | and a.order_number = #{orderNumber} |
| | | </if> |
| | | and a.technology_number = #{technologyNumber} |
| | | and a.patch_status=0 |
| | | and a.breakage_quantity>0 |
| | | and c.review_status = 0 |
| | | |
| | | </select> |
| | | </mapper> |