X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttGroup.class.php;h=f85f9097163071101057b959a7833463cb82cdf7;hb=a08292683b29da0946e2099e3fd94bc2d19688f3;hp=b0c50eef539295faf170327f8093730d3367c3ea;hpb=b10bedad0cf854c9cb49bf0582b20869cb0c458d;p=timetracker.git diff --git a/WEB-INF/lib/ttGroup.class.php b/WEB-INF/lib/ttGroup.class.php index b0c50eef..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(); @@ -97,9 +100,9 @@ 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']; } }