From e150655a785de36a65a26a0dc4d3d6d65fe7e9d0 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期四, 04 五月 2023 18:03:37 +0800
Subject: [PATCH] 11111
---
src/main/java/com/hxzkoa/controller/WarningController.java | 680 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 673 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/hxzkoa/controller/WarningController.java b/src/main/java/com/hxzkoa/controller/WarningController.java
index 3582cd3..cc3f742 100644
--- a/src/main/java/com/hxzkoa/controller/WarningController.java
+++ b/src/main/java/com/hxzkoa/controller/WarningController.java
@@ -1,5 +1,6 @@
package com.hxzkoa.controller;
+import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
@@ -15,10 +16,16 @@
import org.springframework.web.bind.annotation.ResponseBody;
import com.hxzkoa.json.tb_historyinwarning;
+import com.hxzkoa.json.tb_jobhistory;
+import com.hxzkoa.json.tb_lixianrecord;
+import com.hxzkoa.json.tb_message_history;
+import com.hxzkoa.json.tb_permission;
+import com.hxzkoa.json.tb_person;
import com.hxzkoa.json.tb_realinwarning;
import com.hxzkoa.json.tb_realkaoqing;
import com.hxzkoa.json.tb_tag;
import com.hxzkoa.json.tb_warning;
+import com.hxzkoa.services.LabelService;
import com.hxzkoa.services.WarningService;
import com.hxzkoa.udp.GetNowTime;
import com.hxzkoa.udp.Udp_Out;
@@ -36,6 +43,8 @@
public class WarningController {
@Autowired
private WarningService warningService;
+ @Autowired
+ private LabelService labelService;
@RequestMapping(value = "/warningSummary.do", method = { RequestMethod.POST, RequestMethod.GET })
public String warningSummary(HttpServletRequest request) {
@@ -51,6 +60,15 @@
}
@ResponseBody
+ @RequestMapping(value = "/warningSummarya.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject warningSummarya(HttpServletRequest request) {
+ JSONObject json = new JSONObject();
+ List<tb_warning> warningSummaryList = warningService.getWarningSummarya();
+ json.put("dataList", warningSummaryList);
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/warningSummary_search.do", method = { RequestMethod.POST, RequestMethod.GET })
public String warningSummary_search(HttpServletRequest request) throws IOException {
JSONObject json = new JSONObject();
@@ -78,6 +96,28 @@
}
@ResponseBody
+ @RequestMapping(value = "/warningSummary_searcha.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject warningSummary_searcha(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("tagid");
+ if (("").equals(input) || input == null) {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ List<tb_warning> warningSummaryList = warningService.searchWarningSummary(input);
+ if (warningSummaryList.size()>0){
+ json.put("result", warningSummaryList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ } else {
+ List<tb_warning> warningSummaryList = warningService.searchWarningSummary(input);
+ json.put("dataList", warningSummaryList);
+ }
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/warningSummary_page.do", method = { RequestMethod.POST, RequestMethod.GET })
public String warningSummary_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
@@ -161,6 +201,15 @@
}
@ResponseBody
+ @RequestMapping(value = "/realTimeWarninga.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject realTimeWarninga(HttpServletRequest request) {
+ JSONObject json = new JSONObject();
+ List<tb_realinwarning> realTimeWarningList = warningService.getRealinWarninga();
+ json.put("dataList", realTimeWarningList);
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/realTimeWarning_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
public void realTimeWarning_delete(HttpServletRequest request) {
String checkValStr = request.getParameter("checkVal");
@@ -170,12 +219,29 @@
}
@ResponseBody
+ @RequestMapping(value = "/realTimeWarning_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int realTimeWarning_deletea(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ int aaa = warningService.realinWarning_deletea(checkVal);
+ return aaa;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/realTimeWarning_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
public void realTimeWarning_deleteAll(HttpServletRequest request) {
warningService.realinWarning_deleteAll();
}
@ResponseBody
+ @RequestMapping(value = "/realTimeWarning_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int realTimeWarning_deleteAlla(HttpServletRequest request) {
+ int aaa = warningService.realinWarning_deleteAlla();
+ return aaa;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/realTimeWarning_search.do", method = { RequestMethod.POST, RequestMethod.GET })
public String realTimeWarning_search(HttpServletRequest request) throws IOException {
JSONObject json = new JSONObject();
@@ -203,6 +269,28 @@
}
@ResponseBody
+ @RequestMapping(value = "/realTimeWarning_searcha.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject realTimeWarning_searcha(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("tagid");
+ if (("").equals(input) || input == null) {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ List<tb_realinwarning> realTimeWarningList = warningService.searchRealinWarning(input);
+ if (realTimeWarningList.size()>0){
+ json.put("result", realTimeWarningList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ } else {
+ List<tb_realinwarning> realTimeWarningList = warningService.searchRealinWarning(input);
+ json.put("dataList", realTimeWarningList);
+ }
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/realTimeWarning_page.do", method = { RequestMethod.POST, RequestMethod.GET })
public String realTimeWarning_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
@@ -286,6 +374,15 @@
}
@ResponseBody
+ @RequestMapping(value = "/historicalWarninga.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject historicalWarninga(HttpServletRequest request) {
+ JSONObject json = new JSONObject();
+ List<tb_historyinwarning> historicalWarningList = warningService.getHistoricalWarninga();
+ json.put("dataList", historicalWarningList);
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/historicalWarning_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
public void historicalWarning_delete(HttpServletRequest request) {
String checkValStr = request.getParameter("checkVal");
@@ -293,7 +390,17 @@
String[] checkVal = checkValStr.split(",");
warningService.historicalWarning_delete(checkVal);
}
-
+
+ @ResponseBody
+ @RequestMapping(value = "/historicalWarning_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int historicalWarning_deletea(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ int aaa = warningService.historicalWarning_deletea(checkVal);
+ return aaa;
+ }
+
@ResponseBody
@RequestMapping(value = "/Warning_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
public void Warning_delete(HttpServletRequest request) {
@@ -314,17 +421,64 @@
}
@ResponseBody
+ @RequestMapping(value = "/Warning_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int Warning_deletea(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ String tagids = request.getParameter("tagids");
+ String types = request.getParameter("types");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ tagids = tagids.replaceAll("\"", "");
+ types = types.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ String[] tagid = tagids.split(",");
+ String[] typess = types.split(",");
+ int aaa = warningService.Warning_deletea(checkVal);
+ for (int i = 0; i < tagid.length; i++) {
+ String xieyi = "BSTOCS1,DELETEWARN," +tagid[i]+ "," +typess[i]+ ",END";
+ Udp_Out.udp_to_cs(xieyi);
+ }
+ return aaa;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/historicalWarning_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
public void historicalWarning_deleteAll(HttpServletRequest request) {
warningService.historicalWarning_deleteAll();
}
-
+
+ @ResponseBody
+ @RequestMapping(value = "/historicalWarning_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int historicalWarning_deleteAlla(HttpServletRequest request) {
+ int aaa = warningService.historicalWarning_deleteAlla();
+ return aaa;
+ }
+
@ResponseBody
@RequestMapping(value = "/Warning_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
public void Warning_deleteAll(HttpServletRequest request) {
- warningService.Warning_deleteAll();
- String xieyi = "BSTOCS1,DELETEWARNALL,END";
- Udp_Out.udp_to_cs(xieyi);
+ String input = request.getParameter("fenlei");
+ if (input.equals("鍏ㄩ儴")) {
+ warningService.Warning_deleteAll();
+ String xieyi = "BSTOCS1,DELETEWARNALL,END";
+ Udp_Out.udp_to_cs(xieyi);
+ } else {
+ warningService.Warning_deletefenlei(input);
+ }
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/Warning_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int Warning_deleteAlla(HttpServletRequest request) {
+ String input = request.getParameter("fenlei");
+ int aaa = 0;
+ if (input.equals("鍏ㄩ儴")) {
+ aaa = warningService.Warning_deleteAlla();
+ String xieyi = "BSTOCS1,DELETEWARNALL,END";
+ Udp_Out.udp_to_cs(xieyi);
+ } else {
+ warningService.Warning_deletefenlei(input);
+ }
+ return aaa;
}
@ResponseBody
@@ -343,6 +497,16 @@
}
@ResponseBody
+ @RequestMapping(value = "/historicalWarning_searcha.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject historicalWarning_searcha(HttpServletRequest request) {
+ String input = request.getParameter("tagid");
+ List<tb_historyinwarning> historicalWarningList = warningService.searchHistoricalWarning(input);
+ JSONObject json = new JSONObject();
+ json.put("dataList", historicalWarningList);
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/historicalWarning_page.do", method = { RequestMethod.POST, RequestMethod.GET })
public String labelManagement_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
@@ -415,7 +579,7 @@
}
return reList;
}
-
+
@ResponseBody
@RequestMapping(value = "/historicalWarning_handle.do", method = { RequestMethod.POST, RequestMethod.GET })
public void historicalWarning_handle(HttpServletRequest request) {
@@ -431,7 +595,24 @@
Udp_Out.udp_to_cs(xieyi);
}
}
-
+
+ @ResponseBody
+ @RequestMapping(value = "/historicalWarning_handlea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int historicalWarning_handlea(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ String types = request.getParameter("types");
+ types = types.replaceAll("\"", "");
+ String[] typess = types.split(",");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ int aaa = warningService.historicalWarning_handle(checkVal);
+ for (int i = 0; i < checkVal.length; i++) {
+ String xieyi = "BSTOCS1,DELLWARN," +checkVal[i]+ "," +typess[i]+ ",END";
+ Udp_Out.udp_to_cs(xieyi);
+ }
+ return aaa;
+ }
+
@ResponseBody
@RequestMapping(value = "/historicalWarning_handleAll.do", method = { RequestMethod.POST, RequestMethod.GET })
public void historicalWarning_handleAll(HttpServletRequest request) {
@@ -441,6 +622,16 @@
Udp_Out.udp_to_cs(xieyi);
}
+ @ResponseBody
+ @RequestMapping(value = "/historicalWarning_handleAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int historicalWarning_handleAlla(HttpServletRequest request) {
+ int aaa = warningService.historicalWarning_handleAll();
+ warningService.historicalWarning_handleAll_realpositoin();
+ String xieyi = "BSTOCS1,DELLWARNALL,END";
+ Udp_Out.udp_to_cs(xieyi);
+ return aaa;
+ }
+
@RequestMapping(value = "/warning_bw_add.do", method = { RequestMethod.POST, RequestMethod.GET })
public void warning_bw_add(HttpServletRequest request) throws IOException {
String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
@@ -491,4 +682,479 @@
String[] checkVal = { realinwarning.getTagid() };
warningService.realinWarning_delete(checkVal);
}
+
+ @ResponseBody
+ @RequestMapping(value = "/shaileixing.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String shaileixing(HttpServletRequest request) {
+ String fenlei = request.getParameter("fenlei");
+ List<tb_warning> labelManagementList = warningService.getleixing(fenlei);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/shaizhuangtai.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String shaizhuangtai(HttpServletRequest request) {
+ String fenlei = request.getParameter("fenlei");
+ List<tb_warning> labelManagementList = warningService.getzhuangtai(fenlei);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/shuangshai.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String shuangshai(HttpServletRequest request) {
+ String fenlei = request.getParameter("fenlei");
+ String fenlei2 = request.getParameter("fenlei2");
+ List<tb_warning> labelManagementList = warningService.getshuangshai(fenlei,fenlei2);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/warningexport.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String warningexport(HttpServletRequest request, HttpServletResponse response) {
+ List<tb_warning> warningSummaryList = warningService.getWarningSummarya();
+ String[] rowName = { "搴忓彿", "鍥存爮鍚嶇О", "鍏宠仈閮ㄩ棬", "鍏宠仈鏍囩", "鍛婅鏃堕棿", "鍛婅鍘熷洜", "鍧愭爣" };
+ List<Object[]> dataList = objectToArray_job(warningSummaryList);
+ ExcelUtils excel = new ExcelUtils("鍛婅鍘嗗彶", rowName, dataList);
+ OutputStream out;
+ String fileName = "";
+ try {
+ fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
+ String filePath2 = request.getServletContext().getRealPath("/") + "hxzk/image/excels/"+fileName;
+ out = new FileOutputStream(filePath2);
+ excel.export(out);
+ out.flush();
+ out.close();
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return fileName;
+ }
+
+ @RequestMapping(value = "/permissionManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String permissionManagement(HttpServletRequest request) {
+ String toPage = "forward:/hxzk/warning/permissionManagement.jsp";
+ List<tb_tag> labelManagementList = warningService.getPermissionManagement(1);
+ List<tb_tag> labelManagementListaa = labelService.getLabelManagementa();
+ request.setAttribute("labelManagementList", labelManagementList);
+ request.setAttribute("labelManagementListaa", labelManagementListaa);
+ int curPage = 1;
+ int count = labelService.getLabelManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", curPage);
+ return toPage;
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/permissionManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String permissionManagement_page(HttpServletRequest request) {
+ String pageStr = request.getParameter("page");
+ String curPageStr = request.getParameter("curPage");
+ int count = labelService.getLabelManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ int curPage = Integer.parseInt(curPageStr);
+ int page = 1;
+ if ("pre".equals(pageStr)) {
+ if (curPage > 1) {
+ page = curPage - 1;
+ }
+ } else if ("next".equals(pageStr)) {
+ if (curPage < minPage) {
+ page = curPage + 1;
+ }
+ } else {
+ page = Integer.parseInt(pageStr);
+ }
+// List<tb_tag> labelManagementList = labelService.getLabelManagement(page);
+ List<tb_tag> labelManagementList = warningService.getPermissionManagement(page);
+ List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", page);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/permissionManagementupdate.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void permissionManagementupdate(HttpServletRequest request) {
+ String checkValStr = request.getParameter("tagids");
+ String panduan = request.getParameter("checkbox");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ for (int i = 0; i < checkVal.length; i++) {
+ warningService.permissionupdate(panduan,checkVal[i]);
+ String xieyi = "BSTOCS1,EDITPER,"+checkVal[i]+","+panduan+",END";
+ Udp_Out.udp_to_cs(xieyi);
+ String person = labelService.findpname(checkVal[i]);
+ tb_permission per = new tb_permission();
+ per.setType("鎺堟潈璁板綍");
+ per.setName(person);
+ per.setTagid(checkVal[i]);
+ if (panduan.equals("1")) {
+ per.setEvent("鎺堟潈");
+ } else {
+ per.setEvent("瑙ｆ潈");
+ }
+ warningService.permission_add(per);
+ }
+// for (int i = 0; i < checkVal.length; i++) {
+// String xieyi = "BSTOCS1,DELETETAG," + checkVal[i] + ",END";
+// Udp_Out.udp_to_cs(xieyi);
+// }
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "findidpermission.do", method = {RequestMethod.POST,RequestMethod.GET})
+ public String findidpermission(HttpServletRequest request) {
+ JSONObject json = new JSONObject();
+ String tagid = request.getParameter("input");
+ List<tb_tag> tag = warningService.getPermissionid(tagid);
+ json.put("dataList", tag);
+ return json.toString();
+ }
+
+ @RequestMapping(value = "/permissionManagement2.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String permissionManagement2(HttpServletRequest request) {
+ String toPage = "forward:/hxzk/warning/permissionManagement2.jsp";
+ List<tb_permission> labelManagementList = warningService.findpermission(1);
+ request.setAttribute("labelManagementList", labelManagementList);
+ int curPage = 1;
+ int count = warningService.getperManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", curPage);
+ return toPage;
+ }
+
+ @RequestMapping(value = "deletepermission.do", method= {RequestMethod.POST,RequestMethod.GET})
+ public void deletepermission(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ for (int i = 0; i < checkVal.length; i++) {
+ warningService.Warning_deleteper(checkVal[i]);
+ }
+ }
+
+ @RequestMapping(value = "deletepermission2.do", method= {RequestMethod.POST,RequestMethod.GET})
+ public void deletepermission2(HttpServletRequest request) {
+ warningService.Warning_deleteper2();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/permission_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String permission_page(HttpServletRequest request) {
+ String pageStr = request.getParameter("page");
+ String curPageStr = request.getParameter("curPage");
+ int count = warningService.getperManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ int curPage = Integer.parseInt(curPageStr);
+ int page = 1;
+ if ("pre".equals(pageStr)) {
+ if (curPage > 1) {
+ page = curPage - 1;
+ }
+ } else if ("next".equals(pageStr)) {
+ if (curPage < minPage) {
+ page = curPage + 1;
+ }
+ } else {
+ page = Integer.parseInt(pageStr);
+ }
+ List<tb_permission> labelManagementList = warningService.findpermission(page);
+ List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", page);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "findidpermission2.do", method = {RequestMethod.POST,RequestMethod.GET})
+ public String findidpermission2(HttpServletRequest request) {
+ JSONObject json = new JSONObject();
+ String tagid = request.getParameter("input");
+ List<tb_permission> tag = warningService.findidpermission2(tagid);
+ json.put("dataList", tag);
+ return json.toString();
+ }
+
+ @RequestMapping(value="tomessagem.do",method= {RequestMethod.POST,RequestMethod.GET})
+ public String tomessagem(HttpServletRequest request) {
+ String toPage = "forward:/hxzk/label/messageManagement.jsp";
+ List<tb_message_history> mess = warningService.findmessage(1);
+ request.setAttribute("dataList", mess);
+ int curPage = 1;
+ int count = warningService.getmessageManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", curPage);
+ return toPage;
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/message_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String message_page(HttpServletRequest request) {
+ String pageStr = request.getParameter("page");
+ String curPageStr = request.getParameter("curPage");
+ int count = warningService.getmessageManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ int curPage = Integer.parseInt(curPageStr);
+ int page = 1;
+ if ("pre".equals(pageStr)) {
+ if (curPage > 1) {
+ page = curPage - 1;
+ }
+ } else if ("next".equals(pageStr)) {
+ if (curPage < minPage) {
+ page = curPage + 1;
+ }
+ } else {
+ page = Integer.parseInt(pageStr);
+ }
+ List<tb_message_history> labelManagementList = warningService.findmessage(page);
+ List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", page);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/message_export.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String message_export(HttpServletRequest request, HttpServletResponse response) {
+ String toPage = "forward:/hxzk/label/messageManagement.jsp";
+ List<tb_message_history> tb_warningList = warningService.findmessage2();
+ String[] rowName = { "搴忓彿", "鏍囩ID", "鎺ユ敹浜�", "鍙戦�佷汉", "淇℃伅", "鍙戦�佹椂闂�", "鍥炲鏃堕棿", "鏄惁鍝嶅簲"};
+ List<Object[]> dataList = objectToArray_warningSummary2(tb_warningList);
+ ExcelUtils excel = new ExcelUtils("淇℃伅璁板綍", rowName, dataList);
+ OutputStream out;
+ try {
+ String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
+ String headStr = "attachment; filename=\"" + fileName + "\"";
+ response.setContentType("APPLICATION/OCTET-STREAM");
+ response.setHeader("Content-Disposition", headStr);
+ out = response.getOutputStream();
+ excel.export(out);
+ out.flush();
+ out.close();
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return toPage;
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/message_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void message_delete(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ warningService.message_delete(checkVal);
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/message_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void message_deletea(HttpServletRequest request) {
+ warningService.message_deletea();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/message_search.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String message_search(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("input");
+ if (("").equals(input) || input == null) {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ List<tb_message_history> warningSummaryList = warningService.findmessage3(input);
+ if (warningSummaryList.size()>0){
+ json.put("result", warningSummaryList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ } else {
+ int curPage = 1;
+ List<Integer> pageList = new ArrayList<Integer>();
+ List<tb_message_history> warningSummaryList = warningService.findmessage3(input);
+ pageList.add(1);
+ json.put("dataList", warningSummaryList);
+ json.put("pageList", pageList);
+ json.put("curPage", curPage);
+ }
+ return json.toString();
+ }
+
+ @RequestMapping(value="tolixian.do",method= {RequestMethod.POST,RequestMethod.GET})
+ public String tolixian(HttpServletRequest request) {
+ String toPage = "forward:/hxzk/label/lixianManagement.jsp";
+ List<tb_lixianrecord> mess = warningService.findlixian(1);
+ request.setAttribute("dataList", mess);
+ int curPage = 1;
+ int count = warningService.getlixianManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", curPage);
+ return toPage;
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/lixian_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String lixian_page(HttpServletRequest request) {
+ String pageStr = request.getParameter("page");
+ String curPageStr = request.getParameter("curPage");
+ int count = warningService.getlixianManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ int curPage = Integer.parseInt(curPageStr);
+ int page = 1;
+ if ("pre".equals(pageStr)) {
+ if (curPage > 1) {
+ page = curPage - 1;
+ }
+ } else if ("next".equals(pageStr)) {
+ if (curPage < minPage) {
+ page = curPage + 1;
+ }
+ } else {
+ page = Integer.parseInt(pageStr);
+ }
+ List<tb_lixianrecord> labelManagementList = warningService.findlixian(page);
+ List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+ JSONObject json = new JSONObject();
+ json.put("dataList", labelManagementList);
+ json.put("pageList", pageList);
+ json.put("curPage", page);
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/lixian_export.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String lixian_export(HttpServletRequest request, HttpServletResponse response) {
+ String toPage = "forward:/hxzk/label/lixianManagement.jsp";
+ List<tb_lixianrecord> tb_warningList = warningService.findlixian2();
+ String[] rowName = { "搴忓彿", "鏍囩ID", "濮撳悕", "閮ㄩ棬", "鏃堕暱/S", "璁板綍鏃堕棿"};
+ List<Object[]> dataList = objectToArray_warningSummary3(tb_warningList);
+ ExcelUtils excel = new ExcelUtils("绂荤嚎鍛婅", rowName, dataList);
+ OutputStream out;
+ try {
+ String fileName = "Excel-" + String.valueOf(System.currentTimeMillis()).substring(4, 13) + ".xls";
+ String headStr = "attachment; filename=\"" + fileName + "\"";
+ response.setContentType("APPLICATION/OCTET-STREAM");
+ response.setHeader("Content-Disposition", headStr);
+ out = response.getOutputStream();
+ excel.export(out);
+ out.flush();
+ out.close();
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return toPage;
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/lixian_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void lixian_delete(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ warningService.lixian_delete(checkVal);
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/lixian_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void lixian_deletea(HttpServletRequest request) {
+ warningService.lixian_deletea();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/lixian_search.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String lixian_search(HttpServletRequest request) throws IOException {
+ JSONObject json = new JSONObject();
+ String input = request.getParameter("input");
+ if (("").equals(input) || input == null) {
+ String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
+ tb_tag tag = (tb_tag) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
+ input = tag.getTag_id();
+ List<tb_lixianrecord> warningSummaryList = warningService.findlixian3(input);
+ if (warningSummaryList.size()>0){
+ json.put("result", warningSummaryList.get(0));
+ } else {
+ json.put("result", "null");
+ }
+ } else {
+ int curPage = 1;
+ List<Integer> pageList = new ArrayList<Integer>();
+ List<tb_lixianrecord> warningSummaryList = warningService.findlixian3(input);
+ pageList.add(1);
+ json.put("dataList", warningSummaryList);
+ json.put("pageList", pageList);
+ json.put("curPage", curPage);
+ }
+ return json.toString();
+ }
+
+ // 浣滀笟淇℃伅 瀵煎嚭琛ㄦ牸 瀵硅薄杞暟缁�
+ public static List<Object[]> objectToArray_job(List<tb_warning> history_powerList) {
+ List<Object[]> reList = new ArrayList<>();
+ for (int i = 0; i < history_powerList.size(); i++) {
+ List<String> words = new ArrayList<String>();
+ tb_warning history_power = (tb_warning) history_powerList.get(i);
+ words.add(history_power.getId() + "");
+ words.add(history_power.getBaoliu2());
+ words.add(history_power.getBaoliu3());
+ words.add(history_power.getObjectid());
+ words.add(history_power.getTime());
+ words.add(history_power.getType());
+ words.add(history_power.getBaoliu1());
+ String[] array = words.toArray(new String[0]);
+ reList.add(array);
+ }
+ return reList;
+ }
+
+ public static List<Object[]> objectToArray_warningSummary2(List<tb_message_history> tb_warningList) {
+ List<Object[]> reList = new ArrayList<>();
+ for (int i = 0; i < tb_warningList.size(); i++) {
+ List<String> words = new ArrayList<String>();
+ tb_message_history warn = tb_warningList.get(i);
+ words.add(warn.getId() + "");
+ words.add(warn.getTagid());
+ words.add(warn.getBaoliu1());
+ words.add(warn.getUsername());
+ words.add(warn.getInfo());
+ words.add(warn.getSendtime());
+ words.add(warn.getReplytime());
+ words.add(warn.getBaoliu2());
+ String[] array = words.toArray(new String[0]);
+ reList.add(array);
+ }
+ return reList;
+ }
+
+ public static List<Object[]> objectToArray_warningSummary3(List<tb_lixianrecord> tb_warningList) {
+ List<Object[]> reList = new ArrayList<>();
+ for (int i = 0; i < tb_warningList.size(); i++) {
+ List<String> words = new ArrayList<String>();
+ tb_lixianrecord warn = tb_warningList.get(i);
+ words.add(warn.getId() + "");
+ words.add(warn.getTagid());
+ words.add(warn.getName());
+ words.add(warn.getBumen());
+ words.add(warn.getPhone());
+ words.add(warn.getTime());
+ String[] array = words.toArray(new String[0]);
+ reList.add(array);
+ }
+ return reList;
+ }
}
--
Gitblit v1.10.0