package com.erry.iclear.dateInterface.entity;

import com.erry.iclear.dateInterface.common.BaseModel;
import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Data;
import org.hibernate.annotations.Persister;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 商品信息表
 * Created by xujin 2019/7/04.
 */
@Entity
@Table(name = "T_CC_HS_CODE")
@Data
public class HsCode extends BaseModel {

    private static final long serialVersionUID = 2693103610036977383L;

    /**
     * 商品信息表ID,自动增加
     */
    @Id
    @GeneratedValue
    @Column(name = "ID")
    private Long id;

    /**
     * 商品编号
     */
    @Column(name = "SKU_CODE")
    private String skuCode;

    /**
     * 商品名称
     */
    @Column(name = "SKUNAME")
    private String skuName;

    /**
     * 关税率
     */
    @Column(name = "DUTY_RATE")
    private BigDecimal dutyRate;

    /**
     * 消费税率
     */
    @Column(name = "REG_RATE")
    private BigDecimal regRate;

    /**
     * 增值税率
     */
    @Column(name = "TAX_RATE")
    private BigDecimal taxRate;

    /**
     * 建议计量单位
     */
    @Column(name = "MEASURE_UNIT")
    private String measureUnit;

    /**
     * 监管条件
     */
    @Column(name = "MONITOR_CONDITION")
    private String monitorCondition;

    /**
     * 备注
     */
    @Column(name = "REMARK")
    private String remark;

    /**
     * 运单创建时间
     */
    @Column(name = "CREATE_TIME")
    private Date createTime;

    /**
     * 运单创建人ID
     */
    @JsonIgnore
    @ManyToOne(targetEntity = SysUser.class)
    @JoinColumn(name = "CREATOR_ID")
    private SysUser creatorId;

    /**
     * 运单创建人
     */
    @Column(name = "CREATOR")
    private String creator;

    /**
     * 运单更新时间
     */
    @Column(name = "UPDATE_TIME")
    private Date updateTime;

    /**
     * 运单更新人ID
     */
    @JsonIgnore
    @ManyToOne(targetEntity = SysUser.class)
    @JoinColumn(name = "UPDATE_USER_ID")
    private SysUser updateUser;

    /**
     * 运单更新人
     */
    @Column(name = "UPDATE_USER")
    private String updateUserName;

    /**
     * 是否有效
     */
    @Column(name = "VALIDATE")
    private Boolean validate;

    /**
     * 第一（法定）计量单位
     */
    @Column(name = "UNIT_LEGAL_FIRST")
    private String unitLegalFirst;

    /**
     * 第一（法定）计量单位编码
     */
    @Column(name = "UNIT_LEGAL_FIRST_CODE")
    private String unitLegalFirstCode;
    /**
     * 第二计量单位
     */
    @Column(name = "UNIT_LEGAL_SECOND")
    private String unitLegalSecond;
    /**
     * 第二计量单位编码
     */
    @Column(name = "UNIT_LEGAL_SECOND_CODE")
    private String unitLegalSecondCode;

    /**
     * CCC标记
     */
    @Column(name = "ISCCC")
    private Boolean isCcc;

    /**
     * 出口含税标记
     */
    @Column(name = "EXPORTTAX")
    private Boolean exporttax;

    /**
     * 要素1
     */
    @Column(name = "ELEMENT1")
    private String element1;

    @Column(name = "FLAG1")
    private BigDecimal flag1;

    @Column(name = "SELECT1")
    private String select1;

    @Column(name = "SELECTFLAG1")
    private BigDecimal selectFlag1;

    /**
     * 要素2
     */
    @Column(name = "ELEMENT2")
    private String element2;

    @Column(name = "FLAG2")
    private BigDecimal flag2;

    @Column(name = "SELECT2")
    private String select2;

    @Column(name = "SELECTFLAG2")
    private BigDecimal selectFlag2;

    /**
     * 要素3
     */
    @Column(name = "ELEMENT3")
    private String element3;

    @Column(name = "FLAG3")
    private BigDecimal flag3;

    @Column(name = "SELECT3")
    private String select3;

    @Column(name = "SELECTFLAG3")
    private BigDecimal selectFlag3;

    /**
     * 要素4
     */
    @Column(name = "ELEMENT4")
    private String element4;

    @Column(name = "FLAG4")
    private BigDecimal flag4;

    @Column(name = "SELECT4")
    private String select4;

    @Column(name = "SELECTFLAG4")
    private BigDecimal selectFlag4;

    /**
     * 要素5
     */
    @Column(name = "ELEMENT5")
    private String element5;

    @Column(name = "FLAG5")
    private BigDecimal flag5;

    @Column(name = "SELECT5")
    private String select5;

    @Column(name = "SELECTFLAG5")
    private BigDecimal selectFlag5;

