REDROOM

Navigation

Breadcrumbs

/ / home / jambtst2015 / public_html / serverfile

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 32.77 KB

/home/jambtst2015/public_html/serverfile/WebadminController.php

Text Base64

<?php

class WebadminController extends Controlleradmin
{
	private $exam_body;
	private $subject_body;
	private $question_body;
	private $lastID;
	private $ajax_val;
	private $question_answer;
	
	/**
	 * Declares class-based actions.
	 */
	 
	 
	 
	 
	 	/**
	 * tableId 1 for exambody
	 * tableId 2 for exam_subject
	 * tableId 3 for exam_paper
	 * tableId 4 for exam_question
	 */
	 
	 
	 
	 
	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->pageTitle = Yii::app()->name . ' - Dashboard';
        /*$this->breadcrumbs = array(
                'Login / Register',
        );*/
		//echo Helpers::getsingleRecord('exam_body','name','id','1');
		//$this->getsingleRecord('Exambody::','name','id','1');
		
		
		//echo $filename = Yii::app()->params['imagebasePath'].'/pincsv/pin.csv';
		//echo '<br>';
		//$record = Csvreader::parse_file($filename);
		//$record = $this->parse_file($filename);
		//print_r($record);
		//exit;
		
		
		$this->layout = 'adminmain';
		$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);
		}
	}
	
	/**
	 * This is the default 'index' action that is invoked
	 * when an action is not explicitly requested by users.
	 */
	public function actionExambodylist()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		
		$this->pageTitle = Yii::app()->name . ' - Login / Register';
        /*$this->breadcrumbs = array(
                'Login / Register',
        );*/
		
		if(empty($_GET['page'])){
			$pageNo = 1;
		}else{
			$pageNo = $_GET['page'];
		}
		
		$criteria=new CDbCriteria(array('order'=>'id desc'));
		$criteria->compare('del_status',0);
	   	$count=Exambody::model()->count($criteria);
    	$pages=new CPagination($count);

