기능(Feature) #480
Updated by John Lee 9 months ago
Implement backend API to create coupon budget, we can use postman to manually create a budget instead of UI now. This API belong to admin site and it will be use for UI in the future.
At least one COUPON_SHARE is required
*Schema of coupon budget*
COUPON_BUDGET_SEQ bigint NOT NULL AUTO_INCREMENT,
SALES_COUNTRY_CODE varchar(9) NOT NULL,
BUDGET_NAME_EN varchar(100) NOT NULL,
BUDGET_NAME_KO varchar(100) NOT NULL,
BUDGET_DESC varchar(1000) DEFAULT NULL,
IN_CHARGE_DEPT_CODE varchar(10) NOT NULL,
SUPPORT_SALES_COMP_CODE_LIST varchar(1000) DEFAULT NULL COMMENT 'Issue for list specific Sellers',
ITEM_CATEGORY_CODE varchar(10) DEFAULT NULL COMMENT 'Reserved Item Category Code: BasicBS003',
COUPON_SHARED_TRADER_COMP_CODE1 int DEFAULT NULL,
COUPON_SHARE_RATE_OR_AMOUNT1 varchar(1) DEFAULT NULL,
COUPON_SHARE_APPLIED_VALUE2 decimal(15, 2) DEFAULT NULL,
COUPON_SHARED_TRADER_COMP_CODE2 int DEFAULT NULL,
COUPON_SHARE_RATE_OR_AMOUNT2 varchar(1) DEFAULT NULL,
COUPON_SHARE_APPLIED_VALUE1 decimal(15, 2) DEFAULT NULL,
TOTAL_BUDGET_AMOUNT decimal(15, 2) NOT NULL,
COUPON_RATE_OR_AMOUNT varchar(1) NOT NULL,
COUPON_APPLIED_VALUE decimal(15, 2) NOT NULL,
MIN_ORDER_AMOUNT decimal(15, 2) NOT NULL COMMENT 'Minimum order value to apply',
DRAFT_CODE varchar(20) DEFAULT NULL COMMENT 'Prefix of coupon code',
USE_YN varchar(1) NOT NULL DEFAULT 'N',
ISSUE_FROM_DATETIME date NOT NULL,
ISSUE_TO_DATETIME date NOT NULL,
USE_FROM_DATE date NOT NULL,
USE_TO_DATE date NOT NULL,
MAX_COUPON_COUNT smallint NOT NULL,
MAX_USAGE_PER_COUPON smallint NOT NULL DEFAULT 1,
FIRST_INSERT_UNO bigint NOT NULL,
FIRST_INSERT_DATETIME datetime NOT NULL,
LAST_UPDATE_UNO bigint NOT NULL,
LAST_UPDATE_DATETIME datetime NOT NULL,
PRIMARY KEY (COUPON_BUDGET_SEQ)
Script insert api schema
<pre><code class="c">
INSERT INTO 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/generate-coupon-item', 'POST', 110000, 'generate coupon item', 'generate coupon item', '/booking/hotel/hana/generate_coupon_item/generate_coupon_item_rq.json', '/booking/hotel/hana/generate_coupon_item/generate_coupon_item_rs.json', '', '', '', '', 'N', 'N', 'N', 'N', '', 'Y', 10000, '2025-06-03 18:36:35', 10000, '2025-06-03 18:36:35');
INSERT INTO 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/coupon-budget', 'PUT', 110000, 'put coupon budget', 'put coupon budget', '/booking/hotel/hana/put_coupon_budget/put_coupon_budget_rq.json', '/booking/hotel/hana/put_coupon_budget/put_coupon_budget_rs.json', '', '', '', '', 'N', 'N', 'N', 'N', '', 'Y', 10000, '2025-06-03 18:36:35', 10000, '2025-06-03 18:36:35');
</code></pre>
