X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FModels%2FUser.php;fp=app%2FModels%2FUser.php;h=8373b5d236c134a5cd0f2fc8127505e0dfb53966;hb=35d1ce20e64f3373d74816ed1bf9440b4213fa1a;hp=164fb026bfecba420a784daf83b44697f37cd869;hpb=f295d5ffc60a5f73bd4dd89c0ecc69aecaac9d8a;p=alttp.git

diff --git a/app/Models/User.php b/app/Models/User.php
index 164fb02..8373b5d 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;
@@ -28,6 +29,16 @@ class User extends Authenticatable
 		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';