dolibarr 21.0.0-alpha
list.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2005-2016 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2005-2009 Regis Houssin <regis.houssin@inodbox.com>
5 * Copyright (C) 2010-2018 Juanjo Menent <jmenent@2byte.es>
6 * Copyright (C) 2022-2024 Alexandre Spangaro <alexandre@inovea-conseil.com>
7 *
8 * This program is free software; you can redistribute it and/or modify
9 * it under the terms of the GNU General Public License as published by
10 * the Free Software Foundation; either version 3 of the License, or
11 * (at your option) any later version.
12 *
13 * This program is distributed in the hope that it will be useful,
14 * but WITHOUT ANY WARRANTY; without even the implied warranty of
15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 * GNU General Public License for more details.
17 *
18 * You should have received a copy of the GNU General Public License
19 * along with this program. If not, see <https://www.gnu.org/licenses/>.
20 */
21
28// Load Dolibarr environment
29require '../../main.inc.php';
30require_once DOL_DOCUMENT_ROOT.'/compta/prelevement/class/bonprelevement.class.php';
31require_once DOL_DOCUMENT_ROOT.'/compta/prelevement/class/ligneprelevement.class.php';
32require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
33
34// Load translation files required by the page
35$langs->loadLangs(array('banks', 'withdrawals', 'companies', 'categories'));
36
37$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'add', 'create', 'edit', 'update', 'view', ...
38$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
39$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions ?
40$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
41$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
42$toselect = GETPOST('toselect', 'array'); // Array of ids of elements selected into a list
43$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'directdebitcredittransferlinelist'; // To manage different context of search
44$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
45$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
46$mode = GETPOST('mode', 'aZ'); // The output mode ('list', 'kanban', 'hierarchy', 'calendar', ...)
47
48$type = GETPOST('type', 'aZ09');
49
50// Load variable for pagination
51$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
52$sortfield = GETPOST('sortfield', 'aZ09comma');
53$sortorder = GETPOST('sortorder', 'aZ09comma');
54$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
55if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
56 // If $page is not defined, or '' or -1 or if we click on clear filters
57 $page = 0;
58}
59$offset = $limit * $page;
60$pageprev = $page - 1;
61$pagenext = $page + 1;
62if (!$sortorder) {
63 $sortorder = "DESC";
64}
65if (!$sortfield) {
66 $sortfield = ($type == 'bank-transfer' ? "datec" : "p.datec");
67}
68
69$search_line = GETPOST('search_line', 'alpha');
70$search_bon = GETPOST('search_bon', 'alpha');
71$search_code = GETPOST('search_code', 'alpha');
72$search_company = GETPOST('search_company', 'alpha');
73$statut = GETPOSTINT('statut');
74
75$bon = new BonPrelevement($db);
76$line = new LignePrelevement($db);
77$company = new Societe($db);
78$userstatic = new User($db);
79
80$hookmanager->initHooks(array('withdrawalsreceiptslineslist'));
81
82// Security check
83$socid = GETPOSTINT('socid');
84if ($user->socid) {
85 $socid = $user->socid;
86}
87if ($type == 'bank-transfer') {
88 $result = restrictedArea($user, 'paymentbybanktransfer', '', '', '');
89} else {
90 $result = restrictedArea($user, 'prelevement', '', '', 'bons');
91}
92
93
94/*
95 * Actions
96 */
97
98if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers
99 $search_line = "";
100 $search_bon = "";
101 $search_code = "";
102 $search_company = "";
103 $statut = "";
104}
105
106
107/*
108 * View
109 */
110
111$form = new Form($db);
112
113$title = $langs->trans("WithdrawalsLines");
114if ($type == 'bank-transfer') {
115 $title = $langs->trans("CreditTransferLines");
116}
117$help_url = '';
118
119$sql = "SELECT p.rowid, p.ref, p.statut as status, p.datec";
120$sql .= " , f.rowid as facid, f.ref as invoiceref, f.total_ttc";
121$sql .= " , s.rowid as socid, s.nom as name, s.code_client, s.code_fournisseur, s.email";
122$sql .= " , pl.amount, pl.statut as statut_ligne, pl.rowid as rowid_ligne";
123
124$sqlfields = $sql; // $sql fields to remove for count total
125
126$sql .= " FROM ".MAIN_DB_PREFIX."prelevement_bons as p";
127$sql .= " , ".MAIN_DB_PREFIX."prelevement_lignes as pl";
128$sql .= " , ".MAIN_DB_PREFIX."prelevement as pf";
129if ($type == 'bank-transfer') {
130 $sql .= " , ".MAIN_DB_PREFIX."facture_fourn as f";
131} else {
132 $sql .= " , ".MAIN_DB_PREFIX."facture as f";
133}
134$sql .= " , ".MAIN_DB_PREFIX."societe as s";
135$sql .= " WHERE pl.fk_prelevement_bons = p.rowid";
136$sql .= " AND pf.fk_prelevement_lignes = pl.rowid";
137if ($type == 'bank-transfer') {
138 $sql .= " AND pf.fk_facture_fourn = f.rowid";
139} else {
140 $sql .= " AND pf.fk_facture = f.rowid";
141}
142$sql .= " AND f.fk_soc = s.rowid";
143$sql .= " AND f.entity IN (".getEntity('invoice').")";
144if ($socid) {
145 $sql .= " AND s.rowid = ".((int) $socid);
146}
147if ($search_bon) {
148 $sql .= " AND pl.rowid = '".$db->escape($search_bon)."'";
149}
150if ($search_line) {
151 $sql .= natural_search("p.ref", $search_line);
152}
153if ($type == 'bank-transfer') {
154 if ($search_code) {
155 $sql .= natural_search("s.code_fournisseur", $search_code);
156 }
157} else {
158 if ($search_code) {
159 $sql .= natural_search("s.code_client", $search_code);
160 }
161}
162if ($search_company) {
163 $sql .= natural_search("s.nom", $search_company);
164}
165//get salary invoices
166if ($type == 'bank-transfer') {
167 $sql .= " UNION";
168
169 $sql .= " SELECT p.rowid, p.ref, p.statut as status, p.datec";
170 $sql .= ", sl.rowid as facid, sl.ref as invoiceref, sl.amount";
171 $sql .= ", u.rowid as socid, CONCAT(u.firstname, ' ', u.lastname) as name, u.ref_employee as code_client, NULL as code_fournisseur, u.email";
172 $sql .= ", pl.amount, pl.statut as statut_ligne, pl.rowid as rowid_ligne";
173
174 $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_bons as p";
175 $sql .= " , ".MAIN_DB_PREFIX."prelevement_lignes as pl";
176 $sql .= " , ".MAIN_DB_PREFIX."prelevement as pf";
177 $sql .= " , ".MAIN_DB_PREFIX."salary as sl";
178 $sql .= " , ".MAIN_DB_PREFIX."user as u";
179
180 $sql .= " WHERE pl.fk_prelevement_bons = p.rowid";
181 $sql .= " AND pf.fk_prelevement_lignes = pl.rowid";
182 $sql .= " AND pf.fk_salary = sl.rowid";
183 $sql .= " AND sl.fk_user = u.rowid";
184 $sql .= " AND sl.entity IN (".getEntity('invoice').")";
185 if ($socid) {
186 $sql .= " AND s.rowid = ".((int) $socid);
187 }
188 if ($search_bon) {
189 $sql .= " AND pl.rowid = '".$db->escape($search_bon)."'";
190 }
191 if ($search_line) {
192 $sql .= natural_search("p.ref", $search_line);
193 }
194 if ($type == 'bank-transfer') {
195 if ($search_code) {
196 $sql .= natural_search("NULL", $search_code);
197 }
198 } else {
199 if ($search_code) {
200 $sql .= natural_search("s.code_client", $search_code);
201 }
202 }
203 if ($search_company) {
204 $sql .= natural_search(array("u.firstname","u.lastname"), $search_company);
205 }
206}
207// Count total nb of records
208$nbtotalofrecords = '';
209if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
210 /* The fast and low memory method to get and count full list converts the sql into a sql count */
211 if ($type == 'bank-transfer') {
212 $sqlforcount = "SELECT COUNT(*) as nbtotalofrecords FROM (" . $sql . ") AS combined_results";
213 } else {
214 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
215 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
216 }
217
218 $resql = $db->query($sqlforcount);
219 if ($resql) {
220 $objforcount = $db->fetch_object($resql);
221 $nbtotalofrecords = $objforcount->nbtotalofrecords;
222 } else {
223 dol_print_error($db);
224 }
225
226 if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
227 $page = 0;
228 $offset = 0;
229 }
230 $db->free($resql);
231}
232
233// Complete request and execute it with limit
234$sql .= $db->order($sortfield, $sortorder);
235if ($limit) {
236 $sql .= $db->plimit($limit + 1, $offset);
237}
238
239$resql = $db->query($sql);
240if (!$resql) {
241 dol_print_error($db);
242 exit;
243}
244
245$num = $db->num_rows($resql);
246
247// Output page
248// --------------------------------------------------------------------
249
250llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'bodyforlist');
251
252$arrayofselected = is_array($toselect) ? $toselect : array();
253
254$param = '';
255$param .= "&statut=".urlencode($statut);
256$param .= "&search_bon=".urlencode($search_bon);
257if ($type == 'bank-transfer') {
258 $param .= '&type=bank-transfer';
259}
260if (!empty($mode)) {
261 $param .= '&mode='.urlencode($mode);
262}
263if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
264 $param .= '&contextpage='.urlencode($contextpage);
265}
266if ($limit > 0 && $limit != $conf->liste_limit) {
267 $param .= '&limit='.((int) $limit);
268}
269if ($optioncss != '') {
270 $param .= '&optioncss='.urlencode($optioncss);
271}
272
273$arrayofmassactions = array(
274 //'presend'=>img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
275 //'builddoc'=>img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
276);
277$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
278
279print '<form method="POST" id="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
280print '<input type="hidden" name="token" value="'.newToken().'">';
281if ($optioncss != '') {
282 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
283}
284print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
285print '<input type="hidden" name="action" value="list">';
286print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
287print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
288print '<input type="hidden" name="page" value="'.$page.'">';
289print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
290print '<input type="hidden" name="page_y" value="">';
291print '<input type="hidden" name="mode" value="'.$mode.'">';
292
293if ($type != '') {
294 print '<input type="hidden" name="type" value="'.$type.'">';
295}
296
297$newcardbutton = '';
298$newcardbutton .= dolGetButtonTitle($langs->trans('ViewList'), '', 'fa fa-bars imgforviewmode', $_SERVER["PHP_SELF"].'?mode=common'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ((empty($mode) || $mode == 'common') ? 2 : 1), array('morecss'=>'reposition'));
299$newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanban'), '', 'fa fa-th-list imgforviewmode', $_SERVER["PHP_SELF"].'?mode=kanban'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ($mode == 'kanban' ? 2 : 1), array('morecss'=>'reposition'));
300
301print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'generic', 0, $newcardbutton, '', $limit, 0, 0, 1);
302
303$moreforfilter = '';
304/*$moreforfilter.='<div class="divsearchfield">';
305 $moreforfilter.= $langs->trans('MyFilter') . ': <input type="text" name="search_myfield" value="'.dol_escape_htmltag($search_myfield).'">';
306 $moreforfilter.= '</div>';*/
307
308$parameters = array();
309$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
310if (empty($reshook)) {
311 $moreforfilter .= $hookmanager->resPrint;
312} else {
313 $moreforfilter = $hookmanager->resPrint;
314}
315
316if (!empty($moreforfilter)) {
317 print '<div class="liste_titre liste_titre_bydiv centpercent">';
318 print $moreforfilter;
319 print '</div>';
320}
321
322$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
323$htmlofselectarray = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')); // This also change content of $arrayfields with user setup
324$selectedfields = ($mode != 'kanban' ? $htmlofselectarray : '');
325$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
326
327print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
328print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
329
330// Fields title search
331// --------------------------------------------------------------------
332print '<tr class="liste_titre_filter">';
333// Action column
334if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
335 print '<td class="liste_titre center maxwidthsearch">';
336 $searchpicto = $form->showFilterButtons('left');
337 print $searchpicto;
338 print '</td>';
339}
340print '<td class="liste_titre"><input type="text" class="flat" name="search_line" value="'.dol_escape_htmltag($search_line).'" size="6"></td>';
341print '<td class="liste_titre"><input type="text" class="flat" name="search_bon" value="'.dol_escape_htmltag($search_bon).'" size="6"></td>';
342print '<td class="liste_titre">&nbsp;</td>';
343print '<td class="liste_titre"><input type="text" class="flat" name="search_company" value="'.dol_escape_htmltag($search_company).'" size="6"></td>';
344print '<td class="liste_titre center"><input type="text" class="flat" name="search_code" value="'.dol_escape_htmltag($search_code).'" size="6"></td>';
345print '<td class="liste_titre">&nbsp;</td>';
346print '<td class="liste_titre">&nbsp;</td>';
347// Action column
348if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
349 print '<td class="liste_titre center maxwidthsearch">';
350 $searchpicto = $form->showFilterButtons();
351 print $searchpicto;
352 print '</td>';
353}
354print '</tr>'."\n";
355
356$totalarray = array();
357$totalarray['nbfield'] = 0;
358
359$columntitle = "WithdrawalsReceipts";
360$columntitlethirdparty = "CustomerCode";
361$columncodethirdparty = "s.code_client";
362if ($type == 'bank-transfer') {
363 $columntitle = "BankTransferReceipts";
364 $columntitlethirdparty = "SupplierCode";
365 $columncodethirdparty = "s.code_fournisseur";
366}
367
368// Fields title label
369// --------------------------------------------------------------------
370print '<tr class="liste_titre">';
371// Action column
372if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
373 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
374 $totalarray['nbfield']++;
375}
376print_liste_field_titre($columntitle, $_SERVER["PHP_SELF"], "p.ref", '', $param, '', $sortfield, $sortorder);
377$totalarray['nbfield']++;
378print_liste_field_titre("Line", $_SERVER["PHP_SELF"], '', '', $param, '', $sortfield, $sortorder);
379$totalarray['nbfield']++;
380print_liste_field_titre(($type == 'bank-transfer' ? "BillsAndSalaries" : "Bills"), $_SERVER["PHP_SELF"], "f.ref", '', $param, '', $sortfield, $sortorder);
381$totalarray['nbfield']++;
382print_liste_field_titre("ThirdParty", $_SERVER["PHP_SELF"], "s.nom", '', $param, '', $sortfield, $sortorder);
383$totalarray['nbfield']++;
384print_liste_field_titre($columntitlethirdparty, $_SERVER["PHP_SELF"], $columncodethirdparty, '', $param, '', $sortfield, $sortorder, 'center ');
385$totalarray['nbfield']++;
386print_liste_field_titre("Date", $_SERVER["PHP_SELF"], "p.datec", "", $param, '', $sortfield, $sortorder, 'center ');
387$totalarray['nbfield']++;
388print_liste_field_titre("Amount", $_SERVER["PHP_SELF"], "pl.amount", "", $param, '', $sortfield, $sortorder, 'right ');
389$totalarray['nbfield']++;
390// Action column
391if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
392 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
393 $totalarray['nbfield']++;
394}
395print '</tr>'."\n";
396
397// Loop on record
398// --------------------------------------------------------------------
399$i = 0;
400$savnbfield = $totalarray['nbfield'];
401$totalarray = array();
402$totalarray['nbfield'] = 0;
403
404$imaxinloop = ($limit ? min($num, $limit) : $num);
405while ($i < $imaxinloop) {
406 $obj = $db->fetch_object($resql);
407
408 $bon->id = $obj->rowid;
409 $bon->ref = $obj->ref;
410 $bon->statut = $obj->status;
411 $bon->date_echeance = $obj->datec;
412 $bon->total = $obj->amount;
413
414 $object = $bon;
415 if ($object->checkIfSalaryBonPrelevement()) {
416 $fullname = explode(' ', $obj->name);
417
418 $userstatic->id = $obj->socid;
419 $userstatic->email = $obj->email;
420 $userstatic->firstname = $fullname[0];
421 $userstatic->lastname = isset($fullname[1]) ? $fullname[1] : '';
422 }
423
424 $company->id = $obj->socid;
425 $company->name = $obj->name;
426 $company->email = $obj->email;
427 $company->code_client = $obj->code_client;
428
429 if ($mode == 'kanban') {
430 if ($i == 0) {
431 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
432 print '<div class="box-flex-container kanban">';
433 }
434 // Output Kanban
435 $selected = -1;
436 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
437 $selected = 0;
438 if (in_array($object->id, $arrayofselected)) {
439 $selected = 1;
440 }
441 }
442 print $object->getKanbanView('', array('selected' => $selected));
443 if ($i == ($imaxinloop - 1)) {
444 print '</div>';
445 print '</td></tr>';
446 }
447 } else {
448 // Show line of result
449 $j = 0;
450 print '<tr data-rowid="'.$object->id.'" class="oddeven">';
451
452 // Action column
453 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
454 print '<td class="nowrap center">';
455 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
456 $selected = 0;
457 if (in_array($object->id, $arrayofselected)) {
458 $selected = 1;
459 }
460 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
461 }
462 print '</td>';
463 if (!$i) {
464 $totalarray['nbfield']++;
465 }
466 }
467 print '<td>';
468 print $bon->getNomUrl(1);
469 print "</td>\n";
470
471 print '<td>';
472 print $line->LibStatut($obj->statut_ligne, 2);
473 print "&nbsp;";
474 print '<a href="'.DOL_URL_ROOT.'/compta/prelevement/line.php?id='.$obj->rowid_ligne.'">';
475 print substr('000000'.$obj->rowid_ligne, -6);
476 print '</a></td>';
477
478 // Ref invoice or salary
479 print '<td class="nowraponall">';
480 $link_to_bill = '/compta/facture/card.php?facid=';
481 $link_title = 'Invoice';
482 $link_picto = 'bill';
483 if ($type == 'bank-transfer') {
484 if ($bon->checkIfSalaryBonPrelevement()) {
485 $link_to_bill = '/salaries/card.php?id=';
486 $link_title = 'SalaryInvoice';
487 $link_picto = 'salary';
488 } else {
489 $link_to_bill = '/fourn/facture/card.php?facid=';
490 $link_title = 'SupplierInvoice';
491 $link_picto = 'supplier_invoice';
492 }
493 }
494 print '<a href="'.DOL_URL_ROOT.$link_to_bill.$obj->facid.'">';
495 print img_object($langs->trans($link_title), $link_picto);
496 if (!$bon->checkIfSalaryBonPrelevement()) {
497 print '&nbsp;'.$obj->invoiceref."</td>\n";
498 } else {
499 print '&nbsp;'.(!empty($obj->invoiceref) ? $obj->invoiceref : $obj->facid)."</td>\n";
500 }
501 print '</a>';
502 print '</td>';
503
504 // Thirdparty (company or user)
505 print '<td class="tdoverflowmax150">';
506 print(!$bon->checkIfSalaryBonPrelevement() ? $company->getNomUrl(1) : $userstatic->getNomUrl(-1));
507 print "</td>\n";
508
509 print '<td class="center">';
510 $link_to_tab = '/comm/card.php?socid=';
511 $link_code = $obj->code_client;
512 if ($type == 'bank-transfer') {
513 $link_to_tab = '/fourn/card.php?socid=';
514 $link_code = $obj->code_fournisseur;
515 }
516 print '<a href="'.DOL_URL_ROOT.$link_to_tab.$company->id.'">'.$link_code."</a>";
517 print "</td>\n";
518
519 print '<td class="center">'.dol_print_date($db->jdate($obj->datec), 'day')."</td>\n";
520
521 print '<td class="nowraponall right"><span class="amount">'.price($obj->amount)."</span></td>\n";
522
523 // Action column
524 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
525 print '<td class="nowrap center">';
526 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
527 $selected = 0;
528 if (in_array($object->id, $arrayofselected)) {
529 $selected = 1;
530 }
531 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
532 }
533 print '</td>';
534 if (!$i) {
535 $totalarray['nbfield']++;
536 }
537 }
538
539 print '</tr>'."\n";
540 }
541 $i++;
542}
543
544if ($num == 0) {
545 print '<tr><td colspan="8"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
546}
547
548$db->free($resql);
549
550$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
551$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
552print $hookmanager->resPrint;
553
554print '</table>'."\n";
555print '</div>'."\n";
556
557print '</form>'."\n";
558
559
560// End of page
561llxFooter();
562$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($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Definition wrapper.php:70
Class to manage withdrawal receipts.
Class to manage generation of HTML components Only common components must be here.
Class to manage withdrawals.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
llxFooter()
Footer empty.
Definition document.php:107
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
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.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
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...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
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.