/* @tier easy @module st @transform settlement-online */ /* * st_ol_0030.pgc - 정산 통화환산(원화) (ST_OL_0030) [tier=easy] * * 외화 매출을 적용환율(1e4 스케일)로 원화 환산한다. 원화 환산액은 * 원단위 미만을 절사하고, 수수료는 환산 후 원화 기준으로 산출한다. * 환율 미입력 시 통화별 고시환율(st_fx_rate)에서 조회한다. */ #include #include #include "txcore.h" #include "txcore_dbio.h" #include "acq_util.h" #include "st_core.h" EXEC SQL INCLUDE sqlca; static long st_fee_round(long amount, long rate_bp) { /* 요율(만분율, basis point) x 금액 -> 원단위 반올림 (BigDecimal HALF_UP 대응) */ if (amount < 0) return -(((-amount) * rate_bp + 5000) / 10000); return (amount * rate_bp + 5000) / 10000; } TX_SERVICE(ST_OL_0030, ctx) { EXEC SQL BEGIN DECLARE SECTION; char h_cur[4]; long h_rate; EXEC SQL END DECLARE SECTION; char merch[16], cur[4]; long fx_amount = 0, rate = 0, fee_bp = 0, krw, fee, net; tx_log(TX_LOG_INFO, "[ST_OL_0030] 정산 통화환산 진입"); if (tx_buf_get(ctx->in, "MERCHID", merch, sizeof(merch)) != TX_OK) { tx_return(ctx, TX_EINVAL, ctx->out); return; } if (tx_buf_get(ctx->in, "CUR", cur, sizeof(cur)) != TX_OK) strncpy(cur, "USD", sizeof(cur) - 1); tx_buf_getlong(ctx->in, "FXAMT", &fx_amount); /* 외화 최소단위 */ tx_buf_getlong(ctx->in, "RATE", &rate); /* 환율 x 10000 */ tx_buf_getlong(ctx->in, "FEEBP", &fee_bp); if (fee_bp <= 0) fee_bp = 200; /* 2% */ /* 고시환율 조회 (당일 최신 고시) */ if (rate <= 0) { strncpy(h_cur, cur, sizeof(h_cur) - 1); h_cur[sizeof(h_cur) - 1] = '\0'; h_rate = 0; EXEC SQL SELECT rate_x10000 INTO :h_rate FROM st_fx_rate WHERE cur_code = :h_cur ORDER BY quote_ts DESC LIMIT 1; if (sqlca.sqlcode == TX_SQL_OK && h_rate > 0) rate = h_rate; else if (sqlca.sqlcode != TX_SQL_OK && sqlca.sqlcode != TX_SQL_NOTFOUND) TX_DBIO_LOG_ERR("SELECT st_fx_rate"); } if (fx_amount <= 0 || rate <= 0) { tx_buf_reset(ctx->out); tx_buf_sets(ctx->out, "RESPCODE", RESP_INVALID); tx_return(ctx, TX_EINVAL, ctx->out); return; } krw = fx_amount * rate / 10000; /* 원단위 미만 절사 */ fee = st_fee_round(krw, fee_bp); net = krw - fee; tx_buf_reset(ctx->out); tx_buf_sets(ctx->out, "RESPCODE", RESP_OK); tx_buf_sets(ctx->out, "MERCHID", merch); tx_buf_sets(ctx->out, "CUR", cur); tx_buf_setlong(ctx->out, "RATE", rate); tx_buf_setlong(ctx->out, "KRW", krw); tx_buf_setlong(ctx->out, "FEE", fee); tx_buf_setlong(ctx->out, "NET", net); tx_log(TX_LOG_INFO, "[ST_OL_0030] 환산 %s fx=%ld rate=%ld krw=%ld net=%ld", cur, fx_amount, rate, krw, net); tx_return(ctx, TX_OK, ctx->out); }