prepare("DELETE FROM invoices WHERE id = ?");
$stmt->bind_param('i', $id);
$stmt->execute();
redirect('manage_invoices.php');
}
// Handle search and filters
$search = trim($_GET['search'] ?? '');
$status_filter = trim($_GET['status'] ?? '');
$date_from = trim($_GET['from'] ?? '');
$date_to = trim($_GET['to'] ?? '');
$where = [];
if ($search !== '') {
$esc = $conn->real_escape_string($search);
$where[] = "(invoice_number LIKE '%$esc%' OR client_name LIKE '%$esc%')";
}
if ($status_filter !== '') {
$esc = $conn->real_escape_string($status_filter);
$where[] = "status = '$esc'";
}
if ($date_from !== '') {
$esc = $conn->real_escape_string($date_from);
$where[] = "date >= '$esc'";
}
if ($date_to !== '') {
$esc = $conn->real_escape_string($date_to);
$where[] = "date <= '$esc'";
}
$whereClause = '';
if (!empty($where)) {
$whereClause = 'WHERE ' . implode(' AND ', $where);
}
// Fetch invoices
$invoices = [];
$query = "SELECT * FROM invoices $whereClause ORDER BY date DESC";
$res = $conn->query($query);
if ($res && $res->num_rows > 0) {
while ($row = $res->fetch_assoc()) {
$invoices[] = $row;
}
}
// Unique statuses for filter dropdown
$statusOptions = [];
$resStatus = $conn->query("SELECT DISTINCT status FROM invoices");
if ($resStatus) {
while ($row = $resStatus->fetch_assoc()) {
$statusOptions[] = $row['status'];
}
}
?>
Manage Invoices - Admin
Invoices
Add New Invoice
| ID |
Invoice # |
Client Name |
Amount (₹) |
Date |
Status |
Actions |
|
|
|
|
|
|
|