public static function checkTestPreTest($test_id)
 {
     $criteria = new CDbCriteria();
     $criteria->condition = 'test_id =:test_id OR pre_test_id =:pre_test_id';
     $criteria->params = array(':test_id' => $test_id, ':pre_test_id' => $test_id);
     $rs = WCourseLecture::model()->findAll($criteria);
     if ($rs && count($rs) > 0) {
         return true;
     } else {
         return false;
     }
 }
. Results will be announced later.</div>
            
            </div>
            <div>
                <?php 
if ($model->kind_of_test == 1 or $model->kind_of_test == 2) {
    $cl = WCourseLecture::model()->find('course_id=' . $_REQUEST['course_id'] . ' AND lecture_id=' . $_REQUEST['lecture_id'] . ' AND pre_test_id=' . $_REQUEST['test_id']);
    ?>
                <a class="btn btn-danger" style="margin-top: 10px" href="<?php 
    echo Yii::app()->createUrl('wLecture/LectureView', array('course_lecture_id' => $cl->id));
    ?>
">Continue Lecture</a>
                <?php 
} elseif ($model->kind_of_test == 0) {
    ?>
                    <?php 
    $cl = WCourseLecture::model()->find('course_id=' . $_REQUEST['course_id'] . ' AND lecture_id=' . $_REQUEST['lecture_id'] . ' AND test_id=' . $_REQUEST['test_id']);
    ?>
                    <p><a class="btn btn-danger" style="margin-top: 10px" href="<?php 
    echo Yii::app()->createUrl('wCourse/TraineeViewCourse', array('id' => $cl->course_id));
    ?>
">Continue Course</a></p>
                    <p><span style="color: green; margin-top: 10px;">Congratulations, you have completed the lesson.</span></p>
                <?php 
}
?>
            </div>
        </div>
        
    </div>
