package com.doumee.dao.business.model;

import com.baomidou.mybatisplus.annotation.TableField;
import com.doumee.core.annotation.excel.ExcelColumn;
import com.doumee.core.model.LoginUserModel;
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 11:05
 */
@Data
@ApiModel("运维盘点明细记录表")
@TableName("`yw_stocktaking_record`")
public class YwStocktakingRecord extends LoginUserModel {

    @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")
    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 = "备注")
    @ExcelColumn(name="备注",index = 9,width = 30)
    private String remark;

    @ApiModelProperty(value = "状态 0未开始 1已盘点", example = "1")
    private Integer status;

    @ApiModelProperty(value = "盘点员编码(关联system_user)")
    private String userId;

    @ApiModelProperty(value = "盘点时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date planDate;

    @ApiModelProperty(value = "编号")
    private String code;

    @ApiModelProperty(value = "物资编码（关联yw_material)", example = "1")
    private Integer materialId;

    @ApiModelProperty(value = "账面数量", example = "1")
    @ExcelColumn(name="账面数量",index = 7,width = 10)
    private BigDecimal stock;

    @ApiModelProperty(value = "实际盘点库存量", example = "1")
    @ExcelColumn(name="盘点数量",index = 8,width = 10)
    private BigDecimal actStock;

    @ApiModelProperty(value = "盘点 0账实相符 1盘亏 2盘盈", example = "1")
    private Integer type;

    @ApiModelProperty(value = "盘点计划编码(关联yw_stocktaking)", example = "1")
    private Integer stocktakingId;

    @ApiModelProperty(value = "资产编码")
    @TableField(exist = false)
    @ExcelColumn(name="物料编码",index = 0,width = 10)
    private String materialCode;

    @ApiModelProperty(value = "资产名称")
    @TableField(exist = false)
    @ExcelColumn(name="物料名称",index = 1,width = 10)
    private String materialName;

    @ApiModelProperty(value = "资产条形码")
    @TableField(exist = false)
    @ExcelColumn(name="条码",index = 2,width = 10)
    private String materialQrcode;

    @ApiModelProperty(value = "资产品牌")
    @TableField(exist = false)
    @ExcelColumn(name="品牌",index = 3,width = 10)
    private String materialBrand;

    @ApiModelProperty(value = "资产规格型号")
    @TableField(exist = false)
    @ExcelColumn(name="规格型号",index = 4,width = 10)
    private String materialAttr;

    @ApiModelProperty(value = "资产单位")
    @TableField(exist = false)
    @ExcelColumn(name="单位",index = 5,width = 10)
    private String materialUnitName;

    @ApiModelProperty(value = "仓库名称")
    @ExcelColumn(name="仓库",index = 6,width = 10)
    @TableField(exist = false)
    private String warehouseName;

    @ApiModelProperty(value = "盘点人名称")
    @TableField(exist = false)
    private String userName;

    @ApiModelProperty(value = "盘点人组织名称")
    @TableField(exist = false)
    private String companyName;










}