Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r32951 -r32967 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 32951) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 32967) @@ -23885,7 +23885,7 @@ betweenSql, eventCode); int invoicePlanCount = objectDao.countBySql("select count(*) from InvoicePlan ip " - + "where ip.type='"+ InvoicePlan.TYPE_FOREIGNTOUSSEAPPLIACTION +"' and ip.recyclingStatus is not null and ip.applicationTime " + + "where ip.recyclingStatus is not null and ip.applicationTime " + betweenSql); rs = objectDao.executeSql(sql); while (rs.next()) {