33require
'../../main.inc.php';
41require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/class/paiement.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/core/modules/facture/modules_facture.php';
44require_once DOL_DOCUMENT_ROOT.
'/core/lib/payments.lib.php';
46 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
49 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formmargin.class.php';
53$langs->loadLangs(array(
'bills',
'banks',
'companies'));
57$action =
GETPOST(
'action',
'aZ09');
58$confirm =
GETPOST(
'confirm',
'alpha');
59$backtopage =
GETPOST(
'backtopage',
'alpha');
68$hookmanager->initHooks(array(
'paymentcard',
'globalcard'));
71include DOL_DOCUMENT_ROOT.
'/core/actions_fetchobject.inc.php';
77 $socid = $user->socid;
81if ($socid && $socid !=
$object->thirdparty->id) {
90 require_once DOL_DOCUMENT_ROOT.
'/stripe/class/stripe.class.php';
92 $service =
'StripeTest';
95 $service =
'StripeLive';
100 global $stripearrayofkeysbyenv;
101 $site_account = $stripearrayofkeysbyenv[$servicestatus][
'publishable_key'];
104 $stripeacc = $stripe->getStripeAccount($service);
112$parameters = array(
'socid' => $socid);
113$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
118if (empty($reshook)) {
119 if ($action ==
'setnote' && $user->hasRight(
'facture',
'paiement')) {
132 if ($action ==
'confirm_delete' && $confirm ==
'yes' && $user->hasRight(
'facture',
'paiement')) {
135 $result =
$object->delete($user);
140 header(
"Location: ".$backtopage);
143 header(
"Location: list.php");
147 $langs->load(
"errors");
153 if ($action ==
'confirm_validate' && $confirm ==
'yes' && $user->hasRight(
'facture',
'paiement')) {
156 if (
$object->validate($user) > 0) {
161 $outputlangs = $langs;
162 if (
GETPOST(
'lang_id',
'aZ09')) {
164 $outputlangs->setDefaultLang(
GETPOST(
'lang_id',
'aZ09'));
171 $sql =
'SELECT f.rowid as facid';
172 $sql .=
' FROM '.MAIN_DB_PREFIX.
'paiement_facture as pf,'.MAIN_DB_PREFIX.
'facture as f,'.MAIN_DB_PREFIX.
'societe as s';
173 $sql .=
' WHERE pf.fk_facture = f.rowid';
174 $sql .=
' AND f.fk_soc = s.rowid';
175 $sql .=
' AND f.entity IN ('.getEntity(
'invoice').
')';
176 $sql .=
' AND pf.fk_paiement = '.((int)
$object->id);
177 $resql =
$db->query($sql);
180 $num =
$db->num_rows($resql);
184 $objp =
$db->fetch_object($resql);
188 if ($invoice->fetch($objp->facid) <= 0) {
194 if ($invoice->generateDocument($invoice->model_pdf, $outputlangs, $hidedetails, $hidedesc, $hideref) < 0) {
212 header(
'Location: '.$_SERVER[
'PHP_SELF'].
'?id='.
$object->id);
218 $langs->load(
"errors");
223 if ($action ==
'setnum_paiement' &&
GETPOST(
'num_paiement') && $user->hasRight(
'facture',
'paiement')) {
226 setEventMessages($langs->trans(
'PaymentNumberUpdateSucceeded'),
null,
'mesgs');
228 setEventMessages($langs->trans(
'PaymentNumberUpdateFailed'),
null,
'errors');
232 if ($action ==
'setdatep' &&
GETPOST(
'datepday') && $user->hasRight(
'facture',
'paiement')) {
234 $res =
$object->update_date($datepaye);
236 setEventMessages($langs->trans(
'PaymentDateUpdateSucceeded'),
null,
'mesgs');
242 if ($action ==
'createbankpayment' && $user->hasRight(
'facture',
'paiement')) {
247 $label =
'(CustomerInvoicePayment)';
249 $label =
'(CustomerInvoicePaymentBack)';
253 if ($bankaccountid > 0) {
257 $result =
$object->addPaymentToBank($user,
'payment', $label, $bankaccountid,
'',
'');
263 setEventMessages($langs->trans(
"ErrorFieldRequired", $langs->transnoentitiesnoconv(
"BankAccount")),
null,
'errors');
284$result =
$object->fetch($id, $ref);
292$head = payment_prepare_head($object);
294print
dol_get_fiche_head($head,
'payment', $langs->trans(
"PaymentCustomerInvoice"), -1,
'payment');
297if ($action ==
'delete') {
298 print $form->formconfirm($_SERVER[
'PHP_SELF'].
'?id='.
$object->id, $langs->trans(
"DeletePayment"), $langs->trans(
"ConfirmDeletePayment"),
'confirm_delete',
'', 0, 2);
302if ($action ==
'valide') {
304 print $form->formconfirm($_SERVER[
'PHP_SELF'].
'?id='.
$object->id.
'&facid='.((
int) $facid), $langs->trans(
"ValidatePayment"), $langs->trans(
"ConfirmValidatePayment"),
'confirm_validate',
'', 0, 2);
307$linkback =
'<a href="'.DOL_URL_ROOT.
'/compta/paiement/list.php?restore_lastsearch_values=1">'.$langs->trans(
"BackToList").
'</a>';
309dol_banner_tab($object,
'ref', $linkback, 1,
'ref',
'ref',
'');
312print
'<div class="fichecenter">';
313print
'<div class="underbanner clearboth"></div>';
315print
'<table class="border tableforfield centpercent">'.
"\n";
318print
'<tr><td class="titlefield">'.$form->editfieldkey(
"Date",
'datep',
$object->date, $object, $user->hasRight(
'facture',
'paiement')).
'</td><td>';
319print $form->editfieldval(
"Date",
'datep',
$object->date, $object, $user->hasRight(
'facture',
'paiement'),
'datehourpicker',
'',
null, $langs->trans(
'PaymentDateUpdateSucceeded'),
'', 0,
'',
'id',
'tzuser');
323$labeltype = $langs->trans(
"PaymentType".
$object->type_code) !=
"PaymentType".$object->type_code ? $langs->trans(
"PaymentType".
$object->type_code) :
$object->type_label;
324print
'<tr><td>'.$langs->trans(
'PaymentMode').
'</td><td>'.$labeltype;
325print
$object->num_payment ?
' - '.$object->num_payment :
'';
329print
'<tr><td>'.$langs->trans(
'Amount').
'</td><td>'.
price(
$object->amount, 0, $langs, 0, -1, -1,
$conf->currency).
'</td></tr>';
339 $bankline->fetch(
$object->bank_line);
340 if ($bankline->rappro) {
342 $title_button =
dol_escape_htmltag($langs->transnoentitiesnoconv(
"CantRemoveConciliatedPayment"));
346 print
'<td>'.$langs->trans(
'BankAccount').
'</td>';
349 $accountstatic->fetch($bankline->fk_account);
350 print $accountstatic->getNomUrl(1);
379 if (
$object->type_code ==
'CHQ' && $bankline->fk_bordereau > 0) {
380 include_once DOL_DOCUMENT_ROOT.
'/compta/paiement/cheque/class/remisecheque.class.php';
382 $bordereau->fetch($bankline->fk_bordereau);
385 print
'<td>'.$langs->trans(
'CheckReceipt').
'</td>';
387 print $bordereau->getNomUrl(1);
394 print
'<td>'.$langs->trans(
'BankTransactionLine').
'</td>';
396 if (
$object->fk_account > 0 && $bankline !==
null) {
397 print $bankline->getNomUrl(1, 0,
'showconciliatedandaccounted');
399 $langs->load(
"admin");
400 print
'<span class="opacitymedium">';
401 print $langs->trans(
"NoRecordFoundIBankcAccount", $langs->transnoentitiesnoconv(
"Module85Name"));
403 if ($user->hasRight(
'facture',
'paiement')) {
406 $amountofpayments =
$object->getAmountsArray();
407 $bankaccountidofinvoices =
null;
408 foreach ($amountofpayments as $idinvoice => $amountofpayment) {
410 $tmpinvoice->fetch($idinvoice);
411 if ($tmpinvoice->fk_account > 0 && $bankaccountidofinvoices !== 0) {
412 if (is_null($bankaccountidofinvoices)) {
413 $bankaccountidofinvoices = $tmpinvoice->fk_account;
414 } elseif ($bankaccountidofinvoices != $tmpinvoice->fk_account) {
415 $bankaccountidofinvoices = 0;
420 print
'<form method="POST" name="createbankpayment">';
421 print
'<input type="hidden" name="token" value="'.newToken().
'">';
422 print
'<input type="hidden" name="action" value="createbankpayment">';
423 print
'<input type="hidden" name="id" value="'.$object->id.
'">';
424 print
' '.$langs->trans(
"ToCreateRelatedRecordIntoBank").
': ';
425 print $form->select_comptes($bankaccountidofinvoices,
'accountid', 0,
'', 2,
'', 0,
'', 1);
427 print
'<input type="submit" class="button small smallpaddingimp" name="createbankpayment" value="'.$langs->trans(
"ClickHere").
'">';
437print
'<tr><td class="'.($user->hasRight(
'facture',
'paiement') ?
'tdtop' :
'').
'">'.$form->editfieldkey(
"Comments",
'note',
$object->note_private, $object, $user->hasRight(
'facture',
'paiement'),
'string',
'', 0, 0).
'</td><td class="wordbreak">';
438print $form->editfieldval(
"Note",
'note',
$object->note_private, $object, $user->hasRight(
'facture',
'paiement'),
'textarea:'.ROWS_3.
':90%');
441if (!empty(
$object->ext_payment_id)) {
443 print
'<tr><td class="tdtop">'.$langs->trans(
"StripePaymentId").
'</td><td class="wordbreak">';
444 if (
isModEnabled(
'stripe') && in_array(
$object->ext_payment_site, array(
'Stripe',
'StripeLive'))) {
445 $tmp1 = explode(
'@',
$object->ext_payment_id);
446 $site_account_payment =
'';
447 if (!empty($tmp1[1])) {
448 $site_account_payment = $tmp1[1];
450 $tmp2 = explode(
':', $tmp1[0]);
451 if (!empty($tmp2[1])) {
452 $stripecu = $tmp2[1];
458 if (!empty($stripeacc)) {
459 $connect = $stripeacc.
'/';
463 $url =
'https://dashboard.stripe.com/'.$connect.($object->ext_payment_site ==
'Stripe' ?
'test/' :
'').
'customers/'.$stripecu;
464 if (!empty($stripearrayofkeysbyenv[1][
'publishable_key']) && $stripearrayofkeysbyenv[1][
'publishable_key'] == $site_account_payment) {
465 $url =
'https://dashboard.stripe.com/'.$connect.
'customers/'.$stripecu;
468 $url =
'https://dashboard.stripe.com/'.($object->ext_payment_site ==
'Stripe' ?
'test/' :
'').
'payments/'.
$object->ext_payment_id;
471 print
' <a href="'.$url.
'" target="_stripe">'.
img_picto($langs->trans(
'ShowInStripe').
' - Publishable key = '.$site_account_payment,
'globe').
'</a>';
480include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_view.tpl.php';
483$parameters = array();
484$reshook = $hookmanager->executeHooks(
'formObjectOptions', $parameters, $object, $action);
485print $hookmanager->resPrint;
498$sql =
'SELECT f.rowid as facid, f.ref, f.type, f.total_ttc, f.paye, f.entity, f.fk_statut, pf.amount, s.nom as name, s.rowid as socid';
499$sql .=
' FROM '.MAIN_DB_PREFIX.
'paiement_facture as pf,'.MAIN_DB_PREFIX.
'facture as f,'.MAIN_DB_PREFIX.
'societe as s';
500$sql .=
' WHERE pf.fk_facture = f.rowid';
501$sql .=
' AND f.fk_soc = s.rowid';
502$sql .=
' AND f.entity IN ('.getEntity(
'invoice').
')';
503$sql .=
' AND pf.fk_paiement = '.((int)
$object->id);
504$resql =
$db->query($sql);
506 $num =
$db->num_rows($resql);
513 print
'<div class="div-table-responsive">';
514 print
'<table class="noborder centpercent">';
516 print
'<tr class="liste_titre">';
517 print
'<td>'.$langs->trans(
'Bill').
'</td>';
518 print
'<td>'.$langs->trans(
'Company').
'</td>';
520 print
'<td>'.$langs->trans(
'Entity').
'</td>';
524 print
'<td class="right">'.$langs->trans(
'Margin').
'</td>';
526 print
'<td class="right">'.$langs->trans(
'ExpectedToPay').
'</td>';
527 print
'<td class="right">'.$langs->trans(
'PayedByThisPayment').
'</td>';
528 print
'<td class="right">'.$langs->trans(
'RemainderToPay').
'</td>';
529 print
'<td class="right">'.$langs->trans(
'Status').
'</td>';
531 $parameters = array();
532 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
538 $objp =
$db->fetch_object($resql);
540 $thirdpartystatic->fetch($objp->socid);
543 $invoice->fetch($objp->facid);
549 $marginInfo = array();
550 $invoice->fetch_lines();
551 $marginInfo = $formmargin->getMarginInfosArray($invoice);
554 $paiement = $invoice->getSommePaiement();
555 $creditnotes = $invoice->getSumCreditNotesUsed();
556 $deposits = $invoice->getSumDepositsUsed();
557 $alreadypaid =
price2num($paiement + $creditnotes + $deposits,
'MT');
558 $remaintopay =
price2num($invoice->total_ttc - $paiement - $creditnotes - $deposits,
'MT');
560 print
'<tr class="oddeven">';
563 print
'<td class="tdoverflowmax150">';
564 print $invoice->getNomUrl(1);
568 print
'<td class="tdoverflowmax150">';
569 print $thirdpartystatic->getNomUrl(1);
575 $mc->getInfo($objp->entity);
582 print
'<td class="right">'.price($marginInfo[
'total_margin']).
'</td>';
586 print
'<td class="right"><span class="amount">'.price($objp->total_ttc).
'</span></td>';
589 print
'<td class="right"><span class="amount">'.price($objp->amount).
'</span></td>';
592 print
'<td class="right"><span class="amount">'.price($remaintopay).
'</span></td>';
595 print
'<td class="right">'.$invoice->getLibStatut(5, (
float) $alreadypaid).
'</td>';
597 $parameters = array(
'fk_paiement' => (
int)
$object->id);
598 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $objp, $action);
603 if ($objp->paye == 1 && !
getDolGlobalString(
'INVOICE_CAN_DELETE_PAYMENT_EVEN_IF_INVOICE_CLOSED')) {
605 $title_button =
dol_escape_htmltag($langs->transnoentitiesnoconv(
"CantRemovePaymentWithOneInvoicePaid"));
608 $total += $objp->amount;
628print
'<div class="tabsAction">';
631 if ($user->socid == 0 &&
$object->statut == 0 && $action ==
'') {
632 if ($user->hasRight(
'facture',
'paiement')) {
633 print
'<a class="butAction" href="'.$_SERVER[
'PHP_SELF'].
'?id='.
$id.
'&action=valide&token='.newToken().
'">'.$langs->trans(
'Valid').
'</a>';
639if (! empty($title_button)) {
640 $params[
'attr'] = array(
'title' => $title_button);
643if ($user->socid == 0 && $action ==
'') {
644 print dolGetButtonAction($langs->trans(
"Delete"),
'',
'delete', $_SERVER[
"PHP_SELF"].
'?id='.
$object->id.
'&action=delete&token='.newToken(),
'delete', $user->hasRight(
'facture',
'paiement') && !$disable_delete, $params);
$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.
Class to manage bank accounts.
Class to manage bank transaction lines.
Class to manage invoices.
const TYPE_CREDIT_NOTE
Credit note invoice.
Class to manage payments of customer invoices.
Class to manage cheque delivery receipts.
Class to manage third parties objects (customers, suppliers, prospects...)
Stripe class @TODO No reason to extend CommonObject.
Class to manage translations.
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)
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.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
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.
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
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.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.