<?php
ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

require_once __DIR__ . '/../../bbs/db_conn.php';
header('Content-Type: application/json; charset=utf-8');

$sys_comp_code = $_GET['sys_comp_code'] ?? '';
$member_id = $_GET['member_id'] ?? '';
$year = $_GET['year'] ?? date('Y');

if (!$sys_comp_code || !$member_id) {
    echo json_encode(['success' => false, 'message' => '파라미터가 부족합니다.'], JSON_UNESCAPED_UNICODE);
    exit;
}

try {
    $pdo = db_conn();
    
    $stmt = $pdo->prepare("CALL proc_get_member_learning_status(:sys_comp_code, :year, :member_id, 'CA10003')");
    $stmt->execute([
        ':sys_comp_code' => $sys_comp_code,
        ':year' => $year,
        ':member_id' => $member_id
    ]);

    $items = $stmt->fetchAll(PDO::FETCH_ASSOC);
    while ($stmt->nextRowset()) {}

    echo json_encode(['success' => true, 'items' => $items], JSON_UNESCAPED_UNICODE);
} catch (Exception $e) {
    error_log('[get_legal_edu_detail] ' . $e->getMessage());
    echo json_encode([
        'success' => false,
        'message' => '서버 에러',
        'detail' => $e->getMessage()
    ], JSON_UNESCAPED_UNICODE);
    exit;
}