PHP setupNumbering Examples

Programming Language: PHP

Method/Function: setupNumbering

Examples at hotexamples.com: 9

PHP setupNumbering - 9 examples found. These are the top rated real world PHP examples of setupNumbering extracted from open source projects. You can rate examples to help us improve the quality of examples.

Example #1

Show file

File: mng-rad-hunt-list.php Project: fortitudezhang/daloradius

$sql = "SELECT * FROM " . $configValues['CONFIG_DB_TBL_RADHG'];
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
$numrows = $res->numRows();
$sql = "SELECT * FROM " . $configValues['CONFIG_DB_TBL_RADHG'] . " ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<form name='listallhunt' method='post' action='mng-rad-hunt-del.php'>";
echo "<table border='0' class='table1'>\n";
echo "\n\t\t\t\t\t<thead>\n                                                        <tr>\n                                                        <th colspan='4' align='left'>\n\n                                Select:\n                                <a class=\"table\" href=\"javascript:SetChecked(1,'nashost[]','listallhunt')\">All</a>\n\n                                <a class=\"table\" href=\"javascript:SetChecked(0,'nashost[]','listallhunt')\">None</a>\n                        <br/>\n                                <input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listallhunt\",\"mng-rad-hunt-del.php\")' />\n                                <br/><br/>\n\n\n                ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType);
}
echo " </th></tr>\n                                        </thead>\n\n                        ";
if ($orderType == "asc") {
    $orderType = "desc";
} else {
    if ($orderType == "desc") {
        $orderType = "asc";
    }
}
echo "<thread> <tr>\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType={$orderType}\">\n\t\t" . $l['all']['HgID'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=nasipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['HgIPHost'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=groupname&orderType={$orderType}\">\n\t\t" . $l['all']['HgGroupName'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=nasportid&orderType={$orderType}\">\n\t\t" . $l['all']['HgPortId'] . "</a>\n\t\t<br/>\n\t\t</th>\n\n\t</tr> </thread>";
while ($row = $res->fetchRow()) {
    echo "<tr>\n                                <td> <input type='checkbox' name='nashost[]' value='{$row['2']}||{$row['3']}'> {$row['0']} </td>\n                                <td> <a class='tablenovisit' href='javascript:return;'\n                                onclick=\"javascript:__displayTooltip();\"\n                                tooltipText=\"\n                                        <a class='toolTip' href='mng-rad-hunt-edit.php?nasipaddress={$row['2']}&nasportid={$row['3']}'>" . $l['Tooltip']['EditHG'] . "</a>\n                                        <a class='toolTip' href='mng-rad-hunt-del.php?nasipaddress={$row['2']}&nasportid={$row['3']}'>" . $l['Tooltip']['RemoveHG'] . "</a>\n                                        <br/>\"\n                                        >{$row['2']}</a></td>\n\t\t\t\t<td> {$row['1']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\n\t\t</tr>";
}
echo "\n                                        <tfoot>\n                                                        <tr>\n                                                        <th colspan='4' align='left'>\n        ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType);

Example #2

Show file

File: acct-date.php Project: fortitudezhang/daloradius

$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
$counter = 0;
$bytesin = 0;
$bytesout = 0;
$megabytesout = 0;
$megabytesin = 0;
$session_seconds = 0;
$session_minutes = 0;
echo "<table border='0' class='table1'>\n";
echo "\n                <thead>\n                        <tr>\n                        <th colspan='12' align='left'>\n\n                        <input class='button' type='button' value='CSV Export'\n                        onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n                        />\n                        <br/>\n                <br/>\n        ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}");
}
echo " </th></tr>\n\t\t\t</thead>\n\t";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n                </tr> </thread>";
while ($row = $res->fetchRow()) {
    printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\n                        <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n                                                {$l['Tooltip']['HotspotEdit']}</a>\n                                        &nbsp;\n                                        <a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n                                                {$l['all']['Compare']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerHotspotInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['1']}</a>\n                        </td>\n\n                        <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t                                        {$l['Tooltip']['UserEdit']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerUserInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['2']}</a>\n                        </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>");
}
echo "\n                                        <tfoot>\n                                                        <tr>\n                                                        <th colspan='12' align='left'>\n        ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}");

Example #3

