public function showForm($ID, $options = array())
{
$this->initForm($ID, $options);
$this->showFormHeader($options);
$order_order = new PluginOrderOrder();
$order_order->getFromDB($this->fields['plugin_order_orders_id']);
$order_reference = new PluginOrderReference();
$order_reference->getFromDB($this->fields["plugin_order_references_id"]);
$canedit = $order_order->can($this->fields['plugin_order_orders_id'], UPDATE) && $order_order->canUpdateOrder() && !$order_order->isCanceled();
$canedit_comment = $order_order->can($this->fields['plugin_order_orders_id'], UPDATE) && !$order_order->isCanceled();
echo "<input type='hidden' name='plugin_order_orders_id' value='" . $this->fields['plugin_order_orders_id'] . "'>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Order", "order") . ": </td>";
echo "<td>";
echo $order_order->getLink(true);
echo "</td>";
echo "<td>" . __("Reference") . ": </td>";
echo "<td>";
$data = array();
$data["id"] = $this->fields["plugin_order_references_id"];
$data["name"] = $order_reference->fields["name"];
echo $order_reference->getReceptionReferenceLink($data);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Unit price tax free", "order") . ": </td>";
if ($canedit) {
echo "<td><input type='number' step='" . PLUGIN_ORDER_NUMBER_STEP . "' name='price_taxfree' value='" . $this->fields['price_taxfree'] . "' class='decimal'>";
} else {
echo "<td>" . Html::formatNumber($this->fields['price_taxfree']) . "</td>";
}
echo "<td>" . __("VAT", "order") . ": </td>";
echo "<td>";
if ($canedit) {
PluginOrderOrderTax::Dropdown(array('value' => $this->fields['plugin_order_ordertaxes_id']));
} else {
echo Dropdown::getDropdownName('glpi_plugin_order_ordertaxes', $this->fields['plugin_order_ordertaxes_id']);
}
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Discount (%)", "order") . ": </td>";
if ($canedit) {
echo "<td><input type='number' step='" . PLUGIN_ORDER_NUMBER_STEP . "' name='discount' \n value='" . $this->fields['discount'] . "' class='decimal'>";
} else {
echo "<td>" . Html::formatNumber($this->fields['discount']) . "</td>";
}
echo "<td>" . __("Discounted price tax free", "order") . ": </td>";
echo "<td>" . Html::formatNumber($this->fields['price_discounted']) . "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Price ATI", "order") . ": </td>";
echo "<td>" . Html::formatNumber($this->fields['price_ati']) . "</td>";
echo "<td>" . __("Status") . ": </td>";
echo "<td>";
echo Dropdown::getDropdownName('glpi_plugin_order_deliverystates', $this->fields['plugin_order_deliverystates_id']);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'><td>";
//comments of order
echo __("Description") . ": </td>";
echo "<td colspan='3'>";
if ($canedit_comment) {
echo "<textarea cols='50' rows='4' name='comment'>" . $this->fields["comment"] . "</textarea>";
} else {
echo $this->fields['comment'];
}
echo "</td></tr>";
$this->showFormButtons(array('canedit' => $canedit || $canedit_comment, 'candel' => $canedit));
return true;
}
public function showOrders($ref)
{
global $DB;
$order = new PluginOrderOrder();
$query = "SELECT `glpi_plugin_order_orders_items`.*\n FROM `glpi_plugin_order_orders_items`\n LEFT JOIN `glpi_plugin_order_references`\n ON (`glpi_plugin_order_references`.`id` = `glpi_plugin_order_orders_items`.`plugin_order_references_id`)\n WHERE `plugin_order_references_id` = '" . $ref->getID() . "'";
$query .= getEntitiesRestrictRequest(" AND ", "glpi_plugin_order_references", "entities_id", $ref->fields["entities_id"], true);
$query .= " GROUP BY `glpi_plugin_order_orders_items`.`plugin_order_orders_id`\n ORDER BY `entities_id`, `name` ";
$result = $DB->query($query);
$nb = $DB->numrows($result);
echo "<div class='center'>";
if ($nb) {
if (isset($_REQUEST["start"])) {
$start = $_REQUEST["start"];
} else {
$start = 0;
}
$query_limit = $query . " LIMIT " . intval($start) . "," . intval($_SESSION['glpilist_limit']);
Html::printAjaxPager(__("Linked orders", "order"), $start, $nb);
echo "<table class='tab_cadre_fixe'>";
echo "<tr>";
echo "<th>" . __("Name") . "</a></th>";
echo "<th>" . __("Entity") . "</th>";
echo "</tr>";
foreach ($DB->request($query_limit) as $data) {
echo "<tr class='tab_bg_1' align='center'>";
echo "<td>";
$order->getFromDB($data['plugin_order_orders_id']);
echo $order->getLink(PluginOrderOrder::canView());
echo "</td>";
echo "<td>";
echo Dropdown::getDropdownName("glpi_entities", $order->fields["entities_id"]);
echo "</td>";
echo "</tr>";
}
echo "</table>";
} else {
echo "<table class='tab_cadre_fixe'>";
echo "<tr class='tab_bg_1'><td class='center'>" . __("No item to display") . "</td></tr>";
echo "</table>";
}
echo "</div>";
}
function showForm($ID, $options = array())
{
if (!self::canView()) {
return false;
}
if ($ID > 0) {
$this->check($ID, 'r');
} else {
// Create item
$this->check(-1, 'w', $options);
}
$this->showTabs($options);
$this->showFormHeader($options);
$order_order = new PluginOrderOrder();
$order_order->getFromDB($this->fields['plugin_order_orders_id']);
$order_reference = new PluginOrderReference();
$order_reference->getFromDB($this->fields["plugin_order_references_id"]);
$canedit = $order_order->can($this->fields['plugin_order_orders_id'], 'w') && $order_order->canUpdateOrder() && !$order_order->isCanceled();
$canedit_comment = $order_order->can($this->fields['plugin_order_orders_id'], 'w') && !$order_order->isCanceled();
echo "<input type='hidden' name='plugin_order_orders_id' value='" . $this->fields['plugin_order_orders_id'] . "'>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Order", "order") . ": </td>";
echo "<td>";
echo $order_order->getLink(true);
echo "</td>";
echo "<td>" . __("Reference") . ": </td>";
echo "<td>";
$data = array();
$data["id"] = $this->fields["plugin_order_references_id"];
$data["name"] = $order_reference->fields["name"];
echo $order_reference->getReceptionReferenceLink($data);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Unit price tax free", "order") . ": </td>";
if ($canedit) {
echo "<td><input type='text' name='price_taxfree' value='" . $this->fields['price_taxfree'] . "'>";
} else {
echo "<td>" . Html::formatNumber($this->fields['price_taxfree']) . "</td>";
}
echo "<td>" . __("VAT", "order") . ": </td>";
echo "<td>";
if ($canedit) {
PluginOrderOrderTaxe::Dropdown(array('value' => $this->fields['plugin_order_ordertaxes_id']));
} else {
echo Dropdown::getDropdownName('glpi_plugin_order_ordertaxes', $this->fields['plugin_order_ordertaxes_id']);
}
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Discount (%)", "order") . ": </td>";
if ($canedit) {
echo "<td><input type='text' name='discount' value='" . $this->fields['discount'] . "'>";
} else {
echo "<td>" . Html::formatNumber($this->fields['discount']) . "</td>";
}
echo "<td>" . __("Discounted price tax free", "order") . ": </td>";
echo "<td>" . Html::formatNumber($this->fields['price_discounted']) . "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __("Price ATI", "order") . ": </td>";
echo "<td>" . Html::formatNumber($this->fields['price_ati']) . "</td>";
echo "<td>" . __("Status") . ": </td>";
echo "<td>";
echo Dropdown::getDropdownName('glpi_plugin_order_deliverystates', $this->fields['plugin_order_deliverystates_id']);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'><td>";
//comments of order
echo __("Description") . ": </td>";
echo "<td colspan='3'>";
if ($canedit_comment) {
echo "<textarea cols='50' rows='4' name='comment'>" . $this->fields["comment"] . "</textarea>";
} else {
echo $this->fields['comment'];
}
echo "</td></tr>";
$this->showFormButtons(array('canedit' => $canedit || $canedit_comment, 'candel' => $canedit));
$this->addDivForTabs();
return true;
}
