package com.fzzy.api.entity;

import com.alibaba.fastjson.annotation.JSONField;
import com.bstek.dorado.annotation.PropertyDef;

import lombok.Data;
import lombok.EqualsAndHashCode;

import javax.persistence.*;

import java.io.Serializable;
import java.util.Date;

/**
 * 接口表-项目信息数据表
 *
 * @author chen
 * @date 2022-09-02 16:03
 */
@Data
@Entity
@Table(name = "API_1405")
@EqualsAndHashCode(callSuper=false)
public class Api1405 implements Serializable {

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

	@Id
    @PropertyDef(label = "项目代码" )
    @Column(name = "xmdm", length = 46)
    private String xmdm;

    @PropertyDef(label = "统一单位编码")
    @Column(name = "tydwbm", length = 20)
    private String tydwbm;

    @PropertyDef(label = "项目名称" )
    @Column(name = "xmmc", length = 128)
    private String xmmc;

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

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

    @PropertyDef(label = "项目类型" )
    @Column(name = "xmlx", length = 1)
    private String xmlx;

    @PropertyDef(label = "建设内容及规模" )
    @Column(name = "jsnr", length = 512)
    private String jsnr;

    @JSONField(format = "yyyy-MM-dd")
    @PropertyDef(label = "拟开工时间" )
    @Column(name = "nkgsj")
    private Date nkgsj;

    @JSONField(format = "yyyy-MM-dd")
    @PropertyDef(label = "拟建成时间" )
    @Column(name = "njcsj")
    private Date njcsj;

    @PropertyDef(label = "建设状态" )
    @Column(name = "jszt", length = 1)
    private String jszt;

    @JSONField(format = "yyyy-MM-dd")
    @PropertyDef(label = "申报日期" )
    @Column(name = "sbrq")
    private Date sbrq;

    @PropertyDef(label = "审批文号" )
    @Column(name = "spwh", length = 128)
    private String spwh;

    @PropertyDef(label = "项目(法人)单位" )
    @Column(name = "xmdw", length = 18)
    private String xmdw;

    @PropertyDef(label = "法人证照类型" )
    @Column(name = "frzzlx", length = 2)
    private String fddbrzzlx;

    @PropertyDef(label = "法人证照号码" )
    @Column(name = "frzzhm", length = 32)
    private String fddbrzzhm;

    @PropertyDef(label = "联系人" )
    @Column(name = "lxr", length = 16)
    private String lxr;

    @PropertyDef(label = "联系方式" )
    @Column(name = "lxfs", length = 16)
    private String lxfs;

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

    @PropertyDef(label = "建设地点" )
    @Column(name = "jsdd", length = 128)
    private String jsdd;

    @PropertyDef(label = "总投资" )
    @Column(name = "ztz", precision = 20, scale = 6)
    private double ztz;

    @PropertyDef(label = "固定资产投资" )
    @Column(name = "gdzctz", precision = 20, scale = 6)
    private double gdzctz;

    @PropertyDef(label = "中央财政资金" )
    @Column(name = "zyczzj", precision = 20, scale = 6)
    private double zyczzj;

    @PropertyDef(label = "省财政资金" )
    @Column(name = "sczzj", precision = 20, scale = 6)
    private double sczzj;

    @JSONField(name = "sczzj01")
    @PropertyDef(label = "市财政资金" )
    @Column(name = "sczzj2", precision = 20, scale = 6)
    private double sczzj2;

    @PropertyDef(label = "银行贷款" )
    @Column(name = "yhdk", precision = 20, scale = 6)
    private double yhdk;

    @PropertyDef(label = "股票债券" )
    @Column(name = "gpzq", precision = 20, scale = 6)
    private double gpzq;

    @PropertyDef(label = "其资金" )
    @Column(name = "qtzj", precision = 20, scale = 6)
    private double qtzj;

    @PropertyDef(label = "项目资料" )
    @Column(name = "xmzl", length = 128)
    private String xmzl;

    @PropertyDef(label = "项目地址经度" )
    @Column(name = "xmdzjd", precision = 20, scale = 6)
    private double xmdzjd;

    @PropertyDef(label = "项目地址纬度" )
    @Column(name = "zmdzwd", precision = 20, scale = 6)
    private double zmdzwd;

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

    @JSONField(format = "yyyy-MM-dd HH:mm:ss")
    @PropertyDef(label = "最后更新时间" )
    @Column(name = "zhgxsj")
    private Date zhgxsj;
    @JSONField(serialize = false)
    @PropertyDef(label = "业务id")
    @Column(name = "bizId", length = 40)
    private String bizId;

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

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