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/da/passingStationCollection/domain/DaPassingStationCollection.java | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 54 insertions(+), 2 deletions(-) diff --git a/jcdm-main/src/main/java/com/jcdm/main/da/passingStationCollection/domain/DaPassingStationCollection.java b/jcdm-main/src/main/java/com/jcdm/main/da/passingStationCollection/domain/DaPassingStationCollection.java index f0f2348..6ced182 100644 --- a/jcdm-main/src/main/java/com/jcdm/main/da/passingStationCollection/domain/DaPassingStationCollection.java +++ b/jcdm-main/src/main/java/com/jcdm/main/da/passingStationCollection/domain/DaPassingStationCollection.java @@ -1,11 +1,20 @@ package com.jcdm.main.da.passingStationCollection.domain; import java.util.Date; + +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; /** * 浜у搧杩囩珯閲囬泦瀵硅薄 da_passing_station_collection @@ -13,6 +22,11 @@ * @author yyt * @date 2023-12-12 */ +@Data +@ExcelIgnoreUnannotated +@ColumnWidth(16) +@HeadRowHeight(14) +@HeadFontStyle(fontHeightInPoints = 11) public class DaPassingStationCollection extends BaseEntity { private static final long serialVersionUID = 1L; @@ -22,22 +36,29 @@ /** 宸ュ崟缂栧彿 */ @Excel(name = "宸ュ崟缂栧彿") + @ExcelProperty(value = "宸ュ崟缂栧彿", index = 0) private String workOrderNo; + private String repairFlag; + /** 鎬绘垚搴忓垪鍙� */ - @Excel(name = "鎬绘垚搴忓垪鍙�") + @Excel(name = "绠变綋缂栫爜") + @ExcelProperty(value = "绠变綋缂栫爜", index = 1) private String sfcCode; /** 浜у搧缂栧彿 */ @Excel(name = "浜у搧缂栧彿") + @ExcelProperty(value = "浜у搧缂栧彿", index = 2) private String productCode; /** 浜х嚎缂栧彿 */ @Excel(name = "浜х嚎缂栧彿") + @ExcelProperty(value = "浜х嚎缂栧彿", index = 3) private String productionLine; /** 宸ヤ綅缂栧彿 */ @Excel(name = "宸ヤ綅缂栧彿") + @ExcelProperty(value = "宸ヤ綅缂栧彿", index = 4) private String locationCode; /** 璁惧缂栧彿 */ @@ -47,12 +68,24 @@ /** 鍏ョ珯鏃堕棿 */ // @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "鍏ョ珯鏃堕棿") + @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @ExcelProperty(value = "鍏ョ珯鏃堕棿", index = 5) private Date inboundTime; /** 鍑虹珯鏃堕棿 */ // @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "鍑虹珯鏃堕棿") + @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @ExcelProperty(value = "鍑虹珯鏃堕棿", index = 6) private Date outboundTime; + + @TableField(exist = false) + private String startTime; + + @TableField(exist = false) + private String endTime; /** 鍏ョ珯鏄惁鍚堟牸 */ @Excel(name = "鍏ョ珯鏄惁鍚堟牸") @@ -64,15 +97,20 @@ /** 鍑虹珯鏄惁鍚堟牸 */ @Excel(name = "鍑虹珯鏄惁鍚堟牸") + @ExcelProperty(value = "鏄惁鍚堟牸", index = 7) private String outRsSign; /** 鍑虹珯NG鍘熷洜 */ @Excel(name = "鍑虹珯NG鍘熷洜") + @ExcelProperty(value = "NG鍘熷洜", index = 8) private String outMsgSign; /** 閲囬泦鏃堕棿 */ // @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "閲囬泦鏃堕棿") + @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @ExcelProperty(value = "閲囬泦鏃堕棿", index = 9) private Date collectionTime; /** 棰勭暀瀛楁1 */ @@ -89,9 +127,23 @@ /** 鑺傛媿鏃堕棿 */ @Excel(name = "鑺傛媿鏃堕棿") + @ExcelProperty(value = "鑺傛媿鏃堕棿", index = 10) private String beatTime; - public void setId(Long id) + @TableField(exist = false) + private Long beatTimeLong; + + private Long[] ids; + + public Long[] getIds() { + return ids; + } + + public void setIds(Long[] ids) { + this.ids = ids; + } + + public void setId(Long id) { this.id = id; } -- Gitblit v1.9.3