public function actionGroup3() { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1 AND know_group=3'; $criteria->order = 'sort_order'; $total = Knowledge::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = Knowledge::model()->findAll($criteria); $this->render('index', array('model' => $model, 'pages' => $pages)); }
public function actionIndex() { if (isset($_GET['id'])) { $model = StudentService::model()->findByPk($_GET['id']); $this->render('detail', array('model' => $model)); } else { if ($_GET['type_id']) { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1 AND ser_type_id=' . $_GET['type_id']; $criteria->order = 'sort_order'; $total = StudentService::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = StudentService::model()->findAll($criteria); $type = StudentServiceType::model()->findByPk($_GET['type_id']); $this->render('index', array('model' => $model, 'type' => $type, 'pages' => $pages)); } else { if ($_GET['group']) { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1 AND ser_group=' . $_GET['group']; $criteria->order = 'sort_order'; $total = StudentService::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = StudentService::model()->findAll($criteria); $group = StudentServiceGroup::model()->findByPk($_GET['group']); $this->render('index', array('model' => $model, 'group' => $group, 'pages' => $pages)); } else { $criteria = new CDbCriteria(); $criteria->select = '*'; $criteria->condition = 'status = 1'; $criteria->order = 'sort_order'; $total = Knowledge::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(20); $pages->applyLimit($criteria); $model = StudentService::model()->findAll($criteria); $this->render('index', array('model' => $model, 'pages' => $pages)); } } } }
public function actionSearch() { $keyword = trim($_GET['q']); if (isset($keyword)) { $condition = new CDbCriteria(); $condition->condition = "name_th LIKE '%{$keyword}%' OR name_en LIKE '%{$keyword}%' OR desc_th LIKE '%{$keyword}%' OR desc_en LIKE '%{$keyword}%'"; $condition->order = "create_date desc"; $condition->offset = 0; $condition->limit = 20; $model_news = News::model()->findAll($condition); $condition = new CDbCriteria(); $condition->condition = "name_th LIKE '%{$keyword}%' OR name_en LIKE '%{$keyword}%'"; $condition->order = "last_update desc"; $condition->offset = 0; $condition->limit = 20; $model_document = Document::model()->findAll($condition); $condition = new CDbCriteria(); $condition->condition = "name_th LIKE '%{$keyword}%' OR name_en LIKE '%{$keyword}%'"; $condition->order = "know_id desc"; $condition->offset = 0; $condition->limit = 20; $model_knowledge = Knowledge::model()->findAll($condition); $condition = new CDbCriteria(); $condition->condition = "name_th LIKE '%{$keyword}%' OR name_en LIKE '%{$keyword}%' OR desc_th LIKE '%{$keyword}%' OR desc_en LIKE '%{$keyword}%'"; $condition->order = "last_update desc"; $condition->offset = 0; $condition->limit = 20; $model_student = StudentService::model()->findAll($condition); //print_r($model); $this->render('search', array('model_news' => $model_news, 'model_document' => $model_document, 'model_knowledge' => $model_knowledge, 'model_student' => $model_student)); } }
/** * 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 Knowledge the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Knowledge::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }