Build out admin Games Checklist page #70

New issue

Open

opened 2026-05-07 20:44:31 -05:00 by jimmyb · 0 comments

jimmyb commented

2026-05-07 20:44:31 -05:00

Owner

Copy link

The /admin/games/checklist page should become a working admin workflow for finding active game records that are missing important metadata. DB/admin users need one place to spot incomplete records, understand what is missing, and jump directly to the edit game page to fix them.

The current Laravel checkout already has an admin games checklist route, sidebar entry, and placeholder view. Related admin pages such as TBD Games and EA Games already use Admin\GameController, x-admin.card, x-admin.table, pagination, platform badges, and edit-game links. The games table stores the metadata this checklist should inspect, including description, source, boxart, genre IDs, website, regional release dates, rating fields, developers, publishers, and composers.

Scope

Replace the current /admin/games/checklist placeholder with a real checklist table.
Include active, non-soft-deleted games only.
Identify missing or incomplete metadata on each game.
Initial checks should include missing release dates, missing website URL, missing source URL, missing description, missing boxart, missing genres, missing developer/publisher data, and missing rating fields where appropriate.
Display each game with ID, title, platform, missing-data summary, and edit action.
Link each row to the existing admin edit game page.
Reuse existing admin layout, sidebar, card, table, platform badge, button, and pagination patterns.
Keep related TBD and EA pages intact; this checklist should complement them rather than replace them.

Acceptance Criteria

Authorized admin game staff can visit /admin/games/checklist and see a populated checklist instead of the placeholder.
Soft-deleted/deactivated games are excluded from the checklist.
Games with no missing checklist fields are excluded from the checklist.
Games with one or more missing fields appear in the table.
Each row shows the game ID, game title, platform, and a readable list of missing metadata.
Each row includes a link or button to admin.games.edit for that game.
Missing release-date checks cover NA, JP, EU, and AUS release date columns.
Missing URL checks distinguish website and source URL where both are considered important.
Missing media/content checks cover boxart, description, and genre assignment.
The page paginates results so large incomplete datasets remain usable.
The empty state clearly says when no incomplete active games were found.
The page follows existing admin dashboard styling and supports light/dark mode.
Existing TBD Games and EA Games pages continue to work independently.

Test Coverage Required

Feature test confirming authorized game-admin users can render /admin/games/checklist.
Authorization test confirming users without the admin games role cannot access the checklist.
Feature test confirming the placeholder text is replaced by checklist table content when incomplete games exist.
Feature tests for games missing release dates, website, source, description, boxart, genres, developer/publisher metadata, and ratings as implemented.
Regression test confirming complete active games do not appear.
Regression test confirming soft-deleted/deactivated games do not appear.
Feature test confirming each checklist row links to the correct admin edit game route.
Feature test confirming pagination works when more than one page of incomplete games exists.
Feature test confirming the empty state renders when no active games have missing data.
Regression tests confirming existing admin.games.tbd and admin.games.early-access pages still render.
Tests should use Pest and focused feature coverage.
Run the focused affected tests, then run vendor/bin/pint --dirty --format agent before closing the issue.

Progress Checklist

Admin games checklist route exists
Admin sidebar links to Games Checklist
Checklist placeholder view exists
Admin game edit page exists
Admin table, card, platform badge, and button components exist
TBD Games and EA Games pages provide reusable admin list patterns
games table stores metadata needed for checklist checks
Define the first-pass checklist fields and labels
Query active games with at least one missing checklist field
Build a missing-metadata summary per game
Replace the placeholder with a paginated admin table
Add edit-game links for every row
Add a clear empty state for no incomplete games
Add tests for access control, missing-field detection, exclusion rules, edit links, pagination, and empty state
Confirm TBD and EA admin pages continue to work alongside the checklist

