| 0,0 → 1,186 |
|---|
| <?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(array_key_exists('detail', $_GET)) { |
| $cdr_detail = array(); |
| $db->query_params('SELECT * FROM cdr WHERE acctid=$1', array($_GET['detail'])); |
| $detail = $db->fetch_row(); |
| |
| for ($i=0;$i<$db->num_fields();$i++) { |
| $col = $db->get_field_name($i); |
| $cdr_detail['CDR_'.strtoupper($col)] = $detail[$col]; |
| } |
| $cdr_detail['CDR_STATUS'] = ($detail ? 'DONE' : 'NOT FOUND'); |
| $cdr_detail['CDR_DURATION_F'] = Duration($detail['duration']); |
| $cdr_detail['CDR_BILLSEC_F'] = Duration($detail['billsec']); |
| |
| $display->add_variables($cdr_detail); |
| $display->add_template('cdr_detail'); |
| } |
| elseif(array_key_exists('active', $_GET)) { |
| $cdr_detail = array(); |
| $db->query_params("SELECT acctid, calldate, linkdate, clid, src, dst, dcontext," |
| . " channel, dstchannel, lastapp, lastdata," |
| . " extract(epoch from date_trunc('second',current_timestamp-calldate)) as duration," |
| . " extract(epoch from date_trunc('second',current_timestamp-linkdate)) as billsec," |
| . " disposition, amaflags, accountcode, uniqueid, userfield FROM activecalls" |
| . " WHERE acctid=$1 and duration is null", array($_GET['active'])); |
| $detail = $db->fetch_row(); |
| |
| for ($i=0;$i<$db->num_fields();$i++) { |
| $col = $db->get_field_name($i); |
| $cdr_detail['CDR_'.strtoupper($col)] = $detail[$col]; |
| } |
| $cdr_detail['CDR_STATUS'] = ($detail ? 'ACTIVE' : 'NOT FOUND'); |
| $cdr_detail['CDR_DURATION_F'] = Duration($detail['duration']); |
| $cdr_detail['CDR_BILLSEC_F'] = Duration($detail['billsec']); |
| |
| $display->add_variables($cdr_detail); |
| $display->add_template('cdr_detail'); |
| } |
| elseif(array_key_exists('s', $_GET) || array_key_exists('list', $_GET)) { |
| function do_field($sql, &$params, $fld) { |
| if($fld && $_GET[$fld]) { |
| $sql .= " and $fld"; |
| if(array_key_exists($fld.'type', $_GET)) { |
| $dType = $_GET[$fld.'type']; |
| switch($dType) { |
| case 1: |
| array_push($params, $_GET[$fld]); |
| $sql .= "=$" . count($params); |
| break; |
| case 2: |
| array_push($params, "$_GET[$fld]%"); |
| $sql .= " LIKE $" . count($params); |
| break; |
| case 3: |
| array_push($params, "%$_GET[$fld]%"); |
| $sql .= " LIKE $" . count($params); |
| break; |
| case 4; |
| array_push($params, "%$_GET[$fld]"); |
| $sql .= " LIKE $" . count($params); |
| } |
| } |
| else { |
| array_push($params, "%$_GET[$fld]%"); |
| $sql .= " LIKE $" . count($params); |
| } |
| } |
| return $sql; |
| } |
| |
| function do_date_compare($period) |
| { |
| return " and date_trunc('" . $period . "', calldate) = date_trunc('" |
| . $period . "', current_date)"; |
| } |
| |
| # Construct Query Here |
| $query = BaseQuery(); |
| $params = array(); |
| $active = false; |
| |
| if ($_GET['before']) { |
| array_push($params, $_GET['before']); |
| $query .= " AND calldate < $" . count($params); |
| } |
| |
| if ($_GET['after']) { |
| array_push($params, $_GET['after']); |
| $query .= " AND calldate > $" . count($params); |
| } |
| |
| $query = do_field($query, $params, 'clid'); |
| $query = do_field($query, $params, 'src'); |
| $query = do_field($query, $params, 'dst'); |
| $query = do_field($query, $params, 'channel'); |
| |
| $query_limit = ''; |
| if(array_key_exists('list',$_GET)) { |
| switch($_GET['list']) { |
| case 'year': $query .= do_date_compare('year'); break; |
| case 'month': $query .= do_date_compare('month'); break; |
| case 'week': $query .= do_date_compare('week'); break; |
| case 'today': $query .= do_date_compare('day'); break; |
| case 'active': |
| $active = true; |
| $query .= " and duration is null"; |
| break; |
| |
| default: $query_limit .= " limit 1000"; |
| } |
| } |
| |
| if($active) { |
| $list_query = "select acctid,calldate,src,dst," |
| . " extract(epoch from date_trunc('second'," |
| . " current_timestamp-linkdate)) as billsec,disposition" |
| . " from activecalls where" |
| . $query . " order by calldate desc" . $query_limit; |
| } |
| else { |
| $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(); |
| $cdr = new Table(array('ID', 'Call Date', 'Source', 'Destination', 'Duration', 'Disposition')); |
| $cdr->set_table_class('stat cdr list'); |
| |
| while($line = $db->fetch_row()) { |
| $cdr->newrow(); |
| $cdr->addcell($line['acctid']); |
| $cdr->addcell($line['calldate']); |
| $cdr->addcell($line['src']); |
| $cdr->addcell($line['dst']); |
| $cdr->addcell($line['disposition'] == 'ANSWERED' ? Duration($line['billsec']) : ''); |
| $cdr->addcell(strtolower($line['disposition'])); |
| $cdr->addcell(array('class' => 'link', 'html' => |
| display_link($PHP_SELF . '?m=cdr&' . ($active ? 'active' : 'detail') |
| . '=' . $line['acctid'], 'Details'))); |
| } |
| $display->add_text($cdr->build()); |
| |
| // summary |
| if($active) { |
| $sum_query = "select" |
| . " sum(extract(epoch from date_trunc('second',current_timestamp-calldate))) as dur," |
| . " sum(extract(epoch from date_trunc('second',current_timestamp-linkdate))) as bill" |
| . " from activecalls where" . $query; |
| } |
| else { |
| $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(); |
| $cdr->set_table_class('stat cdr sum'); |
| $cdr->addcell(array('tag' => 'th', 'text' => 'Calls')); |
| $cdr->addcell($calls_number); |
| $cdr->newrow(); |
| $cdr->addcell(array('tag' => 'th', 'text' => 'Call Seconds')); |
| $cdr->addcell(Duration($line['dur'])); |
| $cdr->newrow(); |
| $cdr->addcell(array('tag' => 'th', 'text' => 'Bill Seconds')); |
| $cdr->addcell(Duration($line['bill'])); |
| $display->add_text($cdr->build()); |
| } |
| else { |
| $display->add_variables(array('CDR_METHOD' => 'GET', 'CDR_ACTION' => $PHP_SELF)); |
| $display->add_template('cdr'); |
| } |
| ?> |
| Property changes: |
|---|
| Added: svn:mergeinfo |
|---|