1 files changed, 0 insertions, 161 deletions
diff --git a/app/Model/SubtaskHistory.php b/app/Model/SubtaskHistory.php
deleted file mode 100644
index 89076261..00000000
--- a/app/Model/SubtaskHistory.php
+++ /dev/null
@@ -1,161 +0,0 @@
-<?php
-
-namespace Model;
-
-use PDO;
-use Core\Registry;
-use Event\SubtaskHistoryListener;
-
-/**
- * Comment history model
- *
- * @package  model
- * @author   Frederic Guillot
- */
-class SubtaskHistory extends BaseHistory
-{
-    /**
-     * SQL table name
-     *
-     * @var string
-     */
-    const TABLE = 'subtask_has_events';
-
-    /**
-     * Maximum number of events
-     *
-     * @var integer
-     */
-    const MAX_EVENTS = 5000;
-
-    /**
-     * Constructor
-     *
-     * @access public
-     * @param  \Core\Registry  $registry  Registry instance
-     */
-    public function __construct(Registry $registry)
-    {
-        parent::__construct($registry);
-        $this->table = self::TABLE;
-    }
-
-    /**
-     * Create a new event
-     *
-     * @access public
-     * @param  integer   $project_id    Project id
-     * @param  integer   $task_id       Task id
-     * @param  integer   $subtask_id    Subtask id
-     * @param  integer   $creator_id    Author of the event (user id)
-     * @param  string    $event_name    Task event name
-     * @param  string    $data          Current comment
-     * @return boolean
-     */
-    public function create($project_id, $task_id, $subtask_id, $creator_id, $event_name, $data)
-    {
-        $values = array(
-            'project_id' => $project_id,
-            'task_id' => $task_id,
-            'subtask_id' => $subtask_id,
-            'creator_id' => $creator_id,
-            'event_name' => $event_name,
-            'date_creation' => time(),
-            'data' => $data,
-        );
-
-        $this->db->startTransaction();
-
-        $this->cleanup(self::MAX_EVENTS - 1);
-        $result = $this->db->table(self::TABLE)->insert($values);
-
-        $this->db->closeTransaction();
-
-        return $result;
-    }
-
-    /**
-     * Get all necessary content to display activity feed
-     *
-     * $author_name
-     * $author_username
-     * $task['id', 'title', 'position', 'column_name']
-     */
-    public function getAllContentByProjectId($project_id, $limit = 50)
-    {
-        $sql = '
-            SELECT
-                subtask_has_events.id,
-                subtask_has_events.date_creation,
-                subtask_has_events.event_name,
-                subtask_has_events.task_id,
-                tasks.title as task_title,
-                users.username as author_username,
-                users.name as author_name,
-                assignees.name as subtask_assignee_name,
-                assignees.username as subtask_assignee_username,
-                task_has_subtasks.title as subtask_title,
-                task_has_subtasks.status as subtask_status,
-                task_has_subtasks.time_spent as subtask_time_spent,
-                task_has_subtasks.time_estimated as subtask_time_estimated
-            FROM subtask_has_events
-            LEFT JOIN users ON users.id=subtask_has_events.creator_id
-            LEFT JOIN tasks ON tasks.id=subtask_has_events.task_id
-            LEFT JOIN task_has_subtasks ON task_has_subtasks.id=subtask_has_events.subtask_id
-            LEFT JOIN users AS assignees ON assignees.id=task_has_subtasks.user_id
-            WHERE subtask_has_events.project_id = ?
-            ORDER BY subtask_has_events.id DESC
-            LIMIT '.$limit.' OFFSET 0
-        ';
-
-        $rq = $this->db->execute($sql, array($project_id));
-        $events = $rq->fetchAll(PDO::FETCH_ASSOC);
-
-        foreach ($events as &$event) {
-            $event['author'] = $event['author_name'] ?: $event['author_username'];
-            $event['subtask_assignee'] = $event['subtask_assignee_name'] ?: $event['subtask_assignee_username'];
-            $event['subtask_status_list'] = $this->subTask->getStatusList();
-            $event['event_title'] = $this->getTitle($event);
-            $event['event_content'] = $this->getContent($event);
-            $event['event_type'] = 'subtask';
-        }
-
-        return $events;
-    }
-
-    /**
-     * Get the event title (translated)
-     *
-     * @access public
-     * @param  array     $event    Event properties
-     * @return string
-     */
-    public function getTitle(array $event)
-    {
-        $titles = array(
-            SubTask::EVENT_UPDATE => t('%s updated a subtask for the task #%d', $event['author'], $event['task_id']),
-            SubTask::EVENT_CREATE => t('%s created a subtask for the task #%d', $event['author'], $event['task_id']),
-        );
-
-        return isset($titles[$event['event_name']]) ? $titles[$event['event_name']] : '';
-    }
-
-    /**
-     * Attach events to be able to record the history
-     *
-     * @access public
-     */
-    public function attachEvents()
-    {
-        $events = array(
-            SubTask::EVENT_UPDATE,
-            SubTask::EVENT_CREATE,
-        );
-
-        $listener = new SubtaskHistoryListener($this);
-
-        foreach ($events as $event_name) {
-            $this->event->attach($event_name, $listener);
-        }
-    }
-}