From cd2cfd37366002f790a2ed1435962d4eff7d5cec Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Tue, 01 Jun 2021 09:39:30 +0800
Subject: [PATCH] 版本合并

---
 blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/equipment/controller/EquipmentController.java |  457 ++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 389 insertions(+), 68 deletions(-)

diff --git a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/equipment/controller/EquipmentController.java b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/equipment/controller/EquipmentController.java
index 4b5994c..25b0bf9 100644
--- a/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/equipment/controller/EquipmentController.java
+++ b/blade-service/blade-jfpts/src/main/java/org/springblade/jfpt/equipment/controller/EquipmentController.java
@@ -20,19 +20,27 @@
 import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
 import io.swagger.annotations.*;
 import lombok.AllArgsConstructor;
+import org.omg.PortableInterceptor.INACTIVE;
+import org.springblade.common.vo.DeptVo;
 import org.springblade.core.boot.ctrl.BladeController;
 import org.springblade.core.mp.support.Condition;
 import org.springblade.core.mp.support.Query;
 import org.springblade.core.tool.api.R;
 import org.springblade.core.tool.constant.BladeConstant;
 import org.springblade.core.tool.utils.Func;
+import org.springblade.jfpt.catalog.entitly.catalog;
 import org.springblade.jfpt.catalog.service.catalogService;
 import org.springblade.jfpt.deploy.service.IDeployService;
 import org.springblade.jfpt.equipment.entity.Equipment;
+import org.springblade.jfpt.equipment.entity.EquipmentPlayInfo;
+import org.springblade.jfpt.equipment.feign.DeptFeignApi;
+import org.springblade.jfpt.equipment.feign.RegionFeignApi;
 import org.springblade.jfpt.equipment.service.IEquipmentService;
 import org.springblade.jfpt.equipment.vo.EquipmentVO;
 import org.springblade.jfpt.equipment.vo.EquipmentVOS;
 import org.springblade.jfpt.equipment.wrapper.EqWrapper;
+import org.springblade.system.entity.Region;
+import org.springblade.system.user.entity.User;
 import org.springframework.web.bind.annotation.*;
 import springfox.documentation.annotations.ApiIgnore;
 
@@ -40,13 +48,10 @@
 import javax.validation.Valid;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
-import java.util.ArrayList;
-import java.util.Date;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
 
 /**
- * 控制器
+ * 设备管理控制器
  *
  * @author BladeX
  * @since 2020-07-01
@@ -61,6 +66,10 @@
 	private final IDeployService iDeployService;
 	private final org.springblade.jfpt.catalog.service.catalogService catalogService;
 
+	private final DeptFeignApi deptFeignApi;
+
+	private final RegionFeignApi regionFeignApi;
+
 	/**
 	 * 详情
 	 */
@@ -72,8 +81,25 @@
 		response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
 		response.setHeader("Access-Control-Allow-Credentials", "true");
 		/*Equipment detail = equipmentService.getOne(Condition.getQueryWrapper(equipment));*/
-
-		return R.data(equipmentService.selectInfo(equipment));
+		EquipmentVOS equipmentVOS = equipmentService.selectInfo(equipment);
+		//获取部门数据
+		List<DeptVo> deptVos = deptFeignApi.selDeptList();
+		if (null!=equipmentVOS.getDeptId()){
+			String[] split =equipmentVOS.getDeptId().split(",");
+			List<String> list = Arrays.asList(split);
+			StringBuffer deptNameBuiffer = new StringBuffer();
+			//数据匹配封装
+			for (String deptId:list) {
+				for (DeptVo deptVo:deptVos) {
+					if (deptId.equals(deptVo.getId().toString())){
+						deptNameBuiffer.append(deptVo.getDeptName()).append("/");
+					}
+				}
+			}
+			//封装部门名称数据
+			equipmentVOS.setDeptName(deptNameBuiffer.substring(0,deptNameBuiffer.length()-1));
+		}
+		return R.data(equipmentVOS);
 	}
 
 	/**
@@ -88,94 +114,225 @@
 	}
 
 	/**
+	 * 查询所有
+	 */
+	@GetMapping("/listAll")
+	@ApiOperationSupport(order = 2)
+	@ApiOperation(value = "分页", notes = "传入equipment")
+	public R<List<EquipmentVO>> listAll(EquipmentVO equipment, Query query) throws ParseException {
+		List<EquipmentVO> pages = equipmentService.listAll(equipment);
+
+		for (int j = 0; j < pages.size(); j++) {
+			String expireTime = pages.get(j).getExpireTime();
+			//1.获取当前时间
+			Date dd = new Date();
+			SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+			String end = sim.format(dd);
+			//把string类型转换为long类型的
+			if (expireTime != null) {
+				long st = sim.parse(expireTime).getTime();
+				long en = sim.parse(end).getTime();
+				//计算天数
+				int day = (int) ((st - en) / 86400000);
+				if (day <= 30) {
+					pages.get(j).setType(1);
+				} else {
+					pages.get(j).setType(0);
+				}
+			}
+
+
+			//判断设备是否在线
+			String Heartbeat = pages.get(j).getHeartbeat();
+			if (Heartbeat != null){
+				long st = sim.parse(Heartbeat).getTime();
+				long en = sim.parse(end).getTime();
+				if ((en - st) >= (60 * 60 * 24 * 1000)){
+					pages.get(j).setOnlineStatus("0");
+				}else{
+					pages.get(j).setOnlineStatus("1");
+				}
+			}else{
+				pages.get(j).setOnlineStatus("0");
+			}
+		}
+		return R.data(pages);
+	}
+
+	/**
 	 * 自定义分页
 	 */
