Access Denied. You do not have permission to manage truck owners.
';
render_footer();
exit;
}
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'], $_POST['user_id'])) {
$userId = (int)$_POST['user_id'];
$action = $_POST['action'];
if ($action === 'approve') {
db()->prepare("UPDATE users SET status = 'active' WHERE id = ? AND role = 'truck_owner'")->execute([$userId]);
$flash = 'Truck Owner approved successfully.';
} elseif ($action === 'reject') {
db()->prepare("UPDATE users SET status = 'rejected' WHERE id = ? AND role = 'truck_owner'")->execute([$userId]);
$flash = 'Truck Owner rejected.';
} elseif ($action === 'delete') {
db()->prepare("DELETE FROM truck_owner_profiles WHERE user_id = ?")->execute([$userId]);
db()->prepare("DELETE FROM users WHERE id = ? AND role = 'truck_owner'")->execute([$userId]);
$flash = 'Truck Owner deleted.';
}
}
// Search and Pagination parameters
$q = trim($_GET['q'] ?? '');
$status = trim($_GET['status'] ?? '');
$page = max(1, (int)($_GET['page'] ?? 1));
$limit = 10;
$offset = ($page - 1) * $limit;
$whereClause = "u.role = 'truck_owner'";
$params = [];
if ($q !== '') {
// Search only by user details as trucks are now one-to-many
$whereClause .= " AND (u.full_name LIKE ? OR u.email LIKE ? OR p.phone LIKE ?)";
$likeQ = "%$q%";
$params = array_merge($params, [$likeQ, $likeQ, $likeQ]);
}
if ($status !== '' && in_array($status, ['active', 'pending', 'rejected'])) {
$whereClause .= " AND u.status = ?";
$params[] = $status;
}
// Total count
$countSql = "
SELECT COUNT(*)
FROM users u
LEFT JOIN truck_owner_profiles p ON u.id = p.user_id
WHERE $whereClause
";
$stmt = db()->prepare($countSql);
$stmt->execute($params);
$total = (int)$stmt->fetchColumn();
$totalPages = (int)ceil($total / $limit);
// Fetch truck owners with truck count
$sql = "
SELECT u.id, u.email, u.full_name, u.status, u.created_at,
p.phone, p.id_card_path,
c.name_en AS country_name,
ci.name_en AS city_name,
(SELECT COUNT(*) FROM trucks t WHERE t.user_id = u.id) as truck_count
FROM users u
LEFT JOIN truck_owner_profiles p ON u.id = p.user_id
LEFT JOIN countries c ON p.country_id = c.id
LEFT JOIN cities ci ON p.city_id = ci.id
WHERE $whereClause
ORDER BY u.created_at DESC
LIMIT $limit OFFSET $offset
";
$stmt = db()->prepare($sql);
$stmt->execute($params);
$owners = $stmt->fetchAll();
render_header(t('manage_truck_owners'), 'admin', true);
?>