getConnection(); // Member stats $sql = "SELECT COUNT(*) as total FROM users WHERE status = 1 AND role != 'advisor'"; $stmt = $conn->prepare($sql); $stmt->execute(); $total_members = $stmt->fetch()['total']; // Project stats (filtered by academic year) $year_filter = getSelectedAcademicYearId($conn); $sql = "SELECT COUNT(*) as total, SUM(CASE WHEN status = 'planning' THEN 1 ELSE 0 END) as planning, SUM(CASE WHEN status = 'in_progress' THEN 1 ELSE 0 END) as in_progress, SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) as completed, SUM(CASE WHEN status = 'on_hold' THEN 1 ELSE 0 END) as on_hold FROM projects WHERE status != 'cancelled'"; if ($year_filter && $year_filter != 0) { $sql .= " AND academic_year_id = ?"; $stmt = $conn->prepare($sql); $stmt->execute([$year_filter]); } else { $stmt = $conn->prepare($sql); $stmt->execute(); } $project_stats = $stmt->fetch(); // Task stats (filtered by academic year through projects) $sql = "SELECT COUNT(*) as total, SUM(CASE WHEN t.status = 'pending' THEN 1 ELSE 0 END) as pending, SUM(CASE WHEN t.status = 'in_progress' THEN 1 ELSE 0 END) as in_progress, SUM(CASE WHEN t.status = 'under_review' THEN 1 ELSE 0 END) as review, SUM(CASE WHEN t.status = 'completed' THEN 1 ELSE 0 END) as completed FROM tasks t LEFT JOIN projects p ON t.project_id = p.id WHERE 1=1"; if ($year_filter && $year_filter != 0) { $sql .= " AND t.academic_year_id = ?"; $stmt = $conn->prepare($sql); $stmt->execute([$year_filter]); } else { $stmt = $conn->prepare($sql); $stmt->execute(); } $task_stats = $stmt->fetch(); // My assigned tasks (งานที่ได้รับมอบหมาย) - filtered by academic year $user_id = $_SESSION['user_id']; $sql = "SELECT t.*, p.name as project_name, CONCAT(creator.first_name_th, ' ', creator.last_name_th) as created_by_name FROM tasks t LEFT JOIN projects p ON t.project_id = p.id INNER JOIN task_assignments ta ON t.id = ta.task_id LEFT JOIN users u ON t.created_by = u.id LEFT JOIN profiles creator ON u.id = creator.user_id WHERE ta.user_id = ? AND t.status IN ('pending', 'in_progress')"; if ($year_filter && $year_filter != 0) { $sql .= " AND t.academic_year_id = ?"; } $sql .= " ORDER BY t.due_date ASC LIMIT 10"; $stmt = $conn->prepare($sql); if ($year_filter && $year_filter != 0) { $stmt->execute([$user_id, $year_filter]); } else { $stmt->execute([$user_id]); } $my_assigned_tasks = $stmt->fetchAll(); // Equipment stats $sql = "SELECT COUNT(*) as total, COUNT(*) as total_qty, SUM(CASE WHEN status = 'available' THEN 1 ELSE 0 END) as available_qty, SUM(CASE WHEN status = 'borrowed' THEN 1 ELSE 0 END) as borrowed_qty, SUM(CASE WHEN status = 'maintenance' THEN 1 ELSE 0 END) as maintenance_qty FROM equipment"; $stmt = $conn->prepare($sql); $stmt->execute(); $equipment_stats = $stmt->fetch(); // Equipment borrowing stats (filtered by academic year) $sql = "SELECT COUNT(*) as total, COALESCE(SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END), 0) as pending, COALESCE(SUM(CASE WHEN status = 'borrowed' THEN 1 ELSE 0 END), 0) as borrowed, COALESCE(SUM(CASE WHEN status = 'request_return' THEN 1 ELSE 0 END), 0) as request_return, COALESCE(SUM(CASE WHEN status = 'returned' THEN 1 ELSE 0 END), 0) as returned FROM equipment_borrowing WHERE 1=1"; $borrowing_params = []; if ($year_filter && $year_filter != 0) { $sql .= " AND academic_year_id = ?"; $borrowing_params[] = $year_filter; } $stmt = $conn->prepare($sql); $stmt->execute($borrowing_params); $borrowing_stats = $stmt->fetch(); // Finance stats (filtered by academic year) $sql = "SELECT COALESCE(SUM(CASE WHEN type = 'income' THEN amount ELSE 0 END), 0) as total_income, COALESCE(SUM(CASE WHEN type = 'expense' THEN amount ELSE 0 END), 0) as total_expense FROM transactions WHERE status = 'approved'"; $finance_params = []; if ($year_filter && $year_filter != 0) { $sql .= " AND academic_year_id = ?"; $finance_params[] = $year_filter; } $stmt = $conn->prepare($sql); $stmt->execute($finance_params); $finance_stats = $stmt->fetch(); $balance = $finance_stats['total_income'] - $finance_stats['total_expense']; // Recent tasks (4 latest tasks, filtered by academic year) $sql = "SELECT t.*, p.name as project_name, CONCAT(creator.first_name_th, ' ', creator.last_name_th) as created_by_name FROM tasks t LEFT JOIN projects p ON t.project_id = p.id LEFT JOIN users u ON t.created_by = u.id LEFT JOIN profiles creator ON u.id = creator.user_id WHERE 1=1"; $recent_task_params = []; if ($year_filter && $year_filter != 0) { $sql .= " AND t.academic_year_id = ?"; $recent_task_params[] = $year_filter; } $sql .= " ORDER BY t.created_at DESC LIMIT 4"; $stmt = $conn->prepare($sql); $stmt->execute($recent_task_params); $recent_tasks = $stmt->fetchAll(); // Include header include 'includes/header.php'; // Include sidebar include 'includes/sidebar.php'; ?>

