<?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";
}
?>