HD Sports Zone Bookmark 25Q-1 — Manager Schedule Builder Data Readiness Inventory / Next Safe Build Module Start

Read-only inventory before any functional builder change. This page detects candidate schedule tables, columns, routes, controllers, views, route separation, and guardrails so the next phase can map the actual draft/published data sources safely. It does not write to the database or change scheduling behavior.

Production / Build Data Source Map 25P Completion Builder Help Strip Soft Conflicts Employee Portal Developer Tools

Data Readiness Inventory Summary

Inventory only. No scheduling behavior changed. This phase gives us a safer map of what tables, columns, routes, and files already exist before changing the actual builder.

Generated Jun 5, 2026 12:16 AM

Inventory 25Q Start Mode

Read-only inspection before any functional builder changes.

9/8 Tables Present / Missing

Candidate draft, published, shift, period, conflict, and audit tables.

14/0 Routes Found / Missing

Builder, employee, conflict, checklist, and support routes.

11/0 Files Present / Missing

Candidate controllers, views, and helper partials.

32 Column Signals Found

Detected useful columns such as employee, start/end time, status, publish, and period fields.

0/0 Guard / Separation Issues

Safety checks that should remain clean before functional work.

Preserved Boundaries

Existing production route preserved Draft/publish logic preserved Soft conflicts remain review-only Employee Portal preserved My Schedule preserved Weekly preserved Print Weekly preserved No database writes No migrations No middleware No auth changes No payroll changes No Time Clock changes No POS changes No reservation changes No payment changes No waiver changes No customer profile changes No notifications No hard blocking No schedule locking changes

Candidate Schedule / Employee Tables

Table Status Rows Columns Purpose Note
hd_schedule_periods Present 2 12
id, title, starts_on, ends_on, status, source, notes, created_by, updated_by, created_at, updated_at, deleted_at 		Likely schedule week/period source candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_draft_shifts Present 5 18
id, schedule_period_id, employee_id, work_date, starts_at, ends_at, role, location, area, status, has_soft_conflict, soft_conflict_summary, manager_notes, created_by, updated_by, created_at, updated_at, deleted_at 		Likely manager draft shift rows candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_published_schedule_periods Present 1 20
id, source_schedule_period_id, title, starts_on, ends_on, published_status, source_snapshot_status, prepared_by, prepared_at, published_by, published_at, published_shift_count, source_draft_shift_count, source_warning_count, source_hard_stop_count, source_summary_payload, internal_notes, created_at, updated_at, deleted_at 		Likely published schedule week/period source candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_published_shifts Present 1 19
id, published_schedule_period_id, source_schedule_period_id, source_draft_shift_id, employee_id, work_date, starts_at, ends_at, role, location, area, published_shift_status, source_had_soft_conflict, source_soft_conflict_summary, manager_notes, source_shift_payload, created_at, updated_at, deleted_at 		Likely employee-facing published shift rows candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_employee_schedules Not Detected 0 0
Not detected 		Possible generic employee schedule header table. Not detected. 25Q-1 does not create it.
hd_employee_schedule_shifts Present 2 18
id, company_id, employee_id, role_id, schedule_date, starts_at, ends_at, scheduled_hours, shift_title, work_area, station_note, status, notes, created_by, updated_by, settings, created_at, updated_at 		Possible generic employee schedule shift table. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_employee_schedule_periods Not Detected 0 0
Not detected 		Possible generic employee schedule period table. Not detected. 25Q-1 does not create it.
hd_schedule_shifts Not Detected 0 0
Not detected 		Possible schedule shift table. Not detected. 25Q-1 does not create it.
hd_shift_templates Not Detected 0 0
Not detected 		Possible reusable shift template table. Not detected. 25Q-1 does not create it.
hd_schedule_templates Not Detected 0 0
Not detected 		Possible schedule template table. Not detected. 25Q-1 does not create it.
hd_schedule_audit_logs Present 10 12
id, schedule_period_id, draft_shift_id, audit_area, audit_action, summary, before_payload, after_payload, performed_by, performed_at, created_at, updated_at 		Schedule audit trail candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_employee_unavailable_blocks Present 0 18
id, company_id, employee_id, block_type, title, starts_on, ends_on, all_day, starts_at, ends_at, status, employee_note, manager_note, created_by, reviewed_by, reviewed_at, created_at, updated_at 		Unavailable block source candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
hd_unavailable_blocks Not Detected 0 0
Not detected 		Unavailable block source candidate. Not detected. 25Q-1 does not create it.
hd_unavailable_block_events Not Detected 0 0
Not detected 		Unavailable block audit/event source candidate. Not detected. 25Q-1 does not create it.
hd_employees Present 4 26
id, company_id, role_id, first_name, last_name, display_name, employee_number, email, phone, status, pin_hash, card_token_hash, barcode_token_hash, pin_required, require_pin_change, last_login_at, settings, created_at, updated_at, alert_phone, receive_print_failure_alerts, sms_alert_opt_in, current_clock_status, last_clocked_in_at, last_clocked_out_at, current_work_area 		Employee record source candidate. Detected. 25Q-1 only reads schema/counts and does not change data.
employees Not Detected 0 0
Not detected 		Generic employee record source candidate. Not detected. 25Q-1 does not create it.
users Present 0 8
id, name, email, email_verified_at, password, remember_token, created_at, updated_at 		User/staff account source candidate. Detected. 25Q-1 only reads schema/counts and does not change data.

