30 require
'../../main.inc.php';
31 require_once DOL_DOCUMENT_ROOT.
'/core/lib/bank.lib.php';
32 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
33 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
34 require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
35 require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/class/paiement.class.php';
36 require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
37 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/paiementfourn.class.php';
38 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
39 require_once DOL_DOCUMENT_ROOT.
'/compta/paiement/cheque/class/remisecheque.class.php';
40 require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
41 require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
42 require_once DOL_DOCUMENT_ROOT.
'/don/class/paymentdonation.class.php';
43 require_once DOL_DOCUMENT_ROOT.
'/loan/class/paymentloan.class.php';
44 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/paymentvarious.class.php';
46 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
47 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions.lib.php';
50 $langs->loadLangs(array(
"banks",
"categories",
"companies",
"bills",
"trips",
"donations",
"loan",
"salaries"));
52 $action =
GETPOST(
'action',
'aZ09');
55 $dvid =
GETPOST(
'dvid',
'alpha');
56 $numref =
GETPOST(
'num',
'alpha');
58 $brref =
GETPOST(
'brref',
'alpha');
59 $oldbankreceipt =
GETPOST(
'oldbankreceipt',
'alpha');
60 $newbankreceipt =
GETPOST(
'newbankreceipt',
'alpha');
61 $rel =
GETPOST(
"rel",
'alphanohtml');
62 $backtopage =
GETPOST(
'backtopage',
'alpha');
65 $fieldid = (!empty($ref) ? $ref : $id);
66 $fieldname = (!empty($ref) ?
'ref' :
'rowid');
68 $socid = $user->socid;
71 $result =
restrictedArea($user,
'banque', $fieldid,
'bank_account',
'',
'', $fieldname);
73 if ($user->rights->banque->consolidate && $action ==
'dvnext' && !empty($dvid)) {
75 $al->datev_next($dvid);
78 if ($user->rights->banque->consolidate && $action ==
'dvprev' && !empty($dvid)) {
80 $al->datev_previous($dvid);
84 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
85 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
86 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
88 $pageplusone =
GETPOST(
"pageplusone",
'int');
90 $page = $pageplusone - 1;
92 if (empty($page) || $page == -1) {
95 $offset = $limit * $page;
96 $pageprev = $page - 1;
97 $pagenext = $page + 1;
102 $sortfield =
"s.nom";
106 if ($id > 0 || !empty($ref)) {
107 $result = $object->fetch($id, $ref);
108 $account = $object->id;
113 $contextpage =
'banktransactionlist'.(empty($object->ref) ?
'' :
'-'.$object->id);
118 if ($rel ==
'prev') {
120 $sql =
"SELECT DISTINCT(b.num_releve) as num";
121 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
122 $sql .=
" WHERE b.num_releve < '".$db->escape($numref).
"'";
123 $sql .=
" AND b.fk_account = ".((int) $object->id);
124 $sql .=
" ORDER BY b.num_releve DESC";
126 dol_syslog(
"htdocs/compta/bank/releve.php", LOG_DEBUG);
127 $resql = $db->query($sql);
129 $numrows = $db->num_rows(
$resql);
131 $obj = $db->fetch_object(
$resql);
136 } elseif ($rel ==
'next') {
138 $sql =
"SELECT DISTINCT(b.num_releve) as num";
139 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
140 $sql .=
" WHERE b.num_releve > '".$db->escape($numref).
"'";
141 $sql .=
" AND b.fk_account = ".((int) $object->id);
142 $sql .=
" ORDER BY b.num_releve ASC";
144 dol_syslog(
"htdocs/compta/bank/releve.php", LOG_DEBUG);
145 $resql = $db->query($sql);
147 $numrows = $db->num_rows(
$resql);
149 $obj = $db->fetch_object(
$resql);
160 $sql =
"SELECT b.rowid, b.dateo as do, b.datev as dv,";
161 $sql .=
" b.amount, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type,";
162 $sql .=
" b.fk_bordereau,";
164 $sql .=
" ba.rowid as bankid, ba.ref as bankref, ba.label as banklabel";
165 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank_account as ba";
166 $sql .=
", ".MAIN_DB_PREFIX.
"bank as b";
167 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'bordereau_cheque as bc ON bc.rowid=b.fk_bordereau';
168 $sql .=
" WHERE b.num_releve='".$db->escape($numref).
"'";
169 if (empty($numref)) {
170 $sql .=
" OR b.num_releve is null";
172 $sql .=
" AND b.fk_account = ".((int) $object->id);
173 $sql .=
" AND b.fk_account = ba.rowid";
174 $sql .= $db->order(
"b.datev, b.datec",
"ASC");
176 $sqlrequestforbankline = $sql;
184 if ($action ==
'confirm_editbankreceipt' && !empty($oldbankreceipt) && !empty($newbankreceipt)) {
186 $sqlupdate =
"UPDATE ".MAIN_DB_PREFIX.
"bank SET num_releve = '".$db->escape($newbankreceipt).
"'";
187 $sqlupdate .=
" WHERE num_releve = '".$db->escape($oldbankreceipt).
"' AND fk_account = ".((int) $id);
188 $result = $db->query($sqlupdate);
201 $title = $langs->trans(
"FinancialAccount").
' - '.$langs->trans(
"AccountStatements");
206 $societestatic =
new Societe($db);
211 $paymentvatstatic =
new Tva($db);
212 $bankstatic =
new Account($db);
221 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
222 $param .=
'&contextpage='.$contextpage;
224 if ($limit > 0 && $limit != $conf->liste_limit) {
225 $param .=
'&limit='.$limit;
228 $param .=
'&id='.urlencode($id);
232 if (empty($numref)) {
237 $sql =
"SELECT DISTINCT(b.num_releve) as numr";
238 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
239 $sql .=
" WHERE b.fk_account = ".((int) $object->id);
240 $sql .= $db->order($sortfield, $sortorder);
244 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
245 $result = $db->query($sql);
246 $totalnboflines = $db->num_rows($result);
249 $sql .= $db->plimit($conf->liste_limit + 1, $offset);
251 $result = $db->query($sql);
253 $numrows = $db->num_rows($result);
258 print
dol_get_fiche_head($head,
'statement', $langs->trans(
"FinancialAccount"), 0,
'account');
260 $linkback =
'<a href="'.DOL_URL_ROOT.
'/compta/bank/list.php?restore_lastsearch_values=1">'.$langs->trans(
"BackToList").
'</a>';
264 dol_banner_tab($object,
'ref', $linkback, 1,
'ref',
'ref', $morehtmlref,
'', 0,
'',
'', 1);
269 print
'<div class="tabsAction">';
271 if ($object->canBeConciliated() > 0) {
272 $allowautomaticconciliation =
false;
273 $titletoconciliatemanual = $langs->trans(
"Conciliate");
274 $titletoconciliateauto = $langs->trans(
"Conciliate");
275 if ($allowautomaticconciliation) {
276 $titletoconciliatemanual .=
' ('.$langs->trans(
"Manual").
')';
277 $titletoconciliateauto .=
' ('.$langs->trans(
"Auto").
')';
281 if ($user->rights->banque->consolidate) {
282 $buttonreconcile =
'<a class="butAction" href="'.DOL_URL_ROOT.
'/compta/bank/bankentries_list.php?action=reconcile&sortfield=b.datev,b.dateo,b.rowid&sortorder=asc,asc,asc&search_conciliated=0&search_account='.$id.$param.
'">'.$titletoconciliatemanual.
'</a>';
284 $buttonreconcile =
'<a class="butActionRefused classfortooltip" title="'.$langs->trans(
"NotEnoughPermissions").
'" href="#">'.$titletoconciliatemanual.
'</a>';
288 if ($allowautomaticconciliation) {
290 if ($user->rights->banque->consolidate) {
292 $newparam = preg_replace(
'/search_conciliated=\d+/i',
'', $newparam);
293 $buttonreconcile .=
' <a class="butAction" style="margin-bottom: 5px !important; margin-top: 5px !important" href="'.DOL_URL_ROOT.
'/compta/bank/bankentries_list.php?action=reconcile&sortfield=b.datev,b.dateo,b.rowid&sortorder=asc,asc,asc&search_conciliated=0'.$newparam.
'">'.$titletoconciliateauto.
'</a>';
295 $buttonreconcile .=
' <a class="butActionRefused" style="margin-bottom: 5px !important; margin-top: 5px !important" title="'.$langs->trans(
"NotEnoughPermissions").
'" href="#">'.$titletoconciliateauto.
'</a>';
299 print $buttonreconcile;
305 print_barre_liste(
'', $page, $_SERVER[
"PHP_SELF"],
"&account=".$object->id, $sortfield, $sortorder,
'', $numrows, $totalnboflines,
'');
307 print
'<form name="aaa" action="'.$_SERVER[
"PHP_SELF"].
'" method="POST">';
308 print
'<input type="hidden" name="token" value="'.newToken().
'">';
309 print
'<input type="hidden" name="action" value="confirm_editbankreceipt">';
310 print
'<input type="hidden" name="backtopage" value="'.$backtopage.
'">';
311 print
'<input type="hidden" name="account" value="'.$object->id.
'">';
312 print
'<input type="hidden" name="page" value="'.$page.
'">';
314 print
'<table class="noborder centpercent">';
315 print
'<tr class="liste_titre">';
316 print
'<td>'.$langs->trans(
"Ref").
'</td>';
317 print
'<td class="right">'.$langs->trans(
"InitialBankBalance").
'</td>';
318 print
'<td class="right">'.$langs->trans(
"EndBankBalance").
'</td>';
322 $balancestart = array();
325 while ($i < min($numrows, $conf->liste_limit)) {
326 $objp = $db->fetch_object($result);
328 if (!isset($objp->numr)) {
331 print
'<tr class="oddeven">';
333 if ($action !=
'editbankreceipt' || $objp->numr != $brref) {
334 print
'<a href="releve.php?num='.$objp->numr.
'&account='.$object->id.
'">'.$objp->numr.
'</a>';
336 print
'<input type="hidden" name="oldbankreceipt" value="'.$objp->numr.
'">';
337 print
'<input type="text" name="newbankreceipt" value="'.$objp->numr.
'">';
338 print
'<input type="submit" class="button small" name="actionnewbankreceipt" value="'.$langs->trans(
"Rename").
'">';
339 print
'<input type="submit" class="button button-cancel small" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
344 $sql =
"SELECT sum(b.amount) as amount";
345 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
346 $sql .=
" WHERE b.num_releve < '".$db->escape($objp->numr).
"'";
347 $sql .=
" AND b.fk_account = ".((int) $object->id);
348 $resql = $db->query($sql);
350 $obj = $db->fetch_object(
$resql);
351 $balancestart[$objp->numr] = $obj->amount;
354 print
'<td class="right"><span class="amount">'.price($balancestart[$objp->numr],
'', $langs, 1, -1, -1, empty($object->currency_code)?$conf->currency:$object->currency_code).
'</span></td>';
357 $sql =
"SELECT sum(b.amount) as amount";
358 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
359 $sql .=
" WHERE b.num_releve = '".$db->escape($objp->numr).
"'";
360 $sql .=
" AND b.fk_account = ".((int) $object->id);
361 $resql = $db->query($sql);
363 $obj = $db->fetch_object(
$resql);
364 $content[$objp->numr] = $obj->amount;
367 print
'<td class="right"><span class="amount">'.price(($balancestart[$objp->numr] + $content[$objp->numr]),
'', $langs, 1, -1, -1, empty($object->currency_code)?$conf->currency:$object->currency_code).
'</span></td>';
369 print
'<td class="center">';
370 if ($user->rights->banque->consolidate && $action !=
'editbankreceipt') {
371 print
'<a class="editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?account='.$object->id.($page > 0 ?
'&page='.$page :
'').
'&action=editbankreceipt&token='.
newToken().
'&brref='.urlencode($objp->numr).
'">'.
img_edit().
'</a>';
393 print
dol_get_fiche_head($head,
'statement', $langs->trans(
"AccountStatement"), -1,
'account');
397 $morehtmlright .=
'<div class="pagination"><ul>';
398 $morehtmlright .=
'<li class="pagination"><a class="paginationnext" href="'.$_SERVER[
"PHP_SELF"].
'?rel=prev&num='.$numref.
'&ve='.$ve.
'&account='.$object->id.
'"><i class="fa fa-chevron-left" title="'.
dol_escape_htmltag($langs->trans(
"Previous")).
'"></i></a></li>';
399 $morehtmlright .=
'<li class="pagination"><span class="active">'.$langs->trans(
"AccountStatement").
" ".$numref.
'</span></li>';
400 $morehtmlright .=
'<li class="pagination"><a class="paginationnext" href="'.$_SERVER[
"PHP_SELF"].
'?rel=next&num='.$numref.
'&ve='.$ve.
'&account='.$object->id.
'"><i class="fa fa-chevron-right" title="'.
dol_escape_htmltag($langs->trans(
"Next")).
'"></i></a></li>';
401 $morehtmlright .=
'</ul></div>';
403 $title = $langs->trans(
"AccountStatement").
' '.$numref.
' - '.$langs->trans(
"BankAccount").
' '.$object->getNomUrl(1,
'receipts');
406 print
'<form method="POST" action="'.$_SERVER[
"PHP_SELF"].
'">';
407 print
'<input type="hidden" name="token" value="'.newToken().
'">';
408 print
'<input type="hidden" name="action" value="add">';
410 print
'<div class="div-table-responsive">';
411 print
'<table class="noborder centpercent">';
412 print
'<tr class="liste_titre">';
413 print
'<td class="center">'.$langs->trans(
"DateOperationShort").
'</td>';
414 print
'<td class="center">'.$langs->trans(
"DateValueShort").
'</td>';
415 print
'<td>'.$langs->trans(
"Type").
'</td>';
416 print
'<td>'.$langs->trans(
"Description").
'</td>';
417 print
'<td class="right" width="60">'.$langs->trans(
"Debit").
'</td>';
418 print
'<td class="right" width="60">'.$langs->trans(
"Credit").
'</td>';
419 print
'<td class="right">'.$langs->trans(
"Balance").
'</td>';
420 print
'<td> </td>';
424 $sql =
"SELECT sum(b.amount) as amount";
425 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank as b";
426 $sql .=
" WHERE b.num_releve < '".$db->escape($numref).
"'";
427 $sql .=
" AND b.fk_account = ".((int) $object->id);
429 $resql = $db->query($sql);
431 $obj = $db->fetch_object(
$resql);
432 $total = $obj->amount;
437 $sql = $sqlrequestforbankline;
439 $result = $db->query($sql);
441 $numrows = $db->num_rows($result);
445 print
'<tr class="oddeven"><td colspan="3"></td>';
446 print
'<td colspan="3"><b>'.$langs->trans(
"InitialBankBalance").
" :</b></td>";
447 print
'<td class="right"><b>'.price($total).
'</b></td><td> </td>';
450 while ($i < $numrows) {
451 $objp = $db->fetch_object($result);
452 $total = $total + $objp->amount;
454 print
'<tr class="oddeven">';
457 print
'<td class="nowrap center">'.dol_print_date($db->jdate($objp->do),
"day").
'</td>';
460 print
'<td valign="center" class="center nowrap">';
461 print
'<span class="spanforajaxedit">'.dol_print_date($db->jdate($objp->dv),
"day").
'</span>';
463 print
'<span class="inline-block">';
464 print
'<a class="ajaxforbankoperationchange reposition" href="'.$_SERVER[
'PHP_SELF'].
'?action=dvprev&num='.$numref.
'&account='.$object->id.
'&rowid='.$objp->rowid.
'&dvid='.$objp->rowid.
'">';
466 print
'<a class="ajaxforbankoperationchange reposition" href="'.$_SERVER[
'PHP_SELF'].
'?action=dvnext&num='.$numref.
'&account='.$object->id.
'&rowid='.$objp->rowid.
'&dvid='.$objp->rowid.
'">';
472 if ($objp->fk_type ==
'SOLD') {
473 $type_label =
' ';
475 $type_label = ($langs->trans(
"PaymentTypeShort".$objp->fk_type) !=
"PaymentTypeShort".$objp->fk_type) ? $langs->trans(
"PaymentTypeShort".$objp->fk_type) : $objp->fk_type;
478 if ($objp->fk_bordereau > 0) {
479 $remisestatic->id = $objp->fk_bordereau;
480 $remisestatic->ref = $objp->ref;
481 $link =
' '.$remisestatic->getNomUrl(1);
483 print
'<td class="nowrap">'.$type_label.
' '.($objp->num_chq ? $objp->num_chq :
'').$link.
'</td>';
486 print
'<td valign="center">';
487 print
'<a href="'.DOL_URL_ROOT.
'/compta/bank/line.php?rowid='.$objp->rowid.
'&account='.$object->id.
'">';
489 preg_match(
'/\((.+)\)/i', $objp->label, $reg);
490 if ($reg[1] && $langs->trans($reg[1]) != $reg[1]) {
491 print $langs->trans($reg[1]);
501 $links = $object->get_url($objp->rowid);
502 foreach ($links as $key => $val) {
508 if ($links[$key][
'type'] ==
'payment') {
509 $paymentstatic->id = $links[$key][
'url_id'];
510 $paymentstatic->ref = $langs->trans(
"Payment");
511 print
' '.$paymentstatic->getNomUrl(1);
513 } elseif ($links[$key][
'type'] ==
'payment_supplier') {
514 $paymentsupplierstatic->id = $links[$key][
'url_id'];
515 $paymentsupplierstatic->ref = $langs->trans(
"Payment");
516 print
' '.$paymentsupplierstatic->getNomUrl(1);
518 } elseif ($links[$key][
'type'] ==
'payment_sc') {
519 print
'<a href="'.DOL_URL_ROOT.
'/compta/payment_sc/card.php?id='.$links[$key][
'url_id'].
'">';
520 print
' '.img_object($langs->trans(
'ShowPayment'),
'payment').
' ';
521 print $langs->trans(
"SocialContributionPayment");
524 } elseif ($links[$key][
'type'] ==
'payment_vat') {
525 $paymentvatstatic->id = $links[$key][
'url_id'];
526 $paymentvatstatic->ref = $langs->trans(
"Payment");
527 print
' '.$paymentvatstatic->getNomUrl(1);
528 } elseif ($links[$key][
'type'] ==
'payment_salary') {
529 print
'<a href="'.DOL_URL_ROOT.
'/salaries/card.php?id='.$links[$key][
'url_id'].
'">';
530 print
' '.img_object($langs->trans(
'ShowPayment'),
'payment').
' ';
531 print $langs->trans(
"Payment");
534 } elseif ($links[$key][
'type'] ==
'payment_donation') {
535 $paymentdonationstatic->id = $links[$key][
'url_id'];
536 $paymentdonationstatic->ref = $langs->trans(
"Payment");
537 print
' '.$paymentdonationstatic->getNomUrl(1);
539 } elseif ($links[$key][
'type'] ==
'payment_loan') {
540 $paymentloanstatic->id = $links[$key][
'url_id'];
541 $paymentloanstatic->ref = $langs->trans(
"Payment");
542 print
' '.$paymentloanstatic->getNomUrl(1);
544 } elseif ($links[$key][
'type'] ==
'payment_various') {
545 $paymentvariousstatic->id = $links[$key][
'url_id'];
546 $paymentvariousstatic->ref = $langs->trans(
"Payment");
547 print
' '.$paymentvariousstatic->getNomUrl(1);
549 } elseif ($links[$key][
'type'] ==
'banktransfert') {
551 if ($objp->amount > 0) {
552 $banklinestatic->fetch($links[$key][
'url_id']);
553 $bankstatic->id = $banklinestatic->fk_account;
554 $bankstatic->label = $banklinestatic->bank_account_label;
555 print
' ('.$langs->trans(
"from").
' ';
556 print $bankstatic->getNomUrl(1,
'transactions');
557 print
' '.$langs->trans(
"toward").
' ';
558 $bankstatic->id = $objp->bankid;
559 $bankstatic->label = $objp->bankref;
560 print $bankstatic->getNomUrl(1,
'');
563 $bankstatic->id = $objp->bankid;
564 $bankstatic->label = $objp->bankref;
565 print
' ('.$langs->trans(
"from").
' ';
566 print $bankstatic->getNomUrl(1,
'');
567 print
' '.$langs->trans(
"toward").
' ';
568 $banklinestatic->fetch($links[$key][
'url_id']);
569 $bankstatic->id = $banklinestatic->fk_account;
570 $bankstatic->label = $banklinestatic->bank_account_label;
571 print $bankstatic->getNomUrl(1,
'transactions');
574 } elseif ($links[$key][
'type'] ==
'company') {
575 $societestatic->id = $links[$key][
'url_id'];
576 $societestatic->name = $links[$key][
'label'];
577 print $societestatic->getNomUrl(1,
'company', 24);
579 } elseif ($links[$key][
'type'] ==
'member') {
580 print
'<a href="'.DOL_URL_ROOT.
'/adherents/card.php?rowid='.$links[$key][
'url_id'].
'">';
581 print
img_object($langs->trans(
'ShowMember'),
'user').
' ';
582 print $links[$key][
'label'];
585 } elseif ($links[$key][
'type'] ==
'user') {
586 print
'<a href="'.DOL_URL_ROOT.
'/user/card.php?id='.$links[$key][
'url_id'].
'">';
587 print
img_object($langs->trans(
'ShowUser'),
'user').
' ';
588 print $links[$key][
'label'];
591 } elseif ($links[$key][
'type'] ==
'sc') {
592 print
'<a href="'.DOL_URL_ROOT.
'/compta/sociales/card.php?id='.$links[$key][
'url_id'].
'">';
593 print
img_object($langs->trans(
'ShowBill'),
'bill').
' ';
594 print $langs->trans(
"SocialContribution");
598 print
'<a href="'.$links[$key][
'url'].$links[$key][
'url_id'].
'">';
599 print $links[$key][
'label'];
607 $sql =
"SELECT label";
608 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bank_categ as ct";
609 $sql .=
", ".MAIN_DB_PREFIX.
"bank_class as cl";
610 $sql .=
" WHERE ct.rowid = cl.fk_categ";
611 $sql .=
" AND ct.entity = ".((int) $conf->entity);
612 $sql .=
" AND cl.lineid = ".((int) $objp->rowid);
614 $resc = $db->query($sql);
616 $numc = $db->num_rows($resc);
618 if ($numc && !$newline) {
621 while ($ii < $numc) {
622 $objc = $db->fetch_object($resc);
623 print
"<br>- <i>".$objc->label.
"</i>";
633 if ($objp->amount < 0) {
634 $totald = $totald + abs($objp->amount);
635 print
'<td class="nowrap right">'.price($objp->amount * -1).
"</td><td> </td>\n";
637 $totalc = $totalc + abs($objp->amount);
638 print
'<td> </td><td class="nowrap right">'.price($objp->amount).
"</td>\n";
641 print
'<td class="nowrap right">'.price(
price2num($total,
'MT')).
"</td>\n";
643 if ($user->rights->banque->modifier || $user->rights->banque->consolidate) {
644 print
'<td class="center"><a class="editfielda reposition" href="'.DOL_URL_ROOT.
'/compta/bank/line.php?rowid='.$objp->rowid.
'&account='.$object->id.
'&backtopage='.urlencode($_SERVER[
"PHP_SELF"].
'?account='.$object->id.
'&num='.$numref).
'">';
648 print
"<td class=\"center\"> </td>";
657 print
"\n".
'<tr class="liste_total"><td class="right" colspan="4">'.$langs->trans(
"Total").
" :</td><td class=\"right\">".
price($totald).
"</td><td class=\"right\">".
price($totalc).
"</td><td> </td><td> </td></tr>";
661 print
"<td class=\"right\" colspan=\"3\"> </td><td colspan=\"3\"><b>".$langs->trans(
"EndBankBalance").
" :</b></td>";
662 print
'<td class="right"><b>'.price(
price2num($total,
'MT')).
"</b></td><td> </td>";
667 $urlajax = DOL_URL_ROOT.
'/core/ajax/bankconciliate.php?token='.
currentToken();
669 <script type="text/javascript">
671 $("a.ajaxforbankoperationchange").each(function(){
672 var current = $(this);
673 current.click(function()
675 console.log("We click on ajaxforbankoperationchange");
676 var url = "'.$urlajax.
'&"+current.attr("href").split("?")[1];
677 $.get(url, function(data)
681 current.parent().parent().find(".spanforajaxedit").replaceWith(data);