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;
|
|
}
|