Detected Column Signals

Table Signal Status Matching Columns Note
hd_schedule_periods status Found status Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_schedule_periods notes Found notes Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_schedule_periods audit fields Found created_by, updated_by Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts employee identity Found employee_id Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts schedule period Found schedule_period_id Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts shift date Found work_date Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts start time Found starts_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts end time Found ends_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts status Found status Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts role / position Found role Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_draft_shifts audit fields Found created_by, updated_by Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_schedule_periods published indicator Found published_status, published_by, published_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_schedule_periods audit fields Found published_by Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_shifts employee identity Found employee_id Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_shifts shift date Found work_date Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_shifts start time Found starts_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_shifts end time Found ends_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_published_shifts role / position Found role Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_schedule_shifts employee identity Found employee_id Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_schedule_shifts start time Found starts_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_schedule_shifts end time Found ends_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_schedule_shifts status Found status Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_schedule_shifts notes Found notes Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_schedule_shifts audit fields Found created_by, updated_by Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_schedule_audit_logs schedule period Found schedule_period_id Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_unavailable_blocks employee identity Found employee_id Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_unavailable_blocks start time Found starts_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_unavailable_blocks end time Found ends_at Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_unavailable_blocks status Found status Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_unavailable_blocks notes Found manager_note Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employee_unavailable_blocks audit fields Found created_by, reviewed_by Useful for future builder logic mapping. 25Q-1 does not use it to write data.
hd_employees status Found status Useful for future builder logic mapping. 25Q-1 does not use it to write data.

Route Inventory

