/** * Check if role user exists * * @param Mage_Core_Model_Abstract $user * @return array|false */ public function roleUserExists(Mage_Core_Model_Abstract $user) { if ($user->getUserId() > 0) { $roleTable = $this->getTable('admin/role'); $dbh = $this->_getReadAdapter(); $binds = array('parent_id' => $user->getRoleId(), 'user_id' => $user->getUserId()); $select = $dbh->select()->from($roleTable)->where('parent_id = :parent_id')->where('user_id = :user_id'); return $dbh->fetchCol($select, $binds); } else { return array(); } }
/** * Retrieve roles which exists for user * * @param Mage_Core_Model_Abstract $user * @return array */ public function roleUserExists(Mage_Core_Model_Abstract $user) { $result = array(); if ($user->getUserId() > 0) { $adapter = $this->_getReadAdapter(); $select = $adapter->select()->from($this->getTable('api/role'))->where('parent_id = ?', $user->getRoleId())->where('user_id = ?', $user->getUserId()); $result = $adapter->fetchCol($select); } return $result; }
public function roleUserExists(Mage_Core_Model_Abstract $user) { if ($user->getUserId() > 0) { $roleTable = $this->getTable('api/role'); $dbh = $this->_getReadAdapter(); $select = $dbh->select()->from($roleTable)->where("parent_id = {$user->getRoleId()} AND user_id = {$user->getUserId()}"); return $dbh->fetchCol($select); } else { return array(); } }
public function hasAssigned2Role(Mage_Core_Model_Abstract $user) { if ($user->getId() > 0) { $dbh = $this->_getReadAdapter(); $select = $dbh->select(); $select->from($this->getTable('admin/role'))->where("parent_id > 0 AND user_id = {$user->getUserId()}"); return $dbh->fetchAll($select); } else { return null; } }