} } $query .= ")"; } //--- header --- $breadcrumbs[] = buildLink("../reports/createreport.php?", $strings["reports"], LINK_INSIDE); if ($id != "") { $breadcrumbs[] = $reportDetail->rep_name[0]; } else { $breadcrumbs[] = $strings["report_results"]; } $pageSection = 'reports'; require_once "../themes/" . THEME . "/header.php"; //--- content ---- $block1 = new block(); $block1->sorting("report_tasks", $sortingUser->sor_report_tasks[0], "tas.name ASC", $sortingFields = array(0 => "tas.id", 1 => "tas.name", 2 => "tas.priority", 3 => "tas.status", 4 => "tas.due_date", 5 => "tas.complete_date", 6 => "mem2.login", 7 => "pro.name", 8 => "tas.published")); if ($projectsFilter == "true") { $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id "; $tmpquery .= "WHERE pro.status IN(0,2,3) AND teams.member = '" . $_SESSION['idSession'] . "' ORDER BY pro.id"; $listProjectsTasks = new request(); $listProjectsTasks->openProjects($tmpquery); $comptListProjectsTasks = count($listProjectsTasks->pro_id); if ($comptListProjectsTasks != "0") { for ($i = 0; $i < $comptListProjectsTasks; $i++) { $filterTasks .= $listProjectsTasks->pro_id[$i]; if ($comptListProjectsTasks - 1 != $i) { $filterTasks .= ","; } } if ($query != "") { $tmpquery = "{$queryStart} {$query} AND pro.id IN({$filterTasks}) ORDER BY {$block1->sortingValue}";
$block2->headingToggle($strings["linked_content"]); $block2->openPaletteIcon(); if ($teamMember == "true" || $_SESSION['profilSession'] == "5") { $block2->paletteIcon(0, "add", $strings["add"]); $block2->paletteIcon(1, "remove", $strings["delete"]); if ($sitePublish == "true") { $block2->paletteIcon(2, "add_projectsite", $strings["add_project_site"]); $block2->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]); } } $block2->paletteIcon(4, "info", $strings["view"]); if ($teamMember == "true" || $_SESSION['profilSession'] == "5") { $block2->paletteIcon(5, "edit", $strings["edit"]); } $block2->closePaletteIcon(); $block2->sorting("meetings_attachment", $sortingUser->sor_meetings_attachment[0], "mat.name ASC", $sortingFields = array(0 => "mat.extension", 1 => "mat.name", 2 => "mat.date", 3 => "mat.status", 4 => "mat.published")); $tmpquery = "WHERE mat.meeting = '{$id}' AND mat.vc_parent = '0' ORDER BY {$block2->sortingValue}"; $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";
$block9->openPaletteScript(); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block9->paletteScript(0, 'add', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'true,false,false', $strings['add']); $block9->paletteScript(1, 'remove', '../tasks/deletetasks.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']); $block9->paletteScript(2, 'copy', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0] . '&cpy=true', 'false,true,false', $strings['copy']); } $block9->paletteScript(6, 'info', '../tasks/viewtask.php', 'false,true,false', $strings['view']); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block9->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']); } $block9->closePaletteScript($comptListMilestones, $listMilestones->tas_id); $block10 = new block(); //--- block header ---- $block10->form = 'wbTuuC'; $block10->openForm("../phases/listphases.php?id={$id}#" . $block10->form . "Anchor"); $block10->sorting('tasks_closed', $sortingUser->sor_tasks_closed[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')); $block10->borne = $blockPage->returnBorne('1'); $block10->rowsLimit = '20'; //--- get data from sql --------- $tmpquery = "WHERE tas.project = '{$id}' AND tas.status NOT IN(0,2,3) AND tas.milestone = '1' ORDER BY {$block10->sortingValue}"; $block10->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery); //--- list --------- $listTasks = new request(); $listTasks->openTasks($tmpquery, $block10->borne, $block10->rowsLimit); $comptListTasks = count($listTasks->tas_id); $block10->headingToggle($strings['tasks_closed'] . ' <span class=addition>(' . $comptListTasks . ')</span>'); $block10->openPaletteIcon(); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block10->paletteIcon(0, 'add', $strings['add']); $block10->paletteIcon(1, 'remove', $strings['delete']); $block10->paletteIcon(2, 'copy', $strings['copy']);
include_once '../includes/library.php'; include '../themes/' . THEME . '/header.php'; $blockPage = new block(); $blockPage->openBreadcrumbs(); $blockPage->itemBreadcrumbs($blockPage->buildLink("../clients/listclients.php?", $strings["organizations"], in)); $blockPage->itemBreadcrumbs($strings["organizations"]); $blockPage->closeBreadcrumbs(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "clientList"; $block1->openForm("../clients/listclients.php?" . session_name() . "=" . session_id() . "#" . $block1->form . "Anchor"); $block1->heading($strings["organizations"]); $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(); $block1->checkboxRow($listOrganizations->org_id[$i]); $block1->cellRow($blockPage->buildLink("../clients/viewclient.php?id=" . $listOrganizations->org_id[$i], $listOrganizations->org_name[$i], in)); $block1->cellRow($listOrganizations->org_phone[$i]); $block1->cellRow($blockPage->buildLink($listOrganizations->org_url[$i], $listOrganizations->org_url[$i], out)); $block1->closeRow(); }
$block1->contentRow($strings['date'], "<input type=\"text\" style=\"width: 150px;\" name=\"ld\" id=\"sel1\" \r\nsize=\"20\" value=\"{$ld}\"><button type=\"reset\" id=\"trigger_a\">...</button>\r\n<script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script>"); echo "\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'>" . $strings["worked_hours"] . " :</td>\r\n <td><input size='20' value='{$hr}' style='width: 150px;' name='hr' maxlength='6' type='text'></td>\r\n</tr>\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'>" . $strings["comments"] . " :</td>\r\n <td><textarea rows='10' style='width: 400px; height: 150px;' name='comm' cols='47'>{$comm}</textarea></td>\r\n</tr>\r\n<tr class='odd'>\r\n <td valign='top' class='leftvalue'> </td>\r\n <td><input type='SUBMIT' value='" . $strings["save"] . "'></td>\r\n</tr>"; $block1->closeContent(); $block1->closeForm(); // This will display time log detail for the current meeting $block2 = new block(); $block2->form = "ahT"; $block2->openForm("../meetings/addmeetingtime.php?id={$id}#" . $block2->form . "Anchor"); $block2->heading($strings["meeting_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('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]);
$block1->paletteIcon(2, "copy", $strings["copy"]); // $block1->paletteIcon(3,"export",$strings["export"]); if ($sitePublish == "true") { $block1->paletteIcon(4, "add_projectsite", $strings["add_project_site"]); $block1->paletteIcon(5, "remove_projectsite", $strings["remove_project_site"]); } } $block1->paletteIcon(6, "info", $strings["view"]); if ($teamMember == "true") { $block1->paletteIcon(7, "edit", $strings["edit"]); $block1->paletteIcon(8, "timelog", $strings["loghours"]); } $block1->closePaletteIcon(); $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));
$block1 = new block(); $block1->form = "calendList"; $block1->openForm("../calendar/viewcalendar.php?viewCalend={$viewCalend}&type={$type}&dateCalend={$dateCalend}#" . $block1->form . "Anchor"); if ($viewCalend == 0) { $heading_posfix = "(" . $strings['cal_personal'] . $strings['calendar'] . ")"; } else { $heading_posfix = "(" . $strings['project'] . $strings['calendar'] . "-" . $listTeam->tea_pro_name[0] . ")"; } $block1->heading("{$dayName} {$day} {$monthName} {$year}" . $heading_posfix); $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(); $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]);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block4->paletteScript(0, 'add', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'true,false,false', $strings['add']); $block4->paletteScript(1, 'remove', '../tasks/deletetasks.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']); $block4->paletteScript(2, 'copy', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0] . '&cpy=true', 'false,true,false', $strings['copy']); } $block4->paletteScript(6, 'info', '../tasks/viewtask.php', 'false,true,false', $strings['view']); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block4->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']); } $block4->closePaletteScript($comptListMilestones, $listMilestones->tas_id); $block3 = new block(); //--- block header ---- $block3->form = 'saTlC'; $block3->openForm("../tasks/listtasks.php?project={$project}#" . $block3->form . "Anchor"); if (isset($flag_phases) && $flag_phases == true) { $block3->sorting("tasks_closed", $sortingUser->sor_tasks_closed[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 { $block3->sorting("tasks_closed", $sortingUser->sor_tasks_closed[0], "tas.due_date ASC", $sortingFields = array("tas.priority", "tas.name", "tas.status", "tas.completion", "tas.due_date", "mem.login", "tas.published")); } $block3->borne = $blockPage->returnBorne('1'); $block3->rowsLimit = '20'; //--- get data from sql --------- $tmpquery = "WHERE tas.project = '{$project}' AND tas.status NOT IN(0,2,3,5) AND tas.milestone = '1' ORDER BY {$block3->sortingValue}"; $block3->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery); //--- list --------- $listClosedTasks = new request(); $listClosedTasks->openTasks($tmpquery, $block3->borne, $block3->rowsLimit); $comptListTasks = count($listClosedTasks->tas_id); $block3->headingToggle($strings['tasks_closed'] . ' <span class=addition>(' . $comptListTasks . ')</span>'); $block3->openPaletteIcon(); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
} } $block5->paletteScript(4, 'info', '../linkedcontent/viewfile.php', 'false,true,false', $strings['view']); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block5->paletteScript(5, 'edit', '../linkedcontent/viewfile.php?edit=true', 'false,true,false', $strings['edit']); } $block5->closePaletteScript($comptListFiles, $listFiles->fil_id); } $block6 = new block(); $block6->form = 'wbJ'; $block6->openForm('../projects/viewproject.php?id=' . $projectDetail->pro_id[0] . '#' . $block6->form . 'Anchor'); $block6->borne = $blockPage->returnBorne('4'); $block6->rowsLimit = '5'; $comptTopic = count($topicNote); if ($comptTopic != '0') { $block6->sorting('notes', $sortingUser->sor_notes[0], 'note.date DESC', $sortingFields = array(0 => 'note.subject', 1 => 'note.topic', 2 => 'note.date', 3 => 'mem.login', 4 => 'note.published')); } else { $block6->sorting('notes', $sortingUser->sor_notes[0], 'note.date DESC', $sortingFields = array(0 => 'note.subject', 1 => 'note.date', 2 => 'mem.login', 3 => 'note.published')); } $tmpquery = "WHERE note.project = '{$id}' ORDER BY {$block6->sortingValue}"; $block6->recordsTotal = compt($initrequest['notes'] . ' ' . $tmpquery); $listNotes = new request(); $listNotes->openNotes($tmpquery, $block6->borne, $block6->rowsLimit); $comptListNotes = count($listNotes->note_id); $block6->headingToggle($strings['notes'] . ' <span class=addition>(' . $comptListNotes . ')</span>'); $block6->openPaletteIcon(); if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') { $block6->paletteIcon(0, 'add', $strings['add']); $block6->paletteIcon(1, 'remove', $strings['delete']); // $block6->paletteIcon(2,'export',$strings['export']); if ($sitePublish == 'true') {
$block1->openPaletteIcon(); $block1->paletteIcon(0, 'add', $strings['add']); if ($view == 'my') { $block1->paletteIcon(1, 'remove', $strings['delete']); } /*if ($sitePublish == "true") { $block1->paletteIcon(3,"add_projectsite",$strings["add_project_site"]); $block1->paletteIcon(4,"remove_projectsite",$strings["remove_project_site"]); }*/ $block1->paletteIcon(5, 'info', $strings['view']); if ($view == 'my') { $block1->paletteIcon(6, 'edit', $strings['edit']); } $block1->closePaletteIcon(); if ($view == 'my') { $block1->sorting('bookmarks', $sortingUser->sor_bookmarks[0], 'boo.name ASC', $sortingFields = array(0 => 'boo.name', 1 => 'boo.category', 2 => 'boo.shared')); } else { $block1->sorting('bookmarks', $sortingUser->sor_bookmarks[0], 'boo.name ASC', $sortingFields = array(0 => 'boo.name', 1 => 'boo.category', 2 => 'mem.login')); } if ($view == 'my') { $tmpquery = "WHERE boo.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}"; } else { if ($view == 'private') { $tmpquery = "WHERE boo.users LIKE '%|" . $_SESSION['idSession'] . "|%' ORDER BY {$block1->sortingValue}"; } 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 ($A[is_using_forum_flag] == 'Y') { $blockPage->bornesNumber = "5"; $block5 = new block(); $block5->form = "forP"; $block5->openForm($_CONF['site_url'] . "/nexproject/viewproject.php?" . "#" . $block2->form . "Anchor"); $block5->headingToggle($strings["forum"]); if ($membertoken != 0) { $block5->openPaletteIcon(); $block5->paletteIcon(0, "view", $strings["view"]); $block5->paletteIcon(1, "info", $strings["add"]); $block5->closePaletteIcon(); } $block5->borne = $blockPage->returnBorne("5"); $block5->rowsLimit = 5; $block5->sorting('discussions', $sortingUser[forum], "{$_TABLES['gf_topic']}.lastupdated DESC", $sortingFields = array(0 => "{$_TABLES['gf_topic']}.subject", 1 => "{$_TABLES['gf_topic']}.name", 2 => "{$_TABLES['gf_topic']}.lastupdated", 3 => "{$_TABLES['gf_topic']}.replies")); $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}"; $result = DB_query($sql); $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 ";
$block1->paletteIcon(1, "remove", $strings["delete"]); $block1->paletteIcon(2, "copy", $strings["copy"]); //$block1->paletteIcon(3,"export",$strings["export"]); if ($sitePublish == "true") { $block1->paletteIcon(4, "add_projectsite", $strings["add_project_site"]); $block1->paletteIcon(5, "remove_projectsite", $strings["remove_project_site"]); } } $block1->paletteIcon(6, "info", $strings["view"]); if ($teamMember == "true") { $block1->paletteIcon(7, "edit", $strings["edit"]); } $block1->closePaletteIcon(); $block1->borne = $blockPage->returnBorne("1"); $block1->rowsLimit = "20"; $block1->sorting("tasks", $sortingUser->sor_tasks[0], "tas.name ASC", $sortingFields = array(0 => "tas.name", 1 => "tas.priority", 2 => "tas.status", 3 => "tas.completion", 4 => "tas.due_date", 5 => "mem.login", 6 => "tas.published")); $tmpquery = "WHERE tas.project = '{$project}' ORDER BY {$block1->sortingValue}"; $block1->recordsTotal = compt($initrequest["tasks"] . " " . $tmpquery); $listTasks = new request(); $listTasks->openTasks($tmpquery, $block1->borne, $block1->rowsLimit); $comptListTasks = count($listTasks->tas_id); if ($comptListTasks != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["task"], 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 < $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];
$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)); $blockPage->itemBreadcrumbs($blockPage->buildLink("../teams/listusers.php?id=" . $projectDetail->pro_id[0], $strings["team_members"], in)); $blockPage->itemBreadcrumbs($strings["add_team"]); $blockPage->closeBreadcrumbs(); $block1 = new block(); $block1->form = "atpt"; $block1->openForm("../teams/adduser.php?" . session_name() . "=" . session_id() . "&project={$project}#" . $block1->form . "Anchor"); $block1->heading($strings["add_team"]); $block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "info", $strings["view"]); $block1->paletteIcon(2, "edit", $strings["edit"]); $block1->closePaletteIcon(); $block1->sorting("users", $sortingUser->sor_users[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected")); $tmpquery = "WHERE tea.project = '{$project}' AND mem.profil != '3'"; $concatMembers = new request(); $concatMembers->openTeams($tmpquery); $comptConcatMembers = count($concatMembers->tea_id); for ($i = 0; $i < $comptConcatMembers; $i++) { $membersTeam .= $concatMembers->tea_mem_id[$i]; if ($i < $comptConcatMembers - 1) { $membersTeam .= ","; } } if ($demoMode == "true") { $tmpquery = "WHERE mem.id NOT IN({$membersTeam}) AND mem.profil != '3' ORDER BY {$block1->sortingValue}"; } else { $tmpquery = "WHERE mem.id NOT IN({$membersTeam}) AND mem.profil != '3' AND mem.id != '2' ORDER BY {$block1->sortingValue}"; }
if ($S_COMPLETEDATE != "ALL" && $S_EDATE2 != "") { if ($query != "") { $query .= " AND tas.complete_date <= '{$S_EDATE2}'"; } else { $query .= "tas.complete_date <= '{$S_EDATE2}'"; } } $query .= ")"; } $blockPage = new block(); if ($msg != "") { include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->sorting("report_tasks", $sortingUser->sor_report_tasks[0], "tas.complete_date DESC", $sortingFields = array(0 => "tas.name", 1 => "tas.project", 2 => "tas.actual_time", 3 => "tas.completion", 4 => "tas.status", 5 => "tas.start_date", 6 => "tas.due_date", 7 => "tas.complete_date", 8 => "mem.login", 9 => "tas.description", 10 => "tas.comments")); if ($projectsFilter == "true") { $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id "; $tmpquery .= "WHERE pro.status IN(0,2,3) AND teams.member = '{$idSession}' ORDER BY pro.id"; $listProjectsTasks = new request(); $listProjectsTasks->openProjects($tmpquery); $comptListProjectsTasks = count($listProjectsTasks->pro_id); if ($comptListProjectsTasks != "0") { for ($i = 0; $i < $comptListProjectsTasks; $i++) { $filterTasks .= $listProjectsTasks->pro_id[$i]; if ($comptListProjectsTasks - 1 != $i) { $filterTasks .= ","; } } if ($query != "") { $tmpquery = "{$queryStart} {$query} AND pro.id IN({$filterTasks}) ORDER BY {$block1->sortingValue}";
// configuration options // today's date $datenow = date("Y-m-d"); // end of configuration $checkSession = true; require_once "../includes/library.php"; $breadcrumbs[] = $strings['reports']; $breadcrumbs[] = buildLink('../reports/createreport.php?typeReports=create', $strings["create_report"], in) . ' | ' . buildLink('../reports/createreport.php?typeReports=custom', $strings['custom_reports'], LINK_INSIDE); $pageSection = 'reports'; require_once "../themes/" . THEME . "/header.php"; // start the first block $block1 = new block(); $block1->form = "xwbT"; $block1->openForm("../reports/overdue.php#" . $block1->form . "Anchor"); $block1->openContent(); $block1->sorting("home_tasks", $sortingUser->sor_home_tasks[0], "tas.priority DESC", $sortingFields = array(0 => "tas.name", 1 => "pro.name", 2 => "tas.status", 3 => "tas.completion", 4 => "tas.due_date", 5 => "mem.login", 6 => "tas.priority")); $query = " WHERE tas.status > 1 and (tas.due_date < '{$datenow}' AND tas.due_date <> '--')"; $tmpquery = "{$query} ORDER BY {$block1->sortingValue}"; $listTasks = new request(); $listTasks->openTasks($tmpquery); $comptListTasks = count($listTasks->tas_id); $block0 = new block(); $block0->openContent(); $block0->contentTitle($strings["report_results"]); if ($comptListTasks == "0") { $block0->contentRow("", "0 " . $strings["matches"] . "<br>" . $strings["no_results_report"]); } if ($comptListTasks == "1") { $block0->contentRow("", "1 " . $strings["match"]); } if ($comptListTasks > "1") {
$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 .= ','; } }
$block2->openForm('../projects/viewprojectsite.php?id=' . $projectDetail->pro_id[0] . '#' . $block2->form . 'Anchor'); $block2->heading($strings['permitted_client']); if ($_SESSION['idSession'] == $projectDetail->pro_owner[0] || $_SESSION['profilSession'] == '5') { $block2->openPaletteIcon(); $block2->paletteIcon(0, 'add', $strings['add']); $block2->paletteIcon(1, 'remove', $strings['delete']); if ($sitePublish == 'true') { $block2->paletteIcon(2, 'add_projectsite', $strings['add_project_site']); $block2->paletteIcon(3, 'remove_projectsite', $strings['remove_project_site']); } $block2->closePaletteIcon(); } else { $block2->headingToggle_close(); } $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->closePaletteScript($comptListProjects, $listProjects->pro_id); $block3 = new block(); $block3->form = "clU"; $block3->openForm("../clients/viewclient.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block3->form . "Anchor"); $block3->headingToggle($strings["client_users"]); $block3->openPaletteIcon(); if ($profilSession == "0" || $profilSession == "1") { $block3->paletteIcon(0, "add", $strings["add"]); $block3->paletteIcon(1, "remove", $strings["delete"]); } $block3->paletteIcon(2, "info", $strings["view"]); if ($profilSession == "0" || $profilSession == "1") { $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(); $block3->checkboxRow($listMembers->mem_id[$i]); $block3->cellRow($blockPage->buildLink("../users/viewclientuser.php?id=" . $listMembers->mem_id[$i] . "&organization={$id}", $listMembers->mem_name[$i], in)); $block3->cellRow($listMembers->mem_login[$i]); $block3->cellRow($blockPage->buildLink($listMembers->mem_email_work[$i], $listMembers->mem_email_work[$i], mail)); $block3->cellRow($listMembers->mem_phone_work[$i]); $z = "(Client on project site)";
* TODO: add export to CSV capabilities */ // configuration options // end of configuration $checkSession = true; require_once "../includes/library.php"; $breadcrumbs[] = $strings['reports']; $breadcrumbs[] = buildLink('../reports/createreport.php?typeReports=create', $strings["create_report"], in) . ' | ' . buildLink('../reports/createreport.php?typeReports=custom', $strings['custom_reports'], LINK_INSIDE); $pageSection = 'reports'; require_once "../themes/" . THEME . "/header.php"; // start the first block $block1 = new block(); $block1->form = "xwbT"; $block1->openForm("../reports/projectbreakdown.php#" . $block1->form . "Anchor"); $block1->openContent(); $block1->sorting("projects", $sortingUser->sor_projects[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "pro.name", 2 => "org.name", 3 => "pro.status")); // $query = " WHERE pro.status = 1 "; $tmpquery = "{$query} ORDER BY {$block1->sortingValue}"; // $tmpquery = $query; $listProjects = new request(); $listProjects->openProjects($tmpquery); $comptListProjects = count($listProjects->pro_id); $block0 = new block(); $block0->openContent(); $block0->contentTitle($strings["report_results"]); if ($comptListProjects == "0") { $block1->contentRow("", "0 " . $strings["matches"] . "<br>" . $strings["no_results_report"]); } if ($comptListProjects == "1") { $block1->contentRow("", "1 " . $strings["match"]); }
} $block1->openPaletteIcon(); if ($teamMember == "true") { $block1->paletteIcon(0, "add", $strings["add"]); } if ($_SESSION['idSession'] == $projectDetail->pro_owner[0]) { $block1->paletteIcon(1, "remove", $strings["delete"]); $block1->paletteIcon(2, "lock", $strings["close"]); if ($sitePublish == "true") { $block1->paletteIcon(3, "add_projectsite", $strings["add_project_site"]); $block1->paletteIcon(4, "remove_projectsite", $strings["remove_project_site"]); } } $block1->paletteIcon(5, "info", $strings["view"]); $block1->closePaletteIcon(); $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]);
$tmpquery = "{$searchTopics} ORDER BY {$block5->sortingValue}"; } $comptListTopics = "0"; if ($validTopics == "true") { $block5->recordsTotal = compt($initrequest["topics"] . " " . $tmpquery); $listTopics = new request(); $listTopics->openTopics($tmpquery, $block5->borne, $block5->rowsLimit); $comptListTopics = count($listTopics->top_id); // echo "$tmpquery<br>"; } $block6 = new block(); $comptTopic = count($topicNote); $block6->borne = $blockPage->returnBorne("6"); $block6->rowsLimit = "10"; if ($comptTopic != "0") { $block6->sorting("notes", $sortingUser->sor_notes[0], "note.date DESC", $sortingFields = array(0 => "note.subject", 1 => "note.topic", 2 => "note.date", 3 => "mem.login", 4 => "note.published")); } else { $block6->sorting("notes", $sortingUser->sor_notes[0], "note.date DESC", $sortingFields = array(0 => "note.subject", 1 => "note.date", 2 => "mem.login", 3 => "note.published")); } if ($projectsFilter == "true") { if ($comptListProjectsFilter != "0") { $tmpquery = "{$searchNotes} AND note.project IN({$filterResults}) ORDER BY {$block6->sortingValue}"; } else { $validNotes = "false"; } } else { $tmpquery = "{$searchNotes} ORDER BY {$block6->sortingValue}"; } $comptListNotes = "0"; if ($validNotes == "true") { $block6->recordsTotal = compt($initrequest["notes"] . " " . $tmpquery);
$block1->openPaletteIcon(); $block1->paletteIcon(0, "add", $strings["add"]); if ($view == "my") { $block1->paletteIcon(1, "remove", $strings["delete"]); } /*if ($sitePublish == "true") { $block1->paletteIcon(3,"add_projectsite",$strings["add_project_site"]); $block1->paletteIcon(4,"remove_projectsite",$strings["remove_project_site"]); }*/ $block1->paletteIcon(5, "info", $strings["view"]); if ($view == "my") { $block1->paletteIcon(6, "edit", $strings["edit"]); } $block1->closePaletteIcon(); if ($view == "my") { $block1->sorting("bookmarks", $sortingUser->sor_bookmarks[0], "boo.name ASC", $sortingFields = array(0 => "boo.name", 1 => "boo.category", 2 => "boo.shared")); } else { $block1->sorting("bookmarks", $sortingUser->sor_bookmarks[0], "boo.name ASC", $sortingFields = array(0 => "boo.name", 1 => "boo.category", 2 => "mem.login")); } if ($view == "my") { $tmpquery = "WHERE boo.owner = '{$idSession}' ORDER BY {$block1->sortingValue}"; } else { if ($view == "private") { $tmpquery = "WHERE boo.users LIKE '%|{$idSession}|%' ORDER BY {$block1->sortingValue}"; } else { $tmpquery = "WHERE boo.shared = '1' OR boo.owner = '{$idSession}' ORDER BY {$block1->sortingValue}"; } } $listBookmarks = new request(); $listBookmarks->openBookmarks($tmpquery); $comptListBookmarks = count($listBookmarks->boo_id);
$checkSession = true; require_once "../includes/library.php"; $breadcrumbs[] = buildLink("../reports/createreport.php?", $strings["reports"], LINK_INSIDE); $breadcrumbs[] = $strings["my_reports"]; $pageSection = 'reports'; require_once "../themes/" . THEME . "/header.php"; //---- content ------ $block1 = new block(); $block1->form = "wbSe"; $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 {
$block2->closePaletteScript($comptListProjects, $listProjects->pro_id); $block3 = new block(); $block3->form = 'clU'; $block3->openForm("../clients/viewclient.php?id={$id}#" . $block3->form . 'Anchor'); $block3->headingToggle($strings['client_users']); $block3->openPaletteIcon(); if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') { $block3->paletteIcon(0, 'add', $strings['add']); $block3->paletteIcon(1, 'remove', $strings['delete']); } $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)';
include '../includes/messages.php'; $blockPage->messagebox($msgLabel); } $block1 = new block(); $block1->form = "srs"; $block1->openForm("../support/listrequests.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block1->form . "Anchor"); $block1->heading($strings["support_requests"]); if ($teamMember == "true" || $profilSession == "0") { $block1->openPaletteIcon(); //$block1->paletteIcon(0,"add",$strings["add"]); $block1->paletteIcon(1, "edit", $strings["edit_status"]); $block1->paletteIcon(2, "remove", $strings["delete"]); $block1->paletteIcon(3, "info", $strings["view"]); $block1->closePaletteIcon(); } $block1->sorting("support_requests", $sortingUser->sor_support_requests[0], "sr.id ASC", $sortingFields = array(0 => "sr.id", 1 => "sr.subject", 2 => "sr.priority", 3 => "sr.status", 4 => "sr.date_open", 5 => "sr.date_close")); /*$tmpquery = "WHERE mem.id = '$idSession'"; $userDetail = new request(); $userDetail->openMembers($tmpquery);*/ $tmpquery = "WHERE sr.project = '{$id}' ORDER BY {$block1->sortingValue}"; $listRequests = new request(); $listRequests->openSupportRequests($tmpquery); $comptListRequests = count($listRequests->sr_id); if ($comptListRequests != "0") { $block1->openResults(); $block1->labels($labels = array(0 => $strings["id"], 1 => $strings["subject"], 2 => $strings["priority"], 3 => $strings["status"], 4 => $strings["date_open"], 5 => $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];
} $block1->paletteIcon(2, "info", $strings["view"]); if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") { $block1->paletteIcon(3, "edit", $strings["edit"]); $block1->paletteIcon(4, "copy", $strings["copy"]); } if ($enable_cvs == "true") { $block1->paletteIcon(7, "cvs", $strings["browse_cvs"]); } if ($enableMantis == "true") { $block1->paletteIcon(8, "bug", $strings["bug"]); } $block1->closePaletteIcon(); $block1->borne = $blockPage->returnBorne("1"); $block1->rowsLimit = "20"; $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 ($typeProjects == "inactive") { if ($projectsFilter == "true") { $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id "; $tmpquery .= " WHERE pro.status IN(0,1,4) AND teams.member = '{$idSession}' ORDER BY {$block1->sortingValue}"; } else { $tmpquery = "WHERE pro.status IN(0,1,4) ORDER BY {$block1->sortingValue}"; } } else { if ($typeProjects == "active") { if ($projectsFilter == "true") { $tmpquery = "LEFT OUTER JOIN " . $tableCollab["teams"] . " teams ON teams.project = pro.id "; $tmpquery .= "WHERE pro.status IN(2,3) AND teams.member = '{$idSession}' ORDER BY {$block1->sortingValue}"; } else { $tmpquery = "WHERE pro.status IN(2,3) ORDER BY {$block1->sortingValue}"; }
$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]); $block2->checkboxRow($listTaskTimes->tim_id[$i], 'true'); $block2->cellRow($listTaskTimes->tim_mem_name[$i]);
$block2->paletteScript(2, "add_projectsite", "../tasks/viewtask.php?addToSiteFile=true&task=" . $taskDetail->tas_id[0] . "&action=publish", "false,true,true", $strings["add_project_site"]); $block2->paletteScript(3, "remove_projectsite", "../tasks/viewtask.php?removeToSiteFile=true&task=" . $taskDetail->tas_id[0] . "&action=publish", "false,true,true", $strings["remove_project_site"]); } } $block2->paletteScript(4, "info", "../linkedcontent/viewfile.php?", "false,true,false", $strings["view"]); if ($teamMember == "true" || $_SESSION['profilSession'] == "5") { $block2->paletteScript(5, "edit", "../linkedcontent/viewfile.php?edit=true", "false,true,false", $strings["edit"]); } $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 {
$block1->form = "saM"; $block1->openForm("../teams/listusers.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block1->form . "Anchor"); $block1->heading($strings["team_members"]); $block1->openPaletteIcon(); if ($idSession == $projectDetail->pro_owner[0] || $profilSession == "5") { $block1->paletteIcon(0, "add", $strings["add"]); $block1->paletteIcon(1, "remove", $strings["delete"]); if ($sitePublish == "true") { $block1->paletteIcon(2, "add_projectsite", $strings["add_project_site"]); $block1->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]); } } $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]);
$blockPage->messagebox($msgLabel); } if ($teamMember == "true" || $profilSession == "5") { $block7 = new block(); $block7->form = "wbSe"; $block7->openForm("../phases/listphases.php?id={$id}&" . session_name() . "=" . session_id() . "#" . $block7->form . "Anchor"); $block7->headingToggle($strings["phases"]); $block7->openPaletteIcon(); $block7->paletteIcon(0, "info", $strings["view"]); if ($teamMember == "true" || $profilSession == "5") { if ($idSession == $projectDetail->pro_owner[0] || $profilSession == "0" || $profilSession == "5") { $block7->paletteIcon(1, "edit", $strings["edit"]); } } $block7->closePaletteIcon(); $block7->sorting("phases", $sortingUser->sor_phases[0], "pha.order_num ASC", $sortingFields = array(0 => "pha.order_num", 1 => "pha.name", 2 => "none", 3 => "none", 4 => "pha.status", 5 => "pha.date_start", 6 => "pha.date_end")); $tmpquery = "WHERE pha.project_id = '{$id}' ORDER BY {$block7->sortingValue}"; $listPhases = new request(); $listPhases->openPhases($tmpquery); $comptListPhases = count($listPhases->pha_id); if ($comptListPhases != "0") { $block7->openResults(); $block7->labels($labels = array(0 => $strings["order"], 1 => $strings["name"], 2 => $strings["total_tasks"], 3 => $strings["uncomplete_tasks"], 4 => $strings["status"], 5 => $strings["date_start"], 6 => $strings["date_end"]), "false"); $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++) {