static function pdfMain(PluginPdfSimplePDF $pdf, SoftwareVersion $version) { global $DB; $ID = $version->getField('id'); $pdf->setColumnsSize(100); $pdf->displayTitle('<b><i>' . sprintf(__('%1$s: %2$s'), __('ID') . "</i>", $ID . "</b>")); $pdf->setColumnsSize(50, 50); $pdf->displayLine('<b><i>' . sprintf(__('%1$s: %2$s'), __('Name') . '</i></b>', $version->fields['name']), '<b><i>' . sprintf(__('%1$s: %2$s'), _n('Software', 'Software', 2) . '</i></b>', Html::clean(Dropdown::getDropdownName('glpi_softwares', $version->fields['softwares_id'])))); $pdf->displayLine('<b><i>' . sprintf(__('%1$s: %2$s'), __('Status') . '</i></b>', Html::clean(Dropdown::getDropdownName('glpi_states', $version->fields['states_id']))), '<b><i>' . sprintf(__('%1$s: %2$s'), __('Operating system') . '</i></b>', Html::clean(Dropdown::getDropdownName('glpi_operatingsystems', $version->fields['operatingsystems_id'])))); $pdf->setColumnsSize(100); PluginPdfCommon::mainLine($pdf, $version, 'comment'); $pdf->displaySpace(); }
static function pdfForVersionByEntity(PluginPdfSimplePDF $pdf, SoftwareVersion $version) { global $DB, $CFG_GLPI; $softwareversions_id = $version->getField('id'); $pdf->setColumnsSize(75, 25); $pdf->setColumnsAlign('left', 'right'); $pdf->displayTitle('<b>' . __('Entity'), _n('Installation', 'Installations', 2) . '</b>'); $lig = $tot = 0; if (in_array(0, $_SESSION["glpiactiveentities"])) { $nb = Computer_SoftwareVersion::countForVersion($softwareversions_id, 0); if ($nb > 0) { $pdf->displayLine(__('Root entity'), $nb); $tot += $nb; $lig++; } } $sql = "SELECT `id`, `completename`\n FROM `glpi_entities` " . getEntitiesRestrictRequest('WHERE', 'glpi_entities') . "\n ORDER BY `completename`"; foreach ($DB->request($sql) as $ID => $data) { $nb = Computer_SoftwareVersion::countForVersion($softwareversions_id, $ID); if ($nb > 0) { $pdf->displayLine($data["completename"], $nb); $tot += $nb; $lig++; } } if ($tot > 0) { if ($lig > 1) { $pdf->displayLine(__('Total'), $tot); } } else { $pdf->setColumnsSize(100); $pdf->displayLine(__('No item found')); } $pdf->displaySpace(); }
/** * Show number of installation per entity * * @param $version SoftwareVersion object * * @return nothing **/ static function showForVersionByEntity(SoftwareVersion $version) { global $DB, $CFG_GLPI, $LANG; $softwareversions_id = $version->getField('id'); if (!haveRight("software", "r") || !$softwareversions_id) { return false; } echo "<div class='center'>"; echo "<table class='tab_cadre'><tr>"; echo "<th> " . $LANG['entity'][0] . " </th>"; echo "<th> " . $LANG['software'][19] . " </th>"; echo "</tr>\n"; $tot = 0; if (in_array(0, $_SESSION["glpiactiveentities"])) { $nb = self::countForVersion($softwareversions_id, 0); if ($nb > 0) { echo "<tr class='tab_bg_2'><td>" . $LANG['entity'][2] . "</td>"; echo "<td class='right'>" . $nb . "</td></tr>\n"; $tot += $nb; } } $sql = "SELECT `id`, `completename`\n FROM `glpi_entities` " . getEntitiesRestrictRequest('WHERE', 'glpi_entities') . "\n ORDER BY `completename`"; foreach ($DB->request($sql) as $ID => $data) { $nb = self::countForVersion($softwareversions_id, $ID); if ($nb > 0) { echo "<tr class='tab_bg_2'><td>" . $data["completename"] . "</td>"; echo "<td class='right'>" . $nb . "</td></tr>\n"; $tot += $nb; } } if ($tot > 0) { echo "<tr class='tab_bg_1'><td class='right b'>" . $LANG['common'][33] . "</td>"; echo "<td class='right b'>" . $tot . "</td></tr>\n"; } else { echo "<tr class='tab_bg_1'><td colspan='2 b'>" . $LANG['search'][15] . "</td></tr>\n"; } echo "</table></div>"; }
/** * Show number of installations per entity * * @param $version SoftwareVersion object * * @return nothing **/ static function showForVersionByEntity(SoftwareVersion $version) { global $DB, $CFG_GLPI; $softwareversions_id = $version->getField('id'); if (!Software::canView() || !$softwareversions_id) { return false; } echo "<div class='center'>"; echo "<table class='tab_cadre'><tr>"; echo "<th>" . __('Entity') . "</th>"; echo "<th>" . self::getTypeName(Session::getPluralNumber()) . "</th>"; echo "</tr>\n"; $tot = 0; $sql = "SELECT `id`, `completename`\n FROM `glpi_entities` " . getEntitiesRestrictRequest('WHERE', 'glpi_entities') . "\n ORDER BY `completename`"; foreach ($DB->request($sql) as $ID => $data) { $nb = self::countForVersion($softwareversions_id, $ID); if ($nb > 0) { echo "<tr class='tab_bg_2'><td>" . $data["completename"] . "</td>"; echo "<td class='numeric'>" . $nb . "</td></tr>\n"; $tot += $nb; } } if ($tot > 0) { echo "<tr class='tab_bg_1'><td class='center b'>" . __('Total') . "</td>"; echo "<td class='numeric b'>" . $tot . "</td></tr>\n"; } else { echo "<tr class='tab_bg_1'><td colspan='2 b'>" . __('No item found') . "</td></tr>\n"; } echo "</table></div>"; }