public function actionLoadMoreTest()
{
$db = Yii::app()->db;
// $comm = $db->createCommand()
// ->select('*')
// ->from('pls_user_test')
// ->group('course_id')
// // ->having('COUNT(DISTINCT course_id)')
// // ->leftJoin('pls_course t2','t.course_id= t2.id')
// ->where('status > 0');
// $data_user_test = $comm->queryAll();
// var_dump($data_user_test);
// $comm = $db->createCommand();
// ->select('*')
// ->from('pls_user_test')
// // ->group('course_id')
// // ->having('COUNT(DISTINCT course_id)')
// // ->leftJoin('pls_course t2','t.course_id= t2.id')
// ->where('status > 0');
// $tesst = $comm->queryAll();
// var_dump($data_user_test);
// $data_user_test = json_decode(json_encode($data_user_test));
$data = array();
if (isset($_POST["page"])) {
$page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
} else {
$page_number = 0;
}
//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
$testuser = new WUserTest();
$results = $testuser->getUserTestCourse($position, Params::$coursePerPage);
$data = $this->renderPartial('_loadmore', array('testuser' => $results), true);
echo $data;
}