From b44d89e240ec1bc45878e92289e206ee31428ba4 Mon Sep 17 00:00:00 2001
From: Daniel Karbach <daniel.karbach@localhorst.tv>
Date: Sat, 12 Jul 2025 15:03:13 +0200
Subject: [PATCH] store step ladder mode

---
 app/Console/Commands/SyncStepLadder.php       |  1 +
 app/Console/Commands/SyncStepLadderFull.php   |  1 +
 app/Models/Episode.php                        |  4 +++
 .../2025_07_12_124515_episode_ladder_mode.php | 26 +++++++++++++++++++
 4 files changed, 32 insertions(+)
 create mode 100644 database/migrations/2025_07_12_124515_episode_ladder_mode.php

diff --git a/app/Console/Commands/SyncStepLadder.php b/app/Console/Commands/SyncStepLadder.php
index b44b843..07afe81 100644
--- a/app/Console/Commands/SyncStepLadder.php
+++ b/app/Console/Commands/SyncStepLadder.php
@@ -71,6 +71,7 @@ class SyncStepLadder extends Command {
 		}
 		$mode = $this->getMode($ladderEntry);
 		$episode->event()->associate($event);
+		$episode->stepLadderMode()->associate($mode);
 		$episode->title = $mode->name;
 		$episode->start = Carbon::createFromTimestamp($ladderEntry['time']);
 		$episode->estimate = 2 * 60 * 60;
diff --git a/app/Console/Commands/SyncStepLadderFull.php b/app/Console/Commands/SyncStepLadderFull.php
index a81033f..6cef974 100644
--- a/app/Console/Commands/SyncStepLadderFull.php
+++ b/app/Console/Commands/SyncStepLadderFull.php
@@ -71,6 +71,7 @@ class SyncStepLadderFull extends Command {
 		}
 		$mode = $this->getMode($ladderEntry);
 		$episode->event()->associate($event);
+		$episode->stepLadderMode()->associate($mode);
 		$episode->title = $mode->name;
 		$episode->start = Carbon::createFromFormat('Y-m-d H:i:s', $ladderEntry['time'], 'America/Detroit')->setTimezone('UTC');
 		$episode->estimate = 2 * 60 * 60;
diff --git a/app/Models/Episode.php b/app/Models/Episode.php
index 4eb8a57..df7c802 100644
--- a/app/Models/Episode.php
+++ b/app/Models/Episode.php
@@ -40,6 +40,10 @@ class Episode extends Model
 		return $this->hasMany(EpisodePlayer::class);
 	}
 
+	public function stepLadderMode() {
+		return $this->belongsTo(StepLadderMode::class);
+	}
+
 	public function getScheduledEventName(): string {
 		$parts = [];
 		if (count($this->players) == 4) {
diff --git a/database/migrations/2025_07_12_124515_episode_ladder_mode.php b/database/migrations/2025_07_12_124515_episode_ladder_mode.php
new file mode 100644
index 0000000..0ece256
--- /dev/null
+++ b/database/migrations/2025_07_12_124515_episode_ladder_mode.php
@@ -0,0 +1,26 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+	/**
+	 * Run the migrations.
+	 */
+	public function up(): void {
+		Schema::table('episodes', function (Blueprint $table) {
+			$table->foreignId('step_ladder_mode_id')->nullable()->default(null)->constrained();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 */
+	public function down(): void {
+		Schema::table('episodes', function (Blueprint $table) {
+			$table->dropColumn('step_ladder_mode_id');
+		});
+	}
+};
-- 
2.39.5