Route Status URI Expected / Blocked Action Purpose Open
Production / Build Schedule Passed hd/employee-schedules/production Blocked: EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleProductionRouteRescueController@index Existing manager build/publish workflow must stay separate. Open
25Q-1 Data Readiness Inventory Passed hd/employee-schedules/builder/data-readiness-inventory Expected: EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderDataReadinessInventoryController@index This read-only inventory page. Open
25Q-1 Data Readiness Inventory Alias Passed hd/employee-schedules/access-resolver/builder-data-readiness-inventory Expected: EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderDataReadinessInventoryController@index Alias for this read-only inventory page. Open
25P-6 Visual Cleanup Completion Passed hd/employee-schedules/builder/visual-cleanup-completion Expected: EmployeeScheduleBuilderVisualCleanupCompletionController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderVisualCleanupCompletionController@index Prior visual cleanup completion page. Open
25P-5 Builder Help Strip Passed hd/employee-schedules/builder/help-strip Expected: EmployeeScheduleBuilderHelpStripController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderHelpStripController@index Prior helper strip page. Open
Builder Checklist Passed hd/employee-schedules/builder/checklist Expected: EmployeeScheduleBuilderChecklistController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderChecklistController@index Manager publish readiness checklist. Open
Builder Workflow Guide Passed hd/employee-schedules/builder/workflow-guide Expected: EmployeeScheduleBuilderWorkflowGuideController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleBuilderWorkflowGuideController@index Manager workflow guide. Open
Soft Conflict Report Passed hd/employee-schedules/unavailable-blocks/soft-conflicts Blocked: EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\HD\Scheduling\HdEmployeeScheduleController@unavailableBlockSoftConflicts Existing soft conflict report remains separate. Open
Employee Portal Passed hd/employee-schedules/employee-portal Expected: EmployeeScheduleSimplifiedPortalController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleSimplifiedPortalController@index Employee-facing schedule entry point. Open
My Schedule Passed hd/employee-schedules/employee-portal/my-schedule Expected: EmployeeScheduleMyScheduleSelfViewController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleMyScheduleSelfViewController@index Employee personal schedule view. Open
Weekly Schedule Passed hd/employee-schedules/employee-portal/weekly Expected: EmployeeScheduleWeeklySelfViewController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleWeeklySelfViewController@index Employee weekly schedule view. Open
Print Weekly Passed hd/employee-schedules/employee-portal/weekly/print Expected: EmployeeScheduleWeeklyPrintSelfViewController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleWeeklyPrintSelfViewController@index Employee printable weekly view. Open
Manager Simple Menu Passed hd/employee-schedules/navigation-cleanup/manager-simplified Expected: EmployeeScheduleManagerSimplifiedNavigationController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleManagerSimplifiedNavigationController@index Manager entry point. Open
Developer Tools Drawer Passed hd/employee-schedules/navigation-cleanup/developer-tools Expected: EmployeeScheduleDeveloperToolsDrawerController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleDeveloperToolsDrawerController@index Developer/support tools. Open

File Inventory

File Status Size Modified Purpose
app/Http/Controllers/Hd/EmployeeSchedules/EmployeeScheduleBuilderDataReadinessInventoryController.php Present 26,621 2026-06-01 17:29:57 25Q-1 read-only inventory controller.
resources/views/hd/employee_schedules/builder_data_readiness_inventory.blade.php Present 19,399 2026-06-01 17:44:24 25Q-1 read-only inventory view.
app/Http/Controllers/Hd/EmployeeSchedules/EmployeeScheduleBuilderVisualCleanupCompletionController.php Present 27,835 2026-06-01 17:21:51 25P-6 completion controller.
resources/views/hd/employee_schedules/builder_visual_cleanup_completion.blade.php Present 21,898 2026-06-01 17:29:57 25P-6 completion view.
resources/views/hd/employee_schedules/_builder_help_strip.blade.php Present 4,360 2026-06-01 17:13:20 25P-5 helper strip partial.
resources/views/hd/employee_schedules/_builder_employee_view_publish_callout.blade.php Present 4,158 2026-06-01 17:10:01 25P-4 employee-view reminder partial.
resources/views/hd/employee_schedules/_builder_soft_conflict_publish_callout.blade.php Present 4,488 2026-06-01 17:03:20 25P-3 soft-conflict callout partial.
resources/views/hd/employee_schedules/_builder_publish_readiness_panel.blade.php Present 4,168 2026-06-01 16:58:44 25P-2 draft/publish readiness partial.
resources/views/hd/employee_schedules/_builder_clarity_panel.blade.php Present 4,213 2026-06-01 16:52:13 25P-1 builder clarity partial.
routes/hd_employee_schedule_navigation.php Present 160,533 2026-06-01 18:14:51 Employee schedule clean/support route file.
routes/web.php Present 68,773 2026-06-03 09:11:23 Main web route file requiring support route file.

Data Readiness Questions for Next Phase

  1. Which table is the actual draft shift source?
  2. Which table is the actual published shift source employees read from?
  3. Which column connects a draft shift to an employee?
  4. Which columns define shift date, start time, and end time?
  5. Which table/column represents the schedule week or period?
  6. Which status values represent draft, ready, published, archived, or canceled?
  7. Which existing controller handles save draft and publish actions?
  8. Which existing view contains the manager build form/buttons?
  9. Which soft conflict report should managers review before publish?
  10. Which employee routes should remain read-only self-view routes?

