Purchase Order System

I need the following web based software written: Users: • Go to the home page of the site • Login in to the site • Once logged in the page would have three choices o Routine Orders  Based on the department associated with the user name, a table with the following information will appear • Item • Description • Pack Size • QTY Requested • Previous Order • Submit  Once the use fills in their qty on the order form, the user clicks submit.  Once submit, a behind the screen a script will compare items order and determine which of the three vendor is cheaper based on the information from product database  A screen will appear displaying what the users has order with QTY and the vendor, the user will have a chance to change the order or to submit.  Submitted, the items qty will be added to a database to track usage, and an email sent to the admin of software.  The email will have following information on it. • Date • Order # • Location • Department • Products o Vendor o Price o QTY  This information will also be inserted in to the PO database o Non-routine Orders  If the user clicks on non-routine orders, then a black form with the followings fields will appear • Item # • Vendor • Description • Price • QTY needs • Department • Submit  Once submit, a screen will displaying showing their request with an assigned PO#.  Once approved, an email will be sent to the admin and the data will be inserted in the PO database o Order Status  User can check to see if order have been ordered and if yes the tracking information • Admin o Admin logins in o Redirected to Admin page o The admin page will have a table with the following choices  Product List • A list of the categories will be displayed • Users can then modify, add or delete product data.  User Admin- displaying all user, Admin can add, delete or modify users accounts  Admin can modify standard order guide and vendor pricing  PO Management-A table with the following fields • Order # - number assigned to order and linked to PO • Location • Status: Open, Ordered, Closed • Tracking info: hyperlink to tracking site • Invoiced Received  Reports-the ability to run a usage reports based on either item or category. • Export into PDF • Export into Excel • Vendors o Can login in o Update contact information o Update their pricing o Update tracking information for PO