PHP / mysql webbased coding job

In Progress

Simple PHP/Database job:

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.

A - discont list

B - discont list

C - discont list

D - main list

S - Special list(s)

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.

pls find attached the needed files/data to complete the job. The coding will be simple, but it will be tricky to understand to deal with all pricelists. you may be confused now. Don't worry, once you understood the project, it will be a piece of cake.

All are DEMODATA, means I will add the full data by myself later on. Thats why you need to tell me how to get the data simply into database.

PLS also add the fields EAN Code, VPE, EP Page, quantity unit - to result pages. All Data is existing. Take care, we use EUR (€).

Notice: To seach by "productname" or pices the query should go over "productname" and "product description". Unfortunally there is only in mainlist a product description". Make sure that "[url removed, login to view]" item number will be also found as "7100", or "07100".

There will be few dealers, who will get a own "special list" with some products by a special price, we can identify them by thier dealer ID.

For example "dealer 88888" is a special customer> "88888" check > if its "S=SPECIAL"

Check FIRST if the selected product is in "S" - special list", if yes get the price from "S" if not

seach "A - discont list" (All Special dealers have the A Status). If not, seach in mainlist.

Another part will be to add another type of user to system "salesman" they login with thier "salesman" ID and a fixed "PW" (also changeable by admin), they all have the same status and see the same data. They use all same lists and enter the same text/product numbers as dealer. But the result page will be different. It has to contain the "dealer"-data and some extra data called: bulk discount (only salesman will see them). Bulk discount is easy to calculate (fixed quanity and percentage -(ALL DATA are already existing). Salesman will be added/listes/edited/deleted by

admin.

You get a mdb Database to convert/import and a very good description how it works/looks like.

You need to start immediately (TODAY/TOMORROW).

You get paid when job is done and working 100%

Skills: MySQL, PHP

See more: why i want this job, why do you want this job, why do i want this job, when you don t get the job, we want a salesman, type of button in php with code, should i take the job, pices, php mysql job, people need job, mdb files, look php id, logo customer care, job seach, job description of salesman, i want to make a product by myself, in need of a salesman, i need salesman job, how to start coding, how to seach job, how to identify a logo, how to get the job, how to get coding job, how to get coding, how to get a job

About the Employer:
( 33 reviews ) unknown, Germany

Project ID: #4383206

Awarded to:

hawkitsolution

Hi, Hawk it solution is a group of proofessionals with resources who are experienced and commited towards Work. Our resources expertise in a wide skil set ,which matches your requirement . We understand what you More

$140 USD in 2 days
(0 Reviews)
0.0

14 freelancers are bidding on average $240 for this job

hits

We are a team of developers with expertise and experience in PHP and MySql, We have developed several complex and custom applications with search etc. I have seen this same requirement posted earlier too. However even More

$525 USD in 5 days
(801 Reviews)
8.7
zeke

Dear Customer! I am an expert web developer with over 6 years of experience and very interested in this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service More

$200 USD in 2 days
(145 Reviews)
6.8
shihan033010

Hi I am ready to start your job right now.

$315 USD in 5 days
(229 Reviews)
6.3
jsr3

I understand your requirements and ready to start right now. Please check your message box for more details.

$157 USD in 3 days
(49 Reviews)
6.2
caneadysl

>>>CAN DELIVER WHAT U NEED AS IT IS ....CHECK FOR PM ME SIR.....

$150 USD in 18 days
(38 Reviews)
5.2
hrarcon

Ready to work on your project

$525 USD in 20 days
(6 Reviews)
5.1
ovgu12

Dear Client, I would like to implement the script for you. I have knowledge in PHP and Mysql Programming with many on und offline experience. Contact me please regarding of your requirements

$450 USD in 10 days
(14 Reviews)
4.0
anonymed

interested to work on, pm me for some clarifications

$125 USD in 3 days
(5 Reviews)
3.5
BZim

I've done work like this in the past - from what I understand, you need: user login, price comparison by status, price comparison by 'dealer specific' and the results of said comparison displaying the entire row of res More

$325 USD in 7 days
(4 Reviews)
3.0
rsen75

i'm 14+ years experienced

$210 USD in 5 days
(2 Reviews)
2.4
NineOwlsTeam

How about having this done for $150 and within 5 days MAX after the bid is accepted ? I am sure i can do this job perfectly.

$125 USD in 3 days
(12 Reviews)
1.9
mahmoud91

I can help you

$160 USD in 7 days
(0 Reviews)
0.0
mingai426

Hi, I have read your description. I am very interest your job. I researched your job deeply. I had worked with web for 5 years. I have rich skill in php, mysql. if you work with me, you will not fail and I won't dis More

$131 USD in 3 days
(0 Reviews)
0.0
favouk

Hello sir, we can provide a backend web site for admin to append your clients and a frontend website which will allow you clients to search products they want. Please check your PMB.

$154 USD in 3 days
(0 Reviews)
0.0
nagarajphp

hi please check PM

$125 USD in 3 days
(0 Reviews)
0.0