Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.2_5.0.3.sql =================================================================== diff -u -r34770 -r34844 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.2_5.0.3.sql (.../5.0.2_5.0.3.sql) (revision 34770) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.2_5.0.3.sql (.../5.0.2_5.0.3.sql) (revision 34844) @@ -1 +1,2 @@ +update TousseItem set packageStatus = '待二次回收' where recyclingApplication_ID in (select ip.id from ForeignTousseApplication fta join invoicePlan ip on ip.id = fta.id where ip.recyclingStatus = '待回收' and fta.packageStatus = '已使用') and packageStatus is null; update TousseItem set packageStatus = (select packageStatus from ForeignTousseApplication where id = TousseItem.recyclingApplication_ID) where recyclingApplication_ID in (select id from ForeignTousseApplication) and packageStatus is null; \ No newline at end of file