Preview: WebadminController.php
Size: 32.77 KB
/home/jambtst2015/public_html/serverfile/WebadminController.php
<?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."'");
Questionbody::model()->updateAll(array("del_status"=> '1'), $criteria );
//End of Update Question paper table//
//Update Question batch 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."'");
Questionbody::model()->updateAll(array("status"=> $status), $criteria );
//End of Update Question paper table//
//Update Question batch 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."'");
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//
}
public function actionLogout()
{
Yii::app()->user->logout();
$this->redirect(Yii::app()->user->returnUrl.'webadmin/');
}
}
Directory Contents
Dirs: 0 × Files: 9