From 2ab35000026ccd58238e6a504b1b5f79f8c262c3 Mon Sep 17 00:00:00 2001 From: liusuyi <1951119284@qq.com> Date: 星期三, 17 七月 2024 10:20:20 +0800 Subject: [PATCH] 优化 --- ard-work/src/main/java/com/ruoyi/device/camera/service/impl/ArdCamerasServiceImpl.java | 540 ++++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 454 insertions(+), 86 deletions(-) diff --git a/ard-work/src/main/java/com/ruoyi/device/camera/service/impl/ArdCamerasServiceImpl.java b/ard-work/src/main/java/com/ruoyi/device/camera/service/impl/ArdCamerasServiceImpl.java index 1af864c..b2070e5 100644 --- a/ard-work/src/main/java/com/ruoyi/device/camera/service/impl/ArdCamerasServiceImpl.java +++ b/ard-work/src/main/java/com/ruoyi/device/camera/service/impl/ArdCamerasServiceImpl.java @@ -1,38 +1,51 @@ package com.ruoyi.device.camera.service.impl; -import java.awt.geom.Point2D; -import java.time.LocalTime; +import java.nio.file.Path; +import java.nio.file.Paths; +import java.text.SimpleDateFormat; import java.util.*; import java.util.stream.Collectors; +import com.ruoyi.alarm.global.domain.GuidePoint; +import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWell; +import com.ruoyi.common.config.ARDConfig; import com.ruoyi.common.constant.CacheConstants; +import com.ruoyi.common.constant.CameraConstants; +import com.ruoyi.common.constant.Constants; import com.ruoyi.common.core.domain.entity.SysDept; +import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.common.core.redis.RedisCache; +import com.ruoyi.common.exception.ServiceException; import com.ruoyi.common.utils.DateUtils; import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.bean.BeanValidators; +import com.ruoyi.common.utils.file.FileUtils; +import com.ruoyi.common.utils.spring.SpringUtils; import com.ruoyi.common.utils.uuid.IdUtils; import com.ruoyi.device.camera.domain.CameraCmd; +import com.ruoyi.device.camera.domain.DeptAndCamerasDto; import com.ruoyi.device.channel.domain.ArdChannel; import com.ruoyi.device.channel.mapper.ArdChannelMapper; -import com.ruoyi.device.channel.service.IArdChannelService; -import com.ruoyi.device.hiksdk.common.GlobalVariable; -import com.ruoyi.device.hiksdk.service.IHikClientService; +import com.ruoyi.media.service.IVtduService; import com.ruoyi.scheduling.domian.SchedulingParam; -import com.ruoyi.system.domain.SysConfig; +import com.ruoyi.system.service.ISysDeptService; +import com.ruoyi.utils.gis.GisUtil; import com.ruoyi.utils.tools.ArdTool; import com.ruoyi.device.camera.domain.ArdCameras; import com.ruoyi.device.camera.mapper.ArdCamerasMapper; import com.ruoyi.device.camera.service.IArdCamerasService; import com.ruoyi.common.annotation.DataScope; import com.ruoyi.system.mapper.SysDeptMapper; -import com.ruoyi.utils.tools.GisTool; -import com.ruoyi.utils.tools.Point; -import com.sun.org.apache.bcel.internal.generic.NEW; +import com.ruoyi.utils.gis.Point; import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Service; import javax.annotation.PostConstruct; import javax.annotation.Resource; +import javax.validation.Validator; /** * 鐩告満璁惧Service涓氬姟灞傚鐞� @@ -49,18 +62,47 @@ private SysDeptMapper sysDeptMapper; @Resource private RedisCache redisCache; - + @Resource + private ISysDeptService deptService; @Resource private ArdChannelMapper ardChannelMapper; - + @Resource + private IVtduService vtduService; + @Resource + protected Validator validator; @PostConstruct public void loadCameras() { + + //娓呯悊鏈湴褰曞儚缂撳瓨鏂囦欢 + String tempPath = ARDConfig.getProfile() + Constants.LOCAL_RECORD_TEMP_PREFIX; + FileUtils.deleteFolder(tempPath); + //娓呯┖鐩告満缂撳瓨 + Collection<String> cacheKeys = redisCache.keys(getCacheKey("*")); + redisCache.deleteObject(cacheKeys); + //閲嶆柊鍔犺浇鐩告満鍒扮紦瀛� List<ArdCameras> ardCameras = selectArdCamerasListNoDataScope(new ArdCameras()); for (ArdCameras ardCamera : ardCameras) { redisCache.setCacheObject(getCacheKey(ardCamera.getId()), ardCamera); } + //娓呯┖娴佸獟浣� + vtduService.clearVtdu(); + } + /** + * @Author 鍒樿嫃涔� + * @Description 瀹氭椂娓呯悊鏈湴褰曞儚缂撳瓨鏂囦欢锛堣秴杩�1澶╋級 + * @Date 2024/6/21 8:13 + * @Param + * @return + */ + //@Scheduled(cron = "0 0/10 * * * ?") + public void clearRecordTemp() + { + log.debug("瀹氭椂娓呯悊鏈湴褰曞儚缂撳瓨鏂囦欢锛堣秴杩�1澶╋級"); + String tempPath = ARDConfig.getProfile() + Constants.LOCAL_RECORD_TEMP_PREFIX; + Path folderPath = Paths.get(tempPath); + FileUtils.deleteNonTodayFiles(folderPath); } /** @@ -81,7 +123,16 @@ */ @Override public ArdCameras selectArdCamerasById(String id) { - return ardCamerasMapper.selectArdCamerasById(id); + ArdCameras ardCameras = ardCamerasMapper.selectArdCamerasById(id); + if (ardCameras != null) { + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(ardCameras.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + if (ardChannels != null) { + ardCameras.setChannelList(ardChannels); + } + } + return ardCameras; } /** @@ -93,7 +144,18 @@ @Override @DataScope(deptAlias = "d", userAlias = "u") public List<ArdCameras> selectArdCamerasList(ArdCameras ardCameras) { - return ardCamerasMapper.selectArdCamerasList(ardCameras); + List<ArdCameras> ardCamerasList = ardCamerasMapper.selectArdCamerasList(ardCameras); + if (ardCamerasList.size() > 0) { + for (ArdCameras camera : ardCamerasList) { + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(camera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + if (ardChannels != null) { + camera.setChannelList(ardChannels); + } + } + } + return ardCamerasList; } /** @@ -120,20 +182,7 @@ ardCameras.setCreateTime(DateUtils.getNowDate()); ardCameras.setUserId(SecurityUtils.getUserId()); redisCache.setCacheObject(getCacheKey(ardCameras.getId()), ardCameras); - int i = ardCamerasMapper.insertArdCameras(ardCameras); - if (i > 0) { -// //鍒犻櫎褰撳墠鐩告満鐨勬墍鏈夐�氶亾 -// ardChannelMapper.deleteArdChannelByDeviceId(ardCameras.getId()); -// //鑾峰彇鐩告満閫氶亾 -// List<ArdChannel> ipChannelList = hikClientService.getCameraChannelList(ardCameras); -// if (ipChannelList.size() > 0) { -// for (ArdChannel channel : ipChannelList) { -// channel.setId(IdUtils.simpleUUID()); -// ardChannelMapper.insertArdChannel(channel); -// } -// } - } - return i; + return ardCamerasMapper.insertArdCameras(ardCameras); } /** @@ -165,6 +214,8 @@ if (res > 0) { for (String id : ids) { redisCache.deleteObject(getCacheKey(id)); + //鍒犻櫎娴佸獟浣� + vtduService.deleteVtduByCameraId(id); //鍒犻櫎褰撳墠鐩告満鐨勬墍鏈夐�氶亾 ardChannelMapper.deleteArdChannelByDeviceId(id); } @@ -188,8 +239,102 @@ return i; } + @Override + public String importCameras(List<ArdCameras> ardCamerasList, Boolean isUpdateSupport, String operName) { + if (StringUtils.isNull(ardCamerasList) || ardCamerasList.size() == 0) { + throw new ServiceException("瀵煎叆浜曟暟鎹笉鑳戒负绌猴紒"); + } + int successNum = 0; + int failureNum = 0; + StringBuilder successMsg = new StringBuilder(); + StringBuilder failureMsg = new StringBuilder(); + for (ArdCameras camera : ardCamerasList) { + try { + //鑾峰彇褰撳墠鐧诲綍鐢ㄦ埛id + String userId = SecurityUtils.getUserId(); + camera.setUserId(userId); + // 楠岃瘉鏄惁瀛樺湪杩欎釜鐢ㄦ埛 + ArdCameras u = ardCamerasMapper.selectArdCamerasById(camera.getId()); + if (StringUtils.isNull(u)) { + BeanValidators.validateWithException(validator, camera); + camera.setCreateBy(operName); + this.insertArdCameras(camera); + successNum++; + successMsg.append("<br/>" + successNum + "銆佺浉鏈篒D " + camera.getId() + " 瀵煎叆鎴愬姛"); + } else if (isUpdateSupport) { + BeanValidators.validateWithException(validator, camera); + checkCameraDataScope(camera.getUserId()); + camera.setUpdateBy(operName); + this.updateArdCameras(camera); + successNum++; + successMsg.append("<br/>" + successNum + "銆佺浉鏈篒D " + camera.getId() + " 鏇存柊鎴愬姛"); + } else { + failureNum++; + failureMsg.append("<br/>" + failureNum + "銆佺浉鏈篒D " + camera.getId() + " 宸插瓨鍦�"); + } + } catch (Exception e) { + failureNum++; + String msg = "<br/>" + failureNum + "銆佺浉鏈篒D " + camera.getId() + " 瀵煎叆澶辫触锛�"; + failureMsg.append(msg + e.getMessage()); + log.error(msg, e); + } + } + if (failureNum > 0) { + failureMsg.insert(0, "寰堟姳姝夛紝瀵煎叆澶辫触锛佸叡 " + failureNum + " 鏉℃暟鎹牸寮忎笉姝g‘锛岄敊璇涓嬶細"); + throw new ServiceException(failureMsg.toString()); + } else { + successMsg.insert(0, "鎭枩鎮紝鏁版嵁宸插叏閮ㄥ鍏ユ垚鍔燂紒鍏� " + successNum + " 鏉★紝鏁版嵁濡備笅锛�"); + } + return successMsg.toString(); + } + + /** + * 鏍¢獙鐩告満鏄惁鍏佽鎿嶄綔 + * + * @param ardCameras 鐩告満淇℃伅 + */ + @Override + public void checkCameraAllowed(ArdCameras ardCameras) { + if (StringUtils.isNotNull(ardCameras.getId())) { + throw new ServiceException("涓嶅厑璁告搷浣滀簳"); + } + } + + /** + * 鏍¢獙鐢ㄦ埛鏄惁鏈夋暟鎹潈闄� + * + * @param userId 鐢ㄦ埛id + */ + @Override + public void checkCameraDataScope(String userId) { + if (!SysUser.isAdmin(SecurityUtils.getUserId())) { + ArdCameras camera = new ArdCameras(); + camera.setUserId(userId); + List<ArdCameras> cameras = SpringUtils.getAopProxy(this).selectArdCamerasList(camera); + if (StringUtils.isEmpty(cameras)) { + throw new ServiceException("娌℃湁鏉冮檺璁块棶浜曟暟鎹紒"); + } + } + } + public List findOptions(ArdCameras ardCameras) { - return ardCamerasMapper.findOptions(ardCameras); + //List<ArdCameras> options = ardCamerasMapper.findOptions(ardCameras); + List<Long> subDeptIdList = sysDeptMapper.selectDeptIdBySub(SecurityUtils.getDeptId());//涓嬪睘鍙婃湰鏉冮檺 + List<Long> ownDeptIdList= sysDeptMapper.selectRoleDeptIdByUsersId(SecurityUtils.getUserId());//鑷畾涔夋潈闄� + HashSet<Long> deptIdSet = new HashSet();//鍘婚噸 + deptIdSet.addAll(subDeptIdList); + deptIdSet.addAll(ownDeptIdList); + List<Long> deptIdList = new ArrayList(); + deptIdList.addAll(deptIdSet);//绗﹀悎鏉′欢鐨勫叏閮ㄦ潈闄� + List<ArdCameras> options = ardCamerasMapper.findTowerCamerasBySubAndOwnDeptIds(deptIdList); + for (ArdCameras camera : + options) { + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(camera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + camera.setChannelList(ardChannels); + } + return options; } /** @@ -200,7 +345,6 @@ * @鍒涘缓鏃堕棿 2023/6/2 10:58 * @淇敼浜哄拰鍏跺畠淇℃伅 */ - @Override public Map getChildDeptAndCamera(Boolean disabled) { Long deptId = SecurityUtils.getDeptId(); @@ -209,6 +353,33 @@ return map; } + @Override + public List<Map<String, Object>> getChildDeptAndCameraOwn(Boolean disabled) { + Long deptId = SecurityUtils.getDeptId(); + SysDept sysDept = sysDeptMapper.selectDeptById(deptId); + List<Long> ownDeptIdList = sysDeptMapper.selectRoleDeptIdByUsersId(SecurityUtils.getUserId());//鑷畾涔夋潈闄愪富閿煡璇� + ownDeptIdList.remove(SecurityUtils.getDeptId());//鑻ヨ嚜瀹氫箟鏉冮檺鍖呭惈鏈骇鏉冮檺锛屽垯绉婚櫎 + Map<String, Object> map = fetchChildDepartments(sysDept, disabled, ownDeptIdList);//鏌ヨ鏈潈闄愬強涓嬪睘鏉冮檺璁惧骞跺湪鑷畾涔夋潈闄愪腑绉婚櫎涓嬪睘閮ㄩ棬涓婚敭 + Set<Long> pIdSet = new HashSet();//鑷畾涔夋潈闄愪富閿殑鏈�璇ユ潈闄� + for(Long deptIdn : ownDeptIdList){ + List<SysDept> pSysDeptList = sysDeptMapper.getParentsDeptListByDeptId(deptIdn); + pIdSet.add(pSysDeptList.get(pSysDeptList.size() - 1).getDeptId());//鑾峰彇 + } + List<Map<String, Object>> result = new ArrayList(); + result.add(map); + for(Long pId : pIdSet){ + SysDept pSysDept = sysDeptMapper.selectDeptById(pId); + Map<String, Object> mapO = fetchChildDepartments(ownDeptIdList, pSysDept, disabled); + result.add(mapO); + } + return result; + } + + @Override + public List<DeptAndCamerasDto> getChildDeptAndCamera() { + List<SysDept> depts = deptService.selectDeptList(new SysDept()); + return fetchChildDepartments(depts); + } /** * @鎻忚堪 閫掑綊鏌ヨ * @鍙傛暟 [sysDept] @@ -236,11 +407,11 @@ } if (ardCameras.size() > 0) { for (ArdCameras camera : ardCameras) { - ArdChannel ardChannel=new ArdChannel(); + ArdChannel ardChannel = new ArdChannel(); ardChannel.setDeviceId(camera.getId()); List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); - if(ardChannels!=null) - { + if (ardChannels != null) { + ardChannels.stream().sorted(); camera.setChannelList(ardChannels); } Map<String, Object> cameraMap = ArdTool.convertEntityToMap(camera); @@ -249,7 +420,112 @@ } map.put("children", childList); return map; + } + /** + * zns + * + * */ + public Map<String, Object> fetchChildDepartments(SysDept sysDept, Boolean disabled, List<Long> ownDeptIdList) { + Map<String, Object> map = new HashMap<>(); + map.put("name", sysDept.getDeptName()); + map.put("deptId", sysDept.getDeptId()); + map.put("disabled", disabled); + List<SysDept> sysDepts = sysDeptMapper.selectNextChildrenDeptById(sysDept.getDeptId()); + for(SysDept sysDeptC : sysDepts){//鑻ヨ嚜瀹氫箟鏉冮檺鍖呭惈涓嬬骇鏉冮檺锛屽垯绉婚櫎 + if(ownDeptIdList.contains(sysDeptC.getDeptId())){ + ownDeptIdList.remove(sysDeptC.getDeptId()); + } + } + List<ArdCameras> ardCameras = ardCamerasMapper.selectArdCamerasByDeptId(sysDept.getDeptId()); + List<Object> childList = new ArrayList<>(); + for (SysDept childDept : sysDepts) { + Map<String, Object> childMap = new HashMap<>(); + childMap.put("name", childDept.getDeptName()); + childMap.put("deptId", childDept.getDeptId()); + childMap.put("disabled", disabled); + Map<String, Object> map1 = fetchChildDepartments(childDept, disabled); + childMap.putAll(map1); + childList.add(childMap); + } + if (ardCameras.size() > 0) { + for (ArdCameras camera : ardCameras) { + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(camera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + if (ardChannels != null) { + ardChannels.stream().sorted(); + camera.setChannelList(ardChannels); + } + Map<String, Object> cameraMap = ArdTool.convertEntityToMap(camera); + childList.add(cameraMap); + } + } + map.put("children", childList); + return map; + } + + public Map<String, Object> fetchChildDepartments(List<Long> ownDeptIdList, SysDept sysDept, Boolean disabled) { + Map<String, Object> map = new HashMap<>(); + map.put("name", sysDept.getDeptName()); + map.put("deptId", sysDept.getDeptId()); + map.put("disabled", disabled); + List<SysDept> sysDepts = sysDeptMapper.selectNextChildrenDeptByIdAndInList(sysDept.getDeptId(),ownDeptIdList); + List<ArdCameras> ardCameras = ardCamerasMapper.selectArdCamerasByDeptId(sysDept.getDeptId()); + List<Object> childList = new ArrayList<>(); + for (SysDept childDept : sysDepts) { + Map<String, Object> childMap = new HashMap<>(); + childMap.put("name", childDept.getDeptName()); + childMap.put("deptId", childDept.getDeptId()); + childMap.put("disabled", disabled); + //Map<String, Object> map1 = fetchChildDepartments(childDept, disabled); + Map<String, Object> map1 = fetchChildDepartments(ownDeptIdList,childDept, disabled); + childMap.putAll(map1); + childList.add(childMap); + } + if (ardCameras.size() > 0) { + for (ArdCameras camera : ardCameras) { + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(camera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + if (ardChannels != null) { + ardChannels.stream().sorted(); + camera.setChannelList(ardChannels); + } + Map<String, Object> cameraMap = ArdTool.convertEntityToMap(camera); + childList.add(cameraMap); + } + } + map.put("children", childList); + return map; + } + + /** + * 鑾峰彇鎵�鏈夐儴闂ㄥ強閮ㄩ棬涓嬬殑鐩告満 + * 鍒樿嫃涔� + * 2024/3/4 14:45:03 + */ + public List<DeptAndCamerasDto> fetchChildDepartments(List<SysDept> sysDepts) { + + List<DeptAndCamerasDto> deptAndCamerasList = sysDepts.stream() + .map(sysDept -> { + List<ArdCameras> ardCameras = ardCamerasMapper.selectArdCamerasByDeptId(sysDept.getDeptId()); + ardCameras.stream().forEach(ardCamera ->{ + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(ardCamera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + if (ardChannels != null) { + ardCamera.setChannelList(ardChannels); + } + }); + DeptAndCamerasDto deptAndCamerasDto = new DeptAndCamerasDto(); + deptAndCamerasDto.setSysDept(sysDept); + deptAndCamerasDto.setArdCamerasList(ardCameras); + return deptAndCamerasDto; + }) + .collect(Collectors.toList()); + + return deptAndCamerasList; } /** @@ -264,7 +540,7 @@ public TreeMap getNearCamerasBycoordinate(CameraCmd cmd) { try { double[] targetPosition = cmd.getTargetPosition(); - if (targetPosition == null || (targetPosition != null && targetPosition.length == 0)) { + if (targetPosition == null) { log.debug("鐩爣浣嶇疆涓虹┖"); return new TreeMap<>(); } @@ -279,7 +555,7 @@ continue; } double[] camPosition = new double[]{camera.getLongitude(), camera.getLatitude()}; - double distance = GisTool.getDistance(cmd.getTargetPosition(), camPosition); + double distance = GisUtil.getDistance(targetPosition, camPosition); if (camera.getCamMaxVisibleDistance() == null) { continue; } @@ -288,7 +564,13 @@ camera.setChanNo(ArdTool.getChannelBydayNightTime(dayNightTime)); ardCameras.put(distance, camera); } - + //鑾峰彇閫氶亾鍒楄〃 + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(camera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + if (ardChannels != null) { + camera.setChannelList(ardChannels); + } } return ardCameras; } catch (Exception ex) { @@ -305,7 +587,7 @@ @Override public List<ArdCameras> getNearCameras(SchedulingParam param) { try { - Long deptId=SecurityUtils.getLoginUser().getUser().getDeptId(); + Long deptId = SecurityUtils.getLoginUser().getUser().getDeptId(); Double longitude = param.getLongitude(); Double latitude = param.getLatitude(); if (longitude == null && latitude == null) { @@ -319,7 +601,7 @@ } String dayNightTime = redisCache.getCacheObject("sys_config:dayNightTime"); //鑾峰彇鎵�鏈夊厜鐢�(鎸夐儴闂�) - ArdCameras cameras= new ArdCameras(); + ArdCameras cameras = new ArdCameras(); cameras.setDeptId(deptId); List<ArdCameras> ardCamerasList = ardCamerasMapper.selectArdCamerasList(cameras); //缁熻鎵�鏈夊厜鐢靛彲瑙嗚寖鍥村唴涓庢姤璀︾偣鐨勮窛绂� @@ -329,57 +611,10 @@ continue; } double[] camPosition = new double[]{camera.getLongitude(), camera.getLatitude()}; - double distance = GisTool.getDistance(new double[]{longitude, latitude}, camPosition); + double distance = GisUtil.getDistance(new double[]{longitude, latitude}, camPosition); if (distance <= radius) { /*鑾峰彇閫氶亾鍒楄〃*/ - ArdChannel ardChannel=new ArdChannel(); - ardChannel.setDeviceId(camera.getId()); - List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); - camera.setChannelList(ardChannels); - ardCameras.add(camera); - } - } - //杩囨护鍦ㄧ嚎鐩告満 - List<ArdCameras> onlineList = ardCameras.stream() - .filter(ardCamera -> (!ardCamera.getLoginId().equals(-1))) - .collect(Collectors.toList()); - return onlineList; - } catch (Exception ex) { - log.error("鑾峰彇闄勮繎鐩告満寮傚父:" + ex.getMessage()); - } - return null; - } - /** - * 鑾峰彇鐩戞帶鍦堝唴鎵�鏈夊湪绾垮厜鐢� - * 鍒樿嫃涔� - * 2023/8/17 13:57:21 - */ - @Override - public List<ArdCameras> getNearCamerasWithPolygon(SchedulingParam param) { - try { - Long deptId=SecurityUtils.getLoginUser().getUser().getDeptId(); - List<Point> partitionLocation = param.getPartitionLocation(); - if(partitionLocation==null) - { - log.debug("澶氳竟褰㈠潗鏍囬泦鍚堜负绌�"); - return null; - } - String dayNightTime = redisCache.getCacheObject("sys_config:dayNightTime"); - //鑾峰彇鎵�鏈夊厜鐢�(鎸夐儴闂�) - ArdCameras cameras= new ArdCameras(); - cameras.setDeptId(deptId); - List<ArdCameras> ardCamerasList = ardCamerasMapper.selectArdCamerasList(cameras); - List<ArdCameras> ardCameras = new ArrayList<>(); - for (ArdCameras camera : ardCamerasList) { - if (camera.getLongitude() == null && camera.getLatitude() == null) { - continue; - } - /*鍒ゆ柇鍧愭爣鏄惁鍦ㄥ杈瑰舰鑼冨洿鍐�*/ - Point camPosition=new Point(camera.getLongitude(), camera.getLatitude()); - boolean inPolygon = GisTool.isInPolygon(camPosition, partitionLocation); - if (inPolygon) { - /*鑾峰彇閫氶亾鍒楄〃*/ - ArdChannel ardChannel=new ArdChannel(); + ArdChannel ardChannel = new ArdChannel(); ardChannel.setDeviceId(camera.getId()); List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); camera.setChannelList(ardChannels); @@ -397,4 +632,137 @@ return null; } + /** + * 鑾峰彇鐩戞帶鍦堝唴鎵�鏈夊湪绾垮厜鐢� + * 鍒樿嫃涔� + * 2023/8/17 13:57:21 + */ + @Override + public List<ArdCameras> getNearCamerasWithPolygon(SchedulingParam param) { + try { + Long deptId = SecurityUtils.getLoginUser().getUser().getDeptId(); + List<Point> partitionLocation = param.getPartitionLocation(); + if (partitionLocation == null) { + log.debug("澶氳竟褰㈠潗鏍囬泦鍚堜负绌�"); + return null; + } + String dayNightTime = redisCache.getCacheObject("sys_config:dayNightTime"); + //鑾峰彇鎵�鏈夊厜鐢�(鎸夐儴闂�) + ArdCameras cameras = new ArdCameras(); + cameras.setDeptId(deptId); + List<ArdCameras> ardCamerasList = ardCamerasMapper.selectArdCamerasList(cameras); + List<ArdCameras> ardCameras = new ArrayList<>(); + for (ArdCameras camera : ardCamerasList) { + if (camera.getLongitude() == null && camera.getLatitude() == null) { + continue; + } + /*鍒ゆ柇鍧愭爣鏄惁鍦ㄥ杈瑰舰鑼冨洿鍐�*/ + Point camPosition = new Point(camera.getLongitude(), camera.getLatitude()); + boolean inPolygon = GisUtil.isInPolygon(camPosition, partitionLocation); + if (inPolygon) { + /*鑾峰彇閫氶亾鍒楄〃*/ + ArdChannel ardChannel = new ArdChannel(); + ardChannel.setDeviceId(camera.getId()); + List<ArdChannel> ardChannels = ardChannelMapper.selectArdChannelList(ardChannel); + camera.setChannelList(ardChannels); + ardCameras.add(camera); + } + } + //杩囨护鍦ㄧ嚎鐩告満 + List<ArdCameras> onlineList = ardCameras.stream() + .filter(ardCamera -> (!ardCamera.getLoginId().equals(-1))) + .collect(Collectors.toList()); + return onlineList; + } catch (Exception ex) { + log.error("鑾峰彇闄勮繎鐩告満寮傚父:" + ex.getMessage()); + } + return null; + } + + /** + * 鏍¢獙鐩告満鏄惁鍞竴 + * + * @param camera 鐩告満 + * @return 缁撴灉 + */ + @Override + public String checkCameraIpAndPortUnique(ArdCameras camera) { + String id = camera.getId(); + String ip = camera.getIp(); + Integer port = camera.getPort(); + ArdCameras info = ardCamerasMapper.checkCameraIpAndPortUnique(ip, port); + if (StringUtils.isNotNull(info) && !info.getId().equals(id)) { + return CameraConstants.NOT_UNIQUE; + } + return CameraConstants.UNIQUE; + } + + @Override + public List<Map<String, Object>> getCamerasByDeptId(Long deptId,String userId) { + List<Long> deptIdList = new ArrayList(); + deptIdList.add(deptId); + deptIdList = getOwnAndChildrenDeptIdList(deptIdList,new ArrayList());//閫掑綊鏌ヨ涓嬪睘閮ㄩ棬涓婚敭 + //List<Map<String, Object>> result = ardCamerasMapper.getCamerasByDeptId(deptId,userId); + List<Map<String, Object>> result = ardCamerasMapper.getCamerasByDeptId(deptIdList,userId); + return result; + } + + public List<Long> getOwnAndChildrenDeptIdList(List<Long> deptIdList,List<Long> deptIdListr){ + deptIdListr.addAll(deptIdList); + List<Long> result = sysDeptMapper.getChildrenDeptIdList(deptIdList); + if(result.size() != 0){ + deptIdListr.addAll(result); + result = getOwnAndChildrenDeptIdList(result,deptIdListr); + } + deptIdListr = deptIdListr.stream().distinct().collect(Collectors.toList()); + return deptIdListr; + } + + @Override + public Boolean getCameraOperationByCameraId(String id, String userId) { + Boolean result = ardCamerasMapper.getCameraOperationByCameraId(id,userId); + return result; + } + + @Override + public Map<String, Object> getChannelByCameraId(String id) { + List<Map<String,Object>> result = ardCamerasMapper.getChannelByCameraId(id); + Map<String,Object> resultMap = new HashMap(); + if(result.size() == 1){ + resultMap.put("chanNo", result.get(0).get("chan_no")); + return resultMap; + }else{ + String configValue = (String) result.get(0).get("config_value"); + String beginTime = configValue.split("-")[0]; + String endTime = configValue.split("-")[1]; + Date now = new Date(); + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); + String nowDay = sdf.format(now); + try{ + Long beginDate = sdf.parse(nowDay).getTime() + + Integer.parseInt(beginTime.split(":")[0]) * 60 * 60 *1000 + + Integer.parseInt(beginTime.split(":")[1]) * 60 *1000; + Long endDate = sdf.parse(nowDay).getTime() + + Integer.parseInt(endTime.split(":")[0]) * 60 * 60 *1000 + + Integer.parseInt(endTime.split(":")[1]) * 60 *1000; + if(now.getTime() >= beginDate && now.getTime() <= endDate){ + result = result.stream().filter(map -> ((Integer)map.get("chan_no")) == 1).collect(Collectors.toList()); + resultMap.put("chanNo", result.get(0).get("chan_no")); + return resultMap; + }else{ + result = result.stream().filter(map -> ((Integer)map.get("chan_no")) == 2).collect(Collectors.toList()); + resultMap.put("chanNo", result.get(0).get("chan_no")); + return resultMap; + } + }catch (Exception e){ + e.printStackTrace(); + return resultMap; + } + } + } + + @Override + public int resetCameraLoginId() { + return ardCamerasMapper.resetCameraLoginId(); + } } -- Gitblit v1.9.3