车辆点位在线接口 TODO省厅点位集合待查询

fuliqi

2024-07-29 a5e63d287b38d38ed530e71568546de447ac50f4

车辆点位在线接口 TODO省厅点位集合待查询

 ycl-common/src/main/java/constant/CheckSnapCountConstants.java

New file
@@ -0,0 +1,23 @@
package constant;


public class CheckSnapCountConstants {
    /**
     * 2022年同期抓拍量(省厅)
     */
    public final static String City = "check.snapCount.city";
    /**
     * 2022年同期抓拍量(区县)
     */
    public final static String County = "check.snapCount.county";

    /**
     * 2022抓拍数计算倍率
     */
    public final static String Multiply = "1.2";

    /**
     * 区域个数
     */
    public final static Integer CountyNum = 7;
}

 ycl-server/src/main/java/com/ycl/platform/service/impl/CheckIndexCarServiceImpl.java

@@ -10,10 +10,13 @@
import com.ycl.platform.mapper.CheckIndexCarMapper;
import com.ycl.platform.service.ICheckIndexCarService;
import com.ycl.platform.service.ITMonitorService;
import com.ycl.system.domain.SysConfig;
import com.ycl.system.entity.SysDept;
import com.ycl.system.mapper.SysConfigMapper;
import com.ycl.system.mapper.SysDeptMapper;
import constant.ApiConstants;
import constant.CheckConstants;
import constant.CheckSnapCountConstants;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -38,6 +41,8 @@
public class CheckIndexCarServiceImpl extends ServiceImpl<CheckIndexCarMapper, CheckIndexCar> implements ICheckIndexCarService {
    @Autowired
    private CheckIndexCarMapper checkIndexCarMapper;
    @Autowired
    private SysConfigMapper sysConfigMapper;
    @Autowired
    private ITMonitorService monitorService;
    @Autowired
@@ -109,112 +114,116 @@
    public int deleteCheckIndexCarById(Long id) {
        return checkIndexCarMapper.deleteCheckIndexCarById(id);
    }

