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;
}
