大屏升级过程态势-新增表: OTA升级包大小排 区间

controller

/**
 *升级过程态势-OTA升级包大小
 */
@ApiOperation("升级过程态势-OTA升级包大小")
@GetMapping("/getOtaPackage")
public RespBean<OtaPackagePo> getOtaPackage() {
    return RespBean.ok("获取升级包大小成功", otaProcessPreviewService.getOtaPackage());
}

service

/**
 * 升级过程态势-OTA升级包大小
 */
OtaPackagePo getOtaPackage();

serviceimpl

/**
 * 升级过程态势-OTA升级包大小
 */
@Override
public OtaPackagePo getOtaPackage() {
    OtaPackagePo otaPackage = otaStatisticsMapper.getOtaPackage();
    return otaPackage;
}

po

package com.zhuoqin.modules.screen.po;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class OtaPackagePo {
    @ApiModelProperty(value = "OTA升级包大小0-100M")
    private String otaPackageSize1;
    @ApiModelProperty(value = "OTA升级包大小101-1024M")
    private String otaPackageSize2;
    @ApiModelProperty(value = "OTA升级包大小1025-5120M")
    private String otaPackageSize3;
    @ApiModelProperty(value = "OTA升级包大小5121M以上")
    private String otaPackageSize4;
}

mapper

//升级过程态势-OTA升级包大小
OtaPackagePo getOtaPackage();

xml

<!--OTA升级包大小-->
<select id="getOtaPackage" resultType="com.zhuoqin.modules.screen.po.OtaPackagePo">
    SELECT
        ( SELECT COUNT( package_size ) FROM ota_package_details WHERE package_size BETWEEN 0 AND 100 ) AS otaPackageSize1,
        ( SELECT COUNT( package_size ) FROM ota_package_details WHERE package_size BETWEEN 101 AND 1024 ) AS otaPackageSize2,
        ( SELECT COUNT( package_size ) FROM ota_package_details WHERE package_size BETWEEN 1025 AND 5120 ) AS otaPackageSize3,
        ( SELECT COUNT( package_size ) FROM ota_package_details WHERE package_size > 5120 ) AS otaPackageSize4
</select>