| | |
|---|
| | | (rt.standard_time * pl.production_quantity) as process_total_time, |
|---|
| | | rt.process_plan_start_day, |
|---|
| | | rt.process_plan_end_day, |
|---|
| | | pl.plan_end_day as order_plan_end_day |
|---|
| | | pl.plan_end_day, |
|---|
| | | COALESCE(rd.plan_end_day,pl.plan_end_day) as order_plan_end_day |
|---|
| | | from aps_plate_plan as pl |
|---|
| | | left join aps_process_route as rt on pl.document_number = rt.work_order_no |
|---|
| | | where pl.document_number is not null and rt.work_order_no is not null and pl.plan_end_day is not null |
|---|
| | | left join aps_plate_standard_require_order_end_day as rd on pl.document_number = rd.doc_no |
|---|
| | | where pl.document_number is not null and rt.work_order_no is not null and |
|---|
| | | (pl.plan_end_day is not null or rd.plan_end_day is not null ) |
|---|
| | | and rd.del_flag =0 |
|---|
| | | order by rt.work_order_no asc, rt.process_number desc |
|---|
| | | </select> |
|---|
| | | <update id="removeOtherStat" parameterType="String"> |
|---|
