} echo '<center><br><h3>' . __('Добавление/удаление аккаунтов из очереди') . '</h3><br> <TABLE border=0 cellPadding=3 cellSpacing=0 width="50%"> <TBODY> <TR bgColor=#F0F0F0> <TD width="50%" align=middle class="tableBody" style="PADDING-BOTTOM: 2px; PADDING-LEFT: 2px; PADDING-RIGHT: 2px; PADDING-TOP: 2px"> <center><strong>' . __('SIP-аккаунты') . '</strong></center></TD> <TD width="50%" align=middle class="tableBody" style="PADDING-BOTTOM: 2px; PADDING-LEFT: 2px; PADDING-RIGHT: 2px; PADDING-TOP: 2px"> <center><strong>' . __('Члены очереди') . '</strong></center></TD> </TR> '; $sipusers = values("SELECT * FROM " . $conf_realtime_db . ".sipusers WHERE 1 ORDER BY name"); $members_accs = ''; $sip_accs = ''; $sip_user_names = get_sipuser_names(); for ($i = 0; $i < count($sipusers); $i++) { $members = values("SELECT * FROM " . $conf_realtime_db . ".queue_members WHERE membername='" . $sipusers[$i]["name"] . "' AND queue_name='" . $queue . "'"); if (count($members) > 0) { $members_accs .= '<a href="index.php?remove=' . $sipusers[$i]["name"] . '&queue=' . $queue . '">' . add_sipuser_name($sipusers[$i]["name"], $sip_user_names) . '</a><br>'; } else { $sip_accs .= '<a href="index.php?add=' . $sipusers[$i]["name"] . '&queue=' . $queue . '">' . add_sipuser_name($sipusers[$i]["name"], $sip_user_names) . '</a><br>'; } } echo '<TR bgcolor="#F2F8FF"> <TD vAlign=top align="center" class=tableBody>' . $sip_accs . '</TD> <TD vAlign=top align="center" class=tableBody>' . $members_accs . '</TD> </TR>'; echo '</TBODY> </table> </center>'; }
if ($result_set[$i]['disposition'] == "BUSY" or $result_set[$i]['dstchannel'] == '') { $result_set[$i]['disposition'] = __('Нет ответа'); $status_color = '#FDE2D5'; } } if ($result_set[$i]['src'] <= 9999 and $result_set[$i]['dst'] <= 9999) { $direct_icon = '<img src="images/inner.png" alt="' . __('Внутренние') . '" title="' . __('Внутренние') . '">'; } $start_src = $result_set[$i]['src']; $start_dst = $result_set[$i]['dst']; $find_param = array(to_format_number($start_src), to_format_number($start_dst)); $result_set[$i]['src'] = format_number($result_set[$i]['src']); $result_set[$i]['dst'] = format_number($result_set[$i]['dst']); $sip_user_names = get_sipuser_names(); $result_set[$i]['src'] = add_sipuser_name($start_src, $sip_user_names, $result_set[$i]['src']); $result_set[$i]['dst'] = add_sipuser_name($start_dst, $sip_user_names, $result_set[$i]['dst']); if (strpos(' ' . $result_set[$i]['dstchannel'], 'SIP')) { $result_set[$i]['dst'] .= ' (' . substr(str_replace('SIP/', '', $result_set[$i]['dstchannel']), 0, strpos(str_replace('SIP/', '', $result_set[$i]['dstchannel']), '-')) . ')'; } //сюда вписать абонента, если он есть $choose_src_abonents = values("SELECT phone_number, abonent FROM " . $conf_statistic_db . ".addressbook WHERE phone_number = \"" . $find_param[0] . "\""); $choose_dest_abonents = values("SELECT phone_number, abonent FROM " . $conf_statistic_db . ".addressbook WHERE phone_number = \"" . $find_param[1] . "\""); $abonents = []; if (count($choose_src_abonents) > 0) { $abonents[0] = "" . $choose_src_abonents[0][1] . "<br>"; } else { $abonents[0] = ""; } if (count($choose_dest_abonents) > 0) { $abonents[1] = "" . $choose_dest_abonents[0][1] . "<br>"; } else {
$perc = 0; } else { $perc = round($lost[0]['c'] * 100 / ($incoming[0]['c'] + $lost[0]['c'])); } $active_time = values("SELECT SUM(length) AS dur FROM firestat.operators_events WHERE operator=" . $operators[$i]['Name'] . " AND eventtype=1 AND eventtime BETWEEN '" . $from . "' AND '" . $to . "'"); $last_active_time = values("SELECT UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(eventtime) AS dur FROM firestat.operators_events WHERE operator=" . $operators[$i]['Name'] . " AND eventtype=1 AND length=0 AND eventtime BETWEEN '" . $from . "' AND '" . $to . "' ORDER BY eventtime DESC LIMIT 1"); if (count($last_active_time) == 0) { $work_time = $active_time[0]['dur']; } else { $work_time = $active_time[0]['dur'] + $last_active_time[0]['dur']; } $sip_user_names = get_sipuser_names(); $out .= ' <TR bgcolor="' . $status_color . '" onMouseOver="bgColor=\'#C4FFD7\'" onMouseOut="bgColor=\'' . $status_color . '\'" onMouseClick="bgColor=\'#C4FFD7\'"> <TD vAlign=top align="" class=tableBody> </TD> <TD vAlign=top align="right" class=tableBody><a href="index.php?module=' . $sModule . '&operator=' . $operators[$i]['Name'] . '&posted=1">' . add_sipuser_name($operators[$i]['Name'], $sip_user_names) . '</a></TD> <TD vAlign=top align="center" class=tableBody>' . format_time($work_time, 1) . '</TD> <TD vAlign=top align="center" class=tableBody>' . $pauses[0]['c'] . '</TD> <TD vAlign=top align="left" class=tableBody>' . format_time($pauses[0]['dur'], 1) . '</TD> <TD vAlign=top align="center" class=tableBody>graph_plot_' . $operators[$i]["Name"] . '</TD> <TD vAlign=top align="center" class=tableBody>' . $incoming[0]['c'] . '</TD> <TD vAlign=top align="center" class=tableBody>' . $lost[0]['c'] . '</TD> <TD vAlign=top align="center" class=tableBody>' . $perc . '%</TD>