分页操作-PageQuery＜Map＜String, String＞＞ query

qq_41868957

于 2022-06-27 00:05:54 发布

阅读量352

点赞数

分类专栏： zq-o 文章标签： java 前端大数据

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

版权

zq-o 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

controller:

@ApiOperation(value = "车辆范围列表")
    @PostMapping("/carRangeList")
    public RespBean<UpgradeAbnormalRankPO> carRangeList(@RequestBody PageQuery<Map<String, String>> query){
        return carRangeMonitorService.carRangeList(query);
    }

service:

RespBean<UpgradeAbnormalRankPO> carRangeList(PageQuery<Map<String, String>> query);

serviceImpl

@Override
    public RespBean<UpgradeAbnormalRankPO> carRangeList(PageQuery<Map<String, String>> query){
        List<OtaLogPo> range = redisCache.redisTemplate.opsForList().range(RedisKey.PROCESS_LOG_LIST, 0, 0);

        String corpCname = "";
        String recordNum = "";
        String dateType;
        if (StringUtils.isBlank(query.getOriginalT().get("corpCname")) && StringUtils.isBlank(query.getOriginalT().get("recordNumber"))) {
            if(range.size()>0){
                corpCname = range.get(0).getCorpCname();
                recordNum = range.get(0).getRecordNum();
            }

//        query.setT(new HashMap<>());
        }else {
            corpCname = query.getOriginalT().get("corpCname");
            recordNum = query.getOriginalT().get("recordNumber");
        }
        dateType = query.getOriginalT().get("dateType");

        if(StringUtils.isEmpty(corpCname)){
            return RespBean.error("生产者名称为空！");
        }
        Map<String, Object> result2 = new HashMap<>();
        String tableSuffix = null,  tableName = null;
        String cpId = carCorpMapper.getIdByCname(corpCname);
        //查询生产者英文简称
        if (StringUtils.isEmpty(recordNum)) {
            Example example = new Example(CarCorp.class);
            example.createCriteria().andEqualTo(CarCorp.CPID, cpId);
            CarCorp carCorp = carCorpMapper.selectOneByExample(example);
            if (carCorp == null) {
                return RespBean.error("数据异常!");
            }
            tableSuffix = carCorp.getCorpEname().toLowerCase(Locale.ROOT);
        } else {
            tableSuffix = BaseEntity.getEnterpriseName(recordNum);
        }
        tableName = "ota_process_log_" + tableSuffix;
        //校验表是否存在
        int exist = otaProcessLogMapper.isTableExist(tableSuffix, dataBaseConfig.getDatabase());
        if (exist <= 0) {
            return RespBean.error("无过程日志");
        }
        PageHelper.startPage(query.getPageNum(), query.getPageSize());
        List<UpgradeAbnormalRankPO> list = otaProcessLogMapper.getCarRangeDetails(recordNum,tableName,dateType);
//        int totalCarNum = otaProcessLogMapper.getTotalCarNum(recordNum,tableName,dateTpye);
//        List<String> list1 = otaProcessLogMapper.getVinlist(tableName,dateTpye);
//        List<String> list1 = otaProcessLogMapper.getVinList(recordNum,corpCname,dateTpye);

        PageSerializable<UpgradeAbnormalRankPO> result = PageSerializable.of(list);
        return RespBean.ok("获取车辆范围列表成功",result);
    }