Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.3.2_4.3.3.sql =================================================================== diff -u -r14750 -r14784 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.3.2_4.3.3.sql (.../4.3.2_4.3.3.sql) (revision 14750) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.3.2_4.3.3.sql (.../4.3.2_4.3.3.sql) (revision 14784) @@ -1,7 +1,7 @@ update MaterialEntry set totalprice = (select sum(cost*amount) from MaterialEntryItem where materialEntry_id=MaterialEntry.id) where totalPrice is null; update foreigntousseapplication set suppliername = (select min(i.suppliername) from invoiceplan p,tousseitem i where p.id = i.recyclingapplication_id and foreigntousseapplication.id = p.id); update ForeignProxyDisinfection set hasPrinted='是' where (select count(*) from TousseInstance po where po.foreignProxyItem_id in(select fi.id from ForeignProxyItem fi where fi.foreignProxyDisinfection_id=ForeignProxyDisinfection.id ))>0; -update ForeignProxyDisinfection set hasPrinted='否' where hasPrinted!='是'; -update ForeignProxyDisinfection set hasPacked='是' where (select count(*) from TousseInstance po where po.foreignProxyItem_id in(select fi.id from ForeignProxyItem fi where fi.foreignProxyDisinfection_id=ForeignProxyDisinfection.id ))>0 -update ForeignProxyDisinfection set hasPacked='否' where hasPacked!='是'; +update ForeignProxyDisinfection set hasPrinted='否' where hasPrinted is null or hasPrinted!='是'; +update ForeignProxyDisinfection set hasPacked='是' where (select count(*) from TousseInstance po where po.foreignProxyItem_id in(select fi.id from ForeignProxyItem fi where fi.foreignProxyDisinfection_id=ForeignProxyDisinfection.id ))>0; +update ForeignProxyDisinfection set hasPacked='否' where hasPacked is null or hasPacked!='是'; update ForeignProxyItem set tousseItemId=(select id from TousseItem where recyclingApplication_ID=ForeignProxyItem.foreignProxyDisinfection_id and tousseDefinitionId=ForeignProxyItem.tousseDefinitionId) where tousseItemId is null; \ No newline at end of file