From 0f75140e1ef1bda48aafa5198d7c68a6bacaf2a1 Mon Sep 17 00:00:00 2001
From: 6c <420680616@qq.com>
Date: 星期五, 18 七月 2025 11:17:56 +0800
Subject: [PATCH] 2025年7月18日 11:17:13-适配国产数据库
---
src/main/java/com/product/server/report/service/GenerateEChartService.java | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/product/server/report/service/GenerateEChartService.java b/src/main/java/com/product/server/report/service/GenerateEChartService.java
index c78d530..9a675e6 100644
--- a/src/main/java/com/product/server/report/service/GenerateEChartService.java
+++ b/src/main/java/com/product/server/report/service/GenerateEChartService.java
@@ -105,6 +105,15 @@
// object.put("function",this.functionArray(uuid));
return object;
}
+ sql_text = "SELECT user_id,SUM(countNo) countNo, type \n" +
+ "FROM ( \t\n" +
+ "\tSELECT receiver user_id,COUNT(receiver) countNo,'寰呭姙' as type \n" +
+ "\tFROM product_oa_cooperate_flow_node \n" +
+ "\tWHERE status IN (0,1) \n" +
+ "\tGROUP BY receiver \t\n" +
+ ") a \n" +
+ "WHERE user_id=13563 \n" +
+ "GROUP BY user_id,type";
DataTableEntity valueData = baseDao.listTable(sql_text,new Object[]{});
//鑾峰彇鎶ヨ〃閰嶇疆灞炴�ц〃 鍔爀charts閰嶇疆灞炴��
//鍙兘鏌ヨ鍒板叧鑱斿睘鎬у�肩殑灞炴�ц〃锛屽鏋滅埗绾у睘鎬т笅鏈夊涓浉鍚屽瓙灞炴�с�傞�氳繃grouping鍒嗙粍銆�
@@ -535,7 +544,7 @@
if (fseParentModuleData == null) {
throw new BaseException(SystemCode.PUBLISH_REPORT_FAIL_MODULE_NO_EXIST.getValue(), SystemCode.PUBLISH_REPORT_FAIL_MODULE_NO_EXIST.getText());
}
-
+
FieldSetEntity fseReport=baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_REPORT_CONFIG, fse.getUUID(), false);
//鍒涘缓MVCC淇濆瓨瀵硅薄
--
Gitblit v1.9.2