3.7

fxl

2023-03-07 52cffc4ab8e9787a6f233295502c7c9788dddae1

 src/main/java/com/hxzkoa/controller/SysSettingController.java

@@ -34,6 +34,7 @@
import com.hxzkoa.json.tb_bsbaowen;
import com.hxzkoa.json.tb_forward_data;
import com.hxzkoa.json.tb_map;
import com.hxzkoa.json.tb_nav;
import com.hxzkoa.json.tb_suanfa;
import com.hxzkoa.json.tb_system;
import com.hxzkoa.json.tb_tag;
@@ -41,6 +42,7 @@
import com.hxzkoa.json.tb_yuan_shi_bao_wen;
import com.hxzkoa.services.MapService;
import com.hxzkoa.services.SysSettingService;
import com.hxzkoa.services.ZhwService;
import com.hxzkoa.udp.Panduan;
import com.hxzkoa.udp.Udp_Out;
/*import com.hxzkoa.udp.Udp_Receive;*/
@@ -61,6 +63,8 @@
   private SysSettingService sysSettingService;
   @Autowired
   private MapService mapService;
   @Autowired
   private ZhwService zhwService;
   
   @ResponseBody
   @RequestMapping(value = "/to_cs_start_.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -254,6 +258,15 @@
      request.setAttribute("curPage", curPage);
      return toPage;
   }
	
   @ResponseBody
   @RequestMapping(value = "/userManagementa.do", method = { RequestMethod.POST, RequestMethod.GET })
   public JSONObject userManagementa(HttpServletRequest request) {
      List<tb_user> userManagementList = sysSettingService.getuserManagement2();
      JSONObject json = new JSONObject();
      json.put("dataList", userManagementList);
      return json;
   }

   @ResponseBody
   @RequestMapping(value = "/userManagement_search.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -269,6 +282,16 @@
      json.put("curPage", curPage);
      return json.toString();
   }
	
   @ResponseBody
   @RequestMapping(value = "/userManagement_searcha.do", method = { RequestMethod.POST, RequestMethod.GET })
   public JSONObject userManagement_searcha(HttpServletRequest request) {
      String input = request.getParameter("username");
      List<tb_user> userManagementList = sysSettingService.searchuserManagement(input);
      JSONObject json = new JSONObject();
      json.put("dataList", userManagementList);
      return json;
   }

   @ResponseBody
   @RequestMapping(value = "/userManagement_page.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -312,6 +335,7 @@
            words.add(user.getDeleteall());
            words.add(user.getAlertq());
            words.add(user.getJustlook());
            words.add(user.getFenceq());
            words.add(String.valueOf(user.getAddtime()));
            String[] array = words.toArray(new String[0]);
            reList.add(array);
@@ -324,7 +348,7 @@
   public String userManagement_export(HttpServletRequest request, HttpServletResponse response) {
      String toPage = "forward:/hxzk/sysSetting/userManagement.jsp";
      List<tb_user> userManagementList = sysSettingService.getuserManagement();
      String[] rowName = { "序号","用户","级别","删除","修改","全部删除","仅观看","添加时间 "};
      String[] rowName = { "序号","用户","级别","删除","修改","全部删除","仅观看","新增","添加时间"};
      List<Object[]> dataList = objectToArray(userManagementList);
      ExcelUtils excel = new ExcelUtils("用户管理", rowName, dataList);
      OutputStream out;
@@ -359,13 +383,46 @@
      String[] checkVal = checkValStr.split(",");
      sysSettingService.userManagement_delete(checkVal);
   }
	
   @ResponseBody
   @RequestMapping(value = "/userManagement_deletea.do", method = { RequestMethod.POST, RequestMethod.GET })
   public int userManagement_deletea(HttpServletRequest request) {
      String checkValStr = request.getParameter("checkVal");
      checkValStr = checkValStr.replaceAll("\"", "");
      String[] checkVal = checkValStr.split(",");
      int aaa = sysSettingService.userManagement_deletea(checkVal);
      return aaa;
   }

   @ResponseBody
   @RequestMapping(value = "/userManagement_deleteAll.do", method = { RequestMethod.POST, RequestMethod.GET })
   public void userManagement_deleteAll(HttpServletRequest request) {
      sysSettingService.userManagement_deleteAll();
   }
	
   @ResponseBody
   @RequestMapping(value = "/userManagement_deleteAlla.do", method = { RequestMethod.POST, RequestMethod.GET })
   public int userManagement_deleteAlla(HttpServletRequest request) {
      int aaa = sysSettingService.userManagement_deleteAlla();
      return aaa;
   }

   @ResponseBody
   @RequestMapping(value = "/userManagement_adda.do", method = { RequestMethod.POST, RequestMethod.GET })
   public int userManagement_adda(HttpServletRequest request) {
      tb_user user = new tb_user();
      user.setUsername(request.getParameter("username"));
      user.setPassword(request.getParameter("password"));
      user.setSuperuser(request.getParameter("superuser"));
      user.setDeleteq(request.getParameter("deleteq"));
      user.setAlertq(request.getParameter("alertq"));
      user.setDeleteall(request.getParameter("deleteall"));
      user.setJustlook(request.getParameter("justlook"));
      int bb = sysSettingService.userManagement_add(user);
      return bb;
   }
	
   @ResponseBody
   @RequestMapping(value = "/userManagement_add.do", method = { RequestMethod.POST, RequestMethod.GET })
   public void userManagement_add(HttpServletRequest request) {
      tb_user user = new tb_user();
@@ -376,9 +433,27 @@
      user.setAlertq(request.getParameter("alertq"));
      user.setDeleteall(request.getParameter("deleteall"));
      user.setJustlook(request.getParameter("justlook"));
      user.setFenceq(request.getParameter("insert"));
      sysSettingService.userManagement_add(user);
   }

   @ResponseBody
   @RequestMapping(value = "/userManagement_modifya.do", method = { RequestMethod.POST, RequestMethod.GET })
   public int userManagement_modifya(HttpServletRequest request) {
      tb_user user = new tb_user();
      user.setId(Integer.parseInt(request.getParameter("id")));
      user.setUsername(request.getParameter("username"));
      user.setPassword(request.getParameter("password"));
      user.setSuperuser(request.getParameter("superuser"));
      user.setDeleteq(request.getParameter("deleteq"));
      user.setAlertq(request.getParameter("alertq"));
      user.setDeleteall(request.getParameter("deleteall"));
      user.setJustlook(request.getParameter("justlook"));
      int bb = sysSettingService.userManagement_modify(user);
      return bb;
   }
	
   @ResponseBody
   @RequestMapping(value = "/userManagement_modify.do", method = { RequestMethod.POST, RequestMethod.GET })
   public void userManagement_modify(HttpServletRequest request) {
      tb_user user = new tb_user();
@@ -390,6 +465,7 @@
      user.setAlertq(request.getParameter("alertq"));
      user.setDeleteall(request.getParameter("deleteall"));
      user.setJustlook(request.getParameter("justlook"));
      user.setFenceq(request.getParameter("insert"));
      sysSettingService.userManagement_modify(user);
   }

@@ -398,6 +474,8 @@
      String toPage = "forward:hxzk/sysSetting/sysSetting.jsp";
      List<tb_system> settingList = sysSettingService.getSetting();
      List<tb_map> maplist = mapService.getMapManagement();
      List<tb_nav> navList = zhwService.getnav();
      request.setAttribute("dataList", navList);
      request.setAttribute("settingList", settingList);
      request.setAttribute("maplist", maplist);
      return toPage;
@@ -438,7 +516,7 @@
      setting.setOffView(request.getParameter("offView"));
      setting.setAnckicon(request.getParameter("anckicon"));
      setting.setGas_show(request.getParameter("gas_show"));
      setting.setQuiet(request.getParameter("quiet"));
//    setting.setQuiet(request.getParameter("quiet"));
      setting.setReal_trak_time(request.getParameter("real_trak_time"));
      setting.setReal_trak_color(request.getParameter("real_trak_color"));
      setting.setYulan_map(request.getParameter("yulan_map_tu"));
@@ -449,7 +527,49 @@
      setting.setGas_hz(request.getParameter("gas_hz"));
      setting.setRssid(request.getParameter("rssid"));
      setting.setFence_show(request.getParameter("fence_show"));
      tb_nav nav = new tb_nav();
      nav.setLabel(request.getParameter("label"));
      nav.setAchor(request.getParameter("achor"));
      nav.setGps(request.getParameter("gps"));
      nav.setFence(request.getParameter("fence"));
      nav.setWarning(request.getParameter("warning"));
      nav.setHistory(request.getParameter("history"));
      nav.setAttendance(request.getParameter("attendance"));
      nav.setBasiclnfo(request.getParameter("basiclnfo"));
      nav.setVideo(request.getParameter("video"));
      nav.setGas(request.getParameter("gas"));
      sysSettingService.sysSetting_modify(setting);
      zhwService.updatenav(nav);
   }
	
   @ResponseBody
   @RequestMapping(value = "/sysSetting_modifya.do", method = { RequestMethod.POST, RequestMethod.GET })
   public String sysSetting_modifya(HttpServletRequest request) {
      tb_system setting = new tb_system();
      setting.setUdpAdress(request.getParameter("ip"));
      setting.setBaoliu20(request.getParameter("port"));
      setting.setBaoliu13(request.getParameter("sxtime"));
      setting.setBaoliu14(request.getParameter("tagupp"));
      setting.setBaoliu15(request.getParameter("fenceupp"));
      setting.setReal_trak_time(request.getParameter("realtraktime"));
      setting.setFence_show(request.getParameter("fenceshow"));
      setting.setViewAnckid(request.getParameter("viewAnckid"));
      setting.setBaoliu16(request.getParameter("showtracks"));
      setting.setBaoliu17(request.getParameter("shownews"));
      setting.setYulan_map(request.getParameter("map"));
      String xieyi = "BSTOCS1,U1ALTERSYSTEM,"+setting.getUdpAdress()+","+setting.getBaoliu20()+","+setting.getBaoliu13()+","+setting.getBaoliu14()+","+setting.getBaoliu15()+","+setting.getReal_trak_time()+","+setting.getFence_show()+","+setting.getViewAnckid()+","+setting.getBaoliu16()+","+setting.getBaoliu17()+","+setting.getYulan_map()+",END";
      Udp_Out.udp_to_cs(xieyi);
      int aaa = sysSettingService.sysSetting_modifya(setting);
      return ""+aaa;
   }
	
   @ResponseBody
   @RequestMapping(value = "/getSysSettinga.do", method = { RequestMethod.POST, RequestMethod.GET })
   public JSONObject getSysSettinga(HttpServletRequest request) {
      JSONObject json = new JSONObject();
      List<tb_system> settingList = sysSettingService.getSetting();
      json.put("dataList", settingList);
      return json;
   }

   @RequestMapping(value = "/algorithmConfiguration.do", method = { RequestMethod.POST, RequestMethod.GET })
