<?php
require __DIR__ . '/db_conn.php';

$pdo = db_conn();

$existsStmt = $pdo->prepare("SELECT base_code, code, code_name FROM edu_codes WHERE group_code='KW100' AND code_name = ? LIMIT 1");
$existsStmt->execute(['자기개발']);
$exists = $existsStmt->fetch(PDO::FETCH_ASSOC);

if ($exists) {
    echo "EXISTS|{$exists['base_code']}|{$exists['code']}|{$exists['code_name']}\n";
} else {
    $nextCode = (int)$pdo->query("SELECT COALESCE(MAX(CAST(code AS UNSIGNED)), 0) FROM edu_codes WHERE group_code='KW100'")->fetchColumn() + 1;
    $code = str_pad((string)$nextCode, 2, '0', STR_PAD_LEFT);
    $baseCode = 'KW100' . $code;

    $ins = $pdo->prepare("INSERT INTO edu_codes (group_code, code, base_code, code_name, is_active, created_by, created_at, updated_by, updated_at) VALUES ('KW100', ?, ?, ?, '1', 'admin', NOW(), 'admin', NOW())");
    $ins->execute([$code, $baseCode, '자기개발']);

    echo "INSERTED|{$baseCode}|{$code}|자기개발\n";
}

$rows = $pdo->query("SELECT code, base_code, code_name FROM edu_codes WHERE group_code='KW100' ORDER BY CAST(code AS UNSIGNED)")->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $r) {
    echo "ROW|{$r['code']}|{$r['base_code']}|{$r['code_name']}\n";
}