189 lines
7.3 KiB
PHP
189 lines
7.3 KiB
PHP
<?php
|
|
/**
|
|
* Observium
|
|
*
|
|
* This file is part of Observium.
|
|
*
|
|
* @package observium
|
|
* @subpackage web
|
|
* @copyright (C) Adam Armstrong
|
|
*
|
|
*/
|
|
|
|
?>
|
|
<div class="row">
|
|
<div class="col-md-12">
|
|
|
|
<?php
|
|
|
|
$where = ' WHERE 1 ';
|
|
$where .= generate_query_permitted(['device'], ['device_table' => 'E']);
|
|
|
|
$form_items = [];
|
|
|
|
// Select devices only with Inventory parts
|
|
foreach (dbFetchRows('SELECT E.`device_id` AS `device_id`, `hostname`, `entPhysicalModelName`
|
|
FROM `entPhysical` AS E
|
|
INNER JOIN `devices` AS D ON D.`device_id` = E.`device_id`' . $where .
|
|
'GROUP BY `device_id`, `entPhysicalModelName`;') as $data) {
|
|
|
|
$form_devices[] = $data['device_id'];
|
|
if ($data['entPhysicalModelName'] != '') {
|
|
$form_items['parts'][$data['entPhysicalModelName']] = $data['entPhysicalModelName'];
|
|
}
|
|
}
|
|
|
|
$where_array = build_devices_where_array($vars);
|
|
$query_permitted = generate_query_permitted_ng(['device'], ['device_table' => 'devices']);
|
|
|
|
$where = ' WHERE 1 ';
|
|
$where .= implode('', $where_array);
|
|
|
|
// Generate array with form elements
|
|
//foreach ([ 'os', 'hardware', 'version', 'features', 'type' ] as $entry) {
|
|
foreach (['os'] as $entry) {
|
|
$query = "SELECT DISTINCT `$entry` FROM `devices`";
|
|
|
|
$tmp_where_array = $where_array;
|
|
$tmp_where_array[$entry] = "`$entry` != ''";
|
|
$query .= generate_where_clause($tmp_where_array, $query_permitted);
|
|
|
|
unset($tmp_where_array);
|
|
|
|
$query .= " GROUP BY `$entry` ORDER BY `$entry`";
|
|
|
|
foreach (dbFetchColumn($query) as $item) {
|
|
//dbError();
|
|
|
|
if ($entry === 'os') {
|
|
$name = $config['os'][$item]['text'];
|
|
} else {
|
|
$name = nicecase($item);
|
|
}
|
|
$form_items[$entry][$item] = $name;
|
|
}
|
|
}
|
|
|
|
$form = ['type' => 'rows',
|
|
'space' => '10px',
|
|
'submit_by_key' => TRUE,
|
|
'url' => generate_url($vars)];
|
|
|
|
//Device field
|
|
$form_items['devices'] = generate_form_values('device', $form_devices);
|
|
$form['row'][0]['device_id'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Device',
|
|
'width' => '100%',
|
|
'value' => $vars['device_id'],
|
|
'groups' => ['', 'UP', 'DOWN', 'DISABLED'], // This is optgroup order for values (if required)
|
|
'values' => $form_items['devices']];
|
|
|
|
// Device OS field
|
|
$form['row'][0]['os'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Select OS',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['os'],
|
|
'values' => $form_items['os']];
|
|
|
|
// Parts field
|
|
if (isset($form_items['parts'])) {
|
|
ksort($form_items['parts']);
|
|
}
|
|
$form['row'][0]['parts'] = [
|
|
'type' => 'multiselect',
|
|
'name' => 'Part Numbers',
|
|
'width' => '100%', //'180px',
|
|
'value' => $vars['parts'],
|
|
'values' => $form_items['parts']];
|
|
|
|
//Serial field
|
|
$form['row'][0]['serial'] = [
|
|
'type' => 'text',
|
|
'name' => 'Serial',
|
|
'width' => '100%',
|
|
'placeholder' => TRUE,
|
|
'submit_by_key' => TRUE,
|
|
'value' => escape_html($vars['serial'])];
|
|
|
|
//Description field
|
|
$form['row'][0]['description'] = [
|
|
'type' => 'text',
|
|
'name' => 'Description',
|
|
'grid' => 2,
|
|
'width' => '100%',
|
|
'placeholder' => TRUE,
|
|
'submit_by_key' => TRUE,
|
|
'value' => escape_html($vars['description'])];
|
|
/*
|
|
$form['row'][0]['deleted'] = array(
|
|
'type' => 'toggle',
|
|
'name' => 'Removed',
|
|
'grid' => 1,
|
|
'view' => 'toggle',
|
|
'palette' => 'red',
|
|
'size' => 'large',
|
|
//'width' => '100%',
|
|
//'label' => 'Removed',
|
|
//'submit_by_key' => TRUE,
|
|
'value' => $vars['deleted']);
|
|
*/
|
|
$form['row'][0]['deleted'] = [
|
|
//'type' => 'switch',
|
|
'type' => 'switch-ng',
|
|
//'on-text' => 'Removed',
|
|
'on-color' => 'danger',
|
|
'on-icon' => 'icon-trash',
|
|
//'off-text' => 'Actual',
|
|
'off-icon' => 'icon-sitemap',
|
|
'grid' => 1,
|
|
//'size' => 'large',
|
|
//'height' => '15px',
|
|
'title' => 'Show/Hide Removed',
|
|
//'placeholder' => 'Removed',
|
|
//'readonly' => TRUE,
|
|
//'disabled' => TRUE,
|
|
//'submit_by_key' => TRUE,
|
|
'value' => $vars['deleted']];
|
|
/*
|
|
$form['row'][0]['deleted'] = array(
|
|
//'type' => 'switch',
|
|
'type' => 'toggle',
|
|
//'on-text' => 'Removed',
|
|
//'on-color' => 'danger',
|
|
'on-icon' => 'icon-sitemap',
|
|
//'off-text' => 'Actual',
|
|
'off-icon' => 'icon-trash',
|
|
'grid' => 1,
|
|
//'size' => 'mini',
|
|
//'height' => '15px',
|
|
//'placeholder' => 'Removed',
|
|
//'submit_by_key' => TRUE,
|
|
'value' => $vars['deleted']);
|
|
*/
|
|
// search button
|
|
$form['row'][0]['search'] = [
|
|
'type' => 'submit',
|
|
'grid' => 1,
|
|
'right' => TRUE];
|
|
|
|
print_form($form);
|
|
unset($form, $form_items, $form_devices);
|
|
|
|
// Pagination
|
|
$vars['pagination'] = TRUE;
|
|
|
|
print_inventory($vars);
|
|
|
|
register_html_title('Inventory');
|
|
|
|
?>
|
|
|
|
</div> <!-- col-md-12 -->
|
|
</div> <!-- row -->
|
|
|
|
<?php
|
|
|
|
// EOF
|