From 74ae355248c0bccadc80fb37bdb36aee5318fee8 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期三, 04 九月 2024 17:16:30 +0800
Subject: [PATCH] 考核指标导出优化

---
 ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java |   41 +++++++++++++++++++++++++++--------------
 1 files changed, 27 insertions(+), 14 deletions(-)

diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java
index 982515a..1e94d59 100644
--- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexVideo.java
+++ b/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;
+    }
 }

--
Gitblit v1.8.0