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
date selected in the calendar. column in the table are as follows:
- 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:
- 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 [url removed, login to view] 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
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
- 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
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:
5 freelancers are bidding on average $520 for this job
hello sir, i'm an experienced web and desktop programmer, i'm familiar with php, ajax, js, html, mysql, postgresql, and i'm very experienced with job like this, i'll send u a PM for more detail :)