summaryrefslogtreecommitdiff
path: root/app/Model/TaskLink.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Model/TaskLink.php')
-rw-r--r--app/Model/TaskLink.php265
1 files changed, 0 insertions, 265 deletions
diff --git a/app/Model/TaskLink.php b/app/Model/TaskLink.php
deleted file mode 100644
index 9c5b3ca3..00000000
--- a/app/Model/TaskLink.php
+++ /dev/null
@@ -1,265 +0,0 @@
-<?php
-
-namespace Kanboard\Model;
-
-use Kanboard\Core\Base;
-use Kanboard\Event\TaskLinkEvent;
-
-/**
- * TaskLink model
- *
- * @package model
- * @author Olivier Maridat
- * @author Frederic Guillot
- */
-class TaskLink extends Base
-{
- /**
- * SQL table name
- *
- * @var string
- */
- const TABLE = 'task_has_links';
-
- /**
- * Events
- *
- * @var string
- */
- const EVENT_CREATE_UPDATE = 'tasklink.create_update';
-
- /**
- * Get a task link
- *
- * @access public
- * @param integer $task_link_id Task link id
- * @return array
- */
- public function getById($task_link_id)
- {
- return $this->db->table(self::TABLE)->eq('id', $task_link_id)->findOne();
- }
-
- /**
- * Get the opposite task link (use the unique index task_has_links_unique)
- *
- * @access public
- * @param array $task_link
- * @return array
- */
- public function getOppositeTaskLink(array $task_link)
- {
- $opposite_link_id = $this->link->getOppositeLinkId($task_link['link_id']);
-
- return $this->db->table(self::TABLE)
- ->eq('opposite_task_id', $task_link['task_id'])
- ->eq('task_id', $task_link['opposite_task_id'])
- ->eq('link_id', $opposite_link_id)
- ->findOne();
- }
-
- /**
- * Get all links attached to a task
- *
- * @access public
- * @param integer $task_id Task id
- * @return array
- */
- public function getAll($task_id)
- {
- return $this->db
- ->table(self::TABLE)
- ->columns(
- self::TABLE.'.id',
- self::TABLE.'.opposite_task_id AS task_id',
- Link::TABLE.'.label',
- Task::TABLE.'.title',
- Task::TABLE.'.is_active',
- Task::TABLE.'.project_id',
- Task::TABLE.'.column_id',
- Task::TABLE.'.color_id',
- Task::TABLE.'.time_spent AS task_time_spent',
- Task::TABLE.'.time_estimated AS task_time_estimated',
- Task::TABLE.'.owner_id AS task_assignee_id',
- User::TABLE.'.username AS task_assignee_username',
- User::TABLE.'.name AS task_assignee_name',
- Column::TABLE.'.title AS column_title',
- Project::TABLE.'.name AS project_name'
- )
- ->eq(self::TABLE.'.task_id', $task_id)
- ->join(Link::TABLE, 'id', 'link_id')
- ->join(Task::TABLE, 'id', 'opposite_task_id')
- ->join(Column::TABLE, 'id', 'column_id', Task::TABLE)
- ->join(User::TABLE, 'id', 'owner_id', Task::TABLE)
- ->join(Project::TABLE, 'id', 'project_id', Task::TABLE)
- ->asc(Link::TABLE.'.id')
- ->desc(Column::TABLE.'.position')
- ->desc(Task::TABLE.'.is_active')
- ->asc(Task::TABLE.'.position')
- ->asc(Task::TABLE.'.id')
- ->findAll();
- }
-
- /**
- * Get all links attached to a task grouped by label
- *
- * @access public
- * @param integer $task_id Task id
- * @return array
- */
- public function getAllGroupedByLabel($task_id)
- {
- $links = $this->getAll($task_id);
- $result = array();
-
- foreach ($links as $link) {
- if (! isset($result[$link['label']])) {
- $result[$link['label']] = array();
- }
-
- $result[$link['label']][] = $link;
- }
-
- return $result;
- }
-
- /**
- * Publish events
- *
- * @access private
- * @param array $events
- */
- private function fireEvents(array $events)
- {
- foreach ($events as $event) {
- $event['project_id'] = $this->taskFinder->getProjectId($event['task_id']);
- $this->container['dispatcher']->dispatch(self::EVENT_CREATE_UPDATE, new TaskLinkEvent($event));
- }
- }
-
- /**
- * Create a new link
- *
- * @access public
- * @param integer $task_id Task id
- * @param integer $opposite_task_id Opposite task id
- * @param integer $link_id Link id
- * @return integer Task link id
- */
- public function create($task_id, $opposite_task_id, $link_id)
- {
- $events = array();
- $this->db->startTransaction();
-
- // Get opposite link
- $opposite_link_id = $this->link->getOppositeLinkId($link_id);
-
- $values = array(
- 'task_id' => $task_id,
- 'opposite_task_id' => $opposite_task_id,
- 'link_id' => $link_id,
- );
-
- // Create the original task link
- $this->db->table(self::TABLE)->insert($values);
- $task_link_id = $this->db->getLastId();
- $events[] = $values;
-
- // Create the opposite task link
- $values = array(
- 'task_id' => $opposite_task_id,
- 'opposite_task_id' => $task_id,
- 'link_id' => $opposite_link_id,
- );
-
- $this->db->table(self::TABLE)->insert($values);
- $events[] = $values;
-
- $this->db->closeTransaction();
-
- $this->fireEvents($events);
-
- return (int) $task_link_id;
- }
-
- /**
- * Update a task link
- *
- * @access public
- * @param integer $task_link_id Task link id
- * @param integer $task_id Task id
- * @param integer $opposite_task_id Opposite task id
- * @param integer $link_id Link id
- * @return boolean
- */
- public function update($task_link_id, $task_id, $opposite_task_id, $link_id)
- {
- $events = array();
- $this->db->startTransaction();
-
- // Get original task link
- $task_link = $this->getById($task_link_id);
-
- // Find opposite task link
- $opposite_task_link = $this->getOppositeTaskLink($task_link);
-
- // Get opposite link
- $opposite_link_id = $this->link->getOppositeLinkId($link_id);
-
- // Update the original task link
- $values = array(
- 'task_id' => $task_id,
- 'opposite_task_id' => $opposite_task_id,
- 'link_id' => $link_id,
- );
-
- $rs1 = $this->db->table(self::TABLE)->eq('id', $task_link_id)->update($values);
- $events[] = $values;
-
- // Update the opposite link
- $values = array(
- 'task_id' => $opposite_task_id,
- 'opposite_task_id' => $task_id,
- 'link_id' => $opposite_link_id,
- );
-
- $rs2 = $this->db->table(self::TABLE)->eq('id', $opposite_task_link['id'])->update($values);
- $events[] = $values;
-
- $this->db->closeTransaction();
-
- if ($rs1 && $rs2) {
- $this->fireEvents($events);
- return true;
- }
-
- return false;
- }
-
- /**
- * Remove a link between two tasks
- *
- * @access public
- * @param integer $task_link_id
- * @return boolean
- */
- public function remove($task_link_id)
- {
- $this->db->startTransaction();
-
- $link = $this->getById($task_link_id);
- $link_id = $this->link->getOppositeLinkId($link['link_id']);
-
- $this->db->table(self::TABLE)->eq('id', $task_link_id)->remove();
-
- $this->db
- ->table(self::TABLE)
- ->eq('opposite_task_id', $link['task_id'])
- ->eq('task_id', $link['opposite_task_id'])
- ->eq('link_id', $link_id)->remove();
-
- $this->db->closeTransaction();
-
- return true;
- }
-}
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-26 23:32:18 +0000