VOC support #2499
closed
Hardblock Allotment - Update allotment again for hotel 235485
Added by Tracy Tran 3 months ago.
Updated 3 months ago.
Description
Booking K25100510382H01
Booking K25092811044H01
.png)
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
- Status changed from 신규(New) to 진행(Doing)
- Start date set to 12/01/2025
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
- Due date set to 12/01/2025
- Status changed from 진행(Doing) to QA test
- Assignee changed from calvin dev to Tracy Tran
- % Done changed from 0 to 100
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Tran to calvin dev
Also available in: Atom
PDF
