Laravel 8 + FullCalendar 5 - Getting the events issue

@vybeauregard THe JSON response is this:

[{"title":"John Doe - Hospital","start":"2022-08-18","allDay":true,"editable":false},{"title":"Mary Joe - Factory","start":"2022-08-19","allDay":true,"editable":false}]

The question actually is how to put it into the calendar JS

@blackshtef What you have appears to be configured correctly. I'm wondering if calendar.blade.php is missing a calendar element, or perhaps multiple elements with an id of calendar?

@vybeauregard The calendar is displaying fine, I invoke it with within the calendar.blade.php. The script with the calendar settings is placed before the tag, and that part is within the app.blade.php layout file (which is included within the calendar.blade.php).

@blackshtef Can you verify that the getEvents request is being called? It should appear in the network tab in your browser's devtools.

@vybeauregard I cannot :) When I look at the source code of the calendar, I see exactley this:

  themeSystem: 'bootstrap5',
				editable: false,
                **events: 'getEvents',**
                displayEventTime: false,

That's where the problem lies actually (I believe) - is "getEvents" the right thing to have here? Shouldn't it be something more "Laravel-y" :) I tried to have "events: {{route(getEvents)}} and when I look at the source code of that, I see that it has rendered to: events: https://test.local/getEvents So I'm thinking there must be something that I can do to actually execute that route and retrieve the array of events that is generated in the controller

@vybeauregard Thats what I would suggest also. Check what request is being made by the calendar and what was the return payload. View the actual network request.

@Snapey https://imgur.com/a/LZOaTKX - This is what I get - but this is the result of the controller function (when I open up test.local/getEvents) - I don't believe this is from the calendar JS function; because, if that were the case, I would see the actual events (this response) in the "events" part of the calendar JS, no?

@Snapey It motivated me to start from skratch, but somewhere mid-way I rearranged functions in the controller (check my answer I just posted) - that's where the actual problem was actually

@blackshtef Do you know collections?

class EventsController extends Controller
{
    public function index()
    {
        return Event::select('event_date', 'event_content')->get()->map(fn ($event) => [
            'title' => $event->event_content,
            'start' => $event->event_date,
            'allDay' => true,
            'editable' => false
        ]);
    }
}

@MichalOravec No, but I will try it out - thanks!

@MichalOravec I used your example and it worked just fine! However, I would like to expand this a bit more - I'd like to add a different color to the events in the calendar based on a thing they applied to. So, I have two tables, events (that has, among other columns, activity_id with values 1, 2 or 3). Another table, activites, has activity_id and activity_color - red, white, green.

I would like, if a user applied to activity with ID 1 to be colored red, activity 2 white etc.

For that, I changed Event::select(...) to Event::all and addedd activity_id => $event->activity_id. But how would I pair that with activity_id and finally the color of the event, that would later be pushed to the calendar?

Let me answer to my own questions :) This is how I modified it:

return Event::select('activity_id')
->join('activities', 'events.activity_id', '=', 'activities.activity_id')
->select('activities.activity_color', 'event_content', 'event_date')
->get()->map(fn ($events) => [...

@Snapey Yes, that makes sense. I will definitely rename the functions, and I'll try to use what you proposed here - an api or ajax route for retriveing the data.