FM / admin

/var/www/vhosts/m-auto.co/httpdocs/admin/

/var/www/vhosts/m-auto.co/httpdocs/admin

Name	Size	Mode	Actions
assets/	-	0755	rm
includes/	-	0755	rm
7-6-2026.zip	10206	0644	edit dl rm
about_edit.php	3899	0644	edit dl rm
about_process.php	1367	0644	edit dl rm
auth.php	684	0644	edit dl rm
bookings.php	5367	0644	edit dl rm
booking_delete.php	924	0644	edit dl rm
branches.php	2470	0644	edit dl rm
branch_delete.php	1290	0644	edit dl rm
branch_form.php	4694	0644	edit dl rm
branch_process.php	1233	0644	edit dl rm
brands.php	2578	0644	edit dl rm
brand_delete.php	1327	0644	edit dl rm
brand_form.php	2369	0644	edit dl rm
brand_process.php	1660	0644	edit dl rm
cars.php	6946	0644	edit dl rm
car_delete.php	2886	0644	edit dl rm
car_form.php	40348	0644	edit dl rm
car_image_actions.php	5142	0644	edit dl rm
car_process.php	10426	0644	edit dl rm
categories.php	2167	0644	edit dl rm
category_delete.php	746	0644	edit dl rm
category_form.php	1607	0644	edit dl rm
category_process.php	943	0644	edit dl rm
dashboard.php	4965	0644	edit dl rm
index.php	2713	0644	edit dl rm
login_process.php	1532	0644	edit dl rm
logout.php	100	0644	edit dl rm
news.php	3448	0644	edit dl rm
news_delete.php	771	0644	edit dl rm
news_form.php	6769	0644	edit dl rm
news_process.php	2527	0644	edit dl rm
offers.php	2810	0644	edit dl rm
offer_delete.php	1327	0644	edit dl rm
offer_form.php	4573	0644	edit dl rm
offer_process.php	2115	0644	edit dl rm
settings.php	5217	0644	edit dl rm
settings_process.php	692	0644	edit dl rm
slider.php	3529	0644	edit dl rm
slider_delete.php	1345	0644	edit dl rm
slider_form.php	4529	0644	edit dl rm
slider_process.php	1983	0644	edit dl rm
themes.php	4703	0644	edit dl rm
theme_delete.php	1332	0644	edit dl rm
theme_form.php	1522	0644	edit dl rm
theme_process.php	1785	0644	edit dl rm
users.php	4480	0644	edit dl rm
user_delete.php	1055	0644	edit dl rm
user_form.php	5463	0644	edit dl rm
user_process.php	3193	0644	edit dl rm
videos.php	4942	0644	edit dl rm
video_delete.php	1717	0644	edit dl rm
video_form.php	7181	0644	edit dl rm
video_process.php	3336	0644	edit dl rm

Edit: /var/www/vhosts/m-auto.co/httpdocs/admin/dashboard.php (4965B)

<?php include 'includes/header.php'; ?>

<?php
// Fetch all settings
$settings_result = $conn->query("SELECT * FROM settings");
$settings = [];
while($row = $settings_result->fetch_assoc()) {
    $settings[$row['setting_key']] = $row['setting_value'];
}
// Fetch stats - Placeholders for now, will be dynamic later
$cars_count = $conn->query("SELECT COUNT(id) as count FROM cars")->fetch_assoc()['count'];
$branches_count = $conn->query("SELECT COUNT(id) as count FROM branches")->fetch_assoc()['count'];
$visits_count = $conn->query("SELECT COUNT(id) as count FROM visit_reservations")->fetch_assoc()['count'];
$maintenance_count = $conn->query("SELECT COUNT(id) as count FROM maintenance_reservations")->fetch_assoc()['count'];
?>

<div class="row mb-4">
    <div class="col-12">
        <div class="glass-card p-4">
            <h4 class="mb-3"><i class="fas fa-info-circle me-2"></i>معلومات الموقع</h4>
            <div class="row">
                <div class="col-md-6">
                    <p><strong>اسم الموقع:</strong> <?= htmlspecialchars($settings['site_title'] ?? 'غير محدد') ?></p>
                    <p><strong>البريد الإلكتروني:</strong> <?= htmlspecialchars($settings['contact_email'] ?? 'غير محدد') ?></p>
                </div>
                <div class="col-md-6">
                    <p><strong>رقم الهاتف:</strong> <?= htmlspecialchars($settings['contact_phone'] ?? 'غير محدد') ?></p>
                    <p><strong>العنوان:</strong> <?= htmlspecialchars($settings['contact_address'] ?? 'غير محدد') ?></p>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row g-4">
    <div class="col-md-3">
        <div class="p-4 glass-card text-center">
            <i class="fas fa-car fs-1 primary-text"></i>
            <h3 class="fs-2 mt-2"><?= $cars_count ?></h3>
            <p class="fs-5">سيارة معروضة</p>
        </div>
    </div>
    <div class="col-md-3">
        <div class="p-4 glass-card text-center">
            <i class="fas fa-map-marked-alt fs-1 primary-text"></i>
            <h3 class="fs-2 mt-2"><?= $branches_count ?></h3>
            <p class="fs-5">فرع</p>
        </div>
    </div>
    <div class="col-md-3">
        <div class="p-4 glass-card text-center">
            <i class="fas fa-calendar-check fs-1 primary-text"></i>
            <h3 class="fs-2 mt-2"><?= $visits_count ?></h3>
            <p class="fs-5">حجز زيارة</p>
        </div>
    </div>
    <div class="col-md-3">
        <div class="p-4 glass-card text-center">
            <i class="fas fa-tools fs-1 primary-text"></i>
            <h3 class="fs-2 mt-2"><?= $maintenance_count ?></h3>
            <p class="fs-5">طلب صيانة</p>
        </div>
    </div>
</div>

<div class="row my-5">
    <h3 class="fs-4 mb-3">آخر الحجوزات</h3>
    <div class="col">
        <div class="glass-card p-3">
            <table class="table table-dark table-hover">
                <thead>
                    <tr>
                        <th scope="col">#</th>
                        <th scope="col">الاسم</th>
                        <th scope="col">الهاتف</th>
                        <th scope="col">نوع الحجز</th>
                        <th scope="col">التاريخ</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                    // Fetch latest 5 reservations (visits and maintenance)
                    $sql = "(SELECT id, name, phone, 'زيارة فرع' as type, visit_date as date FROM visit_reservations ORDER BY created_at DESC LIMIT 3) 
                            UNION ALL 
                            (SELECT id, name, phone, 'طلب صيانة' as type, reservation_date as date FROM maintenance_reservations ORDER BY created_at DESC LIMIT 2) 
                            ORDER BY date DESC";
                    $result = $conn->query($sql);
                    if ($result->num_rows > 0) {
                        while($row = $result->fetch_assoc()) {
                            echo "<tr>";
                            echo "<td>" . $row["id"] . "</td>";
                            echo "<td>" . htmlspecialchars($row["name"]) . "</td>";
                            echo "<td>" . htmlspecialchars($row["phone"]) . "</td>";
                            echo "<td><span class='badge bg-primary'>" . $row["type"] . "</span></td>";
                            echo "<td>" . $row["date"] . "</td>";
                            echo "</tr>";
                        }
                    } else {
                        echo "<tr><td colspan='5' class='text-center'>لا توجد حجوزات حالياً.</td></tr>";
                    }
                    ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

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

cmd: