switch-ztp/www/index.php

<?php
//-
// Copyright (c) 2011-2016 Joe Clarke <jclarke@cisco.com>
// 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 BY THE AUTHOR AND CONTRIBUTORS ``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 OR CONTRIBUTORS 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.

include_once 'db.inc.php';
include_once 'swreg/swreg.inc.php';
require_once 'Log.php';
require_once 'functions.php';

$dsn = "$db_driver:host=$db_host;dbname=$db_name";

$options = [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES => false,
];

try {
    $dbh = new PDO($dsn, $db_user, $db_pass, $options);
} catch (PDOException $e) {
    die($e->getMessage());
}

$logger = Log::singleton('file', LOGFILE, TOOL_NAME.' : Physical Switches');
if ($logger === false) {
    die("Failed to open logfile.\n");
}
$mask = Log::UPTO(LOG_LEVEL);
$logger->setMask($mask);

$base = get_base($_SERVER['SCRIPT_NAME']);
$ruser = '<AUTHENTICATION NOT ENABLED>';
if (isset($_SERVER['REMOTE_USER'])) {
    $ruser = $_SERVER['REMOTE_USER'];
}

$errors = array();
if (isset($_REQUEST['prev_checked'])) {
    $pc = $_REQUEST['prev_checked'];
    $pas = $_REQUEST['prev_assigned_switch'];
    $c = (isset($_REQUEST['checked'])) ? $_REQUEST['checked'] : array();
    $as = $_REQUEST['assigned_switch'];
    $d = (isset($_REQUEST['delete'])) ? $_REQUEST['delete'] : array();
    foreach ($pc as $swsn => $value) {
        $curr_del = (isset($d[$swsn])) ? $d[$swsn] : 0;
        if ($curr_del == 1) {
            $sql = "DELETE FROM DEVICE_MAP WHERE serial_number='{$swsn}'";
            try {
                $dbh->query($sql);
                $logger->info("User {$ruser} deleted physical switch {$swsn}");
            } catch (PDOException $e) {
                array_push($errors, "Failed to delete switch {$swsn}: {$e->getMessage()}");
            }
            continue;
        }
        $curr_checked = (isset($c[$swsn])) ? $c[$swsn] : 0;
        if ($value != $curr_checked || $pas[$swsn] != $as[$swsn]) {
            $nc = $curr_checked;
            $additional = '';
            if ($nc == 1 && $as == '__BOGUS__') {
                array_push($errors, "You must select a logical switch assignment for $swsn");
            } else {
                if ($nc == 0 || $as == '__BOGUS__') {
                    $nas = 'NULL';
                    $additional = ", provisioned_status = '".PROVISION_UNKNOWN."', device_status = '".REACHABILITY_NEVER_REACHABLE."'";
                } else {
                    $nas = "'{$as[$swsn]}'";
                }
                $sql = "UPDATE DEVICE_MAP SET checked_out='{$nc}', assigned_switch = {$nas} {$additional} WHERE serial_number='{$swsn}'";
                try {
                    $dbh->query($sql);
                    $logger->info("User {$ruser} updated physical switches, checked_out={$nc}, assigned_switch={$nas} for serial_number={$swsn}");
                } catch (PDOException $e) {
                    array_push($errors, "Failed to update $swsn: '{$e->getMessage()}'");
                }
            }
        }
    }
}

