package com.skua.modules.equipment.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.skua.core.aspect.annotation.Dict;
import com.skua.tool.annotation.BeanAnno;
import com.skua.tool.annotation.JoinSqlQueryAnno;
import com.skua.tool.enums.JoinSqlQueryEnum;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.util.Date;

/**
 * 备品备件表
 * 【库存】
 * 目前这个表存储了很多[物料]冗余字段，所以在操作[物料]时，需要同时维护这个表的冗余信息
 */
@Data
@TableName("equipment_sparepart")
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@ApiModel(value = "equipment_sparepart对象", description = "备品备件表")
public class EquipmentSparepart {

    /**
     * id
     */
    @TableId(type = IdType.UUID)
    @ApiModelProperty(value = "id")
    private String id;
    /**
     * 备件编号
     */
    @Excel(name = "备件编号", width = 15)
    @ApiModelProperty(value = "备件编号")
    @JoinSqlQueryAnno(joinSqlQueryEnum = JoinSqlQueryEnum.LIKE)
    private String sparepartCode;
    /**
     * 备件名称
     */
    @Excel(name = "备件名称", width = 15)
    @ApiModelProperty(value = "备件名称")
    @JoinSqlQueryAnno(joinSqlQueryEnum = JoinSqlQueryEnum.LIKE)
    private String sparepartName;

    @ApiModelProperty(value = "备件详细名称")
    private String sparepartAlias;

    private String sparepartAliass;

    private String sparepartValue;

    /**
     * 备件类型
     */
    @Excel(name = "备件类型", width = 15)
    @ApiModelProperty(value = "备件类型")
    //@BeanAnno(targetFieldName = "sparepartType_dictText")
    @Dict(dictTable = "equipment_sparepart_Type",dicCode = "id",dicText = "item_text")
    @JoinSqlQueryAnno(joinSqlQueryEnum = JoinSqlQueryEnum.EQ)
    private String sparepartType;
    /**
     * 备件图片
     */
    @Excel(name = "备件图片", width = 15)
    @ApiModelProperty(value = "备件图片")
    private String sparepartImg;
    /**
     * 更换周期
     */
    @Excel(name = "更换周期", width = 15)
    @ApiModelProperty(value = "更换周期")
    private String changeCircle;
    /**
     * 规格型号
     */
    @Excel(name = "规格型号", width = 15)
    @ApiModelProperty(value = "规格型号")
    @JoinSqlQueryAnno(joinSqlQueryEnum = JoinSqlQueryEnum.LIKE)
    private String specification;
    /**
     * 生产厂商
     */
    @Excel(name = "生产厂商", width = 15)
    @ApiModelProperty(value = "生产厂商")
    @Dict(dictTable = "equipment_brand",dicCode = "id",dicText = "brand_company")
    private String manufacturer;
    /**
     * 计量单位
     */
    @Excel(name = "计量单位", width = 15)
    @ApiModelProperty(value = "计量单位")
    private String measuringUnit;
    /**
     * 库存金额
     */
    @Excel(name = "库存金额", width = 15)
    @ApiModelProperty(value = "库存金额")
    private BigDecimal storageMoney;
    /**
     * 当前库存
     */
    @Excel(name = "当前库存", width = 15)
    @ApiModelProperty(value = "当前库存")
    private BigDecimal storageNum;
    /**
     * 库存上限
     */
    @Excel(name = "库存上限", width = 15)
    @ApiModelProperty(value = "库存上限")
    private BigDecimal storageMaxNum;
    /**
     * 库存下限
     */
    @Excel(name = "库存下限", width = 15)
    @ApiModelProperty(value = "库存下限")
    private BigDecimal storageMinNum;
    /**
     * 材质
     */
    @Excel(name = "材质", width = 15)
    @ApiModelProperty(value = "材质")
    private String texture;
    /**
     * 二维码
     */
    @Excel(name = "二维码", width = 15)
    @ApiModelProperty(value = "二维码")
    private String qrCode;
    /**
     * 备注
     */
    @Excel(name = "备注", width = 15)
    @ApiModelProperty(value = "备注")
    private String remark;
    /**
     * 版本(0/1)
     */
    @Excel(name = "版本(0/1)", width = 15)
    @ApiModelProperty(value = "版本(0/1)")
    private Integer version;
    /**
     * 创建人id
     */
    @Excel(name = "创建人id", width = 15)
    @ApiModelProperty(value = "创建人id")
    private String createBy;
    /**
     * 创建时间
     */
    @Excel(name = "创建时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "创建时间")
    private Date createTime;
    /**
     * 修改人id
     */
    @Excel(name = "修改人id", width = 15)
    @ApiModelProperty(value = "修改人id")
    private String updateBy;
    /**
     * 修改时间
     */
    @Excel(name = "修改时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "修改时间")
    private Date updateTime;
    /**
     * 所属部门
     */
    @Excel(name = "所属部门", width = 15)
    @ApiModelProperty(value = "所属部门")
    private String createDept;
    /**
     * 所属公司
     */
    @Excel(name = "所属公司", width = 15)
    @ApiModelProperty(value = "所属公司")
    private String createCmpy;
    /**
     * 删除标识，0:正常,1:删除
     */
    @Excel(name = "删除标识，0:正常,1:删除", width = 15)
    @ApiModelProperty(value = "删除标识，0:正常,1:删除")
    private Integer delFlag;

    @Excel(name = "备件单价", width = 15)
    @ApiModelProperty(value = "备件单价")
    private BigDecimal unitPrice;

    @ApiModelProperty(value = "质量")
    private String quality;

    @ApiModelProperty(value = "实收数量")
    private BigDecimal actualNum;

    @ApiModelProperty(value = "排序字段")
    private Integer orderNum;

    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "修改时间")
    private Date inventoryUpdateTime;

    /**
     * 物资id
     */
    @Excel(name = "物资id", width = 15)
    @ApiModelProperty(value = "物资id")
    private String suppliesId;
    /**
     * 仓库id
     */
    @Excel(name = "仓库id", width = 15)
    @ApiModelProperty(value = "仓库id")
    private String suppliesWarehouseId;

    /**
     * 所属厂站
     */
    @Excel(name = "所属厂站", width = 15)
    @ApiModelProperty(value = "所属厂站")
    private String departId;

    /** 物料属性 */
    @ApiModelProperty(value = "物料属性")
    @Dict(dicCode = "sparepart_attribute")
    private String sparepartAttribute;

}