/**
* Manages all models.
*/
public function actionAdmin()
{
$model = new MrCourse('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['MrCourse'])) {
$model->attributes = $_GET['MrCourse'];
}
if (isset($_REQUEST['ajaxPagin'])) {
$subSql = "";
if (isset($_POST['MrCourse']['course_name']) && $_POST['MrCourse']['course_name'] != '') {
$subSql .= " AND course_name regexp('" . $_POST['MrCourse']['course_name'] . "')";
}
if (isset($_POST['MrCourse']['course_abbr']) && $_POST['MrCourse']['course_abbr'] != '') {
$subSql .= " AND course_abbr regexp('" . $_POST['MrCourse']['course_abbr'] . "')";
}
if (isset($_POST['MrCourse']['level']) && $_POST['MrCourse']['level'] != '') {
$subSql .= " AND level regexp('" . $_POST['MrCourse']['level'] . "')";
}
if (isset($_POST['MrCourse']['id']) && $_POST['MrCourse']['id'] != '') {
$subSql .= " AND id regexp('" . $_POST['MrCourse']['id'] . "')";
}
if (isset($_POST['q']) && $_POST['q'] != '') {
$subSql = " AND course_name regexp('" . $_POST['q'] . "') OR course_abbr regexp('" . $_POST['q'] . "') OR level regexp('" . $_POST['q'] . "') OR course_fees regexp('" . $_POST['q'] . "')";
}
$sql = "SELECT * FROM `mr_course` WHERE 1=1 " . $subSql . " order by id DESC";
$data = $this->customPagination($sql, isset($_REQUEST['page']) ? $_REQUEST['page'] : 1, array(isset($_REQUEST['sort']) ? $_REQUEST['sort'] : '', isset($_REQUEST['order']) ? $_REQUEST['order'] : ''));
$this->renderPartial('grid', array('data' => $data));
Yii::app()->end();
}
$this->render('admin', array('model' => $model));
}
