1 files changed, 162 insertions, 0 deletions
diff --git a/models/project.php b/models/project.php
new file mode 100644
index 00000000..7a0fb2b1
--- /dev/null
+++ b/models/project.php
@@ -0,0 +1,162 @@
+<?php
+
+namespace Model;
+
+use \SimpleValidator\Validator;
+use \SimpleValidator\Validators;
+
+class Project extends Base
+{
+    const TABLE = 'projects';
+    const ACTIVE = 1;
+    const INACTIVE = 0;
+
+    public function get($project_id)
+    {
+        return $this->db->table(self::TABLE)->eq('id', $project_id)->findOne();
+    }
+
+    public function getAll($fetch_stats = false)
+    {
+        if (! $fetch_stats) {
+            return $this->db->table(self::TABLE)->asc('name')->findAll();
+        }
+
+        $this->db->startTransaction();
+
+        $projects = $this->db
+                        ->table(self::TABLE)
+                        ->asc('name')
+                        ->findAll();
+
+        $taskModel = new \Model\Task;
+        $boardModel = new \Model\Board;
+
+        foreach ($projects as &$project) {
+
+            $columns = $boardModel->getcolumns($project['id']);
+            $project['nb_active_tasks'] = 0;
+
+            foreach ($columns as &$column) {
+                $column['nb_active_tasks'] = $taskModel->countByColumnId($project['id'], $column['id']);
+                $project['nb_active_tasks'] += $column['nb_active_tasks'];
+            }
+
+            $project['columns'] = $columns;
+            $project['nb_tasks'] = $taskModel->countByProjectId($project['id']);
+        }
+
+        $this->db->closeTransaction();
+
+        return $projects;
+    }
+
+    public function getList()
+    {
+        return array(t('None')) + $this->db->table(self::TABLE)->asc('name')->listing('id', 'name');
+    }
+
+    public function getAllByStatus($status)
+    {
+        return $this->db
+                    ->table(self::TABLE)
+                    ->asc('name')
+                    ->eq('is_active', $status)
+                    ->findAll();
+    }
+
+    public function getListByStatus($status)
+    {
+        return $this->db
+                    ->table(self::TABLE)
+                    ->asc('name')
+                    ->eq('is_active', $status)
+                    ->listing('id', 'name');
+    }
+
+    public function countByStatus($status)
+    {
+        return $this->db
+                    ->table(self::TABLE)
+                    ->eq('is_active', $status)
+                    ->count();
+    }
+
+    public function create(array $values)
+    {
+        $this->db->startTransaction();
+
+        $this->db->table(self::TABLE)->save($values);
+
+        $project_id = $this->db->getConnection()->getLastId();
+
+        $boardModel = new \Model\Board;
+
+        $boardModel->create($project_id, array(
+            t('Backlog'),
+            t('Ready'),
+            t('Work in progress'),
+            t('Done'),
+        ));
+
+        $this->db->closeTransaction();
+
+        return $project_id;
+    }
+
+    public function update(array $values)
+    {
+        return $this->db->table(self::TABLE)->eq('id', $values['id'])->save($values);
+    }
+
+    public function remove($project_id)
+    {
+        return $this->db->table(self::TABLE)->eq('id', $project_id)->remove();
+    }
+
+    public function enable($project_id)
+    {
+        return $this->db
+                    ->table(self::TABLE)
+                    ->eq('id', $project_id)
+                    ->save(array('is_active' => 1));
+    }
+
+    public function disable($project_id)
+    {
+        return $this->db
+                    ->table(self::TABLE)
+                    ->eq('id', $project_id)
+                    ->save(array('is_active' => 0));
+    }
+
+    public function validateCreation(array $values)
+    {
+        $v = new Validator($values, array(
+            new Validators\Required('name', t('The project name is required')),
+            new Validators\MaxLength('name', t('The maximum length is %d characters', 50), 50),
+            new Validators\Unique('name', t('This project must be unique'), $this->db->getConnection(), self::TABLE)
+        ));
+
+        return array(
+            $v->execute(),
+            $v->getErrors()
+        );
+    }
+
+    public function validateModification(array $values)
+    {
+        $v = new Validator($values, array(
+            new Validators\Required('id', t('The project id is required')),
+            new Validators\Integer('id', t('This value must be an integer')),
+            new Validators\Required('name', t('The project name is required')),
+            new Validators\MaxLength('name', t('The maximum length is %d characters', 50), 50),
+            new Validators\Unique('name', t('This project must be unique'), $this->db->getConnection(), self::TABLE)
+        ));
+
+        return array(
+            $v->execute(),
+            $v->getErrors()
+        );
+    }
+}