/**
* Show for PDF an projet - Hierarchy
*
* @param $pdf object for the output
* @param $ID of the projet
*/
static function pdfHierarchyForProjet(PluginPdfSimplePDF $pdf, PluginProjetProjet $appli, $parents = 0)
{
global $DB, $CFG_GLPI;
$ID = $appli->fields['id'];
if (!$appli->can($ID, "r")) {
return false;
}
if (!plugin_projet_haveRight("projet", "r")) {
return false;
}
$pdf->setColumnsSize(100);
if ($parents) {
$pdf->displayTitle('<b>' . __('Parent project', 'projet') . '</b>');
} else {
$pdf->displayTitle('<b>' . _n('Child project', 'Child projects', 2, 'projet') . '</b>');
}
$first = false;
$query = "SELECT `" . $appli->gettable() . "`.* ";
if ($parents != 0) {
$parent = "plugin_projet_projets_id_1";
$child = "plugin_projet_projets_id_2";
} else {
$parent = "plugin_projet_projets_id_2";
$child = "plugin_projet_projets_id_1";
}
$query .= " FROM `glpi_plugin_projet_projets`";
$query .= " LEFT JOIN `glpi_plugin_projet_projets_projets` \n ON (`glpi_plugin_projet_projets_projets`.`{$child}` = `glpi_plugin_projet_projets`.`id`)";
$query .= " WHERE `glpi_plugin_projet_projets_projets`.`{$parent}` = '{$ID}' ";
if ($appli->maybeTemplate()) {
$LINK = " AND ";
if ($first) {
$LINK = " ";
$first = false;
}
$query .= $LINK . "`" . $appli->getTable() . "`.`is_template` = '0' ";
}
// Add is_deleted if item have it
if ($appli->maybeDeleted()) {
$LINK = " AND ";
if ($first) {
$LINK = " ";
$first = false;
}
$query .= $LINK . "`" . $appli->getTable() . "`.`is_deleted` = '0' ";
}
$LINK = " AND ";
$query .= getEntitiesRestrictRequest(" AND ", $appli->gettable(), '', '', $appli->maybeRecursive());
$query .= " ORDER BY `" . $appli->gettable() . "`.`name`";
$result = $DB->query($query);
$number = $DB->numrows($result);
if (!$number) {
$pdf->displayLine(__('No item found'));
} else {
if (Session::isMultiEntitiesMode()) {
$pdf->setColumnsSize(17, 17, 17, 17, 16, 16);
$pdf->displayTitle('<b><i>' . __('Name'), __('Entity'), __('Progress'), _n('State', 'States', 1), __('Start date'), __('End date') . '</i></b>');
} else {
$pdf->setColumnsSize(20, 17, 17, 17, 17);
$pdf->displayTitle('<b><i>' . __('Name'), __('Progress'), _n('State', 'States', 1), __('Start date'), __('End date') . '</i></b>');
}
while ($data = $DB->fetch_array($result)) {
$items_id_display = "";
if ($_SESSION["glpiis_ids_visible"] || empty($data["name"])) {
$items_id_display = " (" . $data["id"] . ")";
}
$name = $data["name"] . $items_id_display;
$entity = Html::clean(Dropdown::getDropdownName("glpi_entities", $data['entities_id']));
if (Session::isMultiEntitiesMode()) {
$pdf->setColumnsSize(17, 17, 17, 17, 16, 16);
$pdf->displayLine($name, $entity, PluginProjetProjet::displayProgressBar('100', $data["advance"], array("simple" => true)), Html::clean(Dropdown::getDropdownName("glpi_plugin_projet_projetstates", $data['plugin_projet_projetstates_id'])), Html::convdate($data["date_begin"]), Html::convdate($data["date_end"]));
} else {
$pdf->setColumnsSize(20, 17, 17, 17, 17);
$pdf->displayLine($name, PluginProjetProjet::displayProgressBar('100', $data["advance"], array("simple" => true)), Html::clean(Dropdown::getDropdownName("glpi_plugin_projet_projetstates", $data['plugin_projet_projetstates_id'])), Html::convdate($data["date_begin"]), Html::convdate($data["date_end"]));
}
}
}
$pdf->displaySpace();
}
