Hana card travel bucket

기능(Feature) #486

Updated by Dante Le 9 months ago

Update COUPON_APPLIED_VALUE, COUPON_SHARE_APPLIED_VALUE1, COUPON_SHARE_APPLIED_VALUE2 to Zero in PM_USED_COUPON table for cancellation booking purpose 
 *[SQL]* Endpoint: /booking/hotel/hana/cancel-coupon 
 [SQL] 
 <pre><code class="sql"> 
 INSERT INTO OMH_SUITE.BS_API_SERVICE_CODE (API_SERVICE_URL, METHOD_NAME, OWNER_COMP_CODE, API_SERVICE_NAME_EN, 
                                            API_SERVICE_NAME_KO, SCHEMA_FILE_NAME_RQ, SCHEMA_FILE_NAME_RS, 
                                            VENDOR_SERVICE_NAME, API_SERVICE_DESC, SAMPLE_REQUEST_MESSAGE, 
                                            SAMPLE_RESPONSE_MESSAGE, OPEN_API_YN, OUTSIDE_INTERFACE_YN, LOG_SAVE_YN, 
                                            IGNORE_SCHEMA_YN, CONTROL_REMARK, USE_YN, FIRST_INSERT_UNO, 
                                            FIRST_INSERT_DATETIME, LAST_UPDATE_UNO, LAST_UPDATE_DATETIME) 
 VALUES ('/booking/hotel/hana/cancel-coupon', 'POST', 110000, 'cancel coupon', 'canel coupon', 
         '/booking/hotel/hana/cancel_coupon/cancel_coupon_schema_rq.json', 
         '/booking/hotel/hana/cancel_coupon/cancel_coupon_schema_rs.json', '', '', '', '', 'N', 'N', 'N', 'N', '', 'Y', 
         10000, '2025-06-03 18:36:35', 10000, '2025-06-03 18:36:35') 
 </code></pre> 
 *[API info]* 
 - Endpoint: /booking/hotel/hana/cancel-coupon 
 - Request: 
 <pre><code class="javascript"> 
 { 
     "condition": { 
         "affiliateUserNo": "test1", 
         "bookingItemCode": "K25060510015H01" 
     }, 
     "stationTypeCode": "STN01", 
     "currency": "KRW", 
     "country": "KR", 
     "language": "KO" 
 } 
 </code></pre> 
 - Response: 
 <pre><code class="javascript"> 
 { 
     "serviceCode": "/booking/hotel/hana/cancel-coupon", 
     "transactionSetId": "FBF6640D60BA49FF88552722F2DAA38A", 
     "succeedYn": true, 
     "serviceName": "/booking/hotel/hana/cancel-coupon" 
 } 
 </code></pre> 

Back