package com.fzzy.api.entity;

import com.alibaba.fastjson.annotation.JSONField;
import com.bstek.dorado.annotation.PropertyDef;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.springframework.format.annotation.DateTimeFormat;
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
 * @date 2023-10-18
 */
@Data
@Entity
@Table(name = "API_1101")
@EqualsAndHashCode(callSuper = false)
public class Api1101 implements Serializable {

    private static final long serialVersionUID = 9157617424050247565L;

    /*----------国标字段----------*/
    @Id
    @PropertyDef(label = "单位代码")
    @Column(name = "dwdm", length = 18)
    private String dwdm;

    @PropertyDef(label = "单位名称")
    @Column(name = "dwmc", length = 256)
    private String dwmc;

    @PropertyDef(label = "单位类型")
    @Column(name = "dwlx", length = 2)
    private String dwlx;

    @PropertyDef(label = "注册日期")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    @JSONField(format = "yyyy-MM-dd")
    @Column(name = "zcrq")
    private Date zcrq;

    @PropertyDef(label = "注册资本")
    @Column(name = "zczb", precision = 20, scale = 6)
    private Double zczb;

    @PropertyDef(label = "资产总额")
    @Column(name = "zcze", precision = 20, scale = 6)
    private Double zcze;

    @PropertyDef(label = "法定代表人")
    @Column(name = "fddbr", length = 100)
    private String fddbr;

    @PropertyDef(label = "法人身份证号")
    @Column(name = "frsfzh", length = 18)
    private String frsfzh;

    @PropertyDef(label = "法人联系方式")
    @Column(name = "frlxfs", length = 50)
    private String frlxfs;

    @PropertyDef(label = "企业联系人")
    @Column(name = "qylxr", length = 100)
    private String qylxr;

    @PropertyDef(label = "办公电话")
    @Column(name = "bgdh", length = 50)
    private String bgdh;

    @PropertyDef(label = "注册地址")
    @Column(name = "zcdz", length = 512)
    private String zcdz;

    @PropertyDef(label = "电子邮箱")
    @Column(name = "dzyx", length = 50)
    private String dzyx;

    @PropertyDef(label = "企业官方网站地址")
    @Column(name = "qygfwzdz", length = 128)
    private String qygfwzdz;

    @PropertyDef(label = "传真号码")
    @Column(name = "czhm", length = 32)
    private String czhm;

    @PropertyDef(label = "邮政编码")
    @Column(name = "yzbm", length = 6)
    private String yzbm;

    @PropertyDef(label = "行政区划代码")
    @Column(name = "xzqhdm", length = 6)
    private String xzqhdm;

    @PropertyDef(label = "上级单位名称")
    @Column(name = "sjdwmc", length = 256)
    private String sjdwmc;

    @PropertyDef(label = "上级单位代码")
    @Column(name = "sjdwdm", length = 18)
    private String sjdwdm;

    @PropertyDef(label = "库区数")
    @Column(name = "kqs")
    private Integer kqs;

    @PropertyDef(label = "仓房数")
    @Column(name = "cfs")
    private Integer cfs;

    @PropertyDef(label = "油罐数")
    @Column(name = "ygs")
    private Integer ygs;

    @PropertyDef(label = "经度")
    @Column(name = "jd", precision = 20, scale = 6)
    private Double jd;

    @PropertyDef(label = "纬度")
    @Column(name = "wd", precision = 20, scale = 6)
    private Double wd;

    @PropertyDef(label = "单位状态")
    @Column(name = "dwzt",length = 1)
    private String dwzt;

    @PropertyDef(label = "操作标志")
    @Column(name = "czbz", length = 1)
    private String czbz;

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


    /*----------广东省平台规范字段----------*/
    @Column(name = "balx", length = 1)
    @PropertyDef(label = "备案类型", description = "0:初次备案 1:变更备案 2:重新备案")
    private String balx;

    @Column(name = "ccywlx", length = 20)
    @PropertyDef(label = "仓储业务类型")
    private String ccywlx;

    @Column(name = "ccpz", length = 20)
    @PropertyDef(label = "仓储品种")
    private String ccpz;

    @Column(name = "bazt", length = 1)
    @PropertyDef(label = "备案状态")
    private String bazt;


    /*----------上海市平台规范字段----------*/
    @PropertyDef(label = "廒间数")
    @Column(name = "ajs")
    private Integer ajs;

    @PropertyDef(label = "标记位")
    @Column(name = "bjw", length = 40)
    private String bjw;


    /*----------接口系统自定义字段----------*/
    @JSONField(serialize = false)
    @PropertyDef(label = "行政区划名称", description = "非国标字段，后期增加")
    @Column(name = "xzqhmc", length = 20)
    private String xzqhmc;

    @JSONField(serialize = false)
    @PropertyDef(label = "业务id")
    @Column(name = "bizId", length = 40)
    private String bizId;

    @JSONField(serialize = false)
    @PropertyDef(label = "库区代码")
    @Column(name = "kqdm", length = 21)
    private String kqdm;

    @JSONField(serialize = false)
    @PropertyDef(label = "同步时间", description = "从粮库系统同步到接口管理中心的时间")
    @Column(name = "syncTime")
    private Date syncTime;
}