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; }