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
140
141
142
143
144
|
<?php
namespace Kanboard\Model;
use Kanboard\Core\Base;
/**
* Task Status
*
* @package Kanboard\Model
* @author Frederic Guillot
*/
class TaskStatusModel extends Base
{
/**
* Return true if the task is closed
*
* @access public
* @param integer $task_id Task id
* @return boolean
*/
public function isClosed($task_id)
{
return $this->checkStatus($task_id, TaskModel::STATUS_CLOSED);
}
/**
* Return true if the task is open
*
* @access public
* @param integer $task_id Task id
* @return boolean
*/
public function isOpen($task_id)
{
return $this->checkStatus($task_id, TaskModel::STATUS_OPEN);
}
/**
* Mark a task closed
*
* @access public
* @param integer $task_id Task id
* @return boolean
*/
public function close($task_id)
{
$this->subtaskStatusModel->closeAll($task_id);
return $this->changeStatus($task_id, TaskModel::STATUS_CLOSED, time(), TaskModel::EVENT_CLOSE);
}
/**
* Mark a task open
*
* @access public
* @param integer $task_id Task id
* @return boolean
*/
public function open($task_id)
{
return $this->changeStatus($task_id, TaskModel::STATUS_OPEN, 0, TaskModel::EVENT_OPEN);
}
/**
* Close multiple tasks
*
* @access public
* @param array $task_ids
*/
public function closeMultipleTasks(array $task_ids)
{
foreach ($task_ids as $task_id) {
$this->close($task_id);
}
}
/**
* Close all tasks within a column/swimlane
*
* @access public
* @param integer $swimlane_id
* @param integer $column_id
*/
public function closeTasksBySwimlaneAndColumn($swimlane_id, $column_id)
{
$task_ids = $this->db
->table(TaskModel::TABLE)
->eq('swimlane_id', $swimlane_id)
->eq('column_id', $column_id)
->eq(TaskModel::TABLE.'.is_active', TaskModel::STATUS_OPEN)
->findAllByColumn('id');
$this->closeMultipleTasks($task_ids);
}
/**
* Common method to change the status of task
*
* @access private
* @param integer $task_id Task id
* @param integer $status Task status
* @param integer $date_completed Timestamp
* @param string $event_name Event name
* @return boolean
*/
private function changeStatus($task_id, $status, $date_completed, $event_name)
{
if (! $this->taskFinderModel->exists($task_id)) {
return false;
}
$result = $this->db
->table(TaskModel::TABLE)
->eq('id', $task_id)
->update(array(
'is_active' => $status,
'date_completed' => $date_completed,
'date_modification' => time(),
));
if ($result) {
$this->queueManager->push($this->taskEventJob->withParams($task_id, array($event_name)));
}
return $result;
}
/**
* Check the status of a task
*
* @access private
* @param integer $task_id Task id
* @param integer $status Task status
* @return boolean
*/
private function checkStatus($task_id, $status)
{
return $this->db
->table(TaskModel::TABLE)
->eq('id', $task_id)
->eq('is_active', $status)
->count() === 1;
}
}
|
