yzt
2023-05-08 24e1c6a1c3d5331b5a4f1111dcbae3ef148eda1a
src/main/java/com/hxzkoa/controller/GpsController.java
@@ -1,30 +1,11 @@
//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by FernFlower decompiler)
//
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.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
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_realocation;
import com.hxzkoa.json.tb_rtkanchor;
import com.hxzkoa.json.tb_system;
import com.hxzkoa.json.tb_tag;
@@ -40,8 +21,25 @@
import com.hxzkoa.util.ModifyConfig;
import com.hxzkoa.util.PageUtil;
import com.hxzkoa.util.RequestUtils;
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.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;
@Controller
public class GpsController {
@@ -53,55 +51,75 @@
   private SysSettingService sysSettingService;
   @Autowired
   private LocationService locationService;
   public GpsController() {
   }
   @ResponseBody
   @RequestMapping(value = "/updateperson.do",method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/updateperson.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public void updateperson(HttpServletRequest request) {
      String strs = request.getParameter("strs");
      Dell_GNGGA.dell_gps(strs);
   }
   @ResponseBody
   @RequestMapping(value = "/xinhuifang.do",method = { RequestMethod.POST, RequestMethod.GET })
   @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));
      return baowen;
   }
   @RequestMapping(value = "/huifang.do",method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/huifang.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String huifang(HttpServletRequest request) {
      String toPage = "forward:/hxzk/baidu.jsp";
      return toPage;
   }
   @RequestMapping(value = "/huifangdodo.do",method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/huifangdodo.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public List<String> huifangdodo(HttpServletRequest request) {
      List<String> sb = gpsService.txt();
      List<String> sb = this.gpsService.txt();
      return sb;
   }
   @RequestMapping(value = "/gpsManagement.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/gpsManagement.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String gpsManagement(HttpServletRequest request) {
      String toPage = "forward:/hxzk/GPS/gpsManagement.jsp";
      List<tb_gps> gpsManagementList = gpsService.getGpsManagement(1);
      List<tb_gps> gpsManagementList = this.gpsService.getGpsManagement(1);
      request.setAttribute("gpsManagementList", gpsManagementList);
      List<tb_system> settingList = sysSettingService.getSetting();
      List<tb_system> settingList = this.sysSettingService.getSetting();
      request.setAttribute("settingList", settingList);
      int curPage = 1;
      int count = gpsService.getGpsManagementCount();
      int count = this.gpsService.getGpsManagementCount();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      request.setAttribute("curPage", Integer.valueOf(curPage));
      return toPage;
   }
   @ResponseBody
   @RequestMapping(value = "/gpsManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/gpsManagement_page.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String gpsManagement_page(HttpServletRequest request) {
      String pageStr = request.getParameter("page");
      String curPageStr = request.getParameter("curPage");
      int count = gpsService.getGpsManagementCount();
      int count = this.gpsService.getGpsManagementCount();
      int minPage = PageUtil.getMinPage(count);
      int curPage = Integer.parseInt(curPageStr);
      int page = 1;
@@ -116,7 +134,8 @@
      } else {
         page = Integer.parseInt(pageStr);
      }
      List<tb_gps> gpsManagementList = gpsService.getGpsManagement(page);
      List<tb_gps> gpsManagementList = this.gpsService.getGpsManagement(page);
      List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
      JSONObject json = new JSONObject();
      json.put("dataList", gpsManagementList);
@@ -124,143 +143,173 @@
      json.put("curPage", page);
      return json.toString();
   }
   @ResponseBody
   @RequestMapping(value = "/gpsManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/gpsManagement_search.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String gpsManagement_search(HttpServletRequest request) {
      String input = request.getParameter("input");
      int curPage = 1;
      List<Integer> pageList = new ArrayList<Integer>();
      List<tb_gps> gpsManagementList = gpsService.searchGpsManagement(input);
      List<Integer> pageList = new ArrayList();
      List<tb_gps> gpsManagementList = this.gpsService.searchGpsManagement(input);
      pageList.add(1);
      JSONObject json = new JSONObject();
      json.put("dataList", gpsManagementList);
      json.put("pageList", pageList);
      json.put("curPage", curPage);
      json.put("curPage", Integer.valueOf(curPage));
      return json.toString();
   }
   @ResponseBody
   @RequestMapping(value = "/gpsManagement_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/gpsManagement_delete.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public void gpsManagement_delete(HttpServletRequest request) throws ParseException {
      String checkValStr = request.getParameter("checkVal");
      checkValStr = checkValStr.replaceAll("\"", "");
      String[] checkVal = checkValStr.split(",");
      gpsService.gpsManagement_delete(checkVal);
      for(int i = 0; i < checkVal.length; i++) {
         String xieyi = "BSTOCS1,DELETEGPS,"+checkVal[i]+",END";
      this.gpsService.gpsManagement_delete(checkVal);
      for(int i = 0; i < checkVal.length; ++i) {
         String xieyi = "BSTOCS1,DELETEGPS," + checkVal[i] + ",END";
         Udp_Out.udp_to_cs(xieyi);
      }
   }
   @ResponseBody
   @RequestMapping(value = "/gpsManagement_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
   @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";
      int aaa = this.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 })
   @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 = {"设备编号","卡号"};
      List<tb_gps> gpsManagementList = this.gpsService.getGpsManagement();
      String[] rowName = new String[]{"设备编号", "卡号"};
      List<Object[]> dataList = objectToArray(gpsManagementList);
      ExcelUtils excel = new ExcelUtils("gps定位", 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();
         OutputStream out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      } catch (Exception var11) {
         var11.printStackTrace();
      }
      return toPage;
   }
   @RequestMapping(value = "/gpsManagement_zeng.do",method = { RequestMethod.POST, RequestMethod.GET })
   public ModelAndView zeng(tb_system request) throws Exception{
   @RequestMapping(
         value = {"/gpsManagement_zeng.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public ModelAndView zeng(tb_system request) throws Exception {
      ModelAndView mv = new ModelAndView();
      gpsService.gpszeng(request);
      this.gpsService.gpszeng(request);
      mv.setViewName("redirect:/gpsManagement.do");
      return mv;
   }
   @RequestMapping(value = "/historicalgpsLocation.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/historicalgpsLocation.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String historicalgpsLocation(HttpServletRequest request) throws SQLException {
      String toPage = "forward:/hxzk/GPS/historicalgpsLocation.jsp";
      String pagePath = Config.getPageConfig();
      Integer perPage = Integer.parseInt(ModifyConfig.readData(pagePath, "perPage"));
      // List<tb_realocation> historicalLocationList =
      // locationService.getRealTimeLocation(1,perPage);
      Date date = new Date(System.currentTimeMillis());
      SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
      String currentDate = formatter.format(date);
      List<tb_gps> trackList = gpsService.getTrack(currentDate, 1, perPage);
      List<tb_gps> trackList = this.gpsService.getTrack(currentDate, 1, perPage);
      request.setAttribute("historicalLocationList", trackList);
      int curPage = 1;
      int count = gpsService.getgpsRealTimeLocationCount(currentDate);
      int count = this.gpsService.getgpsRealTimeLocationCount(currentDate);
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", curPage);
      request.setAttribute("curPage", Integer.valueOf(curPage));
      request.setAttribute("perPage", perPage);
      // 处理日期查询列表
      List<String> trackDateList = gpsService.getgpsTrackDateList();
      List<String> trackDateReList = new ArrayList<String>();
      List<String> trackDateList = this.gpsService.getgpsTrackDateList();
      List<String> trackDateReList = new ArrayList();
      trackDateReList.add(currentDate);
      for (int i = 0; i < trackDateList.size(); i++) {
         String listdate = trackDateList.get(i);
         if (!(currentDate).equals(listdate)) {
      for(int i = 0; i < trackDateList.size(); ++i) {
         String listdate = (String)trackDateList.get(i);
         if (!currentDate.equals(listdate)) {
            trackDateReList.add(listdate);
         }
      }
      request.setAttribute("dateList", trackDateReList);
      return toPage;
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocationa.do", method = { RequestMethod.POST, RequestMethod.GET })
   @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);
      int aaa = this.locationService.searchtablenameLocation("tb_gps_track_" + date);
      if (aaa != 0) {
         List<tb_gps> trackList = gpsService.getTracka(date);
         List<tb_gps> trackList = this.gpsService.getTracka(date);
         json.put("dateList", trackList);
      } else {
         List<tb_gps> trackList = new ArrayList<>();
         List<tb_gps> trackList = new ArrayList();
         json.put("dateList", trackList);
      }
      return json;
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_page.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/historicalgpsLocation_page.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String historicalgpsLocation_page(HttpServletRequest request) {
      String pageStr = request.getParameter("page");
      String curPageStr = request.getParameter("curPage");
      String date = request.getParameter("date");
      int count = gpsService.getgpsRealTimeLocationCount(date);
      int count = this.gpsService.getgpsRealTimeLocationCount(date);
      int minPage = PageUtil.getMinPage(count);
      int curPage = Integer.parseInt(curPageStr);
      String pagePath = Config.getPageConfig();
      Integer perPage = Integer.parseInt(ModifyConfig.readData(pagePath, "perPage"));
      if (("").equals(pageStr) || pageStr == null) {
      if ("".equals(pageStr) || pageStr == null) {
         pageStr = curPageStr;
      }
      int page = 1;
      if ("pre".equals(pageStr)) {
         if (curPage > 1) {
@@ -273,9 +322,8 @@
      } else {
         page = Integer.parseInt(pageStr);
      }
      // List<tb_realocation> historicalLocationList =
      // locationService.getRealTimeLocation(page,perPage);
      List<tb_gps> trackList = gpsService.getTrack(date, page, perPage);
      List<tb_gps> trackList = this.gpsService.getTrack(date, page, perPage);
      List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
      JSONObject json = new JSONObject();
      json.put("dataList", trackList);
@@ -283,93 +331,119 @@
      json.put("curPage", page);
      return json.toString();
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_delete.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/historicalgpsLocation_delete.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public void historicalgpsLocation_delete(HttpServletRequest request) {
      String checkValStr = request.getParameter("checkVal");
      String datea = request.getParameter("datea");
      checkValStr = checkValStr.replaceAll("\"", "");
      String[] checkVal = checkValStr.split(",");
      gpsService.realTimegpsLocation_delete(checkVal,datea);
      this.gpsService.realTimegpsLocation_delete(checkVal, datea);
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
   @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 bbb = this.locationService.searchtablenameLocation("tb_gps_track_" + datea);
      int aaa = 0;
      if (bbb != 0) {
         aaa = gpsService.realTimegpsLocation_deletea(checkVal,datea);
         aaa = this.gpsService.realTimegpsLocation_deletea(checkVal, datea);
      }
      return aaa;
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/historicalgpsLocation_deleteAll.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public void historicalLocation_deleteAll(HttpServletRequest request) {
      String date = request.getParameter("aaaa");
      gpsService.realTimegpsLocation_deleteAll(date);
      this.gpsService.realTimegpsLocation_deleteAll(date);
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
   @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 bbb = this.locationService.searchtablenameLocation("tb_gps_track_" + date);
      int aaa = 0;
      if (bbb != 0) {
         aaa = gpsService.realTimegpsLocation_deleteAlla(date);
      }
         aaa = this.gpsService.realTimegpsLocation_deleteAlla(date);
      }
      return aaa;
   }
   @ResponseBody
   @RequestMapping(value = "/getstatus.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/getstatus.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String getstatus(HttpServletRequest request) {
      String tagid = request.getParameter("tagid");
      String zhuangtai = gpsService.getpersontagid(tagid);
      String zhuangtai = this.gpsService.getpersontagid(tagid);
      return zhuangtai;
   }
   @ResponseBody
   @RequestMapping(value = "/getstatusss.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/getstatusss.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String getstatusss(HttpServletRequest request) {
      String tagid = "8888";
      String zhuangtai = gpsService.getpersontagid(tagid);
      String zhuangtai = this.gpsService.getpersontagid(tagid);
      return zhuangtai;
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_search.do", method = { RequestMethod.POST, RequestMethod.GET })
   @RequestMapping(
         value = {"/historicalgpsLocation_search.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public String historicalgpsLocation_search(HttpServletRequest request) {
      String date = request.getParameter("tttt");
      String input = request.getParameter("input");
      List<Integer> pageList = new ArrayList<Integer>();
      List<tb_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date,1);
      List<Integer> pageList = new ArrayList();
      List<tb_gps> historicalLocationList = this.gpsService.searchRealTimegpsLocation(input, date, 1);
      pageList.add(1);
      JSONObject json = new JSONObject();
      int curPage = 1;
      int count = gpsService.getgpsRealTimeLocationCount2(date,input);
      int count = this.gpsService.getgpsRealTimeLocationCount2(date, input);
      int minPage = PageUtil.getMinPage2(count);
      json.put("dataList", historicalLocationList);
      json.put("pageList", PageUtil.getPage(minPage));
      json.put("curPage", curPage);
      json.put("curPage", Integer.valueOf(curPage));
      return json.toString();
   }
   @ResponseBody
   @RequestMapping(value = "/historicalgpsLocation_search2.do", method = { RequestMethod.POST, RequestMethod.GET })
   @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 count = this.gpsService.getgpsRealTimeLocationCount2(date, input);
      int minPage = PageUtil.getMinPage2(count);
      int curPage = Integer.parseInt(curPageStr);
      int page = 1;
@@ -384,7 +458,8 @@
      } else {
         page = Integer.parseInt(pageStr);
      }
      List<tb_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date,page);
      List<tb_gps> historicalLocationList = this.gpsService.searchRealTimegpsLocation(input, date, page);
      List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
      JSONObject json = new JSONObject();
      json.put("dataList", historicalLocationList);
@@ -392,194 +467,223 @@
      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 })
   @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 = this.locationService.searchtablenameLocation("tb_gps_track_" + date);
      if (aaa != 0) {
         List<tb_gps> historicalLocationList = this.gpsService.searchRealTimegpsLocation(input, date, 1);
         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";
      String tagid = request.getParameter("tagid");
      String begin = request.getParameter("begintime");
      String end = request.getParameter("endtime");
      String date = request.getParameter("date");
      List<tb_gps> historicalLocationList = gpsService.getRealTimegpsLocation(tagid,begin,end,date);
      String[] rowName = {"序号", "设备编号","纬度","经度","GPS状态","卫星数","海拔高","差分站ID","水平精度因子","差分时间","电量","更新时间"};
      List<tb_gps> historicalLocationList = this.gpsService.getRealTimegpsLocation(tagid, begin, end, date);
      String[] rowName = new String[]{"序号", "设备编号", "纬度", "经度", "GPS状态", "卫星数", "海拔高", "差分站ID", "水平精度因子", "差分时间", "电量", "更新时间"};
      List<Object[]> dataList = objectToArray2(historicalLocationList);
      //System.out.print(dataList.get(0));
      ExcelUtils excel = new ExcelUtils("GPS数据", 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();
         OutputStream out = response.getOutputStream();
         excel.export(out);
         out.flush();
         out.close();
      } catch (Exception e) {
         e.printStackTrace();
      }
      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(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());
            words.add(gps.getGps_state());
            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]);
            reList.add(array);
         }
         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();
      } catch (Exception var15) {
         var15.printStackTrace();
      }
      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");
      String filename = date + ".txt";
      response.setHeader("Content-Disposition", "attachement;filename=" + filename);
      InputStream is = new FileInputStream("C:\\" + date + ".txt");
      OutputStream os = response.getOutputStream();
      byte[] buffer = new byte[1024];
      int len;
      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();
         tb_gps gps = (tb_gps)sensorManagementList.get(i);
         words.add(gps.getTagid());
         words.add(gps.getCcid());
         String[] array = (String[])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();
         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());
         words.add(gps.getGps_state());
         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 = (String[])words.toArray(new String[0]);
         reList.add(array);
      }
      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 = this.gpsService.findrtkanchor(1);
      request.setAttribute("dataList", mess);
      int curPage = 1;
      int count = this.gpsService.getrtkanchorManagementCount();
      int minPage = PageUtil.getMinPage(count);
      request.setAttribute("pageList", PageUtil.getPage(minPage));
      request.setAttribute("curPage", Integer.valueOf(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(",");
      this.gpsService.rtkanchor_delete(checkVal);
   }
   @ResponseBody
   @RequestMapping(
         value = {"/rtkanchor_deletea.do"},
         method = {RequestMethod.POST, RequestMethod.GET}
   )
   public void rtkanchor_deletea(HttpServletRequest request) {
      this.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");
      List warningSummaryList;
      if (!"".equals(input) && input != null) {
         int curPage = 1;
         List<Integer> pageList = new ArrayList();
         warningSummaryList = this.gpsService.findrtkanchor3(input);
         pageList.add(1);
         json.put("dataList", warningSummaryList);
         json.put("pageList", pageList);
         json.put("curPage", Integer.valueOf(curPage));
      } else {
         String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
         tb_tag tag = (tb_tag)JSONObject.toBean(JSONObject.fromObject(jsonString), tb_tag.class);
         input = tag.getTag_id();
         warningSummaryList = this.gpsService.findrtkanchor3(input);
         if (warningSummaryList.size() > 0) {
            json.put("result", warningSummaryList.get(0));
         } else {
            json.put("result", "null");
         }
      }
      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 = this.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 = this.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();
   }
}