public function actionSearch() { $model = new Appointment('search'); if (!$model->app_type) { $model->app_type = [Appointment::TYPE_VIEWING, Appointment::TYPE_VALUATION]; } if (!$model->app_notetype) { $model->app_notetype = Appointment::getNoteTypes(); } if (!$model->app_start) { $model->app_start = date('d-m-Y', strtotime('-1 year')); } if (isset($_GET['Appointment']) && $_GET['Appointment']) { $model->attributes = $_GET['Appointment']; } $dataProvider = $model->search(); $dataProvider->getCriteria()->select = ['t.app_status', 't.app_start', 't.app_type', 't.app_notetype', 't.app_subject', 't.app_user']; $dataProvider->getCriteria()->with['clients']['select'] = ['clients.cli_fname', 'clients.cli_sname']; $dataProvider->getCriteria()->with['_instructions']['select'] = ['_instructions.dea_id']; $dataProvider->getCriteria()->with['user']['select'] = ['user.use_fname', 'user.use_sname']; $this->render('search', compact('model', 'dataProvider')); }