X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FModels%2FUser.php;h=ad5215f064acc5407b2d1bc48664c549c3e41fbb;hb=dc004b57a3d95d29dbf8a06a07df43f603eec6be;hp=ff45c6177c234acddda70e6b62493863fb48d151;hpb=3a774bb649734fc3a2135ec1b52cef9a049880ee;p=alttp.git

diff --git a/app/Models/User.php b/app/Models/User.php
index ff45c61..ad5215f 100644
--- a/app/Models/User.php
+++ b/app/Models/User.php
@@ -2,6 +2,7 @@
 
 namespace App\Models;
 
+use Illuminate\Database\Eloquent\Builder;
 use Illuminate\Database\Eloquent\Factories\HasFactory;
 use Illuminate\Foundation\Auth\User as Authenticatable;
 use Illuminate\Notifications\Notifiable;
@@ -12,10 +13,41 @@ class User extends Authenticatable
 {
 	use HasApiTokens, HasFactory, Notifiable;
 
+	public function findResult(Round $round) {
+		foreach ($round->results as $result) {
+			if ($this->id == $result->user_id) {
+				return $result;
+			}
+		}
+		return null;
+	}
+
+	public function getName() {
+		if (!empty($this->nickname)) {
+			return $this->nickname;
+		}
+		return $this->username;
+	}
+
+	public function getRandomQuoteAttribute() {
+		return $this->results()
+			->where('comment', '!=', '')
+			->whereHas('round', function(Builder $query) {
+				$query->where('locked', true);
+			})
+			->inRandomOrder()
+			->first();
+	}
+
+
 	public function isAdmin() {
 		return $this->role === 'admin';
 	}
 
+	public function isPrivileged() {
+		return $this->role === 'special' || $this->isAdmin();
+	}
+
 	public function isApplicant(Tournament $tournament) {
 		foreach ($tournament->applications as $applicant) {
 			if ($applicant->user_id == $this->id) {
@@ -83,6 +115,10 @@ class User extends Authenticatable
 	}
 
 
+	public function channel_crews() {
+		return $this->hasMany(ChannelCrew::class);
+	}
+
 	public function participation() {
 		return $this->hasMany(Participant::class);
 	}
@@ -187,6 +223,7 @@ class User extends Authenticatable
 		'discriminator' => 'string',
 		'email' => 'string',
 		'avatar' => 'string',
+		'avatar_cached' => 'datetime',
 		'verified' => 'boolean',
 		'locale' => 'string',
 		'mfa_enabled' => 'boolean',