In Progress

PHP pages to display supplier info for company intranet

I am looking for someone to create 2 php webpages for me.

The pages should be clear, mostly in white but with the colours from our logo.

I will provide the logo and mysqldump file for testing.

You will have to provide the html , php and mysql queries.

You will have to point me to where to change the mysql connection info.

The pages will be used to query our mysql server and extract data on our suppliers performance.

FIRST PAGE

This page should display a ranking of all suppliers by sales with the ability to change the date range to change the data. We should also be able to sort by Name, Sales, Gross Profit and increase/decrease from last year. Whenever I change the dates the page should refresh.

Headings – Supplier, Sales , Gross Profit , Margin (profit/sales), Sales last year , Gross profit last year , margin last year, This_year_sales – last_year_sales , This_year_gross_profit – last_year_gross_profit

Here is a bit of the query to help you get started

select suppliercode,company ,sum([url removed, login to view])as this_year_sales , sum(sbinvl.total-([url removed, login to view]*[url removed, login to view]))as this_year_GP

from sbinvl

left join sbinvh

ON [url removed, login to view] = [url removed, login to view]

left join sbstk

on [url removed, login to view] = [url removed, login to view]

left join sisov1contacts

on [url removed, login to view] = [url removed, login to view]

where year([url removed, login to view]) = '2011'

group by suppliercode

The negative figures should be in red and positive green.

SECOND PAGE

I want to be able to click on a supplier to view the stock codes for the chosen supplier in the same layout. This should launch another page listing the stockcodes with the same headings.

Again ,The negative figures should be in red and positive green.

This report should be print friendly

Skills: HTML, MySQL, PHP, Website Design

See more: where to get logo design, where to get company logo, where to get a company logo, where to design logo, want to create a website for company, total company logo, to create a company logo server, the data supplier, red point, range query, php codes for website design, php and mysql no codes, php and mysql connection, negative logo design, looking for supplier, logo refresh design, logo design query, logo design for report, i want someone to create me a logo, i want someone to create a website for me, intranet logo design, html codes to create website, html codes for website, help to create a company logo, get logo for company

About the Employer:
( 5 reviews ) wick, United Kingdom

Project ID: #1110864

Awarded to:

linglom

Please see PM.

£60 GBP in 1 day
(16 Reviews)
3.9

18 freelancers are bidding on average £113 for this job

sanjay2004

Professional developers with similar expertise here. We are posting our bid as an expression of interest and appreciate further discussion in private message board. We are waiting for your message to communicate furthe More

£151 GBP in 7 days
(1157 Reviews)
9.9
zeke

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

£100 GBP in 1 day
(169 Reviews)
7.0
netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

£80 GBP in 1 day
(93 Reviews)
6.8
shuiwatermizu

please see pm

£100 GBP in 0 days
(96 Reviews)
6.4
expertonphp

PLEASE CHECK YOUR INBOX TO SEE MY BID DETAILS, LETS START. THANKS!!

£100 GBP in 5 days
(100 Reviews)
6.1
ashwin86

Please check pmb for further details

£200 GBP in 4 days
(66 Reviews)
6.1
allroundexperts

Please check PMB

£140 GBP in 4 days
(113 Reviews)
5.6
muhammadghasan

hi, Please Check your PMB, thanks

£150 GBP in 5 days
(30 Reviews)
5.4
aukint

Hey, Greetings from AukInternational. ****Please check your Inbox****

£120 GBP in 5 days
(47 Reviews)
5.4
twr1965

Please see pm

£60 GBP in 2 days
(13 Reviews)
4.6
jewelhuq

I can do it

£50 GBP in 5 days
(21 Reviews)
4.6
univane

Kindly check PM

£250 GBP in 10 days
(23 Reviews)
4.4
thenightcoder

Easy job. Could start now. Terms in PM.

£100 GBP in 2 days
(4 Reviews)
2.2
rajzana

i am ready to complete your project.

£40 GBP in 2 days
(0 Reviews)
0.0
focussedme

Hello Sir. I want to work on this project. I will build clear and easy to use webpages for you.I will provide you satisfactory work. Give me an opportunity to work for [url removed, login to view] you.

£40 GBP in 3 days
(2 Reviews)
0.0
ankuraren4u

Please Check your PMB

£120 GBP in 4 days
(0 Reviews)
0.0
swamis71

Please check the pm

£180 GBP in 5 days
(0 Reviews)
0.0