basic content editing

[alttp.git] / app / Models / User.php

diff --git a/app/Models/User.php b/app/Models/User.php
index b4950c306c458fc5973f2a899f7021f93603f53d..db834b7a240ca423141f254a1494fc9916b82c22 100644 (file)
--- 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,6 +13,63 @@ 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 hasGlobalRole($name) {
+               return !empty($this->global_roles) && in_array($name, $this->global_roles);
+       }
+
+       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) {
+                               return true;
+                       }
+               }
+               return false;
+       }
+
+       public function isDeniedApplicant(Tournament $tournament) {
+               foreach ($tournament->applications as $applicant) {
+                       if ($applicant->user_id == $this->id) {
+                               return $applicant->denied;
+                       }
+               }
+               return false;
+       }
+
        public function isParticipant(Tournament $tournament) {
                foreach ($tournament->participants as $participant) {
                        if ($participant->user_id == $this->id) {
@@ -39,6 +97,31 @@ class User extends Authenticatable
                return false;
        }
 
+       public function isTournamentCrew(Tournament $tournament) {
+               return $this->isTournamentAdmin($tournament) || $this->isTournamentMonitor($tournament);
+       }
+
+       public function isTournamentMonitor(Tournament $tournament) {
+               foreach ($tournament->participants as $participant) {
+                       if ($participant->user_id == $this->id) {
+                               return in_array('monitor', $participant->roles);
+                       }
+               }
+               return false;
+       }
+
+       public function hasFinished(Round $round) {
+               foreach ($round->results as $result) {
+                       if ($result->user_id != $this->id) continue;
+                       return $result->has_finished;
+               }
+               return false;
+       }
+
+
+       public function channel_crews() {
+               return $this->hasMany(ChannelCrew::class);
+       }
 
        public function participation() {
                return $this->hasMany(Participant::class);
@@ -59,37 +142,46 @@ class User extends Authenticatable
 
        public function round_first() {
                return $this->rounds()
-                       ->whereNot('locked')
+                       ->where('locked', true)
+                       ->where('no_record', false)
+                       ->wherePivot('forfeit', false)
                        ->wherePivot('placement', 1);
        }
 
        public function round_second() {
                return $this->rounds()
-                       ->whereNot('locked')
+                       ->where('locked', true)
+                       ->where('no_record', false)
+                       ->wherePivot('forfeit', false)
                        ->wherePivot('placement', 2);
        }
 
        public function round_third() {
                return $this->rounds()
-                       ->whereNot('locked')
+                       ->where('locked', true)
+                       ->where('no_record', false)
+                       ->wherePivot('forfeit', false)
                        ->wherePivot('placement', 3);
        }
 
        public function tournament_first() {
                return $this->tournaments()
-                       ->whereNot('locked')
+                       ->where('locked', true)
+                       ->where('no_record', false)
                        ->wherePivot('placement', 1);
        }
 
        public function tournament_second() {
                return $this->tournaments()
-                       ->whereNot('locked')
+                       ->where('locked', true)
+                       ->where('no_record', false)
                        ->wherePivot('placement', 2);
        }
 
        public function tournament_third() {
                return $this->tournaments()
-                       ->whereNot('locked')
+                       ->where('locked', true)
+                       ->where('no_record', false)
                        ->wherePivot('placement', 3);
        }
 
@@ -102,6 +194,7 @@ class User extends Authenticatable
        protected $fillable = [
                'id',
                'username',
+               'discord_nickname',
                'discriminator',
                'email',
                'avatar',
@@ -135,7 +228,9 @@ class User extends Authenticatable
                'discriminator' => 'string',
                'email' => 'string',
                'avatar' => 'string',
+               'avatar_cached' => 'datetime',
                'verified' => 'boolean',
+               'global_roles' => 'array',
                'locale' => 'string',
                'mfa_enabled' => 'boolean',
                'refresh_token' => 'encrypted',