Index: ssts-web/src/main/webapp/jasperRtp/workload.jasper =================================================================== diff -u -r17011 -r18190 Binary files differ Index: ssts-web/src/main/webapp/disinfectsystem/config/dgszyy/config.js =================================================================== diff -u -r17512 -r18190 --- ssts-web/src/main/webapp/disinfectsystem/config/dgszyy/config.js (.../config.js) (revision 17512) +++ ssts-web/src/main/webapp/disinfectsystem/config/dgszyy/config.js (.../config.js) (revision 18190) @@ -123,6 +123,9 @@ //自定义装配后清理配包人 cleanOperatorAfterDirectPacking : true, //当有丢失、报损时允许不补充材料即可装配 - allowPackingWhenUnSupplementMaterial : true + allowPackingWhenUnSupplementMaterial : true, + //是否是加强版的“消毒供应中心工作量统计报表”(即:增加了评分功能),为true时是加强版的,没配或者为false则不是 + strengthenStatisticalWorkload : true + } \ No newline at end of file Index: ssts-web/src/main/webapp/homepage/menuconfigure.js =================================================================== diff -u -r18094 -r18190 --- ssts-web/src/main/webapp/homepage/menuconfigure.js (.../menuconfigure.js) (revision 18094) +++ ssts-web/src/main/webapp/homepage/menuconfigure.js (.../menuconfigure.js) (revision 18190) @@ -459,7 +459,7 @@ hidden:SSTS_WorkLoad_Menu, children:[ {hidden :SSTS_YearWorkload,text:"年度消毒中心指标工作量统计",href:WWWROOT+'/disinfectsystem/reportforms/yearWorkloadReportView2.jsp',hrefTarget:linkTarget,leaf:true}, - {hidden :SSTS_StatisticalWorkload,text:"消毒中心员工工作统计评分报表",href:WWWROOT+'/disinfectsystem/reportforms/statisticalWorkloadView.jsp',hrefTarget:linkTarget,leaf:true}, + {hidden :SSTS_StatisticalWorkload,text:(sstsConfig.strengthenStatisticalWorkload ? "消毒供应中心工作人员绩效评分表" : "消毒供应中心工作量统计报表"),href:WWWROOT+'/disinfectsystem/reportforms/statisticalWorkloadView.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_USERECORD_TOTAL,text:"使用记录录入统计报表",href:WWWROOT+'/disinfectsystem/reportforms/useRecordTotalView.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_USERECORD_Item,text:"使用记录录入明细报表",href:WWWROOT+'/disinfectsystem/reportforms/useRecordItemView.jsp',hrefTarget:linkTarget,leaf:true}, {hidden :SSTS_USERECORD_OperatorTotal,text:"使用记录人员汇总报表",href:WWWROOT+'/disinfectsystem/reportforms/useRecordOperatorTotalView.jsp',hrefTarget:linkTarget,leaf:true}, Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r18189 -r18190 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18189) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18190) @@ -200,7 +200,7 @@ import com.forgon.disinfectsystem.jasperreports.javabeansource.WashWorkload_main; import com.forgon.disinfectsystem.jasperreports.javabeansource.WorkQualityCollection; import com.forgon.disinfectsystem.jasperreports.javabeansource.YearReportChartBean; -import com.forgon.disinfectsystem.jasperreports.javabeansource.YearWorkLoad; +import com.forgon.disinfectsystem.jasperreports.javabeansource.StatisticalWorkload; import com.forgon.disinfectsystem.jasperreports.javabeansource.YearWorkLoadReportBean; import com.forgon.disinfectsystem.jasperreports.javabeansource.YearWorkloadBean; import com.forgon.disinfectsystem.jasperreports.javabeansource.returnGoodsSummary; @@ -7905,281 +7905,278 @@ * @return */ @Override - public List getWorkLoad(String startTime, String endTime, - String querySupplyRoom) { - - List list = new ArrayList(); + public List getStatisticalWorkloadData(String startTime, String endTime, + String querySupplyRoom, boolean isStrengthen) { + List list = new ArrayList(); if (StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime) && StringUtils.isNotBlank(querySupplyRoom)) { String startDateTime = startTime + " 00:00:00"; String endDateTime = endTime + " 23:59:59"; - calculateWorkLoadByUser(startDateTime, endDateTime, list, querySupplyRoom); - } - return list; - - } + + + Map sequenceMap = new HashMap(); + sequenceMap.put("回收数量", 1); + sequenceMap.put("清点数量", 2); + sequenceMap.put("清洗数量", 3); + sequenceMap.put("配包数量", 4); + sequenceMap.put("审核数量", 5); + sequenceMap.put("灭菌数量", 6); + sequenceMap.put("发货数量", 7); + sequenceMap.put("检查数量", 8); + sequenceMap.put("包装数量", 9); + sequenceMap.put("核对数量", 10); - /** - * 计算消毒供应中心每个员工的工作量(私有方法仅供本类调用) - * @param startDateTime 统计的开始时间 - * @param endDateTime 统计的结束时间 - * @param list 计算的结果集合 - * @param supplyRoom 被统计消毒供应中心的科室编码(包括一级或者二级供应中心) - */ - private void calculateWorkLoadByUser(String startDateTime, String endDateTime, - List list, String supplyRoom) { - - Map sequenceMap = new HashMap(); - sequenceMap.put("回收数量", 1); - sequenceMap.put("清点数量", 2); - sequenceMap.put("清洗数量", 3); - sequenceMap.put("配包数量", 4); - sequenceMap.put("审核数量", 5); - sequenceMap.put("灭菌数量", 6); - sequenceMap.put("发货数量", 7); - sequenceMap.put("核对数量", 10); - sequenceMap.put("检查数量", 8); - sequenceMap.put("包装数量", 9); + //查询的时间段 + String betweenSql = String.format(" between %s and %s ", dateQueryAdapter.dateAdapter(startDateTime),dateQueryAdapter.dateAdapter(endDateTime)); + + //数据库计算字符串长度的函数名 + String sqlLengthFunctionName = DatabaseUtil.getSqlLengthFunctionName(dbConnection); + + //回收记录 + String tousseAmountSql = String.format("select '回收数量' type,rr.recyclingUser userName,sum(ti.amount) amount from RecyclingRecord rr,RecyclingItem ti " + + "where ti.recyclingRecord_id = rr.id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.recyclingUser) <> 0" + + "group by rr.recyclingUser ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + tousseAmountSql += " union all "; + //清点记录 + tousseAmountSql += String.format("select '清点数量' type,rr.operator userName,sum(ti.amount) amount from RecyclingRecord rr,RecyclingItem ti " + + "where ti.recyclingRecord_id = rr.id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.operator) <> 0 " + + "group by rr.operator ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + tousseAmountSql += " union all "; + + tousseAmountSql += "select '清洗数量' type,t1.userName userName,sum(t1.materialCount) amount from ("; + tousseAmountSql += String.format("select case when (min(cb.personInCharge) is null or min(cb.personInCharge) = '') then min(wr.operator) else min(cb.personInCharge) end userName,min(ci.tousseAmountForMaterial) materialCount " + + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci " + + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id and ci.itemType = '材料' " + + "and wr.orgUnitCoding = '%s' and wr.endDate %s and wr.washMaterialAmount <> 0 group by ci.tousseDefinitionID,ci.recyclingRecordId", querySupplyRoom,betweenSql); + tousseAmountSql += " union all "; + tousseAmountSql += String.format("select case when (cb.personInCharge is null or cb.personInCharge = '') then wr.operator else cb.personInCharge end userName,ci.amount materialCount " + + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci " + + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id " + + "and wr.orgUnitCoding = '%s' and ci.itemtype != '材料' and wr.endDate %s and wr.washMaterialAmount <> 0", querySupplyRoom,betweenSql); + tousseAmountSql += ") t1 group by t1.userName "; + + tousseAmountSql += " union all "; - //查询的时间段 - String betweenSql = String.format(" between %s and %s ", dateQueryAdapter.dateAdapter(startDateTime),dateQueryAdapter.dateAdapter(endDateTime)); - - String sqlLengthFunctionName = DatabaseUtil.getSqlLengthFunctionName(dbConnection);//数据库计算字符串长度的函数名 - - //回收记录 - String tousseAmountSql = String.format("select '回收数量' type,rr.recyclingUser userName,sum(ti.amount) amount from RecyclingRecord rr,RecyclingItem ti " - + "where ti.recyclingRecord_id = rr.id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.recyclingUser) <> 0" - + "group by rr.recyclingUser ", supplyRoom,betweenSql,sqlLengthFunctionName); - - tousseAmountSql += " union all "; - //清点记录 - tousseAmountSql += String.format("select '清点数量' type,rr.operator userName,sum(ti.amount) amount from RecyclingRecord rr,RecyclingItem ti " - + "where ti.recyclingRecord_id = rr.id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.operator) <> 0 " - + "group by rr.operator ", supplyRoom,betweenSql,sqlLengthFunctionName); - - tousseAmountSql += " union all "; - - tousseAmountSql += "select '清洗数量' type,t1.userName userName,sum(t1.materialCount) amount from ("; - tousseAmountSql += String.format("select case when (min(cb.personInCharge) is null or min(cb.personInCharge) = '') then min(wr.operator) else min(cb.personInCharge) end userName,min(ci.tousseAmountForMaterial) materialCount " - + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci " - + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id and ci.itemType = '材料' " - + "and wr.orgUnitCoding = '%s' and wr.endDate %s and wr.washMaterialAmount <> 0 group by ci.tousseDefinitionID,ci.recyclingRecordId", supplyRoom,betweenSql); - tousseAmountSql += " union all "; - tousseAmountSql += String.format("select case when (cb.personInCharge is null or cb.personInCharge = '') then wr.operator else cb.personInCharge end userName,ci.amount materialCount " - + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci " - + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id " - + "and wr.orgUnitCoding = '%s' and ci.itemtype != '材料' and wr.endDate %s and wr.washMaterialAmount <> 0", supplyRoom,betweenSql); - tousseAmountSql += ") t1 group by t1.userName "; - - tousseAmountSql += " union all "; - - //装配记录 - tousseAmountSql += String.format("select '配包数量' type,pr.packer userName,sum(pr.amount) amount from PackingRecord pr " - + "where pr.orgUnitCoding = '%s' and pr.packTime %s and pr.packer is not null and %s(pr.packer)<>0 " - + "group by pr.packer ", supplyRoom,betweenSql,sqlLengthFunctionName); - - tousseAmountSql += " union all "; - - //审核记录 - tousseAmountSql += String.format("select '审核数量' type,ti.reviewer userName,count(*) amount from tousseInstance ti " - + "where ti.orgUnitCoding = '%s' and ti.reviewTime %s and %s(ti.reviewer) <> 0 " - + "group by ti.reviewer ", supplyRoom,betweenSql,sqlLengthFunctionName); - - tousseAmountSql += " union all "; - - //灭菌记录 - tousseAmountSql += "select '灭菌数量' type,temp.userName userName,sum(temp.amount) amount from("; - tousseAmountSql += String.format("select sr.sterilizationUser userName,count(*) amount from SterilizationRecord sr,sterilization_tousseInstance st,TousseInstance ti " - + "where sr.id = st.sterilizationRecord_id and st.tousseInstance_id = ti.id " - + "and sr.orgUnitCoding='%s' and sr.endDate %s and %s(sr.sterilizationUser)<>0 group by sr.sterilizationUser ", - supplyRoom, betweenSql, sqlLengthFunctionName); + //装配记录 + tousseAmountSql += String.format("select '配包数量' type,pr.packer userName,sum(pr.amount) amount from PackingRecord pr " + + "where pr.orgUnitCoding = '%s' and pr.packTime %s and pr.packer is not null and %s(pr.packer)<>0 " + + "group by pr.packer ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + tousseAmountSql += " union all "; - tousseAmountSql += String.format("select sr.sterilizationUser userName,count(*) amount from SterilizationRecord sr,sterilization_reviewed sre,ReviewedBasket rb,TousseInstance ti " - + "where sr.id = sre.sterilizationRecord_id and sre.reviewedBasket_id = rb.id and rb.id = ti.reviewBasket_ID " - + "and sr.orgUnitCoding='%s' and sr.endDate %s and %s(sr.sterilizationUser)<>0 group by sr.sterilizationUser ", - supplyRoom, betweenSql, sqlLengthFunctionName); - tousseAmountSql += ") temp group by temp.userName"; - + + //审核记录 + tousseAmountSql += String.format("select '审核数量' type,ti.reviewer userName,count(*) amount from tousseInstance ti " + + "where ti.orgUnitCoding = '%s' and ti.reviewTime %s and %s(ti.reviewer) <> 0 " + + "group by ti.reviewer ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + tousseAmountSql += " union all "; + + //灭菌记录 + tousseAmountSql += "select '灭菌数量' type,temp.userName userName,sum(temp.amount) amount from("; + tousseAmountSql += String.format("select sr.sterilizationUser userName,count(*) amount from SterilizationRecord sr,sterilization_tousseInstance st,TousseInstance ti " + + "where sr.id = st.sterilizationRecord_id and st.tousseInstance_id = ti.id " + + "and sr.orgUnitCoding='%s' and sr.endDate %s and %s(sr.sterilizationUser)<>0 group by sr.sterilizationUser ", + querySupplyRoom, betweenSql, sqlLengthFunctionName); + tousseAmountSql += " union all "; + tousseAmountSql += String.format("select sr.sterilizationUser userName,count(*) amount from SterilizationRecord sr,sterilization_reviewed sre,ReviewedBasket rb,TousseInstance ti " + + "where sr.id = sre.sterilizationRecord_id and sre.reviewedBasket_id = rb.id and rb.id = ti.reviewBasket_ID " + + "and sr.orgUnitCoding='%s' and sr.endDate %s and %s(sr.sterilizationUser)<>0 group by sr.sterilizationUser ", + querySupplyRoom, betweenSql, sqlLengthFunctionName); + tousseAmountSql += ") temp group by temp.userName"; + + tousseAmountSql += " union all "; + + //发货记录 + tousseAmountSql += String.format("select '发货数量' type,i.sender userName,sum(ii.amount) amount from Invoice i,InvoiceItem ii " + + "where ii.invoice_id = i.id and i.orgUnitCoding = '%s' and i.sendTime %s and %s(i.sender)<>0 " + + "group by i.sender ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + tousseAmountSql += " union all "; + + //核对记录 + tousseAmountSql += String.format("select '核对数量' type,i.assistantSender userName,sum(ii.amount) amount from Invoice i, InvoiceItem ii " + + "where ii.invoice_id = i.id and i.orgUnitCoding= '%s' and i.sendTime %s and %s(i.assistantSender) <> 0 " + + "group by i.assistantSender ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + if(CssdUtils.isProject("zsly")){ //中山六院的项目(4.0的代码) + SupplyRoomConfig cfg = supplyRoomConfigManager.getFirstSupplyRoomConfig(); + String supplyRoom_zsly = "'"+cfg.getOrgUnitCoding()+"' "; tousseAmountSql += " union all "; - - //发货记录 - tousseAmountSql += String.format("select '发货数量' type,i.sender userName,sum(ii.amount) amount from Invoice i,InvoiceItem ii " - + "where ii.invoice_id = i.id and i.orgUnitCoding = '%s' and i.sendTime %s and %s(i.sender)<>0 " - + "group by i.sender ", supplyRoom,betweenSql,sqlLengthFunctionName); - tousseAmountSql += " union all "; - - //核对记录 - tousseAmountSql += String.format("select '核对数量' type,i.assistantSender userName,sum(ii.amount) amount from Invoice i, InvoiceItem ii " - + "where ii.invoice_id = i.id and i.orgUnitCoding= '%s' and i.sendTime %s and %s(i.assistantSender) <> 0 " - + "group by i.assistantSender ", supplyRoom,betweenSql,sqlLengthFunctionName); - - if(CssdUtils.isProject("zsly")){ //中山六院的项目(4.0的代码) - SupplyRoomConfig cfg = supplyRoomConfigManager.getFirstSupplyRoomConfig(); - String supplyRoom_zsly = "'"+cfg.getOrgUnitCoding()+"' "; - tousseAmountSql += " union all "; - //检查数量 - tousseAmountSql += String.format("select '检查数量' type,p.inspector userName,sum(pr.amount) amount from PackingRecord pr " - + "where pr.orgUnitCoding= '%s' and pr.packTime %s and %s(pr.inspector)<>0 " - + "group by pr.inspector ", supplyRoom_zsly,supplyRoom_zsly,sqlLengthFunctionName); - //包装数量 - tousseAmountSql += " union all "; - tousseAmountSql += String.format("select '包装数量' type,pr.wrapper userName,sum(pr.amount) amount from PackingRecord pr " - + "where pr.orgUnitCoding = '%s' and pr.packTime %s and %s(pr.wrapper)<>0 " - + "group by pr.wrapper ", supplyRoom_zsly,betweenSql,sqlLengthFunctionName); - } - - ResultSet rs = objectDao.executeSql(tousseAmountSql); - if (rs != null) { - try { - while (rs.next()) { - String type = rs.getString("type"); - String userName = rs.getString("userName"); - int amount = rs.getInt("amount"); - YearWorkLoad workLoadBean = new YearWorkLoad(); - workLoadBean.setOperator(userName); - workLoadBean.setAmount(amount); - workLoadBean.setColumnName(type); - workLoadBean.setSequence(sequenceMap.get(type)); - list.add(workLoadBean); + //检查数量 + tousseAmountSql += String.format("select '检查数量' type,p.inspector userName,sum(pr.amount) amount from PackingRecord pr " + + "where pr.orgUnitCoding= '%s' and pr.packTime %s and %s(pr.inspector)<>0 " + + "group by pr.inspector ", supplyRoom_zsly,supplyRoom_zsly,sqlLengthFunctionName); + //包装数量 + tousseAmountSql += " union all "; + tousseAmountSql += String.format("select '包装数量' type,pr.wrapper userName,sum(pr.amount) amount from PackingRecord pr " + + "where pr.orgUnitCoding = '%s' and pr.packTime %s and %s(pr.wrapper)<>0 " + + "group by pr.wrapper ", supplyRoom_zsly,betweenSql,sqlLengthFunctionName); + } + + ResultSet rs = objectDao.executeSql(tousseAmountSql); + if (rs != null) { + try { + while (rs.next()) { + String type = rs.getString("type"); + String userName = rs.getString("userName"); + int amount = rs.getInt("amount"); + StatisticalWorkload workLoadBean = new StatisticalWorkload(); + workLoadBean.setOperator(userName); + workLoadBean.setAmount(amount); + workLoadBean.setColumnName(type); + workLoadBean.setSequence(sequenceMap.get(type)); + list.add(workLoadBean); + } + } catch (SQLException e) { + e.printStackTrace(); + }finally { + DatabaseUtil.closeResultSetAndStatement(rs); } - } catch (SQLException e) { - e.printStackTrace(); - }finally { - DatabaseUtil.closeResultSetAndStatement(rs); } - } - - List scoreConfigs = objectDao.findBySql(WorkScoreConfig.class.getSimpleName(), "where po.orgUnitCoding = '" + supplyRoom + "'"); - Map scoreConfigMap = new HashMap(); - if(scoreConfigs != null){ - for (WorkScoreConfig workScoreConfig : scoreConfigs) { - scoreConfigMap.put(workScoreConfig.getName(), workScoreConfig.getValue()); + + Map scoreConfigMap = new HashMap(); + if (isStrengthen) { + List scoreConfigs = objectDao.findBySql(WorkScoreConfig.class.getSimpleName(), "where po.orgUnitCoding = '" + querySupplyRoom + "'"); + scoreConfigMap = new HashMap(); + if(scoreConfigs != null){ + for (WorkScoreConfig workScoreConfig : scoreConfigs) { + scoreConfigMap.put(workScoreConfig.getName(), workScoreConfig.getValue()); + } + } } - } - - //回收记录 - String materialAmountSql = String.format("select '回收数量' type,rr.recyclingUser userName,sum(ti.amount * ms.count) amount from RecyclingRecord rr,RecyclingItem ti,tousseDefinition td,materialInstance ms " - + "where ti.recyclingRecord_id = rr.id and ti.tousseDefinitionId = td.id and td.id = ms.tousse_id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.recyclingUser) <> 0" - + "group by rr.recyclingUser ", supplyRoom,betweenSql,sqlLengthFunctionName); - - materialAmountSql += " union all "; - //清点记录 - materialAmountSql += String.format("select '清点数量' type,rr.operator userName,sum(ti.amount * ms.count) amount from RecyclingRecord rr,RecyclingItem ti,tousseDefinition td,materialInstance ms " - + "where ti.recyclingRecord_id = rr.id and ti.tousseDefinitionId = td.id and td.id = ms.tousse_id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.operator) <> 0 " - + "group by rr.operator ", supplyRoom,betweenSql,sqlLengthFunctionName); - - materialAmountSql += " union all "; - - //清洗记录 - materialAmountSql += "select '清洗数量' type,t1.userName userName,sum(t1.materialCount) amount from ("; - materialAmountSql += String.format("select case when (cb.personInCharge is null or cb.personInCharge = '') then wr.operator else cb.personInCharge end userName,ci.amount materialCount " - + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci " - + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id and ci.itemType = '材料' " - + "and wr.orgUnitCoding = '%s' and wr.endDate %s and wr.washMaterialAmount <> 0", supplyRoom,betweenSql); - materialAmountSql += " union all "; - materialAmountSql += String.format("select case when (cb.personInCharge is null or cb.personInCharge = '') then wr.operator else cb.personInCharge end userName,(ci.amount*mi.count) materialCount " - + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci,TousseDefinition td,MaterialInstance mi " - + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id and td.id = ci.toussedefinition_id and mi.tousse_id = td.id " - + "and ci.itemType <> '材料' and wr.orgUnitCoding = '%s' and wr.endDate %s and wr.washMaterialAmount <> 0", supplyRoom,betweenSql); - materialAmountSql += " union all "; - materialAmountSql += String.format("select wr.operator userName,wrm.amount materialCount " - + "from WashAndDisinfectRecord wr, WashRecord_WashMaterial wm,WashAndDisinfectRecordMaterial wrm " - + "where wm.WashAndDisinfectRecord_ID = wr.id and wrm.id = wm.WashAndDisinfectMaterial_ID " - + "and wr.orgUnitCoding = '%s' and wr.endDate %s", supplyRoom , betweenSql); - materialAmountSql += ") t1 group by t1.userName "; - - materialAmountSql += "union all "; + + + //回收记录 + String materialAmountSql = String.format("select '回收数量' type,rr.recyclingUser userName,sum(ti.amount * ms.count) amount from RecyclingRecord rr,RecyclingItem ti,tousseDefinition td,materialInstance ms " + + "where ti.recyclingRecord_id = rr.id and ti.tousseDefinitionId = td.id and td.id = ms.tousse_id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.recyclingUser) <> 0" + + "group by rr.recyclingUser ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + materialAmountSql += " union all "; + //清点记录 + materialAmountSql += String.format("select '清点数量' type,rr.operator userName,sum(ti.amount * ms.count) amount from RecyclingRecord rr,RecyclingItem ti,tousseDefinition td,materialInstance ms " + + "where ti.recyclingRecord_id = rr.id and ti.tousseDefinitionId = td.id and td.id = ms.tousse_id and rr.orgUnitCoding = '%s' and rr.recyclingTime %s and %s(rr.operator) <> 0 " + + "group by rr.operator ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + materialAmountSql += " union all "; + + //清洗记录 + materialAmountSql += "select '清洗数量' type,t1.userName userName,sum(t1.materialCount) amount from ("; + materialAmountSql += String.format("select case when (cb.personInCharge is null or cb.personInCharge = '') then wr.operator else cb.personInCharge end userName,ci.amount materialCount " + + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci " + + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id and ci.itemType = '材料' " + + "and wr.orgUnitCoding = '%s' and wr.endDate %s and wr.washMaterialAmount <> 0", querySupplyRoom,betweenSql); + materialAmountSql += " union all "; + materialAmountSql += String.format("select case when (cb.personInCharge is null or cb.personInCharge = '') then wr.operator else cb.personInCharge end userName,(ci.amount*mi.count) materialCount " + + "from WashAndDisinfectRecord wr,ClassifyBasket_WashRecord cw,ClassifyBasket cb,ClassifiedItem ci,TousseDefinition td,MaterialInstance mi " + + "where cw.WashAndDisinfectRecord_ID = wr.id and cb.id = cw.ClassifyBasket_ID and ci.classifybasket_id = cb.id and td.id = ci.toussedefinition_id and mi.tousse_id = td.id " + + "and ci.itemType <> '材料' and wr.orgUnitCoding = '%s' and wr.endDate %s and wr.washMaterialAmount <> 0", querySupplyRoom,betweenSql); + materialAmountSql += " union all "; + materialAmountSql += String.format("select wr.operator userName,wrm.amount materialCount " + + "from WashAndDisinfectRecord wr, WashRecord_WashMaterial wm,WashAndDisinfectRecordMaterial wrm " + + "where wm.WashAndDisinfectRecord_ID = wr.id and wrm.id = wm.WashAndDisinfectMaterial_ID " + + "and wr.orgUnitCoding = '%s' and wr.endDate %s", querySupplyRoom , betweenSql); + materialAmountSql += ") t1 group by t1.userName "; + + materialAmountSql += "union all "; - //装配记录 - materialAmountSql += String.format("select '配包数量' type,pr.packer userName,sum(pr.amount * ms.count) amount from PackingRecord pr,tousseDefinition td,materialInstance ms " - + "where pr.tousseDefinitionId = td.id and td.id = ms.tousse_id and pr.orgUnitCoding = '%s' and pr.packTime %s and pr.packer is not null and %s(pr.packer)<>0 " - + "group by pr.packer ", supplyRoom,betweenSql,sqlLengthFunctionName); - - materialAmountSql += "union all "; - - //审核记录 - materialAmountSql += String.format("select '审核数量' type,ti.reviewer userName,sum(ms.count) amount from tousseInstance ti,tousseDefinition td,materialInstance ms " - + "where ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and ti.orgUnitCoding = '%s' and ti.reviewTime %s and ti.reviewer is not null and %s(ti.reviewer) <> 0 " - + "group by ti.reviewer ", supplyRoom,betweenSql,sqlLengthFunctionName); - + //装配记录 + materialAmountSql += String.format("select '配包数量' type,pr.packer userName,sum(pr.amount * ms.count) amount from PackingRecord pr,tousseDefinition td,materialInstance ms " + + "where pr.tousseDefinitionId = td.id and td.id = ms.tousse_id and pr.orgUnitCoding = '%s' and pr.packTime %s and pr.packer is not null and %s(pr.packer)<>0 " + + "group by pr.packer ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + materialAmountSql += "union all "; + + //审核记录 + materialAmountSql += String.format("select '审核数量' type,ti.reviewer userName,sum(ms.count) amount from tousseInstance ti,tousseDefinition td,materialInstance ms " + + "where ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and ti.orgUnitCoding = '%s' and ti.reviewTime %s and ti.reviewer is not null and %s(ti.reviewer) <> 0 " + + "group by ti.reviewer ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + materialAmountSql += " union all "; + + materialAmountSql += "select '灭菌数量' type,tmp.userName,sum(tmp.amount) from ("; + materialAmountSql += String.format("select sr.sterilizationUser userName,sum(ms.count) amount from SterilizationRecord sr,sterilization_tousseInstance st,TousseInstance ti,tousseDefinition td,materialInstance ms " + +" where sr.id = st.sterilizationRecord_id and st.tousseInstance_id = ti.id and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and sr.orgUnitCoding = '%s' and sr.endDate %s " + + "and %s(sr.sterilizationUser) <> 0 group by sr.sterilizationUser ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + materialAmountSql += " union all "; + materialAmountSql += String.format("select sr.sterilizationUser userName,sum(ms.count) amount from SterilizationRecord sr,sterilization_reviewed sre,ReviewedBasket rb,TousseInstance ti,tousseDefinition td,materialInstance ms " + +" where sr.id = sre.sterilizationRecord_id and sre.reviewedBasket_id = rb.id and rb.id = ti.reviewBasket_ID and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and sr.orgUnitCoding = '%s' " + + "and sr.endDate %s and %s(sr.sterilizationUser) <> 0 group by sr.sterilizationUser ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + + materialAmountSql += ")tmp group by tmp.userName"; + materialAmountSql += " union all "; + + materialAmountSql += "select '发货数量' type,tmp.userName,sum(tmp.amount) from ("; + materialAmountSql += String.format("select i.sender userName,sum(ms.count) amount from Invoice i,tousseInstance ti,tousseDefinition td,materialInstance ms " + + "where ti.invoice_id = i.id and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and i.orgUnitCoding = '%s' and i.sendTime %s and %s(i.sender) <> 0 " + + "group by i.sender ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + materialAmountSql += " union all "; + materialAmountSql += String.format("select i.sender userName,sum(ii.amount) amount from Invoice i,invoiceItem ii " + + "where ii.invoice_id = i.id and i.orgUnitCoding = '%s' and ii.tousseType = '一次性物品' and i.sendTime %s and %s(i.sender) <> 0 " + + "group by i.sender ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + materialAmountSql += ")tmp group by tmp.userName"; + materialAmountSql += " union all "; + + materialAmountSql += "select '核对数量' type,tmp.userName,sum(tmp.amount) from ("; + materialAmountSql += String.format("select i.assistantSender userName,sum(ms.count) amount from Invoice i,tousseInstance ti,tousseDefinition td,materialInstance ms " + + "where ti.invoice_id = i.id and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and i.orgUnitCoding = '%s' and i.sendTime %s and %s(i.assistantSender) <> 0 " + + "group by i.assistantSender ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + materialAmountSql += " union all "; + materialAmountSql += String.format("select i.assistantSender userName,sum(ii.amount) amount from Invoice i,invoiceItem ii " + + "where ii.invoice_id = i.id and i.orgUnitCoding = '%s' and ii.tousseType = '一次性物品' and i.sendTime %s and %s(i.assistantSender) <> 0 " + + "group by i.assistantSender ", querySupplyRoom,betweenSql,sqlLengthFunctionName); + materialAmountSql += ")tmp group by tmp.userName"; + + if(CssdUtils.isProject("zsly")){ //中山六院的项目(4.0的代码) + SupplyRoomConfig cfg = supplyRoomConfigManager.getFirstSupplyRoomConfig(); + String supplyRoom_zsly = "'"+cfg.getOrgUnitCoding()+"' "; materialAmountSql += " union all "; - - materialAmountSql += "select '灭菌数量' type,tmp.userName,sum(tmp.amount) from ("; - materialAmountSql += String.format("select sr.sterilizationUser userName,sum(ms.count) amount from SterilizationRecord sr,sterilization_tousseInstance st,TousseInstance ti,tousseDefinition td,materialInstance ms " - +" where sr.id = st.sterilizationRecord_id and st.tousseInstance_id = ti.id and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and sr.orgUnitCoding = '%s' and sr.endDate %s " - + "and %s(sr.sterilizationUser) <> 0 group by sr.sterilizationUser ", supplyRoom,betweenSql,sqlLengthFunctionName); - materialAmountSql += " union all "; - materialAmountSql += String.format("select sr.sterilizationUser userName,sum(ms.count) amount from SterilizationRecord sr,sterilization_reviewed sre,ReviewedBasket rb,TousseInstance ti,tousseDefinition td,materialInstance ms " - +" where sr.id = sre.sterilizationRecord_id and sre.reviewedBasket_id = rb.id and rb.id = ti.reviewBasket_ID and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and sr.orgUnitCoding = '%s' " - + "and sr.endDate %s and %s(sr.sterilizationUser) <> 0 group by sr.sterilizationUser ", supplyRoom,betweenSql,sqlLengthFunctionName); - - materialAmountSql += ")tmp group by tmp.userName"; - materialAmountSql += " union all "; - - materialAmountSql += "select '发货数量' type,tmp.userName,sum(tmp.amount) from ("; - materialAmountSql += String.format("select i.sender userName,sum(ms.count) amount from Invoice i,tousseInstance ti,tousseDefinition td,materialInstance ms " - + "where ti.invoice_id = i.id and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and i.orgUnitCoding = '%s' and i.sendTime %s and %s(i.sender) <> 0 " - + "group by i.sender ", supplyRoom,betweenSql,sqlLengthFunctionName); - materialAmountSql += " union all "; - materialAmountSql += String.format("select i.sender userName,sum(ii.amount) amount from Invoice i,invoiceItem ii " - + "where ii.invoice_id = i.id and i.orgUnitCoding = '%s' and ii.tousseType = '一次性物品' and i.sendTime %s and %s(i.sender) <> 0 " - + "group by i.sender ", supplyRoom,betweenSql,sqlLengthFunctionName); - materialAmountSql += ")tmp group by tmp.userName"; - materialAmountSql += " union all "; - - materialAmountSql += "select '核对数量' type,tmp.userName,sum(tmp.amount) from ("; - materialAmountSql += String.format("select i.assistantSender userName,sum(ms.count) amount from Invoice i,tousseInstance ti,tousseDefinition td,materialInstance ms " - + "where ti.invoice_id = i.id and ti.tousseDefinition_id = td.id and td.id = ms.tousse_id and i.orgUnitCoding = '%s' and i.sendTime %s and %s(i.assistantSender) <> 0 " - + "group by i.assistantSender ", supplyRoom,betweenSql,sqlLengthFunctionName); - materialAmountSql += " union all "; - materialAmountSql += String.format("select i.assistantSender userName,sum(ii.amount) amount from Invoice i,invoiceItem ii " - + "where ii.invoice_id = i.id and i.orgUnitCoding = '%s' and ii.tousseType = '一次性物品' and i.sendTime %s and %s(i.assistantSender) <> 0 " - + "group by i.assistantSender ", supplyRoom,betweenSql,sqlLengthFunctionName); - materialAmountSql += ")tmp group by tmp.userName"; - - if(CssdUtils.isProject("zsly")){ //中山六院的项目(4.0的代码) - SupplyRoomConfig cfg = supplyRoomConfigManager.getFirstSupplyRoomConfig(); - String supplyRoom_zsly = "'"+cfg.getOrgUnitCoding()+"' "; - materialAmountSql += " union all "; - //检查数量 - materialAmountSql += String.format("select '检查数量' type,p.inspector userName,sum(pr.amount * ms.count) amount from PackingRecord pr,tousseDefinition td,materialInstance ms " - + "where pr.tousseDefinitionId = td.id and td.id = ms.tousse_id and pr.orgUnitCoding= '%s' and pr.packTime %s and pr.inspector is not null and %s(pr.inspector)<>0 " - + "group by pr.inspector ", supplyRoom_zsly,supplyRoom_zsly,sqlLengthFunctionName); - //包装数量 - materialAmountSql += "union all "; - materialAmountSql += String.format("select '包装数量' type,pr.wrapper userName,sum(pr.amount * ms.count) amount from PackingRecord pr,tousseDefinition td,materialInstance ms " - + "where pr.tousseDefinitionId = td.id and td.id = ms.tousse_id and pr.orgUnitCoding = '%s' and pr.packTime %s and pr.wrapper is not null and %s(pr.wrapper)<>0 " - + "group by pr.wrapper ", supplyRoom_zsly,betweenSql,sqlLengthFunctionName); - } - - ResultSet rs2 = objectDao.executeSql(materialAmountSql); - if (rs2 != null) { - try { - while (rs2.next()) { - String type = rs2.getString("type"); - String userName = rs2.getString("userName"); - int amount = rs2.getInt("amount"); - YearWorkLoad workLoadBean = new YearWorkLoad(); - workLoadBean.setOperator(userName); - workLoadBean.setMaterialAmount(amount); - workLoadBean.setColumnName(type); - workLoadBean.setSequence(sequenceMap.get(type)); - Integer scoreConfig = scoreConfigMap.get(type); - if(scoreConfig != null && scoreConfig > 0){ - //评分数小数点后面舍去(3 / 2 = 1分) - workLoadBean.setScore(amount/scoreConfig); + //检查数量 + materialAmountSql += String.format("select '检查数量' type,p.inspector userName,sum(pr.amount * ms.count) amount from PackingRecord pr,tousseDefinition td,materialInstance ms " + + "where pr.tousseDefinitionId = td.id and td.id = ms.tousse_id and pr.orgUnitCoding= '%s' and pr.packTime %s and pr.inspector is not null and %s(pr.inspector)<>0 " + + "group by pr.inspector ", supplyRoom_zsly,supplyRoom_zsly,sqlLengthFunctionName); + //包装数量 + materialAmountSql += "union all "; + materialAmountSql += String.format("select '包装数量' type,pr.wrapper userName,sum(pr.amount * ms.count) amount from PackingRecord pr,tousseDefinition td,materialInstance ms " + + "where pr.tousseDefinitionId = td.id and td.id = ms.tousse_id and pr.orgUnitCoding = '%s' and pr.packTime %s and pr.wrapper is not null and %s(pr.wrapper)<>0 " + + "group by pr.wrapper ", supplyRoom_zsly,betweenSql,sqlLengthFunctionName); + } + + ResultSet rs2 = objectDao.executeSql(materialAmountSql); + if (rs2 != null) { + try { + while (rs2.next()) { + String type = rs2.getString("type"); + String userName = rs2.getString("userName"); + int amount = rs2.getInt("amount"); + StatisticalWorkload workLoadBean = new StatisticalWorkload(); + workLoadBean.setOperator(userName); + workLoadBean.setMaterialAmount(amount); + workLoadBean.setColumnName(type); + workLoadBean.setSequence(sequenceMap.get(type)); + if (scoreConfigMap.size() > 0) { + Integer scoreConfig = scoreConfigMap.get(type); + if(scoreConfig != null && scoreConfig > 0){ + //评分数小数点后面舍去(3 / 2 = 1分) + workLoadBean.setScore(amount/scoreConfig); + } + } + list.add(workLoadBean); } - list.add(workLoadBean); + } catch (SQLException e) { + e.printStackTrace(); + }finally { + DatabaseUtil.closeResultSetAndStatement(rs2); } - } catch (SQLException e) { - e.printStackTrace(); - }finally { - DatabaseUtil.closeResultSetAndStatement(rs2); } + + + } + return list; } - + /** * 器械包运作统计报表 */ Index: ssts-web/src/main/webapp/disinfectsystem/reportforms/statisticalWorkloadView.jsp =================================================================== diff -u -r17011 -r18190 --- ssts-web/src/main/webapp/disinfectsystem/reportforms/statisticalWorkloadView.jsp (.../statisticalWorkloadView.jsp) (revision 17011) +++ ssts-web/src/main/webapp/disinfectsystem/reportforms/statisticalWorkloadView.jsp (.../statisticalWorkloadView.jsp) (revision 18190) @@ -1,60 +1,25 @@ -<%@ page contentType="text/html; charset=UTF-8"%> -<%@ include file="/common/taglibs.jsp"%> +<%@page contentType="text/html; charset=UTF-8"%> +<%@include file="/common/taglibs.jsp"%> +<%@include file="/common/includeExtJsAndCss.jsp"%> - -<%@ include file="/common/includeExtJsAndCss.jsp"%> + + + + + - - - - + - - - - - - - - - -消毒中心员工工作统计评分报表 + +消毒供应中心工作量统计报表 - + @@ -63,11 +28,5 @@
- - -
- - -
\ No newline at end of file Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java =================================================================== diff -u -r18179 -r18190 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java (.../JasperreportsAction.java) (revision 18179) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java (.../JasperreportsAction.java) (revision 18190) @@ -37,6 +37,7 @@ import net.sf.json.JSONObject; import org.apache.commons.lang.StringUtils; +import org.apache.commons.lang3.BooleanUtils; import org.apache.struts2.convention.annotation.Action; import org.apache.struts2.convention.annotation.Namespace; import org.apache.struts2.convention.annotation.ParentPackage; @@ -573,11 +574,16 @@ }else{ return jasperReportManager.getYearWorkloadReport(year,departCoding); } - } else if (reportName.equals("workload")) { + } else if (reportName.equals("statisticalWorkload")) { String startTime = StrutsParamUtils.getPraramValue("startTime", ""); String endTime = StrutsParamUtils.getPraramValue("endTime", ""); String departCoding = StrutsParamUtils.getPraramValue("departCoding", ""); - return jasperReportManager.getWorkLoad(startTime, endTime,departCoding); + String isStrengthen = StrutsParamUtils.getPraramValue("isStrengthen", ""); + + if (StringTools.isNotBlank(startTime) + && StringTools.isNotBlank(endTime)) { + return jasperReportManager.getStatisticalWorkloadData(startTime, endTime, departCoding, BooleanUtils.toBoolean(isStrengthen)); + } } else if (reportName.equals("tousseOperate")) { String startDate = StrutsParamUtils.getPraramValue("startDate", ""); String endDate = StrutsParamUtils.getPraramValue("endDate", ""); @@ -1311,12 +1317,17 @@ year = new SimpleDateFormat("yyyy").format(new Date()); } map.put("title", year + "年度消毒供应中心员工工作量统计报表"); - } else if (reportName.equals("workload")) { + } else if (reportName.equals("statisticalWorkload")) { String startTime = StrutsParamUtils.getPraramValue("startTime", ""); String endTime = StrutsParamUtils.getPraramValue("endTime", ""); - map.put("title", "消毒供应中心工作量统计报表"); - map.put("date1", startTime); - map.put("date2", endTime); + String isStrengthen = StrutsParamUtils.getPraramValue("isStrengthen", ""); + String title = ""; + if (BooleanUtils.toBoolean(isStrengthen)) { + title += String.format("消毒供应中心工作人员绩效评分表(%s~%s)", startTime, endTime); + } else { + title += String.format("消毒供应中心工作量统计报表(%s~%s)", startTime, endTime); + } + map.put("title", title); } else if (reportName.equals("useRecordTotalView")) {// 使用记录录入统计报表 String startDay = StrutsParamUtils.getPraramValue("startDay", ""); String endDay = StrutsParamUtils.getPraramValue("endDay", ""); Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/javabeansource/YearWorkLoad.java =================================================================== diff -u -r17011 -r18190 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/javabeansource/YearWorkLoad.java (.../YearWorkLoad.java) (revision 17011) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/javabeansource/YearWorkLoad.java (.../StatisticalWorkload.java) (revision 18190) @@ -4,7 +4,7 @@ * @author 工作量统计报表 * */ -public class YearWorkLoad { +public class StatisticalWorkload { public Integer sequence; @@ -77,5 +77,5 @@ public void setScore(Integer score) { this.score = score; } - + } Fisheye: Tag 18190 refers to a dead (removed) revision in file `ssts-web/src/main/webapp/jasperRtp/workload.jrxml'. Fisheye: No comparison available. Pass `N' to diff? Index: ssts-web/src/main/webapp/disinfectsystem/reportforms/statisticalWorkloadView.js =================================================================== diff -u -r17582 -r18190 --- ssts-web/src/main/webapp/disinfectsystem/reportforms/statisticalWorkloadView.js (.../statisticalWorkloadView.js) (revision 17582) +++ ssts-web/src/main/webapp/disinfectsystem/reportforms/statisticalWorkloadView.js (.../statisticalWorkloadView.js) (revision 18190) @@ -1,4 +1,5 @@ -var entityName = "消毒中心员工工作统计评分报表"; +var isStrengthen = sstsConfig.strengthenStatisticalWorkload; +var entityName = isStrengthen ? "消毒供应中心工作人员绩效评分表" : "消毒供应中心工作量统计报表"; var form; /** @@ -7,7 +8,6 @@ */ var myMask; function reloadReport(){ - if (!form.getForm().isValid()) { showResult('请正确填写表单各值'); return false; @@ -16,19 +16,21 @@ var startTime= $Id('startTime').value; var endTime = $Id('endTime').value; var departCoding = Ext.getCmp('querySupplyRoom').getValue(); + var jasperreportName = isStrengthen ? 'strengthenStatisticalWorkload.jasper' : 'statisticalWorkload.jasper'; myMask = new Ext.LoadMask(Ext.getBody(), { msg: '正在加载,请稍候!', removeMask: true }); myMask.show(); window.open(WWWROOT + "/jasperreports/jasperreportsAction!createReportFromJavaBeanSource.do?" + - "jasperreportName=workload.jasper&reportName=workload" + + "jasperreportName=" + jasperreportName + + "&reportName=statisticalWorkload" + + "&isStrengthen=" + isStrengthen + "&departCoding=" + departCoding + "&startTime=" + startTime + "&endTime=" + endTime, 'thisIframe', '_self'); - } @@ -197,6 +199,7 @@ },{ xtype : 'button', text : '设置评分标准', + hidden : !isStrengthen, minWidth : 70, iconCls : 'icon_set', handler : function() { Index: ssts-web/src/main/webapp/jasperRtp/workload.jasper =================================================================== diff -u -r17011 -r18190 Binary files differ Index: ssts-web/src/main/webapp/jasperRtp/statisticalWorkload.jasper =================================================================== diff -u Binary files differ Index: ssts-web/src/main/resources/systemset/operationDefine.xml =================================================================== diff -u -r18094 -r18190 --- ssts-web/src/main/resources/systemset/operationDefine.xml (.../operationDefine.xml) (revision 18094) +++ ssts-web/src/main/resources/systemset/operationDefine.xml (.../operationDefine.xml) (revision 18190) @@ -284,7 +284,7 @@ - + Index: ssts-web/src/main/webapp/jasperRtp/workload.jrxml =================================================================== diff -u -r17011 -r18190 --- ssts-web/src/main/webapp/jasperRtp/workload.jrxml (.../workload.jrxml) (revision 17011) +++ ssts-web/src/main/webapp/jasperRtp/workload.jrxml (.../strengthenStatisticalWorkload.jrxml) (revision 18190) @@ -1,6 +1,6 @@ - - + +