dolibarr 25.0.0-alpha
virement_request.php
Go to the documentation of this file.
1<?php
2
3/* Copyright (C) 2005-2015 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2015 Charlie BENKE <charlie@patas-monkey.com>
5 * Copyright (C) 2017-2019 Alexandre Spangaro <aspangaro@open-dsi.fr>
6 * Copyright (C) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
7 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
8 * Copyright (C) 2024-2026 Frédéric France <frederic.france@free.fr>
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 3 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program. If not, see <https://www.gnu.org/licenses/>.
22 */
23
30// Load Dolibarr environment
31require '../main.inc.php';
32require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
33require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
34require_once DOL_DOCUMENT_ROOT.'/salaries/class/salary.class.php';
35require_once DOL_DOCUMENT_ROOT.'/salaries/class/paymentsalary.class.php';
36require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
37require_once DOL_DOCUMENT_ROOT.'/core/lib/salaries.lib.php';
38require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php';
39require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingjournal.class.php';
40require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
41require_once DOL_DOCUMENT_ROOT.'/compta/prelevement/class/bonprelevement.class.php';
42
43require_once DOL_DOCUMENT_ROOT.'/societe/class/companybankaccount.class.php';
44require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.class.php';
45require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.php';
46
47require_once DOL_DOCUMENT_ROOT.'/core/lib/invoice.lib.php';
48require_once DOL_DOCUMENT_ROOT.'/core/lib/fourn.lib.php';
49require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
50require_once DOL_DOCUMENT_ROOT.'/compta/prelevement/class/bonprelevement.class.php';
51require_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
52require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
53require_once DOL_DOCUMENT_ROOT.'/societe/class/companybankaccount.class.php';
54require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.class.php';
55require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.php';
56if (isModEnabled('project')) {
57 require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
58 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php';
59}
60
70// Load translation files required by the page
71$langs->loadLangs(array("compta", "bills", "users", "salaries", "hrm", "withdrawals"));
72
73$id = GETPOSTINT('id');
74$ref = GETPOST('ref', 'alpha');
75$action = GETPOST('action', 'aZ09');
76$type = 'salary';
77
78$label = GETPOST('label', 'alphanohtml');
79$projectid = (GETPOSTINT('projectid') ? GETPOSTINT('projectid') : GETPOSTINT('fk_project'));
80
81// Security check
82$socid = GETPOSTINT('socid');
83if ($user->socid) {
84 $socid = $user->socid;
85}
86
87
88$object = new Salary($db);
89$extrafields = new ExtraFields($db);
90
91$childids = $user->getAllChildIds(1);
92
93// fetch optionals attributes and labels
94$extrafields->fetch_name_optionals_label($object->table_element);
95
96// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
97$hookmanager->initHooks(array('salaryinfo', 'globalcard'));
98
99$object = new Salary($db);
100if ($id > 0) {
101 $object->fetch($id);
102
103 // Check current user can read this salary
104 $canread = 0;
105 if ($user->hasRight('salaries', 'readall')) {
106 $canread = 1;
107 }
108 if ($user->hasRight('salaries', 'read') && $object->fk_user > 0 && in_array($object->fk_user, $childids)) {
109 $canread = 1;
110 }
111 if (!$canread) {
113 }
114}
115
116$permissiontoread = $user->hasRight('salaries', 'read');
117$permissiontoadd = $user->hasRight('salaries', 'write'); // Used by the include of actions_addupdatedelete.inc.php and actions_linkedfiles
118$permissiontodelete = $user->hasRight('salaries', 'delete') || ($permissiontoadd && isset($object->status) && $object->status == $object::STATUS_UNPAID);
119
120$moreparam = '';
121$obj = new Salary($db);
122
123// Load object
124if ($id > 0) {
125 $ret = $object->fetch($id);
126 $isdraft = (($obj->status == Salary::STATUS_UNPAID) ? 1 : 0);
127 if ($ret > 0) {
128 $object->fetch_thirdparty();
129 }
130}
131
132$hookmanager->initHooks(array('directdebitcard', 'globalcard'));
133
134restrictedArea($user, 'salaries', $object->id, 'salary', '');
135
136
137/*
138 * Actions
139 */
140
141// Link to a project
142if ($action == 'classin' && $user->hasRight('banque', 'modifier')) {
143 $object->fetch($id);
144 $object->setProject($projectid);
145}
146
147// set label
148if ($action == 'setlabel' && $user->hasRight('salaries', 'write')) {
149 $object->fetch($id);
150 $object->label = $label;
151 $result = $object->update($user);
152 if ($result < 0) {
153 setEventMessages($object->error, $object->errors, 'errors');
154 }
155}
156
157$parameters = array('socid' => $socid);
158$reshook = $hookmanager->executeHooks('doActions', $parameters, $obj, $action); // Note that $action and $object may have been modified by some hooks
159if ($reshook < 0) {
160 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
161}
162
163// payment mode
164if ($action == 'setmode' && $permissiontoadd) {
165 $object->fetch($id);
166 $result = $object->setPaymentMethods(GETPOSTINT('mode_reglement_id'));
167 if ($result < 0) {
168 setEventMessages($object->error, $object->errors, 'errors');
169 }
170}
171
172// bank account
173if ($action == 'setbankaccount' && $permissiontoadd) {
174 $object->fetch($id);
175 $result = $object->setBankAccount(GETPOSTINT('fk_account'));
176 if ($result < 0) {
177 setEventMessages($object->error, $object->errors, 'errors');
178 }
179}
180
181if ($action == "add" && $permissiontoadd) {
182 //var_dump($object);exit;
183 if ($object->id > 0) {
184 $db->begin();
185
186 $sourcetype = 'salaire';
187 $newtype = 'salaire';
188
189 $paymentservice = GETPOST('paymentservice'); // value can be 'stripesepa'. not used yet.
190
191 $result = $object->demande_prelevement($user, GETPOSTFLOAT('request_transfer'), $newtype, $sourcetype);
192
193 if ($result > 0) {
194 $db->commit();
195
196 setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
197 } else {
198 $db->rollback();
199
200 setEventMessages($obj->error, $obj->errors, 'errors');
201 }
202 }
203 $action = '';
204}
205
206if ($action == "delete" && $permissiontodelete) {
207 if ($object->id > 0) {
208 $result = $object->demande_prelevement_delete($user, GETPOSTINT('did'));
209 if ($result == 0) {
210 header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id);
211 exit;
212 }
213 }
214}
215
216
217/*
218 * View
219 */
220
221$form = new Form($db);
222
223$title = $langs->trans('Salary')." - ".$langs->trans('Info');
224$help_url = "";
225llxHeader("", $title, $help_url);
226
227$object->fetch($id);
228$object->info($id);
229
230$head = salaries_prepare_head($object);
231
232print dol_get_fiche_head($head, 'request_virement', $langs->trans("SalaryPayment"), -1, 'salary');
233
234$linkback = '<a href="'.DOL_URL_ROOT.'/salaries/list.php?restore_lastsearch_values=1'.(!empty($socid) ? '&socid='.$socid : '').'">'.$langs->trans("BackToList").'</a>';
235
236$morehtmlref = '<div class="refidno">';
237
238$userstatic = new User($db);
239$userstatic->fetch($object->fk_user);
240
241
242// Label
243if ($action != 'editlabel') {
244 $morehtmlref .= $form->editfieldkey("Label", 'label', $object->label, $object, $user->hasRight('salaries', 'write'), 'string', '', 0, 1);
245 $morehtmlref .= $object->label;
246} else {
247 $morehtmlref .= $langs->trans('Label').' :&nbsp;';
248 $morehtmlref .= '<form method="post" action="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'">';
249 $morehtmlref .= '<input type="hidden" name="action" value="setlabel">';
250 $morehtmlref .= '<input type="hidden" name="token" value="'.newToken().'">';
251 $morehtmlref .= '<input type="text" name="label" value="'.dolPrintHTMLForAttribute($object->label).'"/>';
252 $morehtmlref .= '<input type="submit" class="button valignmiddle" value="'.$langs->trans("Modify").'">';
253 $morehtmlref .= '</form>';
254}
255
256$morehtmlref .= '<br>'.$langs->trans('Employee').' : '.$userstatic->getNomUrl(-1);
257
258$usercancreate = $permissiontoadd;
259
260// Project
261if (isModEnabled('project')) {
262 $langs->load("projects");
263 $morehtmlref .= '<br>';
264 if ($usercancreate) {
265 $morehtmlref .= img_picto($langs->trans("Project"), 'project', 'class="pictofixedwidth"');
266 if ($action != 'classify') {
267 $morehtmlref .= '<a class="editfielda" href="'.dolBuildUrl($_SERVER['PHP_SELF'], ['action' => 'classify', 'id' => $object->id], true).'">'.img_edit($langs->transnoentitiesnoconv('SetProject')).'</a> ';
268 }
269 $morehtmlref .= $form->form_project($_SERVER['PHP_SELF'].'?id='.$object->id, -1, (string) $object->fk_project, ($action == 'classify' ? 'projectid' : 'none'), 0, 0, 0, 1, '', 'maxwidth300');
270 } else {
271 if (!empty($object->fk_project)) {
272 $proj = new Project($db);
273 $proj->fetch($object->fk_project);
274 $morehtmlref .= $proj->getNomUrl(1);
275 if ($proj->title) {
276 $morehtmlref .= '<span class="opacitymedium"> - '.dol_escape_htmltag($proj->title).'</span>';
277 }
278 }
279 }
280}
281
282$morehtmlref .= '</div>';
283
284$totalpaid = $object->getSommePaiement();
285
286$object->totalpaid = $totalpaid;
287$object->alreadypaid = $totalpaid; // Same then $totalpaid because there is no amount of credit note or deposits for salary payments.
288
289dol_banner_tab($object, 'id', $linkback, 1, 'rowid', 'ref', $morehtmlref, '', 0, '', '');
290
291print '<div class="fichecenter">';
292print '<div class="fichehalfleft">';
293
294print '<div class="underbanner clearboth"></div>';
295
296
297print '<table class="border centpercent tableforfield">';
298
299if ($action == 'edit') {
300 print '<tr><td class="titlefieldmiddle">'.$langs->trans("DateStartPeriod")."</td><td>";
301 print $form->selectDate($object->datesp, 'datesp', 0, 0, 0, 'datesp', 1);
302 print "</td></tr>";
303} else {
304 print "<tr>";
305 print '<td class="titlefieldmiddle">' . $langs->trans("DateStartPeriod") . '</td><td>';
306 print dol_print_date($object->datesp, 'day');
307 print '</td></tr>';
308}
309
310if ($action == 'edit') {
311 print '<tr><td>'.$langs->trans("DateEndPeriod")."</td><td>";
312 print $form->selectDate($object->dateep, 'dateep', 0, 0, 0, 'dateep', 1);
313 print "</td></tr>";
314} else {
315 print "<tr>";
316 print '<td>' . $langs->trans("DateEndPeriod") . '</td><td>';
317 print dol_print_date($object->dateep, 'day');
318 print '</td></tr>';
319}
320if ($action == 'edit') {
321 print '<tr><td class="fieldrequired">' . $langs->trans("Amount") . '</td><td><input name="amount" size="10" value="' . price($object->amount) . '"></td></tr>';
322} else {
323 print '<tr><td>' . $langs->trans("Amount") . '</td><td><span class="amount">' . price($object->amount, 0, $langs, 1, -1, -1, $conf->currency) . '</span></td></tr>';
324}
325
326// Default mode of payment
327print '<tr><td>';
328print '<table class="nobordernopadding" width="100%"><tr><td>';
329print $langs->trans('DefaultPaymentMode');
330print '</td>';
331if ($action != 'editmode') {
332 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editmode&token='.newToken().'&id='.$object->id.'">'.img_edit($langs->trans('SetMode'), 1).'</a></td>';
333}
334print '</tr></table>';
335print '</td><td>';
336
337if ($action == 'editmode') {
338 $form->form_modes_reglement($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->type_payment, 'mode_reglement_id');
339} else {
340 $form->form_modes_reglement($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->type_payment, 'none');
341}
342print '</td></tr>';
343
344// Default Bank Account
345if (isModEnabled("bank")) {
346 print '<tr><td class="nowrap">';
347 print '<table width="100%" class="nobordernopadding"><tr><td class="nowrap">';
348 print $langs->trans('DefaultBankAccount');
349 print '<td>';
350 if ($action != 'editbankaccount' && $user->hasRight('salaries', 'write')) {
351 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editbankaccount&token='.newToken().'&id='.$object->id.'">'.img_edit($langs->trans('SetBankAccount'), 1).'</a></td>';
352 }
353 print '</tr></table>';
354 print '</td><td>';
355 if ($action == 'editbankaccount') {
356 $form->formSelectAccount($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->fk_account, 'fk_account', 1);
357 } else {
358 $form->formSelectAccount($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->fk_account, 'none');
359 }
360 print '</td>';
361 print '</tr>';
362}
363
364// Other attributes
365include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php';
366
367print '</table>';
368print '</div>';
369
370$user_perms = $user->hasRight('virement', 'bons', 'creer');
371$buttonlabel = $langs->trans("MakeTransferRequest");
372$user_perms = $user->hasRight('paymentbybanktransfer', 'create');
373
374print '<div class="fichehalfright">';
375/*
376 * Payments
377 */
378$sql = "SELECT p.rowid, p.num_payment as num_payment, p.datep as dp, p.amount,";
379$sql .= " c.code as type_code,c.libelle as paiement_type,";
380$sql .= ' ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.currency_code as bacurrency_code, ba.fk_accountancy_journal';
381$sql .= " FROM ".MAIN_DB_PREFIX."payment_salary as p";
382$sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank as b ON p.fk_bank = b.rowid';
383$sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as ba ON b.fk_account = ba.rowid';
384$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_paiement as c ON p.fk_typepayment = c.id";
385$sql .= ", ".MAIN_DB_PREFIX."salary as s";
386$sql .= " WHERE p.fk_salary = ".((int) $id);
387$sql .= " AND p.fk_salary = s.rowid";
388$sql .= " AND s.entity IN (".getEntity('tax').")";
389$sql .= " ORDER BY dp DESC";
390
391$resteapayer = 0;
392//print $sql;
393$resql = $db->query($sql);
394if ($resql) {
395 $totalpaid = 0;
396
397 $num = $db->num_rows($resql);
398
399 $i = 0;
400 $total = 0;
401
402 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
403 print '<table class="noborder paymenttable">';
404 print '<tr class="liste_titre">';
405 print '<td>'.$langs->trans("RefPayment").'</td>';
406 print '<td>'.$langs->trans("Date").'</td>';
407 print '<td>'.$langs->trans("Type").'</td>';
408 if (isModEnabled("bank")) {
409 print '<td class="liste_titre right">'.$langs->trans('BankAccount').'</td>';
410 }
411 print '<td class="right">'.$langs->trans("Amount").'</td>';
412 print '</tr>';
413
414 if ($num > 0) {
415 $bankaccountstatic = new Account($db);
416 while ($i < $num) {
417 $objp = $db->fetch_object($resql);
418
419 print '<tr class="oddeven"><td>';
420 print '<a href="'.DOL_URL_ROOT.'/salaries/payment_salary/card.php?id='.$objp->rowid.'">'.img_object($langs->trans("Payment"), "payment").' '.$objp->rowid.'</a></td>';
421 print '<td>'.dol_print_date($db->jdate($objp->dp), 'dayhour', 'tzuserrel')."</td>\n";
422 $labeltype = $langs->trans("PaymentType".$objp->type_code) != "PaymentType".$objp->type_code ? $langs->trans("PaymentType".$objp->type_code) : $objp->paiement_type;
423 print "<td>".$labeltype.' '.$objp->num_payment."</td>\n";
424 if (isModEnabled("bank")) {
425 $bankaccountstatic->id = $objp->baid;
426 $bankaccountstatic->ref = $objp->baref;
427 $bankaccountstatic->label = $objp->baref;
428 $bankaccountstatic->number = $objp->banumber;
429 $bankaccountstatic->currency_code = $objp->bacurrency_code;
430
431 if (isModEnabled('accounting')) {
432 $bankaccountstatic->account_number = $objp->account_number;
433
434 $accountingjournal = new AccountingJournal($db);
435 $accountingjournal->fetch($objp->fk_accountancy_journal);
436 $bankaccountstatic->accountancy_journal = $accountingjournal->getNomUrl(0, 1, 1, '', 1);
437 }
438
439 print '<td class="right">';
440 if ($bankaccountstatic->id) {
441 print $bankaccountstatic->getNomUrl(1, 'transactions');
442 }
443 print '</td>';
444 }
445 print '<td class="right nowrap amountcard">'.price($objp->amount)."</td>\n";
446 print "</tr>";
447 $totalpaid += $objp->amount;
448 $i++;
449 }
450 } else {
451 print '<tr class="oddeven"><td><span class="opacitymedium">'.$langs->trans("None").'</span></td>';
452 print '<td></td><td></td><td></td><td></td>';
453 print '</tr>';
454 }
455
456 // print '<tr><td colspan="'.$nbcols.'" class="right">'.$langs->trans("AlreadyPaid").' :</td><td class="right nowrap amountcard">'.price($totalpaid)."</td></tr>\n";
457 // print '<tr><td colspan="'.$nbcols.'" class="right">'.$langs->trans("AmountExpected").' :</td><td class="right nowrap amountcard">'.price($object->amount)."</td></tr>\n";
458
459 $resteapayer = (float) $object->amount - $totalpaid;
460 // $cssforamountpaymentcomplete = 'amountpaymentcomplete';
461
462 // print '<tr><td colspan="'.$nbcols.'" class="right">'.$langs->trans("RemainderToPay")." :</td>";
463 // print '<td class="right nowrap'.($resteapayer ? ' amountremaintopay' : (' '.$cssforamountpaymentcomplete)).'">'.price($resteapayer)."</td></tr>\n";
464
465 print "</table>";
466 print '</div>';
467
468 $db->free($resql);
469} else {
470 dol_print_error($db);
471}
472print '</div>';
473print '</div>';
474print '<div class="clearboth"></div>';
475
476
478
480print '<div class="tabsAction">'."\n";
481
482$sql = "SELECT pfd.rowid, pfd.traite, pfd.date_demande as date_demande,";
483$sql .= " pfd.date_traite as date_traite, pfd.amount, pfd.fk_prelevement_bons,";
484$sql .= " pb.ref, pb.date_trans, pb.method_trans, pb.credite, pb.date_credit, pb.datec, pb.statut as status, pb.amount as pb_amount,";
485$sql .= " u.rowid as user_id, u.email, u.lastname, u.firstname, u.login, u.statut as user_status";
486$sql .= " FROM ".MAIN_DB_PREFIX."prelevement_demande as pfd";
487$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."user as u on pfd.fk_user_demande = u.rowid";
488$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."prelevement_bons as pb ON pb.rowid = pfd.fk_prelevement_bons";
489$sql .= " WHERE pfd.fk_salary = ".((int) $object->id);
490$sql .= " AND pfd.traite = 0";
491$sql .= " AND pfd.type = 'ban'";
492$sql .= " ORDER BY pfd.date_demande DESC";
493$resql = $db->query($sql);
494
495$hadRequest = $db->num_rows($resql);
496if ($object->paye == 0 && $hadRequest == 0) {
497 if ($resteapayer > 0) {
498 if ($user_perms) {
499 print '<form method="POST" action="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'">';
500 print '<input type="hidden" name="token" value="'.newToken().'" />';
501 print '<input type="hidden" name="id" value="'.$object->id.'" />';
502 print '<input type="hidden" name="type" value="'.$type.'" />';
503 print '<input type="hidden" name="action" value="add" />';
504 print '<label for="withdraw_request_amount">'.$langs->trans('BankTransferAmount').' </label>';
505 print '<input type="text" id="withdraw_request_amount" name="request_transfer" value="'.price($resteapayer, 0, $langs, 1, -1, -1).'" size="9" />';
506 print '<input type="submit" class="butAction" value="'.$buttonlabel.'" />';
507 print '</form>';
508
509 if (getDolGlobalString('STRIPE_SEPA_DIRECT_DEBIT_SHOW_OLD_BUTTON')) { // This is hidden, prefer to use mode enabled with STRIPE_SEPA_DIRECT_DEBIT
510 // TODO Replace this with a checkbox for each payment mode: "Send request to XXX immediately..."
511 print "<br>";
512 //add stripe sepa button
513 $buttonlabel = $langs->trans("MakeWithdrawRequestStripe");
514 print '<form method="POST" action="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'">';
515 print '<input type="hidden" name="token" value="'.newToken().'" />';
516 print '<input type="hidden" name="id" value="'.$object->id.'" />';
517 print '<input type="hidden" name="type" value="'.$type.'" />';
518 print '<input type="hidden" name="action" value="add" />';
519 print '<input type="hidden" name="paymenservice" value="stripesepa" />';
520 print '<label for="withdraw_request_amount">'.$langs->trans('BankTransferAmount').' </label>';
521 print '<input type="text" id="withdraw_request_amount" name="request_transfer" value="'.price($resteapayer, 0, $langs, 1, -1, -1).'" size="9" />';
522 print '<input type="submit" class="butAction" value="'.$buttonlabel.'" />';
523 print '</form>';
524 }
525 } else {
526 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("NotEnoughPermissions")).'">'.$buttonlabel.'</a>';
527 }
528 } else {
529 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("AmountMustBePositive")).'">'.$buttonlabel.'</a>';
530 }
531} else {
532 if ($hadRequest == 0) {
533 if ($object->paye > 0) {
534 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("AlreadyPaid")).'">'.$buttonlabel.'</a>';
535 } else {
536 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("Draft")).'">'.$buttonlabel.'</a>';
537 }
538 } else {
539 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("RequestAlreadyDone")).'">'.$buttonlabel.'</a>';
540 }
541}
542
543print '</div>';
544
545print '<div>';
546
547
548$bprev = new BonPrelevement($db);
549
550
551print '<div class="div-table-responsive-no-min">';
552print '<table class="noborder centpercent">';
553
554print '<tr class="liste_titre">';
555// Action column
556if ($conf->main_checkbox_left_column) {
557 print '<td>&nbsp;</td>';
558}
559print '<td class="left">'.$langs->trans("DateRequest").'</td>';
560print '<td>'.$langs->trans("User").'</td>';
561print '<td class="center">'.$langs->trans("Amount").'</td>';
562print '<td class="center">'.$langs->trans("DateProcess").'</td>';
563print '<td class="center">'.$langs->trans("BankTransferReceipt").'</td>';
564print '<td>&nbsp;</td>';
565// Action column
566if (!$conf->main_checkbox_left_column) {
567 print '<td>&nbsp;</td>';
568}
569print '</tr>';
570
571$num = 0;
572if ($resql) {
573 $i = 0;
574
575 $tmpuser = new User($db);
576
577 $num = $db->num_rows($resql);
578 if ($num > 0) {
579 while ($i < $num) {
580 $obj = $db->fetch_object($resql);
581
582 $tmpuser->id = $obj->user_id;
583 $tmpuser->login = $obj->login;
584 $tmpuser->ref = $obj->login;
585 $tmpuser->email = $obj->email;
586 $tmpuser->lastname = $obj->lastname;
587 $tmpuser->firstname = $obj->firstname;
588 $tmpuser->status = $obj->user_status;
589
590 print '<tr class="oddeven">';
591
592 // Action column
593 if ($conf->main_checkbox_left_column) {
594 print '<td class="right">';
595 print '<a href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=delete&token='.newToken().'&did='.$obj->rowid.'&type='.urlencode($type).'">';
596 print img_delete();
597 print '</a></td>';
598 }
599
600 // Date
601 print '<td class="nowraponall">'.dol_print_date($db->jdate($obj->date_demande), 'dayhour')."</td>\n";
602
603 // User
604 print '<td class="tdoverflowmax125">';
605 print $tmpuser->getNomUrl(-1, '', 0, 0, 0, 0, 'login');
606 print '</td>';
607
608 // Amount
609 print '<td class="center"><span class="amount">'.price($obj->amount).'</span></td>';
610
611 // Date process
612 print '<td class="center"><span class="opacitymedium">'.$langs->trans("OrderWaiting").'</span></td>';
613
614 // Link to make payment now
615 print '<td class="minwidth75">';
616 if ($obj->fk_prelevement_bons > 0) {
617 $withdrawreceipt = new BonPrelevement($db);
618 $withdrawreceipt->id = $obj->fk_prelevement_bons;
619 $withdrawreceipt->ref = $obj->ref;
620 $withdrawreceipt->date_trans = $db->jdate($obj->date_trans);
621 $withdrawreceipt->date_credit = $db->jdate($obj->date_credit);
622 $withdrawreceipt->date_creation = $db->jdate($obj->datec);
623 $withdrawreceipt->statut = $obj->status;
624 $withdrawreceipt->status = $obj->status;
625 $withdrawreceipt->amount = $obj->pb_amount;
626 //$withdrawreceipt->credite = $db->jdate($obj->credite);
627
628 print $withdrawreceipt->getNomUrl(1);
629 }
630
631 if (getDolGlobalString('STRIPE_SEPA_CREDIT_TRANSFER')) {
632 $langs->load("stripe");
633 if ($obj->fk_prelevement_bons > 0) {
634 print ' &nbsp; ';
635 }
636 print '<a href="'.$_SERVER["PHP_SELF"].'?action=sepastripecredittransfer&paymentservice=stripesepa&token='.newToken().'&did='.$obj->rowid.'&id='.$object->id.'&type='.urlencode($type).'">'.img_picto('', 'stripe', 'class="pictofixedwidth"').$langs->trans("RequesCreditTransferWithStripe").'</a>';
637 }
638 print '</td>';
639
640 //
641 print '<td class="center">-</td>';
642
643 // Action column
644 if (!$conf->main_checkbox_left_column) {
645 print '<td class="right">';
646 print '<a href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=delete&token='.newToken().'&did='.$obj->rowid.'&type='.urlencode($type).'">';
647 print img_delete();
648 print '</a></td>';
649 }
650
651 print "</tr>\n";
652 $i++;
653 }
654 }
655
656 $db->free($resql);
657} else {
658 dol_print_error($db);
659}
660
661// Past requests when bon prelevement
662
663$sql = "SELECT pfd.rowid, pfd.traite, pfd.date_demande as date_demande,";
664$sql .= " pfd.date_traite as date_traite, pfd.amount, pfd.fk_prelevement_bons,";
665$sql .= " pb.ref, pb.date_trans, pb.method_trans, pb.credite, pb.date_credit, pb.datec, pb.statut as status, pb.fk_bank_account, pb.amount as pb_amount,";
666$sql .= " u.rowid as user_id, u.email, u.lastname, u.firstname, u.login, u.statut as user_status";
667$sql .= " FROM ".MAIN_DB_PREFIX."prelevement_demande as pfd";
668$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."user as u on pfd.fk_user_demande = u.rowid";
669$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."prelevement_bons as pb ON pb.rowid = pfd.fk_prelevement_bons";
670$sql .= " WHERE pfd.fk_salary = ".((int) $object->id);
671$sql .= " AND pfd.traite = 1";
672$sql .= " AND pfd.type = 'ban'";
673$sql .= " ORDER BY pfd.date_demande DESC";
674
675$numOfBp = 0;
676$resql = $db->query($sql);
677if ($resql) {
678 $numOfBp = $db->num_rows($resql);
679 $i = 0;
680 $tmpuser = new User($db);
681 if ($numOfBp > 0) {
682 while ($i < $numOfBp) {
683 $obj = $db->fetch_object($resql);
684
685 $tmpuser->id = $obj->user_id;
686 $tmpuser->login = $obj->login;
687 $tmpuser->ref = $obj->login;
688 $tmpuser->email = $obj->email;
689 $tmpuser->lastname = $obj->lastname;
690 $tmpuser->firstname = $obj->firstname;
691 $tmpuser->status = $obj->user_status;
692
693 print '<tr class="oddeven">';
694
695 // Action column
696 if ($conf->main_checkbox_left_column) {
697 print '<td>&nbsp;</td>';
698 }
699
700 // Date
701 print '<td class="nowraponall">'.dol_print_date($db->jdate($obj->date_demande), 'dayhour')."</td>\n";
702
703 // User
704 print '<td class="tdoverflowmax125">';
705 print $tmpuser->getNomUrl(-1, '', 0, 0, 0, 0, 'login');
706 print '</td>';
707
708 // Amount
709 print '<td class="center"><span class="amount">'.price($obj->amount).'</span></td>';
710
711 // Date process
712 print '<td class="center nowraponall">'.dol_print_date($db->jdate($obj->date_traite), 'dayhour', 'tzuserrel')."</td>\n";
713
714 // Link to payment request done
715 print '<td class="center minwidth75">';
716 if ($obj->fk_prelevement_bons > 0) {
717 $withdrawreceipt = new BonPrelevement($db);
718 $withdrawreceipt->id = $obj->fk_prelevement_bons;
719 $withdrawreceipt->ref = $obj->ref;
720 $withdrawreceipt->date_trans = $db->jdate($obj->date_trans);
721 $withdrawreceipt->date_credit = $db->jdate($obj->date_credit);
722 $withdrawreceipt->date_creation = $db->jdate($obj->datec);
723 $withdrawreceipt->status = $obj->status;
724 $withdrawreceipt->fk_bank_account = $obj->fk_bank_account;
725 $withdrawreceipt->amount = $obj->pb_amount;
726 //$withdrawreceipt->credite = $db->jdate($obj->credite);
727
728 print $withdrawreceipt->getNomUrl(1);
729 print ' ';
730 print $withdrawreceipt->getLibStatut(2);
731
732 // Show the bank account
733 $fk_bank_account = $withdrawreceipt->fk_bank_account;
734 if (empty($fk_bank_account)) {
735 $fk_bank_account = getDolGlobalInt('PAYMENTBYBANKTRANSFER_ID_BANKACCOUNT'); // A salary is only paid by credit transfer
736 }
737 if ($fk_bank_account > 0) {
738 $bankaccount = new Account($db);
739 $result = $bankaccount->fetch($fk_bank_account);
740 if ($result > 0) {
741 print ' - ';
742 print $bankaccount->getNomUrl(1);
743 }
744 }
745 }
746 print "</td>\n";
747
748 //
749 print '<td>&nbsp;</td>';
750
751 // Action column
752 if (!$conf->main_checkbox_left_column) {
753 print '<td>&nbsp;</td>';
754 }
755
756 print "</tr>\n";
757 $i++;
758 }
759 }
760 $db->free($resql);
761} else {
762 dol_print_error($db);
763}
764
765if ($num == 0 && $numOfBp == 0) {
766 print '<tr class="oddeven"><td colspan="7"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
767}
768
769print "</table>";
770print '</div>';
771
772// End of page
773llxFooter();
774$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:47
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 accounting journals.
Class to manage withdrawal receipts.
Class to manage standard extra fields.
Class to manage generation of HTML components Only common components must be here.
Class to manage projects.
Class to manage salary payments.
Class to manage Dolibarr users.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTFLOAT($paramname, $rounding='', $option=2)
Return the value of a $_GET or $_POST supervariable, converted into float.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
Definition html.lib.php:542
dol_get_fiche_end($notab=0)
Return tab footer of a card.
Definition html.lib.php:740
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.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.
print
button