Show file

File: acct-username.php Project: JWynegar/daloradius

//userConnectionStatus($username, 1);                     // userConnectionStatus (same as above)
include 'library/opendb.php';
//orig: used as maethod to get total rows - this is required for the pages_numbering.php page
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE UserName='******';";
$res = $dbSocket->query($sql);
$numrows = $res->numRows();
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE UserName='******' ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<table border='0' class='table1'>\n";
echo "\n\t\t\t<thead>\n\t\t\t<tr>\n\t\t\t\t<th colspan='12' align='left'>\n\n\t\t\t<input class='button' type='button' value='Exportar CSV'\n\t\t\tonClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n\t\t\t/>\n\t\t\t<br/>\n\t\t\t<br/>\n\t\t";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}");
}
echo " </th></tr></thead>";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['ID'] . "</a>\n\t\t\t</th>\n\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Username'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['StartTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['StopTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['Termination'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t\t</th>\n\t\t\t</tr> </thread>";
while ($row = $res->fetchRow()) {
    printqn("<tr>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<td> <a class='tablenovisit' href='javascript:return;'\n\t\t\t\t\t\t\t\tonClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n\t\t\t\t\t\t\t\t\t\tjavascript:__displayTooltip();'\n\t\t\t\t\t\t\t\ttooltipText='\n\t\t\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n\t\t\t\t\t\t\t\t\t\t\t\t{$l['Tooltip']['HotspotEdit']}</a>\n\t\t\t\t\t\t\t\t\t\t&nbsp;\n\t\t\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n\t\t\t\t\t\t\t\t\t\t\t\t{$l['all']['Compare']}</a>\n\t\t\t\t\t\t\t\t\t\t<br/><br/>\n\n\t\t\t\t\t\t\t\t\t\t<div id=\"divContainerHotspotInfo\">\n\t\t\t\t\t\t\t\t\t\t\t\tLoading...\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<br/>'\n\t\t\t\t\t\t\t\t>{$row['1']}</a>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td> <a class='tablenovisit' href='javascript:return;'\n\t\t\t\t\t\t\t\tonClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n\t\t\t\t\t\t\t\t\t\tjavascript:__displayTooltip();'\n\t\t\t\t\t\t\t\ttooltipText='\n\t\t\t\t\t\t\t\t\t\t<a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t\t\t\t\t\t\t\t\t\t\t{$l['Tooltip']['UserEdit']}</a>\n\t\t\t\t\t\t\t\t\t\t<br/><br/>\n\n\t\t\t\t\t\t\t\t\t\t<div id=\"divContainerUserInfo\">\n\t\t\t\t\t\t\t\t\t\t\t\tLoading...\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<br/>'\n\t\t\t\t\t\t\t\t>{$row['2']}</a>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t\t\t<td> {$row['10']} </td>\n\t\t\t\t</tr>");
}
echo "\n\t\t\t\t<tfoot>\n\t\t\t\t\t<tr>\n\t\t\t\t\t<th colspan='12' align='left'>\n\t        ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}");

Example #4

Show file

File: mng-rad-attributes-search.php Project: fevenor/Dockerfile

$sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Attribute like '%{$attribute}%' AND Type <> ''" . " GROUP BY Attribute;";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
$numrows = $res->numRows();
$sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Attribute like '%{$attribute}%' AND Type <> '' " . " GROUP BY Attribute ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<form name='listvendorattributes' method='post' action='mng-rad-attributes-del.php'>";
echo "<table border='0' class='table1'>\n";
echo "\n\t\t<thead>\n\t\t\t<tr>\n\t\t\t<th colspan='10' align='left'>\n\n\t\t\tSelect:\n\t\t\t<a class=\"table\" href=\"javascript:SetChecked(1,'vendor[]','listvendorattributes')\">All</a>\n\t\t\t<a class=\"table\" href=\"javascript:SetChecked(0,'vendor[]','listvendorattributes')\">None</a>\n\t\t\t<br/>\n\t\t\t<input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listvendorattributes\",\"mng-rad-attributes-del.php\")' />\n\t\t\t<br/><br/>\n\t";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&attribute={$attribute}");
}
echo "\t</th></tr>\n\t\t\t</thead>\n\t";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType={$orderTypeNextPage}&attribute={$attribute}\">\n\t\t" . $l['all']['VendorID'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=vendor&orderType={$orderTypeNextPage}&attribute={$attribute}\">\n\t\t" . $l['all']['VendorName'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=attribute&orderType={$orderTypeNextPage}&attribute={$attribute}\">\n\t\t" . $l['all']['VendorAttribute'] . "</a>\n\t\t</th>\n\n\t\t</tr> </thread>";
while ($row = $res->fetchRow()) {
    printqn("<tr>\n                                <td> <input type='checkbox' name='vendor[]' value='{$row['1']}||{$row['2']}'> {$row['0']} </td>\n\t\t\t\t<td> <a class='tablenovisit' href='mng-rad-attributes-list.php?vendor={$row['1']}'>{$row['1']}</a></td>\n                                <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retVendorAttributeInfo.php\",\"retAttributeInfo\",\"divContainerAttributeInfo\",\"attribute={$row['2']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-rad-attributes-edit.php?vendor={$row['1']}&attribute={$row['2']}\">\n                                                {$l['Tooltip']['AttributeEdit']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerAttributeInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['2']}</a>\n                                </td>\n                        </tr>\n                        ");
}
echo "\n\t\t<tfoot>\n\t\t\t<tr>\n\t\t\t<th colspan='10' align='left'>\n\t";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&attribute={$attribute}");

Example #5

Show file

File: bill-paypal-transactions.php Project: fevenor/Dockerfile

// sanitizing the array passed to us in the get request
$select = $dbSocket->escapeSimple($select);
$sql = "SELECT {$select} FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . " WHERE " . " (payer_email LIKE '{$payer_email}') AND " . " (payment_address_status LIKE '{$payment_address_status}') AND " . " (payer_status LIKE '{$payer_status}') AND " . " (payment_status LIKE '{$payment_status}') AND " . " (vendor_type LIKE '{$vendor_type}') AND " . " (payment_date>'{$startdate}' AND payment_date<'{$enddate}')";
$res = $dbSocket->query($sql);
$numrows = $res->numRows();
$sql = "SELECT {$select} FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGMERCHANT'] . " WHERE " . " (payer_email LIKE '{$payer_email}') AND " . " (payment_address_status LIKE '{$payment_address_status}') AND " . " (payer_status LIKE '{$payer_status}') AND " . " (payment_status LIKE '{$payment_status}') AND " . " (vendor_type LIKE '{$vendor_type}') AND " . " (payment_date>'{$startdate}' AND payment_date<'{$enddate}') " . " ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<table border='0' class='table1'>\n";
echo "\n\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='25'>" . $l['all']['Records'] . "</th>\n\t\t\t\t\t\t\t</tr>\n\n                                                        <tr>\n                                                        <th colspan='25' align='left'>\n                <br/>\n        ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, $getFields, $getQuery);
}
echo " </th></tr>\n                                        </thead>\n\n                        ";
// building the dybamic table list fields
echo "<thread> <tr>";
foreach ($sqlfields as $value) {
    switch ($value) {
        case "id":
            $title = $l['all']['ID'];
            break;
        case "username":
            $title = $l['all']['Username'];
            break;
        case "password":
            $title = $l['all']['Password'];
            break;

Example #6

Show file

File: mng-rad-attributes-list.php Project: fortitudezhang/daloradius

$sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Vendor = '{$vendor}' AND Type <> '';";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
$numrows = $res->numRows();
$sql = "SELECT id, Vendor, Attribute FROM dictionary WHERE Vendor = '{$vendor}' AND Type <> '' " . "ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<form name='listvendorattributes' method='post' action='mng-rad-attributes-del.php'>";
echo "<table border='0' class='table1'>\n";
echo "\n\t\t\t\t\t<thead>\n                                                        <tr>\n                                                        <th colspan='10' align='left'>\n\n                                Select:\n                                <a class=\"table\" href=\"javascript:SetChecked(1,'vendor[]','listvendorattributes')\">All</a>\n\n                                <a class=\"table\" href=\"javascript:SetChecked(0,'vendor[]','listvendorattributes')\">None</a>\n                        <br/>\n                                <input class='button' type='button' value='Delete' onClick='javascript:removeCheckbox(\"listvendorattributes\",\"mng-rad-attributes-del.php\")' />\n                                <br/><br/>\n\n\n                ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&vendor={$vendor}");
}
echo " </th></tr>\n                                        </thead>\n\n                        ";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=id&orderType={$orderTypeNextPage}&vendor={$vendor}\">\n\t\t" . $l['all']['VendorID'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=vendor&orderType={$orderTypeNextPage}&vendor={$vendor}\">\n\t\t" . $l['all']['VendorName'] . "</a>\n\t\t</th>\n\n\t\t<th scope='col'>\n\t\t<a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=attribute&orderType={$orderTypeNextPage}&vendor={$vendor}\">\n\t\t" . $l['all']['VendorAttribute'] . "</a>\n\t\t</th>\n\n\t\t</tr> </thread>";
while ($row = $res->fetchRow()) {
    printqn("<tr>\n                                <td> <input type='checkbox' name='vendor[]' value='{$row['1']}||{$row['2']}'> {$row['0']} </td>\n\n\t\t\t\t<td>{$row['1']}</td>\n\n\t\t                <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retVendorAttributeInfo.php\",\"retAttributeInfo\",\"divContainerAttributeInfo\",\"attribute={$row['2']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-rad-attributes-edit.php?vendor={$row['1']}&attribute={$row['2']}\">\n                                                {$l['Tooltip']['AttributeEdit']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerAttributeInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['2']}</a>\n        \t                </td>\n\t\t\t</tr>\n\t\t\t");
}
echo "\n                                        <tfoot>\n                                                        <tr>\n                                                        <th colspan='10' align='left'>\n        ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&vendor={$vendor}");

Example #7

Show file

File: acct-hotspot-accounting.php Project: fevenor/Dockerfile

$_SESSION['reportType'] = "accountingGeneric";
//orig: used as maethod to get total rows - this is required for the pages_numbering.php page
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name='{$hotspot}';";
$res = $dbSocket->query($sql);
$numrows = $res->numRows();
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name='{$hotspot}'  ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<table border='0' class='table1'>\n";
echo "\n                        <thead>\n\t\t\t\t<tr>\n                                <th colspan='12' align='left'>\n\n                        <input class='button' type='button' value='CSV Export'\n                        onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n                        />\n\t\t\t<br/>\n\n                <br/>\n        ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&hotspot={$hotspot}");
}
echo " </th></tr>\n                                        </thead>\n\n                        ";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=hotspot&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?hotspot={$hotspot}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n\t\t</tr> </thread>";
while ($row = $res->fetchRow()) {
    printqn("<tr>\n                        <td> {$row['0']} </td>\n                        <td> {$row['1']} </td>\n\n                        <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n                                                {$l['Tooltip']['UserEdit']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerUserInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['2']}</a>\n                        </td>\n\n                        <td> {$row['3']} </td>\n                        <td> {$row['4']} </td>\n                        <td> {$row['5']} </td>\n                        <td> " . time2str($row[6]) . " </td>\n                        <td> " . toxbyte($row[7]) . "</td>\n                        <td> " . toxbyte($row[8]) . "</td>\n                        <td> {$row['9']} </td>\n                        <td> {$row['10']} </td>\n                </tr>");
}
echo "\n                                        <tfoot>\n                                                        <tr>\n                                                        <th colspan='12' align='left'>\n        ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&hotspot={$hotspot}");