// results per page
    	$pages->pageSize=2;
    	$pages->applyLimit($criteria);
    	$models=Exambody::model()->findAll($criteria);
		$allExambody = $models;
		$this->layout = 'adminmain';
		$this->render('exambodylist',array('allExambody'=>$allExambody,'pageMax' => $pages->pageSize,'pageNo' => $pageNo,'pages' => $pages));
	}
	
	/**
	 * Displays the exam bode page
	 */
	public function actionExambody()
	{
		$model=new ExambodyForm;
		//echo Yii::app()->imagebasePath;
		$editId = Yii::app()->request->getQuery('edit');
		if($editId > 0){		//edit
			$this->pageTitle = Yii::app()->name . ' - Exam Body Edit';
			$this->breadcrumbs=array(
				'Exam Body'=>array('webadmin/exambodylist'),
				'Exam Body Edit',
			);
			$editRecord = Exambody::model()->findByPK($editId);
		}else{					//add
			$this->pageTitle = Yii::app()->name . ' - Exam Body Add';
			$this->breadcrumbs=array(
				'Exam Body'=>array('webadmin/exambodylist'),
				'Exam Body Add',
			);
			$editRecord['name']='';
			$editRecord['full_name']='';
			$editRecord['logo']='';
			$editRecord['validity']='';
		}
		
		
		if(isset($_POST['ExambodyForm']))
		{
			$model->attributes=$_POST['ExambodyForm'];
			if($model->validate())
			{
				$editId = Yii::app()->request->getQuery('edit');
				if($editId > 0){		//edit
				$record = Exambody::model()->find("name = '".$model->name."' AND id!='".$editId."' AND del_status='0'");
					if (empty($record)){
					//$editRecord = Exambody::model()->findByPK($editId);
					//image upload
					$uploadedFile=CUploadedFile::getInstance($model,'image');
					if(!empty($uploadedFile)){
						$rnd = time();  // generate random number between 0-9999
						$fileName = "{$rnd}-{$uploadedFile}";  // random number + file name
						$model->image = $fileName;
						$uploadedFile->saveAs(Yii::app()->params['imagebasePath'].'/exambody/'.$fileName);  // image will uplode to rootDirectory/banner/
					}else{
					
						
						$model->image = $_REQUEST['h_image'];
					}
					//update
					$updateExambody = Exambody::model()->updateByPk($editId,array("name"=>$model->name,"full_name"=>$model->full_name,"logo"=>$model->image,"validity"=>$model->validity,"modify_date"=>new CDbExpression('NOW()'))); 
					if($updateExambody){
						Yii::app()->user->setFlash('exambody','Exam Body Updated Successfully.');
						//$this->refresh();
						$this->redirect(Yii::app()->createUrl('webadmin/exambodylist/'));
					}
					}else{
						
						// record exists
						Yii::app()->user->setFlash('error','Exam Body Already Exists.');
						$editRecord['name']=$model->name;
						$editRecord['full_name']=$model->full_name;
					}
				}else{					//add
					$record = Exambody::model()->find("name = '".$model->name."' AND del_status='0'");
					if (empty($record)){
						// record does't exist
						//exit("record does't exist");
						
						//image upload
						$uploadedFile=CUploadedFile::getInstance($model,'image');
						if(!empty($uploadedFile)){
							$rnd = time();  // generate random number between 0-9999
							$fileName = "{$rnd}-{$uploadedFile}";  // random number + file name
							$model->image = $fileName;
							$uploadedFile->saveAs(Yii::app()->params['imagebasePath'].'/exambody/'.$fileName);  // image will uplode to rootDirectory/banner/
						}else{
							$model->image = '';
						}
						//insert
						$this->exam_body = new Exambody;
						$this->exam_body->name = $model->name;
						$this->exam_body->full_name = $model->full_name;
						$this->exam_body->logo = $model->image;
						$this->exam_body->validity = $model->validity;
						$this->exam_body->post_date = new CDbExpression('NOW()');
						$saved = $this->exam_body->save();
						$this->lastID = Yii::app()->db->getLastInsertID();
						//exit($this->lastID);
						if($this->lastID){
							Yii::app()->user->setFlash('exambody','Exam Body Added Successfully.');
							//$this->refresh();
							$this->redirect(Yii::app()->createUrl('webadmin/exambodylist/'));
						}
					}else {
						// record exists
						Yii::app()->user->setFlash('error','Exam Body Already Exists.');
						$editRecord['name']=$model->name;
						$editRecord['full_name']=$model->full_name;
						//$this->refresh();
						//exit("record exists");
					}
				}
				
			}
		}
		for($days=1;$days<366;$days++){
			$dayArray[$days] = $days;
		}
		
		
		$this->layout = 'adminmain';
		$this->render('exambody',array('model'=>$model,'editRecord'=>$editRecord,'dayArray'=>$dayArray));
	}

/**
	 * 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->layout = 'adminmain';
		$this->render('contact',array('model'=>$model));
	}

/**
	 * Displays the login page
	 */
	public function actionLogin()
	{
		//exit("actionLogin");
		$model=new AdminLoginForm;
		$this->pageTitle=Yii::app()->name . ' - Administration Login';
		// 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['AdminLoginForm']))
		{
			//exit("actionLogin");
			$model->attributes=$_POST['AdminLoginForm'];
			// validate user input and redirect to the previous page if valid
			if($model->validate() && $model->login())
				$this->redirect(Yii::app()->user->returnUrl.'webadmin/');
		}
		$this->layout = 'adminmain';
		// display the login form
		$this->render('login',array('model'=>$model));
	}
	
	
	// List The subjects //
	
	public function actionSubjectlist()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		
		$this->pageTitle = Yii::app()->name . ' - Login / Register';
        /*$this->breadcrumbs = array(
                'Login / Register',
        );*/
		
		if(empty($_GET['page'])){
			$pageNo = 1;
		}else{
			$pageNo = $_GET['page'];
		}
		
		$criteria=new CDbCriteria(array('order'=>'id desc'));
		$criteria->compare('del_status',0);
	   	$count=Subjectbody::model()->count($criteria);
    	$pages=new CPagination($count);

