limit(100) ->findMany(); $biopages = []; foreach($profiles as $bio){ $alias = $bio->alias; $urls = \Core\DB::url() ->where('userid', $bio->userid) ->findMany(); $views = 0; if($urls){ foreach($urls as $u){ $views += (int)$u->click; } } $bio->views = $views; // categoria fictícia para filtro (ex: creator, store, agency) $bio->category = $bio->category ?? 'creator'; $biopages[] = $bio; } // Ordenar por views decrescente usort($biopages,function($a,$b){ return $b->views <=> $a->views; }); ?>
Top Creators by Clicks
$bio): $data = json_decode($bio->data ?? '{}', true); $name = $bio->name ?? $bio->alias; $alias = $bio->alias; $avatar = $data['avatar'] ?? ''; $avatar_url = empty($avatar) ? 'https://idlink.io/content/avatar/uTEUqs_idlink-(2)_cropped.png' : url('content/profiles/'.$avatar); ?>