$wc = '';
if (isset($_REQUEST['filter'])) {
    switch ($_REQUEST['filter']) {
    case 'a':
        $wc = '';
        break;
    case 'p':
        $wc = 'WHERE assigned_switch IS NOT NULL';
        break;
    case 'up':
        $wc = 'WHERE assigned_switch IS NULL';
        break;
    case 'vu':
        $wc = 'WHERE provisioned_status=\''.PROVISION_UNKNOWN.'\'';
        break;
    case 'vi':
        $wc = 'WHERE provisioned_status=\''.PROVISION_IN_PROGRESS.'\'';
        break;
    case 'vf':
        $wc = 'WHERE provisioned_status=\''.PROVISION_FAIL.'\'';
        break;
    case 'vs':
        $wc = 'WHERE provisioned_status=\''.PROVISION_SUCCESS.'\'';
        break;
    case 'r':
        $wc = 'WHERE device_status=\''.REACHABILITY_REACHABLE.'\'';
        break;
    case 'ur':
        $wc = 'WHERE provisioned_status=\''.PROVISION_SUCCESS.'\' AND (device_status=\''.REACHABILITY_NEVER_REACHABLE.'\' OR device_status=\''.REACHABILITY_NOW_UNREACHABLE.'\')';
        break;
    default:
        if (preg_match("/^pid:([\w\d-]+)/", $_REQUEST['filter'], $match)) {
            $wc = "WHERE pid = '{$match[1]}'";
        } else {
            $wc = '';
        }
        break;
    }
}

$res = null;
if (isset($_REQUEST['switch_name'])) {
    $sql = "SELECT * FROM DEVICE_MAP WHERE serial_number LIKE '%{$_REQUEST['switch_name']}%' OR assigned_switch LIKE '%{$_REQUEST['switch_name']}%'";
    try {
        $res = $dbh->query($sql);
    } catch (PDOException $e) {
        echo "<p><font color=\"red\">Error querying for physical switches: {$e->getMessage()}</font></p>\r\n";
        exit(1);
    }
} else {
    $sql = 'SELECT * FROM DEVICE_MAP '.$wc.' ORDER BY serial_number';
    try {
        $res = $dbh->query($sql);
    } catch (PDOException $e) {
        echo "<p><font color=\"red\">Error querying for physical switches: {$e->getMessage()}</font></p>\r\n";
        exit(1);
    }
}

$sql = 'SELECT name, pid FROM SWITCHES ORDER BY name';
$ls_res = null;
try {
    $ls_res = $dbh->query($sql);
} catch (PDOException $e) {
    echo "<p><font color=\"red\">Error querying for logical switches: {$e->getMessage()}</font></p>\r\n";
    exit(1);
}

$lswitches = array();
while ($row = $ls_res->fetch()) {
    if (!isset($lswitches[$row['pid']])) {
        $lswitches[$row['pid']] = array('__BOGUS__', $row['name']);
    } else {
        array_push($lswitches[$row['pid']], $row['name']);
    }
}

$switches = array();
while ($row = $res->fetch()) {
    array_push($switches, $row);
}

$sql = 'SELECT DISTINCT(pid) AS pid FROM DEVICE_MAP';
try {
    $res = $dbh->query($sql);
} catch (PDOException $e) {
    echo "<p><font color=\"red\">Error querying for PIDs: {$e->getMessage()}</font></p>\r\n";
    exit(1);
}

$pids = array();
while ($row = $res->fetch()) {
    $pids[$row['pid']] = true;
}

$sql = 'SELECT assigned_switch FROM DEVICE_MAP WHERE assigned_switch IS NOT NULL';
try {
    $res = $dbh->query($sql);
} catch (PDOException $e) {
    echo "<p><font color=\"red\">Error querying for assigned switches: {$e->getMessage()}</font></p>\r\n";
    exit(1);
}

$used = array();
while ($row = $res->fetch()) {
    $used[$row['assigned_switch']] = true;
}

$filt = null;
if (!isset($_REQUEST['filter'])) {
    $filt = '';
} else {
    $filt = $_REQUEST['filter'];
}

print_header(TOOL_NAME.': Physical Switches');
?>
  <body class="flex">
    <script language="javascript">
var deletes = 0;

var PROVISION_UNKNOWN = <?=PROVISION_UNKNOWN?>;
var PROVISION_IN_PROGRESS = <?=PROVISION_IN_PROGRESS?>;
var PROVISION_FAIL = <?=PROVISION_FAIL?>;
var PROVISION_SUCCESS = <?=PROVISION_SUCCESS?>;

