$listSubtasks = new request();
$listSubtasks->openSubtasks($tmpquery);
$comptListSubtasks = count($listSubtasks->subtas_id);
if ($comptListSubtasks != "0") {
$block4->openResults();
$block4->labels($labels = array(0 => $strings["subtask"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["completion"], 4 => $strings["due_date"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true");
for ($i = 0; $i < $comptListSubtasks; $i++) {
if ($listSubtasks->subtas_due_date[$i] == "") {
$listSubtasks->subtas_due_date[$i] = $strings["none"];
}
$idStatus = $listSubtasks->subtas_status[$i];
$idPriority = $listSubtasks->subtas_priority[$i];
$idPublish = $listSubtasks->subtas_published[$i];
$complValue = $listSubtasks->subtas_completion[$i] > 0 ? $listSubtasks->subtas_completion[$i] . "0 %" : $listSubtasks->subtas_completion[$i] . " %";
$block4->openRow();
$block4->checkboxRow($listSubtasks->subtas_id[$i]);
$block4->cellRow($blockPage->buildLink("../subtasks/viewsubtask.php?id=" . $listSubtasks->subtas_id[$i] . "&task={$id}", $listSubtasks->subtas_name[$i], in));
$block4->cellRow("<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]);
$block4->cellRow($status[$idStatus]);
$block4->cellRow($complValue);
if ($listSubtasks->subtas_due_date[$i] <= $date && $listSubtasks->subtas_completion[$i] != "10") {
$block4->cellRow("<b>" . $listSubtasks->subtas_due_date[$i] . "</b>");
} else {
$block4->cellRow($listSubtasks->subtas_due_date[$i]);
}
if ($listSubtasks->subtas_start_date[$i] != "--" && $listSubtasks->subtas_due_date[$i] != "--") {
$gantt = "true";
}
if ($listSubtasks->subtas_assigned_to[$i] == "0") {
$block4->cellRow($strings["unassigned"]);
} else {
$listAttachments->openMeetingsAttachment($tmpquery);
$comptListFiles = count($listAttachments->mat_id);
if ($comptListFiles != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["type"], 1 => $strings["name"], 2 => $strings["date"], 3 => $strings["approval_tracking"], 4 => $strings["published"]), "true");
require_once "../includes/files_types.php";
for ($i = 0; $i < $comptListFiles; $i++) {
$existFile = "false";
$idStatus = $listAttachments->mat_status[$i];
$idPublish = $listAttachments->mat_published[$i];
$type = file_info_type($listAttachments->mat_extension[$i]);
if (file_exists("../files/" . $listAttachments->mat_project[$i] . "/meetings/" . $listAttachments->mat_meeting[$i] . "/" . $listAttachments->mat_name[$i])) {
$existFile = "true";
}
$block2->openRow($listAttachments->mat_id[$i]);
$block2->checkboxRow($listAttachments->mat_id[$i]);
if ($existFile == "true") {
$block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $type, icone));
} else {
$block2->cellRow(" ");
}
if ($existFile == "true") {
$block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $listAttachments->mat_name[$i], LINK_INSIDE));
} else {
$block2->cellRow($strings["missing_file"] . " (" . $listAttachments->mat_name[$i] . ")");
}
$block2->cellRow($listAttachments->mat_date[$i]);
$block2->cellRow(buildLink("../meetings/viewfile.php?id=" . $listAttachments->mat_id[$i], $statusFile[$idStatus], LINK_INSIDE));
if ($sitePublish == "true") {
$block2->cellRow($statusPublish[$idPublish]);
}
$block10->paletteIcon(8, 'timelog', $strings['loghours']);
}
$block10->closePaletteIcon();
if ($comptListTasks != '0') {
$block10->openResults();
$block10->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['phase'], $strings['assigned_to'], $strings['published']), 'true');
for ($i = 0; $i < $comptListTasks; $i++) {
if ($listTasks->tas_due_date[$i] == '') {
$listTasks->tas_due_date[$i] = $strings['none'];
}
$idStatus = $listTasks->tas_status[$i];
$idPriority = $listTasks->tas_priority[$i];
$idPublish = $listTasks->tas_published[$i];
$complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . '0 %' : $listTasks->tas_completion[$i] . ' %';
$block10->openRow($listTasks->tas_id[$i]);
$block10->checkboxRow($listTasks->tas_id[$i]);
//--- id ----
#$block10->cellRow(buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_id[$i], LINK_INSIDE));
//--- prio ---
$block10->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">', '1%', true);
//--- name ----
if ($idStatus == 1) {
$block10->cellRow(buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_STRIKE), "99%");
} else {
$block10->cellRow(buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_INSIDE), "99%");
}
//--- status ----
$block10->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true);
//--- complete ----
$block10->cellRow($complValue);
//---- due date ------
$block1->openForm("../reports/listreports.php#" . $block1->form . "Anchor");
$block1->heading($strings["my_reports"]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "add", $strings["add"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
$block1->sorting("reports", $sortingUser->sor_reports[0], "rep.name ASC", $sortingFields = array(0 => "rep.name", 1 => "rep.created"));
$tmpquery = "WHERE rep.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}";
$listReports = new request();
$listReports->openReports($tmpquery);
$comptListReports = count($listReports->rep_id);
if ($comptListReports != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["name"], 1 => $strings["created"]), "false");
for ($i = 0; $i < $comptListReports; $i++) {
$block1->openRow($listReports->rep_id[$i]);
$block1->checkboxRow($listReports->rep_id[$i]);
$block1->cellRow(buildLink("../reports/resultsreport.php?id=" . $listReports->rep_id[$i], $listReports->rep_name[$i], LINK_INSIDE));
$block1->cellRow(createDate($listReports->rep_created[$i], $_SESSION['timezoneSession']));
}
$block1->closeResults();
} else {
$block1->noresults();
}
$block1->closeFormResults();
$block1->block_close();
$block1->openPaletteScript();
$block1->paletteScript(0, "add", "../reports/createreport.php?", "true,true,true", $strings["add"]);
$block1->paletteScript(1, "remove", "../reports/deletereports.php?", "false,true,true", $strings["delete"]);
$block1->closePaletteScript($comptListReports, $listReports->rep_id);
require_once "../themes/" . THEME . "/footer.php";
$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];
}
}
$comptPri = count($priority);
for ($rp = 0; $rp < $comptPri; $rp++) {
if ($listRequests->sr_priority[$i] == $rp) {
$requestPriority = $priority[$rp];
}
}
$block1->openRow();
$block1->checkboxRow($listRequests->sr_id[$i]);
$block1->cellRow($listRequests->sr_id[$i]);
$block1->cellRow($blockPage->buildLink("../support/viewrequest.php?id=" . $listRequests->sr_id[$i], $listRequests->sr_subject[$i], in));
$block1->cellRow($requestPriority);
$block1->cellRow($currentStatus);
$block1->cellRow($listRequests->sr_date_open[$i]);
$block1->cellRow($listRequests->sr_date_close[$i]);
$block1->closeRow();
}
$block1->closeResults();
} else {
$block1->noresults();
}
$block1->closeFormResults();
if ($teamMember == "true" || $profilSession == "0") {
$block1->openPaletteScript();
echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"SUBMIT\" value=\"" . $strings["save"] . "\"></td></tr>";
$block1->closeContent();
$block1->heading($strings["holidays"]);
$block1->openPaletteIcon();
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
$tmpquery = " ORDER BY hol.date DESC";
$holidayList = new request();
$holidayList->openHoliday($tmpquery);
$comptHolidayList = count($holidayList->hol_id);
$block1->recordsTotal = $comptHolidayList;
if ($comptHolidayList > 0) {
$block1->openResults();
$block1->labels($labels = array(0 => $strings['date'], 1 => $strings['comments']), 'true', $sorting = false, $sortingOff = array(0 => '0', 1 => 'DESC'));
for ($i = 0; $i < $comptHolidayList; $i++) {
$block1->openRow($holidayList->hol_id[$i]);
$block1->checkboxRow($holidayList->hol_id[$i]);
$block1->cellRow($holidayList->hol_date[$i]);
$block1->cellRow($holidayList->hol_comments[$i]);
$block1->closeRow();
}
$block1->closeResults();
} else {
$block1->noresults();
}
$block1->closeFormResults();
$block1->openPaletteScript();
$block1->paletteScript(1, "remove", "../administration/deleteholidays.php?", "false,true,true", $strings["delete"]);
$block1->closePaletteScript($comptHolidayList, $holidayList->hol_id);
$block1->headingForm_close();
require_once "../themes/" . THEME . "/footer.php";
$block1->openForm("../clients/listclients.php#" . $block1->form . "Anchor");
$block1->heading($strings["organizations"]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "add", $strings["add"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
$tmpquery = "WHERE org.id != '1' ORDER BY org.url DESC";
$listOrganizations = new request();
$listOrganizations->openOrganizations($tmpquery);
$comptListOrganizations = count($listOrganizations->org_id);
if ($comptListOrganizations != "0") {
$block1->openResults($checkbox = "false");
$block1->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false", $sorting = "false", $sortingOff = array(0 => "2", 1 => "DESC"));
for ($i = 0; $i < $comptListOrganizations; $i++) {
$block1->openRow();
$block1->checkboxRow($listOrganizations->org_id[$i], $checkbox = "false");
$block1->cellRow(buildLink("../clients/viewclient.php?id=" . $listOrganizations->org_id[$i], $listOrganizations->org_name[$i], LINK_INSIDE));
$block1->cellRow($listOrganizations->org_phone[$i]);
$block1->cellRow(buildLink($listOrganizations->org_url[$i], $listOrganizations->org_url[$i], LINK_OUT));
$block1->closeRow();
}
$block1->closeResults();
} else {
$block1->noresults();
}
$block1->closeFormResults();
$block1->openPaletteScript();
$block1->paletteScript(0, "add", "../clients/editclient.php?", "true,false,false", $strings["add"]);
$block1->paletteScript(1, "remove", "../clients/deleteclients.php?", "false,true,true", $strings["delete"]);
$block1->closePaletteScript($comptListOrganizations, $listOrganizations->org_id);
require_once "../themes/" . THEME . "/footer.php";
if ($project != "") {
$tmpquery = "WHERE topic.project = '{$project}' ORDER BY {$block1->sortingValue}";
} else {
$tmpquery = "WHERE topic.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block1->sortingValue}";
}
$listTopics = new request();
$listTopics->openTopics($tmpquery);
$comptListTopics = count($listTopics->top_id);
if ($comptListTopics != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["topic"], 1 => $strings["owner"], 2 => $strings["posts"], 3 => $strings["last_post"], 4 => $strings["status"], 5 => $strings["published"]), "true");
for ($i = 0; $i < $comptListTopics; $i++) {
$idStatus = $listTopics->top_status[$i];
$idPublish = $listTopics->top_published[$i];
$block1->openRow($listTopics->top_id[$i]);
$block1->checkboxRow($listTopics->top_id[$i]);
$block1->cellRow(buildLink("../topics/viewtopic.php?id=" . $listTopics->top_id[$i], $listTopics->top_subject[$i], LINK_INSIDE));
$block1->cellRow(buildLink($listTopics->top_mem_email_work[$i], $listTopics->top_mem_login[$i], LINK_MAIL));
$block1->cellRow($listTopics->top_posts[$i]);
if ($listTopics->top_last_post[$i] > $_SESSION['lastvisiteSession']) {
$block1->cellRow("<b>" . createDate($listTopics->top_last_post[$i], $_SESSION['timezoneSession']) . "</b>");
} else {
$block1->cellRow(createDate($listTopics->top_last_post[$i], $_SESSION['timezoneSession']));
}
$block1->cellRow($statusTopic[$idStatus]);
if ($sitePublish == "true") {
$block1->cellRow($statusPublish[$idPublish]);
}
$block1->closeRow();
}
$block1->closeResults();
$tmpquery = "WHERE boo.shared = '1' OR boo.owner = '{$idSession}' ORDER BY {$block1->sortingValue}";
}
}
$listBookmarks = new request();
$listBookmarks->openBookmarks($tmpquery);
$comptListBookmarks = count($listBookmarks->boo_id);
if ($comptListBookmarks != "0") {
$block1->openResults();
if ($view == "my") {
$block1->labels($labels = array(0 => $strings["name"], 1 => $strings["bookmark_category"], 2 => $strings["shared"]), "false");
} else {
$block1->labels($labels = array(0 => $strings["name"], 1 => $strings["bookmark_category"], 2 => $strings["owner"]), "false");
}
for ($i = 0; $i < $comptListBookmarks; $i++) {
$block1->openRow();
$block1->checkboxRow($listBookmarks->boo_id[$i]);
$block1->cellRow($blockPage->buildLink("../bookmarks/viewbookmark.php?view={$view}&id=" . $listBookmarks->boo_id[$i], $listBookmarks->boo_name[$i], in) . " " . $blockPage->buildLink($listBookmarks->boo_url[$i], "(" . $strings["url"] . ")", out));
$block1->cellRow($listBookmarks->boo_boocat_name[$i]);
if ($view == "my") {
if ($listBookmarks->boo_shared[$i] == "1") {
$printShared = $strings["yes"];
} else {
$printShared = $strings["no"];
}
$block1->cellRow($printShared);
} else {
$block1->cellRow($blockPage->buildLink($listBookmarks->boo_mem_email_work[$i], $listBookmarks->boo_mem_login[$i], mail));
}
$block1->closeRow();
}
$block1->closeResults();
$rate_type_value = "0";
} else {
if ($listInvoicesItems->invitem_rate_type[$i] == "b") {
$rate_type_value = "1";
} else {
if ($listInvoicesItems->invitem_rate_type[$i] == "c") {
$rate_type_value = "2";
} else {
if (is_numeric($listInvoicesItems->invitem_rate_type[$i])) {
$rate_type_value = "3";
}
}
}
}
$block2->openRow();
$block2->checkboxRow($listInvoicesItems->invitem_id[$i]);
$block2->cellRow($listInvoicesItems->invitem_position[$i]);
$block2->cellRow($blockPage->buildLink("../invoicing/editinvoiceitem.php?invoiceitem=" . $listInvoicesItems->invitem_id[$i], $listInvoicesItems->invitem_title[$i], in));
$block2->cellRow($rateType[$rate_type_value]);
$block2->cellRow($listInvoicesItems->invitem_rate_value[$i]);
$block2->cellRow($listInvoicesItems->invitem_amount_ex_tax[$i]);
if ($listInvoicesItems->invitem_completed[$i] == "1") {
$block2->cellRow($strings["yes"]);
} else {
$block2->cellRow($strings["no"]);
}
$block2->closeRow();
}
$block2->closeResults();
} else {
$block2->noresults();
$block3->openResults();
if (isset($flag_phases) && $flag_phases == true) {
$block3->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['phase'], $strings['assigned_to'], $strings['published']), 'true');
} else {
$block3->labels($labels = array('P', $strings['name'], $strings['status'], $strings['completion'], $strings['due_date'], $strings['assigned_to'], $strings['published']), 'true');
}
for ($i = 0; $i < $comptListTasks; $i++) {
if ($listClosedTasks->tas_due_date[$i] == '') {
$listClosedTasks->tas_due_date[$i] = $strings['none'];
}
$idStatus = $listClosedTasks->tas_status[$i];
$idPriority = $listClosedTasks->tas_priority[$i];
$idPublish = $listClosedTasks->tas_published[$i];
$complValue = $listClosedTasks->tas_completion[$i] > 0 ? $listClosedTasks->tas_completion[$i] . '0 %' : $listClosedTasks->tas_completion[$i] . ' %';
$block3->openRow($listClosedTasks->tas_id[$i]);
$block3->checkboxRow($listClosedTasks->tas_id[$i]);
//--- id ----
#$block3->cellRow(buildLink("../tasks/viewtask.php?id=" . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_id[$i], LINK_INSIDE));
//--- prio ---
$block3->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '">', '1%', true);
//--- name ----
if ($idStatus == 1 or $idStatus == 6) {
$block3->cellRow(buildLink('../tasks/viewtask.php?id=' . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_name[$i], LINK_STRIKE), "99%");
} else {
$block3->cellRow(buildLink('../tasks/viewtask.php?id=' . $listClosedTasks->tas_id[$i], $listClosedTasks->tas_name[$i], LINK_INSIDE), "99%");
}
//--- status ----
$block3->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true);
//--- complete ----
$block3->cellRow($complValue);
//---- due date ------
$sql = "SELECT {$_TABLES['gf_topic']}.id,{$_TABLES['gf_topic']}.pid,";
$sql .= "{$_TABLES['gf_topic']}.subject,{$_TABLES['users']}.fullname,";
$sql .= "{$_TABLES['gf_topic']}.lastupdated,{$_TABLES['gf_topic']}.replies ";
$sql .= "FROM {$_TABLES['gf_topic']}, {$_TABLES['users']} ";
$sql .= "WHERE forum={$A['fid']} AND pid=0 ";
$sql .= "AND {$_TABLES['gf_topic']}.uid={$_TABLES['users']}.uid ";
$sql .= "ORDER BY {$block5->sortingValue} LIMIT {$block5->borne},{$block5->rowsLimit}";
$result = DB_query($sql);
$comptListTasks = DB_numrows($result);
if ($comptListTasks != "0") {
$block5->openResults();
$block5->labels($labels = array(0 => $strings["Subject"], 1 => $strings["Author"], 2 => $strings["lastUpdated"], 3 => $strings["Replies"]), "true");
for ($i = 0; $i < $comptListTasks; $i++) {
list($listForum->topic[$i], $parent, $listForum->subject[$i], $listForum->author[$i], $listForum->date[$i], $listForum->replies[$i]) = DB_fetchArray($result);
$block5->openRow();
$block5->checkboxRow($listForum->topic[$i]);
$block5->cellRow($blockPage->buildLink($_CONF['site_url'] . "/forum/viewtopic.php?forum=" . $A[fid] . "&showtopic=" . $listForum->topic[$i], $listForum->subject[$i], "in", 'Click to View Discussion'));
$block5->cellRow($listForum->author[$i]);
$block5->cellRow(strftime("%Y/%m/%d %H:%M", $listForum->date[$i]));
$block5->cellRow($listForum->replies[$i]);
$block5->closeRow();
}
$block5->closeResults();
$block5->bornesFooter("5", $blockPage->bornesNumber, "", "pid={$pid}");
} else {
$block5->noresults();
}
echo '<input type="hidden" name="pid" value="' . $pid . '">';
$block5->closeToggle();
$block5->closeFormResults();
if ($membertoken != 0) {
/**
* determine phase start and end dates by finding the
* earliest start times and latest end times for
* member tasks
*/
/**
* start task
*/
if ($phaseStart == "--" or $phaseStart == "") {
$phaseStart = $strings["none"];
}
if ($phaseEnd == "--" or $phaseEnd == "") {
$phaseEnd = $strings["none"];
}
$blockProject->openRow();
$blockProject->checkboxRow($phaseID, $checkbox = "false");
$blockProject->cellRow(buildLink("../phases/viewphase.php?id=" . $listPhases->pha_id[$i], $phaseName, LINK_INSIDE));
$blockProject->cellRow($phaseStatus[$listPhases->pha_status[$i]]);
$blockProject->cellRow($comptlistTasksRow);
$blockProject->cellRow($comptUncompleteTasks);
$blockProject->cellRow($phaseStart);
$blockProject->cellRow($phaseEnd);
// $blockProject->cellRow($phaseCompletion);
$blockProject->closeRow();
}
} else {
// no tasks for project
}
$blockProject->closeResults();
$blockProject->heading_close();
print "<p><br></p>";
require_once '../themes/' . THEME . '/header.php';
//--- content ----
$block1 = new block();
$block1->form = 'adminD';
$block1->openForm('../administration/listlogs.php?action=delete&id=' . $id . '#' . $block1->form . 'Anchor');
$block1->headingForm($strings['logs']);
$block1->openResults($checkbox = false);
$block1->labels($labels = array(0 => $strings['user_name'], 1 => $strings['ip'], 2 => $strings['session'], 3 => $strings['compteur'], 4 => $strings['last_visit'], 5 => $strings['connected']), false, $sorting = false, $sortingOff = array(0 => '4', 1 => 'DESC'));
$tmpquery = 'ORDER BY last_visite DESC';
$listLogs = new request();
$listLogs->openLogs($tmpquery);
$comptListLogs = count($listLogs->log_id);
$dateunix = date("U");
for ($i = 0; $i < $comptListLogs; $i++) {
$block1->openRow();
$block1->checkboxRow($listLogs->log_id[$i], $checkbox = false);
$block1->cellRow($listLogs->log_login[$i]);
$block1->cellRow($listLogs->log_ip[$i]);
$block1->cellRow($listLogs->log_session[$i]);
$block1->cellRow($listLogs->log_compt[$i]);
$block1->cellRow(createDate($listLogs->log_last_visite[$i], $_SESSION['timezoneSession']));
if ($listLogs->log_mem_profil[$i] == 3) {
$z = '(Client on project site)';
} else {
$z = '';
}
if ($listLogs->log_connected[$i] > $dateunix - 5 * 60) {
$block1->cellRow($strings['yes'] . ' ' . $z);
} else {
$block1->cellRow($strings['no']);
}
$dayRecurr = _dayOfWeek(mktime(12, 12, 12, $month, $day, $year));
if ($viewCalend == 0) {
$tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' AND ((cal.date_start <= '{$dateCalend}' AND cal.date_end >= '{$dateCalend}' AND cal.recurring = '0') OR ((cal.date_start <= '{$dateCalend}' AND cal.date_end <= '{$dateCalend}') AND cal.recurring = '1' AND cal.recur_day = '{$dayRecurr}')) ORDER BY cal.shortname";
} else {
$tmpquery = "WHERE cal.project = '{$viewCalend}' AND ((cal.date_start <= '{$dateCalend}' AND cal.date_end >= '{$dateCalend}' AND cal.recurring = '0') OR ((cal.date_start <= '{$dateCalend}' AND cal.date_end <= '{$dateCalend}') AND cal.recurring = '1' AND cal.recur_day = '{$dayRecurr}')) ORDER BY cal.shortname";
}
// $tmpquery = "WHERE cal.owner = '" . $_SESSION['idSession'] . "' AND cal.date_start <= '$dateCalend' AND cal.date_end >= '$dateCalend' ORDER BY $block1->sortingValue";
$listCalendar = new request();
$listCalendar->openCalendar($tmpquery);
$comptListCalendar = count($listCalendar->cal_id);
if ($comptListCalendar != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["shortname"], 1 => $strings["subject"], 2 => $strings["date_start"], 3 => $strings["date_end"]), "false");
for ($i = 0; $i < $comptListCalendar; $i++) {
$block1->openRow($listCalendar->cal_id[$i]);
$block1->checkboxRow($listCalendar->cal_id[$i]);
$block1->cellRow(buildLink("../calendar/viewcalendar.php?{$dateEnreg}=" . $listCalendar->cal_id[$i] . "&viewCalend={$viewCalend}&type=calendDetail&dateCalend={$dateCalend}", $listCalendar->cal_shortname[$i], LINK_INSIDE));
$block1->cellRow($listCalendar->cal_subject[$i]);
$block1->cellRow($listCalendar->cal_date_start[$i]);
$block1->cellRow($listCalendar->cal_date_end[$i]);
$block1->closeRow();
}
$block1->closeResults();
} else {
$block1->noresults();
}
$block1->closeFormResults();
$block1->openPaletteScript();
$block1->paletteScript(0, "add", "../calendar/viewcalendar.php?viewCalend={$viewCalend}&dateCalend={$dateCalend}&type=calendEdit", "true,false,false", $strings["add"]);
$block1->paletteScript(1, "remove", "../calendar/deletecalendar.php?", "false,true,true", $strings["delete"]);
$block1->paletteScript(2, "info", "../calendar/viewcalendar.php?viewCalend={$viewCalend}&dateCalend={$dateCalend}&type=calendDetail", "false,true,false", $strings["view"]);
$block3->paletteIcon(2, 'info', $strings['view']);
if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') {
$block3->paletteIcon(3, 'edit', $strings['edit']);
}
$block3->closePaletteIcon();
$block3->sorting('users', $sortingUser->sor_users[0], 'mem.name ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mem.login', 2 => 'mem.email_work', 3 => 'mem.profil', 4 => 'connected'));
$tmpquery = "WHERE mem.organization = '{$id}' ORDER BY {$block3->sortingValue}";
$listMembers = new request();
$listMembers->openMembers($tmpquery);
$comptListMembers = count($listMembers->mem_id);
if ($comptListMembers != '0') {
$block3->openResults();
$block3->labels($labels = array(0 => $strings['full_name'], 1 => $strings['user_name'], 2 => $strings['email'], 3 => $strings['work_phone'], 4 => $strings['connected']), 'false');
for ($i = 0; $i < $comptListMembers; $i++) {
$block3->openRow($listMembers->mem_id[$i]);
$block3->checkboxRow($listMembers->mem_id[$i]);
$block3->cellRow(buildLink('../users/viewclientuser.php?id=' . $listMembers->mem_id[$i] . "&organization={$id}", $listMembers->mem_name[$i], LINK_INSIDE));
$block3->cellRow($listMembers->mem_login[$i]);
$block3->cellRow(buildLink($listMembers->mem_email_work[$i], $listMembers->mem_email_work[$i], LINK_MAIL));
$block3->cellRow($listMembers->mem_phone_work[$i]);
$z = '(Client on project site)';
if ($listMembers->mem_log_connected[$i] > $dateunix - 5 * 60) {
$block3->cellRow($strings['yes'] . ' ' . $z);
} else {
$block3->cellRow($strings['no']);
}
}
$block3->closeResults();
} else {
$block3->noresults();
}
$block6->form = "notesForm";
$block6->openForm("../search/resultssearch.php?searchfor={$searchfor}&heading={$heading}#" . $block6->form . "Anchor");
$block6->headingForm($strings["search_results"] . " : " . $strings["notes"] . " ({$block6->recordsTotal})");
/*$block6->openPaletteIcon();
$block6->paletteIcon(0,"export",$strings["export"]);
$block6->closePaletteIcon();*/
$block6->openResults();
if ($comptTopic != "0") {
$block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["topic"], 2 => $strings["date"], 3 => $strings["owner"], 4 => $strings["published"]), "true");
} else {
$block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["date"], 2 => $strings["owner"], 3 => $strings["published"]), "true");
}
for ($i = 0; $i < $comptListNotes; $i++) {
$idPublish = $listNotes->note_published[$i];
$block6->openRow($listNotes->note_id[$i]);
$block6->checkboxRow($listNotes->note_id[$i]);
$block6->cellRow(buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], LINK_INSIDE));
if ($comptTopic != "0") {
$block6->cellRow($topicNote[$listNotes->note_topic[$i]]);
}
$block6->cellRow($listNotes->note_date[$i]);
$block6->cellRow(buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], LINK_MAIL));
if ($sitePublish == "true") {
$block6->cellRow($statusPublish[$idPublish]);
}
$block6->closeRow();
}
$block6->closeResults();
$block6->bornesFooter("6", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}");
$block6->closeToggle();
$block3->headingForm_close();
}
$block1->recordsTotal = compt($initrequest["projects"] . " " . $tmpquery);
$listProjects = new request();
$listProjects->openProjects($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListProjects = count($listProjects->pro_id);
if ($comptListProjects != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["id"], 1 => $strings["project"], 2 => $strings["priority"], 3 => $strings["organization"], 4 => $strings["status"], 5 => $strings["owner"], 6 => $strings["project_site"]), "true");
for ($i = 0; $i < $comptListProjects; $i++) {
if ($listProjects->pro_org_id[$i] == "1") {
$listProjects->pro_org_name[$i] = $strings["none"];
}
$idStatus = $listProjects->pro_status[$i];
$idPriority = $listProjects->pro_priority[$i];
$block1->openRow();
$block1->checkboxRow($listProjects->pro_id[$i]);
$block1->cellRow($blockPage->buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_id[$i], in));
$block1->cellRow($blockPage->buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_name[$i], in));
$block1->cellRow("<img src=\"../themes/" . THEME . "/gfx_priority/" . $idPriority . ".gif\" alt=\"\"> " . $priority[$idPriority]);
$block1->cellRow($listProjects->pro_org_name[$i]);
$block1->cellRow($status[$idStatus]);
$block1->cellRow($blockPage->buildLink($listProjects->pro_mem_email_work[$i], $listProjects->pro_mem_login[$i], mail));
if ($sitePublish == "true") {
if ($listProjects->pro_published[$i] == "1") {
$block1->cellRow("<" . $blockPage->buildLink("../projects/addprojectsite.php?id=" . $listProjects->pro_id[$i], $strings["create"] . "...", in) . ">");
} else {
$block1->cellRow("<" . $blockPage->buildLink("../projects/viewprojectsite.php?id=" . $listProjects->pro_id[$i], $strings["details"], in) . ">");
}
}
$block1->closeRow();
}
$listTasks = new request();
$listTasks->openTasks($tmpqueryTask);
$comptListTasks = count($listTasks->tas_id);
$blockProject->openResults("false");
$blockProject->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["status"], 3 => $strings["due_date"], 4 => $strings["completed"], 5 => $strings["assigned_to"], 6 => $strings["published"]), "true");
if ($comptListProjects != "0") {
for ($i = 0; $i < $comptListTasks; $i++) {
if ($listTasks->tas_due_date[$i] == "--" or $listTasks->tas_due_date[$i] == "") {
$listTasks->tas_due_date[$i] = $strings["none"];
}
$idStatus = $listTasks->tas_status[$i];
$idPriority = $listTasks->tas_priority[$i];
$idPublished = $listTasks->tas_published[$i];
$complValue = $listTasks->tas_completion[$i] > 0 ? $listTasks->tas_completion[$i] . "0 %" : $listTasks->tas_completion[$i] . " %";
$blockProject->openRow();
$blockProject->checkboxRow($listTasks->tas_id[$i], $checkbox = "false");
$blockProject->cellRow(buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_name[$i], LINK_INSIDE));
$blockProject->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '"> ' . $priority[$idPriority], '', true);
$blockProject->cellRow($status[$idStatus]);
$blockProject->cellRow($listTasks->tas_due_date[$i]);
if ($complValue != "100 %") {
$blockProject->cellRow($complValue);
} else {
$blockProject->cellRow($listTasks->tas_complete_date[$i]);
}
if ($listTasks->tas_assigned_to[$i] == "0") {
$blockProject->cellRow($strings["unassigned"]);
} else {
$blockProject->cellRow($listTasks->tas_mem_login[$i]);
}
$blockProject->cellRow($statusPublish[$idPublished]);
}
$block3 = new block();
$block3->form = "ahT";
$block3->openForm("../tasks/viewtask.php?id={$id}#" . $block3->form . "Anchor");
$block3->headingToggle($strings["assignment_history"]);
$block3->headingToggle_close();
$block3->sorting("assignment", $sortingUser->sor_assignment[0], "ass.assigned DESC", $sortingFields = array(0 => "ass.comments", 1 => "mem1.login", 2 => "mem2.login", 3 => "ass.assigned"));
$tmpquery = "WHERE ass.task = '{$id}' ORDER BY {$block3->sortingValue}";
$listAssign = new request();
$listAssign->openAssignments($tmpquery);
$comptListAssign = count($listAssign->ass_id);
$block3->openResults($checkbox = "false");
$block3->labels($labels = array(0 => $strings["comment"], 1 => $strings["assigned_by"], 2 => $strings["to"], 3 => $strings["assigned_on"]), "false");
for ($i = 0; $i < $comptListAssign; $i++) {
$block3->openRow();
$block3->checkboxRow($listAssign->ass_id[$i], $checkbox = "false");
if ($listAssign->ass_comments[$i] != "") {
$block3->cellRow($listAssign->ass_comments[$i]);
} else {
if ($listAssign->ass_assigned_to[$i] == "0") {
$block3->cellRow($strings["task_unassigned"]);
} else {
$block3->cellRow($strings["task_assigned"] . " " . $listAssign->ass_mem2_name[$i] . " (" . $listAssign->ass_mem2_login[$i] . ")");
}
}
$block3->cellRow(buildLink($listAssign->ass_mem1_email_work[$i], $listAssign->ass_mem1_login[$i], LINK_MAIL));
if ($listAssign->ass_assigned_to[$i] == "0") {
$block3->cellRow($strings["unassigned"]);
} else {
$block3->cellRow(buildLink($listAssign->ass_mem2_email_work[$i], $listAssign->ass_mem2_login[$i], LINK_MAIL));
}
$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->closeResults();
} else {
$block1->noresults();
}
$block1->closeFormResults();
include '../themes/' . THEME . '/footer.php';
$heading_text = "{$heading_text} {$strings['reports_from']} {$s_sdate2} {$strings['reports_to']} {$s_edate2}";
}
$heading_text = $heading_text . ': ' . ($comptListHours == 1 ? "{$comptListHours} {$strings['match']}" : "{$comptListHours} {$strings['matches']}");
// set up the header string
$block1->heading($heading_text);
// initialize counters
$totalMemHours = 0;
$block1->openPaletteIcon();
$block1->paletteIcon(0, "export", $strings["export"]);
$block1->closePaletteIcon();
if ($comptListHours != "0") {
$block1->openResults($checkbox = "false");
$block1->labels($labels = array(0 => $strings["organization"], 1 => $strings["project"], 2 => $strings["name"], 3 => $strings["date"], 4 => $strings["type"], 5 => $strings["service"], 6 => $strings["hours"]), "true");
for ($i = 0; $i < $comptListHours; $i++) {
$block1->openRow();
$block1->checkboxRow($listHours->tim_id[$i], $checkbox = "false");
$block1->cellRow($listHours->tim_org_name[$i]);
$block1->cellRow(buildLink("../projects/viewproject.php?id=" . $listHours->tim_project[$i], $listHours->tim_pro_name[$i], LINK_INSIDE));
$block1->cellRow($listHours->tim_mem_name[$i]);
$block1->cellRow($listHours->tim_date[$i]);
$block1->cellRow($projectType[$listHours->tim_pro_type[$i]]);
// $block1->contentRow($strings["type"],$projectType[$projectDetail->pro_type[0]]);
$block1->cellRow($listHours->tim_svc_name[$i]);
$block1->cellRow($listHours->tim_hours[$i]);
$block1->closeRow();
// add to total hours
$totalMemHours += $listHours->tim_hours[$i];
}
// print the totals
$block1->openRow();
$block1->checkboxRow($listHours->tim_id[$i], $checkbox = "false");
$block2->rowsLimit = "20";
$block2->sorting('meetings_time', $sortingUser->sor_meetings_time[0], 'mti.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mti.date', 2 => 'mti.hours', 3 => 'mti.created', 4 => 'mti.modified', 5 => 'mti.comments'));
$tmpquery = "WHERE mti.meeting = '{$id}' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest["meetings_time"] . " " . $tmpquery);
$listMeetingTimes = new request();
$listMeetingTimes->openMeetingTime($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListMeetingTimes = count($listMeetingTimes->mti_id);
if ($comptListMeetingTimes != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["owner"], 1 => $strings["date"], 2 => ucfirst($strings["hours"]), 3 => $strings["created"], 4 => $strings["modified"], 5 => $strings['comment']), "true");
// display logged hours for project
for ($i = 0; $i < $comptListMeetingTimes; $i++) {
// only PM, PMA, and OWNERS can modify/delete
if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listMeetingTimes->mti_owner[$i]) {
$block2->openRow($listMeetingTimes->mti_id[$i]);
$block2->checkboxRow($listMeetingTimes->mti_id[$i], 'true');
$block2->cellRow($listMeetingTimes->mti_mem_name[$i]);
$block2->cellRow($listMeetingTimes->mti_date[$i]);
$block2->cellRow($listMeetingTimes->mti_hours[$i]);
$block2->cellRow($listMeetingTimes->mti_created[$i]);
$block2->cellRow($listMeetingTimes->mti_modified[$i]);
// truncate large comments to keep the display clean
$comments = $listMeetingTimes->mti_comments[$i];
$lenComm = 40;
if (strLen($comments) > $lenComm) {
$comments = substr($listMeetingTimes->mti_comments[$i], 0, $lenComm) . ' ...';
}
$block2->cellRow($comments);
$block2->closeRow();
}
}
$block2->openContent();
$block2->sorting('team', $sortingUser->sor_team[0], 'mem.name ASC', $sortingFields = array(0 => 'mem.name', 1 => 'mem.title', 2 => 'mem.login', 3 => 'mem.phone_work', 4 => 'log.connected', 5 => 'tea.published'));
$tmpquery = "WHERE tea.project = '{$id}' AND mem.profil = '3' ORDER BY {$block2->sortingValue}";
$listPermitted = new request();
$listPermitted->openTeams($tmpquery);
$comptListPermitted = count($listPermitted->tea_id);
if ($comptListPermitted != '0') {
$block2->openResults();
$block2->labels($labels = array(0 => $strings['full_name'], 1 => $strings['title'], 2 => $strings['user_name'], 3 => $strings['work_phone'], 4 => $strings['connected'], 5 => $strings['published']), 'true');
for ($i = 0; $i < $comptListPermitted; $i++) {
if ($listPermitted->tea_mem_phone_work[$i] == '') {
$listPermitted->tea_mem_phone_work[$i] = $strings['none'];
}
$idPublish = $listPermitted->tea_published[$i];
$block2->openRow($listPermitted->tea_mem_id[$i]);
$block2->checkboxRow($listPermitted->tea_mem_id[$i]);
$block2->cellRow(buildLink('../users/viewclientuser.php?id=' . $listPermitted->tea_mem_id[$i] . '&organization=' . $projectDetail->pro_organization[0], $listPermitted->tea_mem_name[$i], LINK_INSIDE));
$block2->cellRow($listPermitted->tea_mem_title[$i]);
$block2->cellRow(buildLink($listPermitted->tea_mem_email_work[$i], $listPermitted->tea_mem_login[$i], LINK_MAIL));
$block2->cellRow($listPermitted->tea_mem_phone_work[$i]);
if ($listPermitted->tea_mem_profil[$i] == '3') {
$z = '(Client on project site)';
} else {
$z = '';
}
if ($listPermitted->tea_log_connected[$i] > $dateunix - 5 * 60) {
$block2->cellRow($strings['yes'] . ' ' . $z);
} else {
$block2->cellRow($strings['no']);
}
if ($sitePublish == 'true') {
}
}
$block1->heading(text("Phrases") . " ( " . $pagestr . " )");
$block1->openPaletteIcon();
$block1->paletteIcon(1, "remove", text("delete"));
$block1->closePaletteIcon();
// ok, now to list up all the phrases
$block1->openResults();
$block1->labels($labels = array(0 => text('Label'), 1 => text('Translation')), $published = "true", "true", $sortingOff = array(0 => '0', 1 => 'DESC'));
reset($translations);
$id = 0;
$checkboxes = array();
foreach ($translations as $key => $value) {
if ($id >= $offset && $id < $offset + $pagesize) {
$block1->openRow($id);
$block1->checkboxRow($id);
$block1->cellRow(htmlspecialchars($key, ENT_QUOTES));
$block1->cellRow("<input type='hidden' name='key" . $id . "' value=\"" . htmlspecialchars($key, ENT_QUOTES) . "\">" . "<input size='80' name='trans" . $id . "' value=\"" . htmlspecialchars($value, ENT_QUOTES) . "\">", 100);
$block1->closeRow();
$checkboxes[] = $id;
}
$id++;
}
$block1->closeResults();
$block1->openContent();
echo "<TR><TD ALIGN='right'>";
echo text("click_to_save") . ": <input type='submit' value='" . text('save_translation') . "'>";
echo "</TD></TR>";
$block1->closeContent();
$block1->openPaletteScript();
$block1->paletteScript(1, "remove", "../administration/edit_language.php?language=" . $sellang . "&offset=" . $offset . "&action=delete", "false,true,true", text("delete"));
$block1->rowsLimit = "20";
$block1->sorting("meetings", $sortingUser->sor_meetings[0], 'mee.date DESC', $sortingFields = array(0 => 'mee.id', 1 => 'mee.name', 2 => 'mee.priority', 3 => 'mee.status', 4 => 'mee.date'));
$tmpquery = "WHERE mee.project = '{$project}' ORDER BY {$block1->sortingValue}";
$block1->recordsTotal = compt($initrequest["meetings"] . " " . $tmpquery);
$listMeetings = new request();
$listMeetings->openMeetings($tmpquery, $block1->borne, $block1->rowsLimit);
$comptListMeetings = count($listMeetings->mee_id);
if ($comptListMeetings != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings['id'], 1 => $strings['meeting'], 2 => $strings['priority'], 3 => $strings['status'], 4 => $strings['date']), 'true');
for ($i = 0; $i < $comptListMeetings; $i++) {
$idStatus = $listMeetings->mee_status[$i];
$idPriority = $listMeetings->mee_priority[$i];
$idPublish = $listMeetings->mee_published[$i];
$block1->openRow($listMeetings->mee_id[$i]);
$block1->checkboxRow($listMeetings->mee_id[$i]);
$block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_id[$i], LINK_INSIDE));
if ($idStatus == 1) {
$block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_name[$i], LINK_STRIKE));
} else {
$block1->cellRow(buildLink("../meetings/viewmeeting.php?id=" . $listMeetings->mee_id[$i], $listMeetings->mee_name[$i], LINK_INSIDE));
}
$block1->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '"> ' . $priority[$idPriority], '', true);
$block1->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true);
if ($listMeetings->mee_date[$i] <= $date && $idStatus != 1) {
$block1->cellRow("<b>" . $listMeetings->mee_date[$i] . "</b>");
} else {
$block1->cellRow($listMeetings->mee_date[$i]);
}
$block1->cellRow($complValue);
$block1->closeRow();
$block2->rowsLimit = "20";
$block2->sorting('tasks_time', $sortingUser->sor_tasks_time[0], 'tim.date ASC', $sortingFields = array(0 => 'mem.name', 1 => 'tim.date', 2 => 'tim.hours', 3 => 'tim.created', 4 => 'tim.modified', 5 => 'tim.comments'));
$tmpquery = "WHERE tim.task = '{$id}' ORDER BY {$block2->sortingValue}";
$block2->recordsTotal = compt($initrequest["tasks_time"] . " " . $tmpquery);
$listTaskTimes = new request();
$listTaskTimes->openTaskTime($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTaskTimes = count($listTaskTimes->tim_id);
if ($comptListTaskTimes != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["owner"], 1 => $strings["date"], 2 => ucfirst($strings["hours"]), 3 => $strings["created"], 4 => $strings["modified"], 5 => $strings['comment']), "true");
// display logged hours for project
for ($i = 0; $i < $comptListTaskTimes; $i++) {
// only PM, PMA, and OWNERS can modify/delete
if ($_SESSION['profilSession'] == 1 or $_SESSION['profilSession'] == 5 or $_SESSION['idSession'] == $listTaskTimes->tim_owner[$i]) {
$block2->openRow($listTaskTimes->tim_id[$i]);
$block2->checkboxRow($listTaskTimes->tim_id[$i], 'true');
$block2->cellRow($listTaskTimes->tim_mem_name[$i]);
$block2->cellRow($listTaskTimes->tim_date[$i]);
$block2->cellRow($listTaskTimes->tim_hours[$i]);
$block2->cellRow($listTaskTimes->tim_created[$i]);
$block2->cellRow($listTaskTimes->tim_modified[$i]);
// truncate large comments to keep the display clean
$comments = $listTaskTimes->tim_comments[$i];
$lenComm = 40;
if (strLen($comments) > $lenComm) {
$comments = substr($listTaskTimes->tim_comments[$i], 0, $lenComm) . ' ...';
}
$block2->cellRow($comments);
$block2->closeRow();
}
}
$block1->openPaletteScript();
$block1->paletteScript(0,"export","../reports/exportcompleted.php?s_date2=$s_date2&","true,false,false",$strings["export"]);
$block1->closePaletteScript($comptListOrganizations,$listOrganizations->org_id);
*/
// set up the header string
$headerString = $strings['project_breakdown'];
$headerString .= ': ' . ($comptListProjects == 1 ? "{$comptListProjects} {$strings['match']}" : "{$comptListProjects} {$strings['matches']}");
$block1->heading($headerString);
$block1->heading_close();
if ($comptListProjects != "0") {
$block1->openResults($checkbox = "false");
$block1->labels($labels = array(0 => $strings["owner"], 1 => $strings["project"], 2 => $strings["organization"], 3 => $strings["status"]), "false");
for ($i = 0; $i < $comptListProjects; $i++) {
$idStatus = $listProjects->pro_status[$i];
$block1->openRow();
$block1->checkboxRow($listProjects->pro_id[$i], $checkbox = "false");
if ($listProjects->pro_owner[$i] == "0") {
$block1->cellRow($strings["unassigned"]);
} else {
$block1->cellRow(buildLink($listProjects->pro_mem_email_work[$i], $listProjects->pro_mem_name[$i], LINK_MAIL));
}
$block1->cellRow(buildLink("../projects/viewproject.php?id=" . $listProjects->pro_id[$i], $listProjects->pro_name[$i], LINK_INSIDE));
$block1->cellRow(buildLink("../clients/viewclient.php?id=" . $listProjects->pro_org_id[$i], $listProjects->pro_org_name[$i], LINK_INSIDE));
// $block1->cellRow($listProjects->pro_status[$i]);
$block1->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true);
$block1->closeRow();
}
$block1->closeResults();
} else {
$block1->noresults();
}
$block1->paletteIcon(5, "email", $strings["email"]);
$block1->closePaletteIcon();
$block1->sorting("team", $sortingUser->sor_team[0], "mem.name ASC", $sortingFields = array(0 => "mem.name", 1 => "mem.title", 2 => "mem.login", 3 => "mem.phone_work", 4 => "log.connected", 5 => "tea.published"));
$tmpquery = "WHERE tea.project = '{$id}' AND mem.profil != '3' ORDER BY {$block1->sortingValue}";
$listTeam = new request();
$listTeam->openTeams($tmpquery);
$comptListTeam = count($listTeam->tea_id);
$block1->openResults();
$block1->labels($labels = array(0 => $strings["full_name"], 1 => $strings["title"], 2 => $strings["user_name"], 3 => $strings["work_phone"], 4 => $strings["connected"], 5 => $strings["published"]), "true");
for ($i = 0; $i < $comptListTeam; $i++) {
if ($listTeam->tea_mem_phone_work[$i] == "") {
$listTeam->tea_mem_phone_work[$i] = $strings["none"];
}
$idPublish = $listTeam->tea_published[$i];
$block1->openRow();
$block1->checkboxRow($listTeam->tea_mem_id[$i]);
$block1->cellRow($blockPage->buildLink("../users/viewuser.php?id=" . $listTeam->tea_mem_id[$i], $listTeam->tea_mem_name[$i], in));
$block1->cellRow($listTeam->tea_mem_title[$i]);
$block1->cellRow($blockPage->buildLink($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_login[$i], mail));
$block1->cellRow($listTeam->tea_mem_phone_work[$i]);
if ($listTeam->tea_log_connected[$i] > $dateunix - 5 * 60) {
$block1->cellRow($strings["yes"] . " " . $z);
} else {
$block1->cellRow($strings["no"]);
}
if ($sitePublish == "true") {
$block1->cellRow($statusPublish[$idPublish]);
}
$block1->closeRow();
}
$block1->closeResults();
$block2->paletteIcon(1, "edit", $strings["edit_newsdesk_comment"]);
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
$block2->paletteIcon(2, "remove", $strings["del_newsdesk_comment"]);
}
$block2->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("2");
$block2->openContent();
if ($comptCommentsDetail != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["name"], 1 => $strings["comment"]), "true");
for ($i = 0; $i < $comptCommentsDetail; $i++) {
$tmpquery_user = "******" . $newsComments->newscom_name[$i] . "' ";
$newsAuthor = new request();
$newsAuthor->openMembers($tmpquery_user);
$block2->openRow();
$block2->checkboxRow($newsComments->newscom_id[$i]);
$block2->cellRow($newsAuthor->mem_name[0]);
$block2->cellRow($newsComments->newscom_comment[$i]);
$block2->closeRow();
}
$block2->closeResults();
$block2->bornesFooter("1", $blockPage->bornesNumber, "", "");
} else {
$block2->noresults();
}
$block2->closeToggle();
$block2->closeFormResults();
$block2->closeContent();
$block2->openPaletteScript();
$block2->paletteScript(0, "add", "../newsdesk/editmessage.php?postid={$id}&", "true,false,false", $strings["add_newsdesk_comment"]);
$block2->paletteScript(1, "edit", "../newsdesk/editmessage.php?postid={$id}&", "false,true,false", $strings["edit_newsdesk_comment"]);
