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); }
public function getButton2V2ById($id, $moduleId) { $db = Zend_DB_table_Abstract::getDefaultAdapter(); $dbPrivilegeType = $this->getDbTable()->info(); $dbPrivilegeTypeName = $dbPrivilegeType['name']; $privilegeMapper = new Cloud_Model_Privilege_CloudPrivilegeMapper(); $dbPrivilege = $privilegeMapper->getDbTable()->info(); $dbPrivilegeName = $dbPrivilege['name']; $select = $db->select()->from(array('p' => $dbPrivilegeName), array())->join(array('pt' => $dbPrivilegeTypeName), 'p.pri_type_id = pt.id', array('button2'))->where("p.id in ({$id})")->where('p.module_id = ?', $moduleId)->where("pt.description != 'access'")->where("pt.description != 'Edit'")->where("pt.description != 'Delete'"); return $db->fetchAll($select); }
public function editItemAction() { $this->view->headTitle($this->config['title']['editMenuItem']); if ($this->request->getParam('id') != null) { $id = $this->request->getParam('id'); $privilegeMapper = new Cloud_Model_Privilege_CloudPrivilegeMapper(); $currentItem = new Cloud_Model_MenuItem_CloudMenuItem(); $this->menuItemMapper->find($id, $currentItem); $form = new Cloud_Form_Admin_MenuItem_Edit(array('item' => $currentItem, 'privileges' => $privilegeMapper->getAccessPrivilege())); if ($this->getRequest()->isPost()) { if ($form->isValid($this->request->getPost())) { $values = $form->getValues(); $item = new Cloud_Model_MenuItem_CloudMenuItem($values); $this->menuItemMapper->save($item); $this->menuItemMapper->updateHome($values['id'], $values['is_home'], $currentItem->getMenu_cat_id()); $this->view->message = 'Đã sửa item: ' . $item->getName(); } } $this->view->form = $form; } }