MyVideoGameList/myvideogamelist.com
MyVideoGameList/myvideogamelist.com
3
0
Fork 0
Code Issues 45 Pull requests Projects 3 Releases Activity Actions

Paginate the public game reviews index #15

New issue
Open
opened 2024-01-14 14:22:08 -06:00 by jimmyb · 3 comments
jimmyb commented 2024-01-14 14:22:08 -06:00
Owner
Copy link

The public Game Reviews page needs pagination so visitors can browse published reviews without loading the full review history on one page.

The current Laravel checkout has a sidebar link to /reviews, an admin “Pending Game Reviews” placeholder, merge references for future game_reviews records, and Recent Gamer Updates support for game_review_published, but the public reviews index itself is not rebuilt yet. This issue tracks ensuring the rebuilt /reviews page is paginated from the start.

Scope

  • Public reviews index at /reviews.
  • Published game review listing only.
  • Pagination controls and page metadata.
  • Filtering out draft, pending, rejected, deleted, or otherwise non-public reviews.
  • Sidebar active state for the existing /reviews link.
  • Reuse of existing Laravel/Tailwind layout and pagination patterns.

Acceptance Criteria

  • /reviews renders a public paginated list of published game reviews.
  • Reviews are ordered newest-first by published date.
  • The index shows review title, author, game, platform, score/rating where available, excerpt, and published timestamp.
  • Pagination limits reviews to a reasonable page size and provides next/previous/page links.
  • Invalid or out-of-range pages fall back cleanly or return the expected Laravel pagination response.
  • Draft, pending, rejected, deleted, or soft-deleted reviews are excluded.
  • Reviews by banned, deleted, or soft-deleted users are excluded.
  • Reviews for deleted or disabled games are excluded.
  • Empty review lists show a clear empty state.
  • The sidebar marks Game Reviews active on /reviews and paginated review pages.
  • User-facing UI supports light/dark mode and follows the existing Laravel/Tailwind site layout patterns.

Test Coverage Required

  • Feature tests for /reviews rendering, newest-first ordering, pagination, page links, and empty state.
  • Feature tests confirming unpublished, pending, rejected, deleted, and soft-deleted reviews are excluded.
  • Feature tests confirming reviews tied to banned/deleted users or deleted/disabled games are excluded.
  • Regression test confirming the sidebar /reviews active state works.
  • Regression test confirming review excerpts/content render safely.
  • Tests should use Pest and focused feature coverage.
  • Run the focused affected tests, then run vendor/bin/pint --dirty before closing the issue.

Progress Checklist

  • Public sidebar link to /reviews exists
  • Admin pending reviews placeholder route/view exists
  • Recent Gamer Updates presenter supports game_review_published
  • Add or confirm review persistence/model
  • Add public /reviews route and controller/action
  • Build paginated public reviews index
  • Add review list item/card presentation
  • Filter non-public reviews, deleted users, and deleted/disabled games
  • Add empty state and pagination controls
  • Confirm sidebar active state for /reviews
  • Add tests for rendering, pagination, filtering, ordering, empty state, and sidebar active state
  • Confirm the reviews index matches expected data coverage
The public Game Reviews page needs pagination so visitors can browse published reviews without loading the full review history on one page. The current Laravel checkout has a sidebar link to `/reviews`, an admin “Pending Game Reviews” placeholder, merge references for future `game_reviews` records, and Recent Gamer Updates support for `game_review_published`, but the public reviews index itself is not rebuilt yet. This issue tracks ensuring the rebuilt `/reviews` page is paginated from the start. ## Scope - Public reviews index at `/reviews`. - Published game review listing only. - Pagination controls and page metadata. - Filtering out draft, pending, rejected, deleted, or otherwise non-public reviews. - Sidebar active state for the existing `/reviews` link. - Reuse of existing Laravel/Tailwind layout and pagination patterns. ## Acceptance Criteria - `/reviews` renders a public paginated list of published game reviews. - Reviews are ordered newest-first by published date. - The index shows review title, author, game, platform, score/rating where available, excerpt, and published timestamp. - Pagination limits reviews to a reasonable page size and provides next/previous/page links. - Invalid or out-of-range pages fall back cleanly or return the expected Laravel pagination response. - Draft, pending, rejected, deleted, or soft-deleted reviews are excluded. - Reviews by banned, deleted, or soft-deleted users are excluded. - Reviews for deleted or disabled games are excluded. - Empty review lists show a clear empty state. - The sidebar marks Game Reviews active on `/reviews` and paginated review pages. - User-facing UI supports light/dark mode and follows the existing Laravel/Tailwind site layout patterns. ## Test Coverage Required - Feature tests for `/reviews` rendering, newest-first ordering, pagination, page links, and empty state. - Feature tests confirming unpublished, pending, rejected, deleted, and soft-deleted reviews are excluded. - Feature tests confirming reviews tied to banned/deleted users or deleted/disabled games are excluded. - Regression test confirming the sidebar `/reviews` active state works. - Regression test confirming review excerpts/content render safely. - Tests should use Pest and focused feature coverage. - Run the focused affected tests, then run `vendor/bin/pint --dirty` before closing the issue. ## Progress Checklist - [x] Public sidebar link to `/reviews` exists - [x] Admin pending reviews placeholder route/view exists - [x] Recent Gamer Updates presenter supports `game_review_published` - [ ] Add or confirm review persistence/model - [ ] Add public `/reviews` route and controller/action - [ ] Build paginated public reviews index - [ ] Add review list item/card presentation - [ ] Filter non-public reviews, deleted users, and deleted/disabled games - [ ] Add empty state and pagination controls - [ ] Confirm sidebar active state for `/reviews` - [ ] Add tests for rendering, pagination, filtering, ordering, empty state, and sidebar active state - [ ] Confirm the reviews index matches expected data coverage
jimmyb commented 2024-01-14 14:22:13 -06:00
Author
Owner
Copy link

