protected function _filterField($strFieldName, $strFieldValue) { switch ($strFieldName) { case 'role': $this->_select->where('ucac_id IN (SELECT ucur_user_id FROM ' . User_UserRole::TableName() . ' JOIN ' . User_Role::TableName() . ' ON ucr_id=ucur_role_id WHERE ucr_name=?)', $strFieldValue); break; default: parent::_filterField($strFieldName, $strFieldValue); } }
/** * @return array */ public static function getTables() { return array(User_Option::TableName(), User_Account::TableName(), User_Role::TableName(), User_UserRole::TableName(), User_AccessList::TableName()); }