Resolve "Widget Aktiver Prozesse"

Closes #5675

Merge request studip/studip!4299

1 files changed, 16 insertions, 0 deletions

diff --git a/db/migrations/6.2.4_step5675_running_processes_widget.php b/db/migrations/6.2.4_step5675_running_processes_widget.php
new file mode 100644
index 0000000..a68dcb8
--- /dev/null
+++ b/db/migrations/6.2.4_step5675_running_processes_widget.php
@@ -0,0 +1,16 @@
+<?php
+
+class Step5675RunningProcessesWidget extends Migration
+{
+    protected function up()
+    {
+        $pos = DBManager::get()->fetchColumn("SELECT MAX(navigationpos) + 1 FROM plugins WHERE plugintype = 'PortalPlugin'");
+        $sql = "INSERT INTO plugins (pluginclassname, pluginname, plugintype, enabled, navigationpos) VALUES (?)";
+        DBManager::get()->execute($sql, [['RunningProcessesWidget', 'RunningProcessesWidget', 'PortalPlugin', 'yes', $pos]]);
+
+        $sql = "INSERT INTO roles_plugins (roleid, pluginid)
+                SELECT roleid, ? FROM roles WHERE `system` = 'y' AND rolename != 'Nobody'";
+        DBManager::get()->execute($sql, [DBManager::get()->lastInsertId()]);
+    }
+
+}