This is a small, simple database project.
We need two PHP or Perl CGI screens that write to a flat file database.
SCREEN #1 (User Screen)
The first screen lists the contents of a separate .csv file (which we manually export from an Excel spreadsheet). This database contains fields SKU, Item Name, Gender, Size, Color, QTY AVAIL.
Beside each line item on the User Screen is a check box. The user can check-mark only one item in the list. If the QTY field in the Item Database = 0, this item does not appear in this list on the User Screen.
At the top of the User Screen is an input field that requests an Order Number. When the Submit button is clicked, the page checks another .csv flat file database (Order Number Database). If that Order Number appears in the APPROVED field in this database, then the Item Name that was check-marked is e-mailed to us (all item attributes) and a thank-you message appears. If the Submit button is clicked without first selecting an Item in the list, an error message is displayed to the User.
When the submission is successful, the Order Number is moved to the FILLED column in the database. Also, the Item selected by the user is adjusted in the QTY column of the Item Database (-1).
SCREEN #2 (Admin Screen)
This admin screen is password protected. Upon authentication, admin sees a list of all items in the Item Database (even items with QTY = 0).
The admin can change and save all attributes, including adding and deleting items.
This screen should allow a .csv export of the database.
This screen should also allow admin to view, add, change, and delete entries in the Order Number database (Approved and Filled fields).
There will be about 100 entries in the Item Database.
There will be about 50 entries in the Order Number Database.
Please see mock-ups attached.