/* @tier easy @module ac @transform acquire-online */ /* * ac_ol_0019.pgc - 매입 온라인 서비스 (AC_OL_0019) [tier=easy] * * 매입일자 변경: 매입 원장의 영업일을 지정일 또는 다음 영업일로 변경한다. */ #include #include #include "txcore.h" #include "txcore_dbio.h" #include "acq_util.h" #include "ac_core.h" EXEC SQL INCLUDE sqlca; TX_SERVICE(AC_OL_0019, ctx) { EXEC SQL BEGIN DECLARE SECTION; char h_key[16]; char h_old_date[9]; char h_new_date[9]; EXEC SQL END DECLARE SECTION; char key[16], newdate_in[9], computed[9]; int has_newdate; tx_log(TX_LOG_INFO, "[AC_OL_0019] 매입일자 변경 진입"); if (tx_buf_get(ctx->in, "KEY", key, sizeof(key)) != TX_OK) { tx_log(TX_LOG_ERROR, "[AC_OL_0019] KEY 누락"); tx_return(ctx, TX_EINVAL, ctx->out); return; } has_newdate = (tx_buf_get(ctx->in, "NEWDATE", newdate_in, sizeof(newdate_in)) == TX_OK); strncpy(h_key, key, sizeof(h_key) - 1); h_key[sizeof(h_key) - 1] = '\0'; EXEC SQL SELECT biz_date INTO :h_old_date FROM ac_ledger WHERE key = :h_key; if (sqlca.sqlcode == TX_SQL_NOTFOUND) { tx_log(TX_LOG_WARN, "[AC_OL_0019] 매입 원장 없음 key=%s", key); tx_return(ctx, TX_ENOENT, ctx->out); return; } if (sqlca.sqlcode != TX_SQL_OK) { TX_DBIO_LOG_ERR("SELECT ac_ledger biz_date"); tx_return(ctx, TX_EDB, ctx->out); return; } if (has_newdate && date_is_valid(newdate_in)) { strncpy(computed, newdate_in, sizeof(computed) - 1); computed[sizeof(computed) - 1] = '\0'; } else { if (has_newdate) tx_log(TX_LOG_WARN, "[AC_OL_0019] NEWDATE 형식 오류(%s) - 다음영업일로 대체", newdate_in); if (date_next_business(h_old_date, computed) != 0) { tx_log(TX_LOG_ERROR, "[AC_OL_0019] 다음영업일 산출 실패 date=%s", h_old_date); tx_return(ctx, TX_FAIL, ctx->out); return; } } strncpy(h_new_date, computed, sizeof(h_new_date) - 1); h_new_date[sizeof(h_new_date) - 1] = '\0'; if (strcmp(h_old_date, h_new_date) == 0) { tx_log(TX_LOG_INFO, "[AC_OL_0019] 변경 불필요 date=%s", h_old_date); tx_buf_reset(ctx->out); tx_buf_sets(ctx->out, "RESPCODE", RESP_OK); tx_buf_sets(ctx->out, "KEY", key); tx_buf_sets(ctx->out, "OLDDATE", h_old_date); tx_buf_sets(ctx->out, "NEWDATE", h_new_date); tx_return(ctx, TX_OK, ctx->out); return; } if (tx_begin() != TX_OK) { tx_log(TX_LOG_ERROR, "[AC_OL_0019] 트랜잭션 시작 실패"); tx_return(ctx, TX_FAIL, ctx->out); return; } EXEC SQL UPDATE ac_ledger SET biz_date = :h_new_date WHERE key = :h_key; if (sqlca.sqlcode != TX_SQL_OK) { TX_DBIO_LOG_ERR("UPDATE ac_ledger biz_date"); tx_abort(); tx_return(ctx, TX_EDB, ctx->out); return; } if (sqlca.sqlerrd[2] == 0) { tx_log(TX_LOG_WARN, "[AC_OL_0019] 변경대상 없음 key=%s", key); tx_abort(); tx_return(ctx, TX_ENOENT, ctx->out); return; } tx_commit(); tx_buf_reset(ctx->out); tx_buf_sets(ctx->out, "RESPCODE", RESP_OK); tx_buf_sets(ctx->out, "KEY", key); tx_buf_sets(ctx->out, "OLDDATE", h_old_date); tx_buf_sets(ctx->out, "NEWDATE", h_new_date); tx_log(TX_LOG_INFO, "[AC_OL_0019] 완료 key=%s %s -> %s", key, h_old_date, h_new_date); tx_return(ctx, TX_OK, ctx->out); }