PHP/MySQL site with add item to form method of creating orders. Need coder to add pricing calulation to add item to order process. Also need to check what type of client the user is to find proper price in `item_prices` table. Coder will also import spread sheets for other client types: sales rep and sub sales rep. We will add a method for checking what type of client a user is at login. Please enquire with questions. Here are the development steps: 1. Import ivprice.xls into a new mysql table in the database. 2. Import REPFILE.csv and SUBREP.csv each into a new table in mysql. 3. Create MySQL table for all users (clients, reps, subreps) for login and client type identification. 4.a. Create account details management page for rep and subrep client types (as there is for client) 4.b. Create account details management page for rep and subrep client types in admin area. 5. Create login method that can identify whether user logging in is a client, rep, or subrep. Redirect to appropriate account page ie client, rep, or subrep. 6. In item page get minimum item quantity and populate quantity menu with multiples of the minimum qty. ex: if minimum is 12, make qty menu show options, 12, 24, 36. 7. Item page pricing part a, retrieve item pricing based on item id, client type, and quantities (w,s,p) (pricing found in inprice table/invprice.xls) ex: SELECT * FROM `invprice` WHERE 'item_id'='A2102DB' AND `clientType`='P'; $item price (qty 1-5) = $2.90 each $item price (qty 6-59) = $2.75 each $item price (qty 60+) = $2.61 each 8.a. At 'add item to order' event, handle pricing data ie create method for tracking the pricing level/cost per item so item quantity can be modified later in edit order section. 8.b. At 'add item to order' event, handle client type data ie. create method for tracking whick client type placed the order ie client, rep, subrep
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Internet Explorer all versions, Firefox, Safari, PHP4, MySQL