Project

General

Profile

Actions
Copy link

VOC support #2604

closed

[OMH] Date request - Rate+allotment check 1215 & please check my request as below.

Added by Tracy Tran 3 months ago. Updated 3 months ago.

Status:
완료성공(Resolve)
Priority:
긴급(Emergency)
Assignee:
Mon Nguyen
Target version:
v1.0.0
Start date:
12/12/2025
Due date:
12/12/2025
% Done:

100%

Estimated time:
0.50 h
Spent time:
0.50 h
Part:
Build env.:
Prod

Description

I would like to request data below. Rate+allotment check 1215

1. For 30 days: If there is rate & allotment below 10days , please mark it as "No bookable".

--> which mean we have 1/3 has no allotment/rate.

2. For 60days: From 31~60days, If there is rate & allotment below 10days , please mark it as "No bookable".

3. For 90days: From 61~90days, If there is rate & allotment below 10days , please mark it as "No bookable".

Could you please help divide the data into these time segments (0–30 days, 31–60 days, 61–90 days) accordingly?

Also, besides of adding the region/city, there are also duplicate hotels, which you mentioned before since is based on contract, is it possible to include the contract type as well?

Please check the example for 20251103 attached.

If possible, we would like to collect it by today.

Very appreciate for your help and assistance.

Thank you.

Best Regards,

Grace

Files

Download all files
Script.sql (3.56 KB) Script.sql Mon Nguyen, 12/12/2025 10:04 AM
20251212-export-hotel-bookable-30-60-90.xlsx (539 KB) 20251212-export-hotel-bookable-30-60-90.xlsx Mon Nguyen, 12/12/2025 10:04 AM
Actions
Copy link

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)