433 lines
15 KiB
PHP
433 lines
15 KiB
PHP
|
<?php
|
||
|
|
/* Copyright (C) 2013-2014 Olivier Geffroy <jeff@jeffinfo.com>
|
||
|
|
* Copyright (C) 2013-2024 Alexandre Spangaro <aspangaro@easya.solutions>
|
||
|
|
* Copyright (C) 2014 Florian Henry <florian.henry@open-concept.pro>
|
||
|
|
* Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
|
||
|
|
*
|
||
|
|
* 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 3 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, see <https://www.gnu.org/licenses/>.
|
||
|
|
*/
|
||
|
|
|
||
|
|
/**
|
||
|
|
* \file htdocs/accountancy/admin/card.php
|
||
|
|
* \ingroup Accountancy (Double entries)
|
||
|
|
* \brief Card of accounting account
|
||
|
|
*/
|
||
|
|
|
||
|
|
// Load Dolibarr environment
|
||
|
|
require '../../main.inc.php';
|
||
|
|
require_once DOL_DOCUMENT_ROOT.'/core/lib/accounting.lib.php';
|
||
|
|
require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingaccount.class.php';
|
||
|
|
require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountancysystem.class.php';
|
||
|
|
require_once DOL_DOCUMENT_ROOT.'/core/class/html.formaccounting.class.php';
|
||
|
|
|
||
|
|
$error = 0;
|
||
|
|
|
||
|
|
// Load translation files required by the page
|
||
|
|
$langs->loadLangs(array('accountancy', 'bills', 'compta'));
|
||
|
|
|
||
|
|
$action = GETPOST('action', 'aZ09');
|
||
|
|
$backtopage = GETPOST('backtopage', 'alpha');
|
||
|
|
$id = GETPOSTINT('id');
|
||
|
|
$ref = GETPOST('ref', 'alpha');
|
||
|
|
$rowid = GETPOSTINT('rowid');
|
||
|
|
$cancel = GETPOST('cancel', 'alpha');
|
||
|
|
|
||
|
|
$account_number = GETPOST('account_number', 'alphanohtml');
|
||
|
|
$label = GETPOST('label', 'alpha');
|
||
|
|
|
||
|
|
// Security check
|
||
|
|
if ($user->socid > 0) {
|
||
|
|
accessforbidden();
|
||
|
|
}
|
||
|
|
if (!$user->hasRight('accounting', 'chartofaccount')) {
|
||
|
|
accessforbidden();
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$object = new AccountingAccount($db);
|
||
|
|
|
||
|
|
|
||
|
|
/*
|
||
|
|
* Action
|
||
|
|
*/
|
||
|
|
|
||
|
|
if (GETPOST('cancel', 'alpha')) {
|
||
|
|
$urltogo = $backtopage ? $backtopage : DOL_URL_ROOT.'/accountancy/admin/account.php';
|
||
|
|
header("Location: ".$urltogo);
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($action == 'add' && $user->hasRight('accounting', 'chartofaccount')) {
|
||
|
|
if (!$cancel) {
|
||
|
|
if (!$account_number) {
|
||
|
|
setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentities("AccountNumber")), null, 'errors');
|
||
|
|
$action = 'create';
|
||
|
|
} elseif (!$label) {
|
||
|
|
setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentities("Label")), null, 'errors');
|
||
|
|
$action = 'create';
|
||
|
|
} else {
|
||
|
|
$sql = "SELECT pcg_version FROM " . MAIN_DB_PREFIX . "accounting_system WHERE rowid = ".((int) getDolGlobalInt('CHARTOFACCOUNTS'));
|
||
|
|
|
||
|
|
dol_syslog('accountancy/admin/card.php:: $sql=' . $sql);
|
||
|
|
$result = $db->query($sql);
|
||
|
|
$obj = $db->fetch_object($result);
|
||
|
|
|
||
|
|
// Clean code
|
||
|
|
|
||
|
|
// To manage zero or not at the end of the accounting account
|
||
|
|
if (!getDolGlobalString('ACCOUNTING_MANAGE_ZERO')) {
|
||
|
|
$account_number = clean_account($account_number);
|
||
|
|
}
|
||
|
|
|
||
|
|
$account_parent = (GETPOSTINT('account_parent') > 0) ? GETPOSTINT('account_parent') : 0;
|
||
|
|
|
||
|
|
$object->fk_pcg_version = $obj->pcg_version;
|
||
|
|
$object->pcg_type = GETPOST('pcg_type', 'alpha');
|
||
|
|
$object->account_number = $account_number;
|
||
|
|
$object->account_parent = $account_parent;
|
||
|
|
$object->account_category = GETPOSTINT('account_category');
|
||
|
|
$object->label = $label;
|
||
|
|
$object->labelshort = GETPOST('labelshort', 'alpha');
|
||
|
|
$object->active = 1;
|
||
|
|
|
||
|
|
$res = $object->create($user);
|
||
|
|
if ($res == -3) {
|
||
|
|
$error = 1;
|
||
|
|
$action = "create";
|
||
|
|
setEventMessages($object->error, $object->errors, 'errors');
|
||
|
|
} elseif ($res == -4) {
|
||
|
|
$error = 2;
|
||
|
|
$action = "create";
|
||
|
|
setEventMessages($object->error, $object->errors, 'errors');
|
||
|
|
} elseif ($res < 0) {
|
||
|
|
$error++;
|
||
|
|
setEventMessages($object->error, $object->errors, 'errors');
|
||
|
|
$action = "create";
|
||
|
|
}
|
||
|
|
if (!$error) {
|
||
|
|
setEventMessages("RecordCreatedSuccessfully", null, 'mesgs');
|
||
|
|
$urltogo = $backtopage ? $backtopage : DOL_URL_ROOT.'/accountancy/admin/account.php';
|
||
|
|
header("Location: " . $urltogo);
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
} elseif ($action == 'edit' && $user->hasRight('accounting', 'chartofaccount')) {
|
||
|
|
if (!$cancel) {
|
||
|
|
if (!$account_number) {
|
||
|
|
setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentities("AccountNumber")), null, 'errors');
|
||
|
|
$action = 'update';
|
||
|
|
} elseif (!$label) {
|
||
|
|
setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentities("Label")), null, 'errors');
|
||
|
|
$action = 'update';
|
||
|
|
} else {
|
||
|
|
$result = $object->fetch($id);
|
||
|
|
|
||
|
|
$sql = "SELECT pcg_version FROM ".MAIN_DB_PREFIX."accounting_system WHERE rowid=".((int) getDolGlobalInt('CHARTOFACCOUNTS'));
|
||
|
|
|
||
|
|
dol_syslog('accountancy/admin/card.php:: $sql=' . $sql);
|
||
|
|
$result2 = $db->query($sql);
|
||
|
|
$obj = $db->fetch_object($result2);
|
||
|
|
|
||
|
|
// Clean code
|
||
|
|
|
||
|
|
// To manage zero or not at the end of the accounting account
|
||
|
|
if (!getDolGlobalString('ACCOUNTING_MANAGE_ZERO')) {
|
||
|
|
$account_number = clean_account($account_number);
|
||
|
|
}
|
||
|
|
|
||
|
|
$account_parent = (GETPOSTINT('account_parent') > 0) ? GETPOSTINT('account_parent') : 0;
|
||
|
|
|
||
|
|
$object->fk_pcg_version = $obj->pcg_version;
|
||
|
|
$object->pcg_type = GETPOST('pcg_type', 'alpha');
|
||
|
|
$object->account_number = $account_number;
|
||
|
|
$object->account_parent = $account_parent;
|
||
|
|
$object->account_category = GETPOSTINT('account_category');
|
||
|
|
$object->label = $label;
|
||
|
|
$object->labelshort = GETPOST('labelshort', 'alpha');
|
||
|
|
|
||
|
|
$result = $object->update($user);
|
||
|
|
|
||
|
|
if ($result > 0) {
|
||
|
|
$urltogo = $backtopage ? $backtopage : ($_SERVER["PHP_SELF"] . "?id=" . $id);
|
||
|
|
header("Location: " . $urltogo);
|
||
|
|
exit();
|
||
|
|
} elseif ($result == -2) {
|
||
|
|
setEventMessages($langs->trans("ErrorAccountNumberAlreadyExists", $object->account_number), null, 'errors');
|
||
|
|
} else {
|
||
|
|
setEventMessages($object->error, null, 'errors');
|
||
|
|
}
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
$urltogo = $backtopage ? $backtopage : ($_SERVER["PHP_SELF"]."?id=".$id);
|
||
|
|
header("Location: ".$urltogo);
|
||
|
|
exit();
|
||
|
|
}
|
||
|
|
} elseif ($action == 'delete' && $user->hasRight('accounting', 'chartofaccount')) {
|
||
|
|
$result = $object->fetch($id);
|
||
|
|
|
||
|
|
if (!empty($object->id)) {
|
||
|
|
$result = $object->delete($user);
|
||
|
|
|
||
|
|
if ($result > 0) {
|
||
|
|
header("Location: account.php");
|
||
|
|
exit;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($result < 0) {
|
||
|
|
setEventMessages($object->error, $object->errors, 'errors');
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
/*
|
||
|
|
* View
|
||
|
|
*/
|
||
|
|
|
||
|
|
$form = new Form($db);
|
||
|
|
$formaccounting = new FormAccounting($db);
|
||
|
|
|
||
|
|
$accountsystem = new AccountancySystem($db);
|
||
|
|
$accountsystem->fetch(getDolGlobalInt('CHARTOFACCOUNTS'));
|
||
|
|
|
||
|
|
$title = $langs->trans('AccountAccounting')." - ".$langs->trans('Card');
|
||
|
|
|
||
|
|
$help_url = 'EN:Module_Double_Entry_Accounting#Setup|FR:Module_Comptabilité_en_Partie_Double#Configuration';
|
||
|
|
|
||
|
|
llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'mod-accountancy page-admin_card');
|
||
|
|
|
||
|
|
|
||
|
|
// Create mode
|
||
|
|
if ($action == 'create') {
|
||
|
|
print load_fiche_titre($langs->trans('NewAccountingAccount'));
|
||
|
|
|
||
|
|
print '<form name="add" action="'.$_SERVER["PHP_SELF"].'" method="POST">'."\n";
|
||
|
|
print '<input type="hidden" name="token" value="'.newToken().'">';
|
||
|
|
print '<input type="hidden" name="action" value="add">';
|
||
|
|
|
||
|
|
print dol_get_fiche_head();
|
||
|
|
|
||
|
|
print '<table class="border centpercent">';
|
||
|
|
|
||
|
|
// Chart of account
|
||
|
|
print '<tr><td class="titlefieldcreate"><span class="fieldrequired">'.$langs->trans("Chartofaccounts").'</span></td>';
|
||
|
|
print '<td>';
|
||
|
|
print $accountsystem->ref;
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
// Account number
|
||
|
|
print '<tr><td class="titlefieldcreate"><span class="fieldrequired">'.$langs->trans("AccountNumber").'</span></td>';
|
||
|
|
print '<td><input name="account_number" size="30" value="'.$account_number.'"></td></tr>';
|
||
|
|
|
||
|
|
// Label
|
||
|
|
print '<tr><td><span class="fieldrequired">'.$langs->trans("Label").'</span></td>';
|
||
|
|
print '<td><input name="label" size="70" value="'.$object->label.'"></td></tr>';
|
||
|
|
|
||
|
|
// Label short
|
||
|
|
print '<tr><td>'.$langs->trans("LabelToShow").'</td>';
|
||
|
|
print '<td><input name="labelshort" size="70" value="'.$object->labelshort.'"></td></tr>';
|
||
|
|
|
||
|
|
// Account parent
|
||
|
|
print '<tr><td>'.$langs->trans("Accountparent").'</td>';
|
||
|
|
print '<td>';
|
||
|
|
print $formaccounting->select_account($object->account_parent, 'account_parent', 1, [], 0, 0, 'minwidth200');
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
// Chart of accounts type
|
||
|
|
print '<tr><td>';
|
||
|
|
print $form->textwithpicto($langs->trans("Pcgtype"), $langs->transnoentitiesnoconv("PcgtypeDesc"));
|
||
|
|
print '</td>';
|
||
|
|
print '<td>';
|
||
|
|
print '<input type="text" name="pcg_type" list="pcg_type_datalist" value="'.dol_escape_htmltag(GETPOSTISSET('pcg_type') ? GETPOST('pcg_type', 'alpha') : $object->pcg_type).'">';
|
||
|
|
// autosuggest from existing account types if found
|
||
|
|
print '<datalist id="pcg_type_datalist">';
|
||
|
|
$sql = "SELECT DISTINCT pcg_type FROM " . MAIN_DB_PREFIX . "accounting_account";
|
||
|
|
$sql .= " WHERE fk_pcg_version = '" . $db->escape($accountsystem->ref) . "'";
|
||
|
|
$sql .= ' AND entity in ('.getEntity('accounting_account', 0).')'; // Always limit to current entity. No sharing in accountancy.
|
||
|
|
$sql .= ' LIMIT 50000'; // just as a sanity check
|
||
|
|
$resql = $db->query($sql);
|
||
|
|
if ($resql) {
|
||
|
|
while ($obj = $db->fetch_object($resql)) {
|
||
|
|
print '<option value="' . dol_escape_htmltag($obj->pcg_type) . '">';
|
||
|
|
}
|
||
|
|
}
|
||
|
|
print '</datalist>';
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
// Category
|
||
|
|
print '<tr><td>';
|
||
|
|
print $form->textwithpicto($langs->trans("AccountingCategory"), $langs->transnoentitiesnoconv("AccountingAccountGroupsDesc"));
|
||
|
|
print '</td>';
|
||
|
|
print '<td>';
|
||
|
|
print $formaccounting->select_accounting_category($object->account_category, 'account_category', 1, 0, 1);
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
print '</table>';
|
||
|
|
|
||
|
|
print dol_get_fiche_end();
|
||
|
|
|
||
|
|
print '<div class="center">';
|
||
|
|
print '<input class="button button-save" type="submit" value="'.$langs->trans("Save").'">';
|
||
|
|
print ' ';
|
||
|
|
print '<input class="button button-cancel" type="submit" name="cancel" value="'.$langs->trans("Cancel").'">';
|
||
|
|
print '</div>';
|
||
|
|
|
||
|
|
print '</form>';
|
||
|
|
} elseif ($id > 0 || $ref) {
|
||
|
|
$result = $object->fetch($id, $ref, 1);
|
||
|
|
|
||
|
|
if ($result > 0) {
|
||
|
|
$head = accounting_prepare_head($object);
|
||
|
|
|
||
|
|
// Edit mode
|
||
|
|
if ($action == 'update') {
|
||
|
|
print dol_get_fiche_head($head, 'card', $langs->trans('AccountAccounting'), 0, 'accounting_account');
|
||
|
|
|
||
|
|
print '<form name="update" action="'.$_SERVER["PHP_SELF"].'" method="POST">'."\n";
|
||
|
|
print '<input type="hidden" name="token" value="'.newToken().'">';
|
||
|
|
print '<input type="hidden" name="action" value="edit">';
|
||
|
|
print '<input type="hidden" name="id" value="'.$id.'">';
|
||
|
|
print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
|
||
|
|
|
||
|
|
print '<table class="border centpercent">';
|
||
|
|
|
||
|
|
// Account number
|
||
|
|
print '<tr><td class="titlefieldcreate"><span class="fieldrequired">'.$langs->trans("AccountNumber").'</span></td>';
|
||
|
|
print '<td><input name="account_number" size="30" value="'.$object->account_number.'"></td></tr>';
|
||
|
|
|
||
|
|
// Label
|
||
|
|
print '<tr><td><span class="fieldrequired">'.$langs->trans("Label").'</span></td>';
|
||
|
|
print '<td><input name="label" size="70" value="'.$object->label.'"></td></tr>';
|
||
|
|
|
||
|
|
// Label short
|
||
|
|
print '<tr><td>'.$langs->trans("LabelToShow").'</td>';
|
||
|
|
print '<td><input name="labelshort" size="70" value="'.$object->labelshort.'"></td></tr>';
|
||
|
|
|
||
|
|
// Account parent
|
||
|
|
print '<tr><td>'.$langs->trans("Accountparent").'</td>';
|
||
|
|
print '<td>';
|
||
|
|
// Note: We accept disabled account as parent account so we can build a hierarchy and use only children
|
||
|
|
print $formaccounting->select_account($object->account_parent, 'account_parent', 1, array(), 0, 0, 'minwidth100 maxwidth300 maxwidthonsmartphone', 1, '');
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
// Chart of accounts type
|
||
|
|
print '<tr><td>';
|
||
|
|
print $form->textwithpicto($langs->trans("Pcgtype"), $langs->transnoentitiesnoconv("PcgtypeDesc"));
|
||
|
|
print '</td>';
|
||
|
|
print '<td>';
|
||
|
|
print '<input type="text" name="pcg_type" list="pcg_type_datalist" value="'.dol_escape_htmltag(GETPOSTISSET('pcg_type') ? GETPOST('pcg_type', 'alpha') : $object->pcg_type).'">';
|
||
|
|
// autosuggest from existing account types if found
|
||
|
|
print '<datalist id="pcg_type_datalist">';
|
||
|
|
$sql = 'SELECT DISTINCT pcg_type FROM ' . MAIN_DB_PREFIX . 'accounting_account';
|
||
|
|
$sql .= " WHERE fk_pcg_version = '" . $db->escape($accountsystem->ref) . "'";
|
||
|
|
$sql .= ' AND entity in ('.getEntity('accounting_account', 0).')'; // Always limit to current entity. No sharing in accountancy.
|
||
|
|
$sql .= ' LIMIT 50000'; // just as a sanity check
|
||
|
|
$resql = $db->query($sql);
|
||
|
|
if ($resql) {
|
||
|
|
while ($obj = $db->fetch_object($resql)) {
|
||
|
|
print '<option value="' . dol_escape_htmltag($obj->pcg_type) . '">';
|
||
|
|
}
|
||
|
|
}
|
||
|
|
print '</datalist>';
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
// Category
|
||
|
|
print '<tr><td>';
|
||
|
|
print $form->textwithpicto($langs->trans("AccountingCategory"), $langs->transnoentitiesnoconv("AccountingAccountGroupsDesc"));
|
||
|
|
print '</td>';
|
||
|
|
print '<td>';
|
||
|
|
print $formaccounting->select_accounting_category($object->account_category, 'account_category', 1);
|
||
|
|
print '</td></tr>';
|
||
|
|
|
||
|
|
print '</table>';
|
||
|
|
|
||
|
|
print dol_get_fiche_end();
|
||
|
|
|
||
|
|
print $form->buttonsSaveCancel();
|
||
|
|
|
||
|
|
print '</form>';
|
||
|
|
} else {
|
||
|
|
// View mode
|
||
|
|
$linkback = '<a href="'.DOL_URL_ROOT.'/accountancy/admin/account.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
|
||
|
|
|
||
|
|
print dol_get_fiche_head($head, 'card', $langs->trans('AccountAccounting'), -1, 'accounting_account');
|
||
|
|
|
||
|
|
dol_banner_tab($object, 'ref', $linkback, 1, 'account_number', 'ref');
|
||
|
|
|
||
|
|
|
||
|
|
print '<div class="fichecenter">';
|
||
|
|
print '<div class="underbanner clearboth"></div>';
|
||
|
|
|
||
|
|
print '<table class="border centpercent tableforfield">';
|
||
|
|
|
||
|
|
// Label
|
||
|
|
print '<tr><td class="titlefield">'.$langs->trans("Label").'</td>';
|
||
|
|
print '<td colspan="2">'.$object->label.'</td></tr>';
|
||
|
|
|
||
|
|
// Label to show
|
||
|
|
print '<tr><td class="titlefield">'.$langs->trans("LabelToShow").'</td>';
|
||
|
|
print '<td colspan="2">'.$object->labelshort.'</td></tr>';
|
||
|
|
|
||
|
|
// Account parent
|
||
|
|
$accp = new AccountingAccount($db);
|
||
|
|
if (!empty($object->account_parent)) {
|
||
|
|
$accp->fetch($object->account_parent, '');
|
||
|
|
}
|
||
|
|
print '<tr><td>'.$langs->trans("Accountparent").'</td>';
|
||
|
|
print '<td colspan="2">'.$accp->account_number.' - '.$accp->label.'</td></tr>';
|
||
|
|
|
||
|
|
// Group of accounting account
|
||
|
|
print '<tr><td>';
|
||
|
|
print $form->textwithpicto($langs->trans("Pcgtype"), $langs->transnoentitiesnoconv("PcgtypeDesc"));
|
||
|
|
print '</td>';
|
||
|
|
print '<td colspan="2">'.$object->pcg_type.'</td></tr>';
|
||
|
|
|
||
|
|
// Custom group of accounting account
|
||
|
|
print "<tr><td>";
|
||
|
|
print $form->textwithpicto($langs->trans("AccountingCategory"), $langs->transnoentitiesnoconv("AccountingAccountGroupsDesc"));
|
||
|
|
print "</td><td colspan='2'>".$object->account_category_label."</td>";
|
||
|
|
|
||
|
|
print '</table>';
|
||
|
|
|
||
|
|
print '</div>';
|
||
|
|
|
||
|
|
print dol_get_fiche_end();
|
||
|
|
|
||
|
|
/*
|
||
|
|
* Actions buttons
|
||
|
|
*/
|
||
|
|
print '<div class="tabsAction">';
|
||
|
|
|
||
|
|
if ($user->hasRight('accounting', 'chartofaccount')) {
|
||
|
|
print '<a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=update&token='.newToken().'&id='.$object->id.'">'.$langs->trans('Modify').'</a>';
|
||
|
|
} else {
|
||
|
|
print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("NotAllowed")).'">'.$langs->trans('Modify').'</a>';
|
||
|
|
}
|
||
|
|
|
||
|
|
// Delete
|
||
|
|
$permissiontodelete = $user->hasRight('accounting', 'chartofaccount');
|
||
|
|
print dolGetButtonAction($langs->trans("Delete"), '', 'delete', $_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delete&token='.newToken(), 'delete', $permissiontodelete);
|
||
|
|
|
||
|
|
print '</div>';
|
||
|
|
}
|
||
|
|
} else {
|
||
|
|
dol_print_error($db, $object->error, $object->errors);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// End of page
|
||
|
|
llxFooter();
|
||
|
|
$db->close();
|