REDROOM

Navigation

Breadcrumbs

/ / home / jambtst2015 / public_html / protected / controllers

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 11.49 KB

/home/jambtst2015/public_html/protected/controllers/UserController_bk.php

Text Base64

<?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);

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 1 Ã— Files: 25

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
_notes DIR	-	drwxr-xr-x	2025-10-13 21:44:23	Edit Download recursive recursive
Copy of HomeController.php	30.97 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
error_log	140.28 KB	lrw-r--r--	2025-11-03 10:09:15	Edit Download recursive recursive
HomeController.php	40.55 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
HomeController_15_9_2014.php	30.92 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
HomeController_bk_11_9_2014.php	30.12 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
HomeController_bk_16_09_2014.php	32.49 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
HomeController_bk_23_9_2014.php	35.00 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
HomeController_bk_24_9_2014.php	38.00 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
HomeController_bk_25_01_2015.php	38.64 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
SiteController.php	2.79 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
UserController.php	23.19 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
UserController_22_9_2014.php	22.67 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
UserController_bk.php	11.49 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
UserController_bk_16_09_2014.php	22.00 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
UserController_bk_sayantan_17_09_2014.php	22.51 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController.php	100.08 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_22_9_2014.php	97.54 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_06_10_2014.php	100.08 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_11_9_2014.php	62.27 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_12_9_2014.php	97.58 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_17_01_2015.php	100.08 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_18_9_2014.php	96.43 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_23_9_2014.php	98.67 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_24_9_2014.php	99.67 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive
WebadminController_bk_29_9_2014.php	100.07 KB	lrw-r--r--	2024-11-22 17:53:11	Edit Download recursive recursive