* Copyright (C) 2024 MDW * Copyright (C) 2024 Frédéric France * * 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/localtax/list.php * \ingroup tax * \brief List of IRPF payments */ // Load Dolibarr environment require '../../main.inc.php'; require_once DOL_DOCUMENT_ROOT.'/compta/localtax/class/localtax.class.php'; /** * @var Conf $conf * @var DoliDB $db * @var HookManager $hookmanager * @var Societe $mysoc * @var Translate $langs * @var User $user */ // Load translation files required by the page $langs->load("compta"); $limit = GETPOSTINT('limit'); // Security check $socid = GETPOSTINT('socid'); if ($user->socid) { $socid = $user->socid; } $result = restrictedArea($user, 'tax', '', '', 'charges'); $ltt = GETPOSTINT("localTaxType"); $mode = GETPOST('mode', 'alpha'); /* * View */ llxHeader(); $localtax_static = new Localtax($db); $url = DOL_URL_ROOT.'/compta/localtax/card.php?action=create&localTaxType='.$ltt; if (!empty($socid)) { $url .= '&socid='.$socid; } $param = ''; if (!empty($mode)) { $param .= '&mode='.urlencode($mode); } $newcardbutton = ''; $newcardbutton .= dolGetButtonTitle($langs->trans('ViewList'), '', 'fa fa-bars imgforviewmode', $_SERVER["PHP_SELF"].'?localTaxType='.$ltt.'&mode=common'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ((empty($mode) || $mode == 'common') ? 2 : 1), array('morecss' => 'reposition')); $newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanban'), '', 'fa fa-th-list imgforviewmode', $_SERVER["PHP_SELF"].'?localTaxType='.$ltt.'&mode=kanban'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ($mode == 'kanban' ? 2 : 1), array('morecss' => 'reposition')); $newcardbutton .= dolGetButtonTitleSeparator(); $newcardbutton .= dolGetButtonTitle($langs->trans('NewLocalTaxPayment', ($ltt + 1)), '', 'fa fa-plus-circle', $url, '', $user->hasRight('tax', 'charges', 'creer')); print load_fiche_titre($langs->transcountry($ltt == 2 ? "LT2Payments" : "LT1Payments", $mysoc->country_code), $newcardbutton, 'title_accountancy'); $sql = "SELECT rowid, amount, label, f.datev, f.datep"; $sql .= " FROM ".MAIN_DB_PREFIX."localtax as f "; $sql .= " WHERE f.entity = ".$conf->entity." AND localtaxtype = ".((int) $ltt); $sql .= " ORDER BY datev DESC"; $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $i = 0; $total = 0; print '

'; // You can use div-table-responsive-no-min if you don't need reserved height for your table print ''; print ''; print ''; print ""; print ""; print ''; print ''; print "\n"; $savnbfield = 5; $imaxinloop = ($limit ? min($num, $limit) : $num); while ($i < $imaxinloop) { $obj = $db->fetch_object($result); $localtax_static->label = $obj->label; $localtax_static->id = $obj->rowid; $localtax_static->ref = $obj->rowid; $localtax_static->datev = $obj->datev; $localtax_static->datep = $obj->datep; $localtax_static->amount = $obj->amount; $total += $obj->amount; if ($mode == 'kanban') { if ($i == 0) { print ''; } } else { print ''; print "\n"; print "\n"; print '\n"; print '\n"; print ''; print "\n"; } $i++; } print ''; print ''; print "

'.$langs->trans("Ref").'	".$langs->trans("Label")."	".$langs->trans("PeriodEndDate")."	'.$langs->trans("DatePayment").'	'.$langs->trans("PayedByThisPayment").'
'; print ' '; } // Output Kanban print $localtax_static->getKanbanView('', array('selected' => in_array($object->id, $arrayofselected))); if ($i == ($imaxinloop - 1)) { print ' '; print '
".$localtax_static->getNomUrl(1)."	".dol_trunc($obj->label, 40)."	'.dol_print_date($db->jdate($obj->datev), 'day')."	'.dol_print_date($db->jdate($obj->datep), 'day')."	'.price($obj->amount).'
'.$langs->trans("Total").'				'.price($total).'

"; print '

'; $db->free($result); } else { dol_print_error($db); } // End of page llxFooter(); $db->close();