| 0,0 → 1,41 |
|---|
| <?php |
| #################################################### |
| # AstWeb - Asterisk PBX Dynamic config environment # |
| # # |
| # Written by: Jamie Carl # |
| # jazz@funkynerd.com # |
| # # |
| # Copyright (C) 2006 Achieve Corp # |
| # # |
| # Licence: This software is licenced under the # |
| # GNU/GPL. Please see licence.txt for # |
| # more information. # |
| #################################################### |
| |
| if(!defined('IN_ASTWEB')) { |
| die('Hacking attempt!'); |
| } |
| |
| $db->query('SELECT COUNT(acctid), SUM(duration) FROM cdr WHERE date(calldate) = current_date'); |
| $db->fetch_row_idx(); |
| $display->add_variables(array('CS_TODAY' => $db->get_field(0), |
| 'CS_TODAY_DUR' => Duration($db->get_field(1)))); |
| $db->query('SELECT COUNT(acctid), SUM(duration) FROM cdr WHERE calldate > (now() - (extract(dow from now()) || \' day\')::interval)'); |
| $db->fetch_row_idx(); |
| $display->add_variables(array('CS_WEEK' => $db->get_field(0), |
| 'CS_WEEK_DUR' => Duration($db->get_field(1)))); |
| $db->query('SELECT COUNT(acctid), SUM(duration) FROM cdr WHERE EXTRACT(month FROM calldate) = EXTRACT(month FROM now())'); |
| $db->fetch_row_idx(); |
| $display->add_variables(array('CS_MONTH' => $db->get_field(0), |
| 'CS_MONTH_DUR' => Duration($db->get_field(1)))); |
| $db->query('SELECT COUNT(acctid), SUM(duration) FROM cdr WHERE calldate > (now() - (extract(month from now()) || \' months\')::interval)'); |
| $db->fetch_row_idx(); |
| $display->add_variables(array('CS_YEAR' => $db->get_field(0), |
| 'CS_YEAR_DUR' => Duration($db->get_field(1)))); |
| $db->query('SELECT COUNT(acctid), SUM(duration) FROM cdr'); |
| $db->fetch_row_idx(); |
| $display->add_variables(array('CS_TOTAL' => $db->get_field(0), |
| 'CS_TOTAL_DUR' => Duration($db->get_field(1)))); |
| |
| $display->add_template('summary'); |
| ?> |