171 public function create($user, $closepaidinvoices = 0, $thirdparty =
null)
173 global $langs,
$conf;
182 $totalamount_converted = 0;
183 $atleastonepaymentnotnull = 0;
185 if ($way ==
'dolibarr') {
186 $amounts = &$this->amounts;
187 $amounts_to_update = &$this->multicurrency_amounts;
189 $amounts = &$this->multicurrency_amounts;
190 $amounts_to_update = &$this->amounts;
193 $currencyofpayment =
'';
194 $currencytxofpayment =
'';
196 foreach ($amounts as $key => $value) {
203 if ($value_converted ===
false) {
205 $this->error = $langs->trans(
'FailedToFoundTheConversionRateForInvoice');
209 $invoice_multicurrency_code = $this->multicurrency_code[$key] ??
'';
210 $invoice_multicurrency_tx = $this->multicurrency_tx[$key] ??
'';
211 if (empty($invoice_multicurrency_code) || empty($invoice_multicurrency_tx)) {
213 if ($tmparray !==
false) {
214 if (empty($invoice_multicurrency_code)) {
215 $invoice_multicurrency_code = $tmparray[
'invoice_multicurrency_code'];
217 if (empty($invoice_multicurrency_tx)) {
218 $invoice_multicurrency_tx = $tmparray[
'invoice_multicurrency_tx'];
223 if (empty($currencyofpayment)) {
224 $currencyofpayment = $invoice_multicurrency_code;
226 if ($currencyofpayment != $invoice_multicurrency_code) {
228 $this->error =
'ErrorYouTryToPayInvoicesWithDifferentCurrenciesInSamePayment';
231 if (empty($currencytxofpayment)) {
232 $currencytxofpayment = $invoice_multicurrency_tx;
235 $totalamount_converted += $value_converted;
236 $amounts_to_update[$key] =
price2num($value_converted,
'MT');
239 $amounts[$key] = $newvalue;
240 $totalamount += $newvalue;
241 if (!empty($newvalue)) {
242 $atleastonepaymentnotnull++;
246 if (!empty($currencyofpayment)) {
248 $bankaccount =
new Account($this->db);
249 $bankaccount->fetch($this->fk_account);
250 $bankcurrencycode = empty($bankaccount->currency_code) ?
$conf->currency : $bankaccount->currency_code;
251 if ($currencyofpayment != $bankcurrencycode && $currencyofpayment !=
$conf->currency && $bankcurrencycode !=
$conf->currency) {
252 $langs->load(
"errors");
253 $this->error = $langs->trans(
'ErrorYouTryToPayInvoicesInACurrencyFromBankWithAnotherCurrency', $currencyofpayment, $bankcurrencycode);
259 $totalamount = (float)
price2num($totalamount);
260 $totalamount_converted = (float)
price2num($totalamount_converted);
264 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
268 if ($totalamount != 0) {
269 $ref = $this->
getNextNumRef(is_object($thirdparty) ? $thirdparty :
'');
271 if ($way ==
'dolibarr') {
272 $total = $totalamount;
273 $mtotal = $totalamount_converted;
275 $total = $totalamount_converted;
276 $mtotal = $totalamount;
279 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'paiementfourn (';
280 $sql .=
'ref, entity, datec, datep, amount, multicurrency_amount, fk_paiement, num_paiement, note, fk_user_author, fk_bank)';
281 $sql .=
" VALUES ('".$this->db->escape($ref).
"', ".((int)
$conf->entity).
", '".$this->db->idate($now).
"',";
282 $sql .=
" '".$this->db->idate($this->datepaye).
"', ".((float) $total).
", ".((float) $mtotal).
", ".((int) $this->paiementid).
", '".$this->db->escape($this->num_payment).
"', '".$this->db->escape($this->note_private).
"', ".((int) $user->id).
", 0)";
284 $resql = $this->db->query($sql);
286 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
'paiementfourn');
289 foreach ($this->amounts as $key => $amount) {
291 if (is_numeric($amount) && $amount != 0) {
293 $sql =
'INSERT INTO '.MAIN_DB_PREFIX.
'paiementfourn_facturefourn (fk_facturefourn, fk_paiementfourn, amount, multicurrency_amount, multicurrency_code, multicurrency_tx)';
294 $sql .=
" VALUES (".((int) $facid).
", ".((int) $this->
id).
", ".((float) $amount).
', '.((float) $this->multicurrency_amounts[$key]).
', '.($currencyofpayment ?
"'".$this->db->escape($currencyofpayment).
"'" :
'NULL').
', '.(!empty($currencytxofpayment) ? (float) $currencytxofpayment : 1).
')';
295 $resql = $this->db->query($sql);
298 $invoice->fetch($facid);
301 if ($closepaidinvoices) {
302 $paiement = $invoice->getSommePaiement();
303 $creditnotes = $invoice->getSumCreditNotesUsed();
305 $deposits = $invoice->getSumDepositsUsed();
307 $alreadypayed =
price2num($paiement + $creditnotes + $deposits,
'MT');
308 $remaintopay =
price2num($invoice->total_ttc - $paiement - $creditnotes - $deposits,
'MT');
309 if ($remaintopay == 0) {
312 $amount_ht = $amount_tva = $amount_ttc = array();
313 $multicurrency_amount_ht = $multicurrency_amount_tva = $multicurrency_amount_ttc = array();
315 @phan-var-force array<string,float> $amount_ht
316 @phan-var-force array<string,float> $amount_tva
317 @phan-var-force array<string,float> $amount_ttc
318 @phan-var-force array<string,float> $multicurrency_amount_ht
319 @phan-var-force array<string,float> $multicurrency_amount_tva
320 @phan-var-force array<string,float> $multicurrency_amount_ttc
324 require_once DOL_DOCUMENT_ROOT .
'/core/class/discount.class.php';
326 $discount->fetch(0, 0, $invoice->id);
327 if (empty($discount->id)) {
328 $discount->discount_type = 1;
329 $discount->description =
'(DEPOSIT)';
330 $discount->fk_soc = $invoice->socid;
331 $discount->socid = $invoice->socid;
332 $discount->fk_invoice_supplier_source = $invoice->id;
333 $discount->multicurrency_code = $invoice->multicurrency_code;
334 $discount->multicurrency_tx = $invoice->multicurrency_tx;
338 foreach ($invoice->lines as $line) {
339 if ($line->total_ht != 0) {
340 if (!array_key_exists($line->tva_tx, $amount_ht)) {
341 $amount_ht[$line->tva_tx] = 0.0;
342 $amount_tva[$line->tva_tx] = 0.0;
343 $amount_ttc[$line->tva_tx] = 0.0;
344 $multicurrency_amount_ht[$line->tva_tx] = 0.0;
345 $multicurrency_amount_tva[$line->tva_tx] = 0.0;
346 $multicurrency_amount_ttc[$line->tva_tx] = 0.0;
348 $amount_ht[$line->tva_tx] += $line->total_ht;
349 $amount_tva[$line->tva_tx] += $line->total_tva;
350 $amount_ttc[$line->tva_tx] += $line->total_ttc;
351 $multicurrency_amount_ht[$line->tva_tx] += $line->multicurrency_total_ht;
352 $multicurrency_amount_tva[$line->tva_tx] += $line->multicurrency_total_tva;
353 $multicurrency_amount_ttc[$line->tva_tx] += $line->multicurrency_total_ttc;
358 foreach ($amount_ht as $tva_tx => $xxx) {
359 $discount->total_ht = abs($amount_ht[$tva_tx]);
360 $discount->total_tva = abs($amount_tva[$tva_tx]);
361 $discount->total_ttc = abs($amount_ttc[$tva_tx]);
364 $discount->amount_ht = $discount->total_ht;
365 $discount->amount_tva = $discount->total_tva;
366 $discount->amount_ttc = $discount->total_ttc;
369 $discount->multicurrency_total_ht = abs($multicurrency_amount_ht[$tva_tx]);
370 $discount->multicurrency_total_tva = abs($multicurrency_amount_tva[$tva_tx]);
371 $discount->multicurrency_total_ttc = abs($multicurrency_amount_ttc[$tva_tx]);
374 $discount->multicurrency_amount_ht = $discount->multicurrency_total_ht;
375 $discount->multicurrency_amount_tva = $discount->multicurrency_total_tva;
376 $discount->multicurrency_amount_ttc = $discount->multicurrency_total_ttc;
378 $discount->tva_tx = abs((
float) $tva_tx);
380 $result = $discount->create($user);
396 $result = $invoice->setPaid($user,
'',
'');
398 $this->error = $invoice->error;
405 $hookmanager->initHooks(array(
'payment_supplierdao'));
406 $parameters = array(
'facid' => $facid,
'invoice' => $invoice,
'remaintopay' => $remaintopay);
407 $action =
'CLOSEPAIDSUPPLIERINVOICE';
408 $reshook = $hookmanager->executeHooks(
'createPayment', $parameters, $this, $action);
410 $this->error = $hookmanager->error;
412 } elseif ($reshook == 0) {
413 dol_syslog(
"Remain to pay for invoice " . $facid .
" not null. We do nothing more.");
421 $outputlangs = $langs;
423 $invoice->fetch_thirdparty();
424 $newlang = $invoice->thirdparty->default_lang;
426 if (!empty($newlang)) {
428 $outputlangs->setDefaultLang($newlang);
430 $ret = $invoice->fetch($facid);
431 $result = $invoice->generateDocument($invoice->model_pdf, $outputlangs);
438 $this->error = $this->db->lasterror();
442 dol_syslog(get_class($this).
'::Create Amount line '.$key.
' not a number. We discard it.');
448 $result = $this->call_trigger(
'PAYMENT_SUPPLIER_CREATE', $user);
455 $this->error = $this->db->lasterror();
459 $this->error =
"ErrorTotalIsNull";
460 dol_syslog(
'PaiementFourn::Create Error '.$this->error, LOG_ERR);
464 if ($totalamount != 0 && $error == 0) {
466 $this->total = $total;
467 $this->multicurrency_amount = $mtotal;
469 dol_syslog(
'PaiementFourn::Create Ok Total = '.$this->
amount.
', Total currency = '.$this->multicurrency_amount);
472 $this->db->rollback();