function mactrack_device()
{
global $device_actions, $mactrack_device_types, $config, $item_rows;
mactrack_device_request_validation();
if (get_request_var('rows') == -1) {
$row_limit = read_config_option('num_rows_table');
} elseif (get_request_var('rows') == -2) {
$row_limit = 999999;
} else {
$row_limit = get_request_var('rows');
}
html_start_box('MacTrack Device Filters', '100%', '', '3', 'center', 'mactrack_devices.php?action=edit&status=' . get_request_var('status'));
mactrack_device_filter();
html_end_box();
$sql_where = '';
$devices = mactrack_get_devices($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT\n\t\tCOUNT(*)\n\t\tFROM mac_track_sites\n\t\tRIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id\n\t\tLEFT JOIN mac_track_device_types ON mac_track_devices.device_type_id=mac_track_device_types.device_type_id\n\t\t{$sql_where}");
$nav = html_nav_bar('mactrack_devices.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $row_limit, $total_rows, 13, __('Devices'));
form_start('mactrack_devices.php', 'chk');
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('device_name' => array(__('Device Name'), 'ASC'), 'site_name' => array(__('Site Name'), 'ASC'), 'snmp_status' => array(__('Status'), 'ASC'), 'hostname' => array(__('Hostname'), 'ASC'), 'device_type' => array(__('Device Type'), 'ASC'), 'ips_total' => array(__('Total IPs'), 'DESC'), 'ports_total' => array(__('User Ports'), 'DESC'), 'ports_active' => array(__('User Ports Up'), 'DESC'), 'ports_trunk' => array(__('Trunk Ports'), 'DESC'), 'macs_active' => array(__('Active Macs'), 'DESC'), 'last_runduration' => array(__('Last Duration'), 'DESC'));
html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false);
if (sizeof($devices)) {
foreach ($devices as $device) {
form_alternate_row('line' . $device['device_id'], true);
mactrack_format_device_row($device);
}
} else {
print '<tr><td colspan="10"><em>' . __('No MacTrack Devices') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($devices)) {
print $nav;
}
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
form_end();
}
function mactrack_view_devices()
{
global $title, $report, $mactrack_search_types, $mactrack_device_types, $rows_selector, $config, $item_rows;
mactrack_device_request_validation();
if (get_request_var('rows') == -1) {
$row_limit = read_config_option('num_rows_table');
} elseif (get_request_var('rows') == -2) {
$row_limit = 999999;
} else {
$row_limit = get_request_var('rows');
}
$webroot = $config['url_path'] . '/plugins/mactrack/';
mactrack_tabs();
html_start_box($title, '100%', '', '3', 'center', '');
mactrack_device_filter2();
html_end_box();
$sql_where = '';
$devices = mactrack_view_get_device_records($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT\n\t\tCOUNT(mac_track_devices.device_id)\n\t\tFROM mac_track_sites\n\t\tRIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id\n\t\tLEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id)\n\t\t{$sql_where}");
$nav = html_nav_bar('mactrack_view_devices.php?report=devices', MAX_DISPLAY_PAGES, get_request_var('page'), $row_limit, $total_rows, 13, __('Devices'));
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('nosort' => array(__('Actions'), ''), 'device_name' => array(__('Device Name'), 'ASC'), 'site_name' => array(__('Site Name'), 'ASC'), 'snmp_status' => array(__('Status'), 'ASC'), 'hostname' => array(__('Hostname'), 'ASC'), 'device_type' => array(__('Device Type'), 'ASC'), 'ips_total' => array(__('Total IP\'s'), 'DESC'), 'ports_total' => array(__('User Ports'), 'DESC'), 'ports_active' => array(__('User Ports Up'), 'DESC'), 'ports_trunk' => array(__('Trunk Ports'), 'DESC'), 'macs_active' => array(__('Active Macs'), 'DESC'), 'vlans_total' => array(__('Total VLAN\'s'), 'DESC'), 'last_runduration' => array(__('Last Duration'), 'DESC'));
html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'));
$i = 0;
if (sizeof($devices) > 0) {
foreach ($devices as $device) {
$hostinfo['hostname'] = $device['hostname'];
$hostinfo['user'] = $device['user_name'];
switch ($device['term_type']) {
case 0:
$hostinfo['transport'] = 'none';
break;
case 1:
$hostinfo['transport'] = 'telnet';
break;
case 2:
$hostinfo['transport'] = 'ssh';
break;
case 3:
$hostinfo['transport'] = 'http';
break;
case 4:
$hostinfo['transport'] = 'https';
break;
}
form_alternate_row();
?>
<td width=100>
<?php
if (api_user_realm_auth('mactrack_sites.php')) {
?>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_devices.php?action=edit&device_id=' . $device['device_id']);
?>
' title='<?php
print __('Edit Device');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/edit_object.png'></a>
<?php
api_plugin_hook_function('remote_link', $hostinfo);
}
?>
<?php
if ($device['host_id'] > 0) {
?>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_view_graphs.php?action=preview&report=graphs&style=selective&graph_list=&host=' . $device['host_id'] . '&graph_template_id=0&filter=');
?>
' title='<?php
print __('View Graphs');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/view_graphs.gif'></a>
<?php
} else {
?>
<img title='<?php
print __('Device Not Mapped to Cacti Device');
?>
' border='0' src='<?php
print $webroot;
?>
images/view_graphs_disabled.gif'>
<?php
}
?>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_view_macs.php?report=macs&reset&device_id=-1&scan_date=3&site_id=' . get_request_var('site_id') . '&device_id=' . $device['device_id']);
?>
' title='<?php
print __('View MAC Addresses');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/view_macs.gif'></a>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_view_interfaces.php?report=interfaces&reset&site=' . get_request_var('site_id') . '&device=' . $device['device_id']);
?>
' title='<?php
print __('View Interfaces');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/view_interfaces.gif'></a>
</td>
<td class='hyperLink'>
<?php
print filter_value($device['device_name'], get_request_var('filter'));
?>
</td>
<td><?php
print filter_value($device['site_name'], get_request_var('filter'));
?>
<td><?php
print get_colored_device_status($device['disabled'] == 'on' ? true : false, $device['snmp_status']);
?>
</td>
<td><?php
print filter_value($device['hostname'], get_request_var('filter'));
?>
<td><?php
print $device['device_type'];
?>
</td)>
<td><?php
print $device['scan_type'] == '1' ? __('N/A') : number_format_i18n($device['ips_total']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['ports_total']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['ports_active']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['ports_trunk']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['macs_active']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['vlans_total']);
?>
</td>
<td><?php
print number_format($device['last_runduration'], 1);
?>
</td>
</tr>
<?php
}
} else {
print '<tr><td colspan="10"><em>' . __('No MacTrack Devices') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($devices)) {
print $nav;
mactrack_display_stats();
}
}