// results per page
    	$pages->pageSize=2;
    	$pages->applyLimit($criteria);
    	$models=Subjectbody::model()->findAll($criteria);
		$allSubject = $models;
		$this->layout = 'adminmain';
		$this->render('subjectbodylist',array('allSubject'=>$allSubject,'pageMax' => $pages->pageSize,'pageNo' => $pageNo,'pages' => $pages));
	}
	
	//end of subject Listing//
	
	//add or edit subject//
	
	
	public function actionSubjectbody()
	{
		$model=new SubjectbodyForm;
		
		$editId = Yii::app()->request->getQuery('edit');
		if($editId > 0){		//edit
		
			$this->breadcrumbs=array(
				'Subject Body'=>array('webadmin/subjectlist'),
				'Subject Body Edit',
			);
			$editRecord = Subjectbody::model()->findByPK($editId);
		}else{					//add
		
			$this->breadcrumbs=array(
				'Subject Body'=>array('webadmin/subjectlist'),
				'Subject Body Add',
			);
			
			$editRecord['exam_name']='';
			$editRecord['subject']='';
			$editRecord['pass_marks']='';
			$editRecord['compulsory']='';
			$editRecord['exam_id']='';
		}
		
		
		if(isset($_POST['SubjectbodyForm']))
		{
			$model->attributes=$_POST['SubjectbodyForm'];
			if($model->validate())
			{
				$editId = Yii::app()->request->getQuery('edit');
				if($editId > 0){		//edit
				
					$record = Subjectbody::model()->find("subject = '".$model->subject_name."' AND exam_id='".$model->exam_name."' AND id!='".$editId."'  AND del_status='0'");
					if (empty($record)){
					
					//update
					$updateExambody = Subjectbody::model()->updateByPk($editId,array("exam_id"=>$model->exam_name,"subject"=>$model->subject_name,"pass_marks"=>$model->marks,"compulsory"=>$model->compulsory,"modify_date"=>new CDbExpression('NOW()'))); 
					if($updateExambody){
						Yii::app()->user->setFlash('subjectbody','Subject Body Updated Successfully.');
						//$this->refresh();
						$this->redirect(Yii::app()->createUrl('webadmin/subjectlist/'));
					}
					}else{
						
						// record exists
						Yii::app()->user->setFlash('error','Subject Already Exists.');
						$editRecord['subject_name']=$model->subject_name;
						$editRecord['exam_name']=$model->exam_name;
						$editRecord['marks']=$model->marks;
					}
				}else{					//add
				
					
				
					$record = Subjectbody::model()->find("subject = '".$model->subject_name."' AND exam_id='".$model->exam_name."'  AND del_status='0'");
					if (empty($record)){
						
						//insert
						$this->subject_body = new Subjectbody;
						$this->subject_body->exam_id = $model->exam_name;
						$this->subject_body->subject= $model->subject_name;
						$this->subject_body->pass_marks = $model->marks;
						//$this->subject_body->pass_marks = $model->marks;
						$this->subject_body->compulsory = $model->compulsory;
						//$this->subject_body->logo = $model->image;
						$this->subject_body->post_date = new CDbExpression('NOW()');
						$saved = $this->subject_body->save();
						$this->lastID = Yii::app()->db->getLastInsertID();
						//exit($this->lastID);
						if($this->lastID){
							Yii::app()->user->setFlash('subjectbody','Subject Added Successfully.');
							//$this->refresh();
							$this->redirect(Yii::app()->createUrl('webadmin/subjectlist/'));
						}
					}else {
						// record exists
						Yii::app()->user->setFlash('error','Subject Already Exists.');
						$editRecord['subject_name']=$model->subject_name;
						$editRecord['exam_name']=$model->exam_name;
						$editRecord['marks']=$model->marks;
						//$editRecord['exam_name']=$model->exam_name;
						//$this->refresh();
						//exit("record exists");
					}
				}
				
			}
		}
		$criteria=new CDbCriteria(array('order'=>'name desc'));
		$criteria->compare('del_status',0);
		$models=Exambody::model()->findAll("status='Active' and del_status='0' order by name asc");
		$allSubject = $models;
		$allSubjectarray=CHtml::listData($allSubject, 'id', 'name');
		$this->layout = 'adminmain';
		$this->render('subjectbody',array('model'=>$model,'editRecord'=>$editRecord,'allSubjectarray'=>$allSubjectarray));
	}
	
	
	//end of add edit subject//
	
	
	
	//question paper listing//
	
	public function actionQuestionbatch()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		
		$this->pageTitle = Yii::app()->name . ' - Login / Register';
        /*$this->breadcrumbs = array(
                'Login / Register',
        );*/
		
		if(empty($_GET['page'])){
			$pageNo = 1;
		}else{
			$pageNo = $_GET['page'];
		}
		
		$criteria=new CDbCriteria(array('order'=>'id desc'));
		$criteria->compare('del_status',0);
	   	$count=Questionbody::model()->count($criteria);
    	$pages=new CPagination($count);

