$block2->paletteScript(0, "add", "../projects/editproject.php?organization=" . $clientDetail->org_id[0] . "", "true,false,false", $strings["add"]);
$block2->paletteScript(1, "remove", "../projects/deleteproject.php?", "false,true,false", $strings["delete"]);
}
$block2->paletteScript(2, "info", "../projects/viewproject.php?", "false,true,false", $strings["view"]);
if ($profilSession == "0" || $profilSession == "1") {
$block2->paletteScript(3, "edit", "../projects/editproject.php?", "false,true,false", $strings["edit"]);
}
//if mantis bug tracker enabled
if ($enableMantis == "true") {
$block2->paletteScript(4, "bug", $pathMantis . "login.php?url=http://{$HTTP_HOST}{$REQUEST_URI}&username={$loginSession}&password={$passwordSession}", "false,true,false", $strings["bug"]);
}
$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);
$block2->paletteScript(0, 'add', '../projects/editproject.php?organization=' . $clientDetail->org_id[0], 'true,false,false', $strings['add']);
$block2->paletteScript(1, 'remove', '../projects/deleteproject.php?', 'false,true,false', $strings['delete']);
}
$block2->paletteScript(2, 'info', '../projects/viewproject.php?', 'false,true,false', $strings['view']);
if ($_SESSION['profilSession'] == '0' || $_SESSION['profilSession'] == '1' || $_SESSION['profilSession'] == '5') {
$block2->paletteScript(3, 'edit', '../projects/editproject.php?', 'false,true,false', $strings['edit']);
}
// if mantis bug tracker enabled
if ($enableMantis == 'true') {
$block2->paletteScript(4, 'bug', $pathMantis . "login.php?url=http://{$HTTP_HOST}{$REQUEST_URI}&f_username="******"&f_password="******"../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);
$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') {
$block6->paletteIcon(3, 'add_projectsite', $strings['add_project_site']);
$block6->paletteIcon(4, 'remove_projectsite', $strings['remove_project_site']);
}
}
$block6->paletteIcon(5, 'info', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$block6->paletteIcon(6, 'edit', $strings['edit']);
}
$block6->closePaletteIcon();
/*if ($sitePublish == "true") {
$block5->paletteScript(3,"add_projectsite","../general/home.php?addToSite=true&project=".$projectDetail->pro_id[0]."&action=publish","false,true,true",$strings["add_project_site"]);
$block5->paletteScript(4,"remove_projectsite","../general/home.php?removeToSite=true&project=".$projectDetail->pro_id[0]."&action=publish","false,true,true",$strings["remove_project_site"]);
}*/
$block5->paletteScript(5, "info", "../notes/viewnote.php", "false,true,false", $strings["view"]);
$block5->paletteScript(6, "edit", "../notes/editnote.php?project={$project}", "false,true,false", $strings["edit"]);
$block5->closePaletteScript($comptListNotes, $listNotes->note_id);
$block4 = new block();
$block4->form = "wbSe";
$block4->openForm("../general/home.php#" . $block4->form . "Anchor");
$block4->sorting("home_reports", $sortingUser->sor_home_reports[0], "rep.name ASC", $sortingFields = array(0 => "rep.name", 1 => "rep.created"));
$tmpquery = "WHERE rep.owner = '" . $_SESSION['idSession'] . "' ORDER BY {$block4->sortingValue}";
$listReports = new request();
$listReports->openReports($tmpquery);
$comptListReports = count($listReports->rep_id);
$block4->headingToggle($strings["my_reports"] . " <span class=addition>({$comptListReports})</span>");
$block4->openPaletteIcon();
$block4->paletteIcon(0, "add", $strings["new"]);
$block4->paletteIcon(1, "remove", $strings["delete"]);
$block4->paletteIcon(2, "info", $strings["view"]);
$block4->closePaletteIcon();
if ($comptListReports != "0") {
$block4->openResults();
$block4->labels($labels = array(0 => $strings["name"], 1 => $strings["created"]), "false");
for ($i = 0; $i < $comptListReports; $i++) {
$block4->openRow($listReports->rep_id[$i]);
$block4->checkboxRow($listReports->rep_id[$i]);
$block4->cellRow(buildLink("../reports/resultsreport.php?id=" . $listReports->rep_id[$i], $listReports->rep_name[$i], LINK_INSIDE), "31");
$block4->cellRow(createDate($listReports->rep_created[$i], $_SESSION['timezoneSession']));
$block4->closeRow();
}
$block1->paletteScript(0, "remove", "../meetings/deletemeetings.php?project=" . $meetingDetail->mee_project[0] . "&id=" . $meetingDetail->mee_id[0] . "", "true,true,false", $strings["delete"]);
$block1->paletteScript(1, "copy", "../meetings/editmeeting.php?project=" . $meetingDetail->mee_project[0] . "&id=" . $meetingDetail->mee_id[0] . '&cpy=true', "true,true,false", $strings["copy"]);
// $block1->paletteScript(2,"export","export.php?","true,true,false",$strings["export"]);
if ($sitePublish == "true") {
$block1->paletteScript(3, "add_projectsite", "../meetings/viewmeeting.php?addToSite=true&id=" . $meetingDetail->mee_id[0] . "&action=publish", "true,true,true", $strings["add_project_site"]);
$block1->paletteScript(4, "remove_projectsite", "../meetings/viewmeeting.php?removeToSite=true&id=" . $meetingDetail->mee_id[0] . "&action=publish", "true,true,true", $strings["remove_project_site"]);
}
$block1->paletteScript(5, "edit", "../meetings/editmeeting.php?project=" . $meetingDetail->mee_project[0] . "&id=" . $meetingDetail->mee_id[0] . '&cpy=false', "true,true,false", $strings["edit"]);
$block1->paletteScript(6, "timelog", "../meetings/addmeetingtime.php?id=" . $meetingDetail->mee_id[0], "true,true,false", $strings["loghours"]);
$block1->closePaletteScript("", "");
}
if ($fileManagement == "true") {
$block2 = new block();
$block2->form = "mdC";
$block2->openForm("../meetings/viewmeeting.php?id={$id}#" . $block2->form . "Anchor");
$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"));
$block10->paletteScript(6, 'info', '../tasks/viewtask.php', 'false,true,false', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$block10->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']);
$block10->paletteScript(8, 'timelog', '../tasks/addtasktime.php', 'false,true,false', $strings['loghours']);
}
$block10->closePaletteScript($comptListTasks, $listTasks->tas_id);
if ($fileManagement == "true") {
$block3 = new block();
$block3->form = "tdC";
$block3->openForm("../phases/viewphase.php?id={$id}#" . $block3->form . "Anchor");
$block3->sorting("files", $sortingUser->sor_files[0], "fil.name ASC", $sortingFields = array("fil.extension", "fil.name", "fil.date", "fil.status", "fil.published"));
$tmpquery = "WHERE fil.project = '" . $projectDetail->pro_id[0] . "' AND fil.phase = '" . $phaseDetail->pha_id[0] . "' AND fil.task = '0' AND fil.vc_parent = '0' ORDER BY {$block3->sortingValue}";
$listFiles = new request();
$listFiles->openFiles($tmpquery);
$comptListFiles = count($listFiles->fil_id);
$block3->headingToggle($strings["linked_content"] . ' <span class=addition>(' . $comptListFiles . ')</span>');
$block3->openPaletteIcon();
if ($teamMember == "true" || $_SESSION['profilSession'] == "5") {
$block3->paletteIcon(0, "add", $strings["add"]);
$block3->paletteIcon(1, "remove", $strings["delete"]);
if ($sitePublish == "true") {
$block3->paletteIcon(2, "add_projectsite", $strings["add_project_site"]);
$block3->paletteIcon(3, "remove_projectsite", $strings["remove_project_site"]);
}
}
$block3->paletteIcon(4, "info", $strings["view"]);
if ($teamMember == "true" || $_SESSION['profilSession'] == "5") {
$block3->paletteIcon(5, "edit", $strings["edit"]);
}
$block3->closePaletteIcon();
if ($comptListFiles != "0") {
$block3->cellRow($blockPage->buildLink($listAssign->ass_mem1_email_work[$i], $listAssign->ass_mem1_login[$i], mail));
if ($listAssign->ass_assigned_to[$i] == "0") {
$block3->cellRow($strings["unassigned"]);
} else {
$block3->cellRow($blockPage->buildLink($listAssign->ass_mem2_email_work[$i], $listAssign->ass_mem2_login[$i], mail));
}
$block3->cellRow(createDate($listAssign->ass_assigned[$i], $timezoneSession));
$block3->closeRow();
}
$block3->closeResults();
$block3->closeToggle();
$block3->closeFormResults();
$block4 = new block();
$block4->form = "subT";
$block4->openForm("../tasks/viewtask.php?" . session_name() . "=" . session_id() . "&task={$id}#" . $block4->form . "Anchor");
$block4->headingToggle($strings["subtasks"]);
$block4->openPaletteIcon();
if ($teamMember == "true" || $profilSession == "5") {
$block4->paletteIcon(0, "add", $strings["add"]);
$block4->paletteIcon(1, "remove", $strings["delete"]);
//$block4->paletteIcon(2,"copy",$strings["copy"]);
//$block4->paletteIcon(3,"export",$strings["export"]);
/*if ($sitePublish == "true") {
$block4->paletteIcon(4,"add_projectsite",$strings["add_project_site"]);
$block4->paletteIcon(5,"remove_projectsite",$strings["remove_project_site"]);
}*/
}
$block4->paletteIcon(6, "info", $strings["view"]);
if ($teamMember == "true" || $profilSession == "5") {
$block4->paletteIcon(7, "edit", $strings["edit"]);
}
function prj_displayMyProjectTasks(&$blockPage)
{
global $_TABLES, $_CONF, $_USER, $_COOKIE, $subTaskImg, $progress, $priority, $strings, $labels, $_PRJCONF;
$limitbase = $_COOKIE['alltasksmin'];
if ($limitbase == '') {
$limitbase = 0;
}
$useThisTIDforAjax = 0;
$filterCSV = COM_applyFilter($_COOKIE['filterTasks']);
if ($blockPage == NULL or $blockPage == '') {
$blockPage = new block();
}
$block2 = new block();
if ($msg != "") {
require_once "includes/messages.php";
$blockPage->messagebox($msgLabel);
}
if (!isset($_USER['uid']) or $_USER['uid'] == "") {
$uid = 1;
} else {
$uid = $_USER['uid'];
}
//my tasks
$blockPage->bornesNumber = "2";
$block2 = new block();
$block2->form = "taP";
$block2->openForm($_CONF['site_url'] . "/nexproject/index.php?" . "#" . $block2->form . "Anchor");
$headingTitle = $strings['my_tasks'];
$headingStatusArea = '<span id="ajaxstatus_tasks" class="pluginInfo" style="display:none"> </span>';
$block2->headingToggle($headingTitle, $headingStatusArea);
$block2->borne = $blockPage->returnBorne("2");
$block2->rowsLimit = $_PRJCONF['task_block_rows'];
$lim = $limitbase * $block2->rowsLimit;
echo '<!--startMyTasks-->';
echo '<div id="divMyTasks">';
$sql = "SELECT {$_TABLES['prj_tasks']}.tid FROM {$_TABLES['prj_tasks']}, {$_TABLES['prj_task_users']}, {$_TABLES['users']} ";
$sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.uid={$uid} ";
$sql .= "AND {$_TABLES['prj_task_users']}.role='o' AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
$result = DB_query($sql);
$block2->recordsTotal = DB_numrows($result);
$lim = $limitbase * $block2->rowsLimit;
$sql = "SELECT {$_TABLES['prj_tasks']}.tid,{$_TABLES['prj_tasks']}.progress_id, {$_TABLES['prj_projects']}.name, ";
$sql .= "{$_TABLES['prj_tasks']}.priority_id, {$_TABLES['prj_tasks']}.name, {$_TABLES['prj_tasks']}.estimated_end_date, ";
$sql .= "{$_TABLES['prj_tasks']}.start_date, {$_TABLES['prj_tasks']}.pid FROM {$_TABLES['prj_tasks']}, ";
$sql .= "{$_TABLES['prj_task_users']}, {$_TABLES['users']}, {$_TABLES['prj_projects']} ";
$sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.role='o' ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_tasks']}.pid={$_TABLES['prj_projects']}.pid ";
$sql .= "AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
if ($filterCSV != '') {
$sql .= "AND {$_TABLES['prj_tasks']}.pid in ({$filterCSV})";
}
$sql .= " ORDER BY {$_TABLES['prj_tasks']}.estimated_end_date ";
$sql .= " LIMIT {$lim}, {$block2->rowsLimit} ";
$result = DB_query($sql, true);
$comptListTasks = DB_numrows($result);
if ($result == FALSE) {
//remove the filterCSV as there might be a cookie issue with it...
$sql = "SELECT {$_TABLES['prj_tasks']}.tid,{$_TABLES['prj_tasks']}.progress_id, {$_TABLES['prj_projects']}.name, ";
$sql .= "{$_TABLES['prj_tasks']}.priority_id, {$_TABLES['prj_tasks']}.name, {$_TABLES['prj_tasks']}.estimated_end_date, ";
$sql .= "{$_TABLES['prj_tasks']}.start_date, {$_TABLES['prj_tasks']}.pid FROM {$_TABLES['prj_tasks']}, ";
$sql .= "{$_TABLES['prj_task_users']}, {$_TABLES['users']}, {$_TABLES['prj_projects']} ";
$sql .= "WHERE {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_task_users']}.tid={$_TABLES['prj_tasks']}.tid ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$_TABLES['users']}.uid AND {$_TABLES['prj_task_users']}.role='o' ";
$sql .= "AND {$_TABLES['prj_task_users']}.uid={$uid} AND {$_TABLES['prj_tasks']}.pid={$_TABLES['prj_projects']}.pid ";
$sql .= "AND {$_TABLES['prj_tasks']}.status_id in (0,3) ";
$sql .= " ORDER BY {$_TABLES['prj_tasks']}.estimated_end_date ";
$sql .= " LIMIT {$lim}, {$block2->rowsLimit} ";
$result = DB_query($sql);
$comptListTasks = DB_numrows($result);
}
if ($comptListTasks != "0") {
$block2->openResults(false);
$block2->labels($labels = array(0 => $strings["task"], 1 => $strings["priority"], 2 => $strings["project"], 3 => $strings["start_date"], 4 => $strings["estimated_end_date"]), "true");
for ($i = 0; $i < DB_numrows($result); $i++) {
list($tid, $idProgress, $projectname, $idPriority, $taskname, $estenddate, $startdate, $pid) = DB_fetchArray($result);
$full_projectname = $projectname;
$full_taskname = $taskname;
if (strlen($taskname) > 25) {
$taskname = substr($taskname, 0, 25) . "....";
}
if (strlen($projectname) > 20) {
$projectname = substr($projectname, 0, 20) . "....";
}
$block2->openRow();
//$block2->checkboxRow($pid);
$block2->cellProgress($progress[$idProgress]);
$block2->cellRow($blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?mode=view&id={$tid}", $taskname, "mytaskcontext", $full_taskname, '', $tid));
$block2->cellRow($priority[$idPriority]);
$block2->cellRow($blockPage->buildLink("{$_CONF['site_url']}/nexproject/viewproject.php?pid={$pid}", $projectname, "context", $full_projectname, $pid));
$block2->cellRow(strftime("%Y/%m/%d", $startdate));
$block2->cellRow(strftime("%Y/%m/%d", $estenddate));
$block2->closeRow();
}
$block2->closeResults();
$pages = intval($block2->recordsTotal / $block2->rowsLimit);
if (fmod($block2->recordsTotal, $block2->rowsLimit) > 0) {
$pages += 1;
}
if ($pages > 1) {
for ($pagecntr = 0; $pagecntr < $pages; $pagecntr++) {
echo '<span style="text-decoration:underline;cursor: hand" onclick=\'setCookie("alltasksmin","';
echo $pagecntr;
echo '","","");prj_getMyTasks("myprj_refresh", "' . $useThisTIDforAjax . '" )\'>';
if ($limitbase == $pagecntr) {
echo '<span style="color:red">';
echo $pagecntr + 1;
echo '</span>';
} else {
echo $pagecntr + 1;
}
echo '</span> ';
}
echo ' <span style="text-decoration:underline;cursor: hand" TITLE="Return to page 1" onclick=\'setCookie("alltasksmin","","","");prj_getMyTasks("myprj_refresh", "' . $useThisTIDforAjax . '" )\'>';
echo '<<</span>';
}
} else {
$block2->noresults();
}
echo '</div>';
echo '<!--endMyTasks-->';
echo '<input type=hidden name=pid value=' . $pid . '>';
$block2->closeToggle();
$block2->closeFormResults();
}
$block1->paletteScript(0, "add", "../newsdesk/editnews.php?", "true,true,true", $strings["add_newsdesk"]);
$block1->paletteScript(1, "remove", "../newsdesk/editnews.php?action=remove&id={$id}", "true,false,true", $strings["del_newsdesk"]);
$block1->paletteScript(3, "edit", "../newsdesk/editnews.php?id={$id}", "true,true,true", $strings["edit_newsdesk"]);
}
$block1->closePaletteScript($comptNewsDetail, $newsDetail->news_id);
///////////////////////////////////////////////////////////////////////////////////
///////////////////////////////// comments block //////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////
$tmpquery = "WHERE newscom.post_id = '" . fixInt($id) . "'";
$newsComments = new request();
$newsComments->openNewsDeskComments($tmpquery);
$comptCommentsDetail = count($newsComments->newscom_id);
$block2 = new block();
$block2->form = "clPrc";
$block2->openForm("../newsdesk/viewnews.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block2->form . "Anchor");
$block2->headingToggle($strings["comments"]);
$block2->openPaletteIcon();
$block2->paletteIcon(0, "add", $strings["add_newsdesk_comment"]);
$block2->paletteIcon(1, "edit", $strings["edit_newsdesk_comment"]);
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
$block2->paletteIcon(2, "remove", $strings["del_newsdesk_comment"]);
}
$block2->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("2");
$block2->openContent();
if ($comptCommentsDetail != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["name"], 1 => $strings["comment"]), "true");
for ($i = 0; $i < $comptCommentsDetail; $i++) {
$tmpquery_user = "******" . $newsComments->newscom_name[$i] . "' ";
$newsAuthor = new request();
$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($phaseDetail->pha_name[0]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
include '../includes/messages.php';
$blockPage->messagebox($msgLabel);
}
//set value in form
$sd = $phaseDetail->pha_date_start[0];
$ed = $phaseDetail->pha_date_end[0];
$c = $phaseDetail->pha_comments[0];
$block1 = new block();
$block1->form = "pdD";
$block1->headingToggle($strings["phase"] . " : " . $phaseDetail->pha_name[0]);
$block1->openContent();
$block1->contentTitle($strings["details"]);
$block1->form = "filedetails";
echo "<a name='filedetailsAnchor'></a>";
echo "<form accept-charset='UNKNOWN' method='POST' action='../phases/editphase.php?id={$id}&action=update&" . session_name() . "=" . session_id() . "#filedetailsAnchor' name='filedetailsForm' enctype='multipart/form-data'>\n\t\t<input type='hidden' name='MAX_FILE_SIZE' value='100000000'>\n\t\t<input type='hidden' name='maxCustom' value='" . $projectDetail->pro_upload_max[0] . "'>\n\t ";
echo "<tr class='odd'><td valign='top' class='leftvalue'>" . $strings["name"] . " :</td><td>" . $phaseDetail->pha_name[0] . "</td></tr>";
echo "<tr class='odd'><td valign='top' class='leftvalue'>" . $strings["phase_id"] . " :</td><td>" . $phaseDetail->pha_id[0] . "</td></tr>";
echo "<tr class='odd'><td valign='top' class='leftvalue'>" . $strings["status"] . " :</td><td><select name='st'>";
$comptSta = count($phaseStatus);
for ($i = 0; $i < $comptSta; $i++) {
if ($phaseDetail->pha_status[0] == $i) {
echo "<option value='{$i}' selected>{$phaseStatus[$i]}</option>";
} else {
echo "<option value='{$i}'>{$phaseStatus[$i]}</option>";
}
}
$blockPage = new block();
$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($strings["phases"]);
$blockPage->closeBreadcrumbs();
if ($msg != "") {
include '../includes/messages.php';
$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();
$block5->cellRow($statusPublish[$idPublish]);
}
$block5->closeRow();
}
$block5->closeResults();
$block5->bornesFooter("5", $blockPage->bornesNumber, "", "searchfor={$searchfor}&heading={$heading}");
$block5->closeToggle();
$block5->closeFormResults();
/*$block5->openPaletteScript();
$block5->paletteScript(0,"export","../projects/exportproject.php?languageSession=$languageSession&type=project","false,true,false",$strings["export"]);
$block5->closePaletteScript($comptListTopics,$listTopics->top_id);*/
}
if ($comptListNotes != "0") {
$block6->form = "notesForm";
$block6->openForm("../search/resultssearch.php?" . session_name() . "=" . session_id() . "&searchfor={$searchfor}&heading={$heading}#" . $block6->form . "Anchor");
$block6->headingToggle($strings["search_results"] . " : " . $strings["notes"] . " ({$block6->recordsTotal})");
/*$block6->openPaletteIcon();
$block6->paletteIcon(0,"export",$strings["export"]);
$block6->closePaletteIcon();*/
$block6->openResults();
if ($comptTopic != "0") {
$block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["topic"], 2 => $strings["date"], 3 => $strings["owner"], 4 => $strings["published"]), "true");
} else {
$block6->labels($labels = array(0 => $strings["subject"], 1 => $strings["date"], 2 => $strings["owner"], 3 => $strings["published"]), "true");
}
for ($i = 0; $i < $comptListNotes; $i++) {
$idPublish = $listNotes->note_published[$i];
$block6->openRow();
$block6->checkboxRow($listNotes->note_id[$i]);
$block6->cellRow($blockPage->buildLink("../notes/viewnote.php?id=" . $listNotes->note_id[$i], $listNotes->note_subject[$i], in));
if ($comptTopic != "0") {
}
$block5->paletteScript(4, "info", "../linkedcontent/viewfile.php?", "false,true,false", $strings["view"]);
if ($teamMember == "true" || $profilSession == "5") {
$block5->paletteScript(5, "edit", "../linkedcontent/viewfile.php?edit=true", "false,true,false", $strings["edit"]);
}
$block5->closePaletteScript($comptListFiles, $listFiles->fil_id);
}
/**
* End Linked Content
* -------------------
* Begin Notes Section
*/
$block6 = new block();
$block6->form = "wbJ";
$block6->openForm("../projects/viewproject.php?" . session_name() . "=" . session_id() . "&id=" . $projectDetail->pro_id[0] . "#" . $block6->form . "Anchor");
$block6->headingToggle($strings["notes"]);
$block6->openPaletteIcon();
if ($teamMember == "true" || $profilSession == "5") {
$block6->paletteIcon(0, "add", $strings["add"]);
$block6->paletteIcon(1, "remove", $strings["delete"]);
//$block6->paletteIcon(2,"export",$strings["export"]);
if ($sitePublish == "true") {
$block6->paletteIcon(3, "add_projectsite", $strings["add_project_site"]);
$block6->paletteIcon(4, "remove_projectsite", $strings["remove_project_site"]);
}
}
$block6->paletteIcon(5, "info", $strings["view"]);
if ($teamMember == "true" || $profilSession == "5") {
$block6->paletteIcon(6, "edit", $strings["edit"]);
}
$block6->closePaletteIcon();
$block2->paletteScript(1, "remove", "../linkedcontent/deletefiles.php?project=" . $projectDetail->pro_id[0] . "&task=" . $taskDetail->tas_id[0] . "", "false,true,true", $strings["delete"]);
if ($sitePublish == "true") {
$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") {
echo '</td></tr></table>';
/* BL: Oct 6, 2004: Not used currently */
if (isset($msg) and $msg != "") {
include "includes/messages.php";
$blockPage->messagebox($msg);
}
$blockPage->bornesNumber = "1";
/* Display the 'All Projects' Block */
prj_displayAllProjects($blockPage);
//gantt chart display area starts here
$blockPage->bornesNumber = "4";
$blockg = new block();
$blockg->form = "gaP";
$headingTitle = 'Gantt Chart';
$headingStatusArea = '<span id="ajaxstatus_gantt" class="pluginInfo" style="display:none"> </span>';
$blockg->headingToggle($headingTitle, $headingStatusArea);
if (isset($_COOKIE['gdate1'])) {
$gdate1 = $_COOKIE['gdate1'];
} else {
if (isset($_GET['gdate1']) and $_GET['gdate1'] != '') {
$gdate1 = $_GET['gdate1'];
} elseif (isset($_POST['gdate1']) and $_POST['gdate1'] != '') {
$gdate1 = $_POST['gdate1'];
} else {
$gdate1 = strftime('%Y/%m/%d', strtotime('-2 weeks'));
}
}
if (isset($_COOKIE['gdate2'])) {
$gdate2 = $_COOKIE['gdate2'];
} else {
if (isset($_POST['gdate2']) and $_POST['gdate2'] != '') {
* Copyright (c) 2003 by the NetOffice developers
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
$checkSession = true;
require_once "../includes/library.php";
$breadcrumbs[] = buildLink("../clients/listclients.php?", $strings["organizations"], LINK_INSIDE);
$breadcrumbs[] = $strings["organizations"];
require_once "../themes/" . THEME . "/header.php";
$block1 = new block();
$block1->form = "clientList";
$block1->openForm("../clients/listclients.php#" . $block1->form . "Anchor");
$block1->headingToggle($strings["organizations"]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "add", $strings["add"]);
$block1->paletteIcon(1, "remove", $strings["delete"]);
$block1->closePaletteIcon();
$block1->sorting("organizations", $sortingUser->sor_organizations[0], "org.name ASC", $sortingFields = array(0 => "org.name", 1 => "org.phone", 2 => "org.url"));
$tmpquery = "WHERE org.id != '1' ORDER BY {$block1->sortingValue}";
$listOrganizations = new request();
$listOrganizations->openOrganizations($tmpquery);
$comptListOrganizations = count($listOrganizations->org_id);
if ($comptListOrganizations != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["name"], 1 => $strings["phone"], 2 => $strings["url"]), "false");
for ($i = 0; $i < $comptListOrganizations; $i++) {
$block1->openRow($listOrganizations->org_id[$i]);
$block1->checkboxRow($listOrganizations->org_id[$i]);
$block4->openPaletteScript();
$block4->paletteScript(0, "info", $_CONF['site_url'] . "/nexfile/details.php", "false,true,false", $strings["view"]);
$block4->paletteScript(1, "add", $_CONF['site_url'] . "/nexfile/index.php?parm=2&op=newprojectfile&cid=" . $cid, "true,true,false", $strings["add"]);
//$block4->paletteScript(2,"remove",$_CONF['site_url'] .
// "/nexfile/details.php?op=deletefile","false,true,false",$strings["delete"]);
$block4->paletteScript(2, "remove", $_CONF['site_url'] . "/nexproject/viewproject.php?pid={$pid}&mode=deletefile", "false,true,false", $strings["delete"]);
$block4->closePaletteScript($comptListTasks, $listDoc->fid);
}
}
}
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 ";
$clientDetail = new request();
$clientDetail->openOrganizations($tmpquery);
$comptClientDetail = count($clientDetail->org_id);
if ($comptClientDetail == "0") {
header('Location: ../clients/listclients.php?msg=blankClient');
exit;
}
//--- header ---
$breadcrumbs[] = buildLink("../clients/listclients.php?", $strings["organizations"], LINK_INSIDE);
$breadcrumbs[] = $strings["organizations"];
//--- content ----
require_once "../themes/" . THEME . "/header.php";
$block1 = new block();
$block1->form = "ecD";
$block1->openForm("../projects/listprojects.php#" . $block1->form . "Anchor");
$block1->headingToggle($strings["organization"] . " : " . $clientDetail->org_name[0]);
$block1->openPaletteIcon();
$block1->paletteIcon(0, "remove", $strings["delete"]);
$block1->paletteIcon(1, "edit", $strings["edit"]);
$block1->closePaletteIcon();
$block1->openContent();
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["name"], $clientDetail->org_name[0]);
$block1->contentRow($strings["address"], $clientDetail->org_address1[0]);
$block1->contentRow($strings["phone"], $clientDetail->org_phone[0]);
$block1->contentRow($strings["url"], buildLink($clientDetail->org_url[0], $clientDetail->org_url[0], LINK_OUT));
$block1->contentRow($strings["email"], buildLink($clientDetail->org_email[0], $clientDetail->org_email[0], LINK_MAIL));
$block1->contentTitle($strings["details"]);
$block1->contentRow($strings["comments"], nl2br($clientDetail->org_comments[0]));
$block1->contentRow($strings["created"], createDate($clientDetail->org_created[0], $_SESSION['timezoneSession']));
$block1->closeContent();
$block1->closeContent();
$block1->closeToggle();
$block1->closeForm();
$block1->openPaletteScript();
$block1->paletteScript(0, "remove", "../invoicing/deleteinvoices.php?id=" . $detailInvoice->inv_id[0] . "&client=" . $projectDetail->pro_org_id[0] . "", "true,true,false", $strings["delete"]);
$block1->paletteScript(2, "export", "exportinvoice.php?id={$id}", "true,true,false", $strings["export"]);
if ($sitePublish == "true") {
$block1->paletteScript(3, "add_projectsite", "../invoicing/viewinvoice.php?addToSite=true&id=" . $detailInvoice->inv_id[0] . "&action=publish", "true,true,true", $strings["add_project_site"]);
$block1->paletteScript(4, "remove_projectsite", "../invoicing/viewinvoice.php?removeToSite=true&id=" . $detailInvoice->inv_id[0] . "&action=publish", "true,true,true", $strings["remove_project_site"]);
}
$block1->paletteScript(5, "edit", "../invoicing/editinvoice.php?id=" . $detailInvoice->inv_id[0], "true,true,false", $strings["edit"]);
$block1->closePaletteScript("", "");
$block2 = new block();
$block2->form = "invoiceItems";
$block2->openForm("../invoicing/viewinvoice.php?id={$id}&" . session_name() . "=" . session_id() . "#" . $block2->form . "Anchor");
$block2->headingToggle($strings["invoice_items"]);
$block2->openPaletteIcon();
//$block2->paletteIcon(6,"info",$strings["view"]);
$block2->paletteIcon(7, "edit", $strings["edit"]);
$block2->closePaletteIcon();
$tmpquery = "WHERE invitem.invoice = '{$id}' AND invitem.active = '1' ORDER BY invitem.position ASC";
$listInvoicesItems = new request();
$listInvoicesItems->openInvoicesItems($tmpquery);
$comptListInvoicesItems = count($listInvoicesItems->invitem_id);
if ($comptListInvoicesItems != "0") {
$block2->openResults();
$block2->labels($labels = array(0 => $strings["position"], 1 => $strings["title"], 2 => $strings["rate_type"], 3 => $strings["rate_value"], 4 => $strings["amount_ex_tax"], 5 => $strings["completed"]), "false", $sorting = "false", $sortingOff = array(0 => "0", 1 => "ASC"));
for ($i = 0; $i < $comptListInvoicesItems; $i++) {
if ($listInvoicesItems->invitem_rate_type[$i] == "a") {
$rate_type_value = "0";
} else {
$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']);
// $block10->paletteIcon(3,'export',$strings['export']);
if ($sitePublish == 'true') {
$block10->paletteIcon(4, 'add_projectsite', $strings['add_project_site']);
$block10->paletteIcon(5, 'remove_projectsite', $strings['remove_project_site']);
}
}
$block10->paletteIcon(6, 'info', $strings['view']);
if ($teamMember == 'true' || $_SESSION['profilSession'] == '5') {
$block10->paletteIcon(7, 'edit', $strings['edit']);
$block10->paletteIcon(8, 'timelog', $strings['loghours']);
//--- header ---
$breadcrumbs[] = buildLink("../administration/admin.php?", $strings["administration"], LINK_INSIDE);
$breadcrumbs[] = buildLink("../users/listusers.php?", $strings["user_management"], LINK_INSIDE);
$breadcrumbs[] = $userDetail->mem_login[0];
$pageSection = 'clients';
$pageTitle = '<span class="type">' . $strings["user_profile"] . '</span><br><span class="name">' . $userDetail->mem_name[0] . '</span>';
require_once "../themes/" . THEME . "/header.php";
//--- content -----
$block1 = new block();
$block1->form = "userD";
$block1->openForm("../users/viewuser.php#" . $block1->form . "Anchor");
if ($error != "") {
$block1->headingError($strings["errors"]);
$block1->contentError($error);
}
$block1->headingToggle($strings["user_profile"]);
$block1->openPaletteIcon();
if ($_SESSION['profilSession'] == "0") {
if ($id != "1" && $id != "2") {
$block1->paletteIcon(0, "remove", $strings["delete"]);
}
$block1->paletteIcon(1, "edit", $strings["edit"]);
}
$block1->paletteIcon(2, "export", $strings["export"]);
$block1->closePaletteIcon();
$block1->openContent();
$block1->contentTitle($strings["user_details"]);
$block1->contentRow($strings["user_name"], $userDetail->mem_login[0]);
$block1->contentRow($strings["full_name"], $userDetail->mem_name[0]);
$block1->contentRow($strings["title"], $userDetail->mem_title[0]);
$block1->contentRow($strings["email"], buildLink($userDetail->mem_email_work[0], $userDetail->mem_email_work[0], LINK_MAIL));
