

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: manage_appointments.php</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>&lt;?php
// Admin page to manage appointment bookings
session_start();
require_once __DIR__ . &#039;/../includes/config.php&#039;;
require_once __DIR__ . &#039;/../includes/functions.php&#039;;
check_admin();

// Delete an appointment if requested
if (isset($_GET[&#039;delete&#039;])) {
    $id = intval($_GET[&#039;delete&#039;]);
    $stmt = $conn-&gt;prepare(&quot;DELETE FROM appointments WHERE id = ?&quot;);
    $stmt-&gt;bind_param(&#039;i&#039;, $id);
    $stmt-&gt;execute();
    redirect(&#039;manage_appointments.php&#039;);
}

// Fetch appointments with optional search and date filters
$appointments = [];
$alertCount = 0;
// Collect filter parameters
$q = trim($_GET[&#039;q&#039;] ?? &#039;&#039;);
$fromDate = trim($_GET[&#039;from&#039;] ?? &#039;&#039;);
$toDate = trim($_GET[&#039;to&#039;] ?? &#039;&#039;);
$whereClauses = [];
$types = &#039;&#039;;
$params = [];
if ($q !== &#039;&#039;) {
    $like = &#039;%&#039; . $q . &#039;%&#039;;
    $whereClauses[] = &quot;(name LIKE ? OR email LIKE ? OR phone LIKE ?)&quot;;
    $types .= &#039;sss&#039;;
    $params[] = $like;
    $params[] = $like;
    $params[] = $like;
}
if ($fromDate !== &#039;&#039;) {
    $whereClauses[] = &quot;DATE(preferred_date) &gt;= ?&quot;;
    $types .= &#039;s&#039;;
    $params[] = $fromDate;
}
if ($toDate !== &#039;&#039;) {
    $whereClauses[] = &quot;DATE(preferred_date) &lt;= ?&quot;;
    $types .= &#039;s&#039;;
    $params[] = $toDate;
}
$sql = &quot;SELECT * FROM appointments&quot;;
if (!empty($whereClauses)) {
    $sql .= &quot; WHERE &quot; . implode(&#039; AND &#039;, $whereClauses);
}
$sql .= &quot; ORDER BY created_at DESC&quot;;
$stmt = $conn-&gt;prepare($sql);
if ($stmt) {
    if ($types !== &#039;&#039;) {
        $stmt-&gt;bind_param($types, ...$params);
    }
    $stmt-&gt;execute();
    $res = $stmt-&gt;get_result();
} else {
    // fallback if prepare fails
    $res = $conn-&gt;query(&quot;SELECT * FROM appointments ORDER BY created_at DESC&quot;);
}
if ($res &amp;&amp; $res-&gt;num_rows &gt; 0) {
    while ($row = $res-&gt;fetch_assoc()) {
        if (isset($row[&#039;is_viewed&#039;]) &amp;&amp; (int)$row[&#039;is_viewed&#039;] === 0) {
            $alertCount++;
        }
        $appointments[] = $row;
    }
}
// Mark all appointments as viewed once admin has seen the page
if ($alertCount &gt; 0) {
    $conn-&gt;query(&quot;UPDATE appointments SET is_viewed = 1 WHERE is_viewed = 0&quot;);
}
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1.0&quot;&gt;
    &lt;title&gt;Manage Appointments - Admin&lt;/title&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;../assets/css/style.css&quot;&gt;
    &lt;!-- FontAwesome for icons --&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;../assets/fontawesome/fontawesome-all.min.css&quot;&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;div class=&quot;admin-wrapper&quot;&gt;
    &lt;div class=&quot;admin-sidebar&quot;&gt;
        &lt;h2&gt;Admin Panel&lt;/h2&gt;
        &lt;!-- Sidebar toggle for collapse --&gt;
        &lt;span class=&quot;toggle-btn&quot; onclick=&quot;toggleSidebar()&quot;&gt;&lt;i class=&quot;fas fa-bars&quot;&gt;&lt;/i&gt;&lt;/span&gt;
        &lt;a href=&quot;dashboard.php&quot;&gt;&lt;i class=&quot;fas fa-tachometer-alt&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Dashboard&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_sliders.php&quot;&gt;&lt;i class=&quot;fas fa-sliders-h&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Manage Sliders&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_services.php&quot;&gt;&lt;i class=&quot;fas fa-cogs&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Manage Services&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_products.php&quot;&gt;&lt;i class=&quot;fas fa-box-open&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Manage Products&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_blogs.php&quot;&gt;&lt;i class=&quot;fas fa-blog&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Manage Blogs&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_gallery.php&quot;&gt;&lt;i class=&quot;fas fa-images&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Manage Gallery&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_clients.php&quot;&gt;&lt;i class=&quot;fas fa-users&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Manage Clients&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_appointments.php&quot; class=&quot;active&quot;&gt;&lt;i class=&quot;fas fa-calendar-check&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Appointments&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_service_bookings.php&quot;&gt;&lt;i class=&quot;fas fa-tools&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Service Bookings&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_parts_bookings.php&quot;&gt;&lt;i class=&quot;fas fa-cubes&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Parts Bookings&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_enquiries.php&quot;&gt;&lt;i class=&quot;fas fa-envelope&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Enquiries&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;manage_invoices.php&quot;&gt;&lt;i class=&quot;fas fa-file-invoice-dollar&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Invoices&lt;/span&gt;&lt;/a&gt;
        &lt;a href=&quot;logout.php&quot;&gt;&lt;i class=&quot;fas fa-sign-out-alt&quot;&gt;&lt;/i&gt;&lt;span class=&quot;label&quot;&gt;Logout&lt;/span&gt;&lt;/a&gt;
    &lt;/div&gt;
    &lt;div class=&quot;admin-content&quot;&gt;
        &lt;h1&gt;Appointments&lt;/h1&gt;
        &lt;!-- Search/filter form --&gt;
        &lt;form method=&quot;get&quot; action=&quot;&quot; style=&quot;margin-bottom:20px;display:flex;flex-wrap:wrap;gap:10px;align-items:flex-end;&quot;&gt;
            &lt;div class=&quot;form-group&quot; style=&quot;margin-right:10px;&quot;&gt;
                &lt;label&gt;Search&lt;/label&gt;
                &lt;input type=&quot;text&quot; name=&quot;q&quot; value=&quot;&lt;?php echo e($q); ?&gt;&quot; placeholder=&quot;Name, email or phone&quot;&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group&quot; style=&quot;margin-right:10px;&quot;&gt;
                &lt;label&gt;From&lt;/label&gt;
                &lt;input type=&quot;date&quot; name=&quot;from&quot; value=&quot;&lt;?php echo e($fromDate); ?&gt;&quot;&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group&quot; style=&quot;margin-right:10px;&quot;&gt;
                &lt;label&gt;To&lt;/label&gt;
                &lt;input type=&quot;date&quot; name=&quot;to&quot; value=&quot;&lt;?php echo e($toDate); ?&gt;&quot;&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group&quot;&gt;
                &lt;button type=&quot;submit&quot; class=&quot;btn-primary&quot; style=&quot;padding:8px 15px;&quot;&gt;Filter&lt;/button&gt;
            &lt;/div&gt;
        &lt;/form&gt;
        &lt;table class=&quot;table&quot;&gt;
            &lt;tr&gt;
                &lt;th&gt;ID&lt;/th&gt;
                &lt;th&gt;Name&lt;/th&gt;
                &lt;th&gt;Email&lt;/th&gt;
                &lt;th&gt;Phone&lt;/th&gt;
                &lt;th&gt;Submitted At&lt;/th&gt;
                &lt;th&gt;Preferred Date&lt;/th&gt;
                &lt;th&gt;Message&lt;/th&gt;
                &lt;th&gt;Actions&lt;/th&gt;
            &lt;/tr&gt;
            &lt;?php foreach ($appointments as $appt): ?&gt;
            &lt;tr&gt;
                &lt;td&gt;&lt;?php echo $appt[&#039;id&#039;]; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($appt[&#039;name&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($appt[&#039;email&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($appt[&#039;phone&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo date(&#039;Y-m-d H:i&#039;, strtotime($appt[&#039;created_at&#039;])); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e(date(&#039;Y-m-d H:i&#039;, strtotime($appt[&#039;preferred_date&#039;]))); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($appt[&#039;message&#039;]); ?&gt;&lt;/td&gt;
                &lt;td class=&quot;actions&quot;&gt;
                    &lt;a href=&quot;manage_appointments.php?delete=&lt;?php echo $appt[&#039;id&#039;]; ?&gt;&quot; onclick=&quot;return confirm(&#039;Delete this appointment?&#039;);&quot;&gt;Delete&lt;/a&gt;
                &lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/table&gt;
        &lt;footer class=&quot;admin-footer&quot;&gt;
            &amp;copy; 2026 Blueswirlz Engineers &amp; Consultants. All rights reserved.
        &lt;/footer&gt;
    &lt;/div&gt;
    &lt;/div&gt;

    &lt;!-- Remove per-page alert audio. The dashboard handles notifications. --&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/blueswirlz.com/admin/manage_appointments.php'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2Fblueswirlz.com%2Fadmin' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>