package com.fzzy.igds.domain;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;

/**
 * @Description 粮食库存管理
 * @Author CZT
 * @Date 2025/11/26 11:10
 */
@Data
@Entity
@Table(name = "d_depot_store")
@TableName("d_depot_store")
@EqualsAndHashCode(callSuper = false)
public class DepotStore extends BizBaseEntity implements Serializable {

    /**
     *
     */
    private static final long serialVersionUID = 1L;

    public static String SORT_PROP = "updateDate";

    @Id
    @Column(name = "id", columnDefinition = "varchar(50) COMMENT '主键'")
    @TableField("id")
    private String id;

    @Column(name = "dept_id", columnDefinition = "varchar(40) COMMENT '所属库区'")
    @TableField("dept_id")
    private String deptId;

    @Column(name = "depot_id", columnDefinition = "varchar(40) COMMENT '所属仓库'")
    @TableField("depot_id")
    private String depotId;

    @Column(name = "food_type", columnDefinition = "varchar(3) COMMENT '粮食性质'")
    @TableField("food_type")
    private String foodType;

    @Column(name = "food_variety", columnDefinition = "varchar(7) COMMENT '粮食品种'")
    @TableField("food_variety")
    private String foodVariety;

    @Column(name = "food_level", columnDefinition = "varchar(2) COMMENT '粮食等级'")
    @TableField("food_level")
    private String foodLevel;

    @Column(name = "food_locationId", columnDefinition = "varchar(40) COMMENT '粮食产地'")
    @TableField("food_locationId")
    private String foodLocationId;

    @Column(name = "food_location", columnDefinition = "varchar(40) COMMENT '粮食产地'")
    @TableField("food_location")
    private String foodLocation;

    @Column(name = "food_year", columnDefinition = "varchar(4) COMMENT '粮食年份'")
    @TableField("food_year")
    private String foodYear;

    @Column(name = "depot_status", columnDefinition = "varchar(2) COMMENT '仓库状态(1=空仓,2=入库中,3=封仓,4=出库中,9=其他)'")
    @TableField("depot_status")
    private String depotStatus;

    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @Column(name = "store_date", columnDefinition = "datetime COMMENT '入库时间'")
    @TableField("store_date")
    private Date storeDate;

    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @Column(name = "full_date", columnDefinition = "datetime COMMENT '封仓日期'")
    @TableField("full_date")
    private Date fullDate;

    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    @Column(name = "out_date", columnDefinition = "datetime COMMENT '出仓时间'")
    @TableField("out_date")
    private Date outDate;

    @Column(name = "storage_real", columnDefinition = "decimal(20,2) COMMENT '实际储量(单位：KG)'")
    @TableField("storage_real")
    private Double storageReal;

    @Column(name = "remark", columnDefinition = "varchar(40) COMMENT '备注'")
    @TableField("remark")
    private String remark;

}