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.
92 protected static ?User $defaultUser = null;
95 * Returns the default public user.
97 public static function getDefault(): self
99 if (!is_null(static::$defaultUser)) {
100 return static::$defaultUser;
103 static::$defaultUser = static::query()->where('system_name', '=', 'public')->first();
105 return static::$defaultUser;
108 public static function clearDefault(): void
110 static::$defaultUser = null;
114 * Check if the user is the default public user.
116 public function isDefault(): bool
118 return $this->system_name === 'public';
122 * The roles that belong to the user.
124 * @return BelongsToMany
126 public function roles()
128 if ($this->id === 0) {
132 return $this->belongsToMany(Role::class);
136 * Check if the user has a role.
138 public function hasRole($roleId): bool
140 return $this->roles->pluck('id')->contains($roleId);
144 * Check if the user has a role.
146 public function hasSystemRole(string $roleSystemName): bool
148 return $this->roles->pluck('system_name')->contains($roleSystemName);
152 * Attach the default system role to this user.
154 public function attachDefaultRole(): void
156 $roleId = intval(setting('registration-role'));
157 if ($roleId && $this->roles()->where('id', '=', $roleId)->count() === 0) {
158 $this->roles()->attach($roleId);
163 * Check if the user has a particular permission.
165 public function can(string $permissionName): bool
167 if ($this->email === 'guest') {
171 return $this->permissions()->contains($permissionName);
175 * Get all permissions belonging to the current user.
177 protected function permissions(): Collection
179 if (isset($this->permissions)) {
180 return $this->permissions;
183 $this->permissions = $this->newQuery()->getConnection()->table('role_user', 'ru')
184 ->select('role_permissions.name as name')->distinct()
185 ->leftJoin('permission_role', 'ru.role_id', '=', 'permission_role.role_id')
186 ->leftJoin('role_permissions', 'permission_role.permission_id', '=', 'role_permissions.id')
187 ->where('ru.user_id', '=', $this->id)
190 return $this->permissions;
194 * Clear any cached permissions on this instance.
196 public function clearPermissionCache()
198 $this->permissions = null;
202 * Attach a role to this user.
204 public function attachRole(Role $role)
206 $this->roles()->attach($role->id);
207 $this->unsetRelation('roles');
211 * Get the social account associated with this user.
213 public function socialAccounts(): HasMany
215 return $this->hasMany(SocialAccount::class);
219 * Check if the user has a social account,
220 * If a driver is passed it checks for that single account type.
222 * @param bool|string $socialDriver
226 public function hasSocialAccount($socialDriver = false)
228 if ($socialDriver === false) {
229 return $this->socialAccounts()->count() > 0;
232 return $this->socialAccounts()->where('driver', '=', $socialDriver)->exists();
236 * Returns a URL to the user's avatar.
238 public function getAvatar(int $size = 50): string
240 $default = url('/user_avatar.png');
241 $imageId = $this->image_id;
242 if ($imageId === 0 || $imageId === '0' || $imageId === null) {
246 if (!empty($this->avatarUrl)) {
247 return $this->avatarUrl;
251 $avatar = $this->avatar ? url($this->avatar->getThumb($size, $size, false)) : $default;
252 } catch (Exception $err) {
256 $this->avatarUrl = $avatar;
262 * Get the avatar for the user.
264 public function avatar(): BelongsTo
266 return $this->belongsTo(Image::class, 'image_id');
270 * Get the API tokens assigned to this user.
272 public function apiTokens(): HasMany
274 return $this->hasMany(ApiToken::class);
278 * Get the favourite instances for this user.
280 public function favourites(): HasMany
282 return $this->hasMany(Favourite::class);
286 * Get the MFA values belonging to this use.
288 public function mfaValues(): HasMany
290 return $this->hasMany(MfaValue::class);
294 * Get the last activity time for this user.
296 public function scopeWithLastActivityAt(Builder $query)
298 $query->addSelect(['activities.created_at as last_activity_at'])
299 ->leftJoinSub(function (\Illuminate\Database\Query\Builder $query) {
300 $query->from('activities')->select('user_id')
301 ->selectRaw('max(created_at) as created_at')
302 ->groupBy('user_id');
303 }, 'activities', 'users.id', '=', 'activities.user_id');
307 * Get the url for editing this user.
309 public function getEditUrl(string $path = ''): string
311 $uri = '/settings/users/' . $this->id . '/' . trim($path, '/');
313 return url(rtrim($uri, '/'));
317 * Get the url that links to this user's profile.
319 public function getProfileUrl(): string
321 return url('/user/' . $this->slug);
325 * Get a shortened version of the user's name.
327 public function getShortName(int $chars = 8): string
329 if (mb_strlen($this->name) <= $chars) {
333 $splitName = explode(' ', $this->name);
334 if (mb_strlen($splitName[0]) <= $chars) {
335 return $splitName[0];
342 * Send the password reset notification.
344 * @param string $token
348 public function sendPasswordResetNotification($token)
350 $this->notify(new ResetPassword($token));
356 public function logDescriptor(): string
358 return "({$this->id}) {$this->name}";
364 public function refreshSlug(): string
366 $this->slug = app(SlugGenerator::class)->generate($this);