package com.cloudroam.vo.projectInfo; import com.alibaba.excel.annotation.ExcelProperty; import com.fasterxml.jackson.annotation.JsonFormat; import lombok.Data; import java.math.BigDecimal; import java.time.LocalDateTime; @Data public class ProjectInfoExcelVO { @ExcelProperty("名称") private String projectName; @ExcelProperty("类型") private String projectTypeName; @ExcelProperty("项目经理") private String managerName; @ExcelProperty("客户") private String companyName; @ExcelProperty("客户联系人") private String contactName; @ExcelProperty("状态") private String projectStatusName; @ExcelProperty("阶段") private String projectStageName; @ExcelProperty("对内工时/h") private BigDecimal innerHours; @ExcelProperty("对外工时/h") private BigDecimal outerHours; @ExcelProperty("基础工时/h") private BigDecimal baseHours; @ExcelProperty("实际工时/h") private BigDecimal actualHours; @ExcelProperty("预计开始时间") @JsonFormat(pattern = "yyyy-MM-dd") private LocalDateTime estimateStartTime; @ExcelProperty("预计完成时间") @JsonFormat(pattern = "yyyy-MM-dd") private LocalDateTime estimateCompleteTime; @ExcelProperty("实际开始时间") @JsonFormat(pattern = "yyyy-MM-dd") private LocalDateTime actualStartTime; @ExcelProperty("实际完成时间") @JsonFormat(pattern = "yyyy-MM-dd") private LocalDateTime actualCompleteTime; @ExcelProperty("项目描述") private String desc; @ExcelProperty("备注") private String remark; }