/**
* Show ports for an item
*
* @param $item CommonDBTM object
* @param $withtemplate integer withtemplate param (default '')
**/
static function showForItem(CommonDBTM $item, $withtemplate = '')
{
global $DB, $CFG_GLPI;
$rand = mt_rand();
$itemtype = $item->getType();
$items_id = $item->getField('id');
if (!Session::haveRight('networking', 'r') || !$item->can($items_id, 'r')) {
return false;
}
$netport = new self();
$netport->item = $item;
if ($itemtype == 'NetworkPort') {
$canedit = false;
} else {
$canedit = $item->can($items_id, 'w');
}
$showmassiveactions = false;
if ($withtemplate != 2) {
$showmassiveactions = $canedit;
}
// Show Add Form
if ($canedit && (empty($withtemplate) || $withtemplate != 2)) {
echo "\n<form method='get' action='" . $netport->getFormURL() . "'>\n";
echo "<input type='hidden' name='items_id' value='" . $item->getID() . "'>\n";
echo "<input type='hidden' name='itemtype' value='" . $item->getType() . "'>\n";
echo "<div class='firstbloc'><table class='tab_cadre_fixe'>\n";
echo "<tr class='tab_bg_2'><td class='center'>\n";
_e('Network port type to be added');
echo " ";
$instantiations = array();
foreach (self::getNetworkPortInstantiations() as $inst_type) {
if (call_user_func(array($inst_type, 'canCreate'))) {
$instantiations[$inst_type] = call_user_func(array($inst_type, 'getTypeName'));
}
}
Dropdown::showFromArray('instantiation_type', $instantiations, array('value' => 'NetworkPortEthernet'));
echo "</td>\n";
echo "<td class='tab_bg_2 center' width='50%'>";
_e('Add several ports');
echo " <input type='checkbox' name='several' value='1'></td>\n";
echo "<td>\n";
echo "<input type='submit' name='create' value=\"" . _sx('button', 'Add') . "\" class='submit'>\n";
echo "</td></tr></table></div>\n";
Html::closeForm();
}
if ($showmassiveactions) {
$checkbox_column = true;
Html::openMassiveActionsForm('mass' . __CLASS__ . $rand);
} else {
$checkbox_column = false;
}
$is_active_network_port = false;
Session::initNavigateListItems('NetworkPort', sprintf(__('%1$s = %2$s'), $item->getTypeName(1), $item->getName()));
if ($itemtype == 'NetworkPort') {
$porttypes = array('NetworkPortAlias', 'NetworkPortAggregate');
} else {
$porttypes = self::getNetworkPortInstantiations();
// Manage NetworkportMigration
$porttypes[] = '';
}
$display_options = self::getDisplayOptions($itemtype);
$table = new HTMLTableMain();
$number_port = self::countForItem($item);
$table_options = array('canedit' => $canedit, 'display_options' => &$display_options);
// Make table name and add the correct show/hide parameters
$table_name = sprintf(__('%1$s: %2$d'), self::getTypeName($number_port), $number_port);
// Add the link to the popup to display the options ...
$table_namelink = self::getDisplayOptionsLink($itemtype);
$table_name = sprintf(__('%1$s - %2$s'), $table_name, $table_namelink);
$table->setTitle($table_name);
$c_main = $table->addHeader('main', self::getTypeName(2));
if ($display_options['dynamic_import'] && $item->isDynamic()) {
$table_options['display_isDynamic'] = true;
} else {
$table_options['display_isDynamic'] = false;
}
if ($display_options['characteristics']) {
$c_instant = $table->addHeader('Instantiation', __('Characteristics'));
$c_instant->setHTMLClass('center');
}
if ($display_options['internet']) {
$options = array('names' => 'NetworkName', 'aliases' => 'NetworkAlias', 'ipaddresses' => 'IPAddress', 'ipnetworks' => 'IPNetwork');
$table_options['dont_display'] = array();
foreach ($options as $option => $itemtype_for_option) {
if (!$display_options[$option]) {
$table_options['dont_display'][$itemtype_for_option] = true;
}
}
$c_network = $table->addHeader('Internet', _n(__('Internet information'), __('Internet information'), 2));
$c_network->setHTMLClass('center');
} else {
$c_network = NULL;
}
foreach ($porttypes as $portType) {
if (empty($portType)) {
$group_name = 'Migration';
$group_title = __('Network ports waiting for manual migration');
} else {
$group_name = $portType;
$group_title = $portType::getTypeName(2);
}
$t_group = $table->createGroup($group_name, $group_title);
if ($withtemplate != 2 && $canedit) {
$c_checkbox = $t_group->addHeader('checkbox', Html::getCheckAllAsCheckbox('mass' . __CLASS__ . $rand, '__RAND__'), $c_main);
} else {
$c_checkbox = NULL;
}
$c_number = $t_group->addHeader('NetworkPort', "#", $c_main);
$c_name = $t_group->addHeader("Name", __('Name'), $c_main);
$c_name->setItemType('NetworkPort');
$c_name->setHTMLClass('center');
if ($table_options['display_isDynamic']) {
$c_dynamic = $t_group->addHeader("Dynamic", __('Automatic inventory'), $c_main);
$c_dynamic->setHTMLClass('center');
}
if ($display_options['characteristics']) {
if (empty($portType)) {
NetworkPortMigration::getMigrationInstantiationHTMLTableHeaders($t_group, $c_instant, $c_network, NULL, $table_options);
} else {
$instantiation = new $portType();
$instantiation->getInstantiationHTMLTableHeaders($t_group, $c_instant, $c_network, NULL, $table_options);
unset($instantiation);
}
}
if ($display_options['internet'] && !$display_options['characteristics']) {
NetworkName::getHTMLTableHeader(__CLASS__, $t_group, $c_network, NULL, $table_options);
}
if ($itemtype == 'NetworkPort') {
switch ($portType) {
case 'NetworkPortAlias':
$search_table = 'glpi_networkportaliases';
$search_request = "`networkports_id_alias`='{$items_id}'";
break;
case 'NetworkPortAggregate':
$search_table = 'glpi_networkportaggregates';
$search_request = "`networkports_id_list` like '%\"{$items_id}\"%'";
break;
}
$query = "SELECT `networkports_id` AS id\n FROM `{$search_table}`\n WHERE {$search_request}";
} else {
$query = "SELECT `id`\n FROM `glpi_networkports`\n WHERE `items_id` = '{$items_id}'\n AND `itemtype` = '{$itemtype}'\n AND `instantiation_type` = '{$portType}'\n AND `is_deleted` = '0'\n ORDER BY `name`,\n `logical_number`";
}
if ($result = $DB->query($query)) {
echo "<div class='spaced'>";
$number_port = $DB->numrows($result);
if ($number_port != 0) {
$is_active_network_port = true;
$save_canedit = $canedit;
if (!empty($portType)) {
$name = sprintf(__('%1$s (%2$s)'), self::getTypeName($number_port), call_user_func(array($portType, 'getTypeName')));
$name = sprintf(__('%1$s: %2$s'), $name, $number_port);
} else {
$name = __('Network ports waiting for manual migration');
$canedit = false;
}
while ($devid = $DB->fetch_row($result)) {
$t_row = $t_group->createRow();
$netport->getFromDB(current($devid));
// No massive action for migration ports
if ($withtemplate != 2 && $canedit && !empty($portType)) {
$ce_checkbox = $t_row->addCell($c_checkbox, "<input type='checkbox' name='item[" . $netport->fields["id"] . "]' value='1'>");
} else {
$ce_checkbox = NULL;
}
$content = "<span class='b'>";
// Display link based on default rights
if ($save_canedit && $withtemplate != 2) {
if (!empty($portType)) {
$content .= "<a href=\"" . $CFG_GLPI["root_doc"] . "/front/networkport.form.php?id=" . $netport->fields["id"] . "\">";
} else {
$content .= "<a href=\"" . $CFG_GLPI["root_doc"] . "/front/networkportmigration.form.php?id=" . $netport->fields["id"] . "\">";
}
}
$content .= $netport->fields["logical_number"];
if ($canedit && $withtemplate != 2) {
$content .= "</a>";
}
$content .= "</span>";
$content .= Html::showToolTip($netport->fields['comment'], array('display' => false));
$t_row->addCell($c_number, $content);
$value = $netport->fields["name"];
$t_row->addCell($c_name, $value, NULL, $netport);
if ($table_options['display_isDynamic']) {
$t_row->addCell($c_dynamic, Dropdown::getYesNo($netport->fields['is_dynamic']));
}
$instant_cell = NULL;
if ($display_options['characteristics']) {
$instantiation = $netport->getInstantiation();
if ($instantiation !== false) {
$instantiation->getInstantiationHTMLTable($netport, $t_row, NULL, $table_options);
unset($instantiation);
}
} else {
if ($display_options['internet']) {
NetworkName::getHTMLTableCellsForItem($t_row, $netport, NULL, $table_options);
}
}
}
$canedit = $save_canedit;
}
echo "</div>";
}
}
if ($is_active_network_port && $showmassiveactions) {
$massiveactionparams = array('num_displayed' => $number_port, 'check_itemtype' => $itemtype, 'check_items_id' => $items_id);
Html::showMassiveActions('NetworkPort', $massiveactionparams);
}
$table->display(array('display_thead' => false, 'display_tfoot' => false));
unset($table);
if (!$is_active_network_port) {
echo "<table class='tab_cadre_fixe'><tr><th>" . __('No network port found') . "</th></tr>";
echo "</table>";
}
if ($showmassiveactions) {
$massiveactionparams['ontop'] = false;
Html::showMassiveActions('NetworkPort', $massiveactionparams);
Html::closeForm();
}
}
/**
* \brief Show names for an item from its form
* Beware that the rendering can be different if readden from direct item form (ie : add new
* NetworkName, remove, ...) or if readden from item of the item (for instance from the computer
* form through NetworkPort::ShowForItem).
*
* @param $item CommonGLPI object
* @param $withtemplate integer withtemplate param (default 0)
**/
static function showForItem(CommonDBTM $item, $withtemplate = 0)
{
global $DB, $CFG_GLPI;
$ID = $item->getID();
if (!$item->can($ID, READ)) {
return false;
}
$rand = mt_rand();
if ($item->getType() == 'NetworkPort' && Session::haveRight('internet', UPDATE) && $item->canUpdateItem()) {
$items_id = $item->getID();
$itemtype = $item->getType();
echo "<div class='firstbloc'>\n";
echo "<form method='post' action='" . static::getFormURL() . "'>\n";
echo "<table class='tab_cadre_fixe'>\n";
echo "<tr><th colspan='4'>" . __('Add a network name') . "</th></tr>";
echo "<tr class='tab_bg_1'><td class='right'>";
echo "<input type='hidden' name='items_id' value='{$items_id}'>\n";
echo "<input type='hidden' name='itemtype' value='{$itemtype}'>\n";
_e('Not associated');
echo "</td><td class='left'>";
self::dropdown(array('name' => 'addressID', 'condition' => '`items_id`=0'));
echo "</td><td class='left'>";
echo "<input type='submit' name='assign_address' value='" . _sx('button', 'Associate') . "' class='submit'>";
echo "</td>";
if (static::canCreate()) {
echo "<td class='right' width='30%'>";
echo "<a href=\"" . static::getFormURL() . "?items_id={$items_id}&itemtype={$itemtype}\">";
echo __('Create a new network name') . "</a>";
echo "</td>";
}
echo "</tr>\n";
echo "</table>\n";
Html::closeForm();
echo "</div>\n";
}
$table_options = array('createRow' => true);
if ($item->getType() == 'FQDN' || $item->getType() == 'NetworkEquipment') {
if (isset($_GET["start"])) {
$start = $_GET["start"];
} else {
$start = 0;
}
if (!empty($_GET["order"])) {
$table_options['order'] = $_GET["order"];
} else {
$table_options['order'] = 'name';
}
if ($item->getType() == 'FQDN') {
$table_options['column_links'] = array('NetworkName' => 'javascript:reloadTab("order=name");', 'NetworkAlias' => 'javascript:reloadTab("order=alias");', 'IPAddress' => 'javascript:reloadTab("order=ip");');
}
$table_options['SQL_options'] = "LIMIT " . $_SESSION['glpilist_limit'] . "\n OFFSET {$start}";
$canedit = false;
} else {
$canedit = Session::haveRight('internet', UPDATE) && $item->canUpdateItem();
}
$table_options['canedit'] = false;
$table_options['rand'] = $rand;
$table_options['massiveactionnetworkname'] = $canedit;
$table = new HTMLTableMain();
$column = $table->addHeader('Internet', self::getTypeName(Session::getPluralNumber()));
$t_group = $table->createGroup('Main', '');
self::getHTMLTableHeader(__CLASS__, $t_group, $column, NULL, $table_options);
$t_row = $t_group->createRow();
self::getHTMLTableCellsForItem($t_row, $item, NULL, $table_options);
if ($table->getNumberOfRows() > 0) {
$number = $table->getNumberOfRows();
if ($item->getType() == 'FQDN') {
$number = min($_SESSION['glpilist_limit'], $table->getNumberOfRows());
Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, self::countForItem($item));
}
Session::initNavigateListItems(__CLASS__, sprintf(__('%1$s = %2$s'), $item->getTypeName(1), $item->getName()));
if ($canedit && $number) {
Html::openMassiveActionsForm('mass' . __CLASS__ . $rand);
$massiveactionparams = array('num_displayed' => $number, 'container' => 'mass' . __CLASS__ . $rand);
Html::showMassiveActions($massiveactionparams);
}
$table->display(array('display_title_for_each_group' => false, 'display_thead' => false, 'display_tfoot' => false, 'display_header_on_foot_for_each_group' => true));
if ($canedit && $number) {
$massiveactionparams['ontop'] = false;
Html::showMassiveActions($massiveactionparams);
Html::closeForm();
}
if ($item->getType() == 'FQDN') {
Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, self::countForItem($item));
}
} else {
echo "<table class='tab_cadre_fixe'><tr><th>" . __('No network name found') . "</th></tr>";
echo "</table>";
}
}
static function showForItem(CommonGLPI $item, $withtemplate = 0)
{
global $DB, $CFG_GLPI;
if ($item->getType() == 'IPNetwork') {
if (isset($_GET["start"])) {
$start = $_GET["start"];
} else {
$start = 0;
}
if (!empty($_GET["order"])) {
$table_options['order'] = $_GET["order"];
} else {
$table_options['order'] = 'ip';
}
$order_by_itemtype = $table_options['order'] == 'itemtype';
$table_options['SQL_options'] = "LIMIT " . $_SESSION['glpilist_limit'] . "\n OFFSET {$start}";
$table = new HTMLTableMain();
$content = "<a href='javascript:reloadTab(\"order=ip\");'>" . self::getTypeName(Session::getPluralNumber()) . "</a>";
$internet_column = $table->addHeader('IP Address', $content);
$content = sprintf(__('%1$s - %2$s'), _n('Item', 'Items', Session::getPluralNumber()), "<a href='javascript:reloadTab(\"order=itemtype\");'>" . __('Order by item type') . "</a>");
$item_column = $table->addHeader('Item', $content);
if ($order_by_itemtype) {
foreach ($CFG_GLPI["networkport_types"] as $itemtype) {
$table_options['group_' . $itemtype] = $table->createGroup($itemtype, $itemtype::getTypeName(Session::getPluralNumber()));
self::getHTMLTableHeader($item->getType(), $table_options['group_' . $itemtype], $item_column, NULL, $table_options);
}
}
$table_options['group_None'] = $table->createGroup('Main', __('Other kind of items'));
self::getHTMLTableHeader($item->getType(), $table_options['group_None'], $item_column, NULL, $table_options);
self::getHTMLTableCellsForItem(NULL, $item, NULL, $table_options);
if ($table->getNumberOfRows() > 0) {
Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, self::countForItem($item));
Session::initNavigateListItems(__CLASS__, sprintf(__('%1$s = %2$s'), $item->getTypeName(1), $item->getName()));
$table->display(array('display_title_for_each_group' => $order_by_itemtype, 'display_super_for_each_group' => false, 'display_tfoot' => false));
Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, self::countForItem($item));
} else {
echo "<table class='tab_cadre_fixe'>";
echo "<tr><th>" . __('No IP address found') . "</th></tr>";
echo "</table>";
}
}
}
/**
* Get the group of elements regarding given item.
* Two kind of item :
* - Device* feed by a link to the attached item (Computer, Printer ...)
* - Computer, Printer ...: feed by the "global" properties of the CommonDevice
* Then feed with the specificities of the Item_Device elements
* In cas of $item is an instance, then $options contains the type of the item (Computer,
* Printer ...).
*
* @param $item
* @param $table
* @param $options array
* @param $delete_all_column (default NULL)
* @param $common_column
* @param $specific_column
* @param $delete_column (default NULL)
* @param $dynamic_column
**/
function getTableGroup(CommonDBTM $item, HTMLTableMain $table, array $options, HTMLTableSuperHeader $delete_all_column = NULL, HTMLTableSuperHeader $common_column, HTMLTableSuperHeader $specific_column, HTMLTableSuperHeader $delete_column = NULL, $dynamic_column)
{
global $DB;
$is_device = $item instanceof CommonDevice;
if ($is_device) {
$peer_type = $options['itemtype'];
if (empty($peer_type)) {
$column_label = __('Dissociated devices');
$group_name = 'None';
} else {
$column_label = $peer_type::getTypeName(Session::getPluralNumber());
$group_name = $peer_type;
}
$table_group = $table->createGroup($group_name, '');
$peer_column = $table_group->addHeader('item', $column_label, $common_column, NULL);
if (!empty($peer_type)) {
//TRANS : %1$s is the type of the device
// %2$s is the type of the item
// %3$s is the name of the item (used for headings of a list),
$itemtype_nav_title = sprintf(__('%1$s of %2$s: %3$s'), $peer_type::getTypeName(Session::getPluralNumber()), $item->getTypeName(1), $item->getName());
$peer_column->setItemType($peer_type, $itemtype_nav_title);
}
} else {
$peer_type = $this->getDeviceType();
$table_group = $table->createGroup($peer_type, '');
//TRANS : %1$s is the type of the device
// %2$s is the type of the item
// %3$s is the name of the item (used for headings of a list),
$options['itemtype_title'] = sprintf(__('%1$s of %2$s: %3$s'), $peer_type::getTypeName(Session::getPluralNumber()), $item->getTypeName(1), $item->getName());
$peer_type::getHTMLTableHeader($item->getType(), $table_group, $common_column, NULL, $options);
}
$specificity_columns = array();
$link_column = $table_group->addHeader('spec_link', '', $specific_column);
$spec_column = $link_column;
foreach ($this->getSpecificities() as $field => $attributs) {
$spec_column = $table_group->addHeader('spec_' . $field, $attributs['long name'], $specific_column, $spec_column);
$specificity_columns[$field] = $spec_column;
}
$infocom_column = $table_group->addHeader('infocom', Infocom::getTypeName(Session::getPluralNumber()), $specific_column, $spec_column);
$document_column = $table_group->addHeader('document', Document::getTypeName(Session::getPluralNumber()), $specific_column, $spec_column);
if ($item->isDynamic()) {
$dynamics_column = $table_group->addHeader('one', ' ', $dynamic_column, $spec_column);
$previous_column = $dynamics_column;
} else {
$previous_column = $spec_column;
}
if ($options['canedit']) {
$group_checkbox_tag = empty($peer_type) ? '__' : $peer_type;
$content = Html::getCheckbox(array('criterion' => array('tag_for_massive' => $group_checkbox_tag)));
$delete_one = $table_group->addHeader('one', $content, $delete_column, $previous_column);
}
if ($is_device) {
$fk = 'items_id';
// Entity restrict
$leftjoin = '';
$where = "";
if (!empty($peer_type)) {
$leftjoin = "LEFT JOIN `" . getTableForItemType($peer_type) . "`\n ON (`" . $this->getTable() . "`.`items_id` = `" . getTableForItemType($peer_type) . "`.`id`\n AND `" . $this->getTable() . "`.`itemtype` = '{$peer_type}')";
$where = getEntitiesRestrictRequest(" AND", getTableForItemType($peer_type));
}
$query = "SELECT `" . $this->getTable() . "`.*\n FROM `" . $this->getTable() . "`\n {$leftjoin}\n WHERE `" . $this->getDeviceForeignKey() . "` = '" . $item->getID() . "'\n AND `" . $this->getTable() . "`.`itemtype` = '{$peer_type}'\n AND `" . $this->getTable() . "`.`is_deleted` = '0'\n {$where}\n ORDER BY `" . $this->getTable() . "`.`itemtype`, `" . $this->getTable() . "`.`{$fk}`";
} else {
$fk = $this->getDeviceForeignKey();
$query = "SELECT *\n FROM `" . $this->getTable() . "`\n WHERE `itemtype` = '" . $item->getType() . "'\n AND `items_id` = '" . $item->getID() . "'\n AND `is_deleted` = '0'\n ORDER BY {$fk}";
}
if (!empty($peer_type)) {
$peer = new $peer_type();
$peer->getEmpty();
} else {
$peer = NULL;
}
foreach ($DB->request($query) as $link) {
Session::addToNavigateListItems(static::getType(), $link["id"]);
$this->getFromDB($link['id']);
if (is_null($peer) || $link[$fk] != $peer->getID()) {
if ($peer instanceof CommonDBTM) {
$peer->getFromDB($link[$fk]);
}
$current_row = $table_group->createRow();
$peer_group = $peer_type . '_' . $link[$fk] . '_' . mt_rand();
$current_row->setHTMLID($peer_group);
if ($options['canedit']) {
$cell_value = Html::getCheckAllAsCheckbox($peer_group);
$current_row->addCell($delete_all_column, $cell_value);
}
if ($is_device) {
$cell = $current_row->addCell($peer_column, $peer ? $peer->getLink() : __('None'), NULL, $peer);
if (is_null($peer)) {
$cell->setHTMLClass('center');
}
} else {
$peer->getHTMLTableCellForItem($current_row, $item, NULL, $options);
}
}
if (Session::haveRight('device', UPDATE)) {
$mode = __s('Update');
} else {
$mode = __s('View');
}
$spec_cell = $current_row->addCell($link_column, "<a href='" . $this->getLinkURL() . "'>{$mode}</a>");
foreach ($this->getSpecificities() as $field => $attributs) {
if (!empty($link[$field])) {
$content = $link[$field];
} else {
$content = '';
}
$spec_cell = $current_row->addCell($specificity_columns[$field], $content, $spec_cell);
}
if (countElementsInTable('glpi_infocoms', "`itemtype`='" . $this->getType() . "' AND\n `items_id`='" . $link['id'] . "'")) {
$content = array(array('function' => 'Infocom::showDisplayLink', 'parameters' => array($this->getType(), $link['id'])));
} else {
$content = '';
}
$current_row->addCell($infocom_column, $content, $spec_cell);
$content = array();
// The order is to be sure that specific documents appear first
$query = "SELECT `documents_id`\n FROM `glpi_documents_items`\n WHERE (`itemtype` = '" . $this->getType() . "' AND `items_id` = '" . $link['id'] . "')\n OR (`itemtype` = '" . $this->getDeviceType() . "'\n AND `items_id` = '" . $link[$this->getDeviceForeignKey()] . "')\n ORDER BY `itemtype` = '" . $this->getDeviceType() . "'";
$document = new Document();
foreach ($DB->request($query) as $document_link) {
if ($document->can($document_link['documents_id'], READ)) {
$content[] = $document->getLink();
}
}
$content = implode('<br>', $content);
$current_row->addCell($document_column, $content, $spec_cell);
if ($item->isDynamic()) {
$previous_cell = $current_row->addCell($dynamics_column, Dropdown::getYesNo($link['is_dynamic']), $spec_cell);
} else {
$previous_cell = $spec_cell;
}
if ($options['canedit']) {
$cell_value = Html::getMassiveActionCheckBox($this->getType(), $link['id'], array('massive_tags' => $group_checkbox_tag));
$current_row->addCell($delete_one, $cell_value, $previous_cell);
}
}
}
static function getTableGroup(CommonDBTM $item, HTMLTableMain $table, array $options, HTMLTableSuperHeader $delete_all_column = NULL, HTMLTableSuperHeader $common_column, HTMLTableSuperHeader $specific_column, HTMLTableSuperHeader $delete_column = NULL, $dynamic_column)
{
global $DB;
$device_type = static::getDeviceType();
$table_group = $table->createGroup($device_type, '');
//TRANS : %1$s is the type of the device
// %2$s is the type of the item
// %3$s is the name of the item (used for headings of a list),
$options['itemtype_title'] = sprintf(__('%1$s of %2$s: %3$s'), $device_type::getTypeName(2), $item->getTypeName(1), $item->getName());
$device_type::getHTMLTableHeader($item->getType(), $table_group, $common_column, NULL, $options);
$spec_column = NULL;
$specificity_columns = array();
foreach (static::getSpecificities() as $field => $attributs) {
$spec_column = $table_group->addHeader('spec_' . $field, $attributs['long name'], $specific_column, $spec_column);
$specificity_columns[$field] = $spec_column;
}
if ($item->isDynamic()) {
$dynamics_column = $table_group->addHeader('one', ' ', $dynamic_column, $spec_column);
$previous_column = $dynamics_column;
} else {
$previous_column = $spec_column;
}
if ($options['canedit']) {
$delete_one = $table_group->addHeader('one', ' ', $delete_column, $previous_column);
}
$fk = static::getDeviceForeignKey();
$query = "SELECT *\n FROM `" . static::getTable() . "`\n WHERE `itemtype` = '" . $item->getType() . "'\n AND `items_id` = '" . $item->getID() . "'\n AND `is_deleted` = '0'\n ORDER BY {$fk}";
$device = new $device_type();
$device->getEmpty();
foreach ($DB->request($query) as $link) {
if ($link[$fk] != $device->getID()) {
$device->getFromDB($link[$fk]);
$current_row = $table_group->createRow();
$device_group = $device_type . '_' . $link[$fk] . '_' . mt_rand();
$current_row->setHTMLID($device_group);
if ($options['canedit']) {
$cell_value = Html::getCheckAllAsCheckbox($device_group);
$current_row->addCell($delete_all_column, $cell_value);
}
$device->getHTMLTableCellForItem($current_row, $item, NULL, $options);
}
$spec_cell = NULL;
foreach (static::getSpecificities() as $field => $attributs) {
$content = $link[$field];
if ($options['canedit']) {
$content = "<input type='text' name='value_" . $device_type . "_" . $link['id'] . "_" . $field . "' value='{$content}' size='" . $attributs['size'] . "'>";
}
$spec_cell = $current_row->addCell($specificity_columns[$field], $content, $spec_cell);
}
if ($item->isDynamic()) {
$previous_cell = $current_row->addCell($dynamics_column, Dropdown::getYesNo($link['is_dynamic']), $spec_cell);
} else {
$previous_cell = $spec_cell;
}
if ($options['canedit']) {
$cell_value = "<input type='checkbox' name='remove_" . $device_type . "_" . $link['id'] . "' value='1'>";
$current_row->addCell($delete_one, $cell_value, $previous_cell);
}
}
}