Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java =================================================================== diff -u -r13892 -r13939 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 13892) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 13939) @@ -786,9 +786,9 @@ //如果物品类型不为空时 if (StringUtils.isNotBlank(tousseType)) { if(TousseItem.DIPOSABLE_YES.equals(tousseType)){ - where8 = String.format("id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and amount - sendOutAmount > 0 and tousseType = '%s')",TousseItem.TYPE_DIPOSABLE_GOODS); + where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and amount - sendOutAmount > 0 and tousseType = '%s')",TousseItem.TYPE_DIPOSABLE_GOODS); }else if(TousseItem.DIPOSABLE_NO.equals(tousseType)){ - where8 = String.format("id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and amount - sendOutAmount > 0 and tousseType != '%s')",TousseItem.TYPE_DIPOSABLE_GOODS); + where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and amount - sendOutAmount > 0 and tousseType != '%s')",TousseItem.TYPE_DIPOSABLE_GOODS); } }