Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1381 → Rev 1382

/asterisk-stats/trunk/includes/summary.php
12,16 → 12,18
# more information. #
####################################################
 
function add_summary($count_name, $dur_name, $interval)
function add_summary($count_name, $dur_name, $interval, $diff = NULL)
{
global $db, $display;
 
$db->query("select count(acctid), sum(billsec) from cdr where" . BaseQuery()
. ($interval ? " and date_trunc('" . $interval . "', calldate) = date_trunc('"
. $interval . "', current_date)" : ""));
$query = "select count(acctid), sum(billsec) from cdr where" . BaseQuery()
. ($interval ? " and date_trunc('" . $interval . "', calldate)"
. ($diff ? " + interval '$diff $interval'" : "") . " = date_trunc('"
. $interval . "', current_date)" : "");
$db->query($query);
$db->fetch_row_idx();
$display->add_variables(array($count_name => $db->get_field(0),
$dur_name => Duration($db->get_field(1))));
$dur_name => FormatDuration($db->get_field(1))));
}
 
# active calls
29,13 → 31,14
. " from activecalls where" . BaseQuery() . " and duration is null");
$db->fetch_row_idx();
$display->add_variables(array('CS_ACTIVE' => $db->get_field(0),
'CS_ACTIVE_DUR' => Duration($db->get_field(1))));
'CS_ACTIVE_DUR' => FormatDuration($db->get_field(1))));
 
add_summary('CS_TODAY', 'CS_TODAY_DUR', 'day');
add_summary('CS_WEEK', 'CS_WEEK_DUR', 'week');
add_summary('CS_MONTH', 'CS_MONTH_DUR', 'month');
add_summary('CS_YEAR', 'CS_YEAR_DUR', 'year');
add_summary('CS_TOTAL', 'CS_TOTAL_DUR', null);
add_summary('CS_TODAY', 'CS_TODAY_DUR', 'day');
add_summary('CS_WEEK', 'CS_WEEK_DUR', 'week');
add_summary('CS_LAST_WEEK', 'CS_LAST_WEEK_DUR', 'week', 1);
add_summary('CS_MONTH', 'CS_MONTH_DUR', 'month');
add_summary('CS_YEAR', 'CS_YEAR_DUR', 'year');
add_summary('CS_TOTAL', 'CS_TOTAL_DUR', null);
 
$display->add_template('summary');
?>