개선(improvement) #943: Migrate plan prices from main database to ES - Ellis improvement - Redmine

Actions

Copy link

개선(improvement) #943

closed

개선(improvement) #317: [New] Setup Elastic search database for read data

Migrate plan prices from main database to ES

Added by Dan Hoang 8 months ago. Updated 7 months ago.

Status:

완료(Done)

Priority:

보통(Normal)

Assignee:

calvin dev

Start date:

07/28/2025

Due date:

07/29/2025

% Done:

100%

Estimated time:

4.00 h

Spent time:

4.00 h

Part:

Build env.:

Dev

Description

Migrate all prices from main database to ES

Actions

Copy link

Updated by calvin dev 8 months ago

Status changed from 신규(New) to 진행(Doing)
Start date set to 07/28/2025

@Data
@JsonIgnoreProperties(ignoreUnknown=true)
public static class PriceDto {
private int date;
private long hotelCode;
private long roomSq;
private long planSq;
private int adult;
private float mspAmount;
private float taxAmount;
private float netAmount;
private float netSellingAmount;
private float grossAmount;
private float contractAmount;
private float extraAdt;
private float extraChd;
private String lastModify = Instant.now().toString();

public String getId() {
           return String.format("%s-%s-%s-%s-%s", hotelCode, roomSq, planSq, date, adult);
       }
   }

Actions

Copy link

Updated by calvin dev 8 months ago

public PlanPrice() {
lastModify = Instant.now().toString();
}
@Override
public String getId() {
return String.format("%s-%s-%s-%s-%s", hotelCode, roomSq, planSq, date, adult);
}
@JsonProperty("d")
private int date;
@JsonProperty("htc")
private long hotelCode;
@JsonProperty("rsq")
private long roomSq;
@JsonProperty("psq")
private long planSq;
@JsonProperty("adt")
private int adult;
@JsonProperty("mspA")
private float mspAmount;
@JsonProperty("taxA")
private float taxAmount;
@JsonProperty("netA")
private float netAmount;
@JsonProperty("netS")
private float netSellingAmount;
@JsonProperty("groA")
private float grossAmount;
@JsonProperty("conA")
private float contractAmount;
@JsonProperty("isS")
private boolean isStop;
@JsonProperty("minN")
private int minNight = 1;
@JsonProperty("maxN")
private int maxNight = 99;
@JsonProperty("cta")
private boolean cta;
@JsonProperty("ctd")
private boolean ctd;
@JsonProperty("extAdt")
private float extraAdt;
@JsonProperty("extChd")
private float extraChd;
@JsonProperty("lstMdf")
private String lastModify;