$projectDetail->pro_name[0] = str_replace("'", "'", $projectDetail->pro_name[0]);
$graph = new GanttGraph();
$graph->SetBox();
$graph->SetMarginColor("white");
$graph->SetColor("white");
$graph->title->Set($strings["task"] . " " . $taskDetail->tas_name[0]);
$graph->subtitle->Set("(" . $strings["created"] . ": " . $taskDetail->tas_created[0] . ")");
$graph->title->SetFont(FF_FONT1);
$graph->SetColor("white");
$graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH | GANTT_HDAY | GANTT_HWEEK);
$graph->scale->week->SetStyle(WEEKSTYLE_FIRSTDAY);
$graph->scale->week->SetFont(FF_FONT0);
$graph->scale->year->SetFont(FF_FONT1);
$tmpquery = "WHERE subtas.task = '{$task}' AND subtas.start_date != '--' AND subtas.due_date != '--' AND tas.published != '1' ORDER BY subtas.due_date";
$listTasks = new request();
$listTasks->openSubtasks($tmpquery);
$comptListTasks = count($listTasks->subtas_id);
for ($i = 0; $i < $comptListTasks; $i++) {
$listTasks->subtas_name[$i] = str_replace('"', '"', $listTasks->subtas_name[$i]);
$listTasks->subtas_name[$i] = str_replace("'", "'", $listTasks->subtas_name[$i]);
$progress = round($listTasks->subtas_completion[$i] / 10, 2);
$printProgress = $listTasks->subtas_completion[$i] * 10;
$activity = new GanttBar($i, $listTasks->subtas_name[$i], $listTasks->subtas_start_date[$i], $listTasks->subtas_due_date[$i]);
$activity->SetPattern(BAND_LDIAG, "yellow");
$activity->caption->Set($listTasks->subtas_mem_login[$i] . " (" . $printProgress . "%)");
$activity->SetFillColor("gray");
if ($listTasks->subtas_priority[$i] == "4" || $listTasks->subtas_priority[$i] == "5") {
$activity->progress->SetPattern(BAND_SOLID, "#BB0000");
} else {
$activity->progress->SetPattern(BAND_SOLID, "#0000BB");
}
<?php
if ($num == "") {
$num = $id;
}
$tmpquery = "WHERE subtas.id IN({$num})";
$subtaskNoti = new request();
$subtaskNoti->openSubtasks($tmpquery);
$tmpquery = "WHERE tas.id = '" . $subtaskNoti->subtas_task[0] . "'";
$taskNoti = new request();
$taskNoti->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '" . $taskNoti->tas_project[0] . "'";
$projectNoti = new request();
$projectNoti->openProjects($tmpquery);
$tmpquery = "WHERE noti.member IN({$at})";
$listNotifications = new request();
$listNotifications->openNotifications($tmpquery);
$comptListNotifications = count($listNotifications->not_id);
if ($listNotifications->not_taskassignment[0] == "0") {
$mail = new notification();
$mail->getUserinfo($idSession, "from");
$mail->partSubject = $strings["noti_taskassignment1"];
$mail->partMessage = $strings["noti_taskassignment2"];
if ($projectNoti->pro_org_id[0] == "1") {
$projectNoti->pro_org_name[0] = $strings["none"];
}
$complValue = $subtaskNoti->subtas_completion[0] > 0 ? $subtaskNoti->subtas_completion[0] . "0 %" : $subtaskNoti->subtas_completion[0] . " %";
$idStatus = $subtaskNoti->subtas_status[0];
$idPriority = $subtaskNoti->subtas_priority[0];
$body = $mail->partMessage . "\n\n" . $strings["subtask"] . " : " . $subtaskNoti->subtas_name[0] . "\n" . $strings["start_date"] . " : " . $subtaskNoti->subtas_start_date[0] . "\n" . $strings["due_date"] . " : " . $subtaskNoti->subtas_due_date[0] . "\n" . $strings["completion"] . " : " . $complValue . "\n" . $strings["priority"] . " : {$priority[$idPriority]}\n" . $strings["status"] . " : {$status[$idStatus]}\n" . $strings["description"] . " : " . $subtaskNoti->subtas_description[0] . "\n\n" . $strings["project"] . " : " . $projectNoti->pro_name[0] . " (" . $projectNoti->pro_id[0] . ")\n" . $strings["task"] . " : " . $taskNoti->tas_name[0] . " (" . $taskNoti->tas_id[0] . ")\n" . $strings["organization"] . " : " . $projectNoti->pro_org_name[0] . "\n\n" . $strings["noti_moreinfo"] . "\n";
if ($subtaskNoti->subtas_mem_organization[0] == "1") {
function ganttPDF($reportName, $listTasks)
{
include "../includes/jpgraph/jpgraph.php";
include "../includes/jpgraph/jpgraph_gantt.php";
$graph = new GanttGraph();
$graph->SetBox();
$graph->SetMarginColor("white");
$graph->SetColor("white");
$graph->title->Set($strings["project"] . " " . $reportName);
// $graph->subtitle->Set("(".$strings["created"].": "..")");
$graph->title->SetFont(FF_FONT1);
$graph->SetColor("white");
$graph->ShowHeaders(GANTT_HYEAR | GANTT_HMONTH | GANTT_HDAY | GANTT_HWEEK);
$graph->scale->week->SetStyle(WEEKSTYLE_FIRSTDAY);
$graph->scale->week->SetFont(FF_FONT0);
$graph->scale->year->SetFont(FF_FONT1);
$comptListTasks = count($listTasks->tas_id);
$posGantt = 0;
for ($i = 0; $i < $comptListTasks; $i++) {
$listTasks->tas_name[$i] = str_replace('"', '"', $listTasks->tas_name[$i]);
$listTasks->tas_name[$i] = str_replace("'", "'", $listTasks->tas_name[$i]);
$progress = round($listTasks->tas_completion[$i] / 10, 2);
$printProgress = $listTasks->tas_completion[$i] * 10;
$activity = new GanttBar($posGantt, $listTasks->tas_pro_name[$i] . " / " . $listTasks->tas_name[$i], $listTasks->tas_start_date[$i], $listTasks->tas_due_date[$i]);
$activity->SetPattern(BAND_LDIAG, "yellow");
$activity->caption->Set($listTasks->tas_mem_login[$i] . " (" . $printProgress . "%)");
$activity->SetFillColor("gray");
if ($listTasks->tas_priority[$i] == "4" || $listTasks->tas_priority[$i] == "5") {
$activity->progress->SetPattern(BAND_SOLID, "#BB0000");
} else {
$activity->progress->SetPattern(BAND_SOLID, "#0000BB");
}
$activity->progress->Set($progress);
$graph->Add($activity);
// begin if subtask
$tmpquery = "WHERE task = " . $listTasks->tas_id[$i];
$listSubTasks = new request();
$listSubTasks->openSubtasks($tmpquery);
$comptListSubTasks = count($listSubTasks->subtas_id);
if ($comptListSubTasks >= 1) {
// list subtasks
for ($j = 0; $j < $comptListSubTasks; $j++) {
$listSubTasks->subtas_name[$j] = str_replace('"', '"', $listSubTasks->subtas_name[$j]);
$listSubTasks->subtas_name[$j] = str_replace("'", "'", $listSubTasks->subtas_name[$j]);
$progress = round($listSubTasks->subtas_completion[$j] / 10, 2);
$printProgress = $listSubTasks->subtas_completion[$j] * 10;
$posGantt += 1;
// $activity = new GanttBar($posGantt,$listTasks->tas_pro_name[$i]." / ".$listSubTasks->subtas_name[$j],$listSubTasks->subtas_start_date[$j],$listSubTasks->subtas_due_date[$j]);
// change name of project for name of parent task
$activity = new GanttBar($posGantt, $listSubTasks->subtas_tas_name[$j] . " / " . $listSubTasks->subtas_name[$j], $listSubTasks->subtas_start_date[$j], $listSubTasks->subtas_due_date[$j]);
//$activity = new GanttBar($j,$strings["project"].": ".$listSubTasks->subtas_pro_name[$j]." / ".$strings["task"].": ".$listSubTasks->subtas_name[$j],$listSubTasks->subtas_start_date[$j],$listSubTasks->subtas_due_date[$j]);
$activity->SetPattern(BAND_LDIAG, "yellow");
$activity->caption->Set($listSubTasks->subtas_mem_login[$j] . " (" . $printProgress . "%)");
$activity->SetFillColor("gray");
if ($listSubTasks->subtas_priority[$j] == "4" || $listSubTasks->subtas_priority[$j] == "5") {
$activity->progress->SetPattern(BAND_SOLID, "#BB0000");
} else {
$activity->progress->SetPattern(BAND_SOLID, "#0000BB");
}
$activity->progress->Set($progress);
$graph->Add($activity);
}
// end for comptListSubTasks
}
// end if subtask
$posGantt += 1;
}
// end for complisttask
$tmpGantt = "../files/" . md5(uniqid(rand()));
$graph->Stroke($tmpGantt);
return $tmpGantt;
}
**
** DESC: Screen: view sub task mod history
**
** HISTORY:
** 05/11/2004 - fixed 1059973
** -----------------------------------------------------------------------------
** TO-DO:
** clean code
** =============================================================================
*/
$checkSession = "true";
include_once '../includes/library.php';
if ($type == "2") {
$tmpquery = "WHERE subtas.id = '{$item}'";
$subtaskDetail = new request();
$subtaskDetail->openSubtasks($tmpquery);
$tmpquery = "WHERE tas.id = '" . $subtaskDetail->subtas_task[0] . "'";
$taskDetail = new request();
$taskDetail->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '" . $taskDetail->tas_project[0] . "'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
if ($projectDetail->pro_enable_phase[0] != "0") {
$tPhase = $taskDetail->tas_parent_phase[0];
if (!$tPhase) {
$tPhase = '0';
}
$tmpquery = "WHERE pha.project_id = '" . $taskDetail->tas_project[0] . "' AND pha.order_num = '{$tPhase}'";
$targetPhase = new request();
$targetPhase->openPhases($tmpquery);
}
$listTasks = new request();
$listTasks->openTasks($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTasks = count($listTasks->tas_id);
//echo "$tmpquery<br/>";
}
$block9 = new block();
$block9->borne = $blockPage->returnBorne("9");
$block9->rowsLimit = "10";
$block9->sorting("home_subtasks", $sortingUser->sor_home_subtasks[0], "subtas.name ASC", $sortingFields = array(0 => "subtas.name", 1 => "subtas.priority", 2 => "subtas.status", 3 => "subtas.due_date", 4 => "mem.login", 5 => "subtas.project", 6 => "subtas.published"));
//$tmpquery = "$searchSubtasks AND pro.id IN($filterResults) ORDER BY $block9->sortingValue";
$tmpquery = "{$searchSubtasks} ORDER BY {$block9->sortingValue}";
$comptListSubtasks = "0";
if ($validSubtasks == "true") {
$block9->recordsTotal = compt($initrequest["subtasks"] . " " . $tmpquery);
$listSubtasks = new request();
$listSubtasks->openSubtasks($tmpquery, $block9->borne, $block9->rowsLimit);
$comptListSubtasks = count($listSubtasks->subtas_id);
//echo "$tmpquery<br/>";
}
$block3 = new block();
$block3->borne = $blockPage->returnBorne("3");
$block3->rowsLimit = "10";
$block3->sorting("users", $sortingUser->sor_users[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.login", 2 => "mem.email_work", 3 => "mem.phone_work", 4 => "log.connected"));
if ($demoMode == "true") {
$tmpquery = "{$searchMembers} ) ORDER BY {$block3->sortingValue}";
} else {
$tmpquery = "{$searchMembers} ) AND mem.id != '2' ORDER BY {$block3->sortingValue}";
}
$comptListMembers = "0";
if ($validMembers == "true") {
$block3->recordsTotal = compt($initrequest["members"] . " " . $tmpquery);
