/**
* Returns all users that are not assigned in the current project.
*
* @return array
*/
public function usersNotIn()
{
if ($this->id > 0) {
$userIds = $this->users()->lists('user_id')->all();
$users = User::where('deleted', '=', User::NOT_DELETED_USERS)->whereNotIn('id', $userIds)->get();
} else {
$users = User::where('deleted', '=', User::NOT_DELETED_USERS)->get();
}
return $users->lists('fullname', 'id')->all();
}
/**
* Fetch a user by column
*
* @param string $field
* @param int|string|bool $value
*
* @return Model\User
*/
public function fetchUserBy($field, $value)
{
return Model\User::where($field, '=', $value)->first();
}
/**
* @param int $deleted
*
* @return int
*/
public static function countUsers($deleted = User::NOT_DELETED_USERS)
{
return User::where('deleted', '=', $deleted)->count();
}
