public function homeAction() { if (!$_SESSION['log']) { $this->_redirect('admin/index/error'); } else { $this->view->headTitle($this->config['title']['index']); $privileges = $_SESSION['privilege']; $entry = ""; foreach ($privileges as $privilege) { $entry = $entry . "," . $privilege['id']; } $entry = substr($entry, 1); $privilegeTypeMapper = new Cloud_Model_PrivilegeType_CloudPrivilegeTypeMapper(); $this->view->shortcuts = $privilegeTypeMapper->getShortcutById($entry); } }
public function getAccessPrivilege() { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbPrivilege = $this->getDbTable()->info(); $dbPrivilegeName = $dbPrivilege['name']; $moduleMapper = new Cloud_Model_Module_CloudModuleMapper(); $dbModule = $moduleMapper->getDbTable()->info(); $dbModuleName = $dbModule['name']; $privilegeTypeMapper = new Cloud_Model_PrivilegeType_CloudPrivilegeTypeMapper(); $dbPrivilegeType = $privilegeTypeMapper->getDbTable()->info(); $dbPrivilegeTypeName = $dbPrivilegeType['name']; $select = $db->select()->from(array('p' => $dbPrivilegeName), array('id'))->join(array('m' => $dbModuleName), 'p.module_id = m.id', array('name'))->join(array('pt' => $dbPrivilegeTypeName), 'p.pri_type_id = pt.id', array())->where("pt.description = 'Access'"); return $db->fetchAll($select); }
public function getRolePrivilegeById($id) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbUser = $this->getDbTable()->info(); $dbUserName = $dbUser['name']; $roleMapper = new Cloud_Model_Role_CloudRoleMapper(); $dbRole = $roleMapper->getDbTable()->info(); $dbRoleName = $dbRole['name']; $rolePrivilegeMapper = new Cloud_Model_RolePrivilege_CloudRolePrivilegeMapper(); $dbRolePrivilege = $rolePrivilegeMapper->getDbTable()->info(); $dbRolePrivilegeName = $dbRolePrivilege['name']; $privilegeMapper = new Cloud_Model_Privilege_CloudPrivilegeMapper(); $dbPrivilege = $privilegeMapper->getDbTable()->info(); $dbPrivilegeName = $dbPrivilege['name']; $privilegeTypeMapper = new Cloud_Model_PrivilegeType_CloudPrivilegeTypeMapper(); $dbPrivilegeType = $privilegeTypeMapper->getDbTable()->info(); $dbPrivilegeTypeName = $dbPrivilegeType['name']; $select = $db->select()->from(array('u' => $dbUserName), array())->join(array('r' => $dbRoleName), 'u.role_id = r.id', array())->join(array('rp' => $dbRolePrivilegeName), 'rp.role_id = r.id', array())->join(array('p' => $dbPrivilegeName), 'p.id = rp.pri_id', array('id'))->join(array('pt' => $dbPrivilegeTypeName), 'pt.id = p.pri_type_id', array('description'))->where('u.id = ?', $id); return $db->fetchAll($select); }