Route Separation Checks

Check Status URI Blocked Controller Current Action
Production is not 25Q-1 Inventory Passed hd/employee-schedules/production EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleProductionRouteRescueController@index
Employee Portal is not 25Q-1 Inventory Passed hd/employee-schedules/employee-portal EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleSimplifiedPortalController@index
My Schedule is not 25Q-1 Inventory Passed hd/employee-schedules/employee-portal/my-schedule EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleMyScheduleSelfViewController@index
Weekly is not 25Q-1 Inventory Passed hd/employee-schedules/employee-portal/weekly EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleWeeklySelfViewController@index
Manager Menu is not 25Q-1 Inventory Passed hd/employee-schedules/navigation-cleanup/manager-simplified EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\Hd\EmployeeSchedules\EmployeeScheduleManagerSimplifiedNavigationController@index
Soft Conflict Report is not 25Q-1 Inventory Passed hd/employee-schedules/unavailable-blocks/soft-conflicts EmployeeScheduleBuilderDataReadinessInventoryController App\Http\Controllers\HD\Scheduling\HdEmployeeScheduleController@unavailableBlockSoftConflicts

Guardrail Checks

Guardrail Status Note
No enforcement middleware created
/home/at4txjiyemp4/public_html/hdsportszone.com/app/Http/Middleware/HdEmployeeScheduleSelfAccess.php 		Passed 25Q-1 does not add middleware.
Auth config exists but is not changed
/home/at4txjiyemp4/public_html/hdsportszone.com/config/auth.php 		Passed 25Q-1 does not edit config/auth.php.
Bootstrap middleware file exists but is not changed
/home/at4txjiyemp4/public_html/hdsportszone.com/bootstrap/app.php 		Passed 25Q-1 does not register middleware.
Production route not overridden by 25Q-1 inventory page
hd/employee-schedules/production 		Passed Production/build route remains separate.
No database writes performed by 25Q-1 inventory page
controller/view only 		Passed 25Q-1 only reads schema, row counts, files, and routes.
No automatic scheduling added
25Q-1 scope 		Passed This phase is only readiness inventory.

Safe Boundaries

  • 25Q-1 is read-only inventory only.
  • It does not replace or override the production/build route.
  • It does not change draft saves, publish behavior, schedule data, employee visibility, permissions, or locking.
  • It does not add employee texts or emails.
  • It does not add automatic scheduling.
  • It does not add hard conflict blocking.
  • It does not add migrations.
  • It does not change payroll, Time Clock, POS shifts, reservations, payments, waivers, or customer profiles.

Not Changed

  • No routes were removed.
  • No production controller was replaced.
  • No employee self-view controller was replaced.
  • No schedule rows were created.
  • No schedule rows were edited.
  • No schedule rows were deleted.
  • No draft workflow was changed.
  • No publish workflow was changed.
  • No employee self-view data was changed.
  • No middleware was created.
  • No auth config was changed.
  • No database writes were introduced.
  • No exports, PDFs, or CSVs were introduced.
  • No employee texts or employee emails were introduced.

Support Links

Screen Purpose Open
Production / Build Schedule Existing live builder workflow. Open
25P-6 Visual Cleanup Completion Prior visual cleanup closeout. Open
Builder Help Strip Consolidated helper links. Open
Review Soft Conflicts Review conflicts before publish. Open
Builder Checklist Manager publish readiness checklist. Open
Employee Portal Employee-facing published schedule entry point. Open
Developer Tools Diagnostics/support tools. Open

Next Recommended Phase

25Q-2 — Manager Schedule Builder Data Source Mapping / Read-Only Draft-Publish Map
Recommended next phase should use the 25Q-1 inventory to map the actual draft and published schedule data sources in a read-only report before any functional changes.
  1. Keep production route/controller intact.
  2. Map actual draft and published schedule tables.
  3. Map employee, date, time, status, and period fields.
  4. Map existing save/publish controller methods if detectable.
  5. Do not alter draft/publish save logic.
  6. Do not change employee self-view data.
  7. Do not add employee texts/emails.
  8. Do not add hard conflict blocking.
  9. Do not add automatic scheduling yet.