student_dashboard.php

<?php
function isMobileDevice() {
    return preg_match(
        "/android|iphone|ipad|ipod|blackberry|windows phone/i",
        $_SERVER['HTTP_USER_AGENT']
    );
}

if (isMobileDevice()) {
    header("Location: nohref.php");
    exit;
}

session_start();
require "config.php";

if (!function_exists('isVideo')) {
    function isVideo($file) {
        $ext = strtolower(pathinfo($file, PATHINFO_EXTENSION));
        return in_array($ext, ['mp4', 'webm', 'ogg']);
    }
}


if (!isset($_SESSION['id'])) {
    header("Location: index.php");
    exit;
}

/* ALWAYS re-check user status from DB */
$stmt = $pdo->prepare("SELECT role, is_active FROM users WHERE id = ?");
$stmt->execute([$_SESSION['id']]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$user) {
    session_destroy();
    header("Location: index.php");
    exit;
}

if ((int)$user['is_active'] !== 1) {
    session_destroy();
    header("Location: nohref.php");
    exit;
}

/* Update session with fresh values */
$_SESSION['role'] = $user['role'];
$_SESSION['is_active'] = (int)$user['is_active'];

/* Role check */
if ($user['role'] !== 'student') {
    header("Location: index.php?error=access_denied");
    exit;
}


$user_id = $_SESSION['id'];


