X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FModels%2FChannel.php;h=bf3b98bc2b231c384a3079613e551514a7435c02;hb=7649d12f400f164dd06f6a45486221234052dbb6;hp=edc2ba8664be682bc3638fbb16e485b905ca55a1;hpb=0b25d0e8a22a13f09efbeab94d0b353ae603bc16;p=alttp.git diff --git a/app/Models/Channel.php b/app/Models/Channel.php index edc2ba8..bf3b98b 100644 --- a/app/Models/Channel.php +++ b/app/Models/Channel.php @@ -2,13 +2,28 @@ namespace App\Models; +use Illuminate\Broadcasting\Channel as PublicChannel; +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), + ]; + if (!empty($this->access_key)) { + $channels[] = new PublicChannel('ChannelKey.'.$this->access_key); + } + return $channels; + } + public function getCurrentEpisode() { return $this->episodes() ->where('start', '<', now()->subMinutes(10)) @@ -17,7 +32,20 @@ class Channel extends Model } 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(); + $query = $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); + $type = $this->getGuessingSetting('leaderboard_type', 'all'); + if ($type == 'month') { + $query->where('created_at', '>=', now()->startOfMonth()); + } else if ($type == 'year') { + $query->where('created_at', '>=', now()->startOfYear()); + } else if (is_numeric($type)) { + $query->where('created_at', '>=', now()->sub($type, 'days')); + } + return $query->get(); } public function hasActiveGuessing() { @@ -70,6 +98,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; @@ -101,23 +132,33 @@ class Channel extends Model $this->save(); } + public function transformGuess($original) { + $transformed = trim($original); + if ($this->guessing_type == 'gtbk') { + $transformed = str_replace(['roodyo1Gtbigkey'], ['2'], $transformed); + $transformed = str_ireplace(['vier 4Head'], ['4'], $transformed); + } + return $transformed; + } + public function registerGuess($uid, $uname, $guess) { $model = new GuessingGuess(); $model->channel()->associate($this); $model->uid = $uid; $model->uname = $uname; - $model->guess = $guess; + $model->guess = $this->transformGuess($guess); $model->save(); } public function scoreGuessing($solution, $guess, $first) { - if ($guess == $solution) { + $transformed = $this->transformGuess($guess); + if ($transformed == $solution) { if ($first) { return $this->getGuessingSetting('points_exact_first', 1); } return $this->getGuessingSetting('points_exact_other', 1); } - $distance = abs(intval($guess) - intval($solution)); + $distance = abs(intval($transformed) - intval($solution)); if ($distance <= $this->getGuessingSetting('points_close_max', 3)) { if ($first) { return $this->getGuessingSetting('points_close_first', 1); @@ -128,13 +169,41 @@ class Channel extends Model } public function isValidGuess($solution) { + $transformed = $this->transformGuess($solution); if ($this->guessing_type == 'gtbk') { - $int_solution = intval($solution); - return $int_solution > 0 && $int_solution < 23; + $int_solution = intval($transformed); + return is_numeric($transformed) && $int_solution > 0 && $int_solution < 23; } return false; } + public function listGuessingWinners($winners) { + $names = []; + $distance = 0; + foreach ($winners as $winner) { + if ($winner->score > 0) { + $names[] = $winner->uname; + $distance = abs(intval($winner->guess) - intval($winner->solution)); + } + } + $msg = ''; + if (empty($names)) { + $msg = $this->getGuessingSetting('no_winners_message'); + } else { + $msg = $this->getGuessingSetting($distance ? 'close_winners_message' : 'winners_message', $this->getGuessingSetting('winners_message')); + $msg = str_replace(['{distance}', '{names}'], [$distance, $this->listAnd($names)], $msg); + } + return $msg; + } + + 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); } @@ -161,16 +230,23 @@ class Channel extends Model 'chat' => 'boolean', 'chat_commands' => 'array', 'chat_settings' => 'array', + 'guessing_end' => 'datetime', 'guessing_settings' => 'array', 'guessing_start' => 'datetime', - 'guessing_end' => 'datetime', 'languages' => 'array', 'join' => 'boolean', ]; protected $hidden = [ + 'access_key', + 'chat', + 'chat_commands', + 'chat_settings', 'created_at', 'ext_id', + 'guessing_settings', + 'join', + 'twitch_chat', 'updated_at', ];