function pagesNavigator($pages, $page) { global $local_page, $local_search, $GUI_LANG, $toprint, $local_order, $order, $local_sortBy, $sortBy, $search, $skin_name; ?> <?php // Печатаем навигатор по страницам if ($pages > 1 && !$toprint) { echo '<table cellpadding=1 cellspacing=0 border=0 align=center><tr>'; if ($page > 0) { print "<td><a href=\"" . complitLink($local_page = "0", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['FirstPage'] . " (1)\"><img border=0 width=11 height=10 src=\"../include/img/colors/" . $skin_name . "/arrows/pages_left.gif\" alt=\"" . $GUI_LANG['FirstPage'] . "\"></a> </td>"; } if ($page > 1) { $prevGoPage = $page - 1; print "<td><a href=\"" . complitLink($local_page = "{$prevGoPage}", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['PreviousPage'] . " ({$page})\"><img border=0 width=12 height=10 src=\"../include/img/colors/" . $skin_name . "/arrows/next_left.gif\" alt=\"" . $GUI_LANG['PreviousPage'] . "\"></a> </td>"; } print "\n\t\t<td>" . $GUI_LANG['Pages'] . ":</td>\n\t"; if ($page < $pages - 2) { $nextGoPage = $page + 1; print "<td> <a href=\"" . complitLink($local_page = "{$nextGoPage}", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['NextPage'] . " (" . ($nextGoPage + 1) . ")\"><img border=0 width=12 height=10 src=\"../include/img/colors/" . $skin_name . "/arrows/next_right.gif\" alt=\"" . $GUI_LANG['NextPage'] . "\"></a></td>"; } if ($page < $pages - 1) { $nextGoPage = $pages - 1; print "<td> <a href=\"" . complitLink($local_page = "{$nextGoPage}", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['LastPage'] . " ({$pages})\"><img border=0 width=11 height=10 src=\"../include/img/colors/" . $skin_name . "/arrows/pages_right.gif\" alt=\"" . $GUI_LANG['LastPage'] . "\"></td>"; } ?> </tr> </table> <br> <table cellpadding=2 cellspacing=0 border=0 align=center> <tr><td> <?php // Печатаем список страниц $startList = 1; $stopList = 1; $numbers = 10; // Количество печатаемых одновременно страниц. if ($pages > 1) { $startList = floor($page / $numbers) * $numbers + 1; $stopList = $startList + $numbers - 1; if ($startList > 1) { $prevList = $startList - 2; print "<a href=\"" . complitLink($local_page = "{$prevList}", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['PreviousListOfPages'] . "\"><img border=0 width=10 height=10 src=../include/img/colors/" . $skin_name . "/arrows/end_left.gif> ...</a> "; } $Num = $startList - 1; for ($zu = $startList; $zu <= $stopList; $zu++) { if ($zu <= $pages && 1 <= $zu) { if ($zu == $page + 1) { echo " <font size=+1>{$zu}</font> "; } else { echo " <a href=\"" . complitLink($local_page = "{$Num}", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['Page'] . " {$zu}\">{$zu}</a> "; } } $Num++; } if ($stopList < $pages) { $nextList = $stopList; print "<a href=\"" . complitLink($local_page = "{$nextList}", $local_order = $order, $local_sortBy = $sortBy, $local_search = $search) . "\" title=\"" . $GUI_LANG['NextListOfPages'] . "\">... <img border=0 width=10 height=10 src=../include/img/colors/" . $skin_name . "/arrows/end_right.gif></a>"; } } echo '</td></tr></table>'; } //echo("</td></tr><tr><td>pages = $pages, page = $page, startLine = $startLine, lastLine = $lastLine, startList = $startList, stopList = $stopList"); ?> <?php }
print "<br><a href='" . complitLink($local_diatype = 'pie') . "'>" . $GUI_LANG['RelativeQuantityOfCalls'] . "</a>"; } if ($diatype != 'bars' && $diatype != 'all') { print "<br><a href='" . complitLink($local_diatype = 'bars') . "'>" . $GUI_LANG['QuantityOfCalls'] . "</a>"; } if ($diatype != 'dur' && $diatype != 'all') { print "<br><a href='" . complitLink($local_diatype = 'dur') . "'>" . $GUI_LANG['DurationOfCalls'] . "</a>"; } } ?> <div align=center> <?php if (empty($diatype) or $diatype == 'pie' or $diatype == 'all') { print "<br><img src=\"../diagram/diagram_pie.php" . complitLink() . "\" width=600 height=300 alt='" . $GUI_LANG['RelativeQuantityOfCalls'] . "'>"; } if ($diatype == 'all' or $diatype == 'bars') { print "<br><img src=\"../diagram/diagram_bars.php" . complitLink() . "\" width=600 height=300 alt='" . $GUI_LANG['QuantityOfCalls'] . "'>"; } if ($diatype == 'all' or $diatype == 'dur') { print "<br><img src=\"../diagram/diagram_bars_dur.php" . complitLink() . "\" width=600 height=300 alt='" . $GUI_LANG['DurationOfCalls'] . "'>"; } } else { ?> <div align=center> <?php echo $GUI_LANG['GDSupportIsDisabled']; } ?> </div> <p> </p>
$expor_excel->MontaConteudo(1, 1, " "); $expor_excel->mid_sqlparaexcel(); } $anyDigit = 1; $linha = 0; if (!isset($noAbonents)) { $noAbonents = 0; } while ($row = $res->FetchRow()) { if (!empty($row[1]) && !$noAbonents) { $intPhoneDescription = "({$row['1']})"; } else { $intPhoneDescription = ""; } if (empty($export)) { echo "<tr " . $COLORS['BaseTrBgcolor'] . " onmouseover=\"setPointer(this, {$anyDigit}, 'over');\" onmouseout=\"setPointer(this, {$anyDigit}, 'out');\" onmousedown=\"setPointer(this, {$anyDigit}, 'click');\">\n\t\t\t\t <td nowrap>\n\t\t\t\t\t<a href=\"" . complitLink($local_int = "{$row['0']}", $local_type = "IntDetail") . "\" title=\"" . $GUI_LANG['InDetails'] . ". " . $GUI_LANG['CallsFromInternalPhone'] . " {$row['0']} {$intPhoneDescription}\">{$row['0']}</a>\n\t\t\t\t\t{$intPhoneDescription}\n\t\t\t\t </td>\n\t\t\t\t <td>\n\t\t\t\t\t<a href=\"" . complitLink($local_int = "{$row['0']}", $local_type = "IntNum") . "\" title=\"" . $GUI_LANG['NumbersFromInternalPhone'] . " {$row['0']} {$intPhoneDescription}\">{$row['2']}</a>\n\t\t\t\t </td>"; } else { $expor_excel->MontaConteudo($linha + 2, 0, $row[0] . " " . $intPhoneDescription); $expor_excel->MontaConteudo($linha + 2, 1, $row[2]); } if (empty($CityLine)) { if (empty($export)) { echo "<td>" . sumTotal($row[3], 0) . "</td>"; } else { $expor_excel->MontaConteudo($linha + 2, 2, sumTotal($row[3], 0)); } } if (empty($TrunkLine)) { if (empty($export)) { echo "<td>" . sumTotal($row[4], 0) . "</td>"; } else {
$coLine = $row[1]; $CallNumber = $row[2]; $Duration = $row[3]; $CallWay = $row[4]; $NamedLine = $row[5]; $NamedPhone = $row[6]; $PhonebookDescription = $row[7]; $NumberIs = setNumberIs(); $intPhoneDescription = setPhoneDescription(); $NumberDescription = SetNumberDescription(); $coLineDescription = SetLineDescription(); setCollColor(); if (empty($export)) { echo "<tr " . $COLORS['BaseTrBgcolor'] . " onmouseover=\"setPointer(this, {$anyDigit}, 'over');\" onmouseout=\"setPointer(this, {$anyDigit}, 'out');\" onmousedown=\"setPointer(this, {$anyDigit}, 'click');\">"; echo "<td nowrap>{$FontColor}{$timeOfCall}{$FontColorEnd}</td>"; echo "<td><a href=\"" . complitLink($local_type = "IntCoDetail", $local_co = "{$coLine}") . "\" title=\"" . $GUI_LANG['CallsFromInternalPhone'] . " {$int} {$intPhoneDescription}, " . $GUI_LANG['ThroughAnExternalLine'] . " {$coLine} {$coLineDescription}\">{$coLine}</a> {$coLineDescription}{$FontColorEnd}</td>"; echo "<td><table width=100%>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t <td width=1%>{$FontColor}{$NumberIs}{$FontColorEnd} </td>\n\t\t\t\t\t\t {$NumberDescription}\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t </table>\n\t\t\t\t\t</td>"; echo "<td>{$FontColor}" . sumTotal($Duration, 0) . "{$FontColorEnd}</td>"; echo "</TR>\n"; } else { if (!empty($PhonebookDescription)) { $PhonebookDescription = " " . $PhonebookDescription; } if (!empty($coLineDescription)) { $coLineDescription = " " . $coLineDescription; } $expor_excel->MontaConteudo($linha + 2, 0, $timeOfCall); $expor_excel->MontaConteudo($linha + 2, 1, $coLine . $coLineDescription); $expor_excel->MontaConteudo($linha + 2, 2, $NumberIs . $PhonebookDescription); $expor_excel->MontaConteudo($linha + 2, 3, sumTotal($Duration, 0)); }
$intPhone = $row[1]; $CallNumber = $row[2]; $Duration = $row[3]; $CallWay = $row[4]; $NamedLine = $row[5]; $NamedPhone = $row[6]; $PhonebookDescription = $row[7]; $NumberIs = setNumberIs(); $intPhoneDescription = setPhoneDescription(); $NumberDescription = SetNumberDescription(); $coLineDescription = SetLineDescription(); setCollColor(); if (empty($export)) { echo "<tr " . $COLORS['BaseTrBgcolor'] . " onmouseover=\"setPointer(this, {$anyDigit}, 'over');\" onmouseout=\"setPointer(this, {$anyDigit}, 'out');\" onmousedown=\"setPointer(this, {$anyDigit}, 'click');\">"; echo "<td nowrap>{$FontColor}{$timeOfCall}{$FontColorEnd}</td>"; echo "<td><a href=\"" . complitLink($local_type = "CoIntDetail", $local_int = "{$intPhone}") . "\" title=\"" . $GUI_LANG['CallsThroughAnExternalLine'] . " {$co} {$coLineDescription} " . $GUI_LANG['FromInternalPhone'] . " {$intPhone} {$intPhoneDescription}\">{$intPhone}</a> {$intPhoneDescription}</td>"; echo "<td>\n\t\t\t\t <table width=100%>\n\t\t\t\t\t<tr>\n\t\t\t\t\t <td width=1%>{$FontColor}{$NumberIs}{$FontColorEnd} </td>\n\t\t\t\t\t {$NumberDescription}\n\t\t\t\t\t</tr>\n\t\t\t\t </table>\n\t\t\t\t </td>"; echo "<TD>{$FontColor}" . sumTotal($Duration, 0) . "{$FontColorEnd}</TD>"; echo "</TR>\n"; } else { if (!empty($PhonebookDescription)) { $PhonebookDescription = " " . $PhonebookDescription; } if (!empty($intPhoneDescription)) { $intPhoneDescription = " " . $intPhoneDescription; } $expor_excel->MontaConteudo($linha + 2, 0, $timeOfCall); $expor_excel->MontaConteudo($linha + 2, 1, $intPhone . $intPhoneDescription); $expor_excel->MontaConteudo($linha + 2, 2, $NumberIs . $PhonebookDescription); $expor_excel->MontaConteudo($linha + 2, 3, sumTotal($Duration, 0)); }
$linha = 0; while (!$res->EOF) { $row = $res->fields; $CallNumber = $row[0]; $CallWay = $row[3]; $NamedLine = $row[4]; $PhonebookDescription = $row[5]; $NumberIs = setNumberIs(); $intPhoneDescription = setPhoneDescription(); $NumberDescription = SetNumberDescription(); $coLineDescription = SetLineDescription(); setCollColor(); if (empty($export)) { echo "<tr " . $COLORS['BaseTrBgcolor'] . " onmouseover=\"setPointer(this, {$anyDigit}, 'over');\" onmouseout=\"setPointer(this, {$anyDigit}, 'out');\" onmousedown=\"setPointer(this, {$anyDigit}, 'click');\">"; echo "<td nowrap>{$FontColor}{$NumberIs}{$FontColorEnd}</td>"; echo "<td>\n\t\t\t\t <table width=100%>\n\t\t\t\t\t<tr>\n\t\t\t\t\t <td width=1%><a href=\"" . complitLink($local_type = "CoNumDetail", $local_num = $CallNumber) . "\" title=\"" . $GUI_LANG['Number'] . ": {$NumberIs}, " . $GUI_LANG['ThroughAnExternalLine'] . ": {$co} {$coLineDescription}\">{$row['1']}</a> </td>\n\t\t\t\t\t {$NumberDescription}\n\t\t\t\t\t</tr>\n\t\t\t\t </table>\n\t\t\t\t </td>"; echo "<TD>{$FontColor}" . sumTotal($row[2], 0) . "{$FontColorEnd}</TD>"; echo "</TR>\n"; } else { if (!empty($PhonebookDescription)) { $PhonebookDescription = " " . $PhonebookDescription; } $expor_excel->MontaConteudo($linha + 2, 0, $NumberIs); $expor_excel->MontaConteudo($linha + 2, 1, $row[1] . $PhonebookDescription); $expor_excel->MontaConteudo($linha + 2, 2, sumTotal($row[2], 0)); } array($InAll); if (!empty($row[1])) { $InAll[0]++; } if (!empty($row[1])) {
$linha = 0; while (!$res->EOF) { $row = $res->fields; $CallNumber = $row[0]; $Duration = $row[2]; $CallWay = $row[3]; $PhonebookDescription = $row[4]; $NumberIs = setNumberIs(); $intPhoneDescription = setPhoneDescription(); $NumberDescription = SetNumberDescription(); $coLineDescription = SetLineDescription(); setCollColor(); if (empty($export)) { echo "<tr " . $COLORS['BaseTrBgcolor'] . " onmouseover=\"setPointer(this, {$anyDigit}, 'over');\" onmouseout=\"setPointer(this, {$anyDigit}, 'out');\" onmousedown=\"setPointer(this, {$anyDigit}, 'click');\">"; echo "<td nowrap>{$FontColor}{$NumberIs}{$FontColorEnd}</td>"; echo "<td><table width=100%>\n\t\t\t\t\t<tr>\n\t\t\t\t\t <td width=1%><a href=\"" . complitLink($local_type = "NumDetail", $local_num = "{$CallNumber}") . "\" title=\"" . $GUI_LANG['CallsOnTheNumber'] . ": {$NumberIs}\">{$row['1']}</a> </td>\n\t\t\t\t\t {$NumberDescription}\n\t\t\t\t\t</tr>\n\t\t\t\t </table>\n\t\t\t\t </td>"; echo "<TD>{$FontColor}" . sumTotal($Duration, 0) . "{$FontColorEnd}</TD>"; echo "</TR>\n"; } else { if (!empty($PhonebookDescription)) { $PhonebookDescription = " " . $PhonebookDescription; } $expor_excel->MontaConteudo($linha + 2, 0, $NumberIs); $expor_excel->MontaConteudo($linha + 2, 1, $row[1] . $PhonebookDescription); $expor_excel->MontaConteudo($linha + 2, 2, sumTotal($Duration, 0)); } array($InAll); if (!empty($row[1])) { $InAll[0]++; } if (!empty($Duration)) {
while (!$res->EOF) { $row = $res->fields; $CallNumber = $row[0]; $Duration = $row[2]; $CallWay = $row[3]; $NamedPhone = $row[4]; $PhonebookDescription = $row[5]; $NumberIs = setNumberIs(); $intPhoneDescription = setPhoneDescription(); $NumberDescription = SetNumberDescription(); $coLineDescription = SetLineDescription(); setCollColor(); if (empty($export)) { echo "<tr " . $COLORS['BaseTrBgcolor'] . " onmouseover=\"setPointer(this, {$anyDigit}, 'over');\" onmouseout=\"setPointer(this, {$anyDigit}, 'out');\" onmousedown=\"setPointer(this, {$anyDigit}, 'click');\">"; echo "<td>{$FontColor}{$NumberIs}{$FontColorEnd}</td></td>"; echo "<td><table width=100%>\n\t\t\t\t\t <tr>\n\t\t\t\t\t\t<td width=1%><a href=\"" . complitLink($local_type = "IntNumDetail", $local_num = "{$CallNumber}") . "\" title=\"" . $GUI_LANG['Number'] . ": {$NumberIs}, " . $GUI_LANG['FromInternalPhone'] . ": {$int} {$intPhoneDescription}\">{$row['1']}</a> </td>\n\t\t\t\t\t\t{$NumberDescription}\n\t\t\t\t\t </tr>\n\t\t\t\t\t</table></td>"; echo "<TD>{$FontColor}" . sumTotal($Duration, 0) . "{$FontColorEnd}</TD>"; echo "</TR>\n"; } else { if (!empty($PhonebookDescription)) { $PhonebookDescription = " " . $PhonebookDescription; } $expor_excel->MontaConteudo($linha + 2, 0, $NumberIs); $expor_excel->MontaConteudo($linha + 2, 1, $row[1] . $PhonebookDescription); $expor_excel->MontaConteudo($linha + 2, 2, sumTotal($Duration, 0)); } if (!isset($InAll)) { $InAll = array(); for ($i = 0; $i < 3; $i++) { $InAll[$i] = 0; }