</div>
 /**
  * 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 WCourseLecture the loaded model
  * @throws CHttpException
  */
 public function loadModel($id)
 {
     $model = WCourseLecture::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }
 public static function getTestByLectureLog()
 {
     $criteria = new CDbCriteria();
     $criteria->condition = 'user_id=:user_id and result=:result';
     $criteria->params = array(':user_id' => Yii::app()->user->id, ':result' => 'OK');
     $criteria->order = 'id DESC';
     $rs = WTrainingLog::model()->findAll($criteria);
     if ($rs) {
         $arrCL = array();
         foreach ($rs as $r) {
             $action = $r['action_url'];
             $arrAction = explode('&', $action);
             $stra = $arrAction[1];
             $course_lecture_id = explode('=', $stra);
             $arrCL[] = WCourseLecture::model()->find('id=:id ORDER BY id DESC', array(':id' => $course_lecture_id[1]));
         }
         return $arrCL;
     } else {
         return null;
     }
 }
 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));
 }
 /**
  * Trainee thuc hien 1 bai test
  * @param: $test_id : Test
  * @param: $course_id: Course  
  **/
 public function actionStarttest($test_id, $course_id, $lecture_id)
 {
     self::CheckLogin();
     $this->layout = '//layouts/main_trainer';
     $cs = Yii::app()->getClientScript();
     unset($_SESSION['dataQuestionLis']);
     $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');
     //Check trainee co trong khoa hoc hay khong
     if (WCourseTrainee::CheckTraineeInCourse($course_id) == FALSE) {
         $this->redirect(Yii::app()->CreateUrl("/"));
     }
     $kind = isset($_REQUEST['kind']) ? $_REQUEST['kind'] : '';
     $db = Yii::app()->db;
     $comm = $db->createCommand()->select('t.*,t2.test_cat')->from('pls_test_parent t')->leftJoin('pls_test_cat t2', 't.test_cat_id = t2.id')->where('t.id=' . $test_id);
     $result = $comm->queryRow();
     $dataQuestion = array();
     $dataQuestionLib = array();
     // Luu Data Question vao 1 mang
     $dataTestUser = WTestUser::model()->find("id_test_parent=" . $test_id . ' AND course_id=' . $course_id . ' AND lecture_id=' . $lecture_id . ' AND user_id=' . Yii::app()->user->id);
     if (empty($dataTestUser)) {
         if (!empty($result["dataconfig"])) {
             $dataconfig = json_decode($result["dataconfig"], true);
             $dataQuestionFix = array();
             $totalquestion = 0;
             // Ket noi database
             $db = Yii::app()->db;
             $comm = $db->createCommand();
             if (isset($dataconfig["datafix"]) and !empty($dataconfig["datafix"])) {
                 $totalquestion += count($dataconfig["datafix"]);
                 if (!empty($result["if_random"])) {
                     $dataNew = array();
                     $i = 0;
                     $count = count($dataconfig["datafix"]);
                     while ($i < $count) {
                         $indexrandom = array_rand($dataconfig["datafix"]);
                         $dataNew[$i] = $dataconfig["datafix"][$indexrandom];
                         unset($dataconfig["datafix"][$indexrandom]);
                         $i++;
                     }
                     $dataconfig["datafix"] = $dataNew;
                 }
                 foreach ($dataconfig["datafix"] as $key => $ItemdataquestionFix) {
                     $dataQuestionFix[] = $ItemdataquestionFix["idquestion"];
                     $dataQuestionLib[$key] = $ItemdataquestionFix;
                 }
             }
             /////////////
             if (isset($dataconfig["datarandom"]) and !empty($dataconfig["datarandom"])) {
                 foreach ($dataconfig["datarandom"] as $itemdatarandom) {
                     $totalquestion += $itemdatarandom["number_question"];
                     $point = $itemdatarandom["point_question"] / $itemdatarandom["number_question"];
                     $comm->reset();
                     $comm = $comm->select('*')->from('pls_question_lib t');
                     if (!empty($dataQuestionFix)) {
                         $comm = $comm->where('t.question_cat_id=' . $itemdatarandom["idcate"] . ' AND t.id NOT IN(' . implode(',', $dataQuestionFix) . ')');
                     } else {
                         $comm = $comm->where('t.question_cat_id=' . $itemdatarandom["idcate"]);
                     }
                     $comm = $comm->order('RAND()')->limit($itemdatarandom["number_question"]);
                     $data = $comm->queryAll();
                     $dataNew = array();
                     if (!empty($data)) {
                         foreach ($data as $key => $dataItem) {
                             $dataNew[$key]["idquestion"] = $dataItem["id"];
                             $dataNew[$key]["point"] = $point;
                         }
                         $dataQuestionLib = array_merge($dataQuestionLib, $dataNew);
                     }
                 }
             }
             $dataTestUser = new WTestUser();
             $dataTestUser->id_test_parent = $test_id;
             $dataTestUser->user_id = Yii::app()->user->id;
             $dataTestUser->dataquestion = json_encode($dataQuestionLib);
             $dataTestUser->course_id = $course_id;
             $dataTestUser->lecture_id = $lecture_id;
             $dataTestUser->kind = $kind;
             $dataTestUser->save();
         }
     } else {
         if (!empty($dataTestUser->dataquestion)) {
             $dataQuestionLib = json_decode($dataTestUser->dataquestion, true);
         }
     }
     $total = count($dataQuestionLib);
     $kind = isset($_REQUEST['kind']) ? $_REQUEST['kind'] : '';
     $model = new WUserTest();
     $model->test_id = $test_id;
     $model->course_id = $course_id;
     $model->lecture_id = $lecture_id;
     $model->user_id = Yii::app()->user->id;
     $model->status = 0;
     $model->added_date = date('Y-m-d H:i:s');
     if ($kind == '' or $kind == 1) {
         $model->test_kind = 1;
     } else {
         $model->test_kind = 0;
     }
     //echo $model->test_kind; exit();
     $oneut = WUserTest::model()->find('test_id=:test_id and course_id=:course_id and lecture_id=:lecture_id and user_id=:user_id and test_kind=:test_kind', array(':test_id' => $test_id, ':course_id' => $course_id, ':lecture_id' => $lecture_id, ':user_id' => Yii::app()->user->id, ':test_kind' => $model->test_kind));
     if (is_null($oneut)) {
         $model->save();
         $user_test_id = $model->id;
     } else {
         if ($oneut->status >= 1) {
             $cl = WCourseLecture::model()->find('course_id=' . $course_id . ' AND lecture_id=' . $lecture_id);
             if ($kind == 1) {
                 $this->redirect(Yii::app()->createUrl("wLecture/LectureView", array("course_lecture_id" => $cl->id)));
             } elseif ($kind == 0) {
                 $this->redirect(Yii::app()->createUrl("wCourse/TraineeViewCourse", array("id" => $cl->course_id)));
             }
         }
         $user_test_id = $oneut->id;
     }
     $per_page = 1;
     $page_number = isset($_POST['page']) ? $_POST['page'] : 0;
     $position = $page_number * $per_page;
     if (!empty($total)) {
         $pagination = WFunction::gettab($dataQuestionLib);
     } else {
         $pagination = '';
     }
     $this->render('/wTest/trainee/starttest', array('course_id' => $course_id, 'lecture_id' => $lecture_id, 'test' => $result, 'pagination' => $pagination, 'total' => $total, 'kind' => $model->test_kind, "question" => $dataQuestionLib, "user_test_id" => $user_test_id));
 }
 public static function getInfoCourseLectureComment($idcomment, $dataId, $dataType)
 {
     $db = Yii::app()->db;
     $dataNew = array();
     $group_id = Yii::app()->session["group_id"];
     if ($dataType == "course") {
         $comm = $db->createCommand()->select('t.*')->from('pls_course t')->where("t.id IS NOT NULL AND t.id=" . $dataId);
         $data = $comm->queryRow();
         if (!empty($data)) {
             $dataNew[$idcomment]["name"] = 'Course: ' . $data["course_name"];
             $url = Yii::app()->createUrl("wCourse/view", array("id" => $data["id"]));
             switch ($group_id) {
                 case 1:
                     $url = Yii::app()->createUrl("wCourse/view", array("id" => $data["id"], "row" => "comment_row_" . $idcomment));
                     break;
                 case 2:
                     $url = Yii::app()->createUrl("wCourse/TraineeViewCourse", array("id" => $data["id"], "row" => "comment_row_" . $idcomment));
                     break;
                 case 3:
                     $url = Yii::app()->createUrl("wCourse/view", array("id" => $data["id"], "row" => "comment_row_" . $idcomment));
                     break;
             }
             $dataNew[$idcomment]["url"] = $url;
         }
     } elseif ($dataType == "courselecture") {
         $comm = $db->createCommand()->select('t.*')->from('pls_lecture t')->where("t.id IS NOT NULL AND t.id=" . $dataId);
         $data = $comm->queryRow();
         if (!empty($data)) {
             $url = NULL;
             switch ($group_id) {
                 case 1:
                 case 3:
                     $url = Yii::app()->createUrl("wLecture/View", array("id" => $data["id"], "row" => "comment_row_" . $idcomment));
                     break;
                 case 2:
                     $datacourselecture = WCourseLecture::model()->findAll("lecture_id=" . $dataId);
                     $course_lecture_id = NULL;
                     if (!empty($datacourselecture)) {
                         foreach ($datacourselecture as $itemcourelecture) {
                             $modelCourseTrainee = WCourseTrainee::model()->find("course_id=" . $itemcourelecture->course_id . ' AND trainee_id=' . Yii::app()->user->id);
                             if (!empty($modelCourseTrainee)) {
                                 $course_lecture_id = $itemcourelecture->id;
                             }
                         }
                     }
                     if (!empty($course_lecture_id)) {
                         $url = Yii::app()->createUrl("wLecture/LectureView", array("course_lecture_id" => $course_lecture_id, "row" => "comment_row_" . $idcomment));
                     } else {
                         $url = "javascript:;";
                     }
                     break;
                     /*case 3:
                       $url = Yii::app()->createUrl("wSuperLecture/LectureView",array("course_lecture_id" => $data["id"]));;
                       break;*/
             }
             $dataNew[$idcomment]["name"] = 'Lecture: ' . $data["lecture_name"];
             $dataNew[$idcomment]["url"] = $url;
         }
     }
     return $dataNew;
 }
Exemple #8
0
<?php

/* @var $this LectureController */
/* @var $model WLecture */
/* @var $form CActiveForm */
$checkEmpty = array();
if (!$model->isNewRecord) {
    $checkEmpty = WCourseLecture::model()->findAll("lecture_id=" . $model->id);
}
?>
<div class="primary_page_edit">
    <div class="form_avatar">
        <a href="javascript:void(0);" style="min-height: 50px;">
            <center>
                <?php 
if (!empty($model->avatar)) {
    ?>
                    <img id="img_avatar_course" style="width:100%;" src="<?php 
    echo Yii::app()->params['url_base'] . '/uploads/avatars/lecture/' . $model->avatar;
    ?>
" alt=""/>
                    <?php 
} else {
    ?>
                    <img id="img_avatar_course" style="width:100%;" src="<?php 
    echo Yii::app()->theme->baseUrl;
    ?>
/img/add-avatar-lecture.jpg" alt=""/>
                <?php 
}
?>
                    <?php 
    if ($dataTestUser["kind"] == 1) {
        ?>
                    <?php 
        $cl = WCourseLecture::model()->find('course_id=' . $dataTestUser['course_id'] . ' AND lecture_id=' . $dataTestUser['lecture_id'] . ' AND pre_test_id=' . $dataTestUser['id_test_parent'] . '');
        ?>
                    <a class="btn btn-danger" style="margin-top: 10px" href="<?php 
        echo Yii::app()->createUrl('wLecture/LectureView', array('course_lecture_id' => $cl->id));
        ?>
">Continue Lecture</a></p>
                    <?php 
    } elseif ($dataTestUser["kind"] == 0) {
        ?>
                    <?php 
        $cl = WCourseLecture::model()->find('course_id=' . $dataTestUser['course_id'] . ' AND lecture_id=' . $dataTestUser['lecture_id'] . ' AND test_id=' . $dataTestUser['id_test_parent'] . '');
        ?>
                    <a class="btn btn-danger" style="margin-top: 10px" href="<?php 
        echo Yii::app()->createUrl('wCourse/TraineeViewCourse', array('id' => $cl->course_id));
        ?>
">Continue</a></p>
                    <?php 
    }
    ?>
                <?php 
}
?>
            </div>
        </div>
    </div>
