/**
* Get search function for the class
*
* @return array of search option
**/
function getSearchOptions()
{
$tab = parent::getSearchOptions();
$tab += Location::getSearchOptionsToAdd();
$tab[3]['datatype'] = 'itemlink';
return $tab;
}
/**
* Get search function for the class
*
* @return array of search option
*/
function getSearchOptions()
{
global $LANG;
$tab = parent::getSearchOptions();
$tab += Location::getSearchOptionsToAdd();
$tab[3]['datatype'] = 'itemlink';
$tab[3]['itemlink_type'] = 'Location';
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['datatype'] = 'number';
$tab[2]['massiveaction'] = false;
$tab[34]['table'] = $this->getTable();
$tab[34]['field'] = 'ref';
$tab[34]['name'] = __('Reference');
$tab[34]['datatype'] = 'string';
$tab[4]['table'] = 'glpi_consumableitemtypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab += Location::getSearchOptionsToAdd();
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'alarm_threshold';
$tab[8]['name'] = __('Alert threshold');
$tab[8]['datatype'] = 'number';
$tab[8]['toadd'] = array('-1' => __('Never'));
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = __('Notes');
$tab[90]['massiveaction'] = false;
$tab[90]['datatype'] = 'text';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
return $tab;
}
function getSearchOptions()
{
global $LANG;
$tab = array();
$tab['common'] = $LANG['common'][32];
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_monitortypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = $LANG['common'][17];
$tab[40]['table'] = 'glpi_monitormodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = $LANG['common'][22];
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = $LANG['state'][0];
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = $LANG['common'][19];
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = $LANG['common'][20];
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = $LANG['common'][18];
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = $LANG['common'][21];
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = $LANG['common'][34];
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'name';
$tab[71]['name'] = $LANG['common'][35];
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = $LANG['common'][26];
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = $LANG['title'][37];
$tab[90]['massiveaction'] = false;
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'size';
$tab[11]['name'] = $LANG['monitors'][21];
$tab[11]['datatype'] = 'number';
$tab[41]['table'] = $this->getTable();
$tab[41]['field'] = 'have_micro';
$tab[41]['name'] = $LANG['monitors'][14];
$tab[41]['datatype'] = 'bool';
$tab[42]['table'] = $this->getTable();
$tab[42]['field'] = 'have_speaker';
$tab[42]['name'] = $LANG['monitors'][15];
$tab[42]['datatype'] = 'bool';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_subd';
$tab[43]['name'] = $LANG['monitors'][19];
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_bnc';
$tab[44]['name'] = $LANG['monitors'][20];
$tab[44]['datatype'] = 'bool';
$tab[45]['table'] = $this->getTable();
$tab[45]['field'] = 'have_dvi';
$tab[45]['name'] = $LANG['monitors'][32];
$tab[45]['datatype'] = 'bool';
$tab[46]['table'] = $this->getTable();
$tab[46]['field'] = 'have_pivot';
$tab[46]['name'] = $LANG['monitors'][33];
$tab[46]['datatype'] = 'bool';
$tab[47]['table'] = $this->getTable();
$tab[47]['field'] = 'have_hdmi';
$tab[47]['name'] = $LANG['monitors'][34];
$tab[47]['datatype'] = 'bool';
$tab[48]['table'] = $this->getTable();
$tab[48]['field'] = 'have_displayport';
$tab[48]['name'] = $LANG['monitors'][31];
$tab[48]['datatype'] = 'bool';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab[80]['massiveaction'] = false;
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = $LANG['peripherals'][31];
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['datatype'] = 'number';
$tab[2]['massiveaction'] = false;
$tab[34]['table'] = $this->getTable();
$tab[34]['field'] = 'ref';
$tab[34]['name'] = __('Reference');
$tab[34]['datatype'] = 'string';
$tab[4]['table'] = 'glpi_consumableitemtypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[9]['table'] = 'glpi_consumableitems';
$tab[9]['field'] = '_virtual';
$tab[9]['linkfield'] = '_virtual';
$tab[9]['name'] = _n('Consumable', 'Consumables', Session::getPluralNumber());
$tab[9]['datatype'] = 'specific';
$tab[9]['massiveaction'] = false;
$tab[9]['nosearch'] = true;
$tab[9]['nosort'] = true;
$tab[9]['additionalfields'] = array('alarm_threshold');
$tab[17]['table'] = 'glpi_consumables';
$tab[17]['field'] = 'id';
$tab[17]['name'] = __('Number of used consumables');
$tab[17]['datatype'] = 'count';
$tab[17]['forcegroupby'] = true;
$tab[17]['usehaving'] = true;
$tab[17]['massiveaction'] = false;
$tab[17]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`date_out` IS NOT NULL");
$tab[19]['table'] = 'glpi_consumables';
$tab[19]['field'] = 'id';
$tab[19]['name'] = __('Number of new consumables');
$tab[19]['datatype'] = 'count';
$tab[19]['forcegroupby'] = true;
$tab[19]['usehaving'] = true;
$tab[19]['massiveaction'] = false;
$tab[19]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`date_out` IS NULL");
$tab += Location::getSearchOptionsToAdd();
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'alarm_threshold';
$tab[8]['name'] = __('Alert threshold');
$tab[8]['datatype'] = 'number';
$tab[8]['toadd'] = array('-1' => __('Never'));
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
// Only use for History (not by search Engine)
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[1]['forcegroupby'] = true;
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab[2]['forcegroupby'] = true;
$tab[2]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[3]['table'] = $this->getTable();
$tab[3]['field'] = 'serial';
$tab[3]['name'] = __('Serial number');
$tab[3]['datatype'] = 'string';
$tab[4]['table'] = $this->getTable();
$tab[4]['field'] = 'number';
$tab[4]['name'] = _x('quantity', 'Number');
$tab[4]['datatype'] = 'number';
$tab[4]['max'] = 100;
$tab[4]['toadd'] = array(-1 => __('Unlimited'));
$tab[5]['table'] = 'glpi_softwarelicensetypes';
$tab[5]['field'] = 'name';
$tab[5]['name'] = __('Type');
$tab[5]['datatype'] = 'dropdown';
$tab[6]['table'] = 'glpi_softwareversions';
$tab[6]['field'] = 'name';
$tab[6]['linkfield'] = 'softwareversions_id_buy';
$tab[6]['name'] = __('Purchase version');
$tab[6]['datatype'] = 'dropdown';
$tab[6]['displaywith'] = array('states_id');
$tab[7]['table'] = 'glpi_softwareversions';
$tab[7]['field'] = 'name';
$tab[7]['linkfield'] = 'softwareversions_id_use';
$tab[7]['name'] = __('Version in use');
$tab[7]['datatype'] = 'dropdown';
$tab[7]['displaywith'] = array('states_id');
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'expire';
$tab[8]['name'] = __('Expiration');
$tab[8]['datatype'] = 'date';
$tab[9]['table'] = $this->getTable();
$tab[9]['field'] = 'is_valid';
$tab[9]['name'] = __('Valid');
$tab[9]['datatype'] = 'bool';
$tab[10]['table'] = 'glpi_softwares';
$tab[10]['field'] = 'name';
$tab[10]['name'] = __('Software');
$tab[10]['datatype'] = 'itemlink';
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_softwarelicense`";
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['datatype'] = 'dropdown';
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
$tab[162]['table'] = $this->getTable();
$tab[162]['field'] = 'otherserial';
$tab[162]['name'] = __('Inventory number');
$tab[162]['massiveaction'] = false;
$tab[162]['datatype'] = 'string';
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
// forcegroup by on name set force group by for all items
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Login');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['forcegroupby'] = true;
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab[34]['table'] = $this->getTable();
$tab[34]['field'] = 'realname';
$tab[34]['name'] = __('Surname');
$tab[34]['datatype'] = 'string';
$tab[9]['table'] = $this->getTable();
$tab[9]['field'] = 'firstname';
$tab[9]['name'] = __('First name');
$tab[9]['datatype'] = 'string';
$tab[5]['table'] = 'glpi_useremails';
$tab[5]['field'] = 'email';
$tab[5]['name'] = _n('Email', 'Emails', 2);
$tab[5]['datatype'] = 'email';
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[5]['forcegroupby'] = true;
$tab[5]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'is_active';
$tab[8]['name'] = __('Active');
$tab[8]['datatype'] = 'bool';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'phone';
$tab[6]['name'] = __('Phone');
$tab[6]['datatype'] = 'string';
$tab[10]['table'] = $this->getTable();
$tab[10]['field'] = 'phone2';
$tab[10]['name'] = __('Phone 2');
$tab[10]['datatype'] = 'string';
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'mobile';
$tab[11]['name'] = __('Mobile phone');
$tab[11]['datatype'] = 'string';
$tab[13]['table'] = 'glpi_groups';
$tab[13]['field'] = 'completename';
$tab[13]['name'] = _n('Group', 'Groups', 2);
$tab[13]['forcegroupby'] = true;
$tab[13]['datatype'] = 'itemlink';
$tab[13]['massiveaction'] = false;
$tab[13]['joinparams'] = array('beforejoin' => array('table' => 'glpi_groups_users', 'joinparams' => array('jointype' => 'child')));
$tab[14]['table'] = $this->getTable();
$tab[14]['field'] = 'last_login';
$tab[14]['name'] = __('Last login');
$tab[14]['datatype'] = 'datetime';
$tab[14]['massiveaction'] = false;
$tab[15]['table'] = 'glpi_users';
$tab[15]['field'] = 'authtype';
$tab[15]['name'] = __('Authentication');
$tab[15]['massiveaction'] = false;
$tab[15]['datatype'] = 'specific';
$tab[15]['searchtype'] = 'equals';
$tab[15]['additionalfields'] = array('auths_id');
$tab[30]['table'] = 'glpi_authldaps';
$tab[30]['field'] = 'name';
$tab[30]['linkfield'] = 'auths_id';
$tab[30]['name'] = __('LDAP directory for authentication');
$tab[30]['massiveaction'] = false;
$tab[30]['joinparams'] = array('condition' => "AND REFTABLE.`authtype` = " . Auth::LDAP);
$tab[30]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_authmails';
$tab[31]['field'] = 'name';
$tab[31]['linkfield'] = 'auths_id';
$tab[31]['name'] = __('Email server for authentication');
$tab[31]['massiveaction'] = false;
$tab[31]['joinparams'] = array('condition' => "AND REFTABLE.`authtype` = " . Auth::MAIL);
$tab[31]['datatype'] = 'dropdown';
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[17]['table'] = $this->getTable();
$tab[17]['field'] = 'language';
$tab[17]['name'] = __('Language');
$tab[17]['datatype'] = 'language';
$tab[17]['display_emptychoice'] = true;
$tab[17]['emptylabel'] = __('Default value');
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[20]['table'] = 'glpi_profiles';
$tab[20]['field'] = 'name';
$tab[20]['name'] = sprintf(__('%1$s (%2$s)'), _n('Profile', 'Profiles', 2), _n('Entity', 'Entities', 1));
$tab[20]['forcegroupby'] = true;
$tab[20]['massiveaction'] = false;
$tab[20]['datatype'] = 'dropdown';
$tab[20]['joinparams'] = array('beforejoin' => array('table' => 'glpi_profiles_users', 'joinparams' => array('jointype' => 'child')));
$tab[21]['table'] = $this->getTable();
$tab[21]['field'] = 'user_dn';
$tab[21]['name'] = __('User DN');
$tab[21]['massiveaction'] = false;
$tab[21]['datatype'] = 'string';
$tab[22]['table'] = $this->getTable();
$tab[22]['field'] = 'registration_number';
$tab[22]['name'] = __('Administrative number');
$tab[22]['datatype'] = 'string';
$tab[23]['table'] = $this->getTable();
$tab[23]['field'] = 'date_sync';
$tab[23]['datatype'] = 'datetime';
$tab[23]['name'] = __('Last synchronization');
$tab[23]['massiveaction'] = false;
$tab[80]['table'] = 'glpi_entities';
$tab[80]['linkfield'] = 'entities_id';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = sprintf(__('%1$s (%2$s)'), _n('Entity', 'Entities', 2), _n('Profile', 'Profiles', 1));
$tab[80]['forcegroupby'] = true;
$tab[80]['datatype'] = 'dropdown';
$tab[80]['massiveaction'] = false;
$tab[80]['joinparams'] = array('beforejoin' => array('table' => 'glpi_profiles_users', 'joinparams' => array('jointype' => 'child')));
$tab[81]['table'] = 'glpi_usertitles';
$tab[81]['field'] = 'name';
$tab[81]['name'] = _x('person', 'Title');
$tab[81]['datatype'] = 'dropdown';
$tab[82]['table'] = 'glpi_usercategories';
$tab[82]['field'] = 'name';
$tab[82]['name'] = __('Category');
$tab[82]['datatype'] = 'dropdown';
$tab[79]['table'] = 'glpi_profiles';
$tab[79]['field'] = 'name';
$tab[79]['name'] = __('Default profile');
$tab[79]['datatype'] = 'dropdown';
$tab[77]['table'] = 'glpi_entities';
$tab[77]['field'] = 'name';
$tab[77]['massiveaction'] = true;
$tab[77]['name'] = __('Default entity');
$tab[77]['datatype'] = 'dropdown';
$tab[60]['table'] = 'glpi_tickets';
$tab[60]['field'] = 'count';
$tab[60]['name'] = __('Number of tickets as requester');
$tab[60]['forcegroupby'] = true;
$tab[60]['usehaving'] = true;
$tab[60]['datatype'] = 'number';
$tab[60]['massiveaction'] = false;
$tab[60]['joinparams'] = array('beforejoin' => array('table' => 'glpi_tickets_users', 'joinparams' => array('jointype' => 'child', 'condition' => 'AND NEWTABLE.`type`
= ' . CommonITILActor::REQUESTER)));
$tab[61]['table'] = 'glpi_tickets';
$tab[61]['field'] = 'count';
$tab[61]['name'] = __('Number of written tickets');
$tab[61]['forcegroupby'] = true;
$tab[61]['usehaving'] = true;
$tab[61]['datatype'] = 'number';
$tab[61]['massiveaction'] = false;
$tab[61]['joinparams'] = array('jointype' => 'child', 'linkfield' => 'users_id_recipient');
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = _n('Appliance', 'Appliances', 2, 'appliances');
$tab[1]['table'] = 'glpi_plugin_appliances_appliances';
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[2]['table'] = 'glpi_plugin_appliances_appliancetypes';
$tab[2]['field'] = 'name';
$tab[2]['name'] = __('Type');
$tab[32]['table'] = 'glpi_states';
$tab[32]['field'] = 'completename';
$tab[32]['name'] = _n('Status', 'Statuses', 1);
$tab[32]['displaytype'] = 'dropdown';
$tab[32]['checktype'] = 'text';
$tab[32]['injectable'] = true;
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_plugin_appliances_appliances';
$tab[4]['field'] = 'comment';
$tab[4]['name'] = __('Comments');
$tab[4]['datatype'] = 'text';
$tab[5]['table'] = 'glpi_plugin_appliances_appliances_items';
$tab[5]['field'] = 'items_id';
$tab[5]['name'] = __('Associated items', 'appliances');
$tab[5]['massiveaction'] = false;
$tab[5]['forcegroupby'] = true;
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[6]['table'] = 'glpi_users';
$tab[6]['field'] = 'name';
$tab[6]['name'] = __('User');
$tab[8]['table'] = 'glpi_groups';
$tab[8]['field'] = 'completename';
$tab[8]['name'] = __('Group');
$tab[8]['condition'] = '`is_itemgroup`';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[9]['table'] = 'glpi_plugin_appliances_appliances';
$tab[9]['field'] = 'date_mod';
$tab[9]['name'] = __('Last update');
$tab[9]['massiveaction'] = false;
$tab[9]['datatype'] = 'datetime';
$tab[10]['table'] = 'glpi_plugin_appliances_environments';
$tab[10]['field'] = 'name';
$tab[10]['name'] = __('Environment', 'appliances');
$tab[11]['table'] = 'glpi_plugin_appliances_appliances';
$tab[11]['field'] = 'is_helpdesk_visible';
$tab[11]['name'] = __('Associable to a ticket');
$tab[11]['datatype'] = 'bool';
$tab[12]['table'] = 'glpi_plugin_appliances_appliances';
$tab[12]['field'] = 'serial';
$tab[12]['name'] = __('Serial number');
$tab[13]['table'] = 'glpi_plugin_appliances_appliances';
$tab[13]['field'] = 'otherserial';
$tab[13]['name'] = __('Inventory number');
$tab[31]['table'] = 'glpi_plugin_appliances_appliances';
$tab[31]['field'] = 'id';
$tab[31]['name'] = __('ID');
$tab[31]['massiveaction'] = false;
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[7]['table'] = 'glpi_plugin_appliances_appliances';
$tab[7]['field'] = 'is_recursive';
$tab[7]['name'] = __('Child entities');
$tab[7]['massiveaction'] = false;
$tab[7]['datatype'] = 'bool';
return $tab;
}
function getSearchOptions()
{
global $LANG;
$tab = array();
$tab['common'] = $LANG['common'][32];
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_printertypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = $LANG['common'][17];
$tab[40]['table'] = 'glpi_printermodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = $LANG['common'][22];
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = $LANG['state'][0];
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = $LANG['common'][19];
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = $LANG['common'][20];
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = $LANG['common'][18];
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = $LANG['common'][21];
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = $LANG['common'][34];
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'name';
$tab[71]['name'] = $LANG['common'][35];
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = $LANG['common'][26];
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[42]['table'] = $this->getTable();
$tab[42]['field'] = 'have_serial';
$tab[42]['name'] = $LANG['printers'][14];
$tab[42]['datatype'] = 'bool';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_parallel';
$tab[43]['name'] = $LANG['printers'][15];
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_usb';
$tab[44]['name'] = $LANG['printers'][27];
$tab[44]['datatype'] = 'bool';
$tab[45]['table'] = $this->getTable();
$tab[45]['field'] = 'have_ethernet';
$tab[45]['name'] = $LANG['printers'][28];
$tab[45]['datatype'] = 'bool';
$tab[46]['table'] = $this->getTable();
$tab[46]['field'] = 'have_wifi';
$tab[46]['name'] = $LANG['printers'][29];
$tab[46]['datatype'] = 'bool';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = $LANG['title'][37];
$tab[90]['massiveaction'] = false;
$tab[32]['table'] = 'glpi_networks';
$tab[32]['field'] = 'name';
$tab[32]['name'] = $LANG['setup'][88];
$tab[33]['table'] = 'glpi_domains';
$tab[33]['field'] = 'name';
$tab[33]['name'] = $LANG['setup'][89];
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab[80]['massiveaction'] = false;
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = $LANG['peripherals'][31];
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = $LANG['entity'][9];
$tab[86]['datatype'] = 'bool';
return $tab;
}
function getSearchOptions()
{
global $LANG;
$tab = array();
$tab['common'] = $LANG['common'][32];
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
// implicit key==1
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
// implicit field is id
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_computertypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = $LANG['common'][17];
$tab[40]['table'] = 'glpi_computermodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = $LANG['common'][22];
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = $LANG['state'][0];
$tab[45]['table'] = 'glpi_operatingsystems';
$tab[45]['field'] = 'name';
$tab[45]['name'] = $LANG['computers'][9];
$tab[46]['table'] = 'glpi_operatingsystemversions';
$tab[46]['field'] = 'name';
$tab[46]['name'] = $LANG['computers'][52];
$tab[41]['table'] = 'glpi_operatingsystemservicepacks';
$tab[41]['field'] = 'name';
$tab[41]['name'] = $LANG['computers'][53];
$tab[42]['table'] = 'glpi_autoupdatesystems';
$tab[42]['field'] = 'name';
$tab[42]['name'] = $LANG['computers'][51];
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'os_license_number';
$tab[43]['name'] = $LANG['computers'][10];
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'os_licenseid';
$tab[44]['name'] = $LANG['computers'][11];
$tab[47]['table'] = $this->getTable();
$tab[47]['field'] = 'uuid';
$tab[47]['name'] = $LANG['computers'][58];
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = $LANG['common'][19];
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = $LANG['common'][20];
$tab[6]['datatype'] = 'string';
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = $LANG['title'][37];
$tab[90]['massiveaction'] = false;
$tab[17]['table'] = $this->getTable();
$tab[17]['field'] = 'contact';
$tab[17]['name'] = $LANG['common'][18];
$tab[17]['datatype'] = 'string';
$tab[18]['table'] = $this->getTable();
$tab[18]['field'] = 'contact_num';
$tab[18]['name'] = $LANG['common'][21];
$tab[18]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = $LANG['common'][34];
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'name';
$tab[71]['name'] = $LANG['common'][35];
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = $LANG['common'][26];
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[32]['table'] = 'glpi_networks';
$tab[32]['field'] = 'name';
$tab[32]['name'] = $LANG['setup'][88];
$tab[33]['table'] = 'glpi_domains';
$tab[33]['field'] = 'name';
$tab[33]['name'] = $LANG['setup'][89];
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab['periph'] = $LANG['title'][30];
$tab[7]['table'] = 'glpi_deviceprocessors';
$tab[7]['field'] = 'designation';
$tab[7]['name'] = $LANG['devices'][4];
$tab[7]['forcegroupby'] = true;
$tab[7]['usehaving'] = true;
$tab[7]['massiveaction'] = false;
$tab[7]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_deviceprocessors', 'joinparams' => array('jointype' => 'child')));
$tab[36]['table'] = 'glpi_computers_deviceprocessors';
$tab[36]['field'] = 'specificity';
$tab[36]['name'] = $LANG['devices'][4] . " " . $LANG['setup'][35];
$tab[36]['forcegroupby'] = true;
$tab[36]['usehaving'] = true;
$tab[36]['datatype'] = 'number';
$tab[36]['width'] = 100;
$tab[36]['massiveaction'] = false;
$tab[36]['joinparams'] = array('jointype' => 'child');
$tab[10]['table'] = 'glpi_devicememories';
$tab[10]['field'] = 'designation';
$tab[10]['name'] = $LANG['computers'][23];
$tab[10]['forcegroupby'] = true;
$tab[10]['usehaving'] = true;
$tab[10]['massiveaction'] = false;
$tab[10]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_devicememories', 'joinparams' => array('jointype' => 'child')));
$tab[35]['table'] = 'glpi_computers_devicememories';
$tab[35]['field'] = 'specificity';
$tab[35]['name'] = $LANG['computers'][24];
$tab[35]['forcegroupby'] = true;
$tab[35]['usehaving'] = true;
$tab[35]['datatype'] = 'number';
$tab[35]['width'] = 100;
$tab[35]['massiveaction'] = false;
$tab[35]['joinparams'] = array('jointype' => 'child');
$tab[11]['table'] = 'glpi_devicenetworkcards';
$tab[11]['field'] = 'designation';
$tab[11]['name'] = $LANG['setup'][9];
$tab[11]['forcegroupby'] = true;
$tab[11]['massiveaction'] = false;
$tab[11]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_devicenetworkcards', 'joinparams' => array('jointype' => 'child')));
$tab[12]['table'] = 'glpi_devicesoundcards';
$tab[12]['field'] = 'designation';
$tab[12]['name'] = $LANG['devices'][7];
$tab[12]['forcegroupby'] = true;
$tab[12]['massiveaction'] = false;
$tab[12]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_devicesoundcards', 'joinparams' => array('jointype' => 'child')));
$tab[13]['table'] = 'glpi_devicegraphiccards';
$tab[13]['field'] = 'designation';
$tab[13]['name'] = $LANG['devices'][2];
$tab[13]['forcegroupby'] = true;
$tab[13]['massiveaction'] = false;
$tab[13]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_devicegraphiccards', 'joinparams' => array('jointype' => 'child')));
$tab[14]['table'] = 'glpi_devicemotherboards';
$tab[14]['field'] = 'designation';
$tab[14]['name'] = $LANG['devices'][5];
$tab[14]['forcegroupby'] = true;
$tab[14]['massiveaction'] = false;
$tab[14]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_devicemotherboards', 'joinparams' => array('jointype' => 'child')));
$tab[15]['table'] = 'glpi_deviceharddrives';
$tab[15]['field'] = 'designation';
$tab[15]['name'] = $LANG['computers'][36];
$tab[15]['forcegroupby'] = true;
$tab[15]['usehaving'] = true;
$tab[15]['massiveaction'] = false;
$tab[15]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_deviceharddrives', 'joinparams' => array('jointype' => 'child')));
$tab[34]['table'] = 'glpi_computers_deviceharddrives';
$tab[34]['field'] = 'specificity';
$tab[34]['name'] = $LANG['computers'][25];
$tab[34]['forcegroupby'] = true;
$tab[34]['usehaving'] = true;
$tab[34]['datatype'] = 'number';
$tab[34]['width'] = 1000;
$tab[34]['massiveaction'] = false;
$tab[34]['joinparams'] = array('jointype' => 'child');
$tab[39]['table'] = 'glpi_devicepowersupplies';
$tab[39]['field'] = 'designation';
$tab[39]['name'] = $LANG['devices'][23];
$tab[39]['forcegroupby'] = true;
$tab[39]['usehaving'] = true;
$tab[39]['massiveaction'] = false;
$tab[39]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computers_devicepowersupplies', 'joinparams' => array('jointype' => 'child')));
$tab['disk'] = $LANG['computers'][8];
$tab[156]['table'] = 'glpi_computerdisks';
$tab[156]['field'] = 'name';
$tab[156]['name'] = $LANG['common'][16] . " " . $LANG['computers'][0];
$tab[156]['forcegroupby'] = true;
$tab[156]['massiveaction'] = false;
$tab[156]['joinparams'] = array('jointype' => 'child');
$tab[150]['table'] = 'glpi_computerdisks';
$tab[150]['field'] = 'totalsize';
$tab[150]['name'] = $LANG['computers'][3];
$tab[150]['forcegroupby'] = true;
$tab[150]['usehaving'] = true;
$tab[150]['datatype'] = 'number';
$tab[150]['width'] = 1000;
$tab[150]['massiveaction'] = false;
$tab[150]['joinparams'] = array('jointype' => 'child');
$tab[151]['table'] = 'glpi_computerdisks';
$tab[151]['field'] = 'freesize';
$tab[151]['name'] = $LANG['computers'][2];
$tab[151]['forcegroupby'] = true;
$tab[151]['datatype'] = 'number';
$tab[151]['width'] = 1000;
$tab[151]['massiveaction'] = false;
$tab[151]['joinparams'] = array('jointype' => 'child');
$tab[152]['table'] = 'glpi_computerdisks';
$tab[152]['field'] = 'freepercent';
$tab[152]['name'] = $LANG['computers'][1];
$tab[152]['forcegroupby'] = true;
$tab[152]['datatype'] = 'decimal';
$tab[152]['width'] = 2;
$tab[152]['computation'] = "ROUND(100*TABLE.freesize/TABLE.totalsize)";
$tab[152]['unit'] = '%';
$tab[152]['massiveaction'] = false;
$tab[152]['joinparams'] = array('jointype' => 'child');
$tab[153]['table'] = 'glpi_computerdisks';
$tab[153]['field'] = 'mountpoint';
$tab[153]['name'] = $LANG['computers'][5];
$tab[153]['forcegroupby'] = true;
$tab[153]['massiveaction'] = false;
$tab[153]['joinparams'] = array('jointype' => 'child');
$tab[154]['table'] = 'glpi_computerdisks';
$tab[154]['field'] = 'device';
$tab[154]['name'] = $LANG['computers'][6];
$tab[154]['forcegroupby'] = true;
$tab[154]['massiveaction'] = false;
$tab[154]['joinparams'] = array('jointype' => 'child');
$tab[155]['table'] = 'glpi_filesystems';
$tab[155]['field'] = 'name';
$tab[155]['name'] = $LANG['computers'][4];
$tab[155]['forcegroupby'] = true;
$tab[155]['massiveaction'] = false;
$tab[155]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computerdisks', 'joinparams' => array('jointype' => 'child')));
$tab['ocsng'] = $LANG['Menu'][33];
$tab[102]['table'] = 'glpi_ocslinks';
$tab[102]['field'] = 'last_update';
$tab[102]['name'] = $LANG['ocsng'][13];
$tab[102]['datatype'] = 'datetime';
$tab[102]['massiveaction'] = false;
$tab[102]['joinparams'] = array('jointype' => 'child');
$tab[103]['table'] = 'glpi_ocslinks';
$tab[103]['field'] = 'last_ocs_update';
$tab[103]['name'] = $LANG['ocsng'][14];
$tab[103]['datatype'] = 'datetime';
$tab[103]['massiveaction'] = false;
$tab[103]['joinparams'] = array('jointype' => 'child');
$tab[100]['table'] = $this->getTable();
$tab[100]['field'] = 'is_ocs_import';
$tab[100]['name'] = $LANG['ocsng'][7];
$tab[100]['massiveaction'] = false;
$tab[100]['datatype'] = 'bool';
$tab[101]['table'] = 'glpi_ocslinks';
$tab[101]['field'] = 'use_auto_update';
$tab[101]['linkfield'] = '_auto_update_ocs';
// update through compter update process
$tab[101]['name'] = $LANG['ocsng'][6] . " " . $LANG['Menu'][33];
$tab[101]['datatype'] = 'bool';
$tab[101]['joinparams'] = array('jointype' => 'child');
$tab[104]['table'] = 'glpi_ocslinks';
$tab[104]['field'] = 'ocs_agent_version';
$tab[104]['name'] = $LANG['ocsng'][49];
$tab[104]['massiveaction'] = false;
$tab[104]['joinparams'] = array('jointype' => 'child');
$tab[105]['table'] = 'glpi_ocslinks';
$tab[105]['field'] = 'tag';
$tab[105]['name'] = $LANG['ocsconfig'][39];
$tab[105]['datatype'] = 'string';
$tab[105]['massiveaction'] = false;
$tab[105]['joinparams'] = array('jointype' => 'child');
$tab['registry'] = $LANG['title'][43];
$tab[110]['table'] = 'glpi_registrykeys';
$tab[110]['field'] = 'value';
$tab[110]['name'] = $LANG['title'][43] . " : " . $LANG['registry'][3];
$tab[110]['forcegroupby'] = true;
$tab[110]['massiveaction'] = false;
$tab[110]['joinparams'] = array('jointype' => 'child');
$tab[111]['table'] = 'glpi_registrykeys';
$tab[111]['field'] = 'ocs_name';
$tab[111]['name'] = $LANG['title'][43] . " : " . $LANG['registry'][6];
$tab[111]['forcegroupby'] = true;
$tab[111]['massiveaction'] = false;
$tab[111]['joinparams'] = array('jointype' => 'child');
$tab['virtualmachine'] = $LANG['computers'][57];
$tab[160]['table'] = 'glpi_computervirtualmachines';
$tab[160]['field'] = 'name';
$tab[160]['name'] = $LANG['computers'][57] . " : " . $LANG['common'][16];
$tab[160]['forcegroupby'] = true;
$tab[160]['massiveaction'] = false;
$tab[160]['joinparams'] = array('jointype' => 'child');
$tab[161]['table'] = 'glpi_virtualmachinestates';
$tab[161]['field'] = 'name';
$tab[161]['name'] = $LANG['computers'][63];
$tab[161]['forcegroupby'] = true;
$tab[161]['massiveaction'] = false;
$tab[161]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computervirtualmachines', 'joinparams' => array('jointype' => 'child')));
$tab[162]['table'] = 'glpi_virtualmachinetypes';
$tab[162]['field'] = 'name';
$tab[162]['name'] = $LANG['computers'][60];
$tab[162]['forcegroupby'] = true;
$tab[162]['massiveaction'] = false;
$tab[162]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computervirtualmachines', 'joinparams' => array('jointype' => 'child')));
$tab[163]['table'] = 'glpi_virtualmachinetypes';
$tab[163]['field'] = 'name';
$tab[163]['name'] = $LANG['computers'][62];
$tab[163]['forcegroupby'] = true;
$tab[163]['massiveaction'] = false;
$tab[163]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computervirtualmachines', 'joinparams' => array('jointype' => 'child')));
$tab[164]['table'] = 'glpi_computervirtualmachines';
$tab[164]['field'] = 'vcpu';
$tab[164]['name'] = $LANG['computers'][57] . " : " . $LANG['computers'][61];
$tab[164]['forcegroupby'] = true;
$tab[164]['massiveaction'] = false;
$tab[164]['joinparams'] = array('jointype' => 'child');
$tab[165]['table'] = 'glpi_computervirtualmachines';
$tab[165]['field'] = 'ram';
$tab[165]['name'] = $LANG['computers'][57] . " : " . $LANG['devices'][6];
$tab[165]['forcegroupby'] = true;
$tab[165]['massiveaction'] = false;
$tab[165]['joinparams'] = array('jointype' => 'child');
$tab[165]['datatype'] = 'integer';
$tab[166]['table'] = 'glpi_computervirtualmachines';
$tab[166]['field'] = 'uuid';
$tab[166]['name'] = $LANG['computers'][57] . " : " . $LANG['computers'][58];
$tab[166]['forcegroupby'] = true;
$tab[166]['massiveaction'] = false;
$tab[166]['joinparams'] = array('jointype' => 'child');
$tab[166]['datatype'] = 'integer';
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_networkequipmenttypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_networkequipmentmodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_networkequipment`";
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['datatype'] = 'dropdown';
$tab[71]['condition'] = '`is_itemgroup`';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[121]['table'] = $this->getTable();
$tab[121]['field'] = 'date_creation';
$tab[121]['name'] = __('Creation date');
$tab[121]['datatype'] = 'datetime';
$tab[121]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[11]['table'] = 'glpi_networkequipmentfirmwares';
$tab[11]['field'] = 'name';
$tab[11]['name'] = _n('Firmware', 'Firmwares', 1);
$tab[11]['datatype'] = 'dropdown';
$tab[14]['table'] = $this->getTable();
$tab[14]['field'] = 'ram';
$tab[14]['name'] = sprintf(__('%1$s (%2$s)'), __('Memory'), __('Mio'));
$tab[14]['datatype'] = 'number';
$tab[32]['table'] = 'glpi_networks';
$tab[32]['field'] = 'name';
$tab[32]['name'] = __('Network');
$tab[32]['datatype'] = 'dropdown';
$tab[33]['table'] = 'glpi_domains';
$tab[33]['field'] = 'name';
$tab[33]['name'] = __('Domain');
$tab[33]['datatype'] = 'dropdown';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[121]['table'] = $this->getTable();
$tab[121]['field'] = 'date_creation';
$tab[121]['name'] = __('Creation date');
$tab[121]['datatype'] = 'datetime';
$tab[121]['massiveaction'] = false;
$tab[4]['table'] = 'glpi_budgettypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'begin_date';
$tab[5]['name'] = __('Start date');
$tab[5]['datatype'] = 'date';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'end_date';
$tab[6]['name'] = __('End date');
$tab[6]['datatype'] = 'date';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'value';
$tab[7]['name'] = _x('price', 'Value');
$tab[7]['datatype'] = 'decimal';
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Location::getSearchOptionsToAdd();
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
global $CFG_GLPI, $LANG;
$tab = array();
$tab['common'] = __s('SIM card', 'simcard');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
// implicit key==1
$tab[1]['injectable'] = true;
$tab[1]['checktype'] = 'text';
$tab[1]['displaytype'] = 'text';
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
// implicit field is id
$tab[2]['injectable'] = false;
$tab[4]['table'] = 'glpi_plugin_simcard_simcardtypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[4]['massiveaction'] = true;
$tab[4]['checktype'] = 'text';
$tab[4]['displaytype'] = 'dropdown';
$tab[4]['injectable'] = true;
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('IMSI', 'simcard');
$tab[5]['datatype'] = 'string';
$tab[5]['checktype'] = 'text';
$tab[5]['displaytype'] = 'text';
$tab[5]['injectable'] = true;
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[6]['checktype'] = 'text';
$tab[6]['displaytype'] = 'text';
$tab[6]['injectable'] = true;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[16]['linkfield'] = 'comment';
$tab[16]['checktype'] = 'text';
$tab[16]['displaytype'] = 'multiline_text';
$tab[16]['injectable'] = true;
$tab += Location::getSearchOptionsToAdd();
$tab[3]['checktype'] = 'text';
$tab[3]['displaytype'] = 'dropdown';
$tab[3]['injectable'] = true;
$tab[91]['injectable'] = false;
$tab[93]['injectable'] = false;
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[19]['injectable'] = false;
// TODO : This index has not any similar in GLPI, should find an other index
$tab[23]['table'] = 'glpi_plugin_simcard_simcardvoltages';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Voltage', 'simcard');
$tab[23]['datatype'] = 'dropdown';
$tab[23]['checktype'] = 'text';
$tab[23]['displaytype'] = 'dropdown';
$tab[23]['injectable'] = true;
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[24]['checktype'] = 'text';
$tab[24]['displaytype'] = 'dropdown';
$tab[24]['injectable'] = true;
$tab[25]['table'] = 'glpi_plugin_simcard_simcardsizes';
$tab[25]['field'] = 'name';
$tab[25]['name'] = __('Size', 'simcard');
$tab[25]['datatype'] = 'dropdown';
$tab[25]['checktype'] = 'text';
$tab[25]['displaytype'] = 'dropdown';
$tab[25]['injectable'] = true;
$tab[26]['table'] = 'glpi_plugin_simcard_phoneoperators';
$tab[26]['field'] = 'name';
$tab[26]['name'] = __('Provider', 'simcard');
$tab[26]['datatype'] = 'dropdown';
$tab[26]['checktype'] = 'text';
$tab[26]['displaytype'] = 'dropdown';
$tab[26]['injectable'] = true;
$tab[27]['table'] = $this->getTable();
$tab[27]['field'] = 'phonenumber';
$tab[27]['name'] = __('Phone number', 'simcard');
$tab[27]['datatype'] = 'string';
$tab[27]['checktype'] = 'text';
$tab[27]['displaytype'] = 'text';
$tab[27]['injectable'] = true;
if (PluginSimcardSimcard::canUpdate()) {
$tab[28]['table'] = $this->getTable();
$tab[28]['field'] = 'pin';
$tab[28]['name'] = __('Pin 1', 'simcard');
$tab[28]['datatype'] = 'string';
$tab[28]['checktype'] = 'text';
$tab[28]['displaytype'] = 'text';
$tab[28]['injectable'] = true;
$tab[29]['table'] = $this->getTable();
$tab[29]['field'] = 'puk';
$tab[29]['name'] = __('Puk 1', 'simcard');
$tab[29]['datatype'] = 'string';
$tab[29]['checktype'] = 'text';
$tab[29]['displaytype'] = 'text';
$tab[29]['injectable'] = true;
$tab[30]['table'] = $this->getTable();
$tab[30]['field'] = 'pin2';
$tab[30]['name'] = __('Pin 2', 'simcard');
$tab[30]['datatype'] = 'string';
$tab[30]['checktype'] = 'text';
$tab[30]['displaytype'] = 'text';
$tab[30]['injectable'] = true;
$tab[32]['table'] = $this->getTable();
$tab[32]['field'] = 'puk2';
$tab[32]['name'] = __('Puk 2', 'simcard');
$tab[32]['datatype'] = 'string';
$tab[32]['checktype'] = 'text';
$tab[32]['displaytype'] = 'text';
$tab[32]['injectable'] = true;
}
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['checktype'] = 'text';
$tab[31]['displaytype'] = 'dropdown';
$tab[31]['injectable'] = true;
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['datatype'] = 'dropdown';
$tab[71]['checktype'] = 'text';
$tab[71]['displaytype'] = 'dropdown';
$tab[71]['injectable'] = true;
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'name';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['condition'] = '`is_assign`';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['datatype'] = 'dropdown';
$tab[49]['checktype'] = 'text';
$tab[49]['displaytype'] = 'dropdown';
$tab[49]['injectable'] = true;
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[70]['checktype'] = 'text';
$tab[70]['displaytype'] = 'dropdown';
$tab[70]['injectable'] = true;
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['injectable'] = false;
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = __('Notes');
$tab[90]['massiveaction'] = false;
$tab[90]['linkfield'] = 'notepad';
$tab[90]['checktype'] = 'text';
$tab[90]['displaytype'] = 'multiline_text';
$tab[90]['injectable'] = true;
return $tab;
}
function getSearchOptions()
{
global $LANG;
$tab = array();
$tab[4]['table'] = $this->getTable();
$tab[4]['field'] = 'comment';
$tab[4]['name'] = $LANG['common'][25];
$tab[4]['datatype'] = 'text';
$tab['common'] = $LANG['common'][32];
$tab[1]['table'] = 'reservation_types';
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = 'reservation_types';
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[16]['table'] = 'reservation_types';
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = $LANG['common'][34];
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'name';
$tab[71]['name'] = $LANG['common'][35];
$tab[19]['table'] = 'reservation_types';
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = $LANG['common'][26];
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab[80]['massiveaction'] = false;
return $tab;
}
function getSearchOptions()
{
global $LANG;
// Only use for History (not by search Engine)
$tab = array();
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[7]['table'] = 'glpi_softwarelicenses';
$tab[7]['field'] = 'name';
$tab[7]['name'] = $LANG['common'][19];
$tab[7]['massiveaction'] = false;
$tab[7]['joinparams'] = array('jointype' => 'child');
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = $LANG['title'][37];
$tab[90]['massiveaction'] = false;
$tab[62]['table'] = 'glpi_softwarecategories';
$tab[62]['field'] = 'name';
$tab[62]['name'] = $LANG['common'][36];
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = $LANG['common'][26];
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = $LANG['common'][34];
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'name';
$tab[71]['name'] = $LANG['common'][35];
$tab[61]['table'] = $this->getTable();
$tab[61]['field'] = 'is_helpdesk_visible';
$tab[61]['name'] = $LANG['software'][46];
$tab[61]['datatype'] = 'bool';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab[80]['massiveaction'] = false;
$tab[72]['table'] = 'glpi_computers_softwareversions';
$tab[72]['field'] = 'count';
$tab[72]['name'] = $LANG['tracking'][29] . " - " . $LANG['software'][19];
$tab[72]['forcegroupby'] = true;
$tab[72]['usehaving'] = true;
$tab[72]['datatype'] = 'number';
$tab[72]['nometa'] = true;
$tab[72]['massiveaction'] = false;
$tab[72]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`is_deleted` = '0'\n AND NEWTABLE.`is_template` = '0'", 'beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = $LANG['entity'][9];
$tab[86]['datatype'] = 'bool';
$tab[86]['massiveaction'] = false;
$tab['versions'] = $LANG['software'][5];
$tab[5]['table'] = 'glpi_softwareversions';
$tab[5]['field'] = 'name';
$tab[5]['name'] = $LANG['common'][16] . " - " . $LANG['software'][5];
$tab[5]['forcegroupby'] = true;
$tab[5]['massiveaction'] = false;
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = $LANG['state'][0];
$tab[31]['forcegroupby'] = true;
$tab[31]['massiveaction'] = false;
$tab[31]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
$tab[170]['table'] = 'glpi_softwareversions';
$tab[170]['field'] = 'comment';
$tab[170]['name'] = $LANG['common'][25] . " - " . $LANG['software'][5];
$tab[170]['forcegroupby'] = true;
$tab[170]['datatype'] = 'text';
$tab[170]['massiveaction'] = false;
$tab[170]['joinparams'] = array('jointype' => 'child');
$tab[4]['table'] = 'glpi_operatingsystems';
$tab[4]['field'] = 'name';
$tab[4]['name'] = $LANG['setup'][5] . " - " . $LANG['software'][5];
$tab[4]['forcegroupby'] = true;
$tab[4]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
$tab['license'] = $LANG['software'][11];
$tab[160]['table'] = 'glpi_softwarelicenses';
$tab[160]['field'] = 'name';
$tab[160]['name'] = $LANG['common'][16] . " - " . $LANG['software'][11];
$tab[160]['forcegroupby'] = true;
$tab[160]['massiveaction'] = false;
$tab[160]['joinparams'] = array('jointype' => 'child');
$tab[161]['table'] = 'glpi_softwarelicenses';
$tab[161]['field'] = 'serial';
$tab[161]['name'] = $LANG['common'][19];
$tab[161]['forcegroupby'] = true;
$tab[161]['massiveaction'] = false;
$tab[161]['joinparams'] = array('jointype' => 'child');
$tab[162]['table'] = 'glpi_softwarelicenses';
$tab[162]['field'] = 'otherserial';
$tab[162]['name'] = $LANG['common'][20];
$tab[162]['forcegroupby'] = true;
$tab[162]['massiveaction'] = false;
$tab[162]['joinparams'] = array('jointype' => 'child');
$tab[163]['table'] = 'glpi_softwarelicenses';
$tab[163]['field'] = 'number';
$tab[163]['name'] = $LANG['tracking'][29] . " - " . $LANG['software'][11];
$tab[163]['forcegroupby'] = true;
$tab[163]['usehaving'] = true;
$tab[163]['datatype'] = 'number';
$tab[163]['massiveaction'] = false;
$tab[163]['joinparams'] = array('jointype' => 'child');
$tab[164]['table'] = 'glpi_softwarelicensetypes';
$tab[164]['field'] = 'name';
$tab[164]['name'] = $LANG['software'][30];
$tab[164]['forcegroupby'] = true;
$tab[164]['massiveaction'] = false;
$tab[164]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwarelicenses', 'joinparams' => array('jointype' => 'child')));
$tab[165]['table'] = 'glpi_softwarelicenses';
$tab[165]['field'] = 'comment';
$tab[165]['name'] = $LANG['common'][25] . " - " . $LANG['software'][11];
$tab[165]['forcegroupby'] = true;
$tab[165]['datatype'] = 'text';
$tab[165]['massiveaction'] = false;
$tab[165]['joinparams'] = array('jointype' => 'child');
$tab[166]['table'] = 'glpi_softwarelicenses';
$tab[166]['field'] = 'expire';
$tab[166]['name'] = $LANG['software'][32];
$tab[166]['forcegroupby'] = true;
$tab[166]['datatype'] = 'date';
$tab[166]['massiveaction'] = false;
$tab[166]['joinparams'] = array('jointype' => 'child');
return $tab;
}
/**
* Get the SEARCH_OPTION array
*
* @param $itemtype
* @param $withplugins boolean get search options from plugins
*
* @return the reference to array of search options for the given item type
**/
static function &getOptions($itemtype, $withplugins = true)
{
global $LANG, $CFG_GLPI;
static $search = array();
if (!isset($search[$itemtype])) {
// standard type first
if ($itemtype == 'States') {
$search[$itemtype]['common'] = $LANG['common'][32];
$search['States'][1]['table'] = 'state_types';
$search['States'][1]['field'] = 'name';
$search['States'][1]['name'] = $LANG['common'][16];
$search['States'][1]['datatype'] = 'itemlink';
$search['States'][1]['searchtype'] = 'contains';
$search['States'][2]['table'] = 'state_types';
$search['States'][2]['field'] = 'id';
$search['States'][2]['name'] = $LANG['common'][2];
$search['States'][2]['searchtype'] = 'contains';
$search['States'][31]['table'] = 'glpi_states';
$search['States'][31]['field'] = 'name';
$search['States'][31]['name'] = $LANG['state'][0];
$search['States'] += Location::getSearchOptionsToAdd();
$search['States'][5]['table'] = 'state_types';
$search['States'][5]['field'] = 'serial';
$search['States'][5]['name'] = $LANG['common'][19];
$search['States'][6]['table'] = 'state_types';
$search['States'][6]['field'] = 'otherserial';
$search['States'][6]['name'] = $LANG['common'][20];
$search['States'][16]['table'] = 'state_types';
$search['States'][16]['field'] = 'comment';
$search['States'][16]['name'] = $LANG['common'][25];
$search['States'][16]['datatype'] = 'text';
$search['States'][70]['table'] = 'glpi_users';
$search['States'][70]['field'] = 'name';
$search['States'][70]['name'] = $LANG['common'][34];
$search['States'][71]['table'] = 'glpi_groups';
$search['States'][71]['field'] = 'name';
$search['States'][71]['name'] = $LANG['common'][35];
$search['States'][19]['table'] = 'state_types';
$search['States'][19]['field'] = 'date_mod';
$search['States'][19]['name'] = $LANG['common'][26];
$search['States'][19]['datatype'] = 'datetime';
$search['States'][19]['massiveaction'] = false;
$search['States'][23]['table'] = 'glpi_manufacturers';
$search['States'][23]['field'] = 'name';
$search['States'][23]['name'] = $LANG['common'][5];
$search['States'][24]['table'] = 'glpi_users';
$search['States'][24]['field'] = 'name';
$search['States'][24]['name'] = $LANG['common'][10];
$search['States'][80]['table'] = 'glpi_entities';
$search['States'][80]['field'] = 'completename';
$search['States'][80]['name'] = $LANG['entity'][0];
} else {
if (class_exists($itemtype)) {
$item = new $itemtype();
$search[$itemtype] = $item->getSearchOptions();
}
}
if (getLoginUserID() && in_array($itemtype, $CFG_GLPI["ticket_types"])) {
$search[$itemtype]['tracking'] = $LANG['title'][24];
$search[$itemtype][60]['table'] = 'glpi_tickets';
$search[$itemtype][60]['linkfield'] = 'items_id';
$search[$itemtype][60]['field'] = 'count';
$search[$itemtype][60]['name'] = $LANG['stats'][13];
$search[$itemtype][60]['forcegroupby'] = true;
$search[$itemtype][60]['usehaving'] = true;
$search[$itemtype][60]['datatype'] = 'number';
$search[$itemtype][60]['massiveaction'] = false;
$search[$itemtype][60]['joinparams'] = array('jointype' => "itemtype_item", 'condition' => getEntitiesRestrictRequest('AND', 'NEWTABLE'));
}
if (in_array($itemtype, $CFG_GLPI["networkport_types"])) {
$search[$itemtype] += NetworkPort::getSearchOptionsToAdd($itemtype);
}
if (in_array($itemtype, $CFG_GLPI["contract_types"])) {
$search[$itemtype] += Contract::getSearchOptionsToAdd();
}
if (in_array($itemtype, $CFG_GLPI["infocom_types"])) {
$search[$itemtype] += Infocom::getSearchOptionsToAdd($itemtype);
}
if ($withplugins) {
// Search options added by plugins
$plugsearch = getPluginSearchOptions($itemtype);
if (count($plugsearch)) {
$search[$itemtype] += array('plugins' => $LANG['common'][29]);
$search[$itemtype] += $plugsearch;
}
}
// Complete linkfield if not define
if ($itemtype === 'States') {
$itemtable = 'states_types';
} else {
$itemtable = $item->getTable();
}
foreach ($search[$itemtype] as $key => $val) {
// Compatibility before 0.80 : Force massive action to false if linkfield is empty :
if (isset($val['linkfield']) && empty($val['linkfield'])) {
$search[$itemtype][$key]['massiveaction'] = false;
}
if (!isset($val['linkfield']) || empty($val['linkfield'])) {
if (strcmp($itemtable, $val['table']) == 0 && (!isset($val['joinparams']) || count($val['joinparams']) == 0)) {
$search[$itemtype][$key]['linkfield'] = $val['field'];
} else {
$search[$itemtype][$key]['linkfield'] = getForeignKeyFieldForTable($val['table']);
}
}
// Add default joinparams
if (!isset($val['joinparams'])) {
$search[$itemtype][$key]['joinparams'] = array();
}
}
}
return $search[$itemtype];
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_printertypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_printermodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_printer`";
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[42]['table'] = $this->getTable();
$tab[42]['field'] = 'have_serial';
$tab[42]['name'] = __('Serial');
$tab[42]['datatype'] = 'bool';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_parallel';
$tab[43]['name'] = __('Parallel');
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_usb';
$tab[44]['name'] = __('USB');
$tab[44]['datatype'] = 'bool';
$tab[45]['table'] = $this->getTable();
$tab[45]['field'] = 'have_ethernet';
$tab[45]['name'] = __('Ethernet');
$tab[45]['datatype'] = 'bool';
$tab[46]['table'] = $this->getTable();
$tab[46]['field'] = 'have_wifi';
$tab[46]['name'] = __('Wifi');
$tab[46]['datatype'] = 'bool';
$tab[13]['table'] = $this->getTable();
$tab[13]['field'] = 'memory_size';
$tab[13]['name'] = __('Memory');
$tab[13]['datatype'] = 'string';
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'init_pages_counter';
$tab[11]['name'] = __('Initial page counter');
$tab[11]['datatype'] = 'number';
$tab[11]['nosearch'] = true;
// only display and histo, no index
$tab[12]['table'] = $this->getTable();
$tab[12]['field'] = 'last_pages_counter';
$tab[12]['name'] = __('Current counter of pages');
$tab[12]['datatype'] = 'number';
$tab[9]['table'] = 'glpi_printers';
$tab[9]['field'] = '_virtual';
$tab[9]['linkfield'] = '_virtual';
$tab[9]['name'] = _n('Cartridge', 'Cartridges', Session::getPluralNumber());
$tab[9]['datatype'] = 'specific';
$tab[9]['massiveaction'] = false;
$tab[9]['nosearch'] = true;
$tab[9]['nosort'] = true;
$tab[17]['table'] = 'glpi_cartridges';
$tab[17]['field'] = 'id';
$tab[17]['name'] = __('Number of used cartridges');
$tab[17]['datatype'] = 'count';
$tab[17]['forcegroupby'] = true;
$tab[17]['usehaving'] = true;
$tab[17]['massiveaction'] = false;
$tab[17]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`date_use` IS NOT NULL\n AND NEWTABLE.`date_out` IS NULL");
$tab[18]['table'] = 'glpi_cartridges';
$tab[18]['field'] = 'id';
$tab[18]['name'] = __('Number of worn cartridges');
$tab[18]['datatype'] = 'count';
$tab[18]['forcegroupby'] = true;
$tab[18]['usehaving'] = true;
$tab[18]['massiveaction'] = false;
$tab[18]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`date_out` IS NOT NULL");
$tab[32]['table'] = 'glpi_networks';
$tab[32]['field'] = 'name';
$tab[32]['name'] = __('Network');
$tab[32]['datatype'] = 'dropdown';
$tab[33]['table'] = 'glpi_domains';
$tab[33]['field'] = 'name';
$tab[33]['name'] = __('Domain');
$tab[33]['datatype'] = 'dropdown';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = __('Global management');
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_monitortypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_monitormodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_monitor`";
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'size';
$tab[11]['name'] = __('Size');
$tab[11]['datatype'] = 'number';
$tab[41]['table'] = $this->getTable();
$tab[41]['field'] = 'have_micro';
$tab[41]['name'] = __('Microphone');
$tab[41]['datatype'] = 'bool';
$tab[42]['table'] = $this->getTable();
$tab[42]['field'] = 'have_speaker';
$tab[42]['name'] = __('Speakers');
$tab[42]['datatype'] = 'bool';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_subd';
$tab[43]['name'] = __('Sub-D');
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_bnc';
$tab[44]['name'] = 'BNC';
$tab[44]['datatype'] = 'bool';
$tab[45]['table'] = $this->getTable();
$tab[45]['field'] = 'have_dvi';
$tab[45]['name'] = __('DVI');
$tab[45]['datatype'] = 'bool';
$tab[46]['table'] = $this->getTable();
$tab[46]['field'] = 'have_pivot';
$tab[46]['name'] = __('Pivot');
$tab[46]['datatype'] = 'bool';
$tab[47]['table'] = $this->getTable();
$tab[47]['field'] = 'have_hdmi';
$tab[47]['name'] = __('HDMI');
$tab[47]['datatype'] = 'bool';
$tab[48]['table'] = $this->getTable();
$tab[48]['field'] = 'have_displayport';
$tab[48]['name'] = __('DisplayPort');
$tab[48]['datatype'] = 'bool';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = __('Global management');
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = self::getTypeName(2);
$tab[1]['table'] = $this->table;
$tab[1]['field'] = 'registration_number';
$tab[1]['name'] = __('Administrative number');
$tab[1]['datatype'] = 'string';
$tab[2]['table'] = $this->table;
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab[34]['table'] = $this->table;
$tab[34]['field'] = 'realname';
$tab[34]['name'] = __('Surname');
$tab[34]['datatype'] = 'string';
$tab[9]['table'] = $this->table;
$tab[9]['field'] = 'firstname';
$tab[9]['name'] = __('First name');
$tab[9]['datatype'] = 'string';
$tab[5]['table'] = 'glpi_useremails';
$tab[5]['field'] = 'email';
$tab[5]['name'] = _n('Email', 'Emails', 2);
$tab[5]['datatype'] = 'email';
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[5]['forcegroupby'] = true;
$tab[5]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[6]['table'] = $this->table;
$tab[6]['field'] = 'phone';
$tab[6]['name'] = __('Phone');
$tab[6]['datatype'] = 'string';
$tab[10]['table'] = $this->table;
$tab[10]['field'] = 'phone2';
$tab[10]['name'] = __('Phone 2');
$tab[10]['datatype'] = 'string';
$tab[11]['table'] = $this->table;
$tab[11]['field'] = 'mobile';
$tab[11]['name'] = __('Mobile phone');
$tab[11]['datatype'] = 'string';
// FROM employee
$tab[4313]['table'] = 'glpi_plugin_resources_employers';
$tab[4313]['field'] = 'completename';
$tab[4313]['name'] = PluginResourcesEmployer::getTypeName(1);
$tab[4313]['datatype'] = 'dropdown';
$tab[4314]['table'] = 'glpi_plugin_resources_clients';
$tab[4314]['field'] = 'name';
$tab[4314]['name'] = PluginResourcesClient::getTypeName(1);
$tab[4314]['datatype'] = 'dropdown';
// FROM resources
$tab[4315]['table'] = 'glpi_plugin_resources_contracttypes';
$tab[4315]['field'] = 'name';
$tab[4315]['name'] = PluginResourcesContractType::getTypeName(1);
$tab[4315]['datatype'] = 'dropdown';
$tab[4316]['table'] = 'glpi_plugin_resources_managers';
$tab[4316]['field'] = 'name';
$tab[4316]['name'] = __('Resource manager', 'resources');
$tab[4316]['searchtype'] = 'contains';
$tab[4316]['datatype'] = 'dropdown';
$tab[4317]['table'] = 'glpi_plugin_resources_resources';
$tab[4317]['field'] = 'date_begin';
$tab[4317]['name'] = __('Arrival date', 'resources');
$tab[4317]['datatype'] = 'date';
$tab[4318]['table'] = 'glpi_plugin_resources_resources';
$tab[4318]['field'] = 'date_end';
$tab[4318]['name'] = __('Departure date', 'resources');
$tab[4318]['datatype'] = 'date';
$tab[4319]['table'] = 'glpi_plugin_resources_departments';
$tab[4319]['field'] = 'name';
$tab[4319]['name'] = PluginResourcesDepartment::getTypeName(1);
$tab[4319]['datatype'] = 'dropdown';
$tab[4320]['table'] = 'glpi_plugin_resources_resourcestates';
$tab[4320]['field'] = 'name';
$tab[4320]['name'] = PluginResourcesResourceState::getTypeName(1);
$tab[4320]['datatype'] = 'dropdown';
return $tab;
}
function getSearchOptions()
{
global $CFG_GLPI;
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
// implicit key==1
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
// implicit field is id
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_computertypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_computermodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_computer`";
$tab[45]['table'] = 'glpi_operatingsystems';
$tab[45]['field'] = 'name';
$tab[45]['name'] = __('Operating system');
$tab[45]['datatype'] = 'dropdown';
$tab[46]['table'] = 'glpi_operatingsystemversions';
$tab[46]['field'] = 'name';
$tab[46]['name'] = __('Version of the operating system');
$tab[46]['datatype'] = 'dropdown';
$tab[41]['table'] = 'glpi_operatingsystemservicepacks';
$tab[41]['field'] = 'name';
$tab[41]['name'] = __('Service pack');
$tab[41]['datatype'] = 'dropdown';
$tab[42]['table'] = 'glpi_autoupdatesystems';
$tab[42]['field'] = 'name';
$tab[42]['name'] = __('Update Source');
$tab[42]['datatype'] = 'dropdown';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'os_license_number';
$tab[43]['name'] = __('Serial of the operating system');
$tab[43]['datatype'] = 'string';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'os_licenseid';
$tab[44]['name'] = __('Product ID of the operating system');
$tab[44]['datatype'] = 'string';
$tab[47]['table'] = $this->getTable();
$tab[47]['field'] = 'uuid';
$tab[47]['name'] = __('UUID');
$tab[47]['datatype'] = 'string';
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[32]['table'] = 'glpi_networks';
$tab[32]['field'] = 'name';
$tab[32]['name'] = __('Network');
$tab[32]['datatype'] = 'dropdown';
$tab[33]['table'] = 'glpi_domains';
$tab[33]['field'] = 'name';
$tab[33]['name'] = __('Domain');
$tab[33]['datatype'] = 'dropdown';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['datatype'] = 'dropdown';
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
$tab['periph'] = _n('Component', 'Components', Session::getPluralNumber());
$items_device_joinparams = array('jointype' => 'itemtype_item', 'specific_itemtype' => 'Computer');
$tab[17]['table'] = 'glpi_deviceprocessors';
$tab[17]['field'] = 'designation';
$tab[17]['name'] = __('Processor');
$tab[17]['forcegroupby'] = true;
$tab[17]['usehaving'] = true;
$tab[17]['massiveaction'] = false;
$tab[17]['datatype'] = 'string';
$tab[17]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_deviceprocessors', 'joinparams' => $items_device_joinparams));
$tab[36]['table'] = 'glpi_items_deviceprocessors';
$tab[36]['field'] = 'frequency';
$tab[36]['name'] = __('Processor frequency');
$tab[36]['unit'] = __('MHz');
$tab[36]['forcegroupby'] = true;
$tab[36]['usehaving'] = true;
$tab[36]['datatype'] = 'number';
$tab[36]['width'] = 100;
$tab[36]['massiveaction'] = false;
$tab[36]['joinparams'] = $items_device_joinparams;
$tab[36]['computation'] = "SUM(TABLE.`frequency`) / COUNT(TABLE.`id`)";
$tab[10]['table'] = 'glpi_devicememories';
$tab[10]['field'] = 'designation';
$tab[10]['name'] = __('Memory type');
$tab[10]['forcegroupby'] = true;
$tab[10]['usehaving'] = true;
$tab[10]['massiveaction'] = false;
$tab[10]['datatype'] = 'string';
$tab[10]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicememories', 'joinparams' => $items_device_joinparams));
$tab[35]['table'] = 'glpi_items_devicememories';
$tab[35]['field'] = 'size';
$tab[35]['unit'] = __('Mio');
$tab[35]['name'] = sprintf(__('%1$s (%2$s)'), __('Memory'), __('Mio'));
$tab[35]['forcegroupby'] = true;
$tab[35]['usehaving'] = true;
$tab[35]['datatype'] = 'number';
$tab[35]['width'] = 100;
$tab[35]['massiveaction'] = false;
$tab[35]['joinparams'] = $items_device_joinparams;
$tab[35]['computation'] = "(SUM(TABLE.`size`) / COUNT(TABLE.`id`))\n * COUNT(DISTINCT TABLE.`id`)";
$tab[11]['table'] = 'glpi_devicenetworkcards';
$tab[11]['field'] = 'designation';
$tab[11]['name'] = _n('Network interface', 'Network interfaces', 1);
$tab[11]['forcegroupby'] = true;
$tab[11]['massiveaction'] = false;
$tab[11]['datatype'] = 'string';
$tab[11]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicenetworkcards', 'joinparams' => $items_device_joinparams));
$tab[20]['table'] = 'glpi_items_devicenetworkcards';
$tab[20]['field'] = 'mac';
$tab[20]['name'] = __('MAC address');
$tab[20]['forcegroupby'] = true;
$tab[20]['massiveaction'] = false;
$tab[20]['datatype'] = 'string';
$tab[20]['joinparams'] = $items_device_joinparams;
$tab[12]['table'] = 'glpi_devicesoundcards';
$tab[12]['field'] = 'designation';
$tab[12]['name'] = __('Soundcard');
$tab[12]['forcegroupby'] = true;
$tab[12]['massiveaction'] = false;
$tab[12]['datatype'] = 'string';
$tab[12]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicesoundcards', 'joinparams' => $items_device_joinparams));
$tab[13]['table'] = 'glpi_devicegraphiccards';
$tab[13]['field'] = 'designation';
$tab[13]['name'] = __('Graphics card');
$tab[13]['forcegroupby'] = true;
$tab[13]['massiveaction'] = false;
$tab[13]['datatype'] = 'string';
$tab[13]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicegraphiccards', 'joinparams' => $items_device_joinparams));
$tab[14]['table'] = 'glpi_devicemotherboards';
$tab[14]['field'] = 'designation';
$tab[14]['name'] = __('System board');
$tab[14]['forcegroupby'] = true;
$tab[14]['massiveaction'] = false;
$tab[14]['datatype'] = 'string';
$tab[14]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicemotherboards', 'joinparams' => $items_device_joinparams));
$tab[15]['table'] = 'glpi_deviceharddrives';
$tab[15]['field'] = 'designation';
$tab[15]['name'] = __('Hard drive type');
$tab[15]['forcegroupby'] = true;
$tab[15]['usehaving'] = true;
$tab[15]['massiveaction'] = false;
$tab[15]['datatype'] = 'string';
$tab[15]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_deviceharddrives', 'joinparams' => $items_device_joinparams));
$tab[34]['table'] = 'glpi_items_deviceharddrives';
$tab[34]['field'] = 'capacity';
$tab[34]['name'] = __('Hard drive size');
$tab[34]['unit'] = __('Mio');
$tab[34]['forcegroupby'] = true;
$tab[34]['usehaving'] = true;
$tab[34]['datatype'] = 'number';
$tab[34]['width'] = 1000;
$tab[34]['massiveaction'] = false;
$tab[34]['joinparams'] = $items_device_joinparams;
$tab[34]['computation'] = "(SUM(TABLE.`capacity`) / COUNT(TABLE.`id`))\n * COUNT(DISTINCT TABLE.`id`)";
$tab[39]['table'] = 'glpi_devicepowersupplies';
$tab[39]['field'] = 'designation';
$tab[39]['name'] = __('Power supply');
$tab[39]['forcegroupby'] = true;
$tab[39]['usehaving'] = true;
$tab[39]['massiveaction'] = false;
$tab[39]['datatype'] = 'string';
$tab[39]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicepowersupplies', 'joinparams' => $items_device_joinparams));
$tab[95]['table'] = 'glpi_devicepcis';
$tab[95]['field'] = 'designation';
$tab[95]['name'] = __('Other component');
$tab[95]['forcegroupby'] = true;
$tab[95]['usehaving'] = true;
$tab[95]['massiveaction'] = false;
$tab[95]['datatype'] = 'string';
$tab[95]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_devicepcis', 'joinparams' => $items_device_joinparams));
$tab['disk'] = _n('Volume', 'Volumes', Session::getPluralNumber());
$tab[156]['table'] = 'glpi_computerdisks';
$tab[156]['field'] = 'name';
$tab[156]['name'] = __('Volume');
$tab[156]['forcegroupby'] = true;
$tab[156]['massiveaction'] = false;
$tab[156]['datatype'] = 'dropdown';
$tab[156]['joinparams'] = array('jointype' => 'child');
$tab[150]['table'] = 'glpi_computerdisks';
$tab[150]['field'] = 'totalsize';
$tab[150]['name'] = sprintf(__('%1$s (%2$s)'), __('Global size'), __('Mio'));
$tab[150]['forcegroupby'] = true;
$tab[150]['usehaving'] = true;
$tab[150]['datatype'] = 'number';
$tab[150]['width'] = 1000;
$tab[150]['massiveaction'] = false;
$tab[150]['joinparams'] = array('jointype' => 'child');
$tab[151]['table'] = 'glpi_computerdisks';
$tab[151]['field'] = 'freesize';
$tab[151]['name'] = __('Free size');
$tab[151]['forcegroupby'] = true;
$tab[151]['datatype'] = 'number';
$tab[151]['width'] = 1000;
$tab[151]['massiveaction'] = false;
$tab[151]['joinparams'] = array('jointype' => 'child');
$tab[152]['table'] = 'glpi_computerdisks';
$tab[152]['field'] = 'freepercent';
$tab[152]['name'] = __('Free percentage');
$tab[152]['forcegroupby'] = true;
$tab[152]['datatype'] = 'decimal';
$tab[152]['width'] = 2;
$tab[152]['computation'] = "ROUND(100*TABLE.freesize/TABLE.totalsize)";
$tab[152]['unit'] = '%';
$tab[152]['massiveaction'] = false;
$tab[152]['joinparams'] = array('jointype' => 'child');
$tab[153]['table'] = 'glpi_computerdisks';
$tab[153]['field'] = 'mountpoint';
$tab[153]['name'] = __('Mount point');
$tab[153]['forcegroupby'] = true;
$tab[153]['massiveaction'] = false;
$tab[153]['datatype'] = 'string';
$tab[153]['joinparams'] = array('jointype' => 'child');
$tab[154]['table'] = 'glpi_computerdisks';
$tab[154]['field'] = 'device';
$tab[154]['name'] = __('Partition');
$tab[154]['forcegroupby'] = true;
$tab[154]['massiveaction'] = false;
$tab[154]['datatype'] = 'string';
$tab[154]['joinparams'] = array('jointype' => 'child');
$tab[155]['table'] = 'glpi_filesystems';
$tab[155]['field'] = 'name';
$tab[155]['name'] = __('File system');
$tab[155]['forcegroupby'] = true;
$tab[155]['massiveaction'] = false;
$tab[155]['datatype'] = 'dropdown';
$tab[155]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computerdisks', 'joinparams' => array('jointype' => 'child')));
$tab['virtualmachine'] = _n('Virtual machine', 'Virtual machines', Session::getPluralNumber());
$tab[160]['table'] = 'glpi_computervirtualmachines';
$tab[160]['field'] = 'name';
$tab[160]['name'] = __('Virtual machine');
$tab[160]['forcegroupby'] = true;
$tab[160]['massiveaction'] = false;
$tab[160]['datatype'] = 'dropdown';
$tab[160]['joinparams'] = array('jointype' => 'child');
$tab[161]['table'] = 'glpi_virtualmachinestates';
$tab[161]['field'] = 'name';
$tab[161]['name'] = __('State of the virtual machine');
$tab[161]['forcegroupby'] = true;
$tab[161]['massiveaction'] = false;
$tab[161]['datatype'] = 'dropdown';
$tab[161]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computervirtualmachines', 'joinparams' => array('jointype' => 'child')));
$tab[162]['table'] = 'glpi_virtualmachinesystems';
$tab[162]['field'] = 'name';
$tab[162]['name'] = __('Virtualization model');
$tab[162]['forcegroupby'] = true;
$tab[162]['massiveaction'] = false;
$tab[162]['datatype'] = 'dropdown';
$tab[162]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computervirtualmachines', 'joinparams' => array('jointype' => 'child')));
$tab[163]['table'] = 'glpi_virtualmachinetypes';
$tab[163]['field'] = 'name';
$tab[163]['name'] = __('Virtualization system');
$tab[163]['datatype'] = 'dropdown';
$tab[163]['forcegroupby'] = true;
$tab[163]['massiveaction'] = false;
$tab[163]['joinparams'] = array('beforejoin' => array('table' => 'glpi_computervirtualmachines', 'joinparams' => array('jointype' => 'child')));
$tab[164]['table'] = 'glpi_computervirtualmachines';
$tab[164]['field'] = 'vcpu';
$tab[164]['name'] = __('Virtual machine processor number');
$tab[164]['datatype'] = 'number';
$tab[164]['forcegroupby'] = true;
$tab[164]['massiveaction'] = false;
$tab[164]['joinparams'] = array('jointype' => 'child');
$tab[165]['table'] = 'glpi_computervirtualmachines';
$tab[165]['field'] = 'ram';
$tab[165]['name'] = __('Memory of virtual machines');
$tab[165]['datatype'] = 'number';
$tab[165]['unit'] = __('Mio');
$tab[165]['forcegroupby'] = true;
$tab[165]['massiveaction'] = false;
$tab[165]['joinparams'] = array('jointype' => 'child');
$tab[166]['table'] = 'glpi_computervirtualmachines';
$tab[166]['field'] = 'uuid';
$tab[166]['name'] = __('Virtual machine UUID');
$tab[165]['datatype'] = 'string';
$tab[166]['forcegroupby'] = true;
$tab[166]['massiveaction'] = false;
$tab[166]['joinparams'] = array('jointype' => 'child');
return $tab;
}
function getSearchOptions()
{
global $LANG;
$tab = array();
$tab['common'] = $LANG['common'][32];
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
$tab[34]['table'] = $this->getTable();
$tab[34]['field'] = 'ref';
$tab[34]['name'] = $LANG['consumables'][2];
$tab[34]['datatype'] = 'string';
$tab[4]['table'] = 'glpi_cartridgeitemtypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = $LANG['common'][17];
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab += Location::getSearchOptionsToAdd();
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'alarm_threshold';
$tab[8]['name'] = $LANG['consumables'][38];
$tab[8]['datatype'] = 'number';
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = $LANG['title'][37];
$tab[90]['massiveaction'] = false;
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab[80]['massiveaction'] = false;
$tab[40]['table'] = 'glpi_printermodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = $LANG['setup'][96];
$tab[40]['forcegroupby'] = true;
$tab[40]['joinparams'] = array('beforejoin' => array('table' => 'glpi_cartridgeitems_printermodels', 'joinparams' => array('jointype' => 'child')));
return $tab;
}
function getSearchOptions()
{
global $CFG_GLPI, $LANG;
$tab = array();
$tab['common'] = $LANG['plugin_simcard']['profile'][1];
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
// $tab[1]['name'] = $LANG['common'][16];
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
// implicit key==1
$tab[1]['injectable'] = true;
$tab[1]['checktype'] = 'text';
$tab[1]['displaytype'] = 'text';
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('Type');
$tab[2]['massiveaction'] = false;
// implicit field is id
$tab[2]['injectable'] = false;
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = $LANG['plugin_simcard'][8];
$tab[5]['datatype'] = 'string';
$tab[5]['checktype'] = 'text';
$tab[5]['displaytype'] = 'text';
$tab[5]['injectable'] = true;
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('common');
$tab[6]['datatype'] = 'string';
$tab[6]['checktype'] = 'text';
$tab[6]['displaytype'] = 'text';
$tab[6]['injectable'] = true;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('common');
$tab[16]['datatype'] = 'text';
$tab[16]['linkfield'] = 'comment';
$tab[16]['checktype'] = 'text';
$tab[16]['displaytype'] = 'multiline_text';
$tab[16]['injectable'] = true;
$tab += Location::getSearchOptionsToAdd();
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('login');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[19]['injectable'] = false;
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('common');
$tab[24]['checktype'] = 'text';
$tab[24]['displaytype'] = 'user';
$tab[24]['injectable'] = true;
$tab[23]['table'] = 'glpi_plugin_simcard_simcardvoltages';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['plugin_simcard'][9];
$tab[23]['checktype'] = 'text';
$tab[23]['displaytype'] = 'dropdown';
$tab[23]['injectable'] = true;
$tab[25]['table'] = 'glpi_plugin_simcard_simcardsizes';
$tab[25]['field'] = 'name';
$tab[25]['name'] = $LANG['plugin_simcard'][6];
$tab[25]['checktype'] = 'text';
$tab[25]['displaytype'] = 'dropdown';
$tab[25]['injectable'] = true;
$tab[26]['table'] = 'glpi_plugin_simcard_phoneoperators';
$tab[26]['field'] = 'name';
$tab[26]['name'] = $LANG['plugin_simcard'][7];
$tab[26]['checktype'] = 'text';
$tab[26]['displaytype'] = 'dropdown';
$tab[26]['injectable'] = true;
$tab[27]['table'] = $this->getTable();
$tab[27]['field'] = 'phonenumber';
$tab[27]['name'] = $LANG['plugin_simcard'][1];
$tab[27]['checktype'] = 'text';
$tab[27]['displaytype'] = 'text';
$tab[27]['injectable'] = true;
if (Session::haveRight('simcard', 'w')) {
$tab[28]['table'] = $this->getTable();
$tab[28]['field'] = 'pin';
$tab[28]['name'] = $LANG['plugin_simcard'][3];
$tab[28]['checktype'] = 'text';
$tab[28]['displaytype'] = 'text';
$tab[28]['injectable'] = true;
$tab[29]['table'] = $this->getTable();
$tab[29]['field'] = 'puk';
$tab[29]['name'] = $LANG['plugin_simcard'][4];
$tab[29]['checktype'] = 'text';
$tab[29]['displaytype'] = 'text';
$tab[29]['injectable'] = true;
$tab[30]['table'] = $this->getTable();
$tab[30]['field'] = 'pin2';
$tab[30]['name'] = $LANG['plugin_simcard'][5];
$tab[30]['checktype'] = 'text';
$tab[30]['displaytype'] = 'text';
$tab[30]['injectable'] = true;
$tab[32]['table'] = $this->getTable();
$tab[32]['field'] = 'puk2';
$tab[32]['name'] = $LANG['plugin_simcard'][2];
$tab[32]['checktype'] = 'text';
$tab[32]['displaytype'] = 'text';
$tab[32]['injectable'] = true;
}
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = __('Statut');
$tab[31]['checktype'] = 'text';
$tab[31]['displaytype'] = 'dropdown';
$tab[31]['injectable'] = true;
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'name';
$tab[49]['linkfield'] = 'groups_id';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['checktype'] = 'text';
$tab[49]['displaytype'] = 'dropdown';
$tab[49]['injectable'] = true;
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('Technician in charge of the hardware');
$tab[70]['checktype'] = 'text';
$tab[70]['displaytype'] = 'user';
$tab[70]['injectable'] = true;
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['injectable'] = false;
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = __('title');
$tab[90]['massiveaction'] = false;
$tab[90]['linkfield'] = 'notepad';
$tab[90]['checktype'] = 'text';
$tab[90]['displaytype'] = 'multiline_text';
$tab[90]['injectable'] = true;
$tab[91]['injectable'] = false;
$tab[93]['injectable'] = false;
$tab[3]['checktype'] = 'text';
$tab[3]['displaytype'] = 'dropdown';
$tab[3]['injectable'] = true;
return $tab;
}
function getSearchOptions()
{
// Only use for History (not by search Engine)
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = __('Notes');
$tab[90]['massiveaction'] = false;
$tab[90]['datatype'] = 'text';
$tab[62]['table'] = 'glpi_softwarecategories';
$tab[62]['field'] = 'name';
$tab[62]['name'] = __('Category');
$tab[62]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Publisher');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[61]['table'] = $this->getTable();
$tab[61]['field'] = 'is_helpdesk_visible';
$tab[61]['name'] = __('Associable to a ticket');
$tab[61]['datatype'] = 'bool';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[72]['table'] = 'glpi_computers_softwareversions';
$tab[72]['field'] = 'count';
$tab[72]['name'] = __('Number of installations');
$tab[72]['forcegroupby'] = true;
$tab[72]['usehaving'] = true;
$tab[72]['datatype'] = 'number';
$tab[72]['nometa'] = true;
$tab[72]['massiveaction'] = false;
if (Session::getLoginUserID()) {
$tab[72]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`is_deleted_computer` = '0'\n AND NEWTABLE.`is_deleted` = '0'\n AND NEWTABLE.`is_template_computer` = '0'\n " . getEntitiesRestrictRequest('AND', 'NEWTABLE'), 'beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
}
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
$tab[86]['massiveaction'] = false;
$tab['versions'] = _n('Version', 'Versions', 2);
$tab[5]['table'] = 'glpi_softwareversions';
$tab[5]['field'] = 'name';
$tab[5]['name'] = __('Version name');
$tab[5]['forcegroupby'] = true;
$tab[5]['massiveaction'] = false;
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[5]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['forcegroupby'] = true;
$tab[31]['massiveaction'] = false;
$tab[31]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
$tab[170]['table'] = 'glpi_softwareversions';
$tab[170]['field'] = 'comment';
$tab[170]['name'] = __('Version comments');
$tab[170]['forcegroupby'] = true;
$tab[170]['datatype'] = 'text';
$tab[170]['massiveaction'] = false;
$tab[170]['joinparams'] = array('jointype' => 'child');
$tab[4]['table'] = 'glpi_operatingsystems';
$tab[4]['field'] = 'name';
$tab[4]['datatype'] = 'dropdown';
$tab[4]['name'] = __('Operating system');
$tab[4]['forcegroupby'] = true;
$tab[4]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
$tab['license'] = _n('License', 'Licenses', 2);
$licjoin = array();
$licjoinexpire = array();
if (!Session::isCron()) {
// no filter for cron
$licjoin = array('jointype' => 'child', 'condition' => getEntitiesRestrictRequest(' AND', "NEWTABLE", '', '', true));
$licjoinexpire = array('jointype' => 'child', 'condition' => getEntitiesRestrictRequest(' AND', "NEWTABLE", '', '', true) . " AND (NEWTABLE.`expire` IS NULL\n OR NEWTABLE.`expire` > NOW())");
}
$tab[160]['table'] = 'glpi_softwarelicenses';
$tab[160]['field'] = 'name';
$tab[160]['name'] = __('License name');
$tab[160]['datatype'] = 'dropdown';
$tab[160]['forcegroupby'] = true;
$tab[160]['massiveaction'] = false;
$tab[160]['joinparams'] = $licjoinexpire;
$tab[161]['table'] = 'glpi_softwarelicenses';
$tab[161]['field'] = 'serial';
$tab[161]['datatype'] = 'string';
$tab[161]['name'] = __('License serial number');
$tab[161]['forcegroupby'] = true;
$tab[161]['massiveaction'] = false;
$tab[161]['joinparams'] = $licjoinexpire;
$tab[162]['table'] = 'glpi_softwarelicenses';
$tab[162]['field'] = 'otherserial';
$tab[162]['datatype'] = 'string';
$tab[162]['name'] = __('License inventory number');
$tab[162]['forcegroupby'] = true;
$tab[162]['massiveaction'] = false;
$tab[162]['joinparams'] = $licjoinexpire;
$tab[163]['table'] = 'glpi_softwarelicenses';
$tab[163]['field'] = 'number';
$tab[163]['name'] = __('Number of licenses');
$tab[163]['forcegroupby'] = true;
$tab[163]['usehaving'] = true;
$tab[163]['datatype'] = 'number';
$tab[163]['massiveaction'] = false;
$tab[163]['joinparams'] = $licjoinexpire;
$tab[164]['table'] = 'glpi_softwarelicensetypes';
$tab[164]['field'] = 'name';
$tab[164]['datatype'] = 'dropdown';
$tab[164]['name'] = __('License types');
$tab[164]['forcegroupby'] = true;
$tab[164]['massiveaction'] = false;
$tab[164]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwarelicenses', 'joinparams' => $licjoinexpire));
$tab[165]['table'] = 'glpi_softwarelicenses';
$tab[165]['field'] = 'comment';
$tab[165]['name'] = __('License comments');
$tab[165]['forcegroupby'] = true;
$tab[165]['datatype'] = 'text';
$tab[165]['massiveaction'] = false;
$tab[165]['joinparams'] = $licjoinexpire;
$tab[166]['table'] = 'glpi_softwarelicenses';
$tab[166]['field'] = 'expire';
$tab[166]['name'] = __('Expiration');
$tab[166]['forcegroupby'] = true;
$tab[166]['datatype'] = 'date';
$tab[166]['massiveaction'] = false;
$tab[166]['joinparams'] = $licjoinexpire;
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_peripheraltypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_peripheralmodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_peripheral`";
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[121]['table'] = $this->getTable();
$tab[121]['field'] = 'date_creation';
$tab[121]['name'] = __('Creation date');
$tab[121]['datatype'] = 'datetime';
$tab[121]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'brand';
$tab[11]['name'] = __('Brand');
$tab[11]['datatype'] = 'string';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = __('Global management');
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
/**
* Get the SEARCH_OPTION array
*
* @param $itemtype
* @param $withplugins boolean get search options from plugins (true by default)
*
* @return the reference to array of search options for the given item type
**/
static function &getOptions($itemtype, $withplugins = true)
{
global $CFG_GLPI;
static $search = array();
$item = NULL;
if (!isset($search[$itemtype])) {
// standard type first
switch ($itemtype) {
case 'Internet':
$search[$itemtype]['common'] = __('Characteristics');
$search[$itemtype][1]['table'] = 'networkport_types';
$search[$itemtype][1]['field'] = 'name';
$search[$itemtype][1]['name'] = __('Name');
$search[$itemtype][1]['datatype'] = 'itemlink';
$search[$itemtype][1]['searchtype'] = 'contains';
$search[$itemtype][2]['table'] = 'networkport_types';
$search[$itemtype][2]['field'] = 'id';
$search[$itemtype][2]['name'] = __('ID');
$search[$itemtype][2]['searchtype'] = 'contains';
$search[$itemtype][31]['table'] = 'glpi_states';
$search[$itemtype][31]['field'] = 'completename';
$search[$itemtype][31]['name'] = __('Status');
$search[$itemtype] += NetworkPort::getSearchOptionsToAdd('networkport_types');
break;
case 'AllAssets':
$search[$itemtype]['common'] = __('Characteristics');
$search[$itemtype][1]['table'] = 'asset_types';
$search[$itemtype][1]['field'] = 'name';
$search[$itemtype][1]['name'] = __('Name');
$search[$itemtype][1]['datatype'] = 'itemlink';
$search[$itemtype][1]['searchtype'] = 'contains';
$search[$itemtype][2]['table'] = 'asset_types';
$search[$itemtype][2]['field'] = 'id';
$search[$itemtype][2]['name'] = __('ID');
$search[$itemtype][2]['searchtype'] = 'contains';
$search[$itemtype][31]['table'] = 'glpi_states';
$search[$itemtype][31]['field'] = 'completename';
$search[$itemtype][31]['name'] = __('Status');
$search[$itemtype] += Location::getSearchOptionsToAdd();
$search[$itemtype][5]['table'] = 'asset_types';
$search[$itemtype][5]['field'] = 'serial';
$search[$itemtype][5]['name'] = __('Serial number');
$search[$itemtype][6]['table'] = 'asset_types';
$search[$itemtype][6]['field'] = 'otherserial';
$search[$itemtype][6]['name'] = __('Inventory number');
$search[$itemtype][16]['table'] = 'asset_types';
$search[$itemtype][16]['field'] = 'comment';
$search[$itemtype][16]['name'] = __('Comments');
$search[$itemtype][16]['datatype'] = 'text';
$search[$itemtype][70]['table'] = 'glpi_users';
$search[$itemtype][70]['field'] = 'name';
$search[$itemtype][70]['name'] = __('User');
$search[$itemtype][7]['table'] = 'asset_types';
$search[$itemtype][7]['field'] = 'contact';
$search[$itemtype][7]['name'] = __('Alternate username');
$search[$itemtype][7]['datatype'] = 'string';
$search[$itemtype][8]['table'] = 'asset_types';
$search[$itemtype][8]['field'] = 'contact_num';
$search[$itemtype][8]['name'] = __('Alternate username number');
$search[$itemtype][8]['datatype'] = 'string';
$search[$itemtype][71]['table'] = 'glpi_groups';
$search[$itemtype][71]['field'] = 'completename';
$search[$itemtype][71]['name'] = __('Group');
$search[$itemtype][19]['table'] = 'asset_types';
$search[$itemtype][19]['field'] = 'date_mod';
$search[$itemtype][19]['name'] = __('Last update');
$search[$itemtype][19]['datatype'] = 'datetime';
$search[$itemtype][19]['massiveaction'] = false;
$search[$itemtype][23]['table'] = 'glpi_manufacturers';
$search[$itemtype][23]['field'] = 'name';
$search[$itemtype][23]['name'] = __('Manufacturer');
$search[$itemtype][24]['table'] = 'glpi_users';
$search[$itemtype][24]['field'] = 'name';
$search[$itemtype][24]['linkfield'] = 'users_id_tech';
$search[$itemtype][24]['name'] = __('Technician in charge of the hardware');
$search[$itemtype][80]['table'] = 'glpi_entities';
$search[$itemtype][80]['field'] = 'completename';
$search[$itemtype][80]['name'] = __('Entity');
break;
default:
if ($item = getItemForItemtype($itemtype)) {
$search[$itemtype] = $item->getSearchOptions();
}
break;
}
if (Session::getLoginUserID() && in_array($itemtype, $CFG_GLPI["ticket_types"])) {
$search[$itemtype]['tracking'] = __('Assistance');
$search[$itemtype][60]['table'] = 'glpi_tickets';
$search[$itemtype][60]['field'] = 'id';
$search[$itemtype][60]['datatype'] = 'count';
$search[$itemtype][60]['name'] = _x('quantity', 'Number of tickets');
$search[$itemtype][60]['forcegroupby'] = true;
$search[$itemtype][60]['usehaving'] = true;
$search[$itemtype][60]['massiveaction'] = false;
$search[$itemtype][60]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_tickets', 'joinparams' => array('jointype' => 'itemtype_item')), 'condition' => getEntitiesRestrictRequest('AND', 'NEWTABLE'));
$search[$itemtype][140]['table'] = 'glpi_problems';
$search[$itemtype][140]['field'] = 'id';
$search[$itemtype][140]['datatype'] = 'count';
$search[$itemtype][140]['name'] = _x('quantity', 'Number of problems');
$search[$itemtype][140]['forcegroupby'] = true;
$search[$itemtype][140]['usehaving'] = true;
$search[$itemtype][140]['massiveaction'] = false;
$search[$itemtype][140]['joinparams'] = array('beforejoin' => array('table' => 'glpi_items_problems', 'joinparams' => array('jointype' => 'itemtype_item')), 'condition' => getEntitiesRestrictRequest('AND', 'NEWTABLE'));
}
if (in_array($itemtype, $CFG_GLPI["networkport_types"]) || $itemtype == 'AllAssets') {
$search[$itemtype] += NetworkPort::getSearchOptionsToAdd($itemtype);
}
if (in_array($itemtype, $CFG_GLPI["contract_types"]) || $itemtype == 'AllAssets') {
$search[$itemtype] += Contract::getSearchOptionsToAdd();
}
if (Document::canApplyOn($itemtype) || $itemtype == 'AllAssets') {
$search[$itemtype] += Document::getSearchOptionsToAdd();
}
if (InfoCom::canApplyOn($itemtype) || $itemtype == 'AllAssets') {
$search[$itemtype] += Infocom::getSearchOptionsToAdd($itemtype);
}
if (in_array($itemtype, $CFG_GLPI["link_types"])) {
$search[$itemtype]['link'] = _n('External link', 'External links', Session::getPluralNumber());
$search[$itemtype] += Link::getSearchOptionsToAdd($itemtype);
}
if ($withplugins) {
// Search options added by plugins
$plugsearch = Plugin::getAddSearchOptions($itemtype);
if (count($plugsearch)) {
$search[$itemtype] += array('plugins' => _n('Plugin', 'Plugins', Session::getPluralNumber()));
$search[$itemtype] += $plugsearch;
}
}
// Complete linkfield if not define
if (is_null($item)) {
// Special union type
$itemtable = $CFG_GLPI['union_search_type'][$itemtype];
} else {
if ($item = getItemForItemtype($itemtype)) {
$itemtable = $item->getTable();
}
}
foreach ($search[$itemtype] as $key => $val) {
if (!is_array($val)) {
// skip sub-menu
continue;
}
// Compatibility before 0.80 : Force massive action to false if linkfield is empty :
if (isset($val['linkfield']) && empty($val['linkfield'])) {
$search[$itemtype][$key]['massiveaction'] = false;
}
// Set default linkfield
if (!isset($val['linkfield']) || empty($val['linkfield'])) {
if (strcmp($itemtable, $val['table']) == 0 && (!isset($val['joinparams']) || count($val['joinparams']) == 0)) {
$search[$itemtype][$key]['linkfield'] = $val['field'];
} else {
$search[$itemtype][$key]['linkfield'] = getForeignKeyFieldForTable($val['table']);
}
}
// Set default datatype
// if (!isset($val['datatype']) || empty($val['datatype'])) {
// if ((strcmp($itemtable,$val['table']) != 0)
// && ($val['field'] == 'name' || $val['field'] == 'completename')) {
// $search[$itemtype][$key]['datatype'] = 'dropdown';
// } else {
// $search[$itemtype][$key]['datatype'] = 'string';
// }
// }
// Add default joinparams
if (!isset($val['joinparams'])) {
$search[$itemtype][$key]['joinparams'] = array();
}
}
}
return $search[$itemtype];
}
function getSearchOptions()
{
global $LANG;
$tab = array();
$tab['common'] = $LANG['common'][32];
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = $LANG['common'][16];
$tab[1]['datatype'] = 'itemlink';
$tab[1]['itemlink_type'] = $this->getType();
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = $LANG['common'][2];
$tab[2]['massiveaction'] = false;
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_phonetypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = $LANG['common'][17];
$tab[40]['table'] = 'glpi_phonemodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = $LANG['common'][22];
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'name';
$tab[31]['name'] = $LANG['state'][0];
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = $LANG['common'][19];
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = $LANG['common'][20];
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = $LANG['common'][18];
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = $LANG['common'][21];
$tab[8]['datatype'] = 'string';
$tab[9]['table'] = $this->getTable();
$tab[9]['field'] = 'number_line';
$tab[9]['name'] = $LANG['phones'][40];
$tab[9]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = $LANG['common'][34];
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'name';
$tab[71]['name'] = $LANG['common'][35];
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = $LANG['common'][26];
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = $LANG['common'][25];
$tab[16]['datatype'] = 'text';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = $LANG['title'][37];
$tab[90]['massiveaction'] = false;
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'brand';
$tab[11]['name'] = $LANG['peripherals'][18];
$tab[11]['datatype'] = 'string';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = $LANG['common'][5];
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = $LANG['common'][10];
$tab[42]['table'] = 'glpi_phonepowersupplies';
$tab[42]['field'] = 'name';
$tab[42]['name'] = $LANG['phones'][36];
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_headset';
$tab[43]['name'] = $LANG['phones'][38];
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_hp';
$tab[44]['name'] = $LANG['phones'][39];
$tab[44]['datatype'] = 'bool';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = $LANG['entity'][0];
$tab[80]['massiveaction'] = false;
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = $LANG['peripherals'][31];
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_phonetypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_phonemodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['condition'] = "`is_visible_phone`";
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[9]['table'] = $this->getTable();
$tab[9]['field'] = 'number_line';
$tab[9]['name'] = _x('quantity', 'Number of lines');
$tab[9]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'brand';
$tab[11]['name'] = __('Brand');
$tab[11]['datatype'] = 'string';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[32]['table'] = $this->getTable();
$tab[32]['field'] = 'firmware';
$tab[32]['name'] = __('Firmware');
$tab[32]['datatype'] = 'string';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[42]['table'] = 'glpi_phonepowersupplies';
$tab[42]['field'] = 'name';
$tab[42]['name'] = __('Power supply');
$tab[42]['datatype'] = 'dropdown';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_headset';
$tab[43]['name'] = __('Headset');
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_hp';
$tab[44]['name'] = __('Speaker');
$tab[44]['datatype'] = 'bool';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = __('Global management');
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
// Only use for History (not by search Engine)
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[62]['table'] = 'glpi_softwarecategories';
$tab[62]['field'] = 'completename';
$tab[62]['name'] = __('Category');
$tab[62]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[121]['table'] = $this->getTable();
$tab[121]['field'] = 'date_creation';
$tab[121]['name'] = __('Creation date');
$tab[121]['datatype'] = 'datetime';
$tab[121]['massiveaction'] = false;
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Publisher');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[61]['table'] = $this->getTable();
$tab[61]['field'] = 'is_helpdesk_visible';
$tab[61]['name'] = __('Associable to a ticket');
$tab[61]['datatype'] = 'bool';
$tab[63]['table'] = $this->getTable();
$tab[63]['field'] = 'is_valid';
//TRANS: Indicator to know is all licenses of the software are valids
$tab[63]['name'] = __('Valid licenses');
$tab[63]['datatype'] = 'bool';
$tab += SoftwareLicense::getSearchOptionsToAdd();
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[72]['table'] = 'glpi_computers_softwareversions';
$tab[72]['field'] = 'id';
$tab[72]['name'] = _x('quantity', 'Number of installations');
$tab[72]['forcegroupby'] = true;
$tab[72]['usehaving'] = true;
$tab[72]['datatype'] = 'count';
$tab[72]['nometa'] = true;
$tab[72]['massiveaction'] = false;
if (Session::getLoginUserID()) {
$tab[72]['joinparams'] = array('jointype' => 'child', 'condition' => "AND NEWTABLE.`is_deleted_computer` = '0'\n AND NEWTABLE.`is_deleted` = '0'\n AND NEWTABLE.`is_template_computer` = '0'\n " . getEntitiesRestrictRequest('AND', 'NEWTABLE'), 'beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
}
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
$tab[86]['massiveaction'] = false;
$tab['versions'] = _n('Version', 'Versions', Session::getPluralNumber());
$tab[5]['table'] = 'glpi_softwareversions';
$tab[5]['field'] = 'name';
$tab[5]['name'] = __('Version name');
$tab[5]['forcegroupby'] = true;
$tab[5]['massiveaction'] = false;
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[5]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['forcegroupby'] = true;
$tab[31]['massiveaction'] = false;
$tab[31]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
$tab[170]['table'] = 'glpi_softwareversions';
$tab[170]['field'] = 'comment';
$tab[170]['name'] = __('Version comments');
$tab[170]['forcegroupby'] = true;
$tab[170]['datatype'] = 'text';
$tab[170]['massiveaction'] = false;
$tab[170]['joinparams'] = array('jointype' => 'child');
$tab[4]['table'] = 'glpi_operatingsystems';
$tab[4]['field'] = 'name';
$tab[4]['datatype'] = 'dropdown';
$tab[4]['name'] = __('Operating system');
$tab[4]['forcegroupby'] = true;
$tab[4]['joinparams'] = array('beforejoin' => array('table' => 'glpi_softwareversions', 'joinparams' => array('jointype' => 'child')));
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd(get_class($this));
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab[4]['table'] = $this->getTable();
$tab[4]['field'] = 'comment';
$tab[4]['name'] = __('Comments');
$tab[4]['datatype'] = 'text';
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'is_active';
$tab[5]['name'] = __('Active');
$tab[5]['datatype'] = 'bool';
$tab['common'] = __('Characteristics');
$tab[1]['table'] = 'reservation_types';
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[1]['addobjectparams'] = array('forcetab' => 'Reservation$1');
$tab[2]['table'] = 'reservation_types';
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab[9]['table'] = 'glpi_reservationitems';
$tab[9]['field'] = '_virtual';
$tab[9]['name'] = __('Planning');
$tab[9]['datatype'] = 'specific';
$tab[9]['massiveaction'] = false;
$tab[9]['nosearch'] = true;
$tab[9]['nosort'] = true;
$tab[9]['additionalfields'] = array('is_active');
$loc = Location::getSearchOptionsToAdd();
// Force massive actions to false
foreach ($loc as $key => $val) {
$tab[$key] = $val;
$tab[$key]['massiveaction'] = false;
}
$tab[6]['table'] = 'reservation_types';
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[16]['table'] = 'reservation_types';
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[16]['massiveaction'] = false;
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[70]['massiveaction'] = false;
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['datatype'] = 'dropdown';
$tab[71]['massiveaction'] = false;
$tab[19]['table'] = 'reservation_types';
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[23]['massiveaction'] = false;
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'interface';
$tab[24]['massiveaction'] = false;
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[80]['massiveaction'] = false;
return $tab;
}
function getSearchOptions()
{
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab += Location::getSearchOptionsToAdd();
$tab[4]['table'] = 'glpi_printertypes';
$tab[4]['field'] = 'name';
$tab[4]['name'] = __('Type');
$tab[4]['datatype'] = 'dropdown';
$tab[40]['table'] = 'glpi_printermodels';
$tab[40]['field'] = 'name';
$tab[40]['name'] = __('Model');
$tab[40]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[5]['table'] = $this->getTable();
$tab[5]['field'] = 'serial';
$tab[5]['name'] = __('Serial number');
$tab[5]['datatype'] = 'string';
$tab[6]['table'] = $this->getTable();
$tab[6]['field'] = 'otherserial';
$tab[6]['name'] = __('Inventory number');
$tab[6]['datatype'] = 'string';
$tab[7]['table'] = $this->getTable();
$tab[7]['field'] = 'contact';
$tab[7]['name'] = __('Alternate username');
$tab[7]['datatype'] = 'string';
$tab[8]['table'] = $this->getTable();
$tab[8]['field'] = 'contact_num';
$tab[8]['name'] = __('Alternate username number');
$tab[8]['datatype'] = 'string';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[42]['table'] = $this->getTable();
$tab[42]['field'] = 'have_serial';
$tab[42]['name'] = __('Serial');
$tab[42]['datatype'] = 'bool';
$tab[43]['table'] = $this->getTable();
$tab[43]['field'] = 'have_parallel';
$tab[43]['name'] = __('Parallel');
$tab[43]['datatype'] = 'bool';
$tab[44]['table'] = $this->getTable();
$tab[44]['field'] = 'have_usb';
$tab[44]['name'] = __('USB');
$tab[44]['datatype'] = 'bool';
$tab[45]['table'] = $this->getTable();
$tab[45]['field'] = 'have_ethernet';
$tab[45]['name'] = __('Ethernet');
$tab[45]['datatype'] = 'bool';
$tab[46]['table'] = $this->getTable();
$tab[46]['field'] = 'have_wifi';
$tab[46]['name'] = __('Wifi');
$tab[46]['datatype'] = 'bool';
$tab[13]['table'] = $this->getTable();
$tab[13]['field'] = 'memory_size';
$tab[13]['name'] = __('Memory');
$tab[13]['datatype'] = 'string';
$tab[11]['table'] = $this->getTable();
$tab[11]['field'] = 'init_pages_counter';
$tab[11]['name'] = __('Initial page counter');
$tab[11]['datatype'] = 'number';
$tab[11]['nosearch'] = true;
// only display and histo, no index
$tab[12]['table'] = $this->getTable();
$tab[12]['field'] = 'last_pages_counter';
$tab[12]['name'] = __('Current counter of pages');
$tab[12]['datatype'] = 'number';
$tab[90]['table'] = $this->getTable();
$tab[90]['field'] = 'notepad';
$tab[90]['name'] = __('Notes');
$tab[90]['massiveaction'] = false;
$tab[90]['datatype'] = 'text';
$tab[32]['table'] = 'glpi_networks';
$tab[32]['field'] = 'name';
$tab[32]['name'] = __('Network');
$tab[32]['datatype'] = 'dropdown';
$tab[33]['table'] = 'glpi_domains';
$tab[33]['field'] = 'name';
$tab[33]['name'] = __('Domain');
$tab[33]['datatype'] = 'dropdown';
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Manufacturer');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the hardware');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the hardware');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[82]['table'] = $this->getTable();
$tab[82]['field'] = 'is_global';
$tab[82]['name'] = __('Global management');
$tab[82]['datatype'] = 'bool';
$tab[82]['massiveaction'] = false;
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
return $tab;
}
