기능(Feature) #486: [Coupon] Implement backend API to update coupon amount - Hana card travel bucket - Redmine

Actions

Copy link

기능(Feature) #486

closed

기능(Feature) #287: Hana Coupon

[Coupon] Implement backend API to update coupon amount

Added by Dan Hoang 9 months ago. Updated 9 months ago.

Status:

완료성공(Resolve)

Priority:

높음(High)

Assignee:

Dante Le

Target version:

Start date:

06/04/2025

Due date:

06/09/2025

% Done:

100%

Estimated time:

Part:

Build env.:

Prod

Description

Update COUPON_APPLIED_VALUE, COUPON_SHARE_APPLIED_VALUE1, COUPON_SHARE_APPLIED_VALUE2 to Zero in PM_USED_COUPON table for cancellation booking purpose
[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')

[API info]
- Endpoint: /booking/hotel/hana/cancel-coupon
- Request:

{
    "condition": {
        "affiliateUserNo": "test1",
        "bookingItemCode": "K25060510015H01" 
    },
    "stationTypeCode": "STN01",
    "currency": "KRW",
    "country": "KR",
    "language": "KO" 
}

- Response:

{
    "serviceCode": "/booking/hotel/hana/cancel-coupon",
    "transactionSetId": "FBF6640D60BA49FF88552722F2DAA38A",
    "succeedYn": true,
    "serviceName": "/booking/hotel/hana/cancel-coupon" 
}

- CUrl:

curl --location 'http://localhost:8080/booking/hotel/hana/cancel-coupon' \
--header 'accept: application/json, text/plain, */*' \
--header 'accept-language: en-US,en;q=0.9,vi;q=0.8' \
--header 'cache-control: no-cache' \
--header 'content-type: application/json' \
--header 'origin: https://www.ohmytrip.com' \
--header 'pragma: no-cache' \
--header 'priority: u=1, i' \
--header 'referer: https://www.ohmytrip.com/' \
--header 'sec-ch-ua: "Chromium";v="136", "Google Chrome";v="136", "Not.A/Brand";v="99"' \
--header 'sec-ch-ua-mobile: ?0' \
--header 'sec-ch-ua-platform: "Windows"' \
--header 'sec-fetch-dest: empty' \
--header 'sec-fetch-mode: cors' \
--header 'sec-fetch-site: same-site' \
--header 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36' \
--data '{
    "condition": {
        "affiliateUserNo": "test1",
        "bookingItemCode": "K25060510015H01" 
    },
    "stationTypeCode": "STN01",
    "currency": "KRW",
    "country": "KR",
    "language": "KO" 
}'