In Progress

Present Call Detail Records from MySQL

I require a set of web pages written in PHP and compatible with PHP version 5.3.2 and upwards. The web pages will query a MySQL database and present information to users in different formats including tables. I require the dependencies to be limited as much as possible and everything to be accomplished through PHP if possible. The web pages will require output to screen and an option to be saved as PDF or CSV and downloaded.

Some of the functions that I require are:

Configuration Page


Allow users to enter MySQL connection details. Host, Database, Table, Username, Password

Allow users to select what columns should be outputted on CDR searches

Allow users to enable/disable a daily summary at the end of their search.

An admin page to add, edit, delete authorised users to the site.



Displaying todays details of Call statistics

Total Calls

Average Calls Per Hour

Minutes Total Duration

Minutes Average Call Duration

CDR Search Reports


With search options like this -> [url removed, login to view]

With output that the user can customize the columns based on the MySQL table columns.

Concurrent Calls



Concurrent calls by day for a specific date range

Concurrent calls by hour for a specific day

Concurrent calls by day for a particular month

Concurrent calls by month for the last 12 months, min, max and average concurrent calls

Daily Traffic Load


Something like this -> [url removed, login to view]

By date searchable by destination, source, channel with the destination and source fields able to be searched with equal to, begins with, contains or ends.

Monthly Traffic


Something like this -> [url removed, login to view]

With the output showing:

total calls in minutes

total calls in volume, i.e. number of calls

Table Structure



calldate datetime NOT NULL default '0000-00-00 00:00:00',

clid varchar(80) NOT NULL default '',

src varchar(80) NOT NULL default '',

dst varchar(80) NOT NULL default '',

dcontext varchar(80) NOT NULL default '',

channel varchar(80) NOT NULL default '',

dstchannel varchar(80) NOT NULL default '',

lastapp varchar(80) NOT NULL default '',

lastdata varchar(80) NOT NULL default '',

duration int(11) NOT NULL default '0',

billsec int(11) NOT NULL default '0',

disposition varchar(45) NOT NULL default '',

amaflags int(11) NOT NULL default '0',

accountcode varchar(20) NOT NULL default '',

uniqueid varchar(32) NOT NULL default '',

userfield varchar(255) NOT NULL default ''


There are already two web based applications that do some of these things. One of them no longer works with the later version of PHP. If you are shortlisted I can give you access to the site for review as it has live data.

The second application is way to difficult to install and is virtually impossible. This site is available at [url removed, login to view] use demo as the username and password. There is no data so it is hard to get a feel. Images are available from [url removed, login to view]

My objection is to get a simple PHP web based application if possible so people can easily copy and install the PHP files into their web server and be operational in minutes.

Please note, as this site evolves/develops there may be some changes to the above requirements, mostly adding additional searches.

Skills: HTML, Linux, MySQL, PDF, PHP

See more: concurrent calls average call duration total calls, mysql cdr concurrent calls hour, average call duration mysql, mysql concurrent calls, what is people per hour, what freelancer changes, what are the functions of a freelancer, what are the application of data structure, traffic volume freelancer, total freelancer users, summary in freelancer, statistics from www freelancer com, shortlisted freelancer, search for a destination or search the web, range query, php works at freelancer, php pdf freelancer, php and mysql pdf, php and mysql connection, people from above, people by hour, pages from freelancer, operational statistics, mysql org, min range

About the Employer:
( 2 reviews ) Springfield Lakes, Australia

Project ID: #1287089

16 freelancers are bidding on average $486 for this job


pls chk pmb

$875 AUD in 7 days
(570 Reviews)

I can deliver the coding for the same

$480 AUD in 6 days
(96 Reviews)

Hello, We are ready to start your project immediately. For more details please read the PMB... Thank you!

$750 AUD in 20 days
(5 Reviews)


$700 AUD in 45 days
(6 Reviews)

Hi I have experience in PHP and I can produce a quality piece of art. I have understood the requirements and gone through the application on the URL you provided. I have not done much work on this site([url removed, login to view] More

$480 AUD in 10 days
(8 Reviews)

Hi Mr, really clear request I would like to help with youur project I have been working with cdr data and voip systems for many years I hope I can help you with your request. Thanks for the attention.

$250 AUD in 15 days
(6 Reviews)

Ready to start right now.

$500 AUD in 10 days
(13 Reviews)

Placing bid

$500 AUD in 25 days
(7 Reviews)

I can help you on this work. I have much experience on PHP, Mysql and Java. I can provide you a high quality work in one month!

$750 AUD in 25 days
(2 Reviews)

Hi, sir! From our past cooperation, you should be aware of my attitude towards projects. I am dedicated to work, quick to complete tasks, and easy to communicate with. Above all, I am a very competent, organized websit More

$250 AUD in 30 days
(3 Reviews)

We've got experience at this field of work.

$350 AUD in 15 days
(1 Review)

Hello I have a experience of about 2 years in webdevelopment. I would like to do this work Please check PM for details Regards Multani

$450 AUD in 30 days
(0 Reviews)

Hello sir, We are ready to work. Please check PMB.

$570 AUD in 12 days
(0 Reviews)

Hello, I have a fair amount of experience using php to pull from a mysql database and display the results on a webpage. Please get in touch if you would like to discuss this further. Thanks! DS

$450 AUD in 7 days
(0 Reviews)

We are interested to do this job, because in past we are experienced on this kind of job...

$500 AUD in 10 days
(0 Reviews)

Please check PMB.

$500 AUD in 10 days
(0 Reviews)

Hello Please Check PMB

$250 AUD in 20 days
(0 Reviews)

Please check PMB

$400 AUD in 20 days
(0 Reviews)