/** * Load viewing of a user group screen. * @param bool $ugid * @param array|bool $header (type=success, warning)(message=localized message) * @return void */ public function index($ugid = false, $header = false) { if ($ugid != false) { $ugid = (int) $ugid; } if (!empty($header)) { $aData['headercfg'] = $header; } else { $aData = array(); } $aViewUrls = array(); $aData['ugid'] = $ugid; $aData['imageurl'] = Yii::app()->getConfig("adminimageurl"); $clang = Yii::app()->lang; if (Yii::app()->session['loginID']) { if ($ugid) { $ugid = sanitize_int($ugid); $aData["usergroupid"] = $ugid; $result = UserGroup::model()->requestViewGroup($ugid, Yii::app()->session["loginID"]); $crow = $result[0]; if ($result) { $aData["groupfound"] = true; $aData["groupname"] = $crow['name']; if (!empty($crow['description'])) { $aData["usergroupdescription"] = $crow['description']; } else { $aData["usergroupdescription"] = ""; } } //$this->user_in_groups_model = new User_in_groups; $eguquery = "SELECT * FROM {{user_in_groups}} AS a INNER JOIN {{users}} AS b ON a.uid = b.uid WHERE ugid = " . $ugid . " ORDER BY b.users_name"; $eguresult = dbExecuteAssoc($eguquery); $aUserInGroupsResult = $eguresult->readAll(); $query2 = "SELECT ugid FROM {{user_groups}} WHERE ugid = " . $ugid . " AND owner_id = " . Yii::app()->session['loginID']; $result2 = dbSelectLimitAssoc($query2, 1); $row2 = $result2->readAll(); $row = 1; $userloop = array(); $bgcc = "oddrow"; foreach ($aUserInGroupsResult as $egurow) { if ($bgcc == "evenrow") { $bgcc = "oddrow"; } else { $bgcc = "evenrow"; } $userloop[$row]["userid"] = $egurow['uid']; // output users $userloop[$row]["rowclass"] = $bgcc; if (Permission::model()->hasGlobalPermission('superadmin', 'update')) { $userloop[$row]["displayactions"] = true; } else { $userloop[$row]["displayactions"] = false; } $userloop[$row]["username"] = $egurow['users_name']; $userloop[$row]["email"] = $egurow['email']; $row++; } $aData["userloop"] = $userloop; if (isset($row2[0]['ugid'])) { $aData["useradddialog"] = true; $aData["useraddusers"] = getGroupUserList($ugid, 'optionlist'); $aData["useraddurl"] = ""; } } $aViewUrls[] = 'viewUserGroup_view'; } if (!empty($header)) { return array($aViewUrls, $aData); } else { $this->_renderWrappedTemplate('usergroup', $aViewUrls, $aData); } }
/** * Load viewing of a user group screen. * @param bool $ugid * @param array|bool $header (type=success, warning)(message=localized message) * @return void */ public function index($ugid = false, $header = false) { if (!Permission::model()->hasGlobalPermission('usergroups', 'read')) { Yii::app()->session['flashmessage'] = gT('Access denied!'); $this->getController()->redirect(App()->createUrl("/admin")); } if ($ugid != false) { $ugid = (int) $ugid; } if (!empty($header)) { $aData['headercfg'] = $header; } else { $aData = array(); } $aViewUrls = array(); $aData['ugid'] = $ugid; $aData['imageurl'] = Yii::app()->getConfig("adminimageurl"); if (Yii::app()->session['loginID']) { if ($ugid) { $ugid = sanitize_int($ugid); $aData["usergroupid"] = $ugid; $result = UserGroup::model()->requestViewGroup($ugid, Yii::app()->session["loginID"]); $crow = $result[0]; if ($result) { $aData["groupfound"] = true; $aData["groupname"] = $crow['name']; if (!empty($crow['description'])) { $aData["usergroupdescription"] = $crow['description']; } else { $aData["usergroupdescription"] = ""; } } //$this->user_in_groups_model = new User_in_groups; $eguquery = "SELECT * FROM {{user_in_groups}} AS a INNER JOIN {{users}} AS b ON a.uid = b.uid WHERE ugid = " . $ugid . " ORDER BY b.users_name"; $eguresult = dbExecuteAssoc($eguquery); $aUserInGroupsResult = $eguresult->readAll(); $query2 = "SELECT ugid FROM {{user_groups}} WHERE ugid = " . $ugid; if (!Permission::model()->hasGlobalPermission('superadmin', 'read')) { $query2 .= " AND owner_id = " . Yii::app()->session['loginID']; } $result2 = dbSelectLimitAssoc($query2, 1); $row2 = $result2->readAll(); $row = 1; $userloop = array(); $bgcc = "oddrow"; foreach ($aUserInGroupsResult as $egurow) { if ($bgcc == "evenrow") { $bgcc = "oddrow"; } else { $bgcc = "evenrow"; } $userloop[$row]["userid"] = $egurow['uid']; // output users $userloop[$row]["rowclass"] = $bgcc; if (Permission::model()->hasGlobalPermission('superadmin', 'update')) { $userloop[$row]["displayactions"] = true; } else { $userloop[$row]["displayactions"] = false; } $userloop[$row]["username"] = $egurow['users_name']; $userloop[$row]["email"] = $egurow['email']; $row++; } $aData["userloop"] = $userloop; if (isset($row2[0]['ugid'])) { $aData["useradddialog"] = true; $aData["useraddusers"] = getGroupUserList($ugid, 'optionlist'); $aData["useraddurl"] = ""; } $aViewUrls[] = 'viewUserGroup_view'; } else { //show listing $aViewUrls['usergroups_view'][] = array(); $aData['model'] = UserGroup::model(); } } if ($ugid == false) { $aData['usergroupbar']['returnbutton']['url'] = 'admin/index'; $aData['usergroupbar']['returnbutton']['text'] = gT('Return to admin home'); } else { $aData['usergroupbar']['edit'] = TRUE; $aData['usergroupbar']['closebutton']['url'] = Yii::app()->createUrl('admin/usergroups/sa/view'); // Close button } if (isset($_GET['pageSize'])) { Yii::app()->user->setState('pageSize', (int) $_GET['pageSize']); } if (!empty($header)) { return array($aViewUrls, $aData); } else { $this->_renderWrappedTemplate('usergroup', $aViewUrls, $aData); } }