This project is for the creation of a simple MySQL database interface.
We need two panels.
***** PANEL #1 *****
The first panel requests a zipcode and an order number, then returns the results:
Expected Ship Date
The "Status" is either Backordered (default), Shipped, Canceled By Customer, or Canceled By Warehouse.
If the "Status" is Backordered, then a Cancel button appears beside each result. When clicked, this changes the "Status" to "Canceled By Customer".
***** PANEL #2 *****
The second panel is the same as the first panel, but has an administrator username and password. The search fields are Order Number and Item Name.
It also includes an "Add Listing" feature where items can be added with all of the previous attributes, and a View All feature which allows viewing all items in the database. Also, a View All Open Items link (which doesn't display any items with the "Status" of Shipped, Canceled By Customer, or Canceled By Warehouse).
This panel also has one additional "Status" option: "Shipped". It also allows the admin to change the status (Update), and a text field to enter data into the Comments field and Expected Ship Date (optional). The default values for these two fields is (Comments) "None" and (Expected Ship Date) "Not Yet Assigned".
In this second panel, the Cancel button is available on items that have a "Status" of Backordered. If the cancel button is pressed in this second panel, the status is changed to "Canceled By Warehouse".
Thank you for your interest in this project.