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
|
<?php
/**
* FusionForge project manager
*
* Copyright 1999-2000, Tim Perdue/Sourceforge
* Copyright 2002, Tim Perdue/GForge, LLC
* Copyright 2009, Roland Mas
*
* This file is part of FusionForge. FusionForge is free software;
* you can redistribute it and/or modify it under the terms of the
* GNU General Public License as published by the Free Software
* Foundation; either version 2 of the Licence, or (at your option)
* any later version.
*
* FusionForge is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License along
* with FusionForge; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
require_once $gfcommon.'pm/ProjectGroup.class.php';
require_once $gfcommon.'pm/ProjectTask.class.php';
require_once $gfcommon.'include/Group.class.php';
require_once $gfcommon.'include/Error.class.php';
/**
* A class that manages the project tasks for a specific user
*/
class ProjectTasksForUser extends Error {
/**
* The User to whom the tasks belong
*/
var $User;
/**
* ProjectTasksForUser - Creates a new ProjectTasksForUser object
*
* @param GFUser $user the User object
* @return bool
*/
function ProjectTasksForUser(&$user) {
$this->User =& $user;
return true;
}
/**
* getTasksFromSQLwithParams - Gets a list of tasks for this user
*
* @param string $sql The SQL query to use to fetch the tasks
* @param array $params
* @return ProjectTask[] An array of ProjectTask objects
*/
function &getTasksFromSQLwithParams ($sql, $params) {
$tasks = array();
$result = db_query_params ($sql, $params);
$rows=db_numrows($result);
for ($i=0; $i < $rows; $i++) {
$project_task_id = db_result($result,$i,'project_task_id');
$arr = db_fetch_array($result);
$task = projecttask_get_object($project_task_id,$arr);
$tasks[] =& $task;
}
return $tasks;
}
/**
* getTasksByGroupProjectName - Gets a list of tasks by group project name
*
* @return array An array of ProjectTask objects
*/
function &getTasksByGroupProjectName () {
return $this->getTasksFromSQLwithParams ('SELECT ptv.*,g.group_name,pgl.project_name
FROM project_task_vw ptv,
project_assigned_to pat,
groups g,
project_group_list pgl
WHERE ptv.project_task_id=pat.project_task_id
AND pgl.group_id=g.group_id
AND pgl.group_project_id=ptv.group_project_id
AND ptv.status_id=1
AND pat.assigned_to_id=$1
ORDER BY group_name,project_name',
array ($this->User->getID())) ;
}
function &getOpenTasksForDate($date) {
return $this->getTasksFromSQLwithParams ('SELECT ptv.*,g.group_name,pgl.project_name
FROM project_task_vw ptv,
project_assigned_to pat,
groups g,
project_group_list pgl
WHERE ptv.project_task_id=pat.project_task_id
AND pgl.group_id=g.group_id
AND pgl.group_project_id=ptv.group_project_id
AND ptv.start_date < $1
AND ptv.status_id=1
AND pat.assigned_to_id=$2
ORDER BY group_name,project_name',
array ($date,
$this->User->getID())) ;
}
function &getTasksForToday() {
$now = getdate();
$today = mktime (18, 00, 00, $now['mon'], $now['mday'], $now['year']);
return $this->getOpenTasksForDate($today);
}
function &getTasksForThisWeek() {
$now = getdate();
$this_week = mktime (18, 00, 00, $now['mon'], $now['mday'], $now['year'])+7*24*3600;
return $this->getOpenTasksForDate($this_week);
}
}
// Local Variables:
// mode: php
// c-file-style: "bsd"
// End:
|
