Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.13.1.el9_7.x86_64

PHP Version:

8.3.30

User:

u823738529

Directory:

/home/u823738529/domains/lughatalarabinstitute.net/public_html/system/rate

Free Space:

11.69 TB

🔧 Quick Actions

✏️ Editing: course_ratings.php

<?php
session_start();
require_once('../config/db.php');

// ✅ استدعاء الهيدر في البداية لتعريف نظام الترجمة والاتجاهات
include('../includes/header.php');

// ✅ التحقق من تسجيل الدخول
if (!isset($_SESSION['user'])) {
    header('Location: ../auth/login.php');
    exit;
}

// جلب جميع الكورسات مع عدد التقييمات ومتوسط التقييم
try {
    $stmt = $conn->prepare("
        SELECT c.id AS course_id, c.course_name,
               COUNT(r.id) AS total_ratings,
               AVG(r.rating) AS avg_rating
        FROM courses c
        LEFT JOIN enrollments e ON e.course_id = c.id
        LEFT JOIN course_ratings r ON r.enrollment_id = e.id
        GROUP BY c.id, c.course_name
        ORDER BY avg_rating DESC, c.course_name ASC
    ");
    $stmt->execute();
    $courses = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    die(__('error_db_general') . $e->getMessage());
}
?>

<?php include('../includes/navbar.php'); ?>

<div class="bg-white dark:bg-gray-800 shadow-2xl rounded-2xl overflow-hidden p-2 sm:p-6">
            
            <?php if (!empty($courses)): ?>
            <div class="mb-6 p-4 border-<?= $dir == 'rtl' ? 'r' : 'l' ?>-4 border-emerald-500 bg-emerald-50 dark:bg-emerald-900/20 rounded-lg">
                <h3 class="text-xl font-bold text-emerald-800 dark:text-emerald-400">
                    <i class="fas fa-chart-line <?= $dir == 'rtl' ? 'ml-2' : 'mr-2' ?>"></i> 
                    <?= __('performance_overview') ?>
                </h3>
                <p class="text-sm text-emerald-600 dark:text-emerald-500 mt-1"><?= __('performance_hint') ?></p>
            </div>

<div class="overflow-x-auto rounded-xl">
                <table class="min-w-full <?= $dir == 'rtl' ? 'text-right' : 'text-left' ?> border-collapse">
                    <thead class="bg-indigo-600 text-white">
                        <tr>
                            <th class="p-4 font-bold text-sm uppercase border-<?= $dir == 'rtl' ? 'l' : 'r' ?> border-indigo-500"><?= __('course_name') ?></th>
                            <th class="p-4 font-bold text-sm uppercase border-<?= $dir == 'rtl' ? 'l' : 'r' ?> border-indigo-500"><?= __('raters_count') ?></th>
                            <th class="p-4 font-bold text-sm uppercase border-<?= $dir == 'rtl' ? 'l' : 'r' ?> border-indigo-500 text-center"><?= __('avg_rating') ?></th>
                            <th class="p-4 font-bold text-sm uppercase text-center"><?= __('quality_index') ?></th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-200 dark:divide-gray-700">
                        <?php foreach ($courses as $course): 
                            $avg = $course['avg_rating'] ? number_format($course['avg_rating'], 1) : 0;
                            $percentage = $course['avg_rating'] ? round(($course['avg_rating']/5)*100, 0) : 0;
                            $total_ratings = (int)$course['total_ratings'];

// منطق النجوم
                            $fullStars = floor($course['avg_rating']);
                            $halfStar = ($course['avg_rating'] - $fullStars) >= 0.25;
                            $emptyStars = 5 - $fullStars - ($halfStar ? 1 : 0);
                        ?>
                        <tr class="hover:bg-gray-50 dark:hover:bg-gray-700/50 transition">
                            <td class="p-4 font-bold text-gray-800 dark:text-gray-200 border-<?= $dir == 'rtl' ? 'l' : 'r' ?> dark:border-gray-700">
                                <?= htmlspecialchars($course['course_name']) ?>
                            </td>
                            
                            <td class="p-4 border-<?= $dir == 'rtl' ? 'l' : 'r' ?> dark:border-gray-700">
                                <span class="px-3 py-1 rounded-full text-xs font-bold bg-gray-100 dark:bg-gray-700 text-gray-600 dark:text-gray-300 border border-gray-200 dark:border-gray-600">
                                    <?= $total_ratings ?> <?= __('rating_unit') ?>
                                </span>
                            </td>
                            
                            <td class="p-4 border-<?= $dir == 'rtl' ? 'l' : 'r' ?> dark:border-gray-700 text-center">
                                <div class="flex items-center justify-center gap-1">
                                    <div class="flex text-yellow-500 text-xs">
                                        <?php for($i=0;$i<$fullStars;$i++) echo '<i class="fas fa-star"></i>'; ?>
                                        <?php if($halfStar) echo '<i class="fas fa-star-half-alt"></i>'; ?>
                                        <?php for($i=0;$i<$emptyStars;$i++) echo '<i class="far fa-star text-gray-300 dark:text-gray-600"></i>'; ?>
                                    </div>
                                    <span class="text-lg font-black text-gray-900 dark:text-white <?= $dir == 'rtl' ? 'mr-2' : 'ml-2' ?>"><?= $avg ?></span>
                                </div>
                            </td>
                            
                            <td class="p-4">
                                <div class="flex items-center gap-3 justify-center">
                                    <div class="flex-1 max-w-[100px] bg-gray-200 dark:bg-gray-700 rounded-full h-2 overflow-hidden">
                                        <div class="h-full rounded-full transition-all duration-1000 <?= $percentage >= 80 ? 'bg-emerald-500' : ($percentage >= 60 ? 'bg-yellow-500' : 'bg-red-500') ?>" 
                                             style="width: <?= $percentage ?>%"></div>
                                    </div>
                                    <span class="text-xs font-bold <?= $percentage >= 80 ? 'text-emerald-600' : ($percentage >= 60 ? 'text-yellow-600' : 'text-red-600') ?>">
                                        <?= $percentage ?>%
                                    </span>
                                </div>
                            </td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
            <?php else: ?>
                <div class="text-center py-20 bg-gray-50 dark:bg-gray-700/30 rounded-2xl border border-dashed border-gray-300 dark:border-gray-600">
                    <div class="bg-white dark:bg-gray-800 w-20 h-20 rounded-full flex items-center justify-center mx-auto mb-4 shadow-lg">
                        <i class="fas fa-chart-pie text-4xl text-gray-300"></i>
                    </div>
                    <p class="text-xl text-gray-500 dark:text-gray-400 font-bold"><?= __('no_rating_data') ?></p>
                </div>
            <?php endif; ?>
        </div>
    </div>
</div>

<?php include('../includes/footer.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: course_ratings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation