public function actionMarkTest()
{
$arrQuestion = isset($_REQUEST["arrQuestion"]) ? $_REQUEST["arrQuestion"] : array();
$user_test_id = isset($_REQUEST["user_test_id"]) ? $_REQUEST["user_test_id"] : NULL;
$json = array("result" => "true");
if (!empty($arrQuestion)) {
$checkSave = TRUE;
foreach ($arrQuestion as $itemquestion) {
$model = WUserAnswers::model()->find("question_id=" . $itemquestion["idquestion"] . ' AND user_test_id=' . $itemquestion["user_test_id"]);
if (!empty($model)) {
$model->point_answer_text = $itemquestion["point_answer_text"];
$model->comment_trainer = $itemquestion["comment_question"];
if (!$model->save()) {
$checkSave = FALSE;
}
}
}
if ($checkSave == TRUE) {
$arrPointQuestion = array();
// Lay Point cua cau hoi
$db = Yii::app()->db;
$comm = $db->createCommand()->select('t.*,t2.test_name')->from('pls_user_test t')->LeftJoin('pls_test_parent t2', 't2.id=t.test_id')->LeftJoin('pls_course t3', 't3.id=t.course_id')->where('t.id=' . $user_test_id . ' AND t3.created_by=' . Yii::app()->user->id);
$dataUserTest = $comm->queryRow();
$comm->reset();
$comm = $db->createCommand()->select('t.*')->from('pls_test_user t')->where('t.id_test_parent=' . $dataUserTest["test_id"] . ' AND user_id=' . $dataUserTest["user_id"] . ' AND kind=' . $dataUserTest["test_kind"] . ' AND t.course_id=' . $dataUserTest["course_id"] . ' AND t.lecture_id=' . $dataUserTest["lecture_id"]);
$dataTestUser = $comm->queryRow();
if (!empty($dataTestUser)) {
if (!empty($dataTestUser["dataquestion"])) {
$dataquestion = json_decode($dataTestUser["dataquestion"], true);
if (!empty($dataquestion)) {
foreach ($dataquestion as $itemdataquestion) {
$arrPointQuestion[$itemdataquestion["idquestion"]]["point"] = $itemdataquestion["point"];
$arrPointQuestion[$itemdataquestion["idquestion"]]["answertrue"] = WQuestionAnswerLib::getAnswerTrueQuestion($itemdataquestion["idquestion"]);
}
}
}
}
// Select Nhung cau tra loi cua hoc vien
$comm->reset();
$comm = $db->createCommand()->select('t.*')->from('pls_user_answers t')->where('t.user_test_id=' . $user_test_id);
$dataUserAnswer = $comm->queryAll();
if (!empty($dataUserAnswer)) {
foreach ($dataUserAnswer as $itemdataUserAnswer) {
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["question_type"] = $itemdataUserAnswer["question_type"];
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["question_id"] = $itemdataUserAnswer["question_id"];
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["doing"] = $itemdataUserAnswer["doing"];
if ($itemdataUserAnswer["question_type"] == 1 or $itemdataUserAnswer["question_type"] == 4) {
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["useranswer"] = $itemdataUserAnswer["user_answer_id"];
} elseif ($itemdataUserAnswer["question_type"] == 2) {
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["useranswer"] = $itemdataUserAnswer["user_answer_text"];
}
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["point_answer_text"] = $itemdataUserAnswer["point_answer_text"];
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["comment_trainer"] = $itemdataUserAnswer["comment_trainer"];
}
}
// Kiem tra nhung cau tra loi dung
$dataNew = array();
$total_point = 0;
if (!empty($arrPointQuestion)) {
foreach ($arrPointQuestion as $key => $itemPointQuestion) {
$dataNew[$key] = $itemPointQuestion;
if (!empty($itemPointQuestion["answertrue"])) {
if ($itemPointQuestion["question_type"] == 4 or $itemPointQuestion["question_type"] == 1) {
// Truong hop nhieu dap an
$dataAnswer = explode(',', $itemPointQuestion["useranswer"]);
$dataAnswerNew = array();
foreach ($dataAnswer as $item) {
if (!empty($item)) {
$dataAnswerNew[] = $item;
}
}
$check = TRUE;
if (count($dataAnswerNew) == count($itemPointQuestion["answertrue"])) {
foreach ($dataAnswerNew as $itemdataAnswerNew) {
if (!in_array($itemdataAnswerNew, $itemPointQuestion["answertrue"])) {
$check = FALSE;
}
}
} else {
$check = FALSE;
}
if ($check == TRUE) {
$dataNew[$key]["check"] = "OK";
$total_point += $itemPointQuestion["point"];
} else {
$dataNew[$key]["check"] = "NOK";
}
}
}
if ($itemPointQuestion["question_type"] == 2) {
if (isset($itemPointQuestion["point_answer_text"])) {
$total_point += $itemPointQuestion["point_answer_text"];
}
}
}
}
// Luu ket qua vao database
$model = WTestUser::model()->find('user_id=' . $dataUserTest["user_id"] . ' AND id_test_parent=' . $dataUserTest["test_id"] . ' AND kind=' . $dataUserTest["test_kind"] . ' AND course_id=' . $dataUserTest["course_id"] . ' AND lecture_id=' . $dataUserTest["lecture_id"]);
$model->datafinish = json_encode($dataNew);
$model->save();
$modelUserTest = WUserTest::model()->find('id=' . $user_test_id);
$modelUserTest->pass_score_point = $total_point;
$modelUserTest->success = 2;
if ($modelUserTest->save()) {
//$testDetails = WTest::model()->find("id=".$test_id);
$username = WUser::getFullNameUser($dataUserTest["user_id"]);
$trainer = WUser::getFullNameUser(Yii::app()->user->id);
$title = "Giáo viên " . $trainer . " đã chấm bài test: " . $dataUserTest["test_name"] . " của bạn";
if (!empty($dataUserTest["success"]) and $dataUserTest["success"] == 2) {
$title = "Giáo viên " . $trainer . " đã chấm bài lại test: " . $dataUserTest["test_name"] . " của bạn";
}
$content = "Dear <strong>" . $username . "</strong>";
//$content .="<br/>Bài làm Test :".$testDetails->test_name." của bạn đã được Giáo viên: <strong>".$trainer.'</strong> chấm xong';
$content .= "<br/>Giáo viên <strong>" . $trainer . '</strong> đã chấm bài: <strong>"' . $dataUserTest["test_name"] . '"</strong> của bạn';
$url = Yii::app()->createUrl("wCourseLecture/Viewresult", array("user_test_id" => $dataUserTest["id"]));
$content .= "<br/><a href='" . $url . "'>Click Để xem kết quả bài test</a>";
WMessage::SendMessage($title, $content, "notifi", Yii::app()->user->id, $dataUserTest["user_id"]);
$json = array("result" => "true");
}
} else {
$json = array("result" => "false", "message" => "");
}
}
echo json_encode($json);
}
<?php
if (!empty($result)) {
foreach ($result as $data) {
$dataAnswer = WQuestionAnswerLib::getAnswerQuestion($data["id"]);
?>
<div class="listquestion ItemQuestion_<?php
echo $data["id"];
?>
">
<div class="questiontest">
<div class="q1 line-box-point" style="position: absolute;top:6px;left: -110px;font-weight: bold;"><?php
echo Yii::t('web/home', 'Question');
?>
: </div>
<input type="hidden" class="item_question" value="<?php
echo $data["id"];
?>
">
<input type="hidden" class="dataidtest" value="<?php
echo $data["id"];
?>
">
<div class="content_question">
<div class="point">
<label class="col-sm-4 control-label required label-point"><?php
echo Yii::t('web/home', 'Point');
?>
</label>
<div class="col-xs-6 col-sm-4">
<input type="text" style="width:60px;" value="<?php
<td align="center">
<?php
$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) {
public function actionFinishTest()
{
$user_test_id = isset($_REQUEST["user_test_id"]) ? $_REQUEST["user_test_id"] : NULL;
$db = Yii::app()->db;
$comm = $db->createCommand()->select('t.*')->from('pls_user_test t')->where('t.id=' . $user_test_id);
$dataUserTest = $comm->queryRow();
//data test
$arrPointQuestion = array();
// Lay Point cua cau hoi
if (!empty($dataUserTest)) {
$comm->reset();
$comm = $db->createCommand()->select('t.*')->from('pls_test_user t')->where('t.id_test_parent=' . $dataUserTest["test_id"] . ' AND t.user_id=' . $dataUserTest["user_id"] . ' AND kind=' . $dataUserTest["test_kind"] . ' AND t.course_id=' . $dataUserTest["course_id"] . ' AND t.lecture_id=' . $dataUserTest["lecture_id"]);
$dataTestUser = $comm->queryRow();
if (!empty($dataTestUser)) {
if (isset($dataTestUser["dataquestion"]) and !empty($dataTestUser["dataquestion"])) {
$dataquestion = json_decode($dataTestUser["dataquestion"], true);
if (!empty($dataquestion)) {
foreach ($dataquestion as $itemdataquestion) {
$arrPointQuestion[$itemdataquestion["idquestion"]]["point"] = $itemdataquestion["point"];
$arrPointQuestion[$itemdataquestion["idquestion"]]["answertrue"] = WQuestionAnswerLib::getAnswerTrueQuestion($itemdataquestion["idquestion"]);
}
}
}
}
// Select Nhung cau tra loi cua hoc vien
$comm->reset();
$comm = $db->createCommand()->select('t.*')->from('pls_user_answers t')->where('t.user_test_id=' . $user_test_id);
$dataUserAnswer = $comm->queryAll();
if (!empty($dataUserAnswer)) {
foreach ($dataUserAnswer as $itemdataUserAnswer) {
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["question_type"] = $itemdataUserAnswer["question_type"];
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["question_id"] = $itemdataUserAnswer["question_id"];
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["doing"] = $itemdataUserAnswer["doing"];
if (isset($itemdataUserAnswer["question_type"]) and $itemdataUserAnswer["question_type"] == 1 or $itemdataUserAnswer["question_type"] == 4) {
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["useranswer"] = $itemdataUserAnswer["user_answer_id"];
} elseif (isset($itemdataUserAnswer["question_type"]) and $itemdataUserAnswer["question_type"] == 2) {
$arrPointQuestion[$itemdataUserAnswer["question_id"]]["useranswer"] = $itemdataUserAnswer["user_answer_text"];
}
}
}
// Kiem tra nhung cau tra loi dung
$dataNew = array();
$totalpoint = 0;
//Kiem tra xem co question Text hay khong
$check_question_type = TRUE;
if (!empty($arrPointQuestion)) {
foreach ($arrPointQuestion as $key => $itemPointQuestion) {
$dataNew[$key] = $itemPointQuestion;
if (isset($itemPointQuestion["question_type"]) and $itemPointQuestion["question_type"] == 2) {
$check_question_type = FALSE;
}
if (isset($itemPointQuestion["answertrue"]) and !empty($itemPointQuestion["answertrue"])) {
if (isset($itemPointQuestion["question_type"]) and $itemPointQuestion["question_type"] == 4 or $itemPointQuestion["question_type"] == 1) {
// Truong hop nhieu dap an
$dataAnswer = explode(',', $itemPointQuestion["useranswer"]);
$dataAnswerNew = array();
foreach ($dataAnswer as $item) {
if (!empty($item)) {
$dataAnswerNew[] = $item;
}
}
$check = TRUE;
if (count($dataAnswerNew) == count($itemPointQuestion["answertrue"])) {
foreach ($dataAnswerNew as $itemdataAnswerNew) {
if (!in_array($itemdataAnswerNew, $itemPointQuestion["answertrue"])) {
$check = FALSE;
}
}
} else {
$check = FALSE;
}
if ($check == TRUE) {
$dataNew[$key]["check"] = "OK";
$totalpoint += $itemPointQuestion["point"];
} else {
$dataNew[$key]["check"] = "NOK";
}
}
}
}
}
// Luu ket qua vao database
$model = WTestUser::model()->find('id_test_parent=' . $dataUserTest["test_id"] . ' AND user_id=' . $dataUserTest["user_id"] . ' AND kind=' . $dataUserTest["test_kind"] . ' AND course_id=' . $dataUserTest["course_id"] . ' AND lecture_id=' . $dataUserTest["lecture_id"]);
$model->datafinish = json_encode($dataNew);
$model->save();
$modelUserTest = WUserTest::model()->find("id=" . $user_test_id);
$modelUserTest->status = 1;
if ($check_question_type == TRUE) {
$modelUserTest->success = 2;
} else {
$modelUserTest->success = 1;
}
$modelUserTest->pass_score_point = $totalpoint;
$modelUserTest->finish_date = date('Y-m-d H:i:s');
if ($modelUserTest->save()) {
echo json_encode(array("result" => "true", "mess" => "Hoàn thành bài kiểm tra"));
} else {
echo json_encode(array("result" => "false", "mess" => "Lỗi !. Chụp lại màn hình và gửi tới Admin để được hỗ trợ tốt nhất."));
}
} else {
echo json_encode(array("result" => "false", "mess" => "Lỗi !. Chụp lại màn hình và gửi tới Admin để được hỗ trợ tốt nhất."));
}
}
?>
<?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 actionDeleteAnswer()
{
$idanswer = $_REQUEST["idanswer"];
$comm = Yii::app()->db->createCommand();
$model = WQuestionAnswerLib::model()->find("id=" . $idanswer);
if (!empty($model)) {
if ($comm->delete('pls_question_answer_lib', 'id=' . $idanswer)) {
echo json_encode(array("result" => "true"));
} else {
echo json_encode(array("result" => "false"));
}
} else {
echo json_encode(array("result" => "true", "status" => "empty"));
}
}
