Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r33995 -r33996 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 33995) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 33996) @@ -21059,7 +21059,7 @@ + " left join TousseItem ti on ti.recyclingApplication_ID=rr.recyclingApplication_id and ti.tousseDefinitionId=ri.tousseDefinitionId " + " where ri.urgentAmount > 0 and (ti.isTerminated is null or ti.isTerminated<>1) " + " and td.tousseType='"+ TousseDefinition.PACKAGE_TYPE_SPLIT +"' " - + ") temp where 1=1 " + betweenSql + tousseNameSql + whereSqlForOrgUnitCoding + " order by temp.回收时间,temp.id" + + ") temp where 1=1 " + betweenSql + tousseNameSql + whereSqlForOrgUnitCoding + " order by temp.回收时间,temp.id,temp.物品名称 asc " ; logger.debug("急用物品处理周期统计报表查询:" + sql); ResultSet result = objectDao.executeSql(sql);