// results per page
    	$pages->pageSize=2;
    	$pages->applyLimit($criteria);
    	$models=Questionbody::model()->findAll($criteria);
		$allQuestions = $models;
		$this->layout = 'adminmain';
		$this->render('questionbodylist',array('allQuestions'=>$allQuestions,'pageMax' => $pages->pageSize,'pageNo' => $pageNo,'pages' => $pages));
	}
	
	//end of question paper listing//
	
	
	
	
	//question add or edit //
	
	public function actionQuestionaddedit()
	{
		
		$model=new QuestionbodyForm;
		
		$editId = Yii::app()->request->getQuery('edit');
		if($editId > 0){		//edit
		
			$this->breadcrumbs=array(
				'Question Paper'=>array('webadmin/questionbatch'),
				'Question Paper Edit',
			);
			$editRecord = Questionbody::model()->findByPK($editId);
			$subjects=Subjectbody::model()->findAll("exam_id=".$editRecord['exam_id']." AND del_status='0' AND  status='Active'");
			$allSubjectarray=CHtml::listData($subjects, 'id', 'subject');
			$subject = $allSubjectarray;
			
			
			
			
			
		}else{					//add
		
			$this->breadcrumbs=array(
				'Question Paper'=>array('webadmin/questionbatch'),
				'Question Paper Add',
			);
			
		
			$editRecord['subject_id']='';
			$editRecord['paper_name']='';
			$editRecord['pass_marks']='';
			$editRecord['compulsory']='';
			$editRecord['exam_id']='';
			$subject = array();
			$paper = array();
		}
		
		
		if(isset($_POST['QuestionbodyForm']))
		{
			$model->attributes=$_POST['QuestionbodyForm'];
			if($model->validate())
			{
				$editId = Yii::app()->request->getQuery('edit');
				if($editId > 0){		//edit
				
					$record = Questionbody::model()->find("exam_id = '".$model->exam_name."' AND subject_id='".$model->subject_name."' AND paper_name='".$model->question_paper_name."' AND id!='".$editId."'  AND del_status='0'");
					if (empty($record)){
					
					$updateExambody = Questionbody::model()->updateByPk($editId,array(
					"exam_id"=>$model->exam_name,
					"subject_id"=>$model->subject_name,
					"pass_marks"=>$model->marks,
					"paper_name"=>$model->question_paper_name,
					"modify_date"=>new CDbExpression('NOW()')
					)); 
					if($updateExambody){
						Yii::app()->user->setFlash('questionbody','Question Paper Updated Successfully.');
						//$this->refresh();
						$this->redirect(Yii::app()->createUrl('webadmin/questionbatch/'));
				}
				}else{
						
						// record exists
						Yii::app()->user->setFlash('error','Question Already Exists.');
						
						//$test = $this->actionAjaxpage('1',$editRecord['exam_id']);
						
						//print_r($test);exit;
						
						$editRecord['exam_id']=$model->exam_name;
						$editRecord['paper_name']=$model->question_paper_name;
						$editRecord['pass_marks']=$model->marks;
					}
				}else{					//add
					$record = Questionbody::model()->find("exam_id = '".$model->exam_name."' AND subject_id='".$model->subject_name."'AND paper_name='".$model->question_paper_name."'  AND del_status='0'");
					if (empty($record)){

//insert
						$this->question_body = new Questionbody;
						$this->question_body->exam_id = $model->exam_name;
						$this->question_body->subject_id= $model->subject_name;
						$this->question_body->pass_marks= $model->marks;
						$this->question_body->paper_name = $model->question_paper_name;
						
						$this->question_body->post_date = new CDbExpression('NOW()');
						$saved = $this->question_body->save();
						$this->lastID = Yii::app()->db->getLastInsertID();
						//exit($this->lastID);
						if($this->lastID){
							Yii::app()->user->setFlash('questionbody','Question Paper Added Successfully.');
							//$this->refresh();
							$this->redirect(Yii::app()->createUrl('webadmin/questionbatch/'));
						}
					}else {
						// record exists
						Yii::app()->user->setFlash('error','Question Already Exists.');
						
						$editRecord['exam_id']=$model->exam_name;
						
						$get_subject =$subjects=Subjectbody::model()->findAll("exam_id=".$editRecord['exam_id']." AND  status='Active' AND del_status='0'");
						$subject = CHtml::listData($get_subject, 'id', 'subject');
						
						//print_r($editRecord['subject_id']);exit;
						
						$editRecord['paper_name']=$model->question_paper_name;
						$editRecord['pass_marks']=$model->marks;
					
					}
				}
				
			}
		}
		$criteria=new CDbCriteria(array('order'=>'name desc'));
		$criteria->compare('del_status',0);
		$criteria->compare('status','Active');
		$models=Exambody::model()->findAll($criteria);
		$allSubject = $models;
		$allSubjectarray=CHtml::listData($allSubject, 'id', 'name');
		$this->layout = 'adminmain';
		$this->render('questionbody',array('model'=>$model,'editRecord'=>$editRecord,'subject'=>$subject,'allSubjectarray'=>$allSubjectarray));
	}
	
	//end of question add or edit//
	
	
	//get ajax value//
	
	public function actionAjaxpage($flag='',$purpose='')
	{
		
		if($flag!=''){
			$_REQUEST['flag']=$flag;
		}
		if($purpose!=''){
			$_REQUEST['value']=$purpose;
		}
		if($_REQUEST['flag']==1){
			//flag 1//
		$subjects=Subjectbody::model()->findAll("exam_id=".$_REQUEST['value']." AND  status='Active' AND del_status='0'");
		$allSubject = $subjects;
		
		$allSubjectarray=CHtml::listData($allSubject, 'id', 'subject');
		$opVal = '';
		$opVal = '<option value="">Select subject name</option>';
		foreach($allSubjectarray as $key=>$value){
			$opVal .= '<option value="'.$key.'">'.$value.'</option>';
		}
		if($flag!='' && $purpose!=''){
			return $opVal;
		}else{
		echo $opVal;
		}
		
		}
		elseif($_REQUEST['flag']==2){
			//flag 2//
		$subjects=Questionbody::model()->findAll("exam_id=".$_REQUEST['value']." AND subject_id='".$_REQUEST['subject']."' AND  status='Active' AND DEL_status='0'");
		$allSubject = $subjects;
		
		$allSubjectarray=CHtml::listData($allSubject, 'id', 'paper_name');
		$opVal = '';
		$opVal = '<option value="">Select paper name</option>';
		foreach($allSubjectarray as $key=>$value){
			$opVal .= '<option value="'.$key.'">'.$value.'</option>';
		}
			if($flag!='' && $purpose!=''){
				return $opVal;
			}else{
				echo $opVal;
			}
			
		}
	}
	
	//end of ajax value//
	
	
	//add question along with multiple answer//
	
	public function actionConfigurequestionbatch(){
		
		
		
		$model=new QuestionanswerForm;
		
		$editId = Yii::app()->request->getQuery('edit');
		if($editId > 0){		//edit
		
			$this->breadcrumbs=array(
				'Question Batch'=>array('webadmin/listinganswers'),
				'Question Batch Edit',
			);
			$editRecord = Questionanswerbody::model()->findByPK($editId);
			$subjects=Subjectbody::model()->findAll("exam_id=".$editRecord['exam_id']." AND  status='Active' AND del_status='0'");
			$allSubjectarray=CHtml::listData($subjects, 'id', 'subject');
			
			$subject = $allSubjectarray;
			
			
			$papers = Questionbody::model()->findAll("subject_id=".$editRecord['subject_id']." AND  status='Active' AND del_status='0'");
			$allPaperarray=CHtml::listData($papers, 'id', 'paper_name');
			$paper = $allPaperarray;
			
			$model->correct_answer = $editRecord['correct_ans'];
			
		}else{					//add
		
			$this->breadcrumbs=array(
				'Question Batch'=>array('webadmin/listinganswers'),
				'Question Batch Add',
			);
			
		
			$editRecord['subject_id']='';
			//$editRecord['paper_name']='';
			$editRecord['paper_id']='';
			//$editRecord['paper_name']='';
			$editRecord['question']='';
			$editRecord['exam_id']='';
			$editRecord['ans1']='';
			$editRecord['ans2']='';
			$editRecord['ans3']='';
			$editRecord['ans4']='';
			$editRecord['ans5']='';
			$paper=array();
			
			//$model->correct_answer ='';
			
			$subject = array();
		}
		
		
		if(isset($_POST['QuestionanswerForm']))
		{
			$model->attributes=$_POST['QuestionanswerForm'];
			if($model->validate())
			{
				$editId = Yii::app()->request->getQuery('edit');
				if($editId > 0){		//edit

$record = Questionanswerbody::model()->find("exam_id = '".$model->exam_name."' AND subject_id='".$model->subject_name."' AND paper_id='".$model->paper_name."' AND question='".$model->question."' AND id!='".$editId."'  AND del_status='0'");
					if (empty($record)){
					
					$updateExambody = Questionanswerbody::model()->updateByPk($editId,array(
					"exam_id"=>$model->exam_name,
					"subject_id"=>$model->subject_name,
					"paper_id"=>$model->paper_name,
					"question"=>$model->question,
					"ans1"=>$model->answer1,
					"ans2"=>$model->answer2,
					"ans3"=>$model->answer3,
					"ans4"=>$model->answer4,
					"ans5"=>$model->answer5,
					"correct_ans"=>$model->correct_answer,
					"modify_date"=>new CDbExpression('NOW()')
					
					)); 
					if($updateExambody){
						Yii::app()->user->setFlash('questionbody','Question Batch Updated Successfully.');
						//$this->refresh();
						$this->redirect(Yii::app()->createUrl('webadmin/listinganswers/'));
				}
				}else{
						
						// record exists
						Yii::app()->user->setFlash('error','Question Already Exists.');
						
						$editRecord['exam_id']=$model->exam_name;
						$editRecord['paper_name']=$model->question_paper_name;
						$editRecord['pass_marks']=$model->marks;
					}
				}else{					//add
					$record = Questionanswerbody::model()->find("exam_id = '".$model->exam_name."' AND subject_id='".$model->subject_name."' AND paper_id='".$model->paper_name."' AND question='".$model->question."'  AND del_status='0'");
					if (empty($record)){

//insert
						$this->question_answer = new Questionanswerbody;
						$this->question_answer->exam_id = $model->exam_name;
						$this->question_answer->subject_id= $model->subject_name;
						$this->question_answer->paper_id= $model->paper_name;
						$this->question_answer->question = $model->question;
						$this->question_answer->ans1 = $model->answer1;
						$this->question_answer->ans2 = $model->answer2;
						$this->question_answer->ans3 = $model->answer3;
						$this->question_answer->ans4 = $model->answer4;
						$this->question_answer->ans5 = $model->answer5;
						$this->question_answer->correct_ans = $model->correct_answer;
						
						$this->question_answer->post_date = new CDbExpression('NOW()');
						$saved = $this->question_answer->save();
						$this->lastID = Yii::app()->db->getLastInsertID();
						//exit($this->lastID);
						if($this->lastID){
							Yii::app()->user->setFlash('questionanswer','Question Batch Added Successfully.');
							//$this->refresh();
							$this->redirect(Yii::app()->createUrl('webadmin/listinganswers/'));
						}
					}else {
						// record exists
						Yii::app()->user->setFlash('error','Question Already Exists.');
						
						$editRecord['exam_id']=$model->exam_name;
						$editRecord['question']=$model->question;
						$editRecord['ans1']=$model->answer1;
						$editRecord['ans2']=$model->answer2;
						$editRecord['ans3']=$model->answer3;
						$editRecord['ans4']=$model->answer4;
						$editRecord['ans5']=$model->answer5;
						$model->correct_answer = $model->correct_answer;
						$editRecord['paper_id']=$model->paper_name;
						$editRecord['pass_marks']=$model->marks;
					
					}
				}
				
			}
		}
		$criteria=new CDbCriteria(array('order'=>'name desc'));
		$criteria->compare('del_status',0);
		$criteria->compare('status','Active');
		$models=Exambody::model()->findAll($criteria);
		
		$allSubject = $models;
		$allSubjectarray=CHtml::listData($allSubject, 'id', 'name');
		$this->layout = 'adminmain';
		$this->render('questionanswerbody',array('model'=>$model,'editRecord'=>$editRecord,'subject'=>$subject,'paper'=>$paper,'allSubjectarray'=>$allSubjectarray));
	
		
	}
	
	//end of add question along with multiple answer//
	
	
	//listing of question and ansqer//
	
	public function actionListinganswers()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		
		$this->pageTitle = Yii::app()->name . ' - Login / Register';
        /*$this->breadcrumbs = array(
                'Login / Register',
        );*/
		
		if(empty($_GET['page'])){
			$pageNo = 1;
		}else{
			$pageNo = $_GET['page'];
		}
		
		$criteria=new CDbCriteria(array('order'=>'id desc'));
		$criteria->compare('del_status',0);
	   	$count=Questionanswerbody::model()->count($criteria);
    	$pages=new CPagination($count);

