From 961ec523a26da1a8c84e16e1f337e0705268d19d Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Thu, 23 Sep 2021 15:08:38 +0800
Subject: [PATCH] 1.附件

---
 src/main/java/org/springblade/modules/information/controller/InformationController.java |  303 +++++++++++++++++++++++++++++++-------------------
 1 files changed, 186 insertions(+), 117 deletions(-)

diff --git a/src/main/java/org/springblade/modules/information/controller/InformationController.java b/src/main/java/org/springblade/modules/information/controller/InformationController.java
index 7e56b0c..a1b52db 100644
--- a/src/main/java/org/springblade/modules/information/controller/InformationController.java
+++ b/src/main/java/org/springblade/modules/information/controller/InformationController.java
@@ -803,8 +803,8 @@
 	 * 保安员统计
 	 */
 	@PostMapping("/selectLi")
-	public R<IPage> selectLi(String jurisdiction, String deptid,String stats, Query query) {
-		IPage list = informationService.selectLi(Condition.getPage(query), jurisdiction, deptid,stats);
+	public R<IPage> selectLi(String jurisdiction, String deptid, String stats, Query query) {
+		IPage list = informationService.selectLi(Condition.getPage(query), jurisdiction, deptid, stats);
 		return R.data(list);
 	}
 
@@ -864,8 +864,8 @@
 	 * 保安员详情
 	 */
 	@PostMapping("/selectUIn")
-	public R<IPage> selectUIn(String deptid, String name, String hold, String photo, String examinationtype, String dispatch, String soil,Query query) {
-		IPage list = informationService.selectUIn(Condition.getPage(query),deptid, name, hold, photo, examinationtype, dispatch, soil);
+	public R<IPage> selectUIn(String deptid, String name, String hold, String photo, String examinationtype, String dispatch, String soil, Query query) {
+		IPage list = informationService.selectUIn(Condition.getPage(query), deptid, name, hold, photo, examinationtype, dispatch, soil);
 		return R.data(list);
 	}
 
@@ -1015,7 +1015,7 @@
 			if (a <= 0) {
 				continue;
 			} else if (a >= 19 && a < 35) {
-				qcount ++;
+				qcount++;
 			} else if (a >= 36 && a < 59) {
 				zcount++;
 			} else {
@@ -1023,12 +1023,11 @@
 			}
 		}
 		Map map = new HashMap();
-		map.put("qcount",qcount);
-		map.put("zcount",zcount);
-		map.put("lcount",lcount);
+		map.put("qcount", qcount);
+		map.put("zcount", zcount);
+		map.put("lcount", lcount);
 		return R.data(map);
 	}
