Issues

• Disable the H2 console when using the MySQL profile

  buggood first issuespring-boot
  NxtLabTech/CityFix#31 · Filter by author niat-web opened on Sep 29, 2026

• Create a shared JavaScript helper for status messages

  enhancementfrontend
  NxtLabTech/CityFix#30 · Filter by author niat-web opened on Sep 29, 2026

• Show the "Fixed on" field only when applicable

  bugfrontendgood first issue
  NxtLabTech/CityFix#29 · Filter by author niat-web opened on Sep 29, 2026

• Add an empty state to the staff reports table

  enhancementfrontendgood first issue
  NxtLabTech/CityFix#28 · Filter by author niat-web opened on Sep 29, 2026

• Set the report page title dynamically

  bugfrontendgood first issue
  NxtLabTech/CityFix#27 · Filter by author niat-web opened on Sep 29, 2026

• Add a Clear Filters action and improve empty states

  enhancementfrontendgood first issue
  NxtLabTech/CityFix#26 · Filter by author niat-web opened on Sep 29, 2026

• Keep report filters in the URL

  enhancementfrontend
  NxtLabTech/CityFix#25 · Filter by author niat-web opened on Sep 29, 2026

• Prevent outdated filter results from replacing newer results

  bugfrontend
  NxtLabTech/CityFix#24 · Filter by author niat-web opened on Sep 29, 2026

• Require explicit confirmation before changing a report status

  bugfrontend
  NxtLabTech/CityFix#23 · Filter by author niat-web opened on Sep 29, 2026

• Mark required fields and enable browser autofill

  enhancementfrontendgood first issue
  NxtLabTech/CityFix#22 · Filter by author niat-web opened on Sep 29, 2026

• Show form validation errors next to the relevant fields

  enhancementfrontendhelp wanted
  NxtLabTech/CityFix#21 · Filter by author niat-web opened on Sep 29, 2026

• Announce loading, success, and error messages to screen readers

  enhancementfrontend
  NxtLabTech/CityFix#20 · Filter by author niat-web opened on Sep 29, 2026

• Improve contrast of form controls and navigation

  bugfrontendgood first issue
  NxtLabTech/CityFix#19 · Filter by author niat-web opened on Sep 29, 2026

• Prevent long text from causing horizontal scrolling

  bugfrontendgood first issue
  NxtLabTech/CityFix#18 · Filter by author niat-web opened on Sep 29, 2026

• Make the staff reports page responsive on mobile

  enhancementfrontend
  NxtLabTech/CityFix#17 · Filter by author niat-web opened on Sep 29, 2026

• Make frontend error and loading handling robust

  bugfrontendgood first issue
  NxtLabTech/CityFix#16 · Filter by author niat-web opened on Sep 29, 2026
  1

• Add pagination to GET /api/reports and the reports page

  enhancementfrontendhelp wanted
  NxtLabTech/CityFix#15 · Filter by author niat-web opened on Sep 29, 2026

• Compute stats with GROUP BY queries and add indexes

  databaseenhancementhelp wanted
  NxtLabTech/CityFix#14 · Filter by author niat-web opened on Sep 29, 2026

• Move report filtering from Java into the database

  databaseenhancementhelp wanted
  NxtLabTech/CityFix#13 · Filter by author niat-web opened on Sep 29, 2026

• Handle simultaneous upvotes safely

  bugdatabasehelp wanted
  NxtLabTech/CityFix#12 · Filter by author niat-web opened on Sep 29, 2026

• Stop returning reporterEmail in public API responses

  enhancementjavaspring-boot
  NxtLabTech/CityFix#11 · Filter by author niat-web opened on Sep 29, 2026
  1

• Make sample-data vote counts match real upvote rows

  bugdatabasejava
  NxtLabTech/CityFix#10 · Filter by author niat-web opened on Sep 29, 2026

• Add NOT NULL constraints to required columns

  databaseenhancementgood first issue
  NxtLabTech/CityFix#9 · Filter by author niat-web opened on Sep 29, 2026
  1

• Add UpvoteRepository tests, including the unique constraint

  databasejavatesting
  NxtLabTech/CityFix#8 · Filter by author niat-web opened on Sep 29, 2026

• Add controller tests for the status, upvote and stats endpoints

  good first issuespring-boottesting
  NxtLabTech/CityFix#7 · Filter by author niat-web opened on Sep 29, 2026