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>&nbsp;</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>&nbsp;</td>";
        }
        print "\n\t\t<td>" . $GUI_LANG['Pages'] . ":</td>\n\t";
        if ($page < $pages - 2) {
            $nextGoPage = $page + 1;
            print "<td>&nbsp;<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>&nbsp;<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 
}
Example #2
0
            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>&nbsp;</p>
Example #3
0
     $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}&nbsp;</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));
 }
Example #5
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}&nbsp;</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));
 }
Example #6
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>&nbsp;</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])) {
Example #7
0
 $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>&nbsp;</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)) {
Example #8
0
 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>&nbsp;</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;
         }