summaryrefslogtreecommitdiff
path: root/app/Model/TaskHistory.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Model/TaskHistory.php')
-rw-r--r--app/Model/TaskHistory.php160
1 files changed, 0 insertions, 160 deletions
diff --git a/app/Model/TaskHistory.php b/app/Model/TaskHistory.php
deleted file mode 100644
index 0615cba0..00000000
--- a/app/Model/TaskHistory.php
+++ /dev/null
@@ -1,160 +0,0 @@
-<?php
-
-namespace Model;
-
-use PDO;
-use Core\Registry;
-use Event\TaskHistoryListener;
-
-/**
- * Task history model
- *
- * @package model
- * @author Frederic Guillot
- */
-class TaskHistory extends BaseHistory
-{
- /**
- * SQL table name
- *
- * @var string
- */
- const TABLE = 'task_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 $creator_id Author of the event (user id)
- * @param string $event_name Task event name
- * @return boolean
- */
- public function create($project_id, $task_id, $creator_id, $event_name)
- {
- $values = array(
- 'project_id' => $project_id,
- 'task_id' => $task_id,
- 'creator_id' => $creator_id,
- 'event_name' => $event_name,
- 'date_creation' => time(),
- );
-
- $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
- task_has_events.id,
- task_has_events.date_creation,
- task_has_events.event_name,
- task_has_events.task_id,
- tasks.title as task_title,
- tasks.position as task_position,
- columns.title as task_column_name,
- users.username as author_username,
- users.name as author_name
- FROM task_has_events
- LEFT JOIN users ON users.id=task_has_events.creator_id
- LEFT JOIN tasks ON tasks.id=task_has_events.task_id
- LEFT JOIN columns ON columns.id=tasks.column_id
- WHERE task_has_events.project_id = ?
- ORDER BY task_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['event_title'] = $this->getTitle($event);
- $event['event_content'] = $this->getContent($event);
- $event['event_type'] = 'task';
- }
-
- return $events;
- }
-
- /**
- * Get the event title (translated)
- *
- * @access public
- * @param array $event Event properties
- * @return string
- */
- public function getTitle(array $event)
- {
- $titles = array(
- Task::EVENT_ASSIGNEE_CHANGE => t('%s change the assignee of the task #%d', $event['author'], $event['task_id']),
- Task::EVENT_UPDATE => t('%s updated the task #%d', $event['author'], $event['task_id']),
- Task::EVENT_CREATE => t('%s created the task #%d', $event['author'], $event['task_id']),
- Task::EVENT_CLOSE => t('%s closed the task #%d', $event['author'], $event['task_id']),
- Task::EVENT_OPEN => t('%s open the task #%d', $event['author'], $event['task_id']),
- Task::EVENT_MOVE_COLUMN => t('%s moved the task #%d to the column "%s"', $event['author'], $event['task_id'], $event['task_column_name']),
- Task::EVENT_MOVE_POSITION => t('%s moved the task #%d to the position %d in the column "%s"', $event['author'], $event['task_id'], $event['task_position'], $event['task_column_name']),
- );
-
- 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(
- Task::EVENT_ASSIGNEE_CHANGE,
- Task::EVENT_UPDATE,
- Task::EVENT_CREATE,
- Task::EVENT_CLOSE,
- Task::EVENT_OPEN,
- Task::EVENT_MOVE_COLUMN,
- Task::EVENT_MOVE_POSITION,
- );
-
- $listener = new TaskHistoryListener($this);
-
- foreach ($events as $event_name) {
- $this->event->attach($event_name, $listener);
- }
- }
-}