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/CheckIndexCar.java | 211 +++++-----------------------------------------------
1 files changed, 21 insertions(+), 190 deletions(-)
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexCar.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexCar.java
index 102550b..e7ce000 100644
--- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckIndexCar.java
+++ b/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;
}
}
--
Gitblit v1.8.0