Project Description:
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(sbinvl.total)as this_year_sales , sum(sbinvl.total-(sbinvl.qty*sbinvl.cost))as this_year_GP
from sbinvl
left join sbinvh
ON sbinvl.ordernumber = sbinvh.ordernumber
left join sbstk
on sbstk.stockcode = sbinvl.stockcode
left join sisov1contacts
on sbstk.suppliercode = sisov1contacts.custom1
where year(sbinvl.invoicedate) = '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
