function plugin_databases_getAddSearchOptions($itemtype)
{
$sopt = array();
if (in_array($itemtype, PluginDatabasesDatabase::getTypes(true))) {
if (Session::haveRight("plugin_databases", READ)) {
$sopt[2410]['table'] = 'glpi_plugin_databases_databases';
$sopt[2410]['field'] = 'name';
$sopt[2410]['name'] = PluginDatabasesDatabase::getTypeName(2) . " - " . __('Name');
$sopt[2410]['forcegroupby'] = true;
$sopt[2410]['datatype'] = 'itemlink';
$sopt[2410]['massiveaction'] = false;
$sopt[2410]['itemlink_type'] = 'PluginDatabasesDatabase';
$sopt[2410]['joinparams'] = array('beforejoin' => array('table' => 'glpi_plugin_databases_databases_items', 'joinparams' => array('jointype' => 'itemtype_item')));
$sopt[2411]['table'] = 'glpi_plugin_databases_databasecategories';
$sopt[2411]['field'] = 'name';
$sopt[2411]['name'] = PluginDatabasesDatabase::getTypeName(2) . " - " . PluginDatabasesDatabaseCategory::getTypeName(1);
$sopt[2411]['forcegroupby'] = true;
$sopt[2411]['joinparams'] = array('beforejoin' => array(array('table' => 'glpi_plugin_databases_databases', 'joinparams' => $sopt[2410]['joinparams'])));
$sopt[2411]['datatype'] = 'dropdown';
$sopt[2411]['massiveaction'] = false;
$sopt[2412]['table'] = 'glpi_plugin_databases_servertypes';
$sopt[2412]['field'] = 'name';
$sopt[2412]['name'] = PluginDatabasesDatabase::getTypeName(2) . " - " . PluginDatabasesServerType::getTypeName(1);
$sopt[2412]['forcegroupby'] = true;
$sopt[2412]['joinparams'] = array('beforejoin' => array(array('table' => 'glpi_plugin_databases_databases', 'joinparams' => $sopt[2410]['joinparams'])));
$sopt[2412]['datatype'] = 'dropdown';
$sopt[2412]['massiveaction'] = false;
$sopt[2413]['table'] = 'glpi_plugin_databases_databasetypes';
$sopt[2413]['field'] = 'name';
$sopt[2413]['name'] = PluginDatabasesDatabase::getTypeName(2) . " - " . PluginDatabasesDatabaseType::getTypeName(1);
$sopt[2413]['forcegroupby'] = true;
$sopt[2413]['joinparams'] = array('beforejoin' => array(array('table' => 'glpi_plugin_databases_databases', 'joinparams' => $sopt[2410]['joinparams'])));
$sopt[2413]['datatype'] = 'dropdown';
$sopt[2413]['massiveaction'] = false;
}
}
/*if ($itemtype == 'Ticket') {
if (Session::haveRight("plugin_databases", READ)) {
$sopt[2414]['table'] = 'glpi_plugin_databases_databases';
$sopt[2414]['field'] = 'name';
$sopt[2414]['linkfield'] = 'items_id';
$sopt[2414]['datatype'] = 'itemlink';
$sopt[2414]['massiveaction'] = false;
$sopt[2414]['name'] = __('Database', 'databases')." - ".
__('Name');
}
}*/
return $sopt;
}
function showForm($ID, $options = array())
{
$this->initForm($ID, $options);
$this->showTabs($options);
$this->showFormHeader($options);
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Name') . "</td>";
echo "<td>";
Html::autocompletionTextField($this, "name");
echo "</td>";
echo "<td>" . PluginDatabasesDatabaseCategory::getTypeName(1) . "</td>";
echo "<td>";
Dropdown::show('PluginDatabasesDatabaseCategory', array('name' => "plugin_databases_databasecategories_id", 'value' => $this->fields["plugin_databases_databasecategories_id"], 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Location') . "</td>";
echo "<td>";
Location::dropdown(array('value' => $this->fields["locations_id"], 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "<td>" . PluginDatabasesServerType::getTypeName(1) . "</td>";
echo "<td>";
Dropdown::show('PluginDatabasesServerType', array('name' => "plugin_databases_servertypes_id", 'value' => $this->fields["plugin_databases_servertypes_id"]));
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Technician in charge of the hardware') . "</td><td>";
User::dropdown(array('name' => "users_id_tech", 'value' => $this->fields["users_id_tech"], 'entity' => $this->fields["entities_id"], 'right' => 'interface'));
echo "</td>";
echo "<td>" . PluginDatabasesDatabaseType::getTypeName(1) . "</td>";
echo "<td>";
Dropdown::show('PluginDatabasesDatabaseType', array('name' => "plugin_databases_databasetypes_id", 'value' => $this->fields["plugin_databases_databasetypes_id"], 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Group in charge of the hardware') . "</td><td>";
Group::dropdown(array('name' => 'groups_id_tech', 'value' => $this->fields['groups_id_tech'], 'entity' => $this->fields['entities_id'], 'condition' => '`is_assign`'));
echo "</td>";
echo "<td>" . __('Editor', 'databases') . "</td>";
echo "<td>";
Dropdown::show('Manufacturer', array('name' => "manufacturers_id", 'value' => $this->fields["manufacturers_id"], 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Supplier') . "</td>";
echo "<td>";
Dropdown::show('Supplier', array('name' => "suppliers_id", 'value' => $this->fields["suppliers_id"], 'entity' => $this->fields["entities_id"]));
echo "</td>";
echo "<td>" . __('Associable to a ticket') . "</td><td>";
Dropdown::showYesNo('is_helpdesk_visible', $this->fields['is_helpdesk_visible']);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center' colspan = '4'>";
printf(__('Last update on %s'), Html::convDateTime($this->fields["date_mod"]));
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td colspan = '4'>";
echo "<table cellpadding='2' cellspacing='2' border='0'><tr><td>";
echo __('Comments') . "</td></tr>";
echo "<tr>";
echo "<td class='center'>";
echo "<textarea cols='125' rows='3' name='comment'>" . $this->fields["comment"] . "</textarea>";
echo "</td></tr></table>";
echo "</td>";
echo "</tr>";
$this->showFormButtons($options);
$this->addDivForTabs();
return true;
}
