/** * $Id: sheet_toggle_icons.php,v 1.4 2004/12/13 00:18:22 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 = $_GET['id']; $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; } //--- 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->form = "client_user_add"; $block1->openForm("../users/addclientuser.php?organization={$organization}&action=add"); if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } $block1->headingForm($strings["add_client_user"]); $block1->openContent(); $block1->contentTitle($strings["enter_user_details"]); $block1->contentRow($strings["user_name"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"16\" type=\"text\" name=\"un\" value=\"{$un}\">"); $block1->contentRow($strings["full_name"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"fn\" value=\"{$fn}\">"); $block1->contentRow($strings["title"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"tit\" value=\"{$tit}\">"); $selectOrganization = "<select name=\"clod\">"; $tmpquery = "WHERE org.id != '1' ORDER BY org.name"; $listOrganizations = new request(); $listOrganizations->openOrganizations($tmpquery); $comptListOrganizations = count($listOrganizations->org_id); for ($i = 0; $i < $comptListOrganizations; $i++) { if ($organization == $listOrganizations->org_id[$i]) { $selectOrganization .= "<option value=\"" . $listOrganizations->org_id[$i] . "\" selected>" . $listOrganizations->org_name[$i] . "</option>"; } else { $selectOrganization .= "<option value=\"" . $listOrganizations->org_id[$i] . "\">" . $listOrganizations->org_name[$i] . "</option>"; } } $selectOrganization .= "</select>"; $block1->contentRow($strings["organization"], $selectOrganization); $block1->contentRow($strings["email"], "<input size=\"24\" style=\"width: 250px;\" maxlength=\"128\" type=\"text\" name=\"em\" value=\"{$em}\">"); $block1->contentRow($strings["work_phone"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"wp\" value=\"{$wp}\">"); $block1->contentRow($strings["home_phone"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"hp\" value=\"{$hp}\">"); $block1->contentRow($strings["mobile_phone"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"mp\" value=\"{$mp}\">"); $block1->contentRow($strings["fax"], "<input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"fax\" value=\"{$fax}\">");
} $listMembers = new request(); $listMembers->openMembers($tmpquery); $comptListMembers = count($listMembers->mem_id); echo "<select name=\"S_ATSEL[]\" size=\"4\" multiple><option selected value=\"ALL\">" . $strings["select_all"] . "</option><option value=\"0\">" . $strings["unassigned"] . "</option>"; for ($i = 0; $i < $comptListMembers; $i++) { echo "<option value=\"" . $listMembers->mem_id[$i] . "\">" . $listMembers->mem_login[$i]; if ($listMembers->mem_profil[$i] == "3") { echo " (" . $strings["client_user"] . ")"; } echo "</option>"; } echo "</select></td></tr>"; echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["organization"] . ":</td><td>"; $listOrganizations = new request(); $listOrganizations->openOrganizations(""); $comptListOrganizations = count($listOrganizations->org_id); echo "<select name=\"S_ORSEL[]\"><option selected value=\"ALL\">" . $strings["select_all"] . "</option>"; for ($i = 0; $i < $comptListOrganizations; $i++) { echo "<option value=\"" . $listOrganizations->org_id[$i] . "\">" . $listOrganizations->org_name[$i] . "</option>"; } echo "</select></td></tr>"; echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["logtime"] . " :</td><td>"; echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\">\r\n<tr>\r\n<td width=\"16\" align=\"center\" class=\"infovalue\"><input checked name=S_COMPLETEDATE type=radio value=ALL></td>\r\n<td align=\"left\" width=\"200\">" . $strings["all_dates"] . "</td>\r\n</tr>\r\n<tr>\r\n<td width=\"16\" align=\"center\" class=\"infovalue\"><input name=S_COMPLETEDATE type=radio value=DATERANGE></td>\r\n<td align=\"left\" width=\"200\">" . $strings["between_dates"] . "</td>\r\n</tr>\r\n</table>\r\n<table border=0 cellpadding=2 cellspacing=0>\r\n<tr><td width=18><img height=8 src=\"../themes/" . THEME . "/spacer.gif\" alt=\"\" width=18></td>\r\n<td class=infoValue noWrap><input type=\"text\" style=\"width: 150px;\" name=\"S_SDATE2\" id=\"sel1\" size=\"20\" value=\"\"><button type=\"reset\" id=\"trigger_a\">...</button><script type=\"text/javascript\">Calendar.setup({ inputField:\"sel1\", button:\"trigger_a\" });</script></td>\r\n</tr>\r\n<tr>\r\n<td width=18> " . $strings["and"] . " <TD class=infoValue noWrap><input type=\"text\" style=\"width: 150px;\" name=\"S_EDATE2\" id=\"sel3\" size=\"20\" value=\"\"><button type=\"reset\" id=\"trigger_b\">...</button><script type=\"text/javascript\">Calendar.setup({ inputField:\"sel3\", button:\"trigger_b\" });</script></TD>\r\n</tr>\r\n</table>"; // need a submit button echo "</select></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["create"] . "\"></td></tr>"; echo "</td></tr></table>\n"; $block1->closeContent(); $block1->closeForm(); // close this block require_once "../themes/" . THEME . "/footer.php";
*/ //General Header require_once '../includes/header.php'; // Banlieues Addon //--- page header --- echo "\n<link rel=\"stylesheet\" href=\"../themes/" . THEME . "/stylesheet.css\" type=\"text/css\">\n<link rel=\"stylesheet\" href=\"../themes/" . THEME . "/calendar/theme.css\" type=\"text/css\">\n{$headBonus}\n</head>\n<body bgcolor=\"../themes/" . THEME . "/bg_main.gif\" {$bodyCommand}>"; //--- >> div for mouse-over scripts --- echo "<div id=\"overDiv\" style=\"position:absolute; visibility:hidden; z-index:1000;\"></div>\n\n"; //--- pageheader ---- echo "<table id=pageHeader><tr>"; //--- client logo --- echo "<td>"; if (!$blank && $version >= "2.0") { $tmpquery = "WHERE org.id = '1'"; $clientHeader = new request(); $clientHeader->openOrganizations($tmpquery); } if (file_exists("../logos_clients/1." . $clientHeader->org_extension_logo[0])) { #echo "<p id=\"header\">"; #echo "<img src=\"../logos_clients/." . $clientHeader->org_extension_logo[0] . "\" border=\"0\" alt=\"" . $clientHeader->org_name[0] . "\">"; echo "<img src=\"../logos_clients/1." . $clientHeader->org_extension_logo[0] . "\" border=\"0\" alt=\"" . $clientHeader->org_name[0] . "\">"; #echo "</p>\n\n"; } else { echo '<img src="../themes/deepblue/img/logo_netoffice.gif">'; } echo "</td>"; //--- account --- echo '<td rowspan="2" id="account">'; if (!$blank && !$notLogged) { echo "<nobr><b>" . $_SESSION['nameSession'] . "</b><br>" . '<a href="../general/login.php?logout=true">' . $strings["logout"] . '</a><br>' . '<a href="../projects_site/home.php?changeProject=true">' . $strings["go_projects_site"] . '</a>' . "</nobr>"; }
for ($i = 0; $i < $comptAssignOwner; $i++) { if ($projectDetail->pro_mem_id[0] == $assignOwner->mem_id[$i]) { echo '<option value="' . $assignOwner->mem_id[$i] . '" selected>' . $assignOwner->mem_login[$i] . ' / ' . $assignOwner->mem_name[$i] . '</option>'; } else { echo '<option value="' . $assignOwner->mem_id[$i] . '">' . $assignOwner->mem_login[$i] . ' / ' . $assignOwner->mem_name[$i] . '</option>'; } } echo '</select></td></tr> <tr class="odd"><td valign="top" class="leftvalue">' . $strings['organization'] . ' :</td><td><select name="clod">'; if ($clientsFilter == 'true' && $_SESSION['profilSession'] == '1') { $tmpquery = "WHERE org.owner = '" . $_SESSION['idSession'] . "' AND org.id != '1' ORDER BY org.name"; } else { $tmpquery = "WHERE org.id != '1' ORDER BY org.name"; } $listClients = new request(); $listClients->openOrganizations($tmpquery); $comptListClients = count($listClients->org_id); if ($projectDetail->pro_org_id[0] == '1') { echo '<option value="1" selected>' . $strings['none'] . '</option>'; } else { echo '<option value="1">' . $strings['none'] . '</option>'; } for ($i = 0; $i < $comptListClients; $i++) { if ($projectDetail->pro_org_id[0] == $listClients->org_id[$i]) { echo '<option value="' . $listClients->org_id[$i] . '" selected>' . $listClients->org_name[$i] . '</option>'; } else { echo '<option value="' . $listClients->org_id[$i] . '">' . $listClients->org_name[$i] . '</option>'; } } echo '</select></td></tr> <tr class="odd"><td valign="top" class="leftvalue">' . $strings['enable_phases'] . ' :</td><td>
<?php #Application name: PhpCollab #Status page: 0 #Path by root: ../users/deleteclientusers.php $checkSession = "true"; include_once '../includes/library.php'; $tmpquery = "WHERE org.id = '{$organization}'"; $detailOrganization = new request(); $detailOrganization->openOrganizations($tmpquery); $comptDetailOrganization = count($detailOrganization->org_id); if ($action == "delete") { $id = str_replace("**", ",", $id); $tmpquery1 = "DELETE FROM " . $tableCollab["members"] . " WHERE id IN({$id})"; $tmpquery2 = "UPDATE " . $tableCollab["tasks"] . " SET assigned_to='{$at}' WHERE assigned_to IN({$id})"; $tmpquery3 = "UPDATE " . $tableCollab["assignments"] . " SET assigned_to='{$at}',assigned='{$dateheure}' WHERE assigned_to IN({$id})"; $tmpquery4 = "DELETE FROM " . $tableCollab["notifications"] . " WHERE member IN({$id})"; $tmpquery5 = "DELETE FROM " . $tableCollab["teams"] . " WHERE member IN({$id})"; connectSql("{$tmpquery1}"); connectSql("{$tmpquery2}"); connectSql("{$tmpquery3}"); connectSql("{$tmpquery4}"); connectSql("{$tmpquery5}"); //if mantis bug tracker enabled if ($enableMantis == "true") { // Call mantis function to remove user include "../mantis/user_delete.php"; } headerFunction("../clients/viewclient.php?id={$organization}&msg=delete&" . session_name() . "=" . session_id()); exit; }
} else { $tmpquery = "{$searchOrganizations} AND org.id IN({$clientsOk}) AND org.id != '1' ORDER BY {$block4->sortingValue}"; } } } else { if ($clientsFilter == "true" && $_SESSION['profilSession'] == "1") { $tmpquery = "{$searchOrganizations} AND org.owner = '" . $_SESSION['idSession'] . "' AND org.id != '1' ORDER BY {$block4->sortingValue}"; } else { $tmpquery = "{$searchOrganizations} AND org.id != '1' ORDER BY {$block4->sortingValue}"; } } $comptListOrganizations = "0"; if ($validOrganizations == "true") { $block4->recordsTotal = compt($initrequest["organizations"] . " " . $tmpquery); $listOrganizations = new request(); $listOrganizations->openOrganizations($tmpquery, $block4->borne, $block4->rowsLimit); $comptListOrganizations = count($listOrganizations->org_id); // echo "$tmpquery<br>"; } $block5 = new block(); $block5->borne = $blockPage->returnBorne("5"); $block5->rowsLimit = "10"; $block5->sorting("home_discussions", $sortingUser->sor_home_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.project", 6 => "topic.published")); if ($projectsFilter == "true") { if ($comptListProjectsFilter != "0") { $tmpquery = "{$searchTopics} AND topic.project IN({$filterResults}) ORDER BY {$block5->sortingValue}"; } else { $validTopics = "false"; } } else { $tmpquery = "{$searchTopics} ORDER BY {$block5->sortingValue}";
$comptMemberTest = count($memberTest->tea_id); if ($comptMemberTest == "0") { header("Location: ../clients/listclients.php?msg=blankClient"); exit; } else { } } else { if ($clientsFilter == "true" && $_SESSION['profilSession'] == "1") { $tmpquery = "WHERE org.owner = '" . $_SESSION['idSession'] . "' AND org.id = '{$organization}'"; } else { $tmpquery = "WHERE org.id = '{$organization}'"; } } $comptDetailClient = "0"; $detailClient = new request(); $detailClient->openOrganizations($tmpquery); $comptDetailClient = count($detailClient->org_id); if ($comptDetailClient == "0") { header("Location: ../clients/listclients.php?msg=blankClient"); exit; } //--- header ------------ $breadcrumbs[] = buildLink("../clients/listclients.php?", $strings["clients"], LINK_INSIDE); $breadcrumbs[] = buildLink("../clients/viewclient.php?id={$organization}", $detailClient->org_name[0], LINK_INSIDE); $breadcrumbs[] = $userDetail->mem_login[0]; $pageSection = 'clients'; $pageTitle = '<span class="type">' . $strings["client_user"] . '</span><br><span class="name">' . $userDetail->mem_name[0] . '</span>'; require_once "../themes/" . THEME . "/header.php"; //--- content ------------ $block1 = new block(); $block1->form = "cuserD";
include "../includes/library.php"; include "../includes/phplib/template.php"; $tmpquery = "WHERE inv.id = '{$id}'"; $detailInvoice = new request(); $detailInvoice->openInvoices($tmpquery); $tmpquery = "WHERE pro.id = '" . $detailInvoice->inv_project[0] . "'"; $projectDetail = new request(); $projectDetail->openProjects($tmpquery); $tmpquery = "WHERE org.id = '" . $projectDetail->pro_organization[0] . "'"; $clientDetail = new request(); $clientDetail->openOrganizations($tmpquery); $comptClientDetail = count($clientDetail->org_id); $tmpquery = "WHERE org.id = '1'"; $mycompanyDetail = new request(); $mycompanyDetail->openOrganizations($tmpquery); $comptMycompanyDetailDetail = count($mycompanyDetail->org_id); $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); $template = new Template(); $template->set_file('invoice', 'tpl_invoice.html'); $template->set_var(array('val_CLIENTNAME' => $clientDetail->org_name[0], 'val_CLIENTADDRESS' => nl2br($clientDetail->org_address1[0]), 'val_COMPANYNAME' => $mycompanyDetail->org_name[0], 'val_COMPANYADDRESS' => nl2br($mycompanyDetail->org_address1[0]), 'str_INVOICE' => $strings["invoice"], 'val_HEADER' => $detailInvoice->inv_header_note[0], 'val_FOOTER' => $detailInvoice->inv_footer_note[0], 'val_TOTALINCTAX' => $detailInvoice->inv_total_inc_tax[0], 'val_TOTALEXTAX' => $detailInvoice->inv_total_ex_tax[0], 'val_TAXRATE' => $detailInvoice->inv_tax_rate[0], 'val_TAXAMOUNT' => $detailInvoice->inv_tax_amount[0], 'str_TOTALINCTAX' => $strings["total_inc_tax"], 'str_TOTALEXTAX' => $strings["total_ex_tax"], 'str_TAXRATE' => $strings["tax_rate"], 'str_TAXAMOUNT' => $strings["tax_amount"], 'str_TITLE' => $strings["title"], 'str_AMOUNTEXTAX' => $strings["amount_ex_tax"])); $template->set_block('invoice', 'items', 'block'); for ($i = 0; $i < $comptListInvoicesItems; $i++) { $template->set_var(array('val_TITLE' => $listInvoicesItems->invitem_title[$i], 'val_AMOUNTEXTAX' => $listInvoicesItems->invitem_amount_ex_tax[$i])); $template->Parse('block', 'items', true); } $dump_buffer = $template->finish($template->parse('invoice', 'invoice')); $filename = $strings["invoice"] . $detailInvoice->inv_id[0];
//case add client organization if ($id == "") { $setTitle .= " : Add Client"; 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); $comments = convertData($comments); //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 { if ($hourly_rate == "") { $hourly_rate = 0.0; } //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,hourly_rate) VALUES('{$cn}','{$add}','{$client_phone}','{$url}','{$email}','{$c}','{$dateheure}','" . fixInt($cown) . "','{$hourly_rate}')"; connectSql("{$tmpquery1}"); $tmpquery = $tableCollab["organizations"]; last_id($tmpquery); $num = $lastId[0]; unset($lastId); $extension = strtolower(substr(strrchr($upload_name, "."), 1));
$breadcrumbs[] = $strings["edit_client_user"]; require_once "../themes/" . THEME . "/header.php"; $block1 = new block(); $block1->form = "client_user_edit"; $block1->openForm("../users/updateclientuser.php?action=update&organization={$organization}"); if ($error != "") { $block1->headingError($strings["errors"]); $block1->contentError($error); } $block1->headingForm($strings["edit_client_user"] . " : {$un}"); $block1->openContent(); $block1->contentTitle($strings["edit_user_details"]); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["user_name"] . " :</td><td><input type=\"hidden\" name=\"id\" value=\"{$id}\"><input size=\"24\" style=\"width: 250px;\" maxlength=\"16\" type=\"text\" name=\"un\" value=\"{$un}\"><input type=\"hidden\" name=\"unOld\" value=\"{$un}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["full_name"] . " :</td><td><input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"fn\" value=\"{$fn}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["title"] . " :</td><td><input size=\"24\" style=\"width: 250px;\" maxlength=\"64\" type=\"text\" name=\"tit\" value=\"{$tit}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["organization"] . " :</td><td><select name=\"clod\">"; $tmpquery = "WHERE org.id != '1' ORDER BY org.name"; $selectClient = new request(); $selectClient->openOrganizations($tmpquery); $comptSelectClient = count($selectClient->org_id); for ($i = 0; $i < $comptSelectClient; $i++) { if ($userDetail->mem_organization[0] == $selectClient->org_id[$i]) { echo "<option value=\"" . $selectClient->org_id[$i] . "\" selected>" . $selectClient->org_name[$i] . "</option>"; } else { echo "<option value=\"" . $selectClient->org_id[$i] . "\">" . $selectClient->org_name[$i] . "</option>"; } } echo "</select></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["email"] . " :</td><td><input size=\"24\" style=\"width: 250px;\" maxlength=\"128\" type=\"text\" name=\"em\" value=\"{$em}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["work_phone"] . " :</td><td><input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"wp\" value=\"{$wp}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["home_phone"] . " :</td><td><input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"hp\" value=\"{$hp}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["mobile_phone"] . " :</td><td><input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"mp\" value=\"{$mp}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["fax"] . " :</td><td class=\"infoValueField\" width=\"634\"><input size=\"14\" style=\"width: 150px;\" maxlength=\"32\" type=\"text\" name=\"fax\" value=\"{$fax}\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["comments"] . " :</td><td><textarea style=\"width: 400px; height: 50px;\" name=\"c\" cols=\"35\" rows=\"2\">{$c}</textarea></td></tr>"; $block1->contentTitle($strings["change_password_user"]); echo "<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["password"] . " :</td><td><input size=\"24\" style=\"width: 250px;\" maxlength=\"16\" type=\"password\" name=\"pw\" value=\"\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\">" . $strings["confirm_password"] . " :</td><td><input size=\"24\" style=\"width: 250px;\" maxlength=\"16\" type=\"password\" name=\"pwa\" value=\"\"></td></tr>\r\n<tr class=\"odd\"><td valign=\"top\" class=\"leftvalue\"> </td><td><input type=\"submit\" name=\"Save\" value=\"" . $strings["save"] . "\"></td></tr>"; $block1->closeContent(); $block1->headingForm_close(); $block1->closeForm(); require_once "../themes/" . THEME . "/footer.php";