36require
'../../main.inc.php';
37require_once DOL_DOCUMENT_ROOT.
'/core/lib/report.lib.php';
38require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
39require_once DOL_DOCUMENT_ROOT.
'/core/lib/bank.lib.php';
40require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
41require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
47require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/class/paiement.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/don/class/don.class.php';
49require_once DOL_DOCUMENT_ROOT.
'/don/class/paymentdonation.class.php';
50require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
51require_once DOL_DOCUMENT_ROOT.
'/salaries/class/paymentsalary.class.php';
52require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
53require_once DOL_DOCUMENT_ROOT.
'/fourn/class/paiementfourn.class.php';
54require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
55require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.class.php';
56require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/bookkeeping.class.php';
57require_once DOL_DOCUMENT_ROOT.
'/societe/class/client.class.php';
58require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
59require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/paymentexpensereport.class.php';
60require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/paymentvarious.class.php';
61require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
62require_once DOL_DOCUMENT_ROOT.
'/loan/class/loan.class.php';
63require_once DOL_DOCUMENT_ROOT.
'/loan/class/paymentloan.class.php';
64require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
75$langs->loadLangs(array(
"companies",
"other",
"compta",
"banks",
"bills",
"donations",
"loan",
"accountancy",
"trips",
"salaries",
"hrm",
"members"));
80$date_startmonth =
GETPOSTINT(
'date_startmonth');
86$in_bookkeeping =
GETPOST(
'in_bookkeeping',
'aZ09');
89if ($only_rappro == 0) {
96$action =
GETPOST(
'action',
'aZ09');
98if ($in_bookkeeping ==
'') {
99 $in_bookkeeping =
'notyet';
104if (!isModEnabled(
'accounting')) {
107if ($user->socid > 0) {
110if (!$user->hasRight(
'accounting',
'bind',
'write')) {
121$date_start =
dol_mktime(0, 0, 0, $date_startmonth, $date_startday, $date_startyear);
122$date_end =
dol_mktime(23, 59, 59, $date_endmonth, $date_endday, $date_endyear);
125$pastmonthyear =
null;
127if (empty($date_startmonth)) {
130 $date_start = $dates[
'date_start'];
131 $pastmonthyear = $dates[
'pastmonthyear'];
132 $pastmonth = $dates[
'pastmonth'];
134if (empty($date_endmonth)) {
137 $date_end = $dates[
'date_end'];
138 $pastmonthyear = $dates[
'pastmonthyear'];
139 $pastmonth = $dates[
'pastmonth'];
142if (!GETPOSTISSET(
'date_startmonth') && (empty($date_start) || empty($date_end))) {
144 $date_end =
dol_get_last_day((
int) $pastmonthyear, (
int) $pastmonth,
false);
149$sql =
"SELECT b.rowid, b.dateo as do, b.datev as dv, b.amount, b.amount_main_currency, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type, b.fk_account,";
150$sql .=
" ba.courant, ba.ref as baref, ba.account_number, ba.fk_accountancy_journal,";
151$sql .=
" soc.rowid as socid, soc.nom as name, soc.email as email, bu1.type as typeop_company,";
153 $sql .=
" spe.accountancy_code_customer_general,";
154 $sql .=
" spe.accountancy_code_customer as code_compta_client,";
155 $sql .=
" spe.accountancy_code_supplier_general,";
156 $sql .=
" spe.accountancy_code_supplier as code_compta_fournisseur,";
158 $sql .=
" soc.accountancy_code_customer_general,";
159 $sql .=
" soc.code_compta as code_compta_client,";
160 $sql .=
" soc.accountancy_code_supplier_general,";
161 $sql .=
" soc.code_compta_fournisseur,";
163$sql .=
" u.accountancy_code_user_general, u.accountancy_code, u.rowid as userid, u.lastname as lastname, u.firstname as firstname, u.email as useremail, u.statut as userstatus,";
164$sql .=
" bu2.type as typeop_user,";
165$sql .=
" bu3.type as typeop_payment, bu4.type as typeop_payment_supplier";
166$sql .=
" FROM ".$db->prefix().
"bank as b";
167$sql .=
" JOIN ".$db->prefix().
"bank_account as ba on b.fk_account = ba.rowid";
168$sql .=
" LEFT JOIN ".$db->prefix().
"bank_url as bu1 ON bu1.fk_bank = b.rowid AND bu1.type='company'";
169$sql .=
" LEFT JOIN ".$db->prefix().
"bank_url as bu2 ON bu2.fk_bank = b.rowid AND bu2.type='user'";
170$sql .=
" LEFT JOIN ".$db->prefix().
"bank_url as bu3 ON bu3.fk_bank = b.rowid AND bu3.type='payment'";
171$sql .=
" LEFT JOIN ".$db->prefix().
"bank_url as bu4 ON bu4.fk_bank = b.rowid AND bu4.type='payment_supplier'";
172$sql .=
" LEFT JOIN ".$db->prefix().
"societe as soc on bu1.url_id=soc.rowid";
174 $sql .=
" LEFT JOIN " . $db->prefix() .
"societe_perentity as spe ON spe.fk_soc = soc.rowid AND spe.entity = " . ((int)
$conf->entity);
176$sql .=
" LEFT JOIN ".$db->prefix().
"user as u on bu2.url_id=u.rowid";
177$sql .=
" WHERE ba.fk_accountancy_journal=".((int) $id_journal);
178$sql .=
" AND b.amount <> 0 AND ba.entity IN (".getEntity(
'bank_account', 0).
")";
179if ($date_start && $date_end) {
180 $sql .=
" AND b.dateo >= '".$db->idate($date_start).
"' AND b.dateo <= '".$db->idate($date_end).
"'";
184 $sql .=
" AND b.dateo >= '".$db->idate(
getDolGlobalInt(
'ACCOUNTING_DATE_START_BINDING')).
"'";
187if ($in_bookkeeping ==
'already') {
188 $sql .=
" AND (b.rowid IN (SELECT fk_doc FROM ".$db->prefix().
"accounting_bookkeeping as ab WHERE ab.doc_type='bank') )";
190if ($in_bookkeeping ==
'notyet') {
191 $sql .=
" AND (b.rowid NOT IN (SELECT fk_doc FROM ".$db->prefix().
"accounting_bookkeeping as ab WHERE ab.doc_type='bank') )";
193if ($only_rappro == 2) {
194 $sql .=
" AND (b.rappro = '1')";
196$sql .=
" ORDER BY b.datev";
202$societestatic =
new Societe($db);
203$userstatic =
new User($db);
204$bankaccountstatic =
new Account($db);
207$paymentvatstatic =
new Tva($db);
219$account_transfer =
'NotDefined';
223$accountingjournalstatic->fetch($id_journal);
224$journal = $accountingjournalstatic->code;
225$journal_label = $accountingjournalstatic->label;
227$tabcompany = array();
233$tabmoreinfo = array();
236@phan-var-force array<array{id:mixed,name:mixed,code_compta_client:string,email:string}> $tabcompany
237@phan-var-force array<array{id:int,name:string,lastname:string,firstname:string,email:string,accountancy_code:string,status:int> $tabuser
238@phan-var-force array<int,array{date:string,type_payment:string,ref:string,fk_bank:int,ban_account_ref:string,fk_bank_account:int,lib:string,type:string}> $tabpay
239@phan-var-force array<array{lib:string,date?:int|string,type_payment?:string,ref?:string,fk_bank?:int,ban_account_ref?:string,fk_bank_account?:int,type?:string,bank_account_ref?:string,paymentid?:int,paymentsupplierid?:int,soclib?:string,paymentscid?:int,paymentdonationid?:int,paymentsubscriptionid?:int,paymentvatid?:int,paymentsalid?:int,paymentexpensereport?:int,paymentvariousid?:int,account_various?:string,paymentloanid?:int}> $tabtp
242$account_customer =
'NotDefined';
243$account_supplier =
'NotDefined';
244$account_employee =
'NotDefined';
247dol_syslog(
"accountancy/journal/bankjournal.php", LOG_DEBUG);
248$result = $db->query($sql);
250 $num = $db->num_rows($result);
256 $account_employee =
getDolGlobalString(
'SALARIES_ACCOUNTING_ACCOUNT_PAYMENT',
'NotDefined');
257 $account_expensereport =
getDolGlobalString(
'ACCOUNTING_ACCOUNT_EXPENSEREPORT',
'NotDefined');
259 $account_pay_donation =
getDolGlobalString(
'DONATION_ACCOUNTINGACCOUNT',
'NotDefined');
260 $account_pay_subscription =
getDolGlobalString(
'ADHERENT_SUBSCRIPTION_ACCOUNTINGACCOUNT',
'NotDefined');
261 $account_transfer =
getDolGlobalString(
'ACCOUNTING_ACCOUNT_TRANSFER_CASH',
'NotDefined');
270 $obj = $db->fetch_object($result);
272 $lineisapurchase = -1;
275 if ($obj->label ==
'(SupplierInvoicePayment)' || $obj->label ==
'(SupplierInvoicePaymentBack)') {
276 $lineisapurchase = 1;
278 if ($obj->label ==
'(CustomerInvoicePayment)' || $obj->label ==
'(CustomerInvoicePaymentBack)') {
282 if ($lineisapurchase < 0) {
283 if ($obj->typeop_payment_supplier ==
'payment_supplier') {
284 $lineisapurchase = 1;
287 if ($lineisasale < 0) {
288 if ($obj->typeop_payment ==
'payment') {
296 $compta_bank = $obj->account_number;
299 $compta_soc =
'NotDefined';
300 $accountancy_code_general =
'NotDefined';
301 if ($lineisapurchase > 0) {
302 $accountancy_code_general = (!empty($obj->accountancy_code_supplier_general) && $obj->accountancy_code_supplier_general !=
'-1') ? $obj->accountancy_code_supplier_general : $account_supplier;
303 $compta_soc = (($obj->code_compta_fournisseur !=
"") ? $obj->code_compta_fournisseur : $account_supplier);
305 if ($lineisasale > 0) {
306 $accountancy_code_general = (!empty($obj->accountancy_code_customer_general) && $obj->accountancy_code_customer_general !=
'-1') ? $obj->accountancy_code_customer_general : $account_customer;
307 $compta_soc = (!empty($obj->code_compta_client) ? $obj->code_compta_client : $account_customer);
310 $tabcompany[$obj->rowid] = array(
312 'name' => $obj->name,
313 'code_compta' => $compta_soc,
314 'accountancy_code_general' => $accountancy_code_general,
315 'email' => $obj->email
321 $accountancy_code_user_general = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
322 $compta_user = (!empty($obj->accountancy_code) ? $obj->accountancy_code :
'');
324 $tabuser[$obj->rowid] = array(
325 'id' => $obj->userid,
327 'lastname' => $obj->lastname,
328 'firstname' => $obj->firstname,
329 'email' => $obj->useremail,
330 'accountancy_code_general' => $accountancy_code_user_general,
331 'accountancy_code' => $compta_user,
332 'status' => $obj->userstatus
336 $tabpay[$obj->rowid][
"date"] = $db->jdate($obj->do);
337 $tabpay[$obj->rowid][
"type_payment"] = $obj->fk_type;
338 $tabpay[$obj->rowid][
"ref"] = $obj->label;
339 $tabpay[$obj->rowid][
"fk_bank"] = $obj->rowid;
340 $tabpay[$obj->rowid][
"bank_account_ref"] = $obj->baref;
341 $tabpay[$obj->rowid][
"fk_bank_account"] = $obj->fk_account;
343 if (preg_match(
'/^\((.*)\)$/i', $obj->label, $reg)) {
344 $tabpay[$obj->rowid][
"lib"] = $langs->trans($reg[1]);
346 $tabpay[$obj->rowid][
"lib"] =
dol_trunc($obj->label, 60);
350 $links =
$object->get_url($obj->rowid);
355 $tabpay[$obj->rowid][
'type'] =
'unknown';
356 $tabtype[$obj->rowid] =
'unknown';
357 $tabmoreinfo[$obj->rowid] = array();
359 $amounttouse = $obj->amount;
360 if (!empty($obj->amount_main_currency)) {
362 $amounttouse = $obj->amount_main_currency;
366 if (is_array($links) && count($links) > 0) {
371 $is_expensereport =
false;
372 foreach ($links as $v) {
373 if ($v[
'type'] ==
'sc') {
377 if ($v[
'type'] ==
'payment_salary') {
381 if ($v[
'type'] ==
'payment_expensereport') {
382 $is_expensereport =
true;
388 foreach ($links as $key => $val) {
389 if ($links[$key][
'type'] ==
'user' && !$is_sc && !$is_salary && !$is_expensereport) {
394 if (in_array($links[$key][
'type'], array(
'sc',
'payment_sc',
'payment',
'payment_supplier',
'payment_vat',
'payment_expensereport',
'banktransfert',
'payment_donation',
'member',
'payment_loan',
'payment_salary',
'payment_various'))) {
398 $tabpay[$obj->rowid][
'type'] = $links[$key][
'type'];
399 $tabtype[$obj->rowid] = $links[$key][
'type'];
410 if ($links[$key][
'type'] ==
'withdraw') {
411 $tabmoreinfo[$obj->rowid][
'withdraw'] = 1;
414 if ($links[$key][
'type'] ==
'payment') {
415 $paymentstatic->id = $links[$key][
'url_id'];
416 $paymentstatic->ref = (string) $links[$key][
'url_id'];
417 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentstatic->getNomUrl(2,
'',
'');
418 $tabpay[$obj->rowid][
"paymentid"] = $paymentstatic->id;
419 } elseif ($links[$key][
'type'] ==
'payment_supplier') {
420 $paymentsupplierstatic->id = $links[$key][
'url_id'];
421 $paymentsupplierstatic->ref = (string) $links[$key][
'url_id'];
422 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentsupplierstatic->getNomUrl(2);
423 $tabpay[$obj->rowid][
"paymentsupplierid"] = $paymentsupplierstatic->id;
424 } elseif ($links[$key][
'type'] ==
'company') {
425 $societestatic->id = $links[$key][
'url_id'];
426 $societestatic->name = $links[$key][
'label'];
427 $societestatic->email = $tabcompany[$obj->rowid][
'email'];
428 $tabpay[$obj->rowid][
"soclib"] = $societestatic->getNomUrl(1,
'', 30);
430 if (empty($tabtp[$obj->rowid][$compta_soc])) {
431 $tabtp[$obj->rowid][$compta_soc] = $amounttouse;
433 $tabtp[$obj->rowid][$compta_soc] += $amounttouse;
436 } elseif ($links[$key][
'type'] ==
'user') {
437 $userstatic->id = $links[$key][
'url_id'];
438 $userstatic->name = $links[$key][
'label'];
439 $userstatic->email = $tabuser[$obj->rowid][
'email'];
440 $userstatic->firstname = $tabuser[$obj->rowid][
'firstname'];
441 $userstatic->lastname = $tabuser[$obj->rowid][
'lastname'];
442 $userstatic->status = $tabuser[$obj->rowid][
'status'];
443 $userstatic->accountancy_code_user_general = $tabuser[$obj->rowid][
'accountancy_code_general'];
444 $userstatic->accountancy_code = $tabuser[$obj->rowid][
'accountancy_code'];
449 if ($userstatic->id > 0) {
451 $tabpay[$obj->rowid][
"soclib"] .=
' '.$userstatic->getNomUrl(-1,
'accountancy', 0);
453 $tabpay[$obj->rowid][
"soclib"] = $userstatic->getNomUrl(-1,
'accountancy', 0);
456 $tabpay[$obj->rowid][
"soclib"] =
'???';
463 if (empty($tabtp[$obj->rowid][$compta_user])) {
464 $tabtp[$obj->rowid][$compta_user] = $amounttouse;
466 $tabtp[$obj->rowid][$compta_user] += $amounttouse;
470 } elseif ($links[$key][
'type'] ==
'sc') {
471 $chargestatic->id = $links[$key][
'url_id'];
472 $chargestatic->ref = (string) $links[$key][
'url_id'];
474 $tabpay[$obj->rowid][
"lib"] .=
' '.$chargestatic->getNomUrl(2);
476 if (preg_match(
'/^\((.*)\)$/i', $links[$key][
'label'], $reg)) {
477 if ($reg[1] ==
'socialcontribution') {
478 $reg[1] =
'SocialContribution';
480 $chargestatic->label = $langs->trans($reg[1]);
482 $chargestatic->label = $links[$key][
'label'];
484 $chargestatic->ref = $chargestatic->label;
503 $resultmid = $tmpcharge->fetch($chargestatic->id);
505 $chargestatic->type_label = $tmpcharge->type_label;
506 $chargestatic->type_code = $tmpcharge->type_code;
507 $chargestatic->type_accountancy_code = $tmpcharge->type_accountancy_code;
509 $tabtp[$obj->rowid][$tmpcharge->type_accountancy_code] = isset($tabtp[$obj->rowid][$tmpcharge->type_accountancy_code]) ? $tabtp[$obj->rowid][$tmpcharge->type_accountancy_code] + $amounttouse : $amounttouse;
512 $tabpay[$obj->rowid][
"soclib"] = $chargestatic->getNomUrl(1,
'30');
513 $tabpay[$obj->rowid][
"paymentscid"] = $chargestatic->id;
514 } elseif ($links[$key][
'type'] ==
'payment_donation') {
515 $paymentdonstatic->id = $links[$key][
'url_id'];
516 $paymentdonstatic->ref = (string) $links[$key][
'url_id'];
517 $paymentdonstatic->fk_donation = $links[$key][
'url_id'];
518 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentdonstatic->getNomUrl(2);
519 $tabpay[$obj->rowid][
"paymentdonationid"] = $paymentdonstatic->id;
520 $tabtp[$obj->rowid][$account_pay_donation] = isset($tabtp[$obj->rowid][$account_pay_donation]) ? $tabtp[$obj->rowid][$account_pay_donation] + $amounttouse : $amounttouse;
521 } elseif ($links[$key][
'type'] ==
'member') {
522 $paymentsubscriptionstatic->id = $links[$key][
'url_id'];
523 $paymentsubscriptionstatic->ref = (string) $links[$key][
'url_id'];
524 $paymentsubscriptionstatic->label = $links[$key][
'label'];
525 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentsubscriptionstatic->getNomUrl(2);
526 $tabpay[$obj->rowid][
"paymentsubscriptionid"] = $paymentsubscriptionstatic->id;
527 $paymentsubscriptionstatic->fetch($paymentsubscriptionstatic->id);
528 $tabtp[$obj->rowid][$account_pay_subscription] = isset($tabtp[$obj->rowid][$account_pay_subscription]) ? $tabtp[$obj->rowid][$account_pay_subscription] + $amounttouse : $amounttouse;
529 } elseif ($links[$key][
'type'] ==
'payment_vat') {
530 $paymentvatstatic->id = $links[$key][
'url_id'];
531 $paymentvatstatic->ref = (string) $links[$key][
'url_id'];
532 $paymentvatstatic->label = $links[$key][
'label'];
533 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentvatstatic->getNomUrl(2);
534 $tabpay[$obj->rowid][
"paymentvatid"] = $paymentvatstatic->id;
535 $tabtp[$obj->rowid][$account_pay_vat] = isset($tabtp[$obj->rowid][$account_pay_vat]) ? $tabtp[$obj->rowid][$account_pay_vat] + $amounttouse : $amounttouse;
536 } elseif ($links[$key][
'type'] ==
'payment_salary') {
537 $paymentsalstatic->id = $links[$key][
'url_id'];
538 $paymentsalstatic->ref = (string) $links[$key][
'url_id'];
539 $paymentsalstatic->label = $links[$key][
'label'];
540 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentsalstatic->getNomUrl(2);
541 $tabpay[$obj->rowid][
"paymentsalid"] = $paymentsalstatic->id;
545 if (
getDolGlobalString(
'ACCOUNTANCY_AUTOFIX_MISSING_LINK_TO_USER_ON_SALARY_BANK_PAYMENT')) {
546 $tmpsalary =
new Salary($db);
547 $tmpsalary->fetch($paymentsalstatic->id);
548 $tmpsalary->fetch_user($tmpsalary->fk_user);
550 $userstatic->id = $tmpsalary->user->id;
551 $userstatic->name = $tmpsalary->user->name;
552 $userstatic->email = $tmpsalary->user->email;
553 $userstatic->firstname = $tmpsalary->user->firstname;
554 $userstatic->lastname = $tmpsalary->user->lastname;
555 $userstatic->status = $tmpsalary->user->status;
556 $userstatic->accountancy_code = $tmpsalary->user->accountancy_code;
558 if ($userstatic->id > 0) {
559 $tabpay[$obj->rowid][
"soclib"] = $userstatic->getNomUrl(1,
'accountancy', 0);
561 $tabpay[$obj->rowid][
"soclib"] =
'???';
564 if (empty($obj->typeop_user)) {
565 $accountancy_code_user_general = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
566 $compta_user = $userstatic->accountancy_code;
568 if (empty($tabtp[$obj->rowid][$compta_user])) {
569 $tabtp[$obj->rowid][$compta_user] = $amounttouse;
571 $tabtp[$obj->rowid][$compta_user] += $amounttouse;
573 $tabuser[$obj->rowid] = array(
574 'id' => $userstatic->id,
576 'lastname' => $userstatic->lastname,
577 'firstname' => $userstatic->firstname,
578 'email' => $userstatic->email,
579 'accountancy_code_general' => $accountancy_code_user_general,
580 'accountancy_code' => $compta_user,
581 'status' => $userstatic->status
586 } elseif ($links[$key][
'type'] ==
'payment_expensereport') {
587 $paymentexpensereportstatic->id = $links[$key][
'url_id'];
588 $tabpay[$obj->rowid][
"lib"] .= $paymentexpensereportstatic->getNomUrl(2);
589 $tabpay[$obj->rowid][
"paymentexpensereport"] = $paymentexpensereportstatic->id;
590 } elseif ($links[$key][
'type'] ==
'payment_various') {
591 $paymentvariousstatic->id = $links[$key][
'url_id'];
592 $paymentvariousstatic->ref = (string) $links[$key][
'url_id'];
593 $paymentvariousstatic->label = $links[$key][
'label'];
594 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentvariousstatic->getNomUrl(2);
595 $tabpay[$obj->rowid][
"paymentvariousid"] = $paymentvariousstatic->id;
596 $paymentvariousstatic->fetch($paymentvariousstatic->id);
597 $account_various = (!empty($paymentvariousstatic->accountancy_code) ? $paymentvariousstatic->accountancy_code :
'NotDefined');
598 $account_subledger = (!empty($paymentvariousstatic->subledger_account) ? $paymentvariousstatic->subledger_account :
'');
599 $tabpay[$obj->rowid][
"account_various"] = $account_various;
600 $tabtp[$obj->rowid][$account_subledger] = isset($tabtp[$obj->rowid][$account_subledger]) ? $tabtp[$obj->rowid][$account_subledger] + $amounttouse : $amounttouse;
601 } elseif ($links[$key][
'type'] ==
'payment_loan') {
602 $paymentloanstatic->id = $links[$key][
'url_id'];
603 $paymentloanstatic->ref = (string) $links[$key][
'url_id'];
604 $paymentloanstatic->fk_loan = $links[$key][
'url_id'];
605 $tabpay[$obj->rowid][
"lib"] .=
' '.$paymentloanstatic->getNomUrl(2);
606 $tabpay[$obj->rowid][
"paymentloanid"] = $paymentloanstatic->id;
608 $sqlmid =
'SELECT pl.amount_capital, pl.amount_insurance, pl.amount_interest, l.accountancy_account_capital, l.accountancy_account_insurance, l.accountancy_account_interest';
609 $sqlmid .=
' FROM '.MAIN_DB_PREFIX.
'payment_loan as pl, '.MAIN_DB_PREFIX.
'loan as l';
610 $sqlmid .=
' WHERE l.rowid = pl.fk_loan AND pl.fk_bank = '.((int) $obj->rowid);
612 dol_syslog(
"accountancy/journal/bankjournal.php:: sqlmid=".$sqlmid, LOG_DEBUG);
613 $resultmid = $db->query($sqlmid);
615 $objmid = $db->fetch_object($resultmid);
616 $tabtp[$obj->rowid][$objmid->accountancy_account_capital] = isset($objmid->amount_capital) ? ($tabtp[$obj->rowid][$objmid->accountancy_account_capital] ?? 0) - $objmid->amount_capital : 0;
617 $tabtp[$obj->rowid][$objmid->accountancy_account_insurance] = isset($objmid->amount_insurance) ? ($tabtp[$obj->rowid][$objmid->accountancy_account_insurance] ?? 0) - $objmid->amount_insurance : 0;
618 $tabtp[$obj->rowid][$objmid->accountancy_account_interest] = isset($objmid->amount_interest) ? ($tabtp[$obj->rowid][$objmid->accountancy_account_interest] ?? 0) - $objmid->amount_interest : 0;
620 } elseif ($links[$key][
'type'] ==
'banktransfert') {
621 $accountLinestatic->fetch($links[$key][
'url_id']);
622 $tabpay[$obj->rowid][
"lib"] .=
' '.$langs->trans(
"BankTransfer").
' '.$accountLinestatic ->getNomUrl(1);
623 $tabtp[$obj->rowid][$account_transfer] = isset($tabtp[$obj->rowid][$account_transfer]) ? $tabtp[$obj->rowid][$account_transfer] + $amounttouse : $amounttouse;
624 $bankaccountstatic->fetch($tabpay[$obj->rowid][
'fk_bank_account']);
625 $tabpay[$obj->rowid][
"soclib"] = $bankaccountstatic->getNomUrl(2);
630 if (empty($tabbq[$obj->rowid][$compta_bank])) {
631 $tabbq[$obj->rowid][$compta_bank] = $amounttouse;
633 $tabbq[$obj->rowid][$compta_bank] += $amounttouse;
638 if (empty($tabtp[$obj->rowid]) && !empty($tabmoreinfo[$obj->rowid][
'withdraw'])) {
639 foreach ($links as $key => $val) {
640 if ($links[$key][
'type'] ==
'payment') {
642 $tmppayment->fetch($links[$key][
'url_id']);
643 $arrayofamounts = $tmppayment->getAmountsArray();
644 if (is_array($arrayofamounts)) {
645 foreach ($arrayofamounts as $invoiceid => $amount) {
646 $tmpinvoice->fetch($invoiceid);
647 $tmpinvoice->fetch_thirdparty();
648 if ($tmpinvoice->thirdparty->code_compta_client) {
649 $tabtp[$obj->rowid][$tmpinvoice->thirdparty->code_compta_client] += $amount;
658 if (empty($tabtp[$obj->rowid])) {
659 $tabtp[$obj->rowid][
'NotDefined'] = $tabbq[$obj->rowid][$compta_bank];
671if (!$error && $action ==
'writebookkeeping' && $user->hasRight(
'accounting',
'bind',
'write')) {
675 $accountingaccountcustomer->fetch(0,
getDolGlobalString(
'ACCOUNTING_ACCOUNT_CUSTOMER'),
true);
678 $accountingaccountsupplier->fetch(0,
getDolGlobalString(
'ACCOUNTING_ACCOUNT_SUPPLIER'),
true);
681 $accountingaccountpayment->fetch(0,
getDolGlobalString(
'SALARIES_ACCOUNTING_ACCOUNT_PAYMENT'),
true);
684 $accountingaccountexpensereport->fetch(0,
getDolGlobalString(
'ACCOUNTING_ACCOUNT_EXPENSEREPORT'),
true);
687 $accountingaccountsuspense->fetch(0,
getDolGlobalString(
'ACCOUNTING_ACCOUNT_SUSPENSE'),
true);
690 foreach ($tabpay as $key => $val) {
705 if (is_array($tabbq[$key])) {
707 foreach ($tabbq[$key] as $k => $mt) {
709 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
711 $accountingaccount->fetch(0, $k,
true);
712 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
714 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
717 $account_label = $accountingaccount->label;
720 if (!empty($val[
'lib'])) {
724 if (!empty($val[
'soclib'])) {
725 $reflabel .=
" / ".dol_string_nohtmltag($val[
'soclib']);
729 $bookkeeping->doc_date = $val[
"date"];
730 $bookkeeping->doc_ref = $ref;
731 $bookkeeping->doc_type =
'bank';
732 $bookkeeping->fk_doc = $key;
733 $bookkeeping->fk_docdet = $val[
"fk_bank"];
735 $bookkeeping->numero_compte = $k;
736 $bookkeeping->label_compte = $account_label;
738 $bookkeeping->label_operation = $reflabel;
739 $bookkeeping->montant = $mt;
740 $bookkeeping->sens = ($mt >= 0) ?
'D' :
'C';
741 $bookkeeping->debit = ($mt >= 0 ? $mt : 0);
742 $bookkeeping->credit = ($mt < 0 ? -$mt : 0);
743 $bookkeeping->code_journal = $journal;
744 $bookkeeping->journal_label = $langs->transnoentities($journal_label);
745 $bookkeeping->fk_user_author = $user->id;
746 $bookkeeping->date_creation = $now;
749 $bookkeeping->subledger_account =
'';
750 $bookkeeping->label_operation = $reflabel;
751 $bookkeeping->entity =
$conf->entity;
753 $totaldebit += $bookkeeping->debit;
754 $totalcredit += $bookkeeping->credit;
756 $result = $bookkeeping->create($user);
758 if ($bookkeeping->error ==
'BookkeepingRecordAlreadyExists') {
761 setEventMessages(
'Transaction for ('.$bookkeeping->doc_type.
', '.$bookkeeping->fk_doc.
', '.$bookkeeping->fk_docdet.
') were already recorded',
null,
'warnings');
773 if (!$errorforline) {
774 if (is_array($tabtp[$key])) {
776 foreach ($tabtp[$key] as $k => $mt) {
781 if (!empty($val[
'lib'])) {
784 if ($tabtype[$key] ==
'banktransfert') {
785 $reflabel .=
dol_string_nohtmltag($langs->transnoentitiesnoconv(
'TransitionalAccount').
' '.$account_transfer);
791 $bookkeeping->doc_date = $val[
"date"];
792 $bookkeeping->doc_ref = $ref;
793 $bookkeeping->doc_type =
'bank';
794 $bookkeeping->fk_doc = $key;
795 $bookkeeping->fk_docdet = $val[
"fk_bank"];
797 $bookkeeping->label_operation = $reflabel;
798 $bookkeeping->montant = $mt;
799 $bookkeeping->sens = ($mt < 0) ?
'D' :
'C';
800 $bookkeeping->debit = ($mt < 0 ? -$mt : 0);
801 $bookkeeping->credit = ($mt >= 0) ? $mt : 0;
802 $bookkeeping->code_journal = $journal;
803 $bookkeeping->journal_label = $langs->transnoentities($journal_label);
804 $bookkeeping->fk_user_author = $user->id;
805 $bookkeeping->date_creation = $now;
807 if ($tabtype[$key] ==
'payment') {
809 $bookkeeping->subledger_account = $k;
810 $bookkeeping->subledger_label = $tabcompany[$key][
'name'];
811 $bookkeeping->numero_compte = $tabcompany[$key][
'accountancy_code_general'];
812 $bookkeeping->label_compte = $accountingaccountcustomer->label;
813 } elseif ($tabtype[$key] ==
'payment_supplier') {
815 $bookkeeping->subledger_account = $k;
816 $bookkeeping->subledger_label = $tabcompany[$key][
'name'];
817 $bookkeeping->numero_compte = $tabcompany[$key][
'accountancy_code_general'];
818 $bookkeeping->label_compte = $accountingaccountsupplier->label;
819 } elseif ($tabtype[$key] ==
'payment_expensereport') {
820 $bookkeeping->subledger_account = $tabuser[$key][
'accountancy_code'];
821 $bookkeeping->subledger_label = $tabuser[$key][
'name'];
823 $bookkeeping->label_compte = $accountingaccountexpensereport->label;
824 } elseif ($tabtype[$key] ==
'payment_salary') {
825 $bookkeeping->subledger_account = $tabuser[$key][
'accountancy_code'];
826 $bookkeeping->subledger_label = $tabuser[$key][
'name'];
827 $bookkeeping->numero_compte = $tabuser[$key][
'accountancy_code_general'];
828 $bookkeeping->label_compte = $accountingaccountpayment->label;
829 } elseif (in_array($tabtype[$key], array(
'sc',
'payment_sc'))) {
830 $bookkeeping->subledger_account =
'';
831 $bookkeeping->subledger_label =
'';
832 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
834 $accountingaccount->fetch(0, $k,
true);
835 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
837 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
839 $bookkeeping->numero_compte = $k;
840 $bookkeeping->label_compte = $accountingaccount->label;
841 } elseif ($tabtype[$key] ==
'payment_vat') {
842 $bookkeeping->subledger_account =
'';
843 $bookkeeping->subledger_label =
'';
844 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
846 $accountingaccount->fetch(0, $k,
true);
847 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
849 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
851 $bookkeeping->numero_compte = $k;
852 $bookkeeping->label_compte = $accountingaccount->label;
853 } elseif ($tabtype[$key] ==
'payment_donation') {
854 $bookkeeping->subledger_account =
'';
855 $bookkeeping->subledger_label =
'';
856 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
858 $accountingaccount->fetch(0, $k,
true);
859 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
861 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
863 $bookkeeping->numero_compte = $k;
864 $bookkeeping->label_compte = $accountingaccount->label;
865 } elseif ($tabtype[$key] ==
'member') {
866 $bookkeeping->subledger_account =
'';
867 $bookkeeping->subledger_label =
'';
868 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
870 $accountingaccount->fetch(0, $k,
true);
871 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
873 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
875 $bookkeeping->numero_compte = $k;
876 $bookkeeping->label_compte = $accountingaccount->label;
877 } elseif ($tabtype[$key] ==
'payment_loan') {
878 $bookkeeping->subledger_account =
'';
879 $bookkeeping->subledger_label =
'';
880 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
882 $accountingaccount->fetch(0, $k,
true);
883 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
885 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
887 $bookkeeping->numero_compte = $k;
888 $bookkeeping->label_compte = $accountingaccount->label;
889 } elseif ($tabtype[$key] ==
'payment_various') {
890 $bookkeeping->subledger_account = $k;
891 $bookkeeping->subledger_label = $tabcompany[$key][
'name'];
892 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$tabpay[$key][
"account_various"]])) {
894 $accountingaccount->fetch(0, $tabpay[$key][
"account_various"],
true);
895 $conf->cache[
'accountingaccountincurrententity'][$tabpay[$key][
"account_various"]] = $accountingaccount;
897 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$tabpay[$key][
"account_various"]];
899 $bookkeeping->numero_compte = $tabpay[$key][
"account_various"];
900 $bookkeeping->label_compte = $accountingaccount->label;
901 } elseif ($tabtype[$key] ==
'banktransfert') {
902 $bookkeeping->subledger_account =
'';
903 $bookkeeping->subledger_label =
'';
904 if (empty(
$conf->cache[
'accountingaccountincurrententity'][$k])) {
906 $accountingaccount->fetch(0, $k,
true);
907 $conf->cache[
'accountingaccountincurrententity'][$k] = $accountingaccount;
909 $accountingaccount =
$conf->cache[
'accountingaccountincurrententity'][$k];
911 $bookkeeping->numero_compte = $k;
912 $bookkeeping->label_compte = $accountingaccount->label;
914 if ($tabtype[$key] ==
'unknown') {
916 $bookkeeping->subledger_account =
'';
917 $bookkeeping->subledger_label =
'';
919 $bookkeeping->label_compte = $accountingaccountsuspense->label;
922 $bookkeeping->label_operation = $reflabel;
923 $bookkeeping->entity =
$conf->entity;
925 $totaldebit += $bookkeeping->debit;
926 $totalcredit += $bookkeeping->credit;
928 $result = $bookkeeping->create($user);
930 if ($bookkeeping->error ==
'BookkeepingRecordAlreadyExists') {
933 setEventMessages(
'Transaction for ('.$bookkeeping->doc_type.
', '.$bookkeeping->fk_doc.
', '.$bookkeeping->fk_docdet.
') were already recorded',
null,
'warnings');
941 require_once DOL_DOCUMENT_ROOT .
'/accountancy/class/lettering.class.php';
943 $nb_lettering = $lettering_static->bookkeepingLetteringAll(array($bookkeeping->id));
949 foreach ($tabbq[$key] as $k => $mt) {
952 if (!empty($val[
'lib'])) {
958 $bookkeeping->doc_date = $val[
"date"];
959 $bookkeeping->doc_ref = $ref;
960 $bookkeeping->doc_type =
'bank';
961 $bookkeeping->fk_doc = $key;
962 $bookkeeping->fk_docdet = $val[
"fk_bank"];
963 $bookkeeping->montant = $mt;
964 $bookkeeping->sens = ($mt < 0) ?
'D' :
'C';
965 $bookkeeping->debit = ($mt < 0 ? -$mt : 0);
966 $bookkeeping->credit = ($mt >= 0) ? $mt : 0;
967 $bookkeeping->code_journal = $journal;
968 $bookkeeping->journal_label = $langs->transnoentities($journal_label);
969 $bookkeeping->fk_user_author = $user->id;
970 $bookkeeping->date_creation = $now;
971 $bookkeeping->label_compte =
'';
972 $bookkeeping->label_operation = $reflabel;
973 $bookkeeping->entity =
$conf->entity;
975 $totaldebit += $bookkeeping->debit;
976 $totalcredit += $bookkeeping->credit;
978 $result = $bookkeeping->create($user);
981 if ($bookkeeping->error ==
'BookkeepingRecordAlreadyExists') {
984 setEventMessages(
'Transaction for ('.$bookkeeping->doc_type.
', '.$bookkeeping->fk_doc.
', '.$bookkeeping->fk_docdet.
') were already recorded',
null,
'warnings');
999 setEventMessages(
'We tried to insert a non balanced transaction in book for '.$ref.
'. Canceled. Surely a bug.',
null,
'errors');
1002 if (!$errorforline) {
1009 if ($error >= $MAXNBERRORS) {
1010 setEventMessages($langs->trans(
"ErrorTooManyErrorsProcessStopped").
' (>'.$MAXNBERRORS.
')',
null,
'errors');
1016 if (empty($error) && count($tabpay) > 0) {
1018 } elseif (count($tabpay) == $error) {
1021 setEventMessages($langs->trans(
"GeneralLedgerSomeRecordWasNotRecorded"),
null,
'warnings');
1027 if (count($tabpay) != $error) {
1028 $param =
'id_journal='.$id_journal;
1029 $param .=
'&date_startday='.$date_startday;
1030 $param .=
'&date_startmonth='.$date_startmonth;
1031 $param .=
'&date_startyear='.$date_startyear;
1032 $param .=
'&date_endday='.$date_endday;
1033 $param .=
'&date_endmonth='.$date_endmonth;
1034 $param .=
'&date_endyear='.$date_endyear;
1035 $param .=
'&in_bookkeeping='.$in_bookkeeping;
1036 header(
"Location: ".$_SERVER[
'PHP_SELF'].($param ?
'?'.$param :
''));
1044if ($action ==
'exportcsv' && $user->hasRight(
'accounting',
'bind',
'write')) {
1047 $filename =
'journal';
1048 $type_export =
'journal';
1049 include DOL_DOCUMENT_ROOT.
'/accountancy/tpl/export_journal.tpl.php';
1052 print
'"'.$langs->transnoentitiesnoconv(
"BankId").
'"'.$sep;
1053 print
'"'.$langs->transnoentitiesnoconv(
"Date").
'"'.$sep;
1054 print
'"'.$langs->transnoentitiesnoconv(
"PaymentMode").
'"'.$sep;
1055 print
'"'.$langs->transnoentitiesnoconv(
"AccountAccounting").
'"'.$sep;
1056 print
'"'.$langs->transnoentitiesnoconv(
"SubledgerAccount").
'"'.$sep;
1057 print
'"'.$langs->transnoentitiesnoconv(
"Label").
'"'.$sep;
1058 print
'"'.$langs->transnoentitiesnoconv(
"AccountingDebit").
'"'.$sep;
1059 print
'"'.$langs->transnoentitiesnoconv(
"AccountingCredit").
'"'.$sep;
1060 print
'"'.$langs->transnoentitiesnoconv(
"Journal").
'"'.$sep;
1061 print
'"'.$langs->transnoentitiesnoconv(
"Note").
'"'.$sep;
1064 foreach ($tabpay as $key => $val) {
1070 foreach ($tabbq[$key] as $k => $mt) {
1073 if (!empty($val[
'lib'])) {
1077 if (!empty($val[
'soclib'])) {
1078 $reflabel .=
" / ".dol_string_nohtmltag($val[
'soclib']);
1081 print
'"'.$key.
'"'.$sep;
1082 print
'"'.$date.
'"'.$sep;
1083 print
'"'.$val[
"type_payment"].
'"'.$sep;
1084 print
'"'.length_accountg(html_entity_decode($k)).
'"'.$sep;
1086 print
'"'.$reflabel.
'"'.$sep;
1087 print
'"'.($mt >= 0 ?
price($mt) :
'').
'"'.$sep;
1088 print
'"'.($mt < 0 ?
price(-$mt) :
'').
'"'.$sep;
1089 print
'"'.$journal.
'"'.$sep;
1090 print
'"'.dol_string_nohtmltag($ref).
'"'.$sep;
1096 if (is_array($tabtp[$key])) {
1097 foreach ($tabtp[$key] as $k => $mt) {
1100 if (!empty($val[
'lib'])) {
1103 if ($tabtype[$key] ==
'banktransfert') {
1104 $reflabel .=
dol_string_nohtmltag($langs->transnoentitiesnoconv(
'TransitionalAccount').
' '.$account_transfer);
1109 print
'"'.$key.
'"'.$sep;
1110 print
'"'.$date.
'"'.$sep;
1111 print
'"'.$val[
"type_payment"].
'"'.$sep;
1112 if ($tabtype[$key] ==
'payment_supplier') {
1113 $account_ledger = (!empty($obj->accountancy_code_supplier_general)) ? $obj->accountancy_code_supplier_general : $account_supplier;
1114 print
'"'.length_accountg($account_ledger).
'"'.$sep;
1115 } elseif ($tabtype[$key] ==
'payment') {
1116 $account_ledger = (!empty($obj->accountancy_code_customer_general)) ? $obj->accountancy_code_customer_general : $account_customer;
1117 print
'"'.length_accountg($account_ledger).
'"'.$sep;
1118 } elseif ($tabtype[$key] ==
'payment_expensereport') {
1119 print
'"'.length_accountg(
getDolGlobalString(
'ACCOUNTING_ACCOUNT_EXPENSEREPORT')).
'"'.$sep;
1120 } elseif ($tabtype[$key] ==
'payment_salary') {
1121 $account_ledger = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
1122 print
'"'.length_accountg($account_ledger).
'"'.$sep;
1124 print
'"'.length_accountg(html_entity_decode($k)).
'"'.$sep;
1126 print
'"'.length_accounta(html_entity_decode($k)).
'"'.$sep;
1127 print
'"'.$reflabel.
'"'.$sep;
1128 print
'"'.($mt < 0 ?
price(-$mt) :
'').
'"'.$sep;
1129 print
'"'.($mt >= 0 ?
price($mt) :
'').
'"'.$sep;
1130 print
'"'.$journal.
'"'.$sep;
1131 print
'"'.dol_string_nohtmltag($ref).
'"'.$sep;
1136 foreach ($tabbq[$key] as $k => $mt) {
1139 if (!empty($val[
'lib'])) {
1144 print
'"'.$key.
'"'.$sep;
1145 print
'"'.$date.
'"'.$sep;
1146 print
'"'.$val[
"type_payment"].
'"'.$sep;
1147 print
'"'.length_accountg(
getDolGlobalString(
'ACCOUNTING_ACCOUNT_SUSPENSE')).
'"'.$sep;
1149 print
'"'.$reflabel.
'"'.$sep;
1150 print
'"'.($mt < 0 ?
price(-$mt) :
'').
'"'.$sep;
1151 print
'"'.($mt >= 0 ?
price($mt) :
'').
'"'.$sep;
1152 print
'"'.$journal.
'"'.$sep;
1153 print
'"'.dol_string_nohtmltag($ref).
'"'.$sep;
1166$form =
new Form($db);
1168if (empty($action) || $action ==
'view') {
1169 $invoicestatic =
new Facture($db);
1172 $vatstatic =
new Tva($db);
1173 $donationstatic =
new Don($db);
1174 $loanstatic =
new Loan($db);
1175 $salarystatic =
new Salary($db);
1178 $title = $langs->trans(
"GenerationOfAccountingEntries").
' - '.$accountingjournalstatic->getNomUrl(0, 2, 1,
'', 1);
1179 $help_url =
'EN:Module_Double_Entry_Accounting|FR:Module_Comptabilité_en_Partie_Double#Génération_des_écritures_en_comptabilité';
1185 $description = $langs->trans(
"DescJournalOnlyBindedVisible").
'<br>';
1187 $listofchoices = array(
1188 'notyet' => $langs->trans(
"NotYetInGeneralLedger"),
1189 'already' => $langs->trans(
"AlreadyInGeneralLedger")
1191 $period = $form->selectDate($date_start ? $date_start : -1,
'date_start', 0, 0, 0,
'', 1, 0).
' - '.$form->selectDate($date_end ? $date_end : -1,
'date_end', 0, 0, 0,
'', 1, 0);
1192 $period .=
'<span class="valignmiddle"> - '.$langs->trans(
"JournalizationInLedgerStatus").
' </span>'.$form->selectarray(
'in_bookkeeping', $listofchoices, $in_bookkeeping, 1, 0, 0,
'', 0, 0, 0,
'',
'minwidth75 valignmiddle');
1194 $varlink =
'id_journal='.$id_journal;
1198 $listofchoices = array(
1199 1 => $langs->trans(
"TransfertAllBankLines"),
1200 2 => $langs->trans(
"TransfertOnlyConciliatedBankLine")
1202 $moreoptions = [
"BankLineConciliated" => $form->selectarray(
'only_rappro', $listofchoices, $only_rappro, 0, 0, 0,
'', 0, 0, 0,
'',
'minwidth75 valignmiddle')];
1204 journalHead($nom,
'', $period, $periodlink, $description, $builddate, $exportlink, array(
'action' =>
''),
'', $varlink, $moreoptions);
1211 $sql =
"SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX.
"accounting_fiscalyear WHERE entity = ".((int)
$conf->entity);
1212 $resql = $db->query($sql);
1214 $obj = $db->fetch_object($resql);
1215 if ($obj->nb == 0) {
1216 print
'<br><div class="warning">'.img_warning().
' '.$langs->trans(
"TheFiscalPeriodIsNotDefined");
1217 $desc =
' : '.$langs->trans(
"AccountancyAreaDescFiscalPeriod", 4,
'{link}');
1218 $desc = str_replace(
'{link}',
'<strong>'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"Setup").
"-".$langs->transnoentitiesnoconv(
"FiscalPeriod").
'</strong>', $desc);
1228 $sql =
"SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX.
"bank_account WHERE entity = ".((int)
$conf->entity).
" AND fk_accountancy_journal IS NULL AND clos=0";
1229 $resql = $db->query($sql);
1231 $obj = $db->fetch_object($resql);
1233 print
'<br><div class="warning">'.img_warning().
' '.$langs->trans(
"TheJournalCodeIsNotDefinedOnSomeBankAccount");
1234 $desc =
' : '.$langs->trans(
"AccountancyAreaDescBank", 6,
'{link}');
1235 $desc = str_replace(
'{link}',
'<strong>'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"Setup").
"-".$langs->transnoentitiesnoconv(
"BankAccounts").
'</strong>', $desc);
1251 print($desc ?
'' :
'<br>').
'<div class="warning">'.
img_warning().
' '.$langs->trans(
"SomeMandatoryStepsOfSetupWereNotDone");
1252 $desc =
' : '.$langs->trans(
"AccountancyAreaDescMisc", 4,
'{link}');
1253 $desc = str_replace(
'{link}',
'<strong>'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"Setup").
"-".$langs->transnoentitiesnoconv(
"MenuDefaultAccounts").
'</strong>', $desc);
1259 print
'<br><div class="tabsAction tabsActionNoBottom centerimp">';
1261 if (
getDolGlobalString(
'ACCOUNTING_ENABLE_EXPORT_DRAFT_JOURNAL') && $in_bookkeeping ==
'notyet') {
1262 print
'<input type="button" class="butAction" name="exportcsv" value="'.$langs->trans(
"ExportDraftJournal").
'" onclick="launch_export();" />';
1267 print
'<input type="button" class="butActionRefused classfortooltip" title="'.dol_escape_htmltag($langs->trans(
"SomeMandatoryStepsOfSetupWereNotDone")).
'" value="'.$langs->trans(
"WriteBookKeeping").
'" />';
1269 if ($in_bookkeeping ==
'notyet') {
1270 print
'<input type="button" class="butAction" name="writebookkeeping" value="'.$langs->trans(
"WriteBookKeeping").
'" onclick="writebookkeeping();" />';
1272 print
'<a class="butActionRefused classfortooltip" name="writebookkeeping">'.$langs->trans(
"WriteBookKeeping").
'</a>';
1280 <script type="text/javascript">
1281 function launch_export() {
1282 console.log("Set value into form and submit");
1283 $("div.fiche form input[name=\"action\"]").val("exportcsv");
1284 $("div.fiche form input[type=\"submit\"]").click();
1285 $("div.fiche form input[name=\"action\"]").val("");
1287 function writebookkeeping() {
1288 console.log("Set value into form and submit");
1289 $("div.fiche form input[name=\"action\"]").val("writebookkeeping");
1290 $("div.fiche form input[type=\"submit\"]").click();
1291 $("div.fiche form input[name=\"action\"]").val("");
1301 print
'<div class="div-table-responsive">';
1302 print
'<table class="noborder centpercent">';
1303 print
'<tr class="liste_titre">';
1304 print
"<td>".$langs->trans(
"Date").
"</td>";
1305 print
"<td>".$langs->trans(
"Piece").
' ('.$langs->trans(
"ObjectsRef").
")</td>";
1306 print
"<td>".$langs->trans(
"AccountAccounting").
"</td>";
1307 print
"<td>".$langs->trans(
"SubledgerAccount").
"</td>";
1308 print
"<td>".$langs->trans(
"LabelOperation").
"</td>";
1309 print
'<td class="center">'.$langs->trans(
"PaymentMode").
"</td>";
1310 print
'<td class="right">'.$langs->trans(
"AccountingDebit").
"</td>";
1311 print
'<td class="right">'.$langs->trans(
"AccountingCredit").
"</td>";
1314 foreach ($tabpay as $key => $val) {
1320 foreach ($tabbq[$key] as $k => $mt) {
1323 if (!empty($val[
'lib'])) {
1324 $reflabel .= $val[
'lib'].
" / ";
1326 $reflabel .= $langs->trans(
"Bank").
' '.$val[
'bank_account_ref'];
1327 if (!empty($val[
'soclib'])) {
1328 $reflabel .=
" / ".$val[
'soclib'];
1332 print
'<!-- Bank bank.rowid='.$key.
'=accounting_bookkeeping.fk_doc (accounting_bookkeeping.doc_type=\'bank\') type='.$tabpay[$key][
'type'].
' ref='.$tabpay[$key][
'ref'].
' -->';
1333 print
'<tr class="oddeven">';
1336 print
"<td>".$date.
"</td>";
1339 print
'<td class="maxwidth300 nopaddingtopimp nopaddingbottomimp">'.dol_escape_htmltag($ref).
"</td>";
1343 if (empty($accounttoshow) || $accounttoshow ==
'NotDefined') {
1344 $accounttoshow =
'<span class="error">'.$langs->trans(
"BankAccountNotDefined").
'</span>';
1346 print
'<td class="maxwidth300" title="'.dol_escape_htmltag(
dol_string_nohtmltag($accounttoshow)).
'">';
1347 print $accounttoshow;
1351 print
'<td class="maxwidth300">';
1361 print
'<td class="maxwidth300 nopaddingtopimp nopaddingbottomimp">';
1365 print
'<td class="center">'.$val[
"type_payment"].
"</td>";
1366 print
'<td class="right nowraponall amount">'.($mt >= 0 ?
price($mt) :
'').
"</td>";
1367 print
'<td class="right nowraponall amount">'.($mt < 0 ?
price(-$mt) :
'').
"</td>";
1375 if (is_array($tabtp[$key])) {
1376 foreach ($tabtp[$key] as $k => $mt) {
1379 if (!empty($val[
'lib'])) {
1380 $reflabel .= $val[
'lib'].(!empty($val[
'soclib']) ?
" / " :
"");
1382 if ($tabtype[$key] ==
'banktransfert') {
1383 $reflabel .= $langs->trans(
'TransitionalAccount').
' '.$account_transfer;
1385 $reflabel .= isset($val[
'soclib']) ? $val[
'soclib'] :
"";
1388 print
'<!-- Thirdparty bank.rowid='.$key.
'=accounting_bookkeeping.fk_doc (accounting_bookkeeping.doc_type=\'bank\') type='.$tabpay[$key][
'type'].
' ref='.$tabpay[$key][
'ref'].
' -->';
1389 print
'<tr class="oddeven">';
1392 print
"<td>".$date.
"</td>";
1395 print
'<td class="nopaddingtopimp nopaddingbottomimp">'.dol_escape_htmltag($ref).
"</td>";
1399 $account_ledger = $k;
1401 if ($tabtype[$key] ==
'payment') {
1402 $account_ledger = (!empty($obj->accountancy_code_customer_general)) ? $obj->accountancy_code_customer_general : $account_customer;
1404 if ($tabtype[$key] ==
'payment_supplier') {
1405 $account_ledger = (!empty($obj->accountancy_code_supplier_general)) ? $obj->accountancy_code_supplier_general : $account_supplier;
1407 if ($tabtype[$key] ==
'payment_expensereport') {
1410 if ($tabtype[$key] ==
'payment_salary') {
1411 $account_ledger = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
1413 if ($tabtype[$key] ==
'payment_vat') {
1416 if ($tabtype[$key] ==
'member') {
1419 if ($tabtype[$key] ==
'payment_various') {
1420 $account_ledger = $tabpay[$key][
"account_various"];
1423 if (empty($accounttoshow) || $accounttoshow ==
'NotDefined') {
1424 if ($tabtype[$key] ==
'unknown') {
1427 $accounttoshow =
'<span class="error small">'.$langs->trans(
'UnknownAccountForThirdpartyAndWaitingAccountNotDefinedBlocking').
'</span>';
1429 $accounttoshow =
'<span class="warning small">'.$langs->trans(
'UnknownAccountForThirdparty',
length_accountg(
getDolGlobalString(
'ACCOUNTING_ACCOUNT_SUSPENSE'))).
'</span>';
1433 $errorstring =
'UnknownAccountForThirdpartyBlocking';
1434 if ($tabtype[$key] ==
'payment') {
1435 $errorstring =
'MainAccountForCustomersNotDefined';
1437 if ($tabtype[$key] ==
'payment_supplier') {
1438 $errorstring =
'MainAccountForSuppliersNotDefined';
1440 if ($tabtype[$key] ==
'payment_expensereport') {
1441 $errorstring =
'MainAccountForUsersNotDefined';
1443 if ($tabtype[$key] ==
'payment_salary') {
1444 $errorstring =
'MainAccountForUsersNotDefined';
1446 if ($tabtype[$key] ==
'payment_vat') {
1447 $errorstring =
'MainAccountForVatPaymentNotDefined';
1449 if ($tabtype[$key] ==
'member') {
1450 $errorstring =
'MainAccountForSubscriptionPaymentNotDefined';
1452 $accounttoshow =
'<span class="error small">'.$langs->trans($errorstring).
'</span>';
1455 print
'<td class="maxwidth300" title="'.dol_escape_htmltag(
dol_string_nohtmltag($accounttoshow)).
'">';
1456 print $accounttoshow;
1460 $accounttoshowsubledger =
'';
1461 if (in_array($tabtype[$key], array(
'payment',
'payment_supplier',
'payment_expensereport',
'payment_salary',
'payment_various'))) {
1463 if ($accounttoshow != $accounttoshowsubledger) {
1464 if (empty($accounttoshowsubledger) || $accounttoshowsubledger ==
'NotDefined') {
1466 if (!empty($tabcompany[$key][
'code_compta'])) {
1467 if (in_array($tabtype[$key], array(
'payment_various'))) {
1469 $accounttoshowsubledger =
'<span class="warning small twolinesmax">'.$langs->trans(
"ThirdpartyAccountNotDefinedOrThirdPartyUnknownSubledgerIgnored").
'</span>';
1470 } elseif (in_array($tabtype[$key], array(
'payment_salary'))) {
1471 $accounttoshowsubledger =
'<span class="warning small twolinesmax">'.$langs->trans(
"ThirdpartyAccountNotDefinedOrThirdPartyUnknownSubledgerIgnored2").
'</span>';
1473 $accounttoshowsubledger =
'<span class="warning small twolinesmax">'.$langs->trans(
"ThirdpartyAccountNotDefinedOrThirdPartyUnknown", $tabcompany[$key][
'code_compta']).
'</span>';
1476 $accounttoshowsubledger =
'<span class="error small twolinesmax">'.$langs->trans(
"ThirdpartyAccountNotDefinedOrThirdPartyUnknownBlocking").
'</span>';
1480 $accounttoshowsubledger =
'';
1483 print
'<td class="maxwidth300 nopaddingtopimp nopaddingbottomimp" title="'.dolPrintHTMLForAttribute(
dol_string_nohtmltag($accounttoshowsubledger)).
'">';
1484 print $accounttoshowsubledger;
1488 print
'<td class="nopaddingtopimpo paddingbottomimp">';
1492 print
'<td class="center">'.$val[
"type_payment"].
"</td>";
1494 print
'<td class="right nowraponall amount">'.($mt < 0 ?
price(-$mt) :
'').
"</td>";
1496 print
'<td class="right nowraponall amount">'.($mt >= 0 ?
price($mt) :
'').
"</td>";
1504 foreach ($tabbq[$key] as $k => $mt) {
1507 if (!empty($val[
'lib'])) {
1508 $reflabel .= $val[
'lib'].
" / ";
1510 $reflabel .=
'WaitingAccount';
1512 print
'<!-- Wait bank.rowid='.$key.
' -->';
1513 print
'<tr class="oddeven">';
1514 print
"<td>".$date.
"</td>";
1515 print
"<td>".$ref.
"</td>";
1528 print
"<td>".dol_escape_htmltag($reflabel).
"</td>";
1529 print
'<td class="center">'.$val[
"type_payment"].
"</td>";
1530 print
'<td class="right nowraponall amount">'.($mt < 0 ?
price(-$mt) :
'').
"</td>";
1531 print
'<td class="right nowraponall amount">'.($mt >= 0 ?
price($mt) :
'').
"</td>";
1542 print
'<tr class="oddeven"><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1569 if ($ref ==
'(SupplierInvoicePayment)' || $ref ==
'(SupplierInvoicePaymentBack)') {
1570 $ref = $langs->transnoentitiesnoconv(
'Supplier');
1572 if ($ref ==
'(CustomerInvoicePayment)' || $ref ==
'(CustomerInvoicePaymentBack)') {
1573 $ref = $langs->transnoentitiesnoconv(
'Customer');
1575 if ($ref ==
'(SocialContributionPayment)') {
1576 $ref = $langs->transnoentitiesnoconv(
'SocialContribution');
1578 if ($ref ==
'(DonationPayment)') {
1579 $ref = $langs->transnoentitiesnoconv(
'Donation');
1581 if ($ref ==
'(SubscriptionPayment)') {
1582 $ref = $langs->transnoentitiesnoconv(
'Subscription');
1584 if ($ref ==
'(ExpenseReportPayment)') {
1585 $ref = $langs->transnoentitiesnoconv(
'Employee');
1587 if ($ref ==
'(LoanPayment)') {
1588 $ref = $langs->transnoentitiesnoconv(
'Loan');
1590 if ($ref ==
'(payment_salary)') {
1591 $ref = $langs->transnoentitiesnoconv(
'Employee');
1595 if ($typerecord ==
'payment') {
1597 $sqlmid =
"SELECT payfac.fk_facture as id, ".$db->ifsql(
'f1.rowid IS NULL',
'f.ref',
'f1.ref').
" as ref";
1598 $sqlmid .=
" FROM ".$db->prefix().
"paiement_facture as payfac";
1599 $sqlmid .=
" LEFT JOIN ".$db->prefix().
"facture as f ON f.rowid = payfac.fk_facture";
1600 $sqlmid .=
" LEFT JOIN ".$db->prefix().
"societe_remise_except as sre ON sre.fk_facture_source = payfac.fk_facture";
1601 $sqlmid .=
" LEFT JOIN ".$db->prefix().
"facture as f1 ON f1.rowid = sre.fk_facture";
1602 $sqlmid .=
" WHERE payfac.fk_paiement=".((int) $val[
'paymentid']);
1604 $sqlmid =
"SELECT payfac.fk_facture as id, f.ref as ref";
1605 $sqlmid .=
" FROM ".$db->prefix().
"paiement_facture as payfac";
1606 $sqlmid .=
" INNER JOIN ".$db->prefix().
"facture as f ON f.rowid = payfac.fk_facture";
1607 $sqlmid .=
" WHERE payfac.fk_paiement=".((int) $val[
'paymentid']);
1609 $ref = $langs->transnoentitiesnoconv(
"Invoice");
1610 } elseif ($typerecord ==
'payment_supplier') {
1611 $sqlmid =
'SELECT payfac.fk_facturefourn as id, f.ref';
1612 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"paiementfourn_facturefourn as payfac, ".MAIN_DB_PREFIX.
"facture_fourn as f";
1613 $sqlmid .=
" WHERE payfac.fk_facturefourn = f.rowid AND payfac.fk_paiementfourn=".((int) $val[
"paymentsupplierid"]);
1614 $ref = $langs->transnoentitiesnoconv(
"SupplierInvoice");
1615 } elseif ($typerecord ==
'payment_expensereport') {
1616 $sqlmid =
'SELECT e.rowid as id, e.ref';
1617 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"payment_expensereport as pe, ".MAIN_DB_PREFIX.
"expensereport as e";
1618 $sqlmid .=
" WHERE pe.rowid=".((int) $val[
"paymentexpensereport"]).
" AND pe.fk_expensereport = e.rowid";
1619 $ref = $langs->transnoentitiesnoconv(
"ExpenseReport");
1620 } elseif ($typerecord ==
'payment_salary') {
1621 $sqlmid =
'SELECT s.rowid as ref';
1622 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"payment_salary as s";
1623 $sqlmid .=
" WHERE s.rowid=".((int) $val[
"paymentsalid"]);
1624 $ref = $langs->transnoentitiesnoconv(
"SalaryPayment");
1625 } elseif ($typerecord ==
'sc') {
1626 $sqlmid =
'SELECT sc.rowid as ref';
1627 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"paiementcharge as sc";
1628 $sqlmid .=
" WHERE sc.rowid=".((int) $val[
"paymentscid"]);
1629 $ref = $langs->transnoentitiesnoconv(
"SocialContribution");
1630 } elseif ($typerecord ==
'payment_vat') {
1631 $sqlmid =
'SELECT v.rowid as ref';
1632 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"tva as v";
1633 $sqlmid .=
" WHERE v.rowid=".((int) $val[
"paymentvatid"]);
1634 $ref = $langs->transnoentitiesnoconv(
"PaymentVat");
1635 } elseif ($typerecord ==
'payment_donation') {
1636 $sqlmid =
'SELECT payd.fk_donation as ref';
1637 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"payment_donation as payd";
1638 $sqlmid .=
" WHERE payd.fk_donation=".((int) $val[
"paymentdonationid"]);
1639 $ref = $langs->transnoentitiesnoconv(
"Donation");
1640 } elseif ($typerecord ==
'payment_loan') {
1641 $sqlmid =
'SELECT l.rowid as ref';
1642 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"payment_loan as l";
1643 $sqlmid .=
" WHERE l.rowid=".((int) $val[
"paymentloanid"]);
1644 $ref = $langs->transnoentitiesnoconv(
"LoanPayment");
1645 } elseif ($typerecord ==
'payment_various') {
1646 $sqlmid =
'SELECT v.rowid as ref';
1647 $sqlmid .=
" FROM ".MAIN_DB_PREFIX.
"payment_various as v";
1648 $sqlmid .=
" WHERE v.rowid=".((int) $val[
"paymentvariousid"]);
1649 $ref = $langs->transnoentitiesnoconv(
"VariousPayment");
1652 if (empty($sqlmid)) {
1653 dol_syslog(
"Found a typerecord=".$typerecord.
" not supported", LOG_WARNING);
1657 dol_syslog(
"accountancy/journal/bankjournal.php::sqlmid=".$sqlmid, LOG_DEBUG);
1658 $resultmid = $db->query($sqlmid);
1660 while ($objmid = $db->fetch_object($resultmid)) {
1661 $ref .=
' '.$objmid->ref;
1668 $ref =
dol_trunc($langs->transnoentitiesnoconv(
"BankId").
' '.$val[
'fk_bank'].
' - '.$ref, 295);
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
length_accountg($account)
Return General accounting account with defined length (used for product and miscellaneous)
journalHead($nom, $variant, $period, $periodlink, $description, $builddate, $exportlink='', $moreparam=array(), $calcmode='', $varlink='', $moreoptions=array())
Show header of a page used to transfer/dispatch data in accounting.
getDefaultDatesForTransfer()
Return Default dates for transfer based on periodicity option in accountancy setup.
length_accounta($accounta)
Return Auxiliary accounting account of thirdparties with defined length.
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.
getSourceDocRef($val, $typerecord)
Return source for doc_ref of a bank transaction.
Class to manage bank accounts.
Class to manage bank transaction lines.
Class to manage accounting accounts.
Class to manage accounting journals.
Class to manage Ledger (General Ledger and Subledger)
Class for managing the social charges.
Class to manage donations.
Class to manage Trips and Expenses.
Class to manage suppliers invoices.
Class to manage invoices.
Class to manage payments for supplier invoices.
Class to manage payments of customer invoices.
Class to manage payments of donations.
Class to manage payments of expense report.
Class to manage payments of loans.
Class to manage payments of salaries.
Class to manage various payments.
Class to manage salary payments.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage subscriptions of foundation members.
Class to manage VAT - Value-added tax (also known in French as TVA - Taxe sur la valeur ajoutée)
Class to manage Dolibarr users.
dol_get_first_day($year, $month=1, $gm=false)
Return GMT time for first day of a month or year.
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
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_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.
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...
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.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.