package com.ruoyi.domain.vo; import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.common.annotation.Excel; import lombok.Data; import org.apache.poi.ss.usermodel.IndexedColors; import java.util.Date; @Data public class DocumentMaterialsVo { @Excel(name="序号", height = 10,width=8,headerColor = IndexedColors.RED, headerBackgroundColor = IndexedColors.WHITE) private Long num; @Excel(name = "文件编号", height = 10, width=8,headerColor = IndexedColors.BLACK, headerBackgroundColor = IndexedColors.WHITE) private String documentNumber; @Excel(name = "责任者", height = 10, width=8,headerColor = IndexedColors.BLACK, headerBackgroundColor = IndexedColors.WHITE) private String creator; @Excel(name = "文件题名", height = 8,headerColor = IndexedColors.RED, headerBackgroundColor = IndexedColors.WHITE) private String title; @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "日期", width = 10, dateFormat = "yyyy-MM-dd", height = 10,headerColor = IndexedColors.BLACK, headerBackgroundColor = IndexedColors.WHITE) private Date date; // 页号(原始数值,用于计算) private Long pageNumber; // 格式化后的页号,用于显示范围,如"38-38"或"23-38" @Excel(name = "页号", height = 10,width = 10,headerColor = IndexedColors.RED, headerBackgroundColor = IndexedColors.WHITE) private String pageNumberFormatted; @Excel(name = "备注", height = 20,width=10,headerColor = IndexedColors.BLACK, headerBackgroundColor = IndexedColors.WHITE) private String remarks; @Excel(name = "档号", height = 10,width=10,headerColor = IndexedColors.RED, headerBackgroundColor = IndexedColors.WHITE, headerFontName = "Arial", headerFontBold = true) private String recordId; @Excel(name = "公开属性", height = 10,width=10,headerColor = IndexedColors.BLACK, headerBackgroundColor = IndexedColors.WHITE) private String publicity; // @Excel(name = "图片", cellType = Excel.ColumnType.IMAGE) // private String url; }