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.69 TB

🔧 Quick Actions

✏️ Editing: expenses_report.php

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

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

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

// جلب كافة المصروفات
$query = "SELECT * FROM expenses ORDER BY expense_date DESC";
$stmt = $conn->prepare($query);
$stmt->execute();
$expenses = $stmt->fetchAll(PDO::FETCH_ASSOC);

$grand_total = array_sum(array_column($expenses, 'amount'));

// جلب أنواع المصروفات للقائمة المنسدلة
$types_stmt = $conn->query("SELECT DISTINCT expense_type FROM expenses WHERE expense_type IS NOT NULL");
$all_types = $types_stmt->fetchAll(PDO::FETCH_COLUMN);
?>

<div class="header-card mb-8 no-print">
            <div class="flex flex-col md:flex-row md:justify-between md:items-center gap-4">
                <div>
                    <h2 class="text-3xl font-extrabold text-gray-800">
                        <i class="fas fa-file-invoice-dollar text-red-500 <?= $dir == 'rtl' ? 'ml-2' : 'mr-2' ?>"></i> <?= __('expenses_report_title') ?>
                    </h2>
                    <p class="mt-1 text-xs text-gray-500 font-bold">
                        <?= __('version') ?>: 1.0 | <?= __('today_date') ?>: <?php echo date('Y-m-d'); ?>
                    </p>
                </div>
                <div class="flex flex-wrap gap-2">
                    <button onclick="window.print()" class="bg-gray-800 text-white px-5 py-2.5 rounded-xl font-bold shadow-md hover:bg-black transition flex items-center text-sm">
                        <i class="fas fa-print <?= $dir == 'rtl' ? 'ml-2' : 'mr-2' ?>"></i> <?= __('print') ?>
                    </button>
                    <button onclick="exportToExcel()" class="bg-emerald-600 text-white px-5 py-2.5 rounded-xl font-bold shadow-md hover:bg-emerald-700 transition flex items-center text-sm">
                        <i class="fas fa-file-excel <?= $dir == 'rtl' ? 'ml-2' : 'mr-2' ?>"></i> Excel
                    </button>
                </div>
            </div>
        </div>

<div class="md:col-span-3">
                    <label class="block text-xs font-bold text-gray-500 mb-2 <?= $dir == 'rtl' ? 'mr-1' : 'ml-1' ?>"><?= __('general_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_desc_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-red-500 outline-none shadow-sm transition">
                    </div>
                </div>

<div class="table-responsive">
            <table id="expensesTable" class="w-full <?= $dir == 'rtl' ? 'text-right' : 'text-left' ?> border-collapse">
                <thead class="table-header text-sm">
                    <tr>
                        <th class="<?= $dir == 'rtl' ? 'text-right' : 'text-left' ?>"><?= __('date') ?></th>
                        <th class="<?= $dir == 'rtl' ? 'text-right' : 'text-left' ?>"><?= __('expense_type') ?></th>
                        <th class="text-center"><?= __('amount') ?></th>
                        <th class="<?= $dir == 'rtl' ? 'text-right' : 'text-left' ?>"><?= __('description') ?></th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-100 text-sm font-medium text-gray-700">
                    <?php foreach ($expenses as $e): ?>
                    <tr class="hover:bg-red-50 transition-colors" 
                        data-type="<?= htmlspecialchars($e['expense_type']) ?>" 
                        data-date="<?= $e['expense_date'] ?>">
                        <td><?= $e['expense_date'] ?></td>
                        <td>
                            <span class="bg-red-100 text-red-700 px-3 py-1 rounded-full text-xs font-bold border border-red-200">
                                <?= htmlspecialchars($e['expense_type']) ?>
                            </span>
                        </td>
                        <td class="text-center font-black text-red-600 text-lg" data-amount="<?= $e['amount'] ?>">
                            <?= number_format($e['amount'], 2) ?>
                        </td>
                        <td class="text-gray-500 whitespace-normal min-w-[200px]">
                            <?= htmlspecialchars($e['description'] ?: '---') ?>
                        </td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
                <tfoot>
                    <tr class="bg-gray-900 text-white font-black text-lg">
                        <td colspan="2" class="p-5 <?= $dir == 'rtl' ? 'text-right' : 'text-left' ?>"><?= __('total_expenses_display') ?></td>
                        <td class="p-5 text-center text-red-400" id="totalDisplay">
                            <?= number_format($grand_total, 2) ?> <?= __('currency') ?>
                        </td>
                        <td></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <p class="md:hidden text-center text-[10px] text-gray-400 mt-4"><?= __('scroll_hint_simple') ?></p>
    </div>
</div>

function filterTable() {
        const searchVal = globalSearch.value.toLowerCase();
        const typeVal = typeFilter.value.toLowerCase();
        const fromVal = dateFrom.value;
        const toVal = dateTo.value;
        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 rType = (row.getAttribute('data-type') || "").toLowerCase();
            const rText = row.innerText.toLowerCase();
            const rAmount = parseFloat(row.cells[2].getAttribute('data-amount')) || 0;

const matchesDate = (!fromVal || rDate >= fromVal) && (!toVal || rDate <= toVal);
            const matchesType = !typeVal || rType.includes(typeVal);
            const matchesSearch = !searchVal || rText.includes(searchVal);

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

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

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

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

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: expenses_report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation