Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r34397 -r34454 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34397) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34454) @@ -23963,7 +23963,7 @@ String tousseDefinitionIdCondition = DatabaseUtil.isPoIdValid(tousseDefinitionId) ? "and td.ancestorId=" + tousseDefinitionId : ""; //时间过滤 String dateCondition = "and " + dateQueryAdapter.dateAreaSql("trdr.operateDate", startDate, endDate, true); - String sql = "select trdr.orgUnitName,td.tousseType,trdi.tousseName,sum(trdi.amount) amount " + String sql = "select trdr.operateDate,trdr.orgUnitName,td.tousseType,trdi.tousseName,sum(trdi.amount) amount " + " from TousseReturnDisinfectRecord trdr join TousseReturnDisinfectItem trdi on trdr.id=trdi.tousseReturnDisinfectRecordId " + " join TousseDefinition td on td.id=trdi.tousseDefinitionId " + " where 1=1 " @@ -23992,6 +23992,7 @@ detailVo.setAmount(rs.getInt("amount")); detailVo.setTousseName(rs.getString("tousseName")); detailVo.setTousseType(rs.getString("tousseType")); + detailVo.setOperateDate(ForgonDateUtils.safelyFormatDate(rs.getTimestamp("operateDate"),ForgonDateUtils.SIMPLEDATEFORMAT_YYYYMMDDHHMM,"")); list.add(detailVo); departMap.put(orgUnitName, list); }