From 4f325193be4f16a9658258fecd525e71917156a0 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sun, 26 Feb 2017 16:06:09 -0500
Subject: Add class SubtaskListFormatter

---
 app/Model/SubtaskTimeTrackingModel.php | 32 --------------------------------
 1 file changed, 32 deletions(-)

(limited to 'app/Model/SubtaskTimeTrackingModel.php')

diff --git a/app/Model/SubtaskTimeTrackingModel.php b/app/Model/SubtaskTimeTrackingModel.php
index 3b1b97e4..25fd95c7 100644
--- a/app/Model/SubtaskTimeTrackingModel.php
+++ b/app/Model/SubtaskTimeTrackingModel.php
@@ -99,38 +99,6 @@ class SubtaskTimeTrackingModel extends Base
                     ->eq(TaskModel::TABLE.'.id', $task_id);
     }
 
-    /**
-     * Get query for project timesheet (pagination)
-     *
-     * @access public
-     * @param  integer    $project_id   Project id
-     * @return \PicoDb\Table
-     */
-    public function getProjectQuery($project_id)
-    {
-        return $this->db
-                    ->table(self::TABLE)
-                    ->columns(
-                        self::TABLE.'.id',
-                        self::TABLE.'.subtask_id',
-                        self::TABLE.'.end',
-                        self::TABLE.'.start',
-                        self::TABLE.'.time_spent',
-                        self::TABLE.'.user_id',
-                        SubtaskModel::TABLE.'.task_id',
-                        SubtaskModel::TABLE.'.title AS subtask_title',
-                        TaskModel::TABLE.'.project_id',
-                        TaskModel::TABLE.'.color_id',
-                        UserModel::TABLE.'.username',
-                        UserModel::TABLE.'.name AS user_fullname'
-                    )
-                    ->join(SubtaskModel::TABLE, 'id', 'subtask_id')
-                    ->join(TaskModel::TABLE, 'id', 'task_id', SubtaskModel::TABLE)
-                    ->join(UserModel::TABLE, 'id', 'user_id', self::TABLE)
-                    ->eq(TaskModel::TABLE.'.project_id', $project_id)
-                    ->asc(self::TABLE.'.id');
-    }
-
     /**
      * Get all recorded time slots for a given user
      *
-- 
cgit v1.2.3