<?php
session_start();
require_once('../config/db.php');

if (!isset($_SESSION['student_id'])) {
    header('Location: login.php');
    exit;
}

// التحقق من وجود طلب لتغيير اللغة
if (isset($_GET['set_lang'])) {
    $requested_lang = $_GET['set_lang'];
    $allowed_langs = ['ar', 'en', 'tr'];

    if (in_array($requested_lang, $allowed_langs)) {
        $_SESSION['lang'] = $requested_lang;
    }
    
    header("Location: " . strtok($_SERVER["REQUEST_URI"], '?'));
    exit();
}

// تحديد اللغة الافتراضية
$lang = isset($_SESSION['lang']) ? $_SESSION['lang'] : 'ar';

// مصفوفة الترجمة الشاملة
$translations = [
    'ar' => [
        'dir' => 'rtl',
        'font' => "'Cairo', sans-serif",
        'title' => 'لوحة الطالب | معهد لغة العرب',
        'portal' => 'بوابة الطالب',
        'inst_name' => 'معهد لغة العرب',
        'badge' => 'طالب متميز',
        'logout' => 'خروج',
        'welcome' => 'أهلاً بك، سيد',
		'attendance_present' => 'حضور',
        'attendance_absent' => 'غياب',
        'attendance_excused' => 'استئذان',
        'attendance_late' => 'تأخير',
        'hero_desc' => 'في معهد لغة العرب، نسعد بمتابعة تطورك الأكاديمي. يمكنك هنا الاطلاع على مسيرتك التعليمية وإدارة شؤونك المالية بكل سهولة.',
        'today' => 'اليوم',
        'total_fees' => 'إجمالي الرسوم',
        'paid_amount' => 'المبلغ المدفوع',
        'discounts' => 'الخصومات',
        'remaining' => 'المبلغ المتبقي',
        'registered_courses' => 'الدورات المسجلة',
        'course_col' => 'الدورة التعليمية',
        'fees_col' => 'الرسوم',
        'system_col' => 'النظام',
        'rating_col' => 'التقييم',
        'news_title' => 'أخبار المعهد',
        'no_news' => 'لا يوجد إعلانات',
        'payments_log' => 'سجل المدفوعات المالية',
		'no_notes' => 'لا توجد ملاحظات',
        'amount_col' => 'قيمة الدفعة',
        'discount_col' => 'الخصم',
        'date_col' => 'التاريخ',
        'method_col' => 'طريقة الدفع',
        'assignments_title' => 'الواجبات والامتحانات',
        'assignment_details' => 'تفاصيل الواجب',
        'exam_date' => 'موعد الامتحان',
        'teacher_col' => 'المعلم',
        'notes_col' => 'ملاحظات',
        'no_assignments' => 'لا يوجد واجبات أو امتحانات حالياً',
        'currency' => 'د.أ',
        'no_notes' => 'لا توجد ملاحظات',
        'footer_desc' => 'بوابتك لتعلم اللغة العربية الناطقين بغيرها بأعلى معايير الجودة الأكاديمية.',
        'contact_us' => 'تواصل معنا',
        'msg_no_courses' => 'لم يتم تسجيل أي كورسات بعد.',
        'msg_remaining' => 'لديك مبلغ متبقي: {amount} د.أ. يرجى دفعه في أقرب وقت.',
        'msg_cleared' => 'لقد قمت بدفع جميع المبالغ. شكراً لك!',
        'toast_success' => 'تم تقييم الدورة بـ {val} نجوم',
        'toast_error' => 'فشل حفظ التقييم',
        'schedule_title' => 'الجدول الدراسي الأسبوعي',
        'attendance_title' => 'سجل الحضور والغياب',
        'day_col' => 'اليوم',
       'time_col' => 'وقت البدء',
        'end_time_col' => 'وقت النهاية',
        'status_col' => 'الحالة',
        'no_attendance' => 'لا يوجد سجلات حضور حالياً',
        'no_schedule' => 'لا يوجد جدول دراسي مسجل حالياً',
        'no_courses' => 'لم تقم بالتسجيل في أي دورة تعليمية بعد',
        'no_payments' => 'لا يوجد دفعات مالية مسجلة حالياً',
        'present' => 'حضور',
        'absent' => 'غياب',
        'excused' => 'استئذان',
        'late' => 'تأخير',
        'in_person' => 'وجاهي',
        'distance' => 'تعلم عن بعد',
        'cash' => 'نقداً',
'نقداً' => 'نقداً',
'card' => 'فيزا',
'فيزا' => 'فيزا',
'cliq' => 'كليك',
'كليك' => 'كليك',
'bank_transfer' => 'تحويل بنكي',
'تحويل بنكي' => 'تحويل بنكي',
        'paid' => 'مدفوع',
        'unpaid' => 'غير مدفوع',
        'balance_due' => 'يوجد متبقي',
		'paid' => 'مدفوع',

'unpaid' => 'غير مدفوع',
        'partially_paid' => 'مدفوع جزئياً'
		
    ],
    'en' => [
        'dir' => 'ltr',
		
        'font' => "'Segoe UI', sans-serif",
        'title' => 'Student Dashboard | Lughat AlArab Institute',
        'portal' => 'Student Portal',
        'inst_name' => 'Lughat AlArab Institute',
		'no_notes' => 'No notes',
        'badge' => 'Distinguished Student',
        'logout' => 'logout',
        'welcome' => 'Welcome, Mr.',
		 'attendance_present' => 'Present',
        'attendance_absent' => 'Absent',
        'attendance_excused' => 'Excused',
		'paid' => 'Paid',

'unpaid' => 'Unpaid',
        'attendance_late' => 'Late',
        'hero_desc' => 'At Lughat AlArab Institute, we are pleased to track your academic progress. Here you can view your educational path and manage your financial affairs easily.',
        'today' => 'Today',
        'total_fees' => 'Total Fees',
        'paid_amount' => 'Paid Amount',
        'discounts' => 'Discounts',
        'remaining' => 'Remaining',
        'registered_courses' => 'Registered Courses',
        'course_col' => 'Course Name',
        'fees_col' => 'Fees',
        'system_col' => 'System',
        'rating_col' => 'Rating',
        'news_title' => 'Institute News',
        'no_news' => 'No Announcements',
        'payments_log' => 'Financial Payments Log',
        'amount_col' => 'Amount',
        'discount_col' => 'Discount',
        'date_col' => 'Date',
        'method_col' => 'Method',
        'assignments_title' => 'Assignments & Exams',
        'assignment_details' => 'Assignment Details',
        'exam_date' => 'Exam Date',
        'teacher_col' => 'Teacher',
        'notes_col' => 'Notes',
        'no_assignments' => 'No assignments or exams available',
        'currency' => 'JOD',
        'no_notes' => 'No notes',
        'footer_desc' => 'Your gateway to learning Arabic for non-native speakers with the highest academic quality standards.',
        'contact_us' => 'Contact Us',
        'msg_no_courses' => 'No courses registered yet.',
        'msg_remaining' => 'You have a remaining balance: {amount} JOD. Please pay soon.',
        'msg_cleared' => 'All payments cleared. Thank you!',
        'toast_success' => 'Course rated {val} stars',
        'toast_error' => 'Rating failed',
        'schedule_title' => 'Weekly Schedule',
        'attendance_title' => 'Attendance Log',
        'day_col' => 'Day',
        'time_col' => 'Start Time',
    'end_time_col' => 'End Time',
        'status_col' => 'Status',
		'مدفوع' => 'Paid',
    'paid' => 'Paid',
    'no_notes' => 'No notes',
        'no_attendance' => 'No attendance records found',
        'no_schedule' => 'No schedule available at the moment',
        'no_courses' => 'You have not registered for any courses yet',
        'no_payments' => 'No financial payments recorded yet',
        'present' => 'Present',
        'absent' => 'Absent',
        'excused' => 'Excused',
        'late' => 'Late',
        'in_person' => 'In-Person',
        'distance' => 'Distance Learning',
       'cash' => 'Cash',
'نقداً' => 'Cash',
'card' => 'Visa Card',
'فيزا' => 'Visa Card',
'cliq' => 'CliQ',
'كليك' => 'CliQ',
'bank_transfer' => 'Bank Transfer',
'تحويل بنكي' => 'Bank Transfer',
        'paid' => 'Paid',
        'unpaid' => 'Unpaid',
        'balance_due' => 'Balance Due',
        'partially_paid' => 'Partially Paid'
    ],
    'tr' => [
        'dir' => 'ltr',
        'font' => "'Segoe UI', sans-serif",
        'title' => 'Öğrenci Paneli | Lughat AlArab Institute',
        'portal' => 'Öğrenci Portalı',
        'inst_name' => 'Lughat AlArab Institute',
        'badge' => 'Seçkin Öğrenci',
        'logout' => 'Çıkış Yap',
        'welcome' => 'Hoş geldiniz, Sn.',
		'attendance_present' => 'Burada',
        'attendance_absent' => 'Yok',
        'attendance_excused' => 'İzinli',
        'attendance_late' => 'Gecikti',
        'hero_desc' => 'Lughat AlArab Institute\'nde akademik gelişiminizi takip etmekten mutluluk duyuyoruz.',
        'today' => 'Bugün',
        'total_fees' => 'Toplam Ücret',
        'paid_amount' => 'Ödenen Tutar',
        'discounts' => 'İndirimler',
        'remaining' => 'Kalan Bakiye',
        'registered_courses' => 'Kayıtlı Kurslar',
        'course_col' => 'Kurs Adı',
        'fees_col' => 'Ücret',
        'system_col' => 'Sistem',
        'rating_col' => 'Değerlendirme',
        'news_title' => 'Enstitü Haberleri',
        'no_news' => 'Duyuru bulunmamaktadır',
        'payments_log' => 'Ödeme Kayıtları',
        'amount_col' => 'Tutar',
        'discount_col' => 'İndirim',
        'date_col' => 'Tarih',
        'method_col' => 'Ödeme Yöntemi',
        'assignments_title' => 'Ödevler ve Sınavlar',
        'assignment_details' => 'Ödev Detayları',
        'exam_date' => 'Sınav Tarihi',
        'teacher_col' => 'Öğretmen',
        'notes_col' => 'Notlar',
        'no_assignments' => 'Henüz ödev veya sınav bulunmamaktadır',
		'no_notes' => 'Not bulunamadı',
        'currency' => 'JOD',
        'no_notes' => 'Not bulunamadı',
        'footer_desc' => 'Anadili Arapça olmayanlar için akademik kalite standartlarında Arapça öğrenme kapınız.',
        'contact_us' => 'Bize Ulaşın',
        'msg_no_courses' => 'Henüz kayıtlı kurs bulunmamaktadır.',
        'msg_remaining' => 'Kalan bakiyeniz: {amount} JOD.',
        'msg_cleared' => 'Tüm ödemeler tamamlandı. Teşekkürler!',
        'toast_success' => 'Kurs {val} yıldızla değerlendirildi',
        'toast_error' => 'Değerlendirme başarısız',
        'schedule_title' => 'Haftalık Ders Programı',
        'attendance_title' => 'Yoklama Kaydı',
        'day_col' => 'Gün',
 'time_col' => 'Başlama Saati',
    'end_time_col' => 'Bitiş Saati',
        'status_col' => 'Durum',
		'paid' => 'Ödendi',

'unpaid' => 'Ödenmedi',
'مدفوع' => 'Ödendi', 
    'paid' => 'Ödendi',
    'no_notes' => 'Not bulunamadı',
        'no_attendance' => 'Henüz yoklama kaydı bulunmamaktadır',
        'no_schedule' => 'Şu an kayıtlı ders programı bulunmamaktadır',
        'no_courses' => 'Henüz herhangi bir kursa kayıt yaptırmadınız',
        'no_payments' => 'Henüz kayıtlı bir ödeme bulunmamaktadır',
        'present' => 'Burada',
        'absent' => 'Yok',
        'excused' => 'İzinli',
        'late' => 'Gecikti',
        'in_person' => 'Yüz Yüze',
        'distance' => 'Uzaktan Öğrenme',
       'cash' => 'Nakit',
'نقداً' => 'Nakit',
'card' => 'Kredi Kartı',
'فيزا' => 'Kredi Kartı',
'cliq' => 'CliQ',
'كليك' => 'CliQ',
'bank_transfer' => 'Banka Havalesi',
'تحويل بنكي' => 'Banka Havalesi',
        'paid' => 'Ödendi',
        'unpaid' => 'Ödenmedi',
        'balance_due' => 'Bakiye Var',
        'partially_paid' => 'Kısmen Ödendi'
    ]
];
$t = $translations[$lang];

