package com.fzzy.async.fzzy40.entity;

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;

/**
 * @Desc:
 * @author: Andy
 * @update-time: 2023/5/22 根据新国标调整名称，优化字段
 */
@Data
@Entity
@Table(name = "D_INOUT_CONTRACT")
public class Fz40InoutContract implements Serializable {

    private static final long serialVersionUID = 1L;

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

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

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

    @Column(name = "NAME_", length = 50)
    @PropertyDef(label = "合同名称")
    private String name;

    @Column(name = "PLAN_ID_", length = 40)
    @PropertyDef(label = "计划编码")
    private String planId;

    @Column(name = "PLAN_NAME_", length = 50)
    @PropertyDef(label = "计划名称")
    private String planName;

    @Column(name = "TYPE_", length = 10)
    @PropertyDef(label = "业务类别", description = "1:销售合同 2:采购合同 3:代储合同")
    private String type;

    @Column(name = "CUSTOMER_TYPE_", length = 10)
    @PropertyDef(label = "客户类型", description = "1:企业 2:个人")
    private String customerType;

    @Column(name = "YEAR_", length = 10)
    @PropertyDef(label = "年份")
    private String year;

    @Column(name = "CUSTOMER_ID_", length = 20)
    @PropertyDef(label = "社会信用码", description = "如果是企业=客户统一社会信用代码")
    private String customerId;

    @Column(name = "CUSTOMER_NAME_", length = 50)
    @PropertyDef(label = "客户名称")
    private String customerName;

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

    @Column(name = "txdz", length = 200)
    @PropertyDef(label = "通讯地址")
    private String txdz;

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

    @PropertyDef(label = "联系人姓名")
    @Column(name = "lxrxm", length = 50)
    private String lxrxm;

    @PropertyDef(label = "联系电话")
    @Column(name = "lxrdh", length = 20)
    private String lxrdh;

    @PropertyDef(label = "身份证号")
    @Column(name = "sfzh", length = 20)
    private String sfzh;

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

    @Column(name = "SIGNING_TIME_")
    @PropertyDef(label = "签订时间", description = "格式：yyyy-MM-dd")
    private Date signingTime;

    @Column(name = "SIGN_ADDRESS_", length = 100)
    @PropertyDef(label = "签约地点")
    private String signAddress;

    @Column(name = "BEGIN_TIME_")
    @PropertyDef(label = "约定开始时间")
    private Date beginTime;

    @Column(name = "END_TIME_")
    @PropertyDef(label = "约定完成时间")
    private Date endTime;

    @Column(name = "REL_END_TIME_")
    @PropertyDef(label = "实际完成时间")
    private Date relEndTime;

    @Column(name = "FOOD_VARIETY_", length = 20)
    @PropertyDef(label = "粮食品种")
    private String foodVariety;

    @Column(name = "FOOD_TYPE_", length = 20)
    @PropertyDef(label = "粮食性质")
    private String foodType;

    @Column(name = "PRICE_")
    @PropertyDef(label = "合同单价，元/吨")
    private Double price;

    @Column(name = "MONEY_")
    @PropertyDef(label = "合同总金额", description = "单位：元")
    private Double money;

    @Column(name = "CONTRACT_AMOUNT_")
    @PropertyDef(label = "合同数量", description = "单位：公斤")
    private Double contactAmount;

    @Column(name = "COMPLETE_NUM_")
    @PropertyDef(label = "履约数量", description = "单位：公斤")
    private Double completeNum;

    @Column(name = "lybzj")
    @PropertyDef(label = "履约保证金", description = "单位：元")
    private Double lybzj;

    @PropertyDef(label = "履约率", description = "单位：%")
    @Column(name = "lyl")
    private Double lyl;

    @Column(name = "jsjg")
    @PropertyDef(label = "结算价格，元/吨")
    private Double jsjg;

    @PropertyDef(label = "结算总金额", description = "单位：元")
    @Column(name = "jszje")
    private Double jszje;

    @PropertyDef(label = "结算与合同一致性", description = "1：符合 2：不符合")
    @Column(name = "jsyhtyzx", length = 1)
    private String jsyhtyzx;

    @PropertyDef(label = "不一致原因")
    @Column(name = "jsyhtbyzyy", length = 250)
    private String jsyhtbyzyy;

    @Column(name = "CUSTOMER_BANK_", length = 10)
    @PropertyDef(label = "客户开户行")
    private String customerBank;

    @Column(name = "CUSTOMER_BANK_ACCOUNT_", length = 40)
    @PropertyDef(label = "客户方账号")
    private String customerBankAccount;

    @Column(name = "CUSTOMER_SIGN_USER_", length = 50)
    @PropertyDef(label = "客户签约人")
    private String customerSignUser;

    @Column(name = "BANK_", length = 50)
    @PropertyDef(label = "本方开户行")
    private String bank;

    @Column(name = "BANK_ACCOUNT_", length = 40)
    @PropertyDef(label = "本方账号")
    private String bankAccount;

    @Column(name = "SIGN_USER_", length = 50)
    @PropertyDef(label = "本方签约人")
    private String signUser;

    @Column(name = "PAY_TYPE_", length = 6)
    @PropertyDef(label = "支付方式")
    private String payType;

    /**
     * --------审批信息--------
     **/

    @Column(name = "CREATE_USER_", length = 50)
    @PropertyDef(label = "创建人")
    private String createUser;

    @Column(name = "AUDIT_USER_", length = 50)
    @PropertyDef(label = "审批人")
    private String auditUser;

    @Column(name = "AUDIT_DATE_")
    @PropertyDef(label = "审批时间", description = "格式：yyyy-MM-dd HH:mm:ss")
    private Date auditDate;

    @Column(name = "AUDIT_STATUS_", length = 10)
    @PropertyDef(label = "审批状态")
    private String auditStatus;

    @Column(name = "CREATE_TIME_")
    @PropertyDef(label = "创建时间")
    private Date createTime;

    @Column(name = "wcrq")
    @PropertyDef(label = "完成时间")
    private Date wcrq;

    @Column(name = "hqzz", length = 30)
    @PropertyDef(label = "货权组织")
    private String hqzz;

    @Column(name = "UPDATE_TIME_")
    @PropertyDef(label = "更新时间")
    private Date updateTime;

    /**
     * --------附件--------
     **/
    @Column(name = "FILE_ID_", length = 30)
    @PropertyDef(label = "附件id")
    private String fileId;

    @Column(name = "FILE_NAME_", length = 50)
    @PropertyDef(label = "附件名称")
    private String fileName;

    @Column(name = "FILE_TIME_")
    @PropertyDef(label = "附件上传时间")
    private Date fileTime;
}