$taskDetail->openTasks($tmpquery);
}
include '../themes/' . THEME . '/header.php';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/listprojects.php?", $strings["projects"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../projects/viewproject.php?id=" . $projectDetail->pro_id[0], $projectDetail->pro_name[0], in));
if ($task != "0") {
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/listtasks.php?project=" . $projectDetail->pro_id[0], $strings["tasks"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../tasks/viewtask.php?id=" . $taskDetail->tas_id[0], $taskDetail->tas_name[0], in));
}
$blockPage->itemBreadcrumbs($strings["unlink_files"]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
include '../includes/messages.php';
$blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->form = "saC";
$block1->openForm("../linkedcontent/deletefiles.php?project={$project}&task={$task}&action=delete&id={$id}&sendto={$sendto}&" . session_name() . "=" . session_id());
$block1->heading($strings["unlink_files"]);
$block1->openContent();
$block1->contentTitle($strings["delete_following"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE fil.id IN({$id}) ORDER BY fil.name";
$listFiles = new request();
$listFiles->openFiles($tmpquery);
$comptListFiles = count($listFiles->fil_id);
for ($i = 0; $i < $comptListFiles; $i++) {
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td>" . $listFiles->fil_name[$i] . "</td></tr>";
}
$p->set_var('priority_options', selectBox2($priority));
$p->set_var('status_options', selectBox2($status));
$p->set_var('progress_options', selectBox2($progress));
$p->set_var('duration_options', selectBox2($duration));
$p->set_var('resource_options', prj_getTeamMembersOptionList($pid));
$p->set_var('VALUE_duration', '0');
$p->set_var('VALUE_progress', '0');
$p->set_var('VALUE_start_date', date("Y/m/d"));
$p->set_var('VALUE_estimated_end_date', date("Y/m/d", mktime(0, 0, 0, date("m"), date("d") + 1, date("Y"))));
$p->parse('output', 'task');
echo $p->finish($p->get_var('output'));
} else {
$block = new block();
$msg = 'permissiondenied';
include "includes/messages.php";
$block->messagebox($msgLabel);
if ($listTasks->parent_task[$i] == 0) {
$block->heading($strings["addTask"]);
} else {
$block->heading($strings["addSubtask"]);
}
$block->openContent();
$block->contentRow('', '<input type="button" name="goback" value="' . $strings['back'] . '" onClick="history.back();">');
$block->closeContent();
$block->closeForm();
}
echo COM_siteFooter();
exit;
break;
case 'view':
// View Task
function prj_displayMyProjectTasks(&$blockPage)
{
global $_TABLES, $_CONF, $_USER, $_COOKIE, $subTaskImg, $progress, $priority, $strings, $labels, $_PRJCONF;
$limitbase = $_COOKIE['alltasksmin'];
if ($limitbase == '') {
$limitbase = 0;
}
$useThisTIDforAjax = 0;
$filterCSV = COM_applyFilter($_COOKIE['filterTasks']);
if ($blockPage == NULL or $blockPage == '') {
$blockPage = new block();
}
$block2 = new block();
if ($msg != "") {
require_once "includes/messages.php";
$blockPage->messagebox($msgLabel);
}
if (!isset($_USER['uid']) or $_USER['uid'] == "") {
$uid = 1;
} else {
$uid = $_USER['uid'];
}
//my tasks
$blockPage->bornesNumber = "2";
$block2 = new block();
$block2->form = "taP";
$block2->openForm($_CONF['site_url'] . "/nexproject/index.php?" . "#" . $block2->form . "Anchor");
$headingTitle = $strings['my_tasks'];
$headingStatusArea = '<span id="ajaxstatus_tasks" class="pluginInfo" style="display:none"> </span>';
$block2->headingToggle($headingTitle, $headingStatusArea);
$block2->borne = $blockPage->returnBorne("2");
$block2->rowsLimit = $_PRJCONF['task_block_rows'];
$lim = $limitbase * $block2->rowsLimit;
echo '<!--startMyTasks-->';
echo '<div id="divMyTasks">';
$sql = "SELECT {$_TABLES['prj_tasks']}.tid FROM {$_TABLES['prj_tasks']}, {$_TABLES['prj_task_users']}, {$_TABLES['users']} ";
$sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.uid={$uid} ";
$sql .= "AND {$_TABLES['prj_task_users']}.role='o' AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
$result = DB_query($sql);
$block2->recordsTotal = DB_numrows($result);
$lim = $limitbase * $block2->rowsLimit;
$sql = "SELECT {$_TABLES['prj_tasks']}.tid,{$_TABLES['prj_tasks']}.progress_id, {$_TABLES['prj_projects']}.name, ";
$sql .= "{$_TABLES['prj_tasks']}.priority_id, {$_TABLES['prj_tasks']}.name, {$_TABLES['prj_tasks']}.estimated_end_date, ";
$sql .= "{$_TABLES['prj_tasks']}.start_date, {$_TABLES['prj_tasks']}.pid FROM {$_TABLES['prj_tasks']}, ";
$sql .= "{$_TABLES['prj_task_users']}, {$_TABLES['users']}, {$_TABLES['prj_projects']} ";
$sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.role='o' ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_tasks']}.pid={$_TABLES['prj_projects']}.pid ";
$sql .= "AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
if ($filterCSV != '') {
$sql .= "AND {$_TABLES['prj_tasks']}.pid in ({$filterCSV})";
}
$sql .= " ORDER BY {$_TABLES['prj_tasks']}.estimated_end_date ";
$sql .= " LIMIT {$lim}, {$block2->rowsLimit} ";
$result = DB_query($sql, true);
$comptListTasks = DB_numrows($result);
if ($result == FALSE) {
//remove the filterCSV as there might be a cookie issue with it...
$sql = "SELECT {$_TABLES['prj_tasks']}.tid,{$_TABLES['prj_tasks']}.progress_id, {$_TABLES['prj_projects']}.name, ";
$sql .= "{$_TABLES['prj_tasks']}.priority_id, {$_TABLES['prj_tasks']}.name, {$_TABLES['prj_tasks']}.estimated_end_date, ";
$sql .= "{$_TABLES['prj_tasks']}.start_date, {$_TABLES['prj_tasks']}.pid FROM {$_TABLES['prj_tasks']}, ";
$sql .= "{$_TABLES['prj_task_users']}, {$_TABLES['users']}, {$_TABLES['prj_projects']} ";
$sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.role='o' ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_tasks']}.pid={$_TABLES['prj_projects']}.pid ";
$sql .= "AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
$sql .= " ORDER BY {$_TABLES['prj_tasks']}.estimated_end_date ";
$sql .= " LIMIT {$lim}, {$block2->rowsLimit} ";
$result = DB_query($sql);
$comptListTasks = DB_numrows($result);
}
if ($comptListTasks != "0") {
$block2->openResults(false);
$block2->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["project"], 3 => $strings["start_date"], 4 => $strings["estimated_end_date"]), "true");
for ($i = 0; $i < DB_numrows($result); $i++) {
list($tid, $idProgress, $projectname, $idPriority, $taskname, $estenddate, $startdate, $pid) = DB_fetchArray($result);
$full_projectname = $projectname;
$full_taskname = $taskname;
if (strlen($taskname) > 25) {
$taskname = substr($taskname, 0, 25) . "....";
}
if (strlen($projectname) > 20) {
$projectname = substr($projectname, 0, 20) . "....";
}
$block2->openRow();
//$block2->checkboxRow($pid);
$block2->cellProgress($progress[$idProgress]);
$block2->cellRow($blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?mode=view&id={$tid}", $taskname, "mytaskcontext", $full_taskname, '', $tid));
$block2->cellRow($priority[$idPriority]);
$block2->cellRow($blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?pid={$pid}", $projectname, "context", $full_projectname, $pid));
$block2->cellRow(strftime("%Y/%m/%d", $startdate));
$block2->cellRow(strftime("%Y/%m/%d", $estenddate));
$block2->closeRow();
}
$block2->closeResults();
$pages = intval($block2->recordsTotal / $block2->rowsLimit);
if (fmod($block2->recordsTotal, $block2->rowsLimit) > 0) {
$pages += 1;
}
if ($pages > 1) {
for ($pagecntr = 0; $pagecntr < $pages; $pagecntr++) {
echo '<span style="text-decoration:underline;cursor: hand" onclick=\'setCookie("alltasksmin","';
echo $pagecntr;
echo '","","");prj_getMyTasks("myprj_refresh", "' . $useThisTIDforAjax . '" )\'>';
if ($limitbase == $pagecntr) {
echo '<span style="color:red">';
echo $pagecntr + 1;
echo '</span>';
} else {
echo $pagecntr + 1;
}
echo '</span> ';
}
echo ' <span style="text-decoration:underline;cursor: hand" TITLE="Return to page 1" onclick=\'setCookie("alltasksmin","","","");prj_getMyTasks("myprj_refresh", "' . $useThisTIDforAjax . '" )\'>';
echo '<<</span>';
}
} else {
$block2->noresults();
}
echo '</div>';
echo '<!--endMyTasks-->';
echo '<input type=hidden name=pid value=' . $pid . '>';
$block2->closeToggle();
$block2->closeFormResults();
}
break;
default:
}
/* Show Custom list of Blocks */
echo COM_siteHeader(array('custom_showBlocks', $_PRJCONF['leftblocks']));
echo '<table cellpadding="0" cellspacing="0" border="0" width="100%"><tr style="vertical-align:top"><td nowrap>';
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink($_CONF['site_url'] . "/nexproject/index.php?", $strings["home"], in));
$blockPage->itemBreadcrumbs($strings["projects"]);
$blockPage->closeBreadcrumbs();
echo '</td></tr></table>';
/* BL: Oct 6, 2004: Not used currently */
if (isset($msg) and $msg != "") {
include "includes/messages.php";
$blockPage->messagebox($msg);
}
$blockPage->bornesNumber = "1";
/* Display the 'All Projects' Block */
prj_displayAllProjects($blockPage);
//gantt chart display area starts here
$blockPage->bornesNumber = "4";
$blockg = new block();
$blockg->form = "gaP";
$headingTitle = 'Gantt Chart';
$headingStatusArea = '<span id="ajaxstatus_gantt" class="pluginInfo" style="display:none"> </span>';
$blockg->headingToggle($headingTitle, $headingStatusArea);
if (isset($_COOKIE['gdate1'])) {
$gdate1 = $_COOKIE['gdate1'];
} else {
if (isset($_GET['gdate1']) and $_GET['gdate1'] != '') {
