3 namespace BookStack\Users\Models;
5 use BookStack\Access\Mfa\MfaValue;
6 use BookStack\Access\SocialAccount;
7 use BookStack\Activity\Models\Favourite;
8 use BookStack\Activity\Models\Loggable;
9 use BookStack\Api\ApiToken;
10 use BookStack\App\Model;
11 use BookStack\App\Sluggable;
12 use BookStack\Entities\Tools\SlugGenerator;
13 use BookStack\Notifications\ResetPassword;
14 use BookStack\Uploads\Image;
17 use Illuminate\Auth\Authenticatable;
18 use Illuminate\Auth\Passwords\CanResetPassword;
19 use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;
20 use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;
21 use Illuminate\Database\Eloquent\Builder;
22 use Illuminate\Database\Eloquent\Factories\HasFactory;
23 use Illuminate\Database\Eloquent\Relations\BelongsTo;
24 use Illuminate\Database\Eloquent\Relations\BelongsToMany;
25 use Illuminate\Database\Eloquent\Relations\HasMany;
26 use Illuminate\Notifications\Notifiable;
27 use Illuminate\Support\Collection;
33 * @property string $name
34 * @property string $slug
35 * @property string $email
36 * @property string $password
37 * @property Carbon $created_at
38 * @property Carbon $updated_at
39 * @property bool $email_confirmed
40 * @property int $image_id
41 * @property string $external_auth_id
42 * @property string $system_name
43 * @property Collection $roles
44 * @property Collection $mfaValues
46 class User extends Model implements AuthenticatableContract, CanResetPasswordContract, Loggable, Sluggable
54 * The database table used by the model.
58 protected $table = 'users';
61 * The attributes that are mass assignable.
65 protected $fillable = ['name', 'email'];
67 protected $casts = ['last_activity_at' => 'datetime'];
70 * The attributes excluded from the model's JSON form.
75 'password', 'remember_token', 'system_name', 'email_confirmed', 'external_auth_id', 'email',
76 'created_at', 'updated_at', 'image_id', 'roles', 'avatar', 'user_id', 'pivot',
80 * This holds the user's permissions when loaded.
82 protected ?Collection $permissions;
85 * This holds the user's avatar URL when loaded to prevent re-calculating within the same request.
87 protected string $avatarUrl = '';
90 * This holds the default user when loaded.
94 protected static ?User $defaultUser = null;
97 * Returns the default public user.
99 public static function getDefault(): self
101 if (!is_null(static::$defaultUser)) {
102 return static::$defaultUser;
105 static::$defaultUser = static::query()->where('system_name', '=', 'public')->first();
107 return static::$defaultUser;
111 * Check if the user is the default public user.
113 public function isDefault(): bool
115 return $this->system_name === 'public';
119 * The roles that belong to the user.
121 * @return BelongsToMany
123 public function roles()
125 if ($this->id === 0) {
129 return $this->belongsToMany(Role::class);
133 * Check if the user has a role.
135 public function hasRole($roleId): bool
137 return $this->roles->pluck('id')->contains($roleId);
141 * Check if the user has a role.
143 public function hasSystemRole(string $roleSystemName): bool
145 return $this->roles->pluck('system_name')->contains($roleSystemName);
149 * Attach the default system role to this user.
151 public function attachDefaultRole(): void
153 $roleId = intval(setting('registration-role'));
154 if ($roleId && $this->roles()->where('id', '=', $roleId)->count() === 0) {
155 $this->roles()->attach($roleId);
160 * Check if the user has a particular permission.
162 public function can(string $permissionName): bool
164 if ($this->email === 'guest') {
168 return $this->permissions()->contains($permissionName);
172 * Get all permissions belonging to the current user.
174 protected function permissions(): Collection
176 if (isset($this->permissions)) {
177 return $this->permissions;
180 $this->permissions = $this->newQuery()->getConnection()->table('role_user', 'ru')
181 ->select('role_permissions.name as name')->distinct()
182 ->leftJoin('permission_role', 'ru.role_id', '=', 'permission_role.role_id')
183 ->leftJoin('role_permissions', 'permission_role.permission_id', '=', 'role_permissions.id')
184 ->where('ru.user_id', '=', $this->id)
187 return $this->permissions;
191 * Clear any cached permissions on this instance.
193 public function clearPermissionCache()
195 $this->permissions = null;
199 * Attach a role to this user.
201 public function attachRole(Role $role)
203 $this->roles()->attach($role->id);
204 $this->unsetRelation('roles');
208 * Get the social account associated with this user.
210 public function socialAccounts(): HasMany
212 return $this->hasMany(SocialAccount::class);
216 * Check if the user has a social account,
217 * If a driver is passed it checks for that single account type.
219 * @param bool|string $socialDriver
223 public function hasSocialAccount($socialDriver = false)
225 if ($socialDriver === false) {
226 return $this->socialAccounts()->count() > 0;
229 return $this->socialAccounts()->where('driver', '=', $socialDriver)->exists();
233 * Returns a URL to the user's avatar.
235 public function getAvatar(int $size = 50): string
237 $default = url('/user_avatar.png');
238 $imageId = $this->image_id;
239 if ($imageId === 0 || $imageId === '0' || $imageId === null) {
243 if (!empty($this->avatarUrl)) {
244 return $this->avatarUrl;
248 $avatar = $this->avatar ? url($this->avatar->getThumb($size, $size, false)) : $default;
249 } catch (Exception $err) {
253 $this->avatarUrl = $avatar;
259 * Get the avatar for the user.
261 public function avatar(): BelongsTo
263 return $this->belongsTo(Image::class, 'image_id');
267 * Get the API tokens assigned to this user.
269 public function apiTokens(): HasMany
271 return $this->hasMany(ApiToken::class);
275 * Get the favourite instances for this user.
277 public function favourites(): HasMany
279 return $this->hasMany(Favourite::class);
283 * Get the MFA values belonging to this use.
285 public function mfaValues(): HasMany
287 return $this->hasMany(MfaValue::class);
291 * Get the last activity time for this user.
293 public function scopeWithLastActivityAt(Builder $query)
295 $query->addSelect(['activities.created_at as last_activity_at'])
296 ->leftJoinSub(function (\Illuminate\Database\Query\Builder $query) {
297 $query->from('activities')->select('user_id')
298 ->selectRaw('max(created_at) as created_at')
299 ->groupBy('user_id');
300 }, 'activities', 'users.id', '=', 'activities.user_id');
304 * Get the url for editing this user.
306 public function getEditUrl(string $path = ''): string
308 $uri = '/settings/users/' . $this->id . '/' . trim($path, '/');
310 return url(rtrim($uri, '/'));
314 * Get the url that links to this user's profile.
316 public function getProfileUrl(): string
318 return url('/user/' . $this->slug);
322 * Get a shortened version of the user's name.
324 public function getShortName(int $chars = 8): string
326 if (mb_strlen($this->name) <= $chars) {
330 $splitName = explode(' ', $this->name);
331 if (mb_strlen($splitName[0]) <= $chars) {
332 return $splitName[0];
339 * Send the password reset notification.
341 * @param string $token
345 public function sendPasswordResetNotification($token)
347 $this->notify(new ResetPassword($token));
353 public function logDescriptor(): string
355 return "({$this->id}) {$this->name}";
361 public function refreshSlug(): string
363 $this->slug = app(SlugGenerator::class)->generate($this);