public function getNextActivity()
{
$sql = 'SELECT * FROM 13027272d.Participant_has_Activity, 13027272d.Activity
WHERE Participant_id = ' . Yii::$app->user->id . '
AND 13027272d.Participant_has_Activity.Activity_id = 13027272d.Activity.id
ORDER BY startDatetime ASC';
$raw = Activity::findBySql($sql)->asArray()->all();
foreach ($raw as $row) {
$eventTimestamp = strtotime($row['startDatetime']);
if ($eventTimestamp - time() + 1800 > 0) {
return $row;
}
}
return false;
}
