From a9406b6b18ee5a8e29cad3248f46320a36ac9749 Mon Sep 17 00:00:00 2001
From: yyt <306727702@qq.com>
Date: 星期三, 21 二月 2024 00:19:44 +0800
Subject: [PATCH] 批量数据采集方法更新
---
jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java | 166 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 165 insertions(+), 1 deletions(-)
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java
index ad4499b..6756f87 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java
@@ -1,9 +1,23 @@
package com.jcdm.main.bs.orderScheduling.domain;
+import com.alibaba.excel.annotation.ExcelIgnore;
+import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
+import com.alibaba.excel.annotation.ExcelProperty;
+import com.alibaba.excel.annotation.write.style.ColumnWidth;
+import com.alibaba.excel.annotation.write.style.HeadFontStyle;
+import com.alibaba.excel.annotation.write.style.HeadRowHeight;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import lombok.Data;
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.jcdm.common.annotation.Excel;
import com.jcdm.common.core.domain.BaseEntity;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.time.LocalDateTime;
+import java.util.Date;
+import java.util.List;
/**
* 璁㈠崟鎺掍骇瀵硅薄 bs_order_scheduling
@@ -11,6 +25,11 @@
* @author jiang
* @date 2024-01-13
*/
+@Data
+@ExcelIgnoreUnannotated
+@ColumnWidth(16)
+@HeadRowHeight(14)
+@HeadFontStyle(fontHeightInPoints = 11)
public class BsOrderScheduling extends BaseEntity
{
private static final long serialVersionUID = 1L;
@@ -20,34 +39,55 @@
/** 璁㈠崟缂栧彿 */
@Excel(name = "璁㈠崟缂栧彿")
+ @ExcelProperty(value = "璁㈠崟缂栧彿", index = 0)
private String orderNo;
/** 鍙戝姩鏈哄彿 */
- @Excel(name = "鍙戝姩鏈哄彿")
+ @Excel(name = "绠变綋缂栫爜")
+ @ExcelProperty(value = "绠变綋缂栫爜", index = 1)
private String engineNo;
+
+ @TableField(exist = false)
+ @ExcelIgnore
+ private List<String> engineNoList;
+
+ @TableField(exist = false)
+ @ExcelIgnore
+ private List<String> engineNoListExcel;
+
/** 浜у搧绫诲瀷 */
@Excel(name = "浜у搧绫诲瀷")
private String productType;
+ @ExcelProperty(value = "浜у搧绫诲瀷", index = 2)
+ private String productTypeString;
+
/** 鏈哄瀷 */
@Excel(name = "鏈哄瀷")
+ @ExcelProperty(value = "鏈哄瀷", index = 3)
private String model;
/** 鐢熶骇鐘舵�� */
@Excel(name = "鐢熶骇鐘舵��")
private String productionStatus;
+ @ExcelProperty(value = "鐢熶骇鐘舵��", index = 4)
+ private String productionStatusString;
+
/** 宸ユ椂 */
@Excel(name = "宸ユ椂")
+ @ExcelProperty(value = "宸ユ椂", index = 5)
private String workingHours;
/** 褰撳墠宸ヤ綅 */
@Excel(name = "褰撳墠宸ヤ綅")
+ @ExcelProperty(value = "褰撳墠宸ヤ綅", index = 6)
private String currentWorkstation;
/** 璐ㄩ噺鐘舵�� */
@Excel(name = "璐ㄩ噺鐘舵��")
+ @ExcelProperty(value = "璐ㄩ噺鐘舵��", index = 7)
private String qualityStatus;
/** 鏄惁鎵撳嵃 */
@@ -56,70 +96,194 @@
/** 10鎶ュ伐 */
@Excel(name = "10鎶ュ伐")
+ @ExcelIgnore
private String report10;
/** 20鎶ュ伐 */
@Excel(name = "20鎶ュ伐")
+ @ExcelIgnore
private String report20;
/** 鍚堢涓婄嚎 */
@Excel(name = "鍚堢涓婄嚎")
+ @ExcelIgnore
private String combinedBoxTime;
/** 鎬昏涓嬬嚎 */
@Excel(name = "鎬昏涓嬬嚎")
+ @ExcelIgnore
private String finalAssemblyTime;
/** 鎿嶄綔浜� */
@Excel(name = "鎿嶄綔浜�")
+ @ExcelProperty(value = "鎿嶄綔浜�", index = 14)
private String operator;
/** 鎿嶄綔鏃堕棿 */
@Excel(name = "鎿嶄綔鏃堕棿")
+ @ExcelProperty(value = "鎿嶄綔鏃堕棿", index = 15)
private String operateTime;
/** 鐘舵�� */
@Excel(name = "鐘舵��")
+ @ExcelIgnore
private String status;
/** 棰勭暀瀛楁1 */
@Excel(name = "棰勭暀瀛楁1")
+ @ExcelIgnore
private String spareField1;
/** 棰勭暀瀛楁2 */
@Excel(name = "棰勭暀瀛楁2")
+ @ExcelIgnore
private String spareField2;
/** 棰勭暀瀛楁3 */
@Excel(name = "棰勭暀瀛楁3")
+ @ExcelIgnore
private String spareField3;
/** 棰勭暀瀛楁4 */
@Excel(name = "棰勭暀瀛楁4")
+ @ExcelIgnore
private String spareField4;
/** 鍒涘缓鐢ㄦ埛 */
@Excel(name = "鍒涘缓鐢ㄦ埛")
+ @ExcelIgnore
private String createUser;
/** 鏇存敼鐢ㄦ埛 */
@Excel(name = "鏇存敼鐢ㄦ埛")
+ @ExcelIgnore
private String updateUser;
/** 澶囨敞 */
@Excel(name = "澶囨敞")
+ @ExcelIgnore
private String remarks;
/** CVT鎶ュ伐 */
@Excel(name = "CVT鎶ュ伐")
+ @ExcelIgnore
private String report30;
+ @ExcelIgnore
private String[] dateConditions;
+ @ExcelIgnore
private String startTime;
+ @ExcelIgnore
private String endTime;
+ /** 鍚堢涓婄嚎鏃堕棿 */
+ @Excel(name = "鍚堢涓婄嚎鏃堕棿")
+ @ExcelProperty(value = "鍚堢涓婄嚎鏃堕棿", index = 8)
+ @com.alibaba.excel.annotation.format.DateTimeFormat("yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date boxClosingOnlineTime;
+
+ /** 鍚堢涓嬬嚎鏃堕棿 */
+ @Excel(name = "鍚堢涓嬬嚎鏃堕棿")
+ @ExcelProperty(value = "鍚堢涓嬬嚎鏃堕棿", index = 9)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date closingBoxOfflineTime;
+
+ /** 鎬昏涓婄嚎鏃堕棿 */
+ @Excel(name = "鎬昏涓婄嚎鏃堕棿")
+ @ExcelProperty(value = "鎬昏涓婄嚎鏃堕棿", index =10)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date finalAssemblyLaunchTime;
+
+ /** 鎬昏涓嬬嚎鏃堕棿 */
+ @Excel(name = "鎬昏涓嬬嚎鏃堕棿")
+ @ExcelProperty(value = "鎬昏涓嬬嚎鏃堕棿", index = 11)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date finalAssemblyOfflineTime;
+
+ /** CVT涓婄嚎鏃堕棿 */
+ @Excel(name = "CVT涓婄嚎鏃堕棿")
+ @ExcelProperty(value = "CVT涓婄嚎鏃堕棿", index = 12)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date cvtLaunchTime;
+
+ /** CVT涓嬬嚎鏃堕棿 */
+ @Excel(name = "CVT涓嬬嚎鏃堕棿")
+ @ExcelProperty(value = "CVT涓嬬嚎鏃堕棿", index = 13)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date cvtOfflineTime;
+
+ @TableField(exist = false)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @ExcelIgnore
+ private LocalDateTime startQuery;
+
+ @TableField(exist = false)
+ @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @ExcelIgnore
+ private LocalDateTime endQuery;
+
+ @TableField(exist = false)
+ @ExcelIgnore
+ private String queryField;
+
+ public Date getBoxClosingOnlineTime() {
+ return boxClosingOnlineTime;
+ }
+
+ public void setBoxClosingOnlineTime(Date boxClosingOnlineTime) {
+ this.boxClosingOnlineTime = boxClosingOnlineTime;
+ }
+
+ public Date getClosingBoxOfflineTime() {
+ return closingBoxOfflineTime;
+ }
+
+ public void setClosingBoxOfflineTime(Date closingBoxOfflineTime) {
+ this.closingBoxOfflineTime = closingBoxOfflineTime;
+ }
+
+ public Date getFinalAssemblyLaunchTime() {
+ return finalAssemblyLaunchTime;
+ }
+
+ public void setFinalAssemblyLaunchTime(Date finalAssemblyLaunchTime) {
+ this.finalAssemblyLaunchTime = finalAssemblyLaunchTime;
+ }
+
+ public Date getFinalAssemblyOfflineTime() {
+ return finalAssemblyOfflineTime;
+ }
+
+ public void setFinalAssemblyOfflineTime(Date finalAssemblyOfflineTime) {
+ this.finalAssemblyOfflineTime = finalAssemblyOfflineTime;
+ }
+
+ public Date getCvtLaunchTime() {
+ return cvtLaunchTime;
+ }
+
+ public void setCvtLaunchTime(Date cvtLaunchTime) {
+ this.cvtLaunchTime = cvtLaunchTime;
+ }
+
+ public Date getCvtOfflineTime() {
+ return cvtOfflineTime;
+ }
+
+ public void setCvtOfflineTime(Date cvtOfflineTime) {
+ this.cvtOfflineTime = cvtOfflineTime;
+ }
+
public String[] getDateConditions() {
return dateConditions;
}
--
Gitblit v1.9.3