From 06856202544f4324e27896e8a7b2fcf1298f5c68 Mon Sep 17 00:00:00 2001
From: dhz <duhuizhe>
Date: 星期三, 22 六月 2022 16:43:50 +0800
Subject: [PATCH] 工单统计
---
src/cn/ksource/web/facade/tj/SatisfactionStatisFacadeImpl.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/cn/ksource/web/facade/tj/SatisfactionStatisFacadeImpl.java b/src/cn/ksource/web/facade/tj/SatisfactionStatisFacadeImpl.java
index e318652..901b895 100644
--- a/src/cn/ksource/web/facade/tj/SatisfactionStatisFacadeImpl.java
+++ b/src/cn/ksource/web/facade/tj/SatisfactionStatisFacadeImpl.java
@@ -54,7 +54,7 @@
//鏌ヨ姣忎釜鏃ユ湡涓嬪搴旂殑鍚勪笁绾ф弧鎰忓害璋冩煡椤圭殑婊℃剰搴︽暟閲�
sql.setLength(0);
//涓夌骇婊℃剰搴﹁皟鏌ラ」涓庢椂闂村杩炴帴
- sql.append(" select t.$COLUMN,GROUP_CONCAT(IFNULL(i.num,'-') order by ordernum1,ordernum2,ordernum3) total_num from ( ");
+ sql.append(" select t.$COLUMN,WM_CONCAT(IFNULL(i.num, '-')) total_num from ( ");
sql.append(" select t2.$COLUMN,t1.resultid,ordernum1,ordernum2,ordernum3 from ");
sql.append(" ( ");
sql.append(" select v3.id resultid,v1.ORDERNUM ordernum1,v2.ORDERNUM ordernum2,v3.ordernum ordernum3 from ");
@@ -100,7 +100,7 @@
}
sql.append(" group by i.$COLUMN,d.RESULTID ");
sql.append(" ) i on t.resultid = i.RESULTID and t.$COLUMN = i.$COLUMN ");
- sql.append(" group by $COLUMN ");
+ sql.append(" group by t.$COLUMN ");
Map resMap = new HashMap();
String finalSql = sql.toString();
@@ -464,13 +464,13 @@
//鏌ヨ鏁版嵁
StringBuilder builder = new StringBuilder();
builder.append(" select d.SATIS_TYPE,d.REQUEST_FG_RATE,d.SATIS_QZ,d.REQUEST_SATIS_SCORE,sum(d.ALL_COUNT) total_num,SUM(d.SATIS_COUNT) do_num,sum(d.ALL_COUNT-SATIS_COUNT) undo_num, ");
- builder.append(" truncate(avg(d.FG_RATE),2) cover_rate,truncate(avg(d.SATIS_SCORE),2) score ");
+ builder.append(" round(avg(d.FG_RATE),2) cover_rate,round(avg(d.SATIS_SCORE),2) score ");
builder.append(" from TOTLE_SATIS_INFO i ,TOTLE_SATIS_DETAIL d ");
builder.append(" where i.ID = d.BUS_ID and i.MONTH >= DATE_FORMAT(:beginDay,'%Y%m') and i.MONTH<=DATE_FORMAT(:endDay,'%Y%m') ");
if(StringUtil.notEmpty(cusId)){
builder.append(" and i.CUSTOMER_ID = :cusId ");
}
- builder.append(" group by d.SATIS_TYPE order by d.SATIS_TYPE ");
+ builder.append(" group by d.SATIS_TYPE,d.REQUEST_FG_RATE,d.SATIS_QZ,d.REQUEST_SATIS_SCORE order by d.SATIS_TYPE ");
List<Map> baseList = baseDao.queryForList(builder.toString(),paramMap);
//缁勭粐琛ㄥご
lebalList.add("璋冩煡绫诲瀷");
--
Gitblit v1.9.1