dolibarr 20.0.0
list.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2011-2014 Juanjo Menent <jmenent@2byte.es>
3 *
4 * This program is free software; you can redistribute it and/or modify
5 * it under the terms of the GNU General Public License as published by
6 * the Free Software Foundation; either version 3 of the License, or
7 * (at your option) any later version.
8 *
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 *
14 * You should have received a copy of the GNU General Public License
15 * along with this program. If not, see <https://www.gnu.org/licenses/>.
16 */
17
24// Load Dolibarr environment
25require '../../main.inc.php';
26require_once DOL_DOCUMENT_ROOT.'/compta/localtax/class/localtax.class.php';
27
28// Load translation files required by the page
29$langs->load("compta");
30
31$limit = GETPOSTINT('limit');
32
33// Security check
34$socid = GETPOSTINT('socid');
35if ($user->socid) {
36 $socid = $user->socid;
37}
38
39$result = restrictedArea($user, 'tax', '', '', 'charges');
40$ltt = GETPOSTINT("localTaxType");
41$mode = GETPOST('mode', 'alpha');
42
43
44/*
45 * View
46 */
47
48llxHeader();
49
50$localtax_static = new Localtax($db);
51
52$url = DOL_URL_ROOT.'/compta/localtax/card.php?action=create&localTaxType='.$ltt;
53if (!empty($socid)) {
54 $url .= '&socid='.$socid;
55}
56$param = '';
57if (!empty($mode)) {
58 $param .= '&mode='.urlencode($mode);
59}
60$newcardbutton = '';
61$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'));
62$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'));
63$newcardbutton .= dolGetButtonTitleSeparator();
64$newcardbutton .= dolGetButtonTitle($langs->trans('NewLocalTaxPayment', ($ltt + 1)), '', 'fa fa-plus-circle', $url, '', $user->hasRight('tax', 'charges', 'creer'));
65
66print load_fiche_titre($langs->transcountry($ltt == 2 ? "LT2Payments" : "LT1Payments", $mysoc->country_code), $newcardbutton, 'title_accountancy');
67
68$sql = "SELECT rowid, amount, label, f.datev, f.datep";
69$sql .= " FROM ".MAIN_DB_PREFIX."localtax as f ";
70$sql .= " WHERE f.entity = ".$conf->entity." AND localtaxtype = ".((int) $ltt);
71$sql .= " ORDER BY datev DESC";
72
73$result = $db->query($sql);
74if ($result) {
75 $num = $db->num_rows($result);
76 $i = 0;
77 $total = 0;
78
79 print '<div class="div-table-responsive-no-min">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
80 print '<table class="noborder centpercent">';
81 print '<tr class="liste_titre">';
82 print '<td class="nowrap" align="left">'.$langs->trans("Ref").'</td>';
83 print "<td>".$langs->trans("Label")."</td>";
84 print "<td>".$langs->trans("PeriodEndDate")."</td>";
85 print '<td class="nowrap" align="left">'.$langs->trans("DatePayment").'</td>';
86 print '<td class="right">'.$langs->trans("PayedByThisPayment").'</td>';
87 print "</tr>\n";
88
89 $savnbfield = 5;
90
91 $imaxinloop = ($limit ? min($num, $limit) : $num);
92 while ($i < $imaxinloop) {
93 $obj = $db->fetch_object($result);
94
95 $localtax_static->label = $obj->label;
96 $localtax_static->id = $obj->rowid;
97 $localtax_static->ref = $obj->rowid;
98 $localtax_static->datev = $obj->datev;
99 $localtax_static->datep = $obj->datep;
100 $localtax_static->amount = $obj->amount;
101
102 $total = $total + $obj->amount;
103
104 if ($mode == 'kanban') {
105 if ($i == 0) {
106 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
107 print '<div class="box-flex-container kanban">';
108 }
109 // Output Kanban
110 print $localtax_static->getKanbanView('', array('selected' => in_array($object->id, $arrayofselected)));
111 if ($i == ($imaxinloop - 1)) {
112 print '</div>';
113 print '</td></tr>';
114 }
115 } else {
116 print '<tr class="oddeven">';
117 print "<td>".$localtax_static->getNomUrl(1)."</td>\n";
118 print "<td>".dol_trunc($obj->label, 40)."</td>\n";
119 print '<td class="left">'.dol_print_date($db->jdate($obj->datev), 'day')."</td>\n";
120 print '<td class="left">'.dol_print_date($db->jdate($obj->datep), 'day')."</td>\n";
121
122 print '<td class="right nowraponall"><span class="amount">'.price($obj->amount).'</span></td>';
123 print "</tr>\n";
124 }
125 $i++;
126 }
127 print '<tr class="liste_total"><td colspan="4">'.$langs->trans("Total").'</td>';
128 print '<td class="right"><span class="amount">'.price($total).'</span></td></tr>';
129
130 print "</table>";
131 print '</div>';
132
133 $db->free($result);
134} else {
135 dol_print_error($db);
136}
137
138// End of page
139llxFooter();
140$db->close();
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:58
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Definition wrapper.php:55
llxFooter()
Empty footer.
Definition wrapper.php:69
Class to manage local tax.
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.