PHP/MySQL Website easy for intermediate coders(repost)

Avg Bid (USD)
Project Budget (USD)
$30 - $200

Project Description:
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

## Deliverables

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).

## Platform

Internet Explorer all versions, Firefox, Safari, PHP4, MySQL

Skills required:
Engineering, MySQL, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.