From 52cffc4ab8e9787a6f233295502c7c9788dddae1 Mon Sep 17 00:00:00 2001
From: fxl <473369119@qq.com>
Date: 星期二, 07 三月 2023 10:45:17 +0800
Subject: [PATCH] 3.7

---
 src/main/java/com/hxzkoa/controller/SysSettingController.java |  152 +++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 136 insertions(+), 16 deletions(-)

diff --git a/src/main/java/com/hxzkoa/controller/SysSettingController.java b/src/main/java/com/hxzkoa/controller/SysSettingController.java
index 4db4b46..ee16138 100644
--- a/src/main/java/com/hxzkoa/controller/SysSettingController.java
+++ b/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("鎵ц浜�");
 	}
 }

--
Gitblit v1.10.0