67 lines
1.9 KiB
PHP
67 lines
1.9 KiB
PHP
<?php
|
|
require_once __DIR__ . '/../../bbs/auth.php';
|
|
edu_require_login();
|
|
|
|
include_once __DIR__ . '/../../bbs/db_conn.php';
|
|
|
|
header('Content-Type: application/json');
|
|
|
|
$year = $_GET['year'] ?? date('Y');
|
|
$month = $_GET['month'] ?? '';
|
|
$comp = $_GET['access_comp'] ?? '';
|
|
|
|
if (!$month && !isset($_GET['fr_date'])) {
|
|
echo json_encode(['success' => false, 'message' => '조회 정보가 없습니다.']);
|
|
exit;
|
|
}
|
|
|
|
try {
|
|
$pdo = db_conn();
|
|
|
|
$fr_date = $_GET['fr_date'] ?? '';
|
|
$to_date = $_GET['to_date'] ?? '';
|
|
|
|
// 법인별 접속자 리스트 조회
|
|
$sql = "
|
|
SELECT
|
|
fn_get_code_name(CONCAT('CO100', u.sys_comp_code)) as comp_name,
|
|
u.sys_comp_code,
|
|
u.name,
|
|
u.dept_name,
|
|
u.rank_name,
|
|
a.accessed_at
|
|
FROM edu_access_logs a
|
|
JOIN edu_users u ON a.member_id = u.member_id and a.sys_comp_code = u.sys_comp_code
|
|
WHERE 1=1
|
|
";
|
|
$params = [];
|
|
|
|
if ($fr_date && $to_date) {
|
|
$sql .= " AND a.accessed_at BETWEEN ? AND ?";
|
|
$params[] = "$fr_date 00:00:00";
|
|
$params[] = "$to_date 23:59:59";
|
|
} elseif ($month) {
|
|
$sql .= " AND YEAR(a.accessed_at) = ? AND MONTH(a.accessed_at) = ?";
|
|
$params[] = $year;
|
|
$params[] = $month;
|
|
} else {
|
|
$sql .= " AND YEAR(a.accessed_at) = ?";
|
|
$params[] = $year;
|
|
}
|
|
|
|
if ($comp !== '') {
|
|
$sql .= " AND u.sys_comp_code = ?";
|
|
$params[] = $comp;
|
|
}
|
|
|
|
$sql .= " ORDER BY a.accessed_at DESC, u.sys_comp_code ASC, u.member_id ASC";
|
|
|
|
$stmt = $pdo->prepare($sql);
|
|
$stmt->execute($params);
|
|
$logs = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
echo json_encode(['success' => true, 'data' => $logs]);
|
|
} catch (Exception $e) {
|
|
echo json_encode(['success' => false, 'message' => '데이터 조회 중 오류가 발생했습니다.', 'error' => $e->getMessage()]);
|
|
}
|