prepare("
INSERT INTO customers (full_name, phone, email, password, is_active, created_at)
VALUES (?,?,?,?,1,NOW())
");
$stmt->bind_param("ssss", $name, $phone, $email, $pass);
$stmt->execute();
$stmt->close();
}
header("Location: users.php");
exit();
}
/* ================== EXPORT CSV ================== */
if (isset($_GET['export']) && $_GET['export'] === 'csv') {
header("Content-Type: text/csv");
header("Content-Disposition: attachment; filename=customers.csv");
$out = fopen("php://output", "w");
fputcsv($out, ['ID','Full Name','Phone','Email','Password','Balance','Created At']);
$sql = "
SELECT c.id, c.full_name, c.phone, c.email, c.password, c.created_at,
IFNULL(SUM(b.amount),0) balance
FROM customers c
LEFT JOIN balance b ON b.user=c.id
WHERE c.is_active=1
GROUP BY c.id
ORDER BY c.id DESC
";
$res = $conn->query($sql);
while ($row = $res->fetch_assoc()) {
fputcsv($out, $row);
}
fclose($out);
exit();
}
/* ================== SOFT DELETE ================== */
if (isset($_POST['deactivate_id'])) {
$id = (int)$_POST['deactivate_id'];
$stmt = $conn->prepare("UPDATE customers SET is_active=0 WHERE id=?");
$stmt->bind_param("i",$id);
$stmt->execute();
$stmt->close();
header("Location: users.php");
exit();
}
/* ================== FUND USER ================== */
if (isset($_POST['fund_user'])) {
$uid = (int)$_POST['user_id'];
$amount = (float)$_POST['amount'];
if ($amount > 0) {
$stmt = $conn->prepare("
INSERT INTO balance (user,amount)
VALUES (?,?)
ON DUPLICATE KEY UPDATE amount = amount + VALUES(amount)
");
$stmt->bind_param("id",$uid,$amount);
$stmt->execute();
$stmt->close();
}
header("Location: users.php");
exit();
}
/* ================== PAGINATION ================== */
$limit = 20;
$page = max(1, (int)($_GET['page'] ?? 1));
$offset = ($page - 1) * $limit;
$search = trim($_GET['search'] ?? '');
/* ================== COUNT ================== */
if ($search !== '') {
$like = "%$search%";
$stmt = $conn->prepare("
SELECT COUNT(*) FROM customers
WHERE is_active=1
AND (full_name LIKE ? OR phone LIKE ? OR email LIKE ?)
");
$stmt->bind_param("sss",$like,$like,$like);
} else {
$stmt = $conn->prepare("SELECT COUNT(*) FROM customers WHERE is_active=1");
}
$stmt->execute();
$stmt->bind_result($total);
$stmt->fetch();
$stmt->close();
$totalPages = ceil($total / $limit);
/* ================== FETCH CUSTOMERS ================== */
if ($search !== '') {
$stmt = $conn->prepare("
SELECT c.*, IFNULL(SUM(b.amount),0) balance
FROM customers c
LEFT JOIN balance b ON b.user=c.id
WHERE c.is_active=1
AND (c.full_name LIKE ? OR c.phone LIKE ? OR c.email LIKE ?)
GROUP BY c.id
ORDER BY c.id DESC
LIMIT ? OFFSET ?
");
$stmt->bind_param("sssii",$like,$like,$like,$limit,$offset);
} else {
$stmt = $conn->prepare("
SELECT c.*, IFNULL(SUM(b.amount),0) balance
FROM customers c
LEFT JOIN balance b ON b.user=c.id
WHERE c.is_active=1
GROUP BY c.id
ORDER BY c.id DESC
LIMIT ? OFFSET ?
");
$stmt->bind_param("ii",$limit,$offset);
}
$stmt->execute();
$result = $stmt->get_result();
$customers = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
?>
Customers — ASOVERIFY Admin
Customers Management
Add Customer
| ID |
Name |
Phone |
Email |
Password |
Balance |
Actions |
| No customers found |
|
|
|
|
|
₦ |
|