query($userInfoQuery); if ($userResult && $userRow = $userResult->fetch_assoc()) { // 只有 em_permission_role_id=2 表示该用户是组长 $isLeader = ($userRow['em_permission_role_id'] == 2); } // 如果不是组长，直接跳转到客户列表页面 if (!$isLeader) { header('Location: customers.php'); exit; } ?> 管理区域
query("SELECT id, em_user FROM employee WHERE em_role=" . $_SESSION['employee_id']); if ($employeeResult) { while ($employeeRow = $employeeResult->fetch_assoc()) { ?>

的客户画像：

query("SELECT tagName, COUNT(id) as count FROM tagtable WHERE employeeId=" . $employeeRow['id'] . " GROUP BY tagName"); if ($tagResult) { while ($tagRow = $tagResult->fetch_assoc()) { echo '' . htmlspecialcharsFix($tagRow['tagName']) . '(' . $tagRow['count'] . ')'; } } ?>