Eye/html/admin/devices/switchstatus.php

<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/auth.php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/languages/" . HTML_LANG . ".php");
require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/idfilter.php");

$device = get_record($db_link, 'devices', "id = ?", [$id]);
$snmp = getSnmpAccess($device);
$device_model = get_record($db_link, 'device_models', "id = ?", [$device['device_model_id']]);

// Перегенерация SNMP-индексов
if (getPOST("regensnmp") !== null) {
    $snmp_index = (int)getPOST("f_snmp_start", null, 1);
    $sSQL = "SELECT id, port FROM device_ports WHERE device_ports.device_id = ? ORDER BY id";
    $flist = get_records_sql($db_link, $sSQL, [$id]);
    LOG_DEBUG($db_link, "Recalc snmp_index for device id: $id with start $snmp_index");
    foreach ($flist as $row) {
        $snmp_val = $row['port'] + $snmp_index - 1;
        update_record($db_link, "device_ports", "id = ?", ['snmp_index' => $snmp_val], [$row['id']]);
    }
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

// Включение PoE
if (getPOST("poe_on") !== null && $device['snmp_version'] > 0) {
    $poe_on = getPOST("poe_on", null, []);
    if (!empty($poe_on) && is_array($poe_on)) {
        foreach ($poe_on as $port_index) {
            $port_index = (int)$port_index;
            if ($port_index <= 0) continue;
            $port = get_record_sql($db_link, 
                "SELECT port FROM device_ports WHERE device_id = ? AND snmp_index = ?", 
                [$id, $port_index]
            );
            if (!empty($port)) {
                LOG_DEBUG($db_link, "Device id: $id enable poe at port {$port['port']} snmp index $port_index");
                set_port_poe_state($device['vendor_id'], $port['port'], $port_index, $device['ip'], $snmp, 1);
            }
        }
    }
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

// Отключение PoE
if (getPOST("poe_off") !== null && $device['snmp_version'] > 0) {
    $poe_off = getPOST("poe_off", null, []);
    if (!empty($poe_off) && is_array($poe_off)) {
        foreach ($poe_off as $port_index) {
            $port_index = (int)$port_index;
            if ($port_index <= 0) continue;
            $port = get_record_sql($db_link, 
                "SELECT port FROM device_ports WHERE device_id = ? AND snmp_index = ?", 
                [$id, $port_index]
            );
            if (!empty($port)) {
                LOG_DEBUG($db_link, "Device id: $id disable poe at port {$port['port']} snmp index $port_index");
                set_port_poe_state($device['vendor_id'], $port['port'], $port_index, $device['ip'], $snmp, 0);
            }
        }
    }
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

// Включение портов
if (getPOST("port_on") !== null && $device['snmp_version'] > 0) {
    $port_on = getPOST("port_on", null, []);
    
    if (!empty($port_on) && is_array($port_on)) {
        foreach ($port_on as $port_index) {
            $port_index = (int)$port_index;
            if ($port_index <= 0) continue;
            LOG_DEBUG($db_link, "Device id: $id enable port with snmp index $port_index");
            set_port_state($device['vendor_id'], $port_index, $device['ip'], $snmp, 1);
        }
    }
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

// Отключение портов
if (getPOST("port_off") !== null && $device['snmp_version'] > 0) {
    $port_off = getPOST("port_off", null, []);
    if (!empty($port_off) && is_array($port_off)) {
        foreach ($port_off as $port_index) {
            $port_index = (int)$port_index;
            if ($port_index <= 0) continue;
            LOG_DEBUG($db_link, "Device id: $id disable port with snmp index $port_index");
            set_port_state($device['vendor_id'], $port_index, $device['ip'], $snmp, 0);
        }
    }
    header("Location: " . $_SERVER["REQUEST_URI"]);
    exit;
}

unset($_POST);

if (!apply_device_lock($db_link, $id)) {
    header("Location: /admin/devices/editdevice.php?id=" . $id . "&status=locked");
    exit;
}

$user_info = get_record_sql($db_link, "SELECT * FROM user_list WHERE id=?", [ $device['user_id'] ]);

require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/header.php");

print_device_submenu($page_url);
print_editdevice_submenu($page_url, $id, $device['device_type'], $user_info['login']);

?>

<div id="contsubmenu">

    <form name="def" action="switchstatus.php?id=<?php echo $id; ?>" method="post">

        <?php
        print "<br>\n";
        print "<b>" . WEB_device_port_state_list . "&nbsp" . $device['device_name'] . " - " . $device['ip'] . "</b><br>\n";

        $snmp_ok = 0;
        $vlan_list = [];
        $vlan_at_port_by_snmp = 1;

        if (!empty($device['ip']) and $device['snmp_version'] > 0) {
            $snmp_ok = check_snmp_access($device['ip'], $snmp);
            $modules_oids = NULL;
            if ($snmp_ok) {
                update_record($db_link, 'devices', 'id=?', [ 'nagios_status'=> 'UP' ], [ $id ]);
                $modules_oids = walk_snmp($device["ip"], $snmp, CISCO_MODULES);
                $vlan_list = get_switch_vlans($device['vendor_id'], $device['ip'], $snmp);
                //if port number 1 not exists - try detect by snmp interface index
                if (isset($vlan_list['1'])) {
                    $vlan_at_port_by_snmp = 0;
                }
            }
        } else {
            $snmp_ok = 0;
        }

        print "<table class=\"data\" cellspacing=\"1\" cellpadding=\"4\">\n";
        print "<tr>\n";
        print "<td>id</td>\n";
        print "<td>" . WEB_device_port_number . "</td>\n";
        print "<td>" . WEB_device_port_name . "</td>\n";
        print "<td>" . WEB_device_port_snmp_index . "</td>\n";
        print "<td>" . WEB_device_connected_endpoint . "</td>\n";
        print "<td>" . WEB_cell_description . "</td>\n";
        print "<td>" . WEB_device_port_uplink . "</td>\n";
        print "<td>" . WEB_nagios . "</td>\n";
        print "<td>" . WEB_cell_skip . "</td>\n";
        print "<td>" . WEB_cell_vlan . "</td>\n";
        print "<td>" . WEB_device_snmp_port_oid_name . "</td>\n";
        print "<td>" . WEB_device_port_speed . "</td>\n";
        print "<td>" . WEB_device_port_errors . "</td>\n";
        print "<td>" . WEB_cell_mac_count . "</td>\n";
        print "<td>" . WEB_msg_additional . "</td>\n";
        if ($device_model['poe_out']) {
            print "<td>" . WEB_device_poe_control . "</td>\n";
        }
        print "<td>" . WEB_device_port_control . "</td>\n";
        print "</tr>\n";
        $sSQL = "SELECT * FROM device_ports WHERE device_ports.device_id=? ORDER BY port";
        $ports = get_records_sql($db_link, $sSQL, [ $id ]);
        foreach ($ports as $row) {
            print "<tr align=center>\n";
            $cl = "down";
            $new_info = NULL;

            $display_vlan = $row['vlan'];
            if (!empty($row['untagged_vlan'])) {
                if ($row['untagged_vlan'] != $row['vlan']) {
                    $pattern = '/(\d+),(\d+),(\d+),(\d+),(\d+),/';
                    $replacement = '${1},${2},${3},${4},${5}<br>U:';
                    $display_untagged = preg_replace($pattern, $replacement, $row['untagged_vlan']);
                    $display_vlan .= ";U:" . $display_untagged;
                }
            }
            if (!empty($row['tagged_vlan'])) {
                $pattern = '/(\d+),(\d+),(\d+),(\d+),(\d+),/';
                $replacement = '${1},${2},${3},${4},${5}<br>T:';
                $display_tagged = preg_replace($pattern, $replacement, $row['tagged_vlan']);
                $display_vlan .= ";T:" . $display_tagged;
            }

            //fix empty port names
            if (empty($row['port_name'])) {
                $row['port_name'] = $row['port'];
                $new_info['port_name'] = $row['port'];
            }

            if ($snmp_ok) {
                $port_state_detail = get_port_state_detail($row['snmp_index'], $device['ip'], $snmp);
                list($poper, $padmin, $pspeed, $perrors) = explode(';', $port_state_detail);
                if ($poper == 1) {
                    $cl = "up";
                }
                if ($poper >= 2) {
                    if ($padmin >= 2) {
                        $cl = "shutdown";
                    } else {
                        $cl = "down";
                    }
                }
            }

            print "<td class='" . $cl . "' style='padding:0'><input type=checkbox name=d_port_index[] value=" . $row['snmp_index'] . " ></td>\n";

            print "<td class='" . $cl . "'><a href=\"#\" onclick=\"" . open_window_url("editport.php?id=" . $row['id']) . " return false;\">" . $row['port'] . "</a></td>\n";
            print "<td class='" . $cl . "' >" . $row['port_name'] . "</td>\n";
            print "<td class='" . $cl . "' >" . $row['snmp_index'] . "</td>\n";
            print "<td class='" . $cl . "'>";
            if (isset($row['target_port_id']) and $row['target_port_id'] > 0) {
                print_device_port($db_link, $row['target_port_id']);
            } else {
                print_auth_port($db_link, $row['id'], TRUE);
            }
            print "</td>\n";
            print "<td class='" . $cl . "' >" . get_port_description($db_link, $row['id'], $row['description']) . "</td>\n";
            print_td_yes($row['uplink'],FALSE,$cl);
            print_td_yes($row['nagios'],FALSE,$cl);
            print_td_yes($row['skip'],FALSE,$cl);
            $poe_info = "";

            $ifname = $row['ifname'];

            if ($snmp_ok) {
                //sfp information
                $sfp_status = get_sfp_status($device['vendor_id'], $row['snmp_index'], $device['ip'], $snmp, $modules_oids);

                //interface name
                $ifname = get_snmp_ifname($device['ip'], $snmp, $row['snmp_index']);

                //poe information
                if ($device_model['poe_out']) {
                    $poe_status = get_port_poe_state($device['vendor_id'], $row['port'], $row['snmp_index'], $device['ip'], $snmp);
                    if (isset($poe_status)) {
                        if ($poe_status == 1) {
                            $port_poe_detail = get_port_poe_detail($device['vendor_id'], $row['port'], $row['snmp_index'], $device['ip'], $snmp);
                            if (empty($port_poe_detail)) {
                                $poe_info = 'POE:on';
                            } else {
                                $poe_info = $port_poe_detail;
                            }
                        }
                        if ($poe_status == 2) {
                            $poe_info = "POE:Off";
                        }
                    }
                }

                //vlans at port
                if (!empty($vlan_list)) {
                    if ($vlan_at_port_by_snmp) {
                        if (!empty($vlan_list[$row['snmp_index']])) {
                            if (!empty($vlan_list[$row['snmp_index']]['pvid'])) {
                                if ($vlan_list[$row['snmp_index']]['pvid'] >= 1 and $vlan_list[$row['snmp_index']]['pvid'] <= 4094) {
                                    $new_info['vlan'] = $vlan_list[$row['snmp_index']]['pvid'];
                                } else {
                                    $new_info['vlan'] = 1;
                                }
                            }
                            if (!empty($vlan_list[$row['snmp_index']]['tagged'])) {
                                $new_info['tagged_vlan'] = $vlan_list[$row['snmp_index']]['tagged'];
                            } else {
                                $new_info['tagged_vlan'] = '';
                            }
                            if (!empty($vlan_list[$row['snmp_index']]['untagged'])) {
                                $new_info['untagged_vlan'] = $vlan_list[$row['snmp_index']]['untagged'];
                            } else {
                                $new_info['untagged_vlan'] = '';
                            }
                        }
                    } else {
                        if (!empty($vlan_list[$row['port']])) {
                            if (!empty($vlan_list[$row['port']]['pvid'])) {
                                if ($vlan_list[$row['port']]['pvid'] >= 1 and $vlan_list[$row['port']]['pvid'] <= 4094) {
                                    $new_info['vlan'] = $vlan_list[$row['port']]['pvid'];
                                } else {
                                    $new_info['vlan'] = 1;
                                }
                            }
                            if (!empty($vlan_list[$row['port']]['tagged'])) {
                                $new_info['tagged_vlan'] = $vlan_list[$row['port']]['tagged'];
                            } else {
                                $new_info['tagged_vlan'] = '';
                            }
                            if (!empty($vlan_list[$row['port']]['untagged'])) {
                                $new_info['untagged_vlan'] = $vlan_list[$row['port']]['untagged'];
                            } else {
                                $new_info['untagged_vlan'] = '';
                            }
                        }
                    }
                    $display_vlan = '';
                    if (!empty($new_info['vlan'])) {
                        $display_vlan = $new_info['vlan'];
                    }
                    if (!empty($new_info['untagged_vlan'])) {
                        if ($new_info['untagged_vlan'] != $new_info['vlan']) {
                            $pattern = '/(\d+),(\d+),(\d+),(\d+),(\d+),/';
                            $replacement = '${1},${2},${3},${4},${5}<br>U:';
                            $display_untagged = preg_replace($pattern, $replacement, $new_info['untagged_vlan']);
                            $display_vlan .= ";U:" . $display_untagged;
                        }
                    }
                    if (!empty($new_info['tagged_vlan'])) {
                        $pattern = '/(\d+),(\d+),(\d+),(\d+),(\d+),/';
                        $replacement = '${1},${2},${3},${4},${5}<br>T:';
                        $display_tagged = preg_replace($pattern, $replacement, $new_info['tagged_vlan']);
                        $display_vlan .= ";T:" . $display_tagged;
                    }
                }
                //interface name
                if (!empty($ifmib_list[$row['snmp_index']])) {
                    $ifname = $ifmib_list[$row['snmp_index']];
                }
                if (!isset($row['ifname']) or $row['ifname'] !== $ifname) {
                    $new_info['ifname'] = $ifname;
                }
            }

            //fix port information
            if ($snmp_ok) {
                update_record($db_link, "device_ports", "id=?", $new_info, [  $row['id'] ]);
            }

            $ifname = compact_port_name($ifname);
            $f_cacti_url = get_cacti_graph($device['ip'], $row['snmp_index']);
            if (empty(get_const('torrus_url')) and (empty($f_cacti_url))) {
                $snmp_url = $ifname;
            } else {
                if (isset($f_cacti_url)) {
                    $snmp_url = "<a href=\"#\" onclick=\"" . open_window_url($f_cacti_url) . "return false;\">" . $ifname . "</a>";
                }
                if (!empty(get_const('torrus_url'))) {
                    $normed_ifname = str_replace("/", "_", $ifname);
                    $normed_ifname = str_replace(".", "_", $normed_ifname);
                    $normed_ifname = trim(str_replace(" ", "_", $normed_ifname));
                    $t_url = str_replace("HOST_IP", $device['ip'], get_const('torrus_url'));
                    $t_url = str_replace("IF_NAME", $normed_ifname, $t_url);
                    $snmp_url = "<a href=\"#\" onclick=\"" . open_window_url($t_url) . "return false;\">" . $ifname . "</a>";
                }
            }

            print "<td class='" . $cl . "'>" . $display_vlan . "</td>\n";
            print "<td class='" . $cl . "'>" . $snmp_url . "</td>\n";

            $speed = "0";
            $cl_speed = $cl;

            if ($pspeed == 0) {
                $speed = "";
            }
            if ($pspeed == 10000000) {
                $speed = "10M";
                $cl_speed = "speed10M";
            }
            if ($pspeed == 100000000) {
                $speed = "100M";
                $cl_speed = "speed100M";
            }
            if ($pspeed == 1000000000) {
                $speed = "1G";
                $cl_speed = "speed1G";
            }
            if ($pspeed == 10000000000) {
                $speed = "10G";
                $cl_speed = "speed10G";
            }
            if ($pspeed == 4294967295) {
                $speed = "10G";
                $cl_speed = "speed10G";
            }
            if ($pspeed == 10) {
                $speed = "10G";
                $cl_speed = "speed10G";
            }
            print "<td class=\"$cl_speed\">" . $speed . "</td>\n";
            $cl_error = $cl;
            if ($perrors > 0) {
                $cl_error = "crc";
            }

            print "<td class=\"$cl_error\">" . $perrors . "</td>\n";
            $snmp_url = "<a href=\"#\" onclick=\"" . open_window_url($f_cacti_url) . " return false;\">" . $ifname . "</a>";

            print "<td class='" . $cl . "' ><button onclick=\"" . open_window_url('portmactable.php?id=' . $row['id']) . " return false;\">" . $row['last_mac_count'] . "</button></td>\n";

            print "<td class='" . $cl . "'>" . $sfp_status . " " . $poe_info . "</td>\n";
            if ($device_model['poe_out']) {
                if (isset($poe_status) and !$row['skip']) {
                    print "<td class=\"data\">";
                    if ($device['vendor_id'] != 9) {
                        if ($poe_status == 2) {
                            print "<button name='poe_on[]' value='{$row['snmp_index']}'>" . WEB_device_poe_on . "</button>";
                        }
                        if ($poe_status == 1) {
                            print "<button name='poe_off[]' value='{$row['snmp_index']}'>" . WEB_device_poe_off . "</button>";
                        }
                    } else {
                        print WEB_msg_unsupported;
                    }
                    print "</td>\n";
                } else {
                    print "<td class=\"data\">";
                    print WEB_msg_unsupported;
                    print "</td>\n";
                }
            }
            if (isset($padmin) and !$row['uplink'] and !$row['skip']) {
                print "<td class=\"data\">";
                if ($device['vendor_id'] != 9) {
                    if ($padmin >= 2) {
                        print "<button name='port_on[]' value='{$row['snmp_index']}'>" . WEB_device_port_on . "</button>";
                    }
                    if ($padmin == 1) {
                        print "<button name='port_off[]' value='{$row['snmp_index']}'>" . WEB_device_port_off . "</button>";
                    }
                } else {
                    print WEB_msg_unsupported;
                }
                print "</td>\n";
            }
            print "</tr>";
        }
        print "<tr>\n";
        print "</table>\n";
        ?>

        <div>
            <?php echo WEB_device_first_port_snmp_value; ?>
            &nbsp
            <input type='text' name='f_snmp_start' value=1>
            <input type='submit' name='regensnmp' value='<?php echo WEB_device_recalc_snmp_port ?>'>
        </div>

<?php
print "<table class=\"data\" cellspacing=\"1\" cellpadding=\"4\">\n";
print "<tr><td>" . WEB_port_status . "</td></tr>\n";
print "<tr><td class=\"down\">" . WEB_port_oper_down . "</td>";
print "<td class=\"up\">" . WEB_port_oper_up . "</td>";
print "<td class=\"shutdown\">" . WEB_port_admin_shutdown . "</td><tr>\n";
print "</table>\n";
print "<table class=\"data\" cellspacing=\"1\" cellpadding=\"4\">\n";
print "<tr><td>" . WEB_port_speed . "</td></tr>\n";
print "<tr><td class=\"speed10M\">" . WEB_port_speed_10 . "</td><td class=\"speed100M\">" . WEB_port_speed_100 . "</td><td class=\"speed1G\">" . WEB_port_speed_1G . "</td><td class=\"speed10G\">" . WEB_port_speed_10G . "</td><tr>\n";
print "</table>\n";
print "</form>";
unset_lock_discovery($db_link, $id);
require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/footer.php");
?>