/* @tier easy @module ac @transform acquire-online */
/*
 * ac_ol_0009.pgc - 매입 온라인 서비스 (AC_OL_0009)  [tier=easy]
 *
 * 해외매입 환산: 외화금액(소수 2자리 포함 정수, 즉 외화금액*100)을
 * fx_rate 고시환율로 원화 환산한다. KEY 가 함께 오면 ac_ledger 원장에
 * 환산결과(원화금액/외화금액/통화코드)를 반영한다.
 */
#include <stdio.h>
#include <string.h>

#include "txcore.h"
#include "txcore_dbio.h"
#include "acq_util.h"
#include "ac_core.h"

EXEC SQL INCLUDE sqlca;

TX_SERVICE(AC_OL_0009, ctx)
{
    EXEC SQL BEGIN DECLARE SECTION;
    char h_cur[4];
    char h_bizdate[9];
    long h_fxamt;
    long h_rate;
    char h_key[16];
    long h_krw;
    EXEC SQL END DECLARE SECTION;

    char curcode[4];
    char bizdate[9];
    char key[16];
    long fxamt = 0;
    long krw;
    int  has_key;

    tx_log(TX_LOG_INFO, "[AC_OL_0009] 해외매입 환산 서비스 진입");

    if (tx_buf_get(ctx->in, "CURCODE", curcode, sizeof(curcode)) != TX_OK ||
        tx_buf_get(ctx->in, "BIZDATE", bizdate, sizeof(bizdate)) != TX_OK) {
        tx_log(TX_LOG_ERROR, "[AC_OL_0009] 필수 필드 누락(CURCODE/BIZDATE)");
        tx_return(ctx, TX_EINVAL, ctx->out);
        return;
    }
    tx_buf_getlong(ctx->in, "FXAMT", &fxamt);

    if (curcode[0] == '\0' || !date_is_valid(bizdate) || !amount_is_valid(fxamt)) {
        tx_log(TX_LOG_WARN, "[AC_OL_0009] 입력 검증 실패 cur=%s date=%s fxamt=%ld",
               curcode, bizdate, fxamt);
        tx_return(ctx, TX_EINVAL, ctx->out);
        return;
    }

    strncpy(h_cur, curcode, sizeof(h_cur) - 1);
    h_cur[sizeof(h_cur) - 1] = '\0';
    strncpy(h_bizdate, bizdate, sizeof(h_bizdate) - 1);
    h_bizdate[sizeof(h_bizdate) - 1] = '\0';

    EXEC SQL SELECT base_rate
        INTO :h_rate
        FROM fx_rate
        WHERE cur_code = :h_cur AND rate_date = :h_bizdate;

    if (sqlca.sqlcode == TX_SQL_NOTFOUND) {
        tx_log(TX_LOG_WARN, "[AC_OL_0009] 고시환율 없음 cur=%s date=%s", curcode, bizdate);
        tx_return(ctx, TX_ENOENT, ctx->out);
        return;
    }
    if (sqlca.sqlcode != TX_SQL_OK) {
        TX_DBIO_LOG_ERR("AC_OL_0009 fx_rate select");
        tx_return(ctx, TX_EDB, ctx->out);
        return;
    }

    h_fxamt = fxamt;
    krw = (h_fxamt * h_rate) / 10000;   /* base_rate 는 10000 배 스케일 고시값 */

    /* KEY 가 함께 오면 원장에 환산결과 반영 (조회성 호출이면 생략 가능) */
    has_key = (tx_buf_get(ctx->in, "KEY", key, sizeof(key)) == TX_OK && key[0] != '\0');
    if (has_key) {
        strncpy(h_key, key, sizeof(h_key) - 1);
        h_key[sizeof(h_key) - 1] = '\0';
        h_krw = krw;

        EXEC SQL UPDATE ac_ledger
            SET amount = :h_krw, fx_amount = :h_fxamt, cur_code = :h_cur, upd_ts = now()
            WHERE key = :h_key;

        if (sqlca.sqlcode != TX_SQL_OK) {
            TX_DBIO_LOG_ERR("AC_OL_0009 ac_ledger update");
            tx_return(ctx, TX_EDB, ctx->out);
            return;
        }
        if (sqlca.sqlerrd[2] == 0)
            tx_log(TX_LOG_WARN, "[AC_OL_0009] 반영대상 원장 없음 key=%s", key);
        else
            tx_log(TX_LOG_INFO, "[AC_OL_0009] 원장반영 완료 key=%s krw=%ld", key, krw);
    }

    tx_buf_reset(ctx->out);
    tx_buf_sets(ctx->out, "RESPCODE", RESP_OK);
    tx_buf_sets(ctx->out, "CURCODE", curcode);
    tx_buf_setlong(ctx->out, "FXAMT", fxamt);
    tx_buf_setlong(ctx->out, "RATE", h_rate);
    tx_buf_setlong(ctx->out, "KRWAMT", krw);
    tx_log(TX_LOG_INFO, "[AC_OL_0009] 환산완료 cur=%s fxamt=%ld rate=%ld krw=%ld",
           curcode, fxamt, h_rate, krw);
    tx_return(ctx, TX_OK, ctx->out);
}