package com.ycl.calculate;
|
|
import com.ycl.platform.domain.entity.CheckIndexCar;
|
import com.ycl.platform.domain.result.HK.SnapshotDataMonitorResult;
|
import com.ycl.platform.domain.vo.TMonitorVO;
|
import com.ycl.platform.mapper.CheckIndexCarMapper;
|
import com.ycl.platform.mapper.TMonitorMapper;
|
import com.ycl.platform.service.ICheckIndexCarService;
|
import com.ycl.system.mapper.SysConfigMapper;
|
import com.ycl.utils.DateUtils;
|
import constant.ApiConstants;
|
import constant.CheckSnapCountConstants;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.redis.core.RedisTemplate;
|
import org.springframework.stereotype.Component;
|
import org.springframework.util.CollectionUtils;
|
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.time.LocalDate;
|
import java.time.temporal.TemporalAdjusters;
|
import java.util.*;
|
import java.util.function.Function;
|
import java.util.stream.Collectors;
|
|
/**
|
* 计算车辆点位在线率、视图库对接稳定性
|
* 抓拍数据量监测结果接口数据
|
* 获取分省厅、区域的map<k,v> k为deptId或者Province_deptId
|
* 循环map计算点位在线率
|
* 更新或新增
|
*/
|
@Component
|
@Slf4j
|
public class CarSnapshopDataCalculation extends IndexCalculationServe implements CalculationStrategy<SnapshotDataMonitorResult> {
|
@Autowired
|
private CheckIndexCarMapper checkIndexCarMapper;
|
@Autowired
|
private SysConfigMapper sysConfigMapper;
|
@Autowired
|
private TMonitorMapper monitorMapper;
|
@Autowired
|
private ICheckIndexCarService checkIndexCarService;
|
@Autowired
|
private RedisTemplate redisTemplate;
|
|
//区域车辆点位在线指标的内部类
|
private static class AreaStats {
|
int totalSites = 0;
|
int onlineSites = 0;
|
int totalDataSum = 0;
|
}
|
|
@Override
|
public void calculate(List<SnapshotDataMonitorResult> list) {
|
if (CollectionUtils.isEmpty(list)) {
|
log.info("数据为空");
|
return;
|
}
|
|
//获得国标码为key的设备map
|
Map<String, TMonitorVO> monitorMap = monitorMapper.selectListByIds(list.stream().map(SnapshotDataMonitorResult::getExternalIndexCode).collect(Collectors.toList()))
|
.stream().collect(Collectors.toMap(TMonitorVO::getSerialNumber, Function.identity()));
|
//获取省厅国标码集合
|
List<String> provinceIds = getProvince();
|
|
Map<String, AreaStats> areaStatsMap = new HashMap<>();
|
// 获取当前日期
|
LocalDate today = LocalDate.now();
|
// 获取本月的第一天
|
LocalDate firstDayOfMonth = today.with(TemporalAdjusters.firstDayOfMonth());
|
// 判断今天是否是本月的第一天
|
if (today.equals(firstDayOfMonth)) {
|
// 如果是，则清除Redis中记录中断次数的数据
|
redisTemplate.delete(ApiConstants.Check_Car_ViewConnect);
|
}
|
for (SnapshotDataMonitorResult result : list) {
|
TMonitorVO monitor = monitorMap.get(result.getExternalIndexCode());
|
if (monitor == null) continue;
|
|
String deptId = monitor.getDeptId().toString();
|
updateAreaStats(areaStatsMap, deptId, result);
|
|
// 处理省厅数据
|
if (!CollectionUtils.isEmpty(provinceIds) && provinceIds.contains(monitor.getSerialNumber())) {
|
String provinceKey = ApiConstants.Province + deptId;
|
updateAreaStats(areaStatsMap, provinceKey, result);
|
}
|
}
|
|
//获取2022同期抓拍平均值 省厅、市局
|
BigDecimal cityCountAvg = getAverageCount(CheckSnapCountConstants.Car_City);
|
BigDecimal countyCountAvg = getAverageCount(CheckSnapCountConstants.Car_County);
|
|
// 查询是否index表已经存在今日数据
|
List<CheckIndexCar> checkIndexCarList = checkIndexCarMapper.selectToday(DateUtils.getDate());
|
List<CheckIndexCar> checkIndexCars = new ArrayList<>();
|
areaStatsMap.forEach((key, stats) -> {
|
if (stats.totalSites > 0) {
|
CheckIndexCar checkIndexCar = createOrUpdateCheckIndexCar(key, stats, cityCountAvg, countyCountAvg, checkIndexCarList);
|
if (checkIndexCar != null) {
|
checkIndexCars.add(checkIndexCar);
|
}
|
}
|
});
|
|
checkIndexCarService.saveOrUpdateBatch(checkIndexCars);
|
}
|
|
/**
|
* 累计总点位数、离线数、总抓拍量
|
*/
|
private void updateAreaStats(Map<String, AreaStats> areaStatsMap, String key, SnapshotDataMonitorResult result) {
|
//返回对象的引用，如果不存在会放入新的key,value
|
AreaStats stats = areaStatsMap.computeIfAbsent(key, k -> new AreaStats());
|
stats.totalSites++;
|
|
if (ApiConstants.HK_SnapCount_ResultType_Null != result.getResultType()) {
|
stats.onlineSites++;
|
stats.totalDataSum += result.getDataCount();
|
}
|
|
}
|
|
/**
|
* 获取2022同期抓拍平均值
|
*/
|
private BigDecimal getAverageCount(String configKey) {
|
String count = sysConfigMapper.checkConfigKeyUnique(configKey).getConfigValue();
|
return new BigDecimal(count)
|
.multiply(new BigDecimal(CheckSnapCountConstants.Multiply))
|
.divide(new BigDecimal(CheckSnapCountConstants.CountyNum), 10, RoundingMode.HALF_UP)
|
.divide(new BigDecimal(LocalDate.now().getDayOfMonth()), 0, RoundingMode.HALF_UP);
|
}
|
|
/**
|
* 车辆点位在线率和视图库对接稳定性
|
*/
|
private CheckIndexCar createOrUpdateCheckIndexCar(String key, AreaStats stats, BigDecimal cityCountAvg, BigDecimal countyCountAvg, List<CheckIndexCar> checkIndexCarList) {
|
CheckIndexCar checkIndexCar = getCheckIndex(key, checkIndexCarList, CheckIndexCar.class);
|
if (checkIndexCar == null) {
|
return null;
|
}
|
|
//调用点位在线计算方法
|
if (stats.totalSites >= ApiConstants.Check_Car_SiteOnline) {
|
Map<String, Object> siteOnlineParam = new HashMap<>();
|
siteOnlineParam.put("totalSites", stats.totalSites);
|
siteOnlineParam.put("onlineSites", stats.onlineSites);
|
BigDecimal siteOnline = siteOnline(siteOnlineParam);
|
checkIndexCar.setSiteOnline(siteOnline.min(BigDecimal.ONE));
|
} else {
|
checkIndexCar.setSiteOnline(BigDecimal.ZERO);
|
}
|
//视图库对接稳定性
|
//Redis记录该区县当月无数据上传次数
|
Integer noDateCount = (Integer) redisTemplate.opsForHash().get(ApiConstants.Check_Car_ViewConnect, key);
|
// 如果值为null，则初始化为0
|
if (noDateCount == null) {
|
noDateCount = 0;
|
}
|
Double deductScore = 0.1 * noDateCount;
|
if (stats.totalDataSum != 0) {
|
BigDecimal avgCount = key.startsWith(ApiConstants.Province) ? cityCountAvg : countyCountAvg;
|
Map<String, Object> viewConnectParam = new HashMap<>();
|
viewConnectParam.put("totalDataSum", stats.totalDataSum);
|
viewConnectParam.put("avgCount", avgCount);
|
BigDecimal viewConnectStability = viewConnectStability(viewConnectParam);
|
viewConnectStability = viewConnectStability.subtract(new BigDecimal(deductScore)).max(BigDecimal.ZERO).min(BigDecimal.ONE);
|
checkIndexCar.setViewConnectStability(viewConnectStability);
|
} else {
|
noDateCount++;
|
}
|
// 将新的值放回Hash中
|
redisTemplate.opsForHash().put(ApiConstants.Check_Car_ViewConnect, key, noDateCount);
|
return checkIndexCar;
|
}
|
}
|
