Rename all models

1 files changed, 0 insertions, 476 deletions

diff --git a/app/Model/TaskFinder.php b/app/Model/TaskFinder.php
deleted file mode 100644
index fed3a580..00000000
--- a/app/Model/TaskFinder.php
+++ /dev/null
@@ -1,476 +0,0 @@
-<?php
-
-namespace Kanboard\Model;
-
-use PDO;
-use Kanboard\Core\Base;
-
-/**
- * Task Finder model
- *
- * @package  model
- * @author   Frederic Guillot
- */
-class TaskFinder extends Base
-{
-    /**
-     * Get query for project user overview
-     *
-     * @access public
-     * @param array    $project_ids
-     * @param integer  $is_active
-     * @return \PicoDb\Table
-     */
-    public function getProjectUserOverviewQuery(array $project_ids, $is_active)
-    {
-        if (empty($project_ids)) {
-            $project_ids = array(-1);
-        }
-
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->columns(
-                        Task::TABLE.'.id',
-                        Task::TABLE.'.title',
-                        Task::TABLE.'.date_due',
-                        Task::TABLE.'.date_started',
-                        Task::TABLE.'.project_id',
-                        Task::TABLE.'.color_id',
-                        Task::TABLE.'.priority',
-                        Task::TABLE.'.time_spent',
-                        Task::TABLE.'.time_estimated',
-                        Project::TABLE.'.name AS project_name',
-                        Column::TABLE.'.title AS column_name',
-                        User::TABLE.'.username AS assignee_username',
-                        User::TABLE.'.name AS assignee_name'
-                    )
-                    ->eq(Task::TABLE.'.is_active', $is_active)
-                    ->in(Project::TABLE.'.id', $project_ids)
-                    ->join(Project::TABLE, 'id', 'project_id')
-                    ->join(Column::TABLE, 'id', 'column_id', Task::TABLE)
-                    ->join(User::TABLE, 'id', 'owner_id', Task::TABLE);
-    }
-
-    /**
-     * Get query for assigned user tasks
-     *
-     * @access public
-     * @param  integer    $user_id       User id
-     * @return \PicoDb\Table
-     */
-    public function getUserQuery($user_id)
-    {
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->columns(
-                        'tasks.id',
-                        'tasks.title',
-                        'tasks.date_due',
-                        'tasks.date_creation',
-                        'tasks.project_id',
-                        'tasks.color_id',
-                        'tasks.priority',
-                        'tasks.time_spent',
-                        'tasks.time_estimated',
-                        'tasks.is_active',
-                        'tasks.creator_id',
-                        'projects.name AS project_name',
-                        'columns.title AS column_title'
-                    )
-                    ->join(Project::TABLE, 'id', 'project_id')
-                    ->join(Column::TABLE, 'id', 'column_id')
-                    ->eq(Task::TABLE.'.owner_id', $user_id)
-                    ->eq(Task::TABLE.'.is_active', Task::STATUS_OPEN)
-                    ->eq(Project::TABLE.'.is_active', Project::ACTIVE);
-    }
-
-    /**
-     * Extended query
-     *
-     * @access public
-     * @return \PicoDb\Table
-     */
-    public function getExtendedQuery()
-    {
-        return $this->db
-            ->table(Task::TABLE)
-            ->columns(
-                '(SELECT COUNT(*) FROM '.Comment::TABLE.' WHERE task_id=tasks.id) AS nb_comments',
-                '(SELECT COUNT(*) FROM '.TaskFile::TABLE.' WHERE task_id=tasks.id) AS nb_files',
-                '(SELECT COUNT(*) FROM '.Subtask::TABLE.' WHERE '.Subtask::TABLE.'.task_id=tasks.id) AS nb_subtasks',
-                '(SELECT COUNT(*) FROM '.Subtask::TABLE.' WHERE '.Subtask::TABLE.'.task_id=tasks.id AND status=2) AS nb_completed_subtasks',
-                '(SELECT COUNT(*) FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id) AS nb_links',
-                '(SELECT COUNT(*) FROM '.TaskExternalLink::TABLE.' WHERE '.TaskExternalLink::TABLE.'.task_id = tasks.id) AS nb_external_links',
-                '(SELECT DISTINCT 1 FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id AND '.TaskLink::TABLE.'.link_id = 9) AS is_milestone',
-                'tasks.id',
-                'tasks.reference',
-                'tasks.title',
-                'tasks.description',
-                'tasks.date_creation',
-                'tasks.date_modification',
-                'tasks.date_completed',
-                'tasks.date_started',
-                'tasks.date_due',
-                'tasks.color_id',
-                'tasks.project_id',
-                'tasks.column_id',
-                'tasks.swimlane_id',
-                'tasks.owner_id',
-                'tasks.creator_id',
-                'tasks.position',
-                'tasks.is_active',
-                'tasks.score',
-                'tasks.category_id',
-                'tasks.priority',
-                'tasks.date_moved',
-                'tasks.recurrence_status',
-                'tasks.recurrence_trigger',
-                'tasks.recurrence_factor',
-                'tasks.recurrence_timeframe',
-                'tasks.recurrence_basedate',
-                'tasks.recurrence_parent',
-                'tasks.recurrence_child',
-                'tasks.time_estimated',
-                'tasks.time_spent',
-                User::TABLE.'.username AS assignee_username',
-                User::TABLE.'.name AS assignee_name',
-                User::TABLE.'.email AS assignee_email',
-                User::TABLE.'.avatar_path AS assignee_avatar_path',
-                Category::TABLE.'.name AS category_name',
-                Category::TABLE.'.description AS category_description',
-                Column::TABLE.'.title AS column_name',
-                Column::TABLE.'.position AS column_position',
-                Swimlane::TABLE.'.name AS swimlane_name',
-                Project::TABLE.'.default_swimlane',
-                Project::TABLE.'.name AS project_name'
-            )
-            ->join(User::TABLE, 'id', 'owner_id', Task::TABLE)
-            ->left(User::TABLE, 'uc', 'id', Task::TABLE, 'creator_id')
-            ->join(Category::TABLE, 'id', 'category_id', Task::TABLE)
-            ->join(Column::TABLE, 'id', 'column_id', Task::TABLE)
-            ->join(Swimlane::TABLE, 'id', 'swimlane_id', Task::TABLE)
-            ->join(Project::TABLE, 'id', 'project_id', Task::TABLE);
-    }
-
-    /**
-     * Get all tasks shown on the board (sorted by position)
-     *
-     * @access public
-     * @param  integer    $project_id     Project id
-     * @param  integer    $column_id      Column id
-     * @param  integer    $swimlane_id    Swimlane id
-     * @return array
-     */
-    public function getTasksByColumnAndSwimlane($project_id, $column_id, $swimlane_id = 0)
-    {
-        return $this->getExtendedQuery()
-                    ->eq(Task::TABLE.'.project_id', $project_id)
-                    ->eq(Task::TABLE.'.column_id', $column_id)
-                    ->eq(Task::TABLE.'.swimlane_id', $swimlane_id)
-                    ->eq(Task::TABLE.'.is_active', Task::STATUS_OPEN)
-                    ->asc(Task::TABLE.'.position')
-                    ->findAll();
-    }
-
-    /**
-     * Get all tasks for a given project and status
-     *
-     * @access public
-     * @param  integer   $project_id      Project id
-     * @param  integer   $status_id       Status id
-     * @return array
-     */
-    public function getAll($project_id, $status_id = Task::STATUS_OPEN)
-    {
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->eq(Task::TABLE.'.project_id', $project_id)
-                    ->eq(Task::TABLE.'.is_active', $status_id)
-                    ->findAll();
-    }
-
-    /**
-     * Get all tasks for a given project and status
-     *
-     * @access public
-     * @param  integer   $project_id
-     * @param  array     $status
-     * @return array
-     */
-    public function getAllIds($project_id, array $status = array(Task::STATUS_OPEN))
-    {
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->eq(Task::TABLE.'.project_id', $project_id)
-                    ->in(Task::TABLE.'.is_active', $status)
-                    ->findAllByColumn('id');
-    }
-
-    /**
-     * Get overdue tasks query
-     *
-     * @access public
-     * @return \PicoDb\Table
-     */
-    public function getOverdueTasksQuery()
-    {
-        return $this->db->table(Task::TABLE)
-                    ->columns(
-                        Task::TABLE.'.id',
-                        Task::TABLE.'.title',
-                        Task::TABLE.'.date_due',
-                        Task::TABLE.'.project_id',
-                        Task::TABLE.'.creator_id',
-                        Task::TABLE.'.owner_id',
-                        Project::TABLE.'.name AS project_name',
-                        User::TABLE.'.username AS assignee_username',
-                        User::TABLE.'.name AS assignee_name'
-                    )
-                    ->join(Project::TABLE, 'id', 'project_id')
-                    ->join(User::TABLE, 'id', 'owner_id')
-                    ->eq(Project::TABLE.'.is_active', 1)
-                    ->eq(Task::TABLE.'.is_active', 1)
-                    ->neq(Task::TABLE.'.date_due', 0)
-                    ->lte(Task::TABLE.'.date_due', mktime(23, 59, 59));
-    }
-
-    /**
-     * Get a list of overdue tasks for all projects
-     *
-     * @access public
-     * @return array
-     */
-    public function getOverdueTasks()
-    {
-        return $this->getOverdueTasksQuery()->findAll();
-    }
-
-     /**
-     * Get a list of overdue tasks by project
-     *
-     * @access public
-     * @param  integer $project_id
-     * @return array
-     */
-    public function getOverdueTasksByProject($project_id)
-    {
-        return $this->getOverdueTasksQuery()->eq(Task::TABLE.'.project_id', $project_id)->findAll();
-    }
-
-     /**
-     * Get a list of overdue tasks by user
-     *
-     * @access public
-     * @param  integer $user_id
-     * @return array
-     */
-    public function getOverdueTasksByUser($user_id)
-    {
-        return $this->getOverdueTasksQuery()->eq(Task::TABLE.'.owner_id', $user_id)->findAll();
-    }
-
-    /**
-     * Get project id for a given task
-     *
-     * @access public
-     * @param  integer   $task_id   Task id
-     * @return integer
-     */
-    public function getProjectId($task_id)
-    {
-        return (int) $this->db->table(Task::TABLE)->eq('id', $task_id)->findOneColumn('project_id') ?: 0;
-    }
-
-    /**
-     * Fetch a task by the id
-     *
-     * @access public
-     * @param  integer   $task_id   Task id
-     * @return array
-     */
-    public function getById($task_id)
-    {
-        return $this->db->table(Task::TABLE)->eq('id', $task_id)->findOne();
-    }
-
-    /**
-     * Fetch a task by the reference (external id)
-     *
-     * @access public
-     * @param  integer  $project_id  Project id
-     * @param  string   $reference   Task reference
-     * @return array
-     */
-    public function getByReference($project_id, $reference)
-    {
-        return $this->db->table(Task::TABLE)->eq('project_id', $project_id)->eq('reference', $reference)->findOne();
-    }
-
-    /**
-     * Get task details (fetch more information from other tables)
-     *
-     * @access public
-     * @param  integer   $task_id   Task id
-     * @return array
-     */
-    public function getDetails($task_id)
-    {
-        $sql = '
-            SELECT
-            tasks.id,
-            tasks.reference,
-            tasks.title,
-            tasks.description,
-            tasks.date_creation,
-            tasks.date_completed,
-            tasks.date_modification,
-            tasks.date_due,
-            tasks.date_started,
-            tasks.time_estimated,
-            tasks.time_spent,
-            tasks.color_id,
-            tasks.project_id,
-            tasks.column_id,
-            tasks.owner_id,
-            tasks.creator_id,
-            tasks.position,
-            tasks.is_active,
-            tasks.score,
-            tasks.category_id,
-            tasks.priority,
-            tasks.swimlane_id,
-            tasks.date_moved,
-            tasks.recurrence_status,
-            tasks.recurrence_trigger,
-            tasks.recurrence_factor,
-            tasks.recurrence_timeframe,
-            tasks.recurrence_basedate,
-            tasks.recurrence_parent,
-            tasks.recurrence_child,
-            project_has_categories.name AS category_name,
-            swimlanes.name AS swimlane_name,
-            projects.name AS project_name,
-            projects.default_swimlane,
-            columns.title AS column_title,
-            users.username AS assignee_username,
-            users.name AS assignee_name,
-            creators.username AS creator_username,
-            creators.name AS creator_name
-            FROM tasks
-            LEFT JOIN users ON users.id = tasks.owner_id
-            LEFT JOIN users AS creators ON creators.id = tasks.creator_id
-            LEFT JOIN project_has_categories ON project_has_categories.id = tasks.category_id
-            LEFT JOIN projects ON projects.id = tasks.project_id
-            LEFT JOIN columns ON columns.id = tasks.column_id
-            LEFT JOIN swimlanes ON swimlanes.id = tasks.swimlane_id
-            WHERE tasks.id = ?
-        ';
-
-        $rq = $this->db->execute($sql, array($task_id));
-        return $rq->fetch(PDO::FETCH_ASSOC);
-    }
-
-    /**
-     * Get iCal query
-     *
-     * @access public
-     * @return \PicoDb\Table
-     */
-    public function getICalQuery()
-    {
-        return $this->db->table(Task::TABLE)
-            ->left(User::TABLE, 'ua', 'id', Task::TABLE, 'owner_id')
-            ->left(User::TABLE, 'uc', 'id', Task::TABLE, 'creator_id')
-            ->columns(
-                Task::TABLE.'.*',
-                'ua.email AS assignee_email',
-                'ua.name AS assignee_name',
-                'ua.username AS assignee_username',
-                'uc.email AS creator_email',
-                'uc.username AS creator_username'
-            );
-    }
-
-    /**
-     * Count all tasks for a given project and status
-     *
-     * @access public
-     * @param  integer   $project_id   Project id
-     * @param  array     $status       List of status id
-     * @return integer
-     */
-    public function countByProjectId($project_id, array $status = array(Task::STATUS_OPEN, Task::STATUS_CLOSED))
-    {
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->eq('project_id', $project_id)
-                    ->in('is_active', $status)
-                    ->count();
-    }
-
-    /**
-     * Count the number of tasks for a given column and status
-     *
-     * @access public
-     * @param  integer   $project_id   Project id
-     * @param  integer   $column_id    Column id
-     * @return integer
-     */
-    public function countByColumnId($project_id, $column_id)
-    {
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->eq('project_id', $project_id)
-                    ->eq('column_id', $column_id)
-                    ->eq('is_active', 1)
-                    ->count();
-    }
-
-    /**
-     * Count the number of tasks for a given column and swimlane
-     *
-     * @access public
-     * @param  integer   $project_id     Project id
-     * @param  integer   $column_id      Column id
-     * @param  integer   $swimlane_id    Swimlane id
-     * @return integer
-     */
-    public function countByColumnAndSwimlaneId($project_id, $column_id, $swimlane_id)
-    {
-        return $this->db
-                    ->table(Task::TABLE)
-                    ->eq('project_id', $project_id)
-                    ->eq('column_id', $column_id)
-                    ->eq('swimlane_id', $swimlane_id)
-                    ->eq('is_active', 1)
-                    ->count();
-    }
-
-    /**
-     * Return true if the task exists
-     *
-     * @access public
-     * @param  integer    $task_id   Task id
-     * @return boolean
-     */
-    public function exists($task_id)
-    {
-        return $this->db->table(Task::TABLE)->eq('id', $task_id)->exists();
-    }
-
-    /**
-     * Get project token
-     *
-     * @access public
-     * @param  integer $task_id
-     * @return string
-     */
-    public function getProjectToken($task_id)
-    {
-        return $this->db
-            ->table(Task::TABLE)
-            ->eq(Task::TABLE.'.id', $task_id)
-            ->join(Project::TABLE, 'id', 'project_id')
-            ->findOneColumn(Project::TABLE.'.token');
-    }
-}