Index: ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportBarChartView.jasper =================================================================== diff -u -r17024 -r18602 Binary files differ Index: ssts-web/src/main/webapp/disinfectsystem/reportforms/qualityMonitoringMonthView.js =================================================================== diff -u -r18189 -r18602 --- ssts-web/src/main/webapp/disinfectsystem/reportforms/qualityMonitoringMonthView.js (.../qualityMonitoringMonthView.js) (revision 18189) +++ ssts-web/src/main/webapp/disinfectsystem/reportforms/qualityMonitoringMonthView.js (.../qualityMonitoringMonthView.js) (revision 18602) @@ -300,7 +300,7 @@ displayField : 'value', store : new top.Ext.data.SimpleStore({ fields : [ 'value' ], - data : [[moduleNameArr[0]],[moduleNameArr[1]],[moduleNameArr[2]],[moduleNameArr[3]],[moduleNameArr[4]],[moduleNameArr[5]]] + data : [[moduleNameArr[0]],[moduleNameArr[1]],[moduleNameArr[2]],[moduleNameArr[3]],[moduleNameArr[4]],[moduleNameArr[5]],['全部环节']] } ), triggerAction : 'all', Index: ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportBarChartView.jrxml =================================================================== diff -u -r17024 -r18602 --- ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportBarChartView.jrxml (.../QualityMonitoringInspectMonthReportBarChartView.jrxml) (revision 17024) +++ ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportBarChartView.jrxml (.../QualityMonitoringInspectMonthReportBarChartView.jrxml) (revision 18602) @@ -1,7 +1,7 @@ - + - + @@ -19,7 +19,7 @@ - + @@ -32,7 +32,28 @@ - + + + + + + + + + + + + + + + + + + + + + + @@ -41,7 +62,7 @@ - + @@ -51,6 +72,9 @@ + + + Index: ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportLineChartView.jasper =================================================================== diff -u -r16176 -r18602 Binary files differ Index: ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportLineChartView.jrxml =================================================================== diff -u -r16176 -r18602 --- ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportLineChartView.jrxml (.../QualityMonitoringInspectMonthReportLineChartView.jrxml) (revision 16176) +++ ssts-web/src/main/webapp/jasperRtp/QualityMonitoringInspectMonthReportLineChartView.jrxml (.../QualityMonitoringInspectMonthReportLineChartView.jrxml) (revision 18602) @@ -47,7 +47,26 @@ - + + + + + + + + + + + + + + + + + + + + @@ -62,7 +81,7 @@ - + @@ -71,6 +90,9 @@ + + + Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r18595 -r18602 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18595) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18602) @@ -13239,11 +13239,15 @@ if(StringUtils.isNotBlank(queryYear) && StringUtils.isNotBlank(type) && StringUtils.isNotBlank(responsibilityType)){ String startYear = queryYear + "-01-01 00:00:00"; String nextYear = getNextYear(queryYear) + " 00:00:00"; + String responsSql = ""; + if(!"全部环节".equals(responsibilityType)){ + responsSql = " and qmd.responsibilityPart='" + responsibilityType + "' "; + } sql = " select " + dateQueryAdapter.dateConverAdapter3("qmi.dateTime","mm") + " ,fd.formName,sum(qmg.amount) " + " from QualityMonitoringInstance qmi,FormInstance fi,FormDefinition fd,QualityMonitoringDefinition qmd ,QualityMonitoringGoods qmg " + " where qmi.id = fi.id and fi.formDefinition_id=fd.id and fd.id=qmd.id " + " and qmi.id=qmg.qualityMonitoringInstance_id " - + " and qmd.responsibilityPart='" + responsibilityType + "' " + + responsSql + " and fd.formType='" + type + "' " + " and qmi.dateTime between " + dateQueryAdapter.dateAdapter(startYear) + " and "+dateQueryAdapter.dateAdapter(nextYear) @@ -13259,11 +13263,15 @@ if(StringUtils.isNotBlank(queryYear) && StringUtils.isNotBlank(type) && StringUtils.isNotBlank(responsibilityType)){ String startTime = queryYear + "-" + queryMonth + "-01 00:00:00"; String endTime = getNextMonth(queryYear,queryMonth) + " 00:00:00"; + String responsSql = ""; + if(!"全部环节".equals(responsibilityType)){ + responsSql = " and qmd.responsibilityPart='" + responsibilityType + "' "; + } sql = " select " + dateQueryAdapter.dateConverAdapter3("qmi.dateTime","day") + " ,fd.formName,sum(qmg.amount) " + "from QualityMonitoringInstance qmi,FormInstance fi,FormDefinition fd,QualityMonitoringDefinition qmd ,QualityMonitoringGoods qmg " + " where qmi.id = fi.id and fi.formDefinition_id=fd.id and fd.id=qmd.id " + " and qmi.id=qmg.qualityMonitoringInstance_id " - + " and qmd.responsibilityPart='" + responsibilityType + "' " + + responsSql + " and fd.formType='" + type + "' " + " and qmi.dateTime between " + dateQueryAdapter.dateAdapter(startTime) + " and "+dateQueryAdapter.dateAdapter(endTime) @@ -13500,6 +13508,10 @@ private List getResultMameList(String monitoringType,String inspectItem,String inspectDetail,String responseType){ List nameList = new ArrayList(); if(StringUtils.isNotBlank(responseType)){ + if("全部环节".equals(responseType)){ + responseType = null; + } + // 责任环节为空时,会获取到全部环节 List qmdList = qualityMonitoringDefinitionManager.loadFormDefinitionGroupByTupeAndResponsibilityPart(monitoringType,responseType); if(CollectionUtils.isNotEmpty(qmdList)){ for(QualityMonitoringDefinition qmd : qmdList){