栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

OTA大屏-车范围不一致

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

OTA大屏-车范围不一致

contronller

@ApiOperation(value = "车范围不一致")
@GetMapping("/carRange")
public RespBean carRange() {
    return otaProcessPreviewService.carRange();
}

service

RespBean carRange();

serviceimpl

 
    @Override
    public RespBean carRange() {
        List corpList = carCorpMapper.getCarCorpList(new CarCorpPo());
        List selectTableNames = otaProcessLogMapper.selectTableNames(dataBaseConfig.getDatabase());
        Map result = new HashMap<>();
        //车范围不一致vin码
        AtomicInteger diffVinCnt = new AtomicInteger();
        //远程升级不及时
        AtomicInteger upgradeUntimely = new AtomicInteger();
        //安装超时
        AtomicInteger installTimeOut = new AtomicInteger();
        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);
                if (StringUtils.isNotBlank(tableName)) {
                    //获取备案信息中的数据与日志中的数据进行比较列表
                    List compareList = otaServicesMapper.getOtaDataAndLogDataCompareList(tableName, new DataQualityAnalysisQuery());
                    int vinnum = otaServicesMapper.getCarField(tableName, new DataQualityAnalysisQuery());
                    if (CollectionUtil.isNotEmpty(compareList)) {
                        compareList.forEach(data -> {
                            if (data != null) {
                                //VIN码不一致
                                diffVinCnt.set(diffVinCnt.get()+vinnum);
                                //远程升级不及时
                                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);
                                }
                                //安装超时
                                long installtime = 0;
                                if(StringUtils.isBlank(data.getOtaInstallTime()) || data.getLogUpgradeEnd() == null){
                                    installTimeOut.set(installTimeOut.get()+1);
                                }else {
                                    switch (data.getOtaInstallTime()){
                                        case "<15":
                                            installtime = 15;
                                            break;
                                        case "15-30":
                                            installtime = 30;
                                            break;
                                        case "30-60":
                                            installtime = 60;
                                            break;
                                        case "60-90":
                                            installtime = 90;
                                            break;
                                        default:
                                            break;

                                    }

                                    Calendar r = Calendar.getInstance();
                                    Date logUpgradeEnd =data.getLogUpgradeEnd();

                                    installtime = installtime*60000;
                                    Date logUpgradeStart = data.getLogUpgradeStart();
                                    if((logUpgradeEnd.getTime()-logUpgradeStart.getTime())>installtime){
                                        installTimeOut.set(installTimeOut.get()+1);
                                    }


//                                    r.setTime(logUpgradeEnd);
//                                    r.add(Calendar.MINUTE,installtime);
//                                    if(DateUtil.compare(r.getTime(),data.getLogUpgradeStart()) < 0){
//                                        installTimeOut.set(installTimeOut.get()+1);
//                                    }
                                }

                            }
                        });
                    }
                }

            });
        }

        result.put("diffVinCnt",diffVinCnt);
        result.put("upgradeUntimely",upgradeUntimely);
        result.put("installTimeOut",installTimeOut);

        return RespBean.ok("获取车范围不一致成功",result );
    }

VIN不一致mapper:

//查询车范围不一致数量:
int getCarField(@Param("logTableName") String logTableName, @Param("query") DataQualityAnalysisQuery query);

    select os.deploy_time               as otaUpgradeTime,
           os.deploy_period             as deployPeriod,
           os.ota_push_way              as otaPushWay,
           os.ota_push_way_remark       as otaPushWayRemark,
           op.ota_download_time         as otaDownloadTime,
           op.ota_install_time          as otaInstallTime,
           oplb.upgrade_way             as logUpgradeWay,
           oplb.upgrade_time            as logUpgradeTime,
           oplb.upgrade_start           as logUpgradeStart,
           oplb.upgrade_end             as logUpgradeEnd,
           os.ota_need_confirm_flag     as otaNeedConfirm,
           oplb.is_setup_flag           as logSetupFlag,
           oplb.record_num              as logRecordNum
    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
    
        orf.audit_state = 2
        
            and orf.report_time between #{query.beginDate} and #{query.endDate}
        
    

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/976181.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号