}
}
$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++) {
