package com.ycl.task; import com.alibaba.fastjson2.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.mongodb.client.result.DeleteResult; import com.ycl.feign.HKClient; import com.ycl.feign.HkApiUtil; import com.ycl.feign.UYClient; import com.ycl.platform.domain.entity.CheckIndexCar; import com.ycl.platform.domain.entity.CheckIndexFace; import com.ycl.platform.domain.entity.TMonitor; import com.ycl.platform.domain.param.HK.*; import com.ycl.platform.domain.result.HK.*; import com.ycl.platform.domain.result.UY.MonitorQualifyResult; import com.ycl.platform.domain.result.UY.VideoOnlineResult; import com.ycl.platform.domain.vo.UpdateOnlineVO; import com.ycl.platform.mapper.CheckIndexCarMapper; import com.ycl.platform.mapper.CheckIndexFaceMapper; import com.ycl.platform.mapper.TMonitorMapper; import com.ycl.platform.mapper.WorkOrderMapper; import com.ycl.platform.service.*; import com.ycl.utils.DateUtils; import constant.ApiConstants; import constant.CheckConstants; import enumeration.general.AreaDeptEnum; import enumeration.general.PublishType; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.data.mongodb.core.MongoTemplate; import org.springframework.data.mongodb.core.query.Criteria; import org.springframework.data.mongodb.core.query.Query; import org.springframework.stereotype.Component; import org.springframework.util.CollectionUtils; import java.math.BigDecimal; import java.text.SimpleDateFormat; import java.util.*; import java.util.function.Function; import java.util.stream.Collectors; //海康对接数据任务 @Slf4j @Component("HKTask") public class HKTask { @Value("${HK.host}") public String host; @Value("${HK.appKey}") public String appKey; @Value("${HK.appSecret}") public String appSecret; @Value("${HK.carCode}") public String carCode; @Value("${HK.faceCode}") public String faceCode; @Value("${HK.carProvinceCode}") public String carProvinceCode; @Value("${HK.faceProvinceCode}") public String faceProvinceCode; @Autowired private MongoTemplate mongoTemplate; @Autowired private IYwThresholdService ywThresholdService; @Autowired private YwPointService pointService; @Autowired private TMonitorMapper monitorMapper; @Autowired private UYErrorTypeCheckService uyErrorTypeCheckService; @Autowired private HKClient hkClient; @Autowired private ICheckIndexCarService carService; @Autowired private CheckIndexCarMapper carMapper; @Autowired private ICheckIndexFaceService faceService; @Autowired private CheckIndexFaceMapper faceMapper; //车辆设备全检指标监测结果 public void vehicleDeviceInspectionTask() { log.info("开始执行车辆设备全检指标监测结果数据同步"); VehicleDeviceInspectionParam param = new VehicleDeviceInspectionParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); param.setDataType(ApiConstants.HK_DataType_CAR); List list = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v2/data/vehFullAmount/query", param, VehicleDeviceInspectionResult.class); if (!CollectionUtils.isEmpty(list)) { //如果存在之前的数据先删除 Query query = new Query(Criteria.where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, VehicleDeviceInspectionResult.class); list.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(list, CheckConstants.Rule_Category_Car); //存放在mongo中 mongoTemplate.insertAll(list); //同步的数据进行工单阈值处理 ywThresholdService.carCheck(list); } // 本地测试 // Query query = new Query(Criteria.where("mongoCreateTime").lt(DateUtils.getDayEnd(new Date()))); // ywThresholdService.carCheck(mongoTemplate.find(query, VehicleDeviceInspectionResult.class)); log.info("结束车辆设备全检指标监测结果数据同步"); } //人脸设备全检指标监测结果 public void faceDeviceInspectionTask() { log.info("开始执行人脸设备全检指标监测结果数据同步"); FaceDeviceInspectionParam param = new FaceDeviceInspectionParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); List list = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v2/data/faceFullAmount/query", param, FaceDeviceInspectionResult.class); if (!CollectionUtils.isEmpty(list)) { //如果存在之前的数据先删除 Query query = new Query(Criteria.where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, FaceDeviceInspectionResult.class); list.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(list, CheckConstants.Rule_Category_Face); //存放在mongo中 mongoTemplate.insertAll(list); //同步的数据进行工单阈值处理 ywThresholdService.faceCheck(list); } // Query query = new Query(Criteria.where("mongoCreateTime").lt(DateUtils.getDayEnd(new Date()))); // ywThresholdService.faceCheck(mongoTemplate.find(query, FaceDeviceInspectionResult.class)); log.info("结束人脸设备全检指标监测结果数据同步"); } // 抓拍数据量监测结果 public void snapshotDataMonitorTask() { log.info("开始执行抓拍数据量检测结果数据同步"); /** 车辆数据 */ SnapshotDataMonitorParam carParam = new SnapshotDataMonitorParam(); carParam.setPageNo(ApiConstants.PageNo); carParam.setPageSize(ApiConstants.HKPageSize); carParam.setDate(DateUtils.getDate()); carParam.setDataType(ApiConstants.HK_DataType_CAR); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/snapCountDetail/query", carParam, SnapshotDataMonitorResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())) .and("dataType").is(ApiConstants.HK_DataType_CAR)); DeleteResult result = mongoTemplate.remove(query, SnapshotDataMonitorResult.class); carList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); //存放在mongo中 carList.forEach(item -> item.setDataType(ApiConstants.HK_DataType_CAR)); mongoTemplate.insertAll(carList); } /** 人脸数据 */ SnapshotDataMonitorParam faceParam = new SnapshotDataMonitorParam(); faceParam.setPageNo(ApiConstants.PageNo); faceParam.setPageSize(ApiConstants.HKPageSize); faceParam.setDate(DateUtils.getDate()); faceParam.setDataType(ApiConstants.HK_DataType_FACE); List faceList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/snapCountDetail/query", faceParam, SnapshotDataMonitorResult.class); if (!CollectionUtils.isEmpty(faceList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())) .and("dataType").is(ApiConstants.HK_DataType_FACE)); DeleteResult result = mongoTemplate.remove(query, SnapshotDataMonitorResult.class); faceList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(faceList, CheckConstants.Rule_Category_Face); //存放在mongo中 faceList.forEach(item -> item.setDataType(ApiConstants.HK_DataType_FACE)); mongoTemplate.insertAll(faceList); } //修改online状态 List totalResult = new ArrayList<>(); totalResult.addAll(carList); totalResult.addAll(faceList); if (!CollectionUtils.isEmpty(totalResult)) { //先拿优云的在线,过滤掉优云已有的国标码 Query query = new Query(); query.addCriteria(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); List results = mongoTemplate.find(query, VideoOnlineResult.class); if (!CollectionUtils.isEmpty(results)) { Date now = new Date(); List uyNoList = results.stream().map(VideoOnlineResult::getNo).collect(Collectors.toList()); List numbers = totalResult.stream().filter(result->!uyNoList.contains(result.getExternalIndexCode())) .map(SnapshotDataMonitorResult::getExternalIndexCode).collect(Collectors.toList()); //排除掉优云且不包含视频设备的国标 Map map = monitorMapper.selectList(new QueryWrapper() .in("serial_number", numbers)) .stream().filter(monitor -> monitor.getCameraFunType()!=null && !monitor.getCameraFunType().contains("1")) .collect(Collectors.toMap(TMonitor::getSerialNumber, Function.identity())); List willUpdateList = new ArrayList<>(); totalResult.forEach(item -> { TMonitor monitor = map.get(item.getExternalIndexCode()); if(monitor!=null) { UpdateOnlineVO vo = new UpdateOnlineVO(); vo.setOnline(item.getDataCount() > 0 ? 1 : -1); vo.setSerialNumber(monitor.getSerialNumber()); vo.setUpdateTime(now); willUpdateList.add(vo); } }); if(!CollectionUtils.isEmpty(willUpdateList)) monitorMapper.updateOnlineFromHk(willUpdateList); // List willUpdateList = totalResult.stream().map(item -> { // UpdateOnlineVO vo = new UpdateOnlineVO(); // vo.setOnline(item.getDataCount() > 0 ? 1 : -1); // vo.setIp(map.get(item.getExternalIndexCode()).getIp()); // vo.setUpdateTime(now); // return vo; // }).collect(Collectors.toList()); // monitorMapper.updateOnlineFromUyOrHk(willUpdateList); // //离线生成工单,一个ip只生成一个工单 // List workOrders = new ArrayList<>(totalResult.stream() // .filter(item -> ApiConstants.UY_OnlineSite_Offline.equals(item.getDataCount() > 0 ? 1 : -1)) // .collect(Collectors.toMap( // SnapshotDataMonitorResult::getIp, // Function.identity(), // (existing, replacement) -> existing // 如果遇到相同的 IP,保留第一个(existing) // )).values()); // uyErrorTypeCheckService.hkOnlineCheck(workOrders); } } log.info("结束抓拍数据量检测结果数据同步"); } //采集设备属性监测结果(人脸) public void monitorDetailTask() { log.info("开始执行采集设备属性监测结果数据同步"); //人脸卡口信息采集准确率 MonitoringDetailParam param = new MonitoringDetailParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); List faceList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/device/cameraExpDetailInfo/query", param, MonitoringDetailResult.class); if (!CollectionUtils.isEmpty(faceList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, MonitoringDetailResult.class); faceList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(faceList, CheckConstants.Rule_Category_Face); //存放在mongo中 mongoTemplate.insertAll(faceList); } log.info("结束采集设备属性监测结果数据同步"); } //卡口属性监测结果 public void crossDetailTask() { log.info("开始执行卡口属性监测结果数据同步"); //车辆卡口信息采集准确率 CrossDetailParam param = new CrossDetailParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/device/crossExpDetailInfo/query", param, CrossDetailResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, CrossDetailResult.class); carList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); //存放在mongo中 mongoTemplate.insertAll(carList); } log.info("结束卡口属性监测结果数据同步"); } //数据完整性监测结果 public void dataIntegrityMonitoringTask() { log.info("开始执行数据完整性监测结果数据同步"); //车辆卡口设备抓拍数据完整性 DataIntegrityMonitoringParam param = new DataIntegrityMonitoringParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); param.setDataType(ApiConstants.HK_DataType_CAR); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/attributeIntegrity/query", param, DataIntegrityMonitoringResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, DataIntegrityMonitoringResult.class); carList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); //存放在mongo中 mongoTemplate.insertAll(carList); } log.info("结束数据完整性监测结果数据同步"); } //属性识别准确监测结果 public void attrRecognitionMonitorTask() { log.info("开始执行属性识别准确监测结果数据同步"); //车辆卡口设备抓拍数据准确性 AttrRecognitionParam param = new AttrRecognitionParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); param.setDataType(ApiConstants.HK_DataType_CAR); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/attributeRecognition/query", param, AttrRecognitionMonitorResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, AttrRecognitionMonitorResult.class); carList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); //存放在mongo中 mongoTemplate.insertAll(carList); } log.info("结束属性识别准确监测结果数据同步"); } //抓拍数据时延监测结果 public void snapshopDelayMonitorTask() { log.info("开始执行抓拍数据时延监测结果数据同步"); //车辆卡口设备抓拍数据上传及时性 /** 车辆数据 */ SnapshotDelayMonitorParam carParam = new SnapshotDelayMonitorParam(); carParam.setPageNo(ApiConstants.PageNo); carParam.setPageSize(ApiConstants.HKPageSize); carParam.setDate(DateUtils.getDate()); carParam.setDataType(ApiConstants.HK_DataType_CAR); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/snapAgingDetail/query", carParam, SnapshotDelayMonitorResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())) .and("dataType").is(ApiConstants.HK_DataType_CAR)); DeleteResult result = mongoTemplate.remove(query, SnapshotDelayMonitorResult.class); //存放在mongo中 carList.stream().forEach(item -> { item.setDataType(ApiConstants.HK_DataType_CAR); if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); mongoTemplate.insertAll(carList); } /** 人脸数据 */ SnapshotDelayMonitorParam faceParam = new SnapshotDelayMonitorParam(); faceParam.setPageNo(ApiConstants.PageNo); faceParam.setPageSize(ApiConstants.HKPageSize); faceParam.setDate(DateUtils.getDate()); faceParam.setDataType(ApiConstants.HK_DataType_FACE); List faceList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/snapAgingDetail/query", faceParam, SnapshotDelayMonitorResult.class); if (!CollectionUtils.isEmpty(faceList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date())) .and("dataType").is(ApiConstants.HK_DataType_FACE)); DeleteResult result = mongoTemplate.remove(query, SnapshotDelayMonitorResult.class); //存放在mongo中 faceList.forEach(item -> { item.setDataType(ApiConstants.HK_DataType_FACE); if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(faceList, CheckConstants.Rule_Category_Face); mongoTemplate.insertAll(faceList); } log.info("结束抓拍数据时延监测结果数据同步"); } //图片访问监测结果 public void picAccessTask() { log.info("开始执行图片访问监测结果数据同步"); //车辆卡口信息采集准确率、车辆卡口设备url可用性 PicAccessParam param = new PicAccessParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); param.setDataType(ApiConstants.HK_DataType_CAR); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v1/data/picAccessDetail/query", param, PicAccessResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, PicAccessResult.class); carList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); //存放在mongo中 mongoTemplate.insertAll(carList); } log.info("结束图片访问监测结果数据同步"); } //车辆设备抽检指标监测结果 public void vehicleDeviceSamplingTask() { log.info("开始执行车辆设备抽检指标监测结果数据同步"); //车辆卡口信息采集准确率、车辆卡口设备url可用性 VehicleDeviceSamplingParam param = new VehicleDeviceSamplingParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); param.setDataType(ApiConstants.HK_DataType_CAR); List carList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v2/data/vehSampleAmount/query", param, VehicleDeviceSamplingResult.class); if (!CollectionUtils.isEmpty(carList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, VehicleDeviceSamplingResult.class); carList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(carList, CheckConstants.Rule_Category_Car); //存放在mongo中 mongoTemplate.insertAll(carList); } log.info("结束车辆设备抽检指标监测结果数据同步"); } //人脸设备抽检指标监测结果 public void faceDeviceSamplingTask() { log.info("开始执行人脸设备抽检指标监测结果数据同步"); FaceDeviceSamplingParam param = new FaceDeviceSamplingParam(); param.setPageNo(ApiConstants.PageNo); param.setPageSize(ApiConstants.HKPageSize); param.setDate(DateUtils.getDate()); List faceList = HkApiUtil.sendAPI(host, appKey, appSecret, "/api/dqd/service/rs/v2/data/faceSampleAmount/query", param, FaceDeviceSamplingResult.class); if (!CollectionUtils.isEmpty(faceList)) { //如果今天存在之前的数据先删除 Query query = new Query(Criteria .where("mongoCreateTime").gte(DateUtils.getDayStart(new Date())).lt(DateUtils.getDayEnd(new Date()))); DeleteResult result = mongoTemplate.remove(query, FaceDeviceSamplingResult.class); faceList.stream().forEach(item -> { if (Objects.nonNull(item.getExternalIndexCode())) { item.setNo(item.getExternalIndexCode()); } }); pointService.setDeviceTagByGB(faceList, CheckConstants.Rule_Category_Face); //存放在mongo中 mongoTemplate.insertAll(faceList); } log.info("结束人脸设备抽检指标监测结果数据同步"); } //考核成绩 public void HkScoreTask() { log.info("开始执行海康考核成绩数据"); //准备新增或修改的数据 List cars = new ArrayList<>(); List faces = new ArrayList<>(); // 查询是否index表已经存在今日数据 List checkIndexFaceList = faceMapper.selectToday(utils.DateUtils.getDate()); List checkIndexCarList = carMapper.selectToday(utils.DateUtils.getDate()); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); // 获取当前时间的Calendar实例 Calendar calendar = Calendar.getInstance(); // 设置时间为前一天 calendar.add(Calendar.DATE, -1); // 获取前一天的Date对象 Date yesterday = calendar.getTime(); //先请求全量数据 ScoreParam param = new ScoreParam(); param.setStartDate(format.format(yesterday)); param.setEndDate(format.format(yesterday)); param.setFocusFlag(ApiConstants.HK_FOCUS_FLAG_ALL); param.setCarTree(carCode); param.setFaceTree(faceCode); JSONObject scoreJson = hkClient.getScore(param); if (scoreJson != null) { String code = scoreJson.getString("code"); if (ApiConstants.HKSuccessCode.equals(code)) { List data = scoreJson.getList("data", HKScoreResult.class); //根据数据转换为index对象 data.forEach(score -> { CheckIndexCar car = new CheckIndexCar(); CheckIndexFace face = new CheckIndexFace(); score2Index(score, car, face); car.setExamineTag(CheckConstants.Examine_Tag_County); face.setExamineTag(CheckConstants.Examine_Tag_County); Optional carFirst = checkIndexCarList.stream() .filter(index -> CheckConstants.Examine_Tag_County.equals(index.getExamineTag()) && car.getDeptId().equals(index.getDeptId())) .findFirst(); Optional faceFirst = checkIndexFaceList.stream() .filter(index -> CheckConstants.Examine_Tag_County.equals(index.getExamineTag()) && face.getDeptId().equals(index.getDeptId())) .findFirst(); if (carFirst.isPresent()) { car.setId(carFirst.get().getId()); } if (faceFirst.isPresent()) { face.setId(faceFirst.get().getId()); } cars.add(car); faces.add(face); }); } } //先请求省厅数据 ScoreParam provinceParam = new ScoreParam(); provinceParam.setStartDate(format.format(yesterday)); provinceParam.setEndDate(format.format(yesterday)); provinceParam.setFocusFlag(ApiConstants.HK_FOCUS_FLAG_ALL); provinceParam.setCarTree(carProvinceCode); provinceParam.setFaceTree(faceProvinceCode); JSONObject scoreProvinceJson = hkClient.getScore(provinceParam); if (scoreProvinceJson != null) { String code = scoreProvinceJson.getString("code"); if (ApiConstants.HKSuccessCode.equals(code)) { List data = scoreProvinceJson.getList("data", HKScoreResult.class); //根据数据转换为index对象 data.forEach(score -> { CheckIndexCar car = new CheckIndexCar(); CheckIndexFace face = new CheckIndexFace(); score2Index(score, car, face); car.setExamineTag(CheckConstants.Examine_Tag_Province); face.setExamineTag(CheckConstants.Examine_Tag_Province); Optional carFirst = checkIndexCarList.stream() .filter(index -> CheckConstants.Examine_Tag_Province.equals(index.getExamineTag()) && car.getDeptId().equals(index.getDeptId())) .findFirst(); Optional faceFirst = checkIndexFaceList.stream() .filter(index -> CheckConstants.Examine_Tag_Province.equals(index.getExamineTag()) && face.getDeptId().equals(index.getDeptId())) .findFirst(); if (carFirst.isPresent()) { car.setId(carFirst.get().getId()); } if (faceFirst.isPresent()) { face.setId(faceFirst.get().getId()); } cars.add(car); faces.add(face); }); } } //存放成绩到mysql,如果存在则替换不存在就新增。 if (!CollectionUtils.isEmpty(cars)) carService.saveOrUpdateBatch(cars); if (!CollectionUtils.isEmpty(faces)) faceService.saveOrUpdateBatch(faces); log.info("结束海康考核成绩数据"); } private void score2Index(HKScoreResult score, CheckIndexCar car, CheckIndexFace face) { car.setDeptId(Long.parseLong(AreaDeptEnum.fromCode(score.getAreaCode()).getDeptId() + "")); car.setCreateTime(new Date()); car.setPublish(PublishType.PUBLISHED.getCode()); face.setDeptId(Long.parseLong(AreaDeptEnum.fromCode(score.getAreaCode()).getDeptId() + "")); face.setCreateTime(new Date()); face.setPublish(PublishType.PUBLISHED.getCode()); car.setViewConnectStability(new BigDecimal(score.getDownCarDataUploadScoreString() == null ? "1" : score.getDownCarDataUploadScoreString())); car.setSiteOnline(new BigDecimal(score.getDownCrossQualityCarScoreString() == null ? "1" : score.getDownCrossQualityCarScoreString())); car.setDeviceDirectoryConsistent(new BigDecimal(score.getDownCrossNumPushCarScoreString() == null ? "1" : score.getDownCrossNumPushCarScoreString())); //TODO:没找到考核项 car.setVehicleInformationCollectionAccuracy(new BigDecimal("1")); car.setVehicleCaptureIntegrity(new BigDecimal(score.getDownCrossAllCarDataIntegrityScoreString() == null ? "1" : score.getDownCrossAllCarDataIntegrityScoreString())); //海康是设为1的,但是接口推的原始数据 car.setVehicleCaptureAccuracy(new BigDecimal("1")); car.setVehicleTimingAccuracy(new BigDecimal(score.getDownCrossCarInvertScoreString() == null ? "1" : score.getDownCrossCarInvertScoreString())); car.setVehicleUploadTimeliness(new BigDecimal(score.getDownCrossAllCarDelayScoreString() == null ? "1" : score.getDownCrossAllCarDelayScoreString())); //TODO:没找到考核项 car.setVehicleUrlAvailability(new BigDecimal("1")); car.setVehiclePictureAvailability(new BigDecimal(score.getDownCrossPictureQualityCarScoreString() == null ? "1" : score.getDownCrossPictureQualityCarScoreString())); face.setViewConnectStability(new BigDecimal(score.getDownFaceDataUploadScoreString() == null ? "1" : score.getDownFaceDataUploadScoreString())); face.setSiteOnline(new BigDecimal(score.getDownFaceDataUploadScoreString() == null ? "1" : score.getDownFaceDataUploadScoreString())); face.setDeviceDirectoryConsistent(new BigDecimal(score.getDownCrossNumPushFaceScoreString() == null ? "1" : score.getDownCrossNumPushFaceScoreString())); //TODO:没找到考核项 face.setFaceInformationCollectionAccuracy(new BigDecimal("1")); //TODO:没找到考核项 face.setFacePictureQualification(new BigDecimal("1")); face.setFaceTimingAccuracy(new BigDecimal(score.getDownCrossFaceInvertScoreString() == null ? "1" : score.getDownCrossFaceInvertScoreString())); face.setFaceUploadTimeliness(new BigDecimal(score.getDownCrossAllFaceDelayScoreString() == null ? "1" : score.getDownCrossAllFaceDelayScoreString())); face.setFacePictureAvailability(new BigDecimal(score.getDownCrossPictureQualityFaceScoreString() == null ? "1" : score.getDownCrossPictureQualityFaceScoreString())); } //解析数据 private List getDataList(JSONObject jsonObject, Class resultClass, String message) { if (jsonObject != null && ApiConstants.HKSuccessCode.equals(jsonObject.getString("code"))) { log.info("数据格式" + jsonObject); JSONObject data = jsonObject.getJSONObject("data"); if (data == null) { log.error(message, jsonObject); return null; } List list = data.getList("list", resultClass); if (CollectionUtils.isEmpty(list)) { log.error(message, data); return null; } return list; } else { log.error(message); } return null; } }