// results per page
    	$pages->pageSize=2;
    	$pages->applyLimit($criteria);
    	$models=Questionanswerbody::model()->findAll($criteria);
		$criteria->compare('del_status',0);
		$allQuestionsanswers = $models;
		$this->layout = 'adminmain';
		$this->render('questionbatchlist',array('allQuestionsanswers'=>$allQuestionsanswers,'pageMax' => $pages->pageSize,'pageNo' => $pageNo,'pages' => $pages));
	}
	
	
	//end of listing//

/**
	 * Logs out the current user and redirect to homepage.
	 */
	 
	 public function actionDelete(){
		 
		 $criteria = new CDbCriteria;

$table = $_REQUEST['table'];
		 $id	= $_REQUEST['id'];
		 if( $table=='1'){
			
			/*$models = Exambody::model()->findAll(" id='".$id."'");
			if($models[0]['logo']!=''){
			unlink(Yii::app()->params['imagebasePath'].'/exambody/'.$models[0]['logo']); 
			}*/
		 	Exambody::model()->updateByPk($id,array(
					"del_status"=> '1'
					)); 
			
			//Update subject table//
			$criteria->addCondition("exam_id='".$id."'");

Subjectbody::model()->updateAll(array("del_status"=> '1'), $criteria );
			//Update subject table//
			
			//Update Question paper table//
			$criteria->addCondition("exam_id='".$id."'");

Questionbody::model()->updateAll(array("del_status"=> '1'), $criteria );
			//End of Update Question paper table//		
			
			//Update Question batch table//
			$criteria->addCondition("exam_id='".$id."'");

Questionanswerbody::model()->updateAll(array("del_status"=> '1'), $criteria );
			//End of Update Question batch table//		
			
			Yii::app()->user->setFlash('exambody','Record Deleted Successfully.');
		 }
		 
		 
		 if($table=='2'){
			 Subjectbody::model()->updateByPk($id,array(
					"del_status"=> '1'
					));
					
					
			 //Update Question paper table//
			$criteria->addCondition("subject_id='".$id."'");

Questionanswerbody::model()->updateAll(array("del_status"=> '1'), $criteria );
			//End of Update Question batch table//	
			
			 Yii::app()->user->setFlash('subjectbody','Record Deleted Successfully.');
		 }
		 
		 
		 
		 if($table=='3'){
			 Questionbody::model()->updateByPk($id,array(
					"del_status"=> '1'
					));
					
			//Update Question batch table//
			$criteria->addCondition("paper_id='".$id."'");

Questionanswerbody::model()->updateAll(array("del_status"=> '1'), $criteria );
			//End of Update Question batch table//	
			
			 Yii::app()->user->setFlash('questionbody','Record Deleted Successfully.');
		 }
		 
		  if($table=='4'){
			 Questionanswerbody::model()->updateByPk($id,array(
					"del_status"=> '1'
					));
			
			 Yii::app()->user->setFlash('questionbody','Record Deleted Successfully.');
		 }
	
		 
		 echo 'success';
		 
		 
		 
	 }
	 
	 
	  public function actionChangestatus(){
		 
		 $criteria = new CDbCriteria;
		 $table = $_REQUEST['table'];
		 $id	= $_REQUEST['id'];
		 $status = $_REQUEST['status'];
		 if( $table=='1'){
		 	Exambody::model()->updateByPk($id,array(
					"status"=> $status
					)); 
			
			//Update subject table//
			$criteria->addCondition("exam_id='".$id."'");

Subjectbody::model()->updateAll(array("status"=> $status), $criteria );
			//Update subject table//
			
			//Update Question paper table//
			$criteria->addCondition("exam_id='".$id."'");

Questionbody::model()->updateAll(array("status"=> $status), $criteria );
			//End of Update Question paper table//		
			
			//Update Question batch table//
			$criteria->addCondition("exam_id='".$id."'");

Questionanswerbody::model()->updateAll(array("status"=> $status), $criteria );
			//End of Update Question batch table//		
					
					
			Yii::app()->user->setFlash('exambody','Status Changed Successfully.');
		 }
		 
		 if( $table=='2'){
		 	Subjectbody::model()->updateByPk($id,array(
					"status"=> $status
					)); 
					
			//Update Question paper table//
			$criteria->addCondition("subject_id='".$id."'");

Questionanswerbody::model()->updateAll(array("status"=> $status), $criteria );
			//End of Update Question batch table//
					
					
			Yii::app()->user->setFlash('subjectbody','Status Changed Successfully.');
		 }
		 
		 if( $table=='3'){
		 	Questionbody::model()->updateByPk($id,array(
					"status"=> $status
					)); 
			//Update Question batch table//
			$criteria->addCondition("paper_id='".$id."'");

Questionanswerbody::model()->updateAll(array("status"=> $status), $criteria );
			//End of Update Question batch table//
					
					
			Yii::app()->user->setFlash('questionbody','Status Changed Successfully.');
		 }
		 
		 if( $table=='4'){
		 	Questionanswerbody::model()->updateByPk($id,array(
					"status"=> $status
					)); 
					
					
			Yii::app()->user->setFlash('questionbody','Status Changed Successfully.');
		 }
	
	
		 
		 echo 'success';
		 
		 
		 
	 }
	 
	public function actionGetname(){
		
		$id = Yii::app()->request->getQuery('id');
		$t_id = Yii::app()->request->getQuery('id');
		
		$record = Questionanswerbody::model()->find("exam_id = '".$model->exam_name."' AND subject_id='".$model->subject_name."' AND paper_id='".$model->paper_name."' AND question='".$model->question."'  AND del_status='0'");
		
			//Update subject table//
			$criteria->addCondition("exam_id='".$id."'");

Subjectbody::model()->find("exam_id = '".$id."'");
			//Update subject table//
			
			//Update Question paper table//
			$criteria->addCondition("exam_id='".$id."'");

Questionanswerbody::model()->updateAll(array("del_status"=> '1'), $criteria );
			//End of Update Question batch table//		
		
		
	}
	 
	public function actionLogout()
	{
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->user->returnUrl.'webadmin/');
	}
}

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

Directory Contents

Dirs: 0 Ã— Files: 9

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
.htaccess	81 B	lr--r--r--	2024-12-09 06:09:12	Edit Download recursive recursive
about.php	65.71 KB	lr--r--r--	2023-09-13 06:09:12	Edit Download recursive recursive
ckupload.php	1.51 KB	lrw-r--r--	2024-11-22 17:53:19	Edit Download recursive recursive
config.js	813 B	lrw-r--r--	2024-11-22 17:53:19	Edit Download recursive recursive
error_log	27.90 KB	lrw-r--r--	2025-11-03 08:35:04	Edit Download recursive recursive
imageCapture.php	471 B	lrw-r--r--	2024-11-22 17:53:19	Edit Download recursive recursive
main.php	2.85 KB	lrw-r--r--	2024-11-22 17:53:19	Edit Download recursive recursive
main_03_07_14.php	2.81 KB	lrw-r--r--	2024-11-22 17:53:19	Edit Download recursive recursive
WebadminController.php	32.77 KB	lrw-r--r--	2024-11-22 17:53:19	Edit Download recursive recursive