Observium_CE/html/includes/search/inventory.inc.php

57 lines
2.0 KiB
PHP

<?php
/**
* Observium
*
* This file is part of Observium.
*
* @package observium
* @subpackage web
* @copyright (C) 2006-2013 Adam Armstrong, (C) 2013-2022 Observium Limited
*
*/
/// SEARCH STATUS
$results = dbFetchRows("SELECT * FROM `entPhysical`
LEFT JOIN `devices` USING (`device_id`)
WHERE `deleted` IS NULL AND (`entPhysicalSerialNum` LIKE ? OR `entPhysicalModelName` LIKE ?) $query_permitted_device
ORDER BY `entPhysicalName` LIMIT $query_limit", [ $query_param, $query_param ]);
if (!safe_empty($results)) {
$max_len = 35;
foreach ($results as $result) {
$name = truncate($result['entPhysicalPhysicalName'], $max_len);
$device_name = truncate($result['hostname'], $max_len);
if ($result['hostname'] != $result['sysName'] && $result['sysName']) {
$device_name .= ' | ' . truncate($result['sysName'], $max_len);
}
if (strlen($result['entPhysicalModelName'])) {
$model = $result['entPhysicalModelName'];
} elseif (strlen($result['entPhysicalDescr'])) {
$model = $result['entPhysicalDescr'];
} elseif (strlen($result['entPhysicalName'])) {
$model = $result['entPhysicalName'];
} else {
$model = "";
}
/// FIXME: once we have alerting, colour this to the sensor's status
$tab_colour = '#194B7F'; // FIXME: This colour pulled from functions.inc.php humanize_device, maybe set it centrally in definitions?
$status_search_results[] = array('url' => generate_device_url($result, array('tab' => 'entphysical')),
'name' => $name, 'colour' => $tab_colour,
'icon' => $config['icon']['inventory'],
'data' => array(
escape_html($device_name),
html_highlight(escape_html($model) . ' | SN: ' . escape_html($result['entPhysicalSerialNum']), $queryString)
)
);
}
$search_results['status'] = array('descr' => 'Inventory entry found', 'results' => $status_search_results);
}
// EOF