

<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_clients.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
// Manage Clients page for admin
session_start();
require_once __DIR__ . &#039;/../includes/config.php&#039;;
require_once __DIR__ . &#039;/../includes/functions.php&#039;;
check_admin();

// Delete a client entry
if (isset($_GET[&#039;delete&#039;])) {
    $id = intval($_GET[&#039;delete&#039;]);
    $stmt = $conn-&gt;prepare(&quot;DELETE FROM clients WHERE id = ?&quot;);
    $stmt-&gt;bind_param(&#039;i&#039;, $id);
    $stmt-&gt;execute();
    redirect(&#039;manage_clients.php&#039;);
}

// Handle reorder actions: move up or down based on display_order column.  If
// display_order does not exist the requests are ignored gracefully.
if (isset($_GET[&#039;move&#039;]) &amp;&amp; isset($_GET[&#039;id&#039;])) {
    $id = intval($_GET[&#039;id&#039;]);
    $direction = $_GET[&#039;move&#039;];
    // Check for display_order column existence
    $colRes = $conn-&gt;query(&quot;SHOW COLUMNS FROM clients LIKE &#039;display_order&#039;&quot;);
    if ($colRes &amp;&amp; $colRes-&gt;num_rows &gt; 0) {
        $curRes = $conn-&gt;query(&quot;SELECT id, display_order FROM clients WHERE id = $id&quot;);
        if ($curRes &amp;&amp; $curRes-&gt;num_rows &gt; 0) {
            $cur = $curRes-&gt;fetch_assoc();
            $order = (int)$cur[&#039;display_order&#039;];
            if ($direction === &#039;up&#039;) {
                $neighborRes = $conn-&gt;query(&quot;SELECT id, display_order FROM clients WHERE display_order &lt; $order ORDER BY display_order DESC LIMIT 1&quot;);
            } else {
                $neighborRes = $conn-&gt;query(&quot;SELECT id, display_order FROM clients WHERE display_order &gt; $order ORDER BY display_order ASC LIMIT 1&quot;);
            }
            if ($neighborRes &amp;&amp; $neighborRes-&gt;num_rows &gt; 0) {
                $neighbor = $neighborRes-&gt;fetch_assoc();
                $neighborOrder = (int)$neighbor[&#039;display_order&#039;];
                // Swap orders
                $conn-&gt;query(&quot;UPDATE clients SET display_order = $neighborOrder WHERE id = $id&quot;);
                $conn-&gt;query(&quot;UPDATE clients SET display_order = $order WHERE id = {$neighbor[&#039;id&#039;]}&quot;);
            }
        }
    }
    redirect(&#039;manage_clients.php&#039;);
}

// Retrieve list of clients.  If a display_order column exists order by it; else
// order by id ascending.  This ensures stable ordering and supports
// reordering when the column is present.
$clients = [];
$hasOrder = false;
$colRes = $conn-&gt;query(&quot;SHOW COLUMNS FROM clients LIKE &#039;display_order&#039;&quot;);
if ($colRes &amp;&amp; $colRes-&gt;num_rows &gt; 0) {
    $hasOrder = true;
}
if ($hasOrder) {
    $res = $conn-&gt;query(&quot;SELECT * FROM clients ORDER BY display_order ASC, id ASC&quot;);
} else {
    $res = $conn-&gt;query(&quot;SELECT * FROM clients ORDER BY id ASC&quot;);
}
if ($res &amp;&amp; $res-&gt;num_rows &gt; 0) {
    while ($row = $res-&gt;fetch_assoc()) {
        $clients[] = $row;
    }
}
?&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 Clients - Admin&lt;/title&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;../assets/css/style.css&quot;&gt;
    &lt;!-- FontAwesome 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 button --&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; class=&quot;active&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;&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;Manage Clients&lt;/h1&gt;
        &lt;p&gt;&lt;a href=&quot;client_form.php&quot; class=&quot;btn-primary&quot; style=&quot;padding:8px 15px;display:inline-block;&quot;&gt;Add New Client&lt;/a&gt;&lt;/p&gt;
        &lt;div class=&quot;gallery-grid-admin&quot;&gt;
            &lt;?php foreach ($clients as $client): ?&gt;
                &lt;div class=&quot;gallery-admin-card&quot;&gt;
                    &lt;?php if (!empty($client[&#039;image_path&#039;])): ?&gt;
                        &lt;img src=&quot;&lt;?php echo e($client[&#039;image_path&#039;]); ?&gt;&quot; alt=&quot;Client&quot;&gt;
                    &lt;?php else: ?&gt;
                        &lt;img src=&quot;../assets/images/placeholder_light_gray_block.png&quot; alt=&quot;Client&quot;&gt;
                    &lt;?php endif; ?&gt;
                    &lt;p&gt;&lt;?php echo e($client[&#039;name&#039;] ?? &#039;&#039;); ?&gt;&lt;/p&gt;
                    &lt;div class=&quot;actions&quot;&gt;
                        &lt;?php if ($hasOrder): ?&gt;
                            &lt;a href=&quot;manage_clients.php?move=up&amp;id=&lt;?php echo $client[&#039;id&#039;]; ?&gt;&quot; title=&quot;Move Up&quot;&gt;&lt;i class=&quot;fas fa-arrow-up&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                            &lt;a href=&quot;manage_clients.php?move=down&amp;id=&lt;?php echo $client[&#039;id&#039;]; ?&gt;&quot; title=&quot;Move Down&quot;&gt;&lt;i class=&quot;fas fa-arrow-down&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;?php endif; ?&gt;
                        &lt;a href=&quot;client_form.php?id=&lt;?php echo $client[&#039;id&#039;]; ?&gt;&quot; title=&quot;Edit&quot;&gt;&lt;i class=&quot;fas fa-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                        &lt;a href=&quot;manage_clients.php?delete=&lt;?php echo $client[&#039;id&#039;]; ?&gt;&quot; title=&quot;Delete&quot; onclick=&quot;return confirm(&#039;Delete this client?&#039;);&quot;&gt;&lt;i class=&quot;fas fa-trash&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/div&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;script&gt;
// Sidebar collapse functionality copied from other admin pages for consistency
function toggleSidebar() {
    var sidebar = document.querySelector(&#039;.admin-sidebar&#039;);
    if (!sidebar) return;
    sidebar.classList.toggle(&#039;collapsed&#039;);
    if (sidebar.classList.contains(&#039;collapsed&#039;)) {
        localStorage.setItem(&#039;sidebarCollapsed&#039;, &#039;1&#039;);
    } else {
        localStorage.removeItem(&#039;sidebarCollapsed&#039;);
    }
}
// Apply saved collapsed state on load
document.addEventListener(&#039;DOMContentLoaded&#039;, function() {
    var sidebar = document.querySelector(&#039;.admin-sidebar&#039;);
    if (sidebar &amp;&amp; localStorage.getItem(&#039;sidebarCollapsed&#039;)) {
        sidebar.classList.add(&#039;collapsed&#039;);
    }
});
&lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/blueplanet.co.in/admin/manage_clients.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%2Fblueplanet.co.in%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>