send new request mails to more users with resource permissions, added RESOURCES_DISABLE_MAIL_ON_NEW_REQUEST personal configtic-05810

1 files changed, 36 insertions, 0 deletions

diff --git a/db/migrations/6.2.6.1_add_disable_mail_on_new_request_config.php b/db/migrations/6.2.6.1_add_disable_mail_on_new_request_config.php
new file mode 100644
index 0000000..1fa322e
--- /dev/null
+++ b/db/migrations/6.2.6.1_add_disable_mail_on_new_request_config.php
@@ -0,0 +1,36 @@
+<?php
+
+
+class AddDisableMailOnNewRequestConfig extends Migration
+{
+    public function description()
+    {
+        return 'Adds the personal configuration RESOURCES_DISABLE_MAIL_ON_NEW_REQUEST.';
+    }
+
+    protected function up()
+    {
+        $db = DBManager::get();
+        $db->exec(
+            "INSERT INTO `config`
+            (`field`, `value`, `type`, `range`, `section`, `mkdate`, `chdate`, `description`)
+            VALUES
+            ('RESOURCES_DISABLE_MAIL_ON_NEW_REQUEST', '0', 'boolean', 'user', 'resources',
+            UNIX_TIMESTAMP(), UNIX_TIMESTAMP(),
+            'Schaltet den Versand von Mails bei neuen Raumanfragen aus.')"
+        );
+    }
+
+    protected function down()
+    {
+        $db = DBManager::get();
+        $db->exec(
+            "DELETE FROM `config_values`
+            WHERE `field` = 'RESOURCES_DISABLE_MAIL_ON_NEW_REQUEST'"
+        );
+        $db->exec(
+            "DELETE FROM `config`
+            WHERE `field` = 'RESOURCES_DISABLE_MAIL_ON_NEW_REQUEST'"
+        );
+    }
+}