-	@GetMapping("/page")
+	@GetMapping("/pages")
 	@ApiOperationSupport(order = 3)
 	@ApiOperation(value = "分页", notes = "传入equipment")
-	public R<IPage<EquipmentVO>> page(EquipmentVO equipment, Query query, String pid, HttpServletResponse response) throws ParseException {
+	public R<IPage<EquipmentVO>> pages(EquipmentVO equipment, Query query, String pid, HttpServletResponse response) throws ParseException {
 		response.setHeader("Access-Control-Allow-Origin", "*");
 		response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
 		response.setHeader("Access-Control-Allow-Credentials", "true");
 
+		IPage<EquipmentVO> page = null;
 		//清空全局参数
 		childMenu = new ArrayList();
 
-		//根据查询条件得到所有设备
-		IPage<EquipmentVO> pages = equipmentService.selectEquipmentPage(Condition.getPage(query), equipment);
+		if (pid == null || pid.equals("")) {
+			//根据查询条件得到所有设备
+			page = equipmentService.selectEquipmentPage(Condition.getPage(query), equipment, null);
+		} else {
+			List<Map<String, Object>> treedatas = catalogService.selectCatalogEqNUmber(null);
+			//根据传入的id递归出该节点下所有的设备
+			List<Map<String, Object>> childList = treeIdList(treedatas, pid);
 
-		//IPage<EquipmentVO> datas =  new IPage<EquipmentVO>
+			if (childList.size() > 0) {
+				//根据查询条件得到所有设备
+				page = equipmentService.selectEquipmentPage(Condition.getPage(query), equipment, childList);
+			} else {
+				List<Map<String, Object>> ces = catalogService.selectCatalogEqNUmber(pid);
+				List list = new ArrayList();
+				list.add(ces.get(0).get("eqid"));
+				//根据查询条件得到所有设备
+				page = equipmentService.selectEquipmentPage(Condition.getPage(query), equipment, list);
+			}
+		}
 
-//		if (pid == null || pid.equals("")) {
-//			for (int j = 0; j < pages.size(); j++) {
-//				String expireTime = pages.get(j).getExpireTime();
-//				//1.获取当前时间
-//				Date dd = new Date();
-//				SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-//				String end = sim.format(dd);
-//				//把string类型转换为long类型的
-//				long st = sim.parse(expireTime).getTime();
-//				long en = sim.parse(end).getTime();
-//				//计算天数
-//				int day = (int) ((st - en) / 86400000);
-//				if (day <= 30) {
-//					pages.get(j).setType(1);
-//				} else {
-//					pages.get(j).setType(0);
-//				}
-//			}
-//			datas = pages;
-//		} else {
-//			List<Map<String, Object>> treedatas = catalogService.selectCatalogEqNUmber(pid);
-//			//根据传入的id递归出该节点下所有的设备
-//			List<Map<String, Object>> childList = treeMenuList(treedatas, Integer.parseInt(pid));
-//			//将得到的设备与查询所得设备进行匹配
-//			for (int i = 0; i < childList.size(); i++) {
-//				for (int j = 0; j < pages.size(); j++) {
-//					String expireTime = pages.get(j).getExpireTime();
-//					//1.获取当前时间
-//					Date dd = new Date();
-//					SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
-//					String end = sim.format(dd);
-//					//把string类型转换为long类型的
-//					long st = sim.parse(expireTime).getTime();
-//					long en = sim.parse(end).getTime();
-//					//计算天数
-//					int day = (int) ((st - en) / 86400000);
-//					if (day <= 30) {
-//						pages.get(j).setType(1);
-//					} else {
-//						pages.get(j).setType(0);
-//					}
-//
-//					if (childList.get(i).get("eqid") != null) {
-//						if (childList.get(i).get("eqid").equals(pages.get(j).getDeviceNumber())) {
-//							datas.add(pages.get(j));
-//						}
-//					}
-//				}
-//			}
-//		}
-		return R.data(pages);
+		if (page != null) {
+			for (int j = 0; j < page.getRecords().size(); j++) {
+				String expireTime = page.getRecords().get(j).getExpireTime();
+				//1.获取当前时间
+				Date dd = new Date();
+				SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+				String end = sim.format(dd);
+				//把string类型转换为long类型的
+
+				if (expireTime != null) {
+					long st = sim.parse(expireTime).getTime();
+					long en = sim.parse(end).getTime();
+					//计算天数
+					int day = (int) ((st - en) / 86400000);
+					if (day <= 30) {
+						page.getRecords().get(j).setType(1);
+					} else {
+						page.getRecords().get(j).setType(0);
+					}
+				}
+			}
+		}
+
+		return R.data(page);
 	}
+
+
+	/**
+	 * 自定义分页(部门挂接)
+	 * @param dxtype  ???
+	 * @param equipment 设备对象信息
+	 * @param query 查询参数
+	 * @param pid  组织机构Id
+	 * @param response servlet 响应对象
+	 */
+	@GetMapping("/pageDept")
+	@ApiOperationSupport(order = 3)
+	@ApiOperation(value = "分页", notes = "传入equipment")
+	public R<IPage<EquipmentVO>> pageDept(EquipmentVO equipment, Query query, String pid, String dxtype, HttpServletResponse response) throws ParseException {
+		response.setHeader("Access-Control-Allow-Origin", "*");
+		response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
+		response.setHeader("Access-Control-Allow-Credentials", "true");
+		//获取部门数据
+		List<DeptVo> deptVos = deptFeignApi.selDeptList();
+		//获取设备数据信息
+		IPage<EquipmentVO> page = equipmentService.selectDeptPages(Condition.getPage(query), equipment, pid, dxtype);
+		//遍历数据
+		for (int j = 0; j < page.getRecords().size(); j++) {
+			if (null!=page.getRecords().get(j).getDeptId()){
+				String[] split = page.getRecords().get(j).getDeptId().split(",");
+				List<String> list = Arrays.asList(split);
+				StringBuffer deptNameBuiffer = new StringBuffer();
+				//数据匹配封装
+				for (String deptId:list) {
+					for (DeptVo deptVo:deptVos) {
+						if (deptId.equals(deptVo.getId().toString())){
+							deptNameBuiffer.append(deptVo.getDeptName()).append(",");
+						}
+					}
+				}
+				//封装部门名称数据
+				page.getRecords().get(j).setDeptName(deptNameBuiffer.substring(0,deptNameBuiffer.length()-1));
+			}
+
+			String expireTime = page.getRecords().get(j).getExpireTime();
+			//1.获取当前时间
+			Date dd = new Date();
+			SimpleDateFormat sim = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+			String end = sim.format(dd);
+			//把string类型转换为long类型的
+
+			if (expireTime != null) {
+				long st = sim.parse(expireTime).getTime();
+				long en = sim.parse(end).getTime();
+				//计算天数
+				int day = (int) ((st - en) / 86400000);
+				if (day <= 30) {
+					page.getRecords().get(j).setType(1);
+				} else {
+					page.getRecords().get(j).setType(0);
+				}
+			}
+
+			//判断设备是否在线
+			String Heartbeat = page.getRecords().get(j).getHeartbeat();
+			if (Heartbeat != null){
+				long st = sim.parse(Heartbeat).getTime();
+				long en = sim.parse(end).getTime();
+				if ((en - st) >= (60 * 60 * 24 * 1000)){
+					page.getRecords().get(j).setOnlineStatus("0");
+				}else{
+					page.getRecords().get(j).setOnlineStatus("1");
+				}
+			}else{
+				page.getRecords().get(j).setOnlineStatus("0");
+			}
+		}
+
+
+		return R.data(page);
+	}
+
 
 	//子节点
 	private static List childMenu = new ArrayList();
 
-	public static List treeMenuList(List<Map<String, Object>> menuList, int pid) {
+	public static List treeMenuList(List<Map<String, Object>> menuList, String pid) {
 		for (int i = 0; i < menuList.size(); i++) {
 			//遍历出父id等于参数的id,add进子节点集合
 
-			if (pid != 0) {
-				if (menuList.get(i).get("pId").equals(pid)) {
+			if (!pid.equals(0)) {
+				if (menuList.get(i).get("pId").toString().equals(pid)) {
 					//递归遍历下一级
-					treeMenuList(menuList, Integer.valueOf((Integer) menuList.get(i).get("id")));
+					treeMenuList(menuList, menuList.get(i).get("id").toString());
 					childMenu.add(menuList.get(i));
 				}
 			}
 
 		}
 		return childMenu;
+	}
+
+	public static List treeIdList(List<Map<String, Object>> menuList, String pid) {
+		for (int i = 0; i < menuList.size(); i++) {
+			//遍历出父id等于参数的id,add进子节点集合
+
+			if (!pid.equals(0)) {
+				if (menuList.get(i).get("pId").toString().equals(pid)) {
+					//递归遍历下一级
+					treeIdList(menuList, menuList.get(i).get("id").toString());
+					if (menuList.get(i).get("eqid") != null && !menuList.get(i).get("eqid").equals("")) {
+						childMenu.add(menuList.get(i).get("eqid"));
+					}
+				}
+			}
+
+		}
+		return childMenu;
+
 	}
 
 	/**
@@ -219,7 +376,86 @@
 	@PostMapping("/submit")
 	@ApiOperationSupport(order = 6)
 	@ApiOperation(value = "新增或修改", notes = "传入equipment")
-	public R submit(@Valid @RequestBody Equipment equipment) {
+	public R submit(@Valid @RequestBody EquipmentVO equipment) {
+		if (equipment.getStime() != null && equipment.getStime().equals("")) {
+			equipment.setStime(null);
+		}
+
+		if (equipment.getExpireTime() != null && equipment.getExpireTime().equals("")) {
+			equipment.setExpireTime(null);
+		}
+
+		if (equipment.getHeartbeat() != null && equipment.getHeartbeat().equals("")) {
+			equipment.setHeartbeat(null);
+		}
+
+		if (equipment.getDtype() == null || equipment.getDtype().equals("")) {
+			equipment.setDtype("0");
+		}
+
+		//判断省市区的值是否为数字或者中文字符串
+		if(null!=equipment.getProvince()){
+			//如果不是数字,则需调用接口匹配数据(直接取区、县参数)
+			if (!equipment.getDistrict().matches("^[0-9]*$") && !equipment.getCity().matches("^[0-9]*$")){
+				Region region = regionFeignApi.selRegionDetail(equipment.getDistrict(),equipment.getCity());
+				if (null!=region){
+					//封装数据
+					equipment.setProvince(region.getProvinceCode());
+					equipment.setCity(region.getCityCode());
+					equipment.setDistrict(region.getDistrictCode());
+				}
+			}
+		}
+
+//		String deviceName = equipment.getDeviceName();
+//		String deviceNumber = equipment.getDeviceNumber();
+//		String pId = equipment.getPid();
+//		if (equipment.getId() == null){
+//			catalogService.addCatalog(deviceName,deviceNumber,pId);
+//		}else{
+//			catalogService.updateCatalog(deviceName,deviceNumber,pId);
+//		}
+
+
+		return R.status(equipmentService.saveOrUpdate(equipment));
+	}
+
+	/**
+	 * APP新增或修改
+	 */
+	@PostMapping("/AppSubmit")
+	@ApiOperationSupport(order = 6)
+	@ApiOperation(value = "新增或修改", notes = "传入equipment")
+	public R AppSubmit(@Valid EquipmentVO equipment) {
+		if (equipment.getStime() != null && equipment.getStime().equals("")) {
+			equipment.setStime(null);
+		}
+
+		if (equipment.getExpireTime() != null && equipment.getExpireTime().equals("")) {
+			equipment.setExpireTime(null);
+		}
+
+		if (equipment.getHeartbeat() != null && equipment.getHeartbeat().equals("")) {
+			equipment.setHeartbeat(null);
+		}
+
+		if (equipment.getDtype() == null || equipment.getDtype().equals("")) {
+			equipment.setDtype("0");
+		}
+
+//		String deviceName = equipment.getDeviceName();
+//		String deviceNumber = equipment.getDeviceNumber();
+//		String pId = equipment.getPid();
+//		if (equipment.getId() == null){
+//			catalogService.addCatalog(deviceName,deviceNumber,pId);
+//		}else{
+//			catalogService.updateCatalog(deviceName,deviceNumber,pId);
+//		}
+
+		if (equipment.getPaddress() != null && !equipment.getPaddress().equals("")) {
+			equipmentService.saveImg(equipment);
+		}
+
 		return R.status(equipmentService.saveOrUpdate(equipment));
 	}
 
@@ -276,4 +512,89 @@
 		return R.data(list);
 	}
 
+	/**
+	 * 修改
+	 */
+	@PostMapping("/updateexpireTime")
+	@ApiOperationSupport(order = 5)
+	@ApiOperation(value = "修改", notes = "传入equipment")
+	public R updateexpireTime(String expireTime, String deviceNumber) {
+		equipmentService.updateexpireTime(expireTime, deviceNumber);
+		return R.success("修改成功");
+	}
+
+	/**
+	 * 设备故障修改
+	 */
+	@PostMapping("/updateExstate")
+	@ApiOperationSupport(order = 5)
+	@ApiOperation(value = "修改", notes = "传入equipment")
+	public R updateExstate(String state, String reason, String deviceNumber) {
+		equipmentService.updateExstate(state, reason, deviceNumber);
+		return R.success("修改成功");
+	}
+
+
+	/**
+	 * 监控台统计
+	 *
+	 * @return
+	 */
+	@PostMapping("/SeleC")
+	public R SeleC() {
+		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");//设置日期格式
+		String time = df.format(new Date());// new Date()为获取当前系统时间
+		//设备在线数量
+		Integer integerz = equipmentService.selectEqCz();
+		//设备掉线数量
+		Integer integerd = equipmentService.selectEqCd();
+		//设备预警数量
+		List<Map<String, Object>> list = equipmentService.selectEqCy(time);
+		//设备故障数量
+		Integer integerg = equipmentService.selectEqCg();
+		Map<String, Object> map = new HashMap<String, Object>();
+		map.put("zx", integerz);
+		map.put("dx", integerd);
+		map.put("yj", list.size());
+		map.put("gz", integerg);
+		return R.data(map);
+	}
+
+	/**
+	 * 监控台统计
+	 * @author arsn 2021-5-6
+	 * @return
+	 */
+	@PostMapping("/SeleCs")
+	public R SeleCs() {
+		return R.data(equipmentService.selEqTypeSum());
+	}
+
+	/**
+	 * 获取设备视频播放的信息
+	 * @param equipmentPlayInfo 视频播放地址对象,只需包含设备编号,以及视频播放格式即可
+	 * @param response 响应域,设置跨域
+	 * @return
+	 */
+	@GetMapping("/selectEquimentPlayInfo")
+	public R selectEquimentPlayInfo(EquipmentPlayInfo equipmentPlayInfo,HttpServletResponse response){
+		response.setHeader("Access-Control-Allow-Origin", "*");
+		response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE");
+		response.setHeader("Access-Control-Allow-Credentials", "true");
+		//返回
+		return R.data(equipmentService.selectEquimentPlayInfo(equipmentPlayInfo));
+	}
+
+
+
+	/**
+	 * 新增或修改设备视频播放的信息
+	 * @param equipmentPlayInfo 视频播放地址对象
+	 * @return
+	 */
+	@PostMapping("/submitEquimentPlayInfo")
+	public R submitEquimentPlayInfo(EquipmentPlayInfo equipmentPlayInfo){
+		return R.status(equipmentService.saveOrUpdateEquipmentPlayInfo(equipmentPlayInfo));
+	}
+
 }

--
Gitblit v1.9.3