$dataquestion = !empty($item["dataquestion"]) ? json_decode($item["dataquestion"], true) : array();
$datafinish = !empty($item["datafinish"]) ? json_decode($item["datafinish"], true) : array();
$user_test_id = $item["user_test_id"];
$data_user_id = $item["user_id"];
$data_course_id = $item["course_id"];
$data_lecture_id = $item["lecture_id"];
$data_test_kind = $item["test_kind"];
$data_test_id = $item["test_id"];
if (empty($datafinish)) {
$dataNew = array();
$totalpointuser = 0;
foreach ($dataquestion as $key => $itemquestion) {
$dataNew[$itemquestion["idquestion"]]["point"] = $itemquestion["point"];
$dataNew[$itemquestion["idquestion"]]["answertrue"] = WQuestionAnswerLib::getAnswerTrueQuestion($itemquestion["idquestion"]);
$dataNew[$itemquestion["idquestion"]]["question_id"] = $itemquestion["idquestion"];
$questionDetails = WQuestionLib::getQuestionDetails($itemquestion["idquestion"]);
if (!empty($questionDetails)) {
$dataNew[$itemquestion["idquestion"]]["question_type"] = $questionDetails["question_type"];
}
//get lai thong tin dap an hoc vien
$dataUserAnswer = WUserAnswers::getDataUserAnswer($user_test_id, $itemquestion["idquestion"], $data_user_id);
$answer = array();
$dataNew[$itemquestion["idquestion"]]["doing"] = (isset($dataUserAnswer["doing"]) and !empty($dataUserAnswer["doing"])) ? $dataUserAnswer["doing"] : 0;
if ($dataUserAnswer["question_type"] == 2) {
$dataNew[$itemquestion["idquestion"]]["useranswer"] = $dataUserAnswer["user_answer_text"];
$dataNew[$itemquestion["idquestion"]]["comment_trainer"] = $dataUserAnswer["comment_trainer"];
$dataNew[$itemquestion["idquestion"]]["point_answer_text"] = $dataUserAnswer["point_answer_text"];
$totalpointuser += $dataNew[$itemquestion["idquestion"]]["point_answer_text"];
} elseif ($dataUserAnswer["question_type"] == 1 or $dataUserAnswer["question_type"] == 4) {
if (!empty($dataUserAnswer) and !empty($dataUserAnswer["user_answer_id"])) {
$dataNew[$itemquestion["idquestion"]]["useranswer"] = $dataUserAnswer["user_answer_id"];
<th>Question</th>
<th>Results</th>
<th>Points</th>
</tr>
</thead>
<tbody>
<?php
if (!empty($datafinish)) {
?>
<?php
$i = 1;
$totalpoint = 0;
foreach ($datafinish as $key => $itemfinish) {
?>
<?php
$details = WQuestionLib::getQuestionDetails($key);
if (isset($itemfinish["question_type"]) and $itemfinish["question_type"] == 2) {
$dataQuestionText[$key]["index"] = $i;
$dataQuestionText[$key]["question_id"] = $key;
$dataQuestionText[$key]["details"] = $details;
$dataQuestionText[$key]["point"] = $itemfinish["point"];
$dataQuestionText[$key]["answers"] = $itemfinish["useranswer"];
$dataQuestionText[$key]["point_answer_text"] = (isset($itemfinish["point_answer_text"]) and $itemfinish["point_answer_text"] != "") ? $itemfinish["point_answer_text"] : "";
$dataQuestionText[$key]["comment_trainer"] = (isset($itemfinish["comment_trainer"]) and !empty($itemfinish["comment_trainer"])) ? $itemfinish["comment_trainer"] : "";
if (isset($itemfinish["point_answer_text"]) and !empty($itemfinish["point_answer_text"])) {
$totalpoint += $itemfinish["point_answer_text"];
}
} else {
if (isset($itemfinish["point_answer_text"]) and !empty($itemfinish["point_answer_text"])) {
$totalpoint += $itemfinish["point_answer_text"];
}
public function actionRemoveAllData()
{
$listid = isset($_REQUEST["listid"]) ? $_REQUEST["listid"] : NULL;
$json = array("result" => "true");
if (!empty($listid)) {
foreach ($listid as $item) {
$model = WQuestionLib::model()->find("id=" . $item["id"]);
if (!empty($model)) {
$comm = Yii::app()->db->createCommand();
if (Yii::app()->session["group_id"] == 1) {
$comm->reset();
$comm->delete('pls_question_lib', 'id=' . $item["id"] . ' AND created_by=' . Yii::app()->user->id);
$comm->reset();
$comm->delete('pls_question_answer_lib', 'question_id=' . $item["id"]);
$comm->reset();
$comm->delete('pls_user_answers', 'question_id=' . $item["id"]);
} elseif (Yii::app()->session["group_id"] == 3) {
$comm->reset();
$comm->delete('pls_question_lib', 'id=' . $item["id"]);
$comm->reset();
$comm->delete('pls_question_answer_lib', 'question_id=' . $item["id"]);
$comm->reset();
$comm->delete('pls_user_answers', 'question_id=' . $item["id"]);
}
}
}
}
echo json_encode($json);
}
<?php
$data = WQuestionLib::getQuestionLibAll(10, 0, $questionType, $namequestion, $question_cat_id);
$where = "";
if (!empty($questionType)) {
$where .= " AND t.question_type=" . $questionType;
}
if (!empty($namequestion)) {
$where .= " AND t.question_text LIKE '%" . $namequestion . "%'";
}
if (!empty($question_cat_id)) {
$where .= " AND t.question_cat_id=" . $question_cat_id;
}
$total = WQuestionLib::getTotalQuestionLib($where);
$page = ceil($total / 10);
?>
<p><a href="javascript:;" class="btn btn-danger btn-xs" style="visibility: hidden;" id="btndeleteall" onclick="return removeAllData(this);"><?php
echo Yii::t('web/home', 'Delete All');
?>
</a></p>
<table class="table table-hover" style="margin-bottom: 0px;">
<thead class="first_thead">
<tr>
<th width="1"><input type="checkbox" id="checkAll"></th>
<th width="1">#</th>
<th><?php
echo Yii::t('web/home', 'Question');
?>
</th>
<th class="col-lg-2"><?php
echo Yii::t('web/home', 'Action');
//echo $str;
?>
<?php
echo $pagination;
?>
</div>
<div class="primary_container_body" style="margin-top: 80px">
<div id="container_course">
<div class="form-horizontal" role="form" id="login11" name="formtest" >
<div id="results">
<?php
$i = 1;
foreach ($question as $itemquestion) {
?>
<?php
$dataQuestion = WQuestionLib::model()->find("id=" . $itemquestion["idquestion"]);
$dataAnswer = WQuestionAnswerLib::getAnswerQuestion($itemquestion["idquestion"]);
$db = Yii::app()->db;
$comm = $db->createCommand();
$comm = $comm->select('*')->from('pls_user_answers')->where("test_id=" . $test["id"] . ' AND user_test_id=' . $user_test_id . ' AND question_id=' . $itemquestion["idquestion"] . ' AND user_id=' . Yii::app()->user->id);
$dataUserAnswers = $comm->queryRow();
$arrAnsCheck = array();
$dataquestiontext = "";
if (!empty($dataUserAnswers)) {
if ($dataUserAnswers["question_type"] == 1 or $dataUserAnswers["question_type"] == 4) {
$user_answer_id = $dataUserAnswers["user_answer_id"];
if (!empty($user_answer_id)) {
$user_answer_id = explode(",", $user_answer_id);
foreach ($user_answer_id as $item_user_answer_id) {
if (!empty($item_user_answer_id)) {
$arrAnsCheck[$item_user_answer_id] = TRUE;
public function actionUpdateQuestionLib()
{
$id = $_REQUEST["id_question"];
$question_cat_id = $_REQUEST["question_cat_id"];
$question_type = $_REQUEST["question_type"];
$question_text = $_REQUEST["question_text"];
$question_true = $_REQUEST["answerTrue"];
$AnswerList = $_REQUEST["answerA"];
$model = WQuestionLib::model()->find("id=" . $id);
$model->question_text = $question_text;
$model->question_type = $question_type;
$model->question_cat_id = $question_cat_id;
if ($model->save()) {
$idQuestion = $id;
$comm = Yii::app()->db->createCommand();
$comm->delete('pls_question_answer_lib', 'question_id=' . $idQuestion);
if ($question_type != 2) {
if (!empty($AnswerList)) {
//neu la nhieu dap an
$dataAnswTrue = array();
if ($question_type != 2 and !empty($question_true)) {
$dataAnswTrue = explode(",", $question_true);
unset($dataAnswTrue[count($dataAnswTrue) - 1]);
}
foreach ($AnswerList as $key => $itemAns) {
$modelAnsw = new WQuestionAnswerLib();
$modelAnsw->answer = $itemAns;
$modelAnsw->question_id = $idQuestion;
if ($question_type != 2) {
if (in_array($key, $dataAnswTrue)) {
$modelAnsw->is_correct_answer = 1;
} else {
$modelAnsw->is_correct_answer = 0;
}
}
$modelAnsw->save();
}
}
}
echo json_encode(array("result" => "true"));
} else {
echo json_encode(array("result" => "false", "message" => "Lỗi thao tác, Mời bạn thao tác lại"));
}
}
