X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/01654e65fdac375c1db8317a956b727987c98c04..c595ddbfdf0515e5fc91cc998bdf2bf92875c998:/WEB-INF/lib/ttTeamHelper.class.php diff --git a/WEB-INF/lib/ttTeamHelper.class.php b/WEB-INF/lib/ttTeamHelper.class.php index 2aab936a..3fc06cc7 100644 --- a/WEB-INF/lib/ttTeamHelper.class.php +++ b/WEB-INF/lib/ttTeamHelper.class.php @@ -157,60 +157,6 @@ class ttTeamHelper { return false; } - // getActiveTasks - returns an array of active tasks for a group. - static function getActiveTasks($group_id) - { - $result = array(); - $mdb2 = getConnection(); - - $sql = "select id, name, description from tt_tasks where group_id = $group_id and status = 1 order by upper(name)"; - $res = $mdb2->query($sql); - $result = array(); - if (!is_a($res, 'PEAR_Error')) { - while ($val = $res->fetchRow()) { - $result[] = $val; - } - } - return $result; - } - - // getInactiveTasks - returns an array of inactive tasks for a group. - static function getInactiveTasks($group_id) - { - $result = array(); - $mdb2 = getConnection(); - - $sql = "select id, name, description from tt_tasks - where group_id = $group_id and status = 0 order by upper(name)"; - $res = $mdb2->query($sql); - $result = array(); - if (!is_a($res, 'PEAR_Error')) { - while ($val = $res->fetchRow()) { - $result[] = $val; - } - } - return $result; - } - - // The getAllTasks obtains all tasks in a group. - static function getAllTasks($group_id, $all_fields = false) { - $mdb2 = getConnection(); - - if ($all_fields) - $sql = "select * from tt_tasks where group_id = $group_id order by status, upper(name)"; - else - $sql = "select id, name from tt_tasks where group_id = $group_id order by status, upper(name)"; - $res = $mdb2->query($sql); - $result = array(); - if (!is_a($res, 'PEAR_Error')) { - while ($val = $res->fetchRow()) { - $result[] = $val; - } - return $result; - } - return false; - } - // getActiveRolesForUser - returns an array of relevant active roles for user with rank less than self. // "Relevant" means that client roles are filtered out if Client plugin is disabled. static function getActiveRolesForUser()