| 16,26 → 16,23 |
|---|
| die('Hacking attempt!'); |
| } |
| |
| $db->query('SELECT COUNT(acctid), SUM(billsec) 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(billsec) 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(billsec) 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(billsec) 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(billsec) FROM cdr'); |
| $db->fetch_row_idx(); |
| $display->add_variables(array('CS_TOTAL' => $db->get_field(0), |
| 'CS_TOTAL_DUR' => Duration($db->get_field(1)))); |
| function add_summary($count_name, $dur_name, $interval) |
| { |
| 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)" : "")); |
| $db->fetch_row_idx(); |
| $display->add_variables(array($count_name => $db->get_field(0), |
| $dur_name => Duration($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); |
| |
| $display->add_template('summary'); |
| ?> |