In Progress

web based CDR Reporting software

Designer Skillset required: essential: PHP, MySQL, SQLite, HTML5, Ajax (knowledge of Linux and Asterisk/Elastix a bonus but not essential.)

(NOTES TO BIDDERS: PLEASE DO NOT APPLY if you do not have a provable high skill set in the above areas mentioned. You will also need to provide some kind of previous examples of work done and also a static office location address and phone number to confirm eligibility

Time constraints are - If you agree to the project and we accept your bid then it will need to be completed within 1.5 month and preferably sooner)

I need you to design a web based CDR reporting system that will run on a standalone LAMP server. It should provide real-time output to browser sessions that will also be viewed on LCD screen plugged into a PC. There will be multiple pages that can be set to rotate in the browser window at a configurable automated rate and refresh the data at 5 second intervals.

The real-time CDR information has two sources on a seperate Elastix 2.3 (Asterisk 1.8 based) PBX server that is running Centos 5.8.

1. MySQL database 'asteriskcdrdb' - available through a port on the Elastix PBX server provides CDR records for each call as it is terminated.

2. SQLite database '/var/www/db/[url removed, login to view]' provides user & dept information mapped to an extension number which will serve as the Key ID to relate this data to the asteriskcdrdb data.

Calculations will need to be performed on this data prior to being displayed. Data format for call times and duration is generally in date & time format, or in seconds stored as an integer. There may be the need for timezone calculations to be performed on the data, though this may be set at source, TBC.

Data format for Ext and User are in text or general format. It may be easiest to create a new SQL database from the two sources and use that for calculations rather tha run it using PHP in the web design. We can discuss this aspect.

OUTPUT:

The purpose of this CDR reporting system is to provide x4 informational output options:

1. Browser session for Dept Managers to see their teams call records on their PC's.

2. LCD screen output of same browser session for all extensions for staff to see on the main office floor.

3. Export browser page information to csv/xls/pdf files for analysis.

4. Export browser page information to csv/xls/pdf file that is emailed to an input address.

ADDITIONAL REQUIREMENTS:

- a pop-up settings bar on the bottom of the screen to enable per browser session control;

- screen switch speed setting (1-5 or paused)

- drop down check-button list of screens visible

- drop down check-button list of departments for limiting extensions that will be viewed in each screen & also reports.

- calculations on data will be required before being sent to browser page fields.

- see the attachments for fields required.

- will need to calculate unique dialed numbers per extension.

precise details of the job to be discussed with the winning bidder. (more details are also available in the attached PDF file)

I can provide backend work on the servers and help with the solution but my web design and MySQL skills are not up to scratch to do this myself.

The attached files show a guide only idea for the pages to display. Again precise details to be discussed with winning bidder.

I am open to suggestions to change methods.

This will be an ongoing project and future expansion to designing charts and further additional features will definitely be in the pipeline so hopeully it will lead to more work together. This is for production servers that are currently live but I can provide a test environment as needed.

I would prefer it to be in HTML5 and Ajax to take advantage of the latest technologies.

Any questions let me know. If the price seems in-correct I am happy to discuss reduction of the project requirements for a person with a highly sophisticated skill-set. I dont believe this is a very difficult or complex job for someone with the skills listed.

Skills: AJAX, Asterisk PBX, HTML5, MySQL, PHP

See more: can create web based cdr asterisk, php based cdr, www sql designer, web production designer, web page design setting, web page design price list, web page design notes, web office live, web notes technologies, web design software with database, web design software list, web design skill, web design project list, web design options, web design new idea, web designing price list, web designing information, web design information in pdf, web designer skills list, web designer skill, web designer price list, web designer pdf, web designer open source software, web designer job available, web designer in linux

About the Employer:
( 2 reviews ) Sydney, Australia

Project ID: #4030397

Awarded to:

canlan318

Hi, i am ready to start your project.

$600 AUD in 10 days
(68 Reviews)
6.8

11 freelancers are bidding on average $717 for this job

Webwingtechology

Dear Sir, Kindly Check PMB, For further discussion of your Project In Details... Many Thanks, Nikhil Pawar Webwing Technologies PVT Limited Business Development Executive

$1350 AUD in 35 days
(19 Reviews)
6.4
sssrihari

Hi, Please check your inbox. Thanks !

$500 AUD in 7 days
(13 Reviews)
5.6
webangel1

your search ends here... please check pmb thank you..

$900 AUD in 30 days
(21 Reviews)
4.5
scinova

Please check your inbox. Thanks.

$450 AUD in 5 days
(6 Reviews)
4.5
shabdullah88

Dear sir After reading your project details,we are interested in this project and would like to bid on this project. we take care of our every client personally and has always long term [url removed, login to view] will do as many More

$1000 AUD in 25 days
(7 Reviews)
3.5
pragyaatech

can complete the project perfectly.

$750 AUD in 10 days
(3 Reviews)
3.0
VR26

We are a Web design and development company that focuses on regular communication with our clients and timely delivery for all our projects. Some of the technologies/area that we focus include:

$300 AUD in 15 days
(2 Reviews)
2.0
IPq6F2Z4s

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. www.<b><i>Removed by Admin</i></b>

$500 AUD in 1 day
(0 Reviews)
0.0
Vtelcomsac

We have developments for realtime asterisk cdr and queuelog with MySQL or Postgrest The solution is in java.. this for best performance. We develop like you need and 0 risk Check the url for an example: http More

$789 AUD in 2 days
(0 Reviews)
0.0
avissol

*******7+ years of experience ******* Kindly, check the PMB. Regards, karan

$750 AUD in 22 days
(0 Reviews)
0.0