/**
* Display a reservation
*
* @param $ID ID a the reservation item
* @param $date date to display
**/
static function displayReservationsForAnItem($ID, $date)
{
global $DB;
$users_id = Session::getLoginUserID();
$resa = new self();
$user = new User();
list($year, $month, $day) = explode("-", $date);
$debut = $date . " 00:00:00";
$fin = $date . " 23:59:59";
$query = "SELECT *\n FROM `glpi_reservations`\n WHERE '" . $debut . "' < `end`\n AND '" . $fin . "' > `begin`\n AND `reservationitems_id` = '{$ID}'\n ORDER BY `begin`";
if ($result = $DB->query($query)) {
if ($DB->numrows($result) > 0) {
echo "<table width='100%'>";
while ($row = $DB->fetch_assoc($result)) {
echo "<tr>";
$user->getFromDB($row["users_id"]);
$display = "";
if ($debut > $row['begin']) {
$heure_debut = "00:00";
} else {
$heure_debut = get_hour_from_sql($row['begin']);
}
if ($fin < $row['end']) {
$heure_fin = "24:00";
} else {
$heure_fin = get_hour_from_sql($row['end']);
}
if (strcmp($heure_debut, "00:00") == 0 && strcmp($heure_fin, "24:00") == 0) {
$display = __('Day');
} else {
if (strcmp($heure_debut, "00:00") == 0) {
$display = sprintf(__('To %s'), $heure_fin);
} else {
if (strcmp($heure_fin, "24:00") == 0) {
$display = sprintf(__('From %s'), $heure_debut);
} else {
$display = $heure_debut . "-" . $heure_fin;
}
}
}
$rand = mt_rand();
$modif = $modif_end = "";
if ($resa->canEdit($row['id'])) {
$modif = "<a id='content_" . $ID . $rand . "'\n href='reservation.form.php?id=" . $row['id'] . "'>";
$modif_end = "</a>";
$modif_end .= Html::showToolTip($row["comment"], array('applyto' => "content_" . $ID . $rand, 'display' => false));
}
echo "<td class='tab_resa center'>" . $modif . "<span>" . $display . "<br><span class='b'>" . formatUserName($user->fields["id"], $user->fields["name"], $user->fields["realname"], $user->fields["firstname"]);
echo "</span></span>";
echo $modif_end;
echo "</td></tr>\n";
}
echo "</table>\n";
}
}
}
/**
* Show Licenses of a software
*
* @param $software Software object
*
* @return nothing
**/
static function showForSoftware(Software $software)
{
global $DB, $CFG_GLPI;
$softwares_id = $software->getField('id');
$license = new self();
$computer = new Computer();
if (!$software->can($softwares_id, READ)) {
return false;
}
$columns = array('name' => __('Name'), 'entity' => __('Entity'), 'serial' => __('Serial number'), 'number' => _x('quantity', 'Number'), '_affected' => __('Affected computers'), 'typename' => __('Type'), 'buyname' => __('Purchase version'), 'usename' => __('Version in use'), 'expire' => __('Expiration'));
if (!$software->isRecursive()) {
unset($columns['entity']);
}
if (isset($_GET["start"])) {
$start = $_GET["start"];
} else {
$start = 0;
}
if (isset($_GET["order"]) && $_GET["order"] == "DESC") {
$order = "DESC";
} else {
$order = "ASC";
}
if (isset($_GET["sort"]) && !empty($_GET["sort"]) && isset($columns[$_GET["sort"]])) {
$sort = "`" . $_GET["sort"] . "`";
} else {
$sort = "`entity` {$order}, `name`";
}
// Righ type is enough. Can add a License on a software we have Read access
$canedit = Software::canUpdate();
$showmassiveactions = $canedit;
// Total Number of events
$number = countElementsInTable("glpi_softwarelicenses", "glpi_softwarelicenses.softwares_id = {$softwares_id} " . getEntitiesRestrictRequest('AND', 'glpi_softwarelicenses', '', '', true));
echo "<div class='spaced'>";
Session::initNavigateListItems('SoftwareLicense', sprintf(__('%1$s = %2$s'), Software::getTypeName(1), $software->getName()));
if ($canedit) {
echo "<div class='center firstbloc'>";
echo "<a class='vsubmit' href='softwarelicense.form.php?softwares_id={$softwares_id}'>" . _x('button', 'Add a license') . "</a>";
echo "</div>";
}
$rand = mt_rand();
$query = "SELECT `glpi_softwarelicenses`.*,\n `buyvers`.`name` AS buyname,\n `usevers`.`name` AS usename,\n `glpi_entities`.`completename` AS entity,\n `glpi_softwarelicensetypes`.`name` AS typename\n FROM `glpi_softwarelicenses`\n LEFT JOIN `glpi_softwareversions` AS buyvers\n ON (`buyvers`.`id` = `glpi_softwarelicenses`.`softwareversions_id_buy`)\n LEFT JOIN `glpi_softwareversions` AS usevers\n ON (`usevers`.`id` = `glpi_softwarelicenses`.`softwareversions_id_use`)\n LEFT JOIN `glpi_entities`\n ON (`glpi_entities`.`id` = `glpi_softwarelicenses`.`entities_id`)\n LEFT JOIN `glpi_softwarelicensetypes`\n ON (`glpi_softwarelicensetypes`.`id`\n = `glpi_softwarelicenses`.`softwarelicensetypes_id`)\n WHERE (`glpi_softwarelicenses`.`softwares_id` = '{$softwares_id}') " . getEntitiesRestrictRequest('AND', 'glpi_softwarelicenses', '', '', true) . "\n ORDER BY {$sort} {$order}\n LIMIT " . intval($start) . "," . intval($_SESSION['glpilist_limit']);
if ($result = $DB->query($query)) {
if ($num_displayed = $DB->numrows($result)) {
// Display the pager
Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, $number);
if ($showmassiveactions) {
Html::openMassiveActionsForm('mass' . __CLASS__ . $rand);
$massiveactionparams = array('num_displayed' => $num_displayed, 'container' => 'mass' . __CLASS__ . $rand, 'extraparams' => array('options' => array('glpi_softwareversions.name' => array('condition' => "`glpi_softwareversions`.`softwares_id`\n = {$softwares_id}"), 'glpi_softwarelicenses.name' => array('itemlink_as_string' => true))));
Html::showMassiveActions($massiveactionparams);
}
$sort_img = "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/" . ($order == "DESC" ? "puce-down.png" : "puce-up.png") . "\" alt='' title=''>";
$sort_img = "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/" . ($order == "DESC" ? "puce-down.png" : "puce-up.png") . "\" alt='' title=''>";
echo "<table class='tab_cadre_fixehov'>";
$header_begin = "<tr><th>";
$header_top = Html::getCheckAllAsCheckbox('mass' . __CLASS__ . $rand);
$header_bottom = Html::getCheckAllAsCheckbox('mass' . __CLASS__ . $rand);
$header_end = '';
foreach ($columns as $key => $val) {
// Non order column
if ($key[0] == '_') {
$header_end .= "<th>{$val}</th>";
} else {
$header_end .= "<th>" . ($sort == "`{$key}`" ? $sort_img : "") . "<a href='javascript:reloadTab(\"sort={$key}&order=" . ($order == "ASC" ? "DESC" : "ASC") . "&start=0\");'>{$val}</a></th>";
}
}
$header_end .= "</tr>\n";
echo $header_begin . $header_top . $header_end;
$tot_assoc = 0;
for ($tot = 0; $data = $DB->fetch_assoc($result);) {
Session::addToNavigateListItems('SoftwareLicense', $data['id']);
$expired = true;
if (is_null($data['expire']) || $data['expire'] > date('Y-m-d')) {
$expired = false;
}
echo "<tr class='tab_bg_2" . ($expired ? '_2' : '') . "'>";
if ($license->canEdit($data['id'])) {
echo "<td>" . Html::getMassiveActionCheckBox(__CLASS__, $data["id"]) . "</td>";
} else {
echo "<td> </td>";
}
echo "<td><a href='softwarelicense.form.php?id=" . $data['id'] . "'>" . $data['name'] . (empty($data['name']) ? "(" . $data['id'] . ")" : "") . "</a></td>";
if (isset($columns['entity'])) {
echo "<td>";
echo $data['entity'];
echo "</td>";
}
echo "<td>" . $data['serial'] . "</td>";
echo "<td class='numeric'>" . ($data['number'] > 0 ? $data['number'] : __('Unlimited')) . "</td>";
$nb_assoc = Computer_SoftwareLicense::countForLicense($data['id']);
$tot_assoc += $nb_assoc;
$color = $data['is_valid'] ? 'green' : 'red';
echo "<td class='numeric {$color}'>" . $nb_assoc . "</td>";
echo "<td>" . $data['typename'] . "</td>";
echo "<td>" . $data['buyname'] . "</td>";
echo "<td>" . $data['usename'] . "</td>";
echo "<td class='center'>" . Html::convDate($data['expire']) . "</td>";
echo "</tr>";
if ($data['number'] < 0) {
// One illimited license, total is illimited
$tot = -1;
} else {
if ($tot >= 0) {
// Expire license not count
if (!$expired) {
// Not illimited, add the current number
$tot += $data['number'];
}
}
}
}
echo "<tr class='tab_bg_1 noHover'>";
echo "<td colspan='" . ($software->isRecursive() ? 4 : 3) . "' class='right b'>" . __('Total') . "</td>";
echo "<td class='numeric'>" . ($tot > 0 ? $tot . "" : __('Unlimited')) . "</td>";
$color = $software->fields['is_valid'] ? 'green' : 'red';
echo "<td class='numeric {$color}'>" . $tot_assoc . "</td><td></td><td></td><td></td><td></td>";
echo "</tr>";
echo "</table>\n";
if ($showmassiveactions) {
$massiveactionparams['ontop'] = false;
Html::showMassiveActions($massiveactionparams);
Html::closeForm();
}
Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, $number);
} else {
echo "<table class='tab_cadre_fixe'><tr><th>" . __('No item found') . "</th></tr></table>";
}
}
echo "</div>";
}
/**
* Show Infocom form for an item (not a standard showForm)
*
* @param $item CommonDBTM object
* @param $withtemplate integer template or basic item (default '')
**/
static function showForItem(CommonDBTM $item, $withtemplate = '')
{
global $CFG_GLPI;
// Show Infocom or blank form
if (!self::canView()) {
return false;
}
if (!$item) {
echo "<div class='spaced'>" . __('Requested item not found') . "</div>";
} else {
$date_tax = $CFG_GLPI["date_tax"];
$dev_ID = $item->getField('id');
$ic = new self();
$option = "";
if ($withtemplate == 2) {
$option = " readonly ";
}
if (!strpos($_SERVER['PHP_SELF'], "infocoms-show") && in_array($item->getType(), array('CartridgeItem', 'ConsumableItem', 'Software'))) {
echo "<div class='firstbloc center'>" . __('For this type of item, the financial and administrative information are only a model for the items which you should add.') . "</div>";
}
if (!$ic->getFromDBforDevice($item->getType(), $dev_ID)) {
$input = array('itemtype' => $item->getType(), 'items_id' => $dev_ID, 'entities_id' => $item->getEntityID());
if ($ic->can(-1, CREATE, $input) && $withtemplate != 2) {
echo "<div class='spaced b'>";
echo "<table class='tab_cadre_fixe'><tr class='tab_bg_1'><th>";
echo sprintf(__('%1$s - %2$s'), $item->getTypeName(1), $item->getName()) . "</th></tr>";
echo "<tr class='tab_bg_1'><td class='center'>";
Html::showSimpleForm($CFG_GLPI["root_doc"] . "/front/infocom.form.php", 'add', __('Enable the financial and administrative information'), array('itemtype' => $item->getType(), 'items_id' => $dev_ID));
echo "</td></tr></table></div>";
}
} else {
// getFromDBforDevice
$canedit = $ic->canEdit($ic->fields['id']) && $withtemplate != 2;
echo "<div class='spaced'>";
if ($canedit) {
echo "<form name='form_ic' method='post' action='" . $CFG_GLPI["root_doc"] . "/front/infocom.form.php'>";
}
echo "<table class='tab_cadre" . (!strpos($_SERVER['PHP_SELF'], "infocoms-show") ? "_fixe" : "") . "'>";
echo "<tr><th colspan='4'>" . __('Financial and administrative information') . "</th></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Supplier') . "</td>";
echo "<td>";
if ($withtemplate == 2) {
echo Dropdown::getDropdownName("glpi_suppliers", $ic->fields["suppliers_id"]);
} else {
Supplier::dropdown(array('value' => $ic->fields["suppliers_id"], 'entity' => $item->getEntityID(), 'width' => '70%'));
}
echo "</td>";
if (Budget::canView()) {
echo "<td>" . __('Budget') . "</td><td >";
Budget::dropdown(array('value' => $ic->fields["budgets_id"], 'entity' => $item->getEntityID(), 'comments' => 1));
} else {
echo "<td colspan='2'>";
}
echo "</td></tr>";
// Can edit calendar ?
$editcalendar = $withtemplate != 2;
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Order number') . "</td>";
echo "<td >";
Html::autocompletionTextField($ic, "order_number", array('option' => $option));
echo "</td>";
echo "<td>" . __('Order date') . "</td><td>";
Html::showDateField("order_date", array('value' => $ic->fields["order_date"], 'maybeempty' => true, 'canedit' => $editcalendar));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
$istemplate = '';
if ($item->isTemplate() || in_array($item->getType(), array('CartridgeItem', 'ConsumableItem', 'Software'))) {
$istemplate = '*';
}
echo "<td>" . sprintf(__('%1$s%2$s'), __('Immobilization number'), $istemplate) . "</td>";
echo "<td>";
$objectName = autoName($ic->fields["immo_number"], "immo_number", $withtemplate == 2, 'Infocom', $item->getEntityID());
Html::autocompletionTextField($ic, "immo_number", array('value' => $objectName, 'option' => $option));
echo "</td>";
echo "<td>" . __('Date of purchase') . "</td><td>";
Html::showDateField("buy_date", array('value' => $ic->fields["buy_date"], 'maybeempty' => true, 'canedit' => $editcalendar));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Invoice number') . "</td>";
echo "<td>";
Html::autocompletionTextField($ic, "bill", array('option' => $option));
echo "</td>";
echo "<td>" . __('Delivery date') . "</td><td>";
Html::showDateField("delivery_date", array('value' => $ic->fields["delivery_date"], 'maybeempty' => true, 'canedit' => $editcalendar));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Delivery form') . "</td><td>";
Html::autocompletionTextField($ic, "delivery_number", array('option' => $option));
echo "</td>";
echo "<td>" . __('Startup date') . "</td><td>";
Html::showDateField("use_date", array('value' => $ic->fields["use_date"], 'maybeempty' => true, 'canedit' => $editcalendar));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . _x('price', 'Value') . "</td>";
echo "<td><input type='text' name='value' {$option} value='" . Html::formatNumber($ic->fields["value"], true) . "' size='14'></td>";
echo "<td>" . __('Date of last physical inventory') . "</td><td>";
Html::showDateField("inventory_date", array('value' => $ic->fields["inventory_date"], 'maybeempty' => true, 'canedit' => $editcalendar));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Warranty extension value') . "</td>";
echo "<td><input type='text' {$option} name='warranty_value' value='" . Html::formatNumber($ic->fields["warranty_value"], true) . "' size='14'></td>";
echo "<td rowspan='5'>" . __('Comments') . "</td>";
echo "<td rowspan='5' class='middle'>";
echo "<textarea cols='45' rows='9' name='comment' >" . $ic->fields["comment"];
echo "</textarea></td></tr>\n";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Account net value') . "</td><td>";
echo Html::formatNumber(self::Amort($ic->fields["sink_type"], $ic->fields["value"], $ic->fields["sink_time"], $ic->fields["sink_coeff"], $ic->fields["warranty_date"], $ic->fields["use_date"], $date_tax, "n"));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Amortization type') . "</td><td >";
if ($withtemplate == 2) {
echo self::getAmortTypeName($ic->fields["sink_type"]);
} else {
self::dropdownAmortType("sink_type", $ic->fields["sink_type"]);
}
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Amortization duration') . "</td><td>";
if ($withtemplate == 2) {
printf(_n('%d year', '%d years', $ic->fields["sink_time"]), $ic->fields["sink_time"]);
} else {
Dropdown::showNumber("sink_time", array('value' => $ic->fields["sink_time"], 'max' => 15, 'unit' => 'year'));
}
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Amortization coefficient') . "</td>";
echo "<td>";
Html::autocompletionTextField($ic, "sink_coeff", array('size' => 14, 'option' => $option));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
if (!in_array($item->getType(), array('Cartridge', 'CartridgeItem', 'Consumable', 'ConsumableItem', 'Software', 'SoftwareLicense'))) {
echo "<td>" . __('TCO (value + tracking cost)') . "</td><td>";
echo self::showTco($item->getField('ticket_tco'), $ic->fields["value"]);
} else {
echo "<td colspan='2'>";
}
echo "</td>";
if (!in_array($item->getType(), array('Cartridge', 'CartridgeItem', 'Consumable', 'ConsumableItem', 'Software', 'SoftwareLicense'))) {
echo "<td>" . __('Monthly TCO') . "</td><td>";
echo self::showTco($item->getField('ticket_tco'), $ic->fields["value"], $ic->fields["warranty_date"]);
} else {
echo "<td colspan='2'>";
}
echo "</td></tr>";
echo "<tr><th colspan='4'>" . __('Warranty information') . "</th></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Start date of warranty') . "</td><td>";
Html::showDateField("warranty_date", array('value' => $ic->fields["warranty_date"], 'maybeempty' => true, 'canedit' => $editcalendar));
echo "</td>";
echo "<td>" . __('Warranty duration') . "</td><td>";
if ($withtemplate == 2) {
// -1 = life
if ($ic->fields["warranty_duration"] == -1) {
_e('Lifelong');
} else {
printf(_n('%d month', '%d months', $ic->fields["warranty_duration"]), $ic->fields["warranty_duration"]);
}
} else {
Dropdown::showNumber("warranty_duration", array('value' => $ic->fields["warranty_duration"], 'min' => 0, 'max' => 120, 'step' => 1, 'toadd' => array(-1 => __('Lifelong')), 'unit' => 'month'));
}
$tmpdat = self::getWarrantyExpir($ic->fields["warranty_date"], $ic->fields["warranty_duration"], 0, true);
if ($tmpdat) {
echo "<span class='small_space'>" . sprintf(__('Valid to %s'), $tmpdat) . "</span>";
}
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>" . __('Warranty information') . "</td>";
echo "<td >";
Html::autocompletionTextField($ic, "warranty_info", array('option' => $option));
echo "</td>";
if ($CFG_GLPI['use_mailing']) {
echo "<td>" . __('Alarms on financial and administrative information') . "</td>";
echo "<td>";
self::dropdownAlert(array('name' => "alert", 'value' => $ic->fields["alert"]));
Alert::displayLastAlert('Infocom', $ic->fields['id']);
} else {
echo "</td><td colspan='2'>";
}
echo "</td></tr>";
if ($canedit) {
echo "<tr>";
echo "<td class='tab_bg_2 center' colspan='2'>";
echo "<input type='hidden' name='id' value='" . $ic->fields['id'] . "'>";
echo "<input type='submit' name='update' value=\"" . _sx('button', 'Save') . "\"\n class='submit'>";
echo "</td>";
echo "<td class='tab_bg_2 center' colspan='2'>";
echo "<input type='submit' name='purge' value=\"" . _sx('button', 'Delete permanently') . "\"\n class='submit'>";
echo "</td></tr>";
echo "</table>";
Html::closeForm();
} else {
echo "</table>";
}
echo "</div>";
}
}
}
