Fix Staffing Publish Bug & Add Setup/Takedown Time Logging

What & Why

Two related issues in the event staffing system:

1. Bug — Cannot publish events with staff assignments: When publishing or updating event groups/dates, the system tries to delete rows. But , , , and all have foreign keys to without or . This causes a FK constraint violation (500 error) whenever an event has staffing data and the admin tries to modify dates/groups or advance the lifecycle. The screenshot shows: .

2. Feature — Coach setup/takedown time logging: Coaches (or coordinators) need to log their arrival time for setup and their departure time after takedown on event day. This should be distinct from the general hours tracking — it captures the actual clock-in and clock-out times on the day of the event. The table already has and columns, but the coach event session UI does not expose them. Coaches should be able to set these times from the coach event session page on the day of the event.

Done looks like

1. Events with existing staff assignments can be published and have their groups/dates updated without errors. 2. On the coach event session page, coaches see fields to log their clock-in time (arrival for setup) and clock-out time (departure after takedown) for each event date they're assigned to. 3. Logged setup/takedown times are saved to the table and visible in the admin payroll/staffing views.

Out of scope

Drag-and-drop or timer/stopwatch-style UI — simple time pickers are sufficient.
Changes to how hours are calculated for payroll (existing logic remains).
Geolocation or GPS verification for clock-in/out.

Relevant files

- - - - - - -

Canadian Elite Volleyball Academy
elitevolleyball.training

Elite Academy

Thursday, April 9, 2026