| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124 |
- package com.its.op.entity.its.ifsc;
- import com.its.op.global.CodeManager;
- import com.its.op.dto.its.ifsc.TbReptCngsSectDto;
- import io.swagger.annotations.ApiModel;
- import io.swagger.annotations.ApiModelProperty;
- import lombok.*;
- import javax.persistence.*;
- import java.io.Serializable;
- /**
- * 반복 정체 구간 Entity Class
- */
- @Getter
- @NoArgsConstructor//(access = AccessLevel.PROTECTED)
- @Builder
- @AllArgsConstructor
- @ApiModel("반복 정체 구간")
- @Entity
- @Table(name = "TB_REPT_CNGS_SECT")
- @IdClass(TbReptCngsSectKey.class)
- public class TbReptCngsSect implements Serializable {
- private static final long serialVersionUID = 1L;
- @ApiModelProperty("정보제공구간 ID") // N NUMBER(10)
- @Id
- @Column(name = "IFSC_ID", nullable = false, columnDefinition = "NUMBER", length = 10)
- private Long ifscId;
- @ApiModelProperty("통계 년월") // N VARCHAR(6)
- @Id
- @Column(name = "STAT_YM", nullable = false, length = 6)
- private String statYm;
- @ApiModelProperty("요일 유형 코드") // N VARCHAR(7)
- @Id
- @Column(name = "DAY_TYPE_CD", nullable = false, length = 7)
- private String dayTypeCd;
- @ApiModelProperty("혼잡 시작 시분") // N VARCHAR(4)
- @Id
- @Column(name = "CNFS_STRT_HM", nullable = false, length = 4)
- private String cnfsStrtHm;
- @ApiModelProperty("혼잡 종료 시분") // Y VARCHAR(4)
- @Column(name = "CNFS_END_HM", length = 4)
- private String cnfsEndHm;
- @ApiModelProperty("평균 속도") // Y NUMBER(3)
- @Column(name = "AVRG_SPED", columnDefinition = "NUMBER", length = 3)
- private Integer avrgSped;
- @ApiModelProperty("평균 통행 시간") // Y NUMBER(6)
- @Column(name = "AVRG_TRVL_HH", columnDefinition = "NUMBER", length = 6)
- private Integer avrgTrvlHh;
- @ApiModelProperty("확정 여부") // Y CHAR(1)
- @Column(name = "DCSN_YN", columnDefinition = "CHAR", length = 1)
- private String dcsnYn;
- @ApiModelProperty("생성 일자") // Y VARCHAR(8)
- @Column(name = "CRTN_YMD", length = 8)
- private String crtnYmd;
- @ApiModelProperty("반복 정체 구간 원본 코드") // Y VARCHAR(7)
- @Column(name = "REPT_CNGS_SECT_ORGN_CD", length = 7)
- private String reptCngsSectOrgnCd;
- @OneToOne
- @JoinColumn(insertable=false, updatable=false, name="IFSC_ID", referencedColumnName = "IFSC_ID")
- TbIfsc ifsc;
- public TbReptCngsSectDto toDto() {
- TbReptCngsSectDto dto = TbReptCngsSectDto.builder()
- .ifscId(this.ifscId)
- .statYm(this.statYm)
- .dayTypeCd(this.dayTypeCd)
- .cnfsStrtHm(this.cnfsStrtHm)
- .cnfsEndHm(this.cnfsEndHm)
- .avrgSped(this.avrgSped)
- .avrgTrvlHh(this.avrgTrvlHh)
- .dcsnYn(this.dcsnYn)
- .crtnYmd(this.crtnYmd)
- .reptCngsSectOrgnCd(this.reptCngsSectOrgnCd)
- .build();
- if (this.ifsc != null) {
- dto.setIfscNm(this.ifsc.getIfscNm());
- dto.setStrtNm(this.ifsc.getStrtNm());
- dto.setEndNm(this.ifsc.getEndNm());
- }
- dto.setDayTypeDesc(CodeManager.getCodeDesc(CodeManager.DAY_TYPE_CD, dto.getDayTypeCd()));
- dto.setReptCngsSectOrgnDesc(CodeManager.getCodeDesc(CodeManager.REPT_CNGS_CD, dto.getReptCngsSectOrgnCd()));
- return dto;
- }
- public void cancelCnfm() {
- this.dayTypeCd = "N";
- }
- public void cnfm() {
- this.dcsnYn = "Y";
- }
- public TbReptCngsSect(Long ifscId, String statYm, String dayTypeCd, String cnfsStrtHm) {
- this.ifscId = ifscId;
- this.statYm = statYm;
- this.dayTypeCd = dayTypeCd;
- this.cnfsStrtHm = cnfsStrtHm;
- }
- public void updateInfo(TbReptCngsSectDto.TbReptCngsSectUpdReq req) {
- this.cnfsEndHm = req.getCnfsEndHm();
- this.avrgSped = req.getAvrgSped();
- this.avrgTrvlHh = req.getAvrgTrvlHh();
- this.dcsnYn = req.getDcsnYn();
- this.crtnYmd = req.getCrtnYmd();
- this.reptCngsSectOrgnCd = req.getReptCngsSectOrgnCd();
- }
- }
|