dolibarr 25.0.0-alpha
payments.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2011-2022 Alexandre Spangaro <aspangaro@open-dsi.fr>
3 * Copyright (C) 2015-2016 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
5 * Copyright (C) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
6 * Copyright (C) 2024-2025 Frédéric France <frederic.france@free.fr>
7 * Copyright (C) 2026 MDW <mdeweerd@users.noreply.github.com>
8 *
9 * This program is free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 3 of the License, or
12 * (at your option) any later version.
13 *
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU General Public License for more details.
18 *
19 * You should have received a copy of the GNU General Public License
20 * along with this program. If not, see <https://www.gnu.org/licenses/>.
21 */
22
29// Load Dolibarr environment
30require '../main.inc.php';
31require_once DOL_DOCUMENT_ROOT.'/salaries/class/salary.class.php';
32require_once DOL_DOCUMENT_ROOT.'/salaries/class/paymentsalary.class.php';
33require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
34if (isModEnabled('accounting')) {
35 require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingjournal.class.php';
36}
37
46// Load translation files required by the page
47$langs->loadLangs(array("compta", "salaries", "bills", "hrm"));
48
49$action = GETPOST('action', 'aZ09') ? GETPOST('action', 'aZ09') : 'view'; // The action 'add', 'create', 'edit', 'update', 'view', ...
50$massaction = GETPOST('massaction', 'alpha'); // The bulk action (combo box choice into lists)
51$show_files = GETPOSTINT('show_files'); // Show files area generated by bulk actions ?
52$confirm = GETPOST('confirm', 'alpha'); // Result of a confirmation
53$cancel = GETPOST('cancel', 'alpha'); // We click on a Cancel button
54$toselect = GETPOST('toselect', 'array:int'); // Array of ids of elements selected into a list
55$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'bomlist'; // To manage different context of search
56$backtopage = GETPOST('backtopage', 'alpha'); // Go back to a dedicated page
57$optioncss = GETPOST('optioncss', 'aZ'); // Option for the css output (always '' except when 'print')
58$mode = GETPOST('mode', 'alpha'); // mode view for result
59
60
61// Load variable for pagination
62$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
63$sortfield = GETPOST('sortfield', 'aZ09comma');
64$sortorder = GETPOST('sortorder', 'aZ09comma');
65$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
66if (empty($page) || $page == -1 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha') || (empty($toselect) && $massaction === '0')) {
67 $page = 0;
68} // If $page is not defined, or '' or -1 or if we click on clear filters or if we select empty mass action
69$offset = $limit * $page;
70$pageprev = $page - 1;
71$pagenext = $page + 1;
72if (!$sortfield) {
73 $sortfield = "s.datep,s.rowid";
74}
75if (!$sortorder) {
76 $sortorder = "DESC,DESC";
77}
78
79// Initialize a technical objects
80$object = new PaymentSalary($db);
81$extrafields = new ExtraFields($db);
82$diroutputmassaction = $conf->user->dir_output.'/temp/massgeneration/'.$user->id;
83$hookmanager->initHooks(array('salarieslist')); // Note that conf->hooks_modules contains array
84
85// Fetch optionals attributes and labels
86$extrafields->fetch_name_optionals_label($object->table_element);
87
88$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
89
90if (!$sortfield) {
91 $sortfield = "s.datep,s.rowid";
92}
93if (!$sortorder) {
94 $sortorder = "DESC,DESC";
95}
96
97$search_ref = GETPOST('search_ref', 'alpha');
98$search_ref_salary = GETPOST('search_ref_salary', 'alpha');
99$search_user = GETPOST('search_user', 'alpha');
100$search_label = GETPOST('search_label', 'alpha');
101$search_date_start = dol_mktime(0, 0, 0, GETPOSTINT('search_date_startmonth'), GETPOSTINT('search_date_startday'), GETPOSTINT('search_date_startyear'));
102$search_date_end = dol_mktime(23, 59, 59, GETPOSTINT('search_date_endmonth'), GETPOSTINT('search_date_endday'), GETPOSTINT('search_date_endyear'));
103$search_dateep_start = dol_mktime(0, 0, 0, GETPOSTINT('search_dateep_startmonth'), GETPOSTINT('search_dateep_startday'), GETPOSTINT('search_dateep_startyear'));
104$search_dateep_end = dol_mktime(23, 59, 59, GETPOSTINT('search_dateep_endmonth'), GETPOSTINT('search_dateep_endday'), GETPOSTINT('search_dateep_endyear'));
105$search_amount = GETPOST('search_amount', 'alpha');
106$search_account = GETPOST('search_account', 'alpha');
107$search_fk_bank = GETPOST('search_fk_bank', 'alpha');
108$search_chq_number = GETPOST('search_chq_number', 'alpha');
109
110$search_type_id = GETPOST('search_type_id', 'int');
111if (!$search_type_id) { // fallback on filtre (deprecated)
112 $filtre = GETPOST("filtre", 'restricthtml');
113 $newfiltre = str_replace('filtre=', '', $filtre);
114 $filterarray = explode('-', $newfiltre);
115 foreach ($filterarray as $val) {
116 $part = explode(':', $val);
117 if ($part[0] == 's.fk_typepayment') {
118 $search_type_id = (int) $part[1];
119 }
120 }
121}
122
123$childids = $user->getAllChildIds(1);
124
125// Initialize array of search criteria
126$search_all = GETPOST("search_all", 'alpha');
127$search = array();
128foreach ($object->fields as $key => $val) {
129 if (GETPOST('search_'.$key, 'alpha') !== '') {
130 $search[$key] = GETPOST('search_'.$key, 'alpha');
131 }
132}
133
134// List of fields to search into when doing a "search in all"
135$fieldstosearchall = array();
136foreach ($object->fields as $key => $val) {
137 if (!empty($val['searchall'])) {
138 $fieldstosearchall['t.'.$key] = $val['label'];
139 }
140}
141
142// Definition of array of fields for columns
143$arrayfields = array();
144foreach ($object->fields as $key => $val) {
145 // If $val['visible']==0, then we never show the field
146 if (!empty($val['visible'])) {
147 $visible = (int) dol_eval((string) $val['visible'], 1, 1, '1');
148 $arrayfields['t.'.$key] = array(
149 'label' => $val['label'],
150 'checked' => (($visible < 0) ? 0 : 1),
151 'enabled' => (abs($visible) != 3 && (bool) dol_eval((string) $val['enabled'], 1)),
152 'position' => $val['position'],
153 'help' => isset($val['help']) ? $val['help'] : ''
154 );
155 }
156}
157
158$permissiontoread = $user->hasRight('salaries', 'read');
159$permissiontoadd = $user->hasRight('salaries', 'write');
160$permissiontodelete = $user->hasRight('salaries', 'delete');
161
162// Security check
163$socid = GETPOSTINT("socid");
164if ($user->socid > 0) {
165 $socid = $user->socid;
166}
167restrictedArea($user, 'salaries', 0, 'salary', '');
168
169
170/*
171 * Actions
172 */
173$error = 0;
174
175if (GETPOST('cancel', 'alpha')) {
176 $action = 'list';
177 $massaction = '';
178}
179if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
180 $massaction = '';
181}
182
183$parameters = array();
184$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
185if ($reshook < 0) {
186 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
187}
188
189if (empty($reshook)) {
190 // Selection of new fields
191 include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
192
193 // Purge search criteria
194 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All test are required to be compatible with all browsers
195 $search_ref = "";
196 $search_ref_salary = "";
197 $search_user = "";
198 $search_label = "";
199 $search_date_start = '';
200 $search_date_end = '';
201 $search_dateep_start = '';
202 $search_dateep_end = '';
203 $search_amount = "";
204 $search_account = '';
205 $search_fk_bank = '';
206 $search_chq_number = '';
207 $search_type_id = "";
208 }
209 if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')
210 || GETPOST('button_search_x', 'alpha') || GETPOST('button_search.x', 'alpha') || GETPOST('button_search', 'alpha')) {
211 $massaction = ''; // Protection to avoid mass action if we force a new search during a mass action confirmation
212 }
213
214 // Mass actions
215 $objectclass = 'PaymentSalary';
216 $objectlabel = 'SalariesPayments';
217 $uploaddir = $conf->salaries->dir_output;
218
219 global $error;
220 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
221
222 // Validate records
223 if (!$error && $massaction == 'buildsepa' && $permissiontoadd) {
224 $objecttmp = new $objectclass($db);
225
226 // TODO
227 }
228}
229
230/*
231 * View
232 */
233
234$form = new Form($db);
235$salstatic = new Salary($db);
236$paymentsalstatic = new PaymentSalary($db);
237$userstatic = new User($db);
238$accountstatic = new Account($db);
239$accountlinestatic = new AccountLine($db);
240
241$now = dol_now();
242
243//$help_url="EN:Module_BillOfMaterials|FR:Module_BillOfMaterials_FR|ES:Módulo_BillOfMaterials";
244$help_url = '';
245$title = $langs->trans('SalariesPayments');
246
247$sql = "SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.admin, u.photo, u.gender, u.salary as current_salary, u.fk_soc as fk_soc, u.statut as status,";
248$sql .= " s.rowid, s.fk_user, s.amount, s.salary, sal.rowid as id_salary, sal.label, s.datep as datep, sal.dateep, b.datev as datev, s.fk_typepayment as type, s.num_payment, s.fk_bank,";
249$sql .= " ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, ba.iban_prefix as iban, ba.bic, ba.currency_code, ba.clos,";
250$sql .= " pst.code as payment_code";
251$sql .= " FROM ".MAIN_DB_PREFIX."payment_salary as s";
252$sql .= " INNER JOIN ".MAIN_DB_PREFIX."salary as sal ON (sal.rowid = s.fk_salary)";
253$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as pst ON s.fk_typepayment = pst.id";
254$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."bank as b ON s.fk_bank = b.rowid";
255$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."bank_account as ba ON b.fk_account = ba.rowid,";
256$sql .= " ".MAIN_DB_PREFIX."user as u";
257$sql .= " WHERE u.rowid = sal.fk_user";
258$sql .= " AND s.entity IN (".getEntity('payment_salaries').")";
259if (!$user->hasRight('salaries', 'readall')) {
260 if (!$user->hasRight('salaries', 'readchild')) {
261 $sql .= " AND sal.fk_user = ".(int) $user->id;
262 } else {
263 $sql .= " AND sal.fk_user IN (".$db->sanitize(implode(',', $childids)).")";
264 }
265}
266
267// Search criteria
268if ($search_ref) {
269 $sql .= " AND s.rowid=".((int) $search_ref);
270}
271if ($search_ref_salary) {
272 $sql .= " AND sal.rowid=".((int) $search_ref_salary);
273}
274if ($search_user) {
275 $sql .= natural_search(array('u.login', 'u.lastname', 'u.firstname', 'u.email'), $search_user);
276}
277if ($search_label) {
278 $sql .= natural_search(array('sal.label'), $search_label);
279}
280if ($search_date_start) {
281 $sql .= " AND s.datep >= '".$db->idate($search_date_start)."'";
282}
283if ($search_date_end) {
284 $sql .= " AND s.datep <= '".$db->idate($search_date_end)."'";
285}
286if ($search_dateep_start) {
287 $sql .= " AND sal.dateep >= '".$db->idate($search_dateep_start)."'";
288}
289if ($search_dateep_end) {
290 $sql .= " AND sal.dateep <= '".$db->idate($search_dateep_end)."'";
291}
292if ($search_amount) {
293 $sql .= natural_search("s.amount", $search_amount, 1);
294}
295if ($search_account > 0) {
296 $sql .= " AND b.fk_account=".((int) $search_account);
297}
298if ($search_fk_bank) {
299 $sql .= " AND s.fk_bank=".((int) $search_fk_bank);
300}
301if ($search_chq_number) {
302 $sql .= natural_search(array('s.num_payment'), $search_chq_number);
303}
304
305if ($search_type_id > 0) {
306 $sql .= " AND s.fk_typepayment=".((int) $search_type_id);
307}
308$sql .= $db->order($sortfield, $sortorder);
309
310// Count total nb of records
311$nbtotalofrecords = 0;
312$resql = null;
313if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
314 $resql = $db->query($sql);
315 if ($resql) {
316 $nbtotalofrecords = $db->num_rows($resql);
317 } else {
318 dol_print_error($db);
319 }
320
321 if (($page * $limit) > (int) $nbtotalofrecords) { // if total of record found is smaller than page * limit, goto and load page 0
322 $page = 0;
323 $offset = 0;
324 }
325}
326// if total of record found is smaller than limit, no need to do paging and to restart another select with limits set.
327if (is_numeric($nbtotalofrecords) && ($limit > $nbtotalofrecords || empty($limit))) {
328 $num = $nbtotalofrecords;
329} else {
330 if ($limit) {
331 $sql .= $db->plimit($limit + 1, $offset);
332 }
333
334 $resql = $db->query($sql);
335 if (!$resql) {
336 dol_print_error($db);
337 exit;
338 }
339
340 $num = $db->num_rows($resql);
341}
342
343// Output page
344// --------------------------------------------------------------------
345
346llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'bodyforlist');
347
348$arrayofselected = is_array($toselect) ? $toselect : array();
349
350$param = '';
351if (!empty($mode)) {
352 $param .= '&mode='.urlencode($mode);
353}
354if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
355 $param .= '&contextpage='.urlencode($contextpage);
356}
357if ($limit > 0 && $limit != $conf->liste_limit) {
358 $param .= '&limit='.((int) $limit);
359}
360if ($search_type_id) {
361 $param .= '&search_type_id='.urlencode($search_type_id);
362}
363if ($optioncss != '') {
364 $param .= '&optioncss='.urlencode($optioncss);
365}
366if ($search_ref) {
367 $param .= '&search_ref='.urlencode($search_ref);
368}
369if ($search_ref_salary) {
370 $param .= '&search_ref_salary='.urlencode($search_ref_salary);
371}
372if ($search_user) {
373 $param .= '&search_user='.urlencode($search_user);
374}
375if ($search_label) {
376 $param .= '&search_label='.urlencode($search_label);
377}
378if ($search_fk_bank) {
379 $param .= '&search_fk_bank='.urlencode((string) ($search_fk_bank));
380}
381if ($search_chq_number) {
382 $param .= '&search_chq_number='.urlencode((string) ($search_chq_number));
383}
384if ($search_account) {
385 $param .= '&search_account='.urlencode((string) ($search_account));
386}
387if ($search_date_start) {
388 $param .= '&search_date_startday='.GETPOSTINT('search_date_startday').'&search_date_startmonth='.GETPOSTINT('search_date_startmonth').'&search_date_startyear='.GETPOSTINT('search_date_startyear');
389}
390if ($search_dateep_start) {
391 $param .= '&search_dateep_startday='.GETPOSTINT('search_dateep_startday').'&search_dateep_startmonth='.GETPOSTINT('search_dateep_startmonth').'&search_dateep_startyear='.GETPOSTINT('search_dateep_startyear');
392}
393if ($search_date_end) {
394 $param .= '&search_date_endday='.GETPOSTINT('search_date_endday').'&search_date_endmonth='.GETPOSTINT('search_date_endmonth').'&search_date_endyear='.GETPOSTINT('search_date_endyear');
395}
396if ($search_dateep_end) {
397 $param .= '&search_dateep_endday='.urlencode((string) (GETPOSTINT('search_dateep_endday'))).'&search_dateep_endmonth='.urlencode((string) (GETPOSTINT('search_dateep_endmonth'))).'&search_dateep_endyear='.urlencode((string) (GETPOSTINT('search_dateep_endyear')));
398}
399// Add $param from extra fields
400include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
401
402// List of mass actions available
403$arrayofmassactions = array(
404 //'presend'=>$langs->trans("SendByMail"),
405 //'buildsepa'=>$langs->trans("BuildSepa"), // TODO
406);
407//if ($permissiontodelete) $arrayofmassactions['predelete'] = '<span class="fa fa-trash paddingrightonly"></span>'.$langs->trans("Delete");
408if (GETPOSTINT('nomassaction') || in_array($massaction, array('presend', 'predelete'))) {
409 $arrayofmassactions = array();
410}
411$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
412
413print '<form method="POST" id="searchFormList" action="'.dolBuildUrl($_SERVER["PHP_SELF"]).'">';
414if ($optioncss != '') {
415 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
416}
417print '<input type="hidden" name="token" value="'.newToken().'">';
418print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
419print '<input type="hidden" name="action" value="list">';
420print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
421print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
422print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
423print '<input type="hidden" name="mode" value="'.$mode.'">';
424
425
426$url = DOL_URL_ROOT.'/salaries/card.php?action=create';
427if (!empty($socid)) {
428 $url .= '&socid='.$socid;
429}
430$newcardbutton = '';
431$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'));
432$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'));
433$newcardbutton .= dolGetButtonTitleSeparator();
434$newcardbutton = dolGetButtonTitle($langs->trans('NewSalaryPayment'), '', 'fa fa-plus-circle', $url, '', $user->hasRight('salaries', 'write'));
435
436print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'object_payment', 0, $newcardbutton, '', $limit, 0, 0, 1);
437
438$moreforfilter = '';
439
440$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
441//$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
442$selectedfields = '';
443$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons('checkforselect', 1) : '');
444
445print '<div class="div-table-responsive">';
446print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
447
448// Fields title search
449// --------------------------------------------------------------------
450print '<tr class="liste_titre_filter">';
451// Action column
452if ($conf->main_checkbox_left_column) {
453 print '<td class="liste_titre maxwidthsearch">';
454 $searchpicto = $form->showFilterButtons();
455 print $searchpicto;
456 print '</td>';
457}
458// Ref
459print '<td class="liste_titre left">';
460print '<input class="flat" type="text" size="3" name="search_ref" value="'.$db->escape($search_ref).'">';
461print '</td>';
462// Salary
463print '<td class="liste_titre center">';
464print '<input class="flat" type="text" size="3" name="search_ref_salary" value="'.$db->escape($search_ref_salary).'">';
465print '</td>';
466// Label
467print '<td class="liste_titre"><input type="text" class="flat width150" name="search_label" value="'.$db->escape($search_label).'"></td>';
468// Date end period
469print '<td class="liste_titre center">';
470print '<div class="nowrapfordate">';
471print $form->selectDate($search_dateep_start ? $search_dateep_start : -1, 'search_dateep_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
472print '</div>';
473print '<div class="nowrapfordate">';
474print $form->selectDate($search_dateep_end ? $search_dateep_end : -1, 'search_dateep_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
475print '</div>';
476print '</td>';
477// Date payment
478print '<td class="liste_titre center">';
479print '<div class="nowrapfordate">';
480print $form->selectDate($search_date_start ? $search_date_start : -1, 'search_date_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
481print '</div>';
482print '<div class="nowrapfordate">';
483print $form->selectDate($search_date_end ? $search_date_end : -1, 'search_date_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
484print '</div>';
485print '</td>';
486// Date value
487/*print '<td class="liste_titre center">';
488print '</td>';*/
489// Employee
490print '<td class="liste_titre">';
491print '<input class="flat" type="text" size="6" name="search_user" value="'.$db->escape($search_user).'">';
492print '</td>';
493// Type
494print '<td class="liste_titre">';
495print $form->select_types_paiements($search_type_id, 'search_type_id', '', 0, 1, 1, 16, 1, 'maxwidth150', 1);
496print '</td>';
497// Chq number
498print '<td class="liste_titre"><input name="search_chq_number" class="flat width50" type="text" value="'.$db->escape($search_chq_number).'"></td>';
499
500if (isModEnabled("bank")) {
501 // Bank transaction
502 print '<td class="liste_titre">';
503 print '<input class="flat width50" type="text" name="search_fk_bank" value="'.$db->escape($search_fk_bank).'">';
504 print '</td>';
505
506 // Account
507 print '<td class="liste_titre">';
508 $form->select_comptes($search_account, 'search_account', 0, '', 1);
509 print '</td>';
510}
511// Amount
512print '<td class="liste_titre right"><input name="search_amount" class="flat" type="text" size="8" value="'.$db->escape($search_amount).'"></td>';
513
514// Extra fields
515include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
516
517// Fields from hook
518$parameters = array('arrayfields' => $arrayfields);
519$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object); // Note that $action and $object may have been modified by hook
520print $hookmanager->resPrint;
521// Action column
522if (!$conf->main_checkbox_left_column) {
523 print '<td class="liste_titre maxwidthsearch">';
524 $searchpicto = $form->showFilterButtons();
525 print $searchpicto;
526 print '</td>';
527}
528print '</tr>'."\n";
529
530$totalarray = array();
531$totalarray['nbfield'] = 0;
532
533// Fields title label
534// --------------------------------------------------------------------
535print '<tr class="liste_titre">';
536// Action column
537if ($conf->main_checkbox_left_column) {
538 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
539 $totalarray['nbfield']++;
540}
541print_liste_field_titre("RefPayment", $_SERVER["PHP_SELF"], "s.rowid", "", $param, "", $sortfield, $sortorder);
542$totalarray['nbfield']++;
543print_liste_field_titre("Salary", $_SERVER["PHP_SELF"], "sal.rowid", "", $param, '', $sortfield, $sortorder);
544$totalarray['nbfield']++;
545print_liste_field_titre("Label", $_SERVER["PHP_SELF"], "s.label", "", $param, '', $sortfield, $sortorder);
546$totalarray['nbfield']++;
547print_liste_field_titre("PeriodEndDate", $_SERVER["PHP_SELF"], "sal.dateep", "", $param, '', $sortfield, $sortorder, 'center ');
548$totalarray['nbfield']++;
549print_liste_field_titre("DatePayment", $_SERVER["PHP_SELF"], "s.datep,s.rowid", "", $param, '', $sortfield, $sortorder, 'center ');
550$totalarray['nbfield']++;
551print_liste_field_titre("Employee", $_SERVER["PHP_SELF"], "u.rowid", "", $param, "", $sortfield, $sortorder);
552$totalarray['nbfield']++;
553print_liste_field_titre("PaymentMode", $_SERVER["PHP_SELF"], "pst.code", "", $param, '', $sortfield, $sortorder);
554$totalarray['nbfield']++;
555print_liste_field_titre("Numero", $_SERVER["PHP_SELF"], "s.num_payment", "", $param, '', $sortfield, $sortorder, '', 'ChequeOrTransferNumber');
556$totalarray['nbfield']++;
557if (isModEnabled("bank")) {
558 print_liste_field_titre("BankTransactionLine", $_SERVER["PHP_SELF"], "s.fk_bank", "", $param, '', $sortfield, $sortorder);
559 $totalarray['nbfield']++;
560 print_liste_field_titre("BankAccount", $_SERVER["PHP_SELF"], "ba.label", "", $param, "", $sortfield, $sortorder);
561 $totalarray['nbfield']++;
562}
563print_liste_field_titre("PayedByThisPayment", $_SERVER["PHP_SELF"], "s.amount", "", $param, 'class="right"', $sortfield, $sortorder);
564$totalarray['nbfield']++;
565// Extra fields
566include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
567// Hook fields
568$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder);
569$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object); // Note that $action and $object may have been modified by hook
570print $hookmanager->resPrint;
571// Action column
572if (!$conf->main_checkbox_left_column) {
573 print getTitleFieldOfList($selectedfields, 0, $_SERVER["PHP_SELF"], '', '', '', '', $sortfield, $sortorder, 'center maxwidthsearch ')."\n";
574 $totalarray['nbfield']++;
575}
576print '</tr>'."\n";
577
578
579// Detect if we need a fetch on each output line
580$needToFetchEachLine = 0;
581if (isset($extrafields->attributes[$object->table_element]['computed']) && is_array($extrafields->attributes[$object->table_element]['computed']) && count($extrafields->attributes[$object->table_element]['computed']) > 0) {
582 foreach ($extrafields->attributes[$object->table_element]['computed'] as $key => $val) {
583 if (!is_null($val) && preg_match('/\$object/', $val)) {
584 $needToFetchEachLine++;
585 }
586 // There is at least one compute field that use $object
587 }
588}
589
590// Loop on record
591// --------------------------------------------------------------------
592$i = 0;
593$savnbfield = $totalarray['nbfield'];
594$totalarray = array();
595$totalarray['nbfield'] = 0;
596$imaxinloop = ($limit ? min($num, $limit) : $num);
597while ($i < $imaxinloop && $resql !== null) {
598 $obj = $db->fetch_object($resql);
599 if (empty($obj)) {
600 break;
601 }
602 // Should not happen
603
604 // Store properties in $object
605 $object->setVarsFromFetchObj($obj);
606
607 $userstatic->id = $obj->uid;
608 $userstatic->lastname = $obj->lastname;
609 $userstatic->firstname = $obj->firstname;
610 $userstatic->admin = $obj->admin;
611 $userstatic->login = $obj->login;
612 $userstatic->email = $obj->email;
613 $userstatic->socid = $obj->fk_soc;
614 $userstatic->statut = (int) $obj->status;
615 $userstatic->status = (int) $obj->status;
616 $userstatic->gender = $obj->gender;
617 $userstatic->photo = $obj->photo;
618
619 $salstatic->id = $obj->id_salary;
620 $salstatic->ref = $obj->id_salary;
621
622 $paymentsalstatic->id = $obj->rowid;
623 $paymentsalstatic->ref = (string) $obj->rowid;
624 $paymentsalstatic->amount = $obj->amount;
625 $paymentsalstatic->fk_typepayment = $obj->payment_code;
626 $paymentsalstatic->datec = $obj->dateep;
627 $paymentsalstatic->datep = $obj->datep;
628
629 $accountlinestatic->id = $obj->fk_bank;
630 $accountlinestatic->ref = $obj->fk_bank;
631 $paymentsalstatic->fk_bank = $accountlinestatic->id;
632 $paymentsalstatic->fk_user_author = $userstatic->id;
633
634 if ($mode == 'kanban') {
635 if ($i == 0) {
636 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
637 print '<div class="box-flex-container kanban">';
638 }
639 // Output Kanban
640 print $paymentsalstatic->getKanbanView('', array('selected' => in_array($object->id, $arrayofselected)));
641 if ($i == ($imaxinloop - 1)) {
642 print '</div>';
643 print '</td></tr>';
644 }
645 } else {
646 // Show here line of result
647 print '<tr class="oddeven">';
648
649 // Action column
650 if ($conf->main_checkbox_left_column) {
651 print '<td class="nowrap center">';
652 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
653 $selected = 0;
654 if (in_array($object->id, $arrayofselected)) {
655 $selected = 1;
656 }
657 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
658 }
659 print '</td>';
660 if (!$i) {
661 $totalarray['nbfield']++;
662 }
663 }
664
665 // Ref
666 print "<td>".$paymentsalstatic->getNomUrl(1)."</td>\n";
667 if (!$i) {
668 $totalarray['nbfield']++;
669 }
670
671 // Ref salary
672 print "<td>".$salstatic->getNomUrl(1)."</td>\n";
673 if (!$i) {
674 $totalarray['nbfield']++;
675 }
676
677 // Label payment
678 print "<td>".dol_trunc($obj->label, 40)."</td>\n";
679 if (!$i) {
680 $totalarray['nbfield']++;
681 }
682
683 // Date end period
684 print '<td class="center">'.dol_print_date($db->jdate($obj->dateep), 'day')."</td>\n";
685 if (!$i) {
686 $totalarray['nbfield']++;
687 }
688
689 // Date payment
690 print '<td class="center">'.dol_print_date($db->jdate($obj->datep), 'day')."</td>\n";
691 if (!$i) {
692 $totalarray['nbfield']++;
693 }
694
695 // Date value
696 /*print '<td class="center">'.dol_print_date($db->jdate($obj->datev), 'day')."</td>\n";
697 if (!$i) $totalarray['nbfield']++;*/
698
699 // Employee
700 print '<td class="tdoverflowmax150">'.$userstatic->getNomUrl(-1)."</td>\n";
701 if (!$i) {
702 $totalarray['nbfield']++;
703 }
704
705 // Type
706 print '<td>';
707 print $langs->trans("PaymentTypeShort".$obj->payment_code);
708 print '</td>';
709 if (!$i) {
710 $totalarray['nbfield']++;
711 }
712
713 // Chq number
714 print '<td>'.$obj->num_payment.'</td>';
715 if (!$i) {
716 $totalarray['nbfield']++;
717 }
718
719 // Account
720 if (isModEnabled("bank")) {
721 // Bank transaction
722 print '<td>';
723 $accountlinestatic->id = $obj->fk_bank;
724 print $accountlinestatic->getNomUrl(1);
725 print '</td>';
726 if (!$i) {
727 $totalarray['nbfield']++;
728 }
729
730 print '<td>';
731 if ($obj->fk_bank > 0) {
732 //$accountstatic->fetch($obj->fk_bank);
733 $accountstatic->id = $obj->bid;
734 $accountstatic->ref = $obj->bref;
735 $accountstatic->number = $obj->bnumber;
736 $accountstatic->iban = $obj->iban;
737 $accountstatic->bic = $obj->bic;
738 $accountstatic->currency_code = $langs->trans("Currency".$obj->currency_code);
739 $accountstatic->clos = $obj->clos;
740
741 if (isModEnabled('accounting')) {
742 $accountstatic->account_number = $obj->account_number;
743
744 $accountingjournal = new AccountingJournal($db);
745 $accountingjournal->fetch($obj->fk_accountancy_journal);
746
747 $accountstatic->accountancy_journal = $accountingjournal->getNomUrl(0, 1, 1, '', 1);
748 }
749 $accountstatic->label = $obj->blabel;
750 if ($accountstatic->id > 0) {
751 print $accountstatic->getNomUrl(1);
752 }
753 } else {
754 print '&nbsp;';
755 }
756 print '</td>';
757 if (!$i) {
758 $totalarray['nbfield']++;
759 }
760 }
761
762 // Amount
763 print '<td class="nowrap right"><span class="amount">'.price($obj->amount).'</span></td>';
764 if (!$i) {
765 $totalarray['nbfield']++;
766 }
767 if (!$i) {
768 $totalarray['pos'][$totalarray['nbfield']] = 'totalttcfield';
769 }
770 if (!$i) {
771 $totalarray['val']['totalttcfield'] = $obj->amount;
772 } else {
773 $totalarray['val']['totalttcfield'] += $obj->amount;
774 }
775
776
777 // Extra fields
778 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
779 // Fields from hook
780 $parameters = array('arrayfields' => $arrayfields, 'object' => $object, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
781 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object); // Note that $action and $object may have been modified by hook
782 print $hookmanager->resPrint;
783
784 // Action column
785 if (!$conf->main_checkbox_left_column) {
786 print '<td class="nowrap center">';
787 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
788 $selected = 0;
789 if (in_array($object->id, $arrayofselected)) {
790 $selected = 1;
791 }
792 print '<input id="cb'.$object->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$object->id.'"'.($selected ? ' checked="checked"' : '').'>';
793 }
794 print '</td>';
795 if (!$i) {
796 $totalarray['nbfield']++;
797 }
798 }
799
800 print '</tr>'."\n";
801 }
802 $i++;
803}
804
805// Show total line
806include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
807
808
809// If no record found
810if ($num == 0) {
811 /*$colspan = 1;
812 foreach ($arrayfields as $key => $val) {
813 if (!empty($val['checked'])) {
814 $colspan++;
815 }
816 }*/
817 $colspan = 12;
818 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
819}
820
821
822if ($resql !== null) {
823 $db->free($resql);
824}
825
826$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
827$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object); // Note that $action and $object may have been modified by hook
828print $hookmanager->resPrint;
829
830print '</table>'."\n";
831print '</div>'."\n";
832
833print '</form>'."\n";
834
835// End of page
836llxFooter();
837$db->close();
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
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:73
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage bank accounts.
Class to manage bank transaction lines.
Class to manage accounting journals.
Class to manage standard extra fields.
Class to manage generation of HTML components Only common components must be here.
Class to manage payments of salaries.
Class to manage salary payments.
Class to manage Dolibarr users.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
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.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isModEnabled($module)
Is Dolibarr module enabled.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
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.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.