/**
* Get all users active in the last x minutes
*
* @param int $minutes The number of minutes which are considered as "online time"
* @param string $orderBy
* @param string $orderDir
* @param int $num The number of users to return. Set to 0 to get all users
*
* @return mixed
*/
public function online($minutes = 15, $orderBy = 'last_visit', $orderDir = 'desc', $num = 20)
{
// If the user visited the logout page as last he's not online anymore
/** @var Builder $baseQuery */
$baseQuery = $this->userModel->where('last_visit', '>=', new \DateTime("{$minutes} minutes ago"))->where('last_page', '!=', 'auth/logout')->orderBy('users.' . $orderBy, $orderDir);
// No need to add anymore if the user has permission to view anyone
if (!$this->permissionChecker->hasPermission('user', null, 'canViewAllOnline')) {
// First get the id of our setting
$settingId = Setting::where('name', 'user.showonline')->first()->id;
// Now join the correct setting_values row
$baseQuery->leftJoin('setting_values', function ($join) use($settingId) {
$join->on('setting_values.user_id', '=', 'users.id')->where('setting_values.setting_id', '=', $settingId);
});
// Either the setting is true or not set...
$baseQuery->where(function ($query) {
$query->where('setting_values.value', true)->orWhereNull('setting_values.value');
// ... or we're querying our row at the moment
if ($this->guard->check()) {
$query->orWhere('users.id', '=', $this->guard->user()->id);
}
});
}
if ($num > 0) {
return $baseQuery->paginate($num, ['users.*']);
}
return $baseQuery->get(['users.*']);
}
/**
* @param string $attribute
*
* @return array
*
* @throws ModelNotFoundException
*/
public function getUseridArray($attribute)
{
$usernames = $this->getUsernameArray($attribute);
$userids = array();
foreach ($usernames as $username) {
$user = User::where('name', $username)->first();
if (!$user) {
throw new ModelNotFoundException();
}
$userids[] = $user->id;
}
return $userids;
}
