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 = BaseQuery(); |
$query = ""; |
$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 1000"; |
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"; |
} |
} |
|
$list_query = "select acctid,calldate,src,dst,billsec,disposition" |
. " from cdr where" |
. $query . " order by calldate desc" . $query_limit; |
$list_query = "SELECT acctid,calldate,src,dst,billsec,disposition" |
. " from cdr where dstchannel != ''" |
. $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" . $query; |
$sum_query = "SELECT sum(duration) as dur, sum(billsec) as bill from cdr where dstchannel != ''" . $query; |
$result = $db->query_params($sum_query, $params); |
$line = $db->fetch_row(); |
$cdr = new Table(); |
135,3 → 135,4 |
$display->add_template('cdr'); |
} |
?> |
|