Can you add grouping of numbers in it (Let's say two companies have one FreePBX server, but the CDR has to be made for two seperate group of numbers)?

@mickecarlsson: The idea is - when you click on the CDR viewer, you can choose or make a group, which contains some extensions. And you can then view the CDR records only for the selected/made group.

I made small changes to support multiple regular expressions separated by a comma in the fields SRC/DST.
For example:
* src = '_2XXN, _562., _.0075' - src any of these numbers
* src = '_!2XXN, _562., _.0075' - src any other than these numbers

If it is normal for you, you can add this changes to the module.

Index: include/config.inc.php
===================================================================
--- include/config.inc.php (revision 50)
+++ include/config.inc.php (working copy)
@@ -170,7 +170,7 @@
$number = substr($number,1);
} elseif ( '_' == substr($number,0,1) ) {
$number_chars = preg_split('//', substr($number,1), -1, PREG_SPLIT_NO_EMPTY);
- $number = '^';
+ $number = '';
foreach ($number_chars as $chr) {
if ( $chr == 'X' ) {
$number .= '[0-9]';
@@ -187,7 +187,6 @@
}
}
$_POST[ $source_data .'_mod' ] = 'asterisk-regexp';
- $number .= '$';
}
return $number;
}
Index: index.php
===================================================================
--- index.php (revision 50)
+++ index.php (working copy)
@@ -116,7 +116,22 @@
}
break;
case "asterisk-regexp":
- $$key = "AND $key $pre_like RLIKE '$val[0]'";
+ $ast_dids = preg_split('/\s*,\s*/', $val[0], -1, PREG_SPLIT_NO_EMPTY);
+ $ast_key = '';
+ foreach ($ast_dids as $did) {
+ if (strlen($ast_key) > 0 ) {
+ if ( $pre_like == ' NOT ' ) {
+ $ast_key .= " and ";
+ } else {
+ $ast_key .= " or ";
+ }
+ if ( '_' == substr($did,0,1) ) {
+ $did = substr($did,1);
+ }
+ }
+ $ast_key .= " $key $pre_like RLIKE '^$did\$'";
+ }
+ $$key = "AND ( $ast_key )";
break;
case "begins_with":
default:

GOT IT!

You were on the right track, you just needed to swipe a little more code from a similar install.php. THIS worked:

// Update cdr database with did field
//
global $db;
global $amp_conf;
if (! function_exists("out")) {
        function out($text) {
                echo $text."<br />";
        }
}
$sql = "SELECT did FROM asteriskcdrdb.cdr";
$confs = $db->getRow($sql, DB_FETCHMODE_ASSOC);

Note that JUST adding "global $amp_conf;" did NOT do the trick, so the "out" function thing must have been the key.

The revised one installs fine.

Haven't tested playback of recordings because I've never actually had a reason to create a recording (I assume you mean a recoding of a call, and I don't even remember the code for that offhand), therefore there are none on the system, and I need to leave in a few minutes. Maybe later tonight I will give that a try.

Okay, I tested playback of recordings on a Mac (OS X 10.5.8) using Firefox, Safari, Chrome, and Opera. In Firefox, Safari and Chrome they played fine using the QuickTime plug-in. In Opera they played fine also although some of the controls were not available, for example you couldn't pause the recording. I think this may be an Opera or a QuickTime issue.

Also tested on Firefox, Chrome and Opera on Ubuntu Linux 10.10. In Firefox it plays fine there also, using the "Totem Browser Plug-In". In Chrome and Opera, it just says "Missing Plug-in" where the control should be. There's probably a fix for that, but since I don't use that system for web browsing I'm not going to worry about it, and I'm inclined to think it's not a problem with your software because a quick Google search tells me that a LOT of people have problems getting sound to play in Ubuntu, when using browsers other than Firefox (and Google Chrome users apparently even have issues getting sound to play under some versions of Windows, so there's that).

