X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttGroup.class.php;h=1aa422c72035681fd9496300fa5aff265b113e04;hb=a3eb3cd074e8b579c9948a6b12587f033ecb3c7e;hp=b7e78f959e8b4a49882ce82074a0f136f6627d86;hpb=035970e91c0a4c132874656b8f13a88c46684717;p=timetracker.git diff --git a/WEB-INF/lib/ttGroup.class.php b/WEB-INF/lib/ttGroup.class.php index b7e78f95..1aa422c7 100644 --- a/WEB-INF/lib/ttGroup.class.php +++ b/WEB-INF/lib/ttGroup.class.php @@ -62,6 +62,9 @@ class ttGroup { var $first_unit_threshold = 0;// Threshold for 1st unit for Work units plugin. var $unit_totals_only = 0; // Totals only option for the Work units plugin. + var $active_users = 0; // Count of active users in group. + // We need a non-zero count to display some menus. + // Constructor. function __construct($id, $org_id) { $mdb2 = getConnection(); @@ -94,11 +97,11 @@ class ttGroup { $this->allow_ip = $val['allow_ip']; $this->password_complexity = $val['password_complexity']; $this->group_name = $val['group_name']; - $this->currency = $val['currency']; */ + $this->currency = $val['currency']; $this->plugins = $val['plugins']; - /* $this->lock_spec = $val['lock_spec']; + /* $this->workday_minutes = $val['workday_minutes']; $this->custom_logo = $val['custom_logo']; */ @@ -119,5 +122,17 @@ class ttGroup { } */ } + + // Determine active user count in a separate query. + // TODO: If performance becomes an issue, investigate combining 2 queries in one. + // At this time we only need to know if at least 1 active user exists. + $sql = "select count(*) as user_count from tt_users". + " where group_id = $id and org_id = $org_id and status = 1"; + $res = $mdb2->query($sql); + if (is_a($res, 'PEAR_Error')) { + return; + } + $val = $res->fetchRow(); + $this->active_users = $val['user_count']; } }