对每个车企的某个数据进行排名

最新推荐文章于 2024-09-16 11:16:36 发布

qq_41868957

最新推荐文章于 2024-09-16 11:16:36 发布

阅读量66

点赞数

分类专栏： zq-o

本文链接：https://blog.csdn.net/qq_41868957/article/details/125478004

版权

大数据

zq-o 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

/**
 * 远程升级周期监测-生产者 升级周期异常情况 排名
 * @return
 */

controller:

@ApiOperation(value = "远程升级周期监测-生产者 升级周期异常情况 排名")
    @PostMapping("/upgradeCycleExceptionTop")
    public RespBean upgradeCycleExceptionTop(@RequestBody DataQualityAnalysisQuery query){
        return remoteUpgradeCycleMonitorService.upgradeCycleExceptionTop(query);
    }

service:

RespBean upgradeCycleExceptionTop(@Param("query") DataQualityAnalysisQuery query);

serviceipml:

@Override
    public RespBean upgradeCycleExceptionTop(DataQualityAnalysisQuery query) {
        CarCorpPo carCorpPo = new CarCorpPo();
        carCorpPo.setRecordNum(query.getRecordNum());
        carCorpPo.setCorpCname(query.getCorpCname());
        List<CarCorpPo> corpList = carCorpMapper.getCarCorpList(carCorpPo);
        List<String> selectTableNames = otaProcessLogMapper.selectTableNames(dataBaseConfig.getDatabase());
        List<Map<String, Object>> list = new ArrayList<>();
        if (CollectionUtil.isNotEmpty(corpList) && CollectionUtil.isNotEmpty(selectTableNames)) {
            corpList.forEach(corp -> {
                String tableName = selectTableNames.stream().filter(selectTableName ->
                        StringUtils.equalsIgnoreCase(selectTableName, "ota_process_log_" + corp.getCorpEname())).findFirst().orElse(null);
                //异常报告次数
                AtomicInteger upgradeUntimely = new AtomicInteger();
                if (StringUtils.isNotBlank(tableName)) {
                    //获取备案信息中的数据与日志中的数据进行比较列表
                    List<OtaLogDataComparePo> compareList = remoteUpgradeCycleMonitorMapper.upgradeCycleExceptionTop(tableName, query);
                    if (CollectionUtil.isNotEmpty(compareList)) {
                        compareList.forEach(data -> {
                            boolean flag = true;
                            if (data != null) {
                                //远程升级不及时
                                Calendar ca = Calendar.getInstance();
                                Date otaUpgradeTime = data.getOtaUpgradeTime();
                                String deployPeriod = data.getDeployPeriod();
                                ca.setTime(otaUpgradeTime);
                                if(!StringUtils.isBlank(deployPeriod)){
                                    ca.add(Calendar.DATE,Integer.parseInt(deployPeriod));
                                }
                                if(DateUtil.compare(ca.getTime(), data.getLogUpgradeEnd()) < 0) {
                                    upgradeUntimely.set(upgradeUntimely.get() + 1);
                                    flag = false;
                                }
                            }
                        });
                    }
                }

                Map<String, Object> map = new HashMap<>();
                map.put("upgradeUntimely",upgradeUntimely.intValue());
                map.put("corpCname",corp.getCorpCname());
                list.add(map);
            });
        }
        //排序
        List<Map<String, Object>> collectList = list.stream().sorted(Comparator.comparing(item -> (Integer) item.get("upgradeUntimely"))).collect(Collectors.toList());
        Collections.reverse(collectList);
        return RespBean.ok("生产者 升级周期异常情况 排名",collectList.stream().limit(10) );
    }

mapper:

List<OtaLogDataComparePo> upgradeCycleExceptionTop(@Param("logTableName") String logTableName, @Param("query") DataQualityAnalysisQuery query);

xml:

<select id="upgradeCycleExceptionTop" resultType="com.zhuoqin.modules.otapr.po.OtaLogDataComparePo">
        select
               cc.corp_cname as corpCname,
        os.deploy_time               as otaUpgradeTime,
        os.deploy_period             as deployPeriod,
        oplb.upgrade_end             as logUpgradeEnd
        from ota_services os
        INNER join ota_packages op on os.record_num = op.record_num
        INNER join ota_report_flow orf on orf.record_num = os.record_num
        INNER join ${logTableName} oplb on op.record_num = oplb.record_num
        INNER join car_corp cc ON orf.cpid = cc.cpid
        <where>
            orf.audit_state = 2
            <if test="@com.zhuoqin.common.utils.Ognl@isNotEmpty(query.year)">
                and YEAR(orf.report_time) = #{query.year}
            </if>
        </where>
        GROUP BY orf.record_num
    </select>