Simple PHP/Database webbased job

In Progress

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: MySQL, PHP

See more: when you don t get the job, people need job, parts database example, look php id, job seach, how to seach job, how to create simple logo, how to create a logo in word, how do we create logo, get it job, first seach, find the right job for me, find the right job, find the job that is right for you, find people to create logo, how to get a first job, can t find job, quick simple, protect database, php database, d matrix, excel log database, create admin login php mysql, easy product database, mysql word excel

About the Employer:
( 33 reviews ) unknown, Germany

Project ID: #4350234

Awarded to:

inzaghi2006

Hi, I'm very interested in your project. Please contact me, Thanks

$140 USD in 3 days
(66 Reviews)
5.8

35 freelancers are bidding on average $204 for this job

hits

We are a team of developers with expertise and experience in PHP and MySql. We have developed many complex and extensive custom sites of varied extents and complexity. Please see PMB for some site URLs of our recent pr More

$250 USD in 3 days
(804 Reviews)
8.7
kabirchy

Hi, I can help you get this done. best quality assured. Thanks

$250 USD in 4 days
(729 Reviews)
8.1
DeamonBizz

we are ready to start right now,please check private message for sample work..

$140 USD in 3 days
(74 Reviews)
6.7
SEugeneV

will be done with the best quality

$250 USD in 3 days
(234 Reviews)
6.6
vertexsolutions

I am not a bidder programmer myself, I have read the detail and very clear with your requirements. I am available and ready to start on your project right away and will take breath after finish it. Thanks

$150 USD in 2 days
(110 Reviews)
6.1
midhusoft

9+ years experience in programming . 8+ experience in PHP . Knowledge in C, C++, PHP, JavaScript And Cold Fusiono Knowledge in Object oriented programming . Strong logical thinking and learning skills.Worked in the int More

$200 USD in 3 days
(73 Reviews)
6.2
waelfree

Hi, I can do that

$250 USD in 3 days
(51 Reviews)
5.8
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ More

$250 USD in 10 days
(68 Reviews)
5.8
adibr70

I have experience working with PHP, JavaScript, AJAX, MySQL and integration into a site. Check your Private Message to see some examples of sites that I made using PHP. Adrian

$249 USD in 10 days
(30 Reviews)
5.5
acecoder84

Hello, I have gone through your project and I can fulfill your requirement because I am an expert of PHP and mysql. Please refer PMB. Regards, Sadhan.

$175 USD in 4 days
(32 Reviews)
5.4
phpXpertbd

I specialize in similar projects. Please check PM for more details.

$250 USD in 7 days
(17 Reviews)
5.4
istankov85

..........

$300 USD in 15 days
(26 Reviews)
4.7
kitty100

Ready to start. Please check PMB.

$250 USD in 7 days
(18 Reviews)
4.6
pollux1er

I can do this Job for you, I am a PHP expert!

$150 USD in 7 days
(26 Reviews)
4.5
jewelhuq

I can do the job. Import & Export to excel function will be remain there.

$140 USD in 3 days
(17 Reviews)
4.5
techdoo

expert here

$200 USD in 3 days
(2 Reviews)
4.3
pratyush23

ready to start immediately. Please see PM for more details

$200 USD in 5 days
(9 Reviews)
5.2
sanjayindrapuri

I am PHP/Wordpress Expert. I am Working Individually and also having team of experts. Lets discuss your project more in details. Ready to work with you.

$250 USD in 27 days
(33 Reviews)
4.1
on2it

on2itonline: Hi, KIWI Team here at on2itonline would love to work for you on this project, we do "full service" websites on a clear and fixed budget. We have lots of offer that others don't, like our lifetime FRE More

$400 USD in 20 days
(2 Reviews)
4.2
pranotosh

Hi, I'm a Web-developer and i can do this easily. Please consider my bid and let me start asap. Thanks

$100 USD in 3 days
(13 Reviews)
3.7