package com.doumee.dao.business.model; import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Data; import com.fasterxml.jackson.annotation.JsonFormat; import java.util.Date; import java.math.BigDecimal; /** * 运维出入库信息明细表 * @author 江蹄蹄 * @date 2025/01/06 14:28 */ @Data @ApiModel("运维出入库信息明细表") @TableName("`yw_outinbound_record`") public class YwOutinboundRecord { @TableId(type = IdType.AUTO) @ApiModelProperty(value = "主键", example = "1") private Integer id; @ApiModelProperty(value = "创建人编码", example = "1") private Integer creator; @ApiModelProperty(value = "创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @ExcelColumn(name="创建时间",width = 10,index = 11,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date createDate; @ApiModelProperty(value = "更新人编码", example = "1") private Integer editor; @ApiModelProperty(value = "更新时间") @JsonFormat(pattern = "yyyy-MM-dd") private Date editDate; @ApiModelProperty(value = "是否删除0否 1是", example = "1") private Integer isdeleted; @ApiModelProperty(value = "备注") private String remark; @ApiModelProperty(value = "出入库记录主键", example = "1") private Integer outInBoundId; @ApiModelProperty(value = "物资编码(关联yw_material)", example = "1") private Integer materialId; @ApiModelProperty(value = "数量", example = "1") @ExcelColumn(name="数量",width = 10,index = 5) private BigDecimal stock; @ApiModelProperty(value = "资产编码") @TableField(exist = false) @ExcelColumn(name="物料编码",width = 10,index = 1) private String materialCode; @ApiModelProperty(value = "资产名称") @TableField(exist = false) @ExcelColumn(name="物料名称",width = 10,index = 2) private String materialName; @ApiModelProperty(value = "资产条形码") @TableField(exist = false) private String materialQrcode; @ApiModelProperty(value = "资产品牌") @TableField(exist = false) private String materialBrand; @ApiModelProperty(value = "资产单位") @TableField(exist = false) @ExcelColumn(name="单位",width = 10,index = 6) private String materialUnitName; @ApiModelProperty(value = "操作类型:1=出库;0=入库(分页列表查询使用)", example = "1") @TableField(exist = false) private Integer inOut; @ApiModelProperty(value = "仓库主键") @TableField(exist = false) private Integer warehouseId; @ApiModelProperty(value = "仓库名称") @TableField(exist = false) @ExcelColumn(name="仓库",width = 10,index = 8) private String warehouseName; @ApiModelProperty(value = "单据日期") @TableField(exist = false) @JsonFormat(pattern = "yyyy-MM-dd") @ExcelColumn(name="单据日期",width = 10,index = 0,dateFormat = "yyyy-MM-dd") private Date doneDate; @ApiModelProperty(value = "一级分类名称") @TableField(exist = false) @ExcelColumn(name="物料分类",width = 10,index = 3) private String categoryParentName; @ApiModelProperty(value = "二级分类名称") @TableField(exist = false) @ExcelColumn(name="物料子分类",width = 10,index = 4) private String categoryName; @ApiModelProperty(value = "操作人名称", example = "1") @TableField(exist = false) @ExcelColumn(name="创建人",width = 10,index = 10) private String createUserName; @ApiModelProperty(value = "单据编号", example = "1") @TableField(exist = false) @ExcelColumn(name="单据编号",width = 10,index = 9) private String code; @ApiModelProperty(value = "类型 0采购入库 1领用退回 2调整入库 3其他入库 4盘盈入库 5领用出库 6仓库出库 7调整出库 8采购出库 9其他出库 10盘亏出库", example = "1") @TableField(exist = false) @ExcelColumn(name="类型",width = 10,index = 7,valueMapping = "0=采购入库;1=领用退回;2=调整入库;3=其他入库;4=盘盈入库;5=领用出库;6=仓库出库;7=调整出库;8=采购出库;9=其他出库;10=盘亏出库;") private Integer type; @ApiModelProperty(value = "单据日期 开始 yyyy-MM-dd", example = "1") @TableField(exist = false) private String doneDateStart; @ApiModelProperty(value = "单据日期 结束 yyyy-MM-dd", example = "1") @TableField(exist = false) private String doneDateEnd; @ApiModelProperty(value = "创建日期 开始 yyyy-MM-dd", example = "1") @TableField(exist = false) private String createDateStart; @ApiModelProperty(value = "创建日期 结束 yyyy-MM-dd", example = "1") @TableField(exist = false) private String createDateEnd; }