27 lines
1.2 KiB
PHP
27 lines
1.2 KiB
PHP
<?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";
|
|
}
|