fix scoring

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

diff --git a/app/Models/Channel.php b/app/Models/Channel.php
index 738312dc3e82a60d6725a0289f2886a11b3dcc2e..da9f6a7360ad772002d0b1307cd751853c77314b 100644 (file)
--- a/app/Models/Channel.php
+++ b/app/Models/Channel.php
@@ -2,13 +2,24 @@
 
 namespace App\Models;
 
+use Illuminate\Broadcasting\PrivateChannel;
+use Illuminate\Database\Eloquent\BroadcastsEvents;
 use Illuminate\Database\Eloquent\Factories\HasFactory;
 use Illuminate\Database\Eloquent\Model;
+use Illuminate\Support\Arr;
 
-class Channel extends Model
-{
+class Channel extends Model {
+
+       use BroadcastsEvents;
        use HasFactory;
 
+       public function broadcastOn($event) {
+               $channels = [
+                       new PrivateChannel('Channel.'.$this->id),
+               ];
+               return $channels;
+       }
+
        public function getCurrentEpisode() {
                return $this->episodes()
                        ->where('start', '<', now()->subMinutes(10))
@@ -16,6 +27,10 @@ class Channel extends Model
                        ->first();
        }
 
+       public function getGuessingLeaderboard() {
+               return $this->winners()->selectRaw('(select t2.uname from guessing_winners t2 where t2.uid = guessing_winners.uid order by created_at desc limit 1) as name, sum(score) as score')->groupBy('uid')->orderBy('score', 'desc')->limit(10)->get();
+       }
+
        public function hasActiveGuessing() {
                return !is_null($this->guessing_start);
        }
@@ -66,6 +81,9 @@ class Channel extends Model
                                $distance = abs(intval($guess->guess) - intval($solution));
                                if (is_null($min_distance) || $distance == $min_distance) {
                                        $candidates[] = $guess;
+                                       if (is_null($min_distance)) {
+                                               $min_distance = $distance;
+                                       }
                                } else if ($distance < $min_distance) {
                                        $candidates = [$guess];
                                        $min_distance = $distance;
@@ -131,6 +149,14 @@ class Channel extends Model
                return false;
        }
 
+       public function listAnd($entries) {
+               $lang = empty($this->languages) ? 'en' : $this->languages[0];
+               if ($lang == 'de') {
+                       return Arr::join($entries, ', ', ' und ');
+               }
+               return Arr::join($entries, ', ', ' and ');
+       }
+
        public function crews() {
                return $this->hasMany(ChannelCrew::class);
        }
@@ -149,6 +175,10 @@ class Channel extends Model
                return $this->belongsTo(Organization::class);
        }
 
+       public function winners() {
+               return $this->hasMany(GuessingWinner::class);
+       }
+
        protected $casts = [
                'chat' => 'boolean',
                'chat_commands' => 'array',