';
# Кнопка скачать запись
$tpl['btn_download'] = '
';
# Кнопка удалить запись
$tpl['btn_delete'] = '
';
# Файл не найден
$tpl['error'] = '
|
|
';
# Прослушивание, скачивание, удаление
$tpl['record'] = '
[_btn_record]
[_btn_download]
[_btn_delete]
|
';
# Скачивание, удаление
$tpl['download'] = '
[_btn_download]
|
';
$tpl['record'] = str_replace(
array(
'[_btn_record]',
'[_btn_download]',
'[_btn_delete]',
),
array(
Config::get('display.main.rec_play') == 1 ? $tpl['btn_record'] : '',
$tpl['btn_download'],
Config::get('display.main.rec_delete') == 1 ? $tpl['btn_delete'] : '',
),
$tpl['record']
);
$tpl['download'] = str_replace('[_btn_download]', $tpl['btn_download'], $tpl['download']);
# Файл не существует
$tmp['result'] = $tpl['error'];
# Аудио
if ( $file_params['type'] == 'audio' ) {
$tmp['result'] = $tpl['record'];
}
# Архив
else if ( $file_params['type'] == 'archive' ) {
$tmp['result'] = $tpl['download'];
}
# Факс
else if ( $file_params['type'] == 'fax' ) {
$tmp['result'] = $tpl['download'];
}
echo $tmp['result'];
}
# Получить параметры файла записи звонка
function getFileParams($row) {
# uniq_name.mp3
$recorded_file = '';
$tmp['result'] = array(
# Тип файла. false, если файл не существует
'type' => false,
# Путь к файлу в base64. То, что после dl.php?f=
'path' => '',
);
$tmp['system_audio_format'] = Config::get('system.audio_format');
# В базе есть колонка с именем записи разговора
if ( isset($row[Config::get('system.column_name')]) ) {
$recorded_file = $row[Config::get('system.column_name')];
}
$mycalldate_ymd = substr($row['calldate'], 0, 10); // ymd
$mycalldate_ym = substr($row['calldate'], 0, 7); // ym
$mycalldate_y = substr($row['calldate'], 0, 4); // y
$mycalldate_m = substr($row['calldate'], 5, 2); // m
$mycalldate_d = substr($row['calldate'], 8, 2); // d
$mydate = date('Y-m-d');
# Имя файла при отложенной конвертации
if ( Config::get('system.audio_defconv') == 1 && $recorded_file ) {
if ( $mycalldate_ymd < $mydate ) {
$recorded_file = preg_replace('#(.+)\.(wav|mp3|wma|ogg|aac)$#i', '${1}.'.$tmp['system_audio_format'], $recorded_file);
} else {
$tmp['system_audio_format'] = 'wav';
}
}
# Получение имени файла и пути
if ( $mycalldate_ymd < $mydate && Config::get('system.storage_format') === 1 ) {
$rec['filename'] = "$mycalldate_y/$mycalldate_ym/$mycalldate_ymd/$recorded_file";
} else if ( $mycalldate_ymd < $mydate && Config::get('system.storage_format') === 2 ) {
$rec['filename'] = "$mycalldate_y/$mycalldate_m/$mycalldate_d/$recorded_file";
} else if ( Config::get('system.storage_format') === 3 ) {
$rec['filename'] = "$mycalldate_y/$mycalldate_ym/$mycalldate_ymd/$recorded_file";
} else if ( Config::get('system.storage_format') === 4 ) {
$rec['filename'] = "$mycalldate_y/$mycalldate_m/$mycalldate_d/$recorded_file";
} else if ( Config::get('system.storage_format') === 5 ) {
$rec['filename'] = $recorded_file;
} else if ( Config::get('system.storage_format') === 6 ) {
$rec['filename'] = $recorded_file.'.'.$tmp['system_audio_format'];
} else {
$rec['filename'] = $recorded_file;
}
$rec['path'] = Config::get('system.monitor_dir').'/'.$rec['filename'];
# Аудио
if ( is_file($rec['path'])
&& $recorded_file
&& filesize($rec['path'])/1024 >= Config::get('system.fsize_exists')
&& preg_match('#(.+)\.'.$tmp['system_audio_format'].'$#i', $rec['filename'])
) {
$tmp['result'] = array(
'type' => 'audio',
'path' => base64_encode($rec['filename']),
);
}
# Архив
else if ( Config::exists('system.archive_format')
&& $recorded_file
&& is_file($rec['path'].'.'.Config::get('system.archive_format'))
&& filesize($rec['path'].'.'.Config::get('system.archive_format'))/1024 >= Config::get('system.fsize_exists')
) {
$tmp['result'] = array(
'type' => 'archive',
'path' => base64_encode( $rec['filename'].'.'.Config::get('system.archive_format') ),
);
}
# Факс
//else if (file_exists($rec['path']) && preg_match('#(.*)\.tiff?$#i', $rec['filename']) && $rec['filesize'] >= Config::get('system.fsize_exists')) {
else if ( is_file($rec['path'])
&& $recorded_file
&& filesize($rec['path'])/1024 >= Config::get('system.fsize_exists')
) {
$tmp['result'] = array(
'type' => 'fax',
'path' => base64_encode($rec['filename']),
);
}
return $tmp['result'];
}
/* CDR Table Display Functions */
function formatCallDate($calldate, $uniqueid) {
//$calldate = date('d.m.Y H:i:s', strtotime($calldate));
echo ''.$calldate.' | ' . PHP_EOL;
}
function formatChannel($channel) {
$chan['short'] = preg_replace('#(.*)\/[^\/]+$#', '$1', $channel);
$chan['full'] = preg_replace('#(.*)-[^-]+$#', '$1', $channel);
$chan['tooltip'] = $chan['full'];
$chan['txt'] = $chan['short'];
if ( Config::exists('display.main.full_channel_tooltip') && Config::get('display.main.full_channel_tooltip') == 1 ) {
$chan['tooltip'] = $channel;
}
if ( Config::exists('display.main.full_channel') && Config::get('display.main.full_channel') == 1 ) {
$chan['txt'] = $chan['full'];
}
echo ''.$chan['txt'].' | ' . PHP_EOL;
}
function formatClid($clid) {
$clid_only = explode(' <', $clid, 2);
$clid_only = htmlspecialchars($clid_only[0]);
$clid = htmlspecialchars($clid);
echo ''.$clid_only.' | ' . PHP_EOL;
}
function formatSrc($src, $clid) {
if ( empty($src) ) {
echo 'Неизвестно | ' . PHP_EOL;
} else {
$src = htmlspecialchars($src);
$clid = htmlspecialchars($clid);
$src_show = $src;
$clipboard = 'data-clipboard data-clipboard-text="'.$clid.'"';
if ( is_numeric($src) && strlen($src) >= Config::get('display.lookup.num_length') && strlen(Config::get('display.lookup.url')) > 0 ) {
$rev = str_replace( '%n', $src, Config::get('display.lookup.url') );
$src_show = ''.$src.'';
$clipboard = '';
}
echo ''.$src_show.' | ' . PHP_EOL;
}
}
function formatApp($app, $lastdata) {
$tooltip = $app . '(' . $lastdata . ')';
echo ''.$app.' | ' . PHP_EOL;
}
function formatDst($dst, $dcontext) {
$dst_show = $dst;
$clipboard = 'data-clipboard data-clipboard-text="'.$dcontext.'"';
if ( is_numeric($dst) && strlen($dst) >= Config::get('display.lookup.num_length') && strlen(Config::get('display.lookup.url')) > 0 ) {
$rev = str_replace( '%n', $dst, Config::get('display.lookup.url') );
$dst_show = ''.$dst.'';
$clipboard = '';
}
echo ''.$dst_show.' | ' . PHP_EOL;
}
function formatDisposition($disposition, $amaflags) {
switch ($amaflags) {
case 0:
$amaflags = 'DOCUMENTATION';
break;
case 1:
$amaflags = 'IGNORE';
break;
case 2:
$amaflags = 'BILLING';
break;
case 3:
default:
$amaflags = 'DEFAULT';
}
// Стиль текста для вызовов
$style = '';
switch ($disposition) {
case 'ANSWERED':
$dispTxt = 'Отвечено';
$style = 'answer';
break;
case 'NO ANSWER':
$dispTxt = 'Не отвечено';
$style = 'noanswer';
break;
case 'BUSY':
$dispTxt = 'Занято';
$style = 'busy';
break;
case 'FAILED':
$dispTxt = 'Ошибка';
$style = 'failed';
break;
case 'CONGESTION':
$dispTxt = 'Перегрузка';
$style = 'congestion';
break;
// FreeSWITCH
case 'NORMAL_CLEARING':
$dispTxt = 'Отвечено FS';
$style = 'answer';
break;
case 'NORMAL_UNSPECIFIED':
$dispTxt = 'Отвечено FS (возможно прерван)';
$style = 'answer';
break;
case 'RECOVERY_ON_TIMER_EXPIRE':
$dispTxt = 'Не отвечено FS';
$style = 'noanswer';
break;
case 'ORIGINATOR_CANCEL':
$dispTxt = 'Звонящий отменил FS';
$style = 'noanswer';
break;
case 'USER_BUSY':
$dispTxt = 'Занято FS';
$style = 'busy';
break;
case 'CALL_REJECTED':
$dispTxt = 'Ошибка FS';
$style = 'failed';
break;
case 'USER_NOT_REGISTERED':
$dispTxt = 'Пользователь не зарегистрирован FS';
$style = 'failed';
break;
case 'NO_USER_RESPONSE':
$dispTxt = 'Нет ответа FS';
$style = 'failed';
break;
case 'UNALLOCATED_NUMBER':
$dispTxt = 'Несуществующий номер FS';
$style = 'failed';
break;
case 'NORMAL_TEMPORARY_FAILURE':
$dispTxt = 'Перегрузка FS';
$style = 'congestion';
break;
default:
$dispTxt = $disposition;
}
echo ''.$dispTxt.' | ' . PHP_EOL;
}
function formatDuration($duration, $billsec) {
$duration = sprintf( '%02d', intval($duration/60) ).':'.sprintf( '%02d', intval($duration%60) );
$billduration = sprintf( '%02d', intval($billsec/60) ).':'.sprintf( '%02d', intval($billsec%60) );
echo ''.$duration.' | ' . PHP_EOL;
}
function formatDurWait($duration, $billsec) {
$durwait = $duration - $billsec;
$durwait = sprintf( '%02d', intval($durwait/60) ).':'.sprintf( '%02d', intval($durwait%60) );
$duration = sprintf( '%02d', intval($duration/60) ).':'.sprintf( '%02d', intval($duration%60) );
echo ''.$durwait.' | ' . PHP_EOL;
}
function formatBillSec($duration, $billsec) {
$duration = sprintf( '%02d', intval($duration/60) ).':'.sprintf( '%02d', intval($duration%60) );
$billduration = sprintf( '%02d', intval($billsec/60) ).':'.sprintf( '%02d', intval($billsec%60) );
echo ''.$billduration.' | ' . PHP_EOL;
}
function formatUserField($userfield) {
echo ''.$userfield.' | ' . PHP_EOL;
}
function formatAccountCode($accountcode) {
echo ''.$accountcode.' | ' . PHP_EOL;
}
/* Asterisk RegExp parser */
function asteriskregexp2sqllike($source_data, $user_num) {
$number = $user_num;
if (strlen($number) < 1) {
$number = $_REQUEST[$source_data];
}
if ('__' == substr($number,0,2)) {
$number = substr($number,1);
} elseif ('_' == substr($number,0,1)) {
$number_chars = preg_split('//', substr($number,1), -1, PREG_SPLIT_NO_EMPTY);
$number = '';
foreach ($number_chars as $chr) {
if ($chr == 'X') {
$number .= '[0-9]';
} elseif ($chr == 'Z') {
$number .= '[1-9]';
} elseif ($chr == 'N') {
$number .= '[2-9]';
} elseif ($chr == '.') {
$number .= '.+';
} elseif ($chr == '!') {
$_REQUEST[ $source_data .'_neg' ] = 'true';
} else {
$number .= $chr;
}
}
$_REQUEST[$source_data .'_mod'] = 'asterisk-regexp';
}
return $number;
}
/* empty() wrapper */
function is_blank(&$value) {
if ( isset($value) ) {
return empty($value) && !is_numeric($value);
}
return true;
}
/*
Money format
*/
// cents: 0=never, 1=if needed, 2=always
// title: title to show
function formatMoney($number, $cents = 2, $title = '') {
if ( is_numeric($number) ) {
// whole number
if ( floor($number) == $number ) {
$money = number_format( $number, ($cents == 2 ? 2 : 0) ); // format
} else { // cents
$money = number_format( round($number, 2), ($cents == 0 ? 0 : 2) ); // format
} // integer or decimal
if ( $title ) {
$title = ' class="simptip-position-top simptip-smooth simptip-fade" data-clipboard data-clipboard-text="'.$title.'" data-tooltip="'.$title.'"';
}
echo ''.$money.''.Config::get('callrate.currency').' | ' . PHP_EOL;
} else {
echo ' | ' . PHP_EOL;
}
}
/*
CallRate
return callrate array [ areacode, rate, description, bill type, total_rate]
*/
function callrates($dst, $duration, $file) {
global $callrate_cache;
if (strlen($file) == 0) {
$file = Config::get('callrate.csv_file');
if (strlen($file) == 0) {
return array('', '', '', '', '');
}
}
if (!array_key_exists($file, $callrate_cache)) {
$callrate_cache[$file] = array();
$fr = fopen($file, 'r') or exit('Не удалось открыть файл с тарифами ('.$file.')');
while (($fr_data = fgetcsv($fr, 1000, ',')) !== false) {
if ($fr_data[0] !== null) {
// Не указан доп. тариф
if ( !isset($fr_data[4]) ) {
$fr_data[4] = null;
}
$callrate_cache[$file][$fr_data[0]] = array($fr_data[1], $fr_data[2], $fr_data[3], $fr_data[4]);
}
}
fclose($fr);
}
for ($i = strlen($dst); $i > 0; $i--) {
if (array_key_exists(substr($dst,0,$i), $callrate_cache[$file])) {
$call_rate = 0;
if ($callrate_cache[$file][substr($dst,0,$i)][2] == 's') {
// per second
if ( $duration >= Config::get('callrate.free_interval') ) {
$call_rate = $duration * ($callrate_cache[$file][substr($dst,0,$i)][0] / 60);
}
} elseif ($callrate_cache[$file][substr($dst,0,$i)][2] == 'c') {
// per call
if ( $duration >= Config::get('callrate.free_interval') ) {
$call_rate = $callrate_cache[$file][substr($dst,0,$i)][0];
}
} elseif ($callrate_cache[$file][substr($dst,0,$i)][2] == '1m+s') {
// 1 minute + per second
if ( $duration < Config::get('callrate.free_interval') ) {}
else if ( $duration < 60 ) {
$call_rate = $callrate_cache[$file][substr($dst,0,$i)][0];
} else {
// указан доп тариф
if (isset($callrate_cache[$file][substr($dst,0,$i)][3]) && $callrate_cache[$file][substr($dst,0,$i)][3] && $callrate_cache[$file][substr($dst,0,$i)][3] > 0) {
$ext_rate = $callrate_cache[$file][substr($dst,0,$i)][3];
} else {
$ext_rate = $callrate_cache[$file][substr($dst,0,$i)][0]/60;
}
$call_rate = $callrate_cache[$file][substr($dst,0,$i)][0] + ( ($duration-60) * ($ext_rate) );
}
} elseif ($callrate_cache[$file][substr($dst,0,$i)][2] == '30s+s') {
// 30 second + per second
if ($duration > 0 && $duration <= 30) {
$call_rate = ($callrate_cache[$file][substr($dst,0,$i)][0] / 2);
} elseif ( $duration > 30 && $duration < 60) {
$call_rate = ($callrate_cache[$file][substr($dst,0,$i)][0] / 2) + (($duration-30) * ($callrate_cache[$file][substr($dst,0,$i)][0] / 60));
} else {
$call_rate = $callrate_cache[$file][substr($dst,0,$i)][0] + (($duration-60) * ($callrate_cache[$file][substr($dst,0,$i)][0] / 60));
}
} elseif ($callrate_cache[$file][substr($dst,0,$i)][2] == '30s+6s') {
// 30 second + 6 second
if ($duration > 0 && $duration <= 30) {
$call_rate = ($callrate_cache[$file][substr($dst,0,$i)][0] / 2);
} else {
$call_rate = ceil($duration / 6) * ($callrate_cache[$file][substr($dst,0,$i)][0] / 10);
}
} else {
//( $callrate_cache[substr($dst,0,$i)][2] == 'm' ) {
// per minute
if ( $duration >= Config::get('callrate.free_interval') ) {
// всего минут разговор
$call_rate = ceil($duration/60);
// указан доп тариф
if (isset($callrate_cache[$file][substr($dst,0,$i)][3]) && $callrate_cache[$file][substr($dst,0,$i)][3] && $callrate_cache[$file][substr($dst,0,$i)][3] > 0) {
$call_rate = $callrate_cache[$file][substr($dst,0,$i)][0] + ( ($call_rate-1) * $callrate_cache[$file][substr($dst,0,$i)][3] );
} else {
$call_rate = $call_rate*$callrate_cache[$file][substr($dst,0,$i)][0];
}
}
}
return array(substr($dst,0,$i),$callrate_cache[$file][substr($dst,0,$i)][0],$callrate_cache[$file][substr($dst,0,$i)][1],$callrate_cache[$file][substr($dst,0,$i)][2],$call_rate);
}
}
return array (0, 0, 'Неизвестно', 'Неизвестно', 0);
}
/*
Connect to DB. Return PDO object
$errors - show connection errors
*/
function dbConnect( $errors = true ) {
$dbh = null;
try {
$dbh = new PDO(
Config::get('db.type') .
':host=' . Config::get('db.host') .
';port=' . Config::get('db.port') .
';dbname=' . Config::get('db.name'),
Config::get('db.user'),
Config::get('db.pass'),
Config::get('db.options')
);
}
catch (PDOException $e) {
if ( $errors === true ) {
echo "\nPDO::errorInfo():\n";
print $e->getMessage();
}
}
return $dbh;
}