static function showHierarchy($ID, $parents = 0)
{
global $DB, $CFG_GLPI;
$first = false;
$projet = new PluginProjetTask();
$query = "SELECT `glpi_plugin_projet_tasks`.* ";
if ($parents != 0) {
$parent = "plugin_projet_tasks_id_1";
$child = "plugin_projet_tasks_id_2";
} else {
$parent = "plugin_projet_tasks_id_2";
$child = "plugin_projet_tasks_id_1";
}
$query .= " FROM `glpi_plugin_projet_tasks`";
$query .= " LEFT JOIN `glpi_plugin_projet_tasks_tasks` \n ON (`glpi_plugin_projet_tasks_tasks`.`{$child}` = `glpi_plugin_projet_tasks`.`id`)";
$query .= " WHERE `glpi_plugin_projet_tasks_tasks`.`{$parent}` = '{$ID}' ";
if ($projet->maybeTemplate()) {
$LINK = " AND ";
if ($first) {
$LINK = " ";
$first = false;
}
$query .= $LINK . "`glpi_plugin_projet_tasks`.`is_template` = '0' ";
}
// Add is_deleted if item have it
if ($projet->maybeDeleted()) {
$LINK = " AND ";
if ($first) {
$LINK = " ";
$first = false;
}
$query .= $LINK . "`glpi_plugin_projet_tasks`.`is_deleted` = '0' ";
}
$LINK = " AND ";
$query .= getEntitiesRestrictRequest(" AND ", "glpi_plugin_projet_tasks", '', '', $projet->maybeRecursive());
$query .= " ORDER BY `glpi_plugin_projet_tasks`.`name`";
$result = $DB->query($query);
$number = $DB->numrows($result);
$i = 0;
if (Session::isMultiEntitiesMode()) {
$colsup = 1;
} else {
$colsup = 0;
}
if ($number != "0") {
echo "<div align='center'><table class='tab_cadre_fixe'>";
$title = _n('Child task', 'Child tasks', 2, 'projet');
if ($parents != 0) {
$title = __('Parent task', 'projet');
}
echo "<tr><th colspan='" . (7 + $colsup) . "'>" . $title . "</th></tr>";
echo "<tr><th>" . __('Name') . "</th>";
if (Session::isMultiEntitiesMode()) {
echo "<th>" . __('Entity') . "</th>";
}
echo "<th>" . __('Progress') . "</th>";
echo "<th>" . _n('User', 'Users', 1) . "</th>";
echo "<th>" . _n('Group', 'Groups', 1) . "</th>";
echo "<th>" . __('State') . "</th>";
echo "</tr>";
while ($data = $DB->fetch_array($result)) {
$start = 0;
$output_type = Search::HTML_OUTPUT;
$del = false;
if ($data["is_deleted"] == '0') {
echo "<tr class='tab_bg_1'>";
} else {
echo "<tr class='tab_bg_1" . ($data["is_deleted"] == '1' ? "_2" : "") . "'>";
}
echo Search::showItem($output_type, "<a href=\"./task.form.php?id=" . $data["id"] . "\">" . $data["name"] . ($_SESSION["glpiis_ids_visible"] || empty($data["name"]) ? ' (' . $data["id"] . ') ' : '') . "</a>", $item_num, $i - $start + 1, '');
if (Session::isMultiEntitiesMode()) {
echo "<td class='center'>" . Dropdown::getDropdownName("glpi_entities", $data['entities_id']) . "</td>";
}
echo Search::showItem($output_type, PluginProjetProjet::displayProgressBar('100', $data["advance"], array("simple" => true)), $item_num, $i - $start + 1, "align='center'");
echo Search::showItem($output_type, getUserName($data['users_id']), $item_num, $i - $start + 1, '');
echo Search::showItem($output_type, Dropdown::getDropdownName("glpi_groups", $data['groups_id']), $item_num, $i - $start + 1, '');
echo Search::showItem($output_type, Dropdown::getDropdownName("glpi_plugin_projet_taskstates", $data['plugin_projet_taskstates_id']), $item_num, $i - $start + 1, "bgcolor='" . PluginProjetTaskState::getStatusColor($data['plugin_projet_taskstates_id']) . "' align='center'");
echo "</tr>";
}
echo "</table></div>";
}
}
