fixes #549: fill missing arrival dates and prevent setting arrival by admin-user instead of admin-arrive

1 files changed, 27 insertions, 0 deletions

diff --git a/db/migrations/2018_12_27_000000_fix_missing_arrival_dates.php b/db/migrations/2018_12_27_000000_fix_missing_arrival_dates.php
new file mode 100644
index 00000000..b932158c
--- /dev/null
+++ b/db/migrations/2018_12_27_000000_fix_missing_arrival_dates.php
@@ -0,0 +1,27 @@
+<?php
+
+namespace Engelsystem\Migrations;
+
+use Engelsystem\Database\Migration\Migration;
+use Engelsystem\Models\User\State;
+
+class FixMissingArrivalDates extends Migration
+{
+    /**
+     * Run the migration
+     */
+    public function up()
+    {
+        $states = State::whereArrived(true)->whereArrivalDate(null)->get();
+        foreach($states as $state) {
+            $state->arrival_date = $state->user->personalData->planned_arrival_date;
+            $state->save();
+        }
+    }
+
+    /**
+     * Down is not possible and not needed since this is a bugfix.
+     */
+    public function down()
+    {}
+}