Results
https://app.optimalworkshop.com/optimalsort/na24d535/ai806t0t/shared-results/bijfq5b6lp1r26md1c65ig2px6zlep55#/t/results/analysisTools/similarityMatrix

https://www.optimalworkshop.com/optimalsort/
unmoderated and open

Name, address, days and hours. Needs to communicate with database: store and update information.

If any issues arise, it will most likely be due to capitalization of or implementation of underscores in table names since PHPMyAdmin works differently that MySQL workbench, and choices were made to support one over the other.

Python

This might allow for faster mysql queries after the restaurant has been in business over a year and accrued thousands of orders.

• - Drag and Drop: Move items from one sub category to another, or just change relative position within same subcategory.
• category images upload
• add, remove, move, change order of
• implement images upload

Ensure mySQL server can be reached on host as Pi will directly access it on port other than 80. Ngrok?

This page will resemble the current orders page, but only show those that have been submitted to "kitchen." This is seen in their status fields. Page only has one function: to mark items as completed. Orders will need to be broken down by individual items. When all items have been completed, the order will be marked as completed and updated on the current orders page.

Cannot upload images that have same names as those already on the server.
Two options: (1) overwrite old pictures. (2) Give new and randomized names to every image uploaded.

This also brings up the possibility of an image gallery to choose previously uploaded images, which incentivizes option 2 above.

Will need this info to calculate total number of people in line by subtracting from total occupants.

Dependency for people counter.
Order Page is suitable candidate.

Make the website attractive

Currently, all the passwords are stored in plaintext in the database. This is a big security concern, will need to fix once we have a stable product.

Completed Wireframes
https://drive.google.com/drive/u/1/folders/1PaBBYQ3VRAo5r5mLl-EPz4oaB5d6ZhlV
Completion List
https://docs.google.com/document/d/1h9GdMwheiEmfguW71pespxJzCuocOLv8yjVOQe8D_cc/edit#heading=h.ly3b0yicexyh

Suggested tool: lucidchart.com

Complete by 10/19 2:00pm

SRS FRs to describe:

Customer Level

• user registration
• user log in/out
• order food
• confirm / pay order
• waiting time estimator
• create reservation

Employee Level

• view pending orders (kitchen view)
• inventory access
• clock in/out

Manager Level

• create / modify employee schedules
• create / modify menu
• manage other roles (hire/fire employee)
• review accounting data: sales revenue

Link to diagram

https://lucid.app/lucidchart/3e13d9a8-9d73-434c-8e1f-8469a70570a0/edit?invitationId=inv_7e918cd3-90ad-43e9-bd7f-2daaf21dad7a&page=AU2h.iVtuFvG#

Have back-end ascertain user's privilege levels through database, and automatically send them to correct dashboard/portal.

Need to investigate why a new username cannot be created and added to database through account HTML page.

https://docs.google.com/document/d/1zmDbT1MgmwRPtBCmdNrlUBmiQR8KYQ8NbKq-qIKbbN4/edit?usp=sharing

Ensure wireframe details can be traced to wiki and vice-versa. For example, the home page links to an "about" page that needs to be described as another feature in the UIRs or FRs.

Filter timesheet from Date to Date

Link to one JS file in each HTML page that creates a specific nav bar based on user privileges. Centralization of nav bar code will make it easier to modify later if needed.

Use Raspberry Pi's people counter data (an integer) -- strored in mySQL database -- to design an algorithm that predicts customer wait times.

According to timesheet and wage of employee to calculate paycheck depending on the pay period chosen (from date to date)

• variables (times visited, last visited date)
• Favorite Menu Item
• Previous order (Button)

4 Diagrams: 1 for each user privilege level

Lucid Chart Diagrams
https://lucid.app/lucidchart/3e13d9a8-9d73-434c-8e1f-8469a70570a0/edit?viewport_loc=-11%2C-649%2C1792%2C2113%2C0_0&invitationId=inv_7e918cd3-90ad-43e9-bd7f-2daaf21dad7a