package com.ld.igds.models;

import com.alibaba.fastjson.annotation.JSONField;
import com.bstek.dorado.annotation.PropertyDef;
import lombok.Data;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;

/**
 * @Author: YYC
 * @Description:账面库存
 * @DateTime: 2023/10/20 14:07
 *
 * 按仓库进行统计，每个月低统计一次(因上海市账面库存接口为按货位统计)
 **/
@Data
@Entity
@Table(name = "D_DEPOT_BOOK_STORE")
public class DepotBookStore implements Serializable {
    /**
     *
     */
    private static final long serialVersionUID = -5548540780391804729L;

    @Id
    @Column(name = "ID_", length = 40)
    private String id;

    @Column(name = "COMPANY_ID_", length = 10)
    @PropertyDef(label = "组织编码")
    private String companyId;

    @Column(name = "DEPT_ID_", length = 20)
    @PropertyDef(label = "库区代码")
    private String deptId;

    @Column(name = "DEPOT_ID_", length = 30)
    @PropertyDef(label = "仓库编码")
    private String depotId;

    @Column(name = "lspzdm", length = 7)
    @PropertyDef(label = "粮食品种代码")
    private String lspzdm;

    @Column(name = "nd", length = 4)
    @PropertyDef(label = "年度")
    private String nd;

    @Column(name = "yf", length = 2)
    @PropertyDef(label = "月份")
    private String yf;

    @Column(name = "qcsl", precision = 20, scale = 3)
    @PropertyDef(label = "期初数量", description = "单位：公斤")
    private Double qcsl = 0.0;

    @Column(name = "bqsrsl", precision = 20, scale = 3)
    @PropertyDef(label = "本期收入数量", description = "单位：公斤")
    private Double bqsrsl = 0.0;

    @Column(name = "bqzcsl", precision = 20, scale = 3)
    @PropertyDef(label = "本期支出数量", description = "单位：公斤")
    private Double bqzcsl = 0.0;

    @Column(name = "qmye", precision = 20, scale = 3)
    @PropertyDef(label = "期末数量", description = "单位：公斤")
    private Double qmye = 0.0;

    @Column(name = "yjbz")
    @PropertyDef(label = "月结标志", description = "0：月结；1 未月结")
    private Integer yjbz;

    @Column(name = "ywrq")
    @JSONField(format = "yyyy-MM-dd")
    @PropertyDef(label = "业务日期")
    private Date ywrq;

    @Column(name = "zhgxsj")
    @JSONField(format = "yyyy-MM-dd HH:mm:ss")
    @PropertyDef(label = "最后更新时间")
    private Date zhgxsj;

}