package com.panzhihua.common.model.vos.community.warehouse; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.converters.string.StringImageConverter; import com.fasterxml.jackson.annotation.JsonFormat; import com.panzhihua.common.utlis.StringUtils; import lombok.Data; import java.net.URL; import java.util.Date; /** * @author zzj */ @Data public class ComActWarehouseApplyExcelVO { @ExcelProperty(value = "申领流水",index = 10) private Integer id; /** * 物品数量 */ @ExcelProperty(value = "物品数量",index = 6) private Integer goodsNum; /** * 预约时间 */ @ExcelProperty(value = "预约领用时间",index = 7) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date reserveTime; /** * 实际时间 */ @ExcelProperty(value = "实际领用时间",index = 8) @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date actualTime; /** * 理由 */ @ExcelProperty(value = "主要困难",index = 9) private String reason; /** * 领取图片 */ @ExcelIgnore private URL receiveUrl; /** * 提交时间 */ @ExcelProperty(value = "提交时间",index = 13) private Date createTime; /** * 状态 0待处理 1 待领取 2已拒绝 3已领取 -1已取消 */ @ExcelProperty(value = "状态",index =14) private String status; @ExcelProperty(value = "核销人",index = 12) private String writeOffUserName; /** * 申请人 */ @ExcelProperty(value = "申请人",index = 0) private String applyName; /** * 申请人联系电话 */ @ExcelProperty(value = "申请人联系电话",index = 1) private String applyPhone; /** * 申请物品 */ @ExcelProperty(value = "申请物品",index = 2) private String item; /** * 捐赠人 */ @ExcelProperty(value = "捐赠人",index = 3) private String donateName; /** * 捐赠人联系方式 */ @ExcelProperty(value = "捐赠人联系方式",index = 4) private String donatePhone; /** * 物品图片 */ @ExcelIgnore private URL image; public void setStatus(String status) { if(StringUtils.isNotEmpty(status)){ if("-1".equals(status)){ status="已取消"; }else if("0".equals(status)){ status="待处理"; } else if("1".equals(status)){ status="待领取"; } else if("2".equals(status)){ status="已驳回"; } else if("3".equals(status)){ status="已领取"; } this.status=status; } } }