$listHours->connectClass(); $listHours->query($tmpquery); $totalHours = 0; $theor_weekly_hours = $work_package[PROJECT_WEEKLY_HOURS]; //$project_begin=new DateTime($work_package[PROJECT_BEGIN]); $project_begin = $work_package[PROJECT_BEGIN]; //echo $work_package[PROJECT_BEGIN]; //$project_now=new DateTime(); $project_now = "NOW"; //$project_duration_interval=date_diff($project_begin,$project_now); //$project_duration=($project_duration_interval->format("%d")); $project_duration_interval = date_diff_outdated($project_begin, $project_now, "w"); //echo $project_duration; //echo $project_duration_interval; while ($row = $listHours->fetch()) { $block2->openRow($db_date_index); $block2->cellRow(""); $block2->cellRow("{$row[0]} > {$row[1]}"); $block2->cellRow("{$row[2]}"); $block2->closeRow(); $totalHours += intval($row[2]); } $pract_weekly_hours = round($totalHours / $project_duration_interval, 2); $theor_total_hours = round($theor_weekly_hours * $project_duration_interval, 2); $block2->openRow($db_date_index); $block2->cellRow(""); $block2->cellRow("Total"); $block2->cellRow("{$totalHours} (theor: {$theor_total_hours}) > {$pract_weekly_hours} hours weekly (theor: {$theor_weekly_hours})"); $block2->closeRow(); } $projectsList = rtrim($projectsList, ",");
$listAttachments = new request(); $listAttachments->openMeetingsAttachment($tmpquery); $comptListFiles = count($listAttachments->mat_id); if ($comptListFiles != "0") { $block2->openResults(); $block2->labels($labels = array(0 => $strings["type"], 1 => $strings["name"], 2 => $strings["date"], 3 => $strings["approval_tracking"], 4 => $strings["published"]), "true"); require_once "../includes/files_types.php"; for ($i = 0; $i < $comptListFiles; $i++) { $existFile = "false"; $idStatus = $listAttachments->mat_status[$i]; $idPublish = $listAttachments->mat_published[$i]; $type = file_info_type($listAttachments->mat_extension[$i]); if (file_exists("../files/" . $listAttachments->mat_project[$i] . "/meetings/" . $listAttachments->mat_meeting[$i] . "/" . $listAttachments->mat_name[$i])) { $existFile = "true"; } $block2->openRow($listAttachments->mat_id[$i]); $block2->checkboxRow($listAttachments->mat_id[$i]); if ($existFile == "true") { $block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $type, icone)); } else { $block2->cellRow(" "); } if ($existFile == "true") { $block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $listAttachments->mat_name[$i], LINK_INSIDE)); } else { $block2->cellRow($strings["missing_file"] . " (" . $listAttachments->mat_name[$i] . ")"); } $block2->cellRow($listAttachments->mat_date[$i]); $block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $statusFile[$idStatus], LINK_INSIDE)); if ($sitePublish == "true") { $block2->cellRow($statusPublish[$idPublish]);
$block10->paletteIcon(7, 'edit', $strings['edit']); $block10->paletteIcon(8, 'timelog', $strings['loghours']); } $block10->closePaletteIcon(); if ($comptListTasks != '0') { $block10->openResults(); $block10->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['phase'], $strings['assigned_to'], $strings['published']), 'true'); for ($i = 0; $i < $comptListTasks; $i++) { if ($listTasks->tas_due_date[$i] == '') { $listTasks->tas_due_date[$i] = $strings['none']; } $idStatus = $listTasks->tas_status[$i]; $idPriority = $listTasks->tas_priority[$i]; $idPublish = $listTasks->tas_published[$i]; $complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . '0 %' : $listTasks->tas_completion[$i] . ' %'; $block10->openRow($listTasks->tas_id[$i]); $block10->checkboxRow($listTasks->tas_id[$i]); //--- id ---- #$block10->cellRow(buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_id[$i], LINK_INSIDE)); //--- prio --- $block10->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">', '1%', true); //--- name ---- if ($idStatus == 1) { $block10->cellRow(buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_STRIKE), "99%"); } else { $block10->cellRow(buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_INSIDE), "99%"); } //--- status ---- $block10->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true); //--- complete ---- $block10->cellRow($complValue);
$block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->closePaletteIcon(); $block1->sorting("team", $sortingUser->sor_team[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected", 5 => "tea.published")); $tmpquery = "WHERE tea.project = '{$id}' AND mem.profil != '3' ORDER BY {$block1->sortingValue}"; $listTeam = new request(); $listTeam->openTeams($tmpquery); $comptListTeam = count($listTeam->tea_id); $block1->openResults(); $block1->labels($labels = array(0 => $strings["full_name"], 1 => $strings["title"], 2 => $strings["user_name"], 3 => $strings["work_phone"], 4 => $strings["connected"], 5 => $strings["published"]), "true"); for ($i = 0; $i < $comptListTeam; $i++) { if ($listTeam->tea_mem_phone_work[$i] == "") { $listTeam->tea_mem_phone_work[$i] = $strings["none"]; } $idPublish = $listTeam->tea_published[$i]; $block1->openRow($listTeam->tea_mem_id[$i]); $block1->checkboxRow($listTeam->tea_mem_id[$i]); $block1->cellRow(buildLink("../users/viewuser.php?id=" . $listTeam->tea_mem_id[$i], $listTeam->tea_mem_name[$i], LINK_INSIDE)); $block1->cellRow($listTeam->tea_mem_title[$i]); $block1->cellRow(buildLink($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_login[$i], LINK_MAIL)); $block1->cellRow($listTeam->tea_mem_phone_work[$i]); if ($listTeam->tea_log_connected[$i] > $dateunix - 5 * 60) { $block1->cellRow($strings["yes"] . " " . $z); } else { $block1->cellRow($strings["no"]); } if ($sitePublish == "true") { $block1->cellRow($statusPublish[$idPublish]); } $block1->closeRow(); }
$block2->borne = $blockPage->returnBorne("1"); $block2->rowsLimit = "20"; $block2->sorting('meetings_time', $sortingUser->sor_meetings_time[0], 'mti.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mti.date', 2 => 'mti.hours', 3 => 'mti.created', 4 => 'mti.modified', 5 => 'mti.comments')); $tmpquery = "WHERE mti.meeting = '{$id}' ORDER BY {$block2->sortingValue}"; $block2->recordsTotal = compt($initrequest["meetings_time"] . " " . $tmpquery); $listMeetingTimes = new request(); $listMeetingTimes->openMeetingTime($tmpquery, $block2->borne, $block2->rowsLimit); $comptListMeetingTimes = count($listMeetingTimes->mti_id); if ($comptListMeetingTimes != "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 < $comptListMeetingTimes; $i++) { // only PM, PMA, and OWNERS can modify/delete if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listMeetingTimes->mti_owner[$i]) { $block2->openRow($listMeetingTimes->mti_id[$i]); $block2->checkboxRow($listMeetingTimes->mti_id[$i], 'true'); $block2->cellRow($listMeetingTimes->mti_mem_name[$i]); $block2->cellRow($listMeetingTimes->mti_date[$i]); $block2->cellRow($listMeetingTimes->mti_hours[$i]); $block2->cellRow($listMeetingTimes->mti_created[$i]); $block2->cellRow($listMeetingTimes->mti_modified[$i]); // truncate large comments to keep the display clean $comments = $listMeetingTimes->mti_comments[$i]; $lenComm = 40; if (strLen($comments) > $lenComm) { $comments = substr($listMeetingTimes->mti_comments[$i], 0, $lenComm) . ' ...'; } $block2->cellRow($comments); $block2->closeRow(); }
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(); }
$block1->openForm("../clients/listclients.php#" . $block1->form . "Anchor"); $block1->heading($strings["organizations"]); $block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->closePaletteIcon(); $block1->sorting("organizations", $sortingUser->sor_organizations[0], "org.name ASC", $sortingFields = array(0 => "org.name", 1 => "org.phone", 2 => "org.url")); $tmpquery = "WHERE org.id != '1' ORDER BY {$block1->sortingValue}"; $listOrganizations = new request(); $listOrganizations->openOrganizations($tmpquery); $comptListOrganizations = count($listOrganizations->org_id); if ($comptListOrganizations != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false"); for ($i = 0; $i < $comptListOrganizations; $i++) { $block1->openRow($listOrganizations->org_id[$i]); $block1->checkboxRow($listOrganizations->org_id[$i]); $block1->cellRow(buildLink("../clients/viewclient.php?id=" . $listOrganizations->org_id[$i], $listOrganizations->org_name[$i], LINK_INSIDE)); $block1->cellRow($listOrganizations->org_phone[$i]); $block1->cellRow(buildLink($listOrganizations->org_url[$i], $listOrganizations->org_url[$i], LINK_OUT)); $block1->closeRow(); } $block1->closeResults(); } else { $block1->noresults(); } $block1->closeFormResults(); $block1->openPaletteScript(); $block1->paletteScript(0, "add", "../clients/editclient.php?", "true,false,false", $strings["add"]); $block1->paletteScript(1, "remove", "../clients/deleteclients.php?", "false,true,true", $strings["delete"]); $block1->closePaletteScript($comptListOrganizations, $listOrganizations->org_id);
$block5->recordsTotal = DB_numrows($result); $sql = "SELECT {$_TABLES['gf_topic']}.id,{$_TABLES['gf_topic']}.pid,"; $sql .= "{$_TABLES['gf_topic']}.subject,{$_TABLES['users']}.fullname,"; $sql .= "{$_TABLES['gf_topic']}.lastupdated,{$_TABLES['gf_topic']}.replies "; $sql .= "FROM {$_TABLES['gf_topic']}, {$_TABLES['users']} "; $sql .= "WHERE forum={$A['fid']} AND pid=0 "; $sql .= "AND {$_TABLES['gf_topic']}.uid={$_TABLES['users']}.uid "; $sql .= "ORDER BY {$block5->sortingValue} LIMIT {$block5->borne},{$block5->rowsLimit}"; $result = DB_query($sql); $comptListTasks = DB_numrows($result); if ($comptListTasks != "0") { $block5->openResults(); $block5->labels($labels = array(0 => $strings["Subject"], 1 => $strings["Author"], 2 => $strings["lastUpdated"], 3 => $strings["Replies"]), "true"); for ($i = 0; $i < $comptListTasks; $i++) { list($listForum->topic[$i], $parent, $listForum->subject[$i], $listForum->author[$i], $listForum->date[$i], $listForum->replies[$i]) = DB_fetchArray($result); $block5->openRow(); $block5->checkboxRow($listForum->topic[$i]); $block5->cellRow($blockPage->buildLink($_CONF['site_url'] . "/forum/viewtopic.php?forum=" . $A[fid] . "&showtopic=" . $listForum->topic[$i], $listForum->subject[$i], "in", 'Click to View Discussion')); $block5->cellRow($listForum->author[$i]); $block5->cellRow(strftime("%Y/%m/%d %H:%M", $listForum->date[$i])); $block5->cellRow($listForum->replies[$i]); $block5->closeRow(); } $block5->closeResults(); $block5->bornesFooter("5", $blockPage->bornesNumber, "", "pid={$pid}"); } else { $block5->noresults(); } echo '<input type="hidden" name="pid" value="' . $pid . '">'; $block5->closeToggle(); $block5->closeFormResults();
if ($comptListTasks != '0') { $block3->openResults(); if (isset($flag_phases) && $flag_phases == true) { $block3->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['phase'], $strings['assigned_to'], $strings['published']), 'true'); } else { $block3->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['assigned_to'], $strings['published']), 'true'); } for ($i = 0; $i < $comptListTasks; $i++) { if ($listClosedTasks->tas_due_date[$i] == '') { $listClosedTasks->tas_due_date[$i] = $strings['none']; } $idStatus = $listClosedTasks->tas_status[$i]; $idPriority = $listClosedTasks->tas_priority[$i]; $idPublish = $listClosedTasks->tas_published[$i]; $complValue = $listClosedTasks->tas_completion[$i] > 0 ? $listClosedTasks->tas_completion[$i] . '0 %' : $listClosedTasks->tas_completion[$i] . ' %'; $block3->openRow($listClosedTasks->tas_id[$i]); $block3->checkboxRow($listClosedTasks->tas_id[$i]); //--- id ---- #$block3->cellRow(buildLink("../tasks/viewtask.php?id=" . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_id[$i], LINK_INSIDE)); //--- prio --- $block3->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">', '1%', true); //--- name ---- if ($idStatus == 1 or $idStatus == 6) { $block3->cellRow(buildLink('../tasks/viewtask.php?id=' . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_name[$i], LINK_STRIKE), "99%"); } else { $block3->cellRow(buildLink('../tasks/viewtask.php?id=' . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_name[$i], LINK_INSIDE), "99%"); } //--- status ---- $block3->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true); //--- complete ---- $block3->cellRow($complValue);
$tmpquery = "WHERE subtas.task = '{$id}' ORDER BY {$block4->sortingValue}"; $listSubtasks = new request(); $listSubtasks->openSubtasks($tmpquery); $comptListSubtasks = count($listSubtasks->subtas_id); if ($comptListSubtasks != "0") { $block4->openResults(); $block4->labels($labels = array(0 => $strings["subtask"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["completion"], 4 => $strings["due_date"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true"); for ($i = 0; $i < $comptListSubtasks; $i++) { if ($listSubtasks->subtas_due_date[$i] == "") { $listSubtasks->subtas_due_date[$i] = $strings["none"]; } $idStatus = $listSubtasks->subtas_status[$i]; $idPriority = $listSubtasks->subtas_priority[$i]; $idPublish = $listSubtasks->subtas_published[$i]; $complValue = $listSubtasks->subtas_completion[$i] > 0 ? $listSubtasks->subtas_completion[$i] . "0 %" : $listSubtasks->subtas_completion[$i] . " %"; $block4->openRow(); $block4->checkboxRow($listSubtasks->subtas_id[$i]); $block4->cellRow($blockPage->buildLink("../subtasks/viewsubtask.php?id=" . $listSubtasks->subtas_id[$i] . "&task={$id}", $listSubtasks->subtas_name[$i], in)); $block4->cellRow("<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]); $block4->cellRow($status[$idStatus]); $block4->cellRow($complValue); if ($listSubtasks->subtas_due_date[$i] <= $date && $listSubtasks->subtas_completion[$i] != "10") { $block4->cellRow("<b>" . $listSubtasks->subtas_due_date[$i] . "</b>"); } else { $block4->cellRow($listSubtasks->subtas_due_date[$i]); } if ($listSubtasks->subtas_start_date[$i] != "--" && $listSubtasks->subtas_due_date[$i] != "--") { $gantt = "true"; } if ($listSubtasks->subtas_assigned_to[$i] == "0") { $block4->cellRow($strings["unassigned"]);
} else { $tmpquery = "WHERE boo.shared = '1' OR boo.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}"; } } $listBookmarks = new request(); $listBookmarks->openBookmarks($tmpquery); $comptListBookmarks = count($listBookmarks->boo_id); if ($comptListBookmarks != '0') { $block1->openResults(); if ($view == 'my') { $block1->labels($labels = array(0 => $strings['name'], 1 => $strings['bookmark_category'], 2 => $strings['shared']), 'false'); } else { $block1->labels($labels = array(0 => $strings['name'], 1 => $strings['bookmark_category'], 2 => $strings['owner']), 'false'); } for ($i = 0; $i < $comptListBookmarks; $i++) { $block1->openRow($listBookmarks->boo_id[$i]); $block1->checkboxRow($listBookmarks->boo_id[$i]); $block1->cellRow(buildLink('../bookmarks/viewbookmark.php?view=' . $view . '&id=' . $listBookmarks->boo_id[$i], $listBookmarks->boo_name[$i], LINK_INSIDE) . ' ' . buildLink($listBookmarks->boo_url[$i], '(' . $strings['url'] . ')', LINK_OUT)); $block1->cellRow($listBookmarks->boo_boocat_name[$i]); if ($view == 'my') { if ($listBookmarks->boo_shared[$i] == '1') { $printShared = $strings['yes']; } else { $printShared = $strings['no']; } $block1->cellRow($printShared); } else { $block1->cellRow(buildLink($listBookmarks->boo_mem_email_work[$i], $listBookmarks->boo_mem_login[$i], LINK_MAIL)); } $block1->closeRow(); }
$tmpquery = "WHERE tas.project = '{$id}'"; $countPhaseTasks = new request(); $countPhaseTasks->openTasks($tmpquery); $comptlistTasks = count($countPhaseTasks->tas_id); for ($i = 0; $i < $comptListPhases; $i++) { $comptlistTasksRow = "0"; $comptUncompleteTasks = "0"; for ($k = 0; $k < $comptlistTasks; $k++) { if ($listPhases->pha_order_num[$i] == $countPhaseTasks->tas_parent_phase[$k]) { $comptlistTasksRow = $comptlistTasksRow + 1; if ($countPhaseTasks->tas_status[$k] == "2" || $countPhaseTasks->tas_status[$k] == "3" || $countPhaseTasks->tas_status[$k] == "4") { $comptUncompleteTasks = $comptUncompleteTasks + 1; } } } $block7->openRow(); $block7->checkboxRow($listPhases->pha_id[$i]); $block7->cellRow($listPhases->pha_order_num[$i]); $block7->cellRow($blockPage->buildLink("../phases/viewphase.php?id=" . $listPhases->pha_id[$i], $listPhases->pha_name[$i], in)); $block7->cellRow($comptlistTasksRow); $block7->cellRow($comptUncompleteTasks); $block7->cellRow($phaseStatus[$listPhases->pha_status[$i]]); $block7->cellRow($listPhases->pha_date_start[$i]); $block7->cellRow($listPhases->pha_date_end[$i]); $block7->closeRow(); } $block7->closeResults(); } else { $block7->noresults(); } $block7->closeToggle();
$block1->heading($strings["service_management"]); $block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->paletteIcon(2, "info", $strings["view"]); $block1->paletteIcon(3, "edit", $strings["edit"]); $block1->closePaletteIcon(); $tmpquery = "ORDER BY serv.name ASC"; $listServices = new request(); $listServices->openServices($tmpquery); $comptListServices = count($listServices->serv_id); if ($comptListServices != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["hourly_rate"]), "false", $sorting = "false", $sortingOff = array(0 => "0", 1 => "ASC")); for ($i = 0; $i < $comptListServices; $i++) { $block1->openRow($listServices->serv_id[$i]); $block1->checkboxRow($listServices->serv_id[$i]); $block1->cellRow(buildLink("../services/viewservice.php?id=" . $listServices->serv_id[$i], $listServices->serv_name[$i], LINK_INSIDE)); $block1->cellRow($listServices->serv_hourly_rate[$i]); $block1->closeRow(); } $block1->closeResults(); } else { $block1->noresults(); } $block1->closeFormResults(); $block1->openPaletteScript(); $block1->paletteScript(0, "add", "../services/editservice.php?", "true,true,true", $strings["add"]); $block1->paletteScript(1, "remove", "../services/deleteservices.php?", "false,true,true", $strings["delete"]); $block1->paletteScript(2, "info", "../services/viewservice.php?", "false,true,false", $strings["view"]); $block1->paletteScript(3, "edit", "../services/editservice.php?", "false,true,false", $strings["edit"]);
} } $block1->recordsTotal = compt($initrequest['projects'] . ' ' . $tmpquery); $listProjects = new request(); $listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit); $comptListProjects = count($listProjects->pro_id); if ($comptListProjects != 0) { $block1->openResults(); $block1->labels($labels = array("P", $strings['project'], $strings['organization'], $strings['status'], $strings['owner'], $strings['project_site']), 'true'); for ($i = 0; $i < $comptListProjects; $i++) { if ($listProjects->pro_org_id[$i] == 1) { $listProjects->pro_org_name[$i] = $strings['none']; } $idStatus = $listProjects->pro_status[$i]; $idPriority = $listProjects->pro_priority[$i]; $block1->openRow($listProjects->pro_id[$i]); $block1->checkboxRow($listProjects->pro_id[$i]); //--- id --- //$block1->cellRow(buildLink('../projects/viewproject.php?id=' . $listProjects->pro_id[$i], $listProjects->pro_id[$i], LINK_INSIDE)); //--- prio ---- $block1->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" title="' . $priority[$idPriority] . '">', "1", true); //--- name --- $block1->cellRow(buildLink('../projects/viewproject.php?id=' . $listProjects->pro_id[$i], $listProjects->pro_name[$i], LINK_INSIDE), "30"); //--- client ---- $block1->cellRow($listProjects->pro_org_name[$i]); //--- status --- $block1->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true); //--- owner ---- $block1->cellRow(buildLink($listProjects->pro_mem_email_work[$i], $listProjects->pro_mem_login[$i], LINK_MAIL), false, true); //--- project-site ------ if ($sitePublish == 'true') {
$block1->sorting("calendar", $sortingUser->sor_calendar[0], "cal.date_end DESC", $sortingFields = array(0 => "cal.shortname", 1 => "cal.subject", 2 => "cal.date_start", 3 => "cal.date_end")); $dayRecurr = _dayOfWeek(mktime(12, 12, 12, $month, $day, $year)); if ($viewCalend == 0) { $tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' AND ((cal.date_start <= '{$dateCalend}' AND cal.date_end >= '{$dateCalend}' AND cal.recurring = '0') OR ((cal.date_start <= '{$dateCalend}' AND cal.date_end <= '{$dateCalend}') AND cal.recurring = '1' AND cal.recur_day = '{$dayRecurr}')) ORDER BY cal.shortname"; } else { $tmpquery = "WHERE cal.project = '{$viewCalend}' AND ((cal.date_start <= '{$dateCalend}' AND cal.date_end >= '{$dateCalend}' AND cal.recurring = '0') OR ((cal.date_start <= '{$dateCalend}' AND cal.date_end <= '{$dateCalend}') AND cal.recurring = '1' AND cal.recur_day = '{$dayRecurr}')) ORDER BY cal.shortname"; } // $tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' AND cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend' ORDER BY $block1->sortingValue"; $listCalendar = new request(); $listCalendar->openCalendar($tmpquery); $comptListCalendar = count($listCalendar->cal_id); if ($comptListCalendar != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["shortname"], 1 => $strings["subject"], 2 => $strings["date_start"], 3 => $strings["date_end"]), "false"); for ($i = 0; $i < $comptListCalendar; $i++) { $block1->openRow($listCalendar->cal_id[$i]); $block1->checkboxRow($listCalendar->cal_id[$i]); $block1->cellRow(buildLink("../calendar/viewcalendar.php?{$dateEnreg}=" . $listCalendar->cal_id[$i] . "&viewCalend={$viewCalend}&type=calendDetail&dateCalend={$dateCalend}", $listCalendar->cal_shortname[$i], LINK_INSIDE)); $block1->cellRow($listCalendar->cal_subject[$i]); $block1->cellRow($listCalendar->cal_date_start[$i]); $block1->cellRow($listCalendar->cal_date_end[$i]); $block1->closeRow(); } $block1->closeResults(); } else { $block1->noresults(); } $block1->closeFormResults(); $block1->openPaletteScript(); $block1->paletteScript(0, "add", "../calendar/viewcalendar.php?viewCalend={$viewCalend}&dateCalend={$dateCalend}&type=calendEdit", "true,false,false", $strings["add"]); $block1->paletteScript(1, "remove", "../calendar/deletecalendar.php?", "false,true,true", $strings["delete"]);
$block1->sorting("discussions", $sortingUser->sor_discussions[0], "topic.last_post DESC", $sortingFields = array(0 => "topic.subject", 1 => "mem.login", 2 => "topic.posts", 3 => "topic.last_post", 4 => "topic.status", 5 => "topic.published")); if ($project != "") { $tmpquery = "WHERE topic.project = '{$project}' ORDER BY {$block1->sortingValue}"; } else { $tmpquery = "WHERE topic.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}"; } $listTopics = new request(); $listTopics->openTopics($tmpquery); $comptListTopics = count($listTopics->top_id); if ($comptListTopics != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["topic"], 1 => $strings["owner"], 2 => $strings["posts"], 3 => $strings["last_post"], 4 => $strings["status"], 5 => $strings["published"]), "true"); for ($i = 0; $i < $comptListTopics; $i++) { $idStatus = $listTopics->top_status[$i]; $idPublish = $listTopics->top_published[$i]; $block1->openRow($listTopics->top_id[$i]); $block1->checkboxRow($listTopics->top_id[$i]); $block1->cellRow(buildLink("../topics/viewtopic.php?id=" . $listTopics->top_id[$i], $listTopics->top_subject[$i], LINK_INSIDE)); $block1->cellRow(buildLink($listTopics->top_mem_email_work[$i], $listTopics->top_mem_login[$i], LINK_MAIL)); $block1->cellRow($listTopics->top_posts[$i]); if ($listTopics->top_last_post[$i] > $_SESSION['lastvisiteSession']) { $block1->cellRow("<b>" . createDate($listTopics->top_last_post[$i], $_SESSION['timezoneSession']) . "</b>"); } else { $block1->cellRow(createDate($listTopics->top_last_post[$i], $_SESSION['timezoneSession'])); } $block1->cellRow($statusTopic[$idStatus]); if ($sitePublish == "true") { $block1->cellRow($statusPublish[$idPublish]); } $block1->closeRow(); }
if ($comptListNotes != "0") { $block6->form = "notesForm"; $block6->openForm("../search/resultssearch.php?searchfor={$searchfor}&heading={$heading}#" . $block6->form . "Anchor"); $block6->headingForm($strings["search_results"] . " : " . $strings["notes"] . " ({$block6->recordsTotal})"); /*$block6->openPaletteIcon(); $block6->paletteIcon(0,"export",$strings["export"]); $block6->closePaletteIcon();*/ $block6->openResults(); if ($comptTopic != "0") { $block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["topic"], 2 => $strings["date"], 3 => $strings["owner"], 4 => $strings["published"]), "true"); } else { $block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["date"], 2 => $strings["owner"], 3 => $strings["published"]), "true"); } for ($i = 0; $i < $comptListNotes; $i++) { $idPublish = $listNotes->note_published[$i]; $block6->openRow($listNotes->note_id[$i]); $block6->checkboxRow($listNotes->note_id[$i]); $block6->cellRow(buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], LINK_INSIDE)); if ($comptTopic != "0") { $block6->cellRow($topicNote[$listNotes->note_topic[$i]]); } $block6->cellRow($listNotes->note_date[$i]); $block6->cellRow(buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], LINK_MAIL)); if ($sitePublish == "true") { $block6->cellRow($statusPublish[$idPublish]); } $block6->closeRow(); } $block6->closeResults(); $block6->bornesFooter("6", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}"); $block6->closeToggle();
$block2->paletteIcon(0, "add", $strings["add"]); $block2->paletteIcon(1, "remove", $strings["delete"]); $block2->closePaletteIcon(); $block2->borne = $blockPage->returnBorne("2"); $block2->rowsLimit = "1"; $block2->sorting("organizations", $sortingUser->sor_organizations[0], "org.name ASC", $sortingFields = array(0 => "org.name", 1 => "org.phone", 2 => "org.url")); $tmpquery = "WHERE org.id != '1' ORDER BY {$block2->sortingValue}"; $block2->recordsTotal = compt($initrequest["organizations"] . " " . $tmpquery); $listOrganizations2 = new request(); $listOrganizations2->openOrganizations($tmpquery, $block2->borne, $block2->rowsLimit); $comptlistOrganizations2 = count($listOrganizations2->org_id); if ($comptlistOrganizations2 != "0") { $block2->openResults(); $block2->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false", $sorting = "false", $sortingOff = array(0 => "2", 1 => "DESC")); for ($i = 0; $i < $comptlistOrganizations2; $i++) { $block2->openRow(); $block2->checkboxRow($listOrganizations2->org_id[$i]); $block2->cellRow(buildLink("../clients/viewclient.php?id=" . $listOrganizations2->org_id[$i], $listOrganizations2->org_name[$i], LINK_INSIDE)); $block2->cellRow($listOrganizations2->org_phone[$i]); $block2->cellRow(buildLink($listOrganizations2->org_url[$i], $listOrganizations2->org_url[$i], LINK_OUT)); $block2->closeRow(); } $block2->closeResults(); $block2->bornesFooter("2", $blockPage->bornesNumber, "", "project={$project}"); } else { $block2->noresults(); } $block2->closeFormResults(); $block2->openPaletteScript(); $block2->paletteScript(0, "add", "../clients/editclient.php?", "true,false,false", $strings["add"]); $block2->paletteScript(1, "remove", "../clients/deleteclients.php?", "false,true,true", $strings["delete"]);
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["save"] . "\"></td></tr>"; $block1->closeContent(); $block1->heading($strings["holidays"]); $block1->openPaletteIcon(); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->closePaletteIcon(); $tmpquery = " ORDER BY hol.date DESC"; $holidayList = new request(); $holidayList->openHoliday($tmpquery); $comptHolidayList = count($holidayList->hol_id); $block1->recordsTotal = $comptHolidayList; if ($comptHolidayList > 0) { $block1->openResults(); $block1->labels($labels = array(0 => $strings['date'], 1 => $strings['comments']), 'true', $sorting = false, $sortingOff = array(0 => '0', 1 => 'DESC')); for ($i = 0; $i < $comptHolidayList; $i++) { $block1->openRow($holidayList->hol_id[$i]); $block1->checkboxRow($holidayList->hol_id[$i]); $block1->cellRow($holidayList->hol_date[$i]); $block1->cellRow($holidayList->hol_comments[$i]); $block1->closeRow(); } $block1->closeResults(); } else { $block1->noresults(); } $block1->closeFormResults(); $block1->openPaletteScript(); $block1->paletteScript(1, "remove", "../administration/deleteholidays.php?", "false,true,true", $strings["delete"]); $block1->closePaletteScript($comptHolidayList, $holidayList->hol_id); $block1->headingForm_close(); require_once "../themes/" . THEME . "/footer.php";
} $block3->paletteIcon(2, 'info', $strings['view']); if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') { $block3->paletteIcon(3, 'edit', $strings['edit']); } $block3->closePaletteIcon(); $block3->sorting('users', $sortingUser->sor_users[0], 'mem.name ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mem.login', 2 => 'mem.email_work', 3 => 'mem.profil', 4 => 'connected')); $tmpquery = "WHERE mem.organization = '{$id}' ORDER BY {$block3->sortingValue}"; $listMembers = new request(); $listMembers->openMembers($tmpquery); $comptListMembers = count($listMembers->mem_id); if ($comptListMembers != '0') { $block3->openResults(); $block3->labels($labels = array(0 => $strings['full_name'], 1 => $strings['user_name'], 2 => $strings['email'], 3 => $strings['work_phone'], 4 => $strings['connected']), 'false'); for ($i = 0; $i < $comptListMembers; $i++) { $block3->openRow($listMembers->mem_id[$i]); $block3->checkboxRow($listMembers->mem_id[$i]); $block3->cellRow(buildLink('../users/viewclientuser.php?id=' . $listMembers->mem_id[$i] . "&organization={$id}", $listMembers->mem_name[$i], LINK_INSIDE)); $block3->cellRow($listMembers->mem_login[$i]); $block3->cellRow(buildLink($listMembers->mem_email_work[$i], $listMembers->mem_email_work[$i], LINK_MAIL)); $block3->cellRow($listMembers->mem_phone_work[$i]); $z = '(Client on project site)'; if ($listMembers->mem_log_connected[$i] > $dateunix - 5 * 60) { $block3->cellRow($strings['yes'] . ' ' . $z); } else { $block3->cellRow($strings['no']); } } $block3->closeResults(); } else { $block3->noresults();
$blockProject->heading_close(); $listTasks = new request(); $listTasks->openTasks($tmpqueryTask); $comptListTasks = count($listTasks->tas_id); $blockProject->openResults("false"); $blockProject->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["due_date"], 4 => $strings["completed"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true"); if ($comptListProjects != "0") { for ($i = 0; $i < $comptListTasks; $i++) { if ($listTasks->tas_due_date[$i] == "--" or $listTasks->tas_due_date[$i] == "") { $listTasks->tas_due_date[$i] = $strings["none"]; } $idStatus = $listTasks->tas_status[$i]; $idPriority = $listTasks->tas_priority[$i]; $idPublished = $listTasks->tas_published[$i]; $complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . "0 %" : $listTasks->tas_completion[$i] . " %"; $blockProject->openRow(); $blockProject->checkboxRow($listTasks->tas_id[$i], $checkbox = "false"); $blockProject->cellRow(buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_INSIDE)); $blockProject->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '"> ' . $priority[$idPriority], '', true); $blockProject->cellRow($status[$idStatus]); $blockProject->cellRow($listTasks->tas_due_date[$i]); if ($complValue != "100 %") { $blockProject->cellRow($complValue); } else { $blockProject->cellRow($listTasks->tas_complete_date[$i]); } if ($listTasks->tas_assigned_to[$i] == "0") { $blockProject->cellRow($strings["unassigned"]); } else { $blockProject->cellRow($listTasks->tas_mem_login[$i]); }
$block2->closePaletteScript($comptListFiles, $listFiles->fil_id); } $block3 = new block(); $block3->form = "ahT"; $block3->openForm("../tasks/viewtask.php?id={$id}#" . $block3->form . "Anchor"); $block3->headingToggle($strings["assignment_history"]); $block3->headingToggle_close(); $block3->sorting("assignment", $sortingUser->sor_assignment[0], "ass.assigned DESC", $sortingFields = array(0 => "ass.comments", 1 => "mem1.login", 2 => "mem2.login", 3 => "ass.assigned")); $tmpquery = "WHERE ass.task = '{$id}' ORDER BY {$block3->sortingValue}"; $listAssign = new request(); $listAssign->openAssignments($tmpquery); $comptListAssign = count($listAssign->ass_id); $block3->openResults($checkbox = "false"); $block3->labels($labels = array(0 => $strings["comment"], 1 => $strings["assigned_by"], 2 => $strings["to"], 3 => $strings["assigned_on"]), "false"); for ($i = 0; $i < $comptListAssign; $i++) { $block3->openRow(); $block3->checkboxRow($listAssign->ass_id[$i], $checkbox = "false"); if ($listAssign->ass_comments[$i] != "") { $block3->cellRow($listAssign->ass_comments[$i]); } else { if ($listAssign->ass_assigned_to[$i] == "0") { $block3->cellRow($strings["task_unassigned"]); } else { $block3->cellRow($strings["task_assigned"] . " " . $listAssign->ass_mem2_name[$i] . " (" . $listAssign->ass_mem2_login[$i] . ")"); } } $block3->cellRow(buildLink($listAssign->ass_mem1_email_work[$i], $listAssign->ass_mem1_login[$i], LINK_MAIL)); if ($listAssign->ass_assigned_to[$i] == "0") { $block3->cellRow($strings["unassigned"]); } else { $block3->cellRow(buildLink($listAssign->ass_mem2_email_work[$i], $listAssign->ass_mem2_login[$i], LINK_MAIL));
$block1->openForm("../reports/listreports.php#" . $block1->form . "Anchor"); $block1->heading($strings["my_reports"]); $block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->closePaletteIcon(); $block1->sorting("reports", $sortingUser->sor_reports[0], "rep.name ASC", $sortingFields = array(0 => "rep.name", 1 => "rep.created")); $tmpquery = "WHERE rep.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}"; $listReports = new request(); $listReports->openReports($tmpquery); $comptListReports = count($listReports->rep_id); if ($comptListReports != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["name"], 1 => $strings["created"]), "false"); for ($i = 0; $i < $comptListReports; $i++) { $block1->openRow($listReports->rep_id[$i]); $block1->checkboxRow($listReports->rep_id[$i]); $block1->cellRow(buildLink("../reports/resultsreport.php?id=" . $listReports->rep_id[$i], $listReports->rep_name[$i], LINK_INSIDE)); $block1->cellRow(createDate($listReports->rep_created[$i], $_SESSION['timezoneSession'])); } $block1->closeResults(); } else { $block1->noresults(); } $block1->closeFormResults(); $block1->block_close(); $block1->openPaletteScript(); $block1->paletteScript(0, "add", "../reports/createreport.php?", "true,true,true", $strings["add"]); $block1->paletteScript(1, "remove", "../reports/deletereports.php?", "false,true,true", $strings["delete"]); $block1->closePaletteScript($comptListReports, $listReports->rep_id); require_once "../themes/" . THEME . "/footer.php";
} $block2->openContent(); $block2->sorting('team', $sortingUser->sor_team[0], 'mem.name ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mem.title', 2 => 'mem.login', 3 => 'mem.phone_work', 4 => 'log.connected', 5 => 'tea.published')); $tmpquery = "WHERE tea.project = '{$id}' AND mem.profil = '3' ORDER BY {$block2->sortingValue}"; $listPermitted = new request(); $listPermitted->openTeams($tmpquery); $comptListPermitted = count($listPermitted->tea_id); if ($comptListPermitted != '0') { $block2->openResults(); $block2->labels($labels = array(0 => $strings['full_name'], 1 => $strings['title'], 2 => $strings['user_name'], 3 => $strings['work_phone'], 4 => $strings['connected'], 5 => $strings['published']), 'true'); for ($i = 0; $i < $comptListPermitted; $i++) { if ($listPermitted->tea_mem_phone_work[$i] == '') { $listPermitted->tea_mem_phone_work[$i] = $strings['none']; } $idPublish = $listPermitted->tea_published[$i]; $block2->openRow($listPermitted->tea_mem_id[$i]); $block2->checkboxRow($listPermitted->tea_mem_id[$i]); $block2->cellRow(buildLink('../users/viewclientuser.php?id=' . $listPermitted->tea_mem_id[$i] . '&organization=' . $projectDetail->pro_organization[0], $listPermitted->tea_mem_name[$i], LINK_INSIDE)); $block2->cellRow($listPermitted->tea_mem_title[$i]); $block2->cellRow(buildLink($listPermitted->tea_mem_email_work[$i], $listPermitted->tea_mem_login[$i], LINK_MAIL)); $block2->cellRow($listPermitted->tea_mem_phone_work[$i]); if ($listPermitted->tea_mem_profil[$i] == '3') { $z = '(Client on project site)'; } else { $z = ''; } if ($listPermitted->tea_log_connected[$i] > $dateunix - 5 * 60) { $block2->cellRow($strings['yes'] . ' ' . $z); } else { $block2->cellRow($strings['no']); }
$pagestr .= $i + 1; } } $block1->heading(text("Phrases") . " ( " . $pagestr . " )"); $block1->openPaletteIcon(); $block1->paletteIcon(1, "remove", text("delete")); $block1->closePaletteIcon(); // ok, now to list up all the phrases $block1->openResults(); $block1->labels($labels = array(0 => text('Label'), 1 => text('Translation')), $published = "true", "true", $sortingOff = array(0 => '0', 1 => 'DESC')); reset($translations); $id = 0; $checkboxes = array(); foreach ($translations as $key => $value) { if ($id >= $offset && $id < $offset + $pagesize) { $block1->openRow($id); $block1->checkboxRow($id); $block1->cellRow(htmlspecialchars($key, ENT_QUOTES)); $block1->cellRow("<input type='hidden' name='key" . $id . "' value=\"" . htmlspecialchars($key, ENT_QUOTES) . "\">" . "<input size='80' name='trans" . $id . "' value=\"" . htmlspecialchars($value, ENT_QUOTES) . "\">", 100); $block1->closeRow(); $checkboxes[] = $id; } $id++; } $block1->closeResults(); $block1->openContent(); echo "<TR><TD ALIGN='right'>"; echo text("click_to_save") . ": <input type='submit' value='" . text('save_translation') . "'>"; echo "</TD></TR>"; $block1->closeContent(); $block1->openPaletteScript();
$block1->borne = $blockPage->returnBorne("1"); $block1->rowsLimit = "20"; $block1->sorting("meetings", $sortingUser->sor_meetings[0], 'mee.date DESC', $sortingFields = array(0 => 'mee.id', 1 => 'mee.name', 2 => 'mee.priority', 3 => 'mee.status', 4 => 'mee.date')); $tmpquery = "WHERE mee.project = '{$project}' ORDER BY {$block1->sortingValue}"; $block1->recordsTotal = compt($initrequest["meetings"] . " " . $tmpquery); $listMeetings = new request(); $listMeetings->openMeetings($tmpquery, $block1->borne, $block1->rowsLimit); $comptListMeetings = count($listMeetings->mee_id); if ($comptListMeetings != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings['id'], 1 => $strings['meeting'], 2 => $strings['priority'], 3 => $strings['status'], 4 => $strings['date']), 'true'); for ($i = 0; $i < $comptListMeetings; $i++) { $idStatus = $listMeetings->mee_status[$i]; $idPriority = $listMeetings->mee_priority[$i]; $idPublish = $listMeetings->mee_published[$i]; $block1->openRow($listMeetings->mee_id[$i]); $block1->checkboxRow($listMeetings->mee_id[$i]); $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_id[$i], LINK_INSIDE)); if ($idStatus == 1) { $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_name[$i], LINK_STRIKE)); } else { $block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_name[$i], LINK_INSIDE)); } $block1->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '"> ' . $priority[$idPriority], '', true); $block1->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true); if ($listMeetings->mee_date[$i] <= $date && $idStatus != 1) { $block1->cellRow("<b>" . $listMeetings->mee_date[$i] . "</b>"); } else { $block1->cellRow($listMeetings->mee_date[$i]); } $block1->cellRow($complValue);
$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]); $block2->checkboxRow($listTaskTimes->tim_id[$i], 'true'); $block2->cellRow($listTaskTimes->tim_mem_name[$i]); $block2->cellRow($listTaskTimes->tim_date[$i]); $block2->cellRow($listTaskTimes->tim_hours[$i]); $block2->cellRow($listTaskTimes->tim_created[$i]); $block2->cellRow($listTaskTimes->tim_modified[$i]); // truncate large comments to keep the display clean $comments = $listTaskTimes->tim_comments[$i]; $lenComm = 40; if (strLen($comments) > $lenComm) { $comments = substr($listTaskTimes->tim_comments[$i], 0, $lenComm) . ' ...'; } $block2->cellRow($comments); $block2->closeRow(); }
$block1->openResults(); $block1->labels($labels = array(0 => $strings["id"], 1 => $strings["subject"], 2 => $strings["owner"], 3 => $strings["project"], 4 => $strings["priority"], 5 => $strings["status"], 6 => $strings["date_open"], 7 => $strings["date_close"]), "false"); for ($i = 0; $i < $comptListRequests; $i++) { $comptSta = count($requestStatus); for ($sr = 0; $sr < $comptSta; $sr++) { if ($listRequests->sr_status[$i] == $sr) { $currentStatus = $requestStatus[$sr]; } } $comptPri = count($priority); for ($rp = 0; $rp < $comptPri; $rp++) { if ($listRequests->sr_priority[$i] == $rp) { $requestPriority = $priority[$rp]; } } $block1->openRow($listRequests->sr_id[$i]); $block1->checkboxRow($listRequests->sr_id[$i]); $block1->cellRow($listRequests->sr_id[$i]); $block1->cellRow(buildLink("../support/viewrequest.php?id=" . $listRequests->sr_id[$i], $listRequests->sr_subject[$i], LINK_INSIDE)); $block1->cellRow($listRequests->sr_mem_name[$i]); $block1->cellRow($listRequests->sr_project[$i]); $block1->cellRow($requestPriority); $block1->cellRow($currentStatus); $block1->cellRow($listRequests->sr_date_open[$i]); $block1->cellRow($listRequests->sr_date_close[$i]); $block1->closeRow(); } $block1->closeResults(); } else { $block1->noresults(); }
$block1->paletteIcon(4, "info", $strings["view"]); $block1->paletteIcon(5, "email", $strings["email"]); $block1->closePaletteIcon(); $block1->sorting("team", $sortingUser->sor_team[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected", 5 => "tea.published")); $tmpquery = "WHERE tea.project = '{$id}' AND mem.profil != '3' ORDER BY {$block1->sortingValue}"; $listTeam = new request(); $listTeam->openTeams($tmpquery); $comptListTeam = count($listTeam->tea_id); $block1->openResults(); $block1->labels($labels = array(0 => $strings["full_name"], 1 => $strings["title"], 2 => $strings["user_name"], 3 => $strings["work_phone"], 4 => $strings["connected"], 5 => $strings["published"]), "true"); for ($i = 0; $i < $comptListTeam; $i++) { if ($listTeam->tea_mem_phone_work[$i] == "") { $listTeam->tea_mem_phone_work[$i] = $strings["none"]; } $idPublish = $listTeam->tea_published[$i]; $block1->openRow(); $block1->checkboxRow($listTeam->tea_mem_id[$i]); $block1->cellRow($blockPage->buildLink("../users/viewuser.php?id=" . $listTeam->tea_mem_id[$i], $listTeam->tea_mem_name[$i], in)); $block1->cellRow($listTeam->tea_mem_title[$i]); $block1->cellRow($blockPage->buildLink($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_login[$i], mail)); $block1->cellRow($listTeam->tea_mem_phone_work[$i]); if ($listTeam->tea_log_connected[$i] > $dateunix - 5 * 60) { $block1->cellRow($strings["yes"] . " " . $z); } else { $block1->cellRow($strings["no"]); } if ($sitePublish == "true") { $block1->cellRow($statusPublish[$idPublish]); } $block1->closeRow(); }
if ($comptListNotes != "0") { $block6->form = "notesForm"; $block6->openForm("../search/resultssearch.php?" . session_name() . "=" . session_id() . "&searchfor={$searchfor}&heading={$heading}#" . $block6->form . "Anchor"); $block6->headingToggle($strings["search_results"] . " : " . $strings["notes"] . " ({$block6->recordsTotal})"); /*$block6->openPaletteIcon(); $block6->paletteIcon(0,"export",$strings["export"]); $block6->closePaletteIcon();*/ $block6->openResults(); if ($comptTopic != "0") { $block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["topic"], 2 => $strings["date"], 3 => $strings["owner"], 4 => $strings["published"]), "true"); } else { $block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["date"], 2 => $strings["owner"], 3 => $strings["published"]), "true"); } for ($i = 0; $i < $comptListNotes; $i++) { $idPublish = $listNotes->note_published[$i]; $block6->openRow(); $block6->checkboxRow($listNotes->note_id[$i]); $block6->cellRow($blockPage->buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], in)); if ($comptTopic != "0") { $block6->cellRow($topicNote[$listNotes->note_topic[$i]]); } $block6->cellRow($listNotes->note_date[$i]); $block6->cellRow($blockPage->buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], mail)); if ($sitePublish == "true") { $block6->cellRow($statusPublish[$idPublish]); } $block6->closeRow(); } $block6->closeResults(); $block6->bornesFooter("6", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}"); $block6->closeToggle();