Example #8

Show file

File: acct-ipaddress.php Project: fevenor/Dockerfile

$_SESSION['reportType'] = "accountingGeneric";
//orig: used as maethod to get total rows - this is required for the pages_numbering.php page
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, radacct.FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, radacct.AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE FramedIPAddress='{$ipaddress}';";
$res = $dbSocket->query($sql);
$numrows = $res->numRows();
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".RadAcctId, " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name as hotspot, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".UserName, radacct.FramedIPAddress, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStartTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctStopTime, radacct.AcctSessionTime, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctInputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctOutputOctets, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".AcctTerminateCause, " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".NASIPAddress FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " LEFT JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " ON " . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid = " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac WHERE FramedIPAddress='{$ipaddress}'  ORDER BY {$orderBy} {$orderType} LIMIT {$offset}, {$rowsPerPage};";
$res = $dbSocket->query($sql);
$logDebugSQL = "";
$logDebugSQL .= $sql . "\n";
/* START - Related to pages_numbering.php */
$maxPage = ceil($numrows / $rowsPerPage);
/* END */
echo "<table border='0' class='table1'>\n";
echo "\n                <thead>\n                        <tr>\n                        <th colspan='12' align='left'>\n\n                        <input class='button' type='button' value='CSV Export'\n                        onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n                        />\n                        <br/>\n                <br/>\n        ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&ipaddress={$ipaddress}");
}
echo " </th></tr>\n                                        </thead>\n\n                        ";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=hotspot&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?ipaddress={$ipaddress}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n                </tr> </thread>";
while ($row = $res->fetchRow()) {
    printqn("<tr>\n                        <td> {$row['0']} </td>\n\n                        <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n                                                {$l['Tooltip']['HotspotEdit']}</a>\n                                        &nbsp;\n                                        <a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n                                                {$l['all']['Compare']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerHotspotInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['1']}</a>\n                        </td>\n\n                        <td> <a class='tablenovisit' href='javascript:return;'\n                                onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n                                        javascript:__displayTooltip();'\n                                tooltipText='\n                                        <a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t                                        {$l['Tooltip']['UserEdit']}</a>\n                                        <br/><br/>\n\n                                        <div id=\"divContainerUserInfo\">\n                                                Loading...\n                                        </div>\n                                        <br/>'\n                                >{$row['2']}</a>\n                        </td>\n                        <td> {$row['3']} </td>\n                        <td> {$row['4']} </td>\n                        <td> {$row['5']} </td>\n                        <td> " . time2str($row[6]) . " </td>\n                        <td> " . toxbyte($row[7]) . "</td>\n                        <td> " . toxbyte($row[8]) . "</td>\n                        <td> {$row['9']} </td>\n                        <td> {$row['10']} </td>\n                </tr>");
}
echo "\n                                        <tfoot>\n                                                        <tr>\n                                                        <th colspan='12' align='left'>\n        ";
setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&ipaddress={$ipaddress}");

