X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FModels%2FChannel.php;h=8af6a7d43e201e191651a4ab9b28fc7c11642ec5;hb=147c5f43c5d41fa18e82edb6651fe5a37c789353;hp=edc2ba8664be682bc3638fbb16e485b905ca55a1;hpb=0b25d0e8a22a13f09efbeab94d0b353ae603bc16;p=alttp.git

diff --git a/app/Models/Channel.php b/app/Models/Channel.php
index edc2ba8..8af6a7d 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))
@@ -16,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() {
@@ -70,6 +134,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 +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);
@@ -128,13 +205,45 @@ 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 chat_bot_logs() {
+		return $this->hasMany(ChatBotLog::class);
+	}
+
 	public function crews() {
 		return $this->hasMany(ChannelCrew::class);
 	}
@@ -161,16 +270,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',
 	];