/* @tier medium @module py @transform payment-online */
/*
 * py_ol_0029.pgc - 지급 일련번호 채번(지급전문 시퀀스) (PY_OL_0029)  [tier=medium]
 *
 * TxCore TX_SERVICE 엔트리. 요청 TXBUF 를 검증하고 임베디드 SQL / 표준
 * DBIO / tx_call 로 처리한 뒤 응답 TXBUF 를 구성한다.
 */
#include <stdio.h>
#include <string.h>

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

EXEC SQL INCLUDE sqlca;

TX_SERVICE(PY_OL_0029, ctx)
{
    EXEC SQL BEGIN DECLARE SECTION;
    char h_bdate[9];
    int  h_seq;
    EXEC SQL END DECLARE SECTION;

    char bdate[16], payno[20];

    tx_log(TX_LOG_INFO, "[PY_OL_0029] 지급 일련번호 채번 진입");
    if (tx_buf_get(ctx->in, "BIZDATE", bdate, sizeof(bdate)) != TX_OK)
        date_today(bdate);
    strncpy(h_bdate, bdate, 8); h_bdate[8] = '\0';

    EXEC SQL SELECT coalesce(count(*), 0) + 1 INTO :h_seq
        FROM py_ledger WHERE biz_date = :h_bdate;
    if (sqlca.sqlcode != TX_SQL_OK) { TX_DBIO_LOG_ERR("py_ol_0029"); tx_return(ctx, TX_EDB, ctx->out); return; }

    snprintf(payno, sizeof(payno), "PY%.8s%05d", bdate, h_seq);
    tx_buf_reset(ctx->out);
    tx_buf_sets(ctx->out, "PAYNO", payno);
    tx_buf_setlong(ctx->out, "SEQ", h_seq);
    tx_log(TX_LOG_INFO, "[PY_OL_0029] 지급번호 채번 %s (seq=%d)", payno, h_seq);
    tx_return(ctx, TX_OK, ctx->out);
}