static function showItems(PluginOrderBill $bill) { global $DB; echo "<div class='spaced'><table class='tab_cadre_fixehov'>"; echo "<tr><th>"; Html::printPagerForm(); echo "</th><th colspan='5'>"; echo _n("Item", "Items", 2); echo "</th></tr>"; $bills_id = $bill->getID(); $query = "SELECT * FROM `" . getTableForItemType("PluginOrderOrder_Item"); $query .= "` WHERE `plugin_order_bills_id` = '{$bills_id}'"; $query .= getEntitiesRestrictRequest(" AND", getTableForItemType("PluginOrderOrder_Item"), "entities_id", $bill->getEntityID(), true); $query .= "GROUP BY `itemtype`"; $result = $DB->query($query); $number = $DB->numrows($result); if (!$number) { echo "</th><td>"; echo _n("Item", "Items", 2); echo "</td></tr>"; } else { echo "<tr><th>" . __("Type") . "</th>"; echo "<th>" . __("Entity") . "</th>"; echo "<th>" . __("Reference") . "</th>"; echo "<th>" . __("Status") . "</th>"; //echo "<th>".__("Sum tax free", "order")."</th>"; echo "</tr>"; $old_itemtype = ''; $num = 0; while ($data = $DB->fetch_array($result)) { if (!class_exists($data['itemtype'])) { continue; } $item = new $data['itemtype'](); if ($data['itemtype']::canView()) { echo "<tr class='tab_bg_1'>"; $ID = ""; if ($_SESSION["glpiis_ids_visible"] || empty($data["name"])) { $ID = " (" . $data["id"] . ")"; } $name = NOT_AVAILABLE; if ($item->getFromDB($data["id"])) { $name = $item->getLink(); } echo "<td class='center top'>" . $item->getTypeName() . "</td>"; echo "<td class='center top'>"; echo Dropdown::getDropdownName('glpi_entities', $item->getEntityID()) . "</td>"; $reference = new PluginOrderReference(); $reference->getFromDB($data["plugin_order_references_id"]); if (PluginOrderReference::canView()) { echo "<td class='center'><a href='" . $reference->getLinkURL() . "'>"; echo $reference->getName() . "</a></td>"; } else { echo "<td class='center'>" . $reference->getName(true) . "</td>"; } echo "</td>"; echo "<td class='center'>" . Dropdown::getDropdownName("glpi_plugin_order_deliverystates", $data["plugin_order_deliverystates_id"]); echo "</tr>"; } } } echo "</table></div>"; }