-
 
 
 	/**
@@ -1041,7 +1040,7 @@
 		//查出所有辖区
 		List<Map<Object, Object>> list = informationService.selJur();
 		List<Map<String, Object>> lists = new ArrayList<>();
-		for (int i = 0; i < list.size(); i++){
+		for (int i = 0; i < list.size(); i++) {
 			Map<String, Object> map = new HashMap<String, Object>();
 			Map<String, Object> mapc = new HashMap<String, Object>();
 			String id = list.get(i).get("id").toString();
@@ -1054,11 +1053,11 @@
 			}
 			String substring = strArrays.substring(0, strArrays.length() - 1);
 			List<Map<Object, Object>> maps = informationService.seleJuList(substring);
-			mapc.put("confess",maps.get(0).get("num"));
-			mapc.put("staff",maps.get(1).get("num"));
-			mapc.put("security",maps.get(2).get("num"));
-			mapc.put("armed",maps.get(3).get("num"));
-			mapc.put("region",maps.get(4).get("num"));
+			mapc.put("confess", maps.get(0).get("num"));
+			mapc.put("staff", maps.get(1).get("num"));
+			mapc.put("security", maps.get(2).get("num"));
+			mapc.put("armed", maps.get(3).get("num"));
+			mapc.put("region", maps.get(4).get("num"));
 			map.put("name", list.get(i).get("deptname"));
 			map.put("server", mapc);
 			lists.add(map);
@@ -1066,62 +1065,57 @@
 		return R.data(lists);
 	}
 
-	/**
-	 * 分局预警统计
-	 */
-	@PostMapping("/selectFj")
-	public R selectFj() {
-		//辖区信息
-		List<Map<Object, Object>> list = informationService.selectJur();
-		List<Map<String, Object>> lists = new ArrayList<>();
-		for (int i = 0; i < list.size(); i++) {
-			Integer count = 0;
-			Map<String, Object> map = new HashMap<String, Object>();
-			//辖区id
-			String id = list.get(i).get("id").toString();
-			//辖区名称
-			String jurname = list.get(i).get("dept_name").toString();
-			String childer = informationService.selJurchilder(id);
-			String[] split = childer.split(",");
-			String strArrays = "";
-			for (int j = 0; j < split.length; j++) {
-				strArrays += "'" + split[j] + "',";
-			}
-			String jurisdiction = strArrays.substring(0, strArrays.length() - 1);
-			//保安员表现差预警数量
-			List<Map<Object, Object>> mapbx = informationService.selectBx(jurisdiction, "", "");
-			for (int ibx = 0; ibx < mapbx.size(); ibx++) {
-				String num = mapbx.get(ibx).get("num").toString();
-				count += Integer.valueOf(num);
-			}
-			//保安员资格异常的数量
-			List<Map<Object, Object>> mapEx = informationService.selectExtype(jurisdiction, "", "");
-			for (int iex = 0; iex < mapEx.size(); iex++) {
-				String num = mapEx.get(iex).get("num").toString();
-				count += Integer.valueOf(num);
-			}
-			//保安公司未持证数量
-			List<Map<Object, String>> mapgs = informationService.selectInCount(jurisdiction, "");
-			count += mapgs.size();
-			//未缴社保数量
-			List<Map<String, Object>> mapsb = informationService.selectCs(jurisdiction, "");
-			for (int isb = 0; isb < mapsb.size(); isb++) {
-				//交社保数
-				String numjs = mapsb.get(isb).get("numj").toString();
-				Integer numj = Integer.parseInt(numjs);
-//				//单位总人数
-//				String numzs = mapsb.get(isb).get("numz").toString();
-//				Integer numz = Integer.parseInt(numzs);
-//				//统计未交社保人数
-//				int i1 = numz - numj;
-				count += numj;
-			}
-			map.put("Count", count);
-			map.put("jurname", jurname);
-			lists.add(map);
-		}
-		return R.data(lists);
-	}
+//	/**
+//	 * 分局预警统计
+//	 */
+//	@PostMapping("/selectFj")
+//	public R selectFj() {
+//		//辖区信息
+//		List<Map<Object, Object>> list = informationService.selectJur();
+//		List<Map<String, Object>> lists = new ArrayList<>();
+//		for (int i = 0; i < list.size(); i++) {
+//			Integer count = 0;
+//			Map<String, Object> map = new HashMap<String, Object>();
+//			//辖区id
+//			String id = list.get(i).get("id").toString();
+//			//辖区名称
+//			String jurname = list.get(i).get("dept_name").toString();
+//			String childer = informationService.selJurchilder(id);
+//			String[] split = childer.split(",");
+//			String strArrays = "";
+//			for (int j = 0; j < split.length; j++) {
+//				strArrays += "'" + split[j] + "',";
+//			}
+//			String jurisdiction = strArrays.substring(0, strArrays.length() - 1);
+//			//保安员表现差预警数量
+//			List<Map<Object, Object>> mapbx = informationService.selectBx(jurisdiction, "", "");
+//			for (int ibx = 0; ibx < mapbx.size(); ibx++) {
+//				String num = mapbx.get(ibx).get("num").toString();
+//				count += Integer.valueOf(num);
+//			}
+//			//保安员资格异常的数量
+//			List<Map<Object, Object>> mapEx = informationService.selectExtype(jurisdiction, "", "");
+//			for (int iex = 0; iex < mapEx.size(); iex++) {
+//				String num = mapEx.get(iex).get("num").toString();
+//				count += Integer.valueOf(num);
+//			}
+//			//保安公司未持证数量
+//			List<Map<Object, String>> mapgs = informationService.selectInCount(jurisdiction, "");
+//			count += mapgs.size();
+//			//未缴社保数量
+//			List<Map<String, Object>> mapsb = informationService.selectCs(jurisdiction, "");
+//			for (int isb = 0; isb < mapsb.size(); isb++) {
+//				//交社保数
+//				String numjs = mapsb.get(isb).get("numj").toString();
+//				Integer numj = Integer.parseInt(numjs);
+//				count += numj;
+//			}
+//			map.put("Count", count);
+//			map.put("jurname", jurname);
+//			lists.add(map);
+//		}
+//		return R.data(lists);
+//	}
 
 	/**
 	 * 首页保安持证统计接口
@@ -1146,19 +1140,19 @@
 			String deptid = strArrays.substring(0, strArrays.length() - 1);
 			Map<String, Object> map = new HashMap<String, Object>();
 			List<Map<String, Object>> objectStringMap = iDeptService.selectHold(deptid);
-			if (objectStringMap.size()==0) {
+			if (objectStringMap.size() == 0) {
 				map.put("name", list.get(i).get("deptname"));
 				map.put("cz", cznumber);
 				map.put("wcz", wcznumber);
 				lists.add(map);
 			} else {
-				for (int c=0;c<objectStringMap.size();c++){
+				for (int c = 0; c < objectStringMap.size(); c++) {
 					String cz = objectStringMap.get(c).get("cz").toString();
 					cznumber += Integer.valueOf(cz);
 					String wcz = objectStringMap.get(c).get("wcz").toString();
 					wcznumber += Integer.valueOf(wcz);
 				}
-				map.put("name",  list.get(i).get("deptname"));
+				map.put("name", list.get(i).get("deptname"));
 				map.put("cz", cznumber);
 				map.put("wcz", wcznumber);
 				lists.add(map);
@@ -1181,7 +1175,7 @@
 		Map<String, Object> map = new HashMap<String, Object>();
 		Integer count = 0;
 		List<Map<String, Object>> lists = new ArrayList<>();
-		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)){
+		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) {
 			List<Map<Object, Object>> maps = informationService.selectBx(jurisdiction, deptid, type);
 			for (int i = 0; i < maps.size(); i++) {
 				String num = maps.get(i).get("num").toString();
@@ -1190,8 +1184,7 @@
 			map.put("count", count);
 			map.put("list", maps);
 			lists.add(map);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1211,7 +1204,6 @@
 
 		return R.data(lists);
 	}
-
 
 
 	/**
@@ -1236,8 +1228,7 @@
 			map.put("count", count);
 			map.put("list", maps);
 			lists.add(map);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1263,10 +1254,10 @@
 	 */
 	@PostMapping("/selectWg")
 	public R selectWg(String jurisdiction) {
-		if (jurisdiction.equals("1372091709474910209")){
+		if (jurisdiction.equals("1372091709474910209")) {
 			List<Map<Object, Object>> list = informationService.selectWg(jurisdiction);
 			List list1 = new ArrayList();
-			int count=0;
+			int count = 0;
 			Map map = new HashMap();
 			for (int i = 0; i < list.size(); i++) {
 				//总数
@@ -1279,22 +1270,20 @@
 				String sbnums = list.get(i).get("sbnum").toString();
 				int sbnum = Integer.parseInt(sbnums);
 				//保安总人数为0
-				if (znum==0){
+				if (znum == 0) {
 					continue;
-				}
-				else {
+				} else {
 					int a = znum / 2;
-					if (cznum<=a || sbnum<=a){
+					if (cznum <= a || sbnum <= a) {
 						count++;
 						list1.add(list.get(i));
 					}
 				}
 			}
-			map.put("count",count);
-			map.put("list",list1);
+			map.put("count", count);
+			map.put("list", list1);
 			return R.data(map);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1304,7 +1293,7 @@
 			String jurisdictiond = strArrays.substring(0, strArrays.length() - 1);
 			List<Map<Object, Object>> list = informationService.selectWg(jurisdictiond);
 			List list1 = new ArrayList();
-			int count=0;
+			int count = 0;
 			Map map = new HashMap();
 			for (int i = 0; i < list.size(); i++) {
 				//总数
@@ -1317,19 +1306,18 @@
 				String sbnums = list.get(i).get("sbnum").toString();
 				int sbnum = Integer.parseInt(sbnums);
 				//保安总人数为0
-				if (znum==0){
+				if (znum == 0) {
 					continue;
-				}
-				else {
+				} else {
 					int a = znum / 2;
-					if (cznum<=a || sbnum<=a){
+					if (cznum <= a || sbnum <= a) {
 						count++;
 						list1.add(list.get(i));
 					}
 				}
 			}
-			map.put("count",count);
-			map.put("list",list1);
+			map.put("count", count);
+			map.put("list", list1);
 			return R.data(map);
 		}
 
@@ -1341,7 +1329,7 @@
 	 */
 	@PostMapping("/selectJy")
 	public R selectJy(String jurisdiction) {
-		if (jurisdiction.equals("1372091709474910209")){
+		if (jurisdiction.equals("1372091709474910209")) {
 			List<Map<Object, Object>> list = informationService.selectJy(jurisdiction);
 			List list1 = new ArrayList();
 			Map map = new HashMap();
@@ -1357,8 +1345,7 @@
 			map.put("count", count);
 			map.put("List", list1);
 			return R.data(map);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1407,8 +1394,7 @@
 			map.put("count", count);
 			map.put("List", list1);
 			return R.data(map);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1446,8 +1432,7 @@
 			List<Map<Object, Object>> maps = informationService.selectCf(jurisdiction);
 			map.put("count", maps.size());
 			return R.data(map);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1467,11 +1452,10 @@
 	 */
 	@PostMapping("/selectIn")
 	public R selectIn(String jurisdiction) {
-		if (jurisdiction.equals("1372091709474910209")|| "".equals(jurisdiction)) {
+		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) {
 			List<Map<Object, Object>> maps = informationService.selectIn(jurisdiction);
 			return R.data(maps);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1489,11 +1473,10 @@
 	 */
 	@PostMapping("/selectTb")
 	public R<IPage> selectTb(String jurisdiction, String enterpriseName, Query query) {
-		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)){
+		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) {
 			IPage list = informationService.selectTb(Condition.getPage(query), jurisdiction, enterpriseName);
 			return R.data(list);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1512,11 +1495,10 @@
 	 */
 	@PostMapping("/selectJj")
 	public R<IPage> selectJj(String jurisdiction, String enterpriseName, Query query) {
-		if (jurisdiction.equals("1372091709474910209")|| "".equals(jurisdiction)) {
+		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) {
 			IPage list = informationService.selectJj(Condition.getPage(query), jurisdiction, enterpriseName);
 			return R.data(list);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1533,12 +1515,11 @@
 	 * 业务统计情况
 	 */
 	@PostMapping("/selectYw")
-	public R<IPage> selectYw(String jurisdiction, String deptid,String stats, Query query) {
-		if (jurisdiction.equals("1372091709474910209")|| "".equals(jurisdiction)) {
+	public R<IPage> selectYw(String jurisdiction, String deptid, String stats, Query query) {
+		if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) {
 			IPage list = informationService.selectYw(Condition.getPage(query), jurisdiction, deptid, stats);
 			return R.data(list);
-		}
-		else {
+		} else {
 			String childer = informationService.selJurchilder(jurisdiction);
 			String[] split = childer.split(",");
 			String strArrays = "";
@@ -1597,4 +1578,92 @@
 		return R.data(lists);
 	}
 
+	/**
+	 * 分局预警统计
+	 */
+	@PostMapping("/selectFj")
+	public R selectFj() {
+		//辖区信息
+		List<Map<Object, Object>> list = informationService.selectJur();
+		List<Map<String, Object>> lists = new ArrayList<>();
+		for (int i = 0; i < list.size(); i++) {
+			Integer count = 0;
+			Map<String, Object> map = new HashMap<String, Object>();
+			//辖区id
+			String id = list.get(i).get("id").toString();
+			//辖区名称
+			String jurname = list.get(i).get("dept_name").toString();
+			String childer = informationService.selJurchilder(id);
+			String[] split = childer.split(",");
+			String strArrays = "";
+			for (int j = 0; j < split.length; j++) {
+				strArrays += "'" + split[j] + "',";
+			}
+			String jurisdiction = strArrays.substring(0, strArrays.length() - 1);
+			//保安员表现差预警数量
+			List<Map<Object, Object>> mapbx = informationService.selectBx(jurisdiction, "", "");
+			for (int ibx = 0; ibx < mapbx.size(); ibx++) {
+				String num = mapbx.get(ibx).get("num").toString();
+				count += Integer.valueOf(num);
+			}
+			//保安员资格异常的数量
+			List<Map<Object, Object>> mapEx = informationService.selectExtype(jurisdiction, "", "");
+			for (int iex = 0; iex < mapEx.size(); iex++) {
+				String num = mapEx.get(iex).get("num").toString();
+				count += Integer.valueOf(num);
+			}
+			//违规经营
+			List<Map<Object, Object>> listwg = informationService.selectWg(jurisdiction);
+			int countwg = 0;
+			for (int ic = 0; ic < listwg.size(); ic++) {
+				//总数
+				String znums = listwg.get(ic).get("znum").toString();
+				int znum = Integer.parseInt(znums);
+				//持证人数
+				String cznums = listwg.get(ic).get("cznum").toString();
+				int cznum = Integer.parseInt(cznums);
+				//缴纳社保人数
+				String sbnums = listwg.get(ic).get("sbnum").toString();
+				int sbnum = Integer.parseInt(sbnums);
+				//保安总人数为0
+				if (znum == 0) {
+					continue;
+				} else {
+					int a = znum / 2;
+					if (cznum <= a || sbnum <= a) {
+						countwg++;
+					}
+				}
+			}
+			//经营不善
+			List<Map<Object, Object>> listjy = informationService.selectJy(jurisdiction);
+			int countjy = 0;
+			for (int iyc = 0; iyc < listjy.size(); iyc++) {
+				String num = listjy.get(iyc).get("fwnum").toString();
+				int a = Integer.parseInt(num);
+				if (a == 0) {
+					countjy++;
+				}
+			}
+			//有实无名
+			List<Map<Object, Object>> listwm = informationService.selectYs(jurisdiction);
+			int countwm = 0;
+			for (int iwm = 0; iwm < listwm.size(); iwm++) {
+				String num = listwm.get(iwm).get("znum").toString();
+				int a = Integer.parseInt(num);
+				if (a == 0) {
+					countwm++;
+				}
+			}
+			//处罚
+			List<Map<Object, Object>> maps = informationService.selectCf(jurisdiction);
+			int size = maps.size();
+			map.put("Count", count+countjy+countwg+countwm+size);
+			map.put("jurname", jurname);
+			lists.add(map);
+		}
+		return R.data(lists);
+	}
+
+
 }

--
Gitblit v1.9.3