From 9283fb88d80cb355ff98364a9a57b657fc511d98 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sat, 17 Oct 2015 15:27:43 -0400
Subject: Add metadata for users, tasks and projects

---
 app/Model/Setting.php | 96 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 96 insertions(+)
 create mode 100644 app/Model/Setting.php

(limited to 'app/Model/Setting.php')

diff --git a/app/Model/Setting.php b/app/Model/Setting.php
new file mode 100644
index 00000000..3507d424
--- /dev/null
+++ b/app/Model/Setting.php
@@ -0,0 +1,96 @@
+<?php
+
+namespace Kanboard\Model;
+
+/**
+ * Application Settings
+ *
+ * @package  model
+ * @author   Frederic Guillot
+ */
+abstract class Setting extends Base
+{
+    /**
+     * SQL table name
+     *
+     * @var string
+     */
+    const TABLE = 'settings';
+
+    /**
+     * Prepare data before save
+     *
+     * @abstract
+     * @access public
+     * @return array
+     */
+    abstract public function prepare(array $values);
+
+    /**
+     * Get all settings
+     *
+     * @access public
+     * @return array
+     */
+    public function getAll()
+    {
+        return $this->db->hashtable(self::TABLE)->getAll('option', 'value');
+    }
+
+    /**
+     * Get a setting value
+     *
+     * @access public
+     * @param  string   $name
+     * @param  string   $default
+     * @return mixed
+     */
+    public function getOption($name, $default = '')
+    {
+        return $this->db
+            ->table(self::TABLE)
+            ->eq('option', $name)
+            ->findOneColumn('value') ?: $default;
+    }
+
+    /**
+     * Return true if a setting exists
+     *
+     * @access public
+     * @param  string   $name
+     * @return boolean
+     */
+    public function exists($name)
+    {
+        return $this->db
+            ->table(self::TABLE)
+            ->eq('option', $name)
+            ->exists();
+    }
+
+    /**
+     * Update or insert new settings
+     *
+     * @access public
+     * @param  array    $values
+     */
+    public function save(array $values)
+    {
+        $results = array();
+        $values = $this->prepare($values);
+
+        $this->db->startTransaction();
+
+        foreach ($values as $option => $value) {
+            if ($this->exists($option)) {
+                $results[] = $this->db->table(self::TABLE)->eq('option', $option)->update(array('value' => $value));
+            } else {
+                $results[] = $this->db->table(self::TABLE)->insert(array('option' => $option, 'value' => $value));
+            }
+        }
+
+        $this->db->closeTransaction();
+
+        return ! in_array(false, $results, true);
+    }
+}
-- 
cgit v1.2.3