query("SELECT id, em_user FROM employee WHERE em_role=" . $_SESSION['employee_id']); if ($employeeResult) { while ($employeeRow = $employeeResult->fetch_assoc()) { ?>
= htmlspecialcharsFix($employeeRow['em_user']) ?>的客户画像:
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'] . ')
'; } } ?>