public function actionList() { $model=new Business('search'); $model->unsetAttributes(); if(isset($_GET['Business'])) $model->attributes=$_GET['Business']; Yii::app()->session['myurl'] = $this->createUrl('list'); $this->render('list',array( 'model'=>$model, )); }
/** * Manages all models. */ public function actionAdmin() { $model = new Business('search'); $model->unsetAttributes(); // clear any default values if (isset($_GET['Business'])) { $model->attributes = $_GET['Business']; } $this->render('admin', array('model' => $model)); }
public function actionManage() { $model = new Business('search'); $model->unsetAttributes(); if (isset($_GET['Business'])) { $model->setAttributes($_GET['Business']); } $this->render('manage', array('model' => $model)); }
public function actionLocation() { $cat = Yii::app()->getRequest()->getQuery('cat'); $bname = Yii::app()->getRequest()->getQuery('keyword'); $catname = Category::model()->getCategoryName($cat); if ($cat == 'all' || empty($catname)) { $query = "SELECT * \n\t\t\t\t\t\tFROM `mm_business` \n\t\t\t\t\t\tWHERE `business_name` LIKE '%" . $bname . "%' \n\t\t\t\t\t\tORDER BY `business_name` LIMIT 10"; } else { $query = "SELECT * \n\t\t\t\t\tFROM `mm_business` \n\t\t\t\t\tWHERE `business_name` LIKE '%" . $bname . "%'\n\t\t\t\t\tAND\t`business_category` LIKE '" . $catname . "'"; } $command = Yii::app()->db->createCommand($query); $result = $command->queryAll(); $model = new Business('search'); $model->unsetAttributes(); // clear any $model->business_name = $bname; $model->business_category = $catname; //send model object for search $this->render('index', array('dataProvider' => $model->search(), 'model' => $model)); /* $dataProvider=new CArrayDataProvider($result, array( 'sort'=>false, 'keyField'=>'id', //this is what will be considered your key field 'pagination'=>array( 'pageSize'=>30, //eureka! you can configure your pagination from here ), )); //echo '<pre>'; var_dump($pp); die(); $this->render('index',array( 'dataProvider'=>$dataProvider, ));*/ //throw new CHttpException(404,'The requested page does not exist.'); }