<?php

class UserController extends Controlleruser
{
	private $exam_user;
	private $lastID;
	private $exam_user_paper;
	
	/**
	 * 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',
			),
		);
	}


	public function actionError()
	{
		if($error=Yii::app()->errorHandler->error)
		{
			if(Yii::app()->request->isAjaxRequest)
				echo $error['message'];
			else
				$this->render('error', $error);
		}
	}
	
	 
	 public function actionUserprofile(){
		 Yii::app()->user->setState('isPinid','');
		 Yii::app()->user->setState('userPincode','');
		 Yii::app()->user->setState('isUserlogin','yes');
		 $data['action'] = $this->action->Id;
		 $data['pageUrl'] = Yii::app()->request->getQuery('page');
		 
		//create lest pannel//
		//echo '<pre>';
		$exam_id = Yii::app()->user->getState('user_xam_id');
		//print_r($exam_id);
		
		$usercriteria = new CDbCriteria();
		$usercriteria->select="id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and pin_id=".Yii::app()->user->getState('isUser'));
		$allUser=Examuser::model()->find($usercriteria); 
		
		//print_r($allUser);
		$usercriteria = new CDbCriteria();
		$usercriteria->select="subject_id,id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and exam_user_id=".$allUser['id']);
		$usercriteria->group = 'subject_id';
		$allSubjects=Examuserpaper::model()->findAll($usercriteria); 
		
		$userSubject = $allSubjects;
		
		//print_r($userSubject);
		$paperArray = array();
		
		foreach($allSubjects as $allSubjectsSingle){
		
			$criteria2 = new CDbCriteria;
			
			$criteria2->select="paper_name,id,exam_id";
			$criteria2->addCondition("exam_id=".$exam_id['id']." and subject_id=".$allSubjectsSingle['subject_id']);
			$allPaper =  Questionbody::model()->findAll($criteria2);
			
			$paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
		 
		 $userDetails = Examuser::model()->find("pin_id = '".addslashes(Yii::app()->user->getState('isUser'))."' AND exam_id='".addslashes($exam_id['id'])."'");
		
		 $model=new UserpinloginForm;
		
		
		 $this->layout = 'inner';
		 $outputHeader = $this->renderPartial('header',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $leftpannel = $this->renderPartial('leftpannel',array('allSubjects'=>$allSubjects,'paperArray'=>$paperArray),true);
		 $outputInner  = $this->renderPartial('userprofile',array('exam_id'=>$exam_id,'model'=>$model,'userDetails'=>$userDetails,'allSubjects'=>$userSubject),true);
		 $this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		 
	 }
	 
	 
	 public function actionSettime(){
		 
		 $data['action'] = $this->action->Id;
		 $data['pageUrl'] = Yii::app()->request->getQuery('page');
		 
		 //create lest pannel//
		 $exam_id = Yii::app()->user->getState('user_xam_id');
		
			$usercriteria = new CDbCriteria();
		$usercriteria->select="id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and pin_id=".Yii::app()->user->getState('isUser'));
		$allUser=Examuser::model()->find($usercriteria); 
		
		//print_r($allUser);
		$usercriteria = new CDbCriteria();
		$usercriteria->select="subject_id,id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and exam_user_id=".$allUser['id']);
		$usercriteria->group = 'subject_id';
		$allSubjects=Examuserpaper::model()->findAll($usercriteria);  

			$paperArray = array();
			
			 foreach($allSubjects as $allSubjectsSingle){
			
			 $criteria2 = new CDbCriteria;
			 
			 $criteria2->select="paper_name,id,exam_id";
			 $criteria2->addCondition("exam_id=".$exam_id['id']." and subject_id=".$allSubjectsSingle['subject_id']);
			 $allPaper =  Questionbody::model()->findAll($criteria2);
			 
			 $paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
		
		$paper_id = $_REQUEST['paper'];
		$subject_id = $_REQUEST['subject'];
		
		if(isset($_REQUEST['submit'])){
			$exam_time = Yii::app()->user->setState('userexam_time',$_REQUEST['user_time']);
			$this->redirect(Yii::app()->createUrl('user/exambatch/paper/'.$_REQUEST['paper_id'].'/subject/'.$_REQUEST['subject_id']));
		}
		
		
		 $this->layout = 'inner';
		 $outputHeader = $this->renderPartial('header',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $leftpannel = $this->renderPartial('leftpannel',array('allSubjects'=>$allSubjects,'paperArray'=>$paperArray),true);
		 $outputInner  = $this->renderPartial('settime',array('exam_id'=>$exam_id),true);
		 $this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		 
		 
		 
	 }
	 
	  public function actionExambatch(){
		  
		 $data['action'] = $this->action->Id;
		 $data['pageUrl'] = Yii::app()->request->getQuery('page');
		 
		 //create lest pannel//
		 $exam_id = Yii::app()->user->getState('user_xam_id');
		
			$usercriteria = new CDbCriteria();
		$usercriteria->select="id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and pin_id=".Yii::app()->user->getState('isUser'));
		$allUser=Examuser::model()->find($usercriteria); 
		
		//print_r($allUser);
		$usercriteria = new CDbCriteria();
		$usercriteria->select="subject_id,id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and exam_user_id=".$allUser['id']);
		$usercriteria->group = 'subject_id';
		$allSubjects=Examuserpaper::model()->findAll($usercriteria);  

			$paperArray = array();
			
			 foreach($allSubjects as $allSubjectsSingle){
			
			 $criteria2 = new CDbCriteria;
			 
			 $criteria2->select="paper_name,id,exam_id";
			 $criteria2->addCondition("exam_id=".$exam_id['id']." and subject_id=".$allSubjectsSingle['subject_id']);
			 $allPaper =  Questionbody::model()->findAll($criteria2);
			 
			 $paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
		
		$paper_id = $_REQUEST['paper'];
		$subject_id = $_REQUEST['subject'];
		$criteria = new CDbCriteria();
        $criteria->select="*"; 
	    $criteria->addCondition("exam_id=".$exam_id['id']." and paper_id=".$paper_id." AND subject_id=".$subject_id);
		$allQuestion = Questionanswerbody::model()->findAll($criteria);
		
		$model=new UserpinloginForm;
		
		
		 $this->layout = 'inner';
		 $outputHeader = $this->renderPartial('header',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $leftpannel = $this->renderPartial('leftpannel',array('allSubjects'=>$allSubjects,'paperArray'=>$paperArray),true);
		 $outputInner  = $this->renderPartial('exambatch',array('exam_id'=>$exam_id,'model'=>$model,'allQuestion'=>$allQuestion),true);
		 $this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		 
		 
		 
	  }
	 
	 public function actionUserexam()
		{
			$exam_time = Yii::app()->user->setState('userexam_time','');
			$correct_answer = 0;
			$exam_id = Yii::app()->user->getState('user_xam_id');
			foreach($_POST['question_h_id'] as $questionId){
				//echo $_POST['option'.$questionId];
				$criteria = new CDbCriteria();
				$criteria->select="correct_ans"; 
				$criteria->addCondition("id=".$questionId);
				$allQuestion = Questionanswerbody::model()->find($criteria);
				$allQuestion['correct_ans'];
				if(isset($_POST['option'.$questionId]) && $_POST['option'.$questionId]==$allQuestion['correct_ans']){
					$correct_answer = $correct_answer+1;
				}
			}
			//echo $correct_answer;exit;
			
					//$updatecriteria = new CDbCriteria();
					//$updatecriteria->addCondition("pin_id='".Yii::app()->user->getState('userName')."'");
					//Examuser::model()->updateAll(array("marks"=> $correct_answer), $updatecriteria );

					$updatecriteria2 = new CDbCriteria();
					$updatecriteria2->addCondition("exam_user_id='".Yii::app()->user->getState('isUser')."' AND exam_id='".$exam_id['id']."' AND subject_id='".$_REQUEST['subject_id']."' AND paper_id='".$_REQUEST['paper_id']."'");
					Examuserpaper::model()->updateAll(array("marks"=> $correct_answer), $updatecriteria2 );
					
					
					
					/*$sql = "select SUM(marks) from exam_user_paper where exam_user_id='".Yii::app()->user->getState('userName')."' AND exam_id='".$exam_id['id']."'";
					$connection=Yii::app()->db;
					$command=$connection->createCommand($sql);
					$dataReader=$command->query();
					//$data = Examuserpaper::model()->query($sql);
					echo '<pre>';
					print_r($dataReader);exit;*/
					
					$this->redirect(Yii::app()->createUrl('user/userprofile/'));
	 }
	 public function actionResult(){
		 
		 $data['action'] = $this->action->Id;
		 $data['pageUrl'] = Yii::app()->request->getQuery('page');
		
		 //create lest pannel//
		 $exam_id = Yii::app()->user->getState('user_xam_id');
		
			$usercriteria = new CDbCriteria();
		$usercriteria->select="id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and pin_id=".Yii::app()->user->getState('isUser'));
		$allUser=Examuser::model()->find($usercriteria); 
		
		//print_r($allUser);
		$usercriteria = new CDbCriteria();
		$usercriteria->select="subject_id,id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and exam_user_id=".$allUser['id']);
		$usercriteria->group = 'subject_id';
		$allSubjects=Examuserpaper::model()->findAll($usercriteria);  

			$paperArray = array();
			
			 foreach($allSubjects as $allSubjectsSingle){
			
			 $criteria2 = new CDbCriteria;
			 
			 $criteria2->select="paper_name,id,exam_id";
			 $criteria2->addCondition("exam_id=".$exam_id['id']." and subject_id=".$allSubjectsSingle['subject_id']);
			 $allPaper =  Questionbody::model()->findAll($criteria2);
			 
			 $paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
		
			$criteria = new CDbCriteria();
            $criteria->select="*";
          
			$criteria->addCondition("exam_user_id=".$allUser['id']);
            $SubjectsArray=Examuserpaper::model()->findAll($criteria); 
		
		 $this->layout = 'inner';
		 $outputHeader = $this->renderPartial('header',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $outputFooter = $this->renderPartial('footer',array('data'=>$data),true);
		 $leftpannel = $this->renderPartial('leftpannel',array('allSubjects'=>$allSubjects,'paperArray'=>$paperArray),true);
		 $outputInner  = $this->renderPartial('result',array('exam_id'=>$exam_id,'subjectsArray'=>$SubjectsArray),true);
		 $this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		 
		 
	 }
		 
		 
	public function actionLogout()
	{
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->homeUrl);
	}
	
	
}