in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Feb 2, 7:12 PM

in-portal
View Options

	Index: trunk/kernel/include/portalgroup.php
	===================================================================
	--- trunk/kernel/include/portalgroup.php (revision 1605)
	+++ trunk/kernel/include/portalgroup.php (revision 1606)
	@@ -1,541 +1,536 @@
	<?php

	class clsPortalGroup extends clsParsedItem
	{
	var $UserCount;

	function clsPortalGroup($GroupId=NULL)
	{
	$this->clsParsedItem($GroupId);
	$this->tablename=GetTablePrefix()."PortalGroup";
	$this->type=7;
	$this->BasePermission="GROUP";
	$this->id_field = "GroupId";
	if($GroupId)
	$this->LoadFromDatabase($GroupId);
	}

	function Validate()
	{
	global $objSession, $Errors;

	$dataValid = true;
	if(!isset($this->m_Name) \|\| $this->m_Name == "")
	{
	$Errors->AddError("error.fieldIsRequired",'Login',"","",get_class($this),"Validate");
	$dataValid = false;
	}

	return $dataValid;
	}


	function HasSystemPermission($PermissionName)
	{
	$GroupId = (int)$this->Get("GroupId");
	$sql = "SELECT * FROM ".GetTablePrefix()."Permissions WHERE GroupId=$GroupId AND Permission='$PermissionName' AND type=1";
	$result = $this->adodbConnection->Execute($sql);
	if($result && !$result->EOF)
	{
	$this->SysPermCache[$PermissionName] = (int)$result->fields["PermissionValue"];
	return (int)$result->fields["PermissionValue"];
	}
	else
	return -1;
	}

	/* set $Value to -1 to delete the permission row from the DB */
	function SetSystemPermission($PermName,$Value)
	{
	//echo "Setting $PermName to $Value<br>\n";
	$oldval = $this->HasSystemPermission($PermName);
	if($Value != $oldval)
	{
	if($Value>-1)
	{
	if($oldval>-1)
	{
	$sql = "UPDATE ".GetTablePrefix()."Permissions SET PermissionValue=$Value ";
	$sql .=" WHERE Type=1 AND Permission='$PermName' AND GroupId=".$this->Get("GroupId");

	//echo "UPDATE SQL: $sql<br>";
	}
	else
	{
	$sql = "INSERT INTO ".GetTablePrefix()."Permissions (Permission, GroupId, PermissionValue, Type, CatId) ";
	$sql .="VALUES ('$PermName',".$this->Get("GroupId").",$Value,1,0)";
	//echo "INSERT SQL: $sql<br>";
	}
	$this->adodbConnection->Execute($sql);
	//echo $sql."<br>\n";
	}
	else
	{
	$sql = "DELETE FROM ".GetTablePrefix()."Permissions ";
	$sql .=" WHERE Type=1 AND Permission='$PermName' AND GroupId=".$this->Get("GroupId");
	//echo "DELETE SQL: $sql<br>";
	$this->adodbConnection->Execute($sql);
	}
	}
	}

	function CheckPermission($permissionName)
	{
	//Check permission and if needs approval set approval
	global $objSession, $Errors;

	if(!$objSession->HasSystemPermission($permissionName))
	{
	//$Errors->AddError("error.AccessDenied","","","",get_class($this),"CheckPermission");
	return false;
	}
	return true;
	}

	function LoadFromDatabase($Id)
	{
	global $Errors;

	if(!isset($Id))
	{
	$Errors->AddError("error.AppError",NULL,'Internal error: LoadFromDatabase id',"",get_class($this),"LoadFromDatabase");
	return false;
	}

	$sql = "SELECT * FROM ".$this->tablename." WHERE GroupId = $Id";
	$result = $this->adodbConnection->Execute($sql);
	if ($result === false)
	{
	$Errors->AddError("error.DatabaseError",NULL,$this->adodbConnection->ErrorMsg(),"",get_class($this),"LoadFromDatabase");
	return false;
	}
	$data = $result->fields;
	$this->SetFromArray($data);
	$this->Clean();
	return true;
	}

	function AddUser($UserId,$PrimaryGroup=0,$edit_table = true)
	{
	global $objSession;

	// add user to group OR just updates it's status there
	$db =& $this->adodbConnection;
	$table=$edit_table?$objSession->GetEditTable('UserGroup'):GetTablePrefix().'UserGroup';

	$group_id = $this->Get('GroupId');

	$sql_patterns['check'] = 'SELECT PortalUserId FROM %s WHERE GroupId = %s AND PortalUserId = %s';
	$sql_patterns['reset_primary'] = 'UPDATE %s SET PrimaryGroup = 0 WHERE PortalUserId = %s';
	$sql_patterns['set_primary'] = 'UPDATE %s SET PrimaryGroup = 1 WHERE GroupId = %s AND PortalUserId = %s';
	$sql_patterns['add_to_group'] = 'INSERT INTO %s (PortalUserId,GroupId,PrimaryGroup) VALUES (%s, %s, %s)';

	$tmp_sql = sprintf($sql_patterns['check'], $table, $group_id, $UserId);
	$check_result = $db->GetOne($tmp_sql);
	if(!$check_result)
	{
	// user is not a memeber of this group
	$GroupCount = TableCount($table,"PortalUserId = $UserId", 0);
	if(!$PrimaryGroup) $PrimaryGroup = ($GroupCount == 0) ? 1 : 0; // reset primary status if not already
	$tmp_sql = sprintf($sql_patterns['add_to_group'], $table, $UserId, $group_id, $PrimaryGroup);
	$db->Execute($tmp_sql);
	}

	if($PrimaryGroup)
	{
	$tmp_sql = sprintf($sql_patterns['reset_primary'], $table, $UserId);
	$db->Execute($tmp_sql);

	$tmp_sql = sprintf($sql_patterns['set_primary'], $table, $group_id, $UserId);
	$db->Execute($tmp_sql);
	}
	}

	function DeleteUser($UserId)
	{
	global $objSession;

	$sql = "DELETE FROM ".$objSession->GetEditTable("UserGroup")." WHERE PortalUserId=$UserId AND GroupId=".$this->Get("GroupId");
	$this->adodbConnection->Execute($sql);
	}


	function GetCustomField( $fieldName)
	{
	global $Errors;

	if(!isset($this->m_UserId))
	{
	$Errors->AddError("error.AppError",NULL,"Get field is required in order to set custom field values","","clsPortalGroup","GetCustomField");
	return false;
	}

	return GetCustomFieldValue($this->m_UserId,"portaluser",$fieldName);
	}

	function SetCustomField( $fieldName, $value)
	{
	global $Errors;
	if(!isset($this->m_UserId))
	{
	$Errors->AddError("error.AppError",NULL,"Set field is required in order to set custom field values","","clsPortalGroup","SetCustomField");
	return false;
	}
	return SetCustomFieldValue($this->m_UserId,"portaluser",$fieldName,$value);
	}

	function GetUserCount()
	{
	if(!is_numeric($this->UserCount))
	{
	$sql = "SELECT count(*) as UserCount FROM ".GetTablePrefix()."UserGroup WHERE GroupId=".$this->Get("GroupId");
	$rs = $this->adodbConnection->Execute($sql);
	if($rs && !$rs->EOF)
	$users = $rs->fields["UserCount"];
	$this->UserCount = (int)$users;
	}
	return $this->UserCount;
	}

	- function GetUserList()
	+ function GetUserList($edit_table = false)
	{
	global $objSession;

	- $sql = "SELECT * FROM ".$objSession->GetEditTable("UserGroup")." WHERE GroupId=".$this->Get("GroupId");
	- $rs = $this->adodbConnection->Execute($sql);
	- $res = array();
	- while($rs && !$rs->EOF)
	- {
	- $res[] = $rs->fields["PortalUserId"];
	- $rs->MoveNext();
	- }
	- return $res;
	+ $table = $edit_table ? $objSession->GetEditTable('UserGroup') : GetTablePrefix().'UserGroup';
	+
	+ $sql = 'SELECT PortalUserId FROM '.$table.' WHERE GroupId = '.$this->UniqueId(); // Get('GroupId');
	+ return $this->adodbConnection->GetCol($sql);
	}

	function parsetag($tag)
	{
	global $var_list_update, $objConfig;
	if(is_object($tag))
	{
	$tagname = $tag->name;
	}
	else
	$tagname = $tag;
	switch($tagname)
	{
	case "group_id":
	return $this->Get("GroupId");
	break;
	case "group_name":
	return $this->Get("Name");
	break;
	case "group_desc":
	return $this->Get("Description");
	break;
	case "group_date":
	return LangDate($this->Get("CreatedOn"));
	break;
	case "group_name":
	return $this->Get("Name");
	break;
	case "group_enabled":
	return $this->Get("Enabled");
	break;
	case "group_date_month":
	return adodb_date("m", $this->Get("CreatedOn"));
	break;
	case "group_date_day":
	return adodb_date("d", $this->Get("CreatedOn"));
	break;
	case "group_date_year":
	return adodb_date("Y", $this->Get("CreatedOn"));
	break;
	case "group_system":
	if ($this->Get("System") == 1)
	return "System";
	else
	return "User Defined";
	break;
	case "group_status":
	if ($this->Get("Enabled") == 1)
	return "Enabled";
	else
	return "Disabled";
	break;
	default:
	if (substr($tag, 0, 6) == "custom")
	return Users_Custom($this->Get("ResourceId"), $tag);
	else
	return "Undefined:$tagname";
	break;
	}
	}
	}

	class clsGroupList extends clsItemCollection
	{
	var $Page;

	function clsGroupList()
	{
	$this->clsItemCollection();
	$this->classname = "clsPortalGroup";
	$this->SetTable('live', GetTablePrefix()."PortalGroup");
	$this->AdminSearchFields = array("name");
	$this->id_field = "GroupId";
	}
	function NumGroups()
	{
	return $this->NumItems();
	}

	function GetGroup($GroupID)
	{
	return $this->GetItem($GroupID);
	}

	function GetPersonalGroup($UserLogin)
	{
	$n = "_".$UserLogin;
	$g = $this->GetItemByField("Name",$n);
	return $g;
	}

	function LoadGroups($where = "",$orderBy = "")
	{
	global $objConfig;

	$this->Clear();
	if($this->Page<1)
	$this->Page=1;

	if(is_numeric($objConfig->Get("Perpage_Groups")))
	{
	$Start = ($this->Page-1)*$objConfig->Get("Perpage_Groups");
	$limit = "LIMIT ".$Start.",".$objConfig->Get("Perpage_Groups");
	}
	else
	$limit = NULL;

	if(strlen($where) == 0) $where = '1';
	$this->QueryItemCount=TableCount($this->SourceTable, $where, 0);
	//echo $this->QueryItemCount."<br>\n";

	if ($orderBy!="")
	{
	$this->Query_PortalGroup($where,$orderBy,$limit);
	}
	else
	{
	$this->Query_PortalGroup($where,"Name DESC",$limit);
	}

	}

	function Query_PortalGroup($whereClause=NULL,$orderByClause=NULL,$limit=null)
	{
	global $m_var_list,$objSession,$Errors;

	$sql = "SELECT * FROM ".$this->SourceTable." ";

	if(strlen($whereClause))
	$sql = sprintf('%s WHERE %s',$sql,$whereClause);

	if(strlen($orderByClause))
	if(strlen(trim($orderByClause)))
	$sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);

	if( isset($limit) ) $sql .= ' '.$limit;
	return $this->Query_Item($sql);
	}

	function Query_UserPortalGroup($whereClause,$orderByClause)
	{
	global $m_var_list,$objSession,$Errors;

	if ($m_var_list["action"] == "m_group_search")
	$table = $userSession->Get("SessionKey") . "_search";
	else
	$table = $this->SourceTable;

	$sql = "SELECT * FROM $table LEFT JOIN UserGroup USING (GroupId) ";

	if(isset($whereClause))
	$sql = sprintf('%s WHERE %s',$sql,$whereClause);

	if(isset($orderByClause))
	if (strlen(trim($orderByClause)))
	{
	$sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);
	}
	$result = $this->adodbConnection->Execute($sql);

	return $this->Query_Item($sql);
	}

	function GetAllGroupList()
	{
	static $GroupListCache;

	if(!is_array($GroupListCache))
	{
	$GroupListCache = array();
	$sql = "SELECT GroupId FROM ".$this->SourceTable." WHERE Enabled=1";

	$rs = $this->adodbConnection->Execute($sql);
	while($rs && !$rs->EOF)
	{
	$GroupListCache[] = $rs->fields["GroupId"];
	$rs->MoveNext();
	}
	}
	return $GroupListCache;
	}

	function Group_Custom($ResourceId, $tag)
	{
	$fieldname= substr($tag, 7);

	$sql = "SELECT Value FROM ".GetTablePrefix()."CustomMetaData LEFT JOIN ".GetTablePrefix()."CustomField USING (CustomFieldId) where ".GetTablePrefix()."CustomMetaData.ResourceId=$ResourceId AND ".GetTablePrefix()."CustomField.FieldName='$fieldname'";

	$result = $this->adodbConnection->Execute($sql);

	if ($result->EOF)
	return "";
	else
	return $result->fields["Value"];
	}

	function Add_Users_To_Group($groupid)
	{
	global $g_usergroup_status;
	$userids = explode("-", $g_usergroup_status);
	$g = $this->GetItem($groupid);
	foreach($userids as $userid)
	$g->AddUser($userid);
	}

	function Delete_Group($GroupId)
	{
	$g = $this->GetItem($GroupId);
	if(is_object($g))
	{
	$g->Delete();
	}
	}

	function Edit_Group($GroupId, $Name, $Description)
	{
	$g = $this->GetItem($GroupId);
	$g->Set(array("Name", "Description"), array($Name, $Description));
	$g->Update();
	return $g;
	}

	function &Add_Group($Name, $Description, $System=1)
	{
	$g = new clsPortalGroup(NULL);
	$g->tablename = $this->SourceTable;
	$g->Set(array("Name", "Description", "System"),array($Name, $Description,$System));
	$g->Set("CreatedOn",adodb_date("U"));
	$g->Create();
	return $g;
	}

	function CopyFromEditTable($idfield)
	{
	global $objSession;
	$GLOBALS['_CopyFromEditTable']=1;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	$sql = "SELECT * FROM $edit_table";

	$rs = $this->adodbConnection->Execute($sql);
	while($rs && !$rs->EOF)
	{
	$data = $rs->fields;
	$c = new $this->classname;
	$c->SetFromArray($data);
	$c->idfield = $idfield;
	$c->Dirty();
	if($c->Get($idfield)<1)
	{
	$old_id = $c->Get($idfield);
	$c->UnsetIdField();
	if(!is_numeric($c->Get("OrgId")))
	$c->Clean(array("OrgId"));
	$c->Create();
	$sql = "UPDATE ".GetTablePrefix()."UserGroup SET GroupId=".$c->Get("GroupId")." WHERE GroupId=$old_id";
	$this->adodbConnection->Execute($sql);
	$sql = "UPDATE ".GetTablePrefix()."Permissions SET GroupId=".$c->Get("GroupId")." WHERE GroupId=$old_id";
	$this->adodbConnection->Execute($sql);
	}

	$c->Update();
	unset($c);
	unset($r);
	$rs->MoveNext();
	}
	@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
	unset($GLOBALS['_CopyFromEditTable']);
	}

	function PurgeEditTable($idfield)
	{
	global $objSession;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");

	$sql = "DELETE FROM ".GetTablePrefix()."UserGroup WHERE GroupId<1";
	$this->adodbConnection->Execute($sql);
	$sql = "DELETE FROM ".GetTablePrefix()."Permissions WHERE GroupId<1";
	$this->adodbConnection->Execute($sql);

	}
	}

	class clsUserGroupList extends clsItemCollection
	{
	function clsUserGroupList()
	{
	$this->clsItemCollection();
	$this->classname = "clsPortalGroup";
	$this->SetTable('live', GetTablePrefix()."UserGroup");
	$this->id_field = "PortalUserId"; // don't try to insert by this ID :)
	}

	function CopyFromEditTable($idfield)
	{
	global $objSession;
	$GLOBALS['_CopyFromEditTable']=1;

	$edit_table = $objSession->GetEditTable($this->SourceTable);
	$sql = "SELECT * FROM $edit_table";
	$rs = $this->adodbConnection->Execute($sql);

	//echo $sql."<BR>";

	$clear_old = true;
	while($rs && !$rs->EOF)
	{
	$data = $rs->fields;

	if ($clear_old) {
	$sql = "DELETE FROM ".$this->SourceTable." WHERE $idfield = ".$data[$idfield];
	@$this->adodbConnection->Execute($sql);
	$clear_old = false;
	}

	$sql = "INSERT INTO ".$this->SourceTable." (PortalUserId, GroupId, PrimaryGroup) VALUES (".$data['PortalUserId'].", ".$data['GroupId'].", ".$data['PrimaryGroup'].")";
	@$this->adodbConnection->Execute($sql);

	$rs->MoveNext();
	}

	@$this->adodbConnection->Execute("DROP TABLE IF EXISTS $edit_table");
	unset($GLOBALS['_CopyFromEditTable']);
	}
	}

	?>

	Property changes on: trunk/kernel/include/portalgroup.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.15
	\ No newline at end of property
	+1.16
	\ No newline at end of property
	Index: trunk/admin/users/addgroup_users.php
	===================================================================
	--- trunk/admin/users/addgroup_users.php (revision 1605)
	+++ trunk/admin/users/addgroup_users.php (revision 1606)
	@@ -1,358 +1,358 @@
	<?php
	##############################################################
	##In-portal ##
	##############################################################
	## In-portal ##
	## Intechnic Corporation ##
	## All Rights Reserved, 1998-2002 ##
	## ##
	## No portion of this code may be copied, reproduced or ##
	## otherwise redistributed without proper written ##
	## consent of Intechnic Corporation. Violation will ##
	## result in revocation of the license and support ##
	## privileges along maximum prosecution allowed by law. ##
	##############################################################
	if(!strlen($pathtoroot))
	{
	$path=dirname(realpath(__FILE__));
	if(strlen($path))
	{
	/* determine the OS type for path parsing */
	$pos = strpos($path,":");
	if ($pos === false)
	{
	$gOS_TYPE="unix";
	$pathchar = "/";
	}
	else
	{
	$gOS_TYPE="win";
	$pathchar="\\";
	}
	$p = $path.$pathchar;
	/Start looking for the root flag file /
	while(!strlen($pathtoroot) && strlen($p))
	{
	$sub = substr($p,strlen($pathchar)*-1);
	if($sub==$pathchar)
	{
	$filename = $p."root.flg";
	}
	else
	$filename = $p.$pathchar."root.flg";
	if(file_exists($filename))
	{
	$pathtoroot = $p;
	}
	else
	{
	$parent = realpath($p.$pathchar."..".$pathchar);
	if($parent!=$p)
	{
	$p = $parent;
	}
	else
	$p = "";
	}
	}
	if(!strlen($pathtoroot))
	$pathtoroot = ".".$pathchar;
	}
	else
	{
	$pathtoroot = ".".$pathchar;
	}
	}

	$sub = substr($pathtoroot,strlen($pathchar)*-1);
	if($sub!=$pathchar)
	{
	$pathtoroot = $pathtoroot.$pathchar;
	}
	//echo $pathtoroot;

	require_once($pathtoroot."kernel/startup.php");
	//admin only util
	$rootURL="http://".ThisDomain().$objConfig->Get("Site_Path");
	$admin = $objConfig->Get("AdminDirectory");
	if(!strlen($admin))
	$admin = "admin";
	$localURL=$rootURL."kernel/";
	$adminURL = $rootURL.$admin;
	$imagesURL = $adminURL."/images";
	//$pathtolocal = $pathtoroot."in-news/";
	require_once ($pathtoroot.$admin."/include/elements.php");
	require_once ($pathtoroot."kernel/admin/include/navmenu.php");
	//require_once ($pathtolocal."admin/include/navmenu.php");
	require_once($pathtoroot.$admin."/toolbar.php");
	require_once($pathtoroot.$admin."/listview/listview.php");

	unset($objEditItems);

	$objEditItems = new clsGroupList();
	$objEditItems->SourceTable = $objSession->GetEditTable("PortalGroup");
	$objEditItems->EnablePaging = FALSE;

	$en = (int)$_GET["en"];
	$objEditItems->Query_Item("SELECT * FROM ".$objEditItems->SourceTable);
	$itemcount=$objEditItems->NumItems();
	$c = $objEditItems->GetItemByIndex($en);

	if($itemcount>1)
	{
	if ($en+1 == $itemcount)
	$en_next = -1;
	else
	$en_next = $en+1;

	if ($en == 0)
	$en_prev = -1;
	else
	$en_prev = $en-1;
	}
	$action = "m_edit_group";

	$envar = "env=" . BuildEnv() . "&en=$en";

	/* -------------------------------------- Section configuration ------------------------------------------- */
	$section = 'in-portal:editgroup_users';
	$sec = $objSections->GetSection($section);
	$SortFieldVar = "User_SortField";
	$SortOrderVar = "User_SortOrder";
	$DefaultSortField = "Login";
	$PerPageVar = "Perpage_User";
	$CurrentPageVar = "Page_UserList";
	$CurrentFilterVar = "User_View";

	$ListForm = "editgroup";
	$CheckClass = "UserChecks";

	/* ------------------------------------- Configure the toolbar ------------------------------------------- */
	$objListToolBar = new clsToolBar();

	$objListToolBar->Set("section",$section);
	$objListToolBar->Set("load_menu_func","");
	$objListToolBar->Set("CheckClass",$CheckClass);
	$objListToolBar->Set("CheckForm",$ListForm);
	$objListToolBar->Add("img_save", "la_Save","#","swap('img_save','toolbar/tool_select_f2.gif');", "swap('img_save', 'toolbar/tool_select.gif');","do_edit_save('editgroup','GroupEditStatus','".$admin."/users/user_groups.php',1);","tool_select.gif");
	$objListToolBar->Add("img_cancel", "la_Cancel","#","swap('img_cancel','toolbar/tool_cancel_f2.gif');", "swap('img_cancel', 'toolbar/tool_cancel.gif');","do_edit_save('editgroup','GroupEditStatus','".$admin."/users/user_groups.php',2);","tool_cancel.gif");
	if($itemcount == 1) $objListToolBar->Add("divider");

	if ( isset($en_prev) \|\| isset($en_next) )
	{
	$url = $RootUrl.$admin."/users/addgroup_users.php";
	$StatusField = "GroupEditStatus";
	$form = "editgroup";
	MultiEditButtons($objListToolBar,$en_next,$en_prev,$form,$StatusField,$url,$sec->Get("OnClick"),'','la_PrevGroup','la_NextGroup');
	$objListToolBar->Add("divider");
	}


	$listImages = array();
	//$img, $alt, $link, $onMouseOver, $onMouseOut, $onClick

	$objListToolBar->Add("new_group", "la_ToolTip_AddUserToGroup","","swap('new_group','toolbar/tool_usertogroup_f2.gif');",
	"swap('new_group', 'toolbar/tool_usertogroup.gif');",
	"OpenUserSelector('','','$envar&source=addgroup_users&GroupId=".$c->Get("GroupId")."&destform=popup&destfield=userlist&Selector=radio&dosubmit=1');",
	"tool_usertogroup.gif");

	$objListToolBar->Add("user_del","la_ToolTip_RemoveUserFromGroup","#", "if (UserChecks.itemChecked()) swap('user_del','toolbar/tool_delete_f2.gif');",
	"if (UserChecks.itemChecked()) swap('user_del', 'toolbar/tool_delete.gif');","if (UserChecks.itemChecked()) UserChecks.check_submit('addgroup_users', 'm_group_removeuser');",
	"tool_delete.gif");
	$listImages[] = "UserChecks.addImage('user_del','$imagesURL/toolbar/tool_delete.gif','$imagesURL/toolbar/tool_delete_f3.gif',1); ";

	$objListToolBar->Add("divider");

	$objListToolBar->Add("user_print", "la_ToolTip_Print","#","swap('user_print','toolbar/tool_print_f2.gif');",
	"swap('user_print', 'toolbar/tool_print.gif');","window.print();","tool_print.gif");

	$objListToolBar->Add("viewmenubutton", "la_ToolTip_View","#","swap('viewmenubutton','toolbar/tool_view_f2.gif'); ",
	"swap('viewmenubutton', 'toolbar/tool_view.gif');",
	"ShowViewMenu();","tool_view.gif");

	$objListToolBar->AddToInitScript($listImages);
	$objListToolBar->AddToInitScript("fwLoadMenus();");

	/* ----------------------------------------- Set the View Filter ---------------------------------------- */

	/* bit place holders for category view menu */
	$Bit_Pending=4;
	$Bit_Disabled=2;
	$Bit_Valid=1;
	$Bit_All = 7;

	$FilterLabels = array();

	$FilterLabels[0] = admin_language("la_Text_Enabled");
	$FilterLabels[1] = admin_language("la_Text_Disabled");
	$FilterLabels[2] = admin_language("la_Text_Pending");

	/* determine current view menu settings */
	$UserView = $objConfig->Get("User_View");

	if(!is_numeric($UserView))
	{
	$UserView = $Bit_All; //Set all bits ON
	$UserFilter = "";
	}
	if($UserView & $Bit_Valid)
	$Status[] = 1;

	if($UserView & $Bit_Disabled)
	$Status[] = 0;

	if($UserView & $Bit_Pending)
	$Status[] = 2;

	if(count($Status)>0)
	{
	$UserFilter = "Status IN (".implode(",",$Status).")";
	}
	else
	$UserFilter = "Status = -1";


	-$GroupUsers = $c->GetUserList();
	+$GroupUsers = $c->GetUserList(true);
	if(count($GroupUsers)>0)
	{
	$list = implode(",",$GroupUsers);
	$where = "u.PortalUserId IN ($list) ";
	}
	else
	{
	$list=0;
	$where = "u.PortalUserId = -1 ";
	}
	$order = $objConfig->Get("User_SortOrder");
	$SearchWords = $objSession->GetVariable("UserGroupSearchWord");
	if(strlen($SearchWords))
	{
	$where .= $objUsers->AdminSearchWhereClause($SearchWords);
	}

	$sql = "SELECT u.*,g.Name AS GroupName,ELT(u.status+1,'".admin_language("la_Text_Disabled")." ','".admin_language("la_Text_Enabled")." ','".admin_language("la_Text_Pending")."') as UserStatus, ";
	$sql .="FROM_UNIXTIME(u.CreatedOn,'%m-%d-%Y') AS DateCreated FROM ".GetTablePrefix()."PortalUser as u ";
	$sql .="LEFT JOIN ".GetTablePrefix()."UserGroup AS ug ON (u.PortalUserId=ug.PortalUserId) AND (ug.PrimaryGroup = 1) ";
	$sql .="LEFT JOIN ".GetTablePrefix()."PortalGroup as g ON (ug.GroupId=g.GroupId) WHERE 1";

	if(strlen($where))
	$sql .= " AND ".$where;
	//$sql .=" ".GetLimitSQL($objSession->GetVariable("Page_Userlist"),$objConfig->Get("Perpage_User"));
	$objListView = new clsListView($objListToolBar);
	$objListView->CurrentPageVar = "Page_Userlist";
	$objListView->PerPageVar = "Perpage_User";

	if($objSession->HasSystemPermission("DEBUG.LIST"))
	echo htmlentities($sql,ENT_NOQUOTES)."<br>\n";

	$objUsers->Query_Item($sql, $objListView->GetLimitSQL() );
	$itemcount = $list?TableCount(GetTablePrefix()."PortalUser","PortalUserId IN ($list)",0):0;

	$objListView->SetListItems($objUsers);
	$objListView->IdField = "ResourceId";
	$objListView->PageLinkTemplate = $pathtoroot. $admin."/templates/user_page_link.tpl";

	$objListView->ColumnHeaders->Add("Login",admin_language("la_prompt_Username"),1,0,$order,"width=\"15%\"","User_SortField","User_SortOrder","Login");
	$objListView->ColumnHeaders->Add("LastName",admin_language("la_prompt_Last_Name"),1,0,$order,"width=\"15%\"","User_SortField","User_SortOrder","LastName");
	$objListView->ColumnHeaders->Add("FirstName",admin_language("la_prompt_First_Name"),1,0,$order,"width=\"15%\"","User_SortField","User_SortOrder","FirstName");
	$objListView->ColumnHeaders->Add("Email",admin_language("la_prompt_Email"),1,0,$order,"width=\"20%\"","User_SortField","User_SortOrder","Email");
	$objListView->ColumnHeaders->Add("GroupName",admin_language("la_prompt_PrimaryGroup"),1,0,$order,"width=\"20%\"","User_SortField","User_SortOrder","GroupName");
	$objListView->ColumnHeaders->Add("DateCreated",admin_language("la_prompt_CreatedOn"),1,0,$order,"width=\"15%\"","User_SortField","User_SortOrder","DateCreated");
	$objListView->ColumnHeaders->SetSort($objConfig->Get("User_SortField"),$order);

	$objListView->PrintToolBar = FALSE;
	$objListView->SearchBar = TRUE;
	$objListView->SearchKeywords = $SearchWords;
	$objListView->SearchAction="m_usergroup_search";
	$objListView->CheckboxName = "itemlist[]";
	$objListView->TotalItemCount = $itemcount;

	for($i=0;$i<count($objUsers->Items);$i++)
	{
	$u =& $objUsers->GetItemRefByIndex($i);
	$objListView->RowIcons[] = $u->StatusIcon();
	}
	$objListView->ConfigureViewMenu($SortFieldVar,$SortOrderVar,$DefaultSortField,
	$CurrentFilterVar,$UserView,$Bit_All);

	foreach($FilterLabels as $Bit=>$Label)
	{
	$objListView->AddViewMenuFilter($Label,$Bit);
	}


	$filter = false; // always initialize variables before use
	if($objSession->GetVariable("UserGroupSearchWord") != '') {
	$filter = true;
	}
	else {
	if ($UserView != $Bit_All) {
	$filter = true;
	}
	}


	$title = GetTitle("la_Text_Group", "la_tab_Users", $c->Get('GroupId'), $c->Get('Name'));//prompt_language("la_Text_Editing")." ".prompt_language("la_Text_Group")." '".$c->Get("Name")."' - ".prompt_language("la_tab_Users");
	$h = "\n\n<SCRIPT Language=\"JavaScript1.2\">\n".$objListView->GetViewMenu($imagesURL)."\n</SCRIPT>\n";
	int_header($objListToolBar,NULL, $title,NULL,$h);
	if ($objSession->GetVariable("HasChanges") == 1) {
	?>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="toolbar">
	<tr>
	<td valign="top">
	<?php int_hint_red(admin_language("la_Warning_Save_Item")); ?>
	</td>
	</tr>
	</table>
	<?php } ?>
	<?php if ($filter) { ?>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="toolbar">
	<tr>
	<td valign="top">
	<?php int_hint_red(admin_language("la_Warning_Filter")); ?>
	</td>
	</tr>
	</table>
	<?php } ?>
	<FORM method="POST" ACTION="" NAME="editgroup" ID="editgroup">
	<?php
	print $objListView->PrintList();
	?>
	<input type="hidden" name="Action" value="">
	<INPUT TYPE="HIDDEN" NAME="GroupId" VALUE="<?php echo $c->Get("GroupId"); ?>">
	<input type="hidden" name="GroupEditStatus" VALUE="0">
	</FORM>

	<FORM NAME="popup" ID="popup" METHOD="POST" ACTION="<?php echo $_SERVER["PHP_SELF"]."?env=".BuildEnv(); ?>">
	<INPUT TYPE="hidden" NAME="userlist">
	<input TYPE="hidden" NAME="Action" VALUE="m_group_add_user">
	<INPUT TYPE="HIDDEN" NAME="GroupId" VALUE="<?php echo $c->Get("GroupId"); ?>">
	</FORM>

	<!-- CODE FOR VIEW MENU -->
	<form ID="viewmenu" method="post" action="<?php echo $_SERVER["PHP_SELF"]."?env=".BuildEnv(); ?>" name="viewmenu">
	<input type="hidden" name="fieldname" value="">
	<input type="hidden" name="varvalue" value="">
	<input type="hidden" name="varvalue2" value="">
	<input type="hidden" name="Action" value="">
	</form>
	<FORM ID="ListSearchForm" NAME="ListSearchForm" method="POST" action="<?php echo $_SERVER["PHP_SELF"]."?env=".BuildEnv(); ?>">
	<INPUT TYPE="HIDDEN" NAME="Action" VALUE="">
	<INPUT TYPE="HIDDEN" NAME="list_search">
	</FORM>
	<FORM NAME="save_edit_buttons" ID="save_edit_buttons" method="POST" ACTION="">
	<tr <?php int_table_color(); ?>>
	<td colspan="5">
	<input type=hidden NAME="Action" VALUE="save_user_edit">
	<input type="hidden" name="GroupEditStatus" VALUE="0">
	</td>
	</tr>
	</FORM>
	<script src="<?php echo $adminURL; ?>/listview/listview.js"></script>
	<script>

	initSelectiorContainers();
	<?php echo $objListToolBar->Get("CheckClass").".setImages();"; ?>
	</script>
	<!-- END CODE-->
	<?php int_footer(); ?>
	\ No newline at end of file

	Property changes on: trunk/admin/users/addgroup_users.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.10
	\ No newline at end of property
	+1.11
	\ No newline at end of property

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options