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');
 }