package com.yuanchu.mom.utils.easyexcel.template;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.alibaba.excel.annotation.write.style.ColumnWidth;
|
import com.alibaba.excel.metadata.BaseRowModel;
|
import com.baomidou.mybatisplus.annotation.TableId;
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
|
import com.yuanchu.mom.utils.easyexcel.converter.SaleTypeConverter;
|
import lombok.Data;
|
import lombok.EqualsAndHashCode;
|
|
import java.io.Serializable;
|
import java.util.Date;
|
|
/**
|
* @Author: Zou, Yu
|
* @DATE: 2023/9/24 0024 11:21
|
*/
|
@Data
|
@EqualsAndHashCode(callSuper = true)
|
public class ExportSaleTemplate extends BaseRowModel implements Serializable {
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="序号", index = 0)
|
private Integer id;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="订单编号", index = 1)
|
@JsonSerialize
|
private String orderNumber;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="订单类型", index = 2)
|
@JsonSerialize
|
private String orderType;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="合同编号", index = 3)
|
@JsonSerialize
|
private String code;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="工程名称", index = 4)
|
@JsonSerialize
|
private String name;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="客户名称", index = 5)
|
@JsonSerialize
|
private String proname;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="交货日期", index = 6)
|
@JsonFormat(pattern = "yyyy-MM-dd")
|
private Date delTime;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="备注", index = 7)
|
@JsonSerialize
|
private String note;
|
|
@ColumnWidth(26)
|
@ExcelProperty(value="状态", index = 8 ,converter = SaleTypeConverter.class)
|
@JsonSerialize
|
private String type;
|
|
}
|
