<?php // $Revision: 1.9 $
/* vim: set expandtab ts=4 sw=4 sts=4: */
/**
* $Id: viewclient.php,v 1.9 2003/11/22 03:15:45 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');
if ($clientsFilter == 'true' && $profilSession == '2') {
$teamMember = 'false';
$tmpquery = "WHERE tea.member = '$idSession' AND org2.id = '$id'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
if ($comptMemberTest == '0') {
header('Location: ../clients/listclients.php?msg=blankClient');
exit;
} else {
$tmpquery = "WHERE org.id = '$id'";
}
} else if ($clientsFilter == 'true' && $profilSession == '1') {
$tmpquery = "WHERE org.owner = '$idSession' AND org.id = '$id'";
} else {
$tmpquery = "WHERE org.id = '$id'";
}
$clientDetail = new request();
$clientDetail->openOrganizations($tmpquery);
$comptClientDetail = count($clientDetail->org_id);
if ($comptClientDetail == '0') {
header('Location: ../clients/listclients.php?msg=blankClient');
exit;
}
require_once('../themes/' . THEME . '/header.php');
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink('../clients/listclients.php?', $strings['clients'], in));
$blockPage->itemBreadcrumbs($clientDetail->org_name[0]);
$blockPage->closeBreadcrumbs();
if ($msg != '') {
require_once('../includes/messages.php');
$blockPage->messagebox($msgLabel);
}
$block1 = new block();
$block1->form = 'ecD';
$block1->openForm('../projects/listprojects.php#' . $block1->form . 'Anchor');
$block1->heading($strings['organization'] . ' : ' . $clientDetail->org_name[0]);
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block1->openPaletteIcon();
$block1->paletteIcon(0, 'remove', $strings['delete']);
$block1->paletteIcon(1, 'edit', $strings['edit']);
$block1->closePaletteIcon();
}
$block1->openContent();
$block1->contentTitle($strings['details']);
if ($clientsFilter == 'true') {
$block1->contentRow($strings['owner'], $blockPage->buildLink('../users/viewuser.php?id=' . $clientDetail->org_mem_id[0], $clientDetail->org_mem_name[0], in) . ' (' . $blockPage->buildLink($clientDetail->org_mem_email_work[0], $clientDetail->org_mem_login[0], mail) . ')');
}
$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'], $blockPage->buildLink($clientDetail->org_url[0], $clientDetail->org_url[0], out));
$block1->contentRow($strings['email'], $blockPage->buildLink($clientDetail->org_email[0], $clientDetail->org_email[0], mail));
$block1->contentRow($strings['comments'], nl2br($clientDetail->org_comments[0]));
$block1->contentRow($strings['created'], createDate($clientDetail->org_created[0], $timezoneSession));
if (file_exists('../logos_clients/' . $id . '.' . $clientDetail->org_extension_logo[0])) {
$block1->contentRow($strings['logo'], '<img src="../logos_clients/' . $id . '.' . $clientDetail->org_extension_logo[0] . '">');
}
$block1->closeContent();
$block1->closeForm();
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block1->openPaletteScript();
$block1->paletteScript(0, 'remove', '../clients/deleteclients.php?id=' . $clientDetail->org_id[0], 'true,true,false', $strings['delete']);
$block1->paletteScript(1, 'edit', '../clients/editclient.php?id=' . $clientDetail->org_id[0], 'true,true,false', $strings['edit']);
$block1->closePaletteScript('', '');
}
$block2 = new block();
$block2->form = 'clPr';
$block2->openForm("../clients/viewclient.php?id=$id#" . $block2->form . 'Anchor');
$block2->headingToggle($strings['client_projects']);
$block2->openPaletteIcon();
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block2->paletteIcon(0, 'add', $strings['add']);
$block2->paletteIcon(1, 'remove', $strings['delete']);
}
$block2->paletteIcon(2, 'info', $strings['view']);
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block2->paletteIcon(3, 'edit', $strings['edit']);
}
// if mantis bug tracker enabled
if ($enableMantis == 'true') {
$block2->paletteIcon(4, 'bug', $strings['bug']);
}
$block2->closePaletteIcon();
$block2->sorting('organization_projects', $sortingUser->sor_organization_projects[0], 'pro.name ASC', $sortingFields = array(0 => 'pro.id', 1 => 'pro.name', 2 => 'pro.priority', 3 => 'pro.status', 4 => 'mem.login', 5 => 'pro.published'));
if ($projectsFilter == 'true') {
$tmpquery = 'LEFT OUTER JOIN ' . $tableCollab['teams'] . ' teams ON teams.project = pro.id ';
$tmpquery .= 'WHERE pro.organization = "' . $clientDetail->org_id[0] . '" AND teams.member = "' . $idSession . '" ORDER BY ' . $block2->sortingValue;
} else {
$tmpquery = 'WHERE pro.organization = "' . $clientDetail->org_id[0] . '" ORDER BY ' . $block2->sortingValue;
}
$listProjects = new request();
$listProjects->openProjects($tmpquery);
$comptListProjects = count($listProjects->pro_id);
if ($comptListProjects != '0') {
$block2->openResults();
$block2->labels($labels = array(0 => $strings['id'], 1 => $strings['project'], 2 => $strings['priority'], 3 => $strings['status'], 4 => $strings['owner'], 5 => $strings['project_site']), 'true');
for ($i = 0; $i < $comptListProjects; $i++) {
$idStatus = $listProjects->pro_status[$i];
$idPriority = $listProjects->pro_priority[$i];
$block2->openRow();
$block2->checkboxRow($listProjects->pro_id[$i]);
$block2->cellRow($blockPage->buildLink('../projects/viewproject.php?id=' . $listProjects->pro_id[$i], $listProjects->pro_id[$i], in));
$block2->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] . '"> ' . $priority[$idPriority], '', true);
$block2->cellRow('<img src="../themes/' . THEME . '/gfx_status/' . $idStatus . '.gif" alt="' . $status[$idStatus] . '"> ' . $status[$idStatus], '', true);
$block2->cellRow($blockPage->buildLink($listProjects->pro_mem_email_work[$i], $listProjects->pro_mem_login[$i], mail));
if ($sitePublish == 'true') {
if ($listProjects->pro_published[$i] == '1') {
$block2->cellRow('<' . $blockPage->buildLink('../projects/addprojectsite.php?id=' . $listProjects->pro_id[$i], $strings['create'] . '...', in) . '>');
} else {
$block2->cellRow('<' . $blockPage->buildLink('../projects/viewprojectsite.php?id=' . $listProjects->pro_id[$i], $strings['details'], in) . '>');
}
}
}
$block2->closeResults();
} else {
$block2->noresults();
}
$block2->closeToggle();
$block2->closeFormResults();
$block2->openPaletteScript();
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$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' || $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=$loginSession&f_password=$passwordSession", 'false,true,false', $strings['bug']);
}
$block2->closePaletteScript($comptListProjects, $listProjects->pro_id);
$block3 = new block();
$block3->form = 'clU';
$block3->openForm("../clients/viewclient.php?id=$id#" . $block3->form . 'Anchor');
$block3->headingToggle($strings['client_users']);
$block3->openPaletteIcon();
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block3->paletteIcon(0, 'add', $strings['add']);
$block3->paletteIcon(1, 'remove', $strings['delete']);
}
$block3->paletteIcon(2, 'info', $strings['view']);
if ($profilSession == '0' || $profilSession == '1' || $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();
$block3->checkboxRow($listMembers->mem_id[$i]);
$block3->cellRow($blockPage->buildLink('../users/viewclientuser.php?id=' . $listMembers->mem_id[$i] . "&organization=$id", $listMembers->mem_name[$i], in));
$block3->cellRow($listMembers->mem_login[$i]);
$block3->cellRow($blockPage->buildLink($listMembers->mem_email_work[$i], $listMembers->mem_email_work[$i], mail));
$block3->cellRow($listMembers->mem_phone_work[$i]);
$z = '(Client on project site)';
if ($listMembers->mem_log_connected[$i] > $dateunix-5 * 60) {
$block3->cellRow($strings['yes'] . ' ' . $z);
} else {
$block3->cellRow($strings['no']);
}
}
$block3->closeResults();
} else {
$block3->noresults();
}
$block3->closeToggle();
$block3->closeFormResults();
$block3->openPaletteScript();
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block3->paletteScript(0, 'add', '../users/addclientuser.php?organization=' . $id, 'true,true,true', $strings['add']);
$block3->paletteScript(1, 'remove', '../users/deleteclientusers.php?organization=' . $id, 'false,true,true', $strings['delete']);
}
$block3->paletteScript(2, 'info', '../users/viewclientuser.php?organization=' . $id, 'false,true,false', $strings['view']);
if ($profilSession == '0' || $profilSession == '1' || $profilSession == '5') {
$block3->paletteScript(3, 'edit', '../users/updateclientuser.php?organization=' . $id, 'false,true,false', $strings['edit']);
}
$block3->closePaletteScript($comptListMembers, $listMembers->mem_id);
require_once('../themes/' . THEME . '/footer.php');
?>