static function showHierarchy($ID, $parents = 0)
{
global $DB, $CFG_GLPI;
$first = false;
$projet = new PluginProjetProjet();
$query = "SELECT `glpi_plugin_projet_projets`.* ";
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 ($projet->maybeTemplate()) {
$LINK = " AND ";
if ($first) {
$LINK = " ";
$first = false;
}
$query .= $LINK . "`glpi_plugin_projet_projets`.`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_projets`.`is_deleted` = '0' ";
}
$LINK = " AND ";
$query .= getEntitiesRestrictRequest(" AND ", "glpi_plugin_projet_projets", '', '', $projet->maybeRecursive());
$query .= " ORDER BY `glpi_plugin_projet_projets`.`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 project', 'Child projects', 2, 'projet');
if ($parents != 0) {
$title = __('Parent project', '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 "<th>" . __('Start date') . "</th>";
echo "<th>" . __('End date') . "</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=\"./projet.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_projetstates", $data['plugin_projet_projetstates_id']), $item_num, $i - $start + 1, "bgcolor='" . PluginProjetProjetState::getStatusColor($data['plugin_projet_projetstates_id']) . "' align='center'");
echo Search::showItem($output_type, Html::convdate($data["date_begin"]), $item_num, $i - $start + 1, "align='center'");
$display = Html::convdate($data["date_end"]);
if ($data["date_end"] <= date('Y-m-d')) {
$display = "<span class='plugin_projet_date_end'>" . Html::convdate($data["date_end"]) . "</span>";
}
echo Search::showItem($output_type, $display, $item_num, $i - $start + 1, "align='center'");
echo "</tr>";
}
echo "</table></div>";
}
}
/**
* Show for PDF an projet
*
* @param $pdf object for the output
* @param $ID of the projet
*/
static function pdfGanttForProjet(PluginPdfSimplePDF $pdf, PluginProjetProjet $appli)
{
global $CFG_GLPI, $gtitle, $gdata, $gconst, $gdate_begin, $gdate_end;
$ID = $appli->fields['id'];
if (!$appli->can($ID, "r")) {
return false;
}
if (!plugin_projet_haveRight("projet", "r")) {
return false;
}
//nom
$gantt_p_name = $appli->fields["name"];
//type de gantt
$int = hexdec(PluginProjetProjetState::getStatusColor($appli->fields["plugin_projet_projetstates_id"]));
$gantt_p_bgcolor = array(0xff & $int >> 0x10, 0xff & $int >> 0x8, 0xff & $int);
$gantt_p_date_begin = date("Y-m-d");
$gantt_p_date_end = date("Y-m-d");
if (!empty($appli->fields["date_begin"])) {
$gantt_p_date_begin = $appli->fields["date_begin"];
}
if (!empty($appli->fields["date_end"])) {
$gantt_p_date_end = $appli->fields["date_end"];
}
$gdata[] = array("type" => 'group', "projet" => $ID, "name" => $gantt_p_name, "date_begin" => $gantt_p_date_begin, "date_end" => $gantt_p_date_end, "advance" => $appli->fields["advance"], "bg_color" => $gantt_p_bgcolor);
PluginProjetTask::showTaskTreeGantt(array('plugin_projet_projets_id' => $ID));
if (!empty($gdate_begin) && !empty($gdate_end)) {
$gtitle = $gtitle . "<DateBeg> / <DateEnd>";
$gdate_begin = date("Y", $gdate_begin) . "-" . date("m", $gdate_begin) . "-" . date("d", $gdate_begin);
$gdate_end = date("Y", $gdate_end) . "-" . date("m", $gdate_end) . "-" . date("d", $gdate_end);
}
$ImgName = self::writeGantt($gtitle, $gdata, $gconst, $gdate_begin, $gdate_end);
$image = GLPI_PLUGIN_DOC_DIR . "/projet/" . $ImgName;
$pdf->newPage();
$pdf->setColumnsSize(100);
$pdf->displayTitle('<b>' . __('Gantt', 'projet') . '</b>');
$size = GetImageSize($image);
$src_w = $size[0];
$src_h = $size[1];
$pdf->addPngFromFile($image, $src_w / 2, $src_h / 2);
$pdf->displaySpace();
unlink($image);
}
function plugin_projet_displayConfigItem($type, $ID, $data, $num)
{
global $CFG_GLPI, $DB;
$searchopt =& Search::getOptions($type);
$table = $searchopt[$ID]["table"];
$field = $searchopt[$ID]["field"];
switch ($type) {
case 'PluginProjetProjet':
switch ($table . '.' . $field) {
case "glpi_plugin_projet_projetstates.name":
return " style=\"background-color:" . PluginProjetProjetState::getStatusColor($data["ITEM_" . $num . "_2"]) . ";\" ";
break;
}
break;
case 'PluginProjetTask':
switch ($table . '.' . $field) {
case "glpi_plugin_projet_tasks.priority":
return " style=\"background-color:" . $_SESSION["glpipriority_" . $data["ITEM_{$num}"]] . ";\" ";
break;
case "glpi_plugin_projet_taskstates.name":
return " style=\"background-color:" . PluginProjetTaskState::getStatusColor($data["ITEM_" . $num . "_2"]) . ";\" ";
break;
}
break;
case 'PluginProjetProjetState':
switch ($table . '.' . $field) {
case "glpi_plugin_projet_projetstates.color":
return " style=\"background-color:" . PluginProjetProjetState::getStatusColor($data["ITEM_" . $num . "_2"]) . ";\" ";
break;
}
break;
case 'PluginProjetTaskState':
switch ($table . '.' . $field) {
case "glpi_plugin_projet_taskstates.color":
return " style=\"background-color:" . PluginProjetTaskState::getStatusColor($data["ITEM_" . $num . "_2"]) . ";\" ";
break;
}
break;
}
return "";
}
