reset password

<?php

class SiteController extends Controller
{
	/**
	 * Declares class-based actions.
	 */
	public function actions()
	{
		return array(
			// captcha action renders the CAPTCHA image displayed on the contact page
			'captcha'=>array(
				'class'=>'CCaptchaAction',
				'backColor'=>0xFFFFFF,
			),
			// page action renders "static" pages stored under 'protected/views/site/pages'
			// They can be accessed via: index.php?r=site/page&view=FileName
			'page'=>array(
				'class'=>'CViewAction',
			),
		);
	}

	/**
	 * This is the default 'index' action that is invoked
	 * when an action is not explicitly requested by users.
	 */
	public function actionIndex()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		$this->render('index');
	}





	/**
	 * This is the action to handle external exceptions.
	 */
	public function actionError()
	{
		if($error=Yii::app()->errorHandler->error)
		{
			if(Yii::app()->request->isAjaxRequest)
				echo $error['message'];
			else
				$this->render('error', $error);
		}
	}

	/**
	 * Displays the contact page
	 */
	public function actionContact()
	{
		$model=new ContactForm;
		if(isset($_POST['ContactForm']))
		{
			$model->attributes=$_POST['ContactForm'];
			if($model->validate())
			{
				$name='=?UTF-8?B?'.base64_encode($model->name).'?=';
				$subject='=?UTF-8?B?'.base64_encode($model->subject).'?=';
				$headers="From: $name <{$model->email}>\r\n".
					"Reply-To: {$model->email}\r\n".
					"MIME-Version: 1.0\r\n".
					"Content-type: text/plain; charset=UTF-8";

				mail(Yii::app()->params['adminEmail'],$subject,$model->body,$headers);
				Yii::app()->user->setFlash('contact','Thank you for contacting us. We will respond to you as soon as possible.');
				$this->refresh();
			}
		}
		$this->render('contact',array('model'=>$model));
	}

	/**
	 * Displays the login page
	 */
	public function actionLogin()
	{
		$model=new LoginForm;

		// if it is ajax validation request
		if(isset($_POST['ajax']) && $_POST['ajax']==='login-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}

		// collect user input data
		if(isset($_POST['LoginForm']))
		{
			$model->attributes=$_POST['LoginForm'];
			// validate user input and redirect to the previous page if valid
			if($model->validate() && $model->login())
				$this->redirect(Yii::app()->user->returnUrl);
		}
		// display the login form
		$this->render('login',array('model'=>$model));
	}

	/**
	 * Logs out the current user and redirect to homepage.
	 */
	public function actionLogout()
	{
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->homeUrl);
	}

	public function actionResetPassword(){

		$model = new ResetPassword;
		$msg = '';
		if(isset($_POST['ResetPassword']))
		{
			$model->attributes= $_POST['ResetPassword'];
			if(!$model->validate())
			{
				$msg = "<strong class='text-error'>formulir yang diisi salah</strong>";
			}else{

				$connect= Yii::app()->db;

				$query = "SELECT username, email FROM user where";
				$query .= "username='".$model->username."' AND email='".$model->email."'";

				$tes = $connect->createCommand($query);
				$rows = $tes->query();
				$hasil= false;

				foreach($rows as $row)
				{
					$hasil = true;
				}

				if($hasil === true)
				{
					$query = "SELECT username, email FROM user where";
					// $query .= "username='".$model->username."' AND email='"$model->email;
					$query .= "username='".$model->username."' AND email='".$model->email."'";

					$tes = $connect->createCommand($query)->query();
					$tes->bindColumn(1,$password);

					while($tes->read()!==false)
					{
						$password = $password;
					}

					$email = new SubmitEmail;
					$subject = "permintaan untuk pemulihan password";
					$subject .= Yii::app()->name;
					$message =	"welcome@".$model->username." dengan password";
					$message .= $password;
					$message .= "<br /><br />";
					$message .= "<a href='http://localhost/latihan/forgot/'>kembali</a>";

					$email->Submit_Email(

						array(Yii::app()->params['adminEmail'], Yii::app()->name),
						array($model->email,$model->username),

						$subject,
						$message
						);

					$model->username = '';
					$model->email = '';
					$model->captcha = '';
					$msg="<strong class='text-info'>congratulation, we have sent your password to your email account</strong>";
				}else
				{
					$msg ="<strong class='text-error'>error data tidak ada</strong>";
				}
			}
		}


		$this->render('resetpassword',array('model'=>$model,'msg'=>$msg));
	}
}