X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;ds=inline;f=app%2FModels%2FUser.php;fp=app%2FModels%2FUser.php;h=b4950c306c458fc5973f2a899f7021f93603f53d;hb=2ab05ab7927e8b21887ffa42d04eb9d4ff899382;hp=4f56ac17f93b8af4ef2aff0c8478ee913ee19fd1;hpb=d32516335ea2534e15256c948e9c38d3de40794b;p=alttp.git

diff --git a/app/Models/User.php b/app/Models/User.php
index 4f56ac1..b4950c3 100644
--- 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.
 	 *