From 648dc6bcfbdd44947ec58e2f3662c1cc3844d782 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Thu, 2 Nov 2017 15:41:58 -0700
Subject: Add predefined templates for task descriptions

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

(limited to 'app/Model')

diff --git a/app/Model/PredefinedTaskDescriptionModel.php b/app/Model/PredefinedTaskDescriptionModel.php
new file mode 100644
index 00000000..7b8e6de2
--- /dev/null
+++ b/app/Model/PredefinedTaskDescriptionModel.php
@@ -0,0 +1,42 @@
+<?php
+
+namespace Kanboard\Model;
+
+use Kanboard\Core\Base;
+
+class PredefinedTaskDescriptionModel extends Base
+{
+    const TABLE = 'predefined_task_descriptions';
+
+    public function getAll($projectId)
+    {
+        return $this->db->table(self::TABLE)->eq('project_id', $projectId)->findAll();
+    }
+
+    public function getById($projectId, $id)
+    {
+        return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->findOne();
+    }
+
+    public function create($projectId, $title, $description)
+    {
+        return $this->db->table(self::TABLE)->persist(array(
+            'project_id' => $projectId,
+            'title' => $title,
+            'description' => $description,
+        ));
+    }
+
+    public function update($projectId, $id, $title, $description)
+    {
+        return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->update(array(
+            'title' => $title,
+            'description' => $description,
+        ));
+    }
+
+    public function remove($projectId, $id)
+    {
+        return $this->db->table(self::TABLE)->eq('project_id', $projectId)->eq('id', $id)->remove();
+    }
+}
-- 
cgit v1.2.3