This repository has been archived on 2026-07-19. You can view files and clone it, but you cannot make any changes to it's state, such as pushing and creating new issues, pull requests or comments.
acquire-core-full/app/online/mg_ol_0003.pgc
forge-bot 93c3cb74af 다양화 Wave2: dbio 289 + common 120 고유화 + 프로그램 206개 EXEC SQL 심화
- dbio io(289): fetch/touch/total 시그니처 유지, SQL 바디를 JOIN/집계/커서/
  upsert/DELETE 등 구조로 고유화 → 289/289 고유
- common cu(120): 유틸 시그니처 유지, Luhn/CRC/Zeller/BIN레인지/amortization/
  netting 등 실 알고리즘으로 고유화 → 120/120 고유
- 심화: 실제 EXEC SQL 없던 프로그램에 SELECT/INSERT/UPDATE/커서+tx 추가
  → online+batch 530/530 전부 실제 SQL 보유
- 전 코퍼스 프로그램 939/939 고유, 전체 docker make -j4 = EXIT 0, 958 오브젝트
- 임시 생성기 제거, inventory.json loc 실측 갱신

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
2026-07-19 04:54:59 +00:00

144 lines
5 KiB
Text

/* @tier easy @module mg @transform msg-gateway-online */
/*
* mg_ol_0003.pgc - 그리드↔구조체 매핑 서비스 (MG_OL_0003) [tier=easy]
*
* 채널이 올린 입력 그리드(FLDCNT 개의 FLD0..FLDn)를 정해진 컬럼 순서
* 규약에 따라 mg_rec_t 원장 레코드로 매핑한다. 필드 개수/순서/필수값을
* 검증하고 매핑 결과를 tx_buf 로 응답한다.
*/
#include <stdio.h>
#include <string.h>
#include "txcore.h"
#include "txcore_dbio.h"
#include "acq_util.h"
#include "mg_core.h"
EXEC SQL INCLUDE sqlca;
/* 그리드 컬럼 순서 규약: 0=처리키 1=가맹점 2=카드 3=금액 4=영업일 */
#define MG3_COL_KEY 0
#define MG3_COL_MERCH 1
#define MG3_COL_CARD 2
#define MG3_COL_AMOUNT 3
#define MG3_COL_BIZDATE 4
#define MG3_COL_REQUIRED 5
TX_SERVICE(MG_OL_0003, ctx)
{
char fldkey[16];
char cell[64];
mg_rec_t rec;
long fldcnt = 0;
long amount;
int i;
tx_log(TX_LOG_INFO, "[MG_OL_0003] 그리드 매핑 서비스 진입");
/* 1) 그리드 필드 개수 확인 */
if (tx_buf_getlong(ctx->in, "FLDCNT", &fldcnt) != TX_OK) {
tx_log(TX_LOG_ERROR, "[MG_OL_0003] 필드개수(FLDCNT) 누락");
tx_return(ctx, TX_EINVAL, ctx->out);
return;
}
if (fldcnt < MG3_COL_REQUIRED) {
tx_log(TX_LOG_WARN, "[MG_OL_0003] 필수 컬럼 부족 fldcnt=%ld(min=%d)",
fldcnt, MG3_COL_REQUIRED);
tx_buf_reset(ctx->out);
tx_buf_sets(ctx->out, "RESP", RESP_INVALID);
tx_buf_setlong(ctx->out, "FLDCNT", fldcnt);
tx_return(ctx, TX_EINVAL, ctx->out);
return;
}
/* 2) 순서대로 셀을 뽑아 구조체 슬롯에 매핑 */
memset(&rec, 0, sizeof(rec));
amount = 0;
for (i = 0; i < MG3_COL_REQUIRED; i++) {
snprintf(fldkey, sizeof(fldkey), "FLD%d", i);
if (tx_buf_get(ctx->in, fldkey, cell, sizeof(cell)) != TX_OK || cell[0] == '\0') {
tx_log(TX_LOG_WARN, "[MG_OL_0003] 그리드 셀 누락/공백 col=%d key=%s", i, fldkey);
tx_buf_reset(ctx->out);
tx_buf_sets(ctx->out, "RESP", RESP_INVALID);
tx_buf_setlong(ctx->out, "BADCOL", (long)i);
tx_return(ctx, TX_EINVAL, ctx->out);
return;
}
switch (i) {
case MG3_COL_KEY:
strncpy(rec.key, cell, sizeof(rec.key) - 1);
break;
case MG3_COL_MERCH:
strncpy(rec.merch_id, cell, sizeof(rec.merch_id) - 1);
break;
case MG3_COL_CARD:
strncpy(rec.card_no, cell, sizeof(rec.card_no) - 1);
break;
case MG3_COL_AMOUNT:
amount = amount_parse(cell, (int)strlen(cell));
break;
case MG3_COL_BIZDATE:
strncpy(rec.biz_date, cell, sizeof(rec.biz_date) - 1);
break;
default:
break;
}
}
rec.amount = amount;
rec.fee = 0;
strncpy(rec.status, MG_ST_RECV, sizeof(rec.status) - 1);
/* 3) 매핑 후 도메인 검증 */
if (!amount_is_valid(rec.amount) || !date_is_valid(rec.biz_date)) {
tx_log(TX_LOG_WARN, "[MG_OL_0003] 매핑값 검증 실패 amount=%ld date=%s",
rec.amount, rec.biz_date);
tx_buf_reset(ctx->out);
tx_buf_sets(ctx->out, "RESP", RESP_INVALID);
tx_return(ctx, TX_EINVAL, ctx->out);
return;
}
/* 4) 매핑 결과 응답 (원장 적재는 별도 서비스 담당) */
tx_buf_reset(ctx->out);
tx_buf_sets(ctx->out, "RESP", RESP_OK);
tx_buf_sets(ctx->out, "KEY", rec.key);
tx_buf_sets(ctx->out, "MERCHID", rec.merch_id);
tx_buf_sets(ctx->out, "CARDNO", rec.card_no);
tx_buf_setlong(ctx->out, "AMOUNT", rec.amount);
tx_buf_sets(ctx->out, "BIZDATE", rec.biz_date);
tx_buf_setlong(ctx->out, "MAPPED", (long)MG3_COL_REQUIRED);
/* 5) 매핑 결과를 매핑감사 테이블(mg_map_audit)에 임베디드 SQL 로 적재 */
{
EXEC SQL BEGIN DECLARE SECTION;
char h_map_key[16];
char h_map_merch[16];
long h_map_cols;
long h_map_amt;
EXEC SQL END DECLARE SECTION;
strncpy(h_map_key, rec.key, sizeof(h_map_key) - 1);
h_map_key[sizeof(h_map_key) - 1] = '\0';
strncpy(h_map_merch, rec.merch_id, sizeof(h_map_merch) - 1);
h_map_merch[sizeof(h_map_merch) - 1] = '\0';
h_map_cols = (long)MG3_COL_REQUIRED;
h_map_amt = rec.amount;
if (tx_begin() == TX_OK) {
EXEC SQL INSERT INTO mg_map_audit
(map_key, merch_id, col_cnt, map_amount)
VALUES (:h_map_key, :h_map_merch, :h_map_cols, :h_map_amt);
if (sqlca.sqlcode != TX_SQL_OK) {
TX_DBIO_LOG_ERR("INSERT mg_map_audit");
tx_abort();
} else {
tx_commit();
}
}
}
tx_log(TX_LOG_INFO, "[MG_OL_0003] 그리드 매핑완료 key=%s cols=%d amount=%ld",
rec.key, MG3_COL_REQUIRED, rec.amount);
tx_return(ctx, TX_OK, ctx->out);
}