Example #9

Show file

File: rep-lastconnect.php Project: JWynegar/daloradius

    // +-------------+-------------+---------------+---------------------+
    $user = $row[0];
    $pass = $row[1];
    $starttime = $row[3];
    $reply = $row[2];
    array_push($array_users, "{$user}");
    array_push($array_pass, "{$pass}");
    array_push($array_starttime, "{$starttime}");
    array_push($array_reply, "{$reply}");
    $count++;
}
// creating the table:
echo "<table border='0' class='table1'>\n";
echo "\r\n                        <thead>\r\n\r\n                                                        <tr>\r\n                                                        <th colspan='10' align='left'>\r\n\r\n                                <input class='button' type='button' value='Exportar CSV'\r\n                                        onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\r\n                                        />\r\n\t\t                <br/><br/>\r\n        ";
if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") {
    setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&usernameLastConnect={$usernameLastConnect}");
}
echo " </th></tr>\r\n                                        </thead>\r\n\r\n                        ";
if ($orderType == "asc") {
    $orderTypeNextPage = "desc";
} else {
    if ($orderType == "desc") {
        $orderTypeNextPage = "asc";
    }
}
echo "<thread> <tr>\r\n                <th scope='col'>\r\n                <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=" . $tableSetting['postauth']['user'] . "&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['Username'] . " \r\n\t\t</th>\r\n\r\n                <th scope='col'>\r\n                <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=pass&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['Password'] . " \r\n\t\t</th>\r\n\r\n                <th scope='col'>\r\n                <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=" . $tableSetting['postauth']['date'] . "&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['StartTime'] . " \r\n\t\t</th>\r\n\r\n                <th scope='col'>\r\n                <a title='Sort' class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?usernameLastConnect={$usernameLastConnect}&orderBy=reply&orderType={$orderTypeNextPage}\">\r\n\t\t" . $l['all']['RADIUSReply'] . " \r\n\t\t</th>\r\n\r\n        </tr> </thread>";
$i = 0;
while ($i != $count) {
    if ($array_reply[$i] == "Access-Reject") {
        $reply = "<font color='red'> Rechazado </font>";
    } else {