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/attendance

Free Space:

11.69 TB

🔧 Quick Actions

✏️ Editing: get_active_students.php

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

header('Content-Type: application/json');

// جلب لغة المستخدم أو الافتراضية
$current_lang = $_SESSION['lang'] ?? 'ar';
$lang = include("../languages/{$current_lang}.php");

$course_id = $_GET['course_id'] ?? null;
$today = date('Y-m-d');

if (!$course_id) {
    // استخدام الرسالة المترجمة للخطأ
    echo json_encode(['error' => $lang['error_course_not_specified'] ?? 'Course not specified']);
    exit;
}

try {
    // 1. جلب الطلاب النشطين الذين لم يتم تحضيرهم اليوم (بواسطة أي مدرس)
    $stmt = $conn->prepare("
        SELECT s.id, s.full_name, s.phone
        FROM students s
        INNER JOIN enrollments e ON s.id = e.student_id
        WHERE e.course_id = ? 
        AND e.status = 'نشط' -- جلب النشطين فقط
        AND s.id NOT IN (
            SELECT student_id FROM attendance 
            WHERE course_id = ? AND attendance_date = ?
        )
        ORDER BY s.full_name ASC
    ");
    $stmt->execute([$course_id, $course_id, $today]);
    $active_students = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 2. التحقق إذا كان هناك طلاب خريجون (مكتملون) لهذا الكورس
    $stmt_grad = $conn->prepare("SELECT COUNT(*) FROM enrollments WHERE course_id = ? AND status = 'مكتمل'");
    $stmt_grad->execute([$course_id]);
    $graduated_count = $stmt_grad->fetchColumn();

echo json_encode([
        'students' => $active_students,
        'has_graduated_only' => (empty($active_students) && $graduated_count > 0)
    ]);

} catch (PDOException $e) {
    http_response_code(500);
    echo json_encode(['error' => $e->getMessage()]);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_active_students.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation