/** * 首页 * */ public function actionIndex() { parent::_acl(); $model = new Teacher(); $criteria = new CDbCriteria(); $criteria->condition = $condition; $criteria->order = 't.id ASC'; //$criteria->with = array ( 'catalog' ); $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 13; //$pageParams = XUtils::buildCondition( $_GET, array ( 'title' , 'catalogId','titleAlias' ) ); //$pages->params = is_array( $pageParams ) ? $pageParams : array (); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->render('teacher_index', array('datalist' => $result, 'pagebar' => $pages)); }
public function actionAutoComplete() { $term = Yii::app()->getRequest()->getParam('term'); $term = mb_strtolower($term); if (Yii::app()->request->isAjaxRequest && $term) { $model = new Teacher(); $names = $model->findAll(array('condition' => " LOWER(name) LIKE '%{$term}%'")); $result = array(); foreach ($names as $name) { $result[] = array('name' => $name['name'], 'id' => $name['id']); } echo CJSON::encode($result); Yii::app()->end(); } }