Resolve "check_admission Cronjob kaputt"

Closes #5269

Merge request studip/studip!4037

1 files changed, 40 insertions, 0 deletions

diff --git a/db/migrations/6.0.45_add_userfilter_namespaces.php b/db/migrations/6.0.45_add_userfilter_namespaces.php
new file mode 100644
index 0000000..bb6de8e
--- /dev/null
+++ b/db/migrations/6.0.45_add_userfilter_namespaces.php
@@ -0,0 +1,40 @@
+<?php
+
+/**
+ * Adds namespace values to UserFilter database entries that already existed pre-6.0.
+ */
+final class AddUserfilterNamespaces extends Migration
+{
+
+    public function description()
+    {
+        return 'Add namesspaces to existing UserFilter database entries';
+    }
+
+    public function up()
+    {
+        $types = [
+            'DegreeCondition',
+            'PermissionCondition',
+            'SemesterOfStudyCondition',
+            'StgteilVersionCondition',
+            'SubjectCondition',
+            'SubjectConditionAny'
+        ];
+
+        DBManager::get()->execute(
+            "UPDATE `userfilter_fields`
+             SET `type` = CONCAT('UserFilterFields\\\', `type`)
+             WHERE `type` IN (:types)",
+            ['types' => $types]
+        );
+
+        // Special handling for datafield entries which have an ID appended to the type name:
+        DBManager::get()->execute(
+            "UPDATE `userfilter_fields`
+             SET `type` = CONCAT('UserFilterFields\\\', `type`)
+             WHERE `type` LIKE :type",
+            ['type' => 'DatafieldCondition_%']
+        );
+    }
+}