2016-04-26 03:30:23 +02:00
|
|
|
<?php
|
|
|
|
|
/*
|
|
|
|
|
FusionPBX
|
|
|
|
|
Version: MPL 1.1
|
|
|
|
|
|
|
|
|
|
The contents of this file are subject to the Mozilla Public License Version
|
|
|
|
|
1.1 (the "License"); you may not use this file except in compliance with
|
|
|
|
|
the License. You may obtain a copy of the License at
|
|
|
|
|
http://www.mozilla.org/MPL/
|
|
|
|
|
|
|
|
|
|
Software distributed under the License is distributed on an "AS IS" basis,
|
|
|
|
|
WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
|
|
|
|
|
for the specific language governing rights and limitations under the
|
|
|
|
|
License.
|
|
|
|
|
|
|
|
|
|
The Original Code is FusionPBX
|
|
|
|
|
|
|
|
|
|
The Initial Developer of the Original Code is
|
|
|
|
|
Mark J Crane <markjcrane@fusionpbx.com>
|
2023-06-02 00:55:19 +02:00
|
|
|
Portions created by the Initial Developer are Copyright (C) 2008-2023
|
2016-04-26 03:30:23 +02:00
|
|
|
the Initial Developer. All Rights Reserved.
|
|
|
|
|
|
|
|
|
|
Contributor(s):
|
|
|
|
|
Mark J Crane <markjcrane@fusionpbx.com>
|
|
|
|
|
*/
|
2018-06-26 05:08:28 +02:00
|
|
|
|
2022-10-11 00:35:14 +02:00
|
|
|
//includes files
|
2023-06-15 19:28:23 +02:00
|
|
|
require_once dirname(__DIR__, 2) . "/resources/require.php";
|
2018-06-26 05:08:28 +02:00
|
|
|
require_once "resources/check_auth.php";
|
|
|
|
|
|
|
|
|
|
//check permissions
|
2020-09-16 23:48:43 +02:00
|
|
|
if (permission_exists('xml_cdr_export')) {
|
2018-06-26 05:08:28 +02:00
|
|
|
//access granted
|
|
|
|
|
}
|
|
|
|
|
else {
|
|
|
|
|
echo "access denied";
|
|
|
|
|
exit;
|
|
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//add multi-lingual support
|
|
|
|
|
$language = new text;
|
|
|
|
|
$text = $language->get();
|
|
|
|
|
|
|
|
|
|
//additional includes
|
|
|
|
|
$rows_per_page = ($_SESSION['domain']['paging']['numeric'] != '') ? $_SESSION['domain']['paging']['numeric'] : 50;
|
2023-06-02 00:55:19 +02:00
|
|
|
$archive_request = isset($_POST['archive_request']) && $_POST['archive_request'] == 'true' ? true : false;
|
2016-04-26 03:30:23 +02:00
|
|
|
require_once "xml_cdr_inc.php";
|
|
|
|
|
|
|
|
|
|
//get the format
|
2019-09-03 16:29:44 +02:00
|
|
|
$export_format = $_REQUEST['export_format'];
|
2016-04-26 03:30:23 +02:00
|
|
|
|
2020-01-29 01:28:01 +01:00
|
|
|
//export the csv
|
2021-01-18 08:00:18 +01:00
|
|
|
if (permission_exists('xml_cdr_export_csv') && $export_format == 'csv') {
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//define file name
|
2023-09-20 03:24:46 +02:00
|
|
|
if ($_REQUEST['show'] == 'all' && permission_exists('xml_cdr_all')) {
|
2016-04-26 03:30:23 +02:00
|
|
|
$csv_filename = "cdr_".date("Ymd_His").".csv";
|
|
|
|
|
}
|
|
|
|
|
else {
|
|
|
|
|
$csv_filename = "cdr_".$_SESSION['domain_name']."_".date("Ymd_His").".csv";
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
//set the http headers
|
|
|
|
|
header('Content-type: application/octet-binary');
|
|
|
|
|
header('Content-Disposition: attachment; filename='.$csv_filename);
|
|
|
|
|
|
|
|
|
|
//set the csv headers
|
|
|
|
|
$z = 0;
|
2019-09-03 16:29:44 +02:00
|
|
|
foreach ($result[0] as $key => $val) {
|
2016-04-26 03:30:23 +02:00
|
|
|
if ($key != "xml" && $key != "json") {
|
2023-09-20 03:58:13 +02:00
|
|
|
$echo = true;
|
|
|
|
|
switch ($key) {
|
|
|
|
|
case 'direction': if (!permission_exists('xml_cdr_direction')) { $echo = false; } break;
|
|
|
|
|
case 'extension': if (!permission_exists('xml_cdr_extension')) { $echo = false; } break;
|
|
|
|
|
case 'caller_id_name': if (!permission_exists('xml_cdr_caller_id_name')) { $echo = false; } break;
|
|
|
|
|
case 'caller_id_number': if (!permission_exists('xml_cdr_caller_id_number')) { $echo = false; } break;
|
|
|
|
|
case 'caller_destination': if (!permission_exists('xml_cdr_caller_destination')) { $echo = false; } break;
|
|
|
|
|
case 'destination_number': if (!permission_exists('xml_cdr_destination')) { $echo = false; } break;
|
|
|
|
|
case 'answer_stamp':
|
|
|
|
|
case 'start_stamp':
|
|
|
|
|
case 'end_stamp':
|
|
|
|
|
case 'start_date_formatted':
|
|
|
|
|
case 'start_time_formatted':
|
|
|
|
|
case 'start_epoch': if (!permission_exists('xml_cdr_start')) { $echo = false; } break;
|
|
|
|
|
case 'tta': if (!permission_exists('xml_cdr_tta')) { $echo = false; } break;
|
|
|
|
|
case 'duration':
|
|
|
|
|
case 'billsec':
|
|
|
|
|
case 'billmsec': if (!permission_exists('xml_cdr_duration')) { $echo = false; } break;
|
|
|
|
|
case 'pdd_ms': if (!permission_exists('xml_cdr_pdd')) { $echo = false; } break;
|
|
|
|
|
case 'rtp_audio_in_mos': if (!permission_exists('xml_cdr_mos')) { $echo = false; } break;
|
|
|
|
|
case 'hangup_cause': if (!permission_exists('xml_cdr_hangup_cause')) { $echo = false; } break;
|
|
|
|
|
case 'record_path':
|
|
|
|
|
case 'record_name': if (!permission_exists('xml_cdr_recording')) { $echo = false; } break;
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
2023-09-20 03:58:13 +02:00
|
|
|
if ($echo) {
|
|
|
|
|
echo ($z == 0 ? null : ',').'"'.$key.'"';
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
$z++;
|
|
|
|
|
}
|
|
|
|
|
echo "\n";
|
|
|
|
|
|
|
|
|
|
//show the csv data
|
|
|
|
|
$x=0;
|
2019-09-03 16:29:44 +02:00
|
|
|
while (true) {
|
2016-04-26 03:30:23 +02:00
|
|
|
$z = 0;
|
2019-09-03 16:29:44 +02:00
|
|
|
foreach ($result[0] as $key => $val) {
|
2016-04-26 03:30:23 +02:00
|
|
|
if ($key != "xml" && $key != "json") {
|
2023-09-20 03:58:13 +02:00
|
|
|
$echo = true;
|
|
|
|
|
switch ($key) {
|
|
|
|
|
case 'direction': if (!permission_exists('xml_cdr_direction')) { $echo = false; } break;
|
|
|
|
|
case 'extension': if (!permission_exists('xml_cdr_extension')) { $echo = false; } break;
|
|
|
|
|
case 'caller_id_name': if (!permission_exists('xml_cdr_caller_id_name')) { $echo = false; } break;
|
|
|
|
|
case 'caller_id_number': if (!permission_exists('xml_cdr_caller_id_number')) { $echo = false; } break;
|
|
|
|
|
case 'caller_destination': if (!permission_exists('xml_cdr_caller_destination')) { $echo = false; } break;
|
|
|
|
|
case 'destination_number': if (!permission_exists('xml_cdr_destination')) { $echo = false; } break;
|
|
|
|
|
case 'answer_stamp':
|
|
|
|
|
case 'start_stamp':
|
|
|
|
|
case 'end_stamp':
|
|
|
|
|
case 'start_date_formatted':
|
|
|
|
|
case 'start_time_formatted':
|
|
|
|
|
case 'start_epoch': if (!permission_exists('xml_cdr_start')) { $echo = false; } break;
|
|
|
|
|
case 'tta': if (!permission_exists('xml_cdr_tta')) { $echo = false; } break;
|
|
|
|
|
case 'duration':
|
|
|
|
|
case 'billsec':
|
|
|
|
|
case 'billmsec': if (!permission_exists('xml_cdr_duration')) { $echo = false; } break;
|
|
|
|
|
case 'pdd_ms': if (!permission_exists('xml_cdr_pdd')) { $echo = false; } break;
|
|
|
|
|
case 'rtp_audio_in_mos': if (!permission_exists('xml_cdr_mos')) { $echo = false; } break;
|
|
|
|
|
case 'hangup_cause': if (!permission_exists('xml_cdr_hangup_cause')) { $echo = false; } break;
|
|
|
|
|
case 'record_path':
|
|
|
|
|
case 'record_name': if (!permission_exists('xml_cdr_recording')) { $echo = false; } break;
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
2023-09-20 03:58:13 +02:00
|
|
|
if ($echo) {
|
|
|
|
|
echo ($z == 0 ? null : ',').'"'.$result[$x][$key].'"';
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
$z++;
|
|
|
|
|
}
|
|
|
|
|
echo "\n";
|
|
|
|
|
++$x;
|
2023-09-20 03:58:13 +02:00
|
|
|
if ($x > ($result_count - 1)) {
|
2016-04-26 03:30:23 +02:00
|
|
|
break;
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
//export as a PDF
|
2021-01-18 08:00:18 +01:00
|
|
|
if (permission_exists('xml_cdr_export_pdf') && $export_format == 'pdf') {
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//load pdf libraries
|
2019-09-03 16:29:44 +02:00
|
|
|
require_once "resources/tcpdf/tcpdf.php";
|
|
|
|
|
require_once "resources/fpdi/fpdi.php";
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//determine page size
|
|
|
|
|
switch ($_SESSION['fax']['page_size']['text']) {
|
2020-02-11 18:44:00 +01:00
|
|
|
case 'a4':
|
2016-04-26 03:30:23 +02:00
|
|
|
$page_width = 11.7; //in
|
|
|
|
|
$page_height = 8.3; //in
|
|
|
|
|
break;
|
2020-02-11 18:44:00 +01:00
|
|
|
case 'legal':
|
2016-04-26 03:30:23 +02:00
|
|
|
$page_width = 14; //in
|
|
|
|
|
$page_height = 8.5; //in
|
|
|
|
|
break;
|
2020-02-11 18:44:00 +01:00
|
|
|
case 'letter':
|
2016-04-26 03:30:23 +02:00
|
|
|
default :
|
|
|
|
|
$page_width = 11; //in
|
|
|
|
|
$page_height = 8.5; //in
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// initialize pdf
|
|
|
|
|
$pdf = new FPDI('L', 'in');
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->SetAutoPageBreak(false);
|
|
|
|
|
$pdf->setPrintHeader(false);
|
|
|
|
|
$pdf->setPrintFooter(false);
|
|
|
|
|
$pdf->SetMargins(0.5, 0.5, 0.5, true);
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//set default font
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->SetFont('helvetica', '', 7);
|
2016-04-26 03:30:23 +02:00
|
|
|
//add new page
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->AddPage('L', array($page_width, $page_height));
|
2016-04-26 03:30:23 +02:00
|
|
|
|
2023-09-20 03:15:04 +02:00
|
|
|
//initialize columns and colspan variables
|
|
|
|
|
$columns = $colspan_line_totals_averages = 0;
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//write the table column headers
|
|
|
|
|
$data_start = '<table cellpadding="0" cellspacing="0" border="0" width="100%">';
|
|
|
|
|
$data_end = '</table>';
|
|
|
|
|
|
|
|
|
|
$data_head = '<tr>';
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_direction')) {
|
|
|
|
|
$data_head .= '<td width="6%"><b>'.$text['label-direction'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_extension')) {
|
|
|
|
|
$data_head .= '<td width="4%"><b>'.$text['label-ext'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_caller_id_name')) {
|
|
|
|
|
$data_head .= '<td width="12%"><b>'.$text['label-caller_id_name'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_caller_id_number')) {
|
|
|
|
|
$data_head .= '<td width="9%"><b>'.$text['label-caller_id_number'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_caller_destination')) {
|
|
|
|
|
$data_head .= '<td width="9%"><b>'.$text['label-caller_destination'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_destination')) {
|
|
|
|
|
$data_head .= '<td width="9%"><b>'.$text['label-destination'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
2024-01-10 22:34:53 +01:00
|
|
|
if (permission_exists('xml_cdr_account_code')) {
|
|
|
|
|
$data_head .= '<td width="12%" nowrap="nowrap"><b>'.$text['label-accountcode'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_start')) {
|
|
|
|
|
$data_head .= '<td width="12%" nowrap="nowrap"><b>'.$text['label-start'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
$colspan_line_totals_averages = $columns - 1;
|
|
|
|
|
if (permission_exists('xml_cdr_tta')) {
|
|
|
|
|
$data_head .= '<td width="3%" align="right"><b>'.$text['label-tta'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_duration')) {
|
|
|
|
|
$data_head .= '<td width="6%" align="right"><b>'.$text['label-duration'].'</b></td>';
|
|
|
|
|
$columns += 2;
|
|
|
|
|
$data_head .= '<td width="7%" align="right"><b>'.$text['label-billsec'].'</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_pdd')) {
|
2023-11-28 01:15:29 +01:00
|
|
|
$data_head .= '<td width="5%" align="right"><b>'.$text['label-pdd'].'</b></td>';
|
2023-09-20 03:15:04 +02:00
|
|
|
$columns++;
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_mos')) {
|
2023-11-28 01:15:29 +01:00
|
|
|
$data_head .= '<td width="5%" align="center"><b>'.$text['label-mos'].'</b></td>';
|
2023-09-20 03:15:04 +02:00
|
|
|
$columns++;
|
|
|
|
|
}
|
2023-06-02 00:55:19 +02:00
|
|
|
if (!empty($_SESSION['cdr']['field']) && is_array($_SESSION['cdr']['field'])) {
|
2018-06-26 05:08:28 +02:00
|
|
|
foreach ($_SESSION['cdr']['field'] as $field) {
|
|
|
|
|
$array = explode(",", $field);
|
|
|
|
|
$field_name = end($array);
|
|
|
|
|
$field_label = ucwords(str_replace("_", " ", $field_name));
|
|
|
|
|
$field_label = str_replace("Sip", "SIP", $field_label);
|
|
|
|
|
if ($field_name != "destination_number") {
|
|
|
|
|
$data_head .= '<td width="10%" align="left"><b>'.$field_label.'</b></td>';
|
|
|
|
|
}
|
2023-09-20 03:15:04 +02:00
|
|
|
$columns++;
|
2018-06-26 05:08:28 +02:00
|
|
|
}
|
|
|
|
|
}
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_hangup_cause')) {
|
|
|
|
|
$data_head .= '<td width="10%"><b>'.$text['label-hangup_cause'].'</b></td>';
|
|
|
|
|
$columns++;
|
|
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
$data_head .= '</tr>';
|
2023-09-20 03:15:04 +02:00
|
|
|
if ($columns != 0) {
|
|
|
|
|
$data_head .= '<tr><td colspan="'.$columns.'"><hr></td></tr>';
|
|
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//initialize total variables
|
|
|
|
|
$total['duration'] = 0;
|
|
|
|
|
$total['billmsec'] = 0;
|
|
|
|
|
$total['pdd_ms'] = 0;
|
|
|
|
|
$total['rtp_audio_in_mos'] = 0;
|
|
|
|
|
$total['tta'] = 0;
|
|
|
|
|
|
|
|
|
|
//write the row cells
|
|
|
|
|
$z = 0; // total counter
|
2023-09-20 03:24:46 +02:00
|
|
|
$z_mos = 0; // total with mos counter
|
2016-04-26 03:30:23 +02:00
|
|
|
$p = 0; // per page counter
|
2023-09-20 03:15:04 +02:00
|
|
|
if (sizeof($result) > 0 && $columns != 0) {
|
2020-02-11 18:44:00 +01:00
|
|
|
foreach ($result as $cdr_num => $fields) {
|
2023-06-02 00:55:19 +02:00
|
|
|
$data_body[$p] = '<tr>';
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_direction')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.$text['label-'.$fields['direction']].'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_extension')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.$fields['extension'].'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_caller_id_name')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.$fields['caller_id_name'].'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_caller_id_number')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.$fields['caller_id_number'].'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_caller_destination')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.format_phone($fields['caller_destination']).'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_destination')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.format_phone($fields['destination_number']).'</td>';
|
|
|
|
|
}
|
2024-01-10 22:34:53 +01:00
|
|
|
if (permission_exists('xml_cdr_account_code')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.$fields['accountcode'].'</td>';
|
|
|
|
|
}
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_start')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.$fields['start_stamp'].'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_tta')) {
|
|
|
|
|
$total['tta'] += ($fields['tta'] > 0) ? $fields['tta'] : 0;
|
|
|
|
|
$data_body[$p] .= '<td align="right">'.(($fields['tta'] >= 0) ? $fields['tta'].'s' : null).'</td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_duration')) {
|
|
|
|
|
$seconds = ($fields['hangup_cause'] == "ORIGINATOR_CANCEL") ? $fields['duration'] : round(($fields['billmsec'] / 1000), 0, PHP_ROUND_HALF_UP);
|
|
|
|
|
$total['duration'] += $seconds;
|
|
|
|
|
$data_body[$p] .= '<td align="right">'.gmdate("G:i:s", $seconds).'</td>';
|
|
|
|
|
$total['billmsec'] += $fields['billmsec'];
|
|
|
|
|
$data_body[$p] .= '<td align="right">'.number_format(round($fields['billmsec'] / 1000, 2), 2).'s</td>';
|
|
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
if (permission_exists("xml_cdr_pdd")) {
|
|
|
|
|
$total['pdd_ms'] += $fields['pdd_ms'];
|
2023-09-20 03:15:04 +02:00
|
|
|
$data_body[$p] .= '<td align="right">'.number_format(round($fields['pdd_ms'] / 1000, 2), 2).'s</td>';
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_mos')) {
|
2016-04-26 03:30:23 +02:00
|
|
|
$total['rtp_audio_in_mos'] += $fields['rtp_audio_in_mos'];
|
2023-09-20 03:15:04 +02:00
|
|
|
$data_body[$p] .= '<td align="center">'.($fields['rtp_audio_in_mos'] ?? '').'</td>';
|
2023-09-20 03:24:46 +02:00
|
|
|
if (!empty($fields['rtp_audio_in_mos']) && is_numeric($fields['rtp_audio_in_mos'])) { $z_mos++; }
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
2023-06-02 00:55:19 +02:00
|
|
|
if (!empty($_SESSION['cdr']['field']) && is_array($_SESSION['cdr']['field'])) {
|
2018-06-26 05:08:28 +02:00
|
|
|
foreach ($_SESSION['cdr']['field'] as $field) {
|
|
|
|
|
$array = explode(",", $field);
|
|
|
|
|
$field_name = end($array);
|
|
|
|
|
$field_label = ucwords(str_replace("_", " ", $field_name));
|
|
|
|
|
$field_label = str_replace("Sip", "SIP", $field_label);
|
|
|
|
|
if ($field_name != "destination_number") {
|
|
|
|
|
$data_body[$p] .= '<td align="right">';
|
|
|
|
|
$data_body[$p] .= $fields[$field_name];
|
|
|
|
|
$data_body[$p] .= '</td>';
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
}
|
|
|
|
|
|
2023-09-20 03:15:04 +02:00
|
|
|
if (permission_exists('xml_cdr_hangup_cause')) {
|
|
|
|
|
$data_body[$p] .= '<td>'.ucwords(strtolower(str_replace("_", " ", $fields['hangup_cause']))).'</td>';
|
|
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
$data_body[$p] .= '</tr>';
|
|
|
|
|
|
|
|
|
|
$z++;
|
|
|
|
|
$p++;
|
|
|
|
|
|
|
|
|
|
if ($p == 60) {
|
|
|
|
|
//output data
|
|
|
|
|
$data_body_chunk = $data_start.$data_head;
|
|
|
|
|
foreach ($data_body as $data_body_row) {
|
|
|
|
|
$data_body_chunk .= $data_body_row;
|
|
|
|
|
}
|
|
|
|
|
$data_body_chunk .= $data_end;
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->writeHTML($data_body_chunk, true, false, false, false, '');
|
2016-04-26 03:30:23 +02:00
|
|
|
unset($data_body_chunk);
|
|
|
|
|
unset($data_body);
|
|
|
|
|
$p = 0;
|
|
|
|
|
|
|
|
|
|
//add new page
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->AddPage('L', array($page_width, $page_height));
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
2023-09-20 03:15:04 +02:00
|
|
|
if ($columns != 0) {
|
|
|
|
|
|
|
|
|
|
//write divider
|
|
|
|
|
$data_footer = '<tr><td colspan="'.$columns.'"></td></tr>';
|
|
|
|
|
|
|
|
|
|
//write totals
|
|
|
|
|
$data_footer .= '<tr>';
|
|
|
|
|
$data_footer .= '<td><b>'.$text['label-total'].'</b></td>';
|
|
|
|
|
$data_footer .= '<td colspan="'.$colspan_line_totals_averages.'">'.$z.'</td>';
|
|
|
|
|
if (permission_exists('xml_cdr_tta')) {
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.number_format(round($total['tta'], 1), 0).'s</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_duration')) {
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.gmdate("G:i:s", $total['duration']).'</b></td>';
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.gmdate("G:i:s", round($total['billmsec'] / 1000, 0)).'</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists("xml_cdr_pdd")) {
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.number_format(round(($total['pdd_ms'] / 1000), 2), 2).'s</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_mos')) {
|
|
|
|
|
$data_footer .= '<td></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_hangup_cause')) {
|
|
|
|
|
$data_footer .= '<td></td>';
|
|
|
|
|
}
|
|
|
|
|
$data_footer .= '</tr>';
|
|
|
|
|
|
|
|
|
|
$data_footer .= '<tr><td colspan="'.$columns.'"><hr></td></tr>';
|
|
|
|
|
|
|
|
|
|
//write averages
|
|
|
|
|
$data_footer .= '<tr>';
|
|
|
|
|
$data_footer .= '<td><b>'.$text['label-average'].'</b></td>';
|
|
|
|
|
$data_footer .= '<td colspan="'.$colspan_line_totals_averages.'"></td>';
|
|
|
|
|
if (permission_exists('xml_cdr_tta')) {
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.round(($total['tta'] / $z), 1).'</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_duration')) {
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.gmdate("G:i:s", floor($total['duration'] / $z)).'</b></td>';
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.gmdate("G:i:s", round($total['billmsec'] / $z / 1000, 0)).'</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists("xml_cdr_pdd")) {
|
|
|
|
|
$data_footer .= '<td align="right"><b>'.number_format(round(($total['pdd_ms'] / $z / 1000), 2), 2).'s</b></td>';
|
|
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_mos')) {
|
2023-09-20 03:24:46 +02:00
|
|
|
$data_footer .= '<td align="center"><b>'.round(($total['rtp_audio_in_mos'] / $z_mos), 2).'</b></td>';
|
2023-09-20 03:15:04 +02:00
|
|
|
}
|
|
|
|
|
if (permission_exists('xml_cdr_hangup_cause')) {
|
|
|
|
|
$data_footer .= '<td></td>';
|
|
|
|
|
}
|
|
|
|
|
$data_footer .= '</tr>';
|
|
|
|
|
|
|
|
|
|
//write divider
|
|
|
|
|
$data_footer .= '<tr><td colspan="'.$columns.'"><hr></td></tr>';
|
|
|
|
|
|
|
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
//add last page
|
|
|
|
|
if ($p >= 55) {
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->AddPage('L', array($page_width, $page_height));
|
2016-04-26 03:30:23 +02:00
|
|
|
}
|
2024-08-29 18:04:18 +02:00
|
|
|
|
|
|
|
|
//clear the output buffer
|
|
|
|
|
if (ob_get_level()) {
|
|
|
|
|
ob_end_clean();
|
|
|
|
|
}
|
|
|
|
|
|
2016-04-26 03:30:23 +02:00
|
|
|
//output remaining data
|
|
|
|
|
$data_body_chunk = $data_start.$data_head;
|
|
|
|
|
foreach ($data_body as $data_body_row) {
|
|
|
|
|
$data_body_chunk .= $data_body_row;
|
|
|
|
|
}
|
|
|
|
|
$data_body_chunk .= $data_footer.$data_end;
|
2018-06-26 05:08:28 +02:00
|
|
|
$pdf->writeHTML($data_body_chunk, true, false, false, false, '');
|
2016-04-26 03:30:23 +02:00
|
|
|
unset($data_body_chunk);
|
|
|
|
|
|
|
|
|
|
//define file name
|
2023-09-20 03:24:46 +02:00
|
|
|
if ($_REQUEST['show'] == 'all' && permission_exists('xml_cdr_all')) {
|
|
|
|
|
$pdf_filename = "cdr_".date("Ymd_His").".pdf";
|
|
|
|
|
}
|
|
|
|
|
else {
|
2023-11-28 00:25:02 +01:00
|
|
|
$pdf_filename = "cdr_".$_SESSION['domain_name']."_".date("Ymd_His").".pdf";
|
2023-09-20 03:24:46 +02:00
|
|
|
}
|
2016-04-26 03:30:23 +02:00
|
|
|
|
|
|
|
|
header("Content-Type: application/force-download");
|
|
|
|
|
header("Content-Type: application/octet-stream");
|
|
|
|
|
header("Content-Type: application/download");
|
|
|
|
|
header("Content-Description: File Transfer");
|
|
|
|
|
header('Content-Disposition: attachment; filename="'.$pdf_filename.'"');
|
|
|
|
|
header("Content-Type: application/pdf");
|
|
|
|
|
header('Accept-Ranges: bytes');
|
|
|
|
|
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
|
|
|
|
|
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // date in the past
|
|
|
|
|
|
|
|
|
|
// push pdf download
|
|
|
|
|
$pdf -> Output($pdf_filename, 'D'); // Display [I]nline, Save to [F]ile, [D]ownload
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
2024-08-29 18:04:18 +02:00
|
|
|
?>
|
