// 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;
$inactive_groups = array();
$mdb2 = getConnection();
- // Get all group ids for groups created or modified more than 8 months ago.
+ // Get all group ids for groups created or modified more than 9 months ago.
// $ts = date('Y-m-d', strtotime('-1 year'));
- $ts = $mdb2->quote(date('Y-m-d', strtotime('-8 month')));
+ $ts = $mdb2->quote(date('Y-m-d', strtotime('-9 month')));
$sql = "select id from tt_groups where created < $ts and (modified is null or modified < $ts) order by id";
$res = $mdb2->query($sql);