/**
* 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]);
}
