/** * 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(); }