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; }