/**
* Luu ket qua test vao db
**/
public function actionResult()
{
$this->layout = '//layouts/main_trainer';
$cs = Yii::app()->getClientScript();
$cs->registerCssFile(Yii::app()->theme->baseUrl . '/css/jquery-ui.css?ver=' . time());
$cs->registerCssFile(Yii::app()->theme->baseUrl . '/css/dialog.css?ver=' . time());
//$cs->registerCssFile(Yii::app()->theme->baseUrl.'/css/jquery.countdown.css?ver='.time());
$cs->registerScriptFile(Yii::app()->theme->baseUrl . '/js/jquery.simplemodal-1.4.4.js', CClientScript::POS_END);
$cs->registerScriptFile(Yii::app()->theme->baseUrl . '/js/jquery-ui.js');
$cs->registerScriptFile(Yii::app()->theme->baseUrl . '/js/jquery.slimscroll.min.js');
$courseid = isset($_REQUEST['course_id']) ? $_REQUEST['course_id'] : '';
$lecture_id = isset($_REQUEST['lecture_id']) ? $_REQUEST['lecture_id'] : '';
$test_id = isset($_REQUEST['test_id']) ? $_REQUEST['test_id'] : '';
$total = isset($_REQUEST['total']) ? $_REQUEST['total'] : '';
$kind = isset($_REQUEST['kind']) ? $_REQUEST['kind'] : '';
//Thong tin bai test
$testDetails = WTestParent::model()->find("id=" . $test_id);
//Get tong so cau hoi
$db = Yii::app()->db;
$comm = $db->createCommand()->select('t.*')->from('pls_test_user t')->where('t.id_test_parent=' . $test_id . ' AND t.user_id=' . Yii::app()->user->id . ' AND kind=' . $kind . ' AND t.course_id=' . $courseid . ' AND t.lecture_id=' . $lecture_id);
$dataTestUser = $comm->queryRow();
if (empty($dataTestUser)) {
$this->redirect(Yii::app()->createUrl("/"));
}
$totalquestion = 0;
$totalTrue = 0;
$totalQuestionText = 0;
$totalfails = 0;
$totalnotdoing = 0;
$totalnoanswer = 0;
if (!empty($dataTestUser) and !empty($dataTestUser["dataquestion"])) {
if (!empty($dataTestUser["dataquestion"])) {
$dataquestion = json_decode($dataTestUser["dataquestion"], true);
$totalquestion = count($dataquestion);
}
//lay so cau hoi dung
if (!empty($dataTestUser["datafinish"])) {
$datafinish = json_decode($dataTestUser["datafinish"], true);
foreach ($datafinish as $itemdatafinish) {
if ($itemdatafinish["question_type"] != 2 and isset($itemdatafinish["check"]) and $itemdatafinish["check"] == "OK") {
++$totalTrue;
} elseif ($itemdatafinish["question_type"] != 2 and isset($itemdatafinish["check"]) and $itemdatafinish["check"] == "NOK" and isset($itemdatafinish["doing"]) and $itemdatafinish["doing"] == 1) {
$totalfails++;
} elseif ($itemdatafinish["question_type"] != 2 and isset($itemdatafinish["check"]) and $itemdatafinish["check"] == "NOK" and isset($itemdatafinish["doing"]) and $itemdatafinish["doing"] == 0) {
$totalnotdoing++;
} elseif ($itemdatafinish["question_type"] == 2) {
++$totalQuestionText;
} elseif (!isset($itemdatafinish["check"])) {
++$totalnoanswer;
}
}
}
}
// Tong diem
$comm->reset();
$comm = $db->createCommand()->select('t.*')->from('pls_user_test t')->where('t.test_id=' . $test_id . ' AND test_kind=' . $kind . ' AND t.course_id=' . $courseid . ' AND t.lecture_id=' . $lecture_id . ' AND user_id=' . Yii::app()->user->id);
$dataUserTest = $comm->queryRow();
$courseDetails = WCourse::model()->find("id=" . $courseid);
$username = WUser::getFullNameUser(Yii::app()->user->id);
$trainer = WUser::getFullNameUser($courseDetails->created_by);
$title = "Học viên " . $username . " Làm xong bài Test :" . $testDetails->test_name;
$content = "Dear <strong>" . $trainer . "</strong>";
$content .= "<br/>Có học viên <strong>" . $username . "</strong> làm xong bài test : " . $testDetails->test_name . " (" . date('H:i d/m/Y') . ")";
$content .= "<br/><a href='" . Yii::app()->createUrl("wUserTest/viewdetails", array("id" => $dataUserTest["id"])) . "'>Click để xem chi tiết</a>";
WMessage::SendMessage($title, $content, "notifi", WUser::getIDMinUser(), $courseDetails->created_by);
$modeltest = WTest::model()->find('id=:id', array(':id' => $test_id));
$this->render('/wTest/trainee/_result', array('testDetails' => $testDetails, 'totalquestion' => $totalquestion, 'totalQuestionText' => $totalQuestionText, 'totalTrue' => $totalTrue, 'totalfails' => $totalfails, 'totalnotdoing' => $totalnotdoing, 'totalnoanswer' => $totalnoanswer, 'dataUserTest' => $dataUserTest, 'dataTestUser' => $dataTestUser));
}
public static function SendMessage($title, $content, $typeSend = "notifi", $iduserFrom = NULL, $iduserTo)
{
$titlemessage = $title;
$contentmessage = $content;
if (empty($iduserFrom)) {
$iduserFrom = WUser::getIDMinUser();
}
$date = date('Y-m-d H:i:s');
if (!empty($iduserTo)) {
$message = new WMessage();
$message->status = 1;
$message->title = $titlemessage;
$message->created_by = $iduserFrom;
$message->created_date = $date;
$message->type_message = $typeSend;
if ($message->save()) {
$idmessage = $message->id;
$messgetTrash = new WMessageTrash();
$messgetTrash->id_message = $idmessage;
$messgetTrash->trash = 0;
$messgetTrash->save();
$messageContent = new WMessageContent();
$messageContent->created_date = $date;
$messageContent->content = $contentmessage;
$messageContent->id_message = $idmessage;
$messageContent->created_by = $iduserFrom;
$messageContent->status = 1;
if ($messageContent->save()) {
$idmessagecontent = $messageContent->id;
if (!empty($iduserTo)) {
$dataUser = WUser::getUserByUsername($iduserTo);
$messageSendto = new WMessageSendto();
$messageSendto->id_message = $idmessage;
$messageSendto->id_message_content = $idmessagecontent;
$messageSendto->id_user_to = $iduserTo;
$messageSendto->type_message = $typeSend;
$messageSendto->status = 0;
$messageSendto->trash = 0;
if ($messageSendto->save()) {
} else {
echo json_encode(array('result' => 'false', 'html' => 'Lỗi thao tác 03. Mời bạn thử lại'));
die;
}
}
} else {
echo json_encode(array('result' => 'false', 'html' => 'Lỗi thao tác 02. Mời bạn thử lại'));
die;
}
} else {
echo json_encode(array('result' => 'false', 'html' => 'Lỗi thao tác 01. Mời bạn thử lại'));
die;
}
} else {
echo json_encode(array('result' => 'false', 'html' => 'Không có User nào cần gửi'));
}
}
public function actionSendComment()
{
$dataType = $_REQUEST["dataType"];
$dataId = $_REQUEST["dataId"];
$action_url = $_REQUEST["action_url"];
$contentComment = $_REQUEST["contentComment"];
$parent_id = $_REQUEST["parent_id"];
$_db = Yii::app()->db;
$comm = $_db->createCommand();
$result = $comm->insert('pls_comment', array('parent_id' => $parent_id, 'user_id' => Yii::app()->user->id, 'content' => $contentComment, 'data_id' => $dataId, 'data_type' => $dataType, 'status' => 1, 'created_date' => date('Y-m-d H:i:s'), 'action_url' => strtolower($action_url)));
if ($result) {
$idnewrecord = Yii::app()->db->getLastInsertID($result);
if ($dataType == "course") {
$courseDetails = WCourse::model()->find("id=" . $dataId);
if (Yii::app()->user->id != $courseDetails->created_by) {
$title = "Bình Luận Khóa học: " . $courseDetails->course_name;
$content = "";
$user = WUser::getUserById(Yii::app()->user->id);
if (Yii::app()->session["group_id"] == 1) {
$content .= "Có giáo viên <strong>" . $user->username . "</strong> bình luận tại Khóa học: <a href='" . Yii::app()->createUrl('wCourse/view', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . "'>\"" . $courseDetails->course_name . "\"</a>";
} else {
if (Yii::app()->session["group_id"] == 2) {
$content .= "Có học viên <strong>" . $user->username . "</strong> bình luận tại Khóa học: <a href='" . Yii::app()->createUrl('wCourse/view', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . "'>\"" . $courseDetails->course_name . "\"</a>";
} else {
if (Yii::app()->session["group_id"] == 3) {
$content .= "Có Quản trị viên <strong>" . $user->username . "</strong> bình luận tại Khóa học: <a href='" . Yii::app()->createUrl('wCourse/view', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . "'>\"" . $courseDetails->course_name . "\"</a>";
}
}
}
$content .= '<br/>Click xem chi tiết: <a href="' . Yii::app()->createUrl('wCourse/view', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . '">' . $courseDetails->course_name . '</a>';
WMessage::SendMessage($title, $content, "notifi", WUser::getIDMinUser(), $courseDetails->created_by);
}
} elseif ($dataType == "courselecture") {
$courseLecture = WLecture::model()->find("id=" . $dataId);
if (Yii::app()->user->id != $courseLecture->created_by) {
$title = "Bình Luận Bài Giảng: " . $courseLecture->lecture_name;
$content = "";
$user = WUser::getUserById(Yii::app()->user->id);
if (Yii::app()->session["group_id"] == 1) {
$content .= "Có giáo viên <strong>" . $user->username . "</strong> bình luận tại Bài Giảng: <a href='" . Yii::app()->createUrl('wLecture/View', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . "'>\"" . $courseLecture->lecture_name . "\"</a>";
} else {
if (Yii::app()->session["group_id"] == 2) {
$content .= "Có học viên <strong>" . $user->username . "</strong> bình luận tại Bài Giảng: <a href='" . Yii::app()->createUrl('wLecture/View', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . "'>\"" . $courseLecture->lecture_name . "\"</a>";
} else {
if (Yii::app()->session["group_id"] == 3) {
$content .= "Có Quản trị viên <strong>" . $user->username . "</strong> bình luận tại Bài Giảng: <a href='" . Yii::app()->createUrl('wLecture/View', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . "'>\"" . $courseLecture->lecture_name . "\"</a>";
}
}
}
$content .= '<br/>Click xem chi tiết: <a href="' . Yii::app()->createUrl('wLecture/View', array("id" => $dataId, "row" => "comment_row_" . $idnewrecord)) . '">' . $courseLecture->lecture_name . '</a>';
WMessage::SendMessage($title, $content, "notifi", WUser::getIDMinUser(), $courseLecture->created_by);
}
}
echo json_encode(array("result" => "true"));
} else {
echo json_encode(array("result" => "false"));
}
}
public function actionEndLectureText()
{
$course_lecture_id = $_POST['course_lecture_id'];
$idtraininglog = $_POST['idtraininglog'];
$totalText = $_POST['totalText'];
$totalViewText = $_POST['totalViewText'];
$viewListText = $_POST['viewListText'];
$user_id = Yii::app()->user->id;
$timeOK = $totalViewText / $totalText * 100;
$viewText = $totalViewText . ' / ' . $totalText;
$check = 'NOK';
if ($timeOK >= 90) {
$check = 'OK';
}
//$des = ' View : ('. number_format($timeOK,2,',','.') .'% View pages '.$viewText.')';
$des = ' Hoàn thành : (' . number_format($timeOK, 2, ',', '.') . '% Xem ' . $viewText . ')';
$desNotifi = 'Học viên hoàn thành : (' . number_format($timeOK, 2, ',', '.') . '% Xem ' . $viewText . ')';
$modelTrainingLog = WTrainingLog::model()->findByPk($idtraininglog);
$modelTrainingLog->user_id = $user_id;
$modelTrainingLog->description = $des;
$modelTrainingLog->result = $check;
$modelTrainingLog->data = $viewListText;
if ($modelTrainingLog->save()) {
if ($modelTrainingLog->result == 'OK') {
$userinfo = WUser::getFullNameUser(Yii::app()->user->id);
$couseDetails = WCourseLecture::getInfoCourse($course_lecture_id);
$trainer = WUser::getFullNameUser($couseDetails["created_by"]);
$title = "Học viên " . $userinfo . " hoàn thành bài giảng:" . $couseDetails["course_name"];
$content = "Dear <strong>" . $trainer . "</strong>";
$content .= "<br/>Học viên <strong>" . $userinfo . '</strong> hoàn thành Bài giảng: <a href="' . Yii::app()->createUrl("wCourse/view", array("id" => $couseDetails["id"])) . '"><strong>' . $couseDetails["course_name"] . " (" . date('H:i d/m/Y') . ")</strong></a>";
//$content .="<br/>==> <a href='".Yii::app()->createUrl("wCourse/view",array("id" => $couseDetails["id"]))."'>".$couseDetails["course_name"]."</a>";
//$content .="<br />Congratulations, you have completed the lesson. ";
//$content .="<br />Xin chúc mừng, Bạn đã hoàn thành bài học. ";
$content .= "<br />" . $modelTrainingLog->description;
WMessage::SendMessage($title, $content, "notifi", WUser::getIDMinUser(), $couseDetails["created_by"]);
$mess = 'Xin chúc mừng, Bạn đã hoàn thành bài học. <br />' . $modelTrainingLog->description;
// Chúc mừng bạn đã hoàn thành bài học
} else {
//$mess = 'You need to learn the lesson. <br />'.$modelTrainingLog->description;//Bạn cần phải học lại bài học.
$mess = 'Bạn chưa hoàn thành bài học. <br />' . $modelTrainingLog->description;
//Bạn cần phải học lại bài học.
}
echo json_encode(array('status' => 'true', 'result' => $modelTrainingLog->result, 'mess' => $mess));
} else {
echo json_encode(array('status' => 'false'));
}
}