34require
'../../main.inc.php';
35require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
36require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
37require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
38require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
39require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/bookkeeping.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/bookkeeping.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formaccounting.class.php';
53$langs->loadLangs(array(
"companies",
"other",
"compta",
"banks",
"bills",
"donations",
"loan",
"accountancy",
"trips",
"salaries",
"hrm",
"members"));
58$date_startmonth =
GETPOSTINT(
'date_startmonth');
64$in_bookkeeping =
GETPOST(
'in_bookkeeping',
'aZ09');
67if ($only_rappro == 0) {
74$action =
GETPOST(
'action',
'aZ09');
76if ($in_bookkeeping ==
'') {
77 $in_bookkeeping =
'notyet';
84if ($user->socid > 0) {
87if (!$user->hasRight(
'accounting',
'bind',
'write')) {
98$date_start =
dol_mktime(0, 0, 0, $date_startmonth, $date_startday, $date_startyear);
99$date_end =
dol_mktime(23, 59, 59, $date_endmonth, $date_endday, $date_endyear);
102$pastmonthyear =
null;
104if (empty($date_startmonth)) {
107 $date_start = $dates[
'date_start'];
108 $pastmonthyear = $dates[
'pastmonthyear'];
109 $pastmonth = $dates[
'pastmonth'];
111if (empty($date_endmonth)) {
114 $date_end = $dates[
'date_end'];
115 $pastmonthyear = $dates[
'pastmonthyear'];
116 $pastmonth = $dates[
'pastmonth'];
119if (!GETPOSTISSET(
'date_startmonth') && (empty($date_start) || empty($date_end))) {
121 $date_end =
dol_get_last_day((
int) $pastmonthyear, (
int) $pastmonth,
false);
126$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,";
127$sql .=
" ba.courant, ba.ref as baref, ba.account_number, ba.fk_accountancy_journal,";
128$sql .=
" bu.type as bu_type";
129$sql .=
" FROM ".$db->prefix().
"bank as b";
130$sql .=
" JOIN ".$db->prefix().
"bank_account as ba on b.fk_account = ba.rowid";
131$sql .=
" LEFT JOIN ".$db->prefix().
"bank_url as bu ON bu.fk_bank = b.rowid";
132$sql .=
" WHERE ba.fk_accountancy_journal = ".((int) $id_journal);
133$sql .=
" AND b.amount <> 0 AND ba.entity IN (".getEntity(
'bank_account').
")";
134if ($date_start && $date_end) {
135 $sql .=
" AND b.dateo >= '".$db->idate($date_start).
"' AND b.dateo <= '".$db->idate($date_end).
"'";
139 $sql .=
" AND b.dateo >= '".$db->idate(
getDolGlobalInt(
'ACCOUNTING_DATE_START_BINDING')).
"'";
142if ($in_bookkeeping ==
'already') {
143 $sql .=
" AND (b.rowid IN (SELECT fk_doc FROM ".$db->prefix().
"accounting_bookkeeping as ab WHERE ab.doc_type='bank') )";
145if ($in_bookkeeping ==
'notyet') {
146 $sql .=
" AND (b.rowid NOT IN (SELECT fk_doc FROM ".$db->prefix().
"accounting_bookkeeping as ab WHERE ab.doc_type='bank') )";
148if ($only_rappro == 2) {
149 $sql .=
" AND (b.rappro = '1')";
151$sql .=
" ORDER BY b.dateo";
154$result_lines = array();
157$payment_ids = array();
159$tabaccount = array();
161$tabaccountingaccount = array();
162$tabvatdata = array();
164dol_syslog(
"accountancy/journal/treasuryjournal.php", LOG_DEBUG);
165$resql = $db->query($sql);
167 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
168 $static_account =
new Account($db);
170 while ($obj = $db->fetch_object($resql)) {
172 if (!isset($tabpay[$obj->rowid])) {
173 $tabpay[$obj->rowid] = array(
175 'date' => $db->jdate($obj->do),
176 'type_payment' => $obj->fk_type,
177 'ref' => $obj->label,
178 'fk_bank_account' => $obj->fk_account,
179 'objects' => array(),
182 if (preg_match(
'/^\((.*)\)$/i', $obj->label, $reg)) {
183 $tabpay[$obj->rowid][
"lib"] = $langs->trans($reg[1]);
185 $tabpay[$obj->rowid][
"lib"] =
dol_trunc($obj->label, 60);
188 $payment_ids[$obj->bu_type][$obj->rowid] = $obj->rowid;
191 if (!isset($tabaccount[$obj->fk_account])) {
192 $static_account->id = $obj->fk_account;
193 $static_account->ref = $obj->baref;
194 $tabaccount[$obj->fk_account] = [
195 'id' => $obj->fk_account,
196 'account_ref' => $obj->baref,
197 'account_number' => $obj->account_number,
198 'url' => $static_account->getNomUrl(1),
204 foreach ($payment_ids as $type => $ids) {
207 require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
211 $sql =
"SELECT f.rowid, f.ref AS ref, f.total_ht AS invoice_total_ht, f.total_ttc AS invoice_total_ttc,";
212 $sql .=
" pf.amount AS amount_payment,";
213 $sql .=
" fd.rowid AS row_id, fd.total_ht, fd.total_tva, fd.total_localtax1, fd.total_localtax2, fd.tva_tx, fd.total_ttc, fd.vat_src_code,";
214 $sql .=
" aa.account_number as accountancy_code, aa.label as accountancy_code_label,";
215 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
216 $sql .=
" FROM ".$db->prefix().
"facturedet as fd";
217 $sql .=
" INNER JOIN ".$db->prefix().
"facture as f ON f.rowid = fd.fk_facture";
218 $sql .=
" INNER JOIN ".$db->prefix().
"paiement_facture as pf ON pf.fk_facture = f.rowid";
219 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pf.fk_paiement AND bu.type = '".$db->escape($type).
"'";
220 $sql .=
" LEFT JOIN ".$db->prefix().
"product as p ON p.rowid = fd.fk_product";
221 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_account as aa ON aa.rowid = fd.fk_code_ventilation";
223 if ($in_bookkeeping ==
'already') {
224 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=f.rowid";
226 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=f.rowid";
228 $sql .=
" WHERE f.entity IN (".getEntity(
'facture', 0).
')';
230 if ($in_bookkeeping ==
'notyet') {
231 $sql .=
" AND ab.rowid IS NULL";
233 $sql .=
" AND fd.fk_code_ventilation > 0";
234 $sql .=
" AND f.fk_statut > 0";
235 $sql .=
" AND fd.product_type IN (0,1)";
237 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
239 $sql .=
" ORDER BY aa.account_number";
241 $resql = $db->query($sql);
243 $langs->load(
"bills");
244 $static_invoice =
new Facture($db);
245 $already_sum = array();
248 while ($obj = $db->fetch_object($resql)) {
249 $object_key = $obj->bu_type.
'_'.$obj->rowid;
255 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
256 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
257 'amount' => $obj->amount_payment,
258 'bu_url_id' => $obj->bu_url_id,
262 if (isset($already_sum[$obj->row_id])) {
265 $already_sum[$obj->row_id] = $obj->row_id;
268 if (!isset($tabobject[$object_key])) {
269 $static_invoice->id = $obj->rowid;
270 $static_invoice->ref = $obj->ref;
271 $tabobject[$object_key] = array(
274 'total_ht' => $obj->invoice_total_ht,
275 'total_ttc' => $obj->invoice_total_ttc,
276 'url' => $static_invoice->getNomUrl(1),
277 'operations' => array(),
283 if (!isset($tabaccountingaccount[$obj->accountancy_code])) {
284 $tabaccountingaccount[$obj->accountancy_code] = array(
285 'label' => !empty($obj->accountancy_code_label) ? $obj->accountancy_code_label : $langs->trans(
'NotDefined'),
290 if (!isset($tabobject[$object_key][
'operations'][$obj->accountancy_code])) {
291 $tabobject[$object_key][
'operations'][$obj->accountancy_code] = array(
295 $tabobject[$object_key][
'operations'][$obj->accountancy_code][
'total_ht'] += $obj->total_ht;
297 if ($obj->total_tva + $obj->total_localtax1 + $obj->total_localtax2 != 0) {
299 if (!isset($tabvatdata[$obj->tva_tx][$obj->vat_src_code])) {
300 $tabvatdata[$obj->tva_tx][$obj->vat_src_code] =
getTaxesFromId($obj->tva_tx.($obj->vat_src_code ?
' ('.$obj->vat_src_code.
')' :
''),
$mysoc,
$mysoc, 0);
302 $compta_tva = (!empty($tabvatdata[$obj->tva_tx][$obj->vat_src_code][
'accountancy_code_sell']) ? $tabvatdata[$obj->tva_tx][$obj->vat_src_code][
'accountancy_code_sell'] : $account_vat_sold);
305 if (!isset($tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx])) {
306 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx] = array(
307 'tva_tx' => $obj->tva_tx,
309 'total_localtax1' => 0,
310 'total_localtax2' => 0,
313 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_tva'] += $obj->total_tva;
314 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_localtax1'] += $obj->total_localtax1;
315 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_localtax2'] += $obj->total_localtax2;
322 case 'payment_supplier':
323 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
327 $sql =
"SELECT ff.rowid, ff.ref, ff.total_ht AS supplier_invoice_total_ht, ff.total_ttc AS supplier_invoice_total_ttc,";
328 $sql .=
" pff.amount AS amount_payment,";
329 $sql .=
" ffd.rowid AS row_id, ffd.total_ht, ffd.tva AS total_tva, ffd.total_localtax1, ffd.total_localtax2, ffd.tva_tx, ffd.total_ttc, ffd.vat_src_code,";
330 $sql .=
" aa.account_number as accountancy_code, aa.label as accountancy_code_label,";
331 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
332 $sql .=
" FROM ".$db->prefix().
"facture_fourn_det as ffd";
333 $sql .=
" INNER JOIN ".$db->prefix().
"facture_fourn as ff ON ff.rowid = ffd.fk_facture_fourn";
334 $sql .=
" INNER JOIN ".$db->prefix().
"paiementfourn_facturefourn as pff ON pff.fk_facturefourn = ff.rowid";
335 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pff.fk_paiementfourn AND bu.type = '".$db->escape($type).
"'";
336 $sql .=
" LEFT JOIN ".$db->prefix().
"product as p ON p.rowid = ffd.fk_product";
337 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_account as aa ON aa.rowid = ffd.fk_code_ventilation";
339 if ($in_bookkeeping ==
'already') {
340 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=ff.rowid";
342 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=ff.rowid";
344 $sql .=
" WHERE ff.entity IN (".getEntity(
'facture_fourn', 0).
')';
346 if ($in_bookkeeping ==
'notyet') {
347 $sql .=
" AND ab.rowid IS NULL";
349 $sql .=
" AND ffd.fk_code_ventilation > 0";
350 $sql .=
" AND ff.fk_statut > 0";
351 $sql .=
" AND ffd.product_type IN (0,1)";
353 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
355 $sql .=
" ORDER BY aa.account_number";
357 $resql = $db->query($sql);
359 $langs->load(
"suppliers");
361 $already_sum = array();
364 while ($obj = $db->fetch_object($resql)) {
365 $object_key = $obj->bu_type.
'_'.$obj->rowid;
368 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
369 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
370 'amount' => -$obj->amount_payment,
371 'bu_url_id' => $obj->bu_url_id,
375 if (isset($already_sum[$obj->row_id])) {
378 $already_sum[$obj->row_id] = $obj->row_id;
381 if (!isset($tabobject[$object_key])) {
382 $static_supplier_invoice->id = $obj->rowid;
383 $static_supplier_invoice->ref = $obj->ref;
384 $tabobject[$object_key] = array(
387 'total_ht' => -$obj->supplier_invoice_total_ht,
388 'total_ttc' => -$obj->supplier_invoice_total_ttc,
389 'url' => $static_supplier_invoice->getNomUrl(1),
390 'operations' => array(),
396 if (!isset($tabaccountingaccount[$obj->accountancy_code])) {
397 $tabaccountingaccount[$obj->accountancy_code] = array(
398 'label' => !empty($obj->accountancy_code_label) ? $obj->accountancy_code_label : $langs->trans(
'NotDefined'),
403 if (!isset($tabobject[$object_key][
'operations'][$obj->accountancy_code])) {
404 $tabobject[$object_key][
'operations'][$obj->accountancy_code] = array(
408 $tabobject[$object_key][
'operations'][$obj->accountancy_code][
'total_ht'] -= $obj->total_ht;
410 if ($obj->total_tva + $obj->total_localtax1 + $obj->total_localtax2 != 0) {
412 if (!isset($tabvatdata[$obj->tva_tx][$obj->vat_src_code])) {
413 $tabvatdata[$obj->tva_tx][$obj->vat_src_code] =
getTaxesFromId($obj->tva_tx.($obj->vat_src_code ?
' ('.$obj->vat_src_code.
')' :
''),
$mysoc,
$mysoc, 0);
415 $compta_tva = (!empty($tabvatdata[$obj->tva_tx][$obj->vat_src_code][
'accountancy_code_buy']) ? $tabvatdata[$obj->tva_tx][$obj->vat_src_code][
'accountancy_code_buy'] : $account_vat_buy);
418 if (!isset($tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx])) {
419 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx] = array(
420 'tva_tx' => $obj->tva_tx,
422 'total_localtax1' => 0,
423 'total_localtax2' => 0,
426 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_tva'] -= $obj->total_tva;
427 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_localtax1'] -= $obj->total_localtax1;
428 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_localtax2'] -= $obj->total_localtax2;
435 case 'payment_expensereport':
436 require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
440 $sql =
"SELECT er.rowid, er.ref, er.total_ht AS expense_report_total_ht, er.total_ttc AS expense_report_total_ttc,";
441 $sql .=
" per.amount AS amount_payment,";
442 $sql .=
" erf.rowid AS row_id, erf.total_ht, erf.total_tva, erf.total_localtax1, erf.total_localtax2, erf.tva_tx, erf.total_ttc, erf.vat_src_code,";
443 $sql .=
" ctf.accountancy_code,";
444 $sql .=
" aa.label as accountancy_code_label,";
445 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
446 $sql .=
" FROM ".$db->prefix().
"expensereport_det as erf";
447 $sql .=
" INNER JOIN ".$db->prefix().
"expensereport as er ON er.rowid = erf.fk_expensereport";
448 $sql .=
" INNER JOIN ".$db->prefix().
"payment_expensereport as per ON per.fk_expensereport = er.rowid";
449 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = per.rowid AND bu.type = '".$db->escape($type).
"'";
450 $sql .=
" LEFT JOIN ".$db->prefix().
"c_type_fees as ctf ON ctf.id = erf.fk_c_type_fees";
451 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_account as aa ON aa.account_number = ctf.accountancy_code";
453 if ($in_bookkeeping ==
'already') {
454 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=er.rowid";
456 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=er.rowid";
458 $sql .=
" WHERE er.entity IN (".getEntity(
'expensereport', 0).
')';
460 if ($in_bookkeeping ==
'notyet') {
461 $sql .=
" AND ab.rowid IS NULL";
463 $sql .=
" AND er.fk_statut >= ".ExpenseReport::STATUS_APPROVED;
464 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
466 $sql .=
" ORDER BY aa.account_number";
468 $resql = $db->query($sql);
470 $langs->load(
"trips");
472 $already_sum = array();
475 while ($obj = $db->fetch_object($resql)) {
476 $object_key = $obj->bu_type.
'_'.$obj->rowid;
479 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
480 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
481 'amount' => -$obj->amount_payment,
482 'bu_url_id' => $obj->bu_url_id,
486 if (isset($already_sum[$obj->row_id])) {
489 $already_sum[$obj->row_id] = $obj->row_id;
492 if (!isset($tabobject[$object_key])) {
493 $static_expense_report->id = $obj->rowid;
494 $static_expense_report->ref = $obj->ref;
495 $tabobject[$object_key] = array(
498 'total_ht' => -$obj->expense_report_total_ht,
499 'total_ttc' => -$obj->expense_report_total_ttc,
500 'url' => $static_expense_report->getNomUrl(1),
501 'operations' => array(),
507 $accountancy_code = !empty($obj->accountancy_code) ? $obj->accountancy_code :
'NotDefined';
508 if (!isset($tabaccountingaccount[$accountancy_code])) {
509 $tabaccountingaccount[$accountancy_code] = array(
510 'label' => !empty($obj->accountancy_code_label) ? $obj->accountancy_code_label : $langs->trans(
'NotDefined'),
515 if (!isset($tabobject[$object_key][
'operations'][$accountancy_code])) {
516 $tabobject[$object_key][
'operations'][$accountancy_code] = array(
520 $tabobject[$object_key][
'operations'][$accountancy_code][
'total_ht'] -= $obj->total_ht;
522 if ($obj->total_tva + $obj->total_localtax1 + $obj->total_localtax2 != 0) {
524 if (!isset($tabvatdata[$obj->tva_tx][$obj->vat_src_code])) {
525 $tabvatdata[$obj->tva_tx][$obj->vat_src_code] =
getTaxesFromId($obj->tva_tx.($obj->vat_src_code ?
' ('.$obj->vat_src_code.
')' :
''),
$mysoc,
$mysoc, 0);
527 $compta_tva = (!empty($tabvatdata[$obj->tva_tx][$obj->vat_src_code][
'accountancy_code_buy']) ? $tabvatdata[$obj->tva_tx][$obj->vat_src_code][
'accountancy_code_buy'] : $account_vat_buy);
530 if (!isset($tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx])) {
531 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx] = array(
532 'tva_tx' => $obj->tva_tx,
534 'total_localtax1' => 0,
535 'total_localtax2' => 0,
538 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_tva'] -= $obj->total_tva;
539 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_localtax1'] -= $obj->total_localtax1;
540 $tabobject[$object_key][
'vats'][$compta_tva][$obj->tva_tx][
'total_localtax2'] -= $obj->total_localtax2;
547 case 'payment_salary':
550 $sql =
"SELECT ps.rowid,";
551 $sql .=
" ps.amount AS amount_payment, ps.label AS label,";
552 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
553 $sql .=
" FROM ".$db->prefix().
"payment_salary as ps";
554 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = ps.rowid AND bu.type = '".$db->escape($type).
"'";
556 if ($in_bookkeeping ==
'already') {
557 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=ps.rowid";
559 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=ps.rowid";
561 $sql .=
" WHERE ps.entity IN (".getEntity(
'user', 0).
')';
563 if ($in_bookkeeping ==
'notyet') {
564 $sql .=
" AND ab.rowid IS NULL";
566 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
568 $resql = $db->query($sql);
570 require_once DOL_DOCUMENT_ROOT.
'/salaries/class/paymentsalary.class.php';
571 $langs->load(
"salaries");
573 $account_employee =
getDolGlobalString(
'SALARIES_ACCOUNTING_ACCOUNT_PAYMENT',
'NotDefined');
576 while ($obj = $db->fetch_object($resql)) {
577 $object_key = $obj->bu_type.
'_'.$obj->rowid;
580 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
581 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
582 'amount' => -$obj->amount_payment,
583 'bu_url_id' => $obj->bu_url_id,
588 if (!isset($tabobject[$object_key])) {
589 $static_payment_salary->id = $obj->rowid;
590 $static_payment_salary->ref = $prefix_ref.$obj->rowid;
591 $tabobject[$object_key] = array(
593 'ref' => $prefix_ref.$obj->rowid,
594 'total_ht' => -$obj->amount_payment,
595 'total_ttc' => -$obj->amount_payment,
596 'url' => $static_payment_salary->getNomUrl(1),
597 'operations' => array(),
603 $tabobject[$object_key][
'operations'][$account_employee] = array(
604 'total_ht' => -$obj->amount_payment,
605 'label' => $obj->label,
615 $sql =
"SELECT cs.rowid, cs.ref, cs.libelle AS label, cs.amount AS sociales_contributions_amount,";
616 $sql .=
" pc.amount AS amount_payment,";
617 $sql .=
" ccs.accountancy_code,";
618 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
619 $sql .=
" FROM ".$db->prefix().
"paiementcharge as pc";
620 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pc.rowid AND bu.type = '".$db->escape($type).
"'";
621 $sql .=
" INNER JOIN ".$db->prefix().
"chargesociales AS cs ON cs.rowid = pc.fk_charge";
622 $sql .=
" LEFT JOIN ".$db->prefix().
"c_chargesociales as ccs ON ccs.id = cs.fk_type";
624 if ($in_bookkeeping ==
'already') {
625 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=cs.rowid";
627 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=cs.rowid";
629 $sql .=
" WHERE cs.entity = ".$conf->entity;
631 if ($in_bookkeeping ==
'notyet') {
632 $sql .=
" AND ab.rowid IS NULL";
634 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
636 $resql = $db->query($sql);
638 require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
640 $langs->load(
"bills");
642 $prefix_ref =
getDolGlobalString(
'MAIN_PAYMENT_SOCIALES_CONTRIBUTIONS_REF_PREFIX',
'SC');
644 while ($obj = $db->fetch_object($resql)) {
645 $object_key = $obj->bu_type.
'_'.$obj->rowid;
648 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
649 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
650 'amount' => -$obj->amount_payment,
651 'bu_url_id' => $obj->bu_url_id,
656 if (!isset($tabobject[$object_key])) {
657 $static_sociales_contributions->id = $obj->rowid;
658 $static_sociales_contributions->ref = $prefix_ref.$obj->rowid;
659 $tabobject[$object_key] = array(
661 'ref' => $prefix_ref.$obj->rowid,
662 'total_ht' => -$obj->sociales_contributions_amount,
663 'total_ttc' => -$obj->sociales_contributions_amount,
664 'url' => $static_sociales_contributions->getNomUrl(1),
665 'operations' => array(),
670 $accountancy_code = !empty($obj->accountancy_code) ? $obj->accountancy_code :
'NotDefined';
673 $tabobject[$object_key][
'operations'][$accountancy_code] = array(
674 'total_ht' => -$obj->sociales_contributions_amount,
675 'label' => $obj->label,
686 $sql =
"SELECT pv.rowid, t.rowid AS tva_id,";
687 $sql .=
" pv.amount AS amount_payment, t.label AS label,";
688 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
689 $sql .=
" FROM ".$db->prefix().
"payment_vat as pv";
690 $sql .=
" INNER JOIN ".$db->prefix().
"tva as t ON t.rowid = pv.fk_tva";
691 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pv.rowid AND bu.type = '".$db->escape($type).
"'";
693 if ($in_bookkeeping ==
'already') {
694 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=t.rowid";
696 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=t.rowid";
698 $sql .=
" WHERE bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
701 if ($in_bookkeeping ==
'notyet') {
702 $sql .=
" AND ab.rowid IS NULL";
705 $resql = $db->query($sql);
707 require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
709 $langs->load(
"salaries");
710 $static_tva =
new Tva($db);
714 while ($obj = $db->fetch_object($resql)) {
715 $object_key = $obj->bu_type.
'_'.$obj->rowid;
718 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
719 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
720 'amount' => -$obj->amount_payment,
721 'bu_url_id' => $obj->bu_url_id,
726 if (!isset($tabobject[$object_key])) {
727 $static_tva->id = $obj->tva_id;
728 $static_tva->ref = $prefix_ref.$obj->tva_id;
729 $tabobject[$object_key] = array(
730 'id' => $obj->tva_id,
731 'ref' => $prefix_ref.$obj->tva_id,
732 'total_ht' => -$obj->amount_payment,
733 'total_ttc' => -$obj->amount_payment,
734 'url' => $static_tva->getNomUrl(1),
735 'operations' => array(),
741 $tabobject[$object_key][
'operations'][$account_pay_vat] = array(
742 'total_ht' => -$obj->amount_payment,
743 'label' => $obj->label,
750 case 'payment_donation':
753 $sql =
"SELECT d.rowid, d.amount AS don_amount,";
754 $sql .=
" pd.amount AS amount_payment,";
755 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
756 $sql .=
" FROM ".$db->prefix().
"payment_donation as pd";
757 $sql .=
" INNER JOIN ".$db->prefix().
"don as d ON pd.fk_donation = d.rowid";
758 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pd.rowid AND bu.type = '".$db->escape($type).
"'";
760 if ($in_bookkeeping ==
'already') {
761 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=d.rowid";
763 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=d.rowid";
765 $sql .=
" WHERE d.entity IN (".getEntity(
'donation', 0).
')';
767 if ($in_bookkeeping ==
'notyet') {
768 $sql .=
" AND ab.rowid IS NULL";
770 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
772 $resql = $db->query($sql);
774 require_once DOL_DOCUMENT_ROOT.
'/don/class/don.class.php';
776 $langs->load(
"donations");
777 $static_don =
new Don($db);
778 $account_pay_donation =
getDolGlobalString(
'DONATION_ACCOUNTINGACCOUNT',
'NotDefined');
781 while ($obj = $db->fetch_object($resql)) {
782 $object_key = $obj->bu_type.
'_'.$obj->rowid;
785 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
786 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
787 'amount' => $obj->amount_payment,
788 'bu_url_id' => $obj->bu_url_id,
793 if (!isset($tabobject[$object_key])) {
794 $static_don->id = $obj->rowid;
795 $static_don->ref = $prefix_ref.$obj->rowid;
796 $tabobject[$object_key] = array(
798 'ref' => $prefix_ref.$obj->rowid,
799 'total_ht' => $obj->don_amount,
800 'total_ttc' => $obj->don_amount,
801 'url' => $static_don->getNomUrl(1),
802 'operations' => array(),
808 $tabobject[$object_key][
'operations'][$account_pay_donation] = array(
809 'total_ht' => $obj->don_amount,
810 'label' => $langs->trans(
'Donation').
' '.$prefix_ref.$obj->rowid,
820 $sql =
"SELECT l.rowid, l.capital AS loan_capital, l.accountancy_account_capital, l.accountancy_account_interest, l.accountancy_account_insurance, l.label,";
821 $sql .=
" pl.amount_capital, pl.amount_interest, pl.amount_insurance,";
822 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
823 $sql .=
" FROM ".$db->prefix().
"payment_loan as pl";
824 $sql .=
" INNER JOIN ".$db->prefix().
"loan as l ON pl.fk_loan = l.rowid";
825 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pl.rowid AND bu.type = '".$db->escape($type).
"'";
827 if ($in_bookkeeping ==
'already') {
828 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=l.rowid";
830 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=l.rowid";
832 $sql .=
" WHERE l.entity = ".$conf->entity;
834 if ($in_bookkeeping ==
'notyet') {
835 $sql .=
" AND ab.rowid IS NULL";
837 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
839 $resql = $db->query($sql);
841 require_once DOL_DOCUMENT_ROOT.
'/loan/class/loan.class.php';
843 $langs->load(
"loan");
844 $static_loan =
new Loan($db);
845 $account_pay_loan_capital =
getDolGlobalString(
'LOAN_ACCOUNTING_ACCOUNT_CAPITAL',
'NotDefined');
846 $account_pay_loan_interest =
getDolGlobalString(
'LOAN_ACCOUNTING_ACCOUNT_INTEREST',
'NotDefined');
847 $account_pay_loan_insurance =
getDolGlobalString(
'LOAN_ACCOUNTING_ACCOUNT_INSURANCE',
'NotDefined');
850 while ($obj = $db->fetch_object($resql)) {
851 $object_key = $obj->bu_type.
'_'.$obj->rowid;
854 $payment_amount = $obj->amount_capital + $obj->amount_interest + $obj->amount_insurance;
855 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
856 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
857 'amount' => -$payment_amount,
858 'bu_url_id' => $obj->bu_url_id,
863 if (!isset($tabobject[$object_key])) {
864 $static_loan->id = $obj->rowid;
865 $static_loan->ref = $prefix_ref.$obj->rowid;
866 $tabobject[$object_key] = array(
868 'ref' => $prefix_ref.$obj->rowid,
869 'total_ht' => -$obj->loan_capital,
870 'total_ttc' => -$obj->loan_capital,
871 'url' => $static_loan->getNomUrl(1),
872 'operations' => array(),
878 $accountancy_account_capital = !empty($obj->accountancy_account_capital) ? $obj->accountancy_account_capital : $account_pay_loan_capital;
879 $tabobject[$object_key][
'operations'][$accountancy_account_capital] = array(
881 'total_ht' => -($obj->loan_capital * $obj->amount_capital / $payment_amount),
882 'label' => $obj->label.
' '.$langs->trans(
'LoanCapital'),
886 $accountancy_account_interest = !empty($obj->accountancy_account_interest) ? $obj->accountancy_account_interest : $account_pay_loan_interest;
887 $tabobject[$object_key][
'operations'][$accountancy_account_interest] = array(
889 'total_ht' => -($obj->loan_capital * $obj->amount_interest / $payment_amount),
890 'label' => $obj->label.
' '.$langs->trans(
'Interest'),
896 $accountancy_account_insurance = !empty($obj->accountancy_account_insurance) ? $obj->accountancy_account_insurance : $account_pay_loan_insurance;
897 $tabobject[$object_key][
'operations'][$accountancy_account_insurance] = array(
899 'total_ht' => -($obj->loan_capital * $obj->amount_insurance / $payment_amount),
900 'label' => $obj->label.
' '.$langs->trans(
'Insurance'),
907 case 'payment_various':
910 $sql =
"SELECT pv.rowid,";
911 $sql .=
" pv.sens AS sens_payment, pv.amount AS amount_payment, pv.label, pv.accountancy_code,";
912 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
913 $sql .=
" FROM ".$db->prefix().
"payment_various as pv";
914 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.url_id = pv.rowid AND bu.type = '".$db->escape($type).
"'";
916 if ($in_bookkeeping ==
'already') {
917 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=pv.rowid";
919 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=pv.rowid";
921 $sql .=
" WHERE pv.entity IN (".getEntity(
'payment_various', 0).
')';
922 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
924 if ($in_bookkeeping ==
'notyet') {
925 $sql .=
" AND ab.rowid IS NULL";
928 $resql = $db->query($sql);
930 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/paymentvarious.class.php';
935 while ($obj = $db->fetch_object($resql)) {
936 $object_key = $obj->bu_type.
'_'.$obj->rowid;
938 $payment_amount = (empty($obj->sens_payment) ? -1 : 1) * $obj->amount_payment;
940 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
941 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
942 'amount' => $payment_amount,
943 'bu_url_id' => $obj->bu_url_id,
948 if (!isset($tabobject[$object_key])) {
949 $static_payment_various->id = $obj->rowid;
950 $static_payment_various->ref = $prefix_ref.$obj->rowid;
951 $tabobject[$object_key] = array(
953 'ref' => $prefix_ref.$obj->rowid,
954 'total_ht' => $payment_amount,
955 'total_ttc' => $payment_amount,
956 'url' => $static_payment_various->getNomUrl(1),
957 'operations' => array(),
963 $accountancy_code = !empty($obj->accountancy_code) ? $obj->accountancy_code :
'NotDefined';
964 $tabobject[$object_key][
'operations'][$obj->accountancy_code] = array(
965 'total_ht' => $payment_amount,
966 'label' => $obj->label,
976 $sql =
"SELECT su.rowid,";
977 $sql .=
" su.subscription AS amount_payment, su.note AS label,";
978 $sql .=
" adh.lastname, adh.firstname,";
979 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
980 $sql .=
" FROM ".$db->prefix().
"subscription as su";
981 $sql .=
" INNER JOIN ".$db->prefix().
"adherent as adh ON adh.rowid = su.fk_adherent";
982 $sql .=
" INNER JOIN ".$db->prefix().
"bank_url as bu ON bu.fk_bank = su.fk_bank AND bu.type = '".$db->escape($type).
"'";
984 if ($in_bookkeeping ==
'already') {
985 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=su.rowid";
987 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=su.rowid";
989 $sql .=
" WHERE bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
991 if ($in_bookkeeping ==
'notyet') {
992 $sql .=
" AND ab.rowid IS NULL";
995 $resql = $db->query($sql);
997 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
999 $langs->load(
"members");
1001 $account_subscription =
getDolGlobalString(
'ADHERENT_SUBSCRIPTION_ACCOUNTINGACCOUNT',
'NotDefined');
1004 while ($obj = $db->fetch_object($resql)) {
1005 $object_key = $obj->bu_type.
'_'.$obj->rowid;
1008 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
1009 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
1010 'amount' => $obj->amount_payment,
1011 'bu_url_id' => $obj->bu_url_id,
1016 if (!isset($tabobject[$object_key])) {
1017 $static_subscription->id = $obj->rowid;
1018 $static_subscription->ref = $prefix_ref.$obj->rowid;
1019 $tabobject[$object_key] = array(
1020 'id' => $obj->rowid,
1021 'ref' => $prefix_ref.$obj->rowid,
1022 'total_ht' => -$obj->amount_payment,
1023 'total_ttc' => -$obj->amount_payment,
1024 'url' => $static_subscription->getNomUrl(1),
1025 'operations' => array(),
1031 $tabobject[$object_key][
'operations'][$account_subscription] = array(
1032 'total_ht' => -$obj->amount_payment,
1033 'label' => $obj->label.
' - '.$obj->lastname.
' '.$obj->firstname,
1040 case 'banktransfert':
1043 $sql =
"SELECT b.rowid, b.amount, b.label,";
1044 $sql .=
" bu.fk_bank, bu.url_id AS bu_url_id, bu.type AS bu_type";
1045 $sql .=
" FROM ".$db->prefix().
"bank_url as bu";
1046 $sql .=
" INNER JOIN ".$db->prefix().
"bank as b ON bu.url_id = b.rowid";
1047 $sql .=
" LEFT JOIN ".$db->prefix().
"bank_account as ba ON ba.rowid = b.fk_account";
1049 if ($in_bookkeeping ==
'already') {
1050 $sql .=
" INNER JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=b.rowid";
1052 $sql .=
" LEFT JOIN ".$db->prefix().
"accounting_bookkeeping as ab ON ab.fk_doc=bu.fk_bank AND ab.fk_docdet=b.rowid";
1054 $sql .=
" WHERE ba.entity IN (".getEntity(
'bank_account', 0).
')';
1055 $sql .=
" AND bu.fk_bank IN (".$db->sanitize(implode(
',', $ids)).
")";
1056 $sql .=
" AND bu.type = '".$db->escape($type).
"'";
1058 if ($in_bookkeeping ==
'notyet') {
1059 $sql .=
" AND ab.rowid IS NULL";
1062 $resql = $db->query($sql);
1064 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
1067 $account_transfer =
getDolGlobalString(
'ACCOUNTING_ACCOUNT_TRANSFER_CASH',
'NotDefined');
1070 while ($obj = $db->fetch_object($resql)) {
1071 $object_key = $obj->bu_type.
'_'.$obj->rowid;
1074 if (!isset($tabpay[$obj->fk_bank][
'objects'][$object_key])) {
1075 $tabpay[$obj->fk_bank][
'objects'][$object_key] = array(
1076 'amount' => -$obj->amount,
1077 'bu_url_id' => $obj->bu_url_id,
1082 if (!isset($tabobject[$object_key])) {
1083 $static_account_line->id = $obj->rowid;
1084 $static_account_line->rowid = $obj->rowid;
1085 $static_account_line->ref = $prefix_ref.$obj->rowid;
1086 $tabobject[$object_key] = array(
1087 'id' => $obj->rowid,
1088 'ref' => $prefix_ref.$obj->rowid,
1089 'total_ht' => -$obj->amount,
1090 'total_ttc' => -$obj->amount,
1091 'url' => $static_account_line->getNomUrl(1),
1092 'operations' => array(),
1098 $tabobject[$object_key][
'operations'][$account_transfer] = array(
1099 'total_ht' => -$obj->amount,
1100 'label' => $obj->label,
1121 return isset($v[
'objects']) && count($v[
'objects']) > 0;
1124$tabpay = array_filter($tabpay,
'payment_filter');
1130$accountingjournalstatic->fetch($id_journal);
1131$journal = $accountingjournalstatic->code;
1132$journal_label = $langs->transnoentitiesnoconv($accountingjournalstatic->label);
1136if ($action ==
'writebookkeeping' ) {
1137 foreach ($tabpay as $payment_id => $payment) {
1138 $accountInfos = $tabaccount[$payment[
"fk_bank_account"]];
1141 if (!isset($tabaccountingaccount[$accountInfos[
'account_number']])) {
1142 $result = $accountingaccount->fetch(0, $accountInfos[
'account_number'],
true);
1144 setEventMessages($accountingaccount->error, $accountingaccount->errors,
'errors');
1148 $tabaccountingaccount[$accountInfos[
'account_number']] = array(
1149 'label' => $result > 0 ? $accountingaccount->label : $langs->trans(
'NotDefined'),
1157 foreach ($payment[
'objects'] as $object_key => $object_data) {
1158 $objectInfos = $tabobject[$object_key];
1160 $label_suffix = (count($payment[
'objects']) > 1 ?
' - '.$objectInfos[
'ref'] :
'');
1165 if ($object_data[
'amount'] >= 0) {
1166 $amount = (float)
price2num($object_data[
'amount'],
'MT');
1167 $total_check += $amount;
1174 $result = $bookkeepingToCreate->createFromValues($payment[
"date"], $objectInfos[
'ref'],
'bank', $payment_id, 0, $accountInfos[
'account_number'], $tabaccountingaccount[$accountInfos[
'account_number']][
'label'], $accountInfos[
'account_ref'].$label_suffix, $amount, $journal, $journal_label,
'');
1179 if (!empty($bookkeepingToCreate->warnings)) {
1182 if (!empty($bookkeepingToCreate->errors)) {
1189 $payment_total_vat = (float)
price2num($object_data[
'amount'] * ($objectInfos[
'total_ttc'] - $objectInfos[
'total_ht']) / $objectInfos[
'total_ttc'],
'MT');
1190 $payment_total_ht = $object_data[
'amount'] - $payment_total_vat;
1191 $total_operation = 0;
1193 $nb_operation = count($objectInfos[
'operations']);
1194 foreach ($objectInfos[
'operations'] as $accountancy_code => $operation) {
1195 if (!empty($operation[
'total_ht'])) {
1197 if (!isset($tabaccountingaccount[$accountancy_code])) {
1198 $result = $accountingaccount->fetch(0, $accountancy_code,
true);
1200 setEventMessages($accountingaccount->error, $accountingaccount->errors,
'errors');
1201 $accountancy_code_label = $accountingaccount->errorsToString();
1203 } elseif ($result > 0) {
1204 $accountancy_code_label = $accountingaccount->label;
1206 $accountancy_code_label = $langs->trans(
'NotDefined');
1208 $tabaccountingaccount[$accountancy_code] = array(
'label' => $accountancy_code_label);
1210 $accountingAccountInfos = $tabaccountingaccount[$accountancy_code];
1211 if ($idx < $nb_operation) {
1212 $amount =
price2num($payment_total_ht * $operation[
'total_ht'] / $objectInfos[
'total_ht'],
'MT');
1213 $total_operation += (float) $amount;
1215 $amount = $payment_total_ht - $total_operation;
1217 $total_check -= (float) $amount;
1221 $result = $bookkeepingToCreate->createFromValues($payment[
"date"], $objectInfos[
'ref'],
'bank', $payment_id, 0, $accountancy_code, $accountingAccountInfos[
'label'], (!empty($operation[
'label']) ? $operation[
'label'] : $accountingAccountInfos[
'label']).$label_suffix, - (float) $amount, $journal, $journal_label,
'');
1225 if (!empty($bookkeepingToCreate->warnings)) {
1228 if (!empty($bookkeepingToCreate->errors)) {
1240 foreach ($objectInfos[
'vats'] as $accountancy_code => $vats) {
1241 foreach ($vats as $vat_tx => $vat_infos) {
1245 foreach ($objectInfos[
'vats'] as $accountancy_code => $vats) {
1246 foreach ($vats as $vat_tx => $vat_infos) {
1247 $amount = $vat_infos[
'total_tva'] + $vat_infos[
'total_localtax1'] + $vat_infos[
'total_localtax2'];
1248 if (!empty($amount)) {
1250 if (!isset($tabaccountingaccount[$accountancy_code])) {
1251 $result = $accountingaccount->fetch(0, $accountancy_code,
true);
1253 setEventMessages($accountingaccount->error, $accountingaccount->errors,
'errors');
1254 $accountancy_code_label = $accountingaccount->errorsToString();
1256 } elseif ($result > 0) {
1257 $accountancy_code_label = $accountingaccount->label;
1259 $accountancy_code_label = $langs->trans(
'NotDefined');
1261 $tabaccountingaccount[$accountancy_code] = array(
'label' => $accountancy_code_label);
1263 $accountingAccountInfos = $tabaccountingaccount[$accountancy_code];
1264 $amount = (float)
price2num($payment_total_vat * $amount / ($objectInfos[
'total_ttc'] - $objectInfos[
'total_ht']),
'MT');
1265 $total_vat += $amount;
1266 $total_check -= $amount;
1270 $result = $bookkeepingToCreate->createFromValues($payment[
"date"], $objectInfos[
'ref'],
'bank', $payment_id, 0, $accountancy_code, $accountingAccountInfos[
'label'], $langs->trans(
'VAT').
' '.
price($vat_infos[
'tva_tx']).
'%'.$label_suffix, -$amount, $journal, $journal_label,
'');
1274 if (!empty($bookkeepingToCreate->warnings)) {
1277 if (!empty($bookkeepingToCreate->errors)) {
1287 if ($object_data[
'amount'] < 0) {
1288 $amount = (float)
price2num($object_data[
'amount'],
'MT');
1289 $total_check += $amount;
1293 $result = $bookkeepingToCreate->createFromValues($payment[
"date"], $objectInfos[
'ref'],
'bank', $payment_id, 0, $accountInfos[
'account_number'], $tabaccountingaccount[$accountInfos[
'account_number']][
'label'], $accountInfos[
'account_ref'].$label_suffix, $amount, $journal, $journal_label,
'');
1297 if (!empty($bookkeepingToCreate->warnings)) {
1300 if (!empty($bookkeepingToCreate->errors)) {
1306 $total_check =
price2num($total_check,
'MT');
1307 if (!empty($total_check)) {
1309 setEventMessages($langs->trans(
'ErrorBookkeepingTryInsertNotBalancedTransactionAndCanceled', $objectInfos[
'ref'], $object_data[
'bu_url_id']),
null,
'errors');
1312 if ($errorforline) {
1315 if ($error >= $MAXNBERRORS) {
1321 if (!$errorforline) {
1328 if ($error >= $MAXNBERRORS) {
1329 setEventMessages($langs->trans(
"ErrorTooManyErrorsProcessStopped").
' (>'.$MAXNBERRORS.
')',
null,
'errors');
1335 if (empty($error) && count($tabpay) > 0) {
1337 } elseif (count($tabpay) == $error) {
1340 setEventMessages($langs->trans(
"GeneralLedgerSomeRecordWasNotRecorded"),
null,
'warnings');
1346 if (count($tabpay) != $error) {
1347 $param =
'id_journal='.$id_journal;
1348 $param .=
'&date_startday='.$date_startday;
1349 $param .=
'&date_startmonth='.$date_startmonth;
1350 $param .=
'&date_startyear='.$date_startyear;
1351 $param .=
'&date_endday='.$date_endday;
1352 $param .=
'&date_endmonth='.$date_endmonth;
1353 $param .=
'&date_endyear='.$date_endyear;
1354 $param .=
'&in_bookkeeping='.$in_bookkeeping;
1355 header(
"Location: " . $_SERVER[
'PHP_SELF'] .
'?' . $param);
1365$form =
new Form($db);
1368if (empty($action) || $action ==
'view') {
1369 llxHeader(
'', $langs->trans(
"FinanceJournal"));
1371 $nom = $langs->trans(
"FinanceJournal").
' | '.$accountingjournalstatic->getNomUrl(0, 1, 1,
'', 1);
1374 $description = $langs->trans(
"DescJournalOnlyBindedVisible").
'<br>';
1376 $listofchoices = array(
1377 'notyet' => $langs->trans(
"NotYetInGeneralLedger"),
1378 'already' => $langs->trans(
"AlreadyInGeneralLedger")
1380 $period = $form->selectDate($date_start ?: -1,
'date_start', 0, 0, 0,
'', 1, 0).
' - '.$form->selectDate($date_end ?: -1,
'date_end', 0, 0, 0,
'', 1, 0);
1381 $period .=
' - '.$langs->trans(
"JournalizationInLedgerStatus").
' '.$form->selectarray(
'in_bookkeeping', $listofchoices, $in_bookkeeping, 1);
1383 $varlink =
'id_journal='.$id_journal;
1387 journalHead($nom, $nomlink, $period, $periodlink, $description, $builddate, $exportlink, array(
'action' =>
''),
'', $varlink);
1390 $sql =
"SELECT COUNT(rowid) as nb FROM ".$db->prefix().
"bank_account WHERE fk_accountancy_journal IS NULL AND clos = 0";
1391 $resql = $db->query($sql);
1393 $obj = $db->fetch_object($resql);
1395 print
'<br>'.img_warning().
' '.$langs->trans(
"TheJournalCodeIsNotDefinedOnSomeBankAccount");
1396 print
' : '.$langs->trans(
"AccountancyAreaDescBank", 9,
'<strong>'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"Setup").
"-".$langs->transnoentitiesnoconv(
"BankAccounts").
'</strong>');
1406 print
'<br>'.img_warning().
' '.$langs->trans(
"SomeMandatoryStepsOfSetupWereNotDone");
1407 print
' : '.$langs->trans(
"AccountancyAreaDescMisc", 4,
'<strong>'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"MenuAccountancy").
'-'.$langs->transnoentitiesnoconv(
"Setup").
"-".$langs->transnoentitiesnoconv(
"MenuDefaultAccounts").
'</strong>');
1410 print
'<br><div class="tabsAction tabsActionNoBottom centerimp">';
1413 print
'<input type="button" class="butAction" name="exportcsv" value="'.$langs->trans(
"ExportDraftJournal").
'" onclick="launch_export();" />';
1419 print
'<input type="button" class="butActionRefused classfortooltip" title="'.dol_escape_htmltag($langs->trans(
"SomeMandatoryStepsOfSetupWereNotDone")).
'" value="'.$langs->trans(
"WriteBookKeeping").
'" />';
1421 if ($in_bookkeeping ==
'notyet') {
1422 print
'<input type="button" class="butAction" name="writebookkeeping" value="'.$langs->trans(
"WriteBookKeeping").
'" onclick="writebookkeeping();" />';
1424 print
'<a class="butActionRefused classfortooltip" name="writebookkeeping">'.$langs->trans(
"WriteBookKeeping").
'</a>';
1431 <script type="text/javascript">
1432 function writebookkeeping() {
1433 console.log("Set value into form and submit");
1434 $("div.fiche form input[name=\"action\"]").val("writebookkeeping");
1435 $("div.fiche form input[type=\"submit\"]").click();
1436 $("div.fiche form input[name=\"action\"]").val("");
1446 print
'<div class="div-table-responsive">';
1447 print
'<table class="noborder centpercent">';
1448 print
'<tr class="liste_titre">';
1449 print
"<td>".$langs->trans(
"Date").
"</td>";
1450 print
"<td>".$langs->trans(
"Piece").
' ('.$langs->trans(
"ObjectsRef").
')</td>';
1451 print
"<td>".$langs->trans(
"AccountAccounting").
"</td>";
1452 print
"<td>".$langs->trans(
"LabelOperation").
"</td>";
1453 print
'<td class="center">'.$langs->trans(
"PaymentMode").
"</td>";
1454 print
'<td class="right">'.$langs->trans(
"AccountingDebit").
"</td>";
1455 print
'<td class="right">'.$langs->trans(
"AccountingCredit").
"</td>";
1458 foreach ($tabpay as $payment_id => $payment) {
1459 $accountInfos = $tabaccount[$payment[
"fk_bank_account"]];
1463 foreach ($payment[
'objects'] as $object_key => $object_data) {
1464 $objectInfos = $tabobject[$object_key];
1466 $label_suffix = (count($payment[
'objects']) > 1 ?
' - '.$objectInfos[
'ref'] :
'');
1469 if ($object_data[
'amount'] >= 0) {
1470 FormAccounting::printJournalLine($langs, $date, $objectInfos[
'url'], $accountInfos[
'account_number'], $accountInfos[
'account_ref'].$label_suffix, $payment[
'type_payment'], $object_data[
'amount']);
1474 $payment_total_vat = (float)
price2num($object_data[
'amount'] * ($objectInfos[
'total_ttc'] - $objectInfos[
'total_ht']) / $objectInfos[
'total_ttc'],
'MT');
1475 $payment_total_ht = $object_data[
'amount'] - $payment_total_vat;
1476 $total_operation = 0;
1478 $nb_operation = count($objectInfos[
'operations']);
1479 foreach ($objectInfos[
'operations'] as $accountancy_code => $operation) {
1481 if (!isset($tabaccountingaccount[$accountancy_code])) {
1482 $result = $accountingaccount->fetch(0, $accountancy_code,
true);
1483 $tabaccountingaccount[$accountancy_code] = array(
1484 'label' => $result < 0 ? $accountingaccount->errorsToString() : ($result > 0 ? $accountingaccount->label : $langs->trans(
'NotDefined')),
1487 $accountingAccountInfos = $tabaccountingaccount[$accountancy_code];
1488 if (!empty($operation[
'total_ht'])) {
1489 if ($idx < $nb_operation) {
1490 $value =
price2num($payment_total_ht * $operation[
'total_ht'] / $objectInfos[
'total_ht'],
'MT');
1491 $total_operation += (float) $value;
1493 $value = $payment_total_ht - $total_operation;
1495 FormAccounting::printJournalLine($langs, $date, $objectInfos[
'url'], $accountancy_code, (!empty($operation[
'label']) ? $operation[
'label'] : $accountingAccountInfos[
'label']).$label_suffix, $payment[
'type_payment'], - (float) $value);
1504 foreach ($objectInfos[
'vats'] as $accountancy_code => $vats) {
1505 foreach ($vats as $vat_tx => $vat_infos) {
1509 foreach ($objectInfos[
'vats'] as $accountancy_code => $vats) {
1510 foreach ($vats as $vat_tx => $vat_infos) {
1511 $amount_vat = $vat_infos[
'total_tva'] + $vat_infos[
'total_localtax1'] + $vat_infos[
'total_localtax2'];
1512 if (!empty($amount_vat)) {
1513 $amount_vat = (float)
price2num($payment_total_vat * $amount_vat / ($objectInfos[
'total_ttc'] - $objectInfos[
'total_ht']),
'MT');
1514 $total_vat += $amount_vat;
1515 FormAccounting::printJournalLine($langs, $date, $objectInfos[
'url'], $accountancy_code, $langs->trans(
'VAT').
' '.
price($vat_infos[
'tva_tx']).
'%'.$label_suffix, $payment[
'type_payment'], -$amount_vat);
1522 if ($object_data[
'amount'] < 0) {
1523 FormAccounting::printJournalLine($langs, $date, $objectInfos[
'url'], $accountInfos[
'account_number'], $accountInfos[
'account_ref'].$label_suffix, $payment[
'type_payment'], $object_data[
'amount']);
1530 print
'<tr class="oddeven"><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
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.
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Class to manage bank accounts.
Class to manage bank transaction lines.
Class to manage accounting accounts.
Class to manage accounting journals.
Class to manage Ledger (General Ledger and Subledger)
Class for managing the social charges.
const TYPE_SITUATION
Situation invoice.
Class to manage donations.
Class to manage Trips and Expenses.
Class to manage suppliers invoices.
const TYPE_DEPOSIT
Deposit invoice.
const TYPE_CREDIT_NOTE
Credit note invoice.
const TYPE_REPLACEMENT
Replacement invoice.
Class to manage invoices.
const TYPE_REPLACEMENT
Replacement invoice.
const TYPE_SITUATION
Situation invoice.
const TYPE_DEPOSIT
Deposit invoice.
const TYPE_CREDIT_NOTE
Credit note invoice.
Class to manage payments of salaries.
Class to manage various payments.
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)
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_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.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
getTaxesFromId($vatrate, $buyer=null, $seller=null, $firstparamisid=1)
Get tax (VAT) main information from Id.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_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.
payment_filter($v)
Filter for payment.