package com.erry.iclear.dateInterface.entity;


import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * 运单表
 * Created by Erry 2019/5/30.
 *
 * @author Administrator
 */
@Entity
@Table(name = "T_CHM_CONSIGNMENT")
@Data
public class ChmConsignment implements Serializable {

    private static final long serialVersionUID = 2693103610036977383L;

    /**
     * 运单表ID,自动增加
     */
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "ID")
    private Long id;


    /**
     * 运单号
     */
    @Column(name = "CONSIGNMENT_CODE")
    private String consignmentCode;

    /**
     * 总运单号
     */
    @Column(name = "CONSIGNMENT_HEAD_CODE")
    private String consignmentHeadCode;

    /**
     * 申报单位
     */
    @Column(name = "DECLARED_UNIT_NAME")
    private String declaredUnitName;

    /**
     * 申报口岸
     */
    @Column(name = "DECLARED_PORT")
    private String declaredPort;


    /**
     * 合同协议号
     */
    @Column(name = "CONTRACT_CODE")
    private String contractCode;


    /**
     * 征免性质ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "TAX_NATURE_ID")
    private DictionaryEntries taxNatureDic;

    /**
     * 征免性质
     */
    @Column(name = "TAX_NATURE")
    private String taxNature;


    /**
     * 指运港ID
     */
    @ManyToOne(targetEntity = ChmCarryPort.class)
    @JoinColumn(name = "THROUGH_STOP_PORT_ID")
    private ChmCarryPort throughStopPortDic;

    /**
     * 指运港
     */
    @Column(name = "THROUGH_STOP_PORT")
    private String throughStopPort;


    /**
     * 报关单类型ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "DECLARED_DOC_TYPE_ID")
    private DictionaryEntries declaredDocTypeDic;

    /**
     * 报关单类型
     */
    @Column(name = "DECLARED_DOC_TYPE")
    private String declaredDocType;

    /**
     * 运费(币制)ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "TRANS_CURRENCY_ID")
    private DictionaryEntries transCurrencyDic;

    /**
     * 运费(币制)
     */
    @Column(name = "TRANS_CURRENCY")
    private String transCurrency;

    /**
     * 运费
     */
    @Column(name = "TRANS_COST")
    private BigDecimal transCost;


    /**
     * 毛重（公斤）
     */
    @Column(name = "GROSS_WEIGHT")
    private BigDecimal grossWeight;


    /**
     * 保费
     */
    @Column(name = "INSURANCE_COST")
    private BigDecimal insuranceCost;

    /**
     * 保费(币制)ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "INSURANCE_CURRENCY_ID")
    private DictionaryEntries insuranceCostCurrencyDic;

    /**
     * 保费(币制)
     */
    @Column(name = "INSURANCE_CURRENCY")
    private String insuranceCostCurrency;


    /**
     * 备案号
     */
    @Column(name = "RECORD_CODE")
    private String recordCode;


    /**
     * 净重（公斤）
     */
    @Column(name = "NET_WEIGHT")
    private BigDecimal netWeight;


    /**
     * 杂费
     */
    @Column(name = "OTHER_COST")
    private BigDecimal otherCost;

    /**
     * 杂费(币制)ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "OTHER_CURRENCY_ID")
    private DictionaryEntries otherCurrencyDic;

    /**
     * 杂费(币制)
     */
    @Column(name = "OTHER_CURRENCY")
    private String otherCurrency;


    /**
     * 件数
     */
    @Column(name = "COUNTS")
    private Long counts;


    /**
     * 预录入编号
     */
    @Column(name = "ENTERING_NO")
    private String enteringNo;


    /**
     * 监管方式ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "TRADE_MODE_ID")
    private DictionaryEntries tradeModeDic;

    /**
     * 监管方式
     */
    @Column(name = "TRADE_MODE")
    private String tradeMode;


    /**
     * 境内发货人编码
     */
    @Column(name = "TRADE_CO_SCC")
    private String tradeCoSCC;

    /**
     * 境内发货人（经营单位编码）
     */
    @Column(name = "OPERATE_UNIT_CODE")
    private String operateUnitCode;

    /**
     * 境内发货人（经营单位名称）
     */
    @Column(name = "OPERATE_UNIT_NAME")
    private String operateUnitName;

    /**
     * 运输方式ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "VEHICLE_WAY_ID")
    private DictionaryEntries vehicleWay;

    /**
     * 运输方式
     */
    @Column(name = "VEHICLE_WAY_CODE")
    private String vehicleWayCode;

    /**
     * 成交方式ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "DEAL_MODE_ID")
    private DictionaryEntries dealModeDic;

    /**
     * 成交方式
     */
    @Column(name = "DEAL_MODE")
    private String dealMode;


    /**
     * 包装种类ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "PACKAGE_TYPE_ID")
    private DictionaryEntries packageTypeDic;

    /**
     * 包装种类
     */
    @Column(name = "PACKAGE_TYPE")
    private String packageType;

    /**
     * 贸易国（地区）ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "TRADE_AREA_CODE_ID")
    private DictionaryEntries tradeAreaCodeDic;

    /**
     * 贸易国（地区）
     */
    @Column(name = "TRADE_AREA_CODE")
    private String tradeAreaCode;

    /**
     * 报关单编号
     */
    @Column(name = "CUSTOMS_NO")
    private String customsNo;

    /**
     * 抵运国（地区）ID
     */
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "FROM_COUNTRY_ID")
    private DictionaryEntries fromCountryDic;

    /**
     * 抵运国（地区）
     */
    @Column(name = "FROM_COUNTRY")
    private String fromCountry;

    /**
     * 境外收货人
     */
    @Column(name = "OVERSEAS_CONSIGNOR_FN_CNAME")
    private String overseasConsignorFnCname;

    /**
     * 境外收货人编码
     */
    @Column(name = "OVERSEAS_CONSIGNOR_CODE")
    private String overseasConsignorCode;


    /**
     * 标记唛码及备注 （标记唛码）
     */
    @Column(name = "DECLARED_REMARK")
    private String declaredRemark;

    /**
     * 运单创建时间
     */
    @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 = DictionaryEntries.class)
    @JoinColumn(name = "CONS_STATUS_ID")
    private DictionaryEntries consStatusDic;

    /**
     * 运单状态
     */
    @Column(name = "CONS_STATUS")
    private String consStatus;


    /**
     * 生产核销位海关编码
     */
    @Column(name = "OWNER_CODE")
    private String ownerCode;

    /**
     * 生产核销单位
     */
    @Column(name = "OWNER_NAME")
    private String ownerName;


    /**
     * 生产核销单位编码
     */
    @Column(name = "OWNER_CODE_SCC")
    private String ownerCodeScc;

    /**
     * 运单类型ID
     */
    @JsonIgnore
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "CONS_TYPE_ID")
    private DictionaryEntries consTypeId;

    /**
     * 运单类型
     */
    @Column(name = "CONS_TYPE")
    private String consType;

    @JsonIgnore
    @ManyToOne(targetEntity = DictionaryEntries.class)
    @JoinColumn(name = "PORT_ID")
    private DictionaryEntries portId;

    @Column(name = "PORT_NAME")
    private String portName;

    /**
     * EANNO
     */
    @Column(name = "EANNO")
    private String eanNo;

    @OneToMany(mappedBy = "chmConsignment", cascade = CascadeType.ALL)
    private List<ChmConsignmentDetail> chmConsignmentDetailList;


    @Override
    public String toString() {
        return "ChmConsignment{" +
                "id=" + id +
                ", enteringNo='" + enteringNo + '\'' +
                ", customsNo='" + customsNo + '\'' +
                ", recordCode='" + recordCode + '\'' +
                ", vehicleWay=" + vehicleWay +
                ", vehicleWayCode='" + vehicleWayCode + '\'' +
                ", consignmentCode='" + consignmentCode + '\'' +
                ", consignmentHeadCode='" + consignmentHeadCode + '\'' +
                ", tradeModeDic=" + tradeModeDic +
                ", tradeMode='" + tradeMode + '\'' +
                ", taxNatureDic=" + taxNatureDic +
                ", taxNature='" + taxNature + '\'' +
                ", dealModeDic=" + dealModeDic +
                ", dealMode='" + dealMode + '\'' +
                ", packageTypeDic=" + packageTypeDic +
                ", packageType='" + packageType + '\'' +
                ", fromCountryDic=" + fromCountryDic +
                ", fromCountry='" + fromCountry + '\'' +
                ", throughStopPortDic=" + throughStopPortDic +
                ", throughStopPort='" + throughStopPort + '\'' +
                ", tradeAreaCodeDic=" + tradeAreaCodeDic +
                ", tradeAreaCode='" + tradeAreaCode + '\'' +
                ", transCost=" + transCost +
                ", transCurrencyDic=" + transCurrencyDic +
                ", transCurrency='" + transCurrency + '\'' +
                ", insuranceCost=" + insuranceCost +
                ", insuranceCostCurrencyDic=" + insuranceCostCurrencyDic +
                ", insuranceCostCurrency='" + insuranceCostCurrency + '\'' +
                ", otherCost=" + otherCost +
                ", otherCurrencyDic=" + otherCurrencyDic +
                ", otherCurrency='" + otherCurrency + '\'' +
                ", contractCode='" + contractCode + '\'' +
                ", counts=" + counts +
                ", grossWeight=" + grossWeight +
                ", netWeight=" + netWeight +
                ", tradeCoSCC='" + tradeCoSCC + '\'' +
                ", operateUnitName='" + operateUnitName + '\'' +
                ", overseasConsignorFnCname='" + overseasConsignorFnCname + '\'' +
                ", overseasConsignorCode='" + overseasConsignorCode + '\'' +
                ", declaredRemark='" + declaredRemark + '\'' +
                ", declaredUnitName='" + declaredUnitName + '\'' +
                ", createTime=" + createTime +
                ", creator='" + creator + '\'' +
                ", updateTime=" + updateTime +
                ", consStatusDic=" + consStatusDic +
                ", consStatus='" + consStatus + '\'' +
                '}';
    }
}