function show_import_form()
{
lcm_page_start(_T('title_archives'), '', '', 'archives_import');
global $tabs;
show_tabs_links($tabs, 1);
lcm_bubble('archive_restore');
// Show the errors (if any)
echo show_all_errors($_SESSION['errors']);
// Upload backup form
echo '<form enctype="multipart/form-data" action="import_db.php" method="post">' . "\n";
echo '<input type="hidden" name="action" value="upload_file" />' . "\n";
echo '<input type="hidden" name="MAX_FILE_SIZE" value="5000000" />' . "\n";
echo "<fieldset class='info_box'>\n";
show_page_subtitle(_T('archives_subtitle_upload'), 'archives_import', 'newrestore');
echo '<p class="normal_text">' . _T('archives_info_how_to_upload') . "</p>\n";
echo '<p class="normal_text">' . _Ti('file_input_name');
echo '<input type="file" name="filename" size="40" value="" /> ';
echo '<input type="submit" name="submit" id="btn_upload" value="' . _T('button_validate') . '" class="search_form_btn" />';
echo "</p>\n";
echo "</fieldset>\n";
echo "</form>\n";
// Restore backup form
echo '<form action="import_db.php" method="post">' . "\n";
echo '<input type="hidden" name="action" value="import" />' . "\n";
echo "<fieldset class='info_box'>\n";
show_page_subtitle(_T('archives_subtitle_restore'), 'archives_import', 'delrestore');
echo "<strong>" . _Ti('archives_input_select_backup') . "</strong><br />";
echo "<select name='file' class='sel_frm'>\n";
lcm_debug("opendir: " . DIR_BACKUPS);
$storage = opendir(DIR_BACKUPS);
while ($file = readdir($storage)) {
lcm_debug("file in opendir: {$file}");
if (is_dir(DIR_BACKUPS . '/' . $file) && strpos($file, 'db-') === 0) {
echo "\t\t<option value='" . substr($file, 3) . "'>" . substr($file, 3) . "</option>\n";
}
}
echo "</select>\n";
// Select restore type
echo "<p class='normal_text'>\n";
echo "<input type='radio' name='restore_type' value='clean' id='r1' /><label for='r1'> <strong>" . _T('archives_input_option_restore') . "</strong></label><br />" . _T('archives_info_option_restore') . "<br /><br />\n";
// [ML] This is confusing as hell. I understand the aim from DB point of view
// but I don't understand the aim from the admin's point of view.
// echo "<input type='radio' name='restore_type' value='replace' id='r2' /><label for='r2'> <strong>Replace (experimental!)</strong></label><br /> Imported backup data will replace the existing. This is usefull to undo the changes made in the database since last backup, without losing the new information. Warning: This operation could break database integrity, especially if importing data between different LCM installations.<br /><br />\n";
echo "<input type='radio' name='restore_type' value='ignore' id='r3' /><label for='r3'> <strong>" . _T('archives_input_option_sync') . " (experimental!)</strong></label><br /> Only backup data NOT existing in the database will be imported. This is usefull to import data lost since last backup, without changing the existing information. Warning: This operation could break database integrity, especially if importing data between different LCM installations.<br /><br />\n";
// TRAD
echo "<button type='submit' class='simple_form_btn'>" . _T('button_validate') . "</button>\n";
echo "</p>\n";
echo "</fieldset\n>";
echo "</form>\n";
lcm_page_end();
$_SESSION['errors'] = array();
}
59 Temple Place, Suite 330, Boston, MA 02111-1307, USA
$Id: listorgs.php,v 1.20 2006/02/20 02:55:17 mlutfy Exp $
*/
include 'inc/inc.php';
include_lcm('inc_impex');
$find_org_string = '';
if (isset($_REQUEST['find_org_string'])) {
$find_org_string = $_REQUEST['find_org_string'];
}
if (!empty($_REQUEST['export']) && $GLOBALS['author_session']['status'] == 'admin') {
export('org', $_REQUEST['exp_format'], $find_org_string);
exit;
}
lcm_page_start(_T('title_org_list'), '', '', 'clients_intro');
lcm_bubble('org_list');
show_find_box('org', $find_org_string, '', (string) ($GLOBALS['author_session']['status'] == 'admin'));
// List all organisations in the system + search criterion if any
$q = "SELECT id_org,name\n\t\tFROM lcm_org";
if (strlen($find_org_string) > 1) {
$q .= " WHERE (name LIKE '%{$find_org_string}%')";
}
// Sort orgs by ID
$order_set = false;
$order_id = '';
if (isset($_REQUEST['order_id'])) {
if ($_REQUEST['order_id'] == 'ASC' || $_REQUEST['order_id'] == 'DESC') {
$order_id = $_REQUEST['order_id'];
$q .= " ORDER BY id_org " . $order_id;
$order_set = true;
}
lcm_page_start(_T('title_error'));
echo "<p>" . _T('error_no_case_specified') . "</p>\n";
lcm_page_end();
exit;
}
if (!allowed($case, 'a')) {
die("You don't have permission to edit this case's access rights.");
}
$q = "SELECT *\n\tFROM lcm_case_author,lcm_author\n\tWHERE (id_case={$case}\n\t AND lcm_case_author.id_author=lcm_author.id_author";
if ($author > 0) {
$q .= " AND lcm_author.id_author={$author}";
}
$q .= ')';
$result = lcm_query($q);
lcm_page_start(_T('title_case_edit_ac'));
lcm_bubble('case_ac');
show_context_start();
show_context_case_title($case);
show_context_case_involving($case);
show_context_end();
?>
<form action="upd_auth.php" method="post">
<table border="0" class="tbl_usr_dtl" width="99%">
<tr>
<th align="center" class="heading"><?php
echo _Th('case_input_author');
?>
</th>
<th align="center" class="heading"><?php
echo _Th('case_ac_input_rights');
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: listclients.php,v 1.37 2006/05/26 06:54:07 mlutfy Exp $
*/
include 'inc/inc.php';
include_lcm('inc_filters');
include_lcm('inc_impex');
$find_client_string = trim(_request('find_client_string'));
if (!empty($_REQUEST['export']) && $GLOBALS['author_session']['status'] == 'admin') {
export('client', $_REQUEST['exp_format'], $find_client_string);
exit;
}
lcm_page_start(_T('title_client_list'), '', '', 'clients_intro');
lcm_bubble('client_list');
show_find_box('client', $find_client_string, '', (string) ($GLOBALS['author_session']['status'] == 'admin'));
// List all clients in the system + search criterion if any
$q = "SELECT id_client,name_first,name_middle,name_last\n\t\tFROM lcm_client";
//
// Add search criteria
//
if ($find_client_string) {
// remove useless spaces
$find_client_string = preg_replace('/ +/', ' ', $find_client_string);
$q .= " WHERE ((name_first LIKE '%{$find_client_string}%')\n\t\t\tOR (name_middle LIKE '%{$find_client_string}%')\n\t\t\tOR (name_last LIKE '%{$find_client_string}%')\n\t\t\tOR (CONCAT(name_first, ' ', name_middle, ' ', name_last) LIKE '%{$find_client_string}%')\n\t\t\tOR (CONCAT(name_first, ' ', name_last) LIKE '%{$find_client_string}%')\n\t\t) ";
}
// Sort clients by ID
$order_set = false;
$order_id = '';
if (isset($_REQUEST['order_id'])) {
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: listexps.php,v 1.5 2006/04/21 16:34:36 mlutfy Exp $
*/
include 'inc/inc.php';
include_lcm('inc_obj_exp');
global $author_session;
global $prefs;
lcm_page_start(_T('title_expenses'), '', '', 'expenses_intro');
lcm_bubble('expenses_list');
//
// For "find expense"
//
$find_exp_string = '';
if (_request('find_exp_string')) {
$find_exp_string = _request('find_exp_string');
// remove useless spaces
$find_exp_string = trim($find_exp_string);
$find_exp_string = preg_replace('/ +/', ' ', $find_exp_string);
}
show_find_box('exp', $find_exp_string);
//
// For "Filter expense owner"
//
$prefs_change = false;
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: listauthors.php,v 1.33 2006/03/21 19:01:53 mlutfy Exp $
*/
include 'inc/inc.php';
include_lcm('inc_acc');
include_lcm('inc_filters');
$find_author_string = '';
if (isset($_REQUEST['find_author_string'])) {
$find_author_string = $_REQUEST['find_author_string'];
}
lcm_page_start(_T('title_author_list'), '', '', 'authors_intro');
lcm_bubble('author_list');
show_find_box('author', $find_author_string);
$q = "SELECT id_author,name_first,name_middle,name_last,status\n\t\tFROM lcm_author\n\t\tWHERE (1=1 ";
// Add search criteria if any
if (strlen($find_author_string) > 1) {
$q .= " AND ((name_first LIKE '%{$find_author_string}%')" . " OR (name_middle LIKE '%{$find_author_string}%')" . " OR (name_last LIKE '%{$find_author_string}%'))";
}
$q .= ")";
// Sort authors by status
$order_set = false;
$order_status = '';
if (isset($_REQUEST['order_status'])) {
if ($_REQUEST['order_status'] == 'ASC' || $_REQUEST['order_status'] == 'DESC') {
$order_status = $_REQUEST['order_status'];
$q .= " ORDER BY status " . $order_status;
$order_set = true;
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: listcases.php,v 1.74 2006/04/21 19:12:44 mlutfy Exp $
*/
include 'inc/inc.php';
include_lcm('inc_obj_case');
global $author_session;
global $prefs;
lcm_page_start(_T('title_my_cases'), '', '', 'cases_intro');
lcm_bubble('case_list');
//
// For "find case"
//
$find_case_string = '';
if (_request('find_case_string')) {
$find_case_string = _request('find_case_string');
// remove useless spaces
$find_case_string = trim($find_case_string);
$find_case_string = preg_replace('/ +/', ' ', $find_case_string);
show_find_box('case', $find_case_string);
}
//
// For "Filter case owner"
//
$prefs_change = false;
include_lcm('inc_keywords_default');
$system_keyword_groups = get_default_keywords();
create_groups($system_keyword_groups);
write_metas();
// regenerate inc/data/inc_meta_cache.php
$_SESSION['info']['refresh'] = 'Keywords cache refreshed';
// TRAD
break;
case '':
// Do Nothing
break;
default:
lcm_panic("No such action (" . _request('action') . ")");
}
lcm_page_start(_T('menu_admin_keywords'), '', '', 'keywords_intro');
lcm_bubble('keyword_list');
echo show_all_errors();
//
// Tabs
//
$groups = array('system' => _T('keywords_tab_system'), 'contact' => _T('keywords_tab_contact'), 'user' => _T('keywords_tab_user'), 'maint' => _T('keywords_tab_maintenance'));
$tab = _request('tab', 'system');
show_tabs($groups, $tab, $_SERVER['SCRIPT_NAME']);
switch ($tab) {
case 'system':
case 'user':
case 'contact':
show_all_keywords_type($tab);
break;
case 'maint':
echo '<fieldset class="info_box">' . "\n";
function show_export_form()
{
global $tabs;
lcm_page_start(_T('title_archives'), '', '', 'archives_export');
show_tabs_links($tabs, 0);
lcm_bubble('archive_create');
show_export_form_partial();
lcm_page_end();
}
