VOC

-- ============================================================
-- VOC #2542: Amend buying rate K25110410443H01 // Hotel Sirius
-- Reason: Rate difference occurred - hotel cancelled old charge
-- ============================================================

-- Step 1: Verify current data
SELECT 'BK_BOOKING_HOTEL_ITEM' AS TBL, BOOKING_ITEM_CODE, 
       VENDOR_PAYMENT_STATUS_CODE, VENDOR_BALANCE_AMOUNT, VENDOR_SUM_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM 
WHERE BOOKING_ITEM_CODE = 'K25110410443H01';

SELECT 'PM_PAYMENT_INFO' AS TBL, PAYMENT_SEQ, CARD_PAYMENT_STATUS_CODE, 
       PAID_AMOUNT, DEPOSIT_TYPE_CODE
FROM PM_PAYMENT_INFO 
WHERE BOOKING_ITEM_CODE = 'K25110410443H01' AND DELETE_YN = 'N';

-- Step 2: Update VCC Status to Fully Cancelled (CCS04)
UPDATE PM_PAYMENT_INFO 
SET CARD_PAYMENT_STATUS_CODE = 'CCS04',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE PAYMENT_SEQ = 3543844
  AND BOOKING_ITEM_CODE = 'K25110410443H01'
  AND CARD_PAYMENT_STATUS_CODE = 'CCS02';

-- Step 3: Update V Payment to Not Paid (VPS01) and Vendor Balance to 134,385
UPDATE BK_BOOKING_HOTEL_ITEM 
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS01',
    VENDOR_BALANCE_AMOUNT = 134385.00,
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K25110410443H01'
  AND VENDOR_PAYMENT_STATUS_CODE = 'VPS03';

-- Step 4: Verify after update
SELECT 'BK_BOOKING_HOTEL_ITEM' AS TBL, BOOKING_ITEM_CODE, 
       VENDOR_PAYMENT_STATUS_CODE, VENDOR_BALANCE_AMOUNT
FROM BK_BOOKING_HOTEL_ITEM 
WHERE BOOKING_ITEM_CODE = 'K25110410443H01';

SELECT 'PM_PAYMENT_INFO' AS TBL, PAYMENT_SEQ, CARD_PAYMENT_STATUS_CODE, PAID_AMOUNT
FROM PM_PAYMENT_INFO 
WHERE BOOKING_ITEM_CODE = 'K25110410443H01' AND DELETE_YN = 'N';

-- ============================================================
-- ROLLBACK (if needed)
-- ============================================================
/*
UPDATE PM_PAYMENT_INFO 
SET CARD_PAYMENT_STATUS_CODE = 'CCS02',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE PAYMENT_SEQ = 3543844;

UPDATE BK_BOOKING_HOTEL_ITEM 
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
    VENDOR_BALANCE_AMOUNT = 0.00,
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K25110410443H01';
*/