考核指标导出优化

fuliqi

2024-09-04 74ae355248c0bccadc80fb37bdb36aee5318fee8

考核指标导出优化

 ycl-pojo/src/main/java/com/ycl/platform/base/CheckIndex.java

@@ -27,14 +27,11 @@
    public String deptName;

    /** 考核标签（省厅/市局） */
//    @Excel(name = "考核标签", dictType = "platform_examine_tag")
    @TableField("examine_tag")
    public Short examineTag;

    @Excel(name = "考核标签")
    @TableField(exist = false)
    public String examineTagStr;

    @TableField(exist = false)
    public List<Integer> deptIds;
    public Long getId() {

 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexCar.java

@@ -1,13 +1,15 @@
package com.ycl.platform.domain.entity;

import annotation.Excel;
import com.alibaba.excel.annotation.ExcelIgnore;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.ycl.platform.base.CheckIndex;
import com.ycl.platform.domain.vo.CheckIndexCarVO;
import constant.CheckConstants;
import lombok.Data;
import org.springframework.lang.NonNull;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
@@ -16,58 +18,49 @@
 * @author ruoyi
 * @date 2024-04-29
 */
@Data
@TableName("t_check_index_car")
public class CheckIndexCar extends CheckIndex
{
    private static final long serialVersionUID = 1L;

    /** 视图库对接稳定性 */
    @Excel(name = "视图库对接稳定性")
    @TableField("view_connect_stability")
    private BigDecimal viewConnectStability;

    /** 点位在线率 */
    @Excel(name = "点位在线率")
    @TableField("site_online")
    private BigDecimal siteOnline;

    /** 联网卡口设备目录一致率 */
    @Excel(name = "联网卡口设备目录一致率",width = 25)
    @TableField("device_directory_consistent")
    private BigDecimal deviceDirectoryConsistent;

    /** 车辆卡口信息采集准确率 */
    @Excel(name = "车辆卡口信息采集准确率",width = 25)
    @TableField("vehicle_information_collection_accuracy")
    private BigDecimal vehicleInformationCollectionAccuracy;

    /** 车辆卡口设备抓拍数据完整性 */
    @Excel(name = "车辆卡口设备抓拍数据完整性",width = 25)
    @TableField("vehicle_capture_integrity")
    private BigDecimal vehicleCaptureIntegrity;

    /** 车辆卡口设备抓拍数据准确性 */
    @Excel(name = "车辆卡口设备抓拍数据准确性",width = 25)
    @TableField("vehicle_capture_accuracy")
    private BigDecimal vehicleCaptureAccuracy;

    /** 车辆卡口设备时钟准确性 */
    @Excel(name = "车辆卡口设备时钟准确性",width = 25)
    @TableField("vehicle_timing_accuracy")
    private BigDecimal vehicleTimingAccuracy;

    /** 车辆卡口设备抓拍数据上传及时性 */
    @Excel(name = "车辆卡口设备抓拍数据上传及时性",width = 25)
    @TableField("vehicle_upload_timeliness")
    private BigDecimal vehicleUploadTimeliness;

    /** 车辆卡口设备url可用性 */
    @Excel(name = "车辆卡口设备url可用性",width = 25)
    @TableField("vehicle_url_availability")
    private BigDecimal vehicleUrlAvailability;

    /** 车辆卡口设备抓拍数据大图可用性 */
    @Excel(name = "车辆卡口设备抓拍数据大图可用性",width = 25)
    @TableField("vehicle_picture_availability")
    private BigDecimal vehiclePictureAvailability;

@@ -75,184 +68,22 @@
    @TableField(exist = false)
    private List<String> quarter;

    public List<String> getQuarter() {
        return quarter;
    }

    public void setQuarter(List<String> quarter) {
        this.quarter = quarter;
    }

    @Override
    public Long getId() {
        return super.getId();
    }

    @Override
    public void setId(Long id) {
        super.setId(id);
    }

    @Override
    public String getDate() {
        return super.getDate();
    }

    @Override
    public void setDate(String date) {
        super.setDate(date);
    }

    @Override
    public Date getCreateTime() {
        return super.getCreateTime();
    }

    @Override
    public void setCreateTime(Date createTime) {
        super.setCreateTime(createTime);
    }

    @Override
    public Long getDeptId() {
        return super.getDeptId();
    }

    @Override
    public void setDeptId(Long deptId) {
        super.setDeptId(deptId);
    }

    @Override
    public String getDeptName() {
        return super.getDeptName();
    }

    @Override
    public void setDeptName(String deptName) {
        super.setDeptName(deptName);
    }

    @Override
    public Short getExamineTag() {
        return super.getExamineTag();
    }

    @Override
    public void setExamineTag(Short examineTag) {
        super.setExamineTag(examineTag);
    }
    public void setViewConnectStability(BigDecimal viewConnectStability)
    {
        this.viewConnectStability = viewConnectStability;
    }

    public BigDecimal getViewConnectStability()
    {
        return viewConnectStability;
    }
    public void setSiteOnline(BigDecimal siteOnline)
    {
        this.siteOnline = siteOnline;
    }

    public BigDecimal getSiteOnline()
    {
        return siteOnline;
    }
    public void setDeviceDirectoryConsistent(BigDecimal deviceDirectoryConsistent)
    {
        this.deviceDirectoryConsistent = deviceDirectoryConsistent;
    }

    public BigDecimal getDeviceDirectoryConsistent()
    {
        return deviceDirectoryConsistent;
    }
    public void setVehicleInformationCollectionAccuracy(BigDecimal vehicleInformationCollectionAccuracy)
    {
        this.vehicleInformationCollectionAccuracy = vehicleInformationCollectionAccuracy;
    }

    public BigDecimal getVehicleInformationCollectionAccuracy()
    {
        return vehicleInformationCollectionAccuracy;
    }
    public void setVehicleCaptureIntegrity(BigDecimal vehicleCaptureIntegrity)
    {
        this.vehicleCaptureIntegrity = vehicleCaptureIntegrity;
    }

    public BigDecimal getVehicleCaptureIntegrity()
    {
        return vehicleCaptureIntegrity;
    }
    public void setVehicleCaptureAccuracy(BigDecimal vehicleCaptureAccuracy)
    {
        this.vehicleCaptureAccuracy = vehicleCaptureAccuracy;
    }

    public BigDecimal getVehicleCaptureAccuracy()
    {
        return vehicleCaptureAccuracy;
    }
    public void setVehicleTimingAccuracy(BigDecimal vehicleTimingAccuracy)
    {
        this.vehicleTimingAccuracy = vehicleTimingAccuracy;
    }

    public BigDecimal getVehicleTimingAccuracy()
    {
        return vehicleTimingAccuracy;
    }
    public void setVehicleUploadTimeliness(BigDecimal vehicleUploadTimeliness)
    {
        this.vehicleUploadTimeliness = vehicleUploadTimeliness;
    }

    public BigDecimal getVehicleUploadTimeliness()
    {
        return vehicleUploadTimeliness;
    }
    public void setVehicleUrlAvailability(BigDecimal vehicleUrlAvailability)
    {
        this.vehicleUrlAvailability = vehicleUrlAvailability;
    }

    public BigDecimal getVehicleUrlAvailability()
    {
        return vehicleUrlAvailability;
    }
    public void setVehiclePictureAvailability(BigDecimal vehiclePictureAvailability)
    {
        this.vehiclePictureAvailability = vehiclePictureAvailability;
    }


    public BigDecimal getVehiclePictureAvailability()
    {
        return vehiclePictureAvailability;
    }

    @Override
    public String toString() {
        return "CheckIndexCar{" +
                "id=" + id +
                ", date='" + date + '\'' +
                ", createTime=" + createTime +
                ", deptId=" + deptId +
                ", deptName='" + deptName + '\'' +
                ", examineTag=" + examineTag +
                ", viewConnectStability=" + viewConnectStability +
                ", siteOnline=" + siteOnline +
                ", deviceDirectoryConsistent=" + deviceDirectoryConsistent +
                ", vehicleInformationCollectionAccuracy=" + vehicleInformationCollectionAccuracy +
                ", vehicleCaptureIntegrity=" + vehicleCaptureIntegrity +
                ", vehicleCaptureAccuracy=" + vehicleCaptureAccuracy +
                ", vehicleTimingAccuracy=" + vehicleTimingAccuracy +
                ", vehicleUploadTimeliness=" + vehicleUploadTimeliness +
                ", vehicleUrlAvailability=" + vehicleUrlAvailability +
                ", vehiclePictureAvailability=" + vehiclePictureAvailability +
                '}';
    public static CheckIndexCarVO getExcelVo(@NonNull CheckIndexCar checkIndexCar) {
        CheckIndexCarVO checkIndexCarVo = new CheckIndexCarVO();
        checkIndexCarVo.setDeptName(checkIndexCar.getDeptName());
        checkIndexCarVo.setDate(checkIndexCar.getDate());
        checkIndexCarVo.setExamineTagStr(CheckConstants.Examine_Tag_Province.equals(checkIndexCar.getExamineTag()) ? "省厅考核" : "区县考核");
        checkIndexCarVo.setSiteOnlineText(checkIndexCar.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehicleCaptureAccuracyText(checkIndexCar.getVehicleCaptureAccuracy().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setDeviceDirectoryConsistentText(checkIndexCar.getDeviceDirectoryConsistent().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehicleCaptureIntegrityText(checkIndexCar.getVehicleCaptureIntegrity().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehicleTimingAccuracyText(checkIndexCar.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehicleUploadTimelinessText(checkIndexCar.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setViewConnectStabilityText(checkIndexCar.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehicleUrlAvailabilityText(checkIndexCar.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehiclePictureAvailabilityText(checkIndexCar.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexCarVo.setVehicleInformationCollectionAccuracyText(checkIndexCar.getVehicleInformationCollectionAccuracy().multiply(new BigDecimal(100))+"%");
        return checkIndexCarVo;
    }
}

 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexFace.java

@@ -5,6 +5,11 @@
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.ycl.platform.base.CheckIndex;
import com.ycl.platform.domain.vo.CheckIndexCarVO;
import com.ycl.platform.domain.vo.CheckIndexFaceVO;
import constant.CheckConstants;
import lombok.Data;
import org.springframework.lang.NonNull;

import java.math.BigDecimal;
import java.util.Date;
@@ -16,48 +21,56 @@
 * @author ruoyi
 * @date 2024-04-29
 */
@Data
@TableName("t_check_index_face")
public class CheckIndexFace extends CheckIndex
{
public class CheckIndexFace extends CheckIndex {
    private static final long serialVersionUID = 1L;

    /** 视图库对接稳定性 */
    @Excel(name = "视图库对接稳定性")
    /**
     * 视图库对接稳定性
     */
    @TableField("view_connect_stability")
    private BigDecimal viewConnectStability;

    /** 点位在线率 */
    @Excel(name = "点位在线率")
    /**
     * 点位在线率
     */
    @TableField("site_online")
    private BigDecimal siteOnline;

    /**  设备目录一致率 */
    @Excel(name = " 设备目录一致率")
    /**
     * 设备目录一致率
     */
    @TableField("device_directory_consistent")
    private BigDecimal deviceDirectoryConsistent;

    /** 人脸卡口信息采集准确率 */
    @Excel(name = "人脸卡口信息采集准确率",width = 25)
    /**
     * 人脸卡口信息采集准确率
     */
    @TableField("face_information_collection_accuracy")
    private BigDecimal faceInformationCollectionAccuracy;

    /** 设备抓拍图片合格性 */
    @Excel(name = "设备抓拍图片合格性")
    /**
     * 设备抓拍图片合格性
     */
    @TableField("face_picture_qualification")
    private BigDecimal facePictureQualification;

    /** 设备抓拍图片时钟准确性 */
    @Excel(name = "设备抓拍图片时钟准确性",width = 25)
    /**
     * 设备抓拍图片时钟准确性
     */
    @TableField("face_timing_accuracy")
    private BigDecimal faceTimingAccuracy;

    /** 抓拍人脸数据上传及时性 */
    @Excel(name = "抓拍人脸数据上传及时性",width = 25)
    /**
     * 抓拍人脸数据上传及时性
     */
    @TableField("face_upload_timeliness")
    private BigDecimal faceUploadTimeliness;

    /** 人脸卡口设备抓拍数据大图可用性 */
    @Excel(name = "人脸卡口设备抓拍数据大图可用性",width = 25)
    /**
     * 人脸卡口设备抓拍数据大图可用性
     */
    @TableField("face_picture_availability")
    private BigDecimal facePictureAvailability;

@@ -65,155 +78,20 @@
    @TableField(exist = false)
    private List<String> quarter;

    public List<String> getQuarter() {
        return quarter;
    }
    public static CheckIndexFaceVO getExcelVo(@NonNull CheckIndexFace checkIndexFace) {
        CheckIndexFaceVO checkIndexFaceVo = new CheckIndexFaceVO();
        checkIndexFaceVo.setDeptName(checkIndexFace.getDeptName());
        checkIndexFaceVo.setDate(checkIndexFace.getDate());
        checkIndexFaceVo.setExamineTagStr(CheckConstants.Examine_Tag_Province.equals(checkIndexFace.getExamineTag()) ? "省厅考核" : "区县考核");
        checkIndexFaceVo.setSiteOnlineText(checkIndexFace.getSiteOnline().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setFaceInformationCollectionAccuracyText(checkIndexFace.getFaceInformationCollectionAccuracy().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setFacePictureAvailabilityText(checkIndexFace.getFacePictureAvailability().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setDeviceDirectoryConsistentTextText(checkIndexFace.getDeviceDirectoryConsistent().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setFaceTimingAccuracyText(checkIndexFace.getFaceTimingAccuracy().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setFacePictureQualificationText(checkIndexFace.getFacePictureQualification().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setViewConnectStabilityText(checkIndexFace.getViewConnectStability().multiply(new BigDecimal(100)) + "%");
        checkIndexFaceVo.setFaceUploadTimelinessText(checkIndexFace.getFaceUploadTimeliness().multiply(new BigDecimal(100)) + "%");

    public void setQuarter(List<String> quarter) {
        this.quarter = quarter;
    }

    public BigDecimal getViewConnectStability() {
        return viewConnectStability;
    }

    public void setViewConnectStability(BigDecimal viewConnectStability) {
        this.viewConnectStability = viewConnectStability;
    }

    public BigDecimal getSiteOnline() {
        return siteOnline;
    }

    public void setSiteOnline(BigDecimal siteOnline) {
        this.siteOnline = siteOnline;
    }

    public BigDecimal getDeviceDirectoryConsistent() {
        return deviceDirectoryConsistent;
    }

    public void setDeviceDirectoryConsistent(BigDecimal deviceDirectoryConsistent) {
        this.deviceDirectoryConsistent = deviceDirectoryConsistent;
    }

    public BigDecimal getFaceInformationCollectionAccuracy() {
        return faceInformationCollectionAccuracy;
    }

    public void setFaceInformationCollectionAccuracy(BigDecimal faceInformationCollectionAccuracy) {
        this.faceInformationCollectionAccuracy = faceInformationCollectionAccuracy;
    }

    public BigDecimal getFacePictureQualification() {
        return facePictureQualification;
    }

    public void setFacePictureQualification(BigDecimal facePictureQualification) {
        this.facePictureQualification = facePictureQualification;
    }

    public BigDecimal getFaceTimingAccuracy() {
        return faceTimingAccuracy;
    }

    public void setFaceTimingAccuracy(BigDecimal faceTimingAccuracy) {
        this.faceTimingAccuracy = faceTimingAccuracy;
    }

    public BigDecimal getFaceUploadTimeliness() {
        return faceUploadTimeliness;
    }

    public void setFaceUploadTimeliness(BigDecimal faceUploadTimeliness) {
        this.faceUploadTimeliness = faceUploadTimeliness;
    }

    public BigDecimal getFacePictureAvailability() {
        return facePictureAvailability;
    }

    public void setFacePictureAvailability(BigDecimal facePictureAvailability) {
        this.facePictureAvailability = facePictureAvailability;
    }

    @Override
    public Long getId() {
        return super.getId();
    }

    @Override
    public void setId(Long id) {
        super.setId(id);
    }

    @Override
    public String getDate() {
        return super.getDate();
    }

    @Override
    public void setDate(String date) {
        super.setDate(date);
    }

    @Override
    public Date getCreateTime() {
        return super.getCreateTime();
    }

    @Override
    public void setCreateTime(Date createTime) {
        super.setCreateTime(createTime);
    }

    @Override
    public Long getDeptId() {
        return super.getDeptId();
    }

    @Override
    public void setDeptId(Long deptId) {
        super.setDeptId(deptId);
    }

    @Override
    public String getDeptName() {
        return super.getDeptName();
    }

    @Override
    public void setDeptName(String deptName) {
        super.setDeptName(deptName);
    }

    @Override
    public Short getExamineTag() {
        return super.getExamineTag();
    }

    @Override
    public void setExamineTag(Short examineTag) {
        super.setExamineTag(examineTag);
    }

    @Override
    public String toString() {
        return "CheckIndexFace{" +
                "id=" + id +
                ", date='" + date + '\'' +
                ", createTime=" + createTime +
                ", deptId=" + deptId +
                ", deptName='" + deptName + '\'' +
                ", examineTag=" + examineTag +
                ", viewConnectStability=" + viewConnectStability +
                ", siteOnline=" + siteOnline +
                ", deviceDirectoryConsistent=" + deviceDirectoryConsistent +
                ", faceInformationCollectionAccuracy=" + faceInformationCollectionAccuracy +
                ", facePictureQualification=" + facePictureQualification +
                ", faceTimingAccuracy=" + faceTimingAccuracy +
                ", faceUploadTimeliness=" + faceUploadTimeliness +
                ", facePictureAvailability=" + facePictureAvailability +
                '}';
        return checkIndexFaceVo;
    }
}

 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java

@@ -5,7 +5,11 @@
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.ycl.platform.base.CheckIndex;
import com.ycl.platform.domain.vo.CheckIndexCarVO;
import com.ycl.platform.domain.vo.CheckIndexVideoVO;
import constant.CheckConstants;
import lombok.Data;
import org.springframework.lang.NonNull;

import java.math.BigDecimal;
import java.util.Date;
@@ -25,98 +29,84 @@
    /**
     * 平台在线率
     */
    @Excel(name = "平台在线率")
    @TableField("platform_online")
    private BigDecimal platformOnline;

    /**
     * 一机一档合格率
     */
    @Excel(name = "一机一档合格率")
    @TableField("monitor_qualification")
    private BigDecimal monitorQualification;

    /**
     * 档案考核比
     */
    @Excel(name = "一机一档注册率")
    @TableField("monitor_registration")
    private BigDecimal monitorRegistration;

    /**
     * 档案考核比
     */
    @Excel(name = "档案考核比")
    @TableField("archives_rate")
    private BigDecimal archivesRate;

    /**
     * 点位在线率
     */
    @Excel(name = "点位在线率")
    @TableField("site_online")
    private BigDecimal siteOnline;

    /**
     * 录象可用率
     */
    @Excel(name = "录象可用率")
    @TableField("video_available")
    private BigDecimal videoAvailable;

    /**
     * 部级点位在线率
     */
    @Excel(name = "部级点位在线率")
    @TableField("ministry_site_online")
    private BigDecimal ministrySiteOnline;

    /**
     * 部级巡检录像可用率
     */
    @Excel(name = "部级巡检录像可用率")
    @TableField("ministry_video_available")
    private BigDecimal ministryVideoAvailable;

    /**
     * 重点点位在线率
     */
    @Excel(name = "重点点位在线率")
    @TableField("key_site_online")
    private BigDecimal keySiteOnline;

    /**
     * 重点点位录象可用率
     */
    @Excel(name = "重点点位录象可用率", width = 25)
    @TableField("key_video_available")
    private BigDecimal keyVideoAvailable;

    /**
     * 重点点位标注正确率
     */
    @Excel(name = "重点点位标注正确率", width = 25)
    @TableField("key_annotation_accuracy")
    private BigDecimal keyAnnotationAccuracy;

    /**
     * 重点点位按时正确率
     */
    @Excel(name = "重点点位按时正确率", width = 25)
    @TableField("key_timing_accuracy")
    private BigDecimal keyTimingAccuracy;

    /**
     *  重点指挥图像在线率
     */
    @Excel(name = "重点指挥图像在线率", width = 25)
    @TableField("key_command_image_online")
    private BigDecimal keyCommandImageOnline;

    /**
     * 视频图像资源安全管理
     */
    @Excel(name = "视频图像资源安全管理", width = 25)
    @TableField("image_resource_security")
    private BigDecimal imageResourceSecurity;

@@ -124,4 +114,27 @@
    @ExcelIgnore
    @TableField(exist = false)
    private List<String> quarter;

    public static CheckIndexVideoVO getExcelVo(@NonNull CheckIndexVideo checkIndexVideo) {
        CheckIndexVideoVO checkIndexVideoVO = new CheckIndexVideoVO();
        checkIndexVideoVO.setDeptName(checkIndexVideo.getDeptName());
        checkIndexVideoVO.setDate(checkIndexVideo.getDate());
        checkIndexVideoVO.setExamineTagStr(CheckConstants.Examine_Tag_Province.equals(checkIndexVideo.getExamineTag()) ? "省厅考核" : "区县考核");
        checkIndexVideoVO.setSiteOnlineText(checkIndexVideo.getSiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setImageResourceSecurityText(checkIndexVideo.getImageResourceSecurity().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setArchivesRateText(checkIndexVideo.getArchivesRate().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setKeyAnnotationAccuracyText(checkIndexVideo.getKeyAnnotationAccuracy().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setKeyCommandImageOnlineText(checkIndexVideo.getKeyCommandImageOnline().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setKeyVideoAvailableText(checkIndexVideo.getKeyVideoAvailable().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setKeySiteOnlineText(checkIndexVideo.getKeySiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setKeyTimingAccuracyText(checkIndexVideo.getKeyTimingAccuracy().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setMinistryVideoAvailableText(checkIndexVideo.getMinistryVideoAvailable().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setVideoAvailableText(checkIndexVideo.getVideoAvailable().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setMinistrySiteOnlineText(checkIndexVideo.getMinistrySiteOnline().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setPlatformOnlineText(checkIndexVideo.getPlatformOnline().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setMonitorQualificationText(checkIndexVideo.getMonitorQualification().multiply(new BigDecimal(100))+"%");
        checkIndexVideoVO.setMonitorRegistrationText(checkIndexVideo.getMonitorRegistration().multiply(new BigDecimal(100))+"%");

        return checkIndexVideoVO;
    }
}

 ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckIndexCarVO.java

New file
@@ -0,0 +1,47 @@
package com.ycl.platform.domain.vo;

import annotation.Excel;
import com.ycl.platform.base.CheckIndex;
import lombok.Data;
@Data
public class CheckIndexCarVO extends CheckIndex {
    /** 视图库对接稳定性 */
    @Excel(name = "视图库对接稳定性")
    private String viewConnectStabilityText;

    /** 点位在线率 */
    @Excel(name = "点位在线率")
    private String siteOnlineText;

    /** 联网卡口设备目录一致率 */
    @Excel(name = "联网卡口设备目录一致率",width = 25)
    private String deviceDirectoryConsistentText;

    /** 车辆卡口信息采集准确率 */
    @Excel(name = "车辆卡口信息采集准确率",width = 25)
    private String vehicleInformationCollectionAccuracyText;

    /** 车辆卡口设备抓拍数据完整性 */
    @Excel(name = "车辆卡口设备抓拍数据完整性",width = 25)
    private String vehicleCaptureIntegrityText;

    /** 车辆卡口设备抓拍数据准确性 */
    @Excel(name = "车辆卡口设备抓拍数据准确性",width = 25)
    private String vehicleCaptureAccuracyText;

    /** 车辆卡口设备时钟准确性 */
    @Excel(name = "车辆卡口设备时钟准确性",width = 25)
    private String vehicleTimingAccuracyText;

    /** 车辆卡口设备抓拍数据上传及时性 */
    @Excel(name = "车辆卡口设备抓拍数据上传及时性",width = 25)
    private String vehicleUploadTimelinessText;

    /** 车辆卡口设备url可用性 */
    @Excel(name = "车辆卡口设备url可用性",width = 25)
    private String vehicleUrlAvailabilityText;

    /** 车辆卡口设备抓拍数据大图可用性 */
    @Excel(name = "车辆卡口设备抓拍数据大图可用性",width = 25)
    private String vehiclePictureAvailabilityText;
}

 ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckIndexFaceVO.java

New file
@@ -0,0 +1,40 @@
package com.ycl.platform.domain.vo;

import annotation.Excel;
import com.ycl.platform.base.CheckIndex;
import lombok.Data;

@Data
public class CheckIndexFaceVO extends CheckIndex {
    /** 视图库对接稳定性 */
    @Excel(name = "视图库对接稳定性")
    private String viewConnectStabilityText;

    /** 点位在线率 */
    @Excel(name = "点位在线率")
    private String siteOnlineText;

    /**  设备目录一致率 */
    @Excel(name = " 设备目录一致率")
    private String deviceDirectoryConsistentTextText;

    /** 人脸卡口信息采集准确率 */
    @Excel(name = "人脸卡口信息采集准确率",width = 25)
    private String faceInformationCollectionAccuracyText;

    /** 设备抓拍图片合格性 */
    @Excel(name = "设备抓拍图片合格性")
    private String facePictureQualificationText;

    /** 设备抓拍图片时钟准确性 */
    @Excel(name = "设备抓拍图片时钟准确性",width = 25)
    private String faceTimingAccuracyText;

    /** 抓拍人脸数据上传及时性 */
    @Excel(name = "抓拍人脸数据上传及时性",width = 25)
    private String faceUploadTimelinessText;

    /** 人脸卡口设备抓拍数据大图可用性 */
    @Excel(name = "人脸卡口设备抓拍数据大图可用性",width = 25)
    private String facePictureAvailabilityText;
}

 ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckIndexVideoVO.java

New file
@@ -0,0 +1,96 @@
package com.ycl.platform.domain.vo;

import annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableField;
import com.ycl.platform.base.CheckIndex;
import lombok.Data;

import java.math.BigDecimal;

@Data
public class CheckIndexVideoVO extends CheckIndex {
    /**
     * 平台在线率
     */
    @Excel(name = "平台在线率")
    private String platformOnlineText;

    /**
     * 一机一档合格率
     */
    @Excel(name = "一机一档合格率")
    private String monitorQualificationText;

    /**
     * 档案考核比
     */
    @Excel(name = "一机一档注册率")
    private String monitorRegistrationText;

    /**
     * 档案考核比
     */
    @Excel(name = "档案考核比")
    private String archivesRateText;

    /**
     * 点位在线率
     */
    @Excel(name = "点位在线率")
    private String siteOnlineText;

    /**
     * 录象可用率
     */
    @Excel(name = "录象可用率")
    private String videoAvailableText;

    /**
     * 部级点位在线率
     */
    @Excel(name = "部级点位在线率")
    private String ministrySiteOnlineText;

    /**
     * 部级巡检录像可用率
     */
    @Excel(name = "部级巡检录像可用率")
    private String ministryVideoAvailableText;

    /**
     * 重点点位在线率
     */
    @Excel(name = "重点点位在线率")
    private String keySiteOnlineText;

    /**
     * 重点点位录象可用率
     */
    @Excel(name = "重点点位录象可用率", width = 25)
    private String keyVideoAvailableText;

    /**
     * 重点点位标注正确率
     */
    @Excel(name = "重点点位标注正确率", width = 25)
    private String keyAnnotationAccuracyText;

    /**
     * 重点点位按时正确率
     */
    @Excel(name = "重点点位按时正确率", width = 25)
    private String keyTimingAccuracyText;

    /**
     *  重点指挥图像在线率
     */
    @Excel(name = "重点指挥图像在线率", width = 25)
    private String keyCommandImageOnlineText;

    /**
     * 视频图像资源安全管理
     */
    @Excel(name = "视频图像资源安全管理", width = 25)
    private String imageResourceSecurityText;

}

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

@@ -2,12 +2,14 @@

import annotation.DataScope;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.platform.domain.dto.CheckScoreDTO;
import com.ycl.platform.domain.dto.CheckScoreIndexDTO;
import com.ycl.platform.domain.dto.ScoreIndexDTO;
import com.ycl.platform.domain.entity.*;
import com.ycl.platform.domain.vo.CheckIndexCarVO;
import com.ycl.platform.domain.vo.CheckIndexFaceVO;
import com.ycl.platform.domain.vo.CheckIndexVideoVO;
import com.ycl.platform.domain.vo.CheckScoreDetailVO;
import com.ycl.platform.mapper.CheckRuleMapper;
import com.ycl.platform.mapper.CheckScoreMapper;
@@ -270,28 +272,34 @@
        checkIndexCar.setDate(date);
        checkIndexCar.setQuarter(checkScoreDTO.getQuarter());
        List<CheckIndexCar> checkIndexCars = indexCarService.selectCheckIndexCarList(checkIndexCar);
        List<CheckIndexCarVO> checkIndexCarVOS = new ArrayList<>();
        for (CheckIndexCar indexCar : checkIndexCars) {
            indexCar.setExamineTagStr(CheckConstants.Examine_Tag_Province.equals(indexCar.getExamineTag()) ? "省厅考核" : "区县考核");
            CheckIndexCarVO excelVo = CheckIndexCar.getExcelVo(indexCar);
            checkIndexCarVOS.add(excelVo);
        }
        ExcelExp e1 = new ExcelExp("车辆考核指标数据", checkIndexCars, CheckIndexCar.class);
        ExcelExp e1 = new ExcelExp("车辆考核指标数据", checkIndexCarVOS, CheckIndexCarVO.class);
        //人脸
        CheckIndexFace checkIndexFace = new CheckIndexFace();
        checkIndexFace.setDate(date);
        checkIndexFace.setQuarter(checkScoreDTO.getQuarter());
        List<CheckIndexFace> checkIndexFaces = indexFaceService.selectCheckIndexFaceList(checkIndexFace);
        List<CheckIndexFaceVO> checkIndexFaceVOS = new ArrayList<>();
        for (CheckIndexFace indexFace : checkIndexFaces) {
            indexFace.setExamineTagStr(CheckConstants.Examine_Tag_Province.equals(indexFace.getExamineTag()) ? "省厅考核" : "区县考核");
            CheckIndexFaceVO excelVo = CheckIndexFace.getExcelVo(indexFace);
            checkIndexFaceVOS.add(excelVo);
        }
        ExcelExp e2 = new ExcelExp("人脸考核指标数据", checkIndexFaces, CheckIndexFace.class);
        ExcelExp e2 = new ExcelExp("人脸考核指标数据", checkIndexFaceVOS, CheckIndexFaceVO.class);
        //视频
        CheckIndexVideo checkIndexVideo = new CheckIndexVideo();
        checkIndexVideo.setDate(date);
        checkIndexVideo.setQuarter(checkScoreDTO.getQuarter());
        List<CheckIndexVideo> checkIndexVideos = indexVideoService.selectCheckIndexVideoList(checkIndexVideo);
        List<CheckIndexVideoVO> checkIndexVideoVOS = new ArrayList<>();
        for (CheckIndexVideo indexVideo : checkIndexVideos) {
            indexVideo.setExamineTagStr(CheckConstants.Examine_Tag_Province.equals(indexVideo.getExamineTag()) ? "省厅考核" : "区县考核");
            CheckIndexVideoVO excelVo = CheckIndexVideo.getExcelVo(indexVideo);
            checkIndexVideoVOS.add(excelVo);
        }
        ExcelExp e3 = new ExcelExp("视频考核指标数据", checkIndexVideos, CheckIndexVideo.class);
        ExcelExp e3 = new ExcelExp("视频考核指标数据", checkIndexVideoVOS, CheckIndexVideoVO.class);

        List<ExcelExp> mysheet = new ArrayList<>();
        mysheet.add(e1);

 ycl-server/src/main/resources/mapper/zgyw/CheckScoreMapper.xml

@@ -144,7 +144,7 @@
            <if test="params.publish != null  and params.publish != ''">and publish = #{params.publish}</if>
            ${params.dataScope}
        </where>
        GROUP BY tcs.dept_id, tcs.examine_category, tcs.examine_tag
--         GROUP BY tcs.dept_id, tcs.examine_category, tcs.examine_tag
    </select>

    <select id="getLast" resultType="com.ycl.platform.domain.entity.CheckScore">