From cc1b7d748b05c2ec87f4f57210882d2f62d6b5bc Mon Sep 17 00:00:00 2001
From: Daniel Karbach <daniel.karbach@localhorst.tv>
Date: Sat, 29 Nov 2025 12:53:07 +0100
Subject: [PATCH] result changes recalculation

---
 .../Commands/RecalculateResultChanges.php     | 41 +++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100644 app/Console/Commands/RecalculateResultChanges.php

diff --git a/app/Console/Commands/RecalculateResultChanges.php b/app/Console/Commands/RecalculateResultChanges.php
new file mode 100644
index 0000000..71061a5
--- /dev/null
+++ b/app/Console/Commands/RecalculateResultChanges.php
@@ -0,0 +1,41 @@
+<?php
+
+namespace App\Console\Commands;
+
+use App\Models\Result;
+use Illuminate\Console\Command;
+
+class RecalculateResultChanges extends Command
+{
+	/**
+	 * The name and signature of the console command.
+	 *
+	 * @var string
+	 */
+	protected $signature = 'result:recalc-changes';
+
+	/**
+	 * The console command description.
+	 *
+	 * @var string
+	 */
+	protected $description = 'Command description';
+
+	/**
+	 * Execute the console command.
+	 */
+	public function handle()
+	{
+		$results = Result::all();
+		foreach ($results as $result) {
+			$reports = $result->round->protocols()
+				->where('type', '=', 'result.report')
+				->where('user_id', '=', $result->user_id)
+				->count();
+			if ($reports > 1) {
+				$result->changed = $reports - 1;
+				$result->save();
+			}
+		}
+	}
+}
-- 
2.47.3