X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttGroup.class.php;h=f85f9097163071101057b959a7833463cb82cdf7;hb=1ca0df080b44b700872bec9216d8405b1f90bc11;hp=bb03845d8d737fcbedccf1dfacb2317b387d9fe3;hpb=03e3d32869aa0791e1d841be69cf5c0c84a5450f;p=timetracker.git diff --git a/WEB-INF/lib/ttGroup.class.php b/WEB-INF/lib/ttGroup.class.php index bb03845d..f85f9097 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(); @@ -98,8 +101,8 @@ class ttGroup { $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']; */ $this->config = $val['config']; @@ -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']; } }