static function pdfForComputer(PluginPdfSimplePDF $pdf, Computer $comp)
{
global $DB;
$ID = $comp->getField('id');
// From Computer_SoftwareVersion::showForComputer();
$query = "SELECT `glpi_softwares`.`softwarecategories_id`,\n `glpi_softwares`.`name` AS softname,\n `glpi_computers_softwareversions`.`id`,\n `glpi_states`.`name` AS state,\n `glpi_softwareversions`.`id` AS verid,\n `glpi_softwareversions`.`softwares_id`,\n `glpi_softwareversions`.`name` AS version\n FROM `glpi_computers_softwareversions`\n LEFT JOIN `glpi_softwareversions`\n ON (`glpi_computers_softwareversions`.`softwareversions_id`\n = `glpi_softwareversions`.`id`)\n LEFT JOIN `glpi_states`\n ON (`glpi_states`.`id` = `glpi_softwareversions`.`states_id`)\n LEFT JOIN `glpi_softwares`\n ON (`glpi_softwareversions`.`softwares_id` = `glpi_softwares`.`id`)\n WHERE `glpi_computers_softwareversions`.`computers_id` = '{$ID}'\n ORDER BY `softwarecategories_id`, `softname`, `version`";
$output = array();
$software_category = new SoftwareCategory();
$software_version = new SoftwareVersion();
foreach ($DB->request($query) as $softwareversion) {
$output[] = $softwareversion;
}
$installed = array();
if (count($output)) {
$pdf->setColumnsSize(100);
$pdf->displayTitle('<b>' . _n('Installed software', 'Installed software', 2, 'pdf') . '</b>');
$cat = -1;
foreach ($output as $soft) {
if ($soft["softwarecategories_id"] != $cat) {
$cat = $soft["softwarecategories_id"];
if ($cat && $software_category->getFromDB($cat)) {
$catname = $software_category->getName();
} else {
$catname = __('Uncategorized software');
}
$pdf->setColumnsSize(100);
$pdf->displayTitle('<b>' . $catname . '</b>');
$pdf->setColumnsSize(50, 13, 13, 24);
$pdf->displayTitle('<b>' . __('Name'), __('Status'), __('Version'), __('License') . '</b>');
}
// From Computer_SoftwareVersion::displaySoftsByCategory()
$verid = $soft['verid'];
$query = "SELECT `glpi_softwarelicenses`.*,\n `glpi_softwarelicensetypes`.`name` AS type\n FROM `glpi_computers_softwarelicenses`\n INNER JOIN `glpi_softwarelicenses`\n ON (`glpi_computers_softwarelicenses`.`softwarelicenses_id`\n = `glpi_softwarelicenses`.`id`)\n LEFT JOIN `glpi_softwarelicensetypes`\n ON (`glpi_softwarelicenses`.`softwarelicensetypes_id`\n =`glpi_softwarelicensetypes`.`id`)\n WHERE `glpi_computers_softwarelicenses`.`computers_id` = '{$ID}'\n AND (`glpi_softwarelicenses`.`softwareversions_id_use` = '{$verid}'\n OR (`glpi_softwarelicenses`.`softwareversions_id_use` = '0'\n AND `glpi_softwarelicenses`.`softwareversions_id_buy` = '{$verid}'))";
$lic = '';
foreach ($DB->request($query) as $licdata) {
$installed[] = $licdata['id'];
$lic .= (empty($lic) ? '' : ', ') . '<b>' . $licdata['name'] . '</b> ' . $licdata['serial'];
if (!empty($licdata['type'])) {
$lic = sprintf(__('%1$s (%2$s)'), $lic, $licdata['type']);
}
}
$pdf->displayLine($soft['softname'], $soft['state'], $soft['version'], $lic);
}
// Each version
} else {
$pdf->displayTitle('<b>' . __('No installed software', 'pdf') . '</b>');
}
// Affected licenses NOT installed
$query = "SELECT `glpi_softwarelicenses`.*,\n `glpi_softwares`.`name` AS softname,\n `glpi_softwareversions`.`name` AS version,\n `glpi_states`.`name` AS state\n FROM `glpi_softwarelicenses`\n LEFT JOIN `glpi_computers_softwarelicenses`\n ON (`glpi_computers_softwarelicenses`.softwarelicenses_id\n = `glpi_softwarelicenses`.`id`)\n INNER JOIN `glpi_softwares`\n ON (`glpi_softwarelicenses`.`softwares_id` = `glpi_softwares`.`id`)\n LEFT JOIN `glpi_softwareversions`\n ON (`glpi_softwarelicenses`.`softwareversions_id_use`\n = `glpi_softwareversions`.`id`\n OR (`glpi_softwarelicenses`.`softwareversions_id_use` = '0'\n AND `glpi_softwarelicenses`.`softwareversions_id_buy`\n = `glpi_softwareversions`.`id`))\n LEFT JOIN `glpi_states`\n ON (`glpi_states`.`id` = `glpi_softwareversions`.`states_id`)\n WHERE `glpi_computers_softwarelicenses`.`computers_id` = '{$ID}' ";
if (count($installed)) {
$query .= " AND `glpi_softwarelicenses`.`id` NOT IN (" . implode(',', $installed) . ")";
}
$req = $DB->request($query);
if ($req->numrows()) {
$pdf->setColumnsSize(100);
$pdf->displayTitle('<b>' . __('Affected licenses of not installed software') . '</b>');
$pdf->setColumnsSize(50, 13, 13, 24);
$pdf->displayTitle('<b>' . __('Name'), __('Status'), __('Version'), __('License') . '</b>');
$lic = '';
foreach ($req as $data) {
$lic .= '<b>' . $data['name'] . '</b> ' . $data['serial'];
if (!empty($data['softwarelicensetypes_id'])) {
$lic = sprintf(__('%1$s (%2$s)'), $lic, Html::Clean(Dropdown::getDropdownName('glpi_softwarelicensetypes', $data['softwarelicensetypes_id'])));
}
$pdf->displayLine($data['softname'], $data['state'], $data['version'], $lic);
}
}
$pdf->displaySpace();
}
