X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/01654e65fdac375c1db8317a956b727987c98c04..29d6481a7dc9e1538be50a942e4891db17467ec4:/WEB-INF/lib/ttTeamHelper.class.php diff --git a/WEB-INF/lib/ttTeamHelper.class.php b/WEB-INF/lib/ttTeamHelper.class.php index 2aab936a..4dd2f9aa 100644 --- a/WEB-INF/lib/ttTeamHelper.class.php +++ b/WEB-INF/lib/ttTeamHelper.class.php @@ -104,21 +104,6 @@ class ttTeamHelper { return $user_list; } - // The getUsers obtains all active and inactive (but not deleted) users in a group. - static function getUsers() { - global $user; - $mdb2 = getConnection(); - $sql = "select id, name from tt_users where group_id = $user->group_id and (status = 1 or status = 0) order by upper(name)"; - $res = $mdb2->query($sql); - $user_list = array(); - if (is_a($res, 'PEAR_Error')) - return false; - while ($val = $res->fetchRow()) { - $user_list[] = $val; - } - return $user_list; - } - // The getInactiveUsers obtains all inactive users in a group. static function getInactiveUsers($group_id, $all_fields = false) { $mdb2 = getConnection(); @@ -157,60 +142,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()