X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=app%2FConsole%2FCommands%2FGuessingClean.php;fp=app%2FConsole%2FCommands%2FGuessingClean.php;h=d26b3e92f37952c971a5c67e275fa27ab9c71054;hb=6977dce178bc418e365b4a013d5798ac8e9e1595;hp=0000000000000000000000000000000000000000;hpb=f4b38f9816492bbb3e2e6194c4248fdfca951f81;p=alttp.git

diff --git a/app/Console/Commands/GuessingClean.php b/app/Console/Commands/GuessingClean.php
new file mode 100644
index 0000000..d26b3e9
--- /dev/null
+++ b/app/Console/Commands/GuessingClean.php
@@ -0,0 +1,47 @@
+<?php
+
+namespace App\Console\Commands;
+
+use App\Models\Channel;
+use Illuminate\Console\Command;
+use Illuminate\Http\Client\RequestException;
+use Illuminate\Support\Facades\Http;
+
+class GuessingClean extends Command {
+
+	/**
+	 * The name and signature of the console command.
+	 *
+	 * @var string
+	 */
+	protected $signature = 'guessing:clean';
+
+	/**
+	 * The console command description.
+	 *
+	 * @var string
+	 */
+	protected $description = 'Cancel orphaned guessing games';
+
+	/**
+	 * Execute the console command.
+	 *
+	 * @return int
+	 */
+	public function handle()
+	{
+		$channels = Channel
+			::whereNotNull('guessing_start')
+			->where('guessing_start', '<', now()
+			->sub(4, 'hour'))
+			->get();
+		foreach ($channels as $channel) {
+			$this->line($channel->title);
+			$channel->guessing_start = null;
+			$channel->guessing_end = null;
+			$channel->save();
+		}
+		return Command::SUCCESS;
+	}
+
+}