// 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;
$result = array();
$mdb2 = getConnection();
- $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and rank < $user->rank and status = 1 order by rank";
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and org_id = $user->org_id and rank < $user->rank and status = 1 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$result = array();
$mdb2 = getConnection();
- $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and rank < $user->rank and status = 0 order by rank";
+ $sql = "select id, name, description, rank, rights from tt_roles where group_id = $user->group_id and org_id = $user->org_id and rank < $user->rank and status = 0 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$inactive_groups = array();
$mdb2 = getConnection();
- // Get all group ids for groups created or modified more than 8 months ago.
- // $ts = date('Y-m-d', strtotime('-1 year'));
- $ts = $mdb2->quote(date('Y-m-d', strtotime('-8 month')));
+ // Get all group ids for groups created or modified more than 1 year ago.
+ $ts = $mdb2->quote(date('Y-m-d', strtotime('-1 year')));
$sql = "select id from tt_groups where created < $ts and (modified is null or modified < $ts) order by id";
$res = $mdb2->query($sql);
// The isGroupActive determines if a group is using Time Tracker or abandoned it.
static function isGroupActive($group_id) {
- $users = array();
-
$mdb2 = getConnection();
- $sql = "select id from tt_users where group_id = $group_id";
- $res = $mdb2->query($sql);
- if (is_a($res, 'PEAR_Error')) die($res->getMessage());
- while ($val = $res->fetchRow()) {
- $users[] = $val['id'];
- }
- $user_list = implode(',', $users); // This is a comma-separated list of user ids.
- if (!$user_list)
- return false; // No users in group.
$count = 0;
$ts = date('Y-m-d', strtotime('-2 years'));
- $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and created > '$ts'";
+ $sql = "select count(*) as cnt from tt_log where group_id = $group_id and created > '$ts'";
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
if ($val = $res->fetchRow()) {
// We will consider a group inactive if it has 5 or less time entries made more than 1 year ago.
$count_last_year = 0;
$ts = date('Y-m-d', strtotime('-1 year'));
- $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and created > '$ts'";
+ $sql = "select count(*) as cnt from tt_log where group_id = $group_id and created > '$ts'";
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
if ($val = $res->fetchRow()) {
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();