public 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();
$table = getTableForItemType("PluginOrderOrder_Item");
$query = "SELECT * FROM `" . $table . "`";
$query .= " WHERE `plugin_order_bills_id` = '{$bills_id}'";
$query .= getEntitiesRestrictRequest(" AND", $table, "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>";
echo "<th>" . __("Type") . "</th>";
echo "<th>" . __("Entity") . "</th>";
echo "<th>" . __("Reference") . "</th>";
echo "<th>" . __("Status") . "</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"]);
echo "<td class='center'>";
if (PluginOrderReference::canView()) {
echo $reference->getLink();
} else {
echo $reference->getName(true);
}
echo "</td>";
echo "<td class='center'>";
Dropdown::getDropdownName("glpi_plugin_order_deliverystates", $data["plugin_order_deliverystates_id"]);
echo "</td>";
echo "</tr>";
}
}
}
echo "</table></div>";
}
public function showPluginFromItems($itemtype, $ID)
{
global $CFG_GLPI;
$infos = $this->getOrderInfosByItem($itemtype, $ID);
if ($infos) {
echo "<div class='center'>";
echo "<table class='tab_cadre_fixe'>";
echo "<tr align='center'><th colspan='2'>" . __("Order informations", "order") . "</th></tr>";
echo "<tr align='center'><td class='tab_bg_2'>" . __("Order name", "order") . "</td>";
echo "<td class='tab_bg_2'>";
$order = new PluginOrderOrder();
$order->getFromDB($infos['id']);
echo $order->getLink(PluginOrderOrder::canView());
$result = getAllDatasFromTable($this->getTable(), "`plugin_order_orders_id`='" . $infos['id'] . "'\n AND `itemtype`='{$itemtype}'\n AND `items_id`='{$ID}'");
if (!empty($result)) {
$link = array_shift($result);
$reference = new PluginOrderReference();
$reference->getFromDB($link['plugin_order_references_id']);
if (Session::haveRight('plugin_order_reference', READ)) {
echo "<tr align='center'><td class='tab_bg_2'>" . __("Reference") . "</td>";
echo "<td class='tab_bg_2'>" . $reference->getLink(PluginOrderReference::canView()) . "</td></tr>";
}
echo "<tr align='center'><td class='tab_bg_2'>" . __("Delivery date") . "</td>";
echo "<td class='tab_bg_2'>" . Html::convDate($link["delivery_date"]) . "</td></tr>";
}
echo "</table></div>";
}
}
