Merge branch 'master' of http://bore.pub:10439/r/ERP_override
| | |
|---|
| | | from reporting_work as a |
|---|
| | | left join reporting_work_detail as b on a.reporting_work_id = b.reporting_work_id |
|---|
| | | where this_process=#{previousProcess} and reviewed_state=0 and process_id= #{processIdStr} |
|---|
| | | and POSITION(b.technology_number in #{technologyStr}) |
|---|
| | | |
|---|
| | | GROUP BY a.reporting_work_id,b.order_number,b.technology_number |
|---|
| | | ) as rws |
|---|
| | | on rws.process_id = fc.process_id and rws.order_number=fc.order_number and rws.technology_number=fc.technology_number |
|---|
