summaryrefslogtreecommitdiff
path: root/app/Model/TaskPaginator.php
blob: bf537fbe51f689f6b358f301d791228dcdc50283 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
<?php

namespace Model;

/**
 * Task Paginator model
 *
 * @package  model
 * @author   Frederic Guillot
 */
class TaskPaginator extends Base
{
    /**
     * Task search with pagination
     *
     * @access public
     * @param  integer    $project_id    Project id
     * @param  string     $search        Search terms
     * @param  integer    $offset        Offset
     * @param  integer    $limit         Limit
     * @param  string     $column        Sorting column
     * @param  string     $direction     Sorting direction
     * @return array
     */
    public function searchTasks($project_id, $search, $offset = 0, $limit = 25, $column = 'tasks.id', $direction = 'DESC')
    {
        return $this->taskFinder->getQuery()
                    ->eq('project_id', $project_id)
                    ->ilike('title', '%'.$search.'%')
                    ->offset($offset)
                    ->limit($limit)
                    ->orderBy($column, $direction)
                    ->findAll();
    }

    /**
     * Count the number of tasks for a custom search
     *
     * @access public
     * @param  integer   $project_id   Project id
     * @param  string    $search       Search terms
     * @return integer
     */
    public function countSearchTasks($project_id, $search)
    {
        return $this->db->table(Task::TABLE)
                        ->eq('project_id', $project_id)
                        ->ilike('title', '%'.$search.'%')
                        ->count();
    }

    /**
     * Get all completed tasks with pagination
     *
     * @access public
     * @param  integer    $project_id    Project id
     * @param  integer    $offset        Offset
     * @param  integer    $limit         Limit
     * @param  string     $column        Sorting column
     * @param  string     $direction     Sorting direction
     * @return array
     */
    public function closedTasks($project_id, $offset = 0, $limit = 25, $column = 'tasks.date_completed', $direction = 'DESC')
    {
        return $this->taskFinder->getQuery()
                    ->eq('project_id', $project_id)
                    ->eq('is_active', Task::STATUS_CLOSED)
                    ->offset($offset)
                    ->limit($limit)
                    ->orderBy($column, $direction)
                    ->findAll();
    }

    /**
     * Count all closed tasks
     *
     * @access public
     * @param  integer   $project_id   Project id
     * @param  array     $status       List of status id
     * @return integer
     */
    public function countClosedTasks($project_id)
    {
        return $this->db
                    ->table(Task::TABLE)
                    ->eq('project_id', $project_id)
                    ->eq('is_active', Task::STATUS_CLOSED)
                    ->count();
    }

    /**
     * Get all open tasks for a given user
     *
     * @access public
     * @param  integer    $user_id       User id
     * @param  integer    $offset        Offset
     * @param  integer    $limit         Limit
     * @param  string     $column        Sorting column
     * @param  string     $direction     Sorting direction
     * @return array
     */
    public function userTasks($user_id, $offset = 0, $limit = 25, $column = 'tasks.id', $direction = 'ASC')
    {
        return $this->db
                    ->table(Task::TABLE)
                    ->columns(
                        'tasks.id',
                        'tasks.title',
                        'tasks.date_due',
                        'tasks.date_creation',
                        'tasks.project_id',
                        'tasks.color_id',
                        'projects.name AS project_name'
                    )
                    ->join(Project::TABLE, 'id', 'project_id')
                    ->eq('tasks.owner_id', $user_id)
                    ->eq('tasks.is_active', Task::STATUS_OPEN)
                    ->offset($offset)
                    ->limit($limit)
                    ->orderBy($column, $direction)
                    ->findAll();
    }

    /**
     * Count all tasks assigned to the user
     *
     * @access public
     * @param  integer    $user_id    User id
     * @return integer
     */
    public function countUserTasks($user_id)
    {
        return $this->db
                    ->table(Task::TABLE)
                    ->eq('owner_id', $user_id)
                    ->eq('is_active', Task::STATUS_OPEN)
                    ->count();
    }
}