prepare('SELECT role_id FROM users WHERE id=?');
$stmt->execute([$user_id]);
$role_id = (int) ($stmt->fetchColumn());
$stmt = $pdo->query('SELECT id, username, nickname, real_name, phone, created_at, level, referrer_id, referral_code FROM users');
$all_users = $stmt->fetchAll(PDO::FETCH_ASSOC);
$user_map = [];
foreach ($all_users as $u) {
$user_map[$u['id']] = $u;
}
$stmt = $pdo->query("SELECT user_id, SUM(amount) as total FROM recharge_orders WHERE status='confirmed' GROUP BY user_id");
$all_performance = $stmt->fetchAll(PDO::FETCH_ASSOC);
$performance_map = [];
foreach ($all_performance as $p) {
$performance_map[$p['user_id']] = $p['total'];
}
function get_team_members_fast($parent_id, $user_map, $performance_map, &$all_users, $level = 1, $parent_name = '', &$visited = [])
{
$members = [];
foreach ($all_users as $u) {
if ($u['referrer_id'] == $parent_id && !in_array($u['id'], $visited)) {
$visited[] = $u['id'];
$performance = isset($performance_map[$u['id']]) ? $performance_map[$u['id']] : 0;
$members[] = [
'id' => $u['id'],
'username' => $u['username'],
'nickname' => $u['nickname'],
'real_name' => $u['real_name'] ?? '',
'phone' => $u['phone'],
'created_at' => $u['created_at'],
'level' => $u['level'],
'performance' => $performance,
'referrer_id' => $u['referrer_id'],
'referrer_name' => $parent_name,
'tree_level' => $level,
];
$members = array_merge($members, get_team_members_fast($u['id'], $user_map, $performance_map, $all_users, $level + 1, $u['username'], $visited));
}
}
return $members;
}
$visited = [];
$team_members = get_team_members_fast($user_id, $user_map, $performance_map, $all_users, 1, '', $visited);
$is_team_leader = ($role_id >= 13 && $role_id <= 38);
$is_partner = ($role_id == 9 || $role_id == 10 || $role_id == 11)
|| (function_exists('merchant_is_shop_owner') && merchant_is_shop_owner($pdo, $user_id));
if (!$is_team_leader && !$is_partner) {
$team_members = array_filter($team_members, static function ($m) {
return $m['tree_level'] == 1 || $m['tree_level'] == 2;
});
}
$layer_stats = [];
$total_performance = 0;
foreach ($team_members as $m) {
$l = $m['tree_level'];
if (!isset($layer_stats[$l])) {
$layer_stats[$l] = ['count' => 0, 'performance' => 0];
}
$layer_stats[$l]['count']++;
$layer_stats[$l]['performance'] += $m['performance'];
$total_performance += $m['performance'];
}
function mask_phone($phone)
{
if (preg_match('/^1[3-9]\d{9}$/', $phone)) {
return substr($phone, 0, 3) . '****' . substr($phone, -4);
} elseif (strlen($phone) > 7) {
return substr($phone, 0, 3) . '****' . substr($phone, -4);
}
return $phone;
}
function mask_name($str)
{
$len = mb_strlen($str, 'UTF-8');
if ($len <= 6) {
if ($len <= 2) {
return $str;
}
return mb_substr($str, 0, 2, 'UTF-8') . str_repeat('*', max(1, $len - 4)) . mb_substr($str, -2, 2, 'UTF-8');
}
return mb_substr($str, 0, 3, 'UTF-8') . str_repeat('*', $len - 6) . mb_substr($str, -3, 3, 'UTF-8');
}
function mask_real_name($real_name)
{
if (empty($real_name)) {
return '';
}
$len = mb_strlen($real_name, 'UTF-8');
if ($len == 1) {
return '*';
}
if ($len == 2) {
return '*' . mb_substr($real_name, 1, 1, 'UTF-8');
}
$first_two = mb_substr($real_name, 0, 2, 'UTF-8');
$remaining = mb_substr($real_name, 2, null, 'UTF-8');
$stars = str_repeat('*', mb_strlen($remaining, 'UTF-8'));
return $first_two . $stars;
}
$team_page_size = 50;
$team_total = count($team_members);
$team_page = max(1, (int) ($_GET['page'] ?? 1));
$team_total_pages = $team_total > 0 ? (int) ceil($team_total / $team_page_size) : 1;
if ($team_page > $team_total_pages) {
$team_page = $team_total_pages;
}
$team_offset = ($team_page - 1) * $team_page_size;
$team_members_page = array_slice($team_members, $team_offset, $team_page_size);
$team_show_pager = $team_total > $team_page_size;
$team_row_from = $team_total > 0 ? $team_offset + 1 : 0;
$team_row_to = min($team_offset + count($team_members_page), $team_total);
$team_form_path = '/user/team_structure.php';
$teamRuPath = parse_url((string) ($_SERVER['REQUEST_URI'] ?? ''), PHP_URL_PATH);
if (is_string($teamRuPath) && $teamRuPath !== '') {
$team_form_path = $teamRuPath;
} elseif (!empty($_SERVER['SCRIPT_NAME'])) {
$team_form_path = (string) $_SERVER['SCRIPT_NAME'];
}
$team_form_get = is_array($_GET) ? $_GET : [];
$team_pager_url = static function (int $pageNum) use ($team_form_path, $team_form_get): string {
$q = $team_form_get;
if ($pageNum > 1) {
$q['page'] = $pageNum;
} else {
unset($q['page']);
}
$path = $team_form_path . ($q === [] ? '' : ('?' . http_build_query($q)));
return function_exists('ggai_member_url_with_impersonate')
? ggai_member_url_with_impersonate($path)
: $path;
};
ob_start();
?>
' . htmlspecialchars(trim($h)) . '';
}
?>
$stat): ?>
| | |
U