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_gps;
|
import com.hxzkoa.json.tb_realocation;
|
import com.hxzkoa.json.tb_system;
|
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;
|
import com.hxzkoa.util.AddTxt;
|
import com.hxzkoa.util.Config;
|
import com.hxzkoa.util.ExcelUtils;
|
import com.hxzkoa.util.ModifyConfig;
|
import com.hxzkoa.util.PageUtil;
|
|
import net.sf.json.JSONObject;
|
|
@Controller
|
public class GpsController {
|
@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 })
|
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 })
|
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 })
|
public String huifang(HttpServletRequest request) {
|
String toPage = "forward:/hxzk/baidu.jsp";
|
return toPage;
|
}
|
|
@RequestMapping(value = "/huifangdodo.do",method = { RequestMethod.POST, RequestMethod.GET })
|
public List<String> huifangdodo(HttpServletRequest request) {
|
List<String> sb = gpsService.txt();
|
return sb;
|
}
|
|
@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);
|
request.setAttribute("gpsManagementList", gpsManagementList);
|
List<tb_system> settingList = sysSettingService.getSetting();
|
request.setAttribute("settingList", settingList);
|
int curPage = 1;
|
int count = gpsService.getGpsManagementCount();
|
int minPage = PageUtil.getMinPage(count);
|
request.setAttribute("pageList", PageUtil.getPage(minPage));
|
request.setAttribute("curPage", curPage);
|
return toPage;
|
}
|
|
@ResponseBody
|
@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 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_gps> gpsManagementList = gpsService.getGpsManagement(page);
|
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
|
JSONObject json = new JSONObject();
|
json.put("dataList", gpsManagementList);
|
json.put("pageList", pageList);
|
json.put("curPage", page);
|
return json.toString();
|
}
|
|
@ResponseBody
|
@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);
|
pageList.add(1);
|
JSONObject json = new JSONObject();
|
json.put("dataList", gpsManagementList);
|
json.put("pageList", pageList);
|
json.put("curPage", curPage);
|
return json.toString();
|
}
|
|
@ResponseBody
|
@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";
|
Udp_Out.udp_to_cs(xieyi);
|
}
|
}
|
|
@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","电量","更新时间"};
|
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();
|
excel.export(out);
|
out.flush();
|
out.close();
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return toPage;
|
}
|
|
@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);
|
mv.setViewName("redirect:/gpsManagement.do");
|
return mv;
|
}
|
|
@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);
|
request.setAttribute("historicalLocationList", trackList);
|
int curPage = 1;
|
int count = gpsService.getgpsRealTimeLocationCount(currentDate);
|
int minPage = PageUtil.getMinPage(count);
|
request.setAttribute("pageList", PageUtil.getPage(minPage));
|
request.setAttribute("curPage", curPage);
|
request.setAttribute("perPage", perPage);
|
// 处理日期查询列表
|
List<String> trackDateList = gpsService.getgpsTrackDateList();
|
List<String> trackDateReList = new ArrayList<String>();
|
trackDateReList.add(currentDate);
|
for (int i = 0; i < trackDateList.size(); i++) {
|
String listdate = 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 })
|
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");
|
String curPageStr = request.getParameter("curPage");
|
String date = request.getParameter("date");
|
int count = 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) {
|
pageStr = 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_realocation> historicalLocationList =
|
// locationService.getRealTimeLocation(page,perPage);
|
List<tb_gps> trackList = gpsService.getTrack(date, page, perPage);
|
List<Integer> pageList = PageUtil.getPage(PageUtil.getLocPage(page, curPage), page, minPage);
|
JSONObject json = new JSONObject();
|
json.put("dataList", trackList);
|
json.put("pageList", pageList);
|
json.put("curPage", page);
|
return json.toString();
|
}
|
|
@ResponseBody
|
@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);
|
}
|
|
@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");
|
gpsService.realTimegpsLocation_deleteAll(date);
|
}
|
|
@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");
|
String zhuangtai = gpsService.getpersontagid(tagid);
|
return zhuangtai;
|
}
|
|
@ResponseBody
|
@RequestMapping(value = "/getstatusss.do", method = { RequestMethod.POST, RequestMethod.GET })
|
public String getstatusss(HttpServletRequest request) {
|
String tagid = "8888";
|
//System.out.print("执行了");
|
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;
|
List<Integer> pageList = new ArrayList<Integer>();
|
List<tb_gps> historicalLocationList = gpsService.searchRealTimegpsLocation(input,date);
|
pageList.add(1);
|
JSONObject json = new JSONObject();
|
json.put("dataList", historicalLocationList);
|
json.put("pageList", pageList);
|
json.put("curPage", curPage);
|
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";
|
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<Object[]> dataList = objectToArray(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();
|
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(String.valueOf(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_power());
|
words.add(gps.getAddtime());
|
String[] array = words.toArray(new String[0]);
|
reList.add(array);
|
}
|
return reList;
|
}
|
|
}
|
