X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/de05f61301a897661c702f03c1b45dd3ab5c0e8a..885b2d93423950dc37ae493b0f59c6050e0e119a:/WEB-INF/lib/ttTeamHelper.class.php diff --git a/WEB-INF/lib/ttTeamHelper.class.php b/WEB-INF/lib/ttTeamHelper.class.php index 359f6b97..a8133b8a 100644 --- a/WEB-INF/lib/ttTeamHelper.class.php +++ b/WEB-INF/lib/ttTeamHelper.class.php @@ -187,24 +187,6 @@ class ttTeamHelper { return false; } - // The getAllUsers obtains all users in a group. - static function getAllUsers($group_id, $all_fields = false) { - $mdb2 = getConnection(); - if ($all_fields) - $sql = "select * from tt_users where group_id = $group_id order by upper(name)"; - else - $sql = "select id, name from tt_users where group_id = $group_id order by upper(name)"; - $res = $mdb2->query($sql); - $result = array(); - if (!is_a($res, 'PEAR_Error')) { - while ($val = $res->fetchRow()) { - $result[] = $val; - } - return $result; - } - return false; - } - // getActiveProjects - returns an array of active projects for a group. static function getActiveProjects($group_id) { @@ -691,48 +673,6 @@ class ttTeamHelper { return false; } - // The markDeleted function marks the group and everything in it as deleted. - static function markDeleted($group_id) { - - // Iterate through group users and mark them as deleted. - $users = ttTeamHelper::getAllUsers($group_id); - foreach ($users as $one_user) { - if (!ttUserHelper::markDeleted($one_user['id'])) return false; - } - - // Mark tasks deleted. - if (!ttTeamHelper::markTasksDeleted($group_id)) return false; - - $mdb2 = getConnection(); - - // Mark roles deleted. - $sql = "update tt_roles set status = NULL where group_id = $group_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - - // Mark projects deleted. - $sql = "update tt_projects set status = NULL where group_id = $group_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - - // Mark clients deleted. - $sql = "update tt_clients set status = NULL where group_id = $group_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - - // Mark custom fields deleted. - $sql = "update tt_custom_fields set status = NULL where group_id = $group_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - - // Mark group deleted. - $sql = "update tt_groups set status = NULL where id = $group_id"; - $affected = $mdb2->exec($sql); - if (is_a($affected, 'PEAR_Error')) return false; - - return true; - } - // The insert function creates a new group. static function insert($fields) {