PHP/MySQL HOMEWORK project.
Company X is a distribution company that distributes shipments for customers. They pick up product at various locations, and deliver that product to other locations for their customers.
Company X needs to input shipments in the web based system(Input done by either customers, or Company X)
Each customer of Company X will need its own login and password associated with their own demographic info( Co Name, address, phone, email, etc..) The system will allow the customer to login and see all the shipments that it has in intransit. Upon viewing the shipments in a tabular form, each shipment can be edited and redirected(Updated). Upon redirection the system will notify the email of record for that customer, and a dispatcher.
The Company X dispatcher needs to be able to search shipments and edit/update/delete shipments.
Extra credit will be given if you integrate information for Company X to be able to edit its own demographic info and have the redirection emails be pulled from the DB.
The HTML/PHP pages can be blank white pages with no design elements. This is a programing class. Not a design class. (There is extra credit for using a CSS)
Site should have an [url removed, login to view] (with login form)
Upon login based on user type.
Display current customer shipments with a link to allow them to Search, or Update them;
Show an Update Record with update time, and user who updated it with comments about why they updated the shipment;
Display search criteria, and result set based on criteria.
Links to pages with the following functions.
Search customer page, list customer page with Edit/
Add Customer Page,
Edit Customer Page,
List Customer Page with
List Shipment Page
Display Search criteria box and allow them to search all customers shipments by (Date Out + # of Days, Date In + # of days, by Date In, Date Out, Weight, Shipper, Exceptions, and Description.) and display them in tabular form with update, edit, delete, add buttons to allow them to add, edit, update, delete shipments via a shipment edit/add form page;