VOC support #2499: Hardblock Allotment - Update allotment again for hotel 235485 - VOC - Redmine

Actions

Copy link

VOC support #2499

closed

Hardblock Allotment - Update allotment again for hotel 235485

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

Status:

완료성공(Resolve)

Priority:

보통(Normal)

Assignee:

calvin dev

Target version:

v1.0.0

Start date:

12/01/2025

Due date:

12/01/2025

% Done:

100%

Estimated time:

Part:

Build env.:

Description

Booking K25100510382H01

Booking K25092811044H01

These booking were booked under Hardblock allotment but allotment restore error when it were cancelled.
Please check and revert allotment for the date related to these booking.

Files

Download all files

image.png (144 KB) image.png		Tracy Tran, 12/01/2025 02:06 AM
image (24).png (166 KB) image (24).png		Tracy Tran, 12/01/2025 02:07 AM

Actions

Copy link

Updated by calvin dev 3 months ago

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

Actions

Copy link

Updated by calvin dev 3 months ago

OMH_SUITE> UPDATE VD_VENDOR_ROOM_ALLOTMENT SET LEFT_COUNT_SUM = LEFT_COUNT_SUM + 1
WHERE APPLIED_DATE >= '20251215' AND APPLIED_DATE <= '20251218'
AND VENDOR_ROOM_TYPE_SEQ = 132391 AND HOTEL_CONTRACT_SEQ = 100483
[2025-12-01 10:16:31] 4 rows affected in 405 ms

OMH_SUITE> UPDATE VD_VENDOR_ROOM_ALLOTMENT SET LEFT_COUNT_SUM = LEFT_COUNT_SUM + 1
WHERE APPLIED_DATE >= '20251208' AND APPLIED_DATE <= '20251211'
AND VENDOR_ROOM_TYPE_SEQ = 132391 AND HOTEL_CONTRACT_SEQ = 110758
[2025-12-01 10:17:34] 4 rows affected in 386 ms

OMH_SUITE> UPDATE VD_VENDOR_ROOM_ALLOTMENT SET LEFT_COUNT_SUM = LEFT_COUNT_SUM + 1
WHERE APPLIED_DATE >= '20251219' AND APPLIED_DATE <= '20251219'
AND VENDOR_ROOM_TYPE_SEQ = 1269009 AND HOTEL_CONTRACT_SEQ = 109613
[2025-12-01 10:18:06] 1 row affected in 410 ms

Actions

Copy link