From 2b543ca35ad4697e31225829be13e375cd2b0259 Mon Sep 17 00:00:00 2001
From: zs <zhoushuai@zbooksoft.com>
Date: 星期三, 04 二月 2026 16:46:00 +0800
Subject: [PATCH] 成果资料退回后需要删除对应附件
---
src/main/java/com/zbooksoft/gdmis/controller/ScreenController.java | 32 +++++++++++---------------------
1 files changed, 11 insertions(+), 21 deletions(-)
diff --git a/src/main/java/com/zbooksoft/gdmis/controller/ScreenController.java b/src/main/java/com/zbooksoft/gdmis/controller/ScreenController.java
index f89f3bb..99f6f2c 100644
--- a/src/main/java/com/zbooksoft/gdmis/controller/ScreenController.java
+++ b/src/main/java/com/zbooksoft/gdmis/controller/ScreenController.java
@@ -10,6 +10,7 @@
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
@@ -32,6 +33,8 @@
DesktopLayoutService desktopLayoutService;
private static final Logger logger = LoggerFactory.getLogger(ScreenController.class);
+ @Autowired
+ private JdbcTemplate jdbcTemplate;
@RequestMapping
@@ -108,29 +111,16 @@
// 鑾峰彇鏉′欢鎼滅储鐨勬煴鐘跺浘鏁版嵁
@RequestMapping("/getSearchConditionEchartsHistogram")
@ResponseBody
- public Object getSearchConditionEchartsHistogram() {
+ public Object getSearchConditionEchartsHistogram(String columnName) {
+ String Sql="select "+columnName+",count("+columnName+") as num FROM cat_item_yswjxx where "+columnName+" is not null group by "+columnName;
+ List<Map<String,Object>> list=jdbcTemplate.queryForList(Sql);
List<String> xAxisData = new ArrayList<String>();
- xAxisData.add("娴锋磱鍖哄煙鍦拌川璋冩煡");
- xAxisData.add("娴峰哺甯﹀湴璐ㄧ熆浜ц皟鏌�");
- xAxisData.add("澶ч檰鏋跺湴璐ㄧ熆浜ц皟鏌�");
- xAxisData.add("鍥介檯娴峰簳鍦拌川鐭夸骇璋冩煡");
- xAxisData.add("鏋佸湴鍦拌川璋冩煡");
- xAxisData.add("鍏朵粬娴锋磱鍦拌川璋冩煡");
- xAxisData.add("姘村伐鐜湴璐ㄥ嫎鏌�");
- xAxisData.add("鍦拌川绉戝鐮旂┒");
- xAxisData.add("鎶�鏈柟娉曠爺绌�");
- List<JSONObject> seriesList = new ArrayList<JSONObject>();
List<Object> yList = new ArrayList<Object>();
- yList.add(10);
- yList.add(20);
- yList.add(80);
- yList.add(0);
- yList.add(30);
- yList.add(10);
- yList.add(40);
- yList.add(50);
- yList.add(60);
-
+ for (Map<String,Object> map:list){
+ xAxisData.add(map.get(columnName).toString());
+ yList.add(map.get("num"));
+ }
+ List<JSONObject> seriesList = new ArrayList<JSONObject>();
JSONObject job = new JSONObject();
job.put("name", "妗ｆ鏁伴噺");
job.put("type", "bar");
--
Gitblit v1.9.1