public function actionLoadMoreSchedule() { $data = array(); if (isset($_POST['page'])) { $page_number = filter_var($_POST['page'], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); } else { $page_number = 0; } if (!is_numeric($page_number)) { header('HTTP/1.1 500 Invalid page number!'); $this->redirect('/'); } $position = $page_number / params::$coursePerPage; $schedule = new WCourse(); $courseSchedule = $schedule->getListCourseSchedule($position, params::$coursePerPage); $data = $this->render('_loadmore', array('courseSchedule' => $courseSchedule)); }
public function actionCourses1() { $criteria = new CDbCriteria(); // $criteria->condition ='user_group_id=1'; $criteria->order = 'id desc'; $criteria->limit = 10; $count = WCourse::model()->count($criteria); $pages = new CPagination($count); $pages->pageSize = Params::$rowsPerPage; $pages->applyLimit($criteria); $courselist = WCourse::model()->findAll($criteria); $data = array(); $db = Yii::app()->db; $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course t')->leftJoin('pls_course_cat t1', 't1.id = t.course_cat_id')->where('t.status = 0 OR t.status = 1')->order('t.id DESC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select(' t.*, t1.course_cat, t1.avatar ')->from('pls_course t')->leftJoin('pls_course_cat t1', 't1.id = t.course_cat_id')->where('t.status = 0 OR t.status = 1')->order('t.id DESC'); $result = $comm->queryAll(); $limit = 10; $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page - 1); $comm->limit = $limit; $comm->offset = $offset; $data = $comm->queryAll(); if (!empty($data)) { $data = CJSON::decode(CJSON::encode($data)); } $count = WCourse::model()->count($criteria); $pages = new CPagination($count); $pages->pageSize = Params::$rowsPerPage; $pages->applyLimit($criteria); // var_dump($data);die; $this->render('listcourse', array('data' => $data, 'courselist' => $courselist, 'pages' => $pages)); }
public function actionTraineeCalendarLecture($id) { if (empty(Yii::app()->user->id)) { $this->redirect(Yii::app()->createUrl('')); } $course = WCourse::model()->find('id=' . $id); $db = Yii::app()->db; $comm = $db->createCommand()->select('t.*,t3.lecture_name,t3.lecture_type,t2.lecture_id,t2.start_date,t2.end_date,t2.id as idcourselecture,t4.fullname,t4.username')->from('pls_course_trainee t')->leftJoin('pls_course_lecture t2', 't.course_id=t2.course_id')->leftJoin('pls_lecture t3', 't3.id=t2.lecture_id')->leftJoin('pls_user t4', 't4.id=t2.trainer_id')->where('t2.course_id=' . $id . ' AND t.trainee_id=' . Yii::app()->user->id)->order('t2.start_date ASC'); $data = $comm->queryAll(); $this->render('trainee/calendar_lecture', array('course' => $course, 'data' => $data)); }
public function actionCopyCourse() { $idcourse = $_REQUEST["idcourse"]; $dataCourse = WCourse::model()->find("id=" . $idcourse); $check = 0; if (!empty($dataCourse)) { $modelCourse = new WCourse(); $modelCourse->approve = $dataCourse->approve; $modelCourse->avatar = $dataCourse->avatar; $modelCourse->course_cat_id = $dataCourse->course_cat_id; $space = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; $newCode = ""; $index = 0; for ($i = 0; $i < strlen($space); $i++) { $checkData = WCourse::model()->findAll("course_code='" . $dataCourse->course_code . $space[$i] . "'"); if (empty($checkData)) { $newCode = $dataCourse->course_code . $space[$i]; break; } else { $index++; } } $name = "Copy "; if ($index != 0) { $name .= $index . ' '; } $modelCourse->course_code = $newCode; $modelCourse->course_name = $name . $dataCourse->course_name; $modelCourse->created_by = $dataCourse->created_by; $modelCourse->created_date = date('Y-m-d H:i:s'); $modelCourse->description = $dataCourse->description; $modelCourse->start_date = NULL; $modelCourse->end_date = NULL; $modelCourse->hot_course = 0; $modelCourse->intruduce = $dataCourse->intruduce; $modelCourse->lecture_count = $dataCourse->lecture_count; $modelCourse->status = $dataCourse->status; $modelCourse->trainee_count = 0; $modelCourse->trainer_id = $dataCourse->trainer_id; if ($modelCourse->save()) { $idcoursenew = $modelCourse->id; $dataCourseLecture = WCourseLecture::model()->findAll('course_id=' . $idcourse . ' ORDER BY start_date ASC'); if (!empty($dataCourseLecture)) { foreach ($dataCourseLecture as $courselecture) { $modelCourseLecture = new WCourseLecture(); $modelCourseLecture->course_id = $idcoursenew; $modelCourseLecture->end_date = NULL; $modelCourseLecture->start_date = NULL; $modelCourseLecture->status = $courselecture->status; $modelCourseLecture->trainer_id = $courselecture->trainer_id; $modelCourseLecture->lecture_id = $courselecture->lecture_id; if ($modelCourseLecture->save()) { } else { $check = 2; } } } } else { $check = 1; } } $mess = ""; $status = "true"; if ($check == 0) { $mess = "Copy thành công"; $status = "true"; } elseif ($check == 1) { $status = "false"; $mess = "Không thêm mới được Course. Lỗi thao tác, mời bạn thử lại."; } else { $status = "false"; $mess = "Lỗi thao tác, mời bạn thử lại."; } echo json_encode(array("result" => $status, 'message' => $mess)); }
<?php $form = $this->beginWidget('CActiveForm', array('id' => 'wcourse-trainee-form', 'focus' => '#LoginForm_username', 'enableAjaxValidation' => false)); ?> <p class="note">Fields with <span class="required">*</span> are required.</p> <?php echo $form->errorSummary($model); ?> <div class="row"> <?php echo $form->labelEx($model, 'course_id'); ?> <?php echo $form->dropDownList($model, 'course_id', CHtml::listData(WCourse::model()->findAll(), 'id', 'course_name'), array('prompt' => 'Chọn khóa học :')); ?> <?php echo $form->error($model, 'course_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'trainee_id'); ?> <?php echo $form->dropDownList($model, 'trainee_id', CHtml::listData(WUser::model()->findAll("group_id=2"), 'id', 'fullname'), array('class' => 'chosen-select', 'multiple' => 'multiple', 'data-placeholder' => "Chọn học viên vào lớp")); ?> <?php
public static function getTestByCourse() { $criteria = new CDbCriteria(); $criteria->alias = 'c'; $criteria->distinct = true; //$criteria->select = 'cl.*, c.*'; //$criteria->join = 'LEFT JOIN {{user_test}} AS ut ON c.id = ut.course_id'; //$criteria->join = 'LEFT JOIN {{course_lecture}} AS cl ON cl.course_id = c.id'; $criteria->condition = 'c.created_by=:created_by and c.status>=:status'; $criteria->params = array(':created_by' => Yii::app()->user->id, ':status' => 1); $criteria->order = ''; $rs = WCourse::model()->findAll($criteria); //$sql = "Select "; //var_dump($rs);exit(); if ($rs) { return $rs; } else { return null; } }
left: 7px; border: 2px solid #fff; } .dot-notifi:before{ background: #01a0e6; } </style> <ul > <li class="dropdown lv1"> <?php $dataTotalNotifi = WMessageSendto::getTotalReadMessage("notifi"); $totalresgister = WCourseTrainee::getTotalTraineeRegister(); $totalnotifi = count($dataTotalNotifi) + $totalresgister; // Thong Bao Kich Hoat Course (Super) if (Yii::app()->session["group_id"] == 3) { $totalCourseRegister = WCourse::getTotalCourseNoActive(); $totalnotifi = $totalnotifi + $totalCourseRegister; } // Danh sach Course Sap dien ra (Trainee Hoc vien) if (Yii::app()->session["group_id"] == 2) { $courseStart = WCourseTrainee::getCourseStartTrainee(); $totalnotifi = $totalnotifi + count($courseStart); } // Danh sach Course Sap dien ra (Trainer Giao Vien) if (Yii::app()->session["group_id"] == 1) { $courseStartTrainer = WCourseTrainee::getCourseStartTrainer(); $totalnotifi = $totalnotifi + count($courseStartTrainer); } ?> <a href="javascript:;" data-toggle="dropdown" role="button" aria-expanded="false" style="position: relative;"> <img src="<?php
" class="btn btn-info" style="float: right; margin-right: 10px; margin-top: 20px;">Category Test</a> <a class="btn btn-warning" style="float: right; margin-right: 10px; margin-top: 20px;" href="<?php echo Yii::app()->createUrl('wTest/QuestionLib'); ?> "><span class="btn_right">Ngân hàng câu hỏi</span></a> <div class="clear"></div> </div> </div> <div class="primary_container"> <div class="primary_container_test" style="box-shadow: 0px 0px 0px; border: 0px; "> <div class="container_test"> <div class="col-md-12" style="padding-bottom:15px;"> <b style="float:left;margin:5px 0;">Filter</b> <div class="col-md-3"> <?php echo CHtml::dropDownList("course_list_id", 'course_list_id', CHtml::listData(WCourse::model()->findAll("status=1"), 'id', 'course_name'), array("onchange" => "return LoadTestResult();", 'prompt' => '--' . Yii::t('web/home', 'Select Course') . '--', 'class' => 'form-control chosen-select')); ?> </div> <div class="col-md-3"> <select id="test_kind" name="course" onchange="return LoadTestResult();" class="form-control"> <option value="">Select Type</option> <option value="1">Pre Test</option> <option value="0">Post Test</option> </select> </div> <div class="col-md-3"> <select id="test_success" onchange="return LoadTestResult();" class="form-control"> <option value="" selected="selected">Select Success</option> <option value="1">Chưa hoàn thành(Chờ chấm điểm)</option> <option value="2">Hoàn Thành</option>
/** * 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 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")); } }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return WCourse the loaded model * @throws CHttpException */ public function loadModel($id) { $model = WCourse::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
echo Yii::app()->createUrl('wCourseTrainee/Listtraineeall'); ?> ">View list</a> </span> </p> </div> <div class="clear"></div> </div> <div class="chart_trainer_right chart_trainer_item fr"> <img class="fl" src="<?php echo Yii::app()->theme->baseUrl; ?> /img/chart-people.png" /> <div class="fl"> <p class="people_online color_40b80c"><?php echo WCourse::getTotalTraineeOfCourse(); ?> </p> <p class="people_row">Trainees in my courses</p> </div> <div class="clear"></div> </div> <div class="clear"></div> </div> <div class="chart_trainer chart_trainer_list"> <div class="chart_trainer_list_item"> <?php $this->widget('web.widgets.wg_data_training_course', array('title' => 'Training Courses')); ?> </div> <div class="chart_trainer_list_item">
public function actionLoadMoreIndex() { //sanitize post value $data = array(); if (isset($_POST["page"])) { $page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); } else { $page_number = 0; } if (isset($_REQUEST["view"])) { $view = $_REQUEST['view']; } else { $view = '_loadmore'; } //throw HTTP error if page number is not valid if (!is_numeric($page_number)) { header('HTTP/1.1 500 Invalid page number!'); $this->redirect('/'); } //get current starting point of records $position = $page_number * Params::$coursePerPage; // vị trí = số trang* số bản ghi của 1 trang //Limit our results within a specified range. $listcours = new WCourse(); $results = $listcours->getListCouresuper($position, Params::$coursePerPage); //var_dump($results);die; $data = $this->renderPartial('supervisor/' . $view, array('listcourses' => $results), true); // var_dump($data);die; echo $data; }
// $newValue = Yii::app()->createUrl('aaa'); // echo CHtml::dropDownList('filter_season', $newValue, $listname); // } ?> <!-- <?php echo CHtml::form(array('extra/save'), 'post'); echo CHtml::hiddenField('model', 'wcoursetrainee'); ?> <div class='menuaction' > <?php echo CHtml::ajaxSubmitButton(Yii::t('app', 'Save'), array('/extra/save'), array('type' => 'POST', 'success' => 'function(data, textStatus, XMLHttpRequest) { $("#wcoursetrainee-grid").yiiGridView.update("wcoursetrainee-grid"); }', array('')), array('')); ?> </div> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'wcoursetrainee-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array(array('name' => 'course_id', 'value' => 'WCourse::model()->findByPk($data->course_id) == null ? "" : WCourse::model()->findByPk($data->course_id)->course_name', 'filter' => CHtml::listData(WCourse::model()->findAll('status=1 and trainee_count >0'), 'id', 'course_name')), array('name' => 'avatar', 'value' => 'WUser::model()->findByPk($data->trainee_id) == null ? "" : CHtml::image(Yii::app()->params["url_base"]."/uploads/avatars/user/".WUser::model()->findByPk($data->trainee_id)->avatar)', 'type' => 'image'), array('name' => 'Trainee', 'value' => 'WUser::model()->findByPk($data->trainee_id) == null ? "" : WUser::model()->findByPk($data->trainee_id)->fullname'), array('name' => 'email', 'value' => 'WUser::model()->findByPk($data->trainee_id) == null ? "" : WUser::model()->findByPk($data->trainee_id)->email'), array('name' => 'phone', 'value' => 'WUser::model()->findByPk($data->trainee_id) == null ? "" : WUser::model()->findByPk($data->trainee_id)->phone'), array('name' => 'address', 'value' => 'WUser::model()->findByPk($data->trainee_id) == null ? "" : WUser::model()->findByPk($data->trainee_id)->address'), array('name' => 'birthday', 'value' => 'WUser::model()->findByPk($data->trainee_id) == null ? "" : WUser::model()->findByPk($data->trainee_id)->date_birth'), array('name' => 'status', 'header' => 'status', 'value' => '($data->status=="1")?("Pendding"):("Activated")')))); ?> <?php echo CHtml::endForm(); ?> --> </div> <table class="table table-hover"> <thead class="first_thead"> <tr> <th>Avatar</th> <th>User Account</th> <th>Full name</th> <th>Company</th> <th>Email</th>
public function actionActiveCourse() { // active course group_id=3 $courseId = $_POST['course_id']; $status = $_POST['status']; $model = WCourse::model()->findByPk($courseId); // var_dump($model);die; if ($status == 1) { $model->status = 0; } else { $model->status = 1; } if ($model->save()) { $userFrom = Yii::app()->user->id; $userTo = $model->created_by; $username = WUser::getFullNameUser($userTo); $title = "Khoá học :" . $model->course_name . ' của bạn đã được kích hoạt'; $content = "Dear <strong>" . $username . "</strong>"; $content .= "<br/>Khóa học của bạn đã được kích hoạt hoàn toàn"; $content .= "<br/>Ngay bây giờ bạn có thể cho học viên của bạn học những bài giảng của khóa học này."; $content .= "<br/>Click đi đến bài viết <a href='" . Yii::app()->createUrl('wCourse/view', array("id" => $courseId)) . "'>" . $model->course_name . "</a> "; $content .= "<br/>Chúc bạn một ngày làm việc tốt"; WMessage::SendMessage($title, $content, "notifi", $userFrom, $userTo); $status = json_encode(array('status' => 'true', 'result' => $model->status)); } else { $status = json_encode(array('status' => 'false')); } echo $status; }
/** * Lists all models. */ public function actionIndex() { if (empty(Yii::app()->user->id) || Yii::app()->session['group_id'] == 2 || empty($_REQUEST['course_id'])) { $this->redirect(Yii::app()->createUrl('')); } $courseId = $_REQUEST['course_id']; $model = WCourse::model()->find('id=' . $courseId); $offset = 0; $limit = 6; $where = ''; if (!empty($_REQUEST['course_id'])) { $where .= ' AND t2.id=' . $_REQUEST['course_id']; } if (Yii::app()->session["group_id"] == 3) { } elseif (Yii::app()->session["group_id"] == 2) { $where .= " AND t2.trainer_id=" . Yii::app()->user->id; } $db = Yii::app()->db; $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course_trainee t1')->leftJoin('pls_course t2', 't2.id= t1.course_id')->leftJoin('pls_user t3', 't1.trainee_id = t3.id')->where('t3.user_group_id=2 ' . $where); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select('t2.course_name,t2.id as course_id,t2.course_code,t1.status,t1.id as idcoursetrainee,t3.username,t3.fullname,t3.email,t3.phone,t3.company,t3.id')->from('pls_course_trainee t1')->leftJoin('pls_course t2', 't2.id= t1.course_id')->leftJoin('pls_user t3', 't1.trainee_id = t3.id')->where('t3.user_group_id=2 ' . $where)->order('t1.status ASC,t1.register_date ASC'); $comm->limit = $limit; $comm->offset = $offset; $data = $comm->queryAll(); $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course_trainee t1')->leftJoin('pls_course t2', 't2.id= t1.course_id')->leftJoin('pls_user t3', 't1.trainee_id = t3.id')->where('t3.user_group_id=2 ' . $where); $countTrainee = $comm->queryScalar(); $total_pages = ceil($countTrainee / 6); $this->render('index', array('total_pages' => $total_pages, 'model' => $model, 'data' => $data)); }