$block7->closeFormResults();
$block7->openPaletteScript();
$block7->paletteScript(0, "info", "../phases/viewphase.php?", "false,true,true", $strings["view"]);
if ($teamMember == "true" || $_SESSION['profilSession'] == "5") {
if ($_SESSION['idSession'] == $projectDetail->pro_owner[0] || $_SESSION['profilSession'] == "0" || $_SESSION['profilSession'] == "5") {
$block7->paletteScript(1, "edit", "../phases/editphase.php?", "false,true,true", $strings["edit"]);
}
}
$block7->closePaletteScript($comptListPhases, $listPhases->pha_id);
}
$block2 = new block();
$block2->form = 'wbTuuO';
$block2->openForm("../phases/listphases.php?id={$id}#" . $block2->form . "Anchor");
$block2->sorting('project_tasks', $sortingUser->sor_project_tasks[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'tas.parent_phase', 'mem.login', 'tas.published'));
$blockPage = new block();
$block2->borne = $blockPage->returnBorne('1');
$block2->rowsLimit = '20';
$tmpquery = "WHERE tas.project = '{$id}' AND tas.status IN(0,2,3) AND tas.milestone = '1' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery);
$listTasks = new request();
$listTasks->openTasks($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTasks = count($listTasks->tas_id);
$block2->headingToggle($strings['tasks_open'] . ' <span class=addition>(' . $comptListTasks . ')</span>');
$block2->openPaletteIcon();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$block2->paletteIcon(0, 'add', $strings['add']);
$block2->paletteIcon(1, 'remove', $strings['delete']);
$block2->paletteIcon(2, 'copy', $strings['copy']);
// $block2->paletteIcon(3,'export',$strings['export']);
if ($sitePublish == 'true') {
$block2->paletteIcon(4, 'add_projectsite', $strings['add_project_site']);
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();
}
$ld = $date;
}
$block1->contentRow($strings['date'], "<input type=\"text\" style=\"width: 150px;\" name=\"ld\" id=\"sel1\"\r\n\tsize=\"20\" value=\"{$ld}\"><button type=\"reset\" id=\"trigger_a\">...</button>\r\n\t<script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>");
echo "\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'>" . $strings["worked_hours"] . " :</td>\r\n\t <td><input size='20' value='{$hr}' style='width: 150px;' name='hr' maxlength='6' type='text'></td>\r\n\t</tr>\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'>" . $strings["comments"] . " :</td>\r\n\t <td><textarea rows='10' style='width: 400px; height: 150px;' name='comm' cols='47'>{$comm}</textarea></td>\r\n\t</tr>\r\n\t<tr class='odd'>\r\n\t <td valign='top' class='leftvalue'> </td>\r\n\t <td><input type='SUBMIT' value='" . $strings["save"] . "'></td>\r\n\t</tr>";
$block1->closeContent();
$block1->block_close();
$block1->closeForm();
$block2 = new block();
$block2->form = "ahT";
$block2->openForm("../tasks/addtasktime.php?id={$id}#" . $block2->form . "Anchor");
$block2->heading($strings["task_time"] . ' : ' . $strings["details"]);
$block2->openPaletteIcon();
$block2->paletteIcon(0, "remove", $strings["delete"]);
$block2->paletteIcon(1, "edit", $strings["edit"]);
$block2->closePaletteIcon();
$block2->borne = $blockPage->returnBorne("1");
$block2->rowsLimit = "20";
$block2->sorting('tasks_time', $sortingUser->sor_tasks_time[0], 'tim.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'tim.date', 2 => 'tim.hours', 3 => 'tim.created', 4 => 'tim.modified', 5 => 'tim.comments'));
$tmpquery = "WHERE tim.task = '{$id}' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest["tasks_time"] . " " . $tmpquery);
$listTaskTimes = new request();
$listTaskTimes->openTaskTime($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTaskTimes = count($listTaskTimes->tim_id);
if ($comptListTaskTimes != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["owner"], 1 => $strings["date"], 2 => ucfirst($strings["hours"]), 3 => $strings["created"], 4 => $strings["modified"], 5 => $strings['comment']), "true");
// display logged hours for project
for ($i = 0; $i < $comptListTaskTimes; $i++) {
// only PM, PMA, and OWNERS can modify/delete
if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listTaskTimes->tim_owner[$i]) {
$block2->openRow($listTaskTimes->tim_id[$i]);
$searchNotes .= " OR LOWER(note.description) like '%{$mots['0']}%'";
$y = 1;
while ($y < $nombre_mots) {
$searchNotes .= " OR LOWER(note.description) like '%{$mots[$y]}%' ";
$y++;
}
//--- header ----
$bodyCommand = "onLoad=\"document.searchForm.searchfor.focus()\"";
$pageSection = 'search';
require_once "../themes/" . THEME . "/header.php";
$breadcrumbs[] = buildLink("../search/createsearch.php?", $strings["search"], LINK_INSIDE);
$breadcrumbs[] = $strings["search_results"];
//--- content ---
$block1 = new block();
$blockPage = new block();
$block1->borne = $blockPage->returnBorne("1");
$block1->rowsLimit = "10";
$block1->sorting("projects", $sortingUser->sor_projects[0], "pro.name ASC", $sortingFields = array(0 => "pro.id", 1 => "pro.name", 2 => "pro.priority", 3 => "org.name", 4 => "pro.status", 5 => "mem.login", 6 => "pro.published"));
if ($projectsFilter == "true") {
$tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id ";
$tmpquery .= "{$searchProjects} AND teams.member = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}";
} else {
$tmpquery = "{$searchProjects} ORDER BY {$block1->sortingValue}";
}
$comptListProjects = "0";
if ($validProjects == "true") {
$block1->recordsTotal = compt($initrequest["projects"] . " " . $tmpquery);
$listProjects = new request();
$listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListProjects = count($listProjects->pro_id);
// echo "$tmpquery<br>";
$blockPage->bornesNumber = '1';
$block1 = new block();
$block1->form = 'clientList';
$block1->openForm('../clients/listclients.php#' . $block1->form . 'Anchor');
$block1->heading($strings['organizations']);
$block1->openPaletteIcon();
if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') {
$block1->paletteIcon(0, 'add', $strings['add']);
$block1->paletteIcon(1, 'remove', $strings['delete']);
}
$block1->paletteIcon(2, 'info', $strings['view']);
if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') {
$block1->paletteIcon(3, 'edit', $strings['edit']);
}
$block1->closePaletteIcon();
$block1->borne = $blockPage->returnBorne('1');
$block1->rowsLimit = '50';
$block1->sorting('organizations', $sortingUser->sor_organizations[0], 'org.name ASC', $sortingFields = array(0 => 'org.name', 1 => 'org.phone', 2 => 'org.url'));
if ($clientsFilter == 'true' && $_SESSION['profilSession'] == '2') {
$teamMember = 'false';
$tmpquery = "WHERE tea.member = '" . $_SESSION['idSession'] . "'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
if ($comptMemberTest == '0') {
$listClients = 'false';
} else {
for ($i = 0; $i < $comptMemberTest; $i++) {
$clientsOk .= $memberTest->tea_org2_id[$i];
if ($comptMemberTest - 1 != $i) {
$clientsOk .= ',';
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
if ($_SESSION['idSession'] == $projectDetail->pro_owner[0] || $_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '5') {
$block7->paletteScript(1, 'edit', '../phases/editphase.php', 'false,true,true', $strings['edit']);
}
}
$block7->closePaletteScript($comptListPhases, $listPhases->pha_id);
}
$block2 = new block();
$block2->form = 'wbTuuO';
$block2->openForm('../projects/viewproject.php?id=' . $projectDetail->pro_id[0] . '#' . $block2->form . 'Anchor');
if (isset($flag_phases) && $flag_phases == true) {
$block2->sorting('project_tasks', $sortingUser->sor_project_tasks[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'tas.parent_phase', 'mem.login', 'tas.published'));
} else {
$block2->sorting('project_tasks', $sortingUser->sor_project_tasks[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'mem.login', 'tas.published'));
}
$block2->borne = $blockPage->returnBorne('1');
$block2->rowsLimit = '20';
$tmpquery = "WHERE tas.project = '{$id}' AND tas.status IN(0,2,3) AND tas.milestone = '1' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery);
$listTasks = new request();
$listTasks->openTasks($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTasks = count($listTasks->tas_id);
$block2->headingToggle($strings['tasks_open'] . ' <span class=addition>(' . $comptListTasks . ')</span>');
$block2->openPaletteIcon();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$block2->paletteIcon(0, 'add', $strings['add']);
$block2->paletteIcon(1, 'remove', $strings['delete']);
$block2->paletteIcon(2, 'copy', $strings['copy']);
// $block2->paletteIcon(3,'export',$strings['export']);
if ($sitePublish == 'true') {
$block2->paletteIcon(4, 'add_projectsite', $strings['add_project_site']);
// if phases are enabled grab phase data
if ($projectDetail->pro_phase_set[0] != '0') {
$flag_phases = true;
$tmpquery = "WHERE pha.project_id = '{$project}'";
$listPhases = new request();
$listPhases->openPhases($tmpquery);
}
$block2 = new block();
$block2->form = 'saTlO';
$block2->openForm("../tasks/listtasks.php?project={$project}#" . $block2->form . "Anchor");
if (isset($flag_phases) && $flag_phases == true) {
$block2->sorting('tasks', $sortingUser->sor_tasks[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'tas.parent_phase', 'mem.login', 'tas.published'));
} else {
$block2->sorting('tasks', $sortingUser->sor_tasks[0], 'tas.due_date ASC', $sortingFields = array('tas.priority', 'tas.name', 'tas.status', 'tas.completion', 'tas.due_date', 'mem.login', 'tas.published'));
}
$block2->borne = $blockPage->returnBorne('1');
$block2->rowsLimit = '50';
$tmpquery = "WHERE tas.project = '{$project}' AND tas.status IN(0,2,3,5) AND tas.milestone = '1' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery);
$listOpenTasks = new request();
$listOpenTasks->openTasks($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTasks = count($listOpenTasks->tas_id);
$block2->headingToggle($strings['tasks_open'] . ' <span class=addition>(' . $comptListTasks . ')</span>');
$block2->openPaletteIcon();
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$block2->paletteIcon(0, 'add', $strings['add']);
$block2->paletteIcon(1, 'remove', $strings['delete']);
$block2->paletteIcon(2, 'copy', $strings['copy']);
// $block2->paletteIcon(3,'export',$strings['export']);
if ($sitePublish == 'true') {
$block2->paletteIcon(4, 'add_projectsite', $strings['add_project_site']);
$tmpquery = "WHERE newscom.post_id = '" . fixInt($id) . "'";
$newsComments = new request();
$newsComments->openNewsDeskComments($tmpquery);
$comptCommentsDetail = count($newsComments->newscom_id);
$block2 = new block();
$block2->form = "clPrc";
$block2->openForm("../newsdesk/viewnews.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block2->form . "Anchor");
$block2->headingToggle($strings["comments"]);
$block2->openPaletteIcon();
$block2->paletteIcon(0, "add", $strings["add_newsdesk_comment"]);
$block2->paletteIcon(1, "edit", $strings["edit_newsdesk_comment"]);
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
$block2->paletteIcon(2, "remove", $strings["del_newsdesk_comment"]);
}
$block2->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("2");
$block2->openContent();
if ($comptCommentsDetail != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["name"], 1 => $strings["comment"]), "true");
for ($i = 0; $i < $comptCommentsDetail; $i++) {
$tmpquery_user = "******" . $newsComments->newscom_name[$i] . "' ";
$newsAuthor = new request();
$newsAuthor->openMembers($tmpquery_user);
$block2->openRow();
$block2->checkboxRow($newsComments->newscom_id[$i]);
$block2->cellRow($newsAuthor->mem_name[0]);
$block2->cellRow($newsComments->newscom_comment[$i]);
$block2->closeRow();
}
$block2->closeResults();
