dolibarr 25.0.0-alpha
line.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2001-2006 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2003 Xavier DUTOIT <doli@sydesy.com>
4 * Copyright (C) 2004-2017 Laurent Destailleur <eldy@users.sourceforge.net>
5 * Copyright (C) 2004 Christophe Combelles <ccomb@free.fr>
6 * Copyright (C) 2005-2012 Regis Houssin <regis.houssin@inodbox.com>
7 * Copyright (C) 2015-2026 Alexandre Spangaro <alexandre@inovea-conseil.com>
8 * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
9 * Copyright (C) 2016 Marcos García <marcosgdf@gmail.com>
10 * Copyright (C) 2018-2026 Frédéric France <frederic.france@free.fr>
11 * Copyright (C) 2021 Gauthier VERDOL <gauthier.verdol@atm-consulting.fr>
12 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
13 *
14 * This program is free software; you can redistribute it and/or modify
15 * it under the terms of the GNU General Public License as published by
16 * the Free Software Foundation; either version 3 of the License, or
17 * (at your option) any later version.
18 *
19 * This program is distributed in the hope that it will be useful,
20 * but WITHOUT ANY WARRANTY; without even the implied warranty of
21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
22 * GNU General Public License for more details.
23 *
24 * You should have received a copy of the GNU General Public License
25 * along with this program. If not, see <https://www.gnu.org/licenses/>.
26 */
27
34// Load Dolibarr environment
35require '../../main.inc.php';
44require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
45require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
46require_once DOL_DOCUMENT_ROOT.'/core/lib/payments.lib.php';
47require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php';
48require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
49
50// Load translation files required by the page
51$langs->loadLangs(array('banks', 'categories', 'compta', 'bills', 'other'));
52if (isModEnabled('member')) {
53 $langs->load("members");
54}
55if (isModEnabled('don')) {
56 $langs->load("donations");
57}
58if (isModEnabled('loan')) {
59 $langs->load("loan");
60}
61if (isModEnabled('salaries')) {
62 $langs->load("salaries");
63}
64
65
66$id = GETPOSTINT('rowid');
67$rowid = GETPOSTINT('rowid');
68$accountoldid = GETPOSTINT('account'); // GETPOST('account') is old account id
69$accountid = GETPOSTINT('accountid'); // GETPOST('accountid') is new account id
70$ref = GETPOST('ref', 'alpha');
71$action = GETPOST('action', 'aZ09');
72$confirm = GETPOST('confirm', 'alpha');
73$orig_account = GETPOST("orig_account");
74$backtopage = GETPOST('backtopage', 'alpha');
75$cancel = GETPOST('cancel', 'alpha');
76
77// Security check
78$fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref : ''));
79$fieldtype = (!empty($ref) ? 'ref' : 'rowid');
80$socid = 0;
81if ($user->socid) {
82 $socid = $user->socid;
83}
84
85// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
86$hookmanager->initHooks(array('bankline'));
87
88$result = restrictedArea($user, 'banque', $accountoldid, 'bank_account');
89if (!$user->hasRight('banque', 'lire') && !$user->hasRight('banque', 'consolidate')) {
91}
92
93$object = new AccountLine($db);
94$extrafields->fetch_name_optionals_label($object->element);
95
96if ($id > 0) {
97 $result = $object->fetch($id);
98 if ($result <= 0) {
99 dol_syslog('Failed to read bank line with id '.$rowid, LOG_WARNING); // This happens due to old bug that has set fk_account to null.
100 $object->id = $id;
101 }
102}
103
104
105/*
106 * Actions
107 */
108
109$error = 0;
110
111$parameters = array('socid' => $socid);
112$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
113if ($reshook < 0) {
114 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
115}
116if ($cancel) {
117 if ($backtopage) {
118 header("Location: ".$backtopage);
119 exit;
120 }
121}
122
123
124if ($user->hasRight('banque', 'consolidate') && $action == 'donext') {
125 $al = new AccountLine($db);
126 $al->dateo_next(GETPOSTINT("rowid"));
127} elseif ($user->hasRight('banque', 'consolidate') && $action == 'doprev') {
128 $al = new AccountLine($db);
129 $al->dateo_previous(GETPOSTINT("rowid"));
130} elseif ($user->hasRight('banque', 'consolidate') && $action == 'dvnext') {
131 $al = new AccountLine($db);
132 $al->datev_next(GETPOSTINT("rowid"));
133} elseif ($user->hasRight('banque', 'consolidate') && $action == 'dvprev') {
134 $al = new AccountLine($db);
135 $al->datev_previous(GETPOSTINT("rowid"));
136}
137
138if ($action == 'confirm_delete_categ' && $confirm == "yes" && $user->hasRight('banque', 'modifier')) {
139 $cat1 = GETPOSTINT("cat1");
140 if (!empty($rowid) && !empty($cat1)) {
141 $sql = "DELETE FROM ".MAIN_DB_PREFIX."category_bankline WHERE lineid = ".((int) $rowid)." AND fk_categ = ".((int) $cat1);
142 if (!$db->query($sql)) {
143 dol_print_error($db);
144 }
145 } else {
146 setEventMessages($langs->trans("MissingIds"), null, 'errors');
147 }
148}
149
150if ($user->hasRight('banque', 'modifier') && $action == "update") {
151 $acsource = new Account($db);
152 $acsource->fetch($accountoldid);
153
154 $actarget = new Account($db);
155 if (GETPOSTINT('accountid') > 0 && !$object->rappro && !$object->getVentilExportCompta()) { // We ask to change bank account
156 $actarget->fetch(GETPOSTINT('accountid'));
157 } else {
158 $actarget->fetch($accountoldid);
159 }
160
161 if (!($actarget->id > 0)) {
162 setEventMessages($langs->trans("ErrorFailedToLoadBankAccount"), null, 'errors');
163 $error++;
164 }
165 if ($actarget->type == Account::TYPE_CASH && GETPOST('value', 'alpha') != 'LIQ') {
166 setEventMessages($langs->trans("ErrorCashAccountAcceptsOnlyCashMoney"), null, 'errors');
167 $error++;
168 }
169
170 if (!$error) {
171 $db->begin();
172
173 $amount = price2num(GETPOST('amount'));
174 $dateop = dol_mktime(12, 0, 0, GETPOSTINT("dateomonth"), GETPOSTINT("dateoday"), GETPOSTINT("dateoyear"));
175 $dateval = dol_mktime(12, 0, 0, GETPOSTINT("datevmonth"), GETPOSTINT("datevday"), GETPOSTINT("datevyear"));
176 $sql = "UPDATE ".MAIN_DB_PREFIX."bank";
177 $sql .= " SET ";
178 // Always opened
179 if (GETPOSTISSET('value')) {
180 $type = GETPOST('value');
181 $sql .= " fk_type='".$db->escape(empty($type) && $object->fk_type == 'SOLD' ? 'SOLD' : $type)."',";
182 }
183 if (GETPOSTISSET('num_chq')) {
184 $sql .= " num_chq='".$db->escape(GETPOST("num_chq"))."',";
185 }
186 if (GETPOSTISSET('banque')) {
187 $sql .= " banque='".$db->escape(GETPOST("banque"))."',";
188 }
189 if (GETPOSTISSET('emetteur')) {
190 $sql .= " emetteur='".$db->escape(GETPOST("emetteur"))."',";
191 }
192 // Blocked when conciliated
193 if (!$object->rappro) {
194 if (GETPOSTISSET('label')) {
195 $sql .= " label = '".$db->escape(GETPOST("label"))."',";
196 }
197 if (GETPOSTISSET('amount')) {
198 $sql .= " amount= '".$db->escape($amount)."',";
199 }
200 if (GETPOSTISSET('dateomonth')) {
201 $sql .= " dateo = '".$db->idate($dateop)."',";
202 }
203 if (GETPOSTISSET('datevmonth')) {
204 $sql .= " datev = '".$db->idate($dateval)."',";
205 }
206 }
207 $sql .= " fk_account = ".((int) $actarget->id);
208 $sql .= " WHERE rowid = ".((int) $object->id);
209
210 $result = $db->query($sql);
211 if (!$result) {
212 $error++;
213 }
214
215 if (!$error) {
216 $arrayofcategs = GETPOST('custcats', 'array');
217 $sql = "DELETE FROM ".MAIN_DB_PREFIX."category_bankline WHERE lineid = ".((int) $rowid);
218 if (!$db->query($sql)) {
219 $error++;
220 dol_print_error($db);
221 }
222 if (count($arrayofcategs)) {
223 foreach ($arrayofcategs as $val) {
224 $sql = "INSERT INTO ".MAIN_DB_PREFIX."category_bankline (lineid, fk_categ) VALUES (".((int) $rowid).", ".((int) $val).")";
225 if (!$db->query($sql)) {
226 $error++;
227 dol_print_error($db);
228 }
229 }
230 // $arrayselected will be loaded after in page output
231 }
232 }
233
234 if (!$error) {
235 $extrafields->setOptionalsFromPost(null, $object, '@GETPOSTISSET');
236 $object->insertExtraFields();
237 }
238
239 if (!$error) {
240 $result = $object->call_trigger('BANKACCOUNTLINE_MODIFY', $user);
241 if ($result < 0) {
242 $error++;
243 }
244 }
245
246 if (!$error) {
247 setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
248 $db->commit();
249 } else {
250 $db->rollback();
251 dol_print_error($db);
252 }
253 }
254}
255
256// Reconcile
257if ($user->hasRight('banque', 'consolidate') && ($action == 'num_releve' || $action == 'setreconcile')) {
258 $num_rel = trim(GETPOST("num_rel"));
259 $rappro = GETPOST('reconciled') ? 1 : 0;
260
261 // Check parameters
262 if ($rappro && empty($num_rel)) {
263 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("AccountStatement")), null, 'errors');
264 $error++;
265 }
266
267 if (!$error) {
268 $db->begin();
269
270 $oldNum_rel = $object->num_releve;
271 $id = $object->fk_account;
272
273 $sql = "UPDATE ".MAIN_DB_PREFIX."bank";
274 $sql .= " SET num_releve = ".($num_rel ? "'".$db->escape($num_rel)."'" : "null");
275 if (empty($num_rel)) {
276 $sql .= ", rappro = 0";
277 } else {
278 $sql .= ", rappro = ".((int) $rappro);
279 }
280 $sql .= " WHERE rowid = ".((int) $rowid);
281
282 $updatePathFile = true;
283 $update_dir = true;
284
285 dol_syslog("line.php update bank line to set the new bank receipt number", LOG_DEBUG);
286
287 $result = $db->query($sql);
288
289 if ($result) {
290 $object->num_releve = $num_rel;
291 $object->rappro = (empty($num_rel) ? 0 : $rappro);
292
293 // Call trigger
294 $triggerres = $object->call_trigger('BANKACCOUNTLINE_MODIFY', $user);
295 if ($triggerres < 0) {
296 $result = false;
297 }
298 // End call triggers
299 }
300
301 // We must not rename the directory of the bank receipt when we change 1 line of bank receipt. Other lines may share the same old ref.
302 // Renaming can be done when we rename globally a bank receipt but not when changing 1 line from one receipt into another one.
303 $filepath = '';
304 $oldfilepath = '';
305 /*
306 if ($result) {
307 if ($oldNum_rel) {
308 if ($num_rel) {
309 $oldfilepath = dol_sanitizePathName("bank/".((int) $id)."/statement/".$oldNum_rel);
310 $filepath = dol_sanitizePathName("bank/".((int) $id)."/statement/".$num_rel);
311
312 $sql = "UPDATE ".MAIN_DB_PREFIX."ecm_files";
313 $sql .= " SET filepath = '".$db->escape($filepath)."'";
314 $sql .= " WHERE filepath = '".$db->escape($oldfilepath)."'";
315 $updatePathFile = $db->query($sql);
316
317 $srcdir = dol_sanitizePathName(DOL_DATA_ROOT."/bank/".((int) $id)."/statement/".$oldNum_rel);
318 $destdir = dol_sanitizePathName(DOL_DATA_ROOT."/bank/".((int) $id)."/statement/".$num_rel);
319
320 if (dol_is_dir($srcdir)) {
321 $update_dir = dol_move_dir($srcdir, $destdir, 1);
322 }
323 }
324 }
325 }
326 */
327
328 if ($result && $updatePathFile && $update_dir) {
329 setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
330 $db->commit();
331 } else {
332 $langs->load("errors");
333 setEventMessages($langs->trans("ErrorFailToRenameDir", $oldfilepath, $filepath), null, 'mesgs');
334 $db->rollback();
335 }
336 }
337}
338
339
340
341/*
342 * View
343 */
344
345$object->fetch($rowid);
346
347$form = new Form($db);
348
349llxHeader('', $langs->trans("BankTransaction"));
350
351$arrayselected = array();
352
353$c = new Categorie($db);
354$cats = $c->containing($rowid, Categorie::TYPE_BANK_LINE);
355if (is_array($cats)) {
356 foreach ($cats as $cat) {
357 $arrayselected[] = $cat->id;
358 }
359}
360
361$head = bankline_prepare_head($rowid);
362
363
364$sql = "SELECT b.rowid, b.dateo as do, b.datev as dv, b.amount, b.label, b.rappro,";
365$sql .= " b.num_releve, b.fk_user_author, b.num_chq, b.fk_type, b.fk_account, b.fk_bordereau as receiptid,";
366$sql .= " b.emetteur,b.banque";
367$sql .= " FROM ".MAIN_DB_PREFIX."bank as b";
368$sql .= " WHERE rowid=".((int) $rowid);
369$sql .= " ORDER BY dateo ASC";
370$result = $db->query($sql);
371if ($result) {
372 $i = 0;
373 $total = 0;
374 if ($db->num_rows($result)) {
375 $objp = $db->fetch_object($result);
376
377 $total += $objp->amount;
378
379 $acct = new Account($db);
380 $acct->fetch($objp->fk_account);
381 $account = $acct->id;
382
383 $bankline = new AccountLine($db);
384 $bankline->fetch($rowid, $ref);
385
386 $links = $acct->get_url($rowid);
387 $bankline->load_previous_next_ref('', 'rowid');
388
389 // Confirmations
390 if ($action == 'delete_categ') {
391 print $form->formconfirm($_SERVER['PHP_SELF']."?rowid=".urlencode((string) ($rowid))."&cat1=".urlencode((string) (GETPOSTINT("fk_categ")))."&orig_account=".urlencode((string) ($orig_account)), $langs->trans("RemoveFromRubrique"), $langs->trans("RemoveFromRubriqueConfirm"), "confirm_delete_categ", '', 'yes', 1);
392 }
393
394 print '<form name="update" method="POST" action="'.$_SERVER['PHP_SELF'].'?rowid='.$rowid.'">';
395 print '<input type="hidden" name="token" value="'.newToken().'">';
396 print '<input type="hidden" name="action" value="update">';
397 print '<input type="hidden" name="orig_account" value="'.$orig_account.'">';
398 print '<input type="hidden" name="account" value="'.$acct->id.'">';
399
400 print dol_get_fiche_head($head, 'bankline', $langs->trans('LineRecord'), 0, 'accountline', 0);
401
402 $linkback = '<a href="'.DOL_URL_ROOT.'/compta/bank/bankentries_list.php?restore_lastsearch_values=1'.(GETPOSTINT('account', 1) ? '&id='.GETPOSTINT('account', 1) : '').'">'.$langs->trans("BackToList").'</a>';
403
404
405 dol_banner_tab($bankline, 'rowid', $linkback);
406
407 print '<div class="fichecenter2">';
408
409 print '<div class="underbanner clearboth"></div>';
410 print '<table class="border centpercent tableforfield">';
411
412 $i++;
413
414 // Bank account
415 print '<tr><td class="titlefieldcreate">'.$langs->trans("BankAccount").'</td>';
416 print '<td>';
417 // $objp->fk_account may be not > 0 if data was lost by an old bug. In such a case, we let a chance to user to fix it.
418 if (($objp->rappro || $bankline->getVentilExportCompta()) && $objp->fk_account > 0) {
419 print $acct->getNomUrl(1, 'transactions', 'reflabel');
420 } else {
421 print img_picto('', 'bank_account', 'class="paddingright"');
422 print $form->select_comptes($acct->id, 'accountid', 0, '', ($acct->id > 0 ? $acct->id : 1), '', 0, '', 1);
423 }
424 print '</td>';
425 print '</tr>';
426
427 // Show links of bank transactions
428 if (count($links)) {
429 print '<tr><td class="tdtop">'.$langs->trans("Links").'</td>';
430 print '<td>';
431 foreach ($links as $key => $val) {
432 if ($key) {
433 print '<br>';
434 }
435 if ($links[$key]['type'] == 'payment') {
436 require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php';
437 $paymenttmp = new Paiement($db);
438 $paymenttmp->fetch($links[$key]['url_id']);
439 $paymenttmp->ref = $langs->trans("Payment").' '.$paymenttmp->ref;
440 /*print '<a href="'.DOL_URL_ROOT.'/compta/paiement/card.php?id='.$links[$key]['url_id'].'">';
441 print img_object($langs->trans('Payment'),'payment').' ';
442 print $langs->trans("Payment");
443 print '</a>';*/
444 print $paymenttmp->getNomUrl(1);
445 } elseif ($links[$key]['type'] == 'payment_supplier') {
446 require_once DOL_DOCUMENT_ROOT.'/fourn/class/paiementfourn.class.php';
447 $paymenttmp = new PaiementFourn($db);
448 $paymenttmp->fetch($links[$key]['url_id']);
449 $paymenttmp->ref = $langs->trans("Payment").' '.$paymenttmp->ref;
450 /*print '<a href="'.DOL_URL_ROOT.'/fourn/paiement/card.php?id='.$links[$key]['url_id'].'">';
451 print img_object($langs->trans('Payment'),'payment').' ';
452 print $langs->trans("Payment");
453 print '</a>';*/
454 print $paymenttmp->getNomUrl(1);
455 } elseif ($links[$key]['type'] == 'company') {
456 $societe = new Societe($db);
457 $societe->fetch($links[$key]['url_id']);
458 print $societe->getNomUrl(1);
459 } elseif ($links[$key]['type'] == 'sc') {
460 print '<a href="'.DOL_URL_ROOT.'/compta/sociales/card.php?id='.$links[$key]['url_id'].'">';
461 print img_object($langs->trans('SocialContribution'), 'bill').' ';
462 print $langs->trans("SocialContribution").($links[$key]['label'] ? ' - '.$links[$key]['label'] : '');
463 print '</a>';
464 } elseif ($links[$key]['type'] == 'vat') {
465 print '<a href="'.DOL_URL_ROOT.'/compta/tva/card.php?id='.$links[$key]['url_id'].'">';
466 print img_object($langs->trans('VATDeclaration'), 'bill').' ';
467 print $langs->trans("VATDeclaration").($links[$key]['label'] ? '&nbsp;'.$links[$key]['label'] : '');
468 print '</a>';
469 } elseif ($links[$key]['type'] == 'salary') {
470 print '<a href="'.DOL_URL_ROOT.'/salaries/card.php?id='.$links[$key]['url_id'].'">';
471 print img_object($langs->trans('Salary'), 'bill').' ';
472 print $langs->trans("Salary").($links[$key]['label'] ? ' - '.$links[$key]['label'] : '');
473 print '</a>';
474 } elseif ($links[$key]['type'] == 'payment_sc') {
475 print '<a href="'.DOL_URL_ROOT.'/compta/payment_sc/card.php?id='.$links[$key]['url_id'].'">';
476 print img_object($langs->trans('Payment'), 'payment').' ';
477 print $langs->trans("SocialContributionPayment");
478 print '</a>';
479 } elseif ($links[$key]['type'] == 'payment_vat') {
480 print '<a href="'.DOL_URL_ROOT.'/compta/payment_vat/card.php?id='.$links[$key]['url_id'].'">';
481 print img_object($langs->trans('VATPayment'), 'payment').' ';
482 print $langs->trans("VATPayment");
483 print '</a>';
484 } elseif ($links[$key]['type'] == 'payment_salary') {
485 print '<a href="'.DOL_URL_ROOT.'/salaries/payment_salary/card.php?id='.$links[$key]['url_id'].'">';
486 print img_object($langs->trans('SalaryPayment'), 'payment').' ';
487 print $langs->trans("SalaryPayment");
488 print '</a>';
489 } elseif ($links[$key]['type'] == 'payment_loan') {
490 print '<a href="'.DOL_URL_ROOT.'/loan/payment/card.php?id='.$links[$key]['url_id'].'">';
491 print img_object($langs->trans('LoanPayment'), 'payment').' ';
492 print $langs->trans("LoanPayment");
493 print '</a>';
494 } elseif ($links[$key]['type'] == 'loan') {
495 print '<a href="'.DOL_URL_ROOT.'/loan/card.php?id='.$links[$key]['url_id'].'">';
496 print img_object($langs->trans('Loan'), 'bill').' ';
497 print $langs->trans("Loan");
498 print '</a>';
499 } elseif ($links[$key]['type'] == 'member') {
500 print '<a href="'.DOL_URL_ROOT.'/adherents/card.php?rowid='.$links[$key]['url_id'].'">';
501 print img_object($langs->trans('Member'), 'user').' ';
502 print $links[$key]['label'];
503 print '</a>';
504 } elseif ($links[$key]['type'] == 'payment_donation') {
505 print '<a href="'.DOL_URL_ROOT.'/don/payment/card.php?id='.$links[$key]['url_id'].'">';
506 print img_object($langs->trans('Donation'), 'payment').' ';
507 print $langs->trans("DonationPayment");
508 print '</a>';
509 } elseif ($links[$key]['type'] == 'banktransfert') { // transfer between 1 local account and another local account
510 print '<a href="'.DOL_URL_ROOT.'/compta/bank/line.php?rowid='.$links[$key]['url_id'].'">';
511 print img_object($langs->trans('Transaction'), 'payment').' ';
512 print $langs->trans("TransactionOnTheOtherAccount");
513 print '</a>';
514 } elseif ($links[$key]['type'] == 'user') {
515 print '<a href="'.DOL_URL_ROOT.'/user/card.php?id='.$links[$key]['url_id'].'">';
516 print img_object($langs->trans('User'), 'user').' ';
517 print $langs->trans("User");
518 print '</a>';
519 } elseif ($links[$key]['type'] == 'payment_various') {
520 require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/paymentvarious.class.php';
521 $paymenttmp = new PaymentVarious($db);
522 $paymenttmp->fetch($links[$key]['url_id']);
523 $paymenttmp->ref = $langs->trans("VariousPayment").' '.$paymenttmp->ref;
524 /*
525 print '<a href="'.DOL_URL_ROOT.'/compta/bank/various_payment/card.php?id='.$links[$key]['url_id'].'">';
526 print img_object($langs->trans('VariousPayment'), 'payment').' ';
527 print $langs->trans("VariousPayment");
528 print '</a>';
529 */
530 print $paymenttmp->getNomUrl(1);
531 } else {
532 // Example type = 'direct-debit', or 'credit-transfer', ....
533 print '<a href="'.$links[$key]['url'].$links[$key]['url_id'].'">';
534 print img_object('', 'generic').' ';
535 print $links[$key]['label'];
536 print '</a>';
537 }
538 }
539 print '</td></tr>';
540 }
541
542 // Type of payment / Number
543 print "<tr><td>".$langs->trans("Type")." / ".$langs->trans("Numero");
544 print ' <em>('.$langs->trans("ChequeOrTransferNumber").')</em>';
545 print "</td>";
546 if ($user->hasRight('banque', 'modifier') || $user->hasRight('banque', 'consolidate')) {
547 print '<td>';
548 $form->select_types_paiements($objp->fk_type, "value", '', 2);
549 print '<input type="text" class="flat" name="num_chq" value="'.(empty($objp->num_chq) ? '' : $objp->num_chq).'">';
550 if ($objp->receiptid) {
551 include_once DOL_DOCUMENT_ROOT.'/compta/paiement/cheque/class/remisecheque.class.php';
552 $receipt = new RemiseCheque($db);
553 $receipt->fetch($objp->receiptid);
554 print ' &nbsp; &nbsp; '.$langs->trans("CheckReceipt").': '.$receipt->getNomUrl(2);
555 }
556 print '</td>';
557 } else {
558 print '<td>'.$objp->fk_type.' '.dol_escape_htmltag($objp->num_chq).'</td>';
559 }
560 print "</tr>";
561
562 // Transmitter
563 print "<tr><td>".$langs->trans("CheckTransmitter");
564 print ' <em>('.$langs->trans("ChequeMaker").')</em>';
565 print "</td>";
566 if ($user->hasRight('banque', 'modifier') || $user->hasRight('banque', 'consolidate')) {
567 print '<td>';
568 print '<input type="text" class="flat minwidth200" name="emetteur" value="'.(empty($objp->emetteur) ? '' : dol_escape_htmltag($objp->emetteur)).'">';
569 print '</td>';
570 } else {
571 print '<td>'.$objp->emetteur.'</td>';
572 }
573 print "</tr>";
574
575 // Bank of cheque
576 print "<tr><td>".$langs->trans("Bank");
577 print ' <em>('.$langs->trans("ChequeBank").')</em>';
578 print "</td>";
579 if ($user->hasRight('banque', 'modifier') || $user->hasRight('banque', 'consolidate')) {
580 print '<td>';
581 print '<input type="text" class="flat minwidth200" name="banque" value="'.(empty($objp->banque) ? '' : dol_escape_htmltag($objp->banque)).'">';
582 print '</td>';
583 } else {
584 print '<td>'.dol_escape_htmltag($objp->banque).'</td>';
585 }
586 print "</tr>";
587
588 // Date ope
589 print '<tr><td>'.$langs->trans("DateOperation").'</td>';
590 if ($user->hasRight('banque', 'modifier') || $user->hasRight('banque', 'consolidate')) {
591 print '<td>';
592 print $form->selectDate($db->jdate($objp->do), 'dateo', 0, 0, 0, 'update', 1, 0, $objp->rappro);
593 if (!$objp->rappro) {
594 print ' &nbsp; ';
595 print '<a class="ajaxforbankoperationchange" href="'.$_SERVER['PHP_SELF'].'?action=doprev&id='.$objp->fk_account.'&rowid='.$objp->rowid.'&token='.newToken().'">';
596 print img_edit_remove()."</a> ";
597 print '<a class="ajaxforbankoperationchange" href="'.$_SERVER['PHP_SELF'].'?action=donext&id='.$objp->fk_account.'&rowid='.$objp->rowid.'&token='.newToken().'">';
598 print img_edit_add()."</a>";
599 }
600 print '</td>';
601 } else {
602 print '<td>';
603 print dol_print_date($db->jdate($objp->do), "day");
604 print '</td>';
605 }
606 print '</tr>';
607
608 // Value date
609 print "<tr><td>".$langs->trans("DateValue")."</td>";
610 if ($user->hasRight('banque', 'modifier') || $user->hasRight('banque', 'consolidate')) {
611 print '<td>';
612 print $form->selectDate($db->jdate($objp->dv), 'datev', 0, 0, 0, 'update', 1, 0, $objp->rappro);
613 if (!$objp->rappro) {
614 print ' &nbsp; ';
615 print '<a class="ajaxforbankoperationchange" href="'.$_SERVER['PHP_SELF'].'?action=dvprev&id='.$objp->fk_account.'&rowid='.$objp->rowid.'&token='.newToken().'">';
616 print img_edit_remove()."</a> ";
617 print '<a class="ajaxforbankoperationchange" href="'.$_SERVER['PHP_SELF'].'?action=dvnext&id='.$objp->fk_account.'&rowid='.$objp->rowid.'&token='.newToken().'">';
618 print img_edit_add()."</a>";
619 }
620 print '</td>';
621 } else {
622 print '<td>';
623 print dol_print_date($db->jdate($objp->dv), "day");
624 print '</td>';
625 }
626 print "</tr>";
627
628 // Description
629 $reg = array();
630 print "<tr><td>".$langs->trans("Label")."</td>";
631 if ($user->hasRight('banque', 'modifier') || $user->hasRight('banque', 'consolidate')) {
632 print '<td>';
633 print '<input name="label" class="flat minwidth300" '.($objp->rappro ? ' disabled' : '').' value="';
634 if (preg_match('/^\‍((.*)\‍)$/i', $objp->label, $reg)) {
635 // Generic label because it is in parentheses. We display it translated.
636 print $langs->trans($reg[1]);
637 } else {
638 print dol_escape_htmltag($objp->label);
639 }
640 print '">';
641 print '</td>';
642 } else {
643 print '<td>';
644 if (preg_match('/^\‍((.*)\‍)$/i', $objp->label, $reg)) {
645 // Generic label because it is in parentheses. We display it translated.
646 print $langs->trans($reg[1]);
647 } else {
648 print dol_escape_htmltag($objp->label);
649 }
650 print '</td>';
651 }
652 print '</tr>';
653
654 // Amount
655 print "<tr><td>".$langs->trans("Amount")."</td>";
656 if ($user->hasRight('banque', 'modifier')) {
657 print '<td>';
658 print '<input name="amount" class="flat maxwidth100" '.($objp->rappro ? ' disabled' : '').' value="'.price($objp->amount).'"> '.$langs->trans("Currency".$acct->currency_code);
659 print '</td>';
660 } else {
661 print '<td>';
662 print price($objp->amount);
663 print '</td>';
664 }
665 print "</tr>";
666
667 // Categories
668 if (isModEnabled('category') && $user->hasRight('categorie', 'lire')) {
669 $langs->load('categories');
670
671 // Bank line
672 print '<tr><td class="toptd">'.$form->editfieldkey('RubriquesTransactions', 'custcats', '', $object, 0).'</td><td>';
673 print $form->selectCategories(Categorie::TYPE_BANK_LINE, 'custcats', $object);
674 print "</td></tr>";
675 }
676
677 // Other attributes
678 $parameters = array();
679 $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $bankline, $action); // Note that $action and $object may have been modified by hook
680 print $hookmanager->resPrint;
681 if (empty($reshook)) {
682 print $bankline->showOptionals($extrafields, ($objp->rappro ? 'view' : 'create'), $parameters);
683 }
684 print "</table>";
685
686 // Code to adjust value date with plus and less picto using an Ajax call instead of a full reload of page
687 /* Not yet ready. We must manage inline replacement of input date field
688 $urlajax = DOL_URL_ROOT.'/core/ajax/bankconciliate.php?token='.currentToken();
689 print '
690 <script type="text/javascript">
691 $(function() {
692 $("a.ajaxforbankoperationchange").each(function(){
693 var current = $(this);
694 current.click(function()
695 {
696 var url = "'.$urlajax.'&"+current.attr("href").split("?")[1];
697 console.log("We click on ajaxforbankoperationchange url="+url);
698 $.get(url, function(data)
699 {
700 console.log(data);
701 current.parent().prev().replaceWith(data);
702 });
703 return false;
704 });
705 });
706 });
707 </script>
708 ';
709 */
710 print '</div>';
711
712 print dol_get_fiche_end();
713
714
715 print '<div class="center"><input type="submit" class="button" value="'.$langs->trans("Update").'"></div><br>';
716
717 print "</form>";
718
719
720
721 // Releve rappro
722 if ($acct->canBeConciliated() > 0) { // Si compte rapprochable
723 print load_fiche_titre($langs->trans("Reconciliation"), '', 'bank_account');
724 print '<hr>'."\n";
725
726 print '<form method="POST" action="'.$_SERVER['PHP_SELF'].'?rowid='.$objp->rowid.'">';
727 print '<input type="hidden" name="token" value="'.newToken().'">';
728 print '<input type="hidden" name="action" value="setreconcile">';
729 print '<input type="hidden" name="orig_account" value="'.$orig_account.'">';
730 print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
731
732 print '<div class="fichecenter">';
733
734 print '<table class="border centpercent">';
735
736 print '<tr><td class="titlefieldcreate">'.$form->textwithpicto($langs->trans("AccountStatement"), $langs->trans("InputReceiptNumber"))."</td>";
737 if ($user->hasRight('banque', 'consolidate')) {
738 print '<td>';
739 if ($objp->rappro) {
740 print '<input name="num_rel_bis" id="num_rel_bis" class="flat" type="text" value="'.$objp->num_releve.'"'.($objp->rappro ? ' disabled' : '').'>';
741 print '<input name="num_rel" id="num_rel" class="flat" type="hidden" value="'.$objp->num_releve.'">';
742 } else {
743 print '<input name="num_rel" id="num_rel" class="flat" value="'.$objp->num_releve.'"'.($objp->rappro ? ' disabled' : '').'>';
744 }
745 if ($objp->num_releve) {
746 print ' &nbsp; <a href="'.DOL_URL_ROOT.'/compta/bank/releve.php?num='.$objp->num_releve.'&account='.$acct->id.'">('.$langs->trans("AccountStatement").' '.$objp->num_releve.')</a>';
747 }
748 print '</td>';
749 } else {
750 print '<td>'.$objp->num_releve.'</td>';
751 }
752 print '</tr>';
753
754 print '<tr><td><label for="reconciled">'.$langs->trans("BankLineConciliated").'</label></td>';
755 if ($user->hasRight('banque', 'consolidate')) {
756 print '<td>';
757 print '<input type="checkbox" id="reconciled" name="reconciled" class="flat" '.(GETPOSTISSET("reconciled") ? (GETPOST("reconciled") ? ' checked="checked"' : '') : ($objp->rappro ? ' checked="checked"' : '')).'">';
758
759 print '
760 <script type="text/javascript">
761 jQuery(document).ready(function() {
762 $("#reconciled").click(function(){
763 console.log("We click on checkbox reconciled "+$("#reconciled").prop("checked"));
764 if ($("#reconciled").prop("checked") == false) {
765 console.log("we remove disabled");
766 jQuery("#num_rel_bis").removeAttr("disabled");
767 jQuery("#num_rel").removeAttr("disabled");
768 jQuery("#num_rel_bis").attr("type", "hidden");
769 jQuery("#num_rel").attr("type", "text");
770 jQuery("#num_rel_bis").hide();
771 jQuery("#num_rel").show();
772 } else {
773
774 }
775 });
776 });
777 </script>
778 ';
779
780 print '</td>';
781 } else {
782 print '<td>'.yn($objp->rappro).'</td>';
783 }
784 print '</tr>';
785 print '</table>';
786
787 print '</div>';
788
789 print '<div class="center">';
790
791 print '<input type="submit" class="button" value="'.$langs->trans("Update").'">';
792 if ($backtopage) {
793 print ' &nbsp; ';
794 print '<input type="submit" name="cancel" class="button button-cancel" value="'.$langs->trans("Cancel").'">';
795 }
796 print '</div>';
797
798 print '</form>';
799 }
800 }
801
802 $db->free($result);
803} else {
804 dol_print_error($db);
805}
806
807// End of page
808llxFooter();
809$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:47
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
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
$c
Definition line.php:353
Class to manage bank accounts.
const TYPE_CASH
Cash account.
Class to manage bank transaction lines.
Class to manage categories.
Class to manage generation of HTML components Only common components must be here.
Class to manage payments for supplier invoices.
Class to manage payments of customer invoices.
Class to manage various payments.
Class to manage cheque delivery receipts.
Class to manage third parties objects (customers, suppliers, prospects...)
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...
price2num($amount, $rounding='', $option=0, $currencycode='')
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.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
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).
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
isModEnabled($module)
Is Dolibarr module enabled.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
Definition html.lib.php:542
dol_get_fiche_end($notab=0)
Return tab footer of a card.
Definition html.lib.php:740
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='', $morecssonpicto='widthpictotitle')
Load a title with picto.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Definition html.lib.php:183
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.