Project 2 Phase 4 GitHub Release

This release has additional features that were added for Phase 4 of our project as well as the documentation. Additionally, we have organized our folder structure.

Below are the features we added:
Sales Report: Given a time window, display the sales by menu item from the order history.
Excess Report: Given a timestamp, display the list of inventory items that only sold less than 10% of their inventory between the timestamp and the current time, assuming no restocks have happened during the window.
Restock Report: Display the list of inventory items whose current inventory is less than the inventory item's minimum amount to have around before needing to restock.
New Seasonal Menu Item: Your vendor just got a new seasonal menu item they have never sold before. Provide and demonstrate the ability to add this menu item to their POS (and any associated inventory items).
What Sales Together: Given a time window, display a list of pairs of menu items that sell together often, popular or not, sorted by most frequent.

We also created documentation for all of the classes, functions, and variables, which can be found in the javadoc

Project 2 Phase 3 GitHub Release

This release includes the Java Swing GUI that we created on both the manager side and the cashier side.

On the cashier side, we have the ability to add drinks to orders and have it affect the quantity of required ingredients when the order is submitted. It also has input validation and will not allow the user to order something if the ingredients are out of stock. There is also flexibility when ordering and the customer can customize toppings, ice level, sugar level, etc.

On the manager side, the manager can view, add, and update items and prices on the menu and inventory. The manager is also able to access and update the inventory efficiently.

Database Correctness Redemo

This GitHub release is for the Project 2 Deliverable: Phase 2 GitHub Release (for our second demo, with updated tables for our UML)

Upon release, this repository contains the generated csvs, our 15 SQL queries, our python code to generate the csv data, and our SQL code to create the tables and their respective schemas.

Furthermore, it also contains the above from the first draft we had for our first demo. However, we replaced the 15 SQL queries to fit our new schema that matches our UML diagram.

The required queries (4 of them) are located in the folder MandatoryQueries, and the 11 other queries are located in the folder OptionalQueries.

Database Correctness Demo

This GitHub release is for the Project 2 Deliverable: Phase 2 GitHub Release

Upon release, this repository contains the generated csvs, our 15 SQL queries, our python code to generate the csv data, and our SQL code to create the tables and their respective schemas.

The required queries (4 of them) are located in the folder MandatoryQueries, and the 11 other queries are located in the folder OptionalQueries.