VOC

-- [VOC #3039] Change Vendor Payment Status: Fully Paid -> Not Paid
-- Booking: K26012410557H01
-- Reason: Due to wrong mapping, AGT agree to pay for different fee, VNOP need to change Buying rate by adding 600,000VND

-- verify (before)
SELECT BOOKING_ITEM_CODE, VENDOR_PAYMENT_STATUS_CODE, VENDOR_SUM_AMOUNT, PL_FINISH_YN
FROM BK_BOOKING_HOTEL_ITEM
WHERE BOOKING_ITEM_CODE = 'K26012410557H01';

-- execute
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS01',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K26012410557H01'
  AND VENDOR_PAYMENT_STATUS_CODE = 'VPS03';

-- verify (after)
SELECT BOOKING_ITEM_CODE, VENDOR_PAYMENT_STATUS_CODE, VENDOR_SUM_AMOUNT, PL_FINISH_YN
FROM BK_BOOKING_HOTEL_ITEM
WHERE BOOKING_ITEM_CODE = 'K26012410557H01';

-- rollback
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
    LAST_UPDATE_UNO = 10000,
    LAST_UPDATE_DATETIME = NOW()
WHERE BOOKING_ITEM_CODE = 'K26012410557H01';