switch-ztp/www/get_logicsw_details.php

<?php
//-
// Copyright (c) 2017 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 . ' : AJAX Get Logical Switch Details');
if ($logger === false) {
    die("Failed to open logfile.\n");
}
$mask = Log::MAX(LOG_LEVEL);
$logger->setMask($mask);

$sql = 'SELECT name, location, is_idf, ip_address, pid FROM SWITCHES';
$sth = null;
try {
    $sth = $dbh->query($sql);
} catch (PDOException $e) {
    header('HTTP/1.1 500 Internal Server Error');
    header('Content-Type: application/json');
    echo json_encode(array('status' => 'ERROR', 'message' => "Failed to get switch details: '{$e->getMessage()}'"));
    $logger->crit("Failed to get switch details: '{$e->getMessage()}'");
    exit(1);
}

header('Content-Type: application/json');
$result = array();
$result['status'] = 'SUCCESS';
$result['response'] = array();

while ($row = $sth->fetch()) {
    $tbase = '';
    if (file_exists(PORT_TMPL_DIR . '/devices/' . "{$row['name']}-ports.tmpl")) {
        $targ = readlink(PORT_TMPL_DIR . '/devices/' . "{$row['name']}-ports.tmpl");
        $tbase = basename($targ);
    }
    $result['response'][$row['name']] = array(
        'location' => (is_null($row['location']) ? '' : $row['location']),
        'is_idf' => $row['is_idf'],
        'ip_address' => (is_null($row['ip_address']) ? '' : $row['ip_address']),
        'pid' => (is_null($row['pid']) ? '' : $row['pid']),
        'exception' => $tbase
    );
}

echo json_encode($result);
cleanup();