| | |
|---|
| | | </delete> |
|---|
| | | |
|---|
| | | <select id="queryTempStat" resultMap="ApsPlateProcessStatResult"> |
|---|
| | | select |
|---|
| | | row_number() over (partition by rt.work_order_no order by rt.process_number desc ) as num, |
|---|
| | | select row_number() over (partition by rt.work_order_no order by rt.process_number desc ) as num, |
|---|
| | | rt.work_order_no, |
|---|
| | | rt.process_name, |
|---|
| | | cast(rt.process_number as numeric(18, 2)) as route_process_number, |
|---|
| | |
|---|
| | | 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_status in (0,1,2,4) |
|---|
| | | order by rt.work_order_no asc , rt.process_number desc |
|---|
| | | </select> |
|---|
| | | <update id="removeOtherStat" parameterType="String"> |
|---|
