VOC

Branch created: `develop-vn/tom/improvement-2645-vcc-cancel-while-new-vcc-setting-under-different-bank-issue`

Repository: oh-api
Workspace: ohmyhotel
Bitbucket URL: https://bitbucket.org/ohmyhotel/oh-api/branch/develop-vn/tom/improvement-2645-vcc-cancel-while-new-vcc-setting-under-different-bank-issue

1. Implementation Summary

Commit: `b760fb8236` - implement 2645 cancel vcc diff bank

1. Problem
   When VCC was created under Bank A (Hana) but booking setting was later changed to Bank B (Citi), account team could not cancel the old VCC because the system was using Bank B's configuration instead of Bank A's.

1. Solution
   Modified the VCC cancel flow to use the original VCC_TYPE_CODE from the payment record (when the VCC was created), not the current booking's VCC type setting.

1. Files Changed (4 files, +287 lines)

1. VCCMapper.java (+5 lines)
- Added 4 new query method declarations:
- `getTemplateItemPaymentSeq()` - Get booking item with VCC type from payment record
- `getVendorPaymentConditionVccType()` - Get vendor payment condition by specific VCC type
- `getVendorPaymentVCCByVccType()` - Get VCC configuration ignoring date conditions (for historical VCC)
- `getCountryInfoByVccTypeCode()` - Get country info for specific VCC type

2. VCCService.java (+189 lines)
- Added `getVendorPaymentForCancel(bookingItemCode, paymentSeq)`:
- Retrieves VCC_TYPE_CODE from PM_PAYMENT_INFO (original VCC type when issued)
- Uses that VCC type to get correct bank configuration for cancel
- Handles fallback if payment VCC type is blank
- Added `diffVccTypeCodeYn()` helper method

3. PaymentVccService.java (+6/-2 lines)
- Modified to call `vccService.getVendorPaymentForCancel()` when paymentSeq is provided
- Falls back to original `getVendorPaymentCondition()` for other operations

4. VCCMapper.xml (+87 lines)
- Added 4 new SQL queries:
- `getTemplateItemPaymentSeq` - JOIN BK_BOOKING_HOTEL_ITEM with PM_PAYMENT_INFO to get VCC type from payment
- `getVendorPaymentConditionVccType` - Query with specific VCC type, ignores date condition for cancel
- `getVendorPaymentVCCByVccType` - Get VCC config by type without date restrictions
- `getCountryInfoByVccTypeCode` - Get country info from BS_DETAIL_CODE by VCC type

1. Key Logic
   ```
   Old flow: Cancel VCC → Use current booking's VCC_TYPE_CODE → Fail if different bank
   New flow: Cancel VCC → Get VCC_TYPE_CODE from PM_PAYMENT_INFO → Use original bank config → Success
   ```

---
Branch: `develop-vn/tom/improvement-2645-vcc-cancel-while-new-vcc-setting-under-different-bank-issue`

Đã check VCC - Error message đó là do test từ trước nên có, không ảnh hưởng đến hoạt động hiện tại.