| | |
| | | |
| | | import com.hxzkoa.json.tb_achor; |
| | | import com.hxzkoa.json.tb_anchor_nearby; |
| | | import com.hxzkoa.json.tb_anchorhistory; |
| | | import com.hxzkoa.json.tb_tongbuanchor; |
| | | import com.hxzkoa.json.tb_wifi; |
| | | import com.hxzkoa.services.AnchorService; |
| | |
| | | return toPage; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagementaa.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public JSONObject anchorManagementaa(HttpServletRequest request) { |
| | | JSONObject json = new JSONObject(); |
| | | List<tb_achor> achorManagementList = anchorService.getAnchorManagement(1); |
| | | int curPage = 1; |
| | | int count = anchorService.getAnchorManagementCount(); |
| | | int minPage = PageUtil.getMinPage(count); |
| | | json.put("dataList", achorManagementList); |
| | | json.put("pageList", PageUtil.getPage(minPage)); |
| | | json.put("curPage", curPage); |
| | | return json; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagementa.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public JSONObject anchorManagementa(HttpServletRequest request) { |
| | | JSONObject json = new JSONObject(); |
| | | List<tb_achor> achorManagementList = anchorService.getAnchorManagementa(); |
| | | for (int i=0; i<achorManagementList.size(); i++) { |
| | | if (!achorManagementList.get(i).getPOSX().equals("") && !achorManagementList.get(i).getPOSY().equals("")) { |
| | | achorManagementList.get(i).setPOSX(""+((double)Math.round(Double.parseDouble(achorManagementList.get(i).getPOSX()))/100)); |
| | | achorManagementList.get(i).setPOSY(""+((double)Math.round(Double.parseDouble(achorManagementList.get(i).getPOSY()))/100)); |
| | | } |
| | | } |
| | | json.put("dataList", achorManagementList); |
| | | return json; |
| | | } |
| | | |
| | | @RequestMapping(value = "/anchor_bw_status.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public void anchor_bw_status(HttpServletRequest request) throws IOException { |
| | | String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset()); |
| | |
| | | tongbu.setState("0"); |
| | | anchorService.syncConfiguration_add(tongbu); |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_adda.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public String anchorManagement_adda(HttpServletRequest request) throws IOException { |
| | | tb_achor anchor = new tb_achor(); |
| | | String aaa = ""; |
| | | String anchorid = request.getParameter("anchorid"); |
| | | if (("").equals(anchorid) || anchorid == null) { |
| | | String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset()); |
| | | anchor = (tb_achor) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_achor.class); |
| | | List<tb_achor> searchAnchorList = anchorService.searchAnchorManagement(anchor.getAnchorid()); |
| | | if (searchAnchorList.size() == 0) { |
| | | anchorService.anchorManagement_addaa(anchor); |
| | | } |
| | | } else { |
| | | anchor.setAnchorid(anchorid); |
| | | // anchor.setPOSX(request.getParameter("POSX")); |
| | | // anchor.setPOSY(request.getParameter("POSY")); |
| | | anchor.setPOSX("0"); |
| | | anchor.setPOSY("0"); |
| | | anchor.setPOSZ(request.getParameter("POSZ")); |
| | | // anchor.setLayer(request.getParameter("layer")); |
| | | // anchor.setZu(request.getParameter("zu")); |
| | | // anchor.setLiangcheng(request.getParameter("liangcheng")); |
| | | // anchor.setAnchorip(request.getParameter("anchorip")); |
| | | anchor.setLayer("0"); |
| | | anchor.setZu("0"); |
| | | anchor.setLiangcheng("0"); |
| | | // if(("").equals(anchor.getLiangcheng())){ |
| | | // anchor.setLiangcheng("100000"); |
| | | // } |
| | | anchor.setAnchorip("0"); |
| | | anchor.setAnchormode("1"); |
| | | anchor.setVersion(Config.getVersion()); |
| | | // 如果该anchorid不存在,新增一条 |
| | | List<tb_achor> searchAnchorList = anchorService.searchAnchorManagement(anchorid); |
| | | if (searchAnchorList.size() == 0) { |
| | | // aaa = anchorService.anchorManagement_addaa(anchor); |
| | | String xieyi = "BSTOCS1,ADDANC,"+anchor.getAnchorid()+","+anchor.getPOSX()+","+anchor.getPOSY()+","+anchor.getPOSZ()+","+anchor.getLayer()+","+anchor.getZu()+","+anchor.getLiangcheng()+","+anchor.getAnchorip()+",END"; |
| | | System.out.print("++++++++"+xieyi); |
| | | Udp_Out.udp_to_cs(xieyi); |
| | | aaa = "1"; |
| | | } else { |
| | | aaa = "基站ID已存在"; |
| | | } |
| | | } |
| | | //新增临近基站和同步基站 |
| | | // tb_anchor_nearby nearby = new tb_anchor_nearby(); |
| | | // nearby.setAnchorid(anchor.getAnchorid()); |
| | | // nearby.setQiehuan("0"); |
| | | // anchorService.proximityConfiguration_add(nearby); |
| | | // tb_tongbuanchor tongbu = new tb_tongbuanchor(); |
| | | // tongbu.setAnchorid(anchor.getAnchorid()); |
| | | // tongbu.setType(anchor.getAnchormode()); |
| | | // tongbu.setState("0"); |
| | | // anchorService.syncConfiguration_add(tongbu); |
| | | return aaa; |
| | | } |
| | | |
| | | @RequestMapping(value = "/anchorManagement_modify.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public void anchorManagement_modify(HttpServletRequest request) { |
| | |
| | | tongbu.setType(anchor.getAnchormode()); |
| | | anchorService.syncConfiguration_modify(tongbu); |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_modifya.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public String anchorManagement_modifya(HttpServletRequest request) { |
| | | tb_achor anchor = new tb_achor(); |
| | | anchor.setAnchorid(request.getParameter("anchorid")); |
| | | anchor.setPOSX(request.getParameter("POSX")); |
| | | anchor.setPOSY(request.getParameter("POSY")); |
| | | anchor.setPOSZ(request.getParameter("POSZ")); |
| | | anchor.setLayer(request.getParameter("layer")); |
| | | anchor.setZu(request.getParameter("zu")); |
| | | anchor.setLiangcheng(request.getParameter("liangcheng")); |
| | | anchor.setAnchorip(request.getParameter("anchorip")); |
| | | // int aaa = anchorService.anchorManagement_modifyaa(anchor); |
| | | String xieyi = "BSTOCS1,ALTERANC,"+anchor.getAnchorid()+","+anchor.getPOSX()+","+anchor.getPOSY()+","+anchor.getPOSZ()+","+anchor.getLayer()+","+anchor.getZu()+","+anchor.getLiangcheng()+","+anchor.getAnchorip()+",END"; |
| | | Udp_Out.udp_to_cs(xieyi); |
| | | //修改临近基站和同步基站 |
| | | // tb_tongbuanchor tongbu = new tb_tongbuanchor(); |
| | | // tongbu.setAnchorid(anchor.getAnchorid()); |
| | | // tongbu.setType(anchor.getAnchormode()); |
| | | // anchorService.syncConfiguration_modify(tongbu); |
| | | return "1"; |
| | | } |
| | | |
| | | @RequestMapping(value = "/anchorManagement_heart.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public void anchorManagement_heart(HttpServletRequest request) throws IOException { |
| | |
| | | anchorService.anchorProx_delete(anchorid); |
| | | anchorService.anchorSync_delete(anchorid); |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_deletea.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public String anchorManagement_deletea(HttpServletRequest request) { |
| | | String checkValStr = request.getParameter("checkVal"); |
| | | checkValStr = checkValStr.replaceAll("\"", ""); |
| | | String[] checkVal = checkValStr.split(","); |
| | | // String[] anchorid = new String[checkVal.length]; |
| | | // for (int i = 0; i < checkVal.length; i++) { |
| | | // List<tb_achor> anchors = anchorService.searchidAnchorManagement(checkVal[i]); |
| | | // System.out.print(anchors.get(0).getAnchorid()); |
| | | // anchorid[i] = anchors.get(0).getAnchorid(); |
| | | // } |
| | | for(int i = 0; i < checkVal.length; i++) { |
| | | String xieyi = "BSTOCS1,DELETEANC,"+checkVal[i]+",END"; |
| | | Udp_Out.udp_to_cs(xieyi); |
| | | } |
| | | // int aaa = anchorService.anchorManagement_deletea(checkVal); |
| | | // anchorService.anchorProx_delete(checkVal); |
| | | // anchorService.anchorSync_delete(checkVal); |
| | | return "1"; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | |
| | | String xieyi = "BSTOCS1,DELETEALLANC,END"; |
| | | Udp_Out.udp_to_cs(xieyi); |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public String anchorManagement_deleteAlla(HttpServletRequest request) { |
| | | // int aaa = anchorService.anchorManagement_deleteAll(); |
| | | String xieyi = "BSTOCS1,DELETEALLANC,END"; |
| | | Udp_Out.udp_to_cs(xieyi); |
| | | return "1"; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | |
| | | } |
| | | return json.toString(); |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_searcha.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public JSONObject anchorManagement_searcha(HttpServletRequest request) throws IOException { |
| | | JSONObject json = new JSONObject(); |
| | | String input = request.getParameter("anchorid"); |
| | | if (("").equals(input) || input == null) { |
| | | String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset()); |
| | | tb_achor anchor = (tb_achor) JSONObject.toBean(JSONObject.fromObject(jsonString), tb_achor.class); |
| | | input = anchor.getAnchorid(); |
| | | List<tb_achor> anchorManagementList = anchorService.searchAnchorManagementaa(input); |
| | | if (anchorManagementList.size()>0){ |
| | | json.put("result", anchorManagementList.get(0)); |
| | | } else { |
| | | json.put("result", "null"); |
| | | } |
| | | } else { |
| | | List<tb_achor> anchorManagementList = anchorService.searchAnchorManagementaa(input); |
| | | json.put("dataList", anchorManagementList); |
| | | } |
| | | return json; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | |
| | | } |
| | | for (MultipartFile file : files) { |
| | | file.transferTo(new File(filePath + file.getOriginalFilename())); |
| | | System.out.print(file.getOriginalFilename()); |
| | | ////System.out.print(file.getOriginalFilename()); |
| | | } |
| | | } catch (IOException e) { |
| | | e.printStackTrace(); |
| | |
| | | String anchormode = sheet.getCell(5, i).getContents(); |
| | | String anchorip = sheet.getCell(6, i).getContents(); |
| | | if (!("").equals(anchorid)) { |
| | | tb_achor anchor = new tb_achor(); |
| | | anchor.setAnchorid(anchorid); |
| | | anchor.setPOSX(POSX); |
| | | anchor.setPOSY(POSY); |
| | | anchor.setPOSZ(POSZ); |
| | | anchor.setLayer(layer); |
| | | anchor.setZu("无"); |
| | | anchor.setLiangcheng("无"); |
| | | anchor.setAnchormode(anchormode); |
| | | anchor.setAnchorip(anchorip); |
| | | anchor.setVersion(Config.getVersion()); |
| | | result = anchorService.anchorManagement_add(anchor); |
| | | List<tb_achor> anchorManagementList = anchorService.searchAnchorManagement(anchorid); |
| | | if (anchorManagementList.size() == 0) { |
| | | tb_achor anchor = new tb_achor(); |
| | | anchor.setAnchorid(anchorid); |
| | | anchor.setPOSX(POSX); |
| | | anchor.setPOSY(POSY); |
| | | anchor.setPOSZ(POSZ); |
| | | anchor.setLayer(layer); |
| | | anchor.setZu("无"); |
| | | anchor.setLiangcheng("无"); |
| | | anchor.setAnchormode(anchormode); |
| | | anchor.setAnchorip(anchorip); |
| | | anchor.setVersion(Config.getVersion()); |
| | | result = anchorService.anchorManagement_add(anchor); |
| | | String xieyi = "BSTOCS1,ADDANC,"+anchor.getAnchorid()+","+anchor.getPOSX()+","+anchor.getPOSY()+","+anchor.getPOSZ()+","+anchor.getLayer()+","+anchor.getZu()+","+anchor.getLiangcheng()+","+anchor.getAnchorip()+",END"; |
| | | Udp_Out.udp_to_cs(xieyi); |
| | | } |
| | | } |
| | | } |
| | | // 释放资源 |
| | |
| | | } |
| | | return nn; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/anchorhistory.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public JSONObject anchorhistory(HttpServletRequest request) { |
| | | JSONObject json = new JSONObject(); |
| | | List<tb_anchorhistory> achorManagementList = anchorService.getAnchorhistory(); |
| | | json.put("dataList", achorManagementList); |
| | | return json; |
| | | } |
| | | |
| | | @ResponseBody |
| | | @RequestMapping(value = "/findidanchorhistory.do", method = { RequestMethod.POST, RequestMethod.GET }) |
| | | public JSONObject anchorhistoryaa(HttpServletRequest request) { |
| | | String date = request.getParameter("date"); |
| | | StringBuffer string = new StringBuffer(date); |
| | | String insert = string.insert(4, "-").toString(); |
| | | JSONObject json = new JSONObject(); |
| | | List<tb_anchorhistory> achorManagementList = anchorService.getidAnchorhistory(insert); |
| | | json.put("dataList", achorManagementList); |
| | | return json; |
| | | } |
| | | } |