提交拉取

chenlu

2024-04-24 5c4c7dd0c4cd462bee347c7c807d51675049918a

提交拉取

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

@@ -310,7 +310,7 @@
    </select>
    <select id="selectGlassProcessNum" resultType="java.lang.Integer">
        select
              d.reporting_work_num-b.reporting_work_num-b.broken_num+ifnull(c.patchNumSum,0)
              d.reporting_work_num_count-b.reporting_work_num_count-b.broken_num+ifnull(c.patchNumSum,0)
        from flow_card as a
        left join sd.order_process_detail as b
        on
@@ -321,8 +321,8 @@
            and b.process_id = a.process_id
        left join sd.order_process_detail as d
            on d.id=b.id-1
        left join (select sum(patch_num) as patchNumSum,order_sort,technology_number,process_id
                   from patch_log
        left join (select sum(rework_num) as patchNumSum,order_sort,technology_number,process_id
                   from rework
                   group by reporting_work_id,order_sort,technology_number) as c
        on
            c.process_id = a.process_id

 north-glass-erp/target/classes/mapper/pp/ReportingWork.xml

@@ -310,7 +310,7 @@
    </select>
    <select id="selectGlassProcessNum" resultType="java.lang.Integer">
        select
              d.reporting_work_num-b.reporting_work_num-b.broken_num+ifnull(c.patchNumSum,0)
              d.reporting_work_num_count-b.reporting_work_num_count-b.broken_num+ifnull(c.patchNumSum,0)
        from flow_card as a
        left join sd.order_process_detail as b
        on
@@ -321,8 +321,8 @@
            and b.process_id = a.process_id
        left join sd.order_process_detail as d
            on d.id=b.id-1
        left join (select sum(patch_num) as patchNumSum,order_sort,technology_number,process_id
                   from patch_log
        left join (select sum(rework_num) as patchNumSum,order_sort,technology_number,process_id
                   from rework
                   group by reporting_work_id,order_sort,technology_number) as c
        on
            c.process_id = a.process_id