var REACHABILITY_NEVER_REACHABLE = <?=REACHABILITY_NEVER_REACHABLE?>;
var REACHABILITY_NOW_UNREACHABLE = <?=REACHABILITY_NOW_UNREACHABLE?>;
var REACHABILITY_REACHABLE = <?=REACHABILITY_REACHABLE?>;

var row_intervals = {};

function refresh() {
	$.ajax({
		url: '<?=$base?>/get_dev_stats.php',
		dataType: 'json',
		success: function(data) {
			$.each(data.response, function(k, v) {
				var rtext = '&nbsp;';
				var color = '#FFFFFF';
				var rtitle = 'Not yet assigned';
				var prs = v.provisioned_status;
				var ds = v.device_status;
				if (prs == PROVISION_SUCCESS) {
					color = '#00FF00';
					rtitle = 'Bootstrap validated successfully';
					rtext += '&nbsp;&nbsp;&nbsp;';
				} else if (prs == PROVISION_UNKNOWN || prs == PROVISION_IN_PROGRESS) {
					color = '#919191';
					rtitle = 'Not yet bootstrapped';
					if (prs == PROVISION_IN_PROGRESS) {
						rtitle = 'Bootstrapping in progress';
						rtext += '&nbsp;';
					}
				} else {
					color = '#FF0000';
					rtitle = 'Bootstrap validation failed';
					rtext += '&nbsp;&nbsp;';
				}

				rtext += '<input type="hidden" id="pros'+k+'" value="'+prs+'">';

				if (prs != PROVISION_IN_PROGRESS) {
					if ('undefined' !== typeof row_intervals[k]) {
						$('#psr_'+k).stop(true, true);
						clearInterval(row_intervals[k]);
						$('#psr_'+k).stop(true, true);
					}
				}

				$('#psr_'+k).css('background', color);
				$('#psr_'+k).html('<span style="display: none">' + prs + '</span>' + rtext);
				$('#psr_'+k).attr('title', rtitle);

				if (prs == PROVISION_IN_PROGRESS) {
					if ('undefined' !== typeof row_intervals[k]) {
						clearInterval(row_intervals[k]);
						$('#psr_'+k).stop(true, true);
					}
					var pulseint = setInterval(function() {
						$('#psr_'+k).animate({
								backgroundColor : '#919191',
							}, 1000).animate({
								backgroundColor : '#f5f5f5',
							}, 1000);
						}, 1500);
					row_intervals[k] = pulseint;
				}

				color = '#FFFFFF';
				rtext = '&nbsp;';
				rtitle = 'Not yet assigned';
				if (ds == REACHABILITY_NEVER_REACHABLE && prs == PROVISION_SUCCESS) {
					color = '#FF0000';
					rtitle = 'Device was never reachable';
				} else if (ds == REACHABILITY_NEVER_REACHABLE) {
					color = '#919191';
					rtitle = 'Not yet bootstrapped';
					rtext += '&nbsp;';
				} else if (ds == REACHABILITY_NOW_UNREACHABLE) {
					color = '#FFFF00';
					rtitle = 'Device has been reachable, but is not reachable now';
					rtext += '&nbsp;&nbsp;';
				} else {
					color = '#00FF00';
					rtitle = 'Device is reachable';
					rtext += '&nbsp;&nbsp;&nbsp;';
				}

				$('#dsr_'+k).css('background', color);
				$('#dsr_'+k).html('<span style="display: none">' + ds + '</span>' + rtext);
				$('#dsr_'+k).attr('title', rtitle);
			});
		},
		complete: function(xhr, message) {
			setTimeout(refresh, 30000);
		}
	});
}