</div>
 public function actionLectureList()
 {
     if (empty(Yii::app()->user->id)) {
         $this->redirect(Yii::app()->createUrl(''));
     }
     $db = Yii::app()->db;
     $comm = $db->createCommand()->select('t.*')->from('pls_lecture_cat t');
     $data_lecture = $comm->queryAll();
     $comm = $db->createCommand()->select('t.*')->from('pls_course t')->leftJoin('pls_course_lecture t1', 't1.course_id = t.id')->group('t.id');
     $data_course = $comm->queryAll();
     $string_where = 't.status = 1';
     $data = array();
     if (isset($_REQUEST["page"])) {
         $page_number = filter_var($_REQUEST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
     } else {
         $page_number = 0;
     }
     if (isset($_REQUEST["cate"]) && !empty($_REQUEST["cate"])) {
         $string_where .= ' AND t2.id=' . $_REQUEST["cate"];
     } else {
         // $value='';
     }
     if (isset($_REQUEST["course"]) && !empty($_REQUEST["course"])) {
         $string_where .= ' AND t.course_id=' . $_REQUEST["course"];
     } else {
         // $value='';
     }
     $position = 0;
     $itempage = 6;
     $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course_lecture t')->leftJoin('pls_lecture t1', 't1.id = t.lecture_id')->leftJoin('pls_lecture_cat t2', 't2.id = t1.lecture_cat_id')->leftJoin('pls_course t4', 't4.id = t.course_id')->where($string_where)->order('t.start_date ASC');
     $total = $comm->queryScalar();
     $comm->reset();
     $comm = $db->createCommand()->select('
                 t.id,
                 t1.lecture_type,
                 t1.lecture_name,
                 t1.training_minute,
                 t1.intro,
                 t1.avatar,
                 t1.pages,
                 t4.course_code,
                 t2.cat_name,
                 t5.fullname
             ')->from('pls_course_lecture t')->leftJoin('pls_lecture t1', 't1.id = t.lecture_id')->leftJoin('pls_lecture_cat t2', 't2.id = t1.lecture_cat_id')->leftJoin('pls_course t4', 't4.id = t.course_id')->leftJoin('pls_user t5', 't.trainer_id = t5.id')->where($string_where)->order('t.start_date ASC');
     // var_dump($string_where);
     /*$limit = 10;
       $page = (isset($_GET['page']) AND !empty($_GET['page'])) ? $_GET['page'] : 1;
       $offset = $limit * ($page-1);
        $pages = new CPagination($total);
       $pages->pageSize = $limit;
       */
     $comm->limit = $itempage;
     $comm->offset = $page_number * 6;
     $results = $comm->queryAll();
     $countLecture = WCourseLecture::model()->findAll();
     $total_pages = ceil(count($countLecture) / 6);
     // số trang = tất cả bản ghi/số bản ghi hiển thị 1 trang
     $this->render('supervisor/lecturelist', array('total_pages' => $total_pages, 'data_lecture' => $data_lecture, 'data_course' => $data_course, 'results' => $results));
 }
 public function actionUpdateTest()
 {
     $course_id = $_POST['course_id'];
     $lecture_id = $_POST['lecture_id'];
     $status = $_POST['status'];
     $idTest = $_POST['idTest'];
     $kind_of_test = $_POST['kind_of_test'];
     $model = WCourseLecture::model()->find('course_id=' . $course_id . ' AND lecture_id=' . $lecture_id);
     if ($status == 0) {
         if ($kind_of_test == 0) {
             $model->pre_test_id = $idTest;
         } elseif ($kind_of_test == 1) {
             $model->test_id = $idTest;
         }
     } else {
         if ($kind_of_test == 0) {
             $model->pre_test_id = '';
         } elseif ($kind_of_test == 1) {
             $model->test_id = '';
         }
     }
     if ($model->save()) {
         if ($kind_of_test == 0) {
             $idTest = $model->pre_test_id;
         } elseif ($kind_of_test == 1) {
             $idTest = $model->test_id;
         }
         echo json_encode(array('status' => 'true', 'idTest' => $idTest));
     } else {
         echo json_encode(array('status' => 'false', 'idTest' => 0));
     }
 }
 /**
  * Deletes a particular model.
  * If deletion is successful, the browser will be redirected to the 'admin' page.
  * @param integer $id the ID of the model to be deleted
  */
 public function actionDelete($id)
 {
     WCourseTrainee::model()->deleteAll(array('trainee_id' => $id));
     WCourseLecture::model()->deleteAll(array('trainee_id' => $id));
     WUserTest::model()->deleteAll(array('user_id' => $id));
     $this->loadModel($id)->delete();
     // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
     if (!isset($_GET['ajax'])) {
         $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
     }
 }
    /**
     * This is the default 'index' action that is invoked
     * when an action is not explicitly requested by users.
     */
    public function actionIndex()
    {
        $view = 'index';
        if (Yii::app()->user->isGuest) {
            $this->redirect(array('login'));
        } else {
            if (Yii::app()->session['group_id'] == 2) {
                $this->layout = '//layouts/main';
                $view = 'trainee/index';
                $this->render($view);
            } elseif (Yii::app()->session['group_id'] == 1) {
                $this->layout = '//layouts/main';
                $view = 'trainer/index';
                $this->render($view);
            } elseif (Yii::app()->session['group_id'] == 4) {
                $this->layout = '//layouts/main';
                $view = 'teamleader/index';
                $this->render($view);
            } elseif (Yii::app()->session['group_id'] == 3) {
                $view = 'supervisor/index';
                // $view = 'index';
                $this->layout = '//layouts/main';
                $data = array();
                // biểu đồ liên quan
                $infoCourse = array();
                $criteria = new CDbCriteria();
                $criteria->condition = 'status = 1';
                $criteria->order = 'id desc';
                $criteria->limit = 6;
                $count = WUser::model()->count($criteria);
                $pages = new CPagination($count);
                // results per page
                $pages->pageSize = Params::$rowsPerPage;
                $pages->applyLimit($criteria);
                $infosupper = WUser::model()->findAll($criteria);
                // course_lecture
                /*   $courseLecture = array();
                     $db = Yii::app()->db;
                    	$comm = $db->createCommand()
                        ->select('COUNT(*)')
                        ->from('pls_course_lecture t')
                        ->leftJoin('pls_course t1','t1.id = t.course_id')
                        ->leftJoin('pls_lecture t2','t2.id = t.lecture_id')
                        ->leftJoin('pls_test t3','t3.id = t.pre_test_id')
                         ->leftJoin('pls_test t4','t4.id = t.test_id')
                        ->leftJoin('pls_user t5','t5.id = t.trainer_id')
                        ->order('t.id DESC');
                     $total = $comm->queryScalar();
                     $comm->reset();
                     $comm = $db->createCommand()
                        ->select('
                            t.*,
                            t1.course_name,
                            t2.lecture_name,
                            t3.test_name,
                            t4.test_name,
                            t5.fullname
                        ')
                        ->from('pls_course_lecture t')
                        ->leftJoin('pls_course t1','t1.id = t.course_id')
                        ->leftJoin('pls_lecture t2','t2.id = t.lecture_id')
                        ->leftJoin('pls_test t3','t3.id = t.pre_test_id')
                          ->leftJoin('pls_test t4','t4.id = t.test_id')
                        ->leftJoin('pls_user t5','t5.id = t.trainer_id')
                        ->order('t.id ASC');
                    	 $limit = 6;
                     $page = (isset($_GET['page']) AND !empty($_GET['page'])) ? $_GET['page'] : 1;
                     $offset = $limit * ($page-1);
                     $comm->limit = $limit;
                     $comm->offset = $offset;
                     $courseLecture = $comm->queryAll();
                     $pages = new CPagination($total);
                     $pages->pageSize = $limit;
                     */
                $courseLecture = array();
                $courseLecture = WCourseLecture::model()->findAll();
                $Lectures = array();
                $Lectures = WLecture::model()->findAll();
                // course trainne
                /*   $courseTrainee = array();
                     $db = Yii::app()->db;
                    	$comm = $db->createCommand()
                        ->select('COUNT(*)')
                        ->from('pls_course_trainee t')
                        ->leftJoin('pls_course t1','t1.id = t.course_id')
                        ->leftJoin('pls_user t2','t2.id = t.trainee_id')
                        ->order('t.id DESC');
                     $total = $comm->queryScalar();
                     $comm->reset();
                     $comm = $db->createCommand()
                        ->select('
                            t.*,
                            t1.course_name,
                            t2.fullname
                        ')
                        ->from('pls_course_trainee t')
                        ->leftJoin('pls_course t1','t1.id = t.course_id')
                        ->leftJoin('pls_user t2','t2.id = t.trainee_id')
                        ->order('t.id ASC');
                    	 $limit = 10;
                     $page = (isset($_GET['page']) AND !empty($_GET['page'])) ? $_GET['page'] : 1;
                     $offset = $limit * ($page-1);
                     $comm->limit = $limit;
                     $comm->offset = $offset;
                     $courseTrainee = $comm->queryAll();
                     $pages = new CPagination($total);
                     $pages->pageSize = $limit;*/
                // course_trainee
                $db = Yii::app()->db;
                $comm = $db->createCommand()->select('count(*)')->from('pls_user t')->where('t.user_group_id=2');
                $total = $comm->queryScalar();
                $comm->reset();
                $comm = $db->createCommand()->select('*')->from('pls_user t')->where('t.user_group_id=2');
                $limit = 5;
                $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1;
                $offset = $limit * ($page - 1);
                $comm->limit = $limit;
                $comm->offset = $offset;
                $data = $comm->queryAll();
                $result = array();
                if (!empty($data)) {
                    foreach ($data as $item) {
                        $result[$item['id']] = $item;
                        $comm->reset();
                        $comm = $db->createCommand()->select('t2.course_name')->from('pls_course_trainee t')->leftJoin('pls_course t2', 't.course_id= t2.id')->where('t.trainee_id=' . $item['id'] . ' AND t.status = 1');
                        $Trainee = $comm->queryAll();
                        $result[$item['id']]['course_list'] = $Trainee;
                    }
                }
                $pages = new CPagination($total);
                $pages->pageSize = $limit;
                $TraineeUser = array();
                $TraineeUser = WUser::model()->findAll('status=1 and user_group_id=2');
                //	 var_dump(count($TraineeUser));
                $TrainerUser = array();
                $TrainerUser = WUser::model()->findAll('status =1 and user_group_id=1');
                // var_dump(count($TrainerUser));
                $sum = array();
                $sum = array_merge($TraineeUser, $TrainerUser);
                //	 var_dump(count($sum));die;
                // var_dump(count($sumUser));die;
                // course_trainer
                $db = Yii::app()->db;
                $comm = $db->createCommand()->select('count(*)')->from('pls_user t')->where('t.user_group_id=1');
                $total = $comm->queryScalar();
                $comm->reset();
                $comm = $db->createCommand()->select('*')->from('pls_user t')->where('t.user_group_id=1');
                $limit = 6;
                $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1;
                $offset = $limit * ($page - 1);
                $comm->limit = $limit;
                $comm->offset = $offset;
                $data = $comm->queryAll();
                $resultTrainer = array();
                if (!empty($data)) {
                    foreach ($data as $item) {
                        $result[$item['id']] = $item;
                        $comm->reset();
                        $comm = $db->createCommand()->select('t2.course_name')->from('pls_course_trainee t')->leftJoin('pls_course t2', 't.course_id= t2.id')->where('t.trainee_id=' . $item['id'] . ' AND t.status = 1');
                        $courseTrainee = $comm->queryAll();
                        $resultTrainer[$item['id']]['course_list'] = $courseTrainee;
                    }
                }
                $pages = new CPagination($total);
                $pages->pageSize = $limit;
                // var_dump(count($resultTrainer));die;
                // course_result_test
                $courseTest = array();
                $db = Yii::app()->db;
                $comm = $db->createCommand()->select('COUNT(*)')->from('pls_user_test t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_user t2', 't2.id = t.user_id')->leftJoin('pls_test t3', 't3.id = t.test_id')->order('t.course_id DESC');
                $total = $comm->queryScalar();
                $comm->reset();
                $comm = $db->createCommand()->select('
	                t.*,
	                t1.course_name,
	                t2.fullname,
	                t3.total_point
	            ')->from('pls_user_test t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_user t2', 't2.id = t.user_id')->leftJoin('pls_test t3', 't3.id = t.test_id')->order('t.course_id ASC');
                $limit = 6;
                $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1;
                $offset = $limit * ($page - 1);
                $comm->limit = $limit;
                $comm->offset = $offset;
                $courseTest = $comm->queryAll();
                $pages = new CPagination($total);
                $pages->pageSize = $limit;
                // lecture_schedule
                $lectureSchedule = array();
                $db = Yii::app()->db;
                $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course_lecture t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_lecture t2', 't2.id = t.lecture_id')->leftJoin('pls_user t5', 't5.id = t.trainer_id')->order('t.trainer_id DESC');
                $total = $comm->queryScalar();
                $comm->reset();
                $comm = $db->createCommand()->select('
	                t.*,
	                t1.course_name,
	                t2.lecture_name,
	                t5.fullname
	            ')->from('pls_course_lecture t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_lecture t2', 't2.id = t.lecture_id')->leftJoin('pls_user t5', 't5.id = t.trainer_id')->order('t.trainer_id DESC');
                $limit = 6;
                $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1;
                $offset = $limit * ($page - 1);
                $comm->limit = $limit;
                $comm->offset = $offset;
                $lectureSchedule = $comm->queryAll();
                $pages = new CPagination($total);
                $pages->pageSize = $limit;
                //  running course
                $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 = 2 and t.end_date > NOW()')->order('t.start_date ASC');
                $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 = 2 and t.end_date > NOW()')->order('t.start_date ASC');
                $limit = 6;
                $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1;
                $offset = $limit * ($page - 1);
                $comm->limit = $limit;
                $comm->offset = $offset;
                $runningCourse = $comm->queryAll();
                $pages = new CPagination($total);
                $pages->pageSize = $limit;
                $totalCourse = array();
                $coursependding = array();
                $courseactive = array();
                $coursestart = array();
                $coursecomplete = array();
                $totalCourse = WCourse::model()->findAll();
                $coursependding = WCourse::model()->findAll('status=0');
                $courseactive = WCourse::model()->findAll('status=1');
                $coursestart = WCourse::model()->findAll('status=2');
                $coursecomplete = WCourse::model()->findAll('status=5');
                $imgoverview = '<img width="680px" height="360px" src="' . Yii::app()->theme->baseUrl . '/img/overview.png" />';
                //  training proccessing
                $dashCourse = array();
                $db = Yii::app()->db;
                $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course t')->leftJoin('pls_user t2', 't2.id = t.trainer_id')->order('t.status ASC');
                $total = $comm->queryScalar();
                $comm->reset();
                $comm = $db->createCommand()->select('
                    t.*,
                    t2.fullname
                ')->from('pls_course t')->leftJoin('pls_user t2', 't2.id = t.trainer_id')->order('t.status ASC');
                $dashCourse = $comm->queryAll();
                $total_pages = ceil(count($dashCourse) / Params::$coursePerPage);
                $test = $db->createCommand('
                SELECT course_id, user_id, AVG(point_percent), YEAR(end_date) ,Y.course_name FROM(
                    SELECT A.course_id, A.lecture_id, A.test_id, A.pass_score_point, A.user_id,  C.total_point,
                        ROUND(IFNULL(A.pass_score_point, 0)*100 / C.total_point, 0) point_percent
                      FROM pls_user_test A
                     INNER JOIN pls_test C ON A.test_id = C.id
                        WHERE A. status  = 1 AND A.success = 2
                     GROUP BY  A.course_id, A.test_id, A.user_id, A.lecture_id
                ) X
                INNER JOIN pls_course Y ON X.course_id = Y.id 
                WHERE Y.end_date < NOW()
                GROUP BY course_id, end_date ,course_name , YEAR(end_date)
                ORDER BY YEAR(end_date) ASC
            ');
                $test = $test->queryAll();
                // MyHelper::dump($test);die;
                $this->render($view, array('total_pages' => $total_pages, 'test' => $test, 'totalCourse' => $totalCourse, 'coursependding' => $coursependding, 'courseactive' => $courseactive, 'coursestart' => $coursestart, 'coursecomplete' => $coursecomplete, 'Lectures' => $Lectures, 'TraineeUser' => $TraineeUser, 'TrainerUser' => $TrainerUser, 'sum' => $sum, 'imgoverview' => $imgoverview, 'runningCourse' => $runningCourse, 'courseTrainer' => $resultTrainer, 'courseTrainee' => $result, 'courseLecture' => $courseLecture, 'courseTest' => $courseTest, 'lectureSchedule' => $lectureSchedule));
                //  $this->render($view,array('courseTrainee'=>$courseTrainee, 'courseLecture'=>$courseLecture, 'courseTest'=>$courseTest,'lectureSchedule'=>$lectureSchedule));
            }
        }
    }
 public function actionUpdateTest()
 {
     $idcourselecture = $_REQUEST['idcourselecture'];
     $kind_of_test = $_REQUEST['kind_of_test'];
     $model = WCourseLecture::model()->find("id=" . $idcourselecture);
     if ($kind_of_test == 0) {
         $model->test_id = NULL;
     } elseif ($kind_of_test == 1) {
         $model->pre_test_id = NULL;
     }
     if ($model->save()) {
         echo json_encode(array('result' => 'true'));
     } else {
         echo json_encode(array('result' => 'false'));
     }
 }