package com.fzzy.async.fzzy61.entity;

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 czt
 *
 * 按仓库进行统计，每个月底统计一次(因上海市账面库存接口为按货位统计，转换接口服务时根据省份要求统计成对应的账面库存)
 **/
@Data
@Entity
@Table(name = "D_DEPOT_BOOK_STORE")
public class Fz61DepotBookStore implements Serializable {

    public static String SORT_PROP = "id";

    @Id
    @Column(name = "ID_", length = 40)
    @PropertyDef(label = "主键", description = "规则：仓库编码_yyyyMMdd")
    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 = "仓库编码", description = "目前上海使用")
    private String depotId;

    @PropertyDef(label = "粮食性质代码", description = "目前上海使用")
    @Column(name = "lsxzdm", length = 7)
    private String lsxzdm;

    @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")
    @PropertyDef(label = "业务日期")
    private Date ywrq;

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

}