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
|
<?php
namespace Model;
/**
* Task Status
*
* @package model
* @author Frederic Guillot
*/
class TaskStatus 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, Task::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, Task::STATUS_OPEN);
}
/**
* Mark a task closed
*
* @access public
* @param integer $task_id Task id
* @return boolean
*/
public function close($task_id)
{
return $this->changeStatus($task_id, Task::STATUS_CLOSED, time(), Task::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, Task::STATUS_OPEN, 0, Task::EVENT_OPEN);
}
/**
* 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 Event name
* @return boolean
*/
private function changeStatus($task_id, $status, $date_completed, $event)
{
if (! $this->taskFinder->exists($task_id)) {
return false;
}
$result = $this->db
->table(Task::TABLE)
->eq('id', $task_id)
->update(array(
'is_active' => $status,
'date_completed' => $date_completed,
'date_modification' => time(),
));
if ($result) {
$this->event->trigger(
$event,
array('task_id' => $task_id) + $this->taskFinder->getById($task_id)
);
}
return $result;
}
/**
* Check the status of 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(Task::TABLE)
->eq('id', $task_id)
->eq('is_active', $status)
->count() === 1;
}
}
|