PHP/MySQL Website easy for intermediate coders(repost)
This project received 8 bids from talented freelancers with an average bid price of $103 USD.Get free quotes for a project like this
Project Budget$30 - $200 USD
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 [url removed, login to view] into a new mysql table in the database. 2. Import [url removed, login to view] and [url removed, login to view] 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/[url removed, login to view]) ex: SELECT * FROM `invprice` WHERE 'item_id'='A2102DB' AND `clientType`='P'; $item price (qty 1-5) = $[url removed, login to view] each $item price (qty 6-59) = $[url removed, login to view] each $item price (qty 60+) = $[url removed, login to view] 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
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online