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';
56$langs->loadLangs(array(
'bills',
'banks',
'withdrawals',
'companies'));
61$action =
GETPOST(
'action',
'aZ09');
64$fieldid = (!empty($ref) ?
'ref' :
'rowid');
66 $socid = $user->socid;
70if ($type ==
'bank-transfer') {
72 $moreparam =
'&type='.$type;
79if (
$id > 0 || !empty($ref)) {
89$hookmanager->initHooks(array(
'directdebitcard',
'globalcard'));
91if ($type ==
'bank-transfer') {
92 $result =
restrictedArea($user,
'fournisseur',
$id,
'facture_fourn',
'facture',
'fk_soc', $fieldid, $isdraft);
93 if (!$user->hasRight(
'fournisseur',
'facture',
'lire')) {
97 $result =
restrictedArea($user,
'facture',
$id,
'',
'',
'fk_soc', $fieldid, $isdraft);
98 if (!$user->hasRight(
'facture',
'lire')) {
103if ($type ==
'bank-transfer') {
104 $usercancreate = ($user->hasRight(
'fournisseur',
'facture',
'creer') || $user->hasRight(
'supplier_invoice',
'creer'));
106 $usercancreate = $user->hasRight(
'facture',
'creer');
114$parameters = array(
'socid' => $socid);
115$reshook = $hookmanager->executeHooks(
'doActions', $parameters,
$object, $action);
117 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
120if (empty($reshook)) {
121 if ($action ==
"new" && $usercancreate) {
126 $sourcetype =
'facture';
127 if ($type ==
'bank-transfer') {
128 $sourcetype =
'supplier_invoice';
129 $newtype =
'bank-transfer';
131 $paymentservice =
GETPOST(
'paymentservice');
135 $amount =
GETPOST(
'withdraw_request_amount',
'alpha');
136 $result =
$object->demande_prelevement($user, (
float)
price2num($amount), $newtype, $sourcetype, 0, $iban ?? 0);
141 setEventMessages($langs->trans(
"RecordSaved"),
null,
'mesgs');
150 if ($action ==
"delete" && $usercancreate) {
154 header(
"Location: ".$_SERVER[
'PHP_SELF'].
"?id=".
$object->id.
'&type='.$type);
161 if ($action ==
'sepastripedirectdebit' && $usercancreate) {
162 $result =
$object->makeStripeSepaRequest($user,
GETPOSTINT(
'did'),
'direct-debit',
'facture');
176 if ($action ==
'sepastripecredittransfer' && $usercancreate) {
177 $result =
$object->makeStripeSepaRequest($user,
GETPOSTINT(
'did'),
'bank-transfer',
'supplier_invoice');
191 if ($action ==
'setconditions' && $usercancreate) {
193 $object->cond_reglement_code = 0;
194 $object->cond_reglement_id = 0;
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;
217 $result =
$object->update($user);
229 } elseif ($action ==
'setmode' && $usercancreate) {
232 } elseif ($action ==
'setdatef' && $usercancreate) {
236 setEventMessages($langs->trans(
"WarningInvoiceDateInFuture"),
null,
'warnings');
238 setEventMessages($langs->trans(
"WarningInvoiceDateTooFarInFuture"),
null,
'warnings');
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;
251 $result =
$object->update($user);
253 dol_print_error($db,
$object->error);
255 } elseif ($action ==
'setdate_lim_reglement' && $usercancreate) {
259 setEventMessages($langs->trans(
"DatePaymentTermCantBeLowerThanObjectDate"),
null,
'warnings');
261 $result =
$object->update($user);
263 dol_print_error($db,
$object->error);
273$form =
new Form($db);
277if ($type ==
'bank-transfer') {
278 $title = $langs->trans(
'SupplierInvoice').
" - ".$langs->trans(
'CreditTransfer');
281 $title = $langs->trans(
'InvoiceCustomer').
" - ".$langs->trans(
'StandingOrders');
282 $helpurl =
"EN:Customers_Invoices|FR:Factures_Clients|ES:Facturas_a_clientes";
289 $selleruserevenustamp =
$mysoc->useRevenueStamp();
291 $totalpaid =
$object->getSommePaiement();
292 $totalcreditnotes =
$object->getSumCreditNotesUsed();
293 $totaldeposits =
$object->getSumDepositsUsed();
300 $resteapayer =
price2num(
$object->total_ttc - $totalpaid - $totalcreditnotes - $totaldeposits,
'MT');
306 if ($type ==
'bank-transfer') {
308 $filterabsolutediscount =
"fk_invoice_supplier_source IS NULL";
309 $filtercreditnote =
"fk_invoice_supplier_source IS NOT NULL";
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)%')";
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');
321 $filterabsolutediscount =
"fk_facture_source IS NULL";
322 $filtercreditnote =
"fk_facture_source IS NOT NULL";
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)%')";
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');
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)) {
338 $author->fetch(
$object->fk_user_author);
341 if ($type ==
'bank-transfer') {
352 $listofopendirectdebitorcredittransfer =
$object->getListOfOpenDirectDebitOrCreditTransfer($type);
353 $numopen = count($listofopendirectdebitorcredittransfer);
355 print
dol_get_fiche_head($head,
'standingorders', $title, -1, ($type ==
'bank-transfer' ?
'supplier_invoice' :
$object->picto));
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>';
361 $linkback =
'<a href="'.DOL_URL_ROOT.
'/compta/facture/list.php?restore_lastsearch_values=1'.(!empty($socid) ?
'&socid='.$socid :
'').
'">'.$langs->trans(
"BackToList").
'</a>';
364 $morehtmlref =
'<div class="refidno">';
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);
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);
374 $morehtmlref .=
'<br>'.$object->thirdparty->getNomUrl(1);
375 if ($type ==
'bank-transfer') {
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>';
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>';
386 $langs->load(
"projects");
387 $morehtmlref .=
'<br>';
389 $morehtmlref .= img_picto($langs->trans(
"Project"),
'project',
'class="pictofixedwidth"');
390 if ($action !=
'classify') {
391 $morehtmlref .=
'<a class="editfielda" href="'.dolBuildUrl($_SERVER[
'PHP_SELF'], [
'action' =>
'classify',
'id' => ((
int)
$object->id)],
true).
'">'.img_edit($langs->transnoentitiesnoconv(
'SetProject')).
'</a> ';
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');
395 if (!empty(
$object->fk_project)) {
397 $proj->fetch(
$object->fk_project);
398 $morehtmlref .= $proj->getNomUrl(1);
400 $morehtmlref .=
'<span class="opacitymedium"> - '.dol_escape_htmltag($proj->title).
'</span>';
405 $morehtmlref .=
'</div>';
407 $object->totalpaid = $totalpaid;
409 dol_banner_tab(
$object,
'ref', $linkback, 1,
'ref',
'ref', $morehtmlref, $moreparam, 0,
'',
'');
411 print
'<div class="fichecenter">';
412 print
'<div class="fichehalfleft">';
413 print
'<div class="underbanner clearboth"></div>';
415 print
'<table class="border centpercent tableforfield">';
418 print
'<tr><td class="titlefield fieldname_type">'.$langs->trans(
'Type').
'</td><td colspan="3">';
419 print
'<span class="badgeneutral">';
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>';
425 if (
$object->type == $object::TYPE_REPLACEMENT) {
426 if ($type ==
'bank-transfer') {
429 $facreplaced =
new Facture($db);
431 $facreplaced->fetch(
$object->fk_facture_source);
432 print
' <span class="opacitymediumbycolor paddingleft">'.$langs->transnoentities(
"ReplaceInvoice", $facreplaced->getNomUrl(1)).
'</span>';
434 if (
$object->type == $object::TYPE_CREDIT_NOTE && !empty(
$object->fk_facture_source)) {
435 if ($type ==
'bank-transfer') {
440 $facusing->fetch(
$object->fk_facture_source);
441 print
' <span class="opacitymediumbycolor paddingleft">'.$langs->transnoentities(
"CorrectInvoice", $facusing->getNomUrl(1)).
'</span>';
445 $object->getListIdAvoirFromInvoice();
447 if (!empty(
$object->creditnote_ids)) {
448 $invoicecredits = array();
449 foreach (
$object->creditnote_ids as $invoiceid) {
450 if ($type ==
'bank-transfer') {
453 $creditnote =
new Facture($db);
455 $creditnote->fetch($invoiceid);
456 $invoicecredits[] = $creditnote->getNomUrl(1);
458 print
' <span class="opacitymediumbycolor paddingleft">'.$langs->transnoentities(
"InvoiceHasAvoir");
459 print
' '. (count($invoicecredits) ?
' ' :
'') . implode(
',', $invoicecredits);
472 print
'<!-- Discounts -->'.
"\n";
473 print
'<tr><td>'.$langs->trans(
'DiscountStillRemaining').
'</td><td colspan="3">';
475 if ($type ==
'bank-transfer') {
478 $thirdparty =
$object->thirdparty;
481 $thirdparty =
$object->thirdparty;
484 $backtopage = urlencode($_SERVER[
"PHP_SELF"].
'?facid='.
$object->id);
485 $cannotApplyDiscount = 1;
486 include DOL_DOCUMENT_ROOT.
'/core/tpl/object_discounts.tpl.php';
491 if ($type ==
'bank-transfer') {
493 print
'<td>'.$form->editfieldkey(
"Label",
'label',
$object->label,
$object, 0).
'</td>';
494 print
'<td>'.$form->editfieldval(
"Label",
'label',
$object->label,
$object, 0).
'</td>';
500 print
'<table class="nobordernopadding centpercent"><tr><td>';
501 print $langs->trans(
'DateInvoice');
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>';
506 print
'</tr></table>';
507 print
'</td><td colspan="3">';
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);
523 print
'<table class="nobordernopadding centpercent"><tr><td>';
524 print $langs->trans(
'PaymentConditionsShort');
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>';
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);
535 $form->form_conditions_reglement($_SERVER[
'PHP_SELF'].
'?id='.
$object->id, (
string)
$object->cond_reglement_id,
'none');
544 print
'<table class="nobordernopadding centpercent"><tr><td>';
545 print $langs->trans(
'DateMaxPayment');
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>';
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;
558 if ($action ==
'editpaymentterm') {
559 print $form->form_date($_SERVER[
'PHP_SELF'].
'?id='.
$object->id, $duedate,
'paymentterm', 0, 0, 1, $type);
563 print img_warning($langs->trans(
'Late'));
573 print
'<table class="nobordernopadding centpercent"><tr><td>';
574 print $langs->trans(
'PaymentMode');
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>';
579 print
'</tr></table>';
580 print
'</td><td colspan="3">';
581 $filtertype =
'CRDT';
582 if ($type ==
'bank-transfer') {
583 $filtertype =
'DBIT';
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);
588 $form->form_modes_reglement($_SERVER[
'PHP_SELF'].
'?id='.
$object->id, (
string)
$object->mode_reglement_id,
'none');
593 print
'<tr><td class="nowrap">';
594 print
'<table width="100%" class="nobordernopadding"><tr><td class="nowrap">';
595 print $langs->trans(
'BankAccount');
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>';
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);
605 $form->formSelectAccount($_SERVER[
'PHP_SELF'].
'?id='.
$object->id, (
string)
$object->fk_account,
'none');
612 print
'<div class="fichehalfright">';
613 print
'<!-- amounts -->'.
"\n";
614 print
'<div class="underbanner clearboth"></div>'.
"\n";
616 print
'<table class="border tableforfield centpercent">';
618 include DOL_DOCUMENT_ROOT.
'/core/tpl/object_currency_amount.tpl.php';
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>';
630 print
'<td class="nowrap amountcard right">' .
price($sign *
$object->multicurrency_total_ht, 0, $langs, 0, -1, -1,
$object->multicurrency_code) .
'</td>';
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>';
640 print
'<td class="nowrap amountcard right">' .
price($sign *
$object->multicurrency_total_tva, 0, $langs, 0, -1, -1,
$object->multicurrency_code) .
'</td>';
645 if ((
$mysoc->localtax1_assuj ==
"1" &&
$mysoc->useLocalTax(1)) ||
$object->total_localtax1 != 0) {
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>';
652 print
'<td class="nowrap amountcard right">' .
price($sign *
$object->multicurrency_total_localtax1, 0, $langs, 0, -1, -1,
$object->multicurrency_code) .
'</td>';
657 if ((
$mysoc->localtax2_assuj ==
"1" &&
$mysoc->useLocalTax(2)) ||
$object->total_localtax2 != 0) {
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>';
664 print
'<td class="nowrap amountcard right">' .
price($sign *
$object->multicurrency_total_localtax2, 0, $langs, 0, -1, -1,
$object->multicurrency_code) .
'</td>';
670 if ($selleruserevenustamp) {
672 print
'<table class="nobordernopadding centpercent"><tr><td>';
673 print $langs->trans(
'RevenueStamp');
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>';
678 print
'</tr></table>';
679 print
'</td><td class="nowrap right">';
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>';
690 print
'<td class="nowrap amountcard right">' .
price($sign *
$object->multicurrency_total_ttc, 0, $langs, 0, -1, -1,
$object->multicurrency_code) .
'</td>';
695 $resteapayer =
price2num(
$object->total_ttc - $totalpaid - $totalcreditnotes - $totaldeposits,
'MT');
698 $parameters = array(
'remaintopay' => $resteapayer);
699 $reshook = $hookmanager->executeHooks(
'finalizeAmountOfInvoice', $parameters,
$object, $action);
701 print $hookmanager->resPrint;
702 if (!empty($remaintopay = $hookmanager->resArray[
'remaintopay'])) {
703 $resteapayer = $remaintopay;
708 print
'<tr><td>'.$langs->trans(
'RemainderToPay').
'</td><td class="nowrap right">'.
price($resteapayer, 1,
'', 1, - 1, - 1,
$conf->currency).
'</td>';
719 print
'<div class="clearboth"></div>';
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);
737 $sql .=
" WHERE pfd.fk_facture = ".((int)
$object->id);
739 $sql .=
" AND pfd.traite = 0";
741 $resql = $db->query($sql);
743 $obj = $db->fetch_object($resql);
745 $pending += (float) $obj->amount;
748 dol_print_error($db);
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);
757 $sqlPending .=
" WHERE p.fk_facture = ".((int)
$object->id);
759 $sqlPending .=
" AND (pl.statut IS NULL OR pl.statut = 0)";
760 $resPending = $db->query($sqlPending);
762 if ($objPending = $db->fetch_object($resPending)) {
763 $pending += (float) $objPending->amount;
766 $db->free($resPending);
794 print
"\n".
'<div class="tabsAction">'.
"\n";
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');
804 $remaintopaylesspendingdebit = $resteapayer - $pending;
810 $canCreateRequest = (
$object->status > $object::STATUS_DRAFT &&
$object->paid == 0 && $remaintopaylesspendingdebit > 0);
813 $canCreateRequest = (
$object->status > $object::STATUS_DRAFT &&
$object->paid == 0 && $numopen == 0 && $resteapayer > 0);
815 if ($canCreateRequest) {
817 $title = $langs->trans(
"NewStandingOrder");
818 if ($type ==
'bank-transfer') {
819 $title = $langs->trans(
"NewPaymentByBankTransfer");
821 print
'<!-- form to select BAN -->';
822 print
'<form method="POST" action="'.dolBuildUrl($_SERVER[
"PHP_SELF"]).
'">';
823 print
'<input type="hidden" name="token" value="'.newToken().
'" />';
824 print
'<input type="hidden" name="id" value="'.$object->id.
'" />';
825 print
'<input type="hidden" name="type" value="'.$type.
'" />';
826 print
'<input type="hidden" name="action" value="new" />';
827 print
'<div class="center formconsumeproduce">';
831 if (
$object->element ==
'invoice' &&
$object->fk_fac_rec_source) {
833 $facturerec->fetch(
$object->fk_fac_rec_source);
834 if ($facturerec->fk_societe_rib) {
836 $res = $companyBankAccount->fetch($facturerec->fk_societe_rib);
837 $selectedRib = $companyBankAccount->id;
840 $selectedRib = $form->selectRib($selectedRib,
'accountcustomerid',
'(fk_soc:=:'.
$object->socid.
")", $langs->trans(
"CustomerIBAN"),
'', 1,
'maxwidth500 maxwidth250onsmartphone');
841 $defaultRibId =
$object->thirdparty->getDefaultRib();
844 $res = $companyBankAccount->fetch($defaultRibId);
845 if ($res > 0 && !$companyBankAccount->verif()) {
846 print img_warning(
'Error on default bank number for IBAN : '.$langs->trans($companyBankAccount->error));
848 } elseif (($type !=
'bank-transfer' &&
$object->mode_reglement_code ==
'PRE') || ($type ==
'bank-transfer' &&
$object->mode_reglement_code ==
'VIR')) {
849 print img_warning($langs->trans(
"NoDefaultIBANFound"));
855 print
' ';
857 print
'<label for="withdraw_request_amount">';
858 if ($type ==
'bank-transfer') {
859 print $langs->trans(
'BankTransferAmount');
861 print $langs->trans(
"WithdrawRequestAmount");
864 print
'<input type="text" class="right width75" id="withdraw_request_amount" name="withdraw_request_amount" value="'.$remaintopaylesspendingdebit.
'">';
867 print
'<input type="submit" class="butAction small" value="'.$buttonlabel.
'" />';
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.
'" />';
888 print
'<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans(
"NotEnoughPermissions")).
'">'.$buttonlabel.
'</a>';
892 if (
$object->status > $object::STATUS_DRAFT) {
896 print
'<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans(
"AmountRequestedAlreadyReachesTotal")).
'">'.$buttonlabel.
'</a>';
900 print
'<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans(
"RequestAlreadyDone")).
'">'.$buttonlabel.
'</a>';
902 print
'<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans(
"AmountMustBePositive")).
'">'.$buttonlabel.
'</a>';
906 print
'<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans(
"AlreadyPaid")).
'">'.$buttonlabel.
'</a>';
909 print
'<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans(
"Draft")).
'">'.$buttonlabel.
'</a>';
915 if ($type ==
'bank-transfer') {
916 print
'<div class="opacitymedium justify">'.$langs->trans(
"DoCreditTransferBeforePayments");
918 print
' '.$langs->trans(
"DoStandingOrdersBeforePayments2");
920 print
' '.$langs->trans(
"DoStandingOrdersBeforePayments3");
921 print
'</div><br><br>';
923 print
'<div class="opacitymedium justify">'.$langs->trans(
"DoStandingOrdersBeforePayments");
925 print
' '.$langs->trans(
"DoStandingOrdersBeforePayments2");
927 print
' '.$langs->trans(
"DoStandingOrdersBeforePayments3");
928 print
'</div><br><br>';
935 print
'<div class="div-table-responsive-no-min">';
936 print
'<table class="noborder centpercent">';
938 print
'<tr class="liste_titre">';
940 if (
$conf->main_checkbox_left_column) {
941 print
'<td> </td>';
943 print
'<td class="left">'.$langs->trans(
"ID").
'</td>';
944 print
'<td class="left">'.$langs->trans(
"DateRequest").
'</td>';
945 print
'<td>'.$langs->trans(
"User").
'</td>';
946 print
'<td class="center">'.$langs->trans(
"Amount").
'</td>';
947 print
'<td class="center">'.$langs->trans(
"IBAN").
'</td>';
948 print
'<td class="center">'.$langs->trans(
"DateProcess").
'</td>';
949 if ($type ==
'bank-transfer') {
950 print
'<td class="">'.$langs->trans(
"BankTransferReceipt").
'</td>';
952 print
'<td class="">'.$langs->trans(
"WithdrawalReceipt").
'</td>';
954 print
'<td> </td>';
956 if (!
$conf->main_checkbox_left_column) {
957 print
'<td> </td>';
961 $sql =
"SELECT pfd.rowid, pfd.traite, pfd.date_demande as date_demande,";
962 $sql .=
" pfd.date_traite as date_traite, pfd.amount, pfd.fk_prelevement_bons,";
963 $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,";
964 $sql .=
" u.rowid as user_id, u.email, u.lastname, u.firstname, u.login, u.statut as user_status,";
965 $sql .=
" sr.iban_prefix as iban, sr.bic as bic";
966 $sql .=
" FROM ".$db->prefix().
"prelevement_demande as pfd";
967 $sql .=
" LEFT JOIN ".$db->prefix().
"user as u on pfd.fk_user_demande = u.rowid";
968 $sql .=
" LEFT JOIN ".$db->prefix().
"prelevement_bons as pb ON pb.rowid = pfd.fk_prelevement_bons";
969 $sql .=
" LEFT JOIN ".$db->prefix().
"societe_rib as sr ON sr.rowid = pfd.fk_societe_rib";
970 if ($type ==
'bank-transfer') {
971 $sql .=
" WHERE fk_facture_fourn = ".((int)
$object->id);
973 $sql .=
" WHERE fk_facture = ".((int)
$object->id);
975 $sql .=
" AND pfd.traite = 0";
976 $sql .=
" AND pfd.type = 'ban'";
977 $sql .=
" ORDER BY pfd.date_demande DESC";
979 $resql = $db->query($sql);
985 $tmpuser =
new User($db);
987 $num = $db->num_rows($resql);
989 $obj = $db->fetch_object($resql);
991 $tmpuser->id = $obj->user_id;
992 $tmpuser->login = $obj->login;
993 $tmpuser->ref = $obj->login;
994 $tmpuser->email = $obj->email;
995 $tmpuser->lastname = $obj->lastname;
996 $tmpuser->firstname = $obj->firstname;
997 $tmpuser->status = $obj->user_status;
999 print
'<tr class="oddeven">';
1002 if (
$conf->main_checkbox_left_column) {
1003 print
'<td class="center">';
1004 print
'<a href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=delete&token='.
newToken().
'&did='.$obj->rowid.
'&type='.urlencode($type).
'">';
1011 print
'<td class="nowraponall">'.$obj->rowid.
"</td>\n";
1014 print
'<td class="nowraponall">'.dol_print_date($db->jdate($obj->date_demande),
'dayhour').
"</td>\n";
1017 print
'<td class="tdoverflowmax125">';
1018 print $tmpuser->getNomUrl(-1,
'', 0, 0, 0, 0,
'login');
1022 print
'<td class="center"><span class="amount">'.price($obj->amount).
'</span></td>';
1025 print
'<td class="center"><span class="iban">';
1027 if ($obj->iban && $obj->bic) {
1031 print
'</span></td>';
1034 print
'<td class="center"><span class="opacitymedium">'.$langs->trans(
"OrderWaiting").
'</span></td>';
1037 print
'<td class="minwidth75">';
1038 if ($obj->fk_prelevement_bons > 0) {
1040 $withdrawreceipt->id = $obj->fk_prelevement_bons;
1041 $withdrawreceipt->ref = $obj->ref;
1042 $withdrawreceipt->date_trans = $db->jdate($obj->date_trans);
1043 $withdrawreceipt->date_credit = $db->jdate($obj->date_credit);
1044 $withdrawreceipt->date_creation = $db->jdate($obj->datec);
1045 $withdrawreceipt->statut = $obj->status;
1046 $withdrawreceipt->status = $obj->status;
1047 $withdrawreceipt->amount = $obj->pb_amount;
1050 print $withdrawreceipt->getNomUrl(1);
1053 if ($type !=
'bank-transfer') {
1055 $langs->load(
"stripe");
1056 if ($obj->fk_prelevement_bons > 0) {
1059 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>';
1063 $langs->load(
"stripe");
1064 if ($obj->fk_prelevement_bons > 0) {
1067 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>';
1073 print
'<td class="">';
1078 if (!
$conf->main_checkbox_left_column) {
1079 print
'<td class="center">';
1080 print
'<a href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&action=delete&token='.
newToken().
'&did='.$obj->rowid.
'&type='.urlencode($type).
'">';
1091 dol_print_error($db);
1097 $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,";
1098 $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,";
1099 $sql .=
" u.rowid as user_id, u.email, u.lastname, u.firstname, u.login, u.statut as user_status, u.photo as user_photo,";
1100 $sql .=
" sr.iban_prefix as iban, sr.bic as bic";
1101 $sql .=
" FROM ".$db->prefix().
"prelevement_demande as pfd";
1102 $sql .=
" LEFT JOIN ".$db->prefix().
"user as u on pfd.fk_user_demande = u.rowid";
1103 $sql .=
" LEFT JOIN ".$db->prefix().
"prelevement_bons as pb ON pb.rowid = pfd.fk_prelevement_bons";
1104 $sql .=
" LEFT JOIN ".$db->prefix().
"societe_rib as sr ON sr.rowid = pfd.fk_societe_rib";
1105 if ($type ==
'bank-transfer') {
1106 $sql .=
" WHERE fk_facture_fourn = ".((int)
$object->id);
1108 $sql .=
" WHERE fk_facture = ".((int)
$object->id);
1110 $sql .=
" AND pfd.traite = 1";
1111 $sql .=
" AND pfd.type = 'ban'";
1113 $sql .=
" ORDER BY pfd.date_demande DESC";
1115 $resql = $db->query($sql);
1117 $num = $db->num_rows($resql);
1121 $tmpuser =
new User($db);
1124 $obj = $db->fetch_object($resql);
1126 $tmpuser->id = $obj->user_id;
1127 $tmpuser->login = $obj->login;
1128 $tmpuser->ref = $obj->login;
1129 $tmpuser->email = $obj->email;
1130 $tmpuser->lastname = $obj->lastname;
1131 $tmpuser->firstname = $obj->firstname;
1132 $tmpuser->status = $obj->user_status;
1133 $tmpuser->photo = $obj->user_photo;
1135 print
'<tr class="oddeven">';
1138 if (
$conf->main_checkbox_left_column) {
1139 print
'<td> </td>';
1143 print
'<td class="nowraponall">'.$obj->rowid.
"</td>\n";
1146 print
'<td class="nowraponall">'.dol_print_date($db->jdate($obj->date_demande),
'day',
'tzuserrel').
"</td>\n";
1149 print
'<td class="tdoverflowmax125">';
1150 print $tmpuser->getNomUrl(-1,
'', 0, 0, 0, 0,
'login');
1154 print
'<td class="center"><span class="amount">'.price($obj->amount).
'</span></td>';
1157 print
'<td class="center"><span class="iban">';
1159 if ($obj->iban && $obj->bic) {
1163 print
'</span></td>';
1166 print
'<td class="center nowraponall">'.dol_print_date($db->jdate($obj->date_traite),
'dayhour',
'tzuserrel').
"</td>\n";
1169 print
'<td class="minwidth75">';
1170 if ($obj->fk_prelevement_bons > 0) {
1172 $withdrawreceipt->id = $obj->fk_prelevement_bons;
1173 $withdrawreceipt->ref = $obj->ref;
1174 $withdrawreceipt->date_trans = $db->jdate($obj->date_trans);
1175 $withdrawreceipt->date_credit = $db->jdate($obj->date_credit);
1176 $withdrawreceipt->date_creation = $db->jdate($obj->datec);
1177 $withdrawreceipt->statut = $obj->status;
1178 $withdrawreceipt->status = $obj->status;
1179 $withdrawreceipt->fk_bank_account = $obj->fk_bank_account;
1180 $withdrawreceipt->amount = $obj->pb_amount;
1183 print $withdrawreceipt->getNomUrl(1);
1185 print $withdrawreceipt->getLibStatut(2);
1188 $fk_bank_account = $withdrawreceipt->fk_bank_account;
1189 if (empty($fk_bank_account)) {
1192 if ($fk_bank_account > 0) {
1193 $bankaccount =
new Account($db);
1194 $result = $bankaccount->fetch($fk_bank_account);
1197 print $bankaccount->getNomUrl(1);
1200 if (!empty($obj->ext_payment_id) || !empty($obj->ext_payment_site)) {
1201 print
' - <span class="small opacitymedium">';
1202 print $obj->ext_payment_id.
'/'.$obj->ext_payment_site;
1209 print
'<td> </td>';
1212 if (!
$conf->main_checkbox_left_column) {
1213 print
'<td> </td>';
1220 if (!$numopen && !$numclosed) {
1221 print
'<tr class="oddeven"><td colspan="9"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
1226 dol_print_error($db);
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
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.
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 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 projects.
Class to manage Dolibarr users.
facturefourn_prepare_head(FactureFournisseur $object)
Prepare array with list of tabs.
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...
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
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.
getDolOptimizeSmallScreen()
Return if render must be optimized for small screen.
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.
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.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
facture_prepare_head($object)
Initialize the array of tabs for customer invoice.
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.
dolDecrypt($chain, $key='', $patterntotest='')
Decode a string with a symmetric encryption.