From 220f7b818bb9399391830fbbb9fb2028a21b938f Mon Sep 17 00:00:00 2001
From: yyt <306727702@qq.com>
Date: 星期三, 21 二月 2024 00:23:34 +0800
Subject: [PATCH] 批量数据采集方法更新
---
jcdm-main/src/main/java/com/jcdm/main/bs/orderScheduling/domain/BsOrderScheduling.java | 78 +++++++++++++++++++++++++++++++++++---
1 files changed, 71 insertions(+), 7 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 9df79cd..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,5 +1,11 @@
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;
@@ -20,6 +26,10 @@
* @date 2024-01-13
*/
@Data
+@ExcelIgnoreUnannotated
+@ColumnWidth(16)
+@HeadRowHeight(14)
+@HeadFontStyle(fontHeightInPoints = 11)
public class BsOrderScheduling extends BaseEntity
{
private static final long serialVersionUID = 1L;
@@ -29,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;
/** 鏄惁鎵撳嵃 */
@@ -65,111 +96,144 @@
/** 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;
/** 鍚堢涓婄嚎鏃堕棿 */
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@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;
/** 鍚堢涓嬬嚎鏃堕棿 */
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@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;
/** 鎬昏涓婄嚎鏃堕棿 */
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@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;
/** 鎬昏涓嬬嚎鏃堕棿 */
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@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涓婄嚎鏃堕棿 */
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@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涓嬬嚎鏃堕棿 */
- @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@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() {
--
Gitblit v1.9.3