package com.its.op.model.entity.database;

import com.its.op.model.dto.database.IfscDto;
import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.ColumnDefault;
import org.hibernate.annotations.DynamicInsert;
import org.hibernate.annotations.DynamicUpdate;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@DynamicInsert
@DynamicUpdate
@Getter
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "TB_IFSC")
public class Ifsc {

    @Id
    @Column(nullable = false, unique = true, length = 10)
    private Long    IFSC_ID;            //	N	NUMBER(10)	    N			정보제공구간 ID
    @Column(length = 100)
    private String  IFSC_NM;            //	N	VARCHAR2(100)	Y			정보제공구간 명
    @Column(length = 7)
    private String  DRCT_CD;            //	N	VARCHAR2(7)	    Y			방향 코드
    @Column(length = 100)
    private String  STRT_NM;            //	N	VARCHAR2(100)	Y			시점 명
    @Column(length = 100)
    private String  END_NM;             //	N	VARCHAR2(100)	Y			종점 명
    @Column(nullable = false)
    private Integer SECT_LNGT;          //	N	NUMBER(5)	    Y	0		구간 길이
    @Column(columnDefinition = "CHAR", length = 1)
    @ColumnDefault(value = "N")
    private String  EXTR_CNCT_SECT_YN;  //	N	CHAR(1)	        Y	'N'		외부 연계 구간 여부
    @Column(length = 600)
    private String  RMRK;               //	N	VARCHAR2(600)	Y			비고
    @Column(nullable = false, length = 10)
    private Long    F_NODE_ID;          //	N	NUMBER(10)	    Y			시작 노드 ID
    @Column(nullable = false, length = 10)
    private Long    T_NODE_ID;          //	N	NUMBER(10)	    Y			종료 노드 ID
    @Column(nullable = false, length = 7)
    private String  SECT_GRAD_CD;       //	N	VARCHAR2(7)	    Y			구간 등급 코드
    @Column(nullable = false, length = 7)
    private String  AREA_CD;            //	N	VARCHAR2(7)	    Y			지역 코드

    @Column(columnDefinition = "CHAR", length = 1)
    @ColumnDefault(value = "N")
    private String  DEL_YN;             //	N	CHAR(1)	        Y	'N'		삭제 여부

    /*@OneToOne(mappedBy = "ifscInfo")
    @Fetch(FetchMode.JOIN)
    private IfscTraf ifscTraf = new IfscTraf();*/
   /* @OneToOne
    @JoinColumn(insertable=false, updatable=false, name="IFSC_ID", referencedColumnName = "IFSC_ID")
    private IfscTraf traf = new IfscTraf();

    @OneToOne
    @JoinColumn(insertable=false, updatable=false, name="F_NODE_ID", referencedColumnName = "NODE_ID")
    private Node from_node = new Node();

    @OneToOne
    @JoinColumn(insertable=false, updatable=false, name="T_NODE_ID", referencedColumnName = "NODE_ID")
    private Node to_node= new Node();*/

    public void updateName(IfscDto.IfscNameUpdateReq req) {
        this.IFSC_NM = req.getIFSC_NM();
        this.STRT_NM = req.getSTRT_NM();
        this.END_NM = req.getEND_NM();
    }

}