From 8d4ad0d13ef71e22cc1036e2c6c00aafb20ed597 Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期二, 10 十二月 2024 17:41:58 +0800 Subject: [PATCH] 电路试验的驻波比csv报告解析 --- inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java | 95 +++++++++++++++++++++++++++++++++-------------- 1 files changed, 66 insertions(+), 29 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java b/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java index 820d6b9..95d6e99 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/pojo/StandardProductList.java @@ -1,15 +1,16 @@ package com.yuanchu.mom.pojo; +import com.alibaba.excel.annotation.ExcelIgnore; +import com.alibaba.excel.annotation.ExcelProperty; import com.baomidou.mybatisplus.annotation.*; - -import java.io.Serializable; -import java.math.BigDecimal; -import java.time.LocalDateTime; -import java.util.Date; - import com.fasterxml.jackson.annotation.JsonFormat; +import com.fasterxml.jackson.databind.annotation.JsonSerialize; +import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; import io.swagger.annotations.ApiModelProperty; import lombok.Data; + +import java.io.Serializable; +import java.time.LocalDateTime; /** * 鏍囧噯鏍戜笅鐨勬楠岄」鐩� @@ -21,149 +22,166 @@ /** * 涓婚敭id */ - @TableId(type = IdType.AUTO) - private Integer id; + @TableId(value = "id",type = IdType.ASSIGN_ID) + @JsonSerialize(using = ToStringSerializer.class) + @ExcelIgnore + private Long id; /** * 妫�楠岄」 */ @ApiModelProperty("妫�楠岄」") + @ExcelProperty(value = "妫�娴嬪弬鏁板悕绉�") private String inspectionItem; - /** - * 妫�楠岄」鍒嗙被 - */ - @ApiModelProperty("妫�楠岄」鍒嗙被") - private String inspectionItemClassify; + @ApiModelProperty("妫�楠岄」EN") + @ExcelProperty(value = "妫�娴嬪弬鏁板悕绉�(EN)") + private String inspectionItemEn; /** * 妫�楠岄」灏忕被 */ @ApiModelProperty("妫�楠岄」灏忕被") + @ExcelProperty(value = "妫�娴嬪瓙椤�") private String inspectionItemSubclass; + + @ApiModelProperty("妫�楠岄」灏忕被EN") + @ExcelProperty(value = "妫�娴嬪瓙椤�(EN)") + private String inspectionItemSubclassEn; /** * 瀹為獙瀹� */ @ApiModelProperty("瀹為獙瀹�") + @ExcelIgnore private String laboratory; @ApiModelProperty("瀛愬疄楠屽") + @ExcelProperty(value = "璇曢獙瀹�") private String sonLaboratory; /** * 璁¢噺鍗曚綅 */ @ApiModelProperty("璁¢噺鍗曚綅") + @ExcelProperty(value = "璁¢噺鍗曚綅") private String unit; /** * 鍗曚环(鍏�) */ @ApiModelProperty("鍗曚环") - private BigDecimal price; + @ExcelProperty(value = "鍗曚环") + private String price; /** * 宸ユ椂(H) */ @ApiModelProperty("宸ユ椂") - private Double manHour; + @ExcelProperty(value = "宸ユ椂绯绘暟") + private String manHour; /** * 宸ユ椂鍒嗙粍 */ @ApiModelProperty("宸ユ椂鍒嗙粍") + @ExcelProperty(value = "宸ユ椂鍒嗙粍") private String manHourGroup; /** * 妫�楠岄」绫诲瀷 */ @ApiModelProperty("妫�楠岄」绫诲瀷") + @ExcelProperty(value = "妫�楠岄」绫诲瀷") private String inspectionItemType; /** * 妫�楠屽�肩被鍨� */ @ApiModelProperty("妫�楠屽�肩被鍨�") + @ExcelProperty(value = "鏁版嵁绫诲瀷") private String inspectionValueType; - - /** - * 璁惧缁� - */ - @ApiModelProperty("璁惧缁�") - private String deviceGroup; /** * 妫�楠屾鏁� */ @ApiModelProperty("妫�楠屾鏁�") + @ExcelIgnore private Integer checkoutNumber; /** * 鍖洪棿 */ @ApiModelProperty("鍖洪棿") + @ExcelIgnore private String section; - - /** - * 鍙栧�肩被鍨� - */ - @ApiModelProperty("鍙栧�肩被鍨�") - private String valueType; /** * 鏂规硶 */ @ApiModelProperty("鏂规硶鍒楄〃") + @ExcelIgnore private String method; @ApiModelProperty("鏂规硶") + @ExcelProperty(value = "鏂规硶鍚嶇О") private String methodS; /** * 棰勮鏃堕棿(澶�) */ @ApiModelProperty("棰勮鏃堕棿") + @ExcelProperty(value = "棰勮瀹屾垚鏃堕棿") private Integer manDay; /** * 鐗规畩鏍囪瘑 */ @ApiModelProperty("鐗规畩鏍囪瘑") + @ExcelProperty(value = "鐗规畩鏍囪瘑") private String bsm; /** * 瑕佹眰鍊� */ @ApiModelProperty("瑕佹眰鍊�") + @ExcelProperty(value = "鍒ゆ柇瑕佹眰") private String ask; - @ApiModelProperty("瑕佹眰鍊�") + @ApiModelProperty("瑕佹眰鎻忚堪") + @ExcelProperty(value = "鏍囧噯鏄剧ず") private String tell; /** * 澶栭敭锛氭爣鍑嗘柟娉昳d */ @ApiModelProperty("鏍囧噯鏂规硶id") + @ExcelIgnore private Integer standardMethodListId; @ApiModelProperty("宸ュ巶") + @ExcelIgnore private String factory; @ApiModelProperty("鏍峰搧鍒嗙被") + @ExcelProperty(value = "娴嬭瘯瀵硅薄") private String sampleType; @ApiModelProperty("鏍峰搧") + @ExcelProperty(value = "浜у搧") private String sample; @ApiModelProperty("鍨嬪彿") + @ExcelProperty(value = "鍨嬪彿") private String model; - @ApiModelProperty("鍨嬪彿") + @ApiModelProperty("妯$増id") + @ExcelIgnore private Integer templateId; @ApiModelProperty("") @TableField(fill = FieldFill.INSERT) + @ExcelIgnore private Integer createUser; /** * @@ -171,12 +189,14 @@ @ApiModelProperty("鍒涘缓鏃堕棿") @TableField(fill = FieldFill.INSERT) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @ExcelIgnore private LocalDateTime createTime; /** * */ @ApiModelProperty("") @TableField(fill = FieldFill.INSERT_UPDATE) + @ExcelIgnore private Integer updateUser; /** * @@ -184,10 +204,27 @@ @ApiModelProperty("淇敼鏃堕棿") @TableField(fill = FieldFill.INSERT_UPDATE) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @ExcelIgnore private LocalDateTime updateTime; @ApiModelProperty("1锛氭湁鏁� 0锛氭棤鏁�") + @ExcelIgnore private Integer state; + @ExcelIgnore private String dic; + + @ExcelIgnore + private String tree; + + @ExcelIgnore + private Integer structureItemParameterId; + + @ApiModelProperty(value = "妫�楠岄」鍒嗙被") + @ExcelIgnore + private String inspectionItemClass; + + @ApiModelProperty(value = "妫�楠岄」鍒嗙被EN") + @ExcelIgnore + private String inspectionItemClassEn; } \ No newline at end of file -- Gitblit v1.9.3