public static function checkAdministratorPageAccess($adminID, $pageID, $permission)
{
$administrator = new ExtranetUsersGroups();
$select = $administrator->select();
$select->where('EUG_UserID = ?', $adminID)->where('EUG_GroupID = 1');
$row = $administrator->fetchRow($select);
if (count($row) == 0) {
$permissionPage = new ExtranetUsersGroups();
$select = $permissionPage->select()->setIntegrityCheck(false);
$select->from('Extranet_UsersGroups')->join('Extranet_Groups', 'EG_ID = EUG_GroupID')->join('Extranet_Groups_Pages_Permissions', 'EGPP_GroupID = EUG_GroupID')->where('EUG_UserID = ?', $adminID)->where('EGPP_PageID = ?', $pageID)->where('EG_Status = "active"');
if ($permission == "structure") {
$select->where('EGPP_Structure = "Y"');
} elseif ($permission == "data") {
$select->where('EGPP_Data = "Y"');
}
$row = $permissionPage->fetchRow($select);
if (count($row) == 0) {
return false;
} else {
return true;
}
} else {
return true;
}
}
public function IsAdministrator()
{
$auth = Zend_Auth::getInstance();
$data = (array) $auth->getStorage()->read();
if (empty($data)) {
return false;
}
$authID = $data['EU_ID'];
$administrator = new ExtranetUsersGroups();
$select = $administrator->select();
$select->where('EUG_UserID = ?', $authID)->where('EUG_GroupID = 1');
$row = $administrator->fetchRow($select);
if (count($row) == 0) {
return false;
} else {
return true;
}
}