Dashboard

สมาชิกทั้งหมด

ดูทั้งหมด

โปรเจค

กำลังดำเนินการ

งานทั้งหมด

รอทำ เสร็จสิ้น

งบประมาณคงเหลือ

฿

รายรับ ฿ รายจ่าย ฿

งานของฉัน

ดูทั้งหมด
งาน โปรเจค กำหนดส่ง สถานะ
ด่วน = 0 && $days_left <= 3; ?>
(เกิน วัน)
(เหลือ วัน) 		'รอดำเนินการ', 'in_progress' => 'กำลังทำ', 'under_review' => 'รอตรวจ' ]; echo $status_badges[$task['status']] ?? ''; ?>

ไม่มีงานที่ได้รับมอบหมาย

งานที่เพิ่มล่าสุด

ดูทั้งหมด
งาน โปรเจค วันที่สร้าง สถานะ
'รอทำ', 'in_progress' => 'กำลังทำ', 'under_review' => 'รอตรวจ', 'completed' => 'เสร็จสิ้น' ]; echo $status_badges[$task['status']] ?? ''; ?>

ยังไม่มีงานในระบบ

สรุปสถานะงาน

เสร็จสิ้น

0 ? round(($task_stats['completed'] / $task_stats['total']) * 100, 1) : 0; echo $completed_pct . '%'; ?>

กำลังทำ

0 ? round(($task_stats['in_progress'] / $task_stats['total']) * 100, 1) : 0; echo $in_progress_pct . '%'; ?>

รอตรวจ

0 ? round(($task_stats['review'] / $task_stats['total']) * 100, 1) : 0; echo $review_pct . '%'; ?>

รอดำเนินการ

0 ? round(($task_stats['pending'] / $task_stats['total']) * 100, 1) : 0; echo $pending_pct . '%'; ?>

ปฏิทินและงานของเดือน

งานของเดือน
กำลังโหลด...

สถิติอุปกรณ์

ประเภททั้งหมด

จำนวนทั้งหมด (ชิ้น)

พร้อมใช้งาน

รายการยืมในปี

กำลังยืมในปี

ดูอุปกรณ์