60 lines
1.8 KiB
PHP
60 lines
1.8 KiB
PHP
<?php
|
|
require_once __DIR__ . '/bbs/db_conn.php';
|
|
|
|
$currentYear = (int) date('Y');
|
|
$currentMonth = (int) date('m');
|
|
$currentQuarterNum = (int) ceil($currentMonth / 3);
|
|
$currentQuarterCode = sprintf('CA200Q%02d', $currentQuarterNum);
|
|
|
|
echo "현재년: $currentYear, 현재분기: $currentQuarterCode\n\n";
|
|
|
|
// 학습목표 조회
|
|
echo "=== edu_learning_goals 데이터 조회 ===\n";
|
|
$stmt = db_conn()->prepare(
|
|
"SELECT goal_code, title, quarter, base_year
|
|
FROM edu_learning_goals
|
|
WHERE is_active = '1'
|
|
AND base_year = ?
|
|
AND quarter = ?
|
|
ORDER BY goal_code ASC"
|
|
);
|
|
$stmt->execute([(string)$currentYear, $currentQuarterCode]);
|
|
$goals = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
echo "결과: " . count($goals) . "개\n";
|
|
foreach ($goals as $g) {
|
|
echo "- " . $g['goal_code'] . " : " . $g['title'] . "\n";
|
|
}
|
|
|
|
// 분기 데이터 있나 확인
|
|
echo "\n=== 모든 분기의 edu_learning_goals ===\n";
|
|
$stmt = db_conn()->query(
|
|
"SELECT DISTINCT quarter, COUNT(*) as cnt
|
|
FROM edu_learning_goals
|
|
WHERE is_active = '1'
|
|
GROUP BY quarter"
|
|
);
|
|
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
|
|
echo "- " . $row['quarter'] . " : " . $row['cnt'] . "개\n";
|
|
}
|
|
|
|
// edu_contents 조회
|
|
echo "\n=== edu_contents 데이터 샘플 (첫 3개) ===\n";
|
|
$rows = db_conn()->query("SELECT goal_code, category_group, title, content_url, sort_order FROM edu_contents WHERE is_active='1' LIMIT 3")->fetchAll(PDO::FETCH_ASSOC);
|
|
foreach ($rows as $row) {
|
|
echo json_encode($row, JSON_UNESCAPED_UNICODE) . "\n";
|
|
}
|
|
|
|
// goal_code별 contents 개수
|
|
echo "\n=== goal_code별 contents 개수 ===\n";
|
|
$stmt = db_conn()->query(
|
|
"SELECT goal_code, COUNT(*) as cnt
|
|
FROM edu_contents
|
|
WHERE is_active = '1'
|
|
GROUP BY goal_code
|
|
ORDER BY goal_code"
|
|
);
|
|
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
|
|
echo "- " . ($row['goal_code'] ?? 'NULL') . " : " . $row['cnt'] . "개\n";
|
|
}
|
|
?>
|