@@ -500,7 +620,7 @@
   @RequestMapping(value = "/getMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
   protected void doPost(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print("result" + jsonString);
      //System.out.print("result" + jsonString);
      JSONObject json_test = JSONObject.fromObject(jsonString);
      String result = json_test.getString("result");
      try {
@@ -566,7 +686,7 @@
   @RequestMapping(value = "/yuanshiMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
   protected void yuanshiMessage(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print("result" + jsonString);
      //System.out.print("result" + jsonString);
      JSONObject json_test = JSONObject.fromObject(jsonString);  
      String result = json_test.getString("result");
      try {
@@ -654,7 +774,7 @@
   @RequestMapping(value = "/debugMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
   protected void debugMessage(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print("result" + jsonString);
      //System.out.print("result" + jsonString);
      JSONObject json_test = JSONObject.fromObject(jsonString);  
      String result = json_test.getString("result");
      try {
@@ -698,7 +818,7 @@
   @RequestMapping(value = "/zhuceMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
   protected void zhuceMessage(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print("result" + jsonString);
      //System.out.print("result" + jsonString);
      JSONObject json_test = JSONObject.fromObject(jsonString);  
      String result = json_test.getString("result");
      try {
@@ -742,7 +862,7 @@
      @RequestMapping(value = "/mysqlMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
      protected void mysqlMessage(HttpServletRequest request) throws IOException {
         String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
         System.out.print("result" + jsonString);
         //System.out.print("result" + jsonString);
         JSONObject json_test = JSONObject.fromObject(jsonString);  
         String result = json_test.getString("result");
         try {
@@ -787,7 +907,7 @@
   @RequestMapping(value = "/gasMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
   protected void gasMessage(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print("result" + jsonString);
      //System.out.print("result" + jsonString);
      JSONObject json_test = JSONObject.fromObject(jsonString);  
      String result = json_test.getString("result");
      try {
@@ -831,7 +951,7 @@
   @RequestMapping(value = "/HEXMessage.do", method = { RequestMethod.POST, RequestMethod.GET })
   protected void HEXMessage(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print("result" + jsonString);
      //System.out.print("result" + jsonString);
      JSONObject json_test = JSONObject.fromObject(jsonString);  
      String result = json_test.getString("result");
      try {
@@ -907,7 +1027,7 @@
      String result = jsonResult.getString("result");
      String wifi_model = sysSettingService.getSetting().get(0).getWifi_mdel();
      List<tb_forward_data> messageTransferList = sysSettingService.getALLMessageTransfer(dataType);
      System.out.print(messageTransferList);
      //System.out.print(messageTransferList);
      DatagramPacket packet = null;
      DatagramSocket socket = new DatagramSocket();
      if (messageTransferList.size() > 0) {
@@ -1048,7 +1168,7 @@
         try {
            socket.send(packet);
            Thread.sleep(100);
            System.out.print("udp发送成功");
            //System.out.print("udp发送成功");
            
         } catch (IOException e) {
            e.printStackTrace();
@@ -1101,7 +1221,7 @@
//    String password = sysSettingService.getSetting().get(0).getDatapass();
//     String cmd = "cmd /c "+ mysqlDumpPath + " -uroot" + " -p" + password + " " + database + " > "
//                + filePath + database + "_" + name + ".sql";
//     System.out.print(cmd);
//     //System.out.print(cmd);
//     
//     //执行备份命令
//     try {
@@ -1122,7 +1242,7 @@
      String database =sysSettingService.getSetting().get(0).getDataname();
      String password = sysSettingService.getSetting().get(0).getDatapass();
       String cmd ="mysqldump -h "+host+" -P "+ port+ " -uroot" + " -p" + password + " " + database;
       System.out.print(cmd);
       //System.out.print(cmd);
       return savePath;
   }
   
@@ -1137,7 +1257,7 @@
         String host = Config.getMysqlHost();
          String port = Config.getMysqlPort();
         String cmd = "mysql -h "+host+" -P "+port+ " -uroot" + " -p" + password + " " + database;
         System.out.print(cmd);
         //System.out.print(cmd);
         boolean b2 = new DatabaseUtil().recover(cmd, recoverPath);
           return String.valueOf(b2);
      } else {
@@ -1158,7 +1278,7 @@
   @RequestMapping(value = "/shiyan.do", method = { RequestMethod.POST, RequestMethod.GET })
   public void shiyan(HttpServletRequest request) throws IOException {
      String jsonString = RequestUtils.getRequestJsonString(request, Config.getCharset());
      System.out.print(jsonString);
      System.out.print("执行了");
      //System.out.print(jsonString);
      //System.out.print("执行了");
   }
}