From 0edc442f5eab9cd4686cab6190739677f73897b5 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期三, 11 五月 2022 17:04:41 +0800
Subject: [PATCH] 优化代码

---
 service-report/src/main/java/com/java110/report/bmo/customReport/InspectionStaffData.java |   31 ++++++++++---------------------
 1 files changed, 10 insertions(+), 21 deletions(-)

diff --git a/service-report/src/main/java/com/java110/report/bmo/customReport/InspectionStaffData.java b/service-report/src/main/java/com/java110/report/bmo/customReport/InspectionStaffData.java
index 196448b..47c6e69 100644
--- a/service-report/src/main/java/com/java110/report/bmo/customReport/InspectionStaffData.java
+++ b/service-report/src/main/java/com/java110/report/bmo/customReport/InspectionStaffData.java
@@ -27,13 +27,9 @@
 
     }
 
-    public JSONObject execute(String paramStr, IQueryServiceDAO queryServiceDAOImpl) {
-
-        JSONObject params = JSONObject.parseObject(paramStr);
-
+    public String execute(String paramStr, IQueryServiceDAO queryServiceDAOImpl) {
         JSONObject paramOut = new JSONObject();
-        JSONArray th = new JSONArray();
-        th.add("鍛樺伐");
+        JSONObject params = JSONObject.parseObject(paramStr);
 
         List sqlParams = new ArrayList();
         String sql = "select \n" +
@@ -98,15 +94,15 @@
         List datas = queryServiceDAOImpl.executeSql(sql, sqlParams.toArray());
 
         if (datas == null || datas.size() < 1) {
-            paramOut.put("td", new JSONArray());
-
-            return paramOut;
+            paramOut.put("toatl",1);
+            paramOut.put("data",new JSONArray());
+            return paramOut.toJSONString();
         }
 
         JSONArray tds = new JSONArray();
         JSONObject td = null;
-        for (int dataIndex = 0 ; dataIndex < datas.size() ; dataIndex ++ ){
-            Map dataObj = (Map)datas.get(dataIndex);
+        for (int dataIndex = 0; dataIndex < datas.size(); dataIndex++) {
+            Map dataObj = (Map) datas.get(dataIndex);
             td = hasInTd(tds, dataObj);
 
             if (td == null) {
@@ -119,17 +115,10 @@
             td.put("鐘舵��", dataObj.get("鐘舵��"));
         }
 
-        for (String key : tds.getJSONObject(0).keySet()) {
-            if ("鍛樺伐".equals(key)) {
-                continue;
-            }
-            th.add(key);
-        }
+        paramOut.put("total",params.get("row"));
+        paramOut.put("data",tds);
 
-
-        paramOut.put("th", th);
-        paramOut.put("td", tds);
-        return paramOut;
+        return paramOut.toJSONString();
     }
 
 

--
Gitblit v1.8.0