diff options
author | Frederic Guillot <fred@kanboard.net> | 2017-02-26 16:06:09 -0500 |
---|---|---|
committer | Frederic Guillot <fred@kanboard.net> | 2017-02-26 16:06:09 -0500 |
commit | 4f325193be4f16a9658258fecd525e71917156a0 (patch) | |
tree | 898aaf4f18bfa9b2b3a09dbb8f54413154b1d357 /app/Model/SubtaskTimeTrackingModel.php | |
parent | 4a87fb34ba0a88303282923a73a8fef83d7aada3 (diff) |
Add class SubtaskListFormatter
Diffstat (limited to 'app/Model/SubtaskTimeTrackingModel.php')
-rw-r--r-- | app/Model/SubtaskTimeTrackingModel.php | 32 |
1 files changed, 0 insertions, 32 deletions
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 @@ -100,38 +100,6 @@ class SubtaskTimeTrackingModel extends Base } /** - * 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 * * @access public |