Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.63_4.9.64.sql =================================================================== diff -u -r30280 -r31401 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.63_4.9.64.sql (.../4.9.63_4.9.64.sql) (revision 30280) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.63_4.9.64.sql (.../4.9.63_4.9.64.sql) (revision 31401) @@ -1 +1,3 @@ -update ForeignTousseApplication set packageStatus = '已使用' where packageStatus = '已接收' and (select count(ti.id) from TousseInstance ti where ti.invoicePlanID = ForeignTousseApplication.id and ti.useRecord_id is not null) > 0; \ No newline at end of file +update ForeignTousseApplication set packageStatus = '已使用' where packageStatus = '已接收' and (select count(ti.id) from TousseInstance ti where ti.invoicePlanID = ForeignTousseApplication.id and ti.useRecord_id is not null) > 0; +update ForeignTousseApplication set packageStatus = '待归还' where packageStatus = '已回收'; +update InvoicePlan set recyclingStatus = '二次回收' where recyclingStatus = '已回收' and type = '外来器械包申请单'; \ No newline at end of file