0) { $_SESSION['message'] = '

Cannot delete customer. They have ' . $bill_count . ' bill(s) in the system.

'; } else { $delete_sql = "DELETE FROM customers WHERE id = ?"; $delete_stmt = mysqli_prepare($conn, $delete_sql); mysqli_stmt_bind_param($delete_stmt, "i", $delete_id); if (mysqli_stmt_execute($delete_stmt)) { $_SESSION['message'] = '

Customer deleted successfully!

'; } else { $_SESSION['message'] = '

Error deleting customer: ' . mysqli_error($conn) . '

'; } } header('Location: manage-customers.php'); exit(); } // Get filter parameters $search_query = isset($_GET['search']) ? trim($_GET['search']) : ''; // Build WHERE conditions $where_conditions = []; $params = []; $types = ''; if (!empty($search_query)) { $where_conditions[] = "(c.name LIKE ? OR c.phone LIKE ? OR c.address LIKE ?)"; $params[] = "%$search_query%"; $params[] = "%$search_query%"; $params[] = "%$search_query%"; $types .= 'sss'; } $where_clause = !empty($where_conditions) ? "WHERE " . implode(" AND ", $where_conditions) : ""; // Get customers with statistics $sql = "SELECT c.*, COUNT(b.id) as total_orders, COALESCE(SUM(b.total_amount), 0) as total_spent, MAX(b.created_at) as last_order_date FROM customers c LEFT JOIN bills b ON c.id = b.customer_id $where_clause GROUP BY c.id ORDER BY c.name"; $stmt = mysqli_prepare($conn, $sql); if (!empty($params)) { mysqli_stmt_bind_param($stmt, $types, ...$params); } mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); // Get customer statistics $stats_sql = "SELECT COUNT(*) as total_customers, COUNT(DISTINCT b.customer_id) as customers_with_orders, SUM(b.total_amount) as total_revenue, AVG(b.total_amount) as avg_order_value FROM customers c LEFT JOIN bills b ON c.id = b.customer_id"; $stats_result = mysqli_query($conn, $stats_sql); $stats = mysqli_fetch_assoc($stats_result); // Display message if exists $message = ''; if (isset($_SESSION['message'])) { $message = $_SESSION['message']; unset($_SESSION['message']); } ?>

Customers / Manage Customers

New Bill Manage Orders

Total Customers

Active Customers

₹

Total Revenue

₹

Avg Order Value

Customers List

Showing customer(s)

0): ?>

#	Customer	Contact	Address	Orders	Total Spent	Last Order	Registered	Actions
	0): ?> Regular Customer New Customer		-	0): ?> orders No orders	0): ?> ₹ ₹ 0 ? number_format($customer['total_spent'] / $customer['total_orders'], 2) : '0.00'; ?> avg -	-
No customers found Create First Customer Clear Search

Customers / Manage Customers

₹

₹

Customers List

No customers found