<?php
/*
This file is part of the Legal Case Management System (LCM).
(C) 2004-2005 Free Software Foundation, Inc.
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.
This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307, USA
$Id: org_det.php,v 1.36 2007/01/12 17:36:15 mlutfy Exp $
*/
include('inc/inc.php');
include_lcm('inc_acc');
include_lcm('inc_contacts');
include_lcm('inc_obj_org');
$org = intval(_request('org'));
if (! ($org > 0)) {
lcm_header("Location: listorgs.php");
exit;
}
$q = "SELECT *
FROM lcm_org
WHERE id_org = $org";
$result = lcm_query($q);
if (! ($row = lcm_fetch_array($result)))
die("ERROR: There is no such organisation in the database.");
lcm_page_start(_T('title_org_view') . ' ' . $row['name'], '', '', 'clients_intro');
//
// Access control
//
$ac = get_ac_org($org);
if (! $ac['r'])
die("Access denied");
// Show tabs
$groups = array(
'general' => array('name' => _T('generic_tab_general'), 'tooltip' => _T('generic_subtitle_general')),
// 'representatives' => _T('generic_tab_representatives'),
'cases' => array('name' => _T('generic_tab_cases'), 'tooltip' => _T('org_subtitle_cases')),
'attachments' => array('name' => _T('generic_tab_documents'), 'tooltip' => _T('org_subtitle_attachments')));
$tab = ( isset($_GET['tab']) ? $_GET['tab'] : 'general' );
show_tabs($groups,$tab,$_SERVER['REQUEST_URI']);
if ($c = intval(_request('attach_case', 0))) {
$q = "SELECT title
FROM lcm_case
WHERE id_case = " . $c;
$result = lcm_query($q);
while ($row1 = lcm_fetch_array($result)) {
echo '<div class="sys_msg_box">';
echo '<ul>';
echo '<li>' . _Ti('org_info_created_attached')
. '<a class="content_link" href="case_det.php?case=' . $c . '">'
. $row1['title']
. "</a></li>\n";
echo "</ul>\n";
echo "</div>\n";
}
}
switch ($tab) {
//
// Show organisation general information
//
case 'general':
echo '<fieldset class="info_box">';
$obj_org = new LcmOrgInfoUI($org);
$obj_org->printGeneral(true);
if ($ac['e'])
echo '<p><a href="edit_org.php?org=' . $row['id_org'] . '" class="edit_lnk">'
. _T('org_button_edit')
. "</a></p>\n";
// [ML] Not useful
// if ($GLOBALS['author_session']['status'] == 'admin')
// echo '<p><a href="export.php?item=org&id=' . $row['id_org'] . '" class="exp_lnk">' . _T('export_button_org') . "</a></p>\n";
echo "</fieldset>\n";
break;
//
// Show organisation representatives
//
case 'representatives' :
echo '<fieldset class="info_box">';
echo '<div class="prefs_column_menu_head">' . _T('org_subtitle_representatives') . "</div><br />\n";
echo '<form action="add_cli_org.php" method="post">' . "\n";
echo '<input type="hidden" name="org" value="' . $org . '" />' . "\n";
// Show organisation representative(s)
$q = "SELECT cl.id_client, name_first, name_middle, name_last
FROM lcm_client_org as clo, lcm_client as cl
WHERE id_org = $org
AND clo.id_client = cl.id_client";
$result = lcm_query($q);
$show_table = false;
if (lcm_num_rows($result)) {
$show_table = true;
echo '<table class="tbl_usr_dtl" width="100%">' . "\n";
echo "<tr>\n";
echo '<th class="heading">' . "#" . '</th>';
echo '<th class="heading" width="99%">' . _Th('person_input_name') . '</th>';
echo '<th class="heading"> </th>';
echo "</tr>\n";
} else {
// TODO info message?
}
$i = 0;
while ($row = lcm_fetch_array($result)) {
echo "<tr>\n";
// ID
echo '<td class="tbl_cont_' . ($i % 2 ? "dark" : "light") . '">' . $row['id_client'] . '</td>';
// Name of client
echo '<td class="tbl_cont_' . ($i % 2 ? "dark" : "light") . '"><a href="client_det.php?client=' . $row['id_client'] . '" class="content_link">';
echo get_person_name($row) . "</a></td>";
// Delete association
echo '<td nowrap="nowrap" class="tbl_cont_' . ($i % 2 ? "dark" : "light") . '">';
echo '<label for="id_rem_cli_' . $row['id_client'] . '">';
echo '<img src="images/jimmac/stock_trash-16.png" width="16" height="16" '
. 'alt="' . _T('org_info_delete_client') . '" title="' . _T('org_info_delete_client') . '" />';
echo '</label> ';
echo '<input type="checkbox" onclick="lcm_show(\'btn_delete\')" id="id_rem_cli_' . $row['id_client'] . '" name="rem_clients[]" value="' . $row['id_client'] . '" />';
echo '</td>';
echo "</tr>\n";
$i++;
}
if ($show_table)
echo "</table>";
echo '<div align="right" style="visibility: hidden">';
echo '<input type="submit" name="submit" id="btn_delete" value="' . _T('button_validate') . '" class="search_form_btn" />';
echo "</div>\n";
if ($ac['w'])
echo "<p><a href=\"sel_cli_org.php?org=$org\" class=\"add_lnk\">" . _T('org_button_add_rep') . "</a></p>";
echo "</form>\n";
echo "</fieldset>";
break;
//
// Show recent cases
//
case 'cases':
$q = "SELECT clo.id_case, c.title, c.date_creation, c.status
FROM lcm_case_client_org as clo, lcm_case as c
WHERE id_org = $org
AND clo.id_case = c.id_case ";
// Sort cases by creation date
$case_order = 'DESC';
if (isset($_REQUEST['case_order']))
if ($_REQUEST['case_order'] == 'ASC' || $_REQUEST['case_order'] == 'DESC')
$case_order = $_REQUEST['case_order'];
$q .= " ORDER BY c.date_creation " . $case_order;
$result = lcm_query($q);
$number_of_rows = lcm_num_rows($result);
$list_pos = 0;
if (isset($_REQUEST['list_pos']))
$list_pos = $_REQUEST['list_pos'];
if ($list_pos >= $number_of_rows)
$list_pos = 0;
// Position to the page info start
if ($list_pos > 0)
if (!lcm_data_seek($result,$list_pos))
lcm_panic("Error seeking position $list_pos in the result");
if (lcm_num_rows($result)) {
echo '<fieldset class="info_box">' . "\n";
show_page_subtitle(_T('org_subtitle_cases'), 'cases_participants');
echo "<p class=\"normal_text\">\n";
show_listcase_start();
for ($cpt = 0; $row1 = lcm_fetch_array($result); $cpt++) {
show_listcase_item($row1, $cpt);
}
show_listcase_end($list_pos, $number_of_rows);
echo "</p>\n";
echo "</fieldset>\n";
}
break;
//
// Organisation attachments
//
case 'attachments' :
echo '<fieldset class="info_box">';
show_page_subtitle(_T('org_subtitle_attachments'), 'tools_documents');
echo "<p class=\"normal_text\">\n";
echo '<form enctype="multipart/form-data" action="attach_file.php" method="post">' . "\n";
echo '<input type="hidden" name="org" value="' . $org . '" />' . "\n";
// List of attached files
show_attachments_list('org', $org);
// Attach new file form
if ($ac['w']) {
show_attachments_upload('org', $org);
echo '<input type="submit" name="submit" value="' . _T('button_validate') . '" class="search_form_btn" />' . "\n";
}
echo "</form>\n";
echo "</p>\n";
echo '</fieldset>';
break;
}
// Show this in all tabs
echo '<p>';
echo '<a href="edit_case.php?case=0&attach_org=' . $row['id_org'] . '" class="create_new_lnk">';
echo _T('case_button_new');
echo "</a>";
echo "</p>\n";
$_SESSION['errors'] = array();
$_SESSION['form_data'] = array();
$_SESSION['org_data'] = array(); // DEPRECATED since 0.6.4
lcm_page_end();
?>