The `/admin/games/checklist` page should become a working admin workflow for finding active game records that are missing important metadata. DB/admin users need one place to spot incomplete records, understand what is missing, and jump directly to the edit game page to fix them. The current Laravel checkout already has an admin games checklist route, sidebar entry, and placeholder view. Related admin pages such as TBD Games and EA Games already use `Admin\GameController`, `x-admin.card`, `x-admin.table`, pagination, platform badges, and edit-game links. The `games` table stores the metadata this checklist should inspect, including description, source, boxart, genre IDs, website, regional release dates, rating fields, developers, publishers, and composers. ## Scope - Replace the current `/admin/games/checklist` placeholder with a real checklist table. - Include active, non-soft-deleted games only. - Identify missing or incomplete metadata on each game. - Initial checks should include missing release dates, missing website URL, missing source URL, missing description, missing boxart, missing genres, missing developer/publisher data, and missing rating fields where appropriate. - Display each game with ID, title, platform, missing-data summary, and edit action. - Link each row to the existing admin edit game page. - Reuse existing admin layout, sidebar, card, table, platform badge, button, and pagination patterns. - Keep related TBD and EA pages intact; this checklist should complement them rather than replace them. ## Acceptance Criteria - Authorized admin game staff can visit `/admin/games/checklist` and see a populated checklist instead of the placeholder. - Soft-deleted/deactivated games are excluded from the checklist. - Games with no missing checklist fields are excluded from the checklist. - Games with one or more missing fields appear in the table. - Each row shows the game ID, game title, platform, and a readable list of missing metadata. - Each row includes a link or button to `admin.games.edit` for that game. - Missing release-date checks cover NA, JP, EU, and AUS release date columns. - Missing URL checks distinguish website and source URL where both are considered important. - Missing media/content checks cover boxart, description, and genre assignment. - The page paginates results so large incomplete datasets remain usable. - The empty state clearly says when no incomplete active games were found. - The page follows existing admin dashboard styling and supports light/dark mode. - Existing TBD Games and EA Games pages continue to work independently. ## Test Coverage Required - Feature test confirming authorized game-admin users can render `/admin/games/checklist`. - Authorization test confirming users without the admin games role cannot access the checklist. - Feature test confirming the placeholder text is replaced by checklist table content when incomplete games exist. - Feature tests for games missing release dates, website, source, description, boxart, genres, developer/publisher metadata, and ratings as implemented. - Regression test confirming complete active games do not appear. - Regression test confirming soft-deleted/deactivated games do not appear. - Feature test confirming each checklist row links to the correct admin edit game route. - Feature test confirming pagination works when more than one page of incomplete games exists. - Feature test confirming the empty state renders when no active games have missing data. - Regression tests confirming existing `admin.games.tbd` and `admin.games.early-access` pages still render. - Tests should use Pest and focused feature coverage. - Run the focused affected tests, then run `vendor/bin/pint --dirty --format agent` before closing the issue. ## Progress Checklist - [x] Admin games checklist route exists - [x] Admin sidebar links to Games Checklist - [x] Checklist placeholder view exists - [x] Admin game edit page exists - [x] Admin table, card, platform badge, and button components exist - [x] TBD Games and EA Games pages provide reusable admin list patterns - [x] `games` table stores metadata needed for checklist checks - [ ] Define the first-pass checklist fields and labels - [ ] Query active games with at least one missing checklist field - [ ] Build a missing-metadata summary per game - [ ] Replace the placeholder with a paginated admin table - [ ] Add edit-game links for every row - [ ] Add a clear empty state for no incomplete games - [ ] Add tests for access control, missing-field detection, exclusion rules, edit links, pagination, and empty state - [ ] Confirm TBD and EA admin pages continue to work alongside the checklist

jimmyb added the

type: feature

component: admin dashboard

component: games

labels

2026-05-07 20:44:31 -05:00

jimmyb added this to the New Features - Part 1 project

2026-06-03 23:54:20 -05:00

No Branch/Tag specified