WIP event filter

[alttp.git] / app / Console / Commands / SyncSpeedGaming.php

diff --git a/app/Console/Commands/SyncSpeedGaming.php b/app/Console/Commands/SyncSpeedGaming.php
index eaaa4fa48e7ccb5989d0c4ca29218ed3c80857c5..c2fa36820af063ed59cc6f62482f4e2e129ae49e 100644 (file)
--- a/app/Console/Commands/SyncSpeedGaming.php
+++ b/app/Console/Commands/SyncSpeedGaming.php
@@ -87,6 +87,8 @@ class SyncSpeedGaming extends Command {
                        ->where('start', '<=', $to)
                        ->whereNotIn('ext_id', $ext_ids);
                foreach ($to_purge->get() as $episode) {
+                       $episode->channels()->detach();
+                       $episode->crew()->delete();
                        $episode->players()->delete();
                }
                $to_purge->delete();
@@ -176,10 +178,13 @@ class SyncSpeedGaming extends Command {
                foreach ($sgEntry['channels'] as $sgChannel) {
                        $ext_ids[] = 'sg:'.$sgChannel['id'];
                }
-               $episode->channels()
-                 ->where('ext_id', 'LIKE', 'sg:%')
-                 ->whereNotIn('ext_id', $ext_ids)
-                 ->detach();
+               $channels = $episode->channels()
+                       ->where('ext_id', 'LIKE', 'sg:%')
+                       ->whereNotIn('ext_id', $ext_ids)
+                       ->get();
+               if (!$channels->isEmpty()) {
+                       $episode->channels()->detach($channels->pluck('id'));
+               }
        }
 
        private function syncChannel(Episode $episode, $sgChannel) {
@@ -278,6 +283,9 @@ class SyncSpeedGaming extends Command {
                if ($channel) {
                        return $channel;
                }
+               return $episode->channels()
+                 ->where('ext_id', 'LIKE', 'sg:%')
+                 ->first();
        }
 
        private function getUserBySGPlayer($player) {