From 935b4b66b99b1f022f82cdaef8e3ef6599afbc72 Mon Sep 17 00:00:00 2001
From: dhz <duhuizhe>
Date: 星期三, 22 六月 2022 15:52:54 +0800
Subject: [PATCH] 工单统计
---
src/cn/ksource/web/facade/satis/SatisfactionFacadeImpl.java | 12 ++++++++----
1 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/src/cn/ksource/web/facade/satis/SatisfactionFacadeImpl.java b/src/cn/ksource/web/facade/satis/SatisfactionFacadeImpl.java
index b2cd592..903125d 100644
--- a/src/cn/ksource/web/facade/satis/SatisfactionFacadeImpl.java
+++ b/src/cn/ksource/web/facade/satis/SatisfactionFacadeImpl.java
@@ -831,7 +831,7 @@
paramMap.put("beginMonth", beginMonth);
paramMap.put("endMonth", endMonth);
- sql.append(" GROUP BY A.CUSTOMER_ID ");
+ sql.append(" GROUP BY A.CUSTOMER_ID ,C.CUSTOMER_NAME ");
List<Map> proList = baseDao.queryForList(sql.toString(),paramMap);
@@ -895,7 +895,11 @@
builder.append(" SELECT D.SATIS_TYPE,D.ALL_COUNT,D.SATIS_COUNT,D.FG_RATE,D.SATIS_SCORE ");
builder.append(" FROM TOTLE_SATIS_INFO I,TOTLE_SATIS_DETAIL D ");
- builder.append(" where I.ID = D.BUS_ID and I.MONTH = :month and I.CUSTOMER_ID = :cusId group by D.SATIS_TYPE ");
+ builder.append(" where I.ID = D.BUS_ID and I.MONTH = :month and I.CUSTOMER_ID = :cusId " +
+ " GROUP BY D.SATIS_TYPE ,D.ALL_COUNT,\n" +
+ " D.SATIS_COUNT,\n" +
+ " D.FG_RATE,\n" +
+ " D.SATIS_SCORE ");
List<Map> list = baseDao.queryForList(builder.toString(),params);
if(list!=null&&list.size()>0){
for(Map map:list){
@@ -932,7 +936,7 @@
String cusId = params.get("cusId");
StringBuilder builder = new StringBuilder();
builder.append(" SELECT I.ALL_SCORE,D.SATIS_SCORE,D.SATIS_TYPE,I.MONTH FROM TOTLE_SATIS_DETAIL D ,TOTLE_SATIS_INFO I ");
- builder.append(" WHERE D.BUS_ID = I.ID AND I.CUSTOMER_ID = :cusId GROUP BY D.SATIS_TYPE,I.MONTH ORDER BY SATIS_TYPE,MONTH");
+ builder.append(" WHERE D.BUS_ID = I.ID AND I.CUSTOMER_ID = :cusId GROUP BY D.SATIS_TYPE,I.MONTH,I.ALL_SCORE,D.SATIS_SCORE ORDER BY SATIS_TYPE,MONTH");
List<Map> queryList = baseDao.queryForList(builder.toString(), params);
builder.setLength(0);
Map<String,Object> queryMap = new HashMap<String,Object>();
@@ -1009,7 +1013,7 @@
String cusId = params.get("cusId");
StringBuilder builder = new StringBuilder();
builder.append(" SELECT D.FG_RATE,D.SATIS_TYPE,I.MONTH FROM TOTLE_SATIS_DETAIL D ,TOTLE_SATIS_INFO I ");
- builder.append(" WHERE D.BUS_ID = I.ID AND I.CUSTOMER_ID = :cusId GROUP BY D.SATIS_TYPE,I.MONTH ORDER BY SATIS_TYPE,MONTH");
+ builder.append(" WHERE D.BUS_ID = I.ID AND I.CUSTOMER_ID = :cusId GROUP BY D.SATIS_TYPE,I.MONTH,D.FG_RATE,D.SATIS_TYPE ORDER BY SATIS_TYPE,MONTH");
List<Map> queryList = baseDao.queryForList(builder.toString(), params);
builder.setLength(0);
Map<String,Object> queryMap = new HashMap<String,Object>();
--
Gitblit v1.9.1