static function showPluginFromItems($itemtype, $ID, $withtemplate = '') { global $DB, $CFG_GLPI; $item = new $itemtype(); $canread = $item->can($ID, READ); $canedit = $item->can($ID, UPDATE); $self = new self(); $query = "SELECT `glpi_plugin_positions_positions`.* " . "FROM `glpi_plugin_positions_positions` " . " LEFT JOIN `glpi_entities` ON (`glpi_entities`.`id` =\n `glpi_plugin_positions_positions`.`entities_id`) " . " WHERE `glpi_plugin_positions_positions`.`items_id` = '" . $ID . "'\n AND `glpi_plugin_positions_positions`.`itemtype` = '" . $itemtype . "' " . getEntitiesRestrictRequest(" AND ", "glpi_plugin_positions_positions", '', '', $self->maybeRecursive()); $query .= " ORDER BY `glpi_plugin_positions_positions`.`name` "; $result = $DB->query($query); $number = $DB->numrows($result); $colsup = 0; if (Session::isMultiEntitiesMode()) { $colsup = 1; } if ($number) { echo "<form method='post' action=\"" . $CFG_GLPI["root_doc"] . "/plugins/positions/front/position.form.php\" name='pointform' id='pointform'>"; echo "<div align='center'><table class='tab_cadre_fixe'>"; echo "<tr><th colspan='" . (4 + $colsup) . "'>" . __('Associated coordinate', 'positions') . ":</th></tr>"; echo "<tr><th>" . __('Name') . "</th>"; if (Session::isMultiEntitiesMode()) { echo "<th>" . __('Entity') . "</th>"; } echo "<th>" . __('Coordinate x', 'positions') . "</th>"; echo "<th>" . __('Coordinate y', 'positions') . "</th>"; if (Session::haveRight('plugin_positions', UPDATE)) { echo "<th> </th>"; } echo "</tr>"; $used = array(); while ($data = $DB->fetch_array($result)) { $positionsID = $data["id"]; $used[] = $positionsID; echo "<tr class='tab_bg_1" . ($data["is_deleted"] == '1' ? "_2" : "") . "'>"; if ($withtemplate != 3 && $canread && (in_array($data['entities_id'], $_SESSION['glpiactiveentities']) || $data["is_recursive"])) { echo "<td class='center'><a href='" . $CFG_GLPI["root_doc"] . "/plugins/positions/front/position.form.php?id=" . $data["id"] . "'>" . $data["name"]; if ($_SESSION["glpiis_ids_visible"] || empty($data["name"])) { echo " (" . $data["id"] . ")"; } echo "</a>"; echo self::showGeolocLink($itemtype, $ID, $data["id"]); echo "</td>"; } else { echo "<td class='center'>" . $data["name"]; if ($_SESSION["glpiis_ids_visible"]) { echo " (" . $data["id"] . ")"; } echo "</td>"; } if (Session::isMultiEntitiesMode()) { echo "<td class='center'>" . Dropdown::getDropdownName("glpi_entities", $data['entities_id']) . "</td>"; } echo "<td class='center'>" . $data["x_coordinates"] . "</td>"; echo "<td class='center'>" . $data["y_coordinates"] . "</td>"; if (Session::haveRight('plugin_positions', UPDATE) && $withtemplate < 2) { if ($data["is_deleted"] != 1) { echo "<td class='center tab_bg_2'>"; Html::showSimpleForm($CFG_GLPI['root_doc'] . '/plugins/positions/front/position.form.php', 'delete_item', _x('button', 'Delete permanently'), array('id' => $positionsID)); echo "</td>"; } else { echo "<td class='tab_bg_2 center'></td>"; } } echo "</tr>"; } echo "</table></div>"; Html::closeForm(); } else { self::showAddFromItem($itemtype, $ID); } }