Implement Page for Admin to View Suggestions

[entrotech]

Dependencies

#935 - Map the process
#936 - Design the process

Overview

A "Suggest an Edit" feature was implemented which records end-user suggestions in a suggestion table. We need to provide a page for an admin to view and process these suggestions.

Action Items

• Write a SQL suggestion searxh query that searches the suggestion table by appropriate criteria.
• Make an Express/Node endpoint /apio/suggestions/search that executes this SQL and returns results as JSON, the enpoint should require the calling user to be logged in as a user with the admin role.
• Add a menu item to the main menu that is only available to admin users and have it link to...
• A page that allows the user to query the suggestions and display them in a list.
• The user should be able to select a suggestion and edit the admin note and update the status to indicate whether the issue is "in process" or "closed" and save the change.
• For saving changes, you will need to provide additional endpoints and sql queries to update the table.

Resources/Instructions

[crisbnp]

Hi @entrotech! Is there a visual what the page (suggestion list) should look like?

[ktjnyc]

@entrotech do you need an issue created for a page mock-up for this one?

[ktjnyc]

Created 2 issues as dependencies for this:
Map out process #935
Design process #936

I'm going to move this to ice-box so that it waits until the other two are complete. This will be updated when it's ready for coding.

[entrotech]

Checked with @hanapotski on tuesday 9/7/21. She said that she and @webdevangelie were going to start working on this soon.

[gigicobos]

@entrotech I tried submitting a Correction (Google Chrome) as a food seeker on the test site and this error message showed up:

[hanapotski]

@entrotech I have this PR up > #1035

[fancyham]

Hi folks, is this issue completed? I see it’s in the ‘done’ column of the Project Management kanban board but is still open — is it actually complete?

[staceyrebekahscott]

Re-closing this issue as all associated PRs appear to be resolved and closed.