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

Free Space:

11.41 TB

🔧 Quick Actions

✏️ Editing: payments_report.php

<?php
session_start();

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

if (!isset($_SESSION['user']) || $_SESSION['user']['role'] !== 'admin') {
    header('Location: ../auth/login.php');
    exit;
}

require_once('../config/db.php');

// جلب الفروع للفلترة
$branches = $conn->query("SELECT DISTINCT address FROM students WHERE address IS NOT NULL AND address != ''")->fetchAll(PDO::FETCH_COLUMN);

// الاستعلام لجلب أرصدة الطلاب
$query = "
    SELECT 
        s.id as student_id,
        s.full_name, 
        s.address as branch_name,
        s.phone, 
        COALESCE(SUM(p.amount_paid), 0) as total_paid,
        COALESCE(SUM(p.discount), 0) as total_payment_discounts,
        (SELECT SUM(c.price) FROM enrollments e JOIN courses c ON e.course_id = c.id WHERE e.student_id = s.id) as original_price,
        (SELECT SUM(e.discount) FROM enrollments e WHERE e.student_id = s.id) as enroll_discounts,
        MAX(p.payment_date) as last_payment_date
    FROM students s
    LEFT JOIN payments p ON s.id = p.student_id
    GROUP BY s.id
    ORDER BY s.full_name ASC
";

$stmt = $conn->prepare($query);
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

$grand_total = array_sum(array_column($results, 'total_paid'));
?>

