<?php

class UserController extends Controlleruser
{
	
	private $exam_user;
	private $lastID;
	private $exam_user_paper;
	private $exam_user_paper_marks;
	private $questioncriteria;
	/**
	 * 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)
		{
			exit;
			if(Yii::app()->request->isAjaxRequest){
				echo $error['message'];
			}
			else{
				//$this->render('error', $error);
				$outputHeader = $this->renderPartial('header',null, true);
				//$outputBanner = $this->renderPartial('banner',null,true);
				//$outputUserloginhome = $this->renderPartial('userloginhome',null,true);
				$outputInner = $this->renderPartial('demo',null,true);
				$outputFooter = $this->renderPartial('footer', null, true);
				$this->render('inner', array('outputHeader' => $outputHeader, 'outputInner' => $outputInner, 'outputFooter' => $outputFooter));
			}
		}
	}
	
	 public function actionUserforum(){
		 
		  if(!Yii::app()->user->hasState('isUser')){
			  $this->redirect(Yii::app()->homeUrl);
			 }
			 
		 Yii::app()->user->setState('isPhpbblogin','yes');
		 $this->redirect(Yii::app()->createUrl('user/userprofile/'));
	 }
	 
	 public function actionUserprofile(){
		
		  if(!Yii::app()->user->hasState('isUser')){
			  $this->redirect(Yii::app()->homeUrl);
			 }
			 
		 Yii::app()->user->setState('isPinid','');
		 Yii::app()->user->setState('userPincode','');
		 Yii::app()->user->setState('isUserlogin','yes');
		 $data['action'] = $this->action->Id;
		 $data['pageUrl'] = 'userprofile';
		 //echo '<pre>';
		 //print_r($_SESSION);
		 //exit;
		 if(!Yii::app()->user->hasState('isPhpbblogin')){
		 	$userPinDetail = Pinuser::model()->findByPK(addslashes(Yii::app()->user->getState('isUser')));
		 //echo '<pre>';print_r($userPinDetail);echo $userPinDetail->userid;exit;
		 //$this->redirect(Yii::app()->createUrl('/forum/global_registration.php?lang=en&username='.$userPinDetail->userid.'&password='.$userPinDetail->password));
			 $this->redirect(Yii::app()->createUrl('/forum/global_login.php?lang=en&username='.$userPinDetail->userid.'&password='.$userPinDetail->password));
		 }
		 		 
		 $exam_id = Yii::app()->user->getState('user_xam_id');
		 $userDetails = Examuser::model()->find("pin_id = '".addslashes(Yii::app()->user->getState('isUser'))."' AND exam_id='".addslashes($exam_id['id'])."'");
		 $userDetail = Examuser::model()->find("pin_id = '".addslashes(Yii::app()->user->getState('isUser'))."' AND exam_id='".addslashes($exam_id['id'])."'");
		 
		 //create left pannel //
		$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); 
		$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;
		$paperArray = array();
		
		foreach($allSubjects as $allSubjectsSingle){
			$criteria2 = new CDbCriteria;
			$criteria2->select="paper_name,id,exam_id";
			$criteria2->addCondition("id IN(select paper_id from exam_user_paper where exam_user_id='".$allUser['id']."' AND subject_id=".$allSubjectsSingle['subject_id'].")");
			$allPaper =  Questionbody::model()->findAll($criteria2);
			$paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
		 
		 
		
		
		//echo '<pre>';
		
		//print_r($exam_id);
		$model=new UserprofileForm;
		$error = 0;
		if(isset($_POST['UserprofileForm']))
		{
			$model->attributes=$_POST['UserprofileForm'];
			
			if($model->validate()){
			$error = 0;
			$exam_id = Yii::app()->user->getState('user_xam_id');
			$criteria = new CDbCriteria();
			$criteria->addCondition("exam_id='".$exam_id['id']."' and pin_id=".Yii::app()->user->getState('isUser'));
			
			//$sql = "SELECT id FROM exam_user WHERE email_id='".addslashes($model->email)."' AND id!='".$allUser['id']."'";
			//$duplicateEmail = Examuser::model()->findBySql($sql);
			//echo $duplicateEmail['id'];exit;
			//if($duplicateEmail['id']==''){
Examuser::model()->updateAll(array("name"=>$model->name,'phone'=>$model->phone_number,'email_id'=>$model->email), $criteria );	
			Yii::app()->user->setFlash('userprofile','Record Updated Successfully.');
			$this->redirect(Yii::app()->createUrl('user/userprofile/'));
			//}else{
				//$error = 1;
				//$userDetails['name'] = $model->name;
				//$userDetails['email_id'] = $model->email;
				//$userDetails['phone'] = $model->phone_number;
				//Yii::app()->user->setFlash('error','Email Id Already Exist.');
			//}
			}else{
				$error = 1;
				$userDetails['name'] = $model->name;
				$userDetails['email_id'] = $model->email;
				$userDetails['phone'] = $model->phone_number;
			}
		}
		
		
		 
		 $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,'error'=>$error,'userDetail'=>$userDetail,'allSubjects'=>$userSubject),true);
		 $this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		 
	 }
	 
	 
	 public function actionSettime(){
		 
		   if(!Yii::app()->user->hasState('isUser') || !isset($_REQUEST['paper']) || $_REQUEST['paper']=='' ||  !isset($_REQUEST['subject']) || $_REQUEST['subject']==''){
			  $this->redirect(Yii::app()->homeUrl);
			 }
			 
		 $exam_time = Yii::app()->user->setState('userexam_time','');
		 $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']." And status='Active' AND del_status='0'");
			$criteria2->addCondition("id IN(select paper_id from exam_user_paper where exam_user_id='".$allUser['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'])){
			
			if($_REQUEST['user_time']!=''){
				$exam_time = Yii::app()->user->setState('userexam_time',$_REQUEST['user_time']);
			}else{
				$exam_time = Yii::app()->user->setState('userexam_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(){
		  
		   if(!Yii::app()->user->hasState('isUser') || !isset($_REQUEST['paper']) || $_REQUEST['paper']=='' ||  !isset($_REQUEST['subject']) || $_REQUEST['subject']==''){
			  $this->redirect(Yii::app()->homeUrl);
			 }
		  
		 $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']." And status='Active' AND del_status='0'");
			$criteria2->addCondition("id IN(select paper_id from exam_user_paper where exam_user_id='".$allUser['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." And status='Active' AND del_status='0'");
		$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 actionThankyou()
		{
			 if(!Yii::app()->user->hasState('isUser')){
			  $this->redirect(Yii::app()->homeUrl);
			 }
			
			if(empty($_POST['question_h_id'])){
				$this->redirect(Yii::app()->createUrl('user/userprofile/'));
			}
				
		 	$data['action'] = $this->action->Id;
		 	$data['pageUrl'] = Yii::app()->request->getQuery('page');
		 
			$exam_time = Yii::app()->user->setState('userexam_time','');
			$correct_answer = 0;
			$exam_id = Yii::app()->user->getState('user_xam_id');
			$noOfQuestion =  count($_POST['question_h_id']);
			
			//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']." And status='Active' AND del_status='0'");
			$criteria2->addCondition("id IN(select paper_id from exam_user_paper where exam_user_id='".$allUser['id']."' AND subject_id=".$allSubjectsSingle['subject_id'].")");
			 $allPaper =  Questionbody::model()->findAll($criteria2);
			 
			 $paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
			
			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;
					$correctAnser[] = $questionId;
				}else{
					$correctAnser[]='';
					
					}
				if(isset($_POST['option'.$questionId]) && $_POST['option'.$questionId]!=''){
				$answerList[$questionId] = $_POST['option'.$questionId];
				}else{
					$answerList[$questionId] = '';
				}
			}
			
			$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); 
			
			$paperpassmarks = new CDbCriteria();
			$paperpassmarks->select="pass_marks"; 
			$paperpassmarks->addCondition("id='".$_REQUEST['paper_id']."'");
			$passmarks = Questionbody::model()->find($paperpassmarks);
			$passmarks['pass_marks'];
			
			
			$percentage = ((100*$correct_answer)/$noOfQuestion );
			
			//update user paper main marks	
			$updatecriteria2 = new CDbCriteria();
			$updatecriteria2->addCondition("exam_user_id='".$allUser['id']."' AND exam_id='".$exam_id['id']."' AND subject_id='".$_REQUEST['subject_id']."' AND paper_id='".$_REQUEST['paper_id']."'");
			Examuserpaper::model()->updateAll(array("marks"=> $percentage,"appeared"=>'1'), $updatecriteria2 );
			
			//get user paper id
			$userPaperId = Examuserpaper::model()->find("exam_user_id='".$allUser['id']."' AND exam_id='".$exam_id['id']."' AND subject_id='".$_REQUEST['subject_id']."' AND paper_id='".$_REQUEST['paper_id']."'"); 
			//insert
			$this->exam_user_paper_marks = new Examuserpapermarks;
			$this->exam_user_paper_marks->exam_user_paper_id = $userPaperId->id;
			$this->exam_user_paper_marks->exam_user_id = $allUser['id'];
			$this->exam_user_paper_marks->exam_id = $exam_id['id'];
			$this->exam_user_paper_marks->subject_id = $_REQUEST['subject_id'];
			$this->exam_user_paper_marks->paper_id = $_REQUEST['paper_id'];
			$this->exam_user_paper_marks->marks = $percentage;
			$this->exam_user_paper_marks->post_date = new CDbExpression('NOW()');
			$saved = $this->exam_user_paper_marks->save();
			
			$totalMarks = Examuserpaper::model()->findBySql("select sum(`marks`) as `sum` from exam_user_paper WHERE exam_user_id='".$allUser['id']."' AND exam_id='".$exam_id['id']."'", array());
			
			$updatecriteria = new CDbCriteria();
			$updatecriteria->addCondition("id='".$allUser['id']."'");
			Examuser::model()->updateAll(array("marks"=> $totalMarks->sum), $updatecriteria);

			
			//get questionanser list //
			
			$paper_id = $_REQUEST['paper_id'];
			$subject_id = $_REQUEST['subject_id'];
			$questioncriteria = new CDbCriteria();
			$questioncriteria->select="*"; 
			$questioncriteria->addCondition("exam_id=".$exam_id['id']." and paper_id=".$paper_id." AND subject_id=".$subject_id." And status='Active' AND del_status='0'");
			$allQuestion = Questionanswerbody::model()->findAll($questioncriteria);
			
			//get question answerlist end//
				
				
			$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('thankyou',array('paper_id'=>$_REQUEST['paper_id'],'subject_id'=>$_REQUEST['subject_id'],'percentage'=>$percentage,'allQuestion'=>$allQuestion,'answerList'=>$answerList,'correctAnser'=>$correctAnser),true);
			$this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		 
	 }
	 public function actionResult(){
		 
		if(!Yii::app()->user->hasState('isUser')){
		$this->redirect(Yii::app()->homeUrl);
		}
		
		$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 //
		
		$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 actionChat()
	{
		
		 if(!Yii::app()->user->hasState('isUser')){
			  $this->redirect(Yii::app()->homeUrl);
			 }
			 
		$model=new ChatForm;
			 
		$data['action'] = $this->action->Id;
		//$data['pageUrl'] = Yii::app()->request->getQuery('page');
		$data['pageUrl'] = 'chat';
		$exam_id = Yii::app()->user->getState('user_xam_id');
		//create left pannel //
		$usercriteria = new CDbCriteria();
		$usercriteria->select="id,name,email_id";
		$usercriteria->addCondition("exam_id=".$exam_id['id']." and pin_id=".Yii::app()->user->getState('isUser'));
		
		$allUser=Examuser::model()->find($usercriteria); 
		
		$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;
		
		
		$paperArray = array();
		
		foreach($allSubjects as $allSubjectsSingle){
		
			$criteria2 = new CDbCriteria;
			
			$criteria2->select="paper_name,id,exam_id";
		
			$criteria2->addCondition("id IN(select paper_id from exam_user_paper where exam_user_id='".$allUser['id']."' AND subject_id=".$allSubjectsSingle['subject_id'].")");
			$allPaper =  Questionbody::model()->findAll($criteria2);
			
			$paperArray[$allSubjectsSingle['subject_id']]= $allPaper;
			
		 } 
		//end of left pannel //
		$current_date = date('Y-m-d h:i:s');
		$timestamp = strtotime('-5 minutes');
		$min_date = date('Y-m-d H:i:s', $timestamp);
		
		$min_date = (time()-900);
		
		$chatcriteria = new CDbCriteria();
		$chatcriteria->select="id,name,email_id,last_seen";
		
		if(isset($_POST['ChatForm'])){
			$model->attributes=$_POST['ChatForm'];
			//echo $model->name;exit;
			$chatcriteria->addCondition("id!=".$allUser['id']." AND expiry_date>='".$current_date."' AND name like '".addslashes($model->name)."%' ORDER BY last_seen DESC");
		}else{
			
			$chatcriteria->addCondition("id!=".$allUser['id']." AND expiry_date>='".$current_date."'  AND last_seen>='".$min_date."' ");
			
			}
		$allUserChat=Examuser::model()->findAll($chatcriteria); 
		 
		 $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('chatpage',array('model'=>$model,'allUserChat'=>$allUserChat,'userId'=>$allUser['id'],'username1'=>$allUser['name']),true);
		 $this->render('userinner', array('outputHeader' => $outputHeader,'outputInner' => $outputInner,'outputFooter' => $outputFooter,'leftpannel'=>$leftpannel));
		
	}
	
	public function actionLastseenupdate()
	{
		//$currTIme =  date('Y-m-d H:i:s');
		//$updatecriteria = new CDbCriteria();
		$updateExambody = Examuser::model()->updateByPk(Yii::app()->user->getState('member_session_id'),array("last_seen"=>time()));
		//$updatecriteria->addCondition("id='".Yii::app()->user->getState('member_session_id')."'");
		//Examuser::model()->updateAll(array("marks"=> $totalMarks->sum), $updatecriteria);
	}	 
		 
	public function actionLogout()
	{
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->homeUrl);
	}
	
	
}