Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/MaterialErrorDamageReportHelper.java =================================================================== diff -u -r35879 -r38988 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/MaterialErrorDamageReportHelper.java (.../MaterialErrorDamageReportHelper.java) (revision 35879) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/MaterialErrorDamageReportHelper.java (.../MaterialErrorDamageReportHelper.java) (revision 38988) @@ -424,7 +424,7 @@ .append(MaterialErrorDamageDetail.TYPE_DAMAGE) .append("'"); String sql = "select * from ( " - +" select medd.damageRemark,medd.type,medd.operator,medd.materialName,medd.toussename,medd.operationTime,medd.depart,medd.amount,medd.materialCost " + +" select medd.damageRemark,medd.type,medd.operator,medd.materialName,ri.toussename,medd.operationTime,medd.depart,medd.amount,medd.materialCost " +" ,ur.circuitNurse,ur.doctorName,case when ur.operationTime is null then ur.enteringDate else ur.operationTime end useTime " +" from MaterialErrorDamageDetail medd " +" join MaterialDefinition md on md.id=medd.materialDefinitionId " @@ -436,7 +436,7 @@ +" left join UseRecord ur on ur.id=ra.userecord_id " +" where ri.amount = 1 " +" union all " - +" select medd.damageRemark,medd.type,medd.operator,medd.materialName,medd.toussename,medd.operationTime,medd.depart,medd.amount,medd.materialCost, " + +" select medd.damageRemark,medd.type,medd.operator,medd.materialName,ri.toussename,medd.operationTime,medd.depart,medd.amount,medd.materialCost, " +" null,null,null " +" from MaterialErrorDamageDetail medd " +" join MaterialDefinition md on md.id=medd.materialDefinitionId " @@ -485,6 +485,7 @@ } MaterialDamageItemBean itemBean = new MaterialDamageItemBean(); + itemBean.setTousseName(item.getTousseName()); itemBean.setMaterialName(item.getMaterialName()); itemBean.setDamageAmount(item.getDamageAmount()); itemBean.setDamageReporter(item.getDamageReporter()); Index: ssts-web/src/main/webapp/jasperRtp/materialDamageItemView_subreport.jasper =================================================================== diff -u -r27617 -r38988 Binary files differ Index: ssts-web/src/main/webapp/jasperRtp/materialDamageItemView.jrxml =================================================================== diff -u -r34012 -r38988 --- ssts-web/src/main/webapp/jasperRtp/materialDamageItemView.jrxml (.../materialDamageItemView.jrxml) (revision 34012) +++ ssts-web/src/main/webapp/jasperRtp/materialDamageItemView.jrxml (.../materialDamageItemView.jrxml) (revision 38988) @@ -1,7 +1,7 @@ - + - +