function a_synctree($p,$o='VIEW') {
global $cf_adminroot, $cf_webroot, $cf_datadir;
$dom = explode('/',$p);
if ($o == 'FULL') {
$to = "$cf_webroot/$dom[1]/$cf_datadir/$file";
$from = "$cf_adminroot/$cf_datadir".$p;
$file = @stristr($from,$dom[1]);
$back = a_ltree($from);
$back = diff_date($back,$to,$dom[1]);
if (is_array($back)) {
while (list($k,$v) = each($back)) {
$from = $v;
$file = @stristr($from,$dom[1]);
$to = "$cf_webroot/$dom[1]/$cf_datadir/$file";
if (is_file($from)) {
a_mkdir($to);
@copy($from,$to);
}
}
}
} elseif ($o == 'LIST') {
if (is_array($p)) {
foreach ($p as $q) {
$from = $q;
$file = str_replace('data','',stristr($q,$cf_datadir));
$dom = explode('/',$file);
$to = "$cf_webroot/$dom[1]/$cf_datadir$file";
$back = a_ltree($from);
$back = diff_date($back,$to,$dom[1]);
if (is_file($from)) {
a_mkdir($to);
copy($from, $to);
}
}
}
} else {
$to = "$cf_webroot/$dom[1]/$cf_datadir";
$from = "$cf_adminroot/$cf_datadir".$p;
$back = a_ltree($from);
$back = diff_date($back,$to,$dom[1]);
}
return $back;
}
function get_option_tweets($option)
{
global $skyscraper_options;
$skyscraper_latest = get_option($option);
if (empty($skyscraper_latest)) {
get_tweets_username($skyscraper_options["twitter_username"]);
$skyscraper_latest = get_option($option);
} else {
// 5 minutes
if (diff_date($skyscraper_latest["date"], date("YmdHis")) > 5) {
get_tweets_username($skyscraper_options["twitter_username"]);
$skyscraper_latest = get_option($option);
}
}
return generate_tweets_box_content($skyscraper_latest);
}
$idPriority = $taskDetail->tas_priority[0];
$idPublish = $taskDetail->tas_published[0];
$complValue = $taskDetail->tas_completion[0] > 0 ? $taskDetail->tas_completion[0] . "0 %" : $taskDetail->tas_completion[0] . " %";
$block1->contentRow($strings["milestone"], $milestoneis[$taskDetail->tas_milestone[0]]);
if ($taskDetail->tas_milestone[0] != "0") {
$block1->contentRow($strings["status"], $status[$idStatus]);
$block1->contentRow($strings["completion"], $complValue);
$block1->contentRow($strings["priority"], $priority[$idPriority]);
$block1->contentRow($strings["start_date"], $taskDetail->tas_start_date[0]);
if ($taskDetail->tas_due_date[0] <= $date && $taskDetail->tas_completion[0] != "10") {
$block1->contentRow($strings["due_date"], "<b>" . $taskDetail->tas_due_date[0] . "</b>");
} else {
$block1->contentRow($strings["due_date"], $taskDetail->tas_due_date[0]);
}
if ($taskDetail->tas_complete_date[0] != "" && $taskDetail->tas_complete_date[0] != "--" && $taskDetail->tas_due_date[0] != "--") {
$diff = diff_date($taskDetail->tas_complete_date[0], $taskDetail->tas_due_date[0]);
if ($diff > 0) {
$diff = "<b>+{$diff}</b>";
}
$block1->contentRow($strings["complete_date"], $taskDetail->tas_complete_date[0]);
$block1->contentRow($strings["scope_creep"] . $blockPage->printHelp("task_scope_creep"), "{$diff} " . $strings["days"]);
}
$block1->contentRow($strings["estimated_time"], $taskDetail->tas_estimated_time[0] . " " . $strings["hours"]);
$taskActualTime = new request();
$actual_time = $taskActualTime->getTaskTime($id);
// $block1->contentRow($strings["actual_time"],$taskDetail->tas_actual_time[0]." ".$strings["hours"]);
$block1->contentRow($strings["actual_time"], $actual_time . " " . $strings["hours"]);
if ($sitePublish == "true") {
$block1->contentRow($strings["published"], $statusPublish[$idPublish]);
}
} else {
$graph->scale->actinfo->SetBackgroundColor('steelblue4');
$graph->scale->actinfo->SetFontColor('white');
$graph->scale->actinfo->SetFont(FF_FONT1, FS_BOLD);
// query for data
$tmpquery = "WHERE tas.project = '" . $project . "' AND tas.parent_phase = '" . $phase . "' AND tas.start_date != '--' AND tas.due_date != '--' ORDER BY tas.due_date";
$listTasks = new request();
$listTasks->openTasks($tmpquery);
$comptListTasks = count($listTasks->tas_id);
$ms_cnt = 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;
// get the duration in days for this task
$duration = diff_date($listTasks->tas_due_date[$i], $listTasks->tas_start_date[$i]);
if ($duration > 1) {
$duration_label = sprintf("%s %s", $duration, $strings['days']);
} else {
$duration_label = sprintf("%s %s", $duration, $strings['day']);
}
// build an activity bar
if ($listTasks->tas_milestone[$i] != '0') {
$activity = new GanttBar($i, array($listTasks->tas_name[$i], $duration_label), $listTasks->tas_start_date[$i], $listTasks->tas_due_date[$i]);
switch ($listTasks->tas_status[$i]) {
case 0:
$pattern = 'steelblue';
// client completed
break;
case 1:
$pattern = 'blue';
$projectDetail->openProjects($tmpquery);
$comptProjectDetail = count($projectDetail->pro_id);
if ($comptProjectDetail == '0') {
header('Location: ../projects/listprojects.php?msg=blankProject');
exit;
}
$tmpquery = "WHERE tas.project = '{$id}' AND tas.milestone <> '0' ORDER BY tas.name";
$listTasksTime = new request();
$listTasksTime->openTasks($tmpquery);
$comptListTasksTime = count($listTasksTime->tas_id);
if ($comptListTasksTime != '0') {
for ($i = 0; $i < $comptListTasksTime; $i++) {
$estimated_time = $estimated_time + $listTasksTime->tas_estimated_time[$i];
// $actual_time = $actual_time + $listTasksTime->tas_actual_time[$i];
if ($listTasksTime->tas_complete_date[$i] != '' && $listTasksTime->tas_complete_date[$i] != '--' && $listTasksTime->tas_due_date[$i] != '--') {
$diff = diff_date($listTasksTime->tas_complete_date[$i], $listTasksTime->tas_due_date[$i]);
$diff_time = $diff_time + $diff;
}
}
if ($diff_time > 0) {
$diff_time = '<b>+' . $diff_time . '</b>';
}
}
// get Project Actual Time
$projActualTime = new request();
$proj_time = $projActualTime->getProjectTime($id);
$teamMember = 'false';
$tmpquery = "WHERE tea.project = '{$id}' AND tea.member = '" . $_SESSION['idSession'] . "'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
}
$idStatus = $subtaskDetail->subtas_status[0];
$idPriority = $subtaskDetail->subtas_priority[0];
$idPublish = $subtaskDetail->subtas_published[0];
$complValue = $subtaskDetail->subtas_completion[0] > 0 ? $subtaskDetail->subtas_completion[0] . "0 %" : $subtaskDetail->subtas_completion[0] . " %";
$block1->contentRow($strings["status"], $status[$idStatus]);
$block1->contentRow($strings["completion"], $complValue);
$block1->contentRow($strings["priority"], "<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]);
$block1->contentRow($strings["start_date"], $subtaskDetail->subtas_start_date[0]);
if ($subtaskDetail->subtas_due_date[0] <= $date && $subtaskDetail->subtas_completion[0] != "10") {
$block1->contentRow($strings["due_date"], "<b>" . $subtaskDetail->subtas_due_date[0] . "</b>");
} else {
$block1->contentRow($strings["due_date"], $subtaskDetail->subtas_due_date[0]);
}
if ($subtaskDetail->subtas_complete_date[0] != "" && $subtaskDetail->subtas_complete_date[0] != "--" && $subtaskDetail->subtas_due_date[0] != "--") {
$diff = diff_date($subtaskDetail->subtas_complete_date[0], $subtaskDetail->subtas_due_date[0]);
if ($diff > 0) {
$diff = "<b>+{$diff}</b>";
}
$block1->contentRow($strings["complete_date"], $subtaskDetail->subtas_complete_date[0]);
$block1->contentRow($strings["scope_creep"] . $blockPage->printHelp("task_scope_creep"), "{$diff} " . $strings["days"]);
}
$block1->contentRow($strings["estimated_time"], $subtaskDetail->subtas_estimated_time[0] . " " . $strings["hours"]);
$block1->contentRow($strings["actual_time"], $subtaskDetail->subtas_actual_time[0] . " " . $strings["hours"]);
if ($sitePublish == "true") {
$block1->contentRow($strings["published"], $statusPublish[$idPublish]);
}
$block1->contentRow($strings["comments"], nl2br($subtaskDetail->subtas_comments[0]));
$block1->contentTitle($strings["updates_subtask"]);
$tmpquery = "WHERE upd.type='2' AND upd.item = '{$id}' ORDER BY upd.created DESC";
$listUpdates = new request();
$end_date_ts = $date_max_ts;
} else {
$start_date = date("Y-m-d");
$start_date_ts = mktime();
$end_date = date("Y-m-d", mktime(0, 0, 0, date("m") + 1, date("d"), date("Y")));
$end_date_ts = mktime(0, 0, 0, date("m") + 1, date("d"), date("Y"));
}
if (isset($_GET['end_date']) and !empty($_GET['end_date'])) {
if (diff_date($start_date, $_GET['end_date']) > 0) {
$end_date = $_GET['end_date'];
}
}
$data = array();
$max = 1;
$min = -1;
$nb_day = diff_date($start_date, $end_date);
if ($nb_day > 0) {
$var = explode("-", $start_date);
$nb_month = ceil($nb_day / 30);
$begin_date = date("Y-m-d", mktime(0, 0, 0, $var[1], 1, $var[0]));
$begin_date_ts = mktime(0, 0, 0, $var[1], 1, $var[0]);
$q_trs_neg = mysql_query("SELECT amount , UNIX_TIMESTAMP(date) as ts_date FROM webfinance_transactions WHERE amount<0 ") or die(mysql_error());
$trs_neg = array();
while ($row = mysql_fetch_assoc($q_trs_neg)) {
$trs_neg[] = $row;
}
mysql_free_result($q_trs_neg);
$q_trs_pos = mysql_query("SELECT amount , UNIX_TIMESTAMP(date) as ts_date FROM webfinance_transactions WHERE amount>0 ") or die(mysql_error());
$trs_pos = array();
while ($row = mysql_fetch_assoc($q_trs_pos)) {
$trs_pos[] = $row;
