Simple PHP/Database webbased job

IN PROGRESS
Bids
37
Avg Bid (USD)
$207
Project Budget (USD)
$30 - $250

Project Description:
Quick simple PHP/Database job to do.

We have users with different disconts (3 types (A/B/C) and we don't want that the people need to use paperlists anymore. We need a webbased seachform to find the right price.

Import 4 excel sheets (containing all needed data) into a mysql database. You need to explain me how to do this in future.

A - discont list
B - discont list
C - discont list
D - main list

We need a login (to protect the data and get the right discont), means the user will log in with "dealernumber" and his "status".

Like ID "123456" and PW "A"

Then we know to choose "A - discont list" and the "A" discont-matrix for main list and this user.

The matrix for mainlist will look like this (example):

Product group 1 = discont -5%
Product group 2 = discont -6%
Product group 3 = discont -7%
Product group 4 = discont -8%
Product group 5 = discont -9%
Product group 6 = discont -10%

"A - discont list" has a fixed price.

Create a webbased seach from with logo and some text, like "Product:" > seach by button. allow "*" to find word parts.

Mainly the people will seach for products "text" or "productnumbers".

List results, easy selectable by mouseclick/keyboard (if there are more than one result).

Check FIRST if the selected product is in "A - discont list", if yes get the price from "A - discont list". If not, seach in mainlist.

Show price from "A - discont list" or if its not there get it from main list (the price will be a calculated result of the conditions/price above.

Show in results:
- show product number
- show product description
- show normal list price (already saved in excel sheet)
- show offer price (already saved in excel sheet)
- show discount price
- source discont list" or "main list" of the calculated price
- button "copy" (will do strg/c of product number, product description and discount price in memory, so the users can paste them)

Dealers will be added/listes/edited/deleted by admin so we need a own login for him.

You need to start immediately.

You get paid when job is done and working 100%

Skills required:
MySQL, PHP
Hire hausmeister
Project posted by:
hausmeister Germany
Verified
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.


$ 250
in 3 days
$ 250
in 4 days
$ 140
in 3 days
$ 250
in 3 days
$ 150
in 2 days
$ 200
in 3 days
$ 250
in 3 days
$ 140
in 3 days
$ 250
in 10 days
$ 249
in 10 days