Show game usage counts on the admin edit screen #937

New issue

Open

opened 2026-08-27 03:31:27 -05:00 by Veilor · 0 comments

Veilor commented

2026-08-27 03:31:27 -05:00

Member

Administrators need a quick summary of whether a game is used by lists, wishlists, or favorites before disabling or replacing it.

The requested data is aggregate usage information; individual user names are out of scope.

Scope

Add aggregate counts for users who have each game in lists, wishlists, and favorites.
Display the three counts in the existing admin game-edit view.
Load counts through the existing game/admin application patterns and preserve current authorization behavior.

Acceptance Criteria

The admin game-edit screen shows separate counts for Lists, Wishlists, and Favorites.
Each count represents the number of users associated with the game in that category, with zero displayed when there are no associations.
The summary is visible without navigating to the public game page.
No user names or other personally identifying details are shown.
Existing game-edit behavior, validation, authorization, and disable/replace workflows remain unchanged.

Test Coverage Required

Feature coverage verifies an authorized administrator can see all three counts on the game-edit screen.
Feature coverage verifies nonzero counts are rendered for list, wishlist, and favorite associations.
Feature coverage verifies zero counts are rendered when the game has no associations.
Feature coverage verifies unauthorized users cannot use the admin game-edit surface to access the summary.

Progress Checklist

Identify the existing admin game-edit controller/action and view.
Use the existing game, list, wishlist, and favorite relationships or query patterns to calculate user counts.
Render a compact three-category summary at the bottom of the edit form.
Add focused feature tests for populated, empty, and unauthorized cases.
Run the affected PHP formatting and focused test checks before review.

Administrators need a quick summary of whether a game is used by lists, wishlists, or favorites before disabling or replacing it. The requested data is aggregate usage information; individual user names are out of scope. ## Scope - Add aggregate counts for users who have each game in lists, wishlists, and favorites. - Display the three counts in the existing admin game-edit view. - Load counts through the existing game/admin application patterns and preserve current authorization behavior. ## Acceptance Criteria - The admin game-edit screen shows separate counts for Lists, Wishlists, and Favorites. - Each count represents the number of users associated with the game in that category, with zero displayed when there are no associations. - The summary is visible without navigating to the public game page. - No user names or other personally identifying details are shown. - Existing game-edit behavior, validation, authorization, and disable/replace workflows remain unchanged. ## Test Coverage Required - Feature coverage verifies an authorized administrator can see all three counts on the game-edit screen. - Feature coverage verifies nonzero counts are rendered for list, wishlist, and favorite associations. - Feature coverage verifies zero counts are rendered when the game has no associations. - Feature coverage verifies unauthorized users cannot use the admin game-edit surface to access the summary. ## Progress Checklist - [ ] Identify the existing admin game-edit controller/action and view. - [ ] Use the existing game, list, wishlist, and favorite relationships or query patterns to calculate user counts. - [ ] Render a compact three-category summary at the bottom of the edit form. - [ ] Add focused feature tests for populated, empty, and unauthorized cases. - [ ] Run the affected PHP formatting and focused test checks before review.

Veilor added the

status

needs codex review

label

2026-08-27 03:31:27 -05:00

Codex changed title from ~~The ability to see if a game is on someones list, wishlist or favorites when we edit games.~~ to Show game usage counts on the admin edit screen

2026-08-27 03:32:01 -05:00

Codex added

component: games

component: game lists

component: user favorites

component: user wishlists

and removed