Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java =================================================================== diff -u -r33808 -r33810 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java (.../DataIndex.java) (revision 33808) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java (.../DataIndex.java) (revision 33810) @@ -2567,6 +2567,17 @@ public Map getSterilizationAmount(ReportQueryParams reportParams, String departmentCode, String date, String queryScope, String startTime, String endTime, List firstDayToLastDay) { Map map = new HashMap(); if (true || StringTools.isNotBlank(departmentCode) && StringTools.isNotBlank(date)) { + if (SupplyRoomQualityQuota.DAY.endsWith(queryScope)) { + String format = null; + if(dbConnection.isOracle()){ + format = "yyyy-MM-dd"; + }else{ + format = "dd"; + } + reportParams.monthlyStr = dateQueryAdapter.dateConverAdapter(dateQueryAdapter.stringFieldToDate("ti.sterileEndTime"),format); + } else { + reportParams.monthlyStr = dateQueryAdapter.dateConverAdapter3(dateQueryAdapter.stringFieldToDate("ti.sterileEndTime"),"mm"); + } String sql = "select monthstr,sum(tl.amount) amount from (" + getWorkAmountByPackageSQL("灭菌数量", reportParams)