public function authenticate() { $q = Yii::app()->dbAdmin->createCommand(); $q->from(AutoAdminAccess::sqlAdminTableName('users')); $q->where(array('AND', 'login = :userName', ), array(':userName'=>$this->username) ); $user = $q->queryRow(); if(!$user) $this->errorCode = self::ERROR_USERNAME_INVALID; elseif($user['password'] != self::hashPassword($this->password)) $this->errorCode = self::ERROR_PASSWORD_INVALID; elseif($user['disabled']) $this->errorCode = self::ERROR_USER_DISABLED; else { $this->errorCode = self::ERROR_NONE; $this->_id = $user['id']; $this->setState('level', $user['level']); $this->setState('interfaceLevel', $user['interface_level']); $this->setState('surname', $user['surname']); $this->setState('firstname', $user['firstname']); Yii::app()->dbAdmin->createCommand()->insert(AutoAdminAccess::sqlAdminTableName('authorizations'), array( 'user_id' => $user['id'], 'when_enter' => date('Y-m-d H:i:s'), 'ip'=> Yii::app()->request->getUserHostAddress(), )); $tableSchema = Yii::app()->dbAdmin->schema->getTable(AutoAdminAccess::sqlAdminTableName('authorizations')); $this->setState('authID', Yii::app()->dbAdmin->getLastInsertID(($tableSchema->sequenceName ? $tableSchema->sequenceName : null))); } return !$this->errorCode; }
/** * Gets default aliases from all user-defined controllers. * @param bool $filterWithExisting Whether to filter the result list with existing (recorded in DB). * @return array An array contains information about interfaces. Format of an element: {defaultAlias}=>array({controllerName}, {actionName}). */ public function getInterfaces($filterWithExisting=false) { $interfaces = array(); $controllersDir = Yii::import('application.modules.autoadmin.controllers.*'); if(is_dir($controllersDir)) { $cFiles = CFileHelper::findFiles($controllersDir, array('fileTypes'=>array('php'))); foreach($cFiles as $cfile) { $controllerName = substr($cfile, strrpos($cfile, DIRECTORY_SEPARATOR)+1, -4); $methods = @get_class_methods($controllerName); if($methods) { $controllerID = substr($controllerName, 0, strrpos($controllerName, 'Controller')); foreach($methods as $methodName) { if($methodName == 'actions' || !preg_match('/^action([a-z_]+)$/i', $methodName, $m)) continue; $actionID = $m[1]; $interfaces[AutoAdmin::interfaceID($controllerID, $actionID)] = array($controllerID, $actionID); } } } } if($interfaces && $filterWithExisting) { $exInterfaces = Yii::app()->dbAdmin->createCommand() ->select('id, alias')->from(AutoAdminAccess::sqlAdminTableName('interfaces')) ->queryAll(); foreach($exInterfaces as $exInterface) { if(isset($interfaces[$exInterface['alias']])) unset($interfaces[$exInterface['alias']]); } } return $interfaces; }