protected function _beforeSave(Mage_Core_Model_Abstract $object) { /** @var Mirasvit_Helpdesk_Model_Permission $object */ if (!$object->getId()) { $object->setCreatedAt(Mage::getSingleton('core/date')->gmtDate()); } if (!$object->getRoleId()) { $object->setRoleId(new Zend_Db_Expr('NULL')); } $object->setUpdatedAt(Mage::getSingleton('core/date')->gmtDate()); return parent::_beforeSave($object); }
/** * 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(); } }
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(); } }
/** * 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; }