Files
edu/admin/bbs/get_legal_edu_detail.php

41 lines
1.2 KiB
PHP

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