/** * Manages all models. */ public function actionAdmin() { $this->pagename = "Manage " . $this->pagename; $model = new Providers('search'); $model->unsetAttributes(); // clear any default values $dataProvider = new CActiveDataProvider('Providers', array('criteria' => array('condition' => "id in (select providers_id from workers where users_id=" . Yii::app()->user->id . ")", 'order' => 'id'), 'pagination' => array('pageSize' => 10))); if (isset($_GET['Providers'])) { $model->attributes = $_GET['Providers']; } $this->render('admin', array('model' => $model, 'dataProvider' => $dataProvider)); }