    /**
     * 要素6
     */
    @Column(name = "ELEMENT6")
    private String element6;

    @Column(name = "FLAG6")
    private BigDecimal flag6;

    @Column(name = "SELECT6")
    private String select6;

    @Column(name = "SELECTFLAG6")
    private BigDecimal selectFlag6;

    /**
     * 要素7
     */
    @Column(name = "ELEMENT7")
    private String element7;

    @Column(name = "FLAG7")
    private BigDecimal flag7;

    @Column(name = "SELECT7")
    private String select7;

    @Column(name = "SELECTFLAG7")
    private BigDecimal selectFlag7;

    /**
     * 要素8
     */
    @Column(name = "ELEMENT8")
    private String element8;

    @Column(name = "FLAG8")
    private BigDecimal flag8;

    @Column(name = "SELECT8")
    private String select8;

    @Column(name = "SELECTFLAG8")
    private BigDecimal selectFlag8;

    /**
     * 要素9
     */
    @Column(name = "ELEMENT9")
    private String element9;

    @Column(name = "FLAG9")
    private BigDecimal flag9;

    @Column(name = "SELECT9")
    private String select9;

    @Column(name = "SELECTFLAG9")
    private BigDecimal selectFlag9;

    /**
     * 要素10
     */
    @Column(name = "ELEMENT10")
    private String element10;

    @Column(name = "FLAG10")
    private BigDecimal flag10;

    @Column(name = "SELECT10")
    private String select10;

    @Column(name = "SELECTFLAG10")
    private BigDecimal selectFlag10;

    /**
     * 要素11
     */
    @Column(name = "ELEMENT11")
    private String element11;

    @Column(name = "FLAG11")
    private BigDecimal flag11;

    @Column(name = "SELECT11")
    private String select11;

    @Column(name = "SELECTFLAG11")
    private BigDecimal selectFlag11;

    /**
     * 要素12
     */
    @Column(name = "ELEMENT12")
    private String element12;

    @Column(name = "FLAG12")
    private BigDecimal flag12;

    @Column(name = "SELECT12")
    private String select12;

    @Column(name = "SELECTFLAG12")
    private BigDecimal selectFlag12;

    /**
     * 要素13
     */
    @Column(name = "ELEMENT13")
    private String element13;

    @Column(name = "FLAG13")
    private BigDecimal flag13;

    @Column(name = "SELECT13")
    private String select13;

    @Column(name = "SELECTFLAG13")
    private BigDecimal selectFlag13;

    /**
     * 要素14
     */
    @Column(name = "ELEMENT14")
    private String element14;

    @Column(name = "FLAG14")
    private BigDecimal flag14;

    @Column(name = "SELECT14")
    private String select14;

    @Column(name = "SELECTFLAG14")
    private BigDecimal selectFlag14;

    /**
     * 要素15
     */
    @Column(name = "ELEMENT15")
    private String element15;

    @Column(name = "FLAG15")
    private BigDecimal flag15;

    @Column(name = "SELECT15")
    private String select15;

    @Column(name = "SELECTFLAG15")
    private BigDecimal selectFlag15;

    /**
     * 要素16
     */
    @Column(name = "ELEMENT16")
    private String element16;

    @Column(name = "FLAG16")
    private BigDecimal flag16;

    @Column(name = "SELECT16")
    private String select16;

    @Column(name = "SELECTFLAG16")
    private BigDecimal selectFlag16;

    /**
     * 要素17
     */
    @Column(name = "ELEMENT17")
    private String element17;

    @Column(name = "FLAG17")
    private BigDecimal flag17;

    @Column(name = "SELECT17")
    private String select17;

    @Column(name = "SELECTFLAG17")
    private BigDecimal selectFlag17;

    /**
     * 要素18
     */
    @Column(name = "ELEMENT18")
    private String element18;

    @Column(name = "FLAG18")
    private BigDecimal flag18;

    @Column(name = "SELECT18")
    private String select18;

    @Column(name = "SELECTFLAG18")
    private BigDecimal selectFlag18;

    /**
     * 要素19
     */
    @Column(name = "ELEMENT19")
    private String element19;

    @Column(name = "FLAG19")
    private BigDecimal flag19;

    @Column(name = "SELECT19")
    private String select19;

    @Column(name = "SELECTFLAG19")
    private BigDecimal selectFlag19;

    /**
     * 要素20
     */
    @Column(name = "ELEMENT20")
    private String element20;

    @Column(name = "FLAG20")
    private BigDecimal flag20;

    @Column(name = "SELECT20")
    private String select20;

    @Column(name = "SELECTFLAG20")
    private BigDecimal selectFlag20;

    /**
     * 出口关税率
     */
    @Column(name = "OUT_RATE")
    private BigDecimal outRate;

    /**
     * 是否限制出口C类申报
     * 1表示限制，0表示不限制
     */
    @Transient
    Integer restrictedC;



    @Override
    public String toString() {
        return "HsCode{" +
                "id=" + id +
                ", skuCode='" + skuCode + '\'' +
                ", skuName='" + skuName + '\'' +
                ", dutyRate=" + dutyRate +
                ", regRate=" + regRate +
                ", taxRate=" + taxRate +
                ", measureUnit='" + measureUnit + '\'' +
                ", monitorCondition='" + monitorCondition + '\'' +
                ", remark='" + remark + '\'' +
                ", createTime=" + createTime +
                ", creatorId=" + creatorId +
                ", creator='" + creator + '\'' +
                ", updateTime=" + updateTime +
                ", updateUser=" + updateUser +
                ", updateUserName='" + updateUserName + '\'' +
                ", validate=" + validate +
                ", unitLegalFirst='" + unitLegalFirst + '\'' +
                ", unitLegalSecond='" + unitLegalSecond + '\'' +
                ", isCcc=" + isCcc +
                ", exporttax=" + exporttax +
                ", element1='" + element1 + '\'' +
                ", flag1=" + flag1 +
                ", select1='" + select1 + '\'' +
                ", selectFlag1=" + selectFlag1 +
                ", element2='" + element2 + '\'' +
                ", flag2=" + flag2 +
                ", select2='" + select2 + '\'' +
                ", selectFlag2=" + selectFlag2 +
                ", element3='" + element3 + '\'' +
                ", flag3=" + flag3 +
                ", select3='" + select3 + '\'' +
                ", selectFlag3=" + selectFlag3 +
                ", element4='" + element4 + '\'' +
                ", flag4=" + flag4 +
                ", select4='" + select4 + '\'' +
                ", selectFlag4=" + selectFlag4 +
                ", element5='" + element5 + '\'' +
                ", flag5=" + flag5 +
                ", select5='" + select5 + '\'' +
                ", selectFlag5=" + selectFlag5 +
                ", element6='" + element6 + '\'' +
                ", flag6=" + flag6 +
                ", select6='" + select6 + '\'' +
                ", selectFlag6=" + selectFlag6 +
                ", element7='" + element7 + '\'' +
                ", flag7=" + flag7 +
                ", select7='" + select7 + '\'' +
                ", selectFlag7=" + selectFlag7 +
                ", element8='" + element8 + '\'' +
                ", flag8=" + flag8 +
                ", select8='" + select8 + '\'' +
                ", selectFlag8=" + selectFlag8 +
                ", element9='" + element9 + '\'' +
                ", flag9=" + flag9 +
                ", select9='" + select9 + '\'' +
                ", selectFlag9=" + selectFlag9 +
                ", element10='" + element10 + '\'' +
                ", flag10=" + flag10 +
                ", select10='" + select10 + '\'' +
                ", selectFlag10=" + selectFlag10 +
                ", element11='" + element11 + '\'' +
                ", flag11=" + flag11 +
                ", select11='" + select11 + '\'' +
                ", selectFlag11=" + selectFlag11 +
                ", element12='" + element12 + '\'' +
                ", flag12=" + flag12 +
                ", select12='" + select12 + '\'' +
                ", selectFlag12=" + selectFlag12 +
                ", element13='" + element13 + '\'' +
                ", flag13=" + flag13 +
                ", select13='" + select13 + '\'' +
                ", selectFlag13=" + selectFlag13 +
                ", element14='" + element14 + '\'' +
                ", flag14=" + flag14 +
                ", select14='" + select14 + '\'' +
                ", selectFlag14=" + selectFlag14 +
                ", element15='" + element15 + '\'' +
                ", flag15=" + flag15 +
                ", select15='" + select15 + '\'' +
                ", selectFlag15=" + selectFlag15 +
                ", element16='" + element16 + '\'' +
                ", flag16=" + flag16 +
                ", select16='" + select16 + '\'' +
                ", selectFlag16=" + selectFlag16 +
                ", element17='" + element17 + '\'' +
                ", flag17=" + flag17 +
                ", select17='" + select17 + '\'' +
                ", selectFlag17=" + selectFlag17 +
                ", element18='" + element18 + '\'' +
                ", flag18=" + flag18 +
                ", select18='" + select18 + '\'' +
                ", selectFlag18=" + selectFlag18 +
                ", element19='" + element19 + '\'' +
                ", flag19=" + flag19 +
                ", select19='" + select19 + '\'' +
                ", selectFlag19=" + selectFlag19 +
                ", element20='" + element20 + '\'' +
                ", flag20=" + flag20 +
                ", select20='" + select20 + '\'' +
                ", selectFlag20=" + selectFlag20 +
                ", outRate=" + outRate +
                '}';
    }

}