dolibarr 22.0.5
prelevement.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2002-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004 Eric Seigne <eric.seigne@ryxeo.com>
4 * Copyright (C) 2004-2016 Laurent Destailleur <eldy@users.sourceforge.net>
5 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
6 * Copyright (C) 2010-2014 Juanjo Menent <jmenent@2byte.es>
7 * Copyright (C) 2017 Ferran Marcet <fmarcet@2byte.es>
8 * Copyright (C) 2018-2024 Frédéric France <frederic.france@free.fr>
9 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
10 *
11 * This program is free software; you can redistribute it and/or modify
12 * it under the terms of the GNU General Public License as published by
13 * the Free Software Foundation; either version 3 of the License, or
14 * (at your option) any later version.
15 *
16 * This program is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
20 *
21 * You should have received a copy of the GNU General Public License
22 * along with this program. If not, see <https://www.gnu.org/licenses/>.
23 */
24
31// Load Dolibarr environment
32require '../../main.inc.php';
33require_once DOL_DOCUMENT_ROOT.'/core/lib/invoice.lib.php';
34require_once DOL_DOCUMENT_ROOT.'/core/lib/fourn.lib.php';
35require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
36require_once DOL_DOCUMENT_ROOT.'/compta/prelevement/class/bonprelevement.class.php';
37require_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
38require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
39require_once DOL_DOCUMENT_ROOT.'/societe/class/companybankaccount.class.php';
40require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.class.php';
41require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.facture.class.php';
42require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture-rec.class.php';
43require_once DOL_DOCUMENT_ROOT.'/societe/class/companybankaccount.class.php';
44
45
55// Load translation files required by the page
56$langs->loadLangs(array('bills', 'banks', 'withdrawals', 'companies'));
57
58$id = (GETPOSTINT('id') ? GETPOSTINT('id') : GETPOSTINT('facid')); // For backward compatibility
59$ref = GETPOST('ref', 'alpha');
60$socid = GETPOSTINT('socid');
61$action = GETPOST('action', 'aZ09');
62$type = GETPOST('type', 'aZ09');
63
64$fieldid = (!empty($ref) ? 'ref' : 'rowid');
65if ($user->socid) {
66 $socid = $user->socid;
67}
68
69$moreparam = '';
70if ($type == 'bank-transfer') {
71 $object = new FactureFournisseur($db);
72 $moreparam = '&type='.$type;
73} else {
74 $object = new Facture($db);
75}
76
77// Load object
78$isdraft = 1;
79if ($id > 0 || !empty($ref)) {
80 $ret = $object->fetch($id, $ref);
81 $isdraft = (($object->status == FactureFournisseur::STATUS_DRAFT) ? 1 : 0);
82 if ($ret > 0) {
83 $id = $object->id; // The page may be called with the ref only: the security check must be done on the object found
84 $fieldid = 'rowid'; // $id is now the id of the invoice, not its ref
85 $object->fetch_thirdparty();
86 }
87}
88
89$hookmanager->initHooks(array('directdebitcard', 'globalcard'));
90
91if ($type == 'bank-transfer') {
92 $result = restrictedArea($user, 'fournisseur', $id, 'facture_fourn', 'facture', 'fk_soc', $fieldid, $isdraft);
93 if (!$user->hasRight('fournisseur', 'facture', 'lire')) {
95 }
96} else {
97 $result = restrictedArea($user, 'facture', $id, '', '', 'fk_soc', $fieldid, $isdraft);
98 if (!$user->hasRight('facture', 'lire')) {
100 }
101}
102
103if ($type == 'bank-transfer') {
104 $usercancreate = ($user->rights->fournisseur->facture->creer || $user->rights->supplier_invoice->creer);
105} else {
106 $usercancreate = $user->hasRight('facture', 'creer');
107}
108
109
110/*
111 * Actions
112 */
113
114$parameters = array('socid' => $socid);
115$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
116if ($reshook < 0) {
117 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
118}
119
120if (empty($reshook)) {
121 if ($action == "new" && $usercancreate) {
122 if ($object->id > 0) {
123 $db->begin();
124
125 $newtype = $type;
126 $sourcetype = 'facture';
127 if ($type == 'bank-transfer') {
128 $sourcetype = 'supplier_invoice';
129 $newtype = 'bank-transfer';
130 }
131 $paymentservice = GETPOST('paymentservice');
132
133 // Get chosen iban id
134 $iban = GETPOSTINT('accountcustomerid');
135 $amount = GETPOST('withdraw_request_amount', 'alpha');
136 $result = $object->demande_prelevement($user, (float) price2num($amount), $newtype, $sourcetype, 0, $iban ?? 0);
137
138 if ($result > 0) {
139 $db->commit();
140
141 setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
142 } else {
143 $db->rollback();
144 setEventMessages($object->error, $object->errors, 'errors');
145 }
146 }
147 $action = '';
148 }
149
150 if ($action == "delete" && $usercancreate) {
151 if ($object->id > 0) {
152 $result = $object->demande_prelevement_delete($user, GETPOSTINT('did'));
153 if ($result == 0) {
154 header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id.'&type='.$type);
155 exit;
156 }
157 }
158 }
159
160 // Make payment with Direct Debit Stripe
161 if ($action == 'sepastripedirectdebit' && $usercancreate) {
162 $result = $object->makeStripeSepaRequest($user, GETPOSTINT('did'), 'direct-debit', 'facture');
163 if ($result < 0) {
164 setEventMessages($object->error, $object->errors, 'errors');
165 } else {
166 // We refresh object data
167 $ret = $object->fetch($id, $ref);
168 $isdraft = (($object->status == Facture::STATUS_DRAFT) ? 1 : 0);
169 if ($ret > 0) {
170 $object->fetch_thirdparty();
171 }
172 }
173 }
174
175 // Make payment with Direct Debit Stripe
176 if ($action == 'sepastripecredittransfer' && $usercancreate) {
177 $result = $object->makeStripeSepaRequest($user, GETPOSTINT('did'), 'bank-transfer', 'supplier_invoice');
178 if ($result < 0) {
179 setEventMessages($object->error, $object->errors, 'errors');
180 } else {
181 // We refresh object data
182 $ret = $object->fetch($id, $ref);
183 $isdraft = (($object->status == FactureFournisseur::STATUS_DRAFT) ? 1 : 0);
184 if ($ret > 0) {
185 $object->fetch_thirdparty();
186 }
187 }
188 }
189
190 // Set payments conditions
191 if ($action == 'setconditions' && $usercancreate) {
192 $object->fetch($id);
193 $object->cond_reglement_code = 0; // To clean property
194 $object->cond_reglement_id = 0; // To clean property
195
196 $error = 0;
197
198 $db->begin();
199
200 if (!$error) {
201 $result = $object->setPaymentTerms(GETPOSTINT('cond_reglement_id'));
202 if ($result < 0) {
203 $error++;
204 setEventMessages($object->error, $object->errors, 'errors');
205 }
206 }
207
208 if (!$error) {
209 $old_date_echeance = $object->date_echeance;
210 $new_date_echeance = $object->calculate_date_lim_reglement();
211 if ($new_date_echeance > $old_date_echeance) {
212 $object->date_echeance = $new_date_echeance;
213 }
214 if ($object->date_echeance < $object->date) {
215 $object->date_echeance = $object->date;
216 }
217 $result = $object->update($user);
218 if ($result < 0) {
219 $error++;
220 setEventMessages($object->error, $object->errors, 'errors');
221 }
222 }
223
224 if ($error) {
225 $db->rollback();
226 } else {
227 $db->commit();
228 }
229 } elseif ($action == 'setmode' && $usercancreate) {
230 // payment mode
231 $result = $object->setPaymentMethods(GETPOSTINT('mode_reglement_id'));
232 } elseif ($action == 'setdatef' && $usercancreate) {
233 $newdate = dol_mktime(0, 0, 0, GETPOSTINT('datefmonth'), GETPOSTINT('datefday'), GETPOSTINT('datefyear'), 'tzserver');
234 if ($newdate > (dol_now('tzuserrel') + getDolGlobalInt('INVOICE_MAX_FUTURE_DELAY'))) {
235 if (!getDolGlobalString('INVOICE_MAX_FUTURE_DELAY')) {
236 setEventMessages($langs->trans("WarningInvoiceDateInFuture"), null, 'warnings');
237 } else {
238 setEventMessages($langs->trans("WarningInvoiceDateTooFarInFuture"), null, 'warnings');
239 }
240 }
241
242 $object->date = $newdate;
243 $date_echence_calc = $object->calculate_date_lim_reglement();
244 if (!empty($object->date_echeance) && $object->date_echeance < $date_echence_calc) {
245 $object->date_echeance = $date_echence_calc;
246 }
247 if ($object->date_echeance && $object->date_echeance < $object->date) {
248 $object->date_echeance = $object->date;
249 }
250
251 $result = $object->update($user);
252 if ($result < 0) {
253 dol_print_error($db, $object->error);
254 }
255 } elseif ($action == 'setdate_lim_reglement' && $usercancreate) {
256 $object->date_echeance = dol_mktime(12, 0, 0, GETPOSTINT('date_lim_reglementmonth'), GETPOSTINT('date_lim_reglementday'), GETPOSTINT('date_lim_reglementyear'));
257 if (!empty($object->date_echeance) && $object->date_echeance < $object->date) {
258 $object->date_echeance = $object->date;
259 setEventMessages($langs->trans("DatePaymentTermCantBeLowerThanObjectDate"), null, 'warnings');
260 }
261 $result = $object->update($user);
262 if ($result < 0) {
263 dol_print_error($db, $object->error);
264 }
265 }
266}
267
268
269/*
270 * View
271 */
272
273$form = new Form($db);
274
275$now = dol_now();
276
277if ($type == 'bank-transfer') {
278 $title = $langs->trans('SupplierInvoice')." - ".$langs->trans('CreditTransfer');
279 $helpurl = "";
280} else {
281 $title = $langs->trans('InvoiceCustomer')." - ".$langs->trans('StandingOrders');
282 $helpurl = "EN:Customers_Invoices|FR:Factures_Clients|ES:Facturas_a_clientes";
283}
284
285llxHeader('', $title, $helpurl);
286
287
288if ($object->id > 0) {
289 $selleruserevenustamp = $mysoc->useRevenueStamp();
290
291 $totalpaid = $object->getSommePaiement();
292 $totalcreditnotes = $object->getSumCreditNotesUsed();
293 $totaldeposits = $object->getSumDepositsUsed();
294 //print "totalpaid=".$totalpaid." totalcreditnotes=".$totalcreditnotes." totaldeposts=".$totaldeposits;
295
296 // We can also use bcadd to avoid pb with floating points
297 // For example print 239.2 - 229.3 - 9.9; does not return 0.
298 //$resteapayer=bcadd($object->total_ttc,$totalpaid,$conf->global->MAIN_MAX_DECIMALS_TOT);
299 //$resteapayer=bcadd($resteapayer,$totalavoir,$conf->global->MAIN_MAX_DECIMALS_TOT);
300 $resteapayer = price2num($object->total_ttc - $totalpaid - $totalcreditnotes - $totaldeposits, 'MT');
301
302 if ($object->paid) {
303 $resteapayer = 0;
304 }
305
306 if ($type == 'bank-transfer') {
307 if (getDolGlobalString('FACTURE_SUPPLIER_DEPOSITS_ARE_JUST_PAYMENTS')) { // Not recommended
308 $filterabsolutediscount = "fk_invoice_supplier_source IS NULL"; // If we want deposit to be subtracted to payments only and not to total of final invoice
309 $filtercreditnote = "fk_invoice_supplier_source IS NOT NULL"; // If we want deposit to be subtracted to payments only and not to total of final invoice
310 } else {
311 $filterabsolutediscount = "fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')";
312 $filtercreditnote = "fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%')";
313 }
314
315 $absolute_discount = $object->thirdparty->getAvailableDiscounts(null, $filterabsolutediscount, 0, 1);
316 $absolute_creditnote = $object->thirdparty->getAvailableDiscounts(null, $filtercreditnote, 0, 1);
317 $absolute_discount = price2num($absolute_discount, 'MT');
318 $absolute_creditnote = price2num($absolute_creditnote, 'MT');
319 } else {
320 if (getDolGlobalString('FACTURE_DEPOSITS_ARE_JUST_PAYMENTS')) { // Not recommended
321 $filterabsolutediscount = "fk_facture_source IS NULL"; // If we want deposit to be subtracted to payments only and not to total of final invoice
322 $filtercreditnote = "fk_facture_source IS NOT NULL"; // If we want deposit to be subtracted to payments only and not to total of final invoice
323 } else {
324 $filterabsolutediscount = "fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')";
325 $filtercreditnote = "fk_facture_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS RECEIVED)%')";
326 }
327
328 $absolute_discount = $object->thirdparty->getAvailableDiscounts(null, $filterabsolutediscount);
329 $absolute_creditnote = $object->thirdparty->getAvailableDiscounts(null, $filtercreditnote);
330 $absolute_discount = price2num($absolute_discount, 'MT');
331 $absolute_creditnote = price2num($absolute_creditnote, 'MT');
332 }
333
334 $author = new User($db);
335 if (!empty($object->user_creation_id)) {
336 $author->fetch($object->user_creation_id);
337 } elseif (!empty($object->fk_user_author)) { // For backward compatibility
338 $author->fetch($object->fk_user_author);
339 }
340
341 if ($type == 'bank-transfer') {
343 } else {
345 }
346
347 $numopen = 0;
348 $pending = 0;
349 $numclosed = 0;
350
351 // How many Direct debit or Credit transfer open requests ?
352 $listofopendirectdebitorcredittransfer = $object->getListOfOpenDirectDebitOrCreditTransfer($type);
353 $numopen = count($listofopendirectdebitorcredittransfer);
354
355 print dol_get_fiche_head($head, 'standingorders', $title, -1, ($type == 'bank-transfer' ? 'supplier_invoice' : 'bill'));
356
357 // Invoice content
358 if ($type == 'bank-transfer') {
359 $linkback = '<a href="'.DOL_URL_ROOT.'/fourn/facture/list.php?restore_lastsearch_values=1'.(!empty($socid) ? '&socid='.$socid : '').'">'.$langs->trans("BackToList").'</a>';
360 } else {
361 $linkback = '<a href="'.DOL_URL_ROOT.'/compta/facture/list.php?restore_lastsearch_values=1'.(!empty($socid) ? '&socid='.$socid : '').'">'.$langs->trans("BackToList").'</a>';
362 }
363
364 $morehtmlref = '<div class="refidno">';
365 // Ref customer
366 if ($type == 'bank-transfer') {
367 $morehtmlref .= $form->editfieldkey("RefSupplierBill", 'ref_supplier', $object->ref_supplier, $object, 0, 'string', '', 0, 1);
368 $morehtmlref .= $form->editfieldval("RefSupplierBill", 'ref_supplier', $object->ref_supplier, $object, 0, 'string', '', null, null, '', 1);
369 } else {
370 $morehtmlref .= $form->editfieldkey("RefCustomer", 'ref_client', $object->ref_customer, $object, 0, 'string', '', 0, 1);
371 $morehtmlref .= $form->editfieldval("RefCustomer", 'ref_client', $object->ref_customer, $object, 0, 'string', '', null, null, '', 1);
372 }
373 // Thirdparty
374 $morehtmlref .= '<br>'.$object->thirdparty->getNomUrl(1);
375 if ($type == 'bank-transfer') {
376 if (!getDolGlobalString('MAIN_DISABLE_OTHER_LINK') && $object->thirdparty->id > 0) {
377 $morehtmlref .= ' <div class="inline-block valignmiddle">(<a class="valignmiddle" href="'.DOL_URL_ROOT.'/fourn/facture/list.php?socid='.((int) $object->thirdparty->id).'">'.$langs->trans("OtherBills").'</a>)</div>';
378 }
379 } else {
380 if (!getDolGlobalString('MAIN_DISABLE_OTHER_LINK') && $object->thirdparty->id > 0) {
381 $morehtmlref .= ' <div class="inline-block valignmiddle">(<a class="valignmiddle" href="'.DOL_URL_ROOT.'/compta/facture/list.php?socid='.((int) $object->thirdparty->id).'">'.$langs->trans("OtherBills").'</a>)</div>';
382 }
383 }
384 // Project
385 if (isModEnabled('project')) {
386 $langs->load("projects");
387 $morehtmlref .= '<br>';
388 if (0) {
389 $morehtmlref .= img_picto($langs->trans("Project"), 'project', 'class="pictofixedwidth"');
390 if ($action != 'classify') {
391 $morehtmlref .= '<a class="editfielda" href="'.$_SERVER['PHP_SELF'].'?action=classify&token='.newToken().'&id='.((int) $object->id).'">'.img_edit($langs->transnoentitiesnoconv('SetProject')).'</a> ';
392 }
393 $morehtmlref .= $form->form_project($_SERVER['PHP_SELF'].'?id='.$object->id, $object->socid, (string) $object->fk_project, ($action == 'classify' ? 'projectid' : 'none'), 0, 0, 0, 1, '', 'maxwidth300');
394 } else {
395 if (!empty($object->fk_project)) {
396 $proj = new Project($db);
397 $proj->fetch($object->fk_project);
398 $morehtmlref .= $proj->getNomUrl(1);
399 if ($proj->title) {
400 $morehtmlref .= '<span class="opacitymedium"> - '.dol_escape_htmltag($proj->title).'</span>';
401 }
402 }
403 }
404 }
405 $morehtmlref .= '</div>';
406
407 $object->totalpaid = $totalpaid; // To give a chance to dol_banner_tab to use already paid amount to show correct status
408
409 dol_banner_tab($object, 'ref', $linkback, 1, 'ref', 'ref', $morehtmlref, $moreparam, 0, '', '');
410
411 print '<div class="fichecenter">';
412 print '<div class="fichehalfleft">';
413 print '<div class="underbanner clearboth"></div>';
414
415 print '<table class="border centpercent tableforfield">';
416
417 // Type
418 print '<tr><td class="titlefield fieldname_type">'.$langs->trans('Type').'</td><td colspan="3">';
419 print '<span class="badgeneutral">';
420 print $object->getLibType();
421 print '</span>';
422 if (!empty($object->module_source)) {
423 print ' <span class="opacitymediumbycolor paddingleft">('.$langs->trans("POS").' '.$object->module_source.' - '.$langs->trans("Terminal").' '.$object->pos_source.')</span>';
424 }
425 if ($object->type == $object::TYPE_REPLACEMENT) {
426 if ($type == 'bank-transfer') {
427 $facreplaced = new FactureFournisseur($db);
428 } else {
429 $facreplaced = new Facture($db);
430 }
431 $facreplaced->fetch($object->fk_facture_source);
432 print ' <span class="opacitymediumbycolor paddingleft">'.$langs->transnoentities("ReplaceInvoice", $facreplaced->getNomUrl(1)).'</span>';
433 }
434 if ($object->type == $object::TYPE_CREDIT_NOTE && !empty($object->fk_facture_source)) {
435 if ($type == 'bank-transfer') {
436 $facusing = new FactureFournisseur($db);
437 } else {
438 $facusing = new Facture($db);
439 }
440 $facusing->fetch($object->fk_facture_source);
441 print ' <span class="opacitymediumbycolor paddingleft">'.$langs->transnoentities("CorrectInvoice", $facusing->getNomUrl(1)).'</span>';
442 }
443
444 // Retrieve credit note ids
445 $object->getListIdAvoirFromInvoice();
446
447 if (!empty($object->creditnote_ids)) {
448 $invoicecredits = array();
449 foreach ($object->creditnote_ids as $invoiceid) {
450 if ($type == 'bank-transfer') {
451 $creditnote = new FactureFournisseur($db);
452 } else {
453 $creditnote = new Facture($db);
454 }
455 $creditnote->fetch($invoiceid);
456 $invoicecredits[] = $creditnote->getNomUrl(1);
457 }
458 print ' <span class="opacitymediumbycolor paddingleft">'.$langs->transnoentities("InvoiceHasAvoir");
459 print ' '. (count($invoicecredits) ? ' ' : '') . implode(',', $invoicecredits);
460 print '</span>';
461 }
462 /*
463 if ($objectidnext > 0) {
464 $facthatreplace=new Facture($db);
465 $facthatreplace->fetch($objectidnext);
466 print ' <span class="opacitymediumbycolor paddingleft">'.str_replace('{s1}', $facthatreplace->getNomUrl(1), $langs->transnoentities("ReplacedByInvoice", '{s1}')).'</span>';
467 }
468 */
469 print '</td></tr>';
470
471 // Relative and absolute discounts
472 print '<!-- Discounts -->'."\n";
473 print '<tr><td>'.$langs->trans('DiscountStillRemaining').'</td><td colspan="3">';
474
475 if ($type == 'bank-transfer') {
476 //$societe = new Fournisseur($db);
477 //$result = $societe->fetch($object->socid);
478 $thirdparty = $object->thirdparty;
479 $discount_type = 1;
480 } else {
481 $thirdparty = $object->thirdparty;
482 $discount_type = 0;
483 }
484 $backtopage = urlencode($_SERVER["PHP_SELF"].'?facid='.$object->id);
485 $cannotApplyDiscount = 1;
486 include DOL_DOCUMENT_ROOT.'/core/tpl/object_discounts.tpl.php';
487
488 print '</td></tr>';
489
490 // Label
491 if ($type == 'bank-transfer') {
492 print '<tr>';
493 print '<td>'.$form->editfieldkey("Label", 'label', $object->label, $object, 0).'</td>';
494 print '<td>'.$form->editfieldval("Label", 'label', $object->label, $object, 0).'</td>';
495 print '</tr>';
496 }
497
498 // Date invoice
499 print '<tr><td>';
500 print '<table class="nobordernopadding centpercent"><tr><td>';
501 print $langs->trans('DateInvoice');
502 print '</td>';
503 if ($object->type != $object::TYPE_CREDIT_NOTE && $action != 'editinvoicedate' && $object->status == $object::STATUS_DRAFT && $user->hasRight('facture', 'creer')) {
504 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editinvoicedate&token='.newToken().'&id='.$object->id.'&type='.urlencode($type).'">'.img_edit($langs->trans('SetDate'), 1).'</a></td>';
505 }
506 print '</tr></table>';
507 print '</td><td colspan="3">';
508
509 if ($object->type != $object::TYPE_CREDIT_NOTE) {
510 if ($action == 'editinvoicedate') {
511 print $form->form_date($_SERVER['PHP_SELF'].'?id='.$object->id, $object->date, 'invoicedate', 0, 0, 1, $type);
512 } else {
513 print dol_print_date($object->date, 'day');
514 }
515 } else {
516 print dol_print_date($object->date, 'day');
517 }
518 print '</td>';
519 print '</tr>';
520
521 // Payment condition
522 print '<tr><td>';
523 print '<table class="nobordernopadding centpercent"><tr><td>';
524 print $langs->trans('PaymentConditionsShort');
525 print '</td>';
526 if ($object->type != $object::TYPE_CREDIT_NOTE && $action != 'editconditions' && $object->status == $object::STATUS_DRAFT && $user->hasRight('facture', 'creer')) {
527 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editconditions&token='.newToken().'&id='.$object->id.'&type='.urlencode($type).'">'.img_edit($langs->trans('SetConditions'), 1).'</a></td>';
528 }
529 print '</tr></table>';
530 print '</td><td colspan="3">';
531 if ($object->type != $object::TYPE_CREDIT_NOTE) {
532 if ($action == 'editconditions') {
533 $form->form_conditions_reglement($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->cond_reglement_id, 'cond_reglement_id', 0, $type);
534 } else {
535 $form->form_conditions_reglement($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->cond_reglement_id, 'none');
536 }
537 } else {
538 print '&nbsp;';
539 }
540 print '</td></tr>';
541
542 // Date payment term
543 print '<tr><td>';
544 print '<table class="nobordernopadding centpercent"><tr><td>';
545 print $langs->trans('DateMaxPayment');
546 print '</td>';
547 if ($object->type != $object::TYPE_CREDIT_NOTE && $action != 'editpaymentterm' && $object->status == $object::STATUS_DRAFT && $user->hasRight('facture', 'creer')) {
548 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editpaymentterm&token='.newToken().'&id='.$object->id.'&type='.urlencode($type).'">'.img_edit($langs->trans('SetDate'), 1).'</a></td>';
549 }
550 print '</tr></table>';
551 print '</td><td colspan="3">';
552 if ($object->type != $object::TYPE_CREDIT_NOTE) {
553 $duedate = $object->date_lim_reglement;
554 if ($type == 'bank-transfer') {
555 $duedate = $object->date_echeance;
556 }
557
558 if ($action == 'editpaymentterm') {
559 print $form->form_date($_SERVER['PHP_SELF'].'?id='.$object->id, $duedate, 'paymentterm', 0, 0, 1, $type);
560 } else {
561 print dol_print_date($duedate, 'day');
562 if ($object->hasDelay()) {
563 print img_warning($langs->trans('Late'));
564 }
565 }
566 } else {
567 print '&nbsp;';
568 }
569 print '</td></tr>';
570
571 // Payment mode
572 print '<tr><td>';
573 print '<table class="nobordernopadding centpercent"><tr><td>';
574 print $langs->trans('PaymentMode');
575 print '</td>';
576 if ($action != 'editmode' && $object->status == $object::STATUS_DRAFT && $user->hasRight('facture', 'creer')) {
577 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editmode&token='.newToken().'&id='.$object->id.'&type='.urlencode($type).'">'.img_edit($langs->trans('SetMode'), 1).'</a></td>';
578 }
579 print '</tr></table>';
580 print '</td><td colspan="3">';
581 $filtertype = 'CRDT';
582 if ($type == 'bank-transfer') {
583 $filtertype = 'DBIT';
584 }
585 if ($action == 'editmode') {
586 $form->form_modes_reglement($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->mode_reglement_id, 'mode_reglement_id', $filtertype, 1, 0, $type);
587 } else {
588 $form->form_modes_reglement($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->mode_reglement_id, 'none');
589 }
590 print '</td></tr>';
591
592 // Bank Account
593 print '<tr><td class="nowrap">';
594 print '<table width="100%" class="nobordernopadding"><tr><td class="nowrap">';
595 print $langs->trans('BankAccount');
596 print '<td>';
597 if (($action != 'editbankaccount') && $user->hasRight('commande', 'creer') && $object->status == $object::STATUS_DRAFT) {
598 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editbankaccount&token='.newToken().'&id='.$object->id.'&type='.urlencode($type).'">'.img_edit($langs->trans('SetBankAccount'), 1).'</a></td>';
599 }
600 print '</tr></table>';
601 print '</td><td colspan="3">';
602 if ($action == 'editbankaccount') {
603 $form->formSelectAccount($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->fk_account, 'fk_account', 1);
604 } else {
605 $form->formSelectAccount($_SERVER['PHP_SELF'].'?id='.$object->id, (string) $object->fk_account, 'none');
606 }
607 print '</td>';
608 print '</tr>';
609 print '</table>';
610 print '</div>';
611
612 print '<div class="fichehalfright">';
613 print '<!-- amounts -->'."\n";
614 print '<div class="underbanner clearboth"></div>'."\n";
615
616 print '<table class="border tableforfield centpercent">';
617
618 include DOL_DOCUMENT_ROOT.'/core/tpl/object_currency_amount.tpl.php';
619
620 $sign = 1;
621 if (getDolGlobalString('INVOICE_POSITIVE_CREDIT_NOTE_SCREEN') && $object->type == $object::TYPE_CREDIT_NOTE) {
622 $sign = -1; // We invert sign for output
623 }
624 print '<tr>';
625 // Amount HT
626 print '<td class="titlefieldmiddle">' . $langs->trans('AmountHT') . '</td>';
627 print '<td class="nowrap amountcard right">' . price($sign * $object->total_ht, 0, $langs, 0, -1, -1, $conf->currency) . '</td>';
628 if (isModEnabled("multicurrency") && ($object->multicurrency_code && $object->multicurrency_code != $conf->currency)) {
629 // Multicurrency Amount HT
630 print '<td class="nowrap amountcard right">' . price($sign * $object->multicurrency_total_ht, 0, $langs, 0, -1, -1, $object->multicurrency_code) . '</td>';
631 }
632 print '</tr>';
633
634 print '<tr>';
635 // Amount VAT
636 print '<td>' . $langs->trans('AmountVAT') . '</td>';
637 print '<td class="nowrap amountcard right">' . price($sign * $object->total_tva, 0, $langs, 0, -1, -1, $conf->currency) . '</td>';
638 if (isModEnabled("multicurrency") && ($object->multicurrency_code && $object->multicurrency_code != $conf->currency)) {
639 // Multicurrency Amount VAT
640 print '<td class="nowrap amountcard right">' . price($sign * $object->multicurrency_total_tva, 0, $langs, 0, -1, -1, $object->multicurrency_code) . '</td>';
641 }
642 print '</tr>';
643
644 // Amount Local Taxes
645 if (($mysoc->localtax1_assuj == "1" && $mysoc->useLocalTax(1)) || $object->total_localtax1 != 0) {
646 print '<tr>';
647 print '<td class="titlefieldmiddle">' . $langs->transcountry("AmountLT1", $mysoc->country_code) . '</td>';
648 print '<td class="nowrap amountcard right">' . price($sign * $object->total_localtax1, 0, $langs, 0, -1, -1, $conf->currency) . '</td>';
649 if (isModEnabled("multicurrency") && ($object->multicurrency_code && $object->multicurrency_code != $conf->currency)) {
650 $object->multicurrency_total_localtax1 = (float) price2num($object->total_localtax1 * $object->multicurrency_tx, 'MT');
651
652 print '<td class="nowrap amountcard right">' . price($sign * $object->multicurrency_total_localtax1, 0, $langs, 0, -1, -1, $object->multicurrency_code) . '</td>';
653 }
654 print '</tr>';
655 }
656
657 if (($mysoc->localtax2_assuj == "1" && $mysoc->useLocalTax(2)) || $object->total_localtax2 != 0) {
658 print '<tr>';
659 print '<td>' . $langs->transcountry("AmountLT2", $mysoc->country_code) . '</td>';
660 print '<td class="nowrap amountcard right">' . price($sign * $object->total_localtax2, 0, $langs, 0, -1, -1, $conf->currency) . '</td>';
661 if (isModEnabled("multicurrency") && ($object->multicurrency_code && $object->multicurrency_code != $conf->currency)) {
662 $object->multicurrency_total_localtax2 = (float) price2num($object->total_localtax2 * $object->multicurrency_tx, 'MT');
663
664 print '<td class="nowrap amountcard right">' . price($sign * $object->multicurrency_total_localtax2, 0, $langs, 0, -1, -1, $object->multicurrency_code) . '</td>';
665 }
666 print '</tr>';
667 }
668
669 // Revenue stamp
670 if ($selleruserevenustamp) { // Test company use revenue stamp
671 print '<tr><td>';
672 print '<table class="nobordernopadding centpercent"><tr><td>';
673 print $langs->trans('RevenueStamp');
674 print '</td>';
675 if ($action != 'editrevenuestamp' && $object->status == $object::STATUS_DRAFT && $user->hasRight('facture', 'creer')) {
676 print '<td class="right"><a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?action=editrevenuestamp&token='.newToken().'&facid='.$object->id.'">'.img_edit($langs->trans('SetRevenuStamp'), 1).'</a></td>';
677 }
678 print '</tr></table>';
679 print '</td><td class="nowrap right">';
680 print price($object->revenuestamp, 1, '', 1, - 1, - 1, $conf->currency);
681 print '</td></tr>';
682 }
683
684 print '<tr>';
685 // Amount TTC
686 print '<td>' . $langs->trans('AmountTTC') . '</td>';
687 print '<td class="nowrap amountcard right">' . price($sign * $object->total_ttc, 0, $langs, 0, -1, -1, $conf->currency) . '</td>';
688 if (isModEnabled("multicurrency") && ($object->multicurrency_code && $object->multicurrency_code != $conf->currency)) {
689 // Multicurrency Amount TTC
690 print '<td class="nowrap amountcard right">' . price($sign * $object->multicurrency_total_ttc, 0, $langs, 0, -1, -1, $object->multicurrency_code) . '</td>';
691 }
692 print '</tr>';
693
694
695 $resteapayer = price2num($object->total_ttc - $totalpaid - $totalcreditnotes - $totaldeposits, 'MT');
696
697 // Hook to change amount for other reasons, e.g. apply cash discount for payment before agreed date
698 $parameters = array('remaintopay' => $resteapayer);
699 $reshook = $hookmanager->executeHooks('finalizeAmountOfInvoice', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
700 if ($reshook > 0) {
701 print $hookmanager->resPrint;
702 if (!empty($remaintopay = $hookmanager->resArray['remaintopay'])) {
703 $resteapayer = $remaintopay;
704 }
705 }
706
707 // TODO Replace this by an include with same code to show already done payment visible in invoice card
708 print '<tr><td>'.$langs->trans('RemainderToPay').'</td><td class="nowrap right">'.price($resteapayer, 1, '', 1, - 1, - 1, $conf->currency).'</td>';
709 if (isModEnabled("multicurrency") && ($object->multicurrency_code && $object->multicurrency_code != $conf->currency)) {
710 print '<td></td>';
711 }
712 print '</tr>';
713
714 print '</table>';
715
716 print '</div>';
717 print '</div>';
718
719 print '<div class="clearboth"></div>';
720
721
722 print dol_get_fiche_end();
723
724
725 // For which amount ?
726 // Note: The 2 following SQL requests are wrong but it works because we have one record into pfd for one record into pl and for into p for the same fk_facture_fourn.
727 // The table prelevement and prelevement_lignes and must be removed in future and merged into prelevement_demande
728 // Step 1: Move field fk_... of llx_prelevement into llx_prelevement_lignes
729 // Step 2: Move field fk_... + status into prelevement_demande.
730 $pending = 0;
731 // Get pending requests open with no transfer receipt yet
732 $sql = "SELECT SUM(pfd.amount) as amount";
733 $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_demande as pfd";
734 if ($type == 'bank-transfer') {
735 $sql .= " WHERE pfd.fk_facture_fourn = ".((int) $object->id);
736 } else {
737 $sql .= " WHERE pfd.fk_facture = ".((int) $object->id);
738 }
739 $sql .= " AND pfd.traite = 0";
740 //$sql .= " AND pfd.type = 'ban'";
741 $resql = $db->query($sql);
742 if ($resql) {
743 $obj = $db->fetch_object($resql);
744 if ($obj) {
745 $pending += (float) $obj->amount;
746 }
747 } else {
748 dol_print_error($db);
749 }
750 // Get pending request with a transfer receipt generated but not yet processed
751 $sqlPending = "SELECT SUM(pl.amount) as amount";
752 $sqlPending .= " FROM ".$db->prefix()."prelevement_lignes as pl";
753 $sqlPending .= " INNER JOIN ".$db->prefix()."prelevement as p ON p.fk_prelevement_lignes = pl.rowid";
754 if ($type == 'bank-transfer') {
755 $sqlPending .= " WHERE p.fk_facture_fourn = ".((int) $object->id);
756 } else {
757 $sqlPending .= " WHERE p.fk_facture = ".((int) $object->id);
758 }
759 $sqlPending .= " AND (pl.statut IS NULL OR pl.statut = 0)";
760 $resPending = $db->query($sqlPending);
761 if ($resPending) {
762 if ($objPending = $db->fetch_object($resPending)) {
763 $pending += (float) $objPending->amount;
764 }
765 }
766 $db->free($resPending);
767
768 /*
769 $sql = "SELECT SUM(pfd.amount) as amount";
770 $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_demande as pfd";
771 if ($type == 'bank-transfer') {
772 $sql .= " WHERE fk_facture_fourn = ".((int) $object->id);
773 } else {
774 $sql .= " WHERE fk_facture = ".((int) $object->id);
775 }
776 $sql .= " AND pfd.traite = 0";
777 $sql .= " AND pfd.type = 'ban'";
778
779 $resql = $db->query($sql);
780 if ($resql) {
781 $obj = $db->fetch_object($resql);
782 if ($obj) {
783 $pendingAmount = $obj->amount;
784 }
785 } else {
786 dol_print_error($db);
787 }
788 */
789
790 /*
791 * Buttons
792 */
793
794 print "\n".'<div class="tabsAction">'."\n";
795
796 $buttonlabel = $langs->trans("MakeWithdrawRequest");
797 $user_perms = $user->hasRight('prelevement', 'bons', 'creer');
798 if ($type == 'bank-transfer') {
799 $buttonlabel = $langs->trans("MakeBankTransferOrder");
800 $user_perms = $user->hasRight('paymentbybanktransfer', 'create');
801 }
802
803 // Add a transfer request
804 if ($object->status > $object::STATUS_DRAFT && $object->paid == 0 && $numopen == 0) {
805 if ($resteapayer > 0) {
806 if ($user_perms) {
807 $remaintopaylesspendingdebit = $resteapayer - $pending;
808
809 $title = $langs->trans("NewStandingOrder");
810 if ($type == 'bank-transfer') {
811 $title = $langs->trans("NewPaymentByBankTransfer");
812 }
813
814 print '<!-- form to select BAN -->';
815 print '<form method="POST" action="'.$_SERVER["PHP_SELF"].'">';
816 print '<input type="hidden" name="token" value="'.newToken().'" />';
817 print '<input type="hidden" name="id" value="'.$object->id.'" />';
818 print '<input type="hidden" name="type" value="'.$type.'" />';
819 print '<input type="hidden" name="action" value="new" />';
820
821 print '<div class="center formconsumeproduce">';
822
823 print $langs->trans('CustomerIBAN').' ';
824
825 // if societe rib in model invoice, we preselect it
826 $selectedRibId = 0;
827 if ($object->element == 'invoice' && $object->fk_fac_rec_source) {
828 $facturerec = new FactureRec($db);
829 $facturerec->fetch($object->fk_fac_rec_source);
830 if ($facturerec->fk_societe_rib) {
831 $companyBankAccount = new CompanyBankAccount($db);
832 $res = $companyBankAccount->fetch($facturerec->fk_societe_rib);
833 $selectedRibId = $companyBankAccount->id;
834 }
835 }
836 $defaultRibId = $object->thirdparty->getDefaultRib();
837 if (empty($selectedRibId)) $selectedRibId = (int) $defaultRibId;
838
839 $selectedRib = $form->selectRib($selectedRibId, 'accountcustomerid', 'fk_soc='.$object->socid, 1, '', 1);
840
841 if ($defaultRibId) {
842 $companyBankAccount = new CompanyBankAccount($db);
843 $res = $companyBankAccount->fetch($defaultRibId);
844 if ($res > 0 && !$companyBankAccount->verif()) {
845 print img_warning('Error on default bank number for IBAN : '.$langs->trans($companyBankAccount->error));
846 }
847 } elseif (($type != 'bank-transfer' && $object->mode_reglement_code == 'PRE') || ($type == 'bank-transfer' && $object->mode_reglement_code == 'VIR')) {
848 print img_warning($langs->trans("NoDefaultIBANFound"));
849 }
850
851
852 // Bank Transfer Amount
853 print ' &nbsp; &nbsp; <label for="withdraw_request_amount">';
854 if ($type == 'bank-transfer') {
855 print $langs->trans('BankTransferAmount');
856 } else {
857 print $langs->trans("WithdrawRequestAmount");
858 }
859 print '</label> ';
860 print '<input type="text" class="right width75" id="withdraw_request_amount" name="withdraw_request_amount" value="'.$remaintopaylesspendingdebit.'">';
861
862 // Button
863 print '<br><br>';
864 print '<input type="submit" class="butAction small" value="'.$buttonlabel.'" />';
865 print '<br><br>';
866
867 print '</div>';
868
869 print '</form>';
870
871 if (getDolGlobalString('STRIPE_SEPA_DIRECT_DEBIT_SHOW_OLD_BUTTON')) { // This is hidden, prefer to use mode enabled with STRIPE_SEPA_DIRECT_DEBIT
872 // TODO Replace this with a checkbox for each payment mode: "Send request to XXX immediately..."
873 print "<br>";
874 // Add stripe sepa button
875 $buttonlabel = $langs->trans("MakeWithdrawRequestStripe");
876 print '<form method="POST" action="">';
877 print '<input type="hidden" name="token" value="'.newToken().'" />';
878 print '<input type="hidden" name="id" value="'.$object->id.'" />';
879 print '<input type="hidden" name="type" value="'.$type.'" />';
880 print '<input type="hidden" name="action" value="new" />';
881 print '<input type="hidden" name="paymenservice" value="stripesepa" />';
882 print '<label for="withdraw_request_amount">'.$langs->trans('BankTransferAmount').' </label>';
883 print '<input type="text" id="withdraw_request_amount" name="withdraw_request_amount" value="'.$remaintopaylesspendingdebit.'" size="9" />';
884 print '<input type="submit" class="butAction small" value="'.$buttonlabel.'" />';
885 print '</form>';
886 }
887 } else {
888 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("NotEnoughPermissions")).'">'.$buttonlabel.'</a>';
889 }
890 } else {
891 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("AmountMustBePositive")).'">'.$buttonlabel.'</a>';
892 }
893 } else {
894 if ($numopen == 0) {
895 if ($object->status > $object::STATUS_DRAFT) {
896 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("AlreadyPaid")).'">'.$buttonlabel.'</a>';
897 } else {
898 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("Draft")).'">'.$buttonlabel.'</a>';
899 }
900 } else {
901 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("RequestAlreadyDone")).'">'.$buttonlabel.'</a>';
902 }
903 }
904
905 print "</div>\n";
906
907
908 if ($type == 'bank-transfer') {
909 print '<div class="opacitymedium justify">'.$langs->trans("DoCreditTransferBeforePayments");
910 if (isModEnabled('stripe') && getDolGlobalString('STRIPE_SEPA_DIRECT_DEBIT')) {
911 print ' '.$langs->trans("DoStandingOrdersBeforePayments2");
912 }
913 print ' '.$langs->trans("DoStandingOrdersBeforePayments3");
914 print '</div><br><br>';
915 } else {
916 print '<div class="opacitymedium justify">'.$langs->trans("DoStandingOrdersBeforePayments");
917 if (isModEnabled('stripe') && getDolGlobalString('STRIPE_SEPA_DIRECT_DEBIT')) {
918 print ' '.$langs->trans("DoStandingOrdersBeforePayments2");
919 }
920 print ' '.$langs->trans("DoStandingOrdersBeforePayments3");
921 print '</div><br><br>';
922 }
923
924 /*
925 * Withdrawals
926 */
927
928 print '<div class="div-table-responsive-no-min">';
929 print '<table class="noborder centpercent">';
930
931 print '<tr class="liste_titre">';
932 // Action column
933 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
934 print '<td>&nbsp;</td>';
935 }
936 print '<td class="left">'.$langs->trans("DateRequest").'</td>';
937 print '<td>'.$langs->trans("User").'</td>';
938 print '<td class="center">'.$langs->trans("Amount").'</td>';
939 print '<td class="center">'.$langs->trans("IBAN").'</td>';
940 print '<td class="center">'.$langs->trans("DateProcess").'</td>';
941 if ($type == 'bank-transfer') {
942 print '<td class="">'.$langs->trans("BankTransferReceipt").'</td>';
943 } else {
944 print '<td class="">'.$langs->trans("WithdrawalReceipt").'</td>';
945 }
946 print '<td>&nbsp;</td>';
947 // Action column
948 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
949 print '<td>&nbsp;</td>';
950 }
951 print '</tr>';
952
953 $sql = "SELECT pfd.rowid, pfd.traite, pfd.date_demande as date_demande,";
954 $sql .= " pfd.date_traite as date_traite, pfd.amount, pfd.fk_prelevement_bons,";
955 $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,";
956 $sql .= " u.rowid as user_id, u.email, u.lastname, u.firstname, u.login, u.statut as user_status,";
957 $sql .= " sr.iban_prefix as iban, sr.bic as bic";
958 $sql .= " FROM ".$db->prefix()."prelevement_demande as pfd";
959 $sql .= " LEFT JOIN ".$db->prefix()."user as u on pfd.fk_user_demande = u.rowid";
960 $sql .= " LEFT JOIN ".$db->prefix()."prelevement_bons as pb ON pb.rowid = pfd.fk_prelevement_bons";
961 $sql .= " LEFT JOIN ".$db->prefix()."societe_rib as sr ON sr.rowid = pfd.fk_societe_rib";
962 if ($type == 'bank-transfer') {
963 $sql .= " WHERE fk_facture_fourn = ".((int) $object->id);
964 } else {
965 $sql .= " WHERE fk_facture = ".((int) $object->id);
966 }
967 $sql .= " AND pfd.traite = 0";
968 $sql .= " AND pfd.type = 'ban'";
969 $sql .= " ORDER BY pfd.date_demande DESC";
970
971 $resql = $db->query($sql);
972
973 $num = 0;
974 if ($resql) {
975 $i = 0;
976
977 $tmpuser = new User($db);
978
979 $num = $db->num_rows($resql);
980 while ($i < $num) {
981 $obj = $db->fetch_object($resql);
982
983 $tmpuser->id = $obj->user_id;
984 $tmpuser->login = $obj->login;
985 $tmpuser->ref = $obj->login;
986 $tmpuser->email = $obj->email;
987 $tmpuser->lastname = $obj->lastname;
988 $tmpuser->firstname = $obj->firstname;
989 $tmpuser->statut = $obj->user_status;
990 $tmpuser->status = $obj->user_status;
991
992 print '<tr class="oddeven">';
993
994 // Action column
995 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
996 print '<td class="center">';
997 print '<a href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=delete&token='.newToken().'&did='.$obj->rowid.'&type='.urlencode($type).'">';
998 print img_delete();
999 print '</a>';
1000 print '</td>';
1001 }
1002
1003 // Date
1004 print '<td class="nowraponall">'.dol_print_date($db->jdate($obj->date_demande), 'dayhour')."</td>\n";
1005
1006 // User
1007 print '<td class="tdoverflowmax125">';
1008 print $tmpuser->getNomUrl(-1, '', 0, 0, 0, 0, 'login');
1009 print '</td>';
1010
1011 // Amount
1012 print '<td class="center"><span class="amount">'.price($obj->amount).'</span></td>';
1013
1014 // Iban
1015 print '<td class="center"><span class="iban">';
1016 print dolDecrypt($obj->iban);
1017 if ($obj->iban && $obj->bic) {
1018 print " / ";
1019 }
1020 print $obj->bic;
1021 print '</span></td>';
1022
1023 // Date process
1024 print '<td class="center"><span class="opacitymedium">'.$langs->trans("OrderWaiting").'</span></td>';
1025
1026 // Link to make payment now
1027 print '<td class="minwidth75">';
1028 if ($obj->fk_prelevement_bons > 0) {
1029 $withdrawreceipt = new BonPrelevement($db);
1030 $withdrawreceipt->id = $obj->fk_prelevement_bons;
1031 $withdrawreceipt->ref = $obj->ref;
1032 $withdrawreceipt->date_trans = $db->jdate($obj->date_trans);
1033 $withdrawreceipt->date_credit = $db->jdate($obj->date_credit);
1034 $withdrawreceipt->date_creation = $db->jdate($obj->datec);
1035 $withdrawreceipt->statut = $obj->status;
1036 $withdrawreceipt->status = $obj->status;
1037 $withdrawreceipt->amount = $obj->pb_amount;
1038 //$withdrawreceipt->credite = $db->jdate($obj->credite);
1039
1040 print $withdrawreceipt->getNomUrl(1);
1041 }
1042
1043 if ($type != 'bank-transfer') {
1044 if (getDolGlobalString('STRIPE_SEPA_DIRECT_DEBIT')) {
1045 $langs->load("stripe");
1046 if ($obj->fk_prelevement_bons > 0) {
1047 print ' &nbsp; ';
1048 }
1049 print '<a href="'.$_SERVER["PHP_SELF"].'?action=sepastripedirectdebit&paymentservice=stripesepa&token='.newToken().'&did='.$obj->rowid.'&id='.$object->id.'&type='.urlencode($type).'">'.img_picto('', 'stripe', 'class="pictofixedwidth"').$langs->trans("RequestDirectDebitWithStripe").'</a>';
1050 }
1051 } else {
1052 if (getDolGlobalString('STRIPE_SEPA_CREDIT_TRANSFER')) {
1053 $langs->load("stripe");
1054 if ($obj->fk_prelevement_bons > 0) {
1055 print ' &nbsp; ';
1056 }
1057 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("RequestDirectDebitWithStripe").'</a>';
1058 }
1059 }
1060 print '</td>';
1061
1062 // Withraw ref
1063 print '<td class="">';
1064 //print '<span class="opacitymedium">'.$langs->trans("OrderWaiting").'</span>';
1065 print '</td>';
1066
1067 // Action column
1068 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1069 print '<td class="center">';
1070 print '<a href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=delete&token='.newToken().'&did='.$obj->rowid.'&type='.urlencode($type).'">';
1071 print img_delete();
1072 print '</a></td>';
1073 }
1074
1075 print "</tr>\n";
1076 $i++;
1077 }
1078
1079 $db->free($resql);
1080 } else {
1081 dol_print_error($db);
1082 }
1083
1084
1085 // Past requests
1086
1087 $sql = "SELECT pfd.rowid, pfd.traite, pfd.date_demande, pfd.date_traite, pfd.fk_prelevement_bons, pfd.amount, pfd.fk_societe_rib, pfd.ext_payment_id, pfd.ext_payment_site,";
1088 $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,";
1089 $sql .= " u.rowid as user_id, u.email, u.lastname, u.firstname, u.login, u.statut as user_status, u.photo as user_photo,";
1090 $sql .= " sr.iban_prefix as iban, sr.bic as bic";
1091 $sql .= " FROM ".$db->prefix()."prelevement_demande as pfd";
1092 $sql .= " LEFT JOIN ".$db->prefix()."user as u on pfd.fk_user_demande = u.rowid";
1093 $sql .= " LEFT JOIN ".$db->prefix()."prelevement_bons as pb ON pb.rowid = pfd.fk_prelevement_bons";
1094 $sql .= " LEFT JOIN ".$db->prefix()."societe_rib as sr ON sr.rowid = pfd.fk_societe_rib";
1095 if ($type == 'bank-transfer') {
1096 $sql .= " WHERE fk_facture_fourn = ".((int) $object->id);
1097 } else {
1098 $sql .= " WHERE fk_facture = ".((int) $object->id);
1099 }
1100 $sql .= " AND pfd.traite = 1";
1101 $sql .= " AND pfd.type = 'ban'";
1102 //$sql .= " AND pfd.entity IN (".getEntity('prelevement_demande').")"; // Disabled because the filter on fk_facture... should be enough.
1103 $sql .= " ORDER BY pfd.date_demande DESC";
1104
1105 $resql = $db->query($sql);
1106 if ($resql) {
1107 $num = $db->num_rows($resql);
1108 $numclosed = $num;
1109 $i = 0;
1110
1111 $tmpuser = new User($db);
1112
1113 while ($i < $num) {
1114 $obj = $db->fetch_object($resql);
1115
1116 $tmpuser->id = $obj->user_id;
1117 $tmpuser->login = $obj->login;
1118 $tmpuser->ref = $obj->login;
1119 $tmpuser->email = $obj->email;
1120 $tmpuser->lastname = $obj->lastname;
1121 $tmpuser->firstname = $obj->firstname;
1122 $tmpuser->statut = $obj->user_status;
1123 $tmpuser->status = $obj->user_status;
1124 $tmpuser->photo = $obj->user_photo;
1125
1126 print '<tr class="oddeven">';
1127
1128 // Action column
1129 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1130 print '<td>&nbsp;</td>';
1131 }
1132
1133 // Date
1134 print '<td class="nowraponall">'.dol_print_date($db->jdate($obj->date_demande), 'day', 'tzuserrel')."</td>\n";
1135
1136 // User
1137 print '<td class="tdoverflowmax125">';
1138 print $tmpuser->getNomUrl(-1, '', 0, 0, 0, 0, 'login');
1139 print '</td>';
1140
1141 // Amount
1142 print '<td class="center"><span class="amount">'.price($obj->amount).'</span></td>';
1143
1144 // Iban
1145 print '<td class="center"><span class="iban">';
1146 print dolDecrypt($obj->iban);
1147 if ($obj->iban && $obj->bic) {
1148 print " / ";
1149 }
1150 print $obj->bic;
1151 print '</span></td>';
1152
1153 // Date process
1154 print '<td class="center nowraponall">'.dol_print_date($db->jdate($obj->date_traite), 'dayhour', 'tzuserrel')."</td>\n";
1155
1156 // Link to payment request done
1157 print '<td class="minwidth75">';
1158 if ($obj->fk_prelevement_bons > 0) {
1159 $withdrawreceipt = new BonPrelevement($db);
1160 $withdrawreceipt->id = $obj->fk_prelevement_bons;
1161 $withdrawreceipt->ref = $obj->ref;
1162 $withdrawreceipt->date_trans = $db->jdate($obj->date_trans);
1163 $withdrawreceipt->date_credit = $db->jdate($obj->date_credit);
1164 $withdrawreceipt->date_creation = $db->jdate($obj->datec);
1165 $withdrawreceipt->statut = $obj->status;
1166 $withdrawreceipt->status = $obj->status;
1167 $withdrawreceipt->fk_bank_account = $obj->fk_bank_account;
1168 $withdrawreceipt->amount = $obj->pb_amount;
1169 //$withdrawreceipt->credite = $db->jdate($obj->credite);
1170
1171 print $withdrawreceipt->getNomUrl(1);
1172 print ' ';
1173 print $withdrawreceipt->getLibStatut(2);
1174
1175 // Show the bank account
1176 $fk_bank_account = $withdrawreceipt->fk_bank_account;
1177 if (empty($fk_bank_account)) {
1178 $fk_bank_account = ($object->type == 'bank-transfer' ? getDolGlobalInt('PAYMENTBYBANKTRANSFER_ID_BANKACCOUNT') : getDolGlobalInt('PRELEVEMENT_ID_BANKACCOUNT'));
1179 }
1180 if ($fk_bank_account > 0) {
1181 $bankaccount = new Account($db);
1182 $result = $bankaccount->fetch($fk_bank_account);
1183 if ($result > 0) {
1184 print ' - ';
1185 print $bankaccount->getNomUrl(1);
1186 }
1187 }
1188 if (!empty($obj->ext_payment_id) || !empty($obj->ext_payment_site)) {
1189 print ' - <span class="small opacitymedium">';
1190 print $obj->ext_payment_id.'/'.$obj->ext_payment_site;
1191 print '</span>';
1192 }
1193 }
1194 print "</td>\n";
1195
1196 //
1197 print '<td>&nbsp;</td>';
1198
1199 // Action column
1200 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1201 print '<td>&nbsp;</td>';
1202 }
1203
1204 print "</tr>\n";
1205 $i++;
1206 }
1207
1208 if (!$numopen && !$numclosed) {
1209 print '<tr class="oddeven"><td colspan="8"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
1210 }
1211
1212 $db->free($resql);
1213 } else {
1214 dol_print_error($db);
1215 }
1216
1217 print "</table>";
1218 print '</div>';
1219}
1220
1221// End of page
1222llxFooter();
1223$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
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
Class to manage bank accounts.
Class to manage withdrawal receipts.
Class to manage bank accounts description of third parties.
Class to manage suppliers invoices.
Class to manage invoices.
const STATUS_DRAFT
Draft status.
Class to manage invoice templates.
Class to manage generation of HTML components Only common components must be here.
Class to manage projects.
Class to manage Dolibarr users.
facturefourn_prepare_head(FactureFournisseur $object)
Prepare array with list of tabs.
Definition fourn.lib.php:37
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...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
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.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
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.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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)
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.
img_edit($titlealt='default', $float=0, $other='')
Show logo edit/modify fiche.
facture_prepare_head($object)
Initialize the array of tabs for customer invoice.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
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.
dolDecrypt($chain, $key='')
Decode a string with a symmetric encryption.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.