/* @tier easy @module mm @transform master-online */
/*
 * mm_ol_0013.pgc - 공통코드 조회 서비스 (MM_OL_0013)  [tier=easy]
 *
 * 코드그룹(code_grp) + 코드(code)로 공통코드 마스터(mm_common_code)를
 * 조회하여 코드명(code_nm)/사용여부(use_yn)/정렬순서(sort_no)를 반환한다.
 * 미사용(use_yn='N') 코드는 조회되더라도 경고를 남긴다. (조회)
 */
#include <stdio.h>
#include <stdlib.h>
#include <string.h>

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

EXEC SQL INCLUDE sqlca;

TX_SERVICE(MM_OL_0013, ctx)
{
    EXEC SQL BEGIN DECLARE SECTION;
    char h_code_grp[8];
    char h_code[8];
    char h_code_nm[64];
    char h_use_yn[2];
    long h_sort_no;
    EXEC SQL END DECLARE SECTION;

    char code_grp[8];
    char code[8];

    tx_log(TX_LOG_INFO, "[MM_OL_0013] 공통코드 조회 서비스 진입");

    if (tx_buf_get(ctx->in, "CODEGRP", code_grp, sizeof(code_grp)) != TX_OK ||
        tx_buf_get(ctx->in, "CODE", code, sizeof(code)) != TX_OK) {
        tx_log(TX_LOG_ERROR, "[MM_OL_0013] 필수 필드 누락");
        tx_buf_sets(ctx->out, "ERRCODE", "MM1300");
        tx_return(ctx, TX_EINVAL, ctx->out);
        return;
    }

    strncpy(h_code_grp, code_grp, sizeof(h_code_grp) - 1);
    h_code_grp[sizeof(h_code_grp) - 1] = '\0';
    strncpy(h_code, code, sizeof(h_code) - 1);
    h_code[sizeof(h_code) - 1] = '\0';

    EXEC SQL SELECT code_nm, use_yn, sort_no
          INTO :h_code_nm, :h_use_yn, :h_sort_no
          FROM mm_common_code
         WHERE code_grp = :h_code_grp
           AND code     = :h_code;

    if (sqlca.sqlcode == TX_SQL_NOTFOUND) {
        tx_log(TX_LOG_WARN, "[MM_OL_0013] 미등록 코드 grp=%s code=%s", code_grp, code);
        tx_buf_sets(ctx->out, "ERRCODE", "MM1301");
        tx_return(ctx, TX_ENOENT, ctx->out);
        return;
    }
    if (sqlca.sqlcode != TX_SQL_OK) {
        TX_DBIO_LOG_ERR("SELECT mm_common_code");
        tx_buf_sets(ctx->out, "ERRCODE", "MM1302");
        tx_return(ctx, TX_EDB, ctx->out);
        return;
    }

    if (strcmp(h_use_yn, "N") == 0)
        tx_log(TX_LOG_WARN, "[MM_OL_0013] 미사용 코드 grp=%s code=%s", code_grp, code);

    tx_buf_reset(ctx->out);
    tx_buf_sets(ctx->out, "CODEGRP", code_grp);
    tx_buf_sets(ctx->out, "CODE", code);
    tx_buf_sets(ctx->out, "CODENM", h_code_nm);
    tx_buf_sets(ctx->out, "USEYN", h_use_yn);
    tx_buf_setlong(ctx->out, "SORTNO", h_sort_no);
    tx_buf_sets(ctx->out, "ERRCODE", RESP_OK);
    tx_log(TX_LOG_INFO, "[MM_OL_0013] 조회완료 grp=%s code=%s 명=%s",
           code_grp, code, h_code_nm);
    tx_return(ctx, TX_OK, ctx->out);
}