33require
'../../main.inc.php';
42require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcategory.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/core/lib/bank.lib.php';
44require_once DOL_DOCUMENT_ROOT.
'/compta/tva/class/tva.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
48 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
51 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingjournal.class.php';
54 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
58$langs->loadLangs(array(
'banks',
'categories',
'accountancy',
'compta'));
60$action =
GETPOST(
'action',
'aZ09');
61$massaction =
GETPOST(
'massaction',
'alpha');
63$confirm =
GETPOST(
'confirm',
'alpha');
64$toselect =
GETPOST(
'toselect',
'array:int');
65$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'bankaccountlist';
68$search_ref =
GETPOST(
'search_ref',
'alpha');
69$search_label =
GETPOST(
'search_label',
'alpha');
70$search_number =
GETPOST(
'search_number',
'alpha');
71$search_status =
GETPOST(
'search_status',
'alpha');
72$optioncss =
GETPOST(
'optioncss',
'alpha');
74$search_category_list =
"";
76 $search_category_list =
GETPOST(
"search_category_".Categorie::TYPE_ACCOUNT.
"_list",
"array");
82 $socid = $user->socid;
85$diroutputmassaction =
$conf->bank->dir_output.
'/temp/massgeneration/'.$user->id;
88$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
89$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
91if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
95$offset = $limit * $page;
99 $sortfield =
'b.label';
108$hookmanager->initHooks(array(
'bankaccountlist'));
111$extrafields->fetch_name_optionals_label(
$object->table_element);
112$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
115$fieldstosearchall = array(
117 'b.label' =>
'Label',
120$checkedtypetiers = 0;
122 'b.ref' => array(
'label' => $langs->trans(
"BankAccounts"),
'checked' =>
'1',
'position' => 10),
123 'b.label' => array(
'label' => $langs->trans(
"Label"),
'checked' =>
'1',
'position' => 12),
124 'accountype' => array(
'label' => $langs->trans(
"Type"),
'checked' =>
'1',
'position' => 14),
125 'b.number' => array(
'label' => $langs->trans(
"AccountIdShort"),
'checked' =>
'1',
'position' => 16),
126 'b.account_number' => array(
'label' => $langs->trans(
"AccountAccounting"),
'checked' => (
string) (
int) (
isModEnabled(
'accounting')),
'position' => 18),
127 'b.fk_accountancy_journal' => array(
'label' => $langs->trans(
"AccountancyJournal"),
'checked' => (
string) (
int) (
isModEnabled(
'accounting')),
'position' => 20),
128 'toreconcile' => array(
'label' => $langs->trans(
"TransactionsToConciliate"),
'checked' =>
'1',
'position' => 50),
129 'b.currency_code' => array(
'label' => $langs->trans(
"Currency"),
'checked' =>
'0',
'position' => 22),
130 'b.datec' => array(
'label' => $langs->trans(
"DateCreation"),
'checked' =>
'0',
'position' => 500),
131 'b.tms' => array(
'label' => $langs->trans(
"DateModificationShort"),
'checked' =>
'0',
'position' => 500),
132 'b.clos' => array(
'label' => $langs->trans(
"Status"),
'checked' =>
'1',
'position' => 1000),
133 'balance' => array(
'label' => $langs->trans(
"Balance"),
'checked' =>
'1',
'position' => 1010),
136include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
138$parameters = array(
'arrayfields' => &$arrayfields);
139$reshook = $hookmanager->executeHooks(
'completeArrayFields', $parameters, $object, $action);
144$permissiontoadd = $user->hasRight(
'banque',
'modifier');
145$permissiontodelete = $user->hasRight(
'banque',
'configurer');
148if ($user->hasRight(
'accounting',
'chartofaccount')) {
160if (
GETPOST(
'cancel',
'alpha')) {
164if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
168$parameters = array(
'socid' => $socid);
169$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
171 setEventMessages($hookmanager->error, $hookmanager->errors,
'errors');
174if (empty($reshook)) {
175 include DOL_DOCUMENT_ROOT .
'/core/actions_changeselectedfields.inc.php';
178 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
183 $search_category_list = array();
184 $search_array_options = array();
188 $objectclass =
'Account';
189 $objectlabel =
'FinancialAccount';
190 $uploaddir =
$conf->bank->dir_output;
191 include DOL_DOCUMENT_ROOT .
'/core/actions_massactions.inc.php';
200$title = $langs->trans(
'BankAccounts');
201$help_url =
'EN:Module_Banks_and_Cash|FR:Module_Banques_et_Caisses|ES:Módulo_Bancos_y_Cajas';
206$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
207$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
$conf->main_checkbox_left_column);
212$sql =
"SELECT b.rowid, b.label, b.courant, b.rappro, b.account_number, b.fk_accountancy_journal, b.currency_code, b.datec as date_creation, b.tms as date_modification";
214if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
215 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
216 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
220$parameters = array();
221$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
222$sql .= $hookmanager->resPrint;
223$sql = preg_replace(
'/,\s*$/',
'', $sql);
227$sql .=
" FROM ".MAIN_DB_PREFIX.
"bank_account as b";
228if (!empty($extrafields->attributes[
$object->table_element][
'label']) && is_array($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
229 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element.
"_extrafields as ef on (b.rowid = ef.fk_object)";
231$sql .=
" WHERE b.entity IN (".getEntity(
'bank_account').
")";
232if ($search_status ===
'opened') {
233 $sql .=
" AND clos = 0";
235if ($search_status ===
'closed') {
236 $sql .=
" AND clos = 1";
238if ($search_ref !=
'') {
239 if (empty($arrayfields[
'b.label'][
'checked'])) {
246if ($search_label !=
'') {
249if ($search_number !=
'') {
253$searchCategoryBankList = $search_category_list;
254$searchCategoryBankOperator = 0;
255if (!empty($searchCategoryBankList)) {
256 $searchCategoryBankSqlList = array();
257 $listofcategoryid =
'';
258 foreach ($searchCategoryBankList as $searchCategoryBank) {
259 if (intval($searchCategoryBank) == -2) {
260 $searchCategoryBankSqlList[] =
"NOT EXISTS (SELECT ck.fk_account FROM ".MAIN_DB_PREFIX.
"categorie_account as ck WHERE b.rowid = ck.fk_account)";
261 } elseif (intval($searchCategoryBank) > 0) {
262 if ($searchCategoryBankOperator == 0) {
263 $searchCategoryBankSqlList[] =
" EXISTS (SELECT ck.fk_account FROM ".MAIN_DB_PREFIX.
"categorie_account as ck WHERE b.rowid = ck.fk_account AND ck.fk_categorie = ".((int) $searchCategoryBank).
")";
265 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryBank);
269 if ($listofcategoryid) {
270 $searchCategoryBankSqlList[] =
" EXISTS (SELECT ck.fk_account FROM ".MAIN_DB_PREFIX.
"categorie_account as ck WHERE b.rowid = ck.fk_account AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid).
"))";
272 if ($searchCategoryBankOperator == 1) {
273 if (!empty($searchCategoryBankSqlList)) {
274 $sql .=
" AND (".implode(
' OR ', $searchCategoryBankSqlList).
")";
277 if (!empty($searchCategoryBankSqlList)) {
278 $sql .=
" AND (".implode(
' AND ', $searchCategoryBankSqlList).
")";
283include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
285$parameters = array();
286$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
287$sql .= $hookmanager->resPrint;
290$nbtotalofrecords =
'';
293 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
294 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
295 $resql = $db->query($sqlforcount);
297 $objforcount = $db->fetch_object($resql);
298 $nbtotalofrecords = $objforcount->nbtotalofrecords;
300 dol_print_error($db);
303 if (($page * $limit) > (
int) $nbtotalofrecords) {
311$sql .= $db->order($sortfield, $sortorder);
313 $sql .= $db->plimit($limit + 1, $offset);
317$resql = $db->query($sql);
319 $num = $db->num_rows($resql);
322 $objp = $db->fetch_object($resql);
323 $accounts[$objp->rowid] = $objp->courant;
328 dol_print_error($db);
333llxHeader(
'', $title, $help_url,
'', 0, 0,
'',
'',
'',
'bodyforlist');
336$arrayofselected = is_array($toselect) ? $toselect : array();
340 $param .=
'&mode='.urlencode($mode);
342if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
343 $param .=
'&contextpage='.urlencode($contextpage);
345if ($limit > 0 && $limit !=
$conf->liste_limit) {
346 $param .=
'&limit='.((int) $limit);
348if ($optioncss !=
'') {
349 $param .=
'&optioncss='.urlencode($optioncss);
351if ($search_ref !=
'') {
352 $param .=
'&search_ref='.urlencode($search_ref);
354if ($search_label !=
'') {
355 $param .=
'&search_label='.urlencode($search_label);
357if ($search_number !=
'') {
358 $param .=
'&search_number='.urlencode($search_number);
360if ($search_status !=
'' && $search_status !=
'-1') {
361 $param .=
'&search_status='.urlencode($search_status);
364 $param .=
'&show_files='.urlencode((
string) ($show_files));
367include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
369$parameters = array(
'param' => &$param);
370$reshook = $hookmanager->executeHooks(
'printFieldListSearchParam', $parameters, $object, $action);
371$param .= $hookmanager->resPrint;
374$arrayofmassactions = array(
378if (!empty($permissiontodelete)) {
379 $arrayofmassactions[
'predelete'] = img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
381if (
isModEnabled(
'category') && $user->hasRight(
'banque',
'modifier')) {
382 $arrayofmassactions[
'preaffecttag'] = img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
384if (in_array($massaction, array(
'presend',
'predelete',
'preaffecttag'))) {
385 $arrayofmassactions = array();
387$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
389print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
390if ($optioncss !=
'') {
391 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
393print
'<input type="hidden" name="token" value="'.newToken().
'">';
394print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
395print
'<input type="hidden" name="action" value="list">';
396print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
397print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
398print
'<input type="hidden" name="page" value="'.$page.
'">';
399print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
400print
'<input type="hidden" name="page_y" value="">';
401print
'<input type="hidden" name="search_status" value="'.$search_status.
'">';
402print
'<input type="hidden" name="mode" value="'.$mode.
'">';
406$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewList'),
'',
'fa fa-bars imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=common'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ((empty($mode) || $mode ==
'common') ? 2 : 1), array(
'morecss' =>
'reposition'));
407$newcardbutton .=
dolGetButtonTitle($langs->trans(
'ViewKanban'),
'',
'fa fa-th-list imgforviewmode', $_SERVER[
"PHP_SELF"].
'?mode=kanban'.preg_replace(
'/(&|\?)*mode=[^&]+/',
'', $param),
'', ($mode ==
'kanban' ? 2 : 1), array(
'morecss' =>
'reposition'));
409$newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewFinancialAccount'),
'',
'fa fa-plus-circle',
'card.php?action=create',
'', $user->hasRight(
'banque',
'configurer'));
411print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'bank_account', 0, $newcardbutton,
'', $limit, 1);
413$topicmail =
"Information";
416$trackid =
'bank'.$object->id;
417include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
428if (
isModEnabled(
'category') && $user->hasRight(
'categorie',
'lire')) {
429 $moreforfilter .= $form->getFilterBox(Categorie::TYPE_ACCOUNT, $search_category_list);
433$parameters = array();
434$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
435if (empty($reshook)) {
436 $moreforfilter .= $hookmanager->resPrint;
438 $moreforfilter = $hookmanager->resPrint;
441if (!empty($moreforfilter)) {
442 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
443 print $moreforfilter;
447$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
448$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
450print
'<div class="div-table-responsive">';
451print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
455print
'<tr class="liste_titre_filter">';
457if (
$conf->main_checkbox_left_column) {
458 print
'<td class="liste_titre center maxwidthsearch">';
459 $searchpicto = $form->showFilterButtons(
'left');
464if (!empty($arrayfields[
'b.ref'][
'checked'])) {
465 print
'<td class="liste_titre">';
466 print
'<input class="flat" size="6" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
470if (!empty($arrayfields[
'b.label'][
'checked'])) {
471 print
'<td class="liste_titre">';
472 print
'<input class="flat" size="6" type="text" name="search_label" value="'.dol_escape_htmltag($search_label).
'">';
476if (!empty($arrayfields[
'accountype'][
'checked'])) {
477 print
'<td class="liste_titre">';
481if (!empty($arrayfields[
'b.number'][
'checked'])) {
482 print
'<td class="liste_titre">';
483 print
'<input class="flat" size="6" type="text" name="search_number" value="'.dol_escape_htmltag($search_number).
'">';
487if (!empty($arrayfields[
'b.account_number'][
'checked'])) {
488 print
'<td class="liste_titre">';
492if (!empty($arrayfields[
'b.fk_accountancy_journal'][
'checked'])) {
493 print
'<td class="liste_titre">';
497if (!empty($arrayfields[
'toreconcile'][
'checked'])) {
498 print
'<td class="liste_titre">';
502if (!empty($arrayfields[
'b.currency_code'][
'checked'])) {
503 print
'<td class="liste_titre">';
507include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
510$parameters = array(
'arrayfields' => $arrayfields);
511$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters, $object, $action);
512print $hookmanager->resPrint;
514if (!empty($arrayfields[
'b.datec'][
'checked'])) {
515 print
'<td class="liste_titre">';
519if (!empty($arrayfields[
'b.tms'][
'checked'])) {
520 print
'<td class="liste_titre">';
524if (!empty($arrayfields[
'b.clos'][
'checked'])) {
525 print
'<td class="liste_titre center parentonrightofpage">';
527 'opened' => $langs->trans(
"Opened"),
528 'closed' => $langs->trans(
"Closed")
530 print $form->selectarray(
"search_status", $array, $search_status, 1, 0, 0,
'', 0, 0, 0,
'',
'search_status minwidth75 maxwidth125 onrightofpage', 1);
534if (!empty($arrayfields[
'balance'][
'checked'])) {
535 print
'<td class="liste_titre"></td>';
538if (!
$conf->main_checkbox_left_column) {
539 print
'<td class="liste_titre center maxwidthsearch">';
540 $searchpicto = $form->showFilterButtons();
546$totalarray = array();
547$totalarray[
'nbfield'] = 0;
551print
'<tr class="liste_titre">';
553if (
$conf->main_checkbox_left_column) {
554 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ');
555 $totalarray[
'nbfield']++;
557if (!empty($arrayfields[
'b.ref'][
'checked'])) {
559 print_liste_field_titre($arrayfields[
'b.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'b.ref',
'', $param,
'', $sortfield, $sortorder);
560 $totalarray[
'nbfield']++;
562if (!empty($arrayfields[
'b.label'][
'checked'])) {
563 print_liste_field_titre($arrayfields[
'b.label'][
'label'], $_SERVER[
"PHP_SELF"],
'b.label',
'', $param,
'', $sortfield, $sortorder);
564 $totalarray[
'nbfield']++;
566if (!empty($arrayfields[
'accountype'][
'checked'])) {
567 print_liste_field_titre($arrayfields[
'accountype'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder);
568 $totalarray[
'nbfield']++;
570if (!empty($arrayfields[
'b.number'][
'checked'])) {
571 print_liste_field_titre($arrayfields[
'b.number'][
'label'], $_SERVER[
"PHP_SELF"],
'b.number',
'', $param,
'', $sortfield, $sortorder);
572 $totalarray[
'nbfield']++;
574if (!empty($arrayfields[
'b.account_number'][
'checked'])) {
575 print_liste_field_titre($arrayfields[
'b.account_number'][
'label'], $_SERVER[
"PHP_SELF"],
'b.account_number',
'', $param,
'', $sortfield, $sortorder);
576 $totalarray[
'nbfield']++;
578if (!empty($arrayfields[
'b.fk_accountancy_journal'][
'checked'])) {
579 print_liste_field_titre($arrayfields[
'b.fk_accountancy_journal'][
'label'], $_SERVER[
"PHP_SELF"],
'b.fk_accountancy_journal',
'', $param,
'', $sortfield, $sortorder);
580 $totalarray[
'nbfield']++;
582if (!empty($arrayfields[
'b.currency_code'][
'checked'])) {
583 print_liste_field_titre($arrayfields[
'b.currency_code'][
'label'], $_SERVER[
"PHP_SELF"],
'b.currency_code',
'', $param,
'', $sortfield, $sortorder,
'center ');
584 $totalarray[
'nbfield']++;
586if (!empty($arrayfields[
'toreconcile'][
'checked'])) {
587 print_liste_field_titre($arrayfields[
'toreconcile'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'center ');
588 $totalarray[
'nbfield']++;
591include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
593$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder);
594$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object, $action);
595print $hookmanager->resPrint;
596if (!empty($arrayfields[
'b.datec'][
'checked'])) {
597 print_liste_field_titre($arrayfields[
'b.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"b.datec",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
598 $totalarray[
'nbfield']++;
600if (!empty($arrayfields[
'b.tms'][
'checked'])) {
601 print_liste_field_titre($arrayfields[
'b.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"b.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
602 $totalarray[
'nbfield']++;
604if (!empty($arrayfields[
'b.clos'][
'checked'])) {
605 print_liste_field_titre($arrayfields[
'b.clos'][
'label'], $_SERVER[
"PHP_SELF"],
'b.clos',
'', $param,
'', $sortfield, $sortorder,
'center ');
606 $totalarray[
'nbfield']++;
608if (!empty($arrayfields[
'balance'][
'checked'])) {
609 print_liste_field_titre($arrayfields[
'balance'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'', $param,
'', $sortfield, $sortorder,
'right ');
610 $totalarray[
'nbfield']++;
613if (!
$conf->main_checkbox_left_column) {
614 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ');
615 $totalarray[
'nbfield']++;
623$savnbfield = $totalarray[
'nbfield'];
624$totalarray = array();
625$totalarray[
'nbfield'] = 0;
626$totalarray[
'val'] = array(
'balance' => 0);
628$lastcurrencycode =
'';
629$imaxinloop = ($limit ? min($num, $limit) : $num);
631foreach ($accounts as $key => $type) {
638 $result = $objecttmp->fetch($key);
640 $solde = $objecttmp->solde(1);
642 if (!empty($lastcurrencycode) && $lastcurrencycode != $objecttmp->currency_code) {
643 $lastcurrencycode =
'various';
645 if ($lastcurrencycode !=
'various') {
646 $lastcurrencycode = $objecttmp->currency_code;
649 if ($mode ==
'kanban') {
651 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
652 print
'<div class="box-flex-container kanban">';
656 if ($massactionbutton || $massaction) {
658 if (in_array(
$object->id, $arrayofselected)) {
663 print $objecttmp->getKanbanView(
'', array(
'selected' => $selected));
664 if ($i == ($imaxinloop - 1)) {
671 print
'<tr data-rowid="'.$objecttmp->id.
'" class="oddeven row-with-select">';
674 if (
$conf->main_checkbox_left_column) {
675 print
'<td class="nowrap center">';
676 if ($massactionbutton || $massaction) {
678 if (in_array($objecttmp->id, $arrayofselected)) {
681 print
'<input id="cb'.$objecttmp->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$objecttmp->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
685 $totalarray[
'nbfield']++;
689 if (!empty($arrayfields[
'b.ref'][
'checked'])) {
690 if (empty($arrayfields[
'b.label'][
'checked'])) {
692 print
'<td class="tdlineheightsmall">';
693 print
'<div class="tdoverflowmax200 inline-block lineheightsmall">';
694 print $objecttmp->getNomUrl(1);
695 if (!empty($objecttmp->label)) {
696 print
'<br><span class="spantitle">'.dolPrintHTML($objecttmp->label).
'</span>';
701 print
'<td class="nowraponall">'.$objecttmp->getNomUrl(1).
'</td>';
704 $totalarray[
'nbfield']++;
709 if (!empty($arrayfields[
'b.label'][
'checked'])) {
710 print
'<td class="tdoverflowmax200" title="'.dolPrintHTMLForAttribute($objecttmp->label).
'">';
711 print
'<span class="spantitle">';
712 print dolPrintHTML($objecttmp->label);
716 $totalarray[
'nbfield']++;
721 if (!empty($arrayfields[
'accountype'][
'checked'])) {
722 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($objecttmp->type_lib[$objecttmp->type]).
'">';
723 print $objecttmp->type_lib[$objecttmp->type];
726 $totalarray[
'nbfield']++;
731 if (!empty($arrayfields[
'b.number'][
'checked'])) {
732 print
'<td>'.dol_escape_htmltag($objecttmp->number).
'</td>';
734 $totalarray[
'nbfield']++;
739 if (!empty($arrayfields[
'b.account_number'][
'checked'])) {
740 print
'<td class="tdoverflowmax250">';
742 if (empty($objecttmp->account_number)) {
743 print img_warning($langs->trans(
"Mandatory"));
746 $accountingaccount->fetch(0, $objecttmp->account_number, 1);
747 print
'<span title="'.dol_escape_htmltag($accountingaccount->account_number.
' - '.$accountingaccount->label).
'">';
748 print $accountingaccount->getNomUrl(0, 1, 1,
'', 0);
752 print
'<span title="'.dol_escape_htmltag($objecttmp->account_number).
'">'.$objecttmp->account_number.
'</span>';
756 $totalarray[
'nbfield']++;
761 if (!empty($arrayfields[
'b.fk_accountancy_journal'][
'checked'])) {
763 if (empty($objecttmp->fk_accountancy_journal)) {
764 $s = img_warning($langs->trans(
"Mandatory"));
767 $accountingjournal->fetch($objecttmp->fk_accountancy_journal);
768 $s = $accountingjournal->getNomUrl(0, 1, 1,
'', 1);
773 print
'<td class="tdoverflowmax125" title="'.dolPrintHTMLForAttribute(
dol_string_nohtmltag($s)).
'">';
777 $totalarray[
'nbfield']++;
782 if (!empty($arrayfields[
'b.currency_code'][
'checked'])) {
783 print
'<td class="center nowraponall">';
784 print $objecttmp->currency_code;
787 $totalarray[
'nbfield']++;
792 if (!empty($arrayfields[
'toreconcile'][
'checked'])) {
793 $conciliate = $objecttmp->canBeConciliated();
796 if ($conciliate == -2) {
797 $labeltoshow = $langs->trans(
"CashAccount");
798 } elseif ($conciliate == -3) {
799 $labeltoshow = $langs->trans(
"Closed");
800 } elseif (empty($objecttmp->rappro)) {
801 $labeltoshow = $langs->trans(
"ConciliationDisabled");
804 print
'<td class="center tdoverflowmax125"'.($labeltoshow ?
' title="'.dolPrintHTML($labeltoshow).
'"' :
'').
'>';
805 if ($conciliate == -2) {
806 print
'<span class="opacitymedium" title="'.$langs->trans(
"CashAccount").
'">'.$langs->trans(
"Never").
'</span>';
807 } elseif ($conciliate == -3) {
808 print
'<span class="opacitymedium" title="'.$langs->trans(
"Closed").
'">'.$langs->trans(
"Never").
'</span>';
809 } elseif (empty($objecttmp->rappro)) {
810 print
'<span class="opacitymedium" title="'.$langs->trans(
"ConciliationDisabled").
'">'.$langs->trans(
"Never").
'</span>';
812 $result = $objecttmp->load_board($user, $objecttmp->id);
813 if (is_numeric($result) && $result < 0) {
814 setEventMessages($objecttmp->error, $objecttmp->errors,
'errors');
816 print
'<a href="'.DOL_URL_ROOT.
'/compta/bank/bankentries_list.php?action=reconcile&sortfield=b.datev,b.dateo,b.rowid&sortorder=asc,asc,asc&id='.((int) $objecttmp->id).
'&search_account='.((int) $objecttmp->id).
'&search_conciliated=0&contextpage=banktransactionlist">';
817 print
'<span class="badge badge-info classfortooltip" title="'.dol_htmlentities($langs->trans(
"TransactionsToConciliate")).
'">';
818 print $result->nbtodo;
821 if ($result->nbtodolate) {
822 print
'<span title="'.dol_htmlentities($langs->trans(
"Late")).
'" class="classfortooltip badge badge-warning marginleftonlyshort">';
823 print
'<i class="fa fa-exclamation-triangle"></i> '.$result->nbtodolate;
831 $totalarray[
'nbfield']++;
836 if (is_array($objecttmp->array_options)) {
838 foreach ($objecttmp->array_options as $k => $v) {
844 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
846 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &$totalarray);
847 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters, $objecttmp, $action);
848 print $hookmanager->resPrint;
850 if (!empty($arrayfields[
'b.datec'][
'checked'])) {
851 print
'<td class="center nowraponall">';
855 $totalarray[
'nbfield']++;
859 if (!empty($arrayfields[
'b.tms'][
'checked'])) {
860 print
'<td class="center nowraponall">';
864 $totalarray[
'nbfield']++;
869 if (!empty($arrayfields[
'b.clos'][
'checked'])) {
870 print
'<td class="center">'.$objecttmp->getLibStatut(5).
'</td>';
872 $totalarray[
'nbfield']++;
877 if (!empty($arrayfields[
'balance'][
'checked'])) {
878 print
'<td class="nowraponall right">';
879 print
'<a href="'.DOL_URL_ROOT.
'/compta/bank/bankentries_list.php?id='.$objecttmp->id.
'">';
880 print
'<span class="amount">'.price(
price2num($solde,
'MT'), 0, $langs, 1, -1, -1, $objecttmp->currency_code).
'</span>';
884 $totalarray[
'nbfield']++;
887 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'balance';
888 $totalarray[
'pospercurrency'][$totalarray[
'nbfield']] =
'balance';
890 $totalarray[
'val'][
'balance'] += $solde;
894 $totalarray[
'valpercurrency'][$objecttmp->currency_code][
'balance'] = ($totalarray[
'valpercurrency'][$objecttmp->currency_code][
'balance'] ?? 0) + $solde;
898 if (!
$conf->main_checkbox_left_column) {
899 print
'<td class="nowrap center">';
900 if ($massactionbutton || $massaction) {
902 if (in_array($objecttmp->id, $arrayofselected)) {
905 print
'<input id="cb'.$objecttmp->id.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$objecttmp->id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
909 $totalarray[
'nbfield']++;
921 foreach ($arrayfields as $key => $val) {
922 if (!empty($val[
'checked'])) {
926 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
930if ($lastcurrencycode ==
'various') {
936 $posKey = array_search(
'balance', $totalarray[
'pos'] ?? array(),
true);
937 if ($posKey !==
false) {
938 unset($totalarray[
'pos'][$posKey]);
940 unset($totalarray[
'val'][
'balance']);
942include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
944print
'</table>'.
"\n";
if(! $sortfield) if(! $sortorder) $object
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.
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to manage bank accounts.
Class to manage accounting accounts.
Class to manage accounting journals.
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by the value of a given key, which produces ascending (default) or descending out...
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.
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
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.