/** * 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)); }