Simple statistic script

This is an application for providing affiliate partners with statistics for calls made to asterisk server. It should consist of two parts: partner and admin part. Admin has the option of statistics and partners, while partners have only the option of Statistics. When a partner logs on, he only get menu 'statistics'. Click on the menu opens a submenu of three items 'daily', 'monthly', 'from-to'. Click on ‘daily statistics’ provides page with the following elements: - Title: Table of calls for day ______, partner _______ - On the right should stand the calendar which is selected the current date, and where can you select a different date for which statistics we want - A table that contains data from the current date and displays the data according to the date selected in the calendar. column in the table are as follows: - ext - During a call - Call time Click on the monthly statistics provide you with the following elements: - Title: Table of calls for the month of _______ , partner ______ - On the right side should be the calendar where the current month is selected, and where partner can change only by month (with left- right arrows or drop-downmenu) - Table showing data for the month that is currently selected in the calendar, and the following columns: - Date - ext - Number of calls - Total duration at the end of the table should stand as much rows as partner has assigned extensions and that each row shows sum total of calls for each of that extensions for selected [login to view URL] last line should have the sum total of all calls to all extensions assigned to the user. The item 'date' should be a link that could lead to daily statistics for the day. Clicking the 'from-to' statistics provide you with the following elements: - Title: Table of calls for the period from _______ to ________, partner _______ - On the right side should stand two calendars. The first would be for selecting starting date, the second would be for selecting ending date - A table that showed the statistics for a specific period would have the following columns: - day - ext - Number of calls - Total duration As with the monthly statistics Last rows should be a summary by the extensions,and the last row cumulative total of all extensions granted to the user. All this should follow the color coding. Select eg. 20 or so colors that would be used for marking extension (for example, the user can be granted 20 extensions, will not probably be more) and then the rows that are related to the given extensions paint in that color, but color has its lighter pair, so if there are several rows together, and refer to same extension, then they should be painted alternately darker and lighter shades. Eg. if you order in color: green, blue, yellow ... and if you assign to a bar, it will all bepainted in shades of green. If you assign two extensions, the first assigned extensionkoristis shades of green and other shades of blue and so on. The background may be a neutral. Or put it so I can change it, possibly to insert a jpg or similar. As for the Admin panel, it should have the following: All of the above as well as at partners, except that each table should have another column 'partner'. Admin statistics on it’s menu should also have the 'Monthly Report'. Monthly report should look like in the attached file and should have the option to export to pdf. ‘No. of calls’ column in monthly report should contain sum of calls for that day, and total duration should contain a sum total of durations of calls for that day. ‘Earnings’ column is ‘total duration’ multiplied by ‘cost of labour’. Value in cost of labour is for 1 min. Data for calls can be found in cdr table in attached database. --------------------------------------------------------------------------------------------------------------------------------- When the admin clicks on the 'partners' need to get a list of all partners (alternately painted, light, dark) in the table with the following columns: - user