3.7

fxl

2023-03-07 52cffc4ab8e9787a6f233295502c7c9788dddae1

 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状态","卫星数","海拔高","差分站ID","电量","更新时间"};
      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状态","卫星数","海拔高","差分站ID","电量","更新时间"};
      List<Object[]> dataList = objectToArray(historicalLocationList);
      System.out.print(dataList.get(0));
      String[] rowName = {"序号", "设备编号","纬度","经度","GPS状态","卫星数","海拔高","差分站ID","水平精度因子","差分时间","电量","更新时间"};
      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();
      }

}