static function pdfForItem(PluginPdfSimplePDF $pdf, CommonDBTM $item) { global $DB, $CFG_GLPI; $ID = $item->getField('id'); $type = get_class($item); if (!Session::haveRight("reservation_central", "r")) { return; } $user = new User(); $ri = new ReservationItem(); $pdf->setColumnsSize(100); if ($ri->getFromDBbyItem($type, $ID)) { $now = $_SESSION["glpi_currenttime"]; $query = "SELECT *\n FROM `glpi_reservationitems`\n INNER JOIN `glpi_reservations`\n ON (`glpi_reservations`.`reservationitems_id` = `glpi_reservationitems`.`id`)\n WHERE `end` > '" . $now . "'\n AND `glpi_reservationitems`.`items_id` = '{$ID}'\n ORDER BY `begin`"; $result = $DB->query($query); $pdf->setColumnsSize(100); $pdf->displayTitle("<b>" . __('Current and future reservations') . "</b>"); if (!$DB->numrows($result)) { $pdf->displayLine("<b>" . __('No reservation') . "</b>"); } else { $pdf->setColumnsSize(14, 14, 26, 46); $pdf->displayTitle('<i>' . __('Start date'), __('End date'), __('By'), __('Comments') . '</i>'); while ($data = $DB->fetch_assoc($result)) { if ($user->getFromDB($data["users_id"])) { $name = formatUserName($user->fields["id"], $user->fields["name"], $user->fields["realname"], $user->fields["firstname"]); } else { $name = "(" . $data["users_id"] . ")"; } $pdf->displayLine(Html::convDateTime($data["begin"]), Html::convDateTime($data["end"]), $name, str_replace(array("\r", "\n"), " ", $data["comment"])); } } $query = "SELECT *\n FROM `glpi_reservationitems`\n INNER JOIN `glpi_reservations`\n ON (`glpi_reservations`.`reservationitems_id` = `glpi_reservationitems`.`id`)\n WHERE `end` <= '" . $now . "'\n AND `glpi_reservationitems`.`items_id` = '{$ID}'\n ORDER BY `begin`\n DESC"; $result = $DB->query($query); $pdf->setColumnsSize(100); $pdf->displayTitle("<b>" . __('Past reservations') . "</b>"); if (!$DB->numrows($result)) { $pdf->displayLine("<b>" . __('No reservation') . "</b>"); } else { $pdf->setColumnsSize(14, 14, 26, 46); $pdf->displayTitle('<i>' . __('Start date'), __('End date'), __('By'), __('Comments') . '</i>'); while ($data = $DB->fetch_assoc($result)) { if ($user->getFromDB($data["users_id"])) { $name = formatUserName($user->fields["id"], $user->fields["name"], $user->fields["realname"], $user->fields["firstname"]); } else { $name = "(" . $data["users_id"] . ")"; } $pdf->displayLine(Html::convDateTime($data["begin"]), Html::convDateTime($data["end"]), $name, str_replace(array("\r", "\n"), " ", $data["comment"])); } } } $pdf->displaySpace(); }
/** * Transfer reservations of an item * * @param $itemtype original type of transfered item * @param $ID original ID of the item * @param $newID new ID of the item **/ function transferReservations($itemtype, $ID, $newID) { global $DB; $ri = new ReservationItem(); if ($ri->getFromDBbyItem($itemtype, $ID)) { switch ($this->options['keep_reservation']) { // delete case 0: // Same item -> delete if ($ID == $newID) { $ri->delete(array('id' => $ri->fields['id'])); } // Copy : nothing to do break; // Keep // Keep default: // Copy : set item as reservable if ($ID != $newID) { $input['itemtype'] = $itemtype; $input['items_id'] = $newID; $input['is_active'] = $ri->fields['is_active']; unset($ri->fields); $ri->add($input); } // Same item -> nothing to do break; } } }
/** * to list infos in debug tab **/ function showDebugInfo() { global $CFG_GLPI; $class = $this->getType(); if (method_exists($class, 'showDebug')) { $this->showDebug(); } if (InfoCom::canApplyOn($class)) { $infocom = new Infocom(); if ($infocom->getFromDBforDevice($class, $this->fields['id'])) { $infocom->showDebug(); } } if (in_array($class, $CFG_GLPI["reservation_types"])) { $resitem = new ReservationItem(); if ($resitem->getFromDBbyItem($class, $this->fields['id'])) { $resitem->showDebugResa(); } } }
/** * Display reservations for an item * * @param $item CommonDBTM object for which the reservation tab need to be displayed * @param $withtemplate withtemplate param (default '') **/ static function showForItem(CommonDBTM $item, $withtemplate = '') { global $DB, $CFG_GLPI; $resaID = 0; if (!Session::haveRight("reservation", READ)) { return false; } echo "<div class='firstbloc'>"; ReservationItem::showActivationFormForItem($item); $ri = new ReservationItem(); if ($ri->getFromDBbyItem($item->getType(), $item->getID())) { $now = $_SESSION["glpi_currenttime"]; // Print reservation in progress $query = "SELECT *\n FROM `glpi_reservations`\n WHERE `end` > '" . $now . "'\n AND `reservationitems_id` = '" . $ri->fields['id'] . "'\n ORDER BY `begin`"; $result = $DB->query($query); echo "<table class='tab_cadre_fixehov'><tr><th colspan='5'>"; if ($ri->fields["is_active"]) { echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "'>" . __('Current and future reservations') . "</a>"; } else { _e('Current and future reservations'); } echo "</th></tr>\n"; if ($DB->numrows($result) == 0) { echo "<tr class='tab_bg_2'>"; echo "<td class='center' colspan='5'>" . __('No reservation') . "</td></tr>\n"; } else { echo "<tr><th>" . __('Start date') . "</th>"; echo "<th>" . __('End date') . "</th>"; echo "<th>" . __('By') . "</th>"; echo "<th>" . __('Comments') . "</th><th> </th></tr>\n"; while ($data = $DB->fetch_assoc($result)) { echo "<tr class='tab_bg_2'>"; echo "<td class='center'>" . Html::convDateTime($data["begin"]) . "</td>"; echo "<td class='center'>" . Html::convDateTime($data["end"]) . "</td>"; echo "<td class='center'>"; echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/user.form.php?id=" . $data["users_id"] . "'>" . getUserName($data["users_id"]) . "</a></td>"; echo "<td class='center'>" . nl2br($data["comment"]) . "</td>"; echo "<td class='center'>"; list($annee, $mois, $jour) = explode("-", $data["begin"]); echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "&mois_courant={$mois}&annee_courante={$annee}' title=\"" . __s('See planning') . "\">"; echo "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/reservation-3.png\" alt='' title=''>" . "</a>"; echo "</td></tr>\n"; } } echo "</table></div>\n"; // Print old reservations $query = "SELECT *\n FROM `glpi_reservations`\n WHERE `end` <= '" . $now . "'\n AND `reservationitems_id` = '" . $ri->fields['id'] . "'\n ORDER BY `begin` DESC"; $result = $DB->query($query); echo "<div class='spaced'><table class='tab_cadre_fixehov'><tr><th colspan='5'>"; if ($ri->fields["is_active"]) { echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "' >" . __('Past reservations') . "</a>"; } else { _e('Past reservations'); } echo "</th></tr>\n"; if ($DB->numrows($result) == 0) { echo "<tr class='tab_bg_2'>"; echo "<td class='center' colspan='5'>" . __('No reservation') . "</td></tr>\n"; } else { echo "<tr><th>" . __('Start date') . "</th>"; echo "<th>" . __('End date') . "</th>"; echo "<th>" . __('By') . "</th>"; echo "<th>" . __('Comments') . "</th><th> </th></tr>\n"; while ($data = $DB->fetch_assoc($result)) { echo "<tr class='tab_bg_2'>"; echo "<td class='center'>" . Html::convDateTime($data["begin"]) . "</td>"; echo "<td class='center'>" . Html::convDateTime($data["end"]) . "</td>"; echo "<td class='center'>"; echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/user.form.php?id=" . $data["users_id"] . "'>" . getUserName($data["users_id"]) . "</a></td>"; echo "<td class='center'>" . nl2br($data["comment"]) . "</td>"; echo "<td class='center'>"; list($annee, $mois, $jour) = explode("-", $data["begin"]); echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "&mois_courant={$mois}&annee_courante={$annee}' title=\"" . __s('See planning') . "\">"; echo "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/reservation-3.png\" alt='' title=''>"; echo "</a></td></tr>\n"; } } echo "</table>\n"; } echo "</div>\n"; }
/** * @param $type * @param $model_id * @param $tab_ids * @param $location **/ static function replace($type, $model_id, $tab_ids, $location) { global $DB, $CFG_GLPI, $PLUGIN_HOOKS; $model = new PluginUninstallModel(); $model->getConfig($model_id); $overwrite = $model->fields["overwrite"]; echo "<div class='center'>"; echo "<table class='tab_cadre_fixe'><tr><th>" . __('Replacement', 'uninstall') . "</th></tr>"; echo "<tr class='tab_bg_2'><td>"; $count = 0; $tot = count($tab_ids); Html::createProgressBar(__('Please wait, replacement is running...', 'uninstall')); foreach ($tab_ids as $olditem_id => $newitem_id) { $count++; $olditem = new $type(); $olditem->getFromDB($olditem_id); $newitem = new $type(); $newitem->getFromDB($newitem_id); //Hook to perform actions before item is being replaced $olditem->fields['_newid'] = $newitem_id; $olditem->fields['_uninstall_event'] = $model_id; $olditem->fields['_action'] = 'replace'; Plugin::doHook("plugin_uninstall_replace_before", $olditem); // Retrieve informations //States if ($model->fields['states_id'] != 0) { $olditem->update(array('id' => $olditem_id, 'states_id' => $model->fields['states_id']), false); } // METHOD REPLACEMENT 1 : Archive if ($model->fields['replace_method'] == self::METHOD_PURGE) { $name_out = str_shuffle(Toolbox::getRandomString(5) . time()); $plugin = new Plugin(); if ($plugin->isActivated('PDF')) { // USE PDF EXPORT $plugin->load('pdf', true); include_once GLPI_ROOT . "/lib/ezpdf/class.ezpdf.php"; //Get all item's tabs $tab = array_keys($olditem->defineTabs()); //Tell PDF to also export item's main tab, and in first position array_unshift($tab, "_main_"); $itempdf = new $PLUGIN_HOOKS['plugin_pdf'][$type]($olditem); $out = $itempdf->generatePDF(array($olditem_id), $tab, 1, false); $name_out .= ".pdf"; } else { //TODO Which datas ? Add Defaults... $out = __('Replacement', 'uninstall') . "\r\n"; $datas = $olditem->fields; unset($datas['comment']); foreach ($datas as $k => $v) { $out .= $k . ";"; } $out .= "\r\n"; foreach ($datas as $k => $v) { $out .= $v . ";"; } // USE CSV EXPORT $name_out .= ".csv"; } // Write document $out_file = GLPI_DOC_DIR . "/_uploads/" . $name_out; $open_file = fopen($out_file, 'a'); fwrite($open_file, $out); fclose($open_file); // Compute comment text $comment = __('This document is the archive of this replaced item', 'uninstall') . " " . self::getCommentsForReplacement($olditem, false, false); // Create & Attach new document to current item $doc = new Document(); $input = array('name' => addslashes(__('Archive of old material', 'uninstall')), 'upload_file' => $name_out, 'comment' => addslashes($comment), 'add' => __('Add'), 'entities_id' => $newitem->getEntityID(), 'is_recursive' => $newitem->isRecursive(), 'link' => "", 'documentcategories_id' => 0, 'items_id' => $olditem_id, 'itemtype' => $type); //Attached the document to the old item, to generate an accurate name $document_added = $doc->add($input); //Attach the document to the new item, once the document's name is correct $docItem = new Document_Item(); $docItemId = $docItem->add(array('documents_id' => $document_added, 'itemtype' => $type, 'items_id' => (int) $newitem_id)); } // General Informations - NAME if ($model->fields["replace_name"]) { if ($overwrite || empty($newitem->fields['name'])) { $newitem->update(array('id' => $newitem_id, 'name' => $olditem->getField('name')), false); } } $data['id'] = $newitem->getID(); // General Informations - SERIAL if ($model->fields["replace_serial"]) { if ($overwrite || empty($newitem->fields['serial'])) { $newitem->update(array('id' => $newitem_id, 'serial' => $olditem->getField('serial')), false); } } // General Informations - OTHERSERIAL if ($model->fields["replace_otherserial"]) { if ($overwrite || empty($newitem->fields['otherserial'])) { $newitem->update(array('id' => $newitem_id, 'otherserial' => $olditem->getField('otherserial')), false); } } // Documents if ($model->fields["replace_documents"] && in_array($type, $CFG_GLPI["document_types"])) { $doc_item = new Document_Item(); foreach (self::getAssociatedDocuments($olditem) as $document) { $doc_item->update(array('id' => $document['assocID'], 'itemtype' => $type, 'items_id' => $newitem_id), false); } } // Contracts if ($model->fields["replace_contracts"] && in_array($type, $CFG_GLPI["contract_types"])) { $contract_item = new Contract_Item(); foreach (self::getAssociatedContracts($olditem) as $contract) { $contract_item->update(array('id' => $contract['id'], 'itemtype' => $type, 'items_id' => $newitem_id), false); } } // Infocoms if ($model->fields["replace_infocoms"] && in_array($type, $CFG_GLPI["infocom_types"])) { $infocom = new Infocom(); if ($overwrite) { // Delete current Infocoms of new item if ($infocom->getFromDBforDevice($type, $newitem_id)) { //Do not log infocom deletion in the new item's history $infocom->dohistory = false; $infocom->deleteFromDB(1); } } // Update current Infocoms of old item if ($infocom->getFromDBforDevice($type, $olditem_id)) { $infocom->update(array('id' => $infocom->getID(), 'itemtype' => $type, 'items_id' => $newitem_id), false); } } // Reservations if ($model->fields["replace_reservations"] && in_array($type, $CFG_GLPI["reservation_types"])) { $resaitem = new ReservationItem(); if ($overwrite) { // Delete current reservation of new item $resa_new = new Reservation(); $resa_new->getFromDB($newitem_id); if ($resa_new->is_reserved()) { $resa_new = new ReservationItem(); $resa_new->getFromDBbyItem($type, $newitem_id); if (count($resa_new->fields)) { $resa_new->deleteFromDB(1); } } } // Update old reservation for attribute to new item $resa_old = new Reservation(); $resa_old->getFromDB($olditem_id); if ($resa_old->is_reserved()) { $resa_old = new ReservationItem(); $resa_old->getFromDBbyItem($type, $olditem_id); if (count($resa_old->fields)) { $resa_old->update(array('id' => $resa_old->getID(), 'itemtype' => $type, 'items_id' => $newitem_id), false); } } } // User if ($model->fields["replace_users"] && in_array($type, $CFG_GLPI["linkuser_types"])) { $data = array(); $data['id'] = $newitem->getID(); if ($newitem->isField('users_id') && ($overwrite || empty($data['users_id']))) { $data['users_id'] = $olditem->getField('users_id'); } if ($newitem->isField('contact') && ($overwrite || empty($data['contact']))) { $data['contact'] = $olditem->getField('contact'); } if ($newitem->isField('contact_num') && ($overwrite || empty($data['contact_num']))) { $data['contact_num'] = $olditem->getField('contact_num'); } $newitem->update($data, false); } // Group if ($model->fields["replace_groups"] && in_array($type, $CFG_GLPI["linkgroup_types"])) { if ($newitem->isField('groups_id') && ($overwrite || empty($data['groups_id']))) { $newitem->update(array('id' => $newitem_id, 'groups_id' => $olditem->getField('groups_id')), false); } } // Tickets if ($model->fields["replace_tickets"] && in_array($type, $CFG_GLPI["ticket_types"])) { $ticket_item = new Item_Ticket(); foreach (self::getAssociatedTickets($type, $olditem_id) as $ticket) { $ticket_item->update(array('id' => $ticket['id'], 'items_id' => $newitem_id), false); } } //Array netport_types renamed in networkport_types in GLPI 0.80 if (isset($CFG_GLPI["netport_types"])) { $netport_types = $CFG_GLPI["netport_types"]; } else { $netport_types = $CFG_GLPI["networkport_types"]; } // NetPorts if ($model->fields["replace_netports"] && in_array($type, $netport_types)) { $netport_item = new NetworkPort(); foreach (self::getAssociatedNetports($type, $olditem_id) as $netport) { $netport_item->update(array('id' => $netport['id'], 'itemtype' => $type, 'items_id' => $newitem_id), false); } } // Directs connections if ($model->fields["replace_direct_connections"] && in_array($type, array('Computer'))) { $comp_item = new Computer_Item(); foreach (self::getAssociatedItems($olditem) as $itemtype => $connections) { foreach ($connections as $connection) { $comp_item->update(array('id' => $connection['id'], 'computers_id' => $newitem_id, 'itemtype' => $itemtype), false); } } } // Location if ($location != 0 && $olditem->isField('locations_id')) { $olditem->getFromDB($olditem_id); switch ($location) { case -1: break; default: $olditem->update(array('id' => $olditem_id, 'locations_id' => $location), false); break; } } $plug = new Plugin(); if ($plug->isActivated('ocsinventoryng')) { //Delete computer from OCS if ($model->fields["remove_from_ocs"] == 1) { PluginUninstallUninstall::deleteComputerInOCSByGlpiID($olditem_id); } //Delete link in glpi_ocs_link if ($model->fields["delete_ocs_link"] || $model->fields["remove_from_ocs"]) { PluginUninstallUninstall::deleteOcsLink($olditem_id); } } if ($plug->isActivated('fusioninventory')) { if ($model->fields['raz_fusioninventory']) { PluginUninstallUninstall::deleteFusionInventoryLink(get_class($olditem), $olditem_id); } } // METHOD REPLACEMENT 1 : Purge if ($model->fields['replace_method'] == self::METHOD_PURGE) { // Retrieve, Compute && Update NEW comment field $comment = self::getCommentsForReplacement($olditem, true); $comment .= "\n- " . __('See attached document', 'uninstall'); $newitem->update(array('id' => $newitem_id, 'comment' => addslashes($comment)), false); // If old item is attached in PDF/CSV // Delete AND Purge it in DB if ($document_added) { $olditem->delete(array('id' => $olditem_id), true); } } // METHOD REPLACEMENT 2 : Delete AND Comment if ($model->fields['replace_method'] == self::METHOD_DELETE_AND_COMMENT) { //Add comment on the new item first $comment = self::getCommentsForReplacement($olditem, true); $newitem->update(array('id' => $newitem_id, 'comment' => Toolbox::addslashes_deep($comment)), false); // Retrieve, Compute && Update OLD comment field $comment = self::getCommentsForReplacement($newitem, false); $olditem->update(array('id' => $olditem_id, 'comment' => Toolbox::addslashes_deep($comment)), false); // Delete OLD item from DB (not PURGE) PluginUninstallUninstall::addUninstallLog($type, $olditem_id, 'replaced_by'); $olditem->delete(array('id' => $olditem_id), 0, false); } //Plugin hook after replacement Plugin::doHook("plugin_uninstall_replace_after", $olditem); //Add history PluginUninstallUninstall::addUninstallLog($type, $newitem_id, 'replace'); Html::changeProgressBarPosition($count, $tot + 1); } Html::changeProgressBarPosition($count, $tot, __('Replacement successful', 'uninstall')); echo "</td></tr>"; echo "</table></div>"; }
/** * Clean the date in the relation tables for the deleted item * Clear N/N Relation **/ function cleanRelationTable() { global $CFG_GLPI, $DB; // If this type have INFOCOM, clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['infocom_types'])) { $infocom = new Infocom(); if ($infocom->getFromDBforDevice($this->getType(), $this->fields['id'])) { $infocom->delete(array('id' => $infocom->fields['id'])); } } // If this type have NETPORT, clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['networkport_types'])) { $query = "SELECT `id`\n FROM `glpi_networkports`\n WHERE (`items_id` = '" . $this->fields['id'] . "'\n AND `itemtype` = '" . $this->getType() . "')"; $result = $DB->query($query); while ($data = $DB->fetch_array($result)) { $q = "DELETE\n FROM `glpi_networkports_networkports`\n WHERE (`networkports_id_1` = '" . $data["id"] . "'\n OR `networkports_id_2` = '" . $data["id"] . "')"; $result2 = $DB->query($q); } $query = "DELETE\n FROM `glpi_networkports`\n WHERE (`items_id` = '" . $this->fields['id'] . "'\n AND `itemtype` = '" . $this->getType() . "')"; $result = $DB->query($query); } // If this type is RESERVABLE clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['reservation_types'])) { $rr = new ReservationItem(); if ($rr->getFromDBbyItem($this->getType(), $this->fields['id'])) { $rr->delete(array('id' => $infocom->fields['id'])); } } // If this type have CONTRACT, clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['contract_types'])) { $ci = new Contract_Item(); $ci->cleanDBonItemDelete($this->getType(), $this->fields['id']); } // If this type have DOCUMENT, clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI["document_types"])) { $di = new Document_Item(); $di->cleanDBonItemDelete($this->getType(), $this->fields['id']); } }
/** * Clean the date in the relation tables for the deleted item * Clear N/N Relation **/ function cleanRelationTable() { global $CFG_GLPI, $DB; // If this type have INFOCOM, clean one associated to purged item if (Infocom::canApplyOn($this)) { $infocom = new Infocom(); if ($infocom->getFromDBforDevice($this->getType(), $this->fields['id'])) { $infocom->delete(array('id' => $infocom->fields['id'])); } } // If this type have NETPORT, clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['networkport_types'])) { // If we don't use delete, then cleanDBonPurge() is not call and the NetworkPorts are not // clean properly $networkPortObject = new NetworkPort(); $networkPortObject->cleanDBonItemDelete($this->getType(), $this->getID()); // Manage networkportmigration if exists if (TableExists('glpi_networkportmigrations')) { $networkPortMigObject = new NetworkPortMigration(); $networkPortMigObject->cleanDBonItemDelete($this->getType(), $this->getID()); } } // If this type is RESERVABLE clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['reservation_types'])) { $rr = new ReservationItem(); if ($rr->getFromDBbyItem($this->getType(), $this->fields['id'])) { $rr->delete(array('id' => $infocom->fields['id'])); } } // If this type have CONTRACT, clean one associated to purged item if (in_array($this->getType(), $CFG_GLPI['contract_types'])) { $ci = new Contract_Item(); $ci->cleanDBonItemDelete($this->getType(), $this->fields['id']); } // If this type have DOCUMENT, clean one associated to purged item if (Document::canApplyOn($this)) { $di = new Document_Item(); $di->cleanDBonItemDelete($this->getType(), $this->fields['id']); } // If this type have NOTEPAD, clean one associated to purged item if ($this->usenotepad) { $note = new Notepad(); $note->cleanDBonItemDelete($this->getType(), $this->fields['id']); } }
static function showActivationFormForItem($itemtype, $items_id) { global $CFG_GLPI, $LANG; if (!haveRight("reservation_central", "w")) { return false; } if (class_exists($itemtype)) { $item = new $itemtype(); if (!$item->getFromDB($items_id)) { return false; } // Recursive type case => need entity right if ($item->isRecursive()) { if (!haveAccessToEntity($item->fields["entities_id"])) { return false; } } } else { return false; } $ri = new ReservationItem(); echo "<div><form method='post' name=form action='" . getItemTypeFormURL('ReservationItem') . "'>"; echo "<table class='tab_cadre_fixe'>"; echo "<tr><th>" . $LANG['reservation'][9] . "</th></tr>"; echo "<tr class='tab_bg_1'>"; if ($ri->getFromDBbyItem($itemtype, $items_id)) { echo "<td class='center'>"; //Switch reservation state echo "<input type='hidden' name='id' value='" . $ri->fields['id'] . "'>"; if ($ri->fields["is_active"]) { echo "<input type='hidden' name='is_active' value='0'>"; echo "<input type='submit' name='update' value=\"" . $LANG['reservation'][3] . "\"\n class='submit'>"; } else { echo "<input type='hidden' name='is_active' value='1'>"; echo "<input type='submit' name='update' value=\"" . $LANG['reservation'][5] . "\"\n class='submit'>"; } echo "<span class='small_space'>"; echo "<input type='submit' name='delete' value=\"" . $LANG['reservation'][6] . "\"\n class='submit' " . addConfirmationOnAction(array($LANG['reservation'][38], $LANG['reservation'][39])) . ">"; echo "</span></td>"; } else { echo "<td class='center'>"; echo "<input type='hidden' name='items_id' value='{$items_id}'>"; echo "<input type='hidden' name='itemtype' value='{$itemtype}'>"; echo "<input type='hidden' name='entities_id' value='" . $item->getEntityID() . "'>"; echo "<input type='hidden' name='is_recursive' value='" . $item->isRecursive() . "'>"; echo "<input type='submit' name='add' value=\"" . $LANG['reservation'][7] . "\" class='submit'>"; echo "</td>"; } echo "</tr></table></form></div>"; }
/** * Display reservations for an item * * @param $ID ID a the item * @param $itemtype item type **/ static function showForItem($itemtype, $ID) { global $DB, $LANG, $CFG_GLPI; $resaID = 0; if (!haveRight("reservation_central", "r")) { return false; } echo "<div class='firstbloc'>"; ReservationItem::showActivationFormForItem($itemtype, $ID); $ri = new ReservationItem(); if ($ri->getFromDBbyItem($itemtype, $ID)) { $now = $_SESSION["glpi_currenttime"]; // Print reservation in progress $query = "SELECT *\n FROM `glpi_reservations`\n WHERE `end` > '{$now}'\n AND `reservationitems_id` = '" . $ri->fields['id'] . "'\n ORDER BY `begin`"; $result = $DB->query($query); echo "<table class='tab_cadre_fixehov'><tr><th colspan='5'>"; if ($ri->fields["is_active"]) { echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "' >" . $LANG['reservation'][35] . "</a>"; } else { echo $LANG['reservation'][35]; } echo "</th></tr>\n"; if ($DB->numrows($result) == 0) { echo "<tr class='tab_bg_2'>"; echo "<td class='center' colspan='5'>" . $LANG['reservation'][37] . "</td></tr>\n"; } else { echo "<tr><th>" . $LANG['search'][8] . "</th>"; echo "<th>" . $LANG['search'][9] . "</th>"; echo "<th>" . $LANG['common'][95] . "</th>"; echo "<th>" . $LANG['common'][25] . "</th><th> </th></tr>\n"; while ($data = $DB->fetch_assoc($result)) { echo "<tr class='tab_bg_2'>"; echo "<td class='center'>" . convDateTime($data["begin"]) . "</td>"; echo "<td class='center'>" . convDateTime($data["end"]) . "</td>"; echo "<td class='center'>"; echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/user.form.php?id=" . $data["users_id"] . "'>" . getUserName($data["users_id"]) . "</a></td>"; echo "<td class='center'>" . nl2br($data["comment"]) . "</td>"; echo "<td class='center'>"; list($annee, $mois, $jour) = explode("-", $data["begin"]); echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "&mois_courant={$mois}&annee_courante={$annee}' title=\"" . $LANG['reservation'][21] . "\">"; echo "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/reservation-3.png\" alt='' title=''></a>"; echo "</td></tr>\n"; } } echo "</table></div>\n"; // Print old reservations $query = "SELECT *\n FROM `glpi_reservations`\n WHERE `end` <= '{$now}'\n AND `reservationitems_id` = '" . $ri->fields['id'] . "'\n ORDER BY `begin` DESC"; $result = $DB->query($query); echo "<div class='spaced'><table class='tab_cadre_fixehov'><tr><th colspan='5'>"; if ($ri->fields["is_active"]) { echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "' >" . $LANG['reservation'][36] . "</a>"; } else { echo $LANG['reservation'][36]; } echo "</th></tr>\n"; if ($DB->numrows($result) == 0) { echo "<tr class='tab_bg_2'>"; echo "<td class='center' colspan='5'>" . $LANG['reservation'][37] . "</td></tr>\n"; } else { echo "<tr><th>" . $LANG['search'][8] . "</th>"; echo "<th>" . $LANG['search'][9] . "</th>"; echo "<th>" . $LANG['common'][95] . "</th>"; echo "<th>" . $LANG['common'][25] . "</th><th> </th></tr>\n"; while ($data = $DB->fetch_assoc($result)) { echo "<tr class='tab_bg_2'>"; echo "<td class='center'>" . convDateTime($data["begin"]) . "</td>"; echo "<td class='center'>" . convDateTime($data["end"]) . "</td>"; echo "<td class='center'>"; echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/user.form.php?id=" . $data["users_id"] . "'>" . getUserName($data["users_id"]) . "</a></td>"; echo "<td class='center'>" . nl2br($data["comment"]) . "</td>"; echo "<td class='center'>"; list($annee, $mois, $jour) = explode("-", $data["begin"]); echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/reservation.php?reservationitems_id=" . $ri->fields['id'] . "&mois_courant={$mois}&annee_courante={$annee}' title=\"" . $LANG['reservation'][21] . "\">"; echo "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/reservation-3.png\" alt='' title=''>"; echo "</a></td></tr>\n"; } } echo "</table>\n"; } echo "</div>\n"; }