public function getTodayUnreadActivityByUserId($id)
{
$sql = 'SELECT Activity.id AS id, Activity_name AS title, startDatetime AS datetime, Venue.name AS venue
FROM 13027272d.Activity, 13027272d.Participant_has_Activity, 13027272d.Venue WHERE
13027272d.Activity.id = 13027272d.Participant_has_Activity.Activity_id
AND 13027272d.Venue.id = 13027272d.Activity.Venue_id
AND 13027272d.Participant_has_Activity.Participant_id = ' . $id . '
AND Participant_has_Activity.Participant_id <> Activity.Administrator_id
AND is_read = 0
ORDER BY startDatetime DESC;';
$raw = ParticipantHasActivity::findBySql($sql)->asArray()->all();
//return $raw;
$arr = [];
foreach ($raw as $row) {
$today = strtotime(date("Y-m-d"));
$eventTimestamp = strtotime($row['datetime']);
if ($eventTimestamp > $today && $eventTimestamp < $today + 86400) {
array_push($arr, $row);
}
}
return $arr;
}