@media print {
        nav, aside, header, footer, .no-print, #sidebar, .sidebar-wrapper, .navbar, #menu-toggle { 
            display: none !important; 
        }
        body { background: white !important; margin: 0 !important; padding: 0 !important; }
        .max-w-7xl { max-width: 100% !important; width: 100% !important; margin: 0 !important; }
        .print-only-header { display: flex !important; justify-content: space-between; align-items: center; border-bottom: 3px solid #4f46e5; padding-bottom: 20px; margin-bottom: 30px; }
        .table-responsive { overflow: visible !important; box-shadow: none !important; border: 1px solid #eee !important; }
        #paymentsTable { min-width: 100% !important; }
        th { background-color: #f3f4f6 !important; color: black !important; border: 1px solid #ddd !important; -webkit-print-color-adjust: exact; }
    }
    .print-only-header { display: none; }
</style>

<div class="md:col-span-3">
                    <label class="block text-xs font-bold text-gray-500 mb-2 <?= $dir == 'rtl' ? 'mr-1' : 'ml-1' ?>"><?= __('instant_search') ?></label>
                    <div class="relative">
                        <span class="absolute inset-y-0 <?= $dir == 'rtl' ? 'right-0 pr-3' : 'left-0 pl-3' ?> flex items-center text-gray-400">
                            <i class="fas fa-search text-xs"></i>
                        </span>
                        <input type="text" id="globalSearch" placeholder="<?= __('search_name_phone_placeholder') ?>" 
                               class="<?= $dir == 'rtl' ? 'pr-9' : 'pl-9' ?> w-full border-gray-200 rounded-xl text-sm py-2.5 px-3 focus:ring-2 focus:ring-indigo-500 outline-none">
                    </div>
                </div>

<div class="table-responsive">
            <table id="paymentsTable" class="w-full <?= $dir == 'rtl' ? 'text-right' : 'text-left' ?> border-collapse">
                <thead class="table-header">
                    <tr>
                        <th class="<?= $dir == 'rtl' ? 'text-right' : 'text-left' ?>"><?= __('student_info') ?></th>
                        <th class="text-center"><?= __('original_amount') ?></th>
                        <th class="text-center"><?= __('discounts') ?></th>
                        <th class="text-center"><?= __('net_amount') ?></th>
                        <th class="text-center"><?= __('paid_amount') ?></th>
                        <th class="text-center"><?= __('remaining_amount') ?></th>
                        <th class="text-center"><?= __('last_payment') ?></th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-100 text-sm">
                    <?php foreach ($results as $row): 
                        $total_disc = ($row['total_payment_discounts'] ?? 0) + ($row['enroll_discounts'] ?? 0);
                        $net_req = ($row['original_price'] ?? 0) - $total_disc;
                        $remaining = $net_req - $row['total_paid'];
                        $last_date = $row['last_payment_date'] ? date('Y-m-d', strtotime($row['last_payment_date'])) : '';
                    ?>
                    <tr class="hover:bg-indigo-50 transition" 
                        data-branch="<?= htmlspecialchars($row['branch_name'] ?? '') ?>" 
                        data-date="<?= $last_date ?>">
                        <td>
                            <div class="font-bold text-gray-900"><?= htmlspecialchars($row['full_name']) ?></div>
                            <div class="text-[11px] text-gray-500"><?= $row['phone'] ?> | <?= $row['branch_name'] ?: __('main_center') ?></div>
                        </td>
                        <td class="text-center text-gray-400 line-through"><?= number_format($row['original_price'], 2) ?></td>
                        <td class="text-center text-orange-600 font-bold"><?= number_format($total_disc, 2) ?></td>
                        <td class="text-center font-bold text-gray-700"><?= number_format($net_req, 2) ?></td>
                        <td class="text-center font-black text-emerald-600" data-paid="<?= $row['total_paid'] ?>">
                            <?= number_format($row['total_paid'], 2) ?>
                        </td>
                        <td class="text-center">
                            <?php 
                            if ($net_req <= 0) {
                                echo '<span class="text-gray-400 font-bold text-xs">'.__('no_dues').'</span>';
                            } elseif ($remaining > 0.05) {
                                if ($row['total_paid'] <= 0) {
                                    echo '<span class="bg-orange-100 text-orange-700 px-3 py-1 rounded-lg font-bold text-xs">'.__('not_paid').'</span>';
                                } else {
                                    echo '<span class="bg-red-600 text-white px-3 py-1 rounded-lg font-bold text-xs shadow-sm">' . number_format($remaining, 2) . '</span>';
                                }
                            } else {
                                echo '<span class="text-emerald-500 font-bold text-xs"><i class="fas fa-check-circle '.($dir == 'rtl' ? 'ml-1' : 'mr-1').'"></i> '.__('completed').'</span>';
                            }
                            ?>
                        </td>
                        <td class="text-center text-gray-500 text-xs"><?= $last_date ?: '---' ?></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
                <tfoot>
                    <tr class="bg-gray-800 text-white font-black">
                        <td colspan="4" class="p-4 <?= $dir == 'rtl' ? 'text-right' : 'text-left' ?>"><?= __('total_collection_display') ?></td>
                        <td class="p-4 text-center text-emerald-400" id="totalDisplay">
                            <?= number_format($grand_total, 2) ?> <?= __('currency') ?>
                        </td>
                        <td colspan="2" class="p-4"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <p class="md:hidden text-center text-[10px] text-gray-400 mt-4"><?= __('scroll_hint') ?></p>
    </div>
</div>

function filterTable() {
        const branchVal = branchFilter.value.toLowerCase();
        const fromVal = dateFrom.value;
        const toVal = dateTo.value;
        const searchVal = globalSearch.value.toLowerCase();
        let currentTotal = 0;

const rangeText = (fromVal || toVal) ? `<?= __('period_from') ?> ${fromVal || '...'} <?= __('period_to') ?> ${toVal || '...'}` : '<?= __('all_periods_report') ?>';
        document.getElementById('printDateRangeDisplay').innerText = rangeText;

Array.from(tableBody.rows).forEach(row => {
            const rDate = row.getAttribute('data-date');
            const rBranch = (row.getAttribute('data-branch') || "").toLowerCase();
            const rText = row.innerText.toLowerCase();
            const rPaid = parseFloat(row.cells[4].getAttribute('data-paid')) || 0;

const matchesDate = (!fromVal || rDate >= fromVal) && (!toVal || rDate <= toVal);
            const matchesBranch = !branchVal || rBranch.includes(branchVal);
            const matchesSearch = !searchVal || rText.includes(searchVal);

if (matchesDate && matchesBranch && matchesSearch) {
                row.style.display = '';
                currentTotal += rPaid;
            } else {
                row.style.display = 'none';
            }
        });
        totalDisplay.innerText = currentTotal.toLocaleString(undefined, {minimumFractionDigits: 2}) + ' <?= __('currency') ?>';
    }

globalSearch.addEventListener('input', filterTable);
    branchFilter.addEventListener('change', filterTable);
    applyFilterBtn.addEventListener('click', filterTable);

document.getElementById('resetFilter').addEventListener('click', () => {
        branchFilter.value = '';
        dateFrom.value = '';
        dateTo.value = '';
        globalSearch.value = '';
        filterTable();
    });
});

function exportToExcel() {
    const table = document.getElementById("paymentsTable");
    const wb = XLSX.utils.table_to_book(table, {sheet: "<?= __('excel_sheet_name') ?>"});
    XLSX.writeFile(wb, "<?= __('excel_file_name') ?>.xlsx");
}
</script>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: payments_report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation