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;
{
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 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) {
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 participation() {
return $this->hasMany(Participant::class);
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);
}