";
$tableheader .= "Tarefa
[tiki-view_tracker.php?trackerId=".TRACKERID_TASKS."#newitem|(+)]
| ";
$tableheader .= "Responsável
| ";
$month = $min_stamp;
$min_day_aux = date("d", $min_stamp) - 1;
$month_string = "";
for ($i = 0; $i <= $nr_days_total; $i++) {
$month_string_aux = date("F", $month);
if (strcmp($month_string_aux, $month_string) <> 0) {
$month_string = $month_string_aux;
$nr_days = date("t", $month);
$tableheader .= "".$month_string." | ";
$min_day_aux = 0;
}
$month = mktime(0, 0, 0, date("m", $month), date("d", $month)+1, date("Y", $month));
}
$tableheader .= "
|---|
";
$first_weekday = date("w", $min_stamp);
$day = mktime(0, 0, 0, date("m", $min_stamp), date("d", $min_stamp), date("Y", $min_stamp));
for ($i = 0; $i <= $nr_days_total; $i++) {
$tableheader .= "| ".date("d", $day)." | ";
$first_weekday = 0;
} else if ($first_weekday == 0) {
$tableheader .= ";background-color: lightyellow\">".date("d", $day)."";
$first_weekday += 1;
} else if (in_array($day, $array_days_off)) {
$tableheader .= ";background-color: lightyellow\">".date("d", $day)."";
$first_weekday += 1;
} else {
$tableheader .= "\" >".date("d", $day)."";
$first_weekday += 1;
}
$day = mktime(0, 0, 0, date("m", $day), date("d", $day)+1, date("Y", $day));
}
$tableheader .= "
";
$first_weekday = date("w", $min_stamp);
$day = mktime(0, 0, 0, date("m", $min_stamp), date("d", $min_stamp), date("Y", $min_stamp));
$weekdays = array("D", "S", "T", "Q", "Q", "S", "S");
for ($i = 0; $i <= $nr_days_total; $i++) {
$tableheader .= "| ".$weekdays[$first_weekday]." | ";
$first_weekday = 0;
} else if ($first_weekday == 0) {
$tableheader .= ";background-color: lightyellow\">".$weekdays[$first_weekday]."";
$first_weekday += 1;
} else if (in_array($day, $array_days_off)) {
$tableheader .= ";background-color: lightyellow\">".$weekdays[$first_weekday]."";
$first_weekday += 1;
} else {
$tableheader .= "\">".$weekdays[$first_weekday]."";
$first_weekday += 1;
}
$day = mktime(0, 0, 0, date("m", $day), date("d", $day)+1, date("Y", $day));
}
$tableheader .= "
";
//Obtem a lista de items do tracker por ordem decrescente de data.
if (in_array(TRACKERID_TASKS, $datalist)) {
$items = $tikilib->list_tracker_items(TRACKERID_TASKS, 0, -1, 'created_desc', '', '');
$items = $items['data']; //é necessário pois a ordenação fica ascendente mesmo com created_desc
$array = array();
foreach ($items as $item) {
if (($max_stamp > $item['field_values'][TASK_INI]['value'] && $item['field_values'][TASK_INI]['value'] > $min_stamp) || ($max_stamp > $item['field_values'][TASK_END]['value'] && $item['field_values'][TASK_END]['value'] > $min_stamp)
|| ($min_stamp > $item['field_values'][TASK_INI]['value'] && $item['field_values'][TASK_END]['value'] > $max_stamp))
{
if (isset($projectlist)) {
if(!in_array($item['field_values'][TASK_PROJECT]['value'], $projectlist)) continue;
}
if (isset($userlist)) {
$listparticipants = explode('|', $item['field_values'][TASK_PARTICIPANTS]['value']);
$user_in = in_array($item['field_values'][TASK_USER]['value'], $userlist);
$array_int = array_intersect($userlist, $listparticipants);
if (count($array_int) == 0) { $participant_in = false; } else { $participant_in = true; }
if (!$user_in && !$participant_in) {
continue;
}
}
if (isset($typelist)) {
if(!in_array($item['field_values'][TASK_TYPE]['value'], $typelist)) continue;
}
if (isset($statelist)) {
if(!in_array($item['status'], $statelist)) continue;
}
$client = $item['field_values'][TASK_PROJECT]['value'];
switch($client) {
case "CustomerA": $color = "DarkBlue";
break;
case "CustomerB": $color = "DarkOrange";
break;
case "CustomerC": $color = "DarkGreen";
break;
case "CustomerD": $color = "Purple";
break;
case "CustomerE": $color = "Silver";
break;
case "CustomerF": $color = "LightSeaGreen";
break;
default: $color = "lightgrey";
break;
}
$user = $item['field_values'][TASK_USER]['value'];
$usertd = "((UserPage".$user."|".$user.")) | ";
$begin_date_stamp_orig = $item['field_values'][TASK_INI]['value'];
$begin_date_stamp = mktime(0, 0, 0, date("m", $begin_date_stamp_orig), date("d", $begin_date_stamp_orig), date("Y", $begin_date_stamp_orig));
$end_date_stamp = $item['field_values'][TASK_END]['value'];
$end_date_stamp = mktime(0, 0, 0, date("m", $end_date_stamp), date("d", $end_date_stamp), date("Y", $end_date_stamp));
$itemID = $item['itemId'];
$desc = $item['field_values'][TASK_DESC]['value'];
$desc_sub = str_replace("
", " ", str_replace("\n", " ", $desc));
$desc_sub = substr($desc, 0, 26) . "...";
$tooltip = "Responsável: ". $user . "
Projecto: " . $item['field_values'][TASK_PROJECT]['value'] . "
Estado: " . $item['status'] . "
Tipo: " .$item['field_values'][TASK_TYPE]['value'] . "
Data Fim: " . date("d-m-Y", $item['field_values'][TASK_FINAL]['value']) . "";
if (isset($listparticipants)) {
$tooltip .= "
Participantes: ";
foreach($listparticipants as $participant)
$tooltip .= $participant . ", ";
$tooltip = substr($tooltip, 0, -2);
$tooltip .= "
Descrição: ~np~" . str_replace("\r\n", "
", addslashes($desc)) . "~/np~";
}
$name = "[tiki-view_tracker_item.php?itemId=" . $itemID . "&show=view&trackerId=".TRACKERID_TASKS."|" . $desc_sub . "] | ";
$string = "" . $name . $usertd;
$day = mktime(0, 0, 0, date("m", $min_stamp), date("d", $min_stamp), date("Y", $min_stamp));
$first_weekday = date("w", $min_stamp);
for ($i = 0; $i <= $nr_days_total; $i++) {
$string .= "| | ";
$first_weekday = 0;
} else if ($first_weekday == 0) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday += 1;
} else if (in_array($day, $array_days_off)) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday += 1;
} else {
if ($day >= $begin_date_stamp && $day <= $end_date_stamp) {
$string .= "bgcolor=\"".$color."\"> ";
} else $string .= "> ";
$first_weekday += 1;
}
$day = mktime(0, 0, 0, date("m", $day), date("d", $day)+1, date("Y", $day));
}
$string .= "
";
$array_id = $begin_date_stamp_orig . '_' . $itemID;
$array[$user][$array_id] = $string;
} /*elseif ($item['created'] < $min_stamp) {
break;
}*/
}
}
//Obtem a lista de items do tracker por ordem decrescente de data.
if (in_array(TRACKERID_SUPPORT, $datalist)) {
$items = $tikilib->list_tracker_items(TRACKERID_SUPPORT, 0, -1, 'created_desc', '', '');
$items = $items['data']; //é necessário pois a ordenação fica ascendente mesmo com created_desc
foreach ($items as $item) {
if (($max_stamp > $item['field_values'][SUPPORT_INI]['value'] && $item['field_values'][SUPPORT_INI]['value'] > $min_stamp) || ($max_stamp > $item['field_values'][SUPPORT_END]['value'] && $item['field_values'][SUPPORT_END]['value'] > $min_stamp)
|| ($min_stamp > $item['field_values'][SUPPORT_INI]['value'] && $item['field_values'][SUPPORT_END]['value'] > $max_stamp)) {
if (isset($projectlist)) {
if(!in_array($item['field_values'][SUPPORT_PROJECT]['value'], $projectlist)) continue;
}
if (isset($userlist)) {
if(!in_array($item['field_values'][SUPPORT_USER]['value'], $userlist)) continue;
}
if (isset($statelist)) {
if(!in_array($item['status'], $statelist)) continue;
}
$color = "Red";
$user = $item['field_values'][SUPPORT_USER]['value'];
$usertd = "((UserPage".$user."|".$user.")) | ";
$begin_date_stamp_orig = $item['field_values'][SUPPORT_INI]['value'];
$begin_date_stamp = mktime(0, 0, 0, date("m", $begin_date_stamp_orig), date("d", $begin_date_stamp_orig), date("Y", $begin_date_stamp_orig));
$end_date_stamp = $item['field_values'][SUPPORT_END]['value'];
$end_date_stamp = mktime(0, 0, 0, date("m", $end_date_stamp), date("d", $end_date_stamp), date("Y", $end_date_stamp));
$itemID = $item['itemId'];
$desc = "Suporte";
$tooltip = "Responsável: ". $user . "
Projecto: " . $item['field_values'][SUPPORT_PROJECT]['value'] . "";
$name = "[tiki-view_tracker_item.php?itemId=" . $itemID . "&show=view&trackerId=".TRACKERID_SUPPORT."|" . $desc . "] | ";
$string = "" . $name . $usertd;
$day = mktime(0, 0, 0, date("m", $min_stamp), date("d", $min_stamp), date("Y", $min_stamp));
$first_weekday = date("w", $min_stamp);
for ($i = 0; $i <= $nr_days_total; $i++) {
$string .= "| = $begin_date_stamp && $day <= $end_date_stamp) {
$string .= "bgcolor=\"".$color."\"> | ";
if ($first_weekday == 6)
$first_weekday = 0;
else
$first_weekday += 1;
} else if ($first_weekday == 6) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday = 0;
} else if ($first_weekday == 0) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday += 1;
} else if (in_array($day, $array_days_off)) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday += 1;
} else {
$string .= "> ";
$first_weekday += 1;
}
$day = mktime(0, 0, 0, date("m", $day), date("d", $day)+1, date("Y", $day));
}
$string .= "
";
$array_id = $begin_date_stamp_orig . '_' . $itemID;
$array[$user][$array_id] = $string;
} /*elseif ($item['created'] < $min_stamp) {
break;
}*/
}
}
//Obtem a lista de items do tracker por ordem decrescente de data.
if (in_array(TRACKERID_RESTS, $datalist)) {
$items = $tikilib->list_tracker_items(TRACKERID_RESTS, 0, -1, 'created_desc', '', '');
$items = $items['data']; //é necessário pois a ordenação fica ascendente mesmo com created_desc
foreach ($items as $item) {
if (($max_stamp > $item['field_values'][RESTS_INI]['value'] && $item['field_values'][RESTS_INI]['value'] > $min_stamp) || ($max_stamp > $item['field_values'][RESTS_END]['value'] && $item['field_values'][RESTS_END]['value'] > $min_stamp)
|| ($min_stamp > $item['field_values'][RESTS_INI]['value'] && $item['field_values'][RESTS_END]['value'] > $max_stamp)) {
if (isset($userlist)) {
if(!in_array($item['field_values'][RESTS_USER]['value'], $userlist)) continue;
}
if (isset($statelist)) {
if(!in_array($item['status'], $statelist)) continue;
}
$color = "Gold";
$user = $item['field_values'][RESTS_USER]['value'];
$usertd = "((UserPage".$user."|".$user.")) | ";
$begin_date_stamp_orig = $item['field_values'][RESTS_INI]['value'];
$begin_date_stamp = mktime(0, 0, 0, date("m", $begin_date_stamp_orig), date("d", $begin_date_stamp_orig), date("Y", $begin_date_stamp_orig));
$end_date_stamp = $item['field_values'][RESTS_END]['value'];
$end_date_stamp = mktime(0, 0, 0, date("m", $end_date_stamp), date("d", $end_date_stamp), date("Y", $end_date_stamp));
$itemID = $item['itemId'];
$desc = "Férias";
$name = "[tiki-view_tracker_item.php?itemId=" . $itemID . "&show=view&trackerId=".TRACKERID_RESTS."|" . $desc . "] | ";
$string = "" . $name . $usertd;
$day = mktime(0, 0, 0, date("m", $min_stamp), date("d", $min_stamp), date("Y", $min_stamp));
$first_weekday = date("w", $min_stamp);
for ($i = 0; $i <= $nr_days_total; $i++) {
$string .= "| | ";
$first_weekday = 0;
} else if ($first_weekday == 0) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday += 1;
} else if (in_array($day, $array_days_off)) {
$string .= "bgcolor=\"lightyellow\"> ";
$first_weekday += 1;
} else {
if ($day >= $begin_date_stamp && $day <= $end_date_stamp) {
$string .= "bgcolor=\"".$color."\"> ";
} else $string .= "> ";
$first_weekday += 1;
}
$day = mktime(0, 0, 0, date("m", $day), date("d", $day)+1, date("Y", $day));
}
$string .= "
";
$array_id = $begin_date_stamp_orig . '_' . $itemID;
$array[$user][$array_id] = $string;
} /*elseif ($item['created'] < $min_stamp) {
break;
}*/
}
}
$teste = ksort($array);
foreach ($array as $key => $val) {
$teste = ksort($val);
$array[$key] = $val;
}
$size = count($array);
$string = "";
if ($size == 0) {
$string = "Não há tarefas entre as datas indicadas (" . date("Y-m-d", $min_stamp) . " e " . date("Y-m-d", $max_stamp) ."), para o(s) tracker(s) " . $data . ".";
} else {
foreach ($array as $key => $val) {
foreach($val as $td => $value) {
$string .= $value;
}
}
$string .= "
";
$string = $tableheader.$string;
}
return $string;
}
?>