From 52cffc4ab8e9787a6f233295502c7c9788dddae1 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期二, 07 三月 2023 10:45:17 +0800
Subject: [PATCH] 3.7
---
src/main/java/com/hxzkoa/controller/GpsController.java | 284 +++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 259 insertions(+), 25 deletions(-)
diff --git a/src/main/java/com/hxzkoa/controller/GpsController.java b/src/main/java/com/hxzkoa/controller/GpsController.java
index d25111d..016fe06 100644
--- a/src/main/java/com/hxzkoa/controller/GpsController.java
+++ b/src/main/java/com/hxzkoa/controller/GpsController.java
@@ -1,12 +1,14 @@
package com.hxzkoa.controller;
+import java.io.FileInputStream;
+import java.io.IOException;
+import java.io.InputStream;
import java.io.OutputStream;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
-import java.util.Enumeration;
import java.util.List;
@@ -20,12 +22,15 @@
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
+import com.hxzkoa.json.tb_cojilu;
import com.hxzkoa.json.tb_gps;
-import com.hxzkoa.json.tb_person;
import com.hxzkoa.json.tb_realocation;
+import com.hxzkoa.json.tb_rtkanchor;
import com.hxzkoa.json.tb_system;
-import com.hxzkoa.json.tb_track;
+import com.hxzkoa.json.tb_tag;
import com.hxzkoa.services.GpsService;
+import com.hxzkoa.services.LabelService;
+import com.hxzkoa.services.LocationService;
import com.hxzkoa.services.SysSettingService;
import com.hxzkoa.udp.Dell_GNGGA;
import com.hxzkoa.udp.Udp_Out;
@@ -43,7 +48,11 @@
@Autowired
private GpsService gpsService;
@Autowired
+ private LabelService labelService;
+ @Autowired
private SysSettingService sysSettingService;
+ @Autowired
+ private LocationService locationService;
@ResponseBody
@RequestMapping(value = "/updateperson.do",method = { RequestMethod.POST, RequestMethod.GET })
@@ -56,13 +65,13 @@
@RequestMapping(value = "/xinhuifang.do",method = { RequestMethod.POST, RequestMethod.GET })
public ArrayList<String> xinhuifang(HttpServletRequest request) {
ArrayList<String> baowen = AddTxt.txt2String();
- System.out.print(baowen.get(0));
+ //System.out.print(baowen.get(0));
return baowen;
}
@RequestMapping(value = "/huifang.do",method = { RequestMethod.POST, RequestMethod.GET })
public String huifang(HttpServletRequest request) {
- String toPage = "forward:/hxzk/GPS/gpsHuifang.jsp";
+ String toPage = "forward:/hxzk/baidu.jsp";
return toPage;
}
@@ -145,11 +154,25 @@
}
@ResponseBody
+ @RequestMapping(value = "/gpsManagement_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int gpsManagement_deletea(HttpServletRequest request) throws ParseException {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ int aaa = gpsService.gpsManagement_deletea(checkVal);
+ for(int i = 0; i < checkVal.length; i++) {
+ String xieyi = "BSTOCS1,DELETEGPS,"+checkVal[i]+",END";
+ Udp_Out.udp_to_cs(xieyi);
+ }
+ return aaa;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/gpsManagement_export.do", method = { RequestMethod.POST, RequestMethod.GET })
public String gpsManagement_export(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/GPS/gpsManagement.jsp";
List<tb_gps> gpsManagementList = gpsService.getGpsManagement();
- String[] rowName = {"搴忓彿", "璁惧缂栧彿","绾害","缁忓害","GPS鐘舵��","鍗槦鏁�","娴锋嫈楂�","宸垎绔橧D","鐢甸噺","鏇存柊鏃堕棿"};
+ String[] rowName = {"璁惧缂栧彿","鍗″彿"};
List<Object[]> dataList = objectToArray(gpsManagementList);
ExcelUtils excel = new ExcelUtils("gps瀹氫綅", rowName, dataList);
OutputStream out;
@@ -209,6 +232,22 @@
}
@ResponseBody
+ @RequestMapping(value = "/historicalgpsLocationa.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public JSONObject historicalgpsLocationa(HttpServletRequest request) throws SQLException {
+ JSONObject json = new JSONObject();
+ String date = request.getParameter("date");
+ int aaa = locationService.searchtablenameLocation("tb_gps_track_"+date);
+ if (aaa != 0) {
+ List<tb_gps> trackList = gpsService.getTracka(date);
+ json.put("dateList", trackList);
+ } else {
+ List<tb_gps> trackList = new ArrayList<>();
+ json.put("dateList", trackList);
+ }
+ return json;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/historicalgpsLocation_page.do", method = { RequestMethod.POST, RequestMethod.GET })
public String historicalgpsLocation_page(HttpServletRequest request) {
String pageStr = request.getParameter("page");
@@ -256,6 +295,21 @@
}
@ResponseBody
+ @RequestMapping(value = "/historicalgpsLocation_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int historicalgpsLocation_deletea(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ String datea = request.getParameter("datea");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ int bbb = locationService.searchtablenameLocation("tb_gps_track_"+datea);
+ int aaa = 0;
+ if (bbb != 0) {
+ aaa = gpsService.realTimegpsLocation_deletea(checkVal,datea);
+ }
+ return aaa;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/historicalgpsLocation_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
public void historicalLocation_deleteAll(HttpServletRequest request) {
String date = request.getParameter("aaaa");
@@ -263,6 +317,18 @@
}
@ResponseBody
+ @RequestMapping(value = "/historicalgpsLocation_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public int historicalLocation_deleteAlla(HttpServletRequest request) {
+ String date = request.getParameter("date");
+ int bbb = locationService.searchtablenameLocation("tb_gps_track_"+date);
+ int aaa = 0;
+ if (bbb != 0) {
+ aaa = gpsService.realTimegpsLocation_deleteAlla(date);
+ }
+ return aaa;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/getstatus.do", method = { RequestMethod.POST, RequestMethod.GET })
public String getstatus(HttpServletRequest request) {
String tagid = request.getParameter("tagid");
@@ -271,22 +337,80 @@
}
@ResponseBody
+ @RequestMapping(value = "/getstatusss.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String getstatusss(HttpServletRequest request) {
+ String tagid = "8888";
+ String zhuangtai = gpsService.getpersontagid(tagid);
+ return zhuangtai;
+ }
+
+ @ResponseBody
@RequestMapping(value = "/historicalgpsLocation_search.do", method = { RequestMethod.POST, RequestMethod.GET })
public String historicalgpsLocation_search(HttpServletRequest request) {
- String input = request.getParameter("input");
String date = request.getParameter("tttt");
- int curPage = 1;
+ String input = request.getParameter("input");
List<Integer> pageList = new ArrayList<Integer>();
- List<tb_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date);
+ List<tb_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date,1);
pageList.add(1);
JSONObject json = new JSONObject();
+ int curPage = 1;
+ int count = gpsService.getgpsRealTimeLocationCount2(date,input);
+ int minPage = PageUtil.getMinPage2(count);
json.put("dataList", historicalLocationList);
- json.put("pageList", pageList);
+ json.put("pageList", PageUtil.getPage(minPage));
json.put("curPage", curPage);
return json.toString();
}
@ResponseBody
+ @RequestMapping(value = "/historicalgpsLocation_search2.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String historicalgpsLocation_search2(HttpServletRequest request) {
+ String pageStr = request.getParameter("page");
+ String curPageStr = request.getParameter("curPage");
+ String date = request.getParameter("date");
+ String input = request.getParameter("input");
+ int count = gpsService.getgpsRealTimeLocationCount2(date,input);
+ int minPage = PageUtil.getMinPage2(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_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date,page);
+ List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
+ JSONObject json = new JSONObject();
+ json.put("dataList", historicalLocationList);
+ json.put("pageList", pageList);
+ json.put("curPage", page);
+ return json.toString();
+ }
+
+// @ResponseBody
+// @RequestMapping(value = "/historicalgpsLocation_searcha.do", method = { RequestMethod.POST, RequestMethod.GET })
+// public JSONObject historicalgpsLocation_searcha(HttpServletRequest request) {
+// String input = request.getParameter("tagid");
+// String date = request.getParameter("date");
+// JSONObject json = new JSONObject();
+// int aaa = locationService.searchtablenameLocation("tb_gps_track_"+date);
+// if (aaa != 0) {
+// List<tb_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date);
+// json.put("dataList", historicalLocationList);
+// } else {
+// List<tb_gps> abc = new ArrayList<>();
+// json.put("dataList", abc);
+// }
+// return json;
+// }
+
+ @ResponseBody
@RequestMapping(value = "/historicalgpsLocation_export.do", method = { RequestMethod.POST, RequestMethod.GET })
public String gpshistoricalPower_export(HttpServletRequest request, HttpServletResponse response) {
String toPage = "forward:/hxzk/label/historicalgpsLocation.jsp";
@@ -294,21 +418,10 @@
String begin = request.getParameter("begintime");
String end = request.getParameter("endtime");
String date = request.getParameter("date");
-// Enumeration<String> paraNames=request.getParameterNames();
-// String thisName = null;
-// String thisValue = null;
-// String[] value = null;
-// int i = 0;
-// for(Enumeration<String> e=paraNames;e.hasMoreElements();){
-// thisName=e.nextElement()+""; //name鍚�
-// thisValue=request.getParameter(thisName); //name鍚嶅搴旂殑鍊�
-// value[i] = thisValue;
-// i++;
-// }
List<tb_gps> historicalLocationList = gpsService.getRealTimegpsLocation(tagid,begin,end,date);
- String[] rowName = {"搴忓彿", "璁惧缂栧彿","绾害","缁忓害","GPS鐘舵��","鍗槦鏁�","娴锋嫈楂�","宸垎绔橧D","鐢甸噺","鏇存柊鏃堕棿"};
- List<Object[]> dataList = objectToArray(historicalLocationList);
- System.out.print(dataList.get(0));
+ String[] rowName = {"搴忓彿", "璁惧缂栧彿","绾害","缁忓害","GPS鐘舵��","鍗槦鏁�","娴锋嫈楂�","宸垎绔橧D","姘村钩绮惧害鍥犲瓙","宸垎鏃堕棿","鐢甸噺","鏇存柊鏃堕棿"};
+ List<Object[]> dataList = objectToArray2(historicalLocationList);
+ //System.out.print(dataList.get(0));
ExcelUtils excel = new ExcelUtils("GPS鏁版嵁", rowName, dataList);
OutputStream out;
try {
@@ -326,13 +439,47 @@
return toPage;
}
+ @ResponseBody
+ @RequestMapping(value = "/totxt.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String totxt(HttpServletRequest request,HttpServletResponse response) throws IOException {
+ String toPage = "forward:/hxzk/label/historicalgpsLocation.jsp";
+ String date = request.getParameter("date");
+ InputStream is;
+ OutputStream os;
+ String filename = date + ".txt";
+ response.setHeader("Content-Disposition", "attachement;filename=" + filename);
+ is = new FileInputStream("C:\\" +date+ ".txt");
+ os = response.getOutputStream();
+ int len = 0;
+ byte[] buffer = new byte[1024];
+ while ((len = is.read(buffer)) != -1) {
+ os.write(buffer, 0, len);
+ }
+ os.close();
+ is.close();
+ return toPage;
+ }
+
// 瀵硅薄杞暟缁�
public static List<Object[]> objectToArray(List<tb_gps> sensorManagementList) {
List<Object[]> reList = new ArrayList<>();
for (int i = 0; i < sensorManagementList.size(); i++) {
List<String> words = new ArrayList<String>();
tb_gps gps = (tb_gps) sensorManagementList.get(i);
- words.add(String.valueOf(gps.getId()));
+ words.add(gps.getTagid());
+ words.add(gps.getCcid());
+ String[] array = words.toArray(new String[0]);
+ reList.add(array);
+ }
+ return reList;
+ }
+
+ public static List<Object[]> objectToArray2(List<tb_gps> sensorManagementList) {
+ List<Object[]> reList = new ArrayList<>();
+ for (int i = 0; i < sensorManagementList.size(); i++) {
+ List<String> words = new ArrayList<String>();
+ tb_gps gps = (tb_gps) sensorManagementList.get(i);
+ words.add(gps.getId()+"");
words.add(gps.getTagid());
words.add(gps.getGps_weidu());
words.add(gps.getGsp_jingdu());
@@ -340,6 +487,8 @@
words.add(gps.getGps_num());
words.add(gps.getGps_haiba_gao());
words.add(gps.getGps_chafen_id());
+ words.add(gps.getGps_hdop());
+ words.add(gps.getGps_chafen_time());
words.add(gps.getGps_power());
words.add(gps.getAddtime());
String[] array = words.toArray(new String[0]);
@@ -347,5 +496,90 @@
}
return reList;
}
+
+ //宸垎鍩虹珯
+ @RequestMapping(value="tortkanchor.do",method= {RequestMethod.POST,RequestMethod.GET})
+ public String tortkanchor(HttpServletRequest request) {
+ String toPage = "forward:/hxzk/GPS/rtkanchorManagement.jsp";
+ List<tb_rtkanchor> mess = gpsService.findrtkanchor(1);
+ request.setAttribute("dataList", mess);
+ int curPage = 1;
+ int count = gpsService.getrtkanchorManagementCount();
+ int minPage = PageUtil.getMinPage(count);
+ request.setAttribute("pageList", PageUtil.getPage(minPage));
+ request.setAttribute("curPage", curPage);
+ return toPage;
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/rtkanchor_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void rtkanchor_delete(HttpServletRequest request) {
+ String checkValStr = request.getParameter("checkVal");
+ checkValStr = checkValStr.replaceAll("\"", "");
+ String[] checkVal = checkValStr.split(",");
+ gpsService.rtkanchor_delete(checkVal);
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/rtkanchor_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public void rtkanchor_deletea(HttpServletRequest request) {
+ gpsService.rtkanchor_deletea();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/rtkanchor_search.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String rtkanchor_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_rtkanchor> warningSummaryList = gpsService.findrtkanchor3(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_rtkanchor> warningSummaryList = gpsService.findrtkanchor3(input);
+ pageList.add(1);
+ json.put("dataList", warningSummaryList);
+ json.put("pageList", pageList);
+ json.put("curPage", curPage);
+ }
+ return json.toString();
+ }
+
+ @ResponseBody
+ @RequestMapping(value = "/rtkanchor_page.do", method = { RequestMethod.POST, RequestMethod.GET })
+ public String rtkanchor_page(HttpServletRequest request) {
+ String pageStr = request.getParameter("page");
+ String curPageStr = request.getParameter("curPage");
+ int count = gpsService.getrtkanchorManagementCount();
+ 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_rtkanchor> labelManagementList = gpsService.findrtkanchor(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();
+ }
}
--
Gitblit v1.10.0