group_id); $allowedCompanies = $obj->getAllowedRecords($AppUI->user_id, 'group_id, group_name'); $company_type_filter = $currentTabId; //Not Defined $companiesType = true; if ($currentTabName == "All Groups") $companiesType = false; if ($currentTabName == "Not Applicable") $company_type_filter = 0; // retrieve list of records $q = new DBQuery; $q->addTable('groups', 'g'); $q->addQuery('g.group_id, g.group_name, g.group_type, g.group_description, count(distinct p.project_id) as countp, count(distinct p2.project_id) as inactive, user_first_name, user_last_name'); $q->addJoin('projects', 'p', 'g.group_id = p.project_group AND p.project_active <> 0'); $q->addJoin('users', 'u', 'g.group_owner = u.user_id'); $q->addJoin('projects', 'p2', 'g.group_id = p2.project_group AND p2.project_active = 0'); if (count($allowedCompanies) > 0) { $q->addWhere('g.group_id IN (' . implode(',', array_keys($allowedCompanies)) . ')'); } else $q->addWhere('0'); if ($companiesType) { $q->addWhere('g.group_type = '.$company_type_filter); } if ($search_string != "") { $q->addWhere("g.group_name LIKE '%$search_string%'"); } if ($owner_filter_id > 0) { $q->addWhere("g.group_owner = $owner_filter_id "); } $q->addGroup('g.group_id'); $q->addOrder($orderby.' '.$orderdir); $rows = $q->loadList(); ?> '; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; } echo "$s\n"; if ($none) { echo $CR . ''; } ?>

_('sort by');?>:	_('Group Name');?>	_('Active Projects');?>	_('Archived Projects');?>	_('Type');?>
	' . $row["group_name"] .'	' . $row["countp"] . '	' . @$row["inactive"] . '	' . $AppUI->_($types[@$row["group_type"]]) . '
' . $AppUI->_( 'No groups available' ) . '