    /**
     * 计算车辆点位在线率、视图库对接稳定性
     *  获取分省厅、区域的map<k,v> k为deptId或者Province_deptId
     *  循环map计算点位在线率
     *  更新或新增
     * 获取分省厅、区域的map<k,v> k为deptId或者Province_deptId
     * 循环map计算点位在线率
     * 更新或新增
     *
     * @param list
     */
    //TODO:视图库对接稳定性
    //TODO：任务顺序需要排在一机一档之后
    @Override
    public void siteOnline(List<SnapshotDataMonitorResult> list) {
        //设备id
        List<String> deviceIds = list.stream().map(SnapshotDataMonitorResult::getExternalIndexCode).collect(Collectors.toList());
        if (!CollectionUtils.isEmpty(deviceIds)) {
            // 用于存储每个区域统计信息的辅助类
            class AreaStats {
                //点位总数
                int totalSites = 0;
                //离线点位数
                int offlineSites = 0;
                //总抓拍量
                int totalDataSum = 0;
            }
            List<TMonitor> monitors = monitorService.list(new QueryWrapper<TMonitor>().in("serial_number", deviceIds));
            Map<String, AreaStats> areaStatsMap = new HashMap<>();
            //获得所有区县deptId
            List<Long> deptIds = deptMapper.selectByParentId(207L);
            deptIds.forEach(deptId -> areaStatsMap.put(deptId + "", new AreaStats()));

            //转换为map
            //TODO：分省厅市局  需要补充集合数据
            List<String> provinceIds = new ArrayList<>();
            Map<String, TMonitor> monitorMap = monitors.stream().collect(Collectors.toMap(TMonitor::getSerialNumber, Function.identity()));
            for (SnapshotDataMonitorResult result : list) {
                TMonitor monitor = monitorMap.get(result.getExternalIndexCode());
                AreaStats areaStats = areaStatsMap.get(monitor.getDeptId() + "");
                String serialNumber = monitor.getSerialNumber();
                //无数据
                if (ApiConstants.HK_SnapCount_ResultType_Null == result.getResultType()) {
                    //区域离线点位数
                    areaStats.offlineSites++;
                } else {
                    //区域总抓拍量
                    areaStats.totalSites += result.getDataCount();
                }
                //区域点位总数
                areaStats.totalDataSum++;
                //是否是省厅数据
                if (!CollectionUtils.isEmpty(provinceIds)) {
                    if (provinceIds.contains(serialNumber)) {
                        //省厅数据
                        AreaStats provinceStats = areaStatsMap.get("Province_" + monitor.getDeptId());
                        //无数据
                        if (ApiConstants.HK_SnapCount_ResultType_Null == result.getResultType()) {
                            //区域离线点位数
                            provinceStats.offlineSites++;
                        } else {
                            //区域总抓拍量
                            provinceStats.totalDataSum += result.getDataCount();
                        }
                        //区域点位总数
                        provinceStats.totalSites++;
                        areaStatsMap.put("Province_" + monitor.getDeptId(), areaStats);
                    }
                }
                areaStatsMap.put(monitor.getDeptId() + "", areaStats);
            }
            List<CheckIndexCar> checkIndexCarList = checkIndexCarMapper.selectToday(DateUtils.getDate());
            List<CheckIndexCar> checkIndexCars = new ArrayList<>();
            areaStatsMap.forEach((k, v) -> {
                if (v.totalSites == 0) {
                    log.info("部门id为{}总点位数为0", k);
                } else {
                    CheckIndexCar checkIndexCar = new CheckIndexCar();
                    //找是否已经存在数据
                    Optional<CheckIndexCar> first;
                    if (k.startsWith("Province_")) {
                        //省厅
                        String[] idArray = k.split("_");
                        first = checkIndexCarList.stream().filter(item -> idArray[1].equals(item.getDeptId() + "") && CheckConstants.Examine_Tag_City.equals(item.getExamineTag()))
                                .findFirst();
                        checkIndexCar.setExamineTag(CheckConstants.Examine_Tag_City);
                        checkIndexCar.setDeptId(Long.parseLong(idArray[1]));
                    } else {
                        //区县
                        first = checkIndexCarList.stream().filter(item -> k.equals(item.getDeptId() + "") && CheckConstants.Examine_Tag_County.equals(item.getExamineTag()))
                                .findFirst();
                        checkIndexCar.setExamineTag(CheckConstants.Examine_Tag_County);
                        checkIndexCar.setDeptId(Long.parseLong(k));
                    }
                    checkIndexCar.setCreateTime(new Date());
                    if (first.isPresent()) {
                        checkIndexCar = first.get();
                    }
                    // 将整数转换为BigDecimal
                    BigDecimal totalSitesBd = new BigDecimal(v.totalSites);
                    BigDecimal offlineSitesBd = new BigDecimal(v.offlineSites);
                    // 执行计算，保留四位小数并四舍五入
                    BigDecimal onlineSitesBd = totalSitesBd.subtract(offlineSitesBd);
                    BigDecimal siteOnline = onlineSitesBd.divide(totalSitesBd, 4, RoundingMode.HALF_UP);
                    checkIndexCar.setSiteOnline(siteOnline);
                    checkIndexCars.add(checkIndexCar);
                }
            });

            saveOrUpdateBatch(checkIndexCars);
        if (CollectionUtils.isEmpty(list)) {
            return;
        }

        Map<String, AreaStats> areaStatsMap = new HashMap<>();
        Map<String, TMonitor> monitorMap = monitorService.list(new QueryWrapper<TMonitor>()
                        .in("serial_number", list.stream().map(SnapshotDataMonitorResult::getExternalIndexCode).collect(Collectors.toList())))
                .stream().collect(Collectors.toMap(TMonitor::getSerialNumber, Function.identity()));

        // TODO: 分省厅市局 需要补充集合数据
        List<String> provinceIds = new ArrayList<>(); // 这里需要根据点位补充

        for (SnapshotDataMonitorResult result : list) {
            TMonitor 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 = "Province_" + deptId;
                updateAreaStats(areaStatsMap, provinceKey, result);
            }
        }

        //获取2022同期抓拍平均值 省厅、市局
        BigDecimal cityCountAvg = getAverageCount(CheckSnapCountConstants.City);
        BigDecimal countyCountAvg = getAverageCount(CheckSnapCountConstants.County);

        // 查询今日数据
        List<CheckIndexCar> checkIndexCarList = checkIndexCarMapper.selectToday(DateUtils.getDate());
        List<CheckIndexCar> checkIndexCars = new ArrayList<>();
        areaStatsMap.forEach((deptId, stats) -> {
            if (stats.totalSites > 0) {
                CheckIndexCar checkIndexCar = createOrUpdateCheckIndexCar(deptId, stats, cityCountAvg, countyCountAvg, checkIndexCarList);
                checkIndexCars.add(checkIndexCar);
            }
        });

        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.offlineSites++;
        } else {
            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), 0, RoundingMode.HALF_UP);
    }
    //车辆点位在线率和视图库对接稳定性
    private CheckIndexCar createOrUpdateCheckIndexCar(String key, AreaStats stats, BigDecimal cityCountAvg, BigDecimal countyCountAvg, List<CheckIndexCar> checkIndexCarList) {
        CheckIndexCar checkIndexCar;

        // 检查是否已存在今日数据
        Optional<CheckIndexCar> existingCar = checkIndexCarList.stream()
                .filter(car -> key.equals(car.getDeptId().toString()) &&
                        (key.startsWith("Province_") ? CheckConstants.Examine_Tag_City.equals(car.getExamineTag())
                                : CheckConstants.Examine_Tag_County.equals(car.getExamineTag())))
                .findFirst();

        if (existingCar.isPresent()) {
            checkIndexCar = existingCar.get();
        } else {
            checkIndexCar = new CheckIndexCar();
            checkIndexCar.setDeptId(key.startsWith("Province_") ? Long.parseLong(key.split("_")[1]) : Long.parseLong(key));
            checkIndexCar.setExamineTag(key.startsWith("Province_") ? CheckConstants.Examine_Tag_City : CheckConstants.Examine_Tag_County);
            checkIndexCar.setCreateTime(new Date());
        }

        // 点位在线率
        BigDecimal totalSitesBd = new BigDecimal(stats.totalSites);
        BigDecimal offlineSitesBd = new BigDecimal(stats.offlineSites);
        BigDecimal onlineSitesBd = totalSitesBd.subtract(offlineSitesBd);
        checkIndexCar.setSiteOnline(onlineSitesBd.divide(totalSitesBd, 4, RoundingMode.HALF_UP));
        //视图库对接稳定性
        BigDecimal avgCount = key.startsWith("Province_") ? cityCountAvg : countyCountAvg;
        checkIndexCar.setViewConnectStability(new BigDecimal(stats.totalDataSum).divide(avgCount, 4, RoundingMode.HALF_UP));

        return checkIndexCar;
    }

    //区域车辆点位在线指标的内部类
    private static class AreaStats {
        int totalSites = 0;
        int offlineSites = 0;
        int totalDataSum = 0;
    }

}