chat bot protocol ui

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

diff --git a/app/Models/Channel.php b/app/Models/Channel.php
index 8debe4f9434ab554d70eb5e16086bf875ed1875e..8af6a7d43e201e191651a4ab9b28fc7c11642ec5 100644 (file)
--- a/app/Models/Channel.php
+++ b/app/Models/Channel.php
@@ -31,8 +31,57 @@ class Channel extends Model {
                        ->first();
        }
 
+       public function randomOfClass($class) {
+               return $this->queryChatlog()
+                       ->where('classification', '=', $class)
+                       ->first();
+       }
+
+       public function queryChatlog() {
+               return ChatLog::where('type', '=', 'chat')
+                       ->where('banned', '=', false)
+                       ->where('created_at', '<', now()->sub(1, 'day'))
+                       ->where(function ($query) {
+                               $query->whereNull('detected_language');
+                               $query->orWhereIn('detected_language', $this->getPreferredLanguages());
+                       })
+                       ->inRandomOrder();
+       }
+
+       public function getPreferredLanguages() {
+               $setting = $this->getChatSetting('language');
+               if ($setting) {
+                       return [$setting];
+               }
+               if (!empty($this->languages)) {
+                       return $this->languages;
+               }
+               return ['de'];
+       }
+
+       public function getChatSetting($name, $default = null) {
+               if (array_key_exists($name, $this->chat_settings)) {
+                       return $this->chat_settings[$name];
+               }
+               return $default;
+       }
+
        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')
+                       ->where('score', '!=', 0)
+                       ->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() {
@@ -119,23 +168,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);
@@ -146,13 +205,33 @@ 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') {
@@ -161,6 +240,10 @@ class Channel extends Model {
                return Arr::join($entries, ', ', ' and ');
        }
 
+       public function chat_bot_logs() {
+               return $this->hasMany(ChatBotLog::class);
+       }
+
        public function crews() {
                return $this->hasMany(ChannelCrew::class);
        }