* Copyright (C) 2004-2013 Laurent Destailleur * Copyright (C) 2005-2009 Regis Houssin * Copyright (C) 2013 Charles-Fr BENKE * Copyright (C) 2015 Jean-François Ferry * Copyright (C) 2016 Marcos García * * 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 . */ /** * \file htdocs/compta/bank/categ.php * \ingroup compta/bank * \brief Page to manage Bank Categories */ // Load Dolibarr environment require '../../main.inc.php'; require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php'; require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/bankcateg.class.php'; // Load translation files required by the page $langs->loadLangs(array('banks', 'categories')); // Get Parameters $action = GETPOST('action', 'aZ09'); $optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print') $categid = GETPOST('categid'); $label = GETPOST("label"); // Initialize technical objects $bankcateg = new BankCateg($db); // Security Check Access Control if (!$user->rights->banque->configurer) { accessforbidden(); } /* * Actions */ if (GETPOST('add')) { if ($label) { $bankcateg = new BankCateg($db); $bankcateg->label = GETPOST('label'); $bankcateg->create($user); } } if ($categid) { $bankcateg = new BankCateg($db); if ($bankcateg->fetch($categid) > 0) { //Update category if (GETPOST('update') && $label) { $bankcateg->label = $label; $bankcateg->update($user); } //Delete category if ($action == 'delete') { $bankcateg->delete($user); } } } /* * View */ $title = $langs->trans('RubriquesTransactions'); $help_url = 'EN:Module_Banks_and_Cash|FR:Module_Banques_et_Caisses|ES:Módulo_Bancos_y_Cajas'; llxHeader('', $title, $help_url); print load_fiche_titre($langs->trans("RubriquesTransactions"), '', 'object_category'); print '
'; if ($optioncss != '') { print ''; } print ''; print ''; print ''; /*print ''; print ''; print ''; print ''; */ print '
'; // You can use div-table-responsive-no-min if you dont need reserved height for your table print ''; print ''; print ''; print ''; print ''; print "\n"; // Line to add category if ($action != 'edit') { print ''; print ''; print ''; print ''; print ''; } $sql = "SELECT rowid, label"; $sql .= " FROM ".MAIN_DB_PREFIX."bank_categ"; $sql .= " WHERE entity = ".$conf->entity; $sql .= " ORDER BY rowid"; $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; $total = 0; while ($i < $num) { $objp = $db->fetch_object($result); print ''; print ''; if (GETPOST('action', 'aZ09') == 'edit' && GETPOST("categid") == $objp->rowid) { print '"; } else { print ""; print ''; print ''; } print ""; $i++; } $db->free($result); } print '
'.$langs->trans("Ref").''.$langs->trans("Label").'
 
'.$objp->rowid.''; print ''; print ''; print ''; print "".$objp->label."'; //print ''.$langs->trans("List").''; print ''; print ''.img_edit().''; print ''.img_delete().''; print '
'; print '
'; print '
'; // End of page llxFooter(); $db->close();