package me.zhengjie.dao.mybatis.entity;

import com.baomidou.mybatisplus.annotation.*;
import lombok.*;
import lombok.experimental.Accessors;
import me.zhengjie.base.plus.QueryKeyword;
import me.zhengjie.base.plus.QueryWapper;

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

@Getter
@Setter
@Accessors(chain = true)
@TableName("contract_order")
@AllArgsConstructor
@NoArgsConstructor
@Builder
public class ContractOrderEntity implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    @TableField("business_no")
    private String businessNo;

    @TableField("prod_id")
    private String prodId;

    @TableField("contract_type_id")
    private String contractTypeId;

    @TableField("main_contract_no")
    private String mainContractNo;
    
    @QueryWapper(QueryKeyword.LIKE)
    @TableField("contract_no")
    private String contractNo;

    @TableField("contract_type")
    private Integer contractType;

    @TableField("start_date")
    private String startDate;

    @TableField("end_date")
    private String endDate;

    @TableField("contract_money")
    private String contractMoney;

    @TableField("rate")
    private String rate;

    @TableField("mortgage_pic")
    private String mortgagePic;

    @TableField("credit_limit")
    private String creditLimit;

    @TableField("credit_start_date")
    private String creditStartDate;

    @TableField("credit_end_date")
    private String creditEndDate;

    @TableField("contract_attachment")
    private String contractAttachment;
    
    @QueryWapper(QueryKeyword.LIKE)
    @TableField("name")
    private String name;

    @TableField("sex")
    private String sex;

    @TableField("birth")
    private String birth;
    
    @QueryWapper(QueryKeyword.LIKE)
    @TableField("id_card")
    private String idCard;

    @TableField("idcard_front_pic")
    private String idcardFrontPic;

    @TableField("idcard_back_pic")
    private String idcardBackPic;

    @TableField("residence")
    private String residence;

    @TableField("phone")
    private String phone;

    @TableField("marriage")
    private String marriage;

    @TableField("marrage_pic")
    private String marragePic;

    @TableField("hkb_pic")
    private String hkbPic;

    @TableField("other_upload")
    private String otherUpload;

    @TableField("joint_flag")
    private Integer jointFlag;

    @TableField("joint_id_card")
    private String jointIdCard;

    @TableField("joint_name")
    private String jointName;

    @TableField("joint_phone")
    private String jointPhone;

    @TableField("joint_idcard_front_pic")
    private String jointIdcardFrontPic;

    @TableField("joint_idcard_back_pic")
    private String jointIdcardBackPic;

    @TableField("joint_sex")
    private String jointSex;

    @TableField("joint_residence")
    private String jointResidence;

    @TableField("bank_id")
    private String bankId;

    @TableField("bank_name")
    private String bankName;

    @TableField("customer_id")
    private String customerId;

    @TableField("customer_name")
    private String customerName;

    @TableField("notary_office_id")
    private String notaryOfficeId;

    @TableField("notary_user_id")
    private String notaryUserId;

    @TableField("notary_user_name")
    private String notaryUserName;

    @TableField("auto_generate")
    private String autoGenerate;

    @TableField("return_reason")
    private String returnReason;

    @TableField("reject_reason")
    private String rejectReason;

    @TableField("status")
    private String status;

    @TableField("creator")
    private String creator;
    @QueryWapper(value = {QueryKeyword.RANGE,QueryKeyword.DESC}, attribute = { "startDate", "endDate" })
    @TableField(value="create_time", fill = FieldFill.INSERT)
    private Date createTime;

    @TableField("updater")
    private String updater;

    @TableField(value = "update_time", fill = FieldFill.UPDATE)
    private Date updateTime;

    @TableField("consult_no")
    private String consultNo;
}