<?php // $Revision: 1.8 $
/* vim: set expandtab ts=4 sw=4 sts=4: */
/**
* $Id: editclient.php,v 1.8 2004/01/18 20:55:07 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');
// case update client organization
if ($id != '') {
// test exists selected client organization, redirect to list if not
$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;
}
}
// case update client organization
if ($id != '') {
if ($action == 'update') {
if ($logoDel == 'on') {
$tmpquery = 'UPDATE ' . $tableCollab['organizations'] . " SET extension_logo='' WHERE id='$id'";
connectSql($tmpquery);
@unlink("../logos_clients/" . $id . ".$extensionOld");
}
$extension = strtolower(substr(strrchr($HTTP_POST_FILES['upload']['name'], '.'), 1));
if (@move_uploaded_file($HTTP_POST_FILES['upload']['tmp_name'], '../logos_clients/' . $id . ".$extension")) {
$tmpquery = 'UPDATE ' . $tableCollab['organizations'] . " SET extension_logo='$extension' WHERE id='$id'";
connectSql($tmpquery);
}
// replace quotes by html code in name and address
$cn = convertData($cn);
$add = convertData($add);
$c = convertData($c);
$tmpquery = 'UPDATE ' . $tableCollab['organizations'] . " SET name='$cn',address1='$add',phone='$wp',url='$url',email='$email',comments='$c',owner='$cown' WHERE id = '$id'";
connectSql($tmpquery);
header("Location: ../clients/viewclient.php?id=$id&msg=update");
exit;
}
// set value in form
$cn = $clientDetail->org_name[0];
$add = $clientDetail->org_address1[0];
$wp = $clientDetail->org_phone[0];
$url = $clientDetail->org_url[0];
$email = $clientDetail->org_email[0];
$c = $clientDetail->org_comments[0];
}
// case add client organization
if ($id == '') {
if ($action == 'add') {
// test if name blank
if ($cn == '') {
$error = $strings['blank_organization_field'];
} else {
// replace quotes by html code in name and address
$cn = convertData($cn);
$add = convertData($add);
$c = convertData($c);
// test if name already exists
$tmpquery = "WHERE org.name = '$cn'";
$existsClient = new request();
$existsClient->openOrganizations($tmpquery);
$comptExistsClient = count($existsClient->org_id);
if ($comptExistsClient != '0') {
$error = $strings['organization_already_exists'];
} else {
// insert into organizations and redirect to new client organization detail (last id)
$tmpquery1 = "INSERT INTO " . $tableCollab["organizations"] . "(name,address1,phone,url,email,comments,created,owner) VALUES('$cn','$add','$wp','$url','$email','$c','$dateheure','$cown')";
connectSql($tmpquery1);
$tmpquery = $tableCollab['organizations'];
last_id($tmpquery);
$num = $lastId[0];
unset($lastId);
$extension = strtolower(substr(strrchr($upload_name, '.'), 1));
if (@move_uploaded_file($upload, '../logos_clients/' . $num . ".$extension")) {
$tmpquery = 'UPDATE ' . $tableCollab['organizations'] . " SET extension_logo='$extension' WHERE id='$num'";
connectSql($tmpquery);
}
header("Location: ../clients/viewclient.php?id=$num&msg=add");
exit;
}
}
}
}
$bodyCommand = 'onLoad="document.ecDForm.cn.focus();"';
require_once('../themes/' . THEME . '/header.php');
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink('../clients/listclients.php?', $strings['clients'], in));
if ($id == '') {
$blockPage->itemBreadcrumbs($strings['add_organization']);
}
if ($id != '') {
$blockPage->itemBreadcrumbs($blockPage->buildLink('../clients/viewclient.php?id=' . $clientDetail->org_id[0], $clientDetail->org_name[0], in));
$blockPage->itemBreadcrumbs($strings['edit_organization']);
}
$blockPage->closeBreadcrumbs();
if ($msg != '') {
require_once('../includes/messages.php');
$blockPage->messagebox($msgLabel);
}
$block1 = new block();
if ($id == '') {
echo "<a name=\"" . $this->form . "Anchor\"></a>\n
<form accept-charset=\"UNKNOWN\" method=\"POST\" action=\"../clients/editclient.php?action=add\" name=\"ecDForm\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"100000000\">\n";
}
if ($id != '') {
echo "<a name=\"" . $this->form . "Anchor\"></a>\n
<form accept-charset=\"UNKNOWN\" method=\"POST\" action=\"../clients/editclient.php?id=$id&action=update\" name=\"ecDForm\" enctype=\"multipart/form-data\"><input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"100000000\">\n";
}
if ($error != '') {
$block1->headingError($strings['errors']);
$block1->contentError($error);
}
if ($id == '') {
$block1->heading($strings['add_organization']);
}
if ($id != '') {
$block1->heading($strings['edit_organization'] . ' : ' . $clientDetail->org_name[0]);
}
$block1->openContent();
$block1->contentTitle($strings['details']);
if ($clientsFilter == 'true') {
$selectOwner = '<select name="cown">';
$tmpquery = "WHERE (mem.profil='5' OR mem.profil='1' OR mem.profil='0') AND mem.login != 'demo' ORDER BY mem.name";
$clientOwner = new request();
$clientOwner->openMembers($tmpquery);
$comptClientOwner = count($clientOwner->mem_id);
for ($i = 0; $i < $comptClientOwner; $i++) {
if ($clientDetail->org_owner[0] == $clientOwner->mem_id[$i] || $idSession == $clientOwner->mem_id[$i]) {
$selectOwner .= '<option value="' . $clientOwner->mem_id[$i] . '" selected>' . $clientOwner->mem_login[$i] . ' / ' . $clientOwner->mem_name[$i] . '</option>';
} else {
$selectOwner .= '<option value="' . $clientOwner->mem_id[$i] . '">' . $clientOwner->mem_login[$i] . ' / ' . $clientOwner->mem_name[$i] . '</option>';
}
}
$selectOwner .= '</select>';
$block1->contentRow($strings['owner'], $selectOwner);
}
$block1->contentRow('* ' . $strings['name'], '<input size="44" value="' . $cn . '" style="width: 400px" name="cn" maxlength="100" type="TEXT">');
$block1->contentRow($strings['address'], '<textarea rows="3" style="width: 400px; height: 50px;" name="add" cols="43">' . $add . '</textarea>');
$block1->contentRow($strings['phone'], '<input size="32" value="' . $wp . '" style="width: 250px" name="wp" maxlength="32" type="TEXT">');
$block1->contentRow($strings['url'], '<input size="44" value="' . $url . '" style="width: 400px" name="url" maxlength="2000" type="TEXT">');
$block1->contentRow($strings['email'], '<input size="44" value="' . $email . '" style="width: 400px" name="email" maxlength="2000" type="TEXT">');
$block1->contentRow($strings['comments'], '<textarea rows="3" style="width: 400px; height: 50px;" name="c" cols="43">' . $c . '</textarea>');
$block1->contentRow($strings['logo'], '<input size="44" style="width: 400px" name="upload" type="file">');
if ($id != '') {
if (file_exists('../logos_clients/' . $id . '.' . $clientDetail->org_extension_logo[0])) {
$block1->contentRow('', '<img src="../logos_clients/' . $id . '.' . $clientDetail->org_extension_logo[0] . '"> <input name="extensionOld" type="hidden" value="' . $clientDetail->org_extension_logo[0] . '"><input name="logoDel" type="checkbox" value="on"> ' . $strings['delete']);
}
}
$block1->contentRow('', '<input type="SUBMIT" value="' . $strings['save'] . '">');
$block1->closeContent();
$block1->closeForm();
require_once('../themes/' . THEME . '/footer.php');
?>