<?php // $Revision: 1.22 $
/* vim: set expandtab ts=4 sw=4 sts=4: */
/**
* $Id: viewproject.php,v 1.22 2004/01/19 18:05:08 madbear Exp $
*
* 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');
#$id = $_REQUEST['id'];
#$msg = $_REQUEST['msg'];
#$action = $_REQUEST['action'];
#$project = $_REQUEST['project'];
#$addToSiteTask = $_REQUEST['addToSiteTask'];
#$removeToSiteTask = $_REQUEST['removeToSiteTask'];
#$closeTopic = $_REQUEST['closeTopic'];
#$addToSiteTopic = $_REQUEST['addToSiteTopic'];
#$removeToSiteTopic = $_REQUEST['removeToSiteTopic'];
#$addToSiteTeam = $_REQUEST['addToSiteTeam'];
#$removeToSiteTeam = $_REQUEST['removeToSiteTeam'];
#$addToSiteFile = $_REQUEST['addToSiteFile'];
#$removeToSiteFile = $_REQUEST['removeToSiteFile'];
#$addToSiteNote = $_REQUEST['addToSiteNote'];
#$removeToSiteNote = $_REQUEST['removeToSiteNote'];
if ($action == 'publish') {
$closeTopic = $HTTP_GET_VARS['closeTopic'];
if ($closeTopic == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['topics'] . " SET status='0' WHERE id IN($id)";
$pieces = explode(',', $id);
$num = count($pieces);
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['topics'] . " SET status='0' WHERE id = '$id'";
$num = 1;
}
connectSql($tmpquery1);
$msg = 'closeTopic';
$id = $project;
}
$addToSiteTask = $HTTP_GET_VARS['addToSiteTask'];
if ($addToSiteTask == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['tasks'] . " SET published='0' WHERE id IN($id)";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['tasks'] . " SET published='0' WHERE id = '$id'";
}
connectSql($tmpquery1);
$msg = 'addToSite';
$id = $project;
}
$removeToSiteTask = $HTTP_GET_VARS['removeToSiteTask'];
if ($removeToSiteTask == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['tasks'] . " SET published='1' WHERE id IN($id)";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['tasks'] . " SET published='1' WHERE id = '$id'";
}
connectSql($tmpquery1);
$msg = 'removeToSite';
$id = $project;
}
$addToSiteTopic = $HTTP_GET_VARS['addToSiteTopic'];
if ($addToSiteTopic == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['topics'] . " SET published='0' WHERE id IN($id)";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['topics'] . " SET published='0' WHERE id = '$id'";
}
connectSql($tmpquery1);
$msg = 'addToSite';
$id = $project;
}
$removeToSiteTopic = $HTTP_GET_VARS['removeToSiteTopic'];
if ($removeToSiteTopic == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['topics'] . " SET published='1' WHERE id IN($id)";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['topics'] . " SET published='1' WHERE id = '$id'";
}
connectSql($tmpquery1);
$msg = 'removeToSite';
$id = $project;
}
$addToSiteTeam = $HTTP_GET_VARS['addToSiteTeam'];
if ($addToSiteTeam == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['teams'] . " SET published='0' WHERE member IN($id) AND project = '$project'";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['teams'] . " SET published='0' WHERE member = '$id' AND project = '$project'";
}
connectSql($tmpquery1);
$msg = 'addToSite';
$id = $project;
}
$removeToSiteTeam = $HTTP_GET_VARS['removeToSiteTeam'];
if ($removeToSiteTeam == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['teams'] . " SET published='1' WHERE member IN($id) AND project = '$project'";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['teams'] . " SET published='1' WHERE member = '$id' AND project = '$project'";
}
connectSql($tmpquery1);
$msg = 'removeToSite';
$id = $project;
}
$addToSiteFile = $HTTP_GET_VARS['addToSiteFile'];
if ($addToSiteFile == 'true') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['files'] . " SET published='0' WHERE id IN($id) OR vc_parent IN ($id)";
connectSql($tmpquery1);
$msg = 'addToSite';
$id = $project;
}
$removeToSiteFile = $HTTP_GET_VARS['removeToSiteFile'];
if ($removeToSiteFile == 'true') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['files'] . " SET published='1' WHERE id IN($id) OR vc_parent IN ($id)";
connectSql($tmpquery1);
$msg = 'removeToSite';
$id = $project;
}
$addToSiteNote = $HTTP_GET_VARS['addToSiteNote'];
if ($addToSiteNote == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['notes'] . " SET published='0' WHERE id IN($id)";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['notes'] . " SET published='0' WHERE id = '$id'";
}
connectSql($tmpquery1);
$msg = 'addToSite';
$id = $project;
}
$removeToSiteNote = $HTTP_GET_VARS['removeToSiteNote'];
if ($removeToSiteNote == 'true') {
$multi = strstr($id, '**');
if ($multi != '') {
$id = str_replace('**', ',', $id);
$tmpquery1 = 'UPDATE ' . $tableCollab['notes'] . " SET published='1' WHERE id IN($id)";
} else {
$tmpquery1 = 'UPDATE ' . $tableCollab['notes'] . " SET published='1' WHERE id = '$id'";
}
connectSql($tmpquery1);
$msg = 'removeToSite';
$id = $project;
}
}
if ($msg == 'demo') {
$id = $project;
}
$tmpquery = "WHERE pro.id = '$id'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
$comptProjectDetail = count($projectDetail->pro_id);
if ($comptProjectDetail == '0') {
header('Location: ../projects/listprojects.php?msg=blankProject');
exit;
}
$tmpquery = "WHERE tas.project = '$id' ORDER BY tas.name";
$listTasksTime = new request();
$listTasksTime->openTasks($tmpquery);
$comptListTasksTime = count($listTasksTime->tas_id);
if ($comptListTasksTime != '0') {
for ($i = 0; $i < $comptListTasksTime; $i++) {
$estimated_time = $estimated_time + $listTasksTime->tas_estimated_time[$i];
// $actual_time = $actual_time + $listTasksTime->tas_actual_time[$i];
if ($listTasksTime->tas_complete_date[$i] != '' && $listTasksTime->tas_complete_date[$i] != '--' && $listTasksTime->tas_due_date[$i] != '--') {
$diff = diff_date($listTasksTime->tas_complete_date[$i], $listTasksTime->tas_due_date[$i]);
$diff_time = $diff_time + $diff;
}
}
if ($diff_time > 0) {
$diff_time = '<b>+' . $diff_time . '</b>';
}
}
// get Project Actual Time
$projActualTime = new request();
$proj_time = $projActualTime->getProjectTime($id);
$teamMember = 'false';
$tmpquery = "WHERE tea.project = '$id' AND tea.member = '$idSession'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
if ($comptMemberTest == '0') {
$teamMember = 'false';
} else {
$teamMember = 'true';
}
if ($teamMember == 'false' && $projectsFilter == 'true') {
header('Location: ../general/permissiondenied.php');
exit;
}
if ($enableHelpSupport == 'true' && ($teamMember == 'true' || $profilSession == '5')) {
$tmpquery = "WHERE sr.status = '0' AND sr.project = '" . $projectDetail->pro_id[0] . "'";
$listNewRequests = new request();
$listNewRequests->openSupportRequests($tmpquery);
$comptListNewRequests = count($listNewRequests->sr_id);
$tmpquery = "WHERE sr.status = '1' AND sr.project = '" . $projectDetail->pro_id[0] . "'";
$listOpenRequests = new request();
$listOpenRequests->openSupportRequests($tmpquery);
$comptListOpenRequests = count($listOpenRequests->sr_id);
$tmpquery = "WHERE sr.status = '2' AND sr.project = '" . $projectDetail->pro_id[0] . "'";
$listCompleteRequests = new request();
$listCompleteRequests->openSupportRequests($tmpquery);
$comptListCompleteRequests = count($listCompleteRequests->sr_id);
}
require_once('../themes/' . THEME . '/header.php');
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink('../projects/listprojects.php', $strings['projects'], in));
$blockPage->itemBreadcrumbs($projectDetail->pro_name[0]);
$blockPage->closeBreadcrumbs();
if ($msg != '') {
require_once('../includes/messages.php');
$blockPage->messagebox($msgLabel);
}
$blockPage->bornesNumber = '4';
$idStatus = $projectDetail->pro_status[0];
$idPriority = $projectDetail->pro_priority[0];
$block1 = new block();
$block1->form = 'pdD';
$block1->openForm('../projects/listprojects.php#' . $block1->form . 'Anchor');
$block1->headingToggle($strings['project'] . ' : ' . $projectDetail->pro_name[0]);
if ($idSession == $projectDetail->pro_owner[0] || $enable_cvs == 'true' || $profilSession == '0' || $profilSession == '5') {
$block1->openPaletteIcon();
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '0' || $profilSession == '5') {
$block1->paletteIcon(0, 'remove', $strings['delete']);
$block1->paletteIcon(1, 'copy', $strings['copy']);
$block1->paletteIcon(2, 'export', $strings['export']);
$block1->paletteIcon(3, 'edit', $strings['edit']);
}
if ($enable_cvs == 'true') {
$block1->paletteIcon(4, 'cvs', $strings['browse_cvs']);
}
// if mantis bug tracker enabled
if ($enableMantis == 'true') {
$block1->paletteIcon(5, 'bug', $strings['bug']);
}
$block1->closePaletteIcon();
}
$block1->openContent();
$block1->contentTitle($strings['details']);
$block1->contentRow($strings['name'], $projectDetail->pro_name[0]);
$block1->contentRow($strings['project_id'], $projectDetail->pro_id[0]);
$block1->contentRow($strings['priority'], $priority[$idPriority]);
// List open phases and link to phase details
if ($projectDetail->pro_phase_set[0] != '0') {
$tmpquery = "WHERE pha.project_id = '$id' AND status = '1' ORDER BY pha.order_num";
$currentPhase = new request();
$currentPhase->openPhases($tmpquery);
$comptCurrentPhase = count($currentPhase->pha_id);
if ($comptCurrentPhase == 0) {
$block1->contentRow($strings['current_phase'], $strings['no_current_phase']);
} else {
for ($i = 0; $i < $comptCurrentPhase; $i++) {
if ($i != $comptCurrentPhase) {
$pnum = $i + 1;
$phasesList .= "$pnum.<a href=\"../phases/viewphase.php?id=" . $currentPhase->pha_id[$i] . '">' . $currentPhase->pha_name[$i] . '</a> ';
}
}
$block1->contentRow($strings['current_phase'], $phasesList);
}
} else {
$block1->contentRow($strings['phase_enabled'], $strings['false']);
}
$block1->contentRow($strings['description'], nl2br($projectDetail->pro_description[0]));
$block1->contentRow($strings['url_dev'], $blockPage->buildLink($projectDetail->pro_url_dev[0], $projectDetail->pro_url_dev[0], out));
$block1->contentRow($strings['url_prod'], $blockPage->buildLink($projectDetail->pro_url_prod[0], $projectDetail->pro_url_prod[0], out));
$block1->contentRow($strings['owner'], $blockPage->buildLink('../users/viewuser.php?id=' . $projectDetail->pro_mem_id[0], $projectDetail->pro_mem_name[0], in) . ' (' . $blockPage->buildLink($projectDetail->pro_mem_email_work[0], $projectDetail->pro_mem_login[0], mail) . ')');
$block1->contentRow($strings['created'], createDate($projectDetail->pro_created[0], $timezoneSession));
$block1->contentRow($strings['modified'], createDate($projectDetail->pro_modified[0], $timezoneSession));
if ($projectDetail->pro_org_id[0] == '1') {
$block1->contentRow($strings['organization'], $strings['none']);
} else {
$block1->contentRow($strings['organization'], $blockPage->buildLink('../clients/viewclient.php?id=' . $projectDetail->pro_org_id[0], $projectDetail->pro_org_name[0], in));
}
$block1->contentRow($strings['status'], $status[$idStatus]);
$block1->contentRow($strings['type'], $projectType[$projectDetail->pro_type[0]]);
if ($fileManagement == 'true') {
$block1->contentRow($strings['max_upload'] . $blockPage->printHelp('max_file_size'), convertSize($projectDetail->pro_upload_max[0]));
$block1->contentRow($strings['project_folder_size'] . $blockPage->printHelp('project_disk_space'), convertSize(folder_info_size('../files/' . $projectDetail->pro_id[0] . '/')));
}
$block1->contentRow($strings['estimated_time'], $estimated_time . ' ' . $strings['hours']);
$block1->contentRow($strings['actual_time'], $proj_time . ' ' . $strings['hours']);
$block1->contentRow($strings['scope_creep'] . $blockPage->printHelp('project_scope_creep'), $diff_time . ' ' . $strings['days']);
if ($sitePublish == 'true') {
if ($projectDetail->pro_published[0] == '1') {
$block1->contentRow($strings['project_site'], '<' . $blockPage->buildLink('../projects/addprojectsite.php?id=' . $id, $strings['create'] . '...', in) . '>');
} else {
$block1->contentRow($strings['project_site'], '<' . $blockPage->buildLink('../projects/viewprojectsite.php?id=' . $id, $strings['details'], in) . '>');
}
}
if ($enableHelpSupport == 'true' && ($teamMember == 'true' || $profilSession == '5') && $supportType == 'team') {
$block1->contentTitle($strings['support']);
$block1->contentRow($strings['new_requests'], $comptListNewRequests . ' - ' . $blockPage->buildLink('../support/support.php?action=new&project=' . $projectDetail->pro_id[0], $strings['manage_new_requests'], in));
$block1->contentRow($strings['open_requests'], $comptListOpenRequests . ' - ' . $blockPage->buildLink('../support/support.php?action=open&project=' . $projectDetail->pro_id[0], $strings['manage_open_requests'], in));
$block1->contentRow($strings['closed_requests'], $comptListCompleteRequests . ' - ' . $blockPage->buildLink('../support/support.php?action=complete&project=' . $projectDetail->pro_id[0], $strings['manage_closed_requests'], in));
}
$block1->closeContent();
$block1->closeToggle();
$block1->closeForm();
if ($idSession == $projectDetail->pro_owner[0] || $enable_cvs == 'true' || $profilSession == '0' || $profilSession == '5') {
$block1->openPaletteScript();
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '0' || $profilSession == '5') {
$block1->paletteScript(0, 'remove', '../projects/deleteproject.php?id=' . $id, 'true,true,false', $strings['delete']);
$block1->paletteScript(1, 'copy', '../projects/editproject.php?id=' . $projectDetail->pro_id[0] . '&cpy=true', 'true,true,false', $strings['copy']);
$block1->paletteScript(2, 'export', '../projects/exportproject.php?languageSession=' . $languageSession . '&type=project&id=' . $projectDetail->pro_id[0], 'true,true,false', $strings['export']);
$block1->paletteScript(3, 'edit', '../projects/editproject.php?id=' . $projectDetail->pro_id[0] . '&cpy=false', 'true,true,false', $strings['edit']);
}
if ($enable_cvs == 'true') {
$block1->paletteScript(4, 'cvs', '../browsecvs/browsecvs.php?id=' . $id, 'true,true,false', $strings['browse_cvs']);
}
if ($enableMantis == 'true') {
$block1->paletteScript(5, 'bug', $pathMantis . 'login.php?id=' . $projectDetail->pro_id[0] . "url=http://{$HTTP_HOST}{$REQUEST_URI}&f_username=$loginSession&f_password=$passwordSession", 'true,true,false', $strings['bug']);
}
$block1->closePaletteScript('', '');
}
// Phase or Task list block
if ($projectDetail->pro_phase_set[0] != '0') {
$block7 = new block();
$block7->form = 'wbSe';
$block7->openForm('../projects/viewproject.php?id=' . $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++) {
if ($listPhases->pha_order_num[$i] == $countPhaseTasks->tas_parent_phase[$k]) {
$comptlistTasksRow = $comptlistTasksRow + 1;
if ($countPhaseTasks->tas_status[$k] == '2' || $countPhaseTasks->tas_status[$k] == '3' || $countPhaseTasks->tas_status[$k] == '4') {
$comptUncompleteTasks = $comptUncompleteTasks + 1;
}
}
}
$block7->openRow();
$block7->checkboxRow($listPhases->pha_id[$i]);
$block7->cellRow($listPhases->pha_order_num[$i]);
$block7->cellRow($blockPage->buildLink('../phases/viewphase.php?id=' . $listPhases->pha_id[$i], $listPhases->pha_name[$i], in));
$block7->cellRow($comptlistTasksRow);
$block7->cellRow($comptUncompleteTasks);
// $block7->cellRow($phaseStatus[$listPhases->pha_status[$i]]);
$block7->cellRow('<img src="../themes/' . THEME . '/gfx_status/phase_' . $listPhases->pha_status[$i] . '.gif" alt="' . $phaseStatus[$listPhases->pha_status[$i]] . '"> ' . $phaseStatus[$listPhases->pha_status[$i]], '', true);
$block7->cellRow($listPhases->pha_date_start[$i]);
$block7->cellRow($listPhases->pha_date_end[$i]);
$block7->closeRow();
}
$block7->closeResults();
} else {
$block7->noresults();
}
$block7->closeToggle();
$block7->closeFormResults();
$block7->openPaletteScript();
$block7->paletteScript(0, 'info', '../phases/viewphase.php', 'false,true,true', $strings['view']);
if ($teamMember == 'true' || $profilSession == '5') {
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '0' || $profilSession == '5') {
$block7->paletteScript(1, 'edit', '../phases/editphase.php', 'false,true,true', $strings['edit']);
}
}
$block7->closePaletteScript($comptListPhases, $listPhases->pha_id);
} else {
$block2 = new block();
$block2->form = 'wbTuu';
$block2->openForm('../projects/viewproject.php?id=' . $projectDetail->pro_id[0] . '#' . $block2->form . 'Anchor');
$block2->headingToggle($strings['tasks']);
$block2->openPaletteIcon();
if ($teamMember == 'true' || $profilSession == '5') {
$block2->paletteIcon(0, 'add', $strings['add']);
$block2->paletteIcon(1, 'remove', $strings['delete']);
$block2->paletteIcon(2, 'copy', $strings['copy']);
// $block2->paletteIcon(3,'export',$strings['export']);
if ($sitePublish == 'true') {
$block2->paletteIcon(4, 'add_projectsite', $strings['add_project_site']);
$block2->paletteIcon(5, 'remove_projectsite', $strings['remove_project_site']);
}
}
$block2->paletteIcon(6, 'info', $strings['view']);
if ($teamMember == 'true' || $profilSession == '5') {
$block2->paletteIcon(7, 'edit', $strings['edit']);
$block2->paletteIcon(8, 'timelog', $strings['loghours']);
}
$block2->closePaletteIcon();
$block2->borne = $blockPage->returnBorne('1');
$block2->rowsLimit = '5';
$block2->sorting('project_tasks', $sortingUser->sor_project_tasks[0], 'tas.name ASC', $sortingFields = array(0 => "tas.id", 1 => 'tas.name', 2 => 'tas.priority', 3 => 'tas.status', 4 => 'tas.completion', 5 => 'tas.due_date', 6 => 'mem.login', 7 => 'tas.published'));
$tmpquery = "WHERE tas.project = '$id' ORDER BY $block2->sortingValue";
$block2->recordsTotal = compt($initrequest['tasks'] . ' ' . $tmpquery);
$listTasks = new request();
$listTasks->openTasks($tmpquery, $block2->borne, $block2->rowsLimit);
$comptListTasks = count($listTasks->tas_id);
if ($comptListTasks != '0') {
$block2->openResults();
$block2->labels($labels = array(0 => $strings['id'], 1 => $strings['name'], 2 => $strings['priority'], 3 => $strings['status'], 4 => $strings['completion'], 5 => $strings['due_date'], 6 => $strings['assigned_to'], 7 => $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] . ' %';
$block2->openRow();
$block2->checkboxRow($listTasks->tas_id[$i]);
$block2->cellRow($blockPage->buildLink("../tasks/viewtask.php?id=" . $listTasks->tas_id[$i], $listTasks->tas_id[$i], in));
if ($idStatus == 1) {
$block2->cellRow($blockPage->buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], instrike));
} else {
$block2->cellRow($blockPage->buildLink('../tasks/viewtask.php?id=' . $listTasks->tas_id[$i], $listTasks->tas_name[$i], in));
}
$block2->cellRow('<img src="../themes/' . THEME . '/gfx_priority/' . $idPriority . '.gif" alt="' . $priority[$idPriority] . '"> ' . $priority[$idPriority], '', true);
$block2->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true);
$block2->cellRow($complValue);
if ($listTasks->tas_due_date[$i] <= $date && $listTasks->tas_completion[$i] != '10') {
$block2->cellRow('<b>' . $listTasks->tas_due_date[$i] . '</b>');
} else {
$block2->cellRow($listTasks->tas_due_date[$i]);
}
if ($listTasks->tas_start_date[$i] != "--" && $listTasks->tas_due_date[$i] != '--') {
$gantt = 'true';
}
if ($listTasks->tas_assigned_to[$i] == '0') {
$block2->cellRow($strings['unassigned']);
} else {
$block2->cellRow($blockPage->buildLink($listTasks->tas_mem_email_work[$i], $listTasks->tas_mem_login[$i], mail));
}
if ($sitePublish == 'true') {
$block2->cellRow($statusPublish[$idPublish]);
}
$block2->closeRow();
}
$block2->closeResults();
$block2->bornesFooter('1', $blockPage->bornesNumber, '../tasks/listtasks.php?project=' . $id, 'id=' . $id);
if ($activeJpgraph == 'true' && $gantt == 'true') {
// show the expanded or compact Gantt Chart
if ($HTTP_GET_VARS['base'] == 1) {
echo "<a href='../projects/viewproject.php?id=" . $projectDetail->pro_id[0] . "'>expand</a><br>";
} else {
echo "<a href='../projects/viewproject.php?id=" . $projectDetail->pro_id[0] . "&base=1'>compact</a><br>";
}
echo '<img src="../tasks/graphtasks.php?project=' . $projectDetail->pro_id[0] . '&base=' . $HTTP_GET_VARS['base'] . '" alt=""><br>
<span class="listEvenBold">' . $blockPage->buildLink('http://www.aditus.nu/jpgraph/', 'JpGraph', powered) . '</span>';
}
} else {
$block2->noresults();
}
$block2->closeToggle();
$block2->closeFormResults();
$block2->openPaletteScript();
if ($teamMember == 'true' || $profilSession == '5') {
$block2->paletteScript(0, 'add', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'true,false,false', $strings['add']);
$block2->paletteScript(1, 'remove', '../tasks/deletetasks.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']);
$block2->paletteScript(2, 'copy', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0] . '&cpy=true', 'false,true,false', $strings['copy']);
// $block2->paletteScript(3,'export','../projects/exportproject.php','false,true,true',$strings['export']);
if ($sitePublish == 'true') {
$block2->paletteScript(4, 'add_projectsite', '../projects/viewproject.php?addToSiteTask=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['add_project_site']);
$block2->paletteScript(5, 'remove_projectsite', '../projects/viewproject.php?removeToSiteTask=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['remove_project_site']);
}
}
$block2->paletteScript(6, 'info', '../tasks/viewtask.php', 'false,true,false', $strings['view']);
if ($teamMember == 'true' || $profilSession == '5') {
$block2->paletteScript(7, 'edit', '../tasks/edittask.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['edit']);
$block2->paletteScript(8, 'timelog', '../tasks/addtasktime.php', 'false,true,false', $strings['loghours']);
}
$block2->closePaletteScript($comptListTasks, $listTasks->tas_id);
}
$block3 = new block();
$block3->form = 'pdH';
$block3->openForm('../projects/viewproject.php?id=' . $id . '#' . $block3->form . 'Anchor');
$block3->headingToggle($strings['discussions']);
$block3->openPaletteIcon();
if ($teamMember == 'true' || $profilSession == '5') {
$block3->paletteIcon(0, 'add', $strings['add']);
}
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '5') {
$block3->paletteIcon(1, 'remove', $strings['delete']);
$block3->paletteIcon(2, 'lock', $strings['close']);
if ($sitePublish == 'true') {
$block3->paletteIcon(3, 'add_projectsite', $strings['add_project_site']);
$block3->paletteIcon(4, 'remove_projectsite', $strings['remove_project_site']);
}
}
$block3->paletteIcon(5, 'info', $strings['view']);
$block3->closePaletteIcon();
$block3->borne = $blockPage->returnBorne('2');
$block3->rowsLimit = '5';
$block3->sorting('project_discussions', $sortingUser->sor_project_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'));
$tmpquery = "WHERE topic.project = '$id' ORDER BY $block3->sortingValue";
$block3->recordsTotal = compt($initrequest['topics'] . ' ' . $tmpquery);
$listTopics = new request();
$listTopics->openTopics($tmpquery, $block3->borne, $block3->rowsLimit);
$comptListTopics = count($listTopics->top_id);
if ($comptListTopics != '0') {
$block3->openResults();
$block3->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];
$block3->openRow();
$block3->checkboxRow($listTopics->top_id[$i]);
$block3->cellRow($blockPage->buildLink('../topics/viewtopic.php?id=' . $listTopics->top_id[$i], $listTopics->top_subject[$i], in));
$block3->cellRow($blockPage->buildLink($listTopics->top_mem_email_work[$i], $listTopics->top_mem_login[$i], mail));
$block3->cellRow($listTopics->top_posts[$i]);
if ($listTopics->top_last_post[$i] > $lastvisiteSession) {
$block3->cellRow('<b>' . createDate($listTopics->top_last_post[$i], $timezoneSession) . '</b>');
} else {
$block3->cellRow(createDate($listTopics->top_last_post[$i], $timezoneSession));
}
$block3->cellRow($statusTopic[$idStatus]);
if ($sitePublish == 'true') {
$block3->cellRow($statusPublish[$idPublish]);
}
$block3->closeRow();
}
$block3->closeResults();
$block3->bornesFooter('2', $blockPage->bornesNumber, '../topics/listtopics.php?project=' . $id, 'id=' . $id);
} else {
$block3->noresults();
}
$block3->closeToggle();
$block3->closeFormResults();
$block3->openPaletteScript();
if ($teamMember == 'true' || $profilSession == '5') {
$block3->paletteScript(0, 'add', '../topics/addtopic.php?project=' . $projectDetail->pro_id[0], 'true,false,false', $strings['add']);
}
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '5') {
$block3->paletteScript(1, 'remove', '../topics/deletetopics.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']);
$block3->paletteScript(2, 'lock', '../projects/viewproject.php?closeTopic=true&project=' . $id . '&action=publish', 'false,true,true', $strings['close']);
if ($sitePublish == 'true') {
$block3->paletteScript(3, 'add_projectsite', '../projects/viewproject.php?addToSiteTopic=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['add_project_site']);
$block3->paletteScript(4, 'remove_projectsite', '../projects/viewproject.php?removeToSiteTopic=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['remove_project_site']);
}
}
$block3->paletteScript(5, 'info', '../topics/viewtopic.php', 'false,true,false', $strings['view']);
$block3->closePaletteScript($comptListTopics, $listTopics->top_id);
$block4 = new block();
$block4->form = 'pdM';
$block4->openForm('../projects/viewproject.php?id=' . $projectDetail->pro_id[0] . '#' . $block4->form . 'Anchor');
$block4->headingToggle($strings['team']);
$block4->openPaletteIcon();
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '5') {
$block4->paletteIcon(0, 'add', $strings['add']);
$block4->paletteIcon(1, 'remove', $strings['delete']);
if ($sitePublish == 'true') {
$block4->paletteIcon(2, 'add_projectsite', $strings['add_project_site']);
$block4->paletteIcon(3, 'remove_projectsite', $strings['remove_project_site']);
}
}
$block4->paletteIcon(4, 'info', $strings['view']);
// $block4->paletteIcon(5,'email',$strings['email']);
$block4->closePaletteIcon();
$block4->borne = $blockPage->returnBorne('3');
$block4->rowsLimit = '5';
$block4->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 $block4->sortingValue";
$block4->recordsTotal = compt($initrequest['teams'] . ' ' . $tmpquery);
$listTeam = new request();
$listTeam->openTeams($tmpquery, $block4->borne, $block4->rowsLimit);
$comptListTeam = count($listTeam->tea_id);
$block4->openResults();
$block4->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'];
}
if ($listTeam->tea_mem_title[$i] == '') {
$listTeam->tea_mem_title[$i] = $strings['none'];
}
$idPublish = $listTeam->tea_published[$i];
$block4->openRow();
$block4->checkboxRow($listTeam->tea_mem_id[$i]);
$block4->cellRow($blockPage->buildLink('../users/viewuser.php?id=' . $listTeam->tea_mem_id[$i], $listTeam->tea_mem_name[$i], in));
$block4->cellRow($listTeam->tea_mem_title[$i]);
$block4->cellRow($blockPage->buildLink($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_login[$i], mail));
$block4->cellRow($listTeam->tea_mem_phone_work[$i]);
if ($listTeam->tea_log_connected[$i] > $dateunix-5 * 60) {
$block4->cellRow($strings['yes'] . ' ' . $z);
} else {
$block4->cellRow($strings['no']);
}
if ($sitePublish == 'true') {
$block4->cellRow($statusPublish[$idPublish]);
}
$block4->closeRow();
}
$block4->closeResults();
$block4->bornesFooter('3', $blockPage->bornesNumber, '../teams/listusers.php?id=' . $id, 'id=' . $id);
$block4->closeToggle();
$block4->closeFormResults();
$block4->openPaletteScript();
if ($idSession == $projectDetail->pro_owner[0] || $profilSession == '5') {
$block4->paletteScript(0, 'add', '../teams/adduser.php?project=' . $projectDetail->pro_id[0], 'true,true,true', $strings['add']);
$block4->paletteScript(1, 'remove', '../teams/deleteusers.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']);
if ($sitePublish == 'true') {
$block4->paletteScript(2, 'add_projectsite', '../projects/viewproject.php?addToSiteTeam=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['add_project_site']);
$block4->paletteScript(3, 'remove_projectsite', '../projects/viewproject.php?removeToSiteTeam=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['remove_project_site']);
}
}
$block4->paletteScript(4, 'info', '../users/viewuser.php?', 'false,true,false', $strings['view']);
// $block4->paletteScript(5,'email','../users/emailusers.php','false,true,true',$strings['email']);
$block4->closePaletteScript($comptListTeam, $listTeam->tea_mem_id);
if ($fileManagement == 'true') {
$block5 = new block();
$block5->form = 'tdC';
$block5->openForm('../projects/viewproject.php?id=' . $id . '#' . $block5->form . 'Anchor');
$block5->headingToggle($strings['linked_content']);
$block5->openPaletteIcon();
if ($teamMember == 'true' || $profilSession == '5') {
$block5->paletteIcon(0, 'add', $strings['add']);
$block5->paletteIcon(1, 'remove', $strings['delete']);
if ($sitePublish == 'true') {
$block5->paletteIcon(2, 'add_projectsite', $strings['add_project_site']);
$block5->paletteIcon(3, 'remove_projectsite', $strings['remove_project_site']);
}
}
$block5->paletteIcon(4, 'info', $strings['view']);
if ($teamMember == 'true' || $profilSession == '5') {
$block5->paletteIcon(5, 'edit', $strings['edit']);
}
$block5->closePaletteIcon();
$block5->sorting('files', $sortingUser->sor_files[0], 'fil.name ASC', $sortingFields = array(0 => 'fil.extension', 1 => 'fil.name', 2 => 'fil.date', 3 => 'fil.status', 4 => 'fil.published'));
$tmpquery = "WHERE fil.project = '$id' AND fil.task = '0' AND fil.vc_parent = '0' AND fil.phase = '0' ORDER BY $block5->sortingValue";
$listFiles = new request();
$listFiles->openFiles($tmpquery);
$comptListFiles = count($listFiles->fil_id);
if ($comptListFiles != '0') {
$block5->openResults();
$block5->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 = $listFiles->fil_status[$i];
$idPublish = $listFiles->fil_published[$i];
$type = file_info_type($listFiles->fil_extension[$i]);
if (file_exists('../files/' . $listFiles->fil_project[$i] . '/' . $listFiles->fil_name[$i])) {
$existFile = 'true';
}
$block5->openRow();
$block5->checkboxRow($listFiles->fil_id[$i]);
if ($existFile == 'true') {
$block5->cellRow($blockPage->buildLink('../linkedcontent/viewfile.php?id=' . $listFiles->fil_id[$i], $type, icone));
} else {
$block5->cellRow(' ');
}
if ($existFile == 'true') {
$block5->cellRow($blockPage->buildLink('../linkedcontent/viewfile.php?id=' . $listFiles->fil_id[$i], $listFiles->fil_name[$i], in));
} else {
$block5->cellRow($strings['missing_file'] . ' (' . $listFiles->fil_name[$i] . ')');
}
$block5->cellRow($listFiles->fil_date[$i]);
$block5->cellRow($blockPage->buildLink('../linkedcontent/viewfile.php?id=' . $listFiles->fil_id[$i], $statusFile[$idStatus], in));
if ($sitePublish == 'true') {
$block5->cellRow($statusPublish[$idPublish]);
}
$block5->closeRow();
}
$block5->closeResults();
} else {
$block5->noresults();
}
$block5->closeToggle();
$block5->closeFormResults();
$block5->openPaletteScript();
if ($teamMember == 'true' || $profilSession == '5') {
$block5->paletteScript(0, 'add', '../linkedcontent/addfile.php?project=' . $id, 'true,true,true', $strings['add']);
$block5->paletteScript(1, 'remove', '../linkedcontent/deletefiles.php?project=' . $id, 'false,true,true', $strings['delete']);
if ($sitePublish == 'true') {
$block5->paletteScript(2, 'add_projectsite', '../projects/viewproject.php?addToSiteFile=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['add_project_site']);
$block5->paletteScript(3, 'remove_projectsite', '../projects/viewproject.php?removeToSiteFile=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['remove_project_site']);
}
}
$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);
}
$block6 = new block();
$block6->form = 'wbJ';
$block6->openForm('../projects/viewproject.php?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();
$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);
if ($comptListNotes != '0') {
$block6->openResults();
if ($comptTopic != '0') {
$block6->labels($labels = array(0 => $strings['subject'], 1 => $strings['topic'], 2 => $strings['date'], 3 => $strings['owner'], 4 => $strings['published']), 'true');
} else {
$block6->labels($labels = array(0 => $strings['subject'], 1 => $strings['date'], 2 => $strings['owner'], 3 => $strings['published']), 'true');
}
for ($i = 0; $i < $comptListNotes; $i++) {
$idPublish = $listNotes->note_published[$i];
$block6->openRow();
$block6->checkboxRow($listNotes->note_id[$i]);
$block6->cellRow($blockPage->buildLink('../notes/viewnote.php?id=' . $listNotes->note_id[$i], $listNotes->note_subject[$i], in));
if ($comptTopic != '0') {
$block6->cellRow($topicNote[$listNotes->note_topic[$i]]);
}
$block6->cellRow($listNotes->note_date[$i]);
$block6->cellRow($blockPage->buildLink($listNotes->note_mem_email_work[$i], $listNotes->note_mem_login[$i], mail));
if ($sitePublish == 'true') {
$block6->cellRow($statusPublish[$idPublish]);
} else {
$block6->cellRow(' ');
}
$block6->closeRow();
}
$block6->closeResults();
$block6->bornesFooter('4', $blockPage->bornesNumber, '../notes/listnotes.php?project=' . $id, 'id=' . $id);
} else {
$block6->noresults();
}
$block6->closeToggle();
$block6->closeFormResults();
$block6->openPaletteScript();
if ($teamMember == 'true' || $profilSession == '5') {
$block6->paletteScript(0, 'add', '../notes/editnote.php?project=' . $projectDetail->pro_id[0], 'true,true,true', $strings['add']);
$block6->paletteScript(1, 'remove', '../notes/deletenotes.php?project=' . $projectDetail->pro_id[0], 'false,true,true', $strings['delete']);
// $block6->paletteScript(2,'export','../projects/exportproject.php','false,true,true',$strings['export']);
if ($sitePublish == 'true') {
$block6->paletteScript(3, 'add_projectsite', '../projects/viewproject.php?addToSiteNote=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['add_project_site']);
$block6->paletteScript(4, 'remove_projectsite', '../projects/viewproject.php?removeToSiteNote=true&project=' . $projectDetail->pro_id[0] . '&action=publish', 'false,true,true', $strings['remove_project_site']);
}
}
$block6->paletteScript(5, 'info', '../notes/viewnote.php', 'false,true,false', $strings['view']);
if ($teamMember == 'true' || $profilSession == '5') {
$block6->paletteScript(6, 'edit', '../notes/editnote.php?project=' . $projectDetail->pro_id[0], 'false,true,false', $strings['edit']);
}
$block6->closePaletteScript($comptListNotes, $listNotes->note_id);
require_once('../themes/' . THEME . '/footer.php');
?>