ВОПРОС: Подскажите, пожалуйста, есть ли какой-нибудь удобный интерфейс для прослушивания записанных звонков? ОТВЕТ: Asterisk-Stat : CDR Analyser
Asterisk-Stat is providing different reports & Graph to allow the Asterisk-admin to analyse quickly and easily the traffic on their Asterisk server.
All the graphic & reports are based over the CDR database.
LAST RELEASE : V2.0.1 (07 March 2005)
FEATURES :
- - CDR REPORT (MONTHLY or DAILY)
- - MONTHLY TRAFFIC
- - DAILY LOAD
- - COMPARE CALL LOAD WITH PREVIOUS DAYS
- - MANY CRITERIAS TO DEFINE THE REPORT
- - EXPORT CDR REPORT TO PDF
- - EXPORT CDR REPORT TO CSV
- - SUPPORT MYSQL & POSTGRESQL
- - MANY OTHERS :)
- - APACHE / HTTP SERVER
- - PHP
- - POSTGRESQL OR MYSQL
- - PHP-PGSQL OR PHP-MYSQL
- - NEED GD LIBRARY
- - JPGRAPH_LIB (included)
- - IMPROVE SPEED RESULT WITH INDEX:
POSTGRESQL : CREATE INDEX calldate_ind ON cdr USING btree (calldate)
MYSQL : ALTER TABLE `cdr` ADD INDEX ( `calldate` ) - - [OPTIONAL]
POSTGRESQL : CREATE INDEX dst_ind ON cdr USING btree (dst)
POSTGRESQL : CREATE INDEX accountcode_ind ON cdr USING btree (accountcode)
MYSQL : ALTER TABLE `cdr` ADD INDEX ( `dst` )
MYSQL : ALTER TABLE `cdr` ADD INDEX ( `accountcode` )
- - PSQL (PostgreSQL) 7.2.4
- - MYSQL Ver 11.18 Distrib 3.23.5
Edit defines.php files
- WEBROOT: This is the root URL of the application.
Example: http://youdomain.com/asterisk-stat/ - FSROOT: This is the server path which contain the application.
Example: /home/users/asterisk-stat/ - HOST: This is the Database host name.
Example: localhost - PORT: Database port.
Example: 5432 - USER: Username to access to the database.
Example: username - PASS: Database password of the user.
Example: password - DBNAME: Name of the Database.
Example: asteriskcdr - DB_TYPE: Database type.
support: mysql and postgres - DB_TABLENAME: Table of the database containing the CDR.
Example: cdrtable - appli_list: PHP array used to associate extension to a name. This can be useful if you want to give more signification during the CDR browsing
$appli_list['4677']=array("Voicemail");
$appli_list['6544']=array("Conference-MeetMe");
DOWNLOAD :
TAR-GZ : asterisk-stat V 2.0.1If you have comments or ideas to improve the CDR-ANALYSER, please drop me an email :)