Call Detail Records from Databse

IN PROGRESS
Bids
5
Avg Bid (AUD)
$250
Project Budget (AUD)
$30 - $250

Project Description:
My limit is AU$250. This project was started by someone who was unable to complete. I will send a copy of what has been produced so far to the winning bidder. You can either start from scratch of build on from what already exists.

I require a set of web pages written in PHP(and or html) and compatible with PHP version 5.3.2 upwards. The web pages will query a MySQL database and present information to users in different formats including tables and graphs. 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/exported as PDF or CSV.

When the web site is launched for the first time a page is to be presented asking for all the relevant details. Database name, tables, username and password etc. See attached file for database structure.

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 based on the columns available in the tables.
An admin page to add, edit, delete authorised users to the site.
User just view.
Admin add/edit/delete users.


Home Page
-------------------------------------------------------
Displaying todays details of Call statistics
Total Calls
Maximum Simultaneous Calls.
Average Calls Per Hour
Minutes Total Duration
Minutes Average Call Duration

CDR Search Reports
-------------------------------------------------------
With search options like this -> http://www.testforme.com/images/freelancer-cdr/cdr%20reports.PNG
With output that the user can customize the columns based on the MySQL table columns.


Concurrent Calls
-------------------------------------------------------
Showing
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 -> http://www.testforme.com/images/freelancer-cdr/daily.PNG
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
-------------------------------------------------------
With the output showing per month:
Default to last 12 months.
total calls in minutes
total calls in volume, i.e. number of calls

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 too difficult to install and is virtually impossible. This site is available at http://demo.cdr-stats.org:9000/show_concurrent_calls/ use demo as the username and password. There is no data so it is hard to get a feel. Images are available from http://www.cdr-stats.org/screenshot/

My goal 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 search features.

I would like to create two versions. A lite version and an enterprise version. The lite version will not include simultaneous call information, multiple tables or PDF output. The lite version will include a PayPal donation link on the home page.

I currently have a web site called acdr.com.au that I would also like created where people can find out about this product, how to install, donate using PayPal and purchase the enterprise version.

Skills required:
HTML, Linux, MySQL, PDF, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 250
in 12 days
$ 250
in 15 days
$ 250
in 20 days
Hire KP63iFH8g
$ 250
in 1 days
$ 250
in 20 days