27 require
'../../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
29 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent_type.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/adherents/class/subscription.class.php';
31 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
33 $langs->loadLangs(array(
"members",
"companies"));
35 $action =
GETPOST(
'action',
'aZ09');
36 $massaction =
GETPOST(
'massaction',
'alpha');
37 $confirm =
GETPOST(
'confirm',
'alpha');
38 $toselect =
GETPOST(
'toselect',
'array');
39 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'subscriptionlist';
40 $mode =
GETPOST(
'mode',
'alpha');
44 $search_ref =
GETPOST(
'search_ref',
'alpha');
45 $search_type =
GETPOST(
'search_type',
'alpha');
46 $search_lastname =
GETPOST(
'search_lastname',
'alpha');
47 $search_firstname =
GETPOST(
'search_firstname',
'alpha');
48 $search_login =
GETPOST(
'search_login',
'alpha');
49 $search_note =
GETPOST(
'search_note',
'alpha');
50 $search_account =
GETPOST(
'search_account',
'int');
51 $search_amount =
GETPOST(
'search_amount',
'alpha');
52 $optioncss =
GETPOST(
'optioncss',
'alpha');
55 $date_select =
GETPOST(
"date_select",
'alpha');
57 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
58 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
59 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
61 if (empty($page) || $page == -1) {
64 $offset = $limit * $page;
65 $pageprev = $page - 1;
66 $pagenext = $page + 1;
71 $sortfield =
"c.dateadh";
77 $hookmanager->initHooks(array(
'subscriptionlist'));
81 $extrafields->fetch_name_optionals_label($object->table_element);
83 $search_array_options = $extrafields->getOptionalsFromPost($object->table_element,
'',
'search_');
86 $fieldstosearchall = array(
89 'd.ref'=>array(
'label'=>
"Ref",
'checked'=>1),
90 'd.fk_type'=>array(
'label'=>
"Type",
'checked'=>1),
91 'd.lastname'=>array(
'label'=>
"Lastname",
'checked'=>1),
92 'd.firstname'=>array(
'label'=>
"Firstname",
'checked'=>1),
93 'd.login'=>array(
'label'=>
"Login",
'checked'=>1),
94 't.libelle'=>array(
'label'=>
"Label",
'checked'=>1),
95 'd.bank'=>array(
'label'=>
"BankAccount",
'checked'=>1,
'enabled'=>(
isModEnabled(
'banque'))),
98 'c.dateadh'=>array(
'label'=>
"DateSubscription",
'checked'=>1,
'position'=>100),
99 'c.datef'=>array(
'label'=>
"EndSubscription",
'checked'=>1,
'position'=>101),
100 'd.amount'=>array(
'label'=>
"Amount",
'checked'=>1,
'position'=>102),
101 'c.datec'=>array(
'label'=>
"DateCreation",
'checked'=>0,
'position'=>500),
102 'c.tms'=>array(
'label'=>
"DateModificationShort",
'checked'=>0,
'position'=>500),
107 $result =
restrictedArea($user,
'adherent',
'',
'',
'cotisation');
114 if (
GETPOST(
'cancel',
'alpha')) {
115 $action =
'list'; $massaction =
'';
117 if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
121 $parameters = array(
'socid'=>isset($socid) ? $socid :
null);
122 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
127 if (empty($reshook)) {
129 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
132 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
135 $search_lastname =
"";
136 $search_firstname =
"";
140 $search_account =
"";
142 $search_array_options = array();
154 $accountstatic =
new Account($db);
159 $sql =
"SELECT d.rowid, d.login, d.firstname, d.lastname, d.societe, d.photo, d.statut,";
160 $sql .=
" d.gender, d.email, d.morphy,";
161 $sql .=
" c.rowid as crowid, c.fk_type, c.subscription,";
162 $sql .=
" c.dateadh, c.datef, c.datec as date_creation, c.tms as date_update,";
163 $sql .=
" c.fk_bank as bank, c.note,";
164 $sql .=
" b.fk_account";
165 $sql .=
" FROM ".MAIN_DB_PREFIX.
"adherent as d";
166 $sql .=
" JOIN ".MAIN_DB_PREFIX.
"subscription as c on d.rowid = c.fk_adherent";
167 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"adherent_extrafields as ef on (d.rowid = ef.fk_object)";
168 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"bank as b ON c.fk_bank=b.rowid";
169 $sql .=
" WHERE d.entity IN (".getEntity(
'adherent').
")";
170 if (isset($date_select) && $date_select !=
'') {
171 $sql .=
" AND c.dateadh >= '".((int) $date_select).
"-01-01 00:00:00'";
172 $sql .=
" AND c.dateadh < '".((int) $date_select + 1).
"-01-01 00:00:00'";
175 if (is_numeric($search_ref)) {
176 $sql .=
" AND c.rowid = ".((int) $search_ref);
178 $sql .=
" AND 1 = 2";
184 if ($search_lastname) {
187 if ($search_firstname) {
196 if ($search_account > 0) {
197 $sql .=
" AND b.fk_account = ".((int) $search_account);
199 if ($search_amount) {
204 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
207 $parameters = array();
208 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters);
209 $sql .= $hookmanager->resPrint;
211 $sql .= $db->order($sortfield, $sortorder);
215 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
216 $resql = $db->query(
$sql);
228 $sql .= $db->plimit($limit + 1, $offset);
230 $result = $db->query(
$sql);
236 $num = $db->num_rows($result);
238 $arrayofselected = is_array($toselect) ? $toselect : array();
240 if ($num == 1 && !empty($conf->global->MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE) && $sall) {
241 $obj = $db->fetch_object($resql);
243 header(
"Location: ".DOL_URL_ROOT.
'/adherents/subscription/card.php?id='.$id);
247 $title = $langs->trans(
"Subscriptions");
248 if (!empty($date_select)) {
249 $title .=
' ('.$langs->trans(
"Year").
' '.$date_select.
')';
252 $help_url =
'EN:Module_Foundations|FR:Module_Adhérents|ES:Módulo_Miembros|DE:Modul_Mitglieder';
259 $param .=
'&mode='.urlencode($mode);
261 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
262 $param .=
'&contextpage='.urlencode($contextpage);
264 if ($limit > 0 && $limit != $conf->liste_limit) {
265 $param .=
'&limit='.urlencode($limit);
268 $param .=
"&statut=".urlencode($statut);
271 $param .=
"&search_type=".urlencode($search_type);
274 $param .=
"&date_select=".urlencode($date_select);
276 if ($search_lastname) {
277 $param .=
"&search_lastname=".urlencode($search_lastname);
280 $param .=
"&search_login=".urlencode($search_login);
282 if ($search_account) {
283 $param .=
"&search_account=".urlencode($search_account);
285 if ($search_amount) {
286 $param .=
"&search_amount=".urlencode($search_amount);
288 if ($optioncss !=
'') {
289 $param .=
'&optioncss='.urlencode($optioncss);
292 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
295 $arrayofmassactions = array(
300 if (in_array($massaction, array(
'presend',
'predelete'))) {
301 $arrayofmassactions = array();
303 $massactionbutton =
$form->selectMassAction(
'', $arrayofmassactions);
306 $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'));
307 $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'));
309 if ($user->hasRight(
'adherent',
'cotisation',
'creer')) {
310 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewSubscription'),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/adherents/list.php?status=-1,1');
313 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">';
314 if ($optioncss !=
'') {
315 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
317 print
'<input type="hidden" name="token" value="'.newToken().
'">';
318 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
319 print
'<input type="hidden" name="action" value="list">';
320 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
321 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
322 print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
323 print
'<input type="hidden" name="date_select" value="'.$date_select.
'">';
324 print
'<input type="hidden" name="mode" value="'.$mode.
'">';
327 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num,
$nbtotalofrecords, $subscription->picto, 0, $newcardbutton,
'', $limit, 0, 0, 1);
329 $topicmail =
"Information";
330 $modelmail =
"subscription";
332 $trackid =
'sub'.$object->id;
333 include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
336 foreach ($fieldstosearchall as $key => $val) {
337 $fieldstosearchall[$key] = $langs->trans($val);
339 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $sall).join(
', ', $fieldstosearchall).
'</div>';
344 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
345 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
346 if ($massactionbutton) {
347 $selectedfields .=
$form->showCheckAddButtons(
'checkforselect', 1);
350 print
'<div class="div-table-responsive">';
351 print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
355 print
'<tr class="liste_titre_filter">';
358 print
'<td class="liste_titre right">';
359 $searchpicto =
$form->showFilterButtons(
'left');
364 if (!empty($conf->global->MAIN_SHOW_TECHNICAL_ID)) {
365 print
'<td class="liste_titre"> </td>';
369 if (!empty($arrayfields[
'd.ref'][
'checked'])) {
370 print
'<td class="liste_titre left">';
371 print
'<input class="flat maxwidth50" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'"></td>';
375 if (!empty($arrayfields[
'd.fk_type'][
'checked'])) {
376 print
'<td class="liste_titre left">';
377 print
'<input class="flat maxwidth50" type="text" name="search_type" value="'.dol_escape_htmltag($search_type).
'">';
381 if (!empty($arrayfields[
'd.lastname'][
'checked'])) {
382 print
'<td class="liste_titre left">';
383 print
'<input class="flat maxwidth75" type="text" name="search_lastname" value="'.dol_escape_htmltag($search_lastname).
'"></td>';
386 if (!empty($arrayfields[
'd.firstname'][
'checked'])) {
387 print
'<td class="liste_titre left">';
388 print
'<input class="flat maxwidth75" type="text" name="search_firstname" value="'.dol_escape_htmltag($search_firstname).
'"></td>';
391 if (!empty($arrayfields[
'd.login'][
'checked'])) {
392 print
'<td class="liste_titre left">';
393 print
'<input class="flat maxwidth75" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'"></td>';
396 if (!empty($arrayfields[
't.libelle'][
'checked'])) {
397 print
'<td class="liste_titre">';
402 if (!empty($arrayfields[
'd.bank'][
'checked'])) {
403 print
'<td class="liste_titre">';
404 $form->select_comptes($search_account,
'search_account', 0,
'', 1,
'', 0,
'maxwidth150');
408 if (!empty($arrayfields[
'c.dateadh'][
'checked'])) {
409 print
'<td class="liste_titre"> </td>';
412 if (!empty($arrayfields[
'c.datef'][
'checked'])) {
413 print
'<td class="liste_titre"> </td>';
416 if (!empty($arrayfields[
'd.amount'][
'checked'])) {
417 print
'<td class="liste_titre right">';
418 print
'<input class="flat" type="text" name="search_amount" value="'.dol_escape_htmltag($search_amount).
'" size="4">';
422 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
425 $parameters = array(
'arrayfields'=>$arrayfields);
426 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
427 print $hookmanager->resPrint;
429 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
430 print
'<td class="liste_titre">';
434 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
435 print
'<td class="liste_titre">';
441 print
'<td class="liste_titre right">';
442 $searchpicto =
$form->showFilterButtons();
449 print
'<tr class="liste_titre">';
451 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ');
453 if (!empty($arrayfields[
'd.ref'][
'checked'])) {
454 print_liste_field_titre($arrayfields[
'd.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"c.rowid", $param,
"",
"", $sortfield, $sortorder);
456 if (!empty($arrayfields[
'd.fk_type'][
'checked'])) {
457 print_liste_field_titre($arrayfields[
'd.fk_type'][
'label'], $_SERVER[
"PHP_SELF"],
"c.fk_type", $param,
"",
"", $sortfield, $sortorder);
459 if (!empty($arrayfields[
'd.lastname'][
'checked'])) {
460 print_liste_field_titre($arrayfields[
'd.lastname'][
'label'], $_SERVER[
"PHP_SELF"],
"d.lastname", $param,
"",
"", $sortfield, $sortorder);
462 if (!empty($arrayfields[
'd.firstname'][
'checked'])) {
463 print_liste_field_titre($arrayfields[
'd.firstname'][
'label'], $_SERVER[
"PHP_SELF"],
"d.firstname", $param,
"",
"", $sortfield, $sortorder);
465 if (!empty($arrayfields[
'd.login'][
'checked'])) {
466 print_liste_field_titre($arrayfields[
'd.login'][
'label'], $_SERVER[
"PHP_SELF"],
"d.login", $param,
"",
"", $sortfield, $sortorder);
468 if (!empty($arrayfields[
't.libelle'][
'checked'])) {
469 print_liste_field_titre($arrayfields[
't.libelle'][
'label'], $_SERVER[
"PHP_SELF"],
"c.note", $param,
"",
'', $sortfield, $sortorder);
471 if (!empty($arrayfields[
'd.bank'][
'checked'])) {
472 print_liste_field_titre($arrayfields[
'd.bank'][
'label'], $_SERVER[
"PHP_SELF"],
"b.fk_account", $param,
"",
"", $sortfield, $sortorder);
474 if (!empty($arrayfields[
'c.dateadh'][
'checked'])) {
475 print_liste_field_titre($arrayfields[
'c.dateadh'][
'label'], $_SERVER[
"PHP_SELF"],
"c.dateadh", $param,
"",
'', $sortfield, $sortorder,
'center nowraponall ');
477 if (!empty($arrayfields[
'c.datef'][
'checked'])) {
478 print_liste_field_titre($arrayfields[
'c.datef'][
'label'], $_SERVER[
"PHP_SELF"],
"c.datef", $param,
"",
'', $sortfield, $sortorder,
'center nowraponall ');
480 if (!empty($arrayfields[
'd.amount'][
'checked'])) {
481 print_liste_field_titre($arrayfields[
'd.amount'][
'label'], $_SERVER[
"PHP_SELF"],
"c.subscription", $param,
"",
'', $sortfield, $sortorder,
'right ');
485 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
488 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
489 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
490 print $hookmanager->resPrint;
491 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
492 print_liste_field_titre($arrayfields[
'c.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"c.datec",
"", $param,
'align="center" class="nowrap"', $sortfield, $sortorder);
494 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
495 print_liste_field_titre($arrayfields[
'c.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"c.tms",
"", $param,
'align="center" class="nowrap"', $sortfield, $sortorder);
498 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'align="center"', $sortfield, $sortorder,
'maxwidthsearch ');
503 $totalarray = array();
504 $totalarray[
'nbfield'] = 0;
505 while ($i < min($num, $limit)) {
506 $obj = $db->fetch_object($result);
508 $subscription->ref = $obj->crowid;
509 $subscription->id = $obj->crowid;
510 $subscription->dateh = $db->jdate($obj->dateadh);
511 $subscription->datef = $db->jdate($obj->datef);
513 $adherent->lastname = $obj->lastname;
514 $adherent->firstname = $obj->firstname;
515 $adherent->ref = $obj->rowid;
516 $adherent->id = $obj->rowid;
517 $adherent->statut = $obj->statut;
518 $adherent->login = $obj->login;
519 $adherent->photo = $obj->photo;
520 $adherent->gender = $obj->gender;
521 $adherent->morphy = $obj->morphy;
522 $adherent->email = $obj->email;
523 $adherent->typeid = $obj->fk_type;
524 $adherent->datefin = $db->jdate($obj->datef);
526 $typeid = ($obj->fk_type > 0 ? $obj->fk_type : $adherent->typeid);
528 $adht->fetch($typeid);
530 $adherent->need_subscription = $adht->subscription;
532 if ($mode ==
'kanban') {
534 print
'<tr><td colspan="12">';
535 print
'<div class="box-flex-container kanban">';
539 $subscription->fk_adherent = $adherent->getNomUrl(1);
540 $subscription->fk_type = $adht->getNomUrl(1);
541 $subscription->amount = $obj->subscription;
542 if ($obj->fk_account > 0) {
543 $accountstatic->id = $obj->fk_account;
544 $accountstatic->fetch($obj->fk_account);
545 $subscription->fk_bank = $accountstatic->getNomUrl(1);
548 print $subscription->getKanbanView(
'');
549 if ($i == (min($num, $limit) - 1)) {
554 print
'<tr class="oddeven">';
557 print
'<td class="center">';
558 if ($massactionbutton || $massaction) {
560 if (in_array($obj->crowid, $arrayofselected)) {
563 print
'<input id="cb'.$obj->crowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->crowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
567 $totalarray[
'nbfield']++;
571 if (!empty($arrayfields[
'd.ref'][
'checked'])) {
572 print
'<td>'.$subscription->getNomUrl(1).
'</td>';
574 $totalarray[
'nbfield']++;
578 if (!empty($arrayfields[
'd.fk_type'][
'checked'])) {
579 print
'<td class="nowraponall">';
581 print $adht->getNomUrl(1);
585 $totalarray[
'nbfield']++;
590 if (!empty($arrayfields[
'd.lastname'][
'checked'])) {
591 print
'<td class="tdoverflowmax150">'.$adherent->getNomUrl(-1, 0,
'card',
'lastname').
'</td>';
593 $totalarray[
'nbfield']++;
597 if (!empty($arrayfields[
'd.firstname'][
'checked'])) {
598 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($adherent->firstname).
'">'.$adherent->firstname.
'</td>';
600 $totalarray[
'nbfield']++;
605 if (!empty($arrayfields[
'd.login'][
'checked'])) {
606 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($adherent->login).
'">'.$adherent->login.
'</td>';
608 $totalarray[
'nbfield']++;
613 if (!empty($arrayfields[
't.libelle'][
'checked'])) {
614 print
'<td class="tdoverflowmax400" title="'.dol_escape_htmltag($obj->note).
'">';
618 $totalarray[
'nbfield']++;
623 if (!empty($arrayfields[
'd.bank'][
'checked'])) {
624 print
'<td class="tdmaxoverflow150">';
625 if ($obj->fk_account > 0) {
626 $accountstatic->id = $obj->fk_account;
627 $accountstatic->fetch($obj->fk_account);
629 print $accountstatic->getNomUrl(1);
633 $totalarray[
'nbfield']++;
638 if (!empty($arrayfields[
'c.dateadh'][
'checked'])) {
639 print
'<td class="center">'.dol_print_date($db->jdate($obj->dateadh),
'day').
"</td>\n";
641 $totalarray[
'nbfield']++;
645 if (!empty($arrayfields[
'c.datef'][
'checked'])) {
646 print
'<td class="center">'.dol_print_date($db->jdate($obj->datef),
'day').
"</td>\n";
648 $totalarray[
'nbfield']++;
652 if (!empty($arrayfields[
'd.amount'][
'checked'])) {
653 print
'<td class="right amount">'.price($obj->subscription).
'</td>';
655 $totalarray[
'nbfield']++;
658 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'd.amount';
660 if (empty($totalarray[
'val'][
'd.amount'])) {
661 $totalarray[
'val'][
'd.amount'] = $obj->subscription;
663 $totalarray[
'val'][
'd.amount'] += $obj->subscription;
667 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
669 $parameters = array(
'arrayfields'=>$arrayfields,
'obj'=>$obj,
'i'=>$i,
'totalarray'=>&$totalarray);
670 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
671 print $hookmanager->resPrint;
673 if (!empty($arrayfields[
'c.datec'][
'checked'])) {
674 print
'<td class="nowrap center">';
675 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuser');
678 $totalarray[
'nbfield']++;
682 if (!empty($arrayfields[
'c.tms'][
'checked'])) {
683 print
'<td class="nowrap center">';
684 print
dol_print_date($db->jdate($obj->date_update),
'dayhour',
'tzuser');
687 $totalarray[
'nbfield']++;
692 print
'<td class="center">';
693 if ($massactionbutton || $massaction) {
695 if (in_array($obj->crowid, $arrayofselected)) {
698 print
'<input id="cb'.$obj->crowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->crowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
702 $totalarray[
'nbfield']++;
711 include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
717 foreach ($arrayfields as $key => $val) {
718 if (!empty($val[
'checked'])) {
722 print
'<tr><td colspan="'.$colspan.
'" class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</td></tr>';
727 $parameters = array(
'sql' =>
$sql);
728 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters);
729 print $hookmanager->resPrint;