public function render() { $friends = User::count(); $partners = Usermeta::select('id')->where('current_member', Usermeta::IS_MEMBER)->count(); $notPartners = $friends - $partners; $this->vars['totalFriends'] = number_format($friends); $this->vars['notPartners'] = number_format($notPartners); $this->vars['partners'] = number_format($partners); $this->vars['partnerPercent'] = round($partners / $friends * 100) . '%'; return $this->makePartial('widget'); }
public function render() { $results = Usermeta::select(DB::raw('count(user_id) as count'), 'gender')->groupBy('gender')->get(); $count = User::count(); $total = 0; foreach ($results as $result) { if (empty($result->gender)) { continue; } $data[$result->gender] = $result->count; $total += $result->count; } $data[Lang::get('dma.friends::lang.user.noGender')] = $count - $total; arsort($data); $this->vars['data'] = $data; return $this->makePartial('widget'); }