/**
* Authenticates a user.
* @return boolean whether authentication succeeds.
*/
public function authenticate()
{
$user = ASystemUser::model()->find('LOWER(username)=?', array(strtolower($this->username)));
//var_dump($user); exit();
if ($user === null) {
$this->errorCode = self::ERROR_USERNAME_INVALID;
} else {
if (!$user->validatePassword($this->password, Yii::app()->params->hashkey)) {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
} else {
$this->_id = $user->id;
$this->_group_id = $user->group_id;
$this->username = $user->username;
$this->setState('role', $user->group_id);
$this->errorCode = self::ERROR_NONE;
//update login
}
}
return $this->errorCode == self::ERROR_NONE;
}
public static function getUserNameById($id)
{
$criteria = new CDbCriteria();
$criteria->select = 'username';
$criteria->condition = 'id=:id';
$criteria->params = array(':id' => (int) $id);
$rs = ASystemUser::model()->find($criteria);
/*
$connection = Yii::app()->db;
$sql = "SELECT username
FROM {{system_user}}
WHERE id = '".$id."'";
$command = $connection->createCommand($sql);
*/
//$rs = $command->queryRow();
if (isset($rs) && $rs['username'] != '') {
return $rs['username'];
} else {
return false;
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = ASystemUser::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function getSystemUserById($id)
{
return ASystemUser::model()->find('id=:id', array(':id' => $id));
}