Add category description (merge and modify pull-request #692)

1 files changed, 32 insertions, 0 deletions

diff --git a/app/Model/Category.php b/app/Model/Category.php
index 1c8ba96f..c8ba7251 100644
--- a/app/Model/Category.php
+++ b/app/Model/Category.php
@@ -74,6 +74,38 @@ class Category extends Base
     }
 
     /**
+     * Prepare categories to be displayed on the board
+     *
+     * @access public
+     * @param  integer   $project_id
+     * @return array
+     */
+    public function getBoardCategories($project_id)
+    {
+        $descriptions = array();
+
+        $listing = array(
+            -1 => t('All categories'),
+            0 => t('No category'),
+        );
+
+        $categories = $this->db->table(self::TABLE)
+                               ->eq('project_id', $project_id)
+                               ->asc('name')
+                               ->findAll();
+
+        foreach ($categories as $category) {
+            $listing[$category['id']] = $category['name'];
+            $descriptions[$category['id']] = $category['description'];
+        }
+
+        return array(
+            $listing,
+            $descriptions,
+        );
+    }
+
+    /**
      * Return the list of all categories
      *
      * @access public