34require_once DOL_DOCUMENT_ROOT .
'/core/class/commonobject.class.php';
35require_once DOL_DOCUMENT_ROOT .
'/core/lib/bank.lib.php';
36require_once DOL_DOCUMENT_ROOT .
'/compta/bank/class/account.class.php';
37require_once DOL_DOCUMENT_ROOT .
'/compta/facture/class/facture.class.php';
38require_once DOL_DOCUMENT_ROOT .
'/compta/paiement/class/paiement.class.php';
39require_once DOL_DOCUMENT_ROOT .
'/fourn/class/fournisseur.facture.class.php';
40require_once DOL_DOCUMENT_ROOT .
'/fourn/class/paiementfourn.class.php';
41require_once DOL_DOCUMENT_ROOT .
'/salaries/class/salary.class.php';
42require_once DOL_DOCUMENT_ROOT .
'/salaries/class/paymentsalary.class.php';
43require_once DOL_DOCUMENT_ROOT .
'/societe/class/societe.class.php';
44require_once DOL_DOCUMENT_ROOT .
'/user/class/userbankaccount.class.php';
55 public $element =
'widthdraw';
60 public $table_element =
'prelevement_bons';
65 public $picto =
'payment';
70 public $date_echeance;
74 public $raison_sociale;
78 public $reference_remise;
82 public $emetteur_code_guichet;
86 public $emetteur_numero_compte;
90 public $emetteur_code_banque;
94 public $emetteur_number_key;
98 public $sepa_xml_pti_in_ctti;
103 public $emetteur_iban;
107 public $emetteur_bic;
111 public $emetteur_ics;
116 public $sepa_schema_version =
'2';
137 public $labelStatus = array();
142 public $factures = array();
147 public $methodes_trans = array();
152 public $invoice_in_error = array();
157 public $thirdparty_in_error = array();
169 const STATUS_DRAFT = 0;
170 const STATUS_TRANSFERED = 1;
171 const STATUS_CREDITED = 2;
172 const STATUS_DEBITED = 2;
173 const STATUS_CANCELED = 9;
219 public $fields = array(
220 'rowid' => array(
'type' =>
'integer',
'label' =>
'TechnicalID',
'enabled' => 1,
'position' => 10,
'notnull' => 1,
'visible' => 0,),
221 'ref' => array(
'type' =>
'varchar(12)',
'label' =>
'Ref',
'enabled' => 1,
'position' => 15,
'notnull' => 0,
'visible' => -1,
'csslist' =>
'tdoverflowmax150',
'showoncombobox' => 1,),
222 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreation',
'enabled' => 1,
'position' => 25,
'notnull' => 0,
'visible' => -1,),
223 'amount' => array(
'type' =>
'double(24,8)',
'label' =>
'Amount',
'enabled' => 1,
'position' => 30,
'notnull' => 0,
'visible' => -1,),
224 'statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Statut',
'enabled' => 1,
'position' => 500,
'notnull' => 0,
'visible' => -1,
'arrayofkeyval' => array(0 =>
'Wait', 1 =>
'Transfered', 2 =>
'Credited')),
225 'credite' => array(
'type' =>
'smallint(6)',
'label' =>
'Credite',
'enabled' => 1,
'position' => 40,
'notnull' => 0,
'visible' => -1,),
226 'note' => array(
'type' =>
'text',
'label' =>
'Note',
'enabled' => 1,
'position' => 45,
'notnull' => 0,
'visible' => -1,),
227 'date_trans' => array(
'type' =>
'datetime',
'label' =>
'TransData',
'enabled' => 1,
'position' => 50,
'notnull' => 0,
'visible' => -1,),
228 'method_trans' => array(
'type' =>
'smallint(6)',
'label' =>
'Methodtrans',
'enabled' => 1,
'position' => 55,
'notnull' => 0,
'visible' => -1,),
229 'fk_user_trans' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserTransfer',
'enabled' => 1,
'position' => 60,
'notnull' => 0,
'visible' => -1,
'css' =>
'maxwidth500 widthcentpercentminusxx',
'csslist' =>
'tdoverflowmax150',),
230 'date_credit' => array(
'type' =>
'datetime',
'label' =>
'CreditDate',
'enabled' => 1,
'position' => 65,
'notnull' => 0,
'visible' => -1,),
231 'fk_user_credit' => array(
'type' =>
'integer:User:user/class/user.class.php',
'label' =>
'UserCredit',
'enabled' => 1,
'position' => 70,
'notnull' => 0,
'visible' => -1,
'css' =>
'maxwidth500 widthcentpercentminusxx',
'csslist' =>
'tdoverflowmax150',),
232 'type' => array(
'type' =>
'varchar(16)',
'label' =>
'Type',
'enabled' => 1,
'position' => 75,
'notnull' => 0,
'visible' => -1,),
233 'fk_bank_account' => array(
'type' =>
'integer',
'label' =>
'BankAccount',
'enabled' => 1,
'position' => 80,
'notnull' => 0,
'visible' => -1,
'css' =>
'maxwidth500 widthcentpercentminusxx',),
277 public $note_private;
286 public $method_trans;
290 public $fk_user_trans;
298 public $fk_user_credit;
306 public $fk_bank_account;
320 $this->filename =
'';
322 $this->date_echeance =
dol_now();
323 $this->raison_sociale =
"";
324 $this->reference_remise =
"";
326 $this->emetteur_code_guichet =
"";
327 $this->emetteur_numero_compte =
"";
328 $this->emetteur_code_banque =
"";
329 $this->emetteur_number_key =
"";
330 $this->sepa_schema_version =
'2';
331 $this->sepa_xml_pti_in_ctti =
false;
333 $this->emetteur_iban =
"";
334 $this->emetteur_bic =
"";
335 $this->emetteur_ics =
"";
337 $this->factures = array();
339 $this->methodes_trans = array(0 =>
'Internet', 2 =>
'Email', 3 =>
'Api');
364 public function addWithdrawDetail($invoice_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number, $number_key, $type =
'debit-order', $sourcetype =
'', $bic =
'', $iban =
'', $rum =
'', $id_prelevement_demande = 0)
373 $result = $this->
addline($line_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number, $number_key, $sourcetype, $bic, $iban, $rum, $id_prelevement_demande);
378 $sql =
"INSERT INTO " . MAIN_DB_PREFIX .
"prelevement (";
379 if ($type !=
'bank-transfer') {
380 $sql .=
"fk_facture";
382 if ($sourcetype ==
'salary') {
385 $sql .=
"fk_facture_fourn";
388 $sql .=
",fk_prelevement_lignes";
389 $sql .=
") VALUES (";
390 $sql .= ((int) $invoice_id);
391 $sql .=
", " . ((int) $line_id);
394 if ($this->db->query($sql)) {
398 $this->errors[] = get_class($this) .
"::addWithdrawDetail " . $this->db->lasterror;
399 dol_syslog(get_class($this) .
"::addWithdrawDetail Error $result");
403 $this->errors[] = get_class($this) .
"::addWithdrawDetail linedid Empty";
404 dol_syslog(get_class($this) .
"::addWithdrawDetail Error $result");
408 dol_syslog(get_class($this) .
"::addWithdrawDetail Error $result");
432 public function addline(&$line_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number, $number_key, $sourcetype =
'', $bic =
'', $iban =
'', $rum =
'', $id_prelevement_demande = 0)
442 $sql =
"SELECT rowid";
443 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_lignes";
444 $sql .=
" WHERE fk_prelevement_bons = " . ((int) $this->
id);
445 if ($sourcetype ==
'salary') {
446 $sql .=
" AND fk_soc = " . ((int) $client_id);
448 $sql .=
" AND fk_user = " . ((int) $client_id);
450 $sql .=
" AND code_banque = '" . $this->db->escape($code_banque) .
"'";
451 $sql .=
" AND code_guichet = '" . $this->db->escape($code_guichet) .
"'";
452 $sql .=
" AND number = '" . $this->db->escape($number) .
"'";
454 $resql = $this->db->query($sql);
456 $num = $this->db->num_rows($resql);
464 $sql =
"INSERT INTO " . MAIN_DB_PREFIX .
"prelevement_lignes (";
465 $sql .=
"fk_prelevement_bons";
467 $sql .=
", client_nom";
469 $sql .=
", fk_prelevement_demande";
470 $sql .= ($sourcetype ==
'salary' ?
", fk_user" :
"");
471 $sql .=
") VALUES (";
472 $sql .= ((int) $this->
id);
473 $sql .=
", " . (($sourcetype !=
'salary') ? ((
int) $client_id) :
"0");
474 $sql .=
", '" . $this->db->escape($client_nom) .
"'";
475 $sql .=
", " . ((float)
price2num($amount));
476 $sql .=
", " . ((int) $id_prelevement_demande);
477 $sql .= (($sourcetype ==
'salary') ?
", " . ((
int) $client_id) :
'');
479 if ($this->db->query($sql)) {
480 $line_id = $this->db->last_insert_id(MAIN_DB_PREFIX .
"prelevement_lignes");
483 $this->errors[] = get_class($this) .
"::addline Error -2 " . $this->db->lasterror;
484 dol_syslog(get_class($this) .
"::addline Error -2");
504 $errors[1027] = $langs->trans(
"DateInvalid");
506 return $errors[abs($error)] ??
'unknown error code';
516 public function fetch($rowid, $ref =
'')
518 $sql =
"SELECT p.rowid, p.ref, p.amount, p.note";
519 $sql .=
", p.datec as dc";
520 $sql .=
", p.date_trans as date_trans";
521 $sql .=
", p.method_trans, p.fk_user_trans";
522 $sql .=
", p.date_credit as date_credit";
523 $sql .=
", p.fk_user_credit";
525 $sql .=
", p.fk_bank_account";
526 $sql .=
", p.statut as status";
527 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_bons as p";
528 $sql .=
" WHERE p.entity IN (" .
getEntity(
'invoice') .
")";
530 $sql .=
" AND p.rowid = " . ((int) $rowid);
532 $sql .=
" AND p.ref = '" . $this->db->escape($ref) .
"'";
535 dol_syslog(get_class($this) .
"::fetch", LOG_DEBUG);
536 $result = $this->db->query($sql);
538 if ($this->db->num_rows($result)) {
539 $obj = $this->db->fetch_object($result);
541 $this->
id = $obj->rowid;
542 $this->
ref = $obj->ref;
543 $this->
amount = $obj->amount;
544 $this->note = $obj->note;
545 $this->note_private = $obj->note;
546 $this->datec = $this->db->jdate($obj->dc);
548 $this->date_trans = $this->db->jdate($obj->date_trans);
549 $this->method_trans = $obj->method_trans;
550 $this->user_trans = $obj->fk_user_trans;
552 $this->date_credit = $this->db->jdate($obj->date_credit);
553 $this->user_credit = $obj->fk_user_credit;
555 $this->
type = $obj->type;
556 $this->fk_bank_account = $obj->fk_bank_account;
558 $this->
status = $obj->status;
559 if (empty($this->
status)) {
562 $this->statut = $this->status;
568 dol_syslog(get_class($this) .
"::Fetch no record found");
601 global
$conf, $langs;
605 if ($this->fetched == 1) {
606 if ($date < $this->date_trans) {
607 $langs->load(
"errors");
608 $this->error = $langs->trans(
'ErrorDateOfMovementLowerThanDateOfFileTransmission');
609 dol_syslog(
"bon-prelevment::set_infocredit 1027 " . $this->error);
615 $sql =
" UPDATE " . MAIN_DB_PREFIX .
"prelevement_bons";
616 $sql .=
" SET fk_user_credit = " . ((int) $user->id);
617 $sql .=
", statut = " . self::STATUS_CREDITED;
618 $sql .=
", date_credit = '" . $this->db->idate($date) .
"'";
619 $sql .=
" WHERE rowid = " . ((int) $this->
id);
620 $sql .=
" AND entity = " . ((int)
$conf->entity);
621 $sql .=
" AND statut = " . self::STATUS_TRANSFERED;
623 $resql = $this->db->query($sql);
625 $langs->load(
'withdrawals');
626 $subject = $langs->trans(
"InfoCreditSubject", $this->
ref);
627 $message = $langs->trans(
"InfoCreditMessage", $this->
ref,
dol_print_date($date,
'dayhour'));
630 $fk_bank_account = $this->fk_bank_account;
631 if (empty($fk_bank_account)) {
636 $amountsperthirdparty = array();
646 for ($i = 0; $i < $num; $i++) {
647 if ($this->
type ==
'bank-transfer') {
648 if ($type ==
'salary') {
649 $fac =
new Salary($this->db);
657 $result = $fac->fetch($facs[$i][0]);
659 $amounts[$fac->id] = $facs[$i][1];
660 if ($this->
type ==
'bank-transfer') {
661 if ($type ==
'salary') {
662 $amountsperthirdparty[$fac->fk_user][$fac->id] = $facs[$i][1];
664 $amountsperthirdparty[$fac->socid][$fac->id] = $facs[$i][1];
667 $amountsperthirdparty[$fac->socid][$fac->id] = $facs[$i][1];
670 $totalpaid = $fac->getSommePaiement();
671 $totalcreditnotes = 0;
672 if (method_exists($fac,
'getSumCreditNotesUsed')) {
673 $totalcreditnotes = $fac->getSumCreditNotesUsed();
676 if (method_exists($fac,
'getSumDepositsUsed')) {
677 $totaldeposits = $fac->getSumDepositsUsed();
679 $alreadypayed = $totalpaid + $totalcreditnotes + $totaldeposits;
683 $amountofdocument = $fac->total_ttc;
684 if ($type ==
'salary') {
685 $amountofdocument = $fac->amount;
687 if (
price2num($alreadypayed + $facs[$i][1],
'MT') ==
price2num($amountofdocument,
'MT')) {
688 $result = $fac->setPaid($user);
690 $this->error = $fac->error;
691 $this->errors = $fac->errors;
697 foreach ($amountsperthirdparty as $thirdpartyid => $cursoramounts) {
698 if ($this->
type ==
'bank-transfer') {
699 if ($type ==
'salary') {
705 $paiement =
new Paiement($this->db);
707 $paiement->datepaye = $date;
708 $paiement->amounts = $cursoramounts;
710 if ($this->
type ==
'bank-transfer') {
711 if ($type ==
'salary') {
712 $paiement->datep = $date;
714 $paiement->paiementid = 2;
715 $paiement->fk_typepayment = 2;
716 $paiement->paiementcode =
'VIR';
718 $paiement->paiementid = 2;
719 $paiement->paiementcode =
'VIR';
722 $paiement->paiementid = 3;
723 $paiement->paiementcode =
'PRE';
726 $paiement->num_payment = $this->ref;
727 $paiement->id_prelevement = $this->id;
729 $result = $paiement->create($user, 1);
733 $this->error = $paiement->error;
734 $this->errors = $paiement->errors;
735 dol_syslog(get_class($this) .
"::set_infocredit AddPayment Error " . $this->error);
737 if ($this->
type ==
'bank-transfer') {
738 if ($type ==
'salary') {
739 $modeforaddpayment =
'payment_salary';
740 $labelforaddpayment =
'(SalaryPayment)';
741 $addbankurl =
'credit-transfer';
743 $modeforaddpayment =
'payment_supplier';
744 $labelforaddpayment =
'(SupplierInvoicePayment)';
745 $addbankurl =
'credit-transfer';
748 $modeforaddpayment =
'payment';
749 $labelforaddpayment =
'(CustomerInvoicePayment)';
750 $addbankurl =
'direct-debit';
756 $result = $paiement->addPaymentToBank($user, $modeforaddpayment, $labelforaddpayment, $fk_bank_account,
'',
'');
758 $result = $paiement->addPaymentToBank($user, $modeforaddpayment, $labelforaddpayment, $fk_bank_account,
'',
'', 0,
'', $addbankurl);
763 $this->error = $paiement->error;
764 $this->errors = $paiement->errors;
765 dol_syslog(get_class($this) .
"::set_infocredit AddPaymentToBank Error " . $this->error);
773 $sql =
" UPDATE " . MAIN_DB_PREFIX .
"prelevement_lignes";
774 $sql .=
" SET statut = 2";
775 $sql .=
" WHERE fk_prelevement_bons = " . ((int) $this->
id);
777 if (!$this->db->query($sql)) {
778 dol_syslog(get_class($this) .
"::set_infocredit Update lines Error");
783 $this->error = $this->db->lasterror();
784 dol_syslog(get_class($this) .
"::set_infocredit Update Bons Error");
790 $this->date_credit = $date;
791 $this->statut = self::STATUS_CREDITED;
792 $this->
status = self::STATUS_CREDITED;
797 $this->db->rollback();
817 global
$conf, $langs;
821 dol_syslog(get_class($this) .
"::set_infotrans Start", LOG_INFO);
823 if ($this->db->begin()) {
824 $sql =
"UPDATE " . MAIN_DB_PREFIX .
"prelevement_bons ";
825 $sql .=
" SET fk_user_trans = " . ((int) $user->id);
826 $sql .=
" , date_trans = '" . $this->db->idate($date) .
"'";
827 $sql .=
" , method_trans = " . ((int) $method);
828 $sql .=
" , statut = " . self::STATUS_TRANSFERED;
829 $sql .=
" WHERE rowid = " . ((int) $this->
id);
830 $sql .=
" AND entity = " . ((int)
$conf->entity);
831 $sql .=
" AND statut = " . self::STATUS_DRAFT;
833 if ($this->db->query($sql)) {
834 $this->method_trans = $method;
835 $langs->load(
'withdrawals');
836 $subject = $langs->trans(
"InfoTransSubject", $this->
ref);
837 $message = $langs->trans(
"InfoTransMessage", $this->
ref,
dolGetFirstLastname($user->firstname, $user->lastname));
838 $message .= $langs->trans(
"InfoTransData",
price($this->
amount), $this->methodes_trans[$this->method_trans],
dol_print_date($date,
'day'));
846 $this->date_trans = $date;
847 $this->statut = self::STATUS_TRANSFERED;
848 $this->
status = self::STATUS_TRANSFERED;
849 $this->user_trans = $user->id;
855 $this->db->rollback();
856 dol_syslog(get_class($this) .
"::set_infotrans ROLLBACK", LOG_ERR);
861 dol_syslog(get_class($this) .
"::set_infotrans Ouverture transaction SQL impossible", LOG_CRIT);
880 dol_syslog(get_class($this) .
"::getListInvoices");
884 if ($this->
type ==
'bank-transfer') {
885 if ($type ==
'salary') {
886 $sql .=
" p.fk_salary";
888 $sql .=
" p.fk_facture_fourn";
891 $sql .=
" p.fk_facture";
894 $sql .=
", SUM(pl.amount)";
896 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_bons as pb,";
897 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_lignes as pl,";
898 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement as p";
899 $sql .=
" WHERE p.fk_prelevement_lignes = pl.rowid";
900 $sql .=
" AND pl.fk_prelevement_bons = pb.rowid";
901 $sql .=
" AND pb.rowid = " . ((int) $this->
id);
902 $sql .=
" AND pb.entity = " . ((int)
$conf->entity);
904 if ($this->
type ==
'bank-transfer') {
905 if ($type ==
'salary') {
906 $sql .=
" GROUP BY p.fk_salary";
908 $sql .=
" GROUP BY p.fk_facture_fourn";
911 $sql .=
" GROUP BY p.fk_facture";
915 $resql = $this->db->query($sql);
917 $num = $this->db->num_rows($resql);
922 $row = $this->db->fetch_row($resql);
934 $this->db->free($resql);
936 $this->error = $this->db->lasterror();
953 $sql =
"SELECT sum(pd.amount) as nb";
954 if ($type !==
'salary') {
955 if ($mode !=
'bank-transfer') {
956 $sql .=
" FROM " . MAIN_DB_PREFIX .
"facture as f,";
958 $sql .=
" FROM " . MAIN_DB_PREFIX .
"facture_fourn as f,";
961 $sql .=
" FROM " . MAIN_DB_PREFIX .
"salary as s,";
963 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_demande as pd";
964 $sql .= ($type !==
'salary' ?
" WHERE f.entity IN (" .
getEntity(
'invoice') .
")" :
" WHERE s.entity IN (" .
getEntity(
'salary') .
")");
966 $sql .= ($type !==
'salary' ?
" AND f.fk_statut = " .
Facture::STATUS_VALIDATED :
" AND s.paye = " . Salary::STATUS_UNPAID);
968 if ($type !==
'salary') {
969 if ($mode !=
'bank-transfer') {
970 $sql .=
" AND f.rowid = pd.fk_facture";
972 $sql .=
" AND f.rowid = pd.fk_facture_fourn";
975 $sql .=
" AND s.rowid = pd.fk_salary";
977 $sql .= ($type !==
'salary' ?
" AND f.paye = 0" :
"");
978 $sql .=
" AND pd.traite = 0";
979 $sql .=
" AND pd.ext_payment_id IS NULL";
980 $sql .= ($type !==
'salary' ?
" AND f.total_ttc > 0" :
"");
982 $resql = $this->db->query($sql);
984 $obj = $this->db->fetch_object($resql);
986 $this->db->free($resql);
991 dol_syslog(get_class($this) .
"::SommeAPrelever Erreur -1");
1007 if ($type ===
'salary') {
1025 if ($forsalary == 1) {
1026 $sql =
"SELECT count(s.rowid) as nb";
1027 $sql .=
" FROM " . MAIN_DB_PREFIX .
"salary as s";
1029 $sql =
"SELECT count(f.rowid) as nb";
1031 if ($type ==
'bank-transfer') {
1032 $sql .=
" FROM " . MAIN_DB_PREFIX .
"facture_fourn as f";
1034 $sql .=
" FROM " . MAIN_DB_PREFIX .
"facture as f";
1037 $sql .=
", " . MAIN_DB_PREFIX .
"prelevement_demande as pd";
1038 if ($forsalary == 1) {
1039 $sql .=
" WHERE s.entity IN (" .
getEntity(
'invoice') .
")";
1041 $sql .=
" AND s.paye = 0";
1044 $sql .=
" WHERE f.entity IN (" .
getEntity(
'invoice') .
")";
1049 if ($forsalary == 1) {
1050 $sql .=
" AND s.rowid = pd.fk_salary";
1052 if ($type ==
'bank-transfer') {
1053 $sql .=
" AND f.rowid = pd.fk_facture_fourn";
1055 $sql .=
" AND f.rowid = pd.fk_facture";
1058 $sql .=
" AND pd.traite = 0";
1059 $sql .=
" AND pd.ext_payment_id IS NULL";
1060 if (!$forsalary == 1) {
1061 $sql .=
" AND f.total_ttc > 0";
1063 $sql .=
" AND s.paye = 0";
1066 dol_syslog(get_class($this) .
"::NbFactureAPrelever");
1067 $resql = $this->db->query($sql);
1070 $obj = $this->db->fetch_object($resql);
1071 $this->db->free($resql);
1075 $this->error = get_class($this) .
"::NbFactureAPrelever Erreur -1 sql=" . $this->db->error();
1105 public function create($banque =
'', $agence =
'', $mode =
'real', $format =
'FRST', $executiondate = 0, $notrigger = 0, $type =
'direct-debit', $dids = 0, $fk_bank_account = 0, $sourcetype =
'invoice')
1108 global
$conf, $langs, $user;
1110 dol_syslog(__METHOD__ .
" mode=".$mode.
" format=".$format.
" type=".$type.
" dids=".(is_array($dids) ? implode(
',', $dids) : $dids).
" fk_bank_account=".$fk_bank_account.
" sourcetype=".$sourcetype, LOG_DEBUG);
1112 require_once DOL_DOCUMENT_ROOT .
"/compta/facture/class/facture.class.php";
1113 require_once DOL_DOCUMENT_ROOT .
"/societe/class/societe.class.php";
1116 if ($type !=
'bank-transfer') {
1117 $format = strtoupper($format);
1118 if (empty($format)) {
1119 $this->error =
'ErrorBadParametersForDirectDebitFileCreate';
1122 if ($mode ===
'real' && !in_array($format, array(
'FRST',
'RCUR',
'OOFF',
'FNAL'),
true)) {
1123 $this->error =
'ErrorBadParametersForDirectDebitFileCreate';
1128 if (!is_int($dids) && !is_array($dids)) {
1129 $this->error =
'ErrorBadParametersForDirectDebitFileCreateDids';
1134 if (empty($fk_bank_account)) {
1135 $fk_bank_account = ($type ==
'bank-transfer' ?
getDolGlobalInt(
'PAYMENTBYBANKTRANSFER_ID_BANKACCOUNT') :
getDolGlobalInt(
'PRELEVEMENT_ID_BANKACCOUNT'));
1137 if (is_int($dids)) {
1138 $dids = array($dids);
1143 if ($sourcetype !=
'salary') {
1144 $entity = $type !=
'bank-transfer' ?
getEntity(
'invoice', 1) :
getEntity(
'supplier_invoice', 1);
1145 $sqlTable = $type !=
'bank-transfer' ?
"facture" :
"facture_fourn";
1146 $socOrUser =
'fk_soc';
1147 $societeOrUser =
'societe';
1150 $sqlTable =
'salary';
1151 $socOrUser =
'fk_user';
1152 $societeOrUser =
'user';
1183 $datetimeprev =
dol_now(
'gmt');
1185 if (!empty($executiondate)) {
1186 $datetimeprev = $executiondate;
1192 $this->invoice_in_error = array();
1193 $this->thirdparty_in_error = array();
1196 $factures = array();
1197 $factures_prev = array();
1198 $factures_prev_id = array();
1200 dol_syslog(__METHOD__ .
" Read invoices/salaries for dids=" . implode(
', ', $dids), LOG_DEBUG);
1202 $sql =
"SELECT f.rowid, pd.rowid as pfdrowid";
1203 $sql .=
", f.".$this->db->sanitize($socOrUser);
1204 $sql .=
", pd.code_banque, pd.code_guichet, pd.number, pd.cle_rib";
1205 $sql .=
", pd.amount";
1206 if ($sourcetype !=
'salary') {
1207 $sql .=
", s.nom as name";
1209 $sql .=
", sr.bic, sr.iban_prefix, sr.frstrecur, sr.default_rib, sr.rum";
1211 $sql .=
", CONCAT(s.firstname, ' ', s.lastname) as name";
1213 $sql .=
", sr.bic, sr.iban_prefix, 'FRST' as frstrecur, sr.default_rib, '' as rum";
1215 $sql .=
", pd.fk_societe_rib as soc_rib_id";
1216 $sql .=
" FROM " . $this->db->prefix() . $sqlTable .
" as f";
1217 $sql .=
" INNER JOIN " . $this->db->prefix() .
"prelevement_demande as pd ON f.rowid = pd.fk_".$this->db->sanitize($sqlTable);
1218 $sql .=
" LEFT JOIN " . $this->db->prefix() . $this->db->sanitize($societeOrUser).
" as s ON s.rowid = f.".$this->db->sanitize($socOrUser);
1219 $sql .=
" LEFT JOIN " . $this->db->prefix() . $this->db->sanitize($societeOrUser.
"_rib").
" as sr ON s.rowid = sr.".$this->db->sanitize($socOrUser);
1220 if ($sourcetype !=
'salary') {
1221 $sql .=
" AND sr.default_rib = 1";
1222 $sql .=
" AND sr.type = 'ban'";
1230 $sql .=
" WHERE f.entity IN (".((int) $entity).
')';
1231 if ($sourcetype !=
'salary') {
1232 $sql .=
" AND f.fk_statut = ".Facture::STATUS_VALIDATED;
1233 $sql .=
" AND f.paye = 0";
1234 $sql .=
" AND f.total_ttc > 0";
1240 $sql .=
" AND f.paye = 0";
1241 $sql .=
" AND f.amount > 0";
1243 $sql .=
" AND pd.traite = 0";
1244 $sql .=
" AND pd.ext_payment_id IS NULL";
1245 if ($dids !== [0] && !empty($dids)) {
1246 $sql .=
" AND pd.rowid IN (".$this->db->sanitize(implode(
',', $dids)).
")";
1249 $resql = $this->db->query($sql);
1251 $num = $this->db->num_rows($resql);
1255 $row = $this->db->fetch_row($resql);
1256 '@phan-var-force array<int<0,12>,string> $row';
1263 $factures[$i] = $row;
1266 $factures[$i][11] =
dolDecrypt($factures[$i][11]);
1270 dol_syslog(__METHOD__ .
" Read invoices/salaries error Found a null amount", LOG_WARNING);
1271 $this->invoice_in_error[$row[0]] =
"Error for invoice or salary id " . $row[0] .
", found a null amount";
1277 $this->db->free($resql);
1278 dol_syslog(__METHOD__ .
" Read invoices/salaries, " . $i .
" invoices/salaries to withdraw", LOG_DEBUG);
1280 $this->error = $this->db->lasterror();
1281 dol_syslog(__METHOD__ .
" Read invoices/salaries error " . $this->db->lasterror(), LOG_ERR);
1287 require_once DOL_DOCUMENT_ROOT .
'/societe/class/societe.class.php';
1288 require_once DOL_DOCUMENT_ROOT .
'/user/class/user.class.php';
1289 require_once DOL_DOCUMENT_ROOT .
'/societe/class/companybankaccount.class.php';
1290 require_once DOL_DOCUMENT_ROOT .
'/core/lib/bank.lib.php';
1292 $tmpsoc =
new Societe($this->db);
1293 $tmpuser =
new User($this->db);
1297 dol_syslog(__METHOD__ .
" Check BAN for each invoices or salaries", LOG_DEBUG);
1299 if (count($factures) > 0) {
1300 foreach ($factures as $key => $fac) {
1304 if ($fac[8] !=
null) {
1305 if ($type !=
'bank-transfer') {
1306 if ($format ==
'FRST' && $fac[12] && $fac[12] !=
'FRST') {
1309 if ($format ==
'RCUR' && $fac[12] && $fac[12] !=
'RCUR') {
1316 if (!empty($fac[15])) {
1318 $bankaccount->fetch((
int) $fac[15]);
1319 if ($bankaccount->id > 0) {
1320 $fac[3] = $bankaccount->code_banque;
1321 $fac[4] = $bankaccount->code_guichet;
1322 $fac[5] = $bankaccount->number;
1323 $fac[6] = $bankaccount->cle_rib;
1324 $fac[10] = $bankaccount->bic;
1325 $fac[11] = $bankaccount->iban;
1326 $fac[14] = $bankaccount->rum;
1331 $bicinloop = $fac[10];
1332 $baninloop = $fac[11];
1336 if ($verif || (empty($fac[10]) &&
getDolGlobalInt(
"WITHDRAWAL_WITHOUT_BIC"))) {
1337 dol_syslog(__METHOD__.
" now call checkIbanForAccount(null, ".$baninloop.
")");
1342 $factures_prev[$i] = $fac;
1344 $factures_prev_id[$i] = $fac[0];
1348 if ($type !=
'bank-transfer') {
1349 $tmpsoc->id = (int) $fac[2];
1350 $tmpsoc->name = $fac[8];
1351 $invoice_url =
"<a href='" . DOL_URL_ROOT .
'/compta/facture/card.php?facid=' . $fac[0] .
"'>" . $fac[9] .
"</a>";
1352 $this->invoice_in_error[$fac[0]] =
"Error incomplete properties of the default bank number ".$baninloop.
" IBAN/BIC for invoice " . $invoice_url .
" for thirdparty " . $tmpsoc->getNomUrl(0);
1353 $this->thirdparty_in_error[$tmpsoc->id] =
"Error on default bank number IBAN/BIC for invoice " . $invoice_url .
" for thirdparty " . $tmpsoc->getNomUrl(0);
1356 if ($type ==
'bank-transfer' && $sourcetype !=
'salary') {
1357 $tmpsoc->id = (int) $fac[2];
1358 $tmpsoc->name = $fac[8];
1359 $invoice_url =
"<a href='" . DOL_URL_ROOT .
'/fourn/facture/card.php?facid=' . $fac[0] .
"'>" . $fac[9] .
"</a>";
1360 $this->invoice_in_error[$fac[0]] =
"Error incomplete properties of the default bank number ".$baninloop.
" IBAN/BIC for invoice " . $invoice_url .
" for thirdparty " . $tmpsoc->getNomUrl(0);
1361 $this->thirdparty_in_error[$tmpsoc->id] =
"Error on default bank number IBAN/BIC for invoice " . $invoice_url .
" for thirdparty " . $tmpsoc->getNomUrl(0);
1364 if ($type ==
'bank-transfer' && $sourcetype ==
'salary') {
1365 $tmpuser->id = (int) $fac[2];
1366 $tmpuser->firstname = $fac[8];
1367 $salary_url =
"<a href='" . DOL_URL_ROOT .
'/salaries/card.php?id=' . $fac[0] .
"'>" . $fac[0] .
"</a>";
1368 $this->invoice_in_error[$fac[0]] =
"Error incomplete properties of the default bank number ".$baninloop.
" IBAN/BIC for salary " . $salary_url .
" for employee " . $tmpuser->getNomUrl(0);
1369 $this->thirdparty_in_error[$tmpuser->id] =
"Error on default bank number IBAN/BIC for salary " . $salary_url .
" for employee " . $tmpuser->getNomUrl(0);
1372 dol_syslog(__METHOD__ .
" Check BAN Error on default bank number IBAN/BIC reported by verif(): " . implode(
', ', $fac), LOG_WARNING);
1375 dol_syslog(__METHOD__ .
" Check BAN Failed to read company", LOG_WARNING);
1384 dol_syslog(__METHOD__ .
" Check BAN No invoice to process", LOG_WARNING);
1391 $out = count($factures_prev) .
" invoices or salaries will be included.";
1396 if (count($factures_prev) > 0) {
1397 if ($mode ==
'real') {
1400 print $langs->trans(
"ModeWarning");
1417 $ref = substr($year, -2) . $month;
1422 $sql =
"SELECT SUBSTRING(ref, 6) AS refnumber";
1423 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_bons";
1424 $sql .=
" WHERE ref LIKE '" . $this->db->escape($prefixt . $ref) .
"%'";
1425 $sql .=
" AND entity = " . ((int)
$conf->entity);
1426 $sql .=
" ORDER BY LENGTH(ref) DESC, ref DESC";
1429 dol_syslog(get_class($this) .
" get next free number", LOG_DEBUG);
1431 $resql = $this->db->query($sql);
1434 $row = $this->db->fetch_row($resql);
1437 $ref = $prefixt . $ref . sprintf(
"%03d", (intval($row[0] ?? 0) + 1));
1443 if ($type !=
'bank-transfer') {
1444 $dir =
$conf->prelevement->dir_output .
'/receipts';
1446 $dir =
$conf->paymentbybanktransfer->dir_output .
'/receipts';
1448 if (!is_dir($dir)) {
1453 $labelentity =
$conf->entity;
1454 $this->filename = $dir .
'/' . $ref .
'-' . $labelentity .
'.xml';
1456 $this->filename = $dir .
'/' . $ref .
'.xml';
1460 $sql =
"INSERT INTO " . MAIN_DB_PREFIX .
"prelevement_bons (";
1461 $sql .=
"ref, entity, datec, type, fk_bank_account";
1462 $sql .=
") VALUES (";
1463 $sql .=
"'" . $this->db->escape($ref) .
"'";
1464 $sql .=
", " . ((int)
$conf->entity);
1465 $sql .=
", '" . $this->db->idate($now) .
"'";
1466 $sql .=
", '" . ($type ==
'bank-transfer' ?
'bank-transfer' :
'debit-order') .
"'";
1467 $sql .=
", " . ((int) $fk_bank_account);
1470 $resql = $this->db->query($sql);
1473 $prev_id = $this->db->last_insert_id(MAIN_DB_PREFIX .
"prelevement_bons");
1474 $this->
id = $prev_id;
1478 $this->errors[] = $this->db->lasterror();
1479 dol_syslog(__METHOD__ .
" Create withdraw receipt " . $this->db->lasterror(), LOG_ERR);
1483 $this->errors[] = $this->db->lasterror();
1484 dol_syslog(__METHOD__ .
" Get last withdraw receipt " . $this->db->lasterror(), LOG_ERR);
1489 dol_syslog(__METHOD__ .
" Now loop on each document to insert them in llx_prelevement_demande");
1492 if (count($factures_prev) > 0) {
1493 foreach ($factures_prev as $fac) {
1537 $sql =
"UPDATE " . MAIN_DB_PREFIX .
"prelevement_demande";
1538 $sql .=
" SET traite = 1";
1539 $sql .=
", date_traite = '" . $this->db->idate($now) .
"'";
1540 $sql .=
", fk_prelevement_bons = " . ((int) $this->
id);
1541 $sql .=
" WHERE rowid = " . ((int) $fac[1]);
1543 $resql = $this->db->query($sql);
1546 $this->errors[] = $this->db->lasterror();
1547 dol_syslog(__METHOD__ .
" Update Error=" . $this->db->lasterror(), LOG_ERR);
1558 dol_syslog(__METHOD__ .
" Init direct debit or credit transfer file for " . count($factures_prev) .
" invoices", LOG_DEBUG);
1560 if (count($factures_prev) > 0) {
1561 $this->date_echeance = $datetimeprev;
1562 $this->reference_remise = $ref;
1564 $account =
new Account($this->db);
1565 if ($account->fetch($fk_bank_account) > 0) {
1566 $this->emetteur_code_banque = $account->code_banque;
1567 $this->emetteur_code_guichet = $account->code_guichet;
1568 $this->emetteur_numero_compte = $account->number;
1569 $this->emetteur_number_key = $account->cle_rib;
1570 $this->sepa_xml_pti_in_ctti = (bool) $account->pti_in_ctti;
1571 $this->emetteur_iban = $account->iban;
1572 $this->emetteur_bic = $account->bic;
1574 $this->emetteur_ics = (($type ==
'bank-transfer' &&
getDolGlobalString(
"SEPA_USE_IDS")) ? $account->ics_transfer : $account->ics);
1576 $this->raison_sociale = $account->owner_name;
1578 $this->factures = $factures_prev_id;
1579 $this->context[
'factures_prev'] = $factures_prev;
1583 if ($sourcetype ==
'salary') {
1584 $userid = $this->context[
'factures_prev'][0][2];
1586 $result = $this->
generate($format, $executiondate, $type, $fk_bank_account, $userid, 0);
1593 dol_syslog(__METHOD__ .
" Bank order file has been generated under filename " . $this->filename, LOG_DEBUG);
1601 $sql =
"UPDATE " . MAIN_DB_PREFIX .
"prelevement_bons";
1602 $sql .=
" SET amount = " .
price2num($this->total);
1603 $sql .=
" WHERE rowid = " . ((int) $this->
id);
1604 $sql .=
" AND entity = " . ((int)
$conf->entity);
1605 $resql = $this->db->query($sql);
1609 dol_syslog(__METHOD__ .
" Error update total: " . $this->db->error(), LOG_ERR);
1613 if (!$error && !$notrigger) {
1614 $triggerName = ($type ==
'bank-transfer') ?
'CREDIT_TRANSFER_ORDER_CREATE' :
'DIRECT_DEBIT_ORDER_CREATE';
1615 $this->
amount = $this->total;
1618 $result = $this->call_trigger($triggerName, $user);
1626 $this->db->commit();
1627 return count($factures_prev);
1629 $this->db->rollback();
1645 public function delete($user, $notrigger = 0)
1650 $resql1 = $resql2 = $resql3 = $resql4 = 0;
1653 $triggername =
'DIRECT_DEBIT_ORDER_DELETE';
1654 if ($this->
type ==
'bank-transfer') {
1655 $triggername =
'PAYMENTBYBANKTRANFER_DELETE';
1658 $result = $this->call_trigger($triggername, $user);
1666 $sql =
"DELETE FROM " . MAIN_DB_PREFIX .
"prelevement WHERE fk_prelevement_lignes IN (SELECT rowid FROM " . MAIN_DB_PREFIX .
"prelevement_lignes WHERE fk_prelevement_bons = " . ((int) $this->
id) .
")";
1667 $resql1 = $this->db->query($sql);
1669 dol_print_error($this->db);
1674 $sql =
"DELETE FROM " . MAIN_DB_PREFIX .
"prelevement_lignes WHERE fk_prelevement_bons = " . ((int) $this->
id);
1675 $resql2 = $this->db->query($sql);
1677 dol_print_error($this->db);
1682 $sql =
"DELETE FROM " . MAIN_DB_PREFIX .
"prelevement_bons WHERE rowid = " . ((int) $this->
id);
1683 $resql3 = $this->db->query($sql);
1685 dol_print_error($this->db);
1690 $sql =
"UPDATE " . MAIN_DB_PREFIX .
"prelevement_demande SET fk_prelevement_bons = NULL, traite = 0 WHERE fk_prelevement_bons = " . ((int) $this->
id);
1691 $resql4 = $this->db->query($sql);
1693 dol_print_error($this->db);
1697 if ($resql1 && $resql2 && $resql3 && $resql4 && !$error) {
1698 $this->db->commit();
1701 $this->db->rollback();
1717 public function getNomUrl($withpicto = 0, $option =
'', $notooltip = 0, $morecss =
'', $save_lastsearch_value = -1)
1719 global
$conf, $langs, $hookmanager;
1721 if (!empty(
$conf->dol_no_mouse_hover)) {
1727 $labeltoshow =
'PaymentByDirectDebit';
1728 $labelforclosedate =
'CreditDate';
1729 if (!empty($this->
type) && $this->
type ==
'bank-transfer') {
1730 $labeltoshow =
'PaymentByBankTransfer';
1731 $labelforclosedate =
'ClosedOn';
1734 $label = img_picto(
'', $this->picto) .
' <u>' . $langs->trans($labeltoshow) .
'</u> ' . $this->
getLibStatut(5);
1736 $label .=
'<b>' . $langs->trans(
'Ref') .
':</b> ' . $this->ref;
1737 if (isset($this->
amount)) {
1738 $label .=
'<br><b>' . $langs->trans(
"Amount") .
':</b> <span class="amount">' .
price($this->
amount).
'</span>';
1740 if (isset($this->date_creation)) {
1741 $label .=
'<br><b>'.$langs->trans(
"DateCreation").
":</b> ".
dol_print_date($this->date_creation,
'dayhour',
'tzuserrel');
1743 if (isset($this->date_trans)) {
1744 $label .=
'<br><b>' . $langs->trans(
"TransData") .
":</b> " .
dol_print_date($this->date_trans,
'dayhour',
'tzuserrel');
1746 if (isset($this->date_credit)) {
1747 $label .=
'<br><b>'.$langs->trans($labelforclosedate).
":</b> ".
dol_print_date($this->date_credit,
'dayhour',
'tzuserrel');
1750 $url = DOL_URL_ROOT .
'/compta/prelevement/card.php?id=' . $this->id;
1751 if (!empty($this->
type) && $this->
type ==
'bank-transfer') {
1752 $url = DOL_URL_ROOT .
'/compta/prelevement/card.php?id=' . $this->id;
1755 if ($option !=
'nolink') {
1757 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1758 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1759 $add_save_lastsearch_values = 1;
1761 if ($add_save_lastsearch_values) {
1762 $url .=
'&save_lastsearch_values=1';
1767 if (empty($notooltip)) {
1769 $label = $langs->trans(
"ShowMyObject");
1773 $linkclose .=
' class="classfortooltip' . ($morecss ?
' ' . $morecss :
'') .
'"';
1775 $linkclose = ($morecss ?
' class="' . $morecss .
'"' :
'');
1778 $linkstart =
'<a href="' . $url .
'"';
1779 $linkstart .= $linkclose .
'>';
1782 $result .= $linkstart;
1784 $result .= img_object(($notooltip ?
'' : $label), ($this->picto ? $this->picto :
'generic'), ($notooltip ? (($withpicto != 2) ?
'class="paddingright"' :
'') :
'class="' . (($withpicto != 2) ?
'paddingright ' :
'') .
'classfortooltip"'), 0, 0, $notooltip ? 0 : 1);
1786 if ($withpicto != 2) {
1787 $result .= $this->ref;
1789 $result .= $linkend;
1791 global $action, $hookmanager;
1792 $hookmanager->initHooks(array(
'banktransferdao'));
1793 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1794 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1796 $result = $hookmanager->resPrint;
1798 $result .= $hookmanager->resPrint;
1813 $sql =
"DELETE FROM " . MAIN_DB_PREFIX .
"notify_def";
1814 $sql .=
" WHERE rowid = " . ((int) $rowid);
1816 if ($this->db->query($sql)) {
1832 if (is_object($user)) {
1833 $userid = $user->id;
1838 $sql =
"DELETE FROM " . MAIN_DB_PREFIX .
"notify_def";
1839 $sql .=
" WHERE fk_user = " . ((int) $userid) .
" AND fk_action = " . ((int) $action);
1841 if ($this->db->query($sql)) {
1862 if (is_object($user)) {
1863 $userid = $user->id;
1871 $sql =
"INSERT INTO " . MAIN_DB_PREFIX .
"notify_def (datec, fk_user, fk_soc, fk_contact, fk_action)";
1872 $sql .=
" VALUES ('" . $this->db->idate($now) .
"', " . ((int) $userid) .
", NULL, NULL, " . ((int) $action) .
")";
1875 if ($this->db->query($sql)) {
1879 dol_syslog(get_class($this) .
"::addNotification Error $result");
1902 public function generate(
string $format =
'FRST',
int $executiondate = 0,
string $type =
'direct-debit',
int $fk_bank_account = 0,
int $forsalary = 0,
int $thirdpartyBANId = 0)
1906 $this->sepa_schema_version = (
getDolGlobalString(
'PRELEVEMENT_SEPA_SCHEMA_VERSION') ==
'8' ?
'8' :
'2');
1908 if ($type !==
'bank-transfer') {
1909 $format = strtoupper($format);
1910 if (!in_array($format, array(
'FRST',
'RCUR',
'OOFF',
'FNAL'),
true)) {
1911 $this->error =
'ErrorBadParametersForDirectDebitFileCreate';
1919 if (empty($fk_bank_account)) {
1920 $fk_bank_account = ($type ==
'bank-transfer' ?
getDolGlobalInt(
'PAYMENTBYBANKTRANSFER_ID_BANKACCOUNT') :
getDolGlobalInt(
'PRELEVEMENT_ID_BANKACCOUNT'));
1925 dol_syslog(get_class($this) .
"::generate build file=" . $this->filename .
" type=" . $type);
1927 $this->file = fopen($this->filename,
"w");
1928 if ($this->file ==
false) {
1929 $this->error = $langs->trans(
'ErrorFailedToOpenFile', $this->filename);
1937 if (
$mysoc->isInSEPA()) {
1940 if ($type !=
'bank-transfer') {
1952 if (!empty($executiondate)) {
1953 $date_actu = $executiondate;
1958 $fileDebiteurSection =
'';
1959 $fileEmetteurSection =
'';
1966 $sql =
"SELECT soc.rowid as socid, soc.code_client as code, soc.address, soc.zip, soc.town, c.code as country_code,";
1968 $sql .=
" pl.client_nom as nom, pl.amount as somme, pl.fk_prelevement_demande,";
1969 $sql .=
" f.ref as reffac,";
1970 $sql .=
" p.fk_facture as idfac, p.rowid as pid,";
1971 $sql .=
" rib.rowid, rib.datec, rib.iban_prefix as iban, rib.bic as bic, rib.rowid as drum, rib.rum, rib.date_rum";
1973 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_lignes as pl,";
1974 $sql .=
" " . MAIN_DB_PREFIX .
"facture as f,";
1975 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement as p,";
1976 $sql .=
" " . MAIN_DB_PREFIX .
"societe as soc,";
1977 $sql .=
" " . MAIN_DB_PREFIX .
"c_country as c,";
1978 $sql .=
" " . MAIN_DB_PREFIX .
"societe_rib as rib";
1979 $sql .=
" WHERE pl.fk_prelevement_bons = " . ((int) $this->
id);
1980 $sql .=
" AND pl.rowid = p.fk_prelevement_lignes";
1981 $sql .=
" AND p.fk_facture = f.rowid";
1982 $sql .=
" AND f.fk_soc = soc.rowid";
1983 $sql .=
" AND soc.fk_pays = c.rowid";
1984 $sql .=
" AND rib.fk_soc = f.fk_soc";
1985 if (!empty($thirdpartyBANId)) {
1986 $sql .=
" AND rib.rowid = " . ((int) $thirdpartyBANId);
1988 $sql .=
" AND rib.default_rib = 1";
1990 $sql .=
" AND rib.type = 'ban'";
1993 $resql = $this->db->query($sql);
1994 $nbtotalDrctDbtTxInf = -1;
1996 $cachearraytotestduplicate = array();
1998 $num = $this->db->num_rows($resql);
2000 $obj = $this->db->fetch_object($resql);
2002 if (!empty($cachearraytotestduplicate[$obj->idfac])) {
2003 $this->error = $langs->trans(
'ErrorCompanyHasDuplicateDefaultBAN', $obj->socid);
2004 $this->invoice_in_error[$obj->idfac] = $this->error;
2008 $cachearraytotestduplicate[$obj->idfac] = $obj->rowid;
2011 $daterum = (!empty($obj->date_rum)) ? $this->db->jdate($obj->date_rum) : $this->db->jdate($obj->datec);
2018 if (!empty($obj->fk_prelevement_demande)) {
2019 $companybankaccountid = 0;
2021 $sqltmp =
"SELECT fk_societe_rib FROM ".MAIN_DB_PREFIX.
"prelevement_demande";
2022 $sqltmp .=
" WHERE rowid = ".((int) $obj->fk_prelevement_demande);
2024 $resqltmp = $this->db->query($sqltmp);
2026 $objtmp = $this->db->fetch_object($resqltmp);
2028 $companybankaccountid = (int) $objtmp->fk_societe_rib;
2032 $bankaccount->fetch($companybankaccountid);
2033 if ($bankaccount->id > 0) {
2034 $daterum = (!empty($bankaccount->date_rum) ? $bankaccount->date_rum : $bankaccount->datec);
2035 $iban = $bankaccount->iban;
2036 $bic = $bankaccount->bic;
2037 $drum = $bankaccount->id;
2038 $rum = $bankaccount->rum;
2042 $fileDebiteurSection .= $this->
EnregDestinataireSEPA($obj->code, $obj->nom, $obj->address, $obj->zip, $obj->town, $obj->country_code,
'',
'',
'', $obj->somme, $obj->reffac, $obj->idfac, $iban, $bic, $daterum, (
string) $drum, $rum, $type);
2044 $this->total += $obj->somme;
2047 $nbtotalDrctDbtTxInf = $i;
2049 $this->error = $this->db->lasterror();
2050 fwrite($this->file,
'ERROR DEBITOR ' . $sql . $CrLf);
2055 if ($result != -2) {
2056 $fileEmetteurSection .= $this->
EnregEmetteurSEPA($conf, $date_actu, $nbtotalDrctDbtTxInf, $this->total, $CrLf, $format, $type, $fk_bank_account);
2060 $this->total = number_format((
float)
price2num($this->total,
'MT'), 2,
".",
"");
2067 fwrite($this->file,
'<' .
'?xml version="1.0" encoding="UTF-8" standalone="yes"?' .
'>' . $CrLf);
2068 $sepaSchemaVersion = $this->sepa_schema_version;
2069 $sepaNamespace =
'urn:iso:std:iso:20022:tech:xsd:pain.008.001.0' . $sepaSchemaVersion;
2070 fwrite($this->file,
'<Document xmlns="' . $sepaNamespace .
'" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' . $CrLf);
2071 fwrite($this->file,
' <CstmrDrctDbtInitn>' . $CrLf);
2073 fwrite($this->file,
' <GrpHdr>' . $CrLf);
2074 fwrite($this->file,
' <MsgId>' . (
'DOL/' . $dateTime_YMD .
'/DD' . $this->
id) .
'</MsgId>' . $CrLf);
2075 fwrite($this->file,
' <CreDtTm>' . $dateTime_ECMA .
'</CreDtTm>' . $CrLf);
2076 fwrite($this->file,
' <NbOfTxs>' . $i .
'</NbOfTxs>' . $CrLf);
2077 fwrite($this->file,
' <CtrlSum>' . $this->total .
'</CtrlSum>' . $CrLf);
2078 fwrite($this->file,
' <InitgPty>' . $CrLf);
2080 fwrite($this->file,
' <Id>' . $CrLf);
2081 fwrite($this->file,
' <PrvtId>' . $CrLf);
2082 fwrite($this->file,
' <Othr>' . $CrLf);
2083 fwrite($this->file,
' <Id>' . $this->emetteur_ics .
'</Id>' . $CrLf);
2084 fwrite($this->file,
' </Othr>' . $CrLf);
2085 fwrite($this->file,
' </PrvtId>' . $CrLf);
2086 fwrite($this->file,
' </Id>' . $CrLf);
2087 fwrite($this->file,
' </InitgPty>' . $CrLf);
2088 fwrite($this->file,
' </GrpHdr>' . $CrLf);
2090 if ($result != -2) {
2091 fwrite($this->file, $fileEmetteurSection);
2094 if ($result != -2) {
2095 fwrite($this->file, $fileDebiteurSection);
2098 fwrite($this->file,
' </PmtInf>' . $CrLf);
2099 fwrite($this->file,
' </CstmrDrctDbtInitn>' . $CrLf);
2100 fwrite($this->file,
'</Document>' . $CrLf);
2113 if (!empty($executiondate)) {
2114 $date_actu = $executiondate;
2119 $fileCrediteurSection =
'';
2120 $fileEmetteurSection =
'';
2126 if (!empty($forsalary)) {
2127 $sql =
"SELECT u.rowid as userId, u.address, u.zip, u.town, c.code as country_code, CONCAT(u.firstname,' ',u.lastname) as nom,";
2129 $sql .=
" pl.client_nom as nom, pl.amount as somme, pl.fk_prelevement_demande,";
2130 $sql .=
" s.ref as reffac,";
2131 $sql .=
" p.fk_salary as idfac,";
2132 $sql .=
" rib.rowid, rib.datec, rib.iban_prefix as iban, rib.bic as bic, rib.rowid as drum, '' as rum, '' as date_rum";
2134 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_lignes as pl,";
2135 $sql .=
" " . MAIN_DB_PREFIX .
"salary as s,";
2136 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement as p,";
2137 $sql .=
" " . MAIN_DB_PREFIX .
"user as u";
2138 $sql .=
" LEFT JOIN " . MAIN_DB_PREFIX .
"c_country as c ON u.fk_country = c.rowid,";
2139 $sql .=
" " . MAIN_DB_PREFIX .
"user_rib as rib";
2140 $sql .=
" WHERE pl.fk_prelevement_bons=" . ((int) $this->
id);
2141 $sql .=
" AND pl.rowid = p.fk_prelevement_lignes";
2142 $sql .=
" AND p.fk_salary = s.rowid";
2143 $sql .=
" AND s.fk_user = u.rowid";
2144 $sql .=
" AND rib.fk_user = s.fk_user";
2146 $sql =
"SELECT soc.rowid as socid, soc.code_client as code, soc.address, soc.zip, soc.town, c.code as country_code,";
2148 $sql .=
" pl.client_nom as nom, pl.amount as somme, pl.fk_prelevement_demande,";
2149 $sql .=
" f.ref as reffac, f.ref_supplier as fac_ref_supplier,";
2150 $sql .=
" p.fk_facture_fourn as idfac,";
2151 $sql .=
" rib.rowid, rib.datec, rib.iban_prefix as iban, rib.bic as bic, rib.rowid as drum, rib.rum, rib.date_rum";
2153 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_lignes as pl,";
2154 $sql .=
" " . MAIN_DB_PREFIX .
"facture_fourn as f,";
2155 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement as p,";
2156 $sql .=
" " . MAIN_DB_PREFIX .
"societe as soc";
2157 $sql .=
" LEFT JOIN " . MAIN_DB_PREFIX .
"c_country as c ON soc.fk_pays = c.rowid,";
2158 $sql .=
" " . MAIN_DB_PREFIX .
"societe_rib as rib";
2159 $sql .=
" WHERE pl.fk_prelevement_bons = " . ((int) $this->
id);
2160 $sql .=
" AND pl.rowid = p.fk_prelevement_lignes";
2161 $sql .=
" AND p.fk_facture_fourn = f.rowid";
2162 $sql .=
" AND f.fk_soc = soc.rowid";
2163 $sql .=
" AND rib.fk_soc = f.fk_soc";
2164 if (!empty($thirdpartyBANId)) {
2165 $sql .=
" AND rib.rowid = " . ((int) $thirdpartyBANId);
2167 $sql .=
" AND rib.default_rib = 1";
2169 $sql .=
" AND rib.type = 'ban'";
2172 $nbtotalDrctDbtTxInf = -1;
2174 require_once DOL_DOCUMENT_ROOT .
'/societe/class/companybankaccount.class.php';
2176 $resql = $this->db->query($sql);
2178 $cachearraytotestduplicate = array();
2180 $num = $this->db->num_rows($resql);
2182 $obj = $this->db->fetch_object($resql);
2185 if (!empty($cachearraytotestduplicate[$obj->idfac])) {
2186 $this->error = $langs->trans(
'ErrorCompanyHasDuplicateDefaultBAN', $obj->socid);
2187 $this->invoice_in_error[$obj->idfac] = $this->error;
2192 $cachearraytotestduplicate[$obj->idfac] = $obj->rowid;
2195 $daterum = (!empty($obj->date_rum)) ? $this->db->jdate($obj->date_rum) : $this->db->jdate($obj->datec);
2202 if (!empty($obj->fk_prelevement_demande)) {
2203 $companybankaccountid = 0;
2205 $sqltmp =
"SELECT fk_societe_rib FROM ".MAIN_DB_PREFIX.
"prelevement_demande";
2206 $sqltmp .=
" WHERE rowid = ".((int) $obj->fk_prelevement_demande);
2208 $resqltmp = $this->db->query($sqltmp);
2210 $objtmp = $this->db->fetch_object($resqltmp);
2212 $companybankaccountid = (int) $objtmp->fk_societe_rib;
2216 $bankaccount->fetch($companybankaccountid);
2217 if ($bankaccount->id > 0) {
2218 $daterum = (!empty($bankaccount->date_rum) ? $bankaccount->date_rum : $bankaccount->datec);
2219 $iban = $bankaccount->iban;
2220 $bic = $bankaccount->bic;
2221 $drum = $bankaccount->id;
2222 $rum = $bankaccount->rum;
2226 $refobj = $obj->reffac;
2227 if (empty($refobj) && !empty($forsalary)) {
2228 $refobj =
"SAL" . $obj->idfac;
2231 $fileCrediteurSection .= $this->
EnregDestinataireSEPA($obj->code, $obj->nom, $obj->address, $obj->zip, $obj->town, $obj->country_code,
'',
'',
'', $obj->somme, $refobj, $obj->idfac, $iban, $bic, $daterum, (
string) $drum, $rum, $type, $obj->fac_ref_supplier);
2233 $this->total += $obj->somme;
2236 $nbtotalDrctDbtTxInf = $i;
2238 $this->error = $this->db->lasterror();
2239 fwrite($this->file,
'ERROR CREDITOR ' . $sql . $CrLf);
2243 if ($result != -2) {
2244 $fileEmetteurSection .= $this->
EnregEmetteurSEPA($conf, $date_actu, $nbtotalDrctDbtTxInf, $this->total, $CrLf, $format, $type);
2248 $this->total = number_format((
float)
price2num($this->total,
'MT'), 2,
".",
"");
2255 fwrite($this->file,
'<' .
'?xml version="1.0" encoding="UTF-8" standalone="yes"?' .
'>' . $CrLf);
2256 fwrite($this->file,
'<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' . $CrLf);
2257 fwrite($this->file,
' <CstmrCdtTrfInitn>' . $CrLf);
2259 fwrite($this->file,
' <GrpHdr>' . $CrLf);
2260 fwrite($this->file,
' <MsgId>' . (
'DOL/' . $dateTime_YMD .
'/CT' . $this->
id) .
'</MsgId>' . $CrLf);
2261 fwrite($this->file,
' <CreDtTm>' . $dateTime_ECMA .
'</CreDtTm>' . $CrLf);
2262 fwrite($this->file,
' <NbOfTxs>' . $i .
'</NbOfTxs>' . $CrLf);
2263 fwrite($this->file,
' <CtrlSum>' . $this->total .
'</CtrlSum>' . $CrLf);
2264 fwrite($this->file,
' <InitgPty>' . $CrLf);
2266 fwrite($this->file,
' <Id>' . $CrLf);
2267 fwrite($this->file,
' <PrvtId>' . $CrLf);
2268 fwrite($this->file,
' <Othr>' . $CrLf);
2269 fwrite($this->file,
' <Id>' . $this->emetteur_ics .
'</Id>' . $CrLf);
2270 fwrite($this->file,
' </Othr>' . $CrLf);
2271 fwrite($this->file,
' </PrvtId>' . $CrLf);
2272 fwrite($this->file,
' </Id>' . $CrLf);
2273 fwrite($this->file,
' </InitgPty>' . $CrLf);
2274 fwrite($this->file,
' </GrpHdr>' . $CrLf);
2276 if ($result != -2) {
2277 fwrite($this->file, $fileEmetteurSection);
2280 if ($result != -2) {
2281 fwrite($this->file, $fileCrediteurSection);
2284 fwrite($this->file,
' </PmtInf>' . $CrLf);
2285 fwrite($this->file,
' </CstmrCdtTrfInitn>' . $CrLf);
2286 fwrite($this->file,
'</Document>' . $CrLf);
2292 if ($type !=
'bank-transfer') {
2293 $sql =
"SELECT pl.amount";
2295 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_lignes as pl,";
2296 $sql .=
" " . MAIN_DB_PREFIX .
"facture as f,";
2297 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement as p";
2298 $sql .=
" WHERE pl.fk_prelevement_bons = " . ((int) $this->
id);
2299 $sql .=
" AND pl.rowid = p.fk_prelevement_lignes";
2300 $sql .=
" AND p.fk_facture = f.rowid";
2304 $resql = $this->db->query($sql);
2306 $num = $this->db->num_rows($resql);
2309 $obj = $this->db->fetch_object($resql);
2310 $this->total += $obj->amount;
2319 $sql =
"SELECT pl.amount";
2321 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement_lignes as pl,";
2322 $sql .=
" " . MAIN_DB_PREFIX .
"facture_fourn as f,";
2323 $sql .=
" " . MAIN_DB_PREFIX .
"prelevement as p";
2324 $sql .=
" WHERE pl.fk_prelevement_bons = " . ((int) $this->
id);
2325 $sql .=
" AND pl.rowid = p.fk_prelevement_lignes";
2326 $sql .=
" AND p.fk_facture_fourn = f.rowid";
2329 $resql = $this->db->query($sql);
2331 $num = $this->db->num_rows($resql);
2334 $obj = $this->db->fetch_object($resql);
2335 $this->total += $obj->amount;
2345 $langs->load(
'withdrawals');
2348 fwrite($this->file, $langs->transnoentitiesnoconv(
'WithdrawalFileNotCapable',
$mysoc->country_code));
2351 fclose($this->file);
2373 return $pre .
'-' .
dol_print_date($row_datec,
'dayhourlogsmall') .
'-' .
dol_trunc((
string) $row_drum . ($row_code_client ?
'-' . $row_code_client :
''), 17,
'right',
'UTF-8', 1);
2398 $country_code = trim((
string) $country_code);
2400 $missingelements = array();
2401 if (trim($town) ==
'') {
2402 $missingelements[] =
'town';
2404 if ($country_code ==
'') {
2405 $missingelements[] =
'country code';
2407 if (count($missingelements) > 0) {
2409 dol_syslog(
'buildSEPAPostalAddressXML: PstlAdr block omitted because the '.implode(
' and the ', $missingelements).
' is empty.', LOG_WARNING);
2413 $XML_ADR = $indent .
'<PstlAdr>' . $CrLf;
2415 if (trim($zip) !=
'') {
2416 $XML_ADR .= $indent .
' <PstCd>' . dolEscapeXML(
dol_trunc($zip, 16,
'right',
'UTF-8', 1)) .
'</PstCd>' . $CrLf;
2418 $XML_ADR .= $indent .
' <TwnNm>' . dolEscapeXML(
dol_trunc($town, 35,
'right',
'UTF-8', 1)) .
'</TwnNm>' . $CrLf;
2419 $XML_ADR .= $indent .
' <Ctry>' . dolEscapeXML($country_code) .
'</Ctry>' . $CrLf;
2420 $addressline1 = strtr((
string) $address, array(chr(13) =>
", ", chr(10) =>
""));
2421 if (trim($addressline1)) {
2424 $XML_ADR .= $indent .
'</PstlAdr>' . $CrLf;
2446 public function EnregDestinataire($rowid, $client_nom, $rib_banque, $rib_guichet, $rib_number, $amount, $ref, $facid, $rib_dom =
'', $type =
'direct-debit')
2449 fwrite($this->file,
"06");
2450 fwrite($this->file,
"08");
2452 fwrite($this->file,
" ");
2454 fwrite($this->file, $this->emetteur_ics);
2458 fwrite($this->file,
" ");
2459 fwrite($this->file,
dol_print_date($this->date_echeance,
"%d%m",
'gmt'));
2460 fwrite($this->file, substr(
dol_print_date($this->date_echeance,
"%y",
'gmt'), 1));
2464 fwrite($this->file, substr(strtoupper($client_nom) .
" ", 0, 24));
2467 $address = strtr($rib_dom, array(
" " =>
"-", chr(13) =>
" ", chr(10) =>
""));
2468 fwrite($this->file, substr($address .
" ", 0, 24));
2472 fwrite($this->file, substr(
" ", 0, 8));
2476 fwrite($this->file, $rib_guichet);
2480 fwrite($this->file, substr(
"000000000000000" . $rib_number, -11));
2484 $montant = (round($amount, 2) * 100);
2486 fwrite($this->file, substr(
"000000000000000" . $montant, -16));
2490 fwrite($this->file, substr(
"*_" . $ref .
"_RDVnet" . $rowid .
" ", 0, 31));
2494 fwrite($this->file, $rib_banque);
2498 fwrite($this->file, substr(
" ", 0, 5));
2500 fwrite($this->file,
"\n");
2530 public function EnregDestinataireSEPA($row_code_client, $row_nom, $row_address, $row_zip, $row_town, $row_country_code, $row_cb, $row_cg, $row_cc, $row_somme, $row_ref, $row_idfac, $row_iban, $row_bic, $row_datec, $row_drum, $row_rum, $type =
'direct-debit', $row_comment =
'')
2536 $row_somme = number_format((
float)
price2num($row_somme,
'MT'), 2,
".",
"");
2538 $row_somme = round((
float) $row_somme, 2);
2541 include_once DOL_DOCUMENT_ROOT .
'/core/lib/functions2.lib.php';
2544 $Rowing = sprintf(
"%010d", $row_idfac);
2548 $Rum = (empty($row_rum) ? $this->
buildRumNumber($row_code_client, $row_datec, $row_drum) : $row_rum);
2554 if (!is_object($hookmanager)) {
2555 include_once DOL_DOCUMENT_ROOT .
'/core/class/hookmanager.class.php';
2558 $hookmanager->initHooks(array(
'bonprelevementdao'));
2559 $parameters = array(
2560 'row_code_client' => &$row_code_client,
'row_nom' => &$row_nom,
'row_address' => &$row_address,
'row_zip' => &$row_zip,
'row_town' => &$row_town,
2561 'row_country_code' => &$row_country_code,
'row_cb' => &$row_cb,
'row_cg' => &$row_cg,
'row_cc' => &$row_cc,
'row_somme' => &$row_somme,
2562 'row_ref' => &$row_ref,
'row_idfac' => &$row_idfac,
'row_iban' => &$row_iban,
'row_bic' => &$row_bic,
'row_datec' => &$row_datec,
2563 'row_drum' => &$row_drum,
'row_rum' => &$row_rum,
'type' => &$type,
'row_comment' => &$row_comment,
2564 'crlf' => &$CrLf,
'rowing' => &$Rowing,
'rum' => &$Rum,
'dtofsgntr' => &$DtOfSgntr,
2566 $reshook = $hookmanager->executeHooks(
'enregDestinataireSEPA', $parameters, $this);
2567 if (empty($reshook)) {
2568 if ($type !=
'bank-transfer') {
2571 $XML_DEBITOR .=
' <DrctDbtTxInf>' . $CrLf;
2572 $XML_DEBITOR .=
' <PmtId>' . $CrLf;
2574 $XML_DEBITOR .=
' <EndToEndId>' . ((
getDolGlobalString(
'PRELEVEMENT_END_TO_END') !=
"") ?
$conf->global->PRELEVEMENT_END_TO_END : (
'DD-' .
dol_trunc($row_idfac .
'-' . $row_ref, 20,
'right',
'UTF-8', 1)) .
'-' . $Rowing) .
'</EndToEndId>' . $CrLf;
2575 $XML_DEBITOR .=
' </PmtId>' . $CrLf;
2576 $XML_DEBITOR .=
' <InstdAmt Ccy="EUR">' . $row_somme .
'</InstdAmt>' . $CrLf;
2577 $XML_DEBITOR .=
' <DrctDbtTx>' . $CrLf;
2578 $XML_DEBITOR .=
' <MndtRltdInf>' . $CrLf;
2579 $XML_DEBITOR .=
' <MndtId>' . $Rum .
'</MndtId>' . $CrLf;
2580 $XML_DEBITOR .=
' <DtOfSgntr>' . $DtOfSgntr .
'</DtOfSgntr>' . $CrLf;
2581 $XML_DEBITOR .=
' <AmdmntInd>false</AmdmntInd>' . $CrLf;
2582 $XML_DEBITOR .=
' </MndtRltdInf>' . $CrLf;
2583 $XML_DEBITOR .=
' </DrctDbtTx>' . $CrLf;
2584 $XML_DEBITOR .=
' <DbtrAgt>' . $CrLf;
2585 $XML_DEBITOR .=
' <FinInstnId>' . $CrLf;
2587 $XML_DEBITOR .=
' ' . ($this->sepa_schema_version ==
'8' ?
'<BICFI>' :
'<BIC>') . $row_bic . ($this->sepa_schema_version ==
'8' ?
'</BICFI>' :
'</BIC>') . $CrLf;
2589 $XML_DEBITOR .=
' </FinInstnId>' . $CrLf;
2590 $XML_DEBITOR .=
' </DbtrAgt>' . $CrLf;
2591 $XML_DEBITOR .=
' <Dbtr>' . $CrLf;
2593 $XML_DEBITOR .= $this->
buildSEPAPostalAddressXML($row_address, $row_zip, $row_town, $row_country_code,
"\t\t\t\t\t", $CrLf);
2594 $XML_DEBITOR .=
' </Dbtr>' . $CrLf;
2595 $XML_DEBITOR .=
' <DbtrAcct>' . $CrLf;
2596 $XML_DEBITOR .=
' <Id>' . $CrLf;
2597 $XML_DEBITOR .=
' <IBAN>' . preg_replace(
'/\s/',
'', $row_iban) .
'</IBAN>' . $CrLf;
2598 $XML_DEBITOR .=
' </Id>' . $CrLf;
2599 $XML_DEBITOR .=
' </DbtrAcct>' . $CrLf;
2600 $XML_DEBITOR .=
' <RmtInf>' . $CrLf;
2603 include_once DOL_DOCUMENT_ROOT .
'/core/lib/functions_creditorref.lib.php';
2605 $invoicestatic =
new Facture($this->db);
2606 $invoicestatic->fetch($row_idfac);
2608 $paymentref = empty($invoicestatic->payment_reference) ?
'' : (string) $invoicestatic->payment_reference;
2611 if ($paymentref ===
'' &&
getDolGlobalString(
'INVOICE_PAYMENT_ENABLE_STRUCTURED_COMMUNICATION') &&
$mysoc->country_code ==
'BE') {
2612 include_once DOL_DOCUMENT_ROOT .
'/core/lib/functions_be.lib.php';
2618 if ($scheme ==
'SCOR' || $scheme ==
'BBA') {
2621 $XML_DEBITOR .=
' <Strd>' . $CrLf;
2622 $XML_DEBITOR .=
' <CdtrRefInf>' . $CrLf;
2623 $XML_DEBITOR .=
' <Tp>' . $CrLf;
2624 $XML_DEBITOR .=
' <CdOrPrtry>' . $CrLf;
2625 if ($scheme ==
'SCOR') {
2626 $XML_DEBITOR .=
' <Cd>SCOR</Cd>' . $CrLf;
2628 $XML_DEBITOR .=
' <Prtry>BBA</Prtry>' . $CrLf;
2630 $XML_DEBITOR .=
' </CdOrPrtry>' . $CrLf;
2631 $XML_DEBITOR .=
' </Tp>' . $CrLf;
2632 $XML_DEBITOR .=
' <Ref>' . dolEscapeXML(
dolPayRefStrip($paymentref)) .
'</Ref>' . $CrLf;
2633 $XML_DEBITOR .=
' </CdtrRefInf>' . $CrLf;
2634 $XML_DEBITOR .=
' </Strd>' . $CrLf;
2635 } elseif ($scheme ==
'FI') {
2637 $XML_DEBITOR .=
' <Ustrd>' . dolEscapeXML($paymentref) .
'</Ustrd>' . $CrLf;
2642 $XML_DEBITOR .=
' </RmtInf>' . $CrLf;
2643 $XML_DEBITOR .=
' </DrctDbtTxInf>' . $CrLf;
2645 $XML_RESULT = $XML_DEBITOR;
2649 $XML_CREDITOR .=
' <CdtTrfTxInf>' . $CrLf;
2650 $XML_CREDITOR .=
' <PmtId>' . $CrLf;
2652 $XML_CREDITOR .=
' <EndToEndId>' . ((
getDolGlobalString(
'PRELEVEMENT_END_TO_END') !=
"") ?
getDolGlobalString(
"PRELEVEMENT_END_TO_END") : (
'CT-' .
dol_trunc($row_idfac .
'-' . $row_ref, 20,
'right',
'UTF-8', 1)) .
'-' . $Rowing) .
'</EndToEndId>' . $CrLf;
2653 $XML_CREDITOR .=
' </PmtId>' . $CrLf;
2654 if (!empty($this->sepa_xml_pti_in_ctti)) {
2655 $XML_CREDITOR .=
' <PmtTpInf>' . $CrLf;
2659 $instrprty =
'HIGH';
2661 $instrprty =
'NORM';
2665 $categoryPurpose =
getDolGlobalString(
'PAYMENTBYBANKTRANSFER_CUSTOM_CATEGORY_PURPOSE',
'CORE');
2667 $XML_CREDITOR .=
' <InstrPrty>' . $instrprty .
'</InstrPrty>' . $CrLf;
2668 $XML_CREDITOR .=
' <SvcLvl>' . $CrLf;
2669 $XML_CREDITOR .=
' <Cd>SEPA</Cd>' . $CrLf;
2670 $XML_CREDITOR .=
' </SvcLvl>' . $CrLf;
2671 $XML_CREDITOR .=
' <CtgyPurp>' . $CrLf;
2672 $XML_CREDITOR .=
' <Cd>' . $categoryPurpose .
'</Cd>' . $CrLf;
2673 $XML_CREDITOR .=
' </CtgyPurp>' . $CrLf;
2674 $XML_CREDITOR .=
' </PmtTpInf>' . $CrLf;
2676 $XML_CREDITOR .=
' <Amt>' . $CrLf;
2677 $XML_CREDITOR .=
' <InstdAmt Ccy="EUR">' . round((
float) $row_somme, 2) .
'</InstdAmt>' . $CrLf;
2678 $XML_CREDITOR .=
' </Amt>' . $CrLf;
2689 $XML_CREDITOR .=
' <CdtrAgt>' . $CrLf;
2690 $XML_CREDITOR .=
' <FinInstnId>' . $CrLf;
2691 $XML_CREDITOR .=
' <BIC>' . $row_bic .
'</BIC>' . $CrLf;
2692 $XML_CREDITOR .=
' </FinInstnId>' . $CrLf;
2693 $XML_CREDITOR .=
' </CdtrAgt>' . $CrLf;
2694 $XML_CREDITOR .=
' <Cdtr>' . $CrLf;
2696 $XML_CREDITOR .= $this->
buildSEPAPostalAddressXML($row_address, $row_zip, $row_town, $row_country_code,
"\t\t\t\t\t", $CrLf);
2697 $XML_CREDITOR .=
' </Cdtr>' . $CrLf;
2698 $XML_CREDITOR .=
' <CdtrAcct>' . $CrLf;
2699 $XML_CREDITOR .=
' <Id>' . $CrLf;
2700 $XML_CREDITOR .=
' <IBAN>' . preg_replace(
'/\s/',
'', $row_iban) .
'</IBAN>' . $CrLf;
2701 $XML_CREDITOR .=
' </Id>' . $CrLf;
2702 $XML_CREDITOR .=
' </CdtrAcct>' . $CrLf;
2703 $XML_CREDITOR .=
' <RmtInf>' . $CrLf;
2706 $XML_CREDITOR .=
' </RmtInf>' . $CrLf;
2707 $XML_CREDITOR .=
' </CdtTrfTxInf>' . $CrLf;
2709 $XML_RESULT = $XML_CREDITOR;
2711 } elseif ($reshook > 0) {
2712 $XML_RESULT = $hookmanager->resPrint;
2714 $XML_RESULT .= $hookmanager->resPrint;
2732 fwrite($this->file,
"03");
2733 fwrite($this->file,
"08");
2735 fwrite($this->file,
" ");
2737 fwrite($this->file, $this->emetteur_ics);
2741 fwrite($this->file,
" ");
2742 fwrite($this->file,
dol_print_date($this->date_echeance,
"%d%m",
'gmt'));
2743 fwrite($this->file, substr(
dol_print_date($this->date_echeance,
"%y",
'gmt'), 1));
2747 fwrite($this->file, substr($this->raison_sociale .
" ", 0, 24));
2751 fwrite($this->file, substr($this->reference_remise .
" ", 0, 7));
2755 fwrite($this->file, substr(
" ", 0, 17));
2759 fwrite($this->file, substr(
" ", 0, 2));
2760 fwrite($this->file,
"E");
2761 fwrite($this->file, substr(
" ", 0, 5));
2765 fwrite($this->file, $this->emetteur_code_guichet);
2769 fwrite($this->file, substr(
"000000000000000" . $this->emetteur_numero_compte, -11));
2773 fwrite($this->file, substr(
" ", 0, 16));
2777 fwrite($this->file, substr(
" ", 0, 31));
2781 fwrite($this->file, $this->emetteur_code_banque);
2785 fwrite($this->file, substr(
" ", 0, 5));
2787 fwrite($this->file,
"\n");
2806 public function EnregEmetteurSEPA($configuration, $ladate, $nombre, $total, $CrLf =
'\n', $format =
'FRST', $type =
'direct-debit', $fk_bank_account = 0)
2816 if (empty($fk_bank_account)) {
2817 $fk_bank_account = ($type ==
'bank-transfer' ?
getDolGlobalInt(
'PAYMENTBYBANKTRANSFER_ID_BANKACCOUNT') :
getDolGlobalInt(
'PRELEVEMENT_ID_BANKACCOUNT'));
2821 $account =
new Account($this->db);
2822 if ($account->fetch($fk_bank_account) > 0) {
2823 $this->emetteur_code_banque = $account->code_banque;
2824 $this->emetteur_code_guichet = $account->code_guichet;
2825 $this->emetteur_numero_compte = $account->number;
2826 $this->emetteur_number_key = $account->cle_rib;
2827 $this->sepa_xml_pti_in_ctti = (bool) $account->pti_in_ctti;
2828 $this->emetteur_iban = $account->iban;
2829 $this->emetteur_bic = $account->bic;
2831 $this->emetteur_ics = (($type ==
'bank-transfer' &&
getDolGlobalString(
"SEPA_USE_IDS")) ? $account->ics_transfer : $account->ics);
2833 $this->raison_sociale = $account->owner_name;
2837 $sql =
"SELECT rowid, ref";
2838 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_bons as pb";
2839 $sql .=
" WHERE pb.rowid = " . ((int) $this->
id);
2841 $resql = $this->db->query($sql);
2843 $obj = $this->db->fetch_object($resql);
2846 $IdBon = sprintf(
"%05d", $obj->rowid);
2847 $RefBon = $obj->ref;
2848 $localInstrument =
getDolGlobalString(
'PAYMENTBYBANKTRANSFER_CUSTOM_LOCAL_INSTRUMENT',
'CORE');
2851 $total = number_format((
float)
price2num($total,
'MT'), 2,
".",
"");
2854 if ($type !=
'bank-transfer') {
2856 $XML_SEPA_INFO =
'';
2857 $XML_SEPA_INFO .=
' <PmtInf>' . $CrLf;
2858 $XML_SEPA_INFO .=
' <PmtInfId>' . (
'DOL/' . $dateTime_YMD .
'/DD' . $IdBon .
'-' . $RefBon) .
'</PmtInfId>' . $CrLf;
2859 $XML_SEPA_INFO .=
' <PmtMtd>DD</PmtMtd>' . $CrLf;
2860 $XML_SEPA_INFO .=
' <NbOfTxs>' . $nombre .
'</NbOfTxs>' . $CrLf;
2861 $XML_SEPA_INFO .=
' <CtrlSum>' . $total .
'</CtrlSum>' . $CrLf;
2862 $XML_SEPA_INFO .=
' <PmtTpInf>' . $CrLf;
2863 $XML_SEPA_INFO .=
' <SvcLvl>' . $CrLf;
2864 $XML_SEPA_INFO .=
' <Cd>SEPA</Cd>' . $CrLf;
2865 $XML_SEPA_INFO .=
' </SvcLvl>' . $CrLf;
2866 $XML_SEPA_INFO .=
' <LclInstrm>' . $CrLf;
2867 $XML_SEPA_INFO .=
' <Cd>' . $localInstrument .
'</Cd>' . $CrLf;
2868 $XML_SEPA_INFO .=
' </LclInstrm>' . $CrLf;
2869 $XML_SEPA_INFO .=
' <SeqTp>' . $format .
'</SeqTp>' . $CrLf;
2870 $XML_SEPA_INFO .=
' </PmtTpInf>' . $CrLf;
2871 $XML_SEPA_INFO .=
' <ReqdColltnDt>' . $dateTime_ETAD .
'</ReqdColltnDt>' . $CrLf;
2872 $XML_SEPA_INFO .=
' <Cdtr>' . $CrLf;
2877 $sender_country_code = (string) ($country[1] ??
'');
2878 $XML_SEPA_INFO .= $this->
buildSEPAPostalAddressXML($sender_address, $sender_zip, $sender_town, $sender_country_code,
"\t\t\t\t", $CrLf);
2879 $XML_SEPA_INFO .=
' </Cdtr>' . $CrLf;
2880 $XML_SEPA_INFO .=
' <CdtrAcct>' . $CrLf;
2881 $XML_SEPA_INFO .=
' <Id>' . $CrLf;
2882 $XML_SEPA_INFO .=
' <IBAN>' . preg_replace(
'/\s/',
'', $this->emetteur_iban) .
'</IBAN>' . $CrLf;
2883 $XML_SEPA_INFO .=
' </Id>' . $CrLf;
2884 $XML_SEPA_INFO .=
' </CdtrAcct>' . $CrLf;
2885 $XML_SEPA_INFO .=
' <CdtrAgt>' . $CrLf;
2886 $XML_SEPA_INFO .=
' <FinInstnId>' . $CrLf;
2887 $XML_SEPA_INFO .=
' ' . ($this->sepa_schema_version ==
'8' ?
'<BICFI>' :
'<BIC>') . $this->emetteur_bic . ($this->sepa_schema_version ==
'8' ?
'</BICFI>' :
'</BIC>') . $CrLf;
2888 $XML_SEPA_INFO .=
' </FinInstnId>' . $CrLf;
2889 $XML_SEPA_INFO .=
' </CdtrAgt>' . $CrLf;
2898 $XML_SEPA_INFO .=
' <ChrgBr>SLEV</ChrgBr>' . $CrLf;
2899 $XML_SEPA_INFO .=
' <CdtrSchmeId>' . $CrLf;
2900 $XML_SEPA_INFO .=
' <Id>' . $CrLf;
2901 $XML_SEPA_INFO .=
' <PrvtId>' . $CrLf;
2902 $XML_SEPA_INFO .=
' <Othr>' . $CrLf;
2903 $XML_SEPA_INFO .=
' <Id>' . $this->emetteur_ics .
'</Id>' . $CrLf;
2904 $XML_SEPA_INFO .=
' <SchmeNm>' . $CrLf;
2905 $XML_SEPA_INFO .=
' <Prtry>SEPA</Prtry>' . $CrLf;
2906 $XML_SEPA_INFO .=
' </SchmeNm>' . $CrLf;
2907 $XML_SEPA_INFO .=
' </Othr>' . $CrLf;
2908 $XML_SEPA_INFO .=
' </PrvtId>' . $CrLf;
2909 $XML_SEPA_INFO .=
' </Id>' . $CrLf;
2910 $XML_SEPA_INFO .=
' </CdtrSchmeId>' . $CrLf;
2913 $XML_SEPA_INFO =
'';
2914 $XML_SEPA_INFO .=
' <PmtInf>' . $CrLf;
2915 $XML_SEPA_INFO .=
' <PmtInfId>' . (
'DOL/' . $dateTime_YMD .
'/CT' . $IdBon .
'-' . $RefBon) .
'</PmtInfId>' . $CrLf;
2916 $XML_SEPA_INFO .=
' <PmtMtd>TRF</PmtMtd>' . $CrLf;
2918 $XML_SEPA_INFO .=
' <NbOfTxs>' . $nombre .
'</NbOfTxs>' . $CrLf;
2919 $XML_SEPA_INFO .=
' <CtrlSum>' . $total .
'</CtrlSum>' . $CrLf;
2920 if (!empty($this->sepa_xml_pti_in_ctti) && !empty($format)) {
2921 $XML_SEPA_INFO .=
' <PmtTpInf>' . $CrLf;
2922 $XML_SEPA_INFO .=
' <SvcLvl>' . $CrLf;
2923 $XML_SEPA_INFO .=
' <Cd>SEPA</Cd>' . $CrLf;
2924 $XML_SEPA_INFO .=
' </SvcLvl>' . $CrLf;
2925 $XML_SEPA_INFO .=
' <LclInstrm>' . $CrLf;
2926 $XML_SEPA_INFO .=
' <Cd>' . $localInstrument .
'</Cd>' . $CrLf;
2927 $XML_SEPA_INFO .=
' </LclInstrm>' . $CrLf;
2928 $XML_SEPA_INFO .=
' <SeqTp>' . $format .
'</SeqTp>' . $CrLf;
2929 $XML_SEPA_INFO .=
' </PmtTpInf>' . $CrLf;
2931 $XML_SEPA_INFO .=
' <ReqdExctnDt>' .
dol_print_date($dateTime_ETAD,
'dayrfc') .
'</ReqdExctnDt>' . $CrLf;
2932 $XML_SEPA_INFO .=
' <Dbtr>' . $CrLf;
2937 $sender_country_code = (string) ($country[1] ??
'');
2938 $XML_SEPA_INFO .= $this->
buildSEPAPostalAddressXML($sender_address, $sender_zip, $sender_town, $sender_country_code,
"\t\t\t\t", $CrLf);
2939 $XML_SEPA_INFO .=
' </Dbtr>' . $CrLf;
2940 $XML_SEPA_INFO .=
' <DbtrAcct>' . $CrLf;
2941 $XML_SEPA_INFO .=
' <Id>' . $CrLf;
2942 $XML_SEPA_INFO .=
' <IBAN>' . preg_replace(
'/\s/',
'', $this->emetteur_iban) .
'</IBAN>' . $CrLf;
2943 $XML_SEPA_INFO .=
' </Id>' . $CrLf;
2944 $XML_SEPA_INFO .=
' </DbtrAcct>' . $CrLf;
2945 $XML_SEPA_INFO .=
' <DbtrAgt>' . $CrLf;
2946 $XML_SEPA_INFO .=
' <FinInstnId>' . $CrLf;
2947 $XML_SEPA_INFO .=
' <BIC>' . $this->emetteur_bic .
'</BIC>' . $CrLf;
2948 $XML_SEPA_INFO .=
' </FinInstnId>' . $CrLf;
2949 $XML_SEPA_INFO .=
' </DbtrAgt>' . $CrLf;
2958 $XML_SEPA_INFO .=
' <ChrgBr>SLEV</ChrgBr>' . $CrLf;
2973 fwrite($this->file,
'INCORRECT EMETTEUR ' . $this->raison_sociale . $CrLf);
2974 $XML_SEPA_INFO =
'';
2976 return $XML_SEPA_INFO;
2989 fwrite($this->file,
"08");
2990 fwrite($this->file,
"08");
2992 fwrite($this->file,
" ");
2994 fwrite($this->file, $this->emetteur_ics);
2998 fwrite($this->file, substr(
" ", 0, 12));
3003 fwrite($this->file, substr(
" ", 0, 24));
3007 fwrite($this->file, substr(
" ", 0, 24));
3011 fwrite($this->file, substr(
" ", 0, 8));
3015 fwrite($this->file, substr(
" ", 0, 5));
3019 fwrite($this->file, substr(
" ", 0, 11));
3023 $montant = ($total * 100);
3025 fwrite($this->file, substr(
"000000000000000" . $montant, -16));
3029 fwrite($this->file, substr(
" ", 0, 31));
3033 fwrite($this->file, substr(
" ", 0, 5));
3037 fwrite($this->file, substr(
" ", 0, 5));
3039 fwrite($this->file,
"\n");
3064 if (empty($this->labelStatus) || empty($this->labelStatusShort)) {
3067 $this->labelStatus[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'StatusWaiting');
3068 $this->labelStatus[self::STATUS_TRANSFERED] = $langs->transnoentitiesnoconv(
'StatusTrans');
3069 $this->labelStatusShort[self::STATUS_DRAFT] = $langs->transnoentitiesnoconv(
'StatusWaiting');
3070 $this->labelStatusShort[self::STATUS_TRANSFERED] = $langs->transnoentitiesnoconv(
'StatusTrans');
3071 if ($this->
type ==
'bank-transfer') {
3072 $this->labelStatus[self::STATUS_DEBITED] = $langs->transnoentitiesnoconv(
'StatusDebited');
3073 $this->labelStatusShort[self::STATUS_DEBITED] = $langs->transnoentitiesnoconv(
'StatusDebited');
3075 $this->labelStatus[self::STATUS_CREDITED] = $langs->transnoentitiesnoconv(
'StatusCredited');
3076 $this->labelStatusShort[self::STATUS_CREDITED] = $langs->transnoentitiesnoconv(
'StatusCredited');
3078 $this->labelStatus[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Canceled');
3079 $this->labelStatusShort[self::STATUS_CANCELED] = $langs->transnoentitiesnoconv(
'Canceled');
3082 $statusType =
'status1';
3083 if ($status == self::STATUS_TRANSFERED) {
3084 $statusType =
'status3';
3086 if ($status == self::STATUS_CREDITED || $status == self::STATUS_DEBITED) {
3087 $statusType =
'status6';
3089 if ($status == self::STATUS_CANCELED) {
3090 $statusType =
'status9';
3093 return dolGetStatus($this->labelStatus[$status], $this->labelStatusShort[$status],
'', $statusType, $mode);
3107 global
$conf, $langs;
3113 if ($mode ==
'direct-debit') {
3114 $sql =
"SELECT p.rowid, p.datec, p.date_trans as date_trans, p.date_credit as date_credit";
3115 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_bons as p";
3116 $sql .=
" WHERE p.entity IN (" .
getEntity(
'prelevement_bons') .
")";
3117 $sql .=
" AND (p.type = 'debit-order' OR p.type = 'direct-debit')";
3118 $sql .=
" AND p.statut < ".((int) BonPrelevement::STATUS_DEBITED);
3120 $sql =
"SELECT p.rowid, p.datec, p.date_trans as date_trans, p.date_credit as date_credit";
3121 $sql .=
" FROM " . MAIN_DB_PREFIX .
"prelevement_bons as p";
3122 $sql .=
" WHERE p.entity IN (" .
getEntity(
'prelevement_bons') .
")";
3123 $sql .=
" AND (p.type = 'bank-transfer' OR p.type = 'credit-transfer')";
3124 $sql .=
" AND p.statut < ".((int) BonPrelevement::STATUS_CREDITED);
3127 $resql = $this->db->query($sql);
3129 $langs->load(
"banks");
3133 if ($mode ==
'direct-debit') {
3134 $warning_delay = (int)
$conf->warning_delays[
'bank_direct_debit'];
3135 $response->warning_delay = $warning_delay / 60 / 60 / 24;
3136 $response->label = $langs->trans(
"PendingDirectDebitToComplete");
3137 $response->labelShort = $langs->trans(
"PendingDirectDebitToCompleteShort");
3138 $response->url = DOL_URL_ROOT .
'/compta/prelevement/orders_list.php?leftmenu=checks&mainmenu=bank&search_status=0,1';
3139 $response->url_late = DOL_URL_ROOT .
'/compta/prelevement/orders_list.php?leftmenu=checks&mainmenu=bank&search_status=0,1';
3141 $warning_delay = (int)
$conf->warning_delays[
'bank_credit_transfer'];
3142 $response->warning_delay = $warning_delay / 60 / 60 / 24;
3143 $response->label = $langs->trans(
"PendingCreditTransferToComplete");
3144 $response->labelShort = $langs->trans(
"PendingCreditTransferToCompleteShort");
3145 $response->url = DOL_URL_ROOT .
'/compta/prelevement/orders_list.php?leftmenu=checks&mainmenu=bank&type=bank-transfer&search_status=0,1';
3146 $response->url_late = DOL_URL_ROOT .
'/compta/prelevement/orders_list.php?leftmenu=checks&mainmenu=bank&type=bank-transfer&search_status=0,1';
3148 $response->img = img_object(
'',
"payment");
3150 $response->nbtodo = 0;
3151 $response->nbtodolate = 0;
3153 while ($obj = $this->db->fetch_object($resql)) {
3154 $response->nbtodo++;
3157 $datetotest = $this->db->jdate(!empty($obj->date_trans) ? $obj->date_trans : $obj->datec);
3158 if ($datetotest && $datetotest < ($now - $warning_delay)) {
3159 $response->nbtodolate++;
3170 dol_print_error($this->db);
3171 $this->error = $this->db->error();
3187 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
3189 $return =
'<div class="box-flex-item box-flex-grow-zero">';
3190 $return .=
'<div class="info-box info-box-sm">';
3191 $return .=
'<span class="info-box-icon bg-infobox-action">';
3192 $return .= img_picto(
'', $this->picto);
3193 $return .=
'</span>';
3194 $return .=
'<div class="info-box-content">';
3195 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">' . $this->
getNomUrl(1) .
'</span>';
3196 if ($selected >= 0) {
3197 $return .=
'<input id="cb' . $this->
id .
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="' . $this->
id .
'"' . ($selected ?
' checked="checked"' :
'') .
'>';
3210 if (isset($this->
amount)) {
3211 $return .=
'<br><span class="opacitymedium">' . $langs->trans(
"Amount") .
'</span> : <span class="amount">' .
price($this->
amount) .
'</span>';
3213 $return .=
'<br><div class="info-box-status">' . $this->
getLibStatut(3) .
'</div>';
3214 $return .=
'</div>';
3215 $return .=
'</div>';
3216 $return .=
'</div>';
3227 if (!empty($this->
id)) {
3232 $sql =
"SELECT COUNT(*) AS nb FROM " . MAIN_DB_PREFIX .
"prelevement_lignes";
3233 $sql .=
" WHERE fk_prelevement_bons = " . ((int) $id);
3234 $sql .=
" AND fk_soc = 0";
3235 $sql .=
" AND fk_user IS NOT NULL";
3238 $resql = $this->db->query($sql);
3240 $obj = $this->db->fetch_object($resql);
3243 dol_print_error($this->db);
$propal type
'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',...
checkIbanForAccount($account=null, $ibantocheck=null)
Check IBAN number information for a bank account.
checkSwiftForAccount($account=null, $swift=null)
Check SWIFT information for a bank account.
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.
addWithdrawDetail($invoice_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number, $number_key, $type='debit-order', $sourcetype='', $bic='', $iban='', $rum='', $id_prelevement_demande=0)
Add invoice to withdrawal.
load_board($user, $mode)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
SommeAPrelever($mode='direct-debit', $type='')
Returns amount waiting for direct debit payment or credit transfer payment.
static buildRumNumber($row_code_client, $row_datec, $row_drum)
Generate dynamically a RUM number for a customer bank account.
EnregEmetteur($type='direct-debit')
Write sender of request (me).
checkIfSalaryBonPrelevement()
Check if is bon prelevement for salary invoice.
EnregTotal($total)
Write end.
NbFactureAPrelever($type='direct-debit', $forsalary=0)
Get number of invoices to pay.
fetch($rowid, $ref='')
Get object and lines from database.
addline(&$line_id, $client_id, $client_nom, $amount, $code_banque, $code_guichet, $number, $number_key, $sourcetype='', $bic='', $iban='', $rum='', $id_prelevement_demande=0)
Add line to withdrawal.
getListInvoices($amounts=0, $type='')
Get invoice or salary list (with amount or not)
deleteNotificationById($rowid)
Delete a notification def by id.
__construct($db)
Constructor.
EnregDestinataire($rowid, $client_nom, $rib_banque, $rib_guichet, $rib_number, $amount, $ref, $facid, $rib_dom='', $type='direct-debit')
Write recipient of request (customer)
getKanbanView($option='', $arraydata=null)
Return clickable link of object (with eventually picto)
getNomUrl($withpicto=0, $option='', $notooltip=0, $morecss='', $save_lastsearch_value=-1)
Returns clickable name (with picto)
LibStatut($status, $mode=0)
Return status label for a status.
update(User $user, $notrigger=0)
Update object into database.
set_infotrans($user, $date, $method)
Set withdrawal to transmitted status.
buildSEPAPostalAddressXML($address, $zip, $town, $country_code, $indent, $CrLf)
Build the SEPA postal address block (<PstlAdr>) in the hybrid format required by ISO 20022 usage guid...
generate(string $format='FRST', int $executiondate=0, string $type='direct-debit', int $fk_bank_account=0, int $forsalary=0, int $thirdpartyBANId=0)
Generate a direct debit or credit transfer file.
getErrorString($error)
Return error string.
EnregEmetteurSEPA($configuration, $ladate, $nombre, $total, $CrLf='\n', $format='FRST', $type='direct-debit', $fk_bank_account=0)
Write sender of request (me).
set_infocredit($user, $date, $type='')
Set direct debit or credit transfer order to "paid" status.
getLibStatut($mode=0)
Return status label of object.
EnregDestinataireSEPA($row_code_client, $row_nom, $row_address, $row_zip, $row_town, $row_country_code, $row_cb, $row_cg, $row_cc, $row_somme, $row_ref, $row_idfac, $row_iban, $row_bic, $row_datec, $row_drum, $row_rum, $type='direct-debit', $row_comment='')
Write recipient (thirdparty concerned by request)
addNotification($db, $user, $action)
Add a notification.
nbOfInvoiceToPay($mode='direct-debit', $type='')
Get number of invoices waiting for payment.
deleteNotification($user, $action)
Delete a notification.
updateCommon(User $user, $notrigger=0)
Update object into database.
Class to manage bank accounts description of third parties.
Class to manage suppliers invoices.
Class to manage invoices.
const STATUS_VALIDATED
Validated (need to be paid)
Class to manage payments for supplier invoices.
Class to manage payments of customer invoices.
Class to manage payments of salaries.
Class to manage salary payments.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
print $langs trans("Ref").' m titre as m m statut as status
Or an array listing all the potential status of the object: array: int of the status => translated la...
dol_now($mode='gmt')
Return date for now.
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
dol_string_nospecial($str, $newstr='_', $badcharstoreplace='', $badcharstoremove='', $keepspaces=0)
Clean a string from all punctuation characters to use it as a ref or login.
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.
dolChmod($filepath, $newmask='')
Change mod of a file.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_string_unaccent($str)
Clean a string from all accent characters to be used as ref, login or by dol_sanitizeFileName.
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.
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).
dol_trunc($string, $size=40, $trunc='right', $stringencoding='UTF-8', $nodot=0, $display=0)
Truncate a string to a particular length adding '...' if string larger than length.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
dolBECalculateStructuredCommunication($invoice_number, $invoice_type)
Calculate Structured Communication / BE Bank payment reference number.
dolPayRefStrip($ref)
Remove formatting spaces from a payment reference (machine form).
dolPayRefDetectScheme($ref)
Detect which structured payment reference scheme a stored value belongs to.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as p p num_paiement as f pf amount as amount
dolDecrypt($chain, $key='', $patterntotest='')
Decode a string with a symmetric encryption.