function CableReport()
{
    global $tableheader, $displaylinks;
    // Remote jQuery and DataTables files:
    echo '<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.0/css/jquery.dataTables.css">';
    echo '<script type="text/javascript" charset="utf8" src="https://code.jquery.com/jquery-1.10.2.min.js"></script>';
    echo '<script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.0/js/jquery.dataTables.js"></script>';
    // Local jQuery and DataTables files from DataTables-1.10.0 distribution zip:
    //echo '<link rel="stylesheet" type="text/css" href="/rt/extensions/cablereportv3/DataTables-1.10.0/media/css/jquery.dataTables.css">';
    //echo '<script type="text/javascript" charset="utf8" src="/rt/extensions/cablereportv3/DataTables-1.10.0/media/js/jquery.js"></script>';
    //echo '<script type="text/javascript" charset="utf8" src="/rt/extensions/cablereportv3/DataTables-1.10.0/media/js/jquery.dataTables.js"></script>';
    echo '<script>
                $(document).ready(function() {
                    $("#cablereport").dataTable({
                        "bPaginate": "true",
                        "bLengthChange": "false",
                        "sPaginationType": "full_numbers",
                        "aaSorting": [[ 0, "desc" ]],
                        "iDisplayLength": 20,
                        "stateSave": false,
                        "oLanguage": {
                                "sLengthMenu": \'Display <select>\'+
                                           \'<option value="10">10</option>\'+
                                           \'<option value="20">20</option>\'+
                                           \'<option value="30">30</option>\'+
                                           \'<option value="40">40</option>\'+
                                           \'<option value="50">50</option>\'+
                                           \'<option value="-1">All</option>\'+
                                           \'</select> records\'
                        }
                    });
                });
                </script>';
    echo "\n";
    echo '<div class=portlet>';
    echo '<h2>' . $tableheader . '</h2>';
    echo "\n";
    echo '<table id="cablereport" class="display">';
    echo "\n";
    echo '<thead><tr>';
    echo '<th>Cable ID</th>';
    echo '<th>Device 1</th>';
    echo '<th>Port 1</th>';
    echo '<th>Type 1</th>';
    echo '<th>Device 2</th>';
    echo '<th>Port 2</th>';
    echo '<th>Type 2</th>';
    echo '</tr></thead>';
    echo "\n";
    echo '<tbody>';
    echo "\n";
    $allports = fetchPortList('IF(la.porta, pa.id, pb.id) IS NOT NULL');
    $cid = 0;
    foreach ($allports as $port) {
        $allporttypes[$port['id']] = $port['oif_name'];
        if ($port['linked'] != 1) {
            continue;
        }
        if ($done[$port['id']] == 1) {
            continue;
        } else {
            $cid++;
            $cabletable[$cid]['cableid'] = $port['cableid'];
            if ($displaylinks == 1) {
                $cabletable[$cid]['device1'] = formatPortLink($port['object_id'], $port['object_name'], NULL, NULL);
                $cabletable[$cid]['port1'] = formatPortLink($port['object_id'], NULL, $port['id'], $port['name']);
            } else {
                $cabletable[$cid]['device1'] = $port['object_name'];
                $cabletable[$cid]['port1'] = $port['name'];
            }
            $cabletable[$cid]['port1id'] = $port['id'];
            $cabletable[$cid]['type1'] = $port['oif_name'];
            if ($displaylinks == 1) {
                $cabletable[$cid]['device2'] = formatPortLink($port['remote_object_id'], $port['remote_object_name'], NULL, NULL);
                $cabletable[$cid]['port2'] = formatPortLink($port['remote_object_id'], NULL, $port['remote_id'], $port['remote_name']);
            } else {
                $cabletable[$cid]['device2'] = $port['remote_object_name'];
                $cabletable[$cid]['port2'] = $port['remote_name'];
            }
            $cabletable[$cid]['port2id'] = $port['remote_id'];
            $cabletable[$cid]['type2'] = '';
            # missing from fetchPortList() add later from $allporttypes being created;
            $done[$port['remote_id']] = 1;
        }
    }
    foreach ($cabletable as $cable) {
        echo '<tr>';
        echo '<td>';
        echo $cable['cableid'];
        echo '</td><td>';
        echo $cable['device1'];
        echo '</td><td>';
        echo $cable['port1'];
        echo '</td><td>';
        echo $cable['type1'];
        echo '</td><td>';
        echo $cable['device2'];
        echo '</td><td>';
        echo $cable['port2'];
        echo '</td><td>';
        echo $allporttypes[$cable['port2id']];
        echo '</td>';
        echo '</tr>';
        echo "\n";
    }
    echo '</tbody></table><br/><br/>';
    echo 'ok-cablereport version 3.2';
    echo '</div>';
}
예제 #2
0
function getPortInfo($port_id)
{
    $result = fetchPortList('Port.id = ?', array($port_id));
    return empty($result) ? NULL : $result[0];
}
예제 #3
0
function lm_getPortInfo($port_id, $back = false)
{
    $linktable = $back ? 'LinkBackend' : 'Link';
    if ($back) {
        $result = lm_fetchPortList('Port.id = ?', array($port_id), $linktable);
    } else {
        $result = fetchPortList('Port.id = ?', array($port_id));
    }
    //return empty ($result) ? NULL : $result[0];
    return $result;
}