BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /asterisk-stats/trunk/summary.php @ 1283

  → /asterisk-stats/trunk/summary.php @ 1284

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 1283 → Rev 1284

/asterisk-stats/trunk/summary.php
16,23 → 16,23
die('Hacking attempt!');
}
$db->query('SELECT COUNT(acctid), SUM(duration) FROM cdr WHERE date(calldate) = current_date');
$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(duration) FROM cdr WHERE calldate > (now() - (extract(dow from now()) || \' day\')::interval)');
$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(duration) FROM cdr WHERE EXTRACT(month FROM calldate) = EXTRACT(month FROM now())');
$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(duration) FROM cdr WHERE calldate > (now() - (extract(month from now()) || \' months\')::interval)');
$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(duration) FROM cdr');
$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))));