$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();