/** * Displays a single Event model. * @param integer $id * @return mixed */ public function actionView($id) { $query = new Query(); $query->select(['*'])->distinct()->from('checkin')->where('event_id=' . $id)->join('JOIN', 'message', 'message.sender_id =checkin.user_id')->join('JOIN', 'user', 'user.id = checkin.user_id')->all(); $command = $query->createCommand(); $data = $command->queryAll(); $searchModel2 = new CheckinSearch(); $dataProvider2 = $searchModel2->searchUsers(\Yii::$app->user->identity->id); //die(); return $this->render('view', ['model' => $this->findModel($id), 'messages' => $data, 'dataProvider2' => $dataProvider2]); }