From ab3a9d33349c2f18a3e3727b26a682058d7735a7 Mon Sep 17 00:00:00 2001 From: Daniel Stefan Haischt Date: Sun, 14 Oct 2007 06:13:04 +0000 Subject: * added initial dynamic table prototype --- packages/dyntables/www/js/dyntables.js | 282 +++++++++++++++ packages/dyntables/www/php/diag_dhcp_leases.php | 438 ++++++++++++++++++++++++ 2 files changed, 720 insertions(+) create mode 100644 packages/dyntables/www/js/dyntables.js create mode 100644 packages/dyntables/www/php/diag_dhcp_leases.php (limited to 'packages/dyntables/www') diff --git a/packages/dyntables/www/js/dyntables.js b/packages/dyntables/www/js/dyntables.js new file mode 100644 index 00000000..9c74ee5d --- /dev/null +++ b/packages/dyntables/www/js/dyntables.js @@ -0,0 +1,282 @@ +/* $Id$ */ +/* ========================================================================== */ +/* + authng_wizard.js + part of pfSense (http://www.pfSense.com) + Copyright (C) 2007 Daniel S. Haischt + All rights reserved. + + Based on m0n0wall (http://m0n0.ch/wall) + Copyright (C) 2003-2006 Manuel Kasper . + All rights reserved. + */ +/* ========================================================================== */ +/* + Redistribution and use in source and binary forms, with or without + modification, are permitted provided that the following conditions are met: + + 1. Redistributions of source code must retain the above copyright notice, + this list of conditions and the following disclaimer. + + 2. Redistributions in binary form must reproduce the above copyright + notice, this list of conditions and the following disclaimer in the + documentation and/or other materials provided with the distribution. + + THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY + AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE + AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, + OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF + SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS + INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN + CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) + ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. + */ +/* ========================================================================== */ + +/** + * + * @access public + * @return void + **/ +function getFirstTD(node, index){ + var firstTD = node.childNodes[index]; + + if (firstTD.tagName == 'TD') { + return firstTD; + } else { + return getFirstTD(node, ++index); + } +} + +/** + * + * @access public + * @return void + **/ +function getTableRow(nodes, index){ + var row = nodes[index]; + + if (row.tagName == 'TR') { + return row; + } else { + return getTableRow(nodes, ++index); + } +} + +/** + * + * @access public + * @return void + **/ +function emtyDhcpLeaseTable(table) { + var tbody = table.childNodes[1]; + var trNodes = tbody.childNodes; + + for (i = 0; i < trNodes.length; i++) { + var currentRow = getTableRow(trNodes, i); + var firstTd = getFirstTD(currentRow, 0); + var classAttrib = firstTd.className; + + if (classAttrib == 'listhdrr') { + continue; + } else if (currentRow.tagName == 'TR') { + tbody.removeChild(currentRow); + } + } +} + +/** + * TODO: data[if], $fspans, $fspane, + * + **/ +function dhcpLeaseTableToHTML(table, json, theme) { + var tbody = table.childNodes[1]; + + if (json && json.length > 0) { + for (i = 0; i < json.length; i++) { + /* text nodes */ + var newActTxt = document.createTextNode(json[i]['act']); + var newEndTxt = document.createTextNode(json[i]['end']); + var newStartTxt = document.createTextNode(json[i]['start']); + var newHostnameTxt = document.createTextNode(json[i]['hostname']); + var newIPTxt = document.createTextNode(json[i]['ip']); + var newMACTxt = document.createTextNode(json[i]['mac']); + var newOnlineTxt = document.createTextNode(json[i]['online']); + var newTypeTxt = document.createTextNode(json[i]['type']); + + var newTR = document.createElement("tr"); + var newTRIdAttrib = document.createAttribute("id"); + newTRIdAttrib.nodeValue = "dhcpRow" + i; + newTR.setAttributeNode(newTRIdAttrib); + + /* IP td element */ + var newIPTD = document.createElement("td"); + /* TD attributes */ + var newIPTDClassAttrib = document.createAttribute("class"); + newIPTDClassAttrib.nodeValue = "listlr"; + /* assign attribs */ + newIPTD.setAttributeNode(newIPTDClassAttrib); + + /* MAC td element */ + var newMACTD = document.createElement("td"); + /* TD attributes */ + var newMACTDClassAttrib = document.createAttribute("class"); + newMACTDClassAttrib.nodeValue = "listr"; + /* assign attribs */ + newMACTD.setAttributeNode(newMACTDClassAttrib); + + /* Hostname td element */ + var newHostnameTD = document.createElement("td"); + /* TD attributes */ + var newHostnameTDClassAttrib = document.createAttribute("class"); + newHostnameTDClassAttrib.nodeValue = "listr"; + /* assign attribs */ + newHostnameTD.setAttributeNode(newHostnameTDClassAttrib); + + /* Start td element */ + var newStartTD = document.createElement("td"); + /* TD attributes */ + var newStartTDClassAttrib = document.createAttribute("class"); + newStartTDClassAttrib.nodeValue = "listr"; + /* assign attribs */ + newStartTD.setAttributeNode(newStartTDClassAttrib); + + /* End td element */ + var newEndTD = document.createElement("td"); + /* TD attributes */ + var newEndTDClassAttrib = document.createAttribute("class"); + newEndTDClassAttrib.nodeValue = "listr"; + /* assign attribs */ + newEndTD.setAttributeNode(newEndTDClassAttrib); + + /* Online td element */ + var newOnlineTD = document.createElement("td"); + /* TD attributes */ + var newOnlineTDClassAttrib = document.createAttribute("class"); + newOnlineTDClassAttrib.nodeValue = "listr"; + /* assign attribs */ + newOnlineTD.setAttributeNode(newOnlineTDClassAttrib); + + /* Lease td element */ + var newLeaseTD = document.createElement("td"); + /* TD attributes */ + var newLeaseTDClassAttrib = document.createAttribute("class"); + newLeaseTDClassAttrib.nodeValue = "listr"; + /* assign attribs */ + newLeaseTD.setAttributeNode(newLeaseTDClassAttrib); + + /* Mapping td element */ + var newMappingTD = document.createElement("td"); + /* TD attributes */ + var newMappingTDClassAttrib = document.createAttribute("class"); + newMappingTDClassAttrib.nodeValue = "list"; + var newMappingTDValignAttrib = document.createAttribute("valign"); + newMappingTDValignAttrib.nodeValue = "middle"; + /* assign attribs */ + newMappingTD.setAttributeNode(newMappingTDClassAttrib); + newMappingTD.setAttributeNode(newMappingTDValignAttrib); + + /* WOL td element */ + var newWOLTD = document.createElement("td"); + /* TD attributes */ + var newWOLTDValignAttrib = document.createAttribute("valign"); + newWOLTDValignAttrib.nodeValue = "middle"; + /* assign attribs */ + newWOLTD.setAttributeNode(newWOLTDValignAttrib); + + /* Mapping anchor */ + var newMappingAnchor = document.createElement("a"); + /* Anchor attribs */ + var newMappingAnchorHrefAttrib = document.createAttribute("href"); + newMappingAnchorHrefAttrib.nodeValue = "services_dhcp_edit.php?if=lan&mac=" + json[i]['mac'] + "&hostname=" + json[i]['hostname']; + /* assign attribs */ + newMappingAnchor.setAttributeNode(newMappingAnchorHrefAttrib); + + /* Mapping button */ + var newMappingButton = document.createElement("img"); + /* Button attribs */ + var newMappingButtonSrcAttrib = document.createAttribute("src"); + newMappingButtonSrcAttrib.nodeValue = "/themes/" + theme + "/images/icons/icon_plus.gif"; + var newMappingButtonWidthAttrib = document.createAttribute("width"); + newMappingButtonWidthAttrib.nodeValue = "17"; + var newMappingButtonHeightAttrib = document.createAttribute("height"); + newMappingButtonHeightAttrib.nodeValue = "17"; + var newMappingButtonBorderAttrib = document.createAttribute("border"); + newMappingButtonBorderAttrib.nodeValue = "0"; + var newMappingButtonTitleAttrib = document.createAttribute("title"); + newMappingButtonTitleAttrib.nodeValue = "add a static mapping for this MAC address"; + var newMappingButtonAltAttrib = document.createAttribute("alt"); + newMappingButtonAltAttrib.nodeValue = "add a static mapping for this MAC address"; + /* assign attribs */ + newMappingButton.setAttributeNode(newMappingButtonSrcAttrib); + newMappingButton.setAttributeNode(newMappingButtonWidthAttrib); + newMappingButton.setAttributeNode(newMappingButtonHeightAttrib); + newMappingButton.setAttributeNode(newMappingButtonBorderAttrib); + newMappingButton.setAttributeNode(newMappingButtonTitleAttrib); + newMappingButton.setAttributeNode(newMappingButtonAltAttrib); + + /* WOL anchor */ + var newWOLAnchor = document.createElement("a"); + /* Anchor attribs */ + var newWOLAnchorHrefAttrib = document.createAttribute("href"); + newWOLAnchorHrefAttrib.nodeValue = "services_wol_edit.php?if=lan&mac=" + json[i]['mac'] + "&descr=pfSense"; + /* assign attribs */ + newWOLAnchor.setAttributeNode(newWOLAnchorHrefAttrib); + + /* WOL button */ + var newWOLButton = document.createElement("img"); + /* Button attribs */ + var newWOLButtonSrcAttrib = document.createAttribute("src"); + newWOLButtonSrcAttrib.nodeValue = "/themes/" + theme + "/images/icons/icon_wol_all.gif"; + var newWOLButtonWidthAttrib = document.createAttribute("width"); + newWOLButtonWidthAttrib.nodeValue = "17"; + var newWOLButtonHeightAttrib = document.createAttribute("height"); + newWOLButtonHeightAttrib.nodeValue = "17"; + var newWOLButtonBorderAttrib = document.createAttribute("border"); + newWOLButtonBorderAttrib.nodeValue = "0"; + var newWOLButtonTitleAttrib = document.createAttribute("title"); + newWOLButtonTitleAttrib.nodeValue = "add a Wake on Lan mapping for this MAC address"; + var newWOLButtonAltAttrib = document.createAttribute("alt"); + newWOLButtonAltAttrib.nodeValue = "add a Wake on Lan mapping for this MAC address"; + /* assign attribs */ + newWOLButton.setAttributeNode(newWOLButtonSrcAttrib); + newWOLButton.setAttributeNode(newWOLButtonWidthAttrib); + newWOLButton.setAttributeNode(newWOLButtonHeightAttrib); + newWOLButton.setAttributeNode(newWOLButtonBorderAttrib); + newWOLButton.setAttributeNode(newWOLButtonTitleAttrib); + newWOLButton.setAttributeNode(newWOLButtonAltAttrib); + + /* assign buttons to anchor elements */ + newMappingAnchor.appendChild(newMappingButton); + newWOLAnchor.appendChild(newWOLButton); + + /* assign anchors to TD elements */ + newMappingTD.appendChild(newMappingAnchor); + newWOLTD.appendChild(newWOLAnchor); + + /* assign text nodes to TD elements */ + newIPTD.appendChild(newIPTxt); + newMACTD.appendChild(newMACTxt); + newHostnameTD.appendChild(newHostnameTxt); + newStartTD.appendChild(newStartTxt); + newEndTD.appendChild(newEndTxt); + newOnlineTD.appendChild(newOnlineTxt); + newLeaseTD.appendChild(newActTxt); + + /* populate table body */ + newTR.appendChild(newIPTD); + newTR.appendChild(newMACTD); + newTR.appendChild(newHostnameTD); + newTR.appendChild(newStartTD); + newTR.appendChild(newEndTD); + newTR.appendChild(newOnlineTD); + newTR.appendChild(newLeaseTD); + newTR.appendChild(newMappingTD); + newTR.appendChild(newWOLTD); + + tbody.appendChild(newTR); + } + } +} \ No newline at end of file diff --git a/packages/dyntables/www/php/diag_dhcp_leases.php b/packages/dyntables/www/php/diag_dhcp_leases.php new file mode 100644 index 00000000..54883431 --- /dev/null +++ b/packages/dyntables/www/php/diag_dhcp_leases.php @@ -0,0 +1,438 @@ +. + All rights reserved. + + Redistribution and use in source and binary forms, with or without + modification, are permitted provided that the following conditions are met: + + 1. Redistributions of source code must retain the above copyright notice, + this list of conditions and the following disclaimer. + + 2. Redistributions in binary form must reproduce the above copyright + notice, this list of conditions and the following disclaimer in the + documentation and/or other materials provided with the distribution. + + THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, + INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY + AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE + AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, + OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF + SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS + INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN + CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) + ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE + POSSIBILITY OF SUCH DAMAGE. +*/ + +require("guiconfig.inc"); +require("dyntables.inc"); + +/* ========================================================================== */ +/* ======================= NON GUI RELATED FUNCTIONS ======================== */ +/* ========================================================================== */ + +function leasecmp($a, $b) { + return strcmp($a[$_GET['order']], $b[$_GET['order']]); +} + +function adjust_gmt($dt) { + $ts = strtotime($dt . " GMT"); + return strftime("%Y/%m/%d %H:%M:%S", $ts); +} + +function remove_duplicate($array, $field) +{ + foreach ($array as $sub) + $cmp[] = $sub[$field]; + $unique = array_unique($cmp); + foreach ($unique as $k => $rien) + $new[] = $array[$k]; + return $new; +} + +$leasesfile = "{$g['dhcpd_chroot_path']}/var/db/dhcpd.leases"; +$awk = "/usr/bin/awk"; +/* this pattern sticks comments into a single array item */ +$cleanpattern = "'{ gsub(\"#.*\", \"\");} { gsub(\";\", \"\"); print;}'"; +/* We then split the leases file by } */ +$splitpattern = "'BEGIN { RS=\"}\";} {for (i=1; i<=NF; i++) printf \"%s \", \$i; printf \"}\\n\";}'"; + +/* stuff the leases file in a proper format into a array by line */ +exec("cat {$leasesfile} | {$awk} {$cleanpattern} | {$awk} {$splitpattern}", $leases_content); +$leases_count = count($leases_content); + +$pools = array(); +$leases = array(); +$i = 0; +$l = 0; +$p = 0; + +// Put everything together again +while($i < $leases_count) { + /* split the line by space */ + $data = explode(" ", $leases_content[$i]); + /* walk the fields */ + $f = 0; + $fcount = count($data); + /* with less then 20 fields there is nothing useful */ + if($fcount < 20) { + $i++; + continue; + } + while($f < $fcount) { + switch($data[$f]) { + case "failover": + $pools[$p]['name'] = $data[$f+2]; + $pools[$p]['mystate'] = $data[$f+7]; + $pools[$p]['peerstate'] = $data[$f+14]; + $pools[$p]['mydate'] = $data[$f+10]; + $pools[$p]['mydate'] .= " " . $data[$f+11]; + $pools[$p]['peerdate'] = $data[$f+17]; + $pools[$p]['peerdate'] .= " " . $data[$f+18]; + $p++; + $i++; + continue 3; + case "lease": + $leases[$l]['ip'] = $data[$f+1]; + $leases[$l]['type'] = "dynamic"; + $f = $f+2; + break; + case "starts": + $leases[$l]['start'] = $data[$f+2]; + $leases[$l]['start'] .= " " . $data[$f+3]; + $f = $f+3; + break; + case "ends": + $leases[$l]['end'] = $data[$f+2]; + $leases[$l]['end'] .= " " . $data[$f+3]; + $f = $f+3; + break; + case "tstp": + $f = $f+3; + break; + case "tsfp": + $f = $f+3; + break; + case "atsfp": + $f = $f+3; + break; + case "cltt": + $f = $f+3; + break; + case "binding": + switch($data[$f+2]) { + case "active": + $leases[$l]['act'] = "active"; + break; + case "free": + $leases[$l]['act'] = "expired"; + $leases[$l]['online'] = "offline"; + break; + case "backup": + $leases[$l]['act'] = "reserved"; + $leases[$l]['online'] = "offline"; + break; + } + $f = $f+1; + break; + case "next": + /* skip the next binding statement */ + $f = $f+3; + break; + case "hardware": + $leases[$l]['mac'] = $data[$f+2]; + /* check if it's online and the lease is active */ + if($leases[$l]['act'] == "active") { + $online = exec("/usr/sbin/arp -an |/usr/bin/awk '/{$leases[$l]['ip']}/ {print}'|wc -l"); + if ($online == 1) { + $leases[$l]['online'] = 'online'; + } else { + $leases[$l]['online'] = 'offline'; + } + } + $f = $f+2; + break; + case "client-hostname": + if($data[$f+1] <> "") { + $leases[$l]['hostname'] = preg_replace('/"/','',$data[$f+1]); + } else { + $hostname = gethostbyaddr($leases[$l]['ip']); + if($hostname <> "") { + $leases[$l]['hostname'] = $hostname; + } + } + $f = $f+1; + break; + case "uid": + $f = $f+1; + break; + } + $f++; + } + $l++; + $i++; +} + +/* remove duplicate items by mac address */ +if(count($leases) > 0) { + $leases = remove_duplicate($leases,"ip"); +} + +if(count($pools) > 0) { + $pools = remove_duplicate($pools,"name"); + asort($pools); +} + +foreach($config['interfaces'] as $ifname => $ifarr) { + if (is_array($config['dhcpd'][$ifname]['staticmap'])) { + foreach($config['dhcpd'][$ifname]['staticmap'] as $static) { + $slease = array(); + $slease['ip'] = $static['ipaddr']; + $slease['type'] = "static"; + $slease['mac'] = $static['mac']; + $slease['start'] = gmdate("M d Y H:i:s", time()); + $slease['end'] = gmdate("M d Y H:i:s", time()); + $slease['end'] = gmdate("M d Y H:i:s", strtotime('+5 minutes')); + $slease['hostname'] = $static['hostname']; + $slease['act'] = "static"; + $online = exec("/usr/sbin/arp -an |/usr/bin/grep {$slease['mac']}| /usr/bin/wc -l|/usr/bin/awk '{print $1;}'"); + if ($online == 1) { + $slease['online'] = 'online'; + } else { + $slease['online'] = 'offline'; + } + $leases[] = $slease; + } + } +} + +/* ========================================================================== */ +/* ====================== PROCESS POST AND GET VARS ========================= */ +/* ========================================================================== */ + +if ($_GET['order']) { + usort($leases, "leasecmp"); +} else if ($_GET['refresh']) { + dl( 'json.so' ); + echo json_encode($leases); + exit; +} + +/* ========================================================================== */ +/* =================== GUI RELATED FUNCTIONS AND STUFF ====================== */ +/* ========================================================================== */ + +$pgtitle = "Diagnostics: DHCP leases"; + +$effectStyle = ' + +'; + +include("head.inc"); + +// add extra stuff to HTML head +if (isset($pfSenseHead)) { + $pfSenseHead->setCloseHead(false); + print($pfSenseHead->getHTML()); +} else { + $closehead = false; +} + +$scriptaculousRefs = ' + + +'; + +$ajaxRequest = " + + +"; + +print($ajaxRequest); +print($scriptaculousRefs); + +foreach(getWindowJSScriptRefs() as $jscript){ + print("{$jscript}\n"); +} + +foreach(getWindowJSStyleRefs() as $style){ + print("{$style}\n"); +} + +print($effectStyle); + +?> + + + + + +