Pushing this back until we get enough reviews.

Pushing this back until we get enough reviews.
jimmyb commented 2024-01-14 14:22:19 -06:00
Author
Owner
Copy link

It looks like we've got enough at this point so we should make this one a priority.

It looks like we've got enough at this point so we should make this one a priority.
Codex changed title from Paginate the Reviews Page to Paginate the public game reviews index 2026-05-25 22:31:55 -05:00
Codex commented 2026-06-10 17:13:48 -05:00
Member
Copy link

Added the public /reviews placeholder route and page. The actual paginated published-reviews index is still tracked by this issue, but the route now resolves and has focused coverage for the placeholder/sidebar state.

Added the public /reviews placeholder route and page. The actual paginated published-reviews index is still tracked by this issue, but the route now resolves and has focused coverage for the placeholder/sidebar state.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
dev
No results found.
Labels
Clear labels   
automated

   
code-quality

   
component: admin dashboard
The issue is related to the admin dashboard functionality.

  
component: backend
The issue is related to the backend code.

  
component: billing
The issue is related to our billing and payment system functionality.

  
component: content management
The issue is related to site content and moderation functionality.

  
component: faqs
The issue relates to our frequency asked questions and their categories.

  
component: game genres
The issue is related to genres in relation to games.

  
component: game lists
The issue is related to user-facing game list functionality.

  
component: game reviews
The issue relates to the game reviews functionality.

  
component: game search
The issue is related to the user-facing game search functionality.

  
component: games
The issue relates to games in our database.

  
component: internal notifications
The issue is related to the functionality of notifications sent for internal usage.

  
component: platforms
The issue is related to platform functionality.

  
component: security
The issue relates to the security issues within the app.

  
component: tests
The issue relates to unit and feature tests.

  
component: user api
The issue relates to the user-facing API.

  
component: user badges
The issue is related to our badge/achievements functionality.

  
component: user blogs
The issue is related to blogging functionality.

  
component: user consoles
The issue is related to user console lists functionality.

  
component: user favorites
This is issue is related to the favorites functionality.

  
component: user friends
The issue relates to the friending functionality.

  
component: user notifications
The issue is related to user-facing notifications functionality.

  
component: user profiles
The issue is related to user profile functionality.

  
component: user site notifications
The issue relates to the functionality of notifications shown to users directly on the website.

  
component: user wishlists
This issue is related to the wishlists functionality.

  
component: web design
This issue is related to the design of the website.

  
dependencies
Pull requests that update a dependency file.

  
php
Pull requests that update PHP code.

  
priority
high
 The issue is considered a high priority.

  
priority
low
 This issue is considered a low priority.

  
priority
medium
 This issue is considered a medium priority.

  
security-hotspot

   
source: codex

   
source: sonarqube
  
status
awaiting feedback
 The issue is awaiting feedback from others.

  
status
backlog
 Issues that are in a backlog status.

  
status
done
 The issue has been completed and closed out.

  
status
in progress
 The issue is in progress and being actively worked on.

  
status
in queue
 The issue is in queue and will be worked on shortly.

  
status
in review
 The issue work has been completed and now the work needs to be reviewed.

  
status
needs codex review
 Use this tag to have Codex spiffy up your issue.

  
status
needs investigation
 The issue describes a problem which needs further investigation.

  
status
wontfix
 This issue will not be worked on.

  
type: bug
The issue describes something working the way it wasn't intended too.

  
type: documentation
Improvements or additions to site documentation.

  
type: feature
A new feature for the website.

  
type: improvement
An improvement on an existing feature.

  
type: regression
The issue describes a function that previously worked and no longer does.

  
type: task
A small-ish task.

No labels
automated
code-quality
component: admin dashboard
component: backend
component: billing
component: content management
component: faqs
component: game genres
component: game lists
component: game reviews
component: game search
component: games
component: internal notifications
component: platforms
component: security
component: tests
component: user api
component: user badges
component: user blogs
component: user consoles
component: user favorites
component: user friends
component: user notifications
component: user profiles
component: user site notifications
component: user wishlists
component: web design
dependencies
php
priority
high
priority
low
priority
medium
security-hotspot
source: codex
source: sonarqube
status
awaiting feedback
status
backlog
status
done
status
in progress
status
in queue
status
in review
status
needs codex review
status
needs investigation
status
wontfix
type: bug
type: documentation
type: feature
type: improvement
type: regression
type: task
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
New Features - Part 1
Assignees
Clear assignees
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
MyVideoGameList/myvideogamelist.com#15
No description provided.