/**
* show for PDF the webapplications associated with a device
*
* @param $pdf
* @param $item
*
**/
static function PdfFromItems(PluginPdfSimplePDF $pdf, CommonGLPI $item)
{
global $DB, $CFG_GLPI;
$pdf->setColumnsSize(100);
$pdf->displayTitle('<b>' . _n('Associated web application', 'Associated web applications', 2, 'webapplications') . '</b>');
$ID = $item->getField('id');
$itemtype = get_Class($item);
$canread = $item->can($ID, READ);
$canedit = $item->can($ID, UPDATE);
$web = new PluginWebapplicationsWebapplication();
$query = "SELECT `glpi_plugin_webapplications_webapplications`.* " . " FROM `glpi_plugin_webapplications_webapplications_items`,`glpi_plugin_webapplications_webapplications` " . " LEFT JOIN `glpi_entities` ON (`glpi_entities`.`id` = `glpi_plugin_webapplications_webapplications`.`entities_id`) " . " WHERE `glpi_plugin_webapplications_webapplications_items`.`items_id` = '" . $ID . "' \n AND `glpi_plugin_webapplications_webapplications_items`.`itemtype` = '" . $itemtype . "' \n AND `glpi_plugin_webapplications_webapplications_items`.`plugin_webapplications_webapplications_id` = `glpi_plugin_webapplications_webapplications`.`id` " . getEntitiesRestrictRequest(" AND ", "glpi_plugin_webapplications_webapplications", '', '', $web->maybeRecursive());
$result = $DB->query($query);
$number = $DB->numrows($result);
if (!$number) {
$pdf->displayLine(__('No item found'));
} else {
if (Session::isMultiEntitiesMode()) {
$pdf->setColumnsSize(25, 25, 15, 15, 20);
$pdf->displayTitle('<b><i>' . __('Name'), __('Entity'), __('Technician in charge of the hardware'), __('Group in charge of the hardware'), PluginWebapplicationsWebapplicationType::getTypeName(1) . '</i></b>');
} else {
$pdf->setColumnsSize(30, 30, 20, 20);
$pdf->displayTitle('<b><i>' . __('Name'), __('Technician in charge of the hardware'), __('Group in charge of the hardware'), PluginWebapplicationsWebapplicationType::getTypeName(1) . '</i></b>');
}
while ($data = $DB->fetch_array($result)) {
$webapplicationsID = $data["id"];
if (Session::isMultiEntitiesMode()) {
$pdf->setColumnsSize(25, 25, 15, 15, 20);
$pdf->displayLine($data["name"], Html::clean(Dropdown::getDropdownName("glpi_entities", $data['entities_id'])), Html::clean(getUsername("glpi_users", $data["users_id_tech"])), Html::clean(Dropdown::getDropdownName("glpi_groups", $data["groups_id_tech"])), Html::clean(Dropdown::getDropdownName("glpi_plugin_webapplications_webapplicationtypes", $data["plugin_webapplications_webapplicationtypes_id"])));
} else {
$pdf->setColumnsSize(50, 25, 25);
$pdf->displayLine($data["name"], Html::clean(getUsername("glpi_users", $data["users_id_tech"])), Html::clean(Dropdown::getDropdownName("glpi_groups", $data["groups_id_tech"])), Html::clean(Dropdown::getDropdownName("glpi_plugin_webapplications_webapplicationtypes", $data["plugin_webapplications_webapplicationtypes_id"])));
}
}
}
}
