VOC support #2269
closed[VOC] Export excel file from July 1 to August 31
100%
Description
Request
please extract the performance file. (EXCEL)
The target cities are as follows:
Okinawa City, Naha, Onna, Ishigaki, Miyakojima, Nago, Yomitan, Chatan, Okinawa.
Please include all bookings from July 1 to August 31 (based on booking date, including cancellations).
Files
Updated by Daniel Do 4 months ago
- File 20251111-Export excel file from July 1 to August 31.xlsx 20251111-Export excel file from July 1 to August 31.xlsx added
- Status changed from 진행(Doing) to 완료(Done)
- Assignee changed from Daniel Do to Joseph Vo
- % Done changed from 0 to 100
- Estimated time changed from 1.00 h to 2.00 h
- Build env. set to Prod
SELECT
'Japan' COUNTRY_CODE
, HHM.REGION_CODE
, BRC.REGION_NAME_EN AS REGION_NAME
, HHM.HOTEL_CODE
, HHM.HOTEL_NAME_EN AS HOTEL_NAME
, BBHI.BOOKING_ITEM_CODE AS BOOKING_CODE
, BBHI.CHECK_IN_DATE
, BBHI.CHECK_OUT_DATE
, BBHI.FIRST_INSERT_DATETIME BOOKING_DATETIME
, CASE WHEN BBHI.BOOKING_STATUS_CODE IN ('BKS02', 'BKS05') THEN 'Confirmed' ELSE 'Cancelled' END AS STATUS
FROM BK_BOOKING_HOTEL_ITEM BBHI
INNER JOIN BK_BOOKING_MASTER BBM ON BBHI.BOOKING_CODE = BBM.BOOKING_CODE
INNER JOIN HO_HOTEL_MASTER HHM ON BBHI.HOTEL_CODE = HHM.HOTEL_CODE AND HHM.COUNTRY_CODE = 'JP'
INNER JOIN BS_REGION_CODE BRC ON BRC.REGION_CODE = HHM.REGION_CODE
WHERE YEAR = 2025 AND MONTH IN (7, 8)
AND (BRC.REGION_CODE = 116548 OR BRC.PARENT_REGION_CODE = 116548)
ORDER BY BBHI.FIRST_INSERT_DATETIME
;
/*
Okinawa City: 143759
Naha: 102120
Onna: 116547
Ishigaki: 101232
Miyakojima: 101872
Nago: 116546
Yomitan: 116548
Chatan: 186676
Okinawa: 139953
*/Updated by ziniy Kang 4 months ago
- Status changed from 완료(Done) to 완료성공(Resolve)
- Target version set to v1.0.0
