/**
* {@inheritDoc}
*/
public function render()
{
$today = date('Y-m-d');
$thisWeek = date('Y-m-d', strtotime('last monday'));
$this->addCss('css/friendstoolbar.css');
$meta = new Usermeta();
$meta_table = $meta->getTable();
$this->vars['numFriends'] = Usermeta::where('current_member', '!=', Usermeta::IS_STAFF)->count();
$this->vars['todayFriends'] = User::join($meta_table, 'users.id', '=', $meta_table . '.user_id')->where('current_member', '!=', Usermeta::IS_STAFF)->where('created_at', '>=', $today)->count();
$this->vars['weekFriends'] = User::join($meta_table, 'users.id', '=', $meta_table . '.user_id')->where('current_member', '!=', Usermeta::IS_STAFF)->where('created_at', '>=', $thisWeek)->count();
$this->vars['averageFriends'] = $this->getAverageFriends();
return $this->makePartial('widget');
}
public function getOptinFriends($friends)
{
$numWithOptin = Usermeta::where('email_optin', 1)->count();
return round($numWithOptin / $friends * 100);
}