$(document).ready(function() {
	$('#devtable').DataTable( {
		"scrollY": "400px",
		"scrollCollapse": true,
		"paging":false
	} );
	refresh();
} );
    </script>
    <div id="headswreg">
      <div class="apage">
        <div id="header">
	  <h1><?=TOOL_NAME?>: Physical Switches</h1>
        </div>
        <br/>
      </div>
    </div>
    <div class="apage">
       <form method="POST" name="search_form" action="<?=$_SERVER['PHP_SELF']?>">
       <table class="noborder" summary="Filter Table">
         <tr>
	   <td class="left_act">Show Only:
             <select name="filter" onChange="MM_jumpMenu('parent', this, 0)">
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=a" <?=($filt == 'a') ? 'selected' : ''?>>All</option>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=p" <?=($filt == 'p') ? 'selected' : ''?>>Assigned</option>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=up" <?=($filt == 'up') ? 'selected' : ''?>>Unassigned</option>
               <option value="<?=$_SERVER['PHP_SELF']?>?filter=vu" <?=($filt == 'vu') ? 'selected' : ''?>>Not Yet Bootstrapped</option>
               <option value="<?=$_SERVER['PHP_SELF']?>?filter=vi" <?=($filt == 'vi') ? 'selected' : ''?>>Bootstrapping In Progress</option>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=vf" <?=($filt == 'vf') ? 'selected' : ''?>>Verification Failed</option>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=vs" <?=($filt == 'vs') ? 'selected' : ''?>>Verification Succeeded</option>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=r" <?=($filt == 'r') ? 'selected' : ''?>>Reachable</option>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=ur" <?=($filt == 'ur') ? 'selected' : ''?>>Unreachable</option>
<?php
foreach ($pids as $lsp => $value) {
    $selected = ($filt == "pid:$lsp") ? 'selected' : ''; ?>
	       <option value="<?=$_SERVER['PHP_SELF']?>?filter=pid:<?=$lsp?>" <?=$selected?>><?=$lsp?></option>
<?php

}
?>
           </select></td>
             <td class="right">Switch Search:
	       <input type="text" size="16" name="switch_name" value="<?=(isset($_REQUEST['switch_name'])) ? $_REQUEST['switch_name'] : ''?>">
               <input type="image" value="Submit" name="search" src="/images/submit_button.png">
             </td>
        </tr>
      </table>
      </form>
      <br/>
      <table class="noborder" summary="Control Table">
        <tr>
	  <td class="left"><a href="<?=$base?>/add_phys.php">Add Physical Switch</a> |
	    <a href="#" onClick="window.open('<?=$base?>/export.php')">Export to Prime / DNS</a> |
	    <a href="<?=$base?>/logicsw.php">Logical Switches</a></td>
        </tr>
      </table>
      <form name="mod_phys_switch_form" method="POST" action="<?=$_SERVER['PHP_SELF']?>" onSubmit='if (deletes > 0) { return confirm("Are you sure you want to delete these " + deletes + " physical switch(es)?"); }'>
<?php

    foreach (array_merge($_GET, $_POST) as $name => $value) {
        if (!is_array($value)) {
            ?>
          <input type="hidden" name="<?=$name?>" value="<?=$value?>">
<?php

        }
    }
?>
        <div class="btable">
        <table summary="Button Table" width="100%" cellspacing="0">
          <tr>
            <td><input type="reset" value="Reset" name="reset">
            <input type="submit" value="Submit" name="submit"></td>
          </tr>
        </table>
        </div>
        <br/>
        <div align="center">
<?php
foreach ($errors as $error) {
    ?>
          <p class="error"><?=$error?></p>
<?php

}
?>
        </div>
        <div class="maintable">
        <table id="devtable" class="cell-border compact" width="100%" cellspacing="0" summary="Physical Switch Table">
          <thead>
          <tr>
            <th class="headlink">Row No.</th>
            <th class="headlink">Delete?</th>
            <th class="headlink">Assigned?</th>
            <th class="headlink">Serial Number</th>
            <th class="headlink">Product ID</th>
            <th class="headlink">MAC Address</th>
            <th class="headlink">Max Ports</th>
            <th class="headlink">Assigned Logical<br/>Switch</th>
            <th class="headlink">Provision<br/>Status</th>
            <th class="headlink">Reachability</th>
          </tr>
          </thead>
          <tbody>
