Need a PHP (PEAR/Smarty) script to display the call detail records (CDR) online

Need a PHP (PEAR/Smarty) script to display the call detail records (CDR) online We need our users to be able to view the call details from their account. The CDRs are stored in a Postgres DB (Mysql programers may bid). I need the reports to show the call log details for a specific number tied to an account. Call Log Report from = 5558384835 from = 5558384836 Sort by calldate Display these fields from the table: calldate, src, dst, duration, disposition

## Deliverables

Example SQL query: SELECT calldate AS CallDate, src AS From, dst AS To, duration AS Duration, disposition AS status FROM cdr WHERE dst = '5558384835' AND hostname = 'vs00' AND accountcode = '233800' AND calldate BETWEEN '2005-10-01 00:00:00' AND '2005-10-31 00:00:00' ORDER BY calldate LIMIT 30 OFFSET 0 The variables passed to above SQL string should be accountcode, dst, between dates and offset The report should default to listing 30 records at a time with Prev/Next (Prev 1 2 3 4 Next) buttons available. The report should be downloadable as well in CSV format, all records. Process: 1. User logs in to site (see comments below) 2. User select the report they would like a. Report based on number i. 5558384835 ii. 5558384836 3. Report generates the following output: Number: 2068384835 Account Code: 233800 Call Date From To Duration Status 10/1/2005 0:18 2145218490 2068384835 1760 ANSWERED 10/1/2005 0:35 8585608676 2068384835 694 ANSWERED 10/1/2005 0:43 3612280042 2068384835 846 ANSWERED 10/1/2005 0:58 3612280042 2068384835 155 ANSWERED 10/1/2005 1:53 3612280042 2068384835 416 ANSWERED 10/1/2005 5:38 6057793221 2068384835 21 ANSWERED 10/1/2005 5:54 6057793221 2068384835 18 ANSWERED 10/1/2005 6:10 8043803637 2068384835 25 ANSWERED 10/1/2005 6:11 8043803637 2068384835 21 ANSWERED 10/1/2005 6:16 8043803637 2068384835 18 ANSWERED 10/1/2005 6:21 6785570911 2068384835 27 ANSWERED 10/1/2005 6:22 6785570911 2068384835 23 ANSWERED 10/1/2005 6:41 6309224538 2068384835 21 ANSWERED 10/1/2005 6:55 2157234743 2068384835 25 ANSWERED 10/1/2005 7:01 6463832503 2068384835 21 ANSWERED 10/1/2005 7:18 9546085338 2068384835 30 ANSWERED 10/1/2005 7:33 8456887503 2068384835 30 ANSWERED 10/1/2005 7:42 8043803637 2068384835 17 ANSWERED 10/1/2005 7:48 3019432162 2068384835 29 ANSWERED 10/1/2005 7:51 3019432162 2068384835 21 ANSWERED 10/1/2005 8:00 6174383317 2068384835 18 ANSWERED 10/1/2005 8:27 3019432162 2068384835 17 ANSWERED 10/1/2005 8:36 8605331738 2068384835 27 ANSWERED 10/1/2005 8:41 8605331738 2068384835 26 ANSWERED 10/1/2005 8:49 5857564800 2068384835 23 ANSWERED 10/1/2005 8:54 2487379374 2068384835 20 ANSWERED 10/1/2005 8:58 2256144956 2068384835 3 ANSWERED 10/1/2005 9:08 9173672185 2068384835 30 ANSWERED 10/1/2005 9:09 8478843835 2068384835 22 ANSWERED 10/1/2005 9:11 2129631234 2068384835 27 ANSWERED << < …1 2 3 4 5 … > >> 4. The second report needs to generate a number of calls received per hour Daily, Weekly, Monthly. Example (Daily): Wednesday 11/1/2005 Time No. Calls 6AM - 7AM 0 7AM - 8AM 6 9AM - 10AM 16 10AM - 11AM 23 12AM - 1PM 35 1PM - 2PM 77 2PM - 3PM 57 3PM -4PM 66 4PM - 5PM 43 6PM - 7PM 22 8PM - 9PM 8 10PM - 11PM 0 11PM - 12AM 0 Similar report for Weekly but showing actual totals for each hours Similar report for Monthly but showing actual totals for each hours Notes: • Winning bidder will receive credentials for accessing the cdr database on our Postgres SQL server. • The account code can not be displayed in the html forms or URL. This necessary from user entering different account codes. • CSS and return links will be added by use in the Smarty template. • PHP code must use PEAR and Smarty templates • The Prev/Next links should only show 5 pages at a time. The number of records displayed should be 30 • There are two pieces of functionality that is not ready. Authentication Need to use a text file (db will be added later, separate project) Group Table The from field should be referenced via a table. However, this is not complete so a text file will need to be used. (The DB portion will be another project) 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Postgres 7.4 PHP 4.4 IE and Firefox Windows XP

Administrasi Basis Data Teknik MySQL PHP Perancangan Perangkat Lunak Pengujian Perangkat Lunak SQL

ID Proyek: #3068513

Tentang proyek