Description
High-Level Requirements:
Extend Assignment #2 for the online retailer to add the following features:
Inventory Report
Sales Report
For the visual reports in requirement #2 listed below, consider Google charts
documentation at the following URL:
https://developers.google.com/chart/interactive/docs/gallery/barchart
Requirements:
Add the Inventory and Sales Reports links that are accessible
only to the Store Manager
Under the Inventory link, the store manager shall be able to:
1. Generate a table of all products and how many items of
every product currently available in the store; list only
product name, price, how many items of that product
available
2. Generate a Bar Chart that shows the product names and the
total number of items available for every product
3. Generate a table of all products currently on sale
4. Generate a table of all products currently that have
manufacturer rebates
Under the Sales Report link, the store manager shall be able to:
1. Generate a table of all products sold and how many items of
every product sold; list only product name, product price,
number of items sold, and total sales of every product sold
2. Generate a Bar Chart that shows the product names and the
total sales for every product
3. Generate a table of total daily sales transactions; that is,
you list the dates and total sales for every day-date