/* -------------------------------------------
   FETCH STUDENT PROFILE
-------------------------------------------- */
$stmt = $pdo->prepare("
    SELECT 
    s.*, 
    s.level_id,
    u.reg_number, 
    u.student_id,
    d.name AS department_name
    FROM students s
    LEFT JOIN users u ON s.user_id = u.id
    LEFT JOIN departments d ON s.department_id = d.id
    WHERE s.user_id = ?
");
$stmt->execute([$user_id]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);
@$student_id = (int)$student['id'];



if (!$student) {
    $student = [
        "id" => 0,
        "first_name" => "",
        "username" => "",
        "last_name"  => "",
        "student_number" => "Not Assigned",
        "reg_number" => "Not Assigned",
        "department_name" => "Not Assigned",
        "email" => "",
        "phone" => "",
        "address" => "",
        "dob" => "",
        "emergency_phone" => "",
        "department_id" => 0
    ];
}

$pic = $student['profile_pic'] ?? 'default.png';

/* -------------------------------------------
   ASSIGNMENTS FOR STUDENT + UNREAD COUNT
-------------------------------------------- */
$assignmentsStmt = $pdo->prepare("
    SELECT DISTINCT 
        a.*, 
        c.code AS course_code,
        c.title AS course_title,
        u.full_name AS posted_by_name
    FROM assignments a
    JOIN registrations r ON r.course_id = a.course_id
    JOIN courses c ON a.course_id = c.id
    JOIN teachers t ON a.posted_by = t.id
    JOIN users u ON t.user_id = u.id
    WHERE r.user_id = ?
    ORDER BY a.created_at DESC
");
$assignmentsStmt->execute([$user_id]);
$student_assignments = $assignmentsStmt->fetchAll(PDO::FETCH_ASSOC);



//live vidoe counter
$liveCountStmt = $pdo->prepare("
    SELECT COUNT(*)
    FROM live_classes lc
    WHERE lc.status IN ('scheduled','live')
      AND EXISTS (
          SELECT 1
          FROM registrations r
          WHERE r.course_id = lc.course_id
            AND r.user_id = ?
      )
");
$liveCountStmt->execute([$user_id]);
$live_class_count = (int)$liveCountStmt->fetchColumn();



// unread assignment count (not yet viewed)
$assignCountStmt = $pdo->prepare("
    SELECT COUNT(DISTINCT a.id)
    FROM assignments a
    JOIN registrations r ON r.course_id = a.course_id
    WHERE r.user_id = :uid
    AND a.id NOT IN (
        SELECT assignment_id 
        FROM assignment_views 
        WHERE user_id = :user
    )
");

$assignCountStmt->execute([
    'uid'  => $user_id,   // registrations.user_id
    'user' => $user_id          // assignment_views.user_id (users.id)
]);

$assignment_unread_count = (int) $assignCountStmt->fetchColumn();


/* -------------------------------------------
   ATTENDANCE COUNTERS
-------------------------------------------- */
// First, get the correct student_id from attendance table directly
// Logged-in student (users.id)
$user_id = $_SESSION['id'];

// Convert users.id → students.id
$stmt = $pdo->prepare("
    SELECT id 
    FROM students 
    WHERE user_id = ? 
    LIMIT 1
");
$stmt->execute([$user_id]);
$student_id = $stmt->fetchColumn();

if (!$student_id) {
    $present = $absent = $late = 0;
} else {

    // MONTHLY attendance summary (teacher-recorded)
    $stmt = $pdo->prepare("
        SELECT
            COUNT(*) AS total_days,
            SUM(status = 'present') AS present_days,
            SUM(status = 'absent') AS absent_days,
            SUM(status = 'late') AS late_days
        FROM attendance
        WHERE student_id = ?
          AND MONTH(attendance_date) = MONTH(CURDATE())
          AND YEAR(attendance_date) = YEAR(CURDATE())
    ");
    $stmt->execute([$student_id]);
    $row = $stmt->fetch(PDO::FETCH_ASSOC);

    $present = (int)$row['present_days'];
    $absent  = (int)$row['absent_days'];
    $late    = (int)$row['late_days'];
}


/* -------------------------------------------
   FETCH ALL SECTIONS
-------------------------------------------- */
$notices = $pdo->query("
    SELECT * FROM notices 
    WHERE visible_to IN ('all','students')
    ORDER BY id DESC LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);

/* -------------------------------------------
   NOTICE COUNTER (Shows all notices for students)
-------------------------------------------- */
$user_id = $_SESSION["id"]; // logged-in student id

// Get UNREAD notices only
$noticeCountStmt = $pdo->prepare("
    SELECT COUNT(*) FROM notices n
    WHERE n.visible_to IN ('all','students')
    AND n.id NOT IN (
        SELECT notice_id FROM notice_reads WHERE user_id = :uid
    )
");
$noticeCountStmt->execute(["uid" => $user_id]);
$notice_count = $noticeCountStmt->fetchColumn();


/* -------------------------------------------
   MESSAGE COUNTER (unread messages)
-------------------------------------------- */
$msgCountStmt = $pdo->prepare("
    SELECT COUNT(*) 
    FROM messages 
    WHERE recipient_id = ? AND is_read = 0
");
$msgCountStmt->execute([$user_id]);
$message_count = $msgCountStmt->fetchColumn();


//result
$resultsStmt = $pdo->prepare("
    SELECT r.* FROM results r
    JOIN students s ON r.student_id = s.id
    WHERE s.user_id = ?
    ORDER BY r.id DESC
");
$resultsStmt->execute([$user_id]);
$results = $resultsStmt->fetchAll(PDO::FETCH_ASSOC);

//timetable
$timetableStmt = $pdo->prepare("
    SELECT 
        t.day,
        t.start_time,
        t.end_time,
        t.venue,
        c.code AS course_code,
        c.title AS course_title,
        s.subject_title,
        u.full_name AS lecturer_name
    FROM timetables t
    JOIN (
        SELECT DISTINCT course_id
        FROM registrations
        WHERE user_id = ?
    ) r ON t.course_id = r.course_id
    JOIN courses c ON t.course_id = c.id
    LEFT JOIN course_subjects s ON t.subject_id = s.id
    LEFT JOIN users u ON t.teacher_id = u.id
    ORDER BY 
        FIELD(t.day,'Friday','Saturday','Sunday'),
        t.start_time
");
$timetableStmt->execute([$user_id]);
$timetable = $timetableStmt->fetchAll(PDO::FETCH_ASSOC);



//payment 
$paymentsStmt = $pdo->prepare("
    SELECT * FROM payments
    WHERE student_id = ?
    ORDER BY created_at DESC
");
$paymentsStmt->execute([$student['id']]);
$payments = $paymentsStmt->fetchAll(PDO::FETCH_ASSOC);

$msgStmt = $pdo->prepare("
    SELECT m.*, u.full_name AS sender_name
    FROM messages m
    LEFT JOIN users u ON m.sender_id = u.id
    WHERE m.recipient_id = ?
    ORDER BY m.id DESC LIMIT 6
");
$msgStmt->execute([$user_id]);
$messages = $msgStmt->fetchAll(PDO::FETCH_ASSOC);

$examsStmt = $pdo->prepare("
    SELECT * FROM exams
    WHERE (department_id = ? OR department_id IS NULL)
      AND (start_at IS NULL OR start_at <= NOW())
      AND (end_at IS NULL OR end_at >= NOW())
");
$examsStmt->execute([$student['department_id']]);
$exams = $examsStmt->fetchAll(PDO::FETCH_ASSOC);

$courses = $pdo->query("
    SELECT c.*, d.name AS dept
    FROM courses c
    LEFT JOIN departments d ON c.department_id = d.id
    ORDER BY c.code
")->fetchAll(PDO::FETCH_ASSOC);


$regStmt = $pdo->prepare("
    SELECT r.*, c.code, c.title 
    FROM registrations r
    JOIN courses c ON r.course_id = c.id
    WHERE r.user_id = ?
    ORDER BY r.created_at DESC
");
$regStmt->execute([$user_id]);
$registrations = $regStmt->fetchAll(PDO::FETCH_ASSOC);

$userQuery = $pdo->prepare("
    SELECT full_name, student_id, reg_number
    FROM users 
    WHERE id = ?
");
$userQuery->execute([$_SESSION['id']]);
$userData = $userQuery->fetch(PDO::FETCH_ASSOC);

$regData = $pdo->prepare("
    SELECT 
        r.course_id, r.subject_id,
        c.title AS course_title,
        c.code AS course_code,
        l.level_name,
        s.subject_code,
        s.subject_title
    FROM registrations r
    JOIN courses c ON r.course_id = c.id
    JOIN levels l ON c.level_id = l.id
    JOIN course_subjects s ON r.subject_id = s.id
    WHERE r.user_id = ?
");
$regData->execute([$user_id]);
$studentRegistrations = $regData->fetchAll(PDO::FETCH_ASSOC);


$gradesStmt = $pdo->prepare("
    SELECT 
        s.*, 
        a.title AS assignment_title
    FROM assignment_submissions s
    JOIN assignments a ON s.assignment_id = a.id
    WHERE s.user_id = ?
    ORDER BY s.id DESC
");
$gradesStmt->execute([$user_id]);
$assignment_grades = $gradesStmt->fetchAll(PDO::FETCH_ASSOC);

//video session
$stmt = $pdo->prepare("
    SELECT lc.*
    FROM live_classes lc
    WHERE lc.status IN ('scheduled','live')
      AND EXISTS (
          SELECT 1
          FROM registrations r
          WHERE r.course_id = lc.course_id
            AND r.user_id = ?
      )
");
$stmt->execute([$user_id]);
$liveClasses = $stmt->fetchAll(PDO::FETCH_ASSOC);



?>


<!DOCTYPE html>
<html>
<head>
    <title>Student Dashboard</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="students_dashboard.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">

</head>
<body>

<!-- SIDEBAR -->
<div class="sidebar">

    <!-- Profile Section -->
    <div class="sidebar-profile">
        <img class="sidebar-avatar"
             src="uploads/profile_pic/<?= htmlspecialchars($student['profile_pic'] ?? 'default.png') ?>"
             id="pic_preview">

        <div class="sidebar-user">
            <p class="hello">👋 Hi,</p>
            <p class="username"><?= htmlspecialchars($_SESSION['fullname']) ?></p>
        </div>
    </div>

    <div class="sidebar-title">PIEDELITE</div>

    <div class="sidebar-menu">

        <button onclick="openAndScroll('profile')" id="nav-profile">
            <i class="fa fa-user"></i> Profile
        </button>

         <button onclick="openNoticePopup()" id="nav-notices">
          <i class="fa fa-bullhorn"></i> Notices 
          <span class="badge" id="noticeBadge"><?= $notice_count ?> 
              <?php if ($notice_count == 0): ?>
<script>
document.getElementById("noticeBadge").style.display = "none";
</script>
<?php endif; ?>

          </span>
         </button>

             <button onclick="openMessagePopup()" id="nav-messages">
            <i class="fa fa-envelope"></i> Inbox
           <span class="badge" id="messageBadge"><?= $message_count ?>
          </button>

         <?php if ($message_count == 0): ?>
        <script>
        document.getElementById("messageBadge").style.display = "none";
        </script>
       <?php endif; ?></span>


        <button onclick="openAssignmentPopup()" id="nav-assignments">
            <i class="fa fa-file-alt"></i>Assignment <span class="badge" id="assignmentBadge"><?= $assignment_unread_count ?></span>
        </button>


         <?php if($assignment_unread_count == 0): ?>
        <script>
        document.getElementById("assignmentBadge").style.display = "none";
        </script>
       <?php endif; ?></span>
         
           <button onclick="openAndScroll('results')" id="nav-results">
              <i class="fa fa-chart-column"></i>Result
         </button>

        <button onclick="openAndScroll('timetable')" id="nav-timetable">
            <i class="fa fa-calendar"></i> Timetable / Calander
        </button>

      <button onclick="openAndScroll('live-classes')" id="nav-live-classes">
        <i class="fa fa-video"></i> Live Classes
        <?php if ($live_class_count > 0): ?>
        <span class="badge"><?= $live_class_count ?></span>
       <?php endif; ?>
      </button>

     <button onclick="openAndScroll('learning-resources')" id="nav-learning-resources">
    <i class="fa fa-book"></i> Learning Resources
     </button>


       <button onclick="openRegistrationModal()">
            <i class="fa fa-book"></i> Registration
        </button>




        <button onclick="openAndScroll('exams')" id="nav-exams">
            <i class="fa fa-file-invoice"></i> Exams
        </button>

       

    </div>

</div>


<!-- MAIN SECTION -->
<div class="main">

    <!-- TOP BAR -->
   
   <div class="topbar">

    <!-- LEFT -->
    <div class="topbar-left">

        <span class="role-badge"><?= strtoupper($_SESSION['role']); ?></span>

        <span class="dept-badge">
            <i class="fa fa-building"></i> <?= htmlspecialchars($student['department_name']); ?>
        </span>

        <span class="attendance present">
            <i class="fa fa-check-circle"></i> Present: <?= $present ?>
        </span>

        <span class="attendance absent">
            <i class="fa fa-times-circle"></i> Absent: <?= $absent ?>
        </span>
    </div>


  
 <!-- RIGHT -->
  <div class="topbar-right">

   
    <div class="level-course-box">

       <div class="level-course-box">

        <!-- LEVEL (unchanged) -->
        <div>
            <i class="fa fa-layer-group"></i>
            <?= $studentRegistrations ? $studentRegistrations[0]['level_name'] : "Not registered" ?>
        </div>

        <!-- COURSES — unique and safe for your CSS -->
        <?php
        if ($studentRegistrations) {

            // Collect unique courses without affecting layout
            $unique = [];
            foreach ($studentRegistrations as $r) {
                $unique[$r['course_id']] = $r; // keeps only one per course
            }

            foreach ($unique as $course):
        ?>
                <div>
                    <i class="fa fa-book"></i>
                    <?= $course['course_code'] ?> - <?= $course['course_title'] ?>
                </div>

        <?php
            endforeach;

        } else {
        ?>
            <div>
                Not registered
            </div>
        <?php } ?>

    </div>


     </div>


        <div class="topbar-profile">
            <img src="uploads/profile_pic/<?= htmlspecialchars($student['profile_pic'] ?? 'default.png') ?>" class="topbar-pic">

            <div class="topbar-dropdown">
                <a onclick="openSection('profile')"><i class="fa fa-user"></i> My Profile</a>
                <a onclick="openSection('messages')"><i class="fa fa-envelope"></i> Messages</a>
                <a onclick="openSection('settings')"><i class="fa fa-gear"></i> Settings</a>
                <a href="logout.php" class="logout"><i class="fa fa-power-off"></i> Logout</a>
            </div>
        </div>

    </div>

</div>



    <!-- CONTENT -->
    <div class="content">

     <!-- PROFILE SECTION -->
<div class="section active" id="profile">

    <div class="profile-header">
        <div class="avatar-box">
            <img src="logo.jpeg" class="logome">
           
        </div>

        <div class="profile-basic">
            <h2 class="student-name"><?= $_SESSION["fullname"]; ?></h2>
            <div class="student-meta">
                <span><i class="fa fa-hashtag"></i> ID: <?= htmlspecialchars($userData['student_id']); ?></span>
                <span><i class="fa fa-id-card"></i> Reg: <?= htmlspecialchars($userData['reg_number']); ?></span>
                <span><i class="fa fa-envelope"></i> <?= $student["email"]; ?></span>
            </div>
        </div>
    </div>

    <div class="panel">

        <div class="panel-title">📘 Student Profile Overview</div>

        <div class="profile-grid">

            <div class="profile-item">
                <label><i class="fa fa-phone"></i> Phone</label>
                <div><?= $student["phone"]; ?></div>
            </div>

            <div class="profile-item">
                <label><i class="fa fa-signature"></i> First Name</label>
                <div><?= $student["first_name"]; ?></div>
            </div>

            <div class="profile-item">
                <label><i class="fa fa-signature"></i> Last Name</label>
                <div><?= $student["last_name"]; ?></div>
            </div>

            <div class="profile-item">
                <label><i class="fa fa-calendar"></i> Date of Birth</label>
                <div><?= $student["dob"]; ?></div>
            </div>

            <div class="profile-item">
                <label><i class="fa fa-location-dot"></i> Address</label>
                <div><?= $student["address"]; ?></div>
            </div>

            <div class="profile-item">
                <label><i class="fa fa-phone-alt"></i> Emergency Phone</label>
                <div><?= $student["emergency_phone"]; ?></div>
            </div>

        </div>

        <a href="update_student_profile.php" class="edit-btn">Edit Profile</a>
    </div>

</div>
<br><br>


<tr>
    <td class="section-title"></td>
    <td>
        <?php if ($studentRegistrations): ?>
            <div class="subject-wrapper">
                <h3 class="subject-header">Registered Subjects</h3>

                <div class="subjects-grid">
                    <?php foreach ($studentRegistrations as $sub): ?>
                        <div class="subject-card">
                            <div class="subject-icon">
                                <span><?= strtoupper(substr($sub['subject_title'], 0, 1)) ?></span>
                            </div>

                            <div class="subject-info">
                                <div class="sub-title"><?= $sub['subject_title'] ?></div>
                                <div class="sub-code"><?= $sub['subject_code'] ?></div>
                            </div>
                        </div>
                    <?php endforeach; ?>
                </div>

            </div>
        <?php else: ?>
            <div class="no-subjects">No subjects registered.</div>
        <?php endif; ?>
    </td>
</tr>



        <!-- NOTICES -->
       <center><div class="section" id="notices">
    <h3>📢 Latest School Notices</h3>

    <?php if (empty($notices)): ?>
        <p>No notices available.</p>
    <?php endif; ?>

    <?php foreach ($notices as $n): ?>
        <div class="card">
            <strong><?= htmlspecialchars($n['title']); ?></strong>
            <br>
            <small style="color:gray;">
                Posted on <?= date("M d, Y", strtotime($n['created_at'])); ?>
            </small>

            <p><?= nl2br(htmlspecialchars($n['body'])); ?></p>
        </div>
    <?php endforeach; ?>
</div></center>


        <!-- INBOX -->
        <div class="section" id="messages">
            <h3>📨 Messages</h3>
            <?php foreach ($messages as $m): ?>
                <div class="card">
                    <strong><?= $m['subject']; ?></strong><br>
                    <em>From: <?= $m['sender_name']; ?></em>
                    <p><?= $m['body']; ?></p>
                </div>
            <?php endforeach; ?>
        </div>


        <!-- ASSIGNMENTS -->
<?php if ($assignment_unread_count == 0): ?>
<script>document.addEventListener('DOMContentLoaded', ()=> {
    const b = document.getElementById('assignmentBadge'); if(b) b.style.display='none';
});</script>
<?php endif; ?></span>


<!-- LEARNING RESOURCES -->
<section class="lms-card" id="learning-resources">
    <div class="card-header">
        <h3>📚 Learning Resources</h3>
        <p>Download lecture notes, slides, PDFs, and audio tutorials</p>
    </div>

    <?php
    // Fetch resources assigned to this student  👈 HERE
   $stmt = $pdo->prepare("
    SELECT 
        r.*,
        c.title AS course_title,
        l.level_name,
        cs.subject_title
    FROM resources r
    JOIN courses c ON r.course_id = c.id
    JOIN levels l ON c.level_id = l.id
    LEFT JOIN course_subjects cs ON r.subject_id = cs.id
    WHERE r.course_id IN (
        SELECT course_id
        FROM registrations
        WHERE user_id = :uid
    )
    ORDER BY r.uploaded_at DESC
");

  $stmt->execute([
    'uid' => $user_id
]);
$resources = $stmt->fetchAll(PDO::FETCH_ASSOC);

    ?>


<?php if (empty($resources)): ?>
    <div class="empty-state">
        <p>📭 No learning resources uploaded yet.</p>
    </div>
<?php else: ?>
    <div class="table-responsive">
        <table class="lms-table">
            <thead>
                <tr>
                    <th>Level</th>
                    <th>Course</th>
                    <th>Subject</th>
                    <th>Resource</th>
                    <th>Date</th>
                    <th>Actions</th>
                </tr>
            </thead>
            <tbody>
            <?php foreach ($resources as $r): ?>
                <tr>
                    <td>
                        <span class="badge badge-level">
                            <?= htmlspecialchars($r['level_name']) ?>
                        </span>
                    </td>

                    <td><?= htmlspecialchars($r['course_title']) ?></td>
                    <td><?= htmlspecialchars($r['subject_title'] ?? 'General') ?></td>


                    <td class="file-name">
                        📄 <?= htmlspecialchars($r['filename']) ?>
                    </td>

                    <td><?= date("d M Y", strtotime($r['uploaded_at'])) ?></td>

                   <td class="actions">



                <?php if (isVideo($r['filename'])): ?>
<?php
$ext = strtolower(pathinfo($r['filename'], PATHINFO_EXTENSION));
$mime = match ($ext) {
    'webm' => 'video/webm',
    'ogg'  => 'video/ogg',
    default => 'video/mp4'
};
?>

  

<div style="margin-top:6px;">
    <a class="btn download"
       href="<?= htmlspecialchars($r['filepath']) ?>"
       download>
       ⬇ Download
    </a>
</div>

<?php else: ?>

  <?php if (isVideo($r['filename'])): ?>
    <video width="100" height="40" controls preload="metadata">
        <source src="<?= htmlspecialchars($r['filepath']) ?>" type="video/mp4">
        Your browser does not support the video tag.
    </video>
<?php else: ?>
    <a href="<?= htmlspecialchars($r['filepath']) ?>" download>Download</a> |
    <a href="<?= htmlspecialchars($r['filepath']) ?>" target="_blank">View</a>
<?php endif; ?>

<?php endif; ?>

</td>



                </tr>
            <?php endforeach; ?>
            </tbody>
        </table>
    </div>
<?php endif; ?>
</section>



     

        <!-- RESULTS -->
      <div class="section" id="results">
    <h3>📊 Assignment Grades</h3>

    <?php if (empty($assignment_grades)): ?>
        <p>No grades available yet.</p>
    <?php endif; ?>

    <?php foreach ($assignment_grades as $g): ?>
        <div class="card">
            <strong><?= htmlspecialchars($g['assignment_title']) ?></strong>

            <div class="row">
                Status:
                <span class="grade-status <?= $g['graded'] ? 'graded' : 'pending' ?>">
                    <?= $g['graded'] ? 'Graded' : 'Pending' ?>
                </span>
            </div>

            <div class="row">
                Grade:
                <span class="grade-value">
                    <?= $g['graded'] ? htmlspecialchars($g['grade']) : '—' ?>
                </span>
            </div>

            <div class="grade-comment">
                <?= $g['graded'] 
                    ? nl2br(htmlspecialchars($g['grade_comment'])) 
                    : 'No feedback yet.' 
                ?>
            </div>
        </div>
    <?php endforeach; ?>
</div>



        <!-- TIMETABLE -->
     <div class="section" id="timetable">
    <h3 class="section-title">📅 Weekly Lecture Timetable</h3>

    <?php if (empty($timetable)): ?>
        <div class="empty-state">
            Timetable not yet published.
        </div>
    <?php else: ?>

    <?php
    // Group timetable by day
    $days = ['Friday','Saturday','Sunday'];
    $grouped = [];

    foreach ($timetable as $t) {
        $grouped[$t['day']][] = $t;
    }
    ?>

    <div class="calendar-grid">

        <?php foreach ($days as $day): ?>
            <div class="calendar-column">

                <div class="calendar-day-header"><?= $day ?></div>

                <?php if (!empty($grouped[$day])): ?>
                    <?php foreach ($grouped[$day] as $t): ?>
                        <div class="calendar-lecture">

                            <div class="calendar-time">
                                <?= date("H:i", strtotime($t['start_time'])) ?>
                                –
                                <?= date("H:i", strtotime($t['end_time'])) ?>
                            </div>

                            <div class="calendar-course">
                                <?= htmlspecialchars($t['course_code']) ?>
                            </div>

                            <div class="calendar-subject">
                                <?= htmlspecialchars($t['subject_title'] ?: 'General Lecture') ?>
                            </div>

                            <div class="calendar-lecturer">
                                👨‍🏫 <?= htmlspecialchars($t['lecturer_name'] ?: 'TBA') ?>
                            </div>

                            <div class="calendar-venue" value="pied campus">
                                📍 <?= htmlspecialchars($t['venue'] ?: 'TBA') ?>
                            </div>

                        </div>
                    <?php endforeach; ?>
                <?php else: ?>
                    <div class="calendar-empty">No lectures</div>
                <?php endif; ?>

            </div>
        <?php endforeach; ?>

    </div>

    <div class="timetable-actions">
        <button onclick="window.location='download_timetable.php'" class="download-btn">
            ⬇ Download Timetable (PDF)
        </button>
    </div>

    <?php endif; ?>
</div>



        <!-- PAYMENTS -->
        <div class="section" id="payments">
            <h3>💳 Payments</h3>
            <?php foreach ($payments as $p): ?>
                <div class="card">
                    ₵<?= $p['amount']; ?> — <strong><?= strtoupper($p['status']); ?></strong>
                </div>
            <?php endforeach; ?>
        </div>

        <!-- EXAMS -->
        <div class="section" id="exams">
            <h3>🧾 Available Exams</h3>
            <?php foreach ($exams as $e): ?>
                <div class="card">
                    <strong><?= $e['title']; ?></strong><br><br>
                    <button onclick="alert('Load exam in center section…')">Take Exam</button>
                </div>
            <?php endforeach; ?>
        </div>


        <!-- LIVE CLASSES -->
<div class="section" id="live-classes">
    <h3>📡 Live Classes</h3>

    <?php
    $now = date('Y-m-d H:i:s');
    ?>

    <?php if (empty($liveClasses)): ?>
        <p>No live classes scheduled.</p>
    <?php endif; ?>

    <?php foreach ($liveClasses as $class): ?>

        <div class="card">

            <strong><?= htmlspecialchars($class['title'] ?? 'Live Class') ?></strong>

            <div style="font-size:13px; color:#666; margin-top:6px;">
                <?= date("M d, Y", strtotime($class['start_time'])) ?>
                • <?= date("H:i", strtotime($class['start_time'])) ?>
                → <?= date("H:i", strtotime($class['end_time'])) ?>
            </div>

         
              <?php if ($class['status'] === 'live'): ?>
    <a 
        href="live_class_room.php?id=<?= (int)$class['id'] ?>" 
        class="btn btn-primary"
        style="margin-top:10px; display:inline-block;"
    >
        🔴 Join Live Class
    </a>
<?php else: ?>
    <span style="color:#999; font-size:13px;">
        ⏳ Scheduled — starts at <?= date("H:i", strtotime($class['start_time'])) ?>
    </span>
<?php endif; ?>


        </div>

    <?php endforeach; ?>
</div>


</div>

<!-- NOTICE POPUP -->
<div id="noticeModal" class="notice-modal">
    <div class="notice-box">
        <span class="close-btn" onclick="closeNoticePopup()">&times;</span>
        <h2>📢 School Notices</h2>

        <?php if (empty($notices)): ?>
            <p>No notices available.</p>
        <?php endif; ?>

        <?php foreach ($notices as $n): ?>
            <div class="notice-card">
                <strong><?= htmlspecialchars($n['title']); ?></strong>
                <br>
                <small>Posted on <?= date("M d, Y", strtotime($n['created_at'])); ?></small>
                <p><?= nl2br(htmlspecialchars($n['body'])); ?></p>
            </div>
        <?php endforeach; ?>
    </div>
</div>


<!-- MESSAGE POPUP -->
<div id="messageModal" class="notice-modal">
    <div class="notice-box">
        <span class="close-btn" onclick="closeMessagePopup()">&times;</span>
        <h2>📨 Your Messages</h2>

        <?php if (empty($messages)): ?>
            <p>No messages available.</p>
        <?php endif; ?>

        <?php foreach ($messages as $msg): ?>
            <div class="notice-card" style="<?= $msg['is_read'] ? '' : 'background:#eef7ff;' ?>">
                <strong><?= htmlspecialchars($msg['subject']); ?></strong>
                <br>
                <small>From <?= htmlspecialchars($msg['sender_name']); ?></small>
                <p><?= nl2br(htmlspecialchars($msg['body'])); ?></p>
            </div>
        <?php endforeach; ?>

    </div>
</div>

<!-- ASSIGNMENT POPUP -->
<div id="assignmentModal" class="notice-modal">
    <div class="notice-box">
        <span class="close-btn" onclick="closeAssignmentPopup()">&times;</span>
        <h2>📚 Assignments</h2>
        
        <?php if (empty($student_assignments)): ?>
            <p>No assignments available.</p>
        <?php endif; ?>

        <?php foreach ($student_assignments as $a): ?>
            <div class="notice-card" style="background:#fff;">
                <div style="display:flex; justify-content:space-between;">
                    <div>
                        <strong><?= htmlspecialchars($a['title']) ?></strong>
                        <div style="font-size:13px; color:#666;">
                            Posted by <?= htmlspecialchars($a['posted_by_name'] ?: 'Staff') ?>
                            • <?= date("M d, Y", strtotime($a['created_at'])) ?>
                            <?php if (!empty($a['due_date'])): ?>
                                • Due <?= date("M d, Y", strtotime($a['due_date'])) ?>
                            <?php endif; ?>
                        </div>
                    </div>

                    <div style="text-align:right;">
                        <a href="download_assignment.php?id=<?= $a['id'] ?>" style="font-size:13px; margin-right:8px;">Download</a>
                        <a href="submission_upload.php?assignment_id=<?= $a['id'] ?>" style="font-size:13px;">Submiter</a>
                    </div>
                </div>

                <p style="margin-top:10px;"><?= nl2br(htmlspecialchars($a['description'])) ?></p>
            </div>
        <?php endforeach; ?>
    </div>
</div>




        <!-- TRANSCRIPT -->
        <div class="section" id="transcript">
            <h3>📄 Transcript</h3>
            <div class="card">
                <button onclick="window.location='download_transcript.php'">
                    Download Transcript
                </button>
            </div>
        </div>

    </div>
</div>



<script>
function openModal(id){
    document.getElementById(id).style.display="block";
    document.getElementById("overlay").style.display="block";
}

function closeModal(id){
    document.getElementById(id).style.display="none";
    document.getElementById("overlay").style.display="none";
}
</script>

<script>
function openRegistrationModal(){
    window.location.href="course_registration.php";
}
</script>

<script>
function openNoticePopup() {

    // OPEN POPUP
    document.getElementById("noticeModal").style.display = "flex";

    // AJAX: Mark all notices read
    fetch("mark_notices_read.php", {
        method: "POST"
    })
    .then(r => r.json())
    .then(res => {
        if (res.success) {
            // Reset counter on screen
            document.getElementById("noticeBadge").innerText = "0";
            document.getElementById("noticeBadge").style.display = "none";
        }
    });
}

function closeNoticePopup() {
    document.getElementById("noticeModal").style.display = "none";
}
</script>

<script>
function openMessagePopup() {

    // OPEN POPUP
    document.getElementById("messageModal").style.display = "flex";

    // AJAX to mark messages as read
    fetch("mark_messages_read.php", { method: "POST" })
    .then(resp => resp.json())
    .then(data => {
        if (data.success) {
            document.getElementById("messageBadge").innerText = "0";
            document.getElementById("messageBadge").style.display = "none";
        }
    });
}

function closeMessagePopup() {
    document.getElementById("messageModal").style.display = "none";
}
</script>


<script>
function openAssignmentPopup() {
    document.getElementById("assignmentModal").style.display = "flex";

    // Mark assignments viewed via AJAX
    fetch("mark_assignments_viewed.php", { method: "POST" })
    .then(r => r.json())
    .then(res => {
        if (res.success) {
            const b = document.getElementById('assignmentBadge');
            if (b) { b.innerText = "0"; b.style.display = "none"; }
        } else {
            console.error(res.error || "Failed to mark assignments read");
        }
    }).catch(err => console.error(err));
}

function closeAssignmentPopup() {
    document.getElementById("assignmentModal").style.display = "none";
}
</script>

<script>
function openAndScroll(id) {

    // Sidebar active state
    document.querySelectorAll(".sidebar-menu button").forEach(btn => {
        btn.classList.remove("active");
    });
    const navBtn = document.getElementById("nav-" + id);
    if (navBtn) navBtn.classList.add("active");

    // Show section
    document.querySelectorAll(".section").forEach(sec => {
        sec.classList.remove("active");
        sec.style.display = "none";
    });

    const section = document.getElementById(id);
    if (!section) return;

    section.style.display = "block";
    section.classList.add("active");

    // Smooth scroll AFTER display
    setTimeout(() => {
        section.scrollIntoView({
            behavior: "smooth",
            block: "start"
        });
    }, 40);
}
</script>

<script>
function markAssignmentsViewed() {
    fetch("mark_assignment_view.php")
        .then(res => res.json())
        .then(data => {
            if (data.success) {
                const badge = document.getElementById("assignmentBadge");
                if (badge) badge.style.display = "none";
            }
        });
}

</script>

<script>
setInterval(() => {
    fetch("check_live_classes.php")
        .then(r => r.json())
        .then(data => {
            if (data.hasLive) {
                location.reload();
            }
        });
}, 10000); // every 10 seconds
</script>


<div id="overlay" class="modal-overlay"></div>

</body>
</html>