<?php
$i = 0;
foreach ($switches as $row) {
    $sn = $row['serial_number'];
    $checked = false;
    if ($row['checked_out'] == 1) {
        $checked = true;
    } ?>
          <tr>
            <td><?=$i + 1?>.</td>
            <td><input type="checkbox" name="delete[<?=$sn?>]" value="1" onClick="if (this.checked == true) { deletes++; } else { deletes--; }"></td>
	    <td><input type="hidden" name="prev_checked[<?=$sn?>]" value="<?=$row['checked_out']?>">
                <input id="checked_<?=$i?>" type="checkbox" name="checked[<?=$sn?>]" value="1" <?=($checked) ? 'checked' : ''?>></td>
	    <td><?=$row['serial_number']?></td>
            <td><?=$row['pid']?></td>
            <td><?=$row['mac']?></td>
            <td><?=$row['max_ports']?></td>
	    <td><input type="hidden" name="prev_assigned_switch[<?=$sn?>]" value="<?=$row['assigned_switch']?>">
                <select id="asw<?=$i?>" name="assigned_switch[<?=$sn?>]" onChange='var elem = document.getElementById("checked_<?=$i?>"); if (this.value == "__BOGUS__") { elem.checked = false; } else { elem.checked = true; }'>
<?php
    $has_avail = false;
    foreach ($lswitches[$row['pid']] as $lsw) {
        $selected = ($row['assigned_switch'] == $lsw) ? 'selected' : '';
        if ($selected == '' && isset($used[$lsw]) && $used[$lsw] === true) {
            continue;
        }
        if ($lsw == '__BOGUS__') {
            ?>
              <option value="__BOGUS__" <?=$selected?>>--Please Select--</option>
<?php

        } else {
            $has_avail = true; ?>
	      <option value="<?=$lsw?>" <?=$selected?>><?=$lsw?></option>
<?php

        }
    }
    if (!$has_avail) {
        ?>
                <option value="__BOGUS__" <?=$selected?>>--Please Select--</option>
<?php

    } ?>
	      </select>
	      &nbsp;<a href="#" onClick='var lsw = document.getElementById("asw<?=$i?>"); if (lsw.value == "__BOGUS__") { alert("There is no logical switch associated to this device."); return false; } else { window.open("<?=$base?>/logicsw.php?switch_name=" + lsw.value, "Logical switch " + lsw.value, "height=480,width=1048"); return false; }'><img src="/images/switch.gif" border="0" title="View logical switch"></a>&nbsp;<a href="#" onClick='var pros = document.getElementById("pros<?=$row['serial_number']?>"); var lsw = document.getElementById("asw<?=$i?>"); if (pros.value < PROVISION_FAIL) { alert("This switch config has not yet been generated."); return false; } else { window.open("<?=$base?>/show_config.php?cfg=" + lsw.value + "-config.txt&dname=" + lsw.value, "Config for switch " + lsw.value, "height=650,width=980"); return false; }'><img src="/images/mag.gif" border="0" title="View switch config"></a>
            </td>
<?php
    $color = '#FFFFFF';
    $rtext = 'N/A';
    $rtitle = 'Not yet assigned'; ?>
             <td id="psr_<?=$row['serial_number']?>" style="background: <?=$color?>;" title="<?=$rtitle?>"><input type="hidden" id="pros<?=$row['serial_number']?>" value="<?=$row['provisioned_status']?>"><span style="display: none"><?=$row['provisioned_status']?></span><?=$rtext?></td>
<?php

    $color = '#FFFFFF';
    $rtext = 'N/A';
    $rtitle = 'Not yet assigned'; ?>
            <td id="dsr_<?=$row['serial_number']?>" style="background: <?=$color?>;" title="<?=$rtitle?>"><span style="display: none"><?=$row['device_status']?></span><?=$rtext?></td>
          </tr>
<?php
    ++$i;
}
?>
          </tbody>
        </table>
        </div>
        <br/>
        <div class="btable">
        <table summary="Button Table" width="100%" cellspacing="0">
          <tr>
            <td><input type="reset" value="Reset" name="reset">
            <input type="submit" value="Submit" name="submit"></td>
          </tr>
        </table>
        </div>
      </form>
    </div>
  </body>
</html>
<?php
cleanup();
?>