/**
  * 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]);
 }
 /**
  * Lists all Checkin models.
  * @return mixed
  */
 public function actionIndex()
 {
     $searchModel = new CheckinSearch();
     $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
     return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
 }