Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1365 → Rev 1366

/asterisk-stats/trunk/cdr.php
34,7 → 34,7
elseif(array_key_exists('s', $_GET) || array_key_exists('list', $_GET)) {
function do_field($sql, &$params, $fld) {
if ($fld && $_GET[$fld]) {
$sql .= " AND $fld";
$sql .= " and $fld";
if (array_key_exists($fld.'type', $_GET)) {
$dType = $_GET[$fld.'type'];
switch ($dType) {
63,7 → 63,7
}
 
# Construct Query Here
$query = "";
$query = BaseQuery();
$params = array();
 
if ($_GET['before']) {
84,17 → 84,17
$query_limit = '';
if(array_key_exists('list',$_GET)) {
switch($_GET['list']) {
case 'year': $query .= " AND date_trunc('year', calldate) = date_trunc('year', current_date)"; break;
case 'month': $query .= " AND date_trunc('month', calldate) = date_trunc('month', current_date)"; break;
case 'week': $query .= " AND date_trunc('week', calldate) = date_trunc('week', current_date)"; break;
case 'today': $query .= " AND date_trunc('day', calldate) = date_trunc('day', current_date)"; break;
default: $query_limit .= " limit 200";
case 'year': $query .= " and date_trunc('year', calldate) = date_trunc('year', current_date)"; break;
case 'month': $query .= " and date_trunc('month', calldate) = date_trunc('month', current_date)"; break;
case 'week': $query .= " and date_trunc('week', calldate) = date_trunc('week', current_date)"; break;
case 'today': $query .= " and date_trunc('day', calldate) = date_trunc('day', current_date)"; break;
default: $query_limit .= " limit 1000";
}
}
 
$list_query = "SELECT acctid,calldate,src,dst,billsec,disposition"
. " from cdr where dstchannel != ''"
. $query . " ORDER BY calldate desc" . $query_limit;
$list_query = "select acctid,calldate,src,dst,billsec,disposition"
. " from cdr where"
. $query . " order by calldate desc" . $query_limit;
$result = $db->query_params($list_query, $params);
 
$calls_number = $db->num_rows();
115,7 → 115,7
$display->add_text($cdr->build());
// summary
$sum_query = "SELECT sum(duration) as dur, sum(billsec) as bill from cdr where dstchannel != ''" . $query;
$sum_query = "select sum(duration) as dur, sum(billsec) as bill from cdr where" . $query;
$result = $db->query_params($sum_query, $params);
$line = $db->fetch_row();
$cdr = new Table();
135,4 → 135,3
$display->add_template('cdr');
}
?>