<?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