// أضف هذه الدالة هنا لتعمل داخل الملف
function __($key) {
    global $t;
    // إذا وجد المفتاح في المصفوفة يرجعه، وإلا يرجع المفتاح نفسه
    return isset($t[$key]) ? $t[$key] : $key;
}

$t = $translations[$lang];
$student_id = $_SESSION['student_id'];

// تسجيل الخروج
if (isset($_GET['logout'])) {
    session_destroy();
    header('Location: login.php');
    exit;
}

// بيانات الطالب
$stmt = $conn->prepare("SELECT * FROM students WHERE id = ?");
$stmt->execute([$student_id]);
$student = $stmt->fetch(PDO::FETCH_ASSOC);

// الإعلانات المرئية
$stmt = $conn->prepare("SELECT * FROM announcements WHERE visible = 1 ORDER BY created_at DESC LIMIT 3");
$stmt->execute();
$announcements = $stmt->fetchAll(PDO::FETCH_ASSOC);

// الكورسات المسجلة
$stmt = $conn->prepare("
    SELECT e.id as enrollment_id, c.id as course_id, c.course_name, c.price, 
           e.enrollment_date, e.attendance_type
    FROM enrollments e
    JOIN courses c ON c.id = e.course_id
    WHERE e.student_id = ?
    ORDER BY e.enrollment_date DESC
");
$stmt->execute([$student_id]);
$enrollments = $stmt->fetchAll(PDO::FETCH_ASSOC);

// الواجبات والامتحانات
$stmt_ass = $conn->prepare("
    SELECT a.*, c.course_name, t.name as teacher_name
    FROM assignments a
    JOIN courses c ON a.course_id = c.id
    LEFT JOIN teachers t ON a.teacher_id = t.id
    WHERE a.student_id = ?
    ORDER BY a.exam_date DESC
");
$stmt_ass->execute([$student_id]);
$assignments = $stmt_ass->fetchAll(PDO::FETCH_ASSOC);

// الجدول الدراسي
$stmt_sch = $conn->prepare("
    SELECT s.*, c.course_name 
    FROM student_schedules s
    JOIN courses c ON s.course_id = c.id
    WHERE s.student_id = ?
    ORDER BY FIELD(day_name, 'Saturday', 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday'), 
             start_time
");
$stmt_sch->execute([$student_id]);
$schedules = $stmt_sch->fetchAll(PDO::FETCH_ASSOC);

// سجل الحضور والغياب
$stmt_att = $conn->prepare("
    SELECT a.*, c.course_name 
    FROM attendance a
    JOIN courses c ON a.course_id = c.id
    WHERE a.student_id = ?
    ORDER BY attendance_date DESC
    LIMIT 10
");
$stmt_att->execute([$student_id]);
$attendance_records = $stmt_att->fetchAll(PDO::FETCH_ASSOC);

// الدفعات
$stmt = $conn->prepare("
    SELECT amount_paid, discount, payment_date, payment_method, notes 
    FROM payments 
    WHERE student_id = ? 
    ORDER BY payment_date DESC
    LIMIT 10
");
$stmt->execute([$student_id]);
$payments = $stmt->fetchAll(PDO::FETCH_ASSOC);

// حساب المبالغ
$total_paid_all = !empty($payments) ? array_sum(array_column($payments, 'amount_paid')) : 0;
$total_discount_all = !empty($payments) ? array_sum(array_column($payments, 'discount')) : 0;
$total_courses = !empty($enrollments) ? array_sum(array_column($enrollments, 'price')) : 0;
$remaining_all = $total_courses - ($total_paid_all + $total_discount_all);

// إشعار الدفع
$notification = "";
$notificationType = "";
if ($total_courses == 0) {
    $notification = $t['msg_no_courses'];
    $notificationType = 'info';
} elseif ($remaining_all > 0) {
    $notification = str_replace('{amount}', number_format($remaining_all, 2), $t['msg_remaining']);
    $notificationType = 'warning';
} else {
    $notification = $t['msg_cleared'];
    $notificationType = 'success';
}

// أيام الأسبوع مترجمة
$week_days = [
    'ar' => [
        'Saturday' => 'السبت', 'Sunday' => 'الأحد', 'Monday' => 'الإثنين',
        'Tuesday' => 'الثلاثاء', 'Wednesday' => 'الأربعاء', 
        'Thursday' => 'الخميس', 'Friday' => 'الجمعة'
    ],
    'en' => [
        'Saturday' => 'Saturday', 'Sunday' => 'Sunday', 'Monday' => 'Monday',
        'Tuesday' => 'Tuesday', 'Wednesday' => 'Wednesday',
        'Thursday' => 'Thursday', 'Friday' => 'Friday'
    ],
    'tr' => [
        'Saturday' => 'Cumartesi', 'Sunday' => 'Pazar', 'Monday' => 'Pazartesi',
        'Tuesday' => 'Salı', 'Wednesday' => 'Çarşamba',
        'Thursday' => 'Perşembe', 'Friday' => 'Cuma'
    ]
];
?>
<!DOCTYPE html>
<html lang="<?= $lang ?>" dir="<?= $t['dir'] ?>">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?= $t['title'] ?></title>
    <script src="https://cdn.tailwindcss.com"></script>
    <link href="https://fonts.googleapis.com/css2?family=Cairo:wght@300;400;500;600;700;800;900&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        :root {
            --gold: #c5a059;
            --dark: #1a1a1a;
            --light-beige: #f8f5ee;
            --beige: #e8e4d9;
            --white: #ffffff;
            --success: #10b981;
            --warning: #f59e0b;
            --danger: #ef4444;
            --info: #3b82f6;
        }

        body {
            font-family: <?= $t['font'] ?>;
            background: linear-gradient(135deg, #f8f5ee 0%, #e8e4d9 100%);
            min-height: 100vh;
            direction: <?= $t['dir'] ?>;
            position: relative;
            overflow-x: hidden;
        }

        body::before {
            content: '';
            position: fixed;
            top: 0;
            <?= $t['dir'] == 'rtl' ? 'right: 0' : 'left: 0' ?>;
            width: 100%;
            height: 100%;
            background-image: url('../assets/pngegg2.jpg');
            background-size: cover;
            background-position: center;
            background-attachment: fixed;
            opacity: 0.05;
            z-index: -1;
            pointer-events: none;
        }

        /* Header Styling */
        .main-header {
            background: linear-gradient(135deg, rgba(26, 26, 26, 0.98) 0%, rgba(40, 40, 40, 0.98) 100%);
            backdrop-filter: blur(10px);
            border-bottom: 3px solid var(--gold);
            box-shadow: 0 4px 20px rgba(0, 0, 0, 0.15);
        }

        /* Hero Section */
        .hero-section {
            background: linear-gradient(135deg, rgba(26, 26, 26, 0.95) 0%, rgba(40, 40, 40, 0.95) 100%);
            border-radius: 24px;
            border-<?= $t['dir'] == 'rtl' ? 'right' : 'left' ?>: 6px solid var(--gold);
            position: relative;
            overflow: hidden;
            box-shadow: 0 10px 30px rgba(0, 0, 0, 0.15);
        }

        .hero-section::before {
            content: '';
            position: absolute;
            top: 0;
            <?= $t['dir'] == 'rtl' ? 'right: 0' : 'left: 0' ?>;
            width: 100%;
            height: 100%;
            background: linear-gradient(45deg, transparent 30%, rgba(197, 160, 89, 0.1) 100%);
            pointer-events: none;
        }

        /* Cards */
        .stat-card {
            background: var(--white);
            border-radius: 20px;
            border: 1px solid rgba(197, 160, 89, 0.2);
            transition: all 0.3s ease;
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.05);
            position: relative;
            overflow: hidden;
        }

        .stat-card::before {
            content: '';
            position: absolute;
            top: 0;
            <?= $t['dir'] == 'rtl' ? 'right: 0' : 'left: 0' ?>;
            width: 4px;
            height: 100%;
            background: var(--gold);
        }

        .stat-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 15px 30px rgba(0, 0, 0, 0.1);
            border-color: rgba(197, 160, 89, 0.4);
        }

        .card {
            background: var(--white);
            border-radius: 20px;
            border: 1px solid rgba(197, 160, 89, 0.15);
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.04);
            transition: all 0.3s ease;
        }

        .card:hover {
            box-shadow: 0 8px 24px rgba(0, 0, 0, 0.08);
        }

        /* Tables */
        .table-container {
            background: var(--white);
            border-radius: 20px;
            overflow: hidden;
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.04);
        }

        .custom-table {
            width: 100%;
            border-collapse: separate;
            border-spacing: 0;
        }

        .custom-table thead {
            background: linear-gradient(135deg, var(--dark) 0%, #2a2a2a 100%);
        }

        .custom-table th {
            color: var(--gold);
            font-weight: 700;
            padding: 16px 20px;
            text-align: <?= $t['dir'] == 'rtl' ? 'right' : 'left' ?>;
            border-bottom: 2px solid rgba(197, 160, 89, 0.3);
        }

        .custom-table tr {
            border-bottom: 1px solid rgba(197, 160, 89, 0.1);
            transition: background-color 0.2s ease;
        }

        .custom-table tr:hover {
            background-color: rgba(197, 160, 89, 0.05);
        }

        .custom-table td {
            padding: 16px 20px;
            text-align: <?= $t['dir'] == 'rtl' ? 'right' : 'left' ?>;
        }

        /* Badges */
        .status-badge {
            display: inline-flex;
            align-items: center;
            padding: 6px 12px;
            border-radius: 50px;
            font-size: 12px;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.5px;
        }

        .status-present { background: #dcfce7; color: #166534; }
        .status-absent { background: #fee2e2; color: #991b1b; }
        .status-excused { background: #fef9c3; color: #854d0e; }
        .status-late { background: #ffedd5; color: #9a3412; }

        /* Buttons */
        .btn-primary {
            background: linear-gradient(135deg, var(--gold) 0%, #d4b57d 100%);
            color: white;
            border: none;
            border-radius: 12px;
            padding: 10px 24px;
            font-weight: 600;
            transition: all 0.3s ease;
            box-shadow: 0 4px 12px rgba(197, 160, 89, 0.3);
        }

        .btn-primary:hover {
            transform: translateY(-2px);
            box-shadow: 0 6px 20px rgba(197, 160, 89, 0.4);
        }

        .btn-outline {
            border: 2px solid var(--gold);
            color: var(--gold);
            background: transparent;
            border-radius: 12px;
            padding: 10px 24px;
            font-weight: 600;
            transition: all 0.3s ease;
        }

        .btn-outline:hover {
            background: var(--gold);
            color: white;
        }

        /* Responsive */
        @media (max-width: 768px) {
            .custom-table thead {
                display: none;
            }
            
            .custom-table tr {
                display: block;
                margin-bottom: 16px;
                border-radius: 16px;
                background: var(--white);
                box-shadow: 0 4px 8px rgba(0, 0, 0, 0.05);
            }
            
            .custom-table td {
                display: flex;
                justify-content: space-between;
                align-items: center;
                padding: 12px 16px;
                border-bottom: 1px solid rgba(197, 160, 89, 0.1);
            }
            
            .custom-table td:last-child {
                border-bottom: none;
            }
            
            .custom-table td::before {
                content: attr(data-label);
                font-weight: 700;
                color: var(--dark);
                opacity: 0.7;
                margin-<?= $t['dir'] == 'rtl' ? 'left' : 'right' ?>: 12px;
            }
        }

        /* Star Rating */
        .star-rating .star {
            color: #e5e7eb;
            cursor: pointer;
            transition: all 0.2s ease;
            font-size: 20px;
        }

        .star-rating .star.active,
        .star-rating .star:hover {
            color: var(--gold);
            transform: scale(1.1);
        }

        /* Footer */
        .main-footer {
            background: linear-gradient(135deg, var(--dark) 0%, #2a2a2a 100%);
            border-top: 4px solid var(--gold);
            position: relative;
            overflow: hidden;
        }

        .main-footer::before {
            content: '';
            position: absolute;
            top: 0;
            <?= $t['dir'] == 'rtl' ? 'right: 0' : 'left: 0' ?>;
            width: 100%;
            height: 100%;
            background: linear-gradient(45deg, transparent 40%, rgba(197, 160, 89, 0.1) 100%);
            pointer-events: none;
        }

        /* Section Headers */
        .section-header {
            position: relative;
            padding-<?= $t['dir'] == 'rtl' ? 'right' : 'left' ?>: 16px;
            margin-bottom: 24px;
        }

        .section-header::before {
            content: '';
            position: absolute;
            top: 0;
            <?= $t['dir'] == 'rtl' ? 'right: 0' : 'left: 0' ?>;
            width: 4px;
            height: 100%;
            background: var(--gold);
            border-radius: 2px;
        }

        /* Loading Animation */
        @keyframes pulse {
            0%, 100% { opacity: 1; }
            50% { opacity: 0.5; }
        }

        .loading {
            animation: pulse 2s cubic-bezier(0.4, 0, 0.6, 1) infinite;
        }
    </style>
</head>
<body class="min-h-screen flex flex-col">

<!-- Header -->
<header class="main-header sticky top-0 z-50">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
        <div class="flex justify-between items-center h-20">
            <!-- Logo -->
            <div class="flex items-center space-x-3 rtl:space-x-reverse">
                <div class="bg-white p-2 rounded-xl shadow-md">
                    <img src="../assets/logo.png" alt="Logo" class="h-10 w-auto">
                </div>
                <div>
                    <h1 class="text-xl font-black text-white"><?= $t['inst_name'] ?></h1>
                    <p class="text-xs text-amber-300 font-semibold tracking-wider"><?= $t['portal'] ?></p>
                </div>
            </div>

            <!-- User Info & Controls -->
            <div class="flex items-center space-x-4 rtl:space-x-reverse">
                <!-- Student Info -->
                <div class="hidden md:block text-<?= $t['dir'] == 'rtl' ? 'right' : 'left' ?>">
                    <p class="text-sm font-bold text-white"><?= htmlspecialchars($student['full_name']) ?></p>
                    <span class="inline-flex items-center px-2.5 py-0.5 rounded-full text-xs font-medium bg-amber-100 text-amber-800">
                        <i class="fas fa-award mr-1 rtl:ml-1 rtl:mr-0"></i>
                        <?= $t['badge'] ?>
                    </span>
                </div>

                <!-- Language Selector -->
                <div class="relative">
                    <button class="btn-outline flex items-center space-x-2 rtl:space-x-reverse py-2 px-3">
                        <i class="fas fa-globe"></i>
                        <span class="hidden lg:inline"><?= strtoupper($lang) ?></span>
                    </button>
                    <div class="absolute top-full mt-2 <?= $t['dir'] == 'rtl' ? 'right-0' : 'left-0' ?> w-32 bg-white rounded-xl shadow-xl border border-gray-200 opacity-0 invisible group-hover:opacity-100 group-hover:visible transition-all duration-200 z-10">
                        <a href="?set_lang=ar" class="block px-4 py-3 text-gray-700 hover:bg-gray-50 border-b border-gray-100 text-sm font-medium <?= $lang == 'ar' ? 'text-amber-600 bg-amber-50' : '' ?>">العربية</a>
                        <a href="?set_lang=en" class="block px-4 py-3 text-gray-700 hover:bg-gray-50 border-b border-gray-100 text-sm font-medium <?= $lang == 'en' ? 'text-amber-600 bg-amber-50' : '' ?>">English</a>
                        <a href="?set_lang=tr" class="block px-4 py-3 text-gray-700 hover:bg-gray-50 text-sm font-medium <?= $lang == 'tr' ? 'text-amber-600 bg-amber-50' : '' ?>">Türkçe</a>
                    </div>
                </div>

                <!-- Logout -->
                <a href="?logout=1" class="btn-primary flex items-center space-x-2 rtl:space-x-reverse py-2 px-4">
                    <i class="fas fa-sign-out-alt"></i>
                    <span class="hidden sm:inline"><?= $t['logout'] ?></span>
                </a>
            </div>
        </div>
    </div>
</header>

<!-- Main Content -->
<main class="flex-grow">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-8">
        <!-- Welcome Section -->
        <section class="hero-section p-6 md:p-8 mb-8">
            <div class="flex flex-col md:flex-row justify-between items-start md:items-center gap-6">
                <div class="flex-1">
                    <h1 class="text-3xl md:text-4xl font-black text-white mb-3">
                        <?= $t['welcome'] ?> 
                        <span class="text-amber-300"><?= explode(' ', $student['full_name'])[0] ?></span>
                        <i class="fas fa-sparkles text-amber-300 ml-2 rtl:mr-2 rtl:ml-0"></i>
                    </h1>
                    <p class="text-gray-300 text-sm md:text-base leading-relaxed max-w-3xl">
                        <?= $t['hero_desc'] ?>
                    </p>
                </div>
                <div class="bg-white/10 backdrop-blur-sm border border-white/20 rounded-2xl p-4 min-w-[140px] text-center">
                    <p class="text-amber-300 text-xs font-bold uppercase tracking-wider mb-1"><?= $t['today'] ?></p>
                    <p class="text-2xl font-black text-white"><?= date('d M, Y') ?></p>
                </div>
            </div>
        </section>

        <!-- Notification -->
        <?php if($notification): ?>
        <div class="mb-8">
            <div class="p-4 rounded-2xl border-<?= $t['dir'] == 'rtl' ? 'r' : 'l' ?>-4 border-<?= 
                $notificationType == 'success' ? 'green' : 
                ($notificationType == 'warning' ? 'amber' : 'blue') ?>-500 
                bg-<?= $notificationType == 'success' ? 'green' : 
                ($notificationType == 'warning' ? 'amber' : 'blue') ?>-50 
                flex items-start gap-4">
                <div class="flex-shrink-0">
                    <div class="w-10 h-10 rounded-full bg-white flex items-center justify-center shadow-sm">
                        <i class="fas fa-<?= 
                            $notificationType == 'success' ? 'check-circle text-green-500' : 
                            ($notificationType == 'warning' ? 'exclamation-triangle text-amber-500' : 'info-circle text-blue-500') ?> 
                            text-lg"></i>
                    </div>
                </div>
                <div class="flex-1">
                    <p class="font-bold text-gray-800"><?= $notification ?></p>
                </div>
            </div>
        </div>
        <?php endif; ?>

        <!-- Stats Cards -->
        <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-4 gap-6 mb-8">
            <div class="stat-card p-6">
                <div class="flex items-center justify-between mb-4">
                    <div class="w-12 h-12 bg-gray-100 rounded-xl flex items-center justify-center">
                        <i class="fas fa-book-open text-2xl text-gray-600"></i>
                    </div>
                    <span class="text-2xl font-black text-gray-800"><?= number_format($total_courses, 2) ?></span>
                </div>
                <p class="text-sm text-gray-500 font-medium"><?= $t['total_fees'] ?></p>
                <p class="text-xs text-gray-400 mt-1"><?= $t['currency'] ?></p>
            </div>

            <div class="stat-card p-6">
                <div class="flex items-center justify-between mb-4">
                    <div class="w-12 h-12 bg-green-50 rounded-xl flex items-center justify-center">
                        <i class="fas fa-check-double text-2xl text-green-600"></i>
                    </div>
                    <span class="text-2xl font-black text-green-600"><?= number_format($total_paid_all, 2) ?></span>
                </div>
                <p class="text-sm text-gray-500 font-medium"><?= $t['paid_amount'] ?></p>
                <p class="text-xs text-gray-400 mt-1"><?= $t['currency'] ?></p>
            </div>

            <div class="stat-card p-6">
                <div class="flex items-center justify-between mb-4">
                    <div class="w-12 h-12 bg-red-50 rounded-xl flex items-center justify-center">
                        <i class="fas fa-wallet text-2xl text-red-600"></i>
                    </div>
                    <span class="text-2xl font-black text-red-600"><?= number_format($remaining_all, 2) ?></span>
                </div>
                <p class="text-sm text-gray-500 font-medium"><?= $t['remaining'] ?></p>
                <p class="text-xs text-gray-400 mt-1"><?= $t['currency'] ?></p>
            </div>

            <div class="stat-card p-6">
                <div class="flex items-center justify-between mb-4">
                    <div class="w-12 h-12 bg-purple-50 rounded-xl flex items-center justify-center">
                        <i class="fas fa-tasks text-2xl text-purple-600"></i>
                    </div>
                    <span class="text-2xl font-black text-purple-600"><?= count($assignments) ?></span>
                </div>
                <p class="text-sm text-gray-500 font-medium"><?= $t['assignments_title'] ?></p>
                <p class="text-xs text-gray-400 mt-1"><?= $lang == 'ar' ? 'المهام' : 'Tasks' ?></p>
            </div>
        </div>

        <!-- Main Grid -->
        <div class="grid grid-cols-1 lg:grid-cols-3 gap-8 mb-8">
            <!-- Left Column - Schedule & Attendance -->
            <div class="lg:col-span-2 space-y-8">
                <!-- Schedule -->
                <div class="card p-6">
    <div class="section-header mb-6">
        <h2 class="text-xl font-black text-gray-800"><?= $t['schedule_title'] ?></h2>
    </div>
    <div class="table-container">
        <table class="custom-table">
            <thead>
                <tr>
                    <th><?= $t['day_col'] ?></th>
                    <th><?= $t['course_col'] ?></th>
                    <th><?= $t['time_col'] ?></th>
                    <th><?= $t['end_time_col'] ?></th>
                </tr>
            </thead>
            <tbody>
                <?php if(!empty($schedules)): ?>
                    <?php foreach($schedules as $sch): ?>
                    <tr>
                        <td data-label="<?= $t['day_col'] ?>">
                            <span class="font-bold text-amber-600">
                                <?= $week_days[$lang][$sch['day_name']] ?>
                            </span>
                        </td>
                        <td data-label="<?= $t['course_col'] ?>">
                            <?= htmlspecialchars($sch['course_name']) ?>
                        </td>
                        <td data-label="<?= $t['time_col'] ?>">
                            <span class="inline-flex items-center px-3 py-1 rounded-full text-sm font-medium bg-gray-100 text-gray-800">
                                <i class="fas fa-play mr-2 rtl:ml-2 rtl:mr-0 text-xs"></i>
                                <?php 
                                    $start_time = date('h:i A', strtotime($sch['start_time']));
                                    if ($lang == 'ar') {
                                        $start_time = str_replace(['AM', 'PM'], ['ص', 'م'], $start_time);
                                    }
                                    echo $start_time;
                                ?>
                            </span>
                        </td>
                        <td data-label="<?= $t['end_time_col'] ?>">
                            <?php if(!empty($sch['end_time'])): ?>
                                <span class="inline-flex items-center px-3 py-1 rounded-full text-sm font-medium bg-blue-100 text-blue-800">
                                    <i class="fas fa-stop mr-2 rtl:ml-2 rtl:mr-0 text-xs"></i>
                                    <?php 
                                        $end_time = date('h:i A', strtotime($sch['end_time']));
                                        if ($lang == 'ar') {
                                            $end_time = str_replace(['AM', 'PM'], ['ص', 'م'], $end_time);
                                        }
                                        echo $end_time;
                                    ?>
                                </span>
                            <?php else: ?>
                                <span class="text-gray-400 text-sm italic">
                                    -
                                </span>
                            <?php endif; ?>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                <?php else: ?>
                    <tr>
                        <td colspan="4" class="text-center py-8">
                            <div class="flex flex-col items-center justify-center">
                                <i class="fas fa-calendar-times text-4xl text-gray-300 mb-3"></i>
                                <p class="text-gray-500 font-medium"><?= $t['no_schedule'] ?></p>
                            </div>
                        </td>
                    </tr>
                <?php endif; ?>
            </tbody>
        </table>
    </div>
</div>

                <!-- Attendance -->
                <div class="card p-6">
                    <div class="section-header mb-6">
                        <h2 class="text-xl font-black text-gray-800"><?= $t['attendance_title'] ?></h2>
                    </div>
                    <div class="table-container">
                        <table class="custom-table">
                            <thead>
                                <tr>
                                    <th><?= $t['date_col'] ?></th>
                                    <th><?= $t['course_col'] ?></th>
                                    <th><?= $t['status_col'] ?></th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php if(!empty($attendance_records)): ?>
                                    <?php foreach($attendance_records as $att): 
                                        $status_class = '';
                                        switch($att['status']) {
                                            case 'حضور': $status_class = 'status-present'; break;
                                            case 'غياب': $status_class = 'status-absent'; break;
                                            case 'استئذان': $status_class = 'status-excused'; break;
                                            case 'تأخير': $status_class = 'status-late'; break;
                                            default: $status_class = 'bg-gray-100 text-gray-800';
                                        }
                                    ?>
                                    <tr>
                                        <td data-label="<?= $t['date_col'] ?>">
                                            <?= date('d/m/Y', strtotime($att['attendance_date'])) ?>
                                        </td>
                                        <td data-label="<?= $t['course_col'] ?>">
                                            <?= htmlspecialchars($att['course_name']) ?>
                                        </td>
                                       <td data-label="<?= $t['status_col'] ?>">
    <span class="status-badge <?= $status_class ?>">
        <?php 
        // تحديد الأيقونة والنص
        $status_mapping = [
            'حضور' => ['key' => 'attendance_present', 'icon' => 'fas fa-check-circle'],
            'غياب' => ['key' => 'attendance_absent', 'icon' => 'fas fa-times-circle'],
            'استئذان' => ['key' => 'attendance_excused', 'icon' => 'fas fa-user-clock'],
            'تأخير' => ['key' => 'attendance_late', 'icon' => 'fas fa-clock']
        ];
        
        $current_status = $att['status'];
        if (isset($status_mapping[$current_status])) {
            $status_key = $status_mapping[$current_status]['key'];
            $status_icon = $status_mapping[$current_status]['icon'];
            $status_text = $t[$status_key];
        } else {
            $status_icon = 'fas fa-question-circle';
            $status_text = $current_status;
        }
        ?>
        
        <i class="<?= $status_icon ?> mr-2 rtl:ml-2 rtl:mr-0"></i>
        <?= $status_text ?>
    </span>
</td>
                                    </tr>
                                    <?php endforeach; ?>
                                <?php else: ?>
                                    <tr>
                                        <td colspan="3" class="text-center py-8">
                                            <div class="flex flex-col items-center justify-center">
                                                <i class="fas fa-clipboard-question text-4xl text-gray-300 mb-3"></i>
                                                <p class="text-gray-500 font-medium"><?= $t['no_attendance'] ?></p>
                                            </div>
                                        </td>
                                    </tr>
                                <?php endif; ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

            <!-- Right Column - Assignments & News -->
            <div class="space-y-8">
                <!-- Assignments -->
        <div class="card p-6">
    <div class="section-header mb-6">
        <h2 class="text-xl font-black text-gray-800"><?= $t['assignments_title'] ?></h2>
    </div>
    <div class="space-y-4">
        <?php if(!empty($assignments)): ?>
           <?php foreach($assignments as $ass): 
    // التحقق من وجود تاريخ الامتحان
    if (!empty($ass['exam_date']) && $ass['exam_date'] != '0000-00-00') {
        // حساب الأيام المتبقية بشكل صحيح
        $exam_timestamp = strtotime(date('Y-m-d', strtotime($ass['exam_date'])));
        $today_timestamp = strtotime(date('Y-m-d'));
        $days_left = round(($exam_timestamp - $today_timestamp) / (60 * 60 * 24));
        
        $date_class = '';
        $status_text = '';
        
        if($days_left < 0) {
            $date_class = 'bg-gray-100 text-gray-600';
            $status_text = $lang == 'ar' ? 'منتهي' : ($lang == 'tr' ? 'Tamamlandı' : 'Completed');
        } elseif($days_left == 0) {
            $date_class = 'bg-red-100 text-red-700';
            $status_text = $lang == 'ar' ? 'اليوم!' : ($lang == 'tr' ? 'Bugün!' : 'Today!');
        } elseif($days_left <= 3) {
            $date_class = 'bg-orange-100 text-orange-700';
            $status_text = $lang == 'ar' ? "بعد $days_left أيام" : 
                          ($lang == 'tr' ? "$days_left gün sonra" : "in $days_left days");
        } else {
            $date_class = 'bg-green-50 text-green-700';
            $status_text = $lang == 'ar' ? "بعد $days_left يوم" : 
                          ($lang == 'tr' ? "$days_left gün sonra" : "in $days_left days");
        }
        
        $date_display = date('d/m', strtotime($ass['exam_date']));
    } else {
        // إذا لم يكن هناك تاريخ امتحان
        $date_class = 'bg-gray-100 text-gray-500';
        $status_text = $lang == 'ar' ? 'غير محدد' : ($lang == 'tr' ? 'Belirtilmemiş' : 'Not specified');
        $date_display = $lang == 'ar' ? '--/--' : '--/--';
        $days_left = null;
    }
?>
            <div class="p-4 rounded-xl border border-gray-200 hover:border-purple-300 transition-colors hover:shadow-sm">
                <div class="flex items-start justify-between mb-2">
                    <div class="flex-1">
                        <div class="flex items-center mb-2">
                            <div class="w-8 h-8 bg-purple-50 rounded-lg flex items-center justify-center mr-3 rtl:ml-3 rtl:mr-0">
                                <i class="fas fa-book text-purple-600"></i>
                            </div>
                            <h4 class="font-bold text-gray-800"><?= htmlspecialchars($ass['course_name']) ?></h4>
                        </div>
                        
                        <div class="text-sm text-gray-600 mb-3 assignment-content">
                            <?php 
                            $details = htmlspecialchars($ass['assignment_details']);
                            $is_long = strlen($details) > 100;
                            ?>
                            
                            <?php if($is_long): ?>
                                <div class="assignment-text">
                                    <div class="short-text"><?= nl2br(substr($details, 0, 100)) ?>...</div>
                                    <div class="full-text hidden"><?= nl2br($details) ?></div>
                                    <button type="button" class="text-purple-600 hover:text-purple-800 text-xs font-medium mt-1 flex items-center show-more-btn">
                                        <i class="fas fa-chevron-down text-xs ml-1 rtl:mr-1 rtl:ml-0"></i>
                                        <span><?= $lang == 'ar' ? 'عرض المزيد' : ($lang == 'tr' ? 'Daha fazla göster' : 'Show more') ?></span>
                                    </button>
                                    <button type="button" class="text-purple-600 hover:text-purple-800 text-xs font-medium mt-1 hidden items-center show-less-btn">
                                        <i class="fas fa-chevron-up text-xs ml-1 rtl:mr-1 rtl:ml-0"></i>
                                        <span><?= $lang == 'ar' ? 'عرض أقل' : ($lang == 'tr' ? 'Daha az göster' : 'Show less') ?></span>
                                    </button>
                                </div>
                            <?php else: ?>
                                <div class="assignment-text"><?= nl2br($details) ?></div>
                            <?php endif; ?>
                        </div>
                        
                        <?php if(!empty($ass['teacher_name'])): ?>
                            <div class="flex items-center text-xs text-gray-500">
                                <i class="fas fa-user-graduate ml-1 rtl:mr-1 rtl:ml-0"></i>
                                <span class="font-medium mr-1 rtl:ml-1 rtl:mr-0"><?= $t['teacher_col'] ?>:</span>
                                <span><?= htmlspecialchars($ass['teacher_name']) ?></span>
                            </div>
                        <?php endif; ?>
                    </div>
                    
                    <div class="ml-4 rtl:mr-4 rtl:ml-0">
                        <div class="text-center">
                            <span class="inline-flex flex-col items-center px-3 py-2 rounded-xl <?= $date_class ?> mb-1">
                                <span class="font-bold text-lg"><?= date('d', strtotime($ass['exam_date'])) ?></span>
                                <span class="text-xs uppercase"><?= date('M', strtotime($ass['exam_date'])) ?></span>
                            </span>
                            <div class="text-xs text-gray-600 mt-1">
                                <div class="font-medium"><?= $t['exam_date'] ?></div>
                                <div class="text-xs <?= str_replace('bg-', 'text-', str_replace('100', '700', $date_class)) ?> mt-0.5">
                                    <?= $status_text ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                
                <?php if(!empty($ass['notes'])): ?>
                    <div class="mt-3 pt-3 border-t border-gray-100">
                        <div class="p-2 bg-amber-50 border border-amber-100 rounded-lg">
                            <p class="text-xs text-amber-800 flex items-start">
                                <i class="fas fa-sticky-note mt-0.5 ml-1 rtl:mr-1 rtl:ml-0"></i>
                                <span>
                                    <strong class="font-medium"><?= $t['notes_col'] ?>:</strong> 
                                    <?= htmlspecialchars($ass['notes']) ?>
                                </span>
                            </p>
                        </div>
                    </div>
                <?php endif; ?>
                
                <!-- معلومات إضافية -->
                <div class="mt-3 flex items-center justify-between text-xs text-gray-400">
                    <div class="flex items-center">
                        <i class="fas fa-calendar-plus ml-1 rtl:mr-1 rtl:ml-0"></i>
                        <span class="mr-1 rtl:ml-1 rtl:mr-0"><?= $lang == 'ar' ? 'تاريخ الإنشاء:' : ($lang == 'tr' ? 'Oluşturulma:' : 'Created:') ?></span>
                        <span class="font-medium"><?= date('d/m/Y', strtotime($ass['created_at'])) ?></span>
                    </div>
                    <?php if($days_left >= 0): ?>
                        <div class="flex items-center <?= 
                            $days_left == 0 ? 'text-red-500' : 
                            ($days_left <= 3 ? 'text-orange-500' : 'text-green-500') 
                        ?>">
                            <i class="fas fa-clock ml-1 rtl:mr-1 rtl:ml-0"></i>
                            <span class="font-medium">
                                <?= $days_left >= 0 ? $days_left : 0 ?>
                                <?= $lang == 'ar' ? ' يوم' : ($lang == 'tr' ? ' gün' : ' days') ?>
                            </span>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
            <?php endforeach; ?>
        <?php else: ?>
            <div class="text-center py-8">
                <div class="w-16 h-16 bg-gray-100 rounded-full flex items-center justify-center mx-auto mb-4">
                    <i class="fas fa-clipboard-check text-3xl text-gray-300"></i>
                </div>
                <h3 class="text-lg font-bold text-gray-700 mb-2"><?= $t['no_assignments'] ?></h3>
                <p class="text-gray-500 max-w-md mx-auto text-sm">
                    <?= $lang == 'ar' ? 'لا توجد واجبات أو امتحانات حالياً. سيتم إضافة المهام الجديدة هنا عند توفرها.' : 
                       ($lang == 'tr' ? 'Henüz ödev veya sınav bulunmamaktadır. Yeni görevler mevcut olduğunda burada eklenecektir.' : 
                       'No assignments or exams available. New tasks will be added here when available.') ?>
                </p>
            </div>
        <?php endif; ?>
    </div>
</div>

<script>
document.addEventListener('DOMContentLoaded', function() {
    // وظيفة عرض/إخفاء تفاصيل الواجب
    document.querySelectorAll('.show-more-btn').forEach(btn => {
        btn.addEventListener('click', function() {
            const container = this.closest('.assignment-text');
            const shortText = container.querySelector('.short-text');
            const fullText = container.querySelector('.full-text');
            const showMoreBtn = container.querySelector('.show-more-btn');
            const showLessBtn = container.querySelector('.show-less-btn');
            
            shortText.classList.add('hidden');
            fullText.classList.remove('hidden');
            showMoreBtn.classList.add('hidden');
            showLessBtn.classList.remove('hidden');
        });
    });
    
    document.querySelectorAll('.show-less-btn').forEach(btn => {
        btn.addEventListener('click', function() {
            const container = this.closest('.assignment-text');
            const shortText = container.querySelector('.short-text');
            const fullText = container.querySelector('.full-text');
            const showMoreBtn = container.querySelector('.show-more-btn');
            const showLessBtn = container.querySelector('.show-less-btn');
            
            fullText.classList.add('hidden');
            shortText.classList.remove('hidden');
            showMoreBtn.classList.remove('hidden');
            showLessBtn.classList.add('hidden');
        });
    });
    
    // تأثيرات hover للبطاقات
    const assignmentCards = document.querySelectorAll('.card .rounded-xl');
    assignmentCards.forEach(card => {
        card.addEventListener('mouseenter', function() {
            this.style.transform = 'translateY(-2px)';
        });
        
        card.addEventListener('mouseleave', function() {
            this.style.transform = 'translateY(0)';
        });
    });
});
</script>
                <!-- News -->
                <div class="card p-6">
                    <div class="section-header mb-6">
                        <h2 class="text-xl font-black text-gray-800"><?= $t['news_title'] ?></h2>
                    </div>
                    <div class="space-y-4">
                        <?php if(!empty($announcements)): ?>
                            <?php foreach($announcements as $ann): ?>
                            <div class="p-4 rounded-xl border border-gray-200 hover:border-amber-200 transition-colors">
                                <h4 class="font-bold text-gray-800 mb-2"><?= htmlspecialchars($ann['title']) ?></h4>
                                <p class="text-sm text-gray-600 mb-3"><?= nl2br(htmlspecialchars(substr($ann['message'], 0, 120))) ?>...</p>
                                <div class="flex items-center justify-between text-xs text-gray-500">
                                    <span>
                                        <i class="far fa-calendar-alt mr-1 rtl:ml-1 rtl:mr-0"></i>
                                        <?= date('d/m/Y', strtotime($ann['created_at'])) ?>
                                    </span>
                                    <i class="fas fa-bullhorn"></i>
                                </div>
                            </div>
                            <?php endforeach; ?>
                        <?php else: ?>
                            <div class="text-center py-8">
                                <i class="fas fa-inbox text-4xl text-gray-300 mb-3"></i>
                                <p class="text-gray-500 font-medium"><?= $t['no_news'] ?></p>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>

        <!-- Courses & Payments -->
        <div class="grid grid-cols-1 lg:grid-cols-2 gap-8 mb-8">
            <!-- Courses -->
            <div class="card p-6">
                <div class="section-header mb-6">
                    <h2 class="text-xl font-black text-gray-800"><?= $t['registered_courses'] ?></h2>
                </div>
                <div class="table-container">
                    <table class="custom-table">
                        <thead>
                            <tr>
                                <th><?= $t['course_col'] ?></th>
                                <th><?= $t['fees_col'] ?></th>
                                <th><?= $t['system_col'] ?></th>
                                <th><?= $t['rating_col'] ?></th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php if(!empty($enrollments)): ?>
                                <?php foreach($enrollments as $en): 
                                    $stmt2 = $conn->prepare("SELECT rating FROM course_ratings WHERE enrollment_id=? AND student_id=?");
                                    $stmt2->execute([$en['enrollment_id'], $student_id]);
                                    $existingRating = $stmt2->fetchColumn() ?: 0;
                                ?>
                                <tr>
                                    <td data-label="<?= $t['course_col'] ?>">
                                        <div class="flex items-center">
                                            <div class="w-10 h-10 bg-amber-50 rounded-lg flex items-center justify-center mr-3 rtl:ml-3 rtl:mr-0">
                                                <i class="fas fa-graduation-cap text-amber-600"></i>
                                            </div>
                                            <span class="font-medium"><?= htmlspecialchars($en['course_name']) ?></span>
                                        </div>
                                    </td>
                                    <td data-label="<?= $t['fees_col'] ?>">
                                        <span class="font-bold text-gray-800"><?= number_format($en['price'], 2) ?> <?= $t['currency'] ?></span>
                                    </td>
                                    <td data-label="<?= $t['system_col'] ?>">
                                        <span class="inline-flex items-center px-3 py-1 rounded-full text-xs font-medium bg-amber-50 text-amber-700 border border-amber-200">
                                            <?= $en['attendance_type'] == 'وجاهي' ? $t['in_person'] : $t['distance'] ?>
                                        </span>
                                    </td>
                                    <td data-label="<?= $t['rating_col'] ?>">
                                        <div class="star-rating flex items-center" data-enrollment="<?= $en['enrollment_id'] ?>">
                                            <?php for($i = 1; $i <= 5; $i++): ?>
                                                <i class="fas fa-star star <?= $existingRating >= $i ? 'active text-amber-500' : 'text-gray-300' ?>" 
                                                   data-value="<?= $i ?>"></i>
                                            <?php endfor; ?>
                                        </div>
                                    </td>
                                </tr>
                                <?php endforeach; ?>
                            <?php else: ?>
                                <tr>
                                    <td colspan="4" class="text-center py-8">
                                        <div class="flex flex-col items-center justify-center">
                                            <i class="fas fa-book-open text-4xl text-gray-300 mb-3"></i>
                                            <p class="text-gray-500 font-medium"><?= $t['no_courses'] ?></p>
                                        </div>
                                    </td>
                                </tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>

            <!-- Payments -->
            <div class="card p-6">
                <div class="section-header mb-6">
                    <h2 class="text-xl font-black text-gray-800"><?= $t['payments_log'] ?></h2>
                </div>
                <div class="table-container">
                    <table class="custom-table">
                        <thead>
                            <tr>
                                <th><?= $t['amount_col'] ?></th>
                                <th><?= $t['date_col'] ?></th>
                                <th><?= $t['method_col'] ?></th>
                                <th><?= $t['notes_col'] ?></th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php if(!empty($payments)): ?>
                                <?php foreach($payments as $p): ?>
                                <tr>
                                    <td data-label="<?= $t['amount_col'] ?>">
                                        <span class="font-bold text-green-600">
                                            <?= number_format($p['amount_paid'], 2) ?> <?= $t['currency'] ?>
                                        </span>
                                    </td>
                                    <td data-label="<?= $t['date_col'] ?>">
                                        <?= date('d/m/Y', strtotime($p['payment_date'])) ?>
                                    </td>
<td data-label="<?= $t['method_col'] ?>">
    <span class="inline-flex items-center px-3 py-1 rounded-full text-xs font-medium bg-amber-50 text-amber-700">
        <?= __($p['payment_method']) ?>
    </span>
</td>
                                   <td data-label="<?= $t['notes_col'] ?>">
    <span class="text-sm text-gray-600 italic">
        <?php 
            // جلب القيمة من قاعدة البيانات وتنظيفها من المسافات
            $db_value = trim($p['notes']); 

            // إذا كانت القيمة هي "مدفوع" بالعربي أو "paid" بالإنجليزي
            // سنقوم بالبحث عن الترجمة المقابلة لها في مصفوفة اللغة الحالية $t
            if (isset($t[$db_value])) {
                echo $t[$db_value];
            } else {
                // في حال لم تكن الكلمة "مدفوع" (أي ملاحظة نصية عادية)، اعرضها كما هي
                echo !empty($db_value) ? htmlspecialchars($db_value) : $t['no_notes'];
            }
        ?>
    </span>
</td>
                                </tr>
                                <?php endforeach; ?>
                            <?php else: ?>
                                <tr>
                                    <td colspan="4" class="text-center py-8">
                                        <div class="flex flex-col items-center justify-center">
                                            <i class="fas fa-receipt text-4xl text-gray-300 mb-3"></i>
                                            <p class="text-gray-500 font-medium"><?= $t['no_payments'] ?></p>
                                        </div>
                                    </td>
                                </tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</main>

<!-- Footer -->
<footer class="main-footer mt-auto">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-8 md:py-12">
        <div class="flex flex-col md:flex-row justify-between items-center gap-8">
            <!-- Logo & Description -->
            <div class="flex flex-col items-center md:items-start text-center md:text-<?= $t['dir'] == 'rtl' ? 'right' : 'left' ?>">
                <div class="bg-white p-2 rounded-xl shadow-lg mb-4">
                    <img src="../assets/cropped-logo.png" alt="Logo" class="h-12 md:h-16 w-auto">
                </div>
                <p class="text-gray-400 text-sm max-w-xs"><?= $t['footer_desc'] ?></p>
            </div>

            <!-- Social Media -->
            <div class="flex flex-col items-center">
                <h4 class="text-white font-bold text-sm uppercase tracking-widest mb-4"><?= $t['contact_us'] ?></h4>
                <div class="flex gap-4">
                    <a href="https://m.facebook.com/LughatAlArabInstitute/" target="_blank" 
                       class="w-12 h-12 bg-white/10 rounded-xl flex items-center justify-center hover:bg-amber-500 transition-colors group">
                        <i class="fab fa-facebook-f text-white text-lg group-hover:text-white"></i>
                    </a>
                    <a href="https://www.instagram.com/lughatalarabinstitute" target="_blank"
                       class="w-12 h-12 bg-white/10 rounded-xl flex items-center justify-center hover:bg-amber-500 transition-colors group">
                        <i class="fab fa-instagram text-white text-lg group-hover:text-white"></i>
                    </a>
                    <a href="https://wa.me/962775400430" target="_blank"
                       class="w-12 h-12 bg-white/10 rounded-xl flex items-center justify-center hover:bg-green-600 transition-colors group">
                        <i class="fab fa-whatsapp text-white text-xl group-hover:text-white"></i>
                    </a>
                </div>
            </div>

            <!-- Copyright -->
            <div class="text-center md:text-<?= $t['dir'] == 'rtl' ? 'left' : 'right' ?>">
                <p class="text-gray-500 text-xs font-medium uppercase tracking-widest">
                    &copy; <?= date('Y') ?> <?= $t['inst_name'] ?>
                </p>
                <p class="text-amber-300 text-xs font-black uppercase tracking-[0.3em] mt-2">
                    Lughat AlArab Institute
                </p>
            </div>
        </div>
    </div>
</footer>

<!-- JavaScript -->
<script>
document.addEventListener('DOMContentLoaded', function() {
    // Star Rating System
    document.querySelectorAll('.star-rating').forEach(ratingContainer => {
        const stars = ratingContainer.querySelectorAll('.star');
        const enrollmentId = ratingContainer.dataset.enrollment;
        
        stars.forEach(star => {
            star.addEventListener('click', function() {
                const ratingValue = parseInt(this.dataset.value);
                
                // Update visual state
                stars.forEach((s, index) => {
                    if(index < ratingValue) {
                        s.classList.add('active', 'text-amber-500');
                        s.classList.remove('text-gray-300');
                    } else {
                        s.classList.remove('active', 'text-amber-500');
                        s.classList.add('text-gray-300');
                    }
                });
                
                // Send rating to server
                const formData = new FormData();
                formData.append('enrollment_id', enrollmentId);
                formData.append('rating', ratingValue);
                
                fetch('save_rating.php', {
                    method: 'POST',
                    body: formData
                })
                .then(response => response.json())
                .then(data => {
                    if(data.success) {
                        showToast('<?= $t["toast_success"] ?>'.replace('{val}', ratingValue), 'success');
                    } else {
                        showToast('<?= $t["toast_error"] ?>', 'error');
                    }
                })
                .catch(error => {
                    console.error('Error:', error);
                    showToast('<?= $t["toast_error"] ?>', 'error');
                });
            });
        });
    });
    
    // Toast Notification System
    function showToast(message, type = 'success') {
        const toast = document.createElement('div');
        toast.className = `fixed top-6 <?= $t['dir'] == 'rtl' ? 'left-6' : 'right-6' ?> z-50 px-6 py-4 rounded-xl shadow-xl font-bold text-sm transform transition-all duration-300 translate-y-0 opacity-100`;
        
        if(type === 'success') {
            toast.className += ' bg-gradient-to-r from-green-500 to-emerald-600 text-white';
        } else if(type === 'error') {
            toast.className += ' bg-gradient-to-r from-red-500 to-rose-600 text-white';
        } else {
            toast.className += ' bg-gradient-to-r from-amber-500 to-orange-600 text-white';
        }
        
        toast.textContent = message;
        document.body.appendChild(toast);
        
        // Auto remove after 3 seconds
        setTimeout(() => {
            toast.style.transform = 'translateY(-20px)';
            toast.style.opacity = '0';
            setTimeout(() => toast.remove(), 300);
        }, 3000);
    }
    
    // Hover effects for cards
    const cards = document.querySelectorAll('.card, .stat-card');
    cards.forEach(card => {
        card.addEventListener('mouseenter', () => {
            card.style.transform = 'translateY(-4px)';
        });
        
        card.addEventListener('mouseleave', () => {
            card.style.transform = 'translateY(0)';
        });
    });
    
    // Language selector toggle
    const langBtn = document.querySelector('.relative');
    const langMenu = langBtn.querySelector('.absolute');
    
    langBtn.addEventListener('mouseenter', () => {
        langMenu.classList.remove('opacity-0', 'invisible');
        langMenu.classList.add('opacity-100', 'visible');
    });
    
    langBtn.addEventListener('mouseleave', () => {
        langMenu.classList.remove('opacity-100', 'visible');
        langMenu.classList.add('opacity-0', 'invisible');
    });
});
</script>
</body>
</html>