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.
Dashboard
-------------------------------------------------------
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 -> [login to view URL]
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 -> [login to view URL]
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 -> [login to view URL]
With the output showing:
total calls in minutes
total calls in volume, i.e. number of calls
Table Structure
-------------------------------------------------------
CREATE TABLE cdr (
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 [login to view URL] use demo as the username and password. There is no data so it is hard to get a feel. Images are available from [login to view URL]
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.
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(freelancer.com) so that's why I put a low initial payment. I am able to provide you with a working demo within 3 days(not all the features will be done though). I am good to go.
Looking foward to working with you.
Kind regards
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.
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 website developer, and you appear pleased with the results I have produced. It would be an honor to give you that same satisfaction once more! I do have a few minor questions concerning the project itself, but I will ask those via private messaging. Until then, I hope to be working with you soon!
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