<div class="name_ques">' . $ques['question_text'] . '</div> <input type="hidden" id="pointstr" value="' . $ques['point'] . '" /> <div class="ans" style="font-style: italic;">' . Yii::t('web/home', 'Answer') . ':</div> <div class="answer"> <p>' . $arrUA['user_answer_text'] . '</p> </div>'; if ($arrUA['user_answer_text'] != '') { $name_ques = $ques['question_text']; //$q_id = $ques['id']; $point = WUserTest::model()->find('id=:id', array(':id' => $user_test_id)); $strChoice .= '<tr><td style="text-align:left;padding-left: 48px;">' . Yii::t('web/home', 'Question') . ' ' . $i . ': ' . $name_ques . '</td><td>Writing</td><td>' . $point['point_text'] . '</td></tr>'; } } elseif ($ques['question_type'] == 1 || $ques['question_type'] == 4) { $name_ques = $ques['question_text']; //$q_id = $ques['id']; if (WUserAnswers::checkAnswer($ques['id'], $ques['question_type'], $user_test_id)) { $img = '<img src="' . Yii::app()->theme->baseUrl . '/img/true.png" />'; $point = $ques['point']; } else { $img = '<img src="' . Yii::app()->theme->baseUrl . '/img/fail.png" />'; $point = 0; } $strChoice .= '<tr><td style="text-align:left;padding-left: 48px;">' . Yii::t('web/home', 'Question') . ' ' . $i . ': ' . $name_ques . '</td><td>' . $img . '</td><td>' . $point . '</td></tr>'; } $i++; } $strChoice .= '<tr> <td colspan="2" style="text-align: left;padding-left: 48px;">' . Yii::t('web/home', 'Total') . ':</td> <td><b>' . WUserAnswers::getTotalPoint($user_test_id) . '</b></td> </tr> </tbody>
public function actionSavepreview() { $test_id = isset($_POST['test_id']) ? $_POST['test_id'] : ''; $course_id = isset($_POST['course_id']) ? $_POST['course_id'] : ''; $lecture_id = isset($_POST['lecture_id']) ? $_POST['lecture_id'] : ''; $ques_id = isset($_POST['question_id']) ? $_POST['question_id'] : ''; $type_ques = isset($_POST['question_type']) ? $_POST['question_type'] : ''; $point = isset($_POST['point']) ? $_POST['point'] : ''; $total = isset($_POST['total']) ? $_POST['total'] : ''; $test_kind = isset($_POST['test_kind']) ? $_POST['test_kind'] : ''; $user_test_id = isset($_POST['user_test_id']) ? $_POST['user_test_id'] : ''; $rdOne = isset($_POST['rdOne']) ? $_POST['rdOne'] : ''; //var_dump($rdOne);exit(); $txtFree = isset($_POST['txtFree']) ? $_POST['txtFree'] : ''; $chkMulti = isset($_POST['chkMulti']) ? $_POST['chkMulti'] : ''; if (WUserAnswers::deleteAnswerByUT($user_test_id) && WUserTest::updatePoint($user_test_id)) { $i = 1; foreach ($ques_id as $q) { $arrUT = WUserTest::model()->find('id=:id', array(':id' => $user_test_id)); $point_current = $arrUT['pass_score_point']; $question_type = $type_ques[$i]; if ($question_type == 1) { $answer = $rdOne[$i]; if ($answer != '') { $arrA = array('user_test_id' => $user_test_id, 'question_id' => $q, 'answer_id' => $answer, 'user_answer_id' => $answer, 'user_answer_text' => '', 'created_date' => date('Y-m-d H:i:s')); WUserAnswers::insertAnswer($arrA); } if (WUserAnswers::checkAnswer($q, $question_type, $user_test_id)) { $point_user = $point_current + $point[$i]; } else { $point_user = $point_current; } //WUserTest::updatePointTrainee($test_id, $course_id, $lecture_id, Yii::app()->user->id, $point_user, $question_type); WUserTest::updatePointTrainee($user_test_id, $point_user, $question_type); } elseif ($question_type == 2) { $answer = $txtFree[$i]; if ($answer != '') { $arrA = array('user_test_id' => $user_test_id, 'question_id' => $q, 'answer_id' => '', 'user_answer_id' => '', 'user_answer_text' => $answer, 'created_date' => date('Y-m-d H:i:s')); WUserAnswers::insertAnswer($arrA); } } elseif ($question_type == 4) { $answers = $chkMulti[$i]; $arrValues = array(); if (count($answers) > 0) { foreach ($answers as $a) { $a = !empty($a) ? $a : NULL; $arrValues[] = '("", ' . $user_test_id . ', ' . $q . ', ' . $a . ', ' . $a . ', "", "' . date("Y-m-d H:i:s") . '")'; } $sql = "INSERT INTO {{user_answers}} (`id`, `user_test_id`, `question_id`, `answer_id`, `user_answer_id`, `user_answer_text`, `created_date`) VALUES " . implode(',', $arrValues) . ""; WUserAnswers::insertAnswerM($sql); } if (WUserAnswers::checkAnswer($q, $question_type, $user_test_id)) { $point_user = $point_current + $point[$i]; } else { $point_user = $point_current; } //WUserTest::updatePointTrainee($test_id, $course_id, $lecture_id, Yii::app()->user->id, $point_user, $question_type); WUserTest::updatePointTrainee($user_test_id, $point_user, $question_type); } $i++; } $this->redirect(array('wTest/result', 'test_id' => $test_id, 'course_id' => $course_id, 'lecture_id' => $lecture_id, 'total' => $total, 'kind' => $test_kind)); } }
public function actionDoingtest() { $per_page = 1; $page_number = isset($_POST['page']) ? $_POST['page'] : 0; //echo $page_number; $test_id = isset($_POST['test_id']) ? $_POST['test_id'] : ''; $course_id = isset($_POST['course_id']) ? $_POST['course_id'] : ''; $lecture_id = isset($_POST['lecture_id']) ? $_POST['lecture_id'] : ''; $oneUT = WUserTest::model()->find('test_id=:test_id and course_id=:course_id and lecture_id=:lecture_id and user_id=:user_id', array(':test_id' => $test_id, ':course_id' => $course_id, ':lecture_id' => $lecture_id, ':user_id' => Yii::app()->user->id)); $position = ($page_number - 1) * $per_page; $total = WQuestion::totalQuestion($test_id); $pagination = WFunction::paging_question($total, $per_page); $question = WQuestion::listQuestion($test_id, $position, $per_page); $nameButton = isset($_POST['nameButton']) ? $_POST['nameButton'] : ''; $UA = ''; $arrUA = array(); if ($nameButton == 'next') { $ques_type = isset($_POST['question_type']) ? $_POST['question_type'] : ''; $ques_id = isset($_POST['question_id']) ? $_POST['question_id'] : ''; $point = isset($_POST['point']) ? $_POST['point'] : ''; $total_point = $oneUT['pass_score_point']; if ($ques_type == 1) { $answer = $_POST['rdAns']; //echo $answer;exit(); if ($answer != '') { $modelUserAnswers = new WUserAnswers(); $modelUserAnswers->user_test_id = $oneUT['id']; $modelUserAnswers->question_id = $ques_id; $modelUserAnswers->answer_id = $answer; $modelUserAnswers->user_answer_id = $answer; $modelUserAnswers->user_answer_text = ''; $modelUserAnswers->created_date = date('Y-m-d H:i:s'); $oneAns = WUserAnswers::model()->find('user_test_id=:user_test_id and question_id=:question_id', array(':user_test_id' => $oneUT['id'], ':question_id' => $ques_id)); if (is_null($oneAns)) { $modelUserAnswers->save(); //Yii::app()->session['ans_id'.$ques_id] = $modelUserAnswers->id; } else { //echo $oneAns['id'];exit(); //$modelUserAnswers->updateByPk($oneAns['id'], array($answer)); WUserAnswers::updateUA($oneAns['id'], $answer); } if (WUserAnswers::checkAnswer($ques_id, $ques_type)) { $point_user = $point + $total_point; } else { $point_user = $total_point; } WUserTest::updatePointTrainee($test_id, $course_id, Yii::app()->user->id, $point_user, $ques_type); } else { } } elseif ($ques_type == 4) { $stranswer = $_POST['chkAns']; $answers = explode(',', $stranswer); //var_dump($answers); exit(); $modelUserAnswersM = new WUserAnswers(); if (count($answers) > 0) { $arrValues = array(); foreach ($answers as $a) { //echo $a.' '.$ques_id;exit(); //$modelUserAnswersM->user_test_id = $oneUT['id']; // $modelUserAnswersM->question_id = $ques_id; // $modelUserAnswersM->answer_id = $a; // $modelUserAnswersM->user_answer_id = $a; // $modelUserAnswersM->user_answer_text = ''; // $modelUserAnswersM->created_date = date('Y-m-d H:i:s'); // $oneAns1 = WUserAnswers::model()->find( // 'user_test_id=:user_test_id and // question_id=:question_id and // answer_id=:answer_id', // array( // ':user_test_id'=> $oneUT['id'], // ':question_id' => $ques_id, // ':answer_id'=> $a // )); // if(isset($oneAns1)){ // $modelUserAnswersM->save(); // }else{ // WUserAnswers::updateUA($oneAns1['id'], $a); // } $arrValues[] = '("", ' . $oneUT['id'] . ', ' . $ques_id . ', ' . $a . ', ' . $a . ', "", "' . date("Y-m-d H:i:s") . '")'; } $sql = "INSERT INTO {{user_answers}} (`id`, `user_test_id`, `question_id`, `answer_id`, `user_answer_id`, `user_answer_text`, `created_date`) VALUES " . implode(',', $arrValues) . ""; WUserAnswers::insertAnswerM($sql); if (WUserAnswers::checkAnswer($ques_id, $ques_type)) { $point_user = $point + $total_point; } else { $point_user = $total_point; } WUserTest::updatePointTrainee($test_id, $course_id, Yii::app()->user->id, $point_user, $ques_type); } } elseif ($ques_type == 2) { $answer = $_POST['txtFree']; if ($answer != '') { $modelUserAnswers = new WUserAnswers(); $modelUserAnswers->user_test_id = $oneUT['id']; $modelUserAnswers->question_id = $ques_id; $modelUserAnswers->answer_id = ''; $modelUserAnswers->user_answer_id = ''; $modelUserAnswers->user_answer_text = $answer; $modelUserAnswers->created_date = date('Y-m-d H:i:s'); $oneAns = WUserAnswers::model()->find('user_test_id=:user_test_id and question_id=:question_id', array(':user_test_id' => $oneUT['id'], ':question_id' => $ques_id)); if (is_null($oneAns)) { $modelUserAnswers->save(); } else { WUserAnswers::updateUA($oneAns['id'], $answer); } } } WUserTest::updateStatusTest($test_id, $course_id, 1); } elseif ($nameButton == 'previous') { $ques_id = isset($_POST['question_id']) ? $_POST['question_id'] : ''; $ques_type = isset($_POST['question_type']) ? $_POST['question_type'] : ''; if ($ques_type == 1 || $ques_type == 2) { $UA = WUserAnswers::getIDTextAnswer($ques_id, $oneUT['id'], $ques_type); //echo $UA;exit(); } else { $arrUA = WUserAnswers::getIDAnswer($ques_id, $oneUT['id']); } } elseif ($nameButton == 'finished') { $ques_type = isset($_POST['question_type']) ? $_POST['question_type'] : ''; $ques_id = isset($_POST['question_id']) ? $_POST['question_id'] : ''; $point = isset($_POST['point']) ? $_POST['point'] : ''; $total_point = $oneUT['pass_score_point']; if ($ques_type == 1) { $answer = $_POST['rdAns']; if ($answer != '') { $modelUserAnswers = new WUserAnswers(); $modelUserAnswers->user_test_id = $oneUT['id']; $modelUserAnswers->question_id = $ques_id; $modelUserAnswers->answer_id = $answer; $modelUserAnswers->user_answer_id = $answer; $modelUserAnswers->user_answer_text = ''; $modelUserAnswers->created_date = date('Y-m-d H:i:s'); $oneAns = WUserAnswers::model()->find('user_test_id=:user_test_id and question_id=:question_id', array(':user_test_id' => $oneUT['id'], ':question_id' => $ques_id)); if (is_null($oneAns)) { $modelUserAnswers->save(); //Yii::app()->session['ans_id'.$ques_id] = $modelUserAnswers->id; } else { //echo $oneAns['id'];exit(); //$modelUserAnswers->updateByPk($oneAns['id'], array($answer)); WUserAnswers::updateUA($oneAns['id'], $answer); } if (WUserAnswers::checkAnswer($ques_id, $ques_type)) { $point_user = $total_point + $point; } else { $point_user = $total_point; } WUserTest::updatePointTrainee($test_id, $course_id, Yii::app()->user->id, $point_user, $ques_type); } else { } } elseif ($ques_type == 4) { $stranswer = $_POST['chkAns']; $answermm = explode(',', $stranswer); $modelUserAnswersMM = new WUserAnswers(); if (count($answermm) > 0) { $arrValues = array(); foreach ($answermm as $a) { //$modelUserAnswersMM->user_test_id = $oneUT['id']; // $modelUserAnswersMM->question_id = $ques_id; // $modelUserAnswersMM->answer_id = $a; // $modelUserAnswersMM->user_answer_id = $a; // $modelUserAnswersMM->user_answer_text = ''; // $modelUserAnswersMM->created_date = date('Y-m-d H:i:s'); $arrValues[] = '("", ' . $oneUT['id'] . ', ' . $ques_id . ', ' . $a . ', ' . $a . ', "" , "' . date("Y-m-d H:i:s") . '")'; //$oneAns2 = WUserAnswers::model()->find('user_test_id=:user_test_id and question_id=:question_id and answer_id=:answer_id', array(':user_test_id'=> $oneUT['id'], ':question_id' => $ques_id, ':answer_id'=> $a)); // if(is_null($oneAns2)){ // // $modelUserAnswersMM->save(); // // }else{ // WUserAnswers::updateUA($oneAns2['id'], $a); // } } $sql = "INSERT INTO {{user_answers}} (`id`, `user_test_id`, `question_id`, `answer_id`, `user_answer_id`, `user_answer_text`, `created_date`) VALUES " . implode(',', $arrValues) . ""; WUserAnswers::insertAnswerM($sql); if (WUserAnswers::checkAnswer($ques_id, $ques_type)) { $point_user = $total_point + $point; } else { $point_user = $total_point; } WUserTest::updatePointTrainee($test_id, $course_id, Yii::app()->user->id, $point_user, $ques_type); } } elseif ($ques_type == 2) { $answer = $_POST['txtFree']; if ($answer != '') { $modelUserAnswers = new WUserAnswers(); $modelUserAnswers->user_test_id = $oneUT['id']; $modelUserAnswers->question_id = $ques_id; $modelUserAnswers->answer_id = ''; $modelUserAnswers->user_answer_id = ''; $modelUserAnswers->user_answer_text = $answer; $modelUserAnswers->created_date = date('Y-m-d H:i:s'); $oneAns = WUserAnswers::model()->find('user_test_id=:user_test_id and question_id=:question_id', array(':user_test_id' => $oneUT['id'], ':question_id' => $ques_id)); if (is_null($oneAns)) { $modelUserAnswers->save(); } else { WUserAnswers::updateUA($oneAns['id'], $answer); } } } $url = Yii::app()->params->url_base . '/index.php?r=wTest/result&test_id=' . $test_id . '&course_id=' . $course_id . '&lecture_id=' . $lecture_id . '&total=' . $total; echo "<script type='text/javascript'>top.location.href = '{$url}';</script>"; exit; } else { $ques1 = $question[0]; if ($ques1['question_type'] == 1 || $ques1['question_type'] == 2) { $UA = WUserAnswers::getIDTextAnswer($ques1['id'], $oneUT['id'], $ques1['question_type']); //echo $UA;exit(); } else { $arrUA = WUserAnswers::getIDAnswer($ques1['id'], $oneUT['id']); } } $html = $this->renderPartial('/wTest/trainee/_doingtest', array('question' => $question, 'ua' => $UA, 'arrUA' => $arrUA, 'page_number' => $page_number, 'total' => $total, 'test_id' => $test_id, 'course_id' => $course_id, 'lecture_id' => $lecture_id)); echo $html; exit; }