dolibarr 23.0.4
bankjournal.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2007-2010 Laurent Destailleur <eldy@users.sourceforge.net>
3 * Copyright (C) 2007-2010 Jean Heimburger <jean@tiaris.info>
4 * Copyright (C) 2011 Juanjo Menent <jmenent@2byte.es>
5 * Copyright (C) 2012 Regis Houssin <regis.houssin@inodbox.com>
6 * Copyright (C) 2013 Christophe Battarel <christophe.battarel@altairis.fr>
7 * Copyright (C) 2013-2022 Open-DSI <support@open-dsi.fr>
8 * Copyright (C) 2013-2025 Alexandre Spangaro <alexandre@inovea-conseil.com>
9 * Copyright (C) 2013-2014 Florian Henry <florian.henry@open-concept.pro>
10 * Copyright (C) 2013-2014 Olivier Geffroy <jeff@jeffinfo.com>
11 * Copyright (C) 2017-2025 Frédéric France <frederic.france@free.fr>
12 * Copyright (C) 2018 Ferran Marcet <fmarcet@2byte.es>
13 * Copyright (C) 2018-2024 Eric Seigne <eric.seigne@cap-rel.fr>
14 * Copyright (C) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
15 * Copyright (C) 2024-2025 MDW <mdeweerd@users.noreply.github.com>
16 *
17 * This program is free software; you can redistribute it and/or modify
18 * it under the terms of the GNU General Public License as published by
19 * the Free Software Foundation; either version 3 of the License, or
20 * (at your option) any later version.
21 *
22 * This program is distributed in the hope that it will be useful,
23 * but WITHOUT ANY WARRANTY; without even the implied warranty of
24 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
25 * GNU General Public License for more details.
26 *
27 * You should have received a copy of the GNU General Public License
28 * along with this program. If not, see <https://www.gnu.org/licenses/>.
29 */
30
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';
65
74// Load translation files required by the page
75$langs->loadLangs(array("companies", "other", "compta", "banks", "bills", "donations", "loan", "accountancy", "trips", "salaries", "hrm", "members"));
76
77// Multi journal
78$id_journal = GETPOSTINT('id_journal');
79
80$date_startmonth = GETPOSTINT('date_startmonth');
81$date_startday = GETPOSTINT('date_startday');
82$date_startyear = GETPOSTINT('date_startyear');
83$date_endmonth = GETPOSTINT('date_endmonth');
84$date_endday = GETPOSTINT('date_endday');
85$date_endyear = GETPOSTINT('date_endyear');
86$in_bookkeeping = GETPOST('in_bookkeeping', 'aZ09');
87
88$only_rappro = GETPOSTINT('only_rappro');
89if ($only_rappro == 0) {
90 //GET page for the first time, use default settings
91 $only_rappro = getDolGlobalInt('ACCOUNTING_BANK_CONCILIATED');
92}
93
94$now = dol_now();
95
96$action = GETPOST('action', 'aZ09');
97
98if ($in_bookkeeping == '') {
99 $in_bookkeeping = 'notyet';
100}
101
102
103// Security check
104if (!isModEnabled('accounting')) {
106}
107if ($user->socid > 0) {
109}
110if (!$user->hasRight('accounting', 'bind', 'write')) {
112}
113
114
115/*
116 * Actions
117 */
118
119$error = 0;
120
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);
123
124$pastmonth = null; // Initialise for static analysis (could be really unseg)
125$pastmonthyear = null;
126
127if (empty($date_startmonth)) {
128 // Period by default on transfer
130 $date_start = $dates['date_start'];
131 $pastmonthyear = $dates['pastmonthyear'];
132 $pastmonth = $dates['pastmonth'];
133}
134if (empty($date_endmonth)) {
135 // Period by default on transfer
137 $date_end = $dates['date_end'];
138 $pastmonthyear = $dates['pastmonthyear'];
139 $pastmonth = $dates['pastmonth'];
140}
141
142if (!GETPOSTISSET('date_startmonth') && (empty($date_start) || empty($date_end))) { // We define date_start and date_end, only if we did not submit the form
143 $date_start = dol_get_first_day((int) $pastmonthyear, (int) $pastmonth, false);
144 $date_end = dol_get_last_day((int) $pastmonthyear, (int) $pastmonth, false);
145}
146
147// Get all bank lines
148//-------------------------------------
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,";
152if (getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
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,";
157} else {
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,";
162}
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";
173if (getDolGlobalString('MAIN_COMPANY_PERENTITY_SHARED')) {
174 $sql .= " LEFT JOIN " . $db->prefix() . "societe_perentity as spe ON spe.fk_soc = soc.rowid AND spe.entity = " . ((int) $conf->entity);
175}
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).")"; // We don't share object for accountancy
179if ($date_start && $date_end) {
180 $sql .= " AND b.dateo >= '".$db->idate($date_start)."' AND b.dateo <= '".$db->idate($date_end)."'";
181}
182// Define begin binding date
183if (getDolGlobalInt('ACCOUNTING_DATE_START_BINDING')) {
184 $sql .= " AND b.dateo >= '".$db->idate(getDolGlobalInt('ACCOUNTING_DATE_START_BINDING'))."'";
185}
186// Already in bookkeeping or not
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') )";
189}
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') )";
192}
193if ($only_rappro == 2) {
194 $sql .= " AND (b.rappro = '1')";
195}
196$sql .= " ORDER BY b.datev";
197//print $sql;
198
199// Preload payment account codes by payment type from c_paiement
200$accountancy_code_by_payment = array();
201$sql2 = "SELECT code, accountancy_code";
202$sql2 .= " FROM ".MAIN_DB_PREFIX."c_paiement";
203$sql2 .= " WHERE entity IN (".getEntity('c_paiement').")";
204$sql2 .= " AND active = 1";
205$resql = $db->query($sql2);
206if ($resql) {
207 while ($objp = $db->fetch_object($resql)) {
208 if (!empty($objp->code) && !empty($objp->accountancy_code)) {
209 $accountancy_code_by_payment[$objp->code] = $objp->accountancy_code;
210 }
211 }
212}
213
214$object = new Account($db);
215$paymentstatic = new Paiement($db);
216$paymentsupplierstatic = new PaiementFourn($db);
217$societestatic = new Societe($db);
218$userstatic = new User($db);
219$bankaccountstatic = new Account($db);
220$chargestatic = new ChargeSociales($db);
221$paymentdonstatic = new PaymentDonation($db);
222$paymentvatstatic = new Tva($db);
223$paymentsalstatic = new PaymentSalary($db);
224$paymentexpensereportstatic = new PaymentExpenseReport($db);
225$paymentvariousstatic = new PaymentVarious($db);
226$paymentloanstatic = new PaymentLoan($db);
227$accountLinestatic = new AccountLine($db);
228$paymentsubscriptionstatic = new Subscription($db);
229
230$tmppayment = new Paiement($db);
231$tmpinvoice = new Facture($db);
232
233$accountingaccount = new AccountingAccount($db);
234$account_transfer = 'NotDefined'; // For static analysis, NotDefined is a reserved word
235
236// Get code of finance journal
237$accountingjournalstatic = new AccountingJournal($db);
238$accountingjournalstatic->fetch($id_journal);
239$journal = $accountingjournalstatic->code;
240$journal_label = $accountingjournalstatic->label;
241
242$tabcompany = array();
243$tabuser = array();
244$tabpay = array();
245$tabbq = array();
246$tabtp = array();
247$tabtype = array();
248$tabmoreinfo = array();
249
250'
251@phan-var-force array<array{id:mixed,name:mixed,code_compta_client:string,email:string}> $tabcompany
252@phan-var-force array<array{id:int,name:string,lastname:string,firstname:string,email:string,accountancy_code:string,status:int> $tabuser
253@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
254@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
255';
256
257$account_customer = 'NotDefined';
258$account_supplier = 'NotDefined';
259$account_employee = 'NotDefined';
260
261//print $sql;
262dol_syslog("accountancy/journal/bankjournal.php", LOG_DEBUG);
263$result = $db->query($sql);
264if ($result) {
265 $num = $db->num_rows($result);
266 //print $sql;
267
268 // Variables
269 $account_supplier = getDolGlobalString('ACCOUNTING_ACCOUNT_SUPPLIER', 'NotDefined'); // NotDefined is a reserved word
270 $account_customer = getDolGlobalString('ACCOUNTING_ACCOUNT_CUSTOMER', 'NotDefined'); // NotDefined is a reserved word
271 $account_employee = getDolGlobalString('SALARIES_ACCOUNTING_ACCOUNT_PAYMENT', 'NotDefined'); // NotDefined is a reserved word
272 $account_expensereport = getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT', 'NotDefined'); // NotDefined is a reserved word
273 $account_pay_vat = getDolGlobalString('ACCOUNTING_VAT_PAY_ACCOUNT', 'NotDefined'); // NotDefined is a reserved word
274 $account_pay_donation = getDolGlobalString('DONATION_ACCOUNTINGACCOUNT', 'NotDefined'); // NotDefined is a reserved word
275 $account_pay_subscription = getDolGlobalString('ADHERENT_SUBSCRIPTION_ACCOUNTINGACCOUNT', 'NotDefined'); // NotDefined is a reserved word
276 $account_transfer = getDolGlobalString('ACCOUNTING_ACCOUNT_TRANSFER_CASH', 'NotDefined'); // NotDefined is a reserved word
277
278 // Loop on each line into the llx_bank table. For each line, we should get:
279 // one line tabpay = line into bank
280 // one line for bank record = tabbq
281 // one line for thirdparty record = tabtp
282 // Note: tabcompany is used to store the subledger account
283 $i = 0;
284 while ($i < $num) {
285 $obj = $db->fetch_object($result);
286
287 $lineisapurchase = -1;
288 $lineisasale = -1;
289 // Old method to detect if it's a sale or purchase
290 if ($obj->label == '(SupplierInvoicePayment)' || $obj->label == '(SupplierInvoicePaymentBack)') {
291 $lineisapurchase = 1;
292 }
293 if ($obj->label == '(CustomerInvoicePayment)' || $obj->label == '(CustomerInvoicePaymentBack)') {
294 $lineisasale = 1;
295 }
296 // Try a more reliable method to detect if record is a supplier payment or a customer payment
297 if ($lineisapurchase < 0) {
298 if ($obj->typeop_payment_supplier == 'payment_supplier') {
299 $lineisapurchase = 1;
300 }
301 }
302 if ($lineisasale < 0) {
303 if ($obj->typeop_payment == 'payment') {
304 $lineisasale = 1;
305 }
306 }
307 //var_dump($obj->type_payment); //var_dump($obj->type_payment_supplier);
308 //var_dump($lineisapurchase); //var_dump($lineisasale);
309
310 // Set accountancy code for bank
311 $compta_bank = $obj->account_number;
312
313 // Determining the bank account by payment method
314 if (!empty($obj->fk_type) && !empty($accountancy_code_by_payment[$obj->fk_type])) {
315 $compta_bank = $accountancy_code_by_payment[$obj->fk_type];
316 }
317
318 // Set accountancy code for thirdparty (example: '411CU...' or '411' if no subledger account defined on customer)
319 $compta_soc = 'NotDefined';
320 $accountancy_code_general = 'NotDefined';
321 if ($lineisapurchase > 0) {
322 $accountancy_code_general = (!empty($obj->accountancy_code_supplier_general) && $obj->accountancy_code_supplier_general != '-1') ? $obj->accountancy_code_supplier_general : $account_supplier;
323 $compta_soc = (($obj->code_compta_fournisseur != "") ? $obj->code_compta_fournisseur : $account_supplier);
324 }
325 if ($lineisasale > 0) {
326 $accountancy_code_general = (!empty($obj->accountancy_code_customer_general) && $obj->accountancy_code_customer_general != '-1') ? $obj->accountancy_code_customer_general : $account_customer;
327 $compta_soc = (!empty($obj->code_compta_client) ? $obj->code_compta_client : $account_customer);
328 }
329
330 $tabcompany[$obj->rowid] = array(
331 'id' => $obj->socid,
332 'name' => $obj->name,
333 'code_compta' => $compta_soc,
334 'accountancy_code_general' => $accountancy_code_general,
335 'email' => $obj->email
336 );
337
338 // Set accountancy code for user
339 // $obj->accountancy_code is the accountancy_code of table u=user (but it is defined only if
340 // a link with type 'user' exists and user as a subledger account)
341 $accountancy_code_user_general = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
342 $compta_user = (!empty($obj->accountancy_code) ? $obj->accountancy_code : '');
343
344 $tabuser[$obj->rowid] = array(
345 'id' => $obj->userid,
346 'name' => dolGetFirstLastname($obj->firstname, $obj->lastname),
347 'lastname' => $obj->lastname,
348 'firstname' => $obj->firstname,
349 'email' => $obj->useremail,
350 'accountancy_code_general' => $accountancy_code_user_general,
351 'accountancy_code' => $compta_user,
352 'status' => $obj->userstatus
353 );
354
355 // Variable bookkeeping ($obj->rowid is Bank Id)
356 $tabpay[$obj->rowid]["date"] = $db->jdate($obj->do);
357 $tabpay[$obj->rowid]["type_payment"] = $obj->fk_type; // CHQ, VIR, LIQ, CB, ...
358 $tabpay[$obj->rowid]["ref"] = $obj->label; // By default. Not unique. May be changed later
359 $tabpay[$obj->rowid]["fk_bank"] = $obj->rowid;
360 $tabpay[$obj->rowid]["bank_account_ref"] = $obj->baref;
361 $tabpay[$obj->rowid]["fk_bank_account"] = $obj->fk_account;
362 $reg = array();
363 if (preg_match('/^\‍((.*)\‍)$/i', $obj->label, $reg)) {
364 $tabpay[$obj->rowid]["lib"] = $langs->trans($reg[1]);
365 } else {
366 $tabpay[$obj->rowid]["lib"] = dol_trunc($obj->label, 60);
367 }
368
369 // Load of url links to the line into llx_bank (so load llx_bank_url)
370 $links = $object->get_url($obj->rowid); // Get an array('url'=>, 'url_id'=>, 'label'=>, 'type'=> 'fk_bank'=> )
371 // print '<p>' . json_encode($object) . "</p>";//exit;
372 // print '<p>' . json_encode($links) . "</p>";//exit;
373
374 // By default
375 $tabpay[$obj->rowid]['type'] = 'unknown'; // Can be SOLD, miscellaneous entry, payment of patient, or any old record with no links in bank_url.
376 $tabtype[$obj->rowid] = 'unknown';
377 $tabmoreinfo[$obj->rowid] = array();
378
379 $amounttouse = $obj->amount;
380 if (!empty($obj->amount_main_currency)) {
381 // If $obj->amount_main_currency is set, it means that $obj->amount is not in same currency, we must use $obj->amount_main_currency
382 $amounttouse = $obj->amount_main_currency;
383 }
384
385 // in case option FACTURE_PAYMENTS_ON_DIFFERENT_THIRDPARTIES_BILLS is on, payment could be for more than one third-partie
386 // so we have to find which part of the payment is affected to each third-parties
387 // (because in this case $obj-amount = the total of the paiement and not the paiement for each third-parties)
388 if (getDolGlobalString('FACTURE_PAYMENTS_ON_DIFFERENT_THIRDPARTIES_BILLS') && ($lineisapurchase == 1 || $lineisasale == 1) ) {
389 if ($lineisapurchase == 1) {
390 $sqlamount = "SELECT SUM(pf.amount) as amount";
391 $sqlamount .= " FROM ".MAIN_DB_PREFIX."paiementfourn_facturefourn AS pf";
392 $sqlamount .= " INNER JOIN ".MAIN_DB_PREFIX."paiementfourn AS p ON pf.fk_paiementfourn = p.rowid";
393 $sqlamount .= " RIGHT JOIN ".MAIN_DB_PREFIX."facture AS f ON pf.fk_facturefourn = f.rowid";
394 $sqlamount .= " WHERE p.fk_bank = ".((int) $obj->rowid);
395 $sqlamount .= " AND f.fk_soc = ".((int) $obj->socid);
396 } else {
397 $sqlamount = "SELECT SUM(pf.amount) as amount";
398 $sqlamount .= " FROM ".MAIN_DB_PREFIX."paiement_facture AS pf";
399 $sqlamount .= " INNER JOIN ".MAIN_DB_PREFIX."paiement AS p ON pf.fk_paiement = p.rowid";
400 $sqlamount .= " RIGHT JOIN ".MAIN_DB_PREFIX."facture AS f ON pf.fk_facture = f.rowid";
401 $sqlamount .= " WHERE p.fk_bank = ".((int) $obj->rowid);
402 $sqlamount .= " AND f.fk_soc = ".((int) $obj->socid);
403 }
404 $resultamount = $db->query($sqlamount);
405 if ($resultamount) {
406 $objamount = $db->fetch_object($resultamount);
407 if (!empty($objamount->amount)) $amounttouse = $objamount->amount;
408 }
409 }
410
411 // get_url may return -1 which is not traversable
412 if (is_array($links) && count($links) > 0) {
413 // Test if entry is for a social contribution, salary or expense report.
414 // In such a case, we will ignore the bank url line for user
415 $is_sc = false;
416 $is_salary = false;
417 $is_expensereport = false;
418 foreach ($links as $v) {
419 if ($v['type'] == 'sc') {
420 $is_sc = true;
421 break;
422 }
423 if ($v['type'] == 'payment_salary') {
424 $is_salary = true;
425 break;
426 }
427 if ($v['type'] == 'payment_expensereport') {
428 $is_expensereport = true;
429 break;
430 }
431 }
432
433 // Now loop on each link of record in bank (code similar to bankentries_list.php)
434 foreach ($links as $key => $val) {
435 if ($links[$key]['type'] == 'user' && !$is_sc && !$is_salary && !$is_expensereport) {
436 // We must avoid as much as possible this "continue". If we want to jump to next loop, it means we don't want to process
437 // the case the link is user (often because managed by hard coded code into another link), and we must avoid this.
438 continue;
439 }
440 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'))) {
441 // So we excluded 'company' and 'user' here. We want only payment lines
442
443 // We save tabtype for a future use, to remember what kind of payment it is
444 $tabpay[$obj->rowid]['type'] = $links[$key]['type'];
445 $tabtype[$obj->rowid] = $links[$key]['type'];
446 /* phpcs:disable -- Code does nothing at this moment -> commented
447 } elseif (in_array($links[$key]['type'], array('company', 'user'))) {
448 if ($tabpay[$obj->rowid]['type'] == 'unknown') {
449 // We can guess here it is a bank record for a thirdparty company or a user.
450 // But we won't be able to record somewhere else than into a waiting account, because there is no other journal to record the contreparty.
451 }
452 */ // phpcs::enable
453 }
454
455 // Special case to ask later to add more request to get information for old links without company link.
456 if ($links[$key]['type'] == 'withdraw') {
457 $tabmoreinfo[$obj->rowid]['withdraw'] = 1;
458 }
459
460 if ($links[$key]['type'] == 'payment') {
461 $paymentstatic->id = $links[$key]['url_id'];
462 $paymentstatic->ref = (string) $links[$key]['url_id'];
463 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentstatic->getNomUrl(2, '', ''); // TODO Do not include list of invoice in tooltip, the dol_string_nohtmltag is ko with this
464 $tabpay[$obj->rowid]["paymentid"] = $paymentstatic->id;
465 } elseif ($links[$key]['type'] == 'payment_supplier') {
466 $paymentsupplierstatic->id = $links[$key]['url_id'];
467 $paymentsupplierstatic->ref = (string) $links[$key]['url_id'];
468 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentsupplierstatic->getNomUrl(2);
469 $tabpay[$obj->rowid]["paymentsupplierid"] = $paymentsupplierstatic->id;
470 } elseif ($links[$key]['type'] == 'company') {
471 $societestatic->id = $links[$key]['url_id'];
472 $societestatic->name = $links[$key]['label'];
473 $societestatic->email = $tabcompany[$obj->rowid]['email'];
474 $tabpay[$obj->rowid]["soclib"] = $societestatic->getNomUrl(1, '', 30);
475 if ($compta_soc) {
476 // because we are in 2 loop (loop on the line from the sql queries and loop on $links)
477 // and in case of option FACTURE_PAYMENTS_ON_DIFFERENT_THIRDPARTIES_BILLS is on,
478 // we will pass here n times for each payment line
479 // so we have to add $amoutouse only if the line $links[$key] correspond to the payment line we are in used ( socid correspondinf at the payment line $links)
480 // if FACTURE_PAYMENTS_ON_DIFFERENT_THIRDPARTIES_BILLS is off we add $amounttouse
481 if (!getDolGlobalString('FACTURE_PAYMENTS_ON_DIFFERENT_THIRDPARTIES_BILLS') || $obj->socid == $links[$key]['url_id']){
482 if (empty($tabtp[$obj->rowid][$compta_soc])) {
483 $tabtp[$obj->rowid][$compta_soc] = $amounttouse;
484 } else {
485 $tabtp[$obj->rowid][$compta_soc] += $amounttouse;
486 }
487 }
488 }
489 } elseif ($links[$key]['type'] == 'user') {
490 $userstatic->id = $links[$key]['url_id'];
491 $userstatic->name = $links[$key]['label'];
492 $userstatic->email = $tabuser[$obj->rowid]['email'];
493 $userstatic->firstname = $tabuser[$obj->rowid]['firstname'];
494 $userstatic->lastname = $tabuser[$obj->rowid]['lastname'];
495 $userstatic->status = $tabuser[$obj->rowid]['status'];
496 $userstatic->accountancy_code_user_general = $tabuser[$obj->rowid]['accountancy_code_general'];
497 $userstatic->accountancy_code = $tabuser[$obj->rowid]['accountancy_code'];
498
499 // For a payment of social contribution, we have a link sc + user.
500 // but we already fill the $tabpay[$obj->rowid]["soclib"] in the line 'sc'.
501 // If we fill it here to, we must concat.
502 if ($userstatic->id > 0) {
503 if ($is_sc) {
504 $tabpay[$obj->rowid]["soclib"] .= ' '.$userstatic->getNomUrl(-1, 'accountancy', 0);
505 } else {
506 $tabpay[$obj->rowid]["soclib"] = $userstatic->getNomUrl(-1, 'accountancy', 0);
507 }
508 } else {
509 $tabpay[$obj->rowid]["soclib"] = '???'; // Should not happen, but happens with old data when id of user was not saved on expense report payment.
510 }
511
512 if ($compta_user) {
513 if ($is_sc) {
514 //$tabcompany[$obj->rowid][$compta_user] += $amounttouse;
515 } else {
516 if (empty($tabtp[$obj->rowid][$compta_user])) {
517 $tabtp[$obj->rowid][$compta_user] = $amounttouse;
518 } else {
519 $tabtp[$obj->rowid][$compta_user] += $amounttouse;
520 }
521 }
522 }
523 } elseif ($links[$key]['type'] == 'sc') {
524 $chargestatic->id = $links[$key]['url_id'];
525 $chargestatic->ref = (string) $links[$key]['url_id'];
526
527 $tabpay[$obj->rowid]["lib"] .= ' '.$chargestatic->getNomUrl(2);
528 $reg = array();
529 if (preg_match('/^\‍((.*)\‍)$/i', $links[$key]['label'], $reg)) {
530 if ($reg[1] == 'socialcontribution') {
531 $reg[1] = 'SocialContribution';
532 }
533 $chargestatic->label = $langs->trans($reg[1]);
534 } else {
535 $chargestatic->label = $links[$key]['label'];
536 }
537 $chargestatic->ref = $chargestatic->label;
538
539 // Retrieve the accounting code of the social contribution of the payment from link of payment.
540 // Note: We have the social contribution id, it can be faster to get accounting code from social contribution id.
541 /*
542 $sqlmid = "SELECT cchgsoc.accountancy_code";
543 $sqlmid .= " FROM ".MAIN_DB_PREFIX."c_chargesociales cchgsoc";
544 $sqlmid .= " INNER JOIN ".MAIN_DB_PREFIX."chargesociales as chgsoc ON chgsoc.fk_type = cchgsoc.id";
545 $sqlmid .= " INNER JOIN ".MAIN_DB_PREFIX."paiementcharge as paycharg ON paycharg.fk_charge = chgsoc.rowid";
546 $sqlmid .= " INNER JOIN ".MAIN_DB_PREFIX."bank_url as bkurl ON bkurl.url_id=paycharg.rowid AND bkurl.type = 'payment_sc'";
547 $sqlmid .= " WHERE bkurl.fk_bank = ".((int) $obj->rowid);
548
549 dol_syslog("accountancy/journal/bankjournal.php:: sqlmid=".$sqlmid, LOG_DEBUG);
550 $resultmid = $db->query($sqlmid);
551 if ($resultmid) {
552 $objmid = $db->fetch_object($resultmid);
553 $tabtp[$obj->rowid][$objmid->accountancy_code] = isset($tabtp[$obj->rowid][$objmid->accountancy_code]) ? $tabtp[$obj->rowid][$objmid->accountancy_code] + $amounttouse : $amounttouse;
554 }*/
555 $tmpcharge = new ChargeSociales($db);
556 $resultmid = $tmpcharge->fetch($chargestatic->id);
557 if ($resultmid) {
558 $chargestatic->type_label = $tmpcharge->type_label;
559 $chargestatic->type_code = $tmpcharge->type_code;
560 $chargestatic->type_accountancy_code = $tmpcharge->type_accountancy_code;
561
562 $tabtp[$obj->rowid][$tmpcharge->type_accountancy_code] = isset($tabtp[$obj->rowid][$tmpcharge->type_accountancy_code]) ? $tabtp[$obj->rowid][$tmpcharge->type_accountancy_code] + $amounttouse : $amounttouse;
563 }
564
565 $tabpay[$obj->rowid]["soclib"] = $chargestatic->getNomUrl(1, '30');
566 $tabpay[$obj->rowid]["paymentscid"] = $chargestatic->id;
567 } elseif ($links[$key]['type'] == 'payment_donation') {
568 $paymentdonstatic->id = $links[$key]['url_id'];
569 $paymentdonstatic->ref = (string) $links[$key]['url_id'];
570 $paymentdonstatic->fk_donation = $links[$key]['url_id'];
571 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentdonstatic->getNomUrl(2);
572 $tabpay[$obj->rowid]["paymentdonationid"] = $paymentdonstatic->id;
573 $tabtp[$obj->rowid][$account_pay_donation] = isset($tabtp[$obj->rowid][$account_pay_donation]) ? $tabtp[$obj->rowid][$account_pay_donation] + $amounttouse : $amounttouse;
574 } elseif ($links[$key]['type'] == 'member') {
575 $paymentsubscriptionstatic->id = $links[$key]['url_id'];
576 $paymentsubscriptionstatic->ref = (string) $links[$key]['url_id'];
577 $paymentsubscriptionstatic->label = $links[$key]['label'];
578 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentsubscriptionstatic->getNomUrl(2);
579 $tabpay[$obj->rowid]["paymentsubscriptionid"] = $paymentsubscriptionstatic->id;
580 $paymentsubscriptionstatic->fetch($paymentsubscriptionstatic->id);
581 $tabtp[$obj->rowid][$account_pay_subscription] = isset($tabtp[$obj->rowid][$account_pay_subscription]) ? $tabtp[$obj->rowid][$account_pay_subscription] + $amounttouse : $amounttouse;
582 } elseif ($links[$key]['type'] == 'payment_vat') { // Payment VAT
583 $paymentvatstatic->id = $links[$key]['url_id'];
584 $paymentvatstatic->ref = (string) $links[$key]['url_id'];
585 $paymentvatstatic->label = $links[$key]['label'];
586 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentvatstatic->getNomUrl(2);
587 $tabpay[$obj->rowid]["paymentvatid"] = $paymentvatstatic->id;
588 $tabtp[$obj->rowid][$account_pay_vat] = isset($tabtp[$obj->rowid][$account_pay_vat]) ? $tabtp[$obj->rowid][$account_pay_vat] + $amounttouse : $amounttouse;
589 } elseif ($links[$key]['type'] == 'payment_salary') {
590 $paymentsalstatic->id = $links[$key]['url_id'];
591 $paymentsalstatic->ref = (string) $links[$key]['url_id'];
592 $paymentsalstatic->label = $links[$key]['label'];
593 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentsalstatic->getNomUrl(2);
594 $tabpay[$obj->rowid]["paymentsalid"] = $paymentsalstatic->id;
595
596 // This part of code is no more required. it is here to solve case where a link were missing (with v14.0.0) and keep writing in accountancy complete.
597 // Note: A better way to fix this is to delete payment of salary and recreate it, or to fix the bookkeeping table manually after.
598 if (getDolGlobalString('ACCOUNTANCY_AUTOFIX_MISSING_LINK_TO_USER_ON_SALARY_BANK_PAYMENT')) {
599 $tmpsalary = new Salary($db);
600 $tmpsalary->fetch($paymentsalstatic->id);
601 $tmpsalary->fetch_user($tmpsalary->fk_user);
602
603 $userstatic->id = $tmpsalary->user->id;
604 $userstatic->name = $tmpsalary->user->name;
605 $userstatic->email = $tmpsalary->user->email;
606 $userstatic->firstname = $tmpsalary->user->firstname;
607 $userstatic->lastname = $tmpsalary->user->lastname;
608 $userstatic->status = $tmpsalary->user->status;
609 $userstatic->accountancy_code = $tmpsalary->user->accountancy_code;
610
611 if ($userstatic->id > 0) {
612 $tabpay[$obj->rowid]["soclib"] = $userstatic->getNomUrl(1, 'accountancy', 0);
613 } else {
614 $tabpay[$obj->rowid]["soclib"] = '???'; // Should not happen
615 }
616
617 if (empty($obj->typeop_user)) { // Add test to avoid adding amount twice if a link already exists also on user.
618 $accountancy_code_user_general = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
619 $compta_user = $userstatic->accountancy_code;
620 if ($compta_user) {
621 if (empty($tabtp[$obj->rowid][$compta_user])) {
622 $tabtp[$obj->rowid][$compta_user] = $amounttouse;
623 } else {
624 $tabtp[$obj->rowid][$compta_user] += $amounttouse;
625 }
626 $tabuser[$obj->rowid] = array(
627 'id' => $userstatic->id,
628 'name' => dolGetFirstLastname($userstatic->firstname, $userstatic->lastname),
629 'lastname' => $userstatic->lastname,
630 'firstname' => $userstatic->firstname,
631 'email' => $userstatic->email,
632 'accountancy_code_general' => $accountancy_code_user_general,
633 'accountancy_code' => $compta_user,
634 'status' => $userstatic->status
635 );
636 }
637 }
638 }
639 } elseif ($links[$key]['type'] == 'payment_expensereport') {
640 $paymentexpensereportstatic->id = $links[$key]['url_id'];
641 $tabpay[$obj->rowid]["lib"] .= $paymentexpensereportstatic->getNomUrl(2);
642 $tabpay[$obj->rowid]["paymentexpensereport"] = $paymentexpensereportstatic->id;
643 } elseif ($links[$key]['type'] == 'payment_various') {
644 $paymentvariousstatic->id = $links[$key]['url_id'];
645 $paymentvariousstatic->ref = (string) $links[$key]['url_id'];
646 $paymentvariousstatic->label = $links[$key]['label'];
647 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentvariousstatic->getNomUrl(2);
648 $tabpay[$obj->rowid]["paymentvariousid"] = $paymentvariousstatic->id;
649 $paymentvariousstatic->fetch($paymentvariousstatic->id);
650 $account_various = (!empty($paymentvariousstatic->accountancy_code) ? $paymentvariousstatic->accountancy_code : 'NotDefined'); // NotDefined is a reserved word
651 $account_subledger = (!empty($paymentvariousstatic->subledger_account) ? $paymentvariousstatic->subledger_account : ''); // NotDefined is a reserved word
652 $tabpay[$obj->rowid]["account_various"] = $account_various;
653 $tabtp[$obj->rowid][$account_subledger] = isset($tabtp[$obj->rowid][$account_subledger]) ? $tabtp[$obj->rowid][$account_subledger] + $amounttouse : $amounttouse;
654 } elseif ($links[$key]['type'] == 'payment_loan') {
655 $paymentloanstatic->id = $links[$key]['url_id'];
656 $paymentloanstatic->ref = (string) $links[$key]['url_id'];
657 $paymentloanstatic->fk_loan = $links[$key]['url_id'];
658 $tabpay[$obj->rowid]["lib"] .= ' '.$paymentloanstatic->getNomUrl(2);
659 $tabpay[$obj->rowid]["paymentloanid"] = $paymentloanstatic->id;
660 //$tabtp[$obj->rowid][$account_pay_loan] += $amounttouse;
661 $sqlmid = 'SELECT pl.amount_capital, pl.amount_insurance, pl.amount_interest, l.accountancy_account_capital, l.accountancy_account_insurance, l.accountancy_account_interest';
662 $sqlmid .= ' FROM '.MAIN_DB_PREFIX.'payment_loan as pl, '.MAIN_DB_PREFIX.'loan as l';
663 $sqlmid .= ' WHERE l.rowid = pl.fk_loan AND pl.fk_bank = '.((int) $obj->rowid);
664
665 dol_syslog("accountancy/journal/bankjournal.php:: sqlmid=".$sqlmid, LOG_DEBUG);
666 $resultmid = $db->query($sqlmid);
667 if ($resultmid) {
668 $objmid = $db->fetch_object($resultmid);
669 $tabtp[$obj->rowid][$objmid->accountancy_account_capital] = isset($objmid->amount_capital) ? ($tabtp[$obj->rowid][$objmid->accountancy_account_capital] ?? 0) - $objmid->amount_capital : 0;
670 $tabtp[$obj->rowid][$objmid->accountancy_account_insurance] = isset($objmid->amount_insurance) ? ($tabtp[$obj->rowid][$objmid->accountancy_account_insurance] ?? 0) - $objmid->amount_insurance : 0;
671 $tabtp[$obj->rowid][$objmid->accountancy_account_interest] = isset($objmid->amount_interest) ? ($tabtp[$obj->rowid][$objmid->accountancy_account_interest] ?? 0) - $objmid->amount_interest : 0;
672 }
673 } elseif ($links[$key]['type'] == 'banktransfert') {
674 $accountLinestatic->fetch($links[$key]['url_id']);
675 $tabpay[$obj->rowid]["lib"] .= ' '.$langs->trans("BankTransfer").' '.$accountLinestatic ->getNomUrl(1);
676 $tabtp[$obj->rowid][$account_transfer] = isset($tabtp[$obj->rowid][$account_transfer]) ? $tabtp[$obj->rowid][$account_transfer] + $amounttouse : $amounttouse;
677 $bankaccountstatic->fetch($tabpay[$obj->rowid]['fk_bank_account']);
678 $tabpay[$obj->rowid]["soclib"] = $bankaccountstatic->getNomUrl(2);
679 }
680 }
681 }
682
683 if (empty($tabbq[$obj->rowid][$compta_bank])) {
684 $tabbq[$obj->rowid][$compta_bank] = $amounttouse;
685 } else {
686 $tabbq[$obj->rowid][$compta_bank] += $amounttouse;
687 }
688
689 // If no links were found to know the amount on thirdparty, we try to guess it.
690 // This may happen on bank entries without the links lines to 'company'.
691 if (empty($tabtp[$obj->rowid]) && !empty($tabmoreinfo[$obj->rowid]['withdraw'])) { // If we don't find 'company' link because it is an old 'withdraw' record
692 foreach ($links as $key => $val) {
693 if ($links[$key]['type'] == 'payment') {
694 // Get thirdparty
695 $tmppayment->fetch($links[$key]['url_id']);
696 $arrayofamounts = $tmppayment->getAmountsArray();
697 if (is_array($arrayofamounts)) {
698 foreach ($arrayofamounts as $invoiceid => $amount) {
699 $tmpinvoice->fetch($invoiceid);
700 $tmpinvoice->fetch_thirdparty();
701 if ($tmpinvoice->thirdparty->code_compta_client) {
702 $tabtp[$obj->rowid][$tmpinvoice->thirdparty->code_compta_client] += $amount;
703 }
704 }
705 }
706 }
707 }
708 }
709
710 // If no links were found to know the amount on thirdparty/user, we init it to account 'NotDefined'.
711 if (empty($tabtp[$obj->rowid])) {
712 $tabtp[$obj->rowid]['NotDefined'] = $tabbq[$obj->rowid][$compta_bank];
713 }
714
715 // if($obj->socid)$tabtp[$obj->rowid][$compta_soc] += $amounttouse;
716
717 $i++;
718 }
719} else {
720 dol_print_error($db);
721}
722
723// Write bookkeeping
724if (!$error && $action == 'writebookkeeping' && $user->hasRight('accounting', 'bind', 'write')) {
725 $now = dol_now();
726
727 $accountingaccountcustomer = new AccountingAccount($db);
728 $accountingaccountcustomer->fetch(0, getDolGlobalString('ACCOUNTING_ACCOUNT_CUSTOMER'), true);
729
730 $accountingaccountsupplier = new AccountingAccount($db);
731 $accountingaccountsupplier->fetch(0, getDolGlobalString('ACCOUNTING_ACCOUNT_SUPPLIER'), true);
732
733 $accountingaccountpayment = new AccountingAccount($db);
734 $accountingaccountpayment->fetch(0, getDolGlobalString('SALARIES_ACCOUNTING_ACCOUNT_PAYMENT'), true);
735
736 $accountingaccountexpensereport = new AccountingAccount($db);
737 $accountingaccountexpensereport->fetch(0, getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT'), true);
738
739 $accountingaccountsuspense = new AccountingAccount($db);
740 $accountingaccountsuspense->fetch(0, getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE'), true);
741
742 $error = 0;
743 foreach ($tabpay as $key => $val) { // $key is rowid into llx_bank
744 $date = dol_print_date($val["date"], 'day');
745
746 $ref = getSourceDocRef($val, $tabtype[$key]);
747
748 $errorforline = 0;
749
750 $totalcredit = 0;
751 $totaldebit = 0;
752
753 $db->begin();
754
755 // Introduce a protection. Total of tabtp must be total of tabbq
756
757 // Bank
758 if (is_array($tabbq[$key])) {
759 // Line into bank account
760 foreach ($tabbq[$key] as $k => $mt) {
761 if ($mt) {
762 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
763 $accountingaccount = new AccountingAccount($db);
764 $accountingaccount->fetch(0, $k, true); // $k is accounting account of the bank.
765 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
766 } else {
767 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
768 }
769
770 $account_label = $accountingaccount->label;
771
772 $reflabel = '';
773 if (!empty($val['lib'])) {
774 $reflabel .= dol_string_nohtmltag($val['lib'])." / ";
775 }
776 $reflabel .= $langs->trans("Bank").' '.dol_string_nohtmltag($val['bank_account_ref']);
777 if (!empty($val['soclib'])) {
778 $reflabel .= " / ".dol_string_nohtmltag($val['soclib']);
779 }
780
781 $bookkeeping = new BookKeeping($db);
782 $bookkeeping->doc_date = $val["date"];
783 $bookkeeping->doc_ref = $ref;
784 $bookkeeping->doc_type = 'bank';
785 $bookkeeping->fk_doc = $key;
786 $bookkeeping->fk_docdet = $val["fk_bank"];
787
788 $bookkeeping->numero_compte = $k;
789 $bookkeeping->label_compte = $account_label;
790
791 $bookkeeping->label_operation = $reflabel;
792 $bookkeeping->montant = $mt;
793 $bookkeeping->sens = ($mt >= 0) ? 'D' : 'C';
794 $bookkeeping->debit = ($mt >= 0 ? $mt : 0);
795 $bookkeeping->credit = ($mt < 0 ? -$mt : 0);
796 $bookkeeping->code_journal = $journal;
797 $bookkeeping->journal_label = $langs->transnoentities($journal_label);
798 $bookkeeping->fk_user_author = $user->id;
799 $bookkeeping->date_creation = $now;
800
801 // No subledger_account value for the bank line but add a specific label_operation
802 $bookkeeping->subledger_account = '';
803 $bookkeeping->label_operation = $reflabel;
804 $bookkeeping->entity = $conf->entity;
805
806 $totaldebit += $bookkeeping->debit;
807 $totalcredit += $bookkeeping->credit;
808
809 $result = $bookkeeping->create($user);
810 if ($result < 0) {
811 if ($bookkeeping->error == 'BookkeepingRecordAlreadyExists') { // Already exists
812 $error++;
813 $errorforline++;
814 setEventMessages('Transaction for ('.$bookkeeping->doc_type.', '.$bookkeeping->fk_doc.', '.$bookkeeping->fk_docdet.') were already recorded', null, 'warnings');
815 } else {
816 $error++;
817 $errorforline++;
818 setEventMessages($bookkeeping->error, $bookkeeping->errors, 'errors');
819 }
820 }
821 }
822 }
823 }
824
825 // Third party
826 if (!$errorforline) {
827 if (is_array($tabtp[$key])) {
828 // Line into thirdparty account
829 foreach ($tabtp[$key] as $k => $mt) {
830 if ($mt) {
831 $lettering = false;
832
833 $reflabel = '';
834 if (!empty($val['lib'])) {
835 $reflabel .= dol_string_nohtmltag($val['lib']).(!empty($val['soclib']) ? " / " : "");
836 }
837 if ($tabtype[$key] == 'banktransfert') {
838 $reflabel .= dol_string_nohtmltag($langs->transnoentitiesnoconv('TransitionalAccount').' '.$account_transfer);
839 } else {
840 $reflabel .= dol_string_nohtmltag($val['soclib'] ?? '');
841 }
842
843 $bookkeeping = new BookKeeping($db);
844 $bookkeeping->doc_date = $val["date"];
845 $bookkeeping->doc_ref = $ref;
846 $bookkeeping->doc_type = 'bank';
847 $bookkeeping->fk_doc = $key;
848 $bookkeeping->fk_docdet = $val["fk_bank"];
849
850 $bookkeeping->label_operation = $reflabel;
851 $bookkeeping->montant = $mt;
852 $bookkeeping->sens = ($mt < 0) ? 'D' : 'C';
853 $bookkeeping->debit = ($mt < 0 ? -$mt : 0);
854 $bookkeeping->credit = ($mt >= 0) ? $mt : 0;
855 $bookkeeping->code_journal = $journal;
856 $bookkeeping->journal_label = $langs->transnoentities($journal_label);
857 $bookkeeping->fk_user_author = $user->id;
858 $bookkeeping->date_creation = $now;
859
860 if ($tabtype[$key] == 'payment') { // If payment is payment of customer invoice, we get ref of invoice
861 $lettering = true;
862 $bookkeeping->subledger_account = $k; // For payment, the subledger account is stored as $key of $tabtp
863 $bookkeeping->subledger_label = $tabcompany[$key]['name']; // $tabcompany is defined only if we are sure there is 1 thirdparty for the bank transaction
864 $bookkeeping->numero_compte = $tabcompany[$key]['accountancy_code_general'];
865 $bookkeeping->label_compte = $accountingaccountcustomer->label;
866 } elseif ($tabtype[$key] == 'payment_supplier') { // If payment is payment of supplier invoice, we get ref of invoice
867 $lettering = true;
868 $bookkeeping->subledger_account = $k; // For payment, the subledger account is stored as $key of $tabtp
869 $bookkeeping->subledger_label = $tabcompany[$key]['name']; // $tabcompany is defined only if we are sure there is 1 thirdparty for the bank transaction
870 $bookkeeping->numero_compte = $tabcompany[$key]['accountancy_code_general'];
871 $bookkeeping->label_compte = $accountingaccountsupplier->label;
872 } elseif ($tabtype[$key] == 'payment_expensereport') {
873 $bookkeeping->subledger_account = $tabuser[$key]['accountancy_code'];
874 $bookkeeping->subledger_label = $tabuser[$key]['name'];
875 $bookkeeping->numero_compte = getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT');
876 $bookkeeping->label_compte = $accountingaccountexpensereport->label;
877 } elseif ($tabtype[$key] == 'payment_salary') {
878 $bookkeeping->subledger_account = $tabuser[$key]['accountancy_code'];
879 $bookkeeping->subledger_label = $tabuser[$key]['name'];
880 $bookkeeping->numero_compte = $tabuser[$key]['accountancy_code_general'];
881 $bookkeeping->label_compte = $accountingaccountpayment->label;
882 } elseif (in_array($tabtype[$key], array('sc', 'payment_sc'))) { // If payment is payment of social contribution
883 $bookkeeping->subledger_account = '';
884 $bookkeeping->subledger_label = '';
885 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
886 $accountingaccount = new AccountingAccount($db);
887 $accountingaccount->fetch(0, $k, true);
888 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
889 } else {
890 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
891 }
892 $bookkeeping->numero_compte = $k;
893 $bookkeeping->label_compte = $accountingaccount->label;
894 } elseif ($tabtype[$key] == 'payment_vat') {
895 $bookkeeping->subledger_account = '';
896 $bookkeeping->subledger_label = '';
897 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
898 $accountingaccount = new AccountingAccount($db);
899 $accountingaccount->fetch(0, $k, true);
900 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
901 } else {
902 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
903 }
904 $bookkeeping->numero_compte = $k;
905 $bookkeeping->label_compte = $accountingaccount->label;
906 } elseif ($tabtype[$key] == 'payment_donation') {
907 $bookkeeping->subledger_account = '';
908 $bookkeeping->subledger_label = '';
909 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
910 $accountingaccount = new AccountingAccount($db);
911 $accountingaccount->fetch(0, $k, true);
912 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
913 } else {
914 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
915 }
916 $bookkeeping->numero_compte = $k;
917 $bookkeeping->label_compte = $accountingaccount->label;
918 } elseif ($tabtype[$key] == 'member') {
919 $bookkeeping->subledger_account = '';
920 $bookkeeping->subledger_label = '';
921 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
922 $accountingaccount = new AccountingAccount($db);
923 $accountingaccount->fetch(0, $k, true);
924 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
925 } else {
926 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
927 }
928 $bookkeeping->numero_compte = $k;
929 $bookkeeping->label_compte = $accountingaccount->label;
930 } elseif ($tabtype[$key] == 'payment_loan') {
931 $bookkeeping->subledger_account = '';
932 $bookkeeping->subledger_label = '';
933 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
934 $accountingaccount = new AccountingAccount($db);
935 $accountingaccount->fetch(0, $k, true);
936 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
937 } else {
938 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
939 }
940 $bookkeeping->numero_compte = $k;
941 $bookkeeping->label_compte = $accountingaccount->label;
942 } elseif ($tabtype[$key] == 'payment_various') {
943 $bookkeeping->subledger_account = $k;
944 $bookkeeping->subledger_label = $tabcompany[$key]['name'];
945 if (empty($conf->cache['accountingaccountincurrententity'][$tabpay[$key]["account_various"]])) {
946 $accountingaccount = new AccountingAccount($db);
947 $accountingaccount->fetch(0, $tabpay[$key]["account_various"], true);
948 $conf->cache['accountingaccountincurrententity'][$tabpay[$key]["account_various"]] = $accountingaccount;
949 } else {
950 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$tabpay[$key]["account_various"]];
951 }
952 $bookkeeping->numero_compte = $tabpay[$key]["account_various"];
953 $bookkeeping->label_compte = $accountingaccount->label;
954 } elseif ($tabtype[$key] == 'banktransfert') {
955 $bookkeeping->subledger_account = '';
956 $bookkeeping->subledger_label = '';
957 if (empty($conf->cache['accountingaccountincurrententity'][$k])) {
958 $accountingaccount = new AccountingAccount($db);
959 $accountingaccount->fetch(0, $k, true);
960 $conf->cache['accountingaccountincurrententity'][$k] = $accountingaccount;
961 } else {
962 $accountingaccount = $conf->cache['accountingaccountincurrententity'][$k];
963 }
964 $bookkeeping->numero_compte = $k;
965 $bookkeeping->label_compte = $accountingaccount->label;
966 } else {
967 if ($tabtype[$key] == 'unknown') { // Unknown transaction, we will use a waiting account for thirdparty.
968 // Temporary account
969 $bookkeeping->subledger_account = '';
970 $bookkeeping->subledger_label = '';
971 $bookkeeping->numero_compte = getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE');
972 $bookkeeping->label_compte = $accountingaccountsuspense->label;
973 }
974 }
975 $bookkeeping->label_operation = $reflabel;
976 $bookkeeping->entity = $conf->entity;
977
978 $totaldebit += $bookkeeping->debit;
979 $totalcredit += $bookkeeping->credit;
980
981 $result = $bookkeeping->create($user);
982 if ($result < 0) {
983 if ($bookkeeping->error == 'BookkeepingRecordAlreadyExists') { // Already exists
984 $error++;
985 $errorforline++;
986 setEventMessages('Transaction for ('.$bookkeeping->doc_type.', '.$bookkeeping->fk_doc.', '.$bookkeeping->fk_docdet.') were already recorded', null, 'warnings');
987 } else {
988 $error++;
989 $errorforline++;
990 setEventMessages($bookkeeping->error, $bookkeeping->errors, 'errors');
991 }
992 } else {
993 if ($lettering && getDolGlobalInt('ACCOUNTING_ENABLE_LETTERING') && getDolGlobalInt('ACCOUNTING_ENABLE_AUTOLETTERING')) {
994 require_once DOL_DOCUMENT_ROOT . '/accountancy/class/lettering.class.php';
995 $lettering_static = new Lettering($db);
996 $nb_lettering = $lettering_static->bookkeepingLetteringAll(array($bookkeeping->id));
997 }
998 }
999 }
1000 }
1001 } else { // If thirdparty unknown, output the waiting account
1002 foreach ($tabbq[$key] as $k => $mt) {
1003 if ($mt) {
1004 $reflabel = '';
1005 if (!empty($val['lib'])) {
1006 $reflabel .= dol_string_nohtmltag($val['lib'])." / ";
1007 }
1008 $reflabel .= dol_string_nohtmltag('WaitingAccount');
1009
1010 $bookkeeping = new BookKeeping($db);
1011 $bookkeeping->doc_date = $val["date"];
1012 $bookkeeping->doc_ref = $ref;
1013 $bookkeeping->doc_type = 'bank';
1014 $bookkeeping->fk_doc = $key;
1015 $bookkeeping->fk_docdet = $val["fk_bank"];
1016 $bookkeeping->montant = $mt;
1017 $bookkeeping->sens = ($mt < 0) ? 'D' : 'C';
1018 $bookkeeping->debit = ($mt < 0 ? -$mt : 0);
1019 $bookkeeping->credit = ($mt >= 0) ? $mt : 0;
1020 $bookkeeping->code_journal = $journal;
1021 $bookkeeping->journal_label = $langs->transnoentities($journal_label);
1022 $bookkeeping->fk_user_author = $user->id;
1023 $bookkeeping->date_creation = $now;
1024 $bookkeeping->label_compte = '';
1025 $bookkeeping->label_operation = $reflabel;
1026 $bookkeeping->entity = $conf->entity;
1027
1028 $totaldebit += $bookkeeping->debit;
1029 $totalcredit += $bookkeeping->credit;
1030
1031 $result = $bookkeeping->create($user);
1032
1033 if ($result < 0) {
1034 if ($bookkeeping->error == 'BookkeepingRecordAlreadyExists') { // Already exists
1035 $error++;
1036 $errorforline++;
1037 setEventMessages('Transaction for ('.$bookkeeping->doc_type.', '.$bookkeeping->fk_doc.', '.$bookkeeping->fk_docdet.') were already recorded', null, 'warnings');
1038 } else {
1039 $error++;
1040 $errorforline++;
1041 setEventMessages($bookkeeping->error, $bookkeeping->errors, 'errors');
1042 }
1043 }
1044 }
1045 }
1046 }
1047 }
1048
1049 if (price2num($totaldebit, 'MT') != price2num($totalcredit, 'MT')) {
1050 $error++;
1051 $errorforline++;
1052 setEventMessages('We tried to insert a non balanced transaction in book for '.$ref.'. Canceled. Surely a bug.', null, 'errors');
1053 }
1054
1055 if (!$errorforline) {
1056 $db->commit();
1057 } else {
1058 //print 'KO for line '.$key.' '.$error.'<br>';
1059 $db->rollback();
1060
1061 $MAXNBERRORS = 5;
1062 if ($error >= $MAXNBERRORS) {
1063 setEventMessages($langs->trans("ErrorTooManyErrorsProcessStopped").' (>'.$MAXNBERRORS.')', null, 'errors');
1064 break; // Break in the foreach
1065 }
1066 }
1067 }
1068
1069 if (empty($error) && count($tabpay) > 0) {
1070 setEventMessages($langs->trans("GeneralLedgerIsWritten"), null, 'mesgs');
1071 } elseif (count($tabpay) == $error) {
1072 setEventMessages($langs->trans("NoNewRecordSaved"), null, 'warnings');
1073 } else {
1074 setEventMessages($langs->trans("GeneralLedgerSomeRecordWasNotRecorded"), null, 'warnings');
1075 }
1076
1077 $action = '';
1078
1079 // Must reload data, so we make a redirect
1080 if (count($tabpay) != $error) {
1081 $param = 'id_journal='.$id_journal;
1082 $param .= '&date_startday='.$date_startday;
1083 $param .= '&date_startmonth='.$date_startmonth;
1084 $param .= '&date_startyear='.$date_startyear;
1085 $param .= '&date_endday='.$date_endday;
1086 $param .= '&date_endmonth='.$date_endmonth;
1087 $param .= '&date_endyear='.$date_endyear;
1088 $param .= '&in_bookkeeping='.$in_bookkeeping;
1089 header("Location: ".$_SERVER['PHP_SELF'].($param ? '?'.$param : ''));
1090 exit;
1091 }
1092}
1093
1094
1095
1096// Export
1097if ($action == 'exportcsv' && $user->hasRight('accounting', 'bind', 'write')) { // ISO and not UTF8 !
1098 $sep = getDolGlobalString('ACCOUNTING_EXPORT_SEPARATORCSV');
1099
1100 $filename = 'journal';
1101 $type_export = 'journal';
1102 include DOL_DOCUMENT_ROOT.'/accountancy/tpl/export_journal.tpl.php';
1103
1104 // CSV header line
1105 print '"'.$langs->transnoentitiesnoconv("BankId").'"'.$sep;
1106 print '"'.$langs->transnoentitiesnoconv("Date").'"'.$sep;
1107 print '"'.$langs->transnoentitiesnoconv("PaymentMode").'"'.$sep;
1108 print '"'.$langs->transnoentitiesnoconv("AccountAccounting").'"'.$sep;
1109 print '"'.$langs->transnoentitiesnoconv("SubledgerAccount").'"'.$sep;
1110 print '"'.$langs->transnoentitiesnoconv("Label").'"'.$sep;
1111 print '"'.$langs->transnoentitiesnoconv("AccountingDebit").'"'.$sep;
1112 print '"'.$langs->transnoentitiesnoconv("AccountingCredit").'"'.$sep;
1113 print '"'.$langs->transnoentitiesnoconv("Journal").'"'.$sep;
1114 print '"'.$langs->transnoentitiesnoconv("Note").'"'.$sep;
1115 print "\n";
1116
1117 foreach ($tabpay as $key => $val) {
1118 $date = dol_print_date($val["date"], 'day');
1119
1120 $ref = getSourceDocRef($val, $tabtype[$key]);
1121
1122 // Bank
1123 foreach ($tabbq[$key] as $k => $mt) {
1124 if ($mt) {
1125 $reflabel = '';
1126 if (!empty($val['lib'])) {
1127 $reflabel .= dol_string_nohtmltag($val['lib'])." / ";
1128 }
1129 $reflabel .= $langs->trans("Bank").' '.dol_string_nohtmltag($val['bank_account_ref']);
1130 if (!empty($val['soclib'])) {
1131 $reflabel .= " / ".dol_string_nohtmltag($val['soclib']);
1132 }
1133
1134 print '"'.$key.'"'.$sep;
1135 print '"'.$date.'"'.$sep;
1136 print '"'.$val["type_payment"].'"'.$sep;
1137 print '"'.length_accountg(html_entity_decode($k)).'"'.$sep;
1138 print " ".$sep;
1139 print '"'.$reflabel.'"'.$sep;
1140 print '"'.($mt >= 0 ? price($mt) : '').'"'.$sep;
1141 print '"'.($mt < 0 ? price(-$mt) : '').'"'.$sep;
1142 print '"'.$journal.'"'.$sep;
1143 print '"'.dol_string_nohtmltag($ref).'"'.$sep;
1144 print "\n";
1145 }
1146 }
1147
1148 // Third party
1149 if (is_array($tabtp[$key])) {
1150 foreach ($tabtp[$key] as $k => $mt) {
1151 if ($mt) {
1152 $reflabel = '';
1153 if (!empty($val['lib'])) {
1154 $reflabel .= dol_string_nohtmltag($val['lib']).(!empty($val['soclib']) ? " / " : "");
1155 }
1156 if ($tabtype[$key] == 'banktransfert') {
1157 $reflabel .= dol_string_nohtmltag($langs->transnoentitiesnoconv('TransitionalAccount').' '.$account_transfer);
1158 } else {
1159 $reflabel .= dol_string_nohtmltag($val['soclib'] ?? '');
1160 }
1161
1162 print '"'.$key.'"'.$sep;
1163 print '"'.$date.'"'.$sep;
1164 print '"'.$val["type_payment"].'"'.$sep;
1165 if ($tabtype[$key] == 'payment_supplier') {
1166 $account_ledger = (!empty($obj->accountancy_code_supplier_general)) ? $obj->accountancy_code_supplier_general : $account_supplier;
1167 print '"'.length_accountg($account_ledger).'"'.$sep;
1168 } elseif ($tabtype[$key] == 'payment') {
1169 $account_ledger = (!empty($obj->accountancy_code_customer_general)) ? $obj->accountancy_code_customer_general : $account_customer;
1170 print '"'.length_accountg($account_ledger).'"'.$sep;
1171 } elseif ($tabtype[$key] == 'payment_expensereport') {
1172 print '"'.length_accountg(getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT')).'"'.$sep;
1173 } elseif ($tabtype[$key] == 'payment_salary') {
1174 $account_ledger = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
1175 print '"'.length_accountg($account_ledger).'"'.$sep;
1176 } else {
1177 print '"'.length_accountg(html_entity_decode($k)).'"'.$sep;
1178 }
1179 print '"'.length_accounta(html_entity_decode($k)).'"'.$sep;
1180 print '"'.$reflabel.'"'.$sep;
1181 print '"'.($mt < 0 ? price(-$mt) : '').'"'.$sep;
1182 print '"'.($mt >= 0 ? price($mt) : '').'"'.$sep;
1183 print '"'.$journal.'"'.$sep;
1184 print '"'.dol_string_nohtmltag($ref).'"'.$sep;
1185 print "\n";
1186 }
1187 }
1188 } else { // If thirdparty unknown, output the waiting account
1189 foreach ($tabbq[$key] as $k => $mt) {
1190 if ($mt) {
1191 $reflabel = '';
1192 if (!empty($val['lib'])) {
1193 $reflabel .= dol_string_nohtmltag($val['lib'])." / ";
1194 }
1195 $reflabel .= dol_string_nohtmltag('WaitingAccount');
1196
1197 print '"'.$key.'"'.$sep;
1198 print '"'.$date.'"'.$sep;
1199 print '"'.$val["type_payment"].'"'.$sep;
1200 print '"'.length_accountg(getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE')).'"'.$sep;
1201 print $sep;
1202 print '"'.$reflabel.'"'.$sep;
1203 print '"'.($mt < 0 ? price(-$mt) : '').'"'.$sep;
1204 print '"'.($mt >= 0 ? price($mt) : '').'"'.$sep;
1205 print '"'.$journal.'"'.$sep;
1206 print '"'.dol_string_nohtmltag($ref).'"'.$sep;
1207 print "\n";
1208 }
1209 }
1210 }
1211 }
1212}
1213
1214
1215/*
1216 * View
1217 */
1218
1219$form = new Form($db);
1220
1221if (empty($action) || $action == 'view') {
1222 $invoicestatic = new Facture($db);
1223 $invoicesupplierstatic = new FactureFournisseur($db);
1224 $expensereportstatic = new ExpenseReport($db);
1225 $vatstatic = new Tva($db);
1226 $donationstatic = new Don($db);
1227 $loanstatic = new Loan($db);
1228 $salarystatic = new Salary($db);
1229 $variousstatic = new PaymentVarious($db);
1230
1231 $title = $langs->trans("GenerationOfAccountingEntries").' - '.$accountingjournalstatic->getNomUrl(0, 2, 1, '', 1);
1232 $help_url = 'EN:Module_Double_Entry_Accounting|FR:Module_Comptabilit&eacute;_en_Partie_Double#G&eacute;n&eacute;ration_des_&eacute;critures_en_comptabilit&eacute;';
1233 llxHeader('', dol_string_nohtmltag($title), $help_url, '', 0, 0, '', '', '', 'mod-accountancy accountancy-generation page-bankjournal');
1234
1235 $nom = $title;
1236 $builddate = dol_now();
1237 //$description = $langs->trans("DescFinanceJournal") . '<br>';
1238 $description = $langs->trans("DescJournalOnlyBindedVisible").'<br>';
1239
1240 $listofchoices = array(
1241 'notyet' => $langs->trans("NotYetInGeneralLedger"),
1242 'already' => $langs->trans("AlreadyInGeneralLedger")
1243 );
1244 $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);
1245 $period .= '<span class="valignmiddle"> - '.$langs->trans("JournalizationInLedgerStatus").' </span>'.$form->selectarray('in_bookkeeping', $listofchoices, $in_bookkeeping, 1, 0, 0, '', 0, 0, 0, '', 'minwidth75 valignmiddle');
1246
1247 $varlink = 'id_journal='.$id_journal;
1248 $periodlink = '';
1249 $exportlink = '';
1250
1251 $listofchoices = array(
1252 1 => $langs->trans("TransfertAllBankLines"),
1253 2 => $langs->trans("TransfertOnlyConciliatedBankLine")
1254 );
1255 $moreoptions = [ "BankLineConciliated" => $form->selectarray('only_rappro', $listofchoices, $only_rappro, 0, 0, 0, '', 0, 0, 0, '', 'minwidth75 valignmiddle')];
1256
1257 journalHead($nom, '', $period, $periodlink, $description, $builddate, $exportlink, array('action' => ''), '', $varlink, $moreoptions);
1258
1259 $desc = '';
1260
1261 if (getDolGlobalString('ACCOUNTANCY_FISCAL_PERIOD_MODE') != 'blockedonclosed') {
1262 // Test that setup is complete (we are in accounting, so test on entity is always on $conf->entity only, no sharing allowed)
1263 // Fiscal period test
1264 $sql = "SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX."accounting_fiscalyear WHERE entity = ".((int) $conf->entity);
1265 $resql = $db->query($sql);
1266 if ($resql) {
1267 $obj = $db->fetch_object($resql);
1268 if ($obj->nb == 0) {
1269 print '<br><div class="warning">'.img_warning().' '.$langs->trans("TheFiscalPeriodIsNotDefined");
1270 $desc = ' : '.$langs->trans("AccountancyAreaDescFiscalPeriod", 4, '{link}');
1271 $desc = str_replace('{link}', '<strong>'.$langs->transnoentitiesnoconv("MenuAccountancy").'-'.$langs->transnoentitiesnoconv("Setup")."-".$langs->transnoentitiesnoconv("FiscalPeriod").'</strong>', $desc);
1272 print $desc;
1273 print '</div>';
1274 }
1275 } else {
1276 dol_print_error($db);
1277 }
1278 }
1279
1280 // Bank test
1281 $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";
1282 $resql = $db->query($sql);
1283 if ($resql) {
1284 $obj = $db->fetch_object($resql);
1285 if ($obj->nb > 0) {
1286 print '<br><div class="warning">'.img_warning().' '.$langs->trans("TheJournalCodeIsNotDefinedOnSomeBankAccount");
1287 $desc = ' : '.$langs->trans("AccountancyAreaDescBank", 6, '{link}');
1288 $desc = str_replace('{link}', '<strong>'.$langs->transnoentitiesnoconv("MenuAccountancy").'-'.$langs->transnoentitiesnoconv("Setup")."-".$langs->transnoentitiesnoconv("BankAccounts").'</strong>', $desc);
1289 print $desc;
1290 print '</div>';
1291 }
1292 } else {
1293 dol_print_error($db);
1294 }
1295
1296
1297 // Button to write into Ledger
1298 if (getDolGlobalString('ACCOUNTING_ACCOUNT_CUSTOMER') == "" || getDolGlobalString('ACCOUNTING_ACCOUNT_CUSTOMER') == '-1'
1299 || getDolGlobalString('ACCOUNTING_ACCOUNT_SUPPLIER') == "" || getDolGlobalString('ACCOUNTING_ACCOUNT_SUPPLIER') == '-1'
1300 || (isModEnabled("salaries") && (getDolGlobalString('SALARIES_ACCOUNTING_ACCOUNT_PAYMENT') == "" || getDolGlobalString('SALARIES_ACCOUNTING_ACCOUNT_PAYMENT') == '-1'))
1301 || (isModEnabled("expensereport") && (getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT') == "" || getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT') == '-1'))) {
1302
1303
1304 print($desc ? '' : '<br>').'<div class="warning">'.img_warning().' '.$langs->trans("SomeMandatoryStepsOfSetupWereNotDone");
1305 $desc = ' : '.$langs->trans("AccountancyAreaDescMisc", 4, '{link}');
1306 $desc = str_replace('{link}', '<strong>'.$langs->transnoentitiesnoconv("MenuAccountancy").'-'.$langs->transnoentitiesnoconv("Setup")."-".$langs->transnoentitiesnoconv("MenuDefaultAccounts").'</strong>', $desc);
1307 print $desc;
1308 print '</div>';
1309 }
1310
1311
1312 print '<br><div class="tabsAction tabsActionNoBottom centerimp">';
1313
1314 if (getDolGlobalString('ACCOUNTING_ENABLE_EXPORT_DRAFT_JOURNAL') && $in_bookkeeping == 'notyet') {
1315 print '<input type="button" class="butAction" name="exportcsv" value="'.$langs->trans("ExportDraftJournal").'" onclick="launch_export();" />';
1316 }
1317
1318 if (getDolGlobalString('ACCOUNTING_ACCOUNT_CUSTOMER') == "" || getDolGlobalString('ACCOUNTING_ACCOUNT_CUSTOMER') == '-1'
1319 || getDolGlobalString('ACCOUNTING_ACCOUNT_SUPPLIER') == "" || getDolGlobalString('ACCOUNTING_ACCOUNT_SUPPLIER') == '-1') {
1320 print '<input type="button" class="butActionRefused classfortooltip" title="'.dol_escape_htmltag($langs->trans("SomeMandatoryStepsOfSetupWereNotDone")).'" value="'.$langs->trans("WriteBookKeeping").'" />';
1321 } else {
1322 if ($in_bookkeeping == 'notyet') {
1323 print '<input type="button" class="butAction" name="writebookkeeping" value="'.$langs->trans("WriteBookKeeping").'" onclick="writebookkeeping();" />';
1324 } else {
1325 print '<a class="butActionRefused classfortooltip" name="writebookkeeping">'.$langs->trans("WriteBookKeeping").'</a>';
1326 }
1327 }
1328
1329 print '</div>';
1330
1331 // TODO Avoid using js. We can use a direct link with $param
1332 print '
1333 <script type="text/javascript">
1334 function launch_export() {
1335 console.log("Set value into form and submit");
1336 $("div.fiche form input[name=\"action\"]").val("exportcsv");
1337 $("div.fiche form input[type=\"submit\"]").click();
1338 $("div.fiche form input[name=\"action\"]").val("");
1339 }
1340 function writebookkeeping() {
1341 console.log("Set value into form and submit");
1342 $("div.fiche form input[name=\"action\"]").val("writebookkeeping");
1343 $("div.fiche form input[type=\"submit\"]").click();
1344 $("div.fiche form input[name=\"action\"]").val("");
1345 }
1346 </script>';
1347
1348 /*
1349 * Show result array
1350 */
1351 print '<br>';
1352
1353 $i = 0;
1354 print '<div class="div-table-responsive">';
1355 print '<table class="noborder centpercent">';
1356 print '<tr class="liste_titre">';
1357 print "<td>".$langs->trans("Date")."</td>";
1358 print "<td>".$langs->trans("Piece").' ('.$langs->trans("ObjectsRef").")</td>";
1359 print "<td>".$langs->trans("AccountAccounting")."</td>";
1360 print "<td>".$langs->trans("SubledgerAccount")."</td>";
1361 print "<td>".$langs->trans("LabelOperation")."</td>";
1362 print '<td class="center">'.$langs->trans("PaymentMode")."</td>";
1363 print '<td class="right">'.$langs->trans("AccountingDebit")."</td>";
1364 print '<td class="right">'.$langs->trans("AccountingCredit")."</td>";
1365 print "</tr>\n";
1366
1367 foreach ($tabpay as $key => $val) { // $key is rowid in llx_bank
1368 $date = dol_print_date($val["date"], 'day');
1369
1370 $ref = getSourceDocRef($val, $tabtype[$key]);
1371
1372 // Bank
1373 foreach ($tabbq[$key] as $k => $mt) {
1374 if ($mt) {
1375 $reflabel = '';
1376 if (!empty($val['lib'])) {
1377 $reflabel .= $val['lib']." / ";
1378 }
1379 $reflabel .= $langs->trans("Bank").' '.$val['bank_account_ref'];
1380 if (!empty($val['soclib'])) {
1381 $reflabel .= " / ".$val['soclib'];
1382 }
1383
1384 //var_dump($tabpay[$key]);
1385 print '<!-- Bank bank.rowid='.$key.'=accounting_bookkeeping.fk_doc (accounting_bookkeeping.doc_type=\'bank\') type='.$tabpay[$key]['type'].' ref='.$tabpay[$key]['ref'].' -->';
1386 print '<tr class="oddeven">';
1387
1388 // Date
1389 print "<td>".$date."</td>";
1390
1391 // Ref
1392 print '<td class="maxwidth300 nopaddingtopimp nopaddingbottomimp">'.dol_escape_htmltag($ref)."</td>";
1393
1394 // Ledger account
1395 $accounttoshow = length_accountg($k);
1396 if (empty($accounttoshow) || $accounttoshow == 'NotDefined') {
1397 $accounttoshow = '<span class="error">'.$langs->trans("BankAccountNotDefined").'</span>';
1398 }
1399 print '<td class="maxwidth300" title="'.dol_escape_htmltag(dol_string_nohtmltag($accounttoshow)).'">';
1400 print $accounttoshow;
1401 print "</td>";
1402
1403 // Subledger account
1404 print '<td class="maxwidth300">';
1405 /*$accounttoshow = length_accountg($k);
1406 if (empty($accounttoshow) || $accounttoshow == 'NotDefined')
1407 {
1408 print '<span class="error">'.$langs->trans("BankAccountNotDefined").'</span>';
1409 }
1410 else print $accounttoshow;*/
1411 print "</td>";
1412
1413 // Label operation
1414 print '<td class="maxwidth300 nopaddingtopimp nopaddingbottomimp">';
1415 print $reflabel; // This is already html escaped content
1416 print "</td>";
1417
1418 print '<td class="center">'.$val["type_payment"]."</td>";
1419 print '<td class="right nowraponall amount">'.($mt >= 0 ? price($mt) : '')."</td>";
1420 print '<td class="right nowraponall amount">'.($mt < 0 ? price(-$mt) : '')."</td>";
1421 print "</tr>";
1422
1423 $i++;
1424 }
1425 }
1426
1427 // Third party
1428 if (is_array($tabtp[$key])) {
1429 foreach ($tabtp[$key] as $k => $mt) {
1430 if ($mt) {
1431 $reflabel = '';
1432 if (!empty($val['lib'])) {
1433 $reflabel .= $val['lib'].(!empty($val['soclib']) ? " / " : "");
1434 }
1435 if ($tabtype[$key] == 'banktransfert') {
1436 $reflabel .= $langs->trans('TransitionalAccount').' '.$account_transfer;
1437 } else {
1438 $reflabel .= isset($val['soclib']) ? $val['soclib'] : "";
1439 }
1440
1441 print '<!-- Thirdparty bank.rowid='.$key.'=accounting_bookkeeping.fk_doc (accounting_bookkeeping.doc_type=\'bank\') type='.$tabpay[$key]['type'].' ref='.$tabpay[$key]['ref'].' -->';
1442 print '<tr class="oddeven">';
1443
1444 // Date
1445 print "<td>".$date."</td>";
1446
1447 // Ref / Piece
1448 print '<td class="nopaddingtopimp nopaddingbottomimp">'.dol_escape_htmltag($ref)."</td>";
1449
1450
1451 // Ledger account
1452 $account_ledger = $k;
1453 // Try to force general ledger account depending on type
1454 if ($tabtype[$key] == 'payment') {
1455 $account_ledger = (!empty($obj->accountancy_code_customer_general)) ? $obj->accountancy_code_customer_general : $account_customer;
1456 }
1457 if ($tabtype[$key] == 'payment_supplier') {
1458 $account_ledger = (!empty($obj->accountancy_code_supplier_general)) ? $obj->accountancy_code_supplier_general : $account_supplier;
1459 }
1460 if ($tabtype[$key] == 'payment_expensereport') {
1461 $account_ledger = getDolGlobalString('ACCOUNTING_ACCOUNT_EXPENSEREPORT');
1462 }
1463 if ($tabtype[$key] == 'payment_salary') {
1464 $account_ledger = (!empty($obj->accountancy_code_user_general)) ? $obj->accountancy_code_user_general : $account_employee;
1465 }
1466 if ($tabtype[$key] == 'payment_vat') {
1467 $account_ledger = getDolGlobalString('ACCOUNTING_VAT_PAY_ACCOUNT');
1468 }
1469 if ($tabtype[$key] == 'member') {
1470 $account_ledger = getDolGlobalString('ADHERENT_SUBSCRIPTION_ACCOUNTINGACCOUNT');
1471 }
1472 if ($tabtype[$key] == 'payment_various') {
1473 $account_ledger = $tabpay[$key]["account_various"];
1474 }
1475 $accounttoshow = length_accountg($account_ledger);
1476 if (empty($accounttoshow) || $accounttoshow == 'NotDefined') {
1477 if ($tabtype[$key] == 'unknown') {
1478 // We will accept writing, but into a waiting account
1479 if (!getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE') || getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE') == '-1') {
1480 $accounttoshow = '<span class="error small">'.$langs->trans('UnknownAccountForThirdpartyAndWaitingAccountNotDefinedBlocking').'</span>';
1481 } else {
1482 $accounttoshow = '<span class="warning small">'.$langs->trans('UnknownAccountForThirdparty', length_accountg(getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE'))).'</span>'; // We will use a waiting account
1483 }
1484 } else {
1485 // We will refuse writing
1486 $errorstring = 'UnknownAccountForThirdpartyBlocking';
1487 if ($tabtype[$key] == 'payment') {
1488 $errorstring = 'MainAccountForCustomersNotDefined';
1489 }
1490 if ($tabtype[$key] == 'payment_supplier') {
1491 $errorstring = 'MainAccountForSuppliersNotDefined';
1492 }
1493 if ($tabtype[$key] == 'payment_expensereport') {
1494 $errorstring = 'MainAccountForUsersNotDefined';
1495 }
1496 if ($tabtype[$key] == 'payment_salary') {
1497 $errorstring = 'MainAccountForUsersNotDefined';
1498 }
1499 if ($tabtype[$key] == 'payment_vat') {
1500 $errorstring = 'MainAccountForVatPaymentNotDefined';
1501 }
1502 if ($tabtype[$key] == 'member') {
1503 $errorstring = 'MainAccountForSubscriptionPaymentNotDefined';
1504 }
1505 $accounttoshow = '<span class="error small">'.$langs->trans($errorstring).'</span>';
1506 }
1507 }
1508 print '<td class="maxwidth300" title="'.dol_escape_htmltag(dol_string_nohtmltag($accounttoshow)).'">';
1509 print $accounttoshow; // This is a HTML string
1510 print "</td>";
1511
1512 // Subledger account
1513 $accounttoshowsubledger = '';
1514 if (in_array($tabtype[$key], array('payment', 'payment_supplier', 'payment_expensereport', 'payment_salary', 'payment_various'))) { // Type of payments that uses a subledger
1515 $accounttoshowsubledger = length_accounta($k);
1516 if ($accounttoshow != $accounttoshowsubledger) {
1517 if (empty($accounttoshowsubledger) || $accounttoshowsubledger == 'NotDefined') {
1518 //print '<span class="error">'.$langs->trans("ThirdpartyAccountNotDefined").'</span>';
1519 if (!empty($tabcompany[$key]['code_compta'])) {
1520 if (in_array($tabtype[$key], array('payment_various'))) {
1521 // For such case, if subledger is not defined, we won't use subledger accounts.
1522 $accounttoshowsubledger = '<span class="warning small twolinesmax">'.$langs->trans("ThirdpartyAccountNotDefinedOrThirdPartyUnknownSubledgerIgnored").'</span>';
1523 } elseif (in_array($tabtype[$key], array('payment_salary'))) {
1524 $accounttoshowsubledger = '<span class="warning small twolinesmax">'.$langs->trans("ThirdpartyAccountNotDefinedOrThirdPartyUnknownSubledgerIgnored2").'</span>';
1525 } else {
1526 $accounttoshowsubledger = '<span class="warning small twolinesmax">'.$langs->trans("ThirdpartyAccountNotDefinedOrThirdPartyUnknown", $tabcompany[$key]['code_compta']).'</span>';
1527 }
1528 } else {
1529 $accounttoshowsubledger = '<span class="error small twolinesmax">'.$langs->trans("ThirdpartyAccountNotDefinedOrThirdPartyUnknownBlocking").'</span>';
1530 }
1531 }
1532 } else {
1533 $accounttoshowsubledger = '';
1534 }
1535 }
1536 print '<td class="maxwidth300 nopaddingtopimp nopaddingbottomimp" title="'.dolPrintHTMLForAttribute(dol_string_nohtmltag($accounttoshowsubledger)).'">';
1537 print $accounttoshowsubledger; // This is a html string
1538 print "</td>";
1539
1540 // Label operation
1541 print '<td class="nopaddingtopimpo paddingbottomimp">';
1542 print $reflabel; // This is a html string
1543 print "</td>";
1544
1545 print '<td class="center">'.$val["type_payment"]."</td>";
1546
1547 print '<td class="right nowraponall amount">'.($mt < 0 ? price(-$mt) : '')."</td>";
1548
1549 print '<td class="right nowraponall amount">'.($mt >= 0 ? price($mt) : '')."</td>";
1550
1551 print "</tr>";
1552
1553 $i++;
1554 }
1555 }
1556 } else { // Waiting account
1557 foreach ($tabbq[$key] as $k => $mt) {
1558 if ($mt) {
1559 $reflabel = '';
1560 if (!empty($val['lib'])) {
1561 $reflabel .= $val['lib']." / ";
1562 }
1563 $reflabel .= 'WaitingAccount';
1564
1565 print '<!-- Wait bank.rowid='.$key.' -->';
1566 print '<tr class="oddeven">';
1567 print "<td>".$date."</td>";
1568 print "<td>".$ref."</td>";
1569 // Ledger account
1570 print "<td>";
1571 /*if (empty($accounttoshow) || $accounttoshow == 'NotDefined')
1572 {
1573 print '<span class="error">'.$langs->trans("WaitAccountNotDefined").'</span>';
1574 }
1575 else */
1576 print length_accountg(getDolGlobalString('ACCOUNTING_ACCOUNT_SUSPENSE'));
1577 print "</td>";
1578 // Subledger account
1579 print "<td>";
1580 print "</td>";
1581 print "<td>".dol_escape_htmltag($reflabel)."</td>";
1582 print '<td class="center">'.$val["type_payment"]."</td>";
1583 print '<td class="right nowraponall amount">'.($mt < 0 ? price(-$mt) : '')."</td>";
1584 print '<td class="right nowraponall amount">'.($mt >= 0 ? price($mt) : '')."</td>";
1585 print "</tr>";
1586
1587 $i++;
1588 }
1589 }
1590 }
1591 }
1592
1593 if (!$i) {
1594 $colspan = 8;
1595 print '<tr class="oddeven"><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
1596 }
1597
1598 print "</table>";
1599 print '</div>';
1600
1601 llxFooter();
1602}
1603
1604$db->close();
1605
1606
1607
1615function getSourceDocRef($val, $typerecord)
1616{
1617 global $db, $langs;
1618
1619 // Defined the docref into $ref (We start with $val['ref'] by default and we complete according to other data)
1620 // WE MUST HAVE SAME REF FOR ALL LINES WE WILL RECORD INTO THE BOOKKEEPING
1621 $ref = $val['ref'];
1622 if ($ref == '(SupplierInvoicePayment)' || $ref == '(SupplierInvoicePaymentBack)') {
1623 $ref = $langs->transnoentitiesnoconv('Supplier');
1624 }
1625 if ($ref == '(CustomerInvoicePayment)' || $ref == '(CustomerInvoicePaymentBack)') {
1626 $ref = $langs->transnoentitiesnoconv('Customer');
1627 }
1628 if ($ref == '(SocialContributionPayment)') {
1629 $ref = $langs->transnoentitiesnoconv('SocialContribution');
1630 }
1631 if ($ref == '(DonationPayment)') {
1632 $ref = $langs->transnoentitiesnoconv('Donation');
1633 }
1634 if ($ref == '(SubscriptionPayment)') {
1635 $ref = $langs->transnoentitiesnoconv('Subscription');
1636 }
1637 if ($ref == '(ExpenseReportPayment)') {
1638 $ref = $langs->transnoentitiesnoconv('Employee');
1639 }
1640 if ($ref == '(LoanPayment)') {
1641 $ref = $langs->transnoentitiesnoconv('Loan');
1642 }
1643 if ($ref == '(payment_salary)') {
1644 $ref = $langs->transnoentitiesnoconv('Employee');
1645 }
1646
1647 $sqlmid = '';
1648 if ($typerecord == 'payment') {
1649 if (getDolGlobalInt('FACTURE_DEPOSITS_ARE_JUST_PAYMENTS')) {
1650 $sqlmid = "SELECT payfac.fk_facture as id, ".$db->ifsql('f1.rowid IS NULL', 'f.ref', 'f1.ref')." as ref";
1651 $sqlmid .= " FROM ".$db->prefix()."paiement_facture as payfac";
1652 $sqlmid .= " LEFT JOIN ".$db->prefix()."facture as f ON f.rowid = payfac.fk_facture";
1653 $sqlmid .= " LEFT JOIN ".$db->prefix()."societe_remise_except as sre ON sre.fk_facture_source = payfac.fk_facture";
1654 $sqlmid .= " LEFT JOIN ".$db->prefix()."facture as f1 ON f1.rowid = sre.fk_facture";
1655 $sqlmid .= " WHERE payfac.fk_paiement=".((int) $val['paymentid']);
1656 } else {
1657 $sqlmid = "SELECT payfac.fk_facture as id, f.ref as ref";
1658 $sqlmid .= " FROM ".$db->prefix()."paiement_facture as payfac";
1659 $sqlmid .= " INNER JOIN ".$db->prefix()."facture as f ON f.rowid = payfac.fk_facture";
1660 $sqlmid .= " WHERE payfac.fk_paiement=".((int) $val['paymentid']);
1661 }
1662 $ref = $langs->transnoentitiesnoconv("Invoice");
1663 } elseif ($typerecord == 'payment_supplier') {
1664 $sqlmid = 'SELECT payfac.fk_facturefourn as id, f.ref';
1665 $sqlmid .= " FROM ".MAIN_DB_PREFIX."paiementfourn_facturefourn as payfac, ".MAIN_DB_PREFIX."facture_fourn as f";
1666 $sqlmid .= " WHERE payfac.fk_facturefourn = f.rowid AND payfac.fk_paiementfourn=".((int) $val["paymentsupplierid"]);
1667 $ref = $langs->transnoentitiesnoconv("SupplierInvoice");
1668 } elseif ($typerecord == 'payment_expensereport') {
1669 $sqlmid = 'SELECT e.rowid as id, e.ref';
1670 $sqlmid .= " FROM ".MAIN_DB_PREFIX."payment_expensereport as pe, ".MAIN_DB_PREFIX."expensereport as e";
1671 $sqlmid .= " WHERE pe.rowid=".((int) $val["paymentexpensereport"])." AND pe.fk_expensereport = e.rowid";
1672 $ref = $langs->transnoentitiesnoconv("ExpenseReport");
1673 } elseif ($typerecord == 'payment_salary') {
1674 $sqlmid = 'SELECT s.rowid as ref';
1675 $sqlmid .= " FROM ".MAIN_DB_PREFIX."payment_salary as s";
1676 $sqlmid .= " WHERE s.rowid=".((int) $val["paymentsalid"]);
1677 $ref = $langs->transnoentitiesnoconv("SalaryPayment");
1678 } elseif ($typerecord == 'sc') {
1679 $sqlmid = 'SELECT sc.rowid as ref';
1680 $sqlmid .= " FROM ".MAIN_DB_PREFIX."paiementcharge as sc";
1681 $sqlmid .= " WHERE sc.rowid=".((int) $val["paymentscid"]);
1682 $ref = $langs->transnoentitiesnoconv("SocialContribution");
1683 } elseif ($typerecord == 'payment_vat') {
1684 $sqlmid = 'SELECT pv.fk_tva as ref'; // paymentvatid is the id of the payment, the ref is the id of the VAT declaration it pays
1685 $sqlmid .= " FROM ".MAIN_DB_PREFIX."payment_vat as pv";
1686 $sqlmid .= " WHERE pv.rowid=".((int) $val["paymentvatid"]);
1687 $ref = $langs->transnoentitiesnoconv("PaymentVat");
1688 } elseif ($typerecord == 'payment_donation') {
1689 $sqlmid = 'SELECT payd.fk_donation as ref';
1690 $sqlmid .= " FROM ".MAIN_DB_PREFIX."payment_donation as payd";
1691 $sqlmid .= " WHERE payd.fk_donation=".((int) $val["paymentdonationid"]);
1692 $ref = $langs->transnoentitiesnoconv("Donation");
1693 } elseif ($typerecord == 'payment_loan') {
1694 $sqlmid = 'SELECT l.rowid as ref';
1695 $sqlmid .= " FROM ".MAIN_DB_PREFIX."payment_loan as l";
1696 $sqlmid .= " WHERE l.rowid=".((int) $val["paymentloanid"]);
1697 $ref = $langs->transnoentitiesnoconv("LoanPayment");
1698 } elseif ($typerecord == 'payment_various') {
1699 $sqlmid = 'SELECT v.rowid as ref';
1700 $sqlmid .= " FROM ".MAIN_DB_PREFIX."payment_various as v";
1701 $sqlmid .= " WHERE v.rowid=".((int) $val["paymentvariousid"]);
1702 $ref = $langs->transnoentitiesnoconv("VariousPayment");
1703 }
1704 // Add warning
1705 if (empty($sqlmid)) {
1706 dol_syslog("Found a typerecord=".$typerecord." not supported", LOG_WARNING);
1707 }
1708
1709 if ($sqlmid) {
1710 dol_syslog("accountancy/journal/bankjournal.php::sqlmid=".$sqlmid, LOG_DEBUG);
1711 $resultmid = $db->query($sqlmid);
1712 if ($resultmid) {
1713 while ($objmid = $db->fetch_object($resultmid)) {
1714 $ref .= ' '.$objmid->ref;
1715 }
1716 } else {
1717 dol_print_error($db);
1718 }
1719 }
1720
1721 $ref = dol_trunc($langs->transnoentitiesnoconv("BankId").' '.$val['fk_bank'].' - '.$ref, 295); // 295 + 3 dots (...) is < than max size of 300
1722 return $ref;
1723}
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
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.
Definition wrapper.php:91
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.
Definition wrapper.php:73
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.
Definition don.class.php:41
Class to manage Trips and Expenses.
Class to manage suppliers invoices.
Class to manage invoices.
Class to manage generation of HTML components Only common components must be here.
Class Lettering.
Loan.
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)
Definition tva.class.php:39
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.
Definition date.lib.php:618
dol_get_last_day($year, $month=12, $gm=false)
Return GMT time for last day of a month or year.
Definition date.lib.php:637
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
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.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
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_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_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.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.