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 [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


- 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

Skills: PHP

See more: statistic script, parts database example, pair line, min cost, extension colors, yellow page script, shades, pdf script, ext, Day Light, blue found, data statistic, table jpg, neutral, rows insert, panel parts database, change color background color php, script refer, statistic number export, asterisk extension number

About the Employer:
( 19 reviews ) Sremska Kamenica, Serbia

Project ID: #1244582

5 freelancers are bidding on average $520 for this job


hi. can do it, but it can have issues depend of ur current setup.

$1000 USD in 10 days
(91 Reviews)

Specialized web programming company with 12 years of experience.

$500 USD in 12 days
(2 Reviews)

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 :)

$250 USD in 10 days
(0 Reviews)

Hi sr, i can start working.

$400 USD in 14 days
(0 Reviews)

hi sir im willing to do this work for you in minimum time with a high quality work with ur 200% satisfaction.i have 3 years of experience in cms,seo,php ,mysql,templates desings,android apps etc. please consider my More

$450 USD in 15 days
(0 Reviews)