Ran into an issue testing the CDR Viewer on my PBX in a Flash setup FreePBX 2.9. If I raise the result limit to 10,000 or higher and check the export to CSV it crashes (after about 10 seconds). However if I try to do the 10,000 and only check the cdr search it works.

Thanks It works now without crashing. However took about 2 min on the system I am running. Bad thing is that I need to create a csv of our monthly call logs for reporting. So I went directly to the database and queried the past month August 1st through August 31 I have 62,000 + lines!!!! So any suggestions on a better way. I was testing making a cron job to query the DB and then upload it to my FTP but kept getting issues with too many arguments. Its been a long week so maybe I am missing something.. Thanks for the help in advance

That was 2+ minutes on the 10,000. The issue is that some months we may have 60,000 lines and others we may have 70,000 or even 80,000 lines. When I query the Database manually and email to my self it creates a ~13Meg file of all 60,000+ lines, in about 1 min and then I have it in my Personal Inbox (Not PBX Mailbox) within another minute or 2.

Something is causing a column shift with Lastapp and Lastdata Duration, Billable sec and proceeding columns are off. Looking into it.

Update:
lastapp column is shifting on us. Also clid is flowing over into src on rows with long clid's. Resulting in additional column shifts on certain rows.

Okay updated changes. Looks good everything matches up. I still have a few where half the clid goes into src. Further research shows that the clid has a "," in the name field. Thus when the function to separate the csv file is done it thinks it should be a new column.

Example
,

After doing a search in the Return Area.

Is it possible to show more info for Src Chan. or Dst Chan. like SIP/Ext# or Sip/Trunk without hovering over them. Currently mine says SIP unless I hover over it. For incoming calls I use ring groups and the Dest. says the ring group but the Dst Chan. is really the area I'm interested in it shows the ext the pickups the call in the ring group.

Thanks

Ran

In the Call Detail Record Search

The form option buttons are on the left for "Order By" and "Extra options" but the search conditions have them on the right it is confusing, at least to my brain I keep selecting the wrong option. I suggest putting them all on the left.

Thanks

Ran

I may be missing it but I don't see a way to show the total of call times. Say I want to know how many minutes ext 510 was on for today. Or multiple extensions in one report

The Call Graph by Day appears to do this I could run it for one extension twice. Once for incoming and one for outgoing then add them manually together. Repeat for all the extensions needed.

This is what I'd love to have I'd even be glad to donate some money.

1. Todays Outgoing total call count for a select "channel" or channels with the sum of the "billsec" for each "channel"
2. Todays Incoming total call count for a select "dstchannel" or dstchannels with the sum of the "billsec" for each "dstchannel"
3. Todays Sum of "incoming call count" and "outgoing call count" for Extension with the sum of outgoing_billsec and incoming_billsec

Example csv report output to one file:
-----------
#Outgoing
Extension, Call count, Billable Sec, Billable Minutes
500, 20, 375, 00:06:25
501
502
503
504
505

#Incoming
Extension, Call count, Billable Sec, Billable Minutes
500, 10, 180, 00:03:00
501
502
503
504
505

#Total
Extension, Call count, Billable Sec, Billable Minutes
500, 30, 555, 00:09:25
501
502
503
504
505

-----------

Thanks

Ran

Is there a more robust version available like a pro version at $$$

Gary.

Very clunky and maybe not cleanest way, but works for our purposes..

To add a 'Save' option for recordings...

edit cdr_play.php

Replace:

	if (isset($file)) {
		echo("<embed width='100%' type='audio/basic' src='modules/cdr/cdr_audio.php?cdr_file=" .$file. "' width=300, height=25 autoplay=true loop=false></embed><br>");
	}

With:

        if (isset($file)) {
                echo("<table><tr><td width=100%><embed width='100%' type='audio/basic' src='modules/cdr/cdr_audio.php?cdr_file=" .$file. "' width=300, height=25 autoplay=true loop=false></embed></td><td width=8></td><td><a href='modules/cdr/cdr_audio.php?cdr_file=" .$file. "' style='text-decoration: none;'>Save</a></td></tr></table>");
        }