/* @tier medium @module py @transform payment-online */
/*
 * py_ol_0024.pgc - 지급 예정액 조회(미지급 대기 합계) (PY_OL_0024)  [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_0024, ctx)
{
    EXEC SQL BEGIN DECLARE SECTION;
    char h_bdate[9];
    int  h_cnt;
    long h_sum, h_fee;
    EXEC SQL END DECLARE SECTION;

    char bdate[16], won[32];

    tx_log(TX_LOG_INFO, "[PY_OL_0024] 지급 예정액 조회 진입");
    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 count(*), coalesce(sum(amount), 0), coalesce(sum(fee), 0)
        INTO :h_cnt, :h_sum, :h_fee
        FROM py_ledger
        WHERE biz_date = :h_bdate AND status IN ('R','M');
    if (sqlca.sqlcode != TX_SQL_OK) { TX_DBIO_LOG_ERR("py_ol_0024"); tx_return(ctx, TX_EDB, ctx->out); return; }

    amount_format_won(h_sum - h_fee, won, sizeof(won));
    tx_buf_reset(ctx->out);
    tx_buf_sets(ctx->out, "BIZDATE", bdate);
    tx_buf_setlong(ctx->out, "PENDCNT", h_cnt);
    tx_buf_setlong(ctx->out, "PENDNET", h_sum - h_fee);
    tx_buf_sets(ctx->out, "PENDWON", won);
    tx_log(TX_LOG_INFO, "[PY_OL_0024] 지급예정 date=%s cnt=%d net=%ld", bdate, h_cnt, h_sum - h_fee);
    tx_return(ctx, TX_OK, ctx->out);
}