I added an option to show only incoming or outgoing calls. This is done by looking at the src (incoming caller ID) and checking to see if the length is less than or greater than 6. All 6 digit numbers, or less, can be used internally. All 7 digit numbers, and higher, can be outside calls. It's a silly way to do it, but it works for me. Alternatively, you could check to see if the src was higher than the highest extension you have in your extensions.conf/situation. In which case LENGTH() would not be used, but rather src > 300 (if all of your extensions are under 300).

http://pastebin.ca/1208529

Here's my updated PHP file. I added coloring to the rows based on $FG_MIN_BILLING_SEC. Right now it's set to 3, so anything less than that will be colored a pinkish red to show that it's a short call. Also includes the changes below.

http://pastebin.com/f442f7c4d

I have a few things I want to add to this, such as make the background color of a line red/different if the call time is 0 or under 2 seconds, etc.

Add the following to call_log.php:
In the getpost_ifset() array, add 'disposition' at the end.

add the the following under getpost_ifset():

$filteranswer=''; //Global variable used to check if the user wants to filter some calls.

Add the following under the if/else block below $date_clause='';:

if ($disposition=='1') {
//Show only Answered calls.
$filteranswer = ' AND Disposition = "ANSWERED" ';
}
if ($disposition=='2') {
//Show only Not Answered calls.
$filteranswer = ' AND Disposition = "NO ANSWER" ';
}

Add the following under if ($posted==1){:

$FG_TABLE_CLAUSE .= $filteranswer; //Concatenate our disposition (Answered/Not answered) to the table clause.

add the following below the </tr> under the DURATION table:

<tr>
<td align="left" bgcolor="#000033">
<font face="verdana" size="1" color="#ffffff"><b>&nbsp;&nbsp;DISPOSITION</b></font>
</td>
<td align="left" bgcolor="#acbdee">
<table width="80%" border="0" cellspacing="0" cellpadding="0"><tr><td><INPUT TYPE="radio" NAME="disposition" value="3" <?if!isset($disposition||($disposition==3)){?>checked<?}?>><font size="2">All</font></td>
<td><INPUT TYPE="radio" NAME="disposition" value="2" <?if($disposition==2){?>checked<?}?>><font size="2">Not Answered</font></td>
<td><INPUT TYPE="radio" NAME="disposition" value="1" <?if($disposition==1){?>checked<?}?>><font size="2">Answered</font></td></tr></table>
</tr>

That should do it. Hope this looks ok.

you can make the graphs work with PHP5 by downloading the latest version of jpgraph and dropping the source files in the jpgraph_lib directory. alternatively, downgrade to PHP4...

Thanks for a great utility. We use it bundled with FreePBX and TrixBox. We needed to be able to listen to the recording of the call, if it was available. We created a patch that allows this, in conjunction with the ARI package by Little John Consulting (also included with TrixBox). If you have a need for this, you can download it from our website. Perhaps it could get added into the main code base at some time.
<p>
<a href="http://insightsys.com/freepbx/">http://insightsys.com/freepbx/</a>

Hi
I find this package a GREAT utility.
small bug: if the name of billing table is different than "cdr" then utility fails, while in one place "cdr" is hardcoded.
To fix it just change the line:

$QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)";

to

$QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM $FG_TABLE_NAME WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)";

There seems to be a problem with watch call graph with PHP5/Postgres SQL.

WP

Is there a way to get the stat package to show graphs, etc of incoming calls only? I've tried every way, can't seem to figure it out.....

This great app counts call time in the wrong way. Try to call to this context:

Answer
Wait(10)
Dial(somewhere)

And in Areski CDR you will see call length ~= actual call + 10s

Because this app counts not real call time between call parties, but the time between caller ant the system.

Fix:

In files:

call-comp.php
call-daily-load.php
call-last-month.php
call-log.php

In line:

$FG_COL_QUERY='calldate, channel, src, clid, lastapp, lastdata, dst, dst, disposition, duration, userfield, accountcode';

Change 'duration' to 'billsec'

Mindaugas