X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/bf0370124e2c2bfb092deed614990fc4cfffe8c6..3e557bb14365fb2483e0889820013198e0088674:/WEB-INF/lib/ttTeamHelper.class.php diff --git a/WEB-INF/lib/ttTeamHelper.class.php b/WEB-INF/lib/ttTeamHelper.class.php index dfcdaaf1..08fa5bee 100644 --- a/WEB-INF/lib/ttTeamHelper.class.php +++ b/WEB-INF/lib/ttTeamHelper.class.php @@ -33,20 +33,6 @@ import('ttInvoiceHelper'); // Class ttTeamHelper - contains helper functions that operate with groups. class ttTeamHelper { - // The getUserCount function returns number of active users in a group. - static function getUserCount($group_id) { - $mdb2 = getConnection(); - - $sql = "select count(id) as cnt from tt_users where group_id = $group_id and status = 1"; - $res = $mdb2->query($sql); - - if (!is_a($res, 'PEAR_Error')) { - $val = $res->fetchRow(); - return $val['cnt']; - } - return false; - } - // The getUsersForClient obtains all active and inactive users in a group that are relevant to a client. static function getUsersForClient() { global $user; @@ -797,30 +783,6 @@ class ttTeamHelper { return true; } - // The markTasksDeleted deletes task binds and marks the tasks as deleted for a group. - static function markTasksDeleted($group_id) { - $mdb2 = getConnection(); - $sql = "select id from tt_tasks where group_id = $group_id"; - $res = $mdb2->query($sql); - if (is_a($res, 'PEAR_Error')) return false; - - while ($val = $res->fetchRow()) { - - // Delete task binds. - $task_id = $val['id']; - $sql = "delete from tt_project_task_binds where task_id = $task_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - - // Mark task as deleted. - $sql = "update tt_tasks set status = NULL where id = $task_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - } - - return true; - } - // The deleteTasks deletes all tasks and task binds for an inactive group. static function deleteTasks($group_id) { $mdb2 = getConnection();