show placements on user profile

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

diff --git a/app/Models/User.php b/app/Models/User.php
index 4f56ac17f93b8af4ef2aff0c8478ee913ee19fd1..b4950c306c458fc5973f2a899f7021f93603f53d 100644 (file)
--- a/app/Models/User.php
+++ b/app/Models/User.php
@@ -39,10 +39,61 @@ class User extends Authenticatable
                return false;
        }
 
+
        public function participation() {
                return $this->hasMany(Participant::class);
        }
 
+       public function results() {
+               return $this->hasMany(Result::class);
+       }
+
+       public function rounds() {
+               return $this->belongsToMany(Round::class, 'results');
+       }
+
+       public function tournaments() {
+               return $this->belongsToMany(Tournament::class, 'participants');
+       }
+
+
+       public function round_first() {
+               return $this->rounds()
+                       ->whereNot('locked')
+                       ->wherePivot('placement', 1);
+       }
+
+       public function round_second() {
+               return $this->rounds()
+                       ->whereNot('locked')
+                       ->wherePivot('placement', 2);
+       }
+
+       public function round_third() {
+               return $this->rounds()
+                       ->whereNot('locked')
+                       ->wherePivot('placement', 3);
+       }
+
+       public function tournament_first() {
+               return $this->tournaments()
+                       ->whereNot('locked')
+                       ->wherePivot('placement', 1);
+       }
+
+       public function tournament_second() {
+               return $this->tournaments()
+                       ->whereNot('locked')
+                       ->wherePivot('placement', 2);
+       }
+
+       public function tournament_third() {
+               return $this->tournaments()
+                       ->whereNot('locked')
+                       ->wherePivot('placement', 3);
+       }
+
+
        /**
         * The attributes that are mass assignable.
         *