+ 0) { +?> + + + + + + + + +\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; +} + +?> +
Failover GroupMy StateSincePeer StateSince
{$fspans}{$data['name']}{$fspane} {$fspans}{$data['mystate']}{$fspane} {$fspans}" . adjust_gmt($data['mydate']) . "{$fspane} {$fspans}{$data['peerstate']}{$fspane} {$fspans}" . adjust_gmt($data['peerdate']) . "{$fspane}   
+ +addColumn("IP address", "ip"); +$table->addColumn("MAC address", "mac"); +$table->addColumn("Hostname", "hostname"); +$table->addColumn("Start", "start"); +$table->addColumn("End", "end"); +$table->addColumn("Online", "online"); +$table->addColumn("Lease Type", "act", "listhdr"); + +// populate table data +$table->setData($leases); + +?> + +

+ + +getColumnHTML(); ?> +getData() as $data) { + if (($data['act'] == "active") || ($data['act'] == "static") || ($_GET['all'] == 1)) { + if ($data['act'] != "active" && $data['act'] != "static") { + $fspans = ""; + $fspane = ""; + } else { + $fspans = $fspane = ""; + } + $lip = ip2long($data['ip']); + if ($data['act'] == "static") { + foreach ($config['dhcpd'] as $dhcpif => $dhcpifconf) { + if(is_array($dhcpifconf['staticmap'])) { + foreach ($dhcpifconf['staticmap'] as $staticent) { + if ($data['ip'] == $staticent['ipaddr']) { + $data['if'] = $dhcpif; + break; + } + } + } + /* exit as soon as we have an interface */ + if ($data['if'] != "") + break; + } + } else { + foreach ($config['dhcpd'] as $dhcpif => $dhcpifconf) { + if (($lip >= ip2long($dhcpifconf['range']['from'])) && ($lip <= ip2long($dhcpifconf['range']['to']))) { + $data['if'] = $dhcpif; + break; + } + } + } + echo "\n"; + echo "\n"; + if ($data['online'] != "online") { + echo "\n"; + } else { + echo "\n"; + } + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + echo "\n"; + + if ($data['type'] == "dynamic") { + echo "\n"; + } else { + echo "\n"; + } + + echo "\n"; + echo "\n"; + } +} + +?> +
{$fspans}{$data['ip']}{$fspane} {$fspans}{$data['mac']}{$fspane} {$fspans}{$data['mac']}{$fspane} {$fspans}{$data['hostname']}{$fspane} {$fspans}" . adjust_gmt($data['start']) . "{$fspane} {$fspans}" . adjust_gmt($data['end']) . "{$fspane} {$fspans}{$data['online']}{$fspane} {$fspans}{$data['act']}{$fspane} "; + echo ""; + echo ""; + echo "
+

+

+ + + + + + + + +
+ +

No leases file found. Is the DHCP server active?

+ + +
 
+ + + + + -- cgit v1.2.3