35require
'../main.inc.php';
36require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent.class.php';
37require_once DOL_DOCUMENT_ROOT.
'/adherents/class/adherent_type.class.php';
38require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
39require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
43$langs->loadLangs(array(
"members",
"companies",
"categories"));
47$action =
GETPOST(
'action',
'aZ09');
48$massaction =
GETPOST(
'massaction',
'alpha');
50$confirm =
GETPOST(
'confirm',
'alpha');
51$cancel =
GETPOST(
'cancel',
'alpha');
52$toselect =
GETPOST(
'toselect',
'array');
53$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'memberslist';
54$backtopage =
GETPOST(
'backtopage',
'alpha');
55$optioncss =
GETPOST(
'optioncss',
'aZ');
56$mode =
GETPOST(
'mode',
'alpha');
59$search =
GETPOST(
"search",
'alpha');
60$search_id =
GETPOST(
'search_id',
'int');
61$search_ref =
GETPOST(
"search_ref",
'alpha');
62$search_lastname =
GETPOST(
"search_lastname",
'alpha');
63$search_firstname =
GETPOST(
"search_firstname",
'alpha');
64$search_gender =
GETPOST(
"search_gender",
'alpha');
65$search_civility =
GETPOST(
"search_civility",
'alpha');
66$search_company =
GETPOST(
'search_company',
'alphanohtml');
67$search_login =
GETPOST(
"search_login",
'alpha');
68$search_address =
GETPOST(
"search_address",
'alpha');
69$search_zip =
GETPOST(
"search_zip",
'alpha');
70$search_town =
GETPOST(
"search_town",
'alpha');
71$search_state =
GETPOST(
"search_state",
'alpha');
72$search_country =
GETPOST(
"search_country",
'alpha');
73$search_phone =
GETPOST(
"search_phone",
'alpha');
74$search_phone_perso =
GETPOST(
"search_phone_perso",
'alpha');
75$search_phone_mobile =
GETPOST(
"search_phone_mobile",
'alpha');
76$search_type =
GETPOST(
"search_type",
'alpha');
77$search_email =
GETPOST(
"search_email",
'alpha');
78$search_categ =
GETPOST(
"search_categ",
'intcomma');
79$search_morphy =
GETPOST(
"search_morphy",
'alpha');
80$search_import_key = trim(
GETPOST(
"search_import_key",
'alpha'));
83if (
GETPOSTINT(
'catid') && empty($search_categ)) {
87$search_filter =
GETPOST(
"search_filter",
'alpha');
88$search_status =
GETPOST(
"search_status",
'intcomma');
94$filter =
GETPOST(
"filter",
'alpha');
96 $search_filter = $filter;
99$statut =
GETPOST(
"statut",
'alpha');
101 $search_status = $statut;
104$search_all = trim((
GETPOST(
'search_all',
'alphanohtml') !=
'') ?
GETPOST(
'search_all',
'alphanohtml') :
GETPOST(
'sall',
'alphanohtml'));
106if ($search_status < -2) {
112$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
113$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
115if (empty($page) || $page == -1) {
118$offset = $limit * $page;
119$pageprev = $page - 1;
120$pagenext = $page + 1;
122 $sortorder = ($filter ==
'outofdate' ?
"DESC" :
"ASC");
125 $sortfield = ($filter ==
'outofdate' ?
"d.datefin" :
"d.lastname");
131$hookmanager->initHooks(array(
'memberlist'));
135$extrafields->fetch_name_optionals_label(
$object->table_element);
137$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
140$fieldstosearchall = array(
142 'd.login' =>
'Login',
143 'd.lastname' =>
'Lastname',
144 'd.firstname' =>
'Firstname',
145 'd.societe' =>
"Company",
146 'd.email' =>
'EMail',
147 'd.address' =>
'Address',
150 'd.phone' =>
"Phone",
151 'd.phone_perso' =>
"PhonePerso",
152 'd.phone_mobile' =>
"PhoneMobile",
153 'd.note_public' =>
'NotePublic',
154 'd.note_private' =>
'NotePrivate',
158 'd.rowid' => array(
'label' =>
'ID',
'checked' => 1,
'enabled' =>
getDolGlobalInt(
'MAIN_SHOW_TECHNICAL_ID'),
'position' => 1),
159 'd.ref' => array(
'label' =>
"Ref",
'checked' => 1),
160 'd.civility' => array(
'label' =>
"Civility",
'checked' => 0),
161 'd.lastname' => array(
'label' =>
"Lastname",
'checked' => 1),
162 'd.firstname' => array(
'label' =>
"Firstname",
'checked' => 1),
163 'd.gender' => array(
'label' =>
"Gender",
'checked' => 0),
164 'd.company' => array(
'label' =>
"Company",
'checked' => 1,
'position' => 70),
165 'd.login' => array(
'label' =>
"Login",
'checked' => 1),
166 'd.morphy' => array(
'label' =>
"MemberNature",
'checked' => 1),
167 't.libelle' => array(
'label' =>
"Type",
'checked' => 1,
'position' => 55),
168 'd.address' => array(
'label' =>
"Address",
'checked' => 0),
169 'd.zip' => array(
'label' =>
"Zip",
'checked' => 0),
170 'd.town' => array(
'label' =>
"Town",
'checked' => 0),
171 'd.phone' => array(
'label' =>
"Phone",
'checked' => 0),
172 'd.phone_perso' => array(
'label' =>
"PhonePerso",
'checked' => 0),
173 'd.phone_mobile' => array(
'label' =>
"PhoneMobile",
'checked' => 0),
174 'd.email' => array(
'label' =>
"Email",
'checked' => 1),
175 'state.nom' => array(
'label' =>
"State",
'checked' => 0,
'position' => 90),
176 'country.code_iso' => array(
'label' =>
"Country",
'checked' => 0,
'position' => 95),
179 'd.datefin' => array(
'label' =>
"EndSubscription"),
180 'd.datec' => array(
'label' =>
"DateCreation"),
181 'd.birth' => array(
'label' =>
"Birthday"),
182 'd.tms' => array(
'label' =>
"DateModificationShort"),
183 'd.statut' => array(
'label' =>
"Status"),
184 'd.import_key' => array(
'label' =>
"ImportId"),
188include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
195foreach (
$object->fields as $key => $val) {
196 if (!array_key_exists($tableprefix.
'.'.$key, $arrayfields)) {
201 if (!empty($val[
'visible'])) {
202 $visible = (int)
dol_eval($val[
'visible'], 1);
203 $arrayfields[$tableprefix.
'.'.$key] = array(
204 'label' => $val[
'label'],
205 'checked' => (($visible < 0) ? 0 : 1),
206 'enabled' => (abs($visible) != 3 && (bool)
dol_eval($val[
'enabled'], 1)),
207 'position' => $val[
'position'],
208 'help' => isset($val[
'help']) ? $val[
'help'] :
''
213'@phan-var-force array<string,array{label:string,checked?:int<0,1>,position?:int,help?:string}> $arrayfields';
224if (
GETPOST(
'cancel',
'alpha')) {
228if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
232$parameters = array(
'socid' => isset($socid) ? $socid : null,
'arrayfields' => &$arrayfields);
233$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
238if (empty($reshook)) {
240 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
243 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
250 $search_lastname =
"";
251 $search_firstname =
"";
253 $search_civility =
"";
255 $search_company =
"";
258 $search_address =
"";
262 $search_country =
'';
264 $search_phone_perso =
'';
265 $search_phone_mobile =
'';
270 $search_import_key =
'';
274 $search_datec_start =
'';
275 $search_datec_end =
'';
276 $search_datem_start =
'';
277 $search_datem_end =
'';
278 $search_array_options = array();
282 if ($massaction ==
'close' && $user->hasRight(
'adherent',
'creer')) {
289 foreach ($toselect as $idtoclose) {
290 $tmpmember->fetch($idtoclose);
291 $result = $tmpmember->resiliate($user);
293 if ($result < 0 && !count($tmpmember->errors)) {
312 if ($massaction ==
'createexternaluser' && $user->hasRight(
'adherent',
'creer') && $user->hasRight(
'user',
'user',
'creer')) {
319 foreach ($toselect as $idtoclose) {
320 $tmpmember->fetch($idtoclose);
322 if (!empty($tmpmember->socid)) {
323 $nuser =
new User($db);
326 $result = $nuser->create_from_member($tmpuser, $tmpmember->login);
328 if ($result < 0 && !count($tmpmember->errors)) {
339 setEventMessages($langs->trans(
"XExternalUserCreated", $nbcreated),
null,
'mesgs');
348 if ($action ==
'createsubscription_confirm' && $confirm ==
"yes" && $user->hasRight(
'adherent',
'creer')) {
356 foreach ($toselect as $id) {
357 $res = $tmpmember->fetch($id);
359 $result = $tmpmember->subscription($now, $amount);
371 setEventMessages($langs->trans(
"XSubsriptionCreated", $nbcreated),
null,
'mesgs');
374 setEventMessages($langs->trans(
"XSubsriptionError", $error),
null,
'mesgs');
380 $objectclass =
'Adherent';
381 $objectlabel =
'Members';
382 $permissiontoread = $user->hasRight(
'adherent',
'lire');
383 $permissiontodelete = $user->hasRight(
'adherent',
'supprimer');
384 $permissiontoadd = $user->hasRight(
'adherent',
'creer');
385 $uploaddir = $conf->adherent->dir_output;
386 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
394$form =
new Form($db);
402$title = $langs->trans(
"Members").
" - ".$langs->trans(
"List");
403$help_url =
'EN:Module_Foundations|FR:Module_Adhérents|ES:Módulo_Miembros|DE:Modul_Mitglieder';
410if (!empty($search_categ) && $search_categ > 0) {
411 $sql =
"SELECT DISTINCT";
415$sql .=
" d.rowid, d.ref, d.login, d.lastname, d.firstname, d.gender, d.societe as company, d.fk_soc,";
416$sql .=
" d.civility, d.datefin, d.address, d.zip, d.town, d.state_id, d.country,";
417$sql .=
" d.email, d.phone, d.phone_perso, d.phone_mobile, d.birth, d.public, d.photo,";
418$sql .=
" d.fk_adherent_type as type_id, d.morphy, d.statut as status, d.datec as date_creation, d.tms as date_modification,";
419$sql .=
" d.note_private, d.note_public, d.import_key,";
421$sql .=
" ".$db->ifsql(
"d.societe IS NULL",
"s.nom",
"d.societe").
" as companyname,";
422$sql .=
" t.libelle as type, t.subscription,";
423$sql .=
" state.code_departement as state_code, state.nom as state_name";
426if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
427 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
428 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
433$parameters = array();
434$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters, $object, $action);
435$sql .= $hookmanager->resPrint;
436$sql = preg_replace(
'/,\s*$/',
'', $sql);
441$sql .=
" FROM ".MAIN_DB_PREFIX.
"adherent as d";
442if (!empty($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
443 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element.
"_extrafields as ef on (d.rowid = ef.fk_object)";
445$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = d.country)";
446$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = d.state_id)";
447$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s on (s.rowid = d.fk_soc)";
450$sql .=
", ".MAIN_DB_PREFIX.
"adherent_type as t";
451$sql .=
" WHERE d.fk_adherent_type = t.rowid";
453$searchCategoryContactList = $search_categ ? array($search_categ) : array();
454$searchCategoryContactOperator = 0;
456if (!empty($searchCategoryContactList)) {
457 $searchCategoryContactSqlList = array();
458 $listofcategoryid =
'';
459 foreach ($searchCategoryContactList as $searchCategoryContact) {
460 if (intval($searchCategoryContact) == -2) {
461 $searchCategoryContactSqlList[] =
"NOT EXISTS (SELECT ck.fk_categorie FROM ".MAIN_DB_PREFIX.
"categorie_member as ck WHERE d.rowid = ck.fk_member)";
462 } elseif (intval($searchCategoryContact) > 0) {
463 if ($searchCategoryContactOperator == 0) {
464 $searchCategoryContactSqlList[] =
" EXISTS (SELECT ck.fk_categorie FROM ".MAIN_DB_PREFIX.
"categorie_member as ck WHERE d.rowid = ck.fk_member AND ck.fk_categorie = ".((int) $searchCategoryContact).
")";
466 $listofcategoryid .= ($listofcategoryid ?
', ' :
'') .((
int) $searchCategoryContact);
470 if ($listofcategoryid) {
471 $searchCategoryContactSqlList[] =
" EXISTS (SELECT ck.fk_categorie FROM ".MAIN_DB_PREFIX.
"categorie_member as ck WHERE d.rowid = ck.fk_member AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid).
"))";
473 if ($searchCategoryContactOperator == 1) {
474 if (!empty($searchCategoryContactSqlList)) {
475 $sql .=
" AND (".implode(
' OR ', $searchCategoryContactSqlList).
")";
478 if (!empty($searchCategoryContactSqlList)) {
479 $sql .=
" AND (".implode(
' AND ', $searchCategoryContactSqlList).
")";
484$sql .=
" AND d.entity IN (".getEntity(
'adherent').
")";
486 $sql .=
natural_search(array_keys($fieldstosearchall), $search_all);
488if ($search_type > 0) {
489 $sql .=
" AND t.rowid=".((int) $search_type);
491if ($search_filter ==
'withoutsubscription') {
492 $sql .=
" AND (datefin IS NULL)";
494if ($search_filter ==
'waitingsubscription') {
495 $sql .=
" AND (datefin IS NULL AND t.subscription = '1')";
497if ($search_filter ==
'uptodate') {
500 $sql .=
" AND (datefin >= '".$db->idate($now).
"' OR (datefin IS NULL AND t.subscription = '0'))";
502if ($search_filter ==
'outofdate') {
503 $sql .=
" AND (datefin < '".$db->idate($now).
"')";
505if ($search_status !=
'') {
507 $sql .=
" AND d.statut in (".$db->sanitize($db->escape($search_status)).
")";
509if ($search_morphy !=
'' && $search_morphy !=
'-1') {
518if ($search_civility) {
521if ($search_firstname) {
524if ($search_lastname) {
525 $sql .=
natural_search(array(
"d.firstname",
"d.lastname",
"d.societe"), $search_lastname);
527if ($search_gender !=
'' && $search_gender !=
'-1') {
533if ($search_company) {
539if ($search_address) {
554if ($search_phone_perso) {
557if ($search_phone_mobile) {
560if ($search_country) {
561 $sql .=
" AND d.country IN (".$db->sanitize($search_country).
')';
563if ($search_import_key) {
566if ($search_datec_start) {
567 $sql .=
" AND d.datec >= '".$db->idate($search_datec_start).
"'";
569if ($search_datec_end) {
570 $sql .=
" AND d.datec <= '".$db->idate($search_datec_end).
"'";
572if ($search_datem_start) {
573 $sql .=
" AND d.tms >= '".$db->idate($search_datem_start).
"'";
575if ($search_datem_end) {
576 $sql .=
" AND d.tms <= '".$db->idate($search_datem_end).
"'";
579include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
581$parameters = array();
582$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters, $object, $action);
583$sql .= $hookmanager->resPrint;
586$nbtotalofrecords =
'';
589 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
590 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
591 $resql = $db->query($sqlforcount);
593 $objforcount = $db->fetch_object($resql);
594 $nbtotalofrecords = $objforcount->nbtotalofrecords;
599 if (($page * $limit) > $nbtotalofrecords) {
608$sql .= $db->order($sortfield, $sortorder);
610 $sql .= $db->plimit($limit + 1, $offset);
613$resql = $db->query($sql);
619$num = $db->num_rows($resql);
623if ($num == 1 &&
getDolGlobalString(
'MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all && !$page) {
624 $obj = $db->fetch_object($resql);
626 header(
"Location: ".DOL_URL_ROOT.
'/adherents/card.php?id='.$id);
633llxHeader(
'', $title, $help_url,
'', 0, 0, $morejs, $morecss,
'',
'mod-member page-list bodyforlist');
635$arrayofselected = is_array($toselect) ? $toselect : array();
638if ($search_type > 0) {
640 $result = $membertype->fetch($search_type);
641 $title .=
" (".$membertype->label.
")";
647 $param .=
'&mode='.urlencode($mode);
649if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
650 $param .=
'&contextpage='.urlencode($contextpage);
652if ($limit > 0 && $limit != $conf->liste_limit) {
653 $param .=
'&limit='.((int) $limit);
655if ($optioncss !=
'') {
656 $param .=
'&optioncss='.urlencode($optioncss);
658if ($search_all !=
"") {
659 $param .=
"&search_all=".urlencode($search_all);
662 $param .=
"&search_ref=".urlencode($search_ref);
664if ($search_civility) {
665 $param .=
"&search_civility=".urlencode($search_civility);
667if ($search_firstname) {
668 $param .=
"&search_firstname=".urlencode($search_firstname);
670if ($search_lastname) {
671 $param .=
"&search_lastname=".urlencode($search_lastname);
674 $param .=
"&search_gender=".urlencode($search_gender);
677 $param .=
"&search_login=".urlencode($search_login);
680 $param .=
"&search_email=".urlencode($search_email);
682if ($search_categ > 0 || $search_categ == -2) {
683 $param .=
"&search_categ=".urlencode((
string) ($search_categ));
685if ($search_company) {
686 $param .=
"&search_company=".urlencode($search_company);
688if ($search_address !=
'') {
689 $param .=
"&search_address=".urlencode($search_address);
691if ($search_town !=
'') {
692 $param .=
"&search_town=".urlencode($search_town);
694if ($search_zip !=
'') {
695 $param .=
"&search_zip=".urlencode($search_zip);
697if ($search_state !=
'') {
698 $param .=
"&search_state=".urlencode($search_state);
700if ($search_country !=
'') {
701 $param .=
"&search_country=".urlencode($search_country);
703if ($search_phone !=
'') {
704 $param .=
"&search_phone=".urlencode($search_phone);
706if ($search_phone_perso !=
'') {
707 $param .=
"&search_phone_perso=".urlencode($search_phone_perso);
709if ($search_phone_mobile !=
'') {
710 $param .=
"&search_phone_mobile=".urlencode($search_phone_mobile);
712if ($search_filter && $search_filter !=
'-1') {
713 $param .=
"&search_filter=".urlencode($search_filter);
715if ($search_status !=
"" && $search_status != -3) {
716 $param .=
"&search_status=".urlencode($search_status);
718if ($search_import_key !=
'') {
719 $param .=
'&search_import_key='.urlencode($search_import_key);
721if ($search_type > 0) {
722 $param .=
"&search_type=".urlencode($search_type);
724if ($search_datec_start) {
725 $param .=
'&search_datec_start_day='.dol_print_date($search_datec_start,
'%d').
'&search_datec_start_month='.
dol_print_date($search_datec_start,
'%m').
'&search_datec_start_year='.
dol_print_date($search_datec_start,
'%Y');
727if ($search_datem_end) {
728 $param .=
'&search_datem_end_day='.dol_print_date($search_datem_end,
'%d').
'&search_datem_end_month='.
dol_print_date($search_datem_end,
'%m').
'&search_datem_end_year='.
dol_print_date($search_datem_end,
'%Y');
732include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
735$arrayofmassactions = array(
739if ($user->hasRight(
'adherent',
'creer')) {
740 $arrayofmassactions[
'close'] =
img_picto(
'',
'close_title',
'class="pictofixedwidth"').$langs->trans(
"Resiliate");
742if ($user->hasRight(
'adherent',
'supprimer')) {
743 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
745if (isModEnabled(
'category') && $user->hasRight(
'adherent',
'creer')) {
746 $arrayofmassactions[
'preaffecttag'] =
img_picto(
'',
'category',
'class="pictofixedwidth"').$langs->trans(
"AffectTag");
748if ($user->hasRight(
'adherent',
'creer') && $user->hasRight(
'user',
'user',
'creer')) {
749 $arrayofmassactions[
'createexternaluser'] =
img_picto(
'',
'user',
'class="pictofixedwidth"').$langs->trans(
"CreateExternalUser");
751if ($user->hasRight(
'adherent',
'creer')) {
752 $arrayofmassactions[
'createsubscription'] =
img_picto(
'',
'payment',
'class="pictofixedwidth"').$langs->trans(
"CreateSubscription");
754if (
GETPOSTINT(
'nomassaction') || in_array($massaction, array(
'presend',
'predelete',
'preaffecttag'))) {
755 $arrayofmassactions = array();
757$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
759print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
760if ($optioncss !=
'') {
761 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
763print
'<input type="hidden" name="token" value="'.newToken().
'">';
764print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
765print
'<input type="hidden" name="action" value="list">';
766print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
767print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
768print
'<input type="hidden" name="page" value="'.$page.
'">';
769print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
770print
'<input type="hidden" name="page_y" value="">';
771print
'<input type="hidden" name="mode" value="'.$mode.
'">';
775$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'));
776$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'));
777if ($user->hasRight(
'adherent',
'creer')) {
779 $newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewMember'),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/adherents/card.php?action=create');
782print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
$object->picto, 0, $newcardbutton,
'', $limit, 0, 0, 1);
784$topicmail =
"Information";
785$modelmail =
"member";
787$trackid =
'mem'.$object->id;
788if ($massaction ==
'createsubscription') {
792 foreach ($toselect as $id) {
794 $tmpmember->fetch($id);
795 $res = $adht->fetch($tmpmember->typeid);
797 $amounttmp = $adht->amount;
798 if (!empty($tmpmember->last_subscription_amount) && !GETPOSTISSET(
'newamount') && is_numeric($amounttmp)) {
799 $amounttmp = max($tmpmember->last_subscription_amount, $amount);
801 $amount = max(0, $amounttmp, $amount);
808 $formquestion = array(
809 array(
'label' => $langs->trans(
"DateSubscription"),
'type' =>
'other',
'value' => $date),
810 array(
'label' => $langs->trans(
"Amount"),
'type' =>
'text',
'value' =>
price($amount, 0,
'', 0),
'name' =>
'amount'),
811 array(
'type' =>
'separator'),
812 array(
'label' => $langs->trans(
"MoreActions"),
'type' =>
'other',
'value' => $langs->trans(
"None").
' '.
img_warning($langs->trans(
"WarningNoComplementaryActionDone"))),
814 print $form->formconfirm($_SERVER[
"PHP_SELF"], $langs->trans(
"ConfirmMassSubsriptionCreation"), $langs->trans(
"ConfirmMassSubsriptionCreationQuestion", count($toselect)),
"createsubscription_confirm", $formquestion,
'', 0, 200, 500, 1);
816include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
820 foreach ($fieldstosearchall as $key => $val) {
821 $fieldstosearchall[$key] = $langs->trans($val);
822 $setupstring .= $key.
"=".$val.
";";
824 print
'<!-- Search done like if MYOBJECT_QUICKSEARCH_ON_FIELDS = '.$setupstring.
' -->'.
"\n";
825 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).implode(
', ', $fieldstosearchall).
'</div>'.
"\n";
828$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
829$htmlofselectarray = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
getDolGlobalString(
'MAIN_CHECKBOX_LEFT_COLUMN'));
830$selectedfields = ($mode !=
'kanban' ? $htmlofselectarray :
'');
831$selectedfields .= (count($arrayofmassactions) ? $form->showCheckAddButtons(
'checkforselect', 1) :
'');
835if (isModEnabled(
'category') && $user->hasRight(
'categorie',
'lire')) {
836 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
837 $moreforfilter .=
'<div class="divsearchfield">';
838 $moreforfilter .=
img_picto($langs->trans(
'Categories'),
'category',
'class="pictofixedwidth"').$formother->select_categories(Categorie::TYPE_MEMBER, $search_categ,
'search_categ', 1, $langs->trans(
"MembersCategoriesShort"));
839 $moreforfilter .=
'</div>';
842 'arrayfields' => &$arrayfields,
844$reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
845if (empty($reshook)) {
846 $moreforfilter .= $hookmanager->resPrint;
848 $moreforfilter = $hookmanager->resPrint;
850if (!empty($moreforfilter)) {
851 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
852 print $moreforfilter;
853 $parameters = array();
854 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
855 print $hookmanager->resPrint;
859print
'<div class="div-table-responsive">';
860print
'<table class="tagtable nobottomiftotal liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
864print
'<tr class="liste_titre_filter">';
868 print
'<td class="liste_titre center maxwidthsearch">';
869 $searchpicto = $form->showFilterButtons(
'left');
875if (!empty($arrayfields[
'd.rowid'][
'checked'])) {
876 print
'<td class="liste_titre">';
877 print
'<input class="flat" size="6" type="text" name="search_id" value="'.dol_escape_htmltag($search_id).
'">';
882if (!empty($arrayfields[
'd.ref'][
'checked'])) {
883 print
'<td class="liste_titre">';
884 print
'<input type="text" class="flat maxwidth75imp" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
889if (!empty($arrayfields[
'd.civility'][
'checked'])) {
890 print
'<td class="liste_titre left">';
891 print
'<input class="flat maxwidth50imp" type="text" name="search_civility" value="'.dol_escape_htmltag($search_civility).
'"></td>';
895if (!empty($arrayfields[
'd.firstname'][
'checked'])) {
896 print
'<td class="liste_titre left">';
897 print
'<input class="flat maxwidth75imp" type="text" name="search_firstname" value="'.dol_escape_htmltag($search_firstname).
'"></td>';
901if (!empty($arrayfields[
'd.lastname'][
'checked'])) {
902 print
'<td class="liste_titre left">';
903 print
'<input class="flat maxwidth75imp" type="text" name="search_lastname" value="'.dol_escape_htmltag($search_lastname).
'"></td>';
907if (!empty($arrayfields[
'd.gender'][
'checked'])) {
908 print
'<td class="liste_titre">';
909 $arraygender = array(
'man' => $langs->trans(
"Genderman"),
'woman' => $langs->trans(
"Genderwoman"),
'other' => $langs->trans(
"Genderother"));
910 print $form->selectarray(
'search_gender', $arraygender, $search_gender, 1);
915if (!empty($arrayfields[
'd.company'][
'checked'])) {
916 print
'<td class="liste_titre left">';
917 print
'<input class="flat maxwidth75imp" type="text" name="search_company" value="'.dol_escape_htmltag($search_company).
'"></td>';
921if (!empty($arrayfields[
'd.login'][
'checked'])) {
922 print
'<td class="liste_titre left">';
923 print
'<input class="flat maxwidth75imp" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'"></td>';
927if (!empty($arrayfields[
'd.morphy'][
'checked'])) {
928 print
'<td class="liste_titre center">';
929 $arraymorphy = array(
'mor' => $langs->trans(
"Moral"),
'phy' => $langs->trans(
"Physical"));
930 print $form->selectarray(
'search_morphy', $arraymorphy, $search_morphy, 1, 0, 0,
'', 0, 0, 0,
'',
'maxwidth100');
935if (!empty($arrayfields[
't.libelle'][
'checked'])) {
938if (!empty($arrayfields[
't.libelle'][
'checked'])) {
939 print
'<td class="liste_titre">';
940 $listetype = $membertypestatic->liste_array();
942 print $form->selectarray(
"search_type", $listetype, $search_type, 1, 0, 0,
'', 0, 32);
947if (!empty($arrayfields[
'd.address'][
'checked'])) {
948 print
'<td class="liste_titre left">';
949 print
'<input class="flat maxwidth75imp" type="text" name="search_address" value="'.dol_escape_htmltag($search_address).
'"></td>';
953if (!empty($arrayfields[
'd.zip'][
'checked'])) {
954 print
'<td class="liste_titre left">';
955 print
'<input class="flat maxwidth50imp" type="text" name="search_zip" value="'.dol_escape_htmltag($search_zip).
'"></td>';
959if (!empty($arrayfields[
'd.town'][
'checked'])) {
960 print
'<td class="liste_titre left">';
961 print
'<input class="flat maxwidth75imp" type="text" name="search_town" value="'.dol_escape_htmltag($search_town).
'"></td>';
965if (!empty($arrayfields[
'state.nom'][
'checked'])) {
966 print
'<td class="liste_titre">';
967 print
'<input class="flat searchstring maxwidth75imp" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
972if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
973 print
'<td class="liste_titre center">';
974 print $form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
979if (!empty($arrayfields[
'd.phone'][
'checked'])) {
980 print
'<td class="liste_titre left">';
981 print
'<input class="flat maxwidth75imp" type="text" name="search_phone" value="'.dol_escape_htmltag($search_phone).
'"></td>';
985if (!empty($arrayfields[
'd.phone_perso'][
'checked'])) {
986 print
'<td class="liste_titre left">';
987 print
'<input class="flat maxwidth75imp" type="text" name="search_phone_perso" value="'.dol_escape_htmltag($search_phone_perso).
'"></td>';
991if (!empty($arrayfields[
'd.phone_mobile'][
'checked'])) {
992 print
'<td class="liste_titre left">';
993 print
'<input class="flat maxwidth75imp" type="text" name="search_phone_mobile" value="'.dol_escape_htmltag($search_phone_mobile).
'"></td>';
997if (!empty($arrayfields[
'd.email'][
'checked'])) {
998 print
'<td class="liste_titre left">';
999 print
'<input class="flat maxwidth75imp" type="text" name="search_email" value="'.dol_escape_htmltag($search_email).
'"></td>';
1003if (!empty($arrayfields[
'd.datefin'][
'checked'])) {
1004 print
'<td class="liste_titre center">';
1006 $selectarray = array(
'-1' =>
'',
'waitingsubscription' => $langs->trans(
"WaitingSubscription"),
'uptodate' => $langs->trans(
"UpToDate"),
'outofdate' => $langs->trans(
"OutOfDate"));
1007 print $form->selectarray(
'search_filter', $selectarray, $search_filter);
1012include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
1015$parameters = array(
'arrayfields' => $arrayfields);
1016$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
1017print $hookmanager->resPrint;
1020if (!empty($arrayfields[
'd.datec'][
'checked'])) {
1021 print
'<td class="liste_titre">';
1022 print
'<div class="nowrapfordate">';
1023 print $form->selectDate($search_datec_start ? $search_datec_start : -1,
'search_datec_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1025 print
'<div class="nowrapfordate">';
1026 print $form->selectDate($search_datec_end ? $search_datec_end : -1,
'search_datec_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1032if (!empty($arrayfields[
'd.birth'][
'checked'])) {
1033 print
'<td class="liste_titre">';
1038if (!empty($arrayfields[
'd.tms'][
'checked'])) {
1039 print
'<td class="liste_titre">';
1040 print
'<div class="nowrapfordate">';
1041 print $form->selectDate($search_datem_start ? $search_datem_start : -1,
'search_datem_start_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1043 print
'<div class="nowrapfordate">';
1044 print $form->selectDate($search_datem_end ? $search_datem_end : -1,
'search_datem_end_', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1050if (!empty($arrayfields[
'd.import_key'][
'checked'])) {
1051 print
'<td class="liste_titre center">';
1052 print
'<input class="flat searchstring maxwidth50" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).
'">';
1057if (!empty($arrayfields[
'd.statut'][
'checked'])) {
1058 print
'<td class="liste_titre center parentonrightofpage">';
1059 $liststatus = array(
1066 print $form->selectarray(
'search_status', $liststatus, $search_status, -3, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage');
1072 print
'<td class="liste_titre center maxwidthsearch">';
1073 $searchpicto = $form->showFilterButtons();
1079$totalarray = array();
1080$totalarray[
'nbfield'] = 0;
1084print
'<tr class="liste_titre">';
1087 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch actioncolumn ');
1088 $totalarray[
'nbfield']++;
1090if (!empty($arrayfields[
'd.rowid'][
'checked'])) {
1091 print_liste_field_titre($arrayfields[
'd.rowid'][
'label'], $_SERVER[
"PHP_SELF"],
'd.rowid',
'', $param,
'', $sortfield, $sortorder,
'center ');
1092 $totalarray[
'nbfield']++;
1094if (!empty($arrayfields[
'd.ref'][
'checked'])) {
1095 print_liste_field_titre($arrayfields[
'd.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'd.ref',
'', $param,
'', $sortfield, $sortorder);
1096 $totalarray[
'nbfield']++;
1098if (!empty($arrayfields[
'd.civility'][
'checked'])) {
1099 print_liste_field_titre($arrayfields[
'd.civility'][
'label'], $_SERVER[
"PHP_SELF"],
'd.civility',
'', $param,
'', $sortfield, $sortorder);
1100 $totalarray[
'nbfield']++;
1102if (!empty($arrayfields[
'd.firstname'][
'checked'])) {
1103 print_liste_field_titre($arrayfields[
'd.firstname'][
'label'], $_SERVER[
"PHP_SELF"],
'd.firstname',
'', $param,
'', $sortfield, $sortorder);
1104 $totalarray[
'nbfield']++;
1106if (!empty($arrayfields[
'd.lastname'][
'checked'])) {
1107 print_liste_field_titre($arrayfields[
'd.lastname'][
'label'], $_SERVER[
"PHP_SELF"],
'd.lastname',
'', $param,
'', $sortfield, $sortorder);
1108 $totalarray[
'nbfield']++;
1110if (!empty($arrayfields[
'd.gender'][
'checked'])) {
1111 print_liste_field_titre($arrayfields[
'd.gender'][
'label'], $_SERVER[
'PHP_SELF'],
'd.gender', $param,
"",
"", $sortfield, $sortorder);
1112 $totalarray[
'nbfield']++;
1114if (!empty($arrayfields[
'd.company'][
'checked'])) {
1115 print_liste_field_titre($arrayfields[
'd.company'][
'label'], $_SERVER[
"PHP_SELF"],
'companyname',
'', $param,
'', $sortfield, $sortorder);
1116 $totalarray[
'nbfield']++;
1118if (!empty($arrayfields[
'd.login'][
'checked'])) {
1119 print_liste_field_titre($arrayfields[
'd.login'][
'label'], $_SERVER[
"PHP_SELF"],
'd.login',
'', $param,
'', $sortfield, $sortorder);
1120 $totalarray[
'nbfield']++;
1122if (!empty($arrayfields[
'd.morphy'][
'checked'])) {
1123 print_liste_field_titre($arrayfields[
'd.morphy'][
'label'], $_SERVER[
"PHP_SELF"],
'd.morphy',
'', $param,
'', $sortfield, $sortorder);
1124 $totalarray[
'nbfield']++;
1126if (!empty($arrayfields[
't.libelle'][
'checked'])) {
1127 print_liste_field_titre($arrayfields[
't.libelle'][
'label'], $_SERVER[
"PHP_SELF"],
't.libelle',
'', $param,
'', $sortfield, $sortorder);
1128 $totalarray[
'nbfield']++;
1130if (!empty($arrayfields[
'd.address'][
'checked'])) {
1131 print_liste_field_titre($arrayfields[
'd.address'][
'label'], $_SERVER[
"PHP_SELF"],
'd.address',
'', $param,
'', $sortfield, $sortorder);
1132 $totalarray[
'nbfield']++;
1134if (!empty($arrayfields[
'd.zip'][
'checked'])) {
1135 print_liste_field_titre($arrayfields[
'd.zip'][
'label'], $_SERVER[
"PHP_SELF"],
'd.zip',
'', $param,
'', $sortfield, $sortorder);
1136 $totalarray[
'nbfield']++;
1138if (!empty($arrayfields[
'd.town'][
'checked'])) {
1139 print_liste_field_titre($arrayfields[
'd.town'][
'label'], $_SERVER[
"PHP_SELF"],
'd.town',
'', $param,
'', $sortfield, $sortorder);
1140 $totalarray[
'nbfield']++;
1142if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1143 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
1144 $totalarray[
'nbfield']++;
1146if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1147 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
1148 $totalarray[
'nbfield']++;
1150if (!empty($arrayfields[
'd.phone'][
'checked'])) {
1151 print_liste_field_titre($arrayfields[
'd.phone'][
'label'], $_SERVER[
"PHP_SELF"],
'd.phone',
'', $param,
'', $sortfield, $sortorder);
1152 $totalarray[
'nbfield']++;
1154if (!empty($arrayfields[
'd.phone_perso'][
'checked'])) {
1155 print_liste_field_titre($arrayfields[
'd.phone_perso'][
'label'], $_SERVER[
"PHP_SELF"],
'd.phone_perso',
'', $param,
'', $sortfield, $sortorder);
1156 $totalarray[
'nbfield']++;
1158if (!empty($arrayfields[
'd.phone_mobile'][
'checked'])) {
1159 print_liste_field_titre($arrayfields[
'd.phone_mobile'][
'label'], $_SERVER[
"PHP_SELF"],
'd.phone_mobile',
'', $param,
'', $sortfield, $sortorder);
1160 $totalarray[
'nbfield']++;
1162if (!empty($arrayfields[
'd.email'][
'checked'])) {
1163 print_liste_field_titre($arrayfields[
'd.email'][
'label'], $_SERVER[
"PHP_SELF"],
'd.email',
'', $param,
'', $sortfield, $sortorder);
1164 $totalarray[
'nbfield']++;
1166if (!empty($arrayfields[
'd.datefin'][
'checked'])) {
1167 print_liste_field_titre($arrayfields[
'd.datefin'][
'label'], $_SERVER[
"PHP_SELF"],
'd.datefin,t.subscription',
'', $param,
'', $sortfield, $sortorder,
'center ');
1168 $totalarray[
'nbfield']++;
1171include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
1174$parameters = array(
'arrayfields' => $arrayfields,
'totalarray' => &$totalarray,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder);
1175$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
1176print $hookmanager->resPrint;
1178if (!empty($arrayfields[
'd.datec'][
'checked'])) {
1179 print_liste_field_titre($arrayfields[
'd.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"d.datec",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1180 $totalarray[
'nbfield']++;
1182if (!empty($arrayfields[
'd.birth'][
'checked'])) {
1183 print_liste_field_titre($arrayfields[
'd.birth'][
'label'], $_SERVER[
"PHP_SELF"],
"d.birth",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1184 $totalarray[
'nbfield']++;
1186if (!empty($arrayfields[
'd.tms'][
'checked'])) {
1187 print_liste_field_titre($arrayfields[
'd.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"d.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1188 $totalarray[
'nbfield']++;
1190if (!empty($arrayfields[
'd.import_key'][
'checked'])) {
1191 print_liste_field_titre($arrayfields[
'd.import_key'][
'label'], $_SERVER[
"PHP_SELF"],
"d.import_key",
"", $param,
'', $sortfield, $sortorder,
'center ');
1192 $totalarray[
'nbfield']++;
1194if (!empty($arrayfields[
'd.statut'][
'checked'])) {
1195 print_liste_field_titre($arrayfields[
'd.statut'][
'label'], $_SERVER[
"PHP_SELF"],
"d.statut,t.subscription,d.datefin",
"", $param,
'', $sortfield, $sortorder,
'center ');
1196 $totalarray[
'nbfield']++;
1199 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'maxwidthsearch center ');
1200 $totalarray[
'nbfield']++;
1207$savnbfield = $totalarray[
'nbfield'];
1208$totalarray = array();
1209$totalarray[
'nbfield'] = 0;
1210$imaxinloop = ($limit ? min($num, $limit) : $num);
1211while ($i < $imaxinloop) {
1212 $obj = $db->fetch_object($resql);
1217 $datefin = $db->jdate($obj->datefin);
1219 $memberstatic->id = $obj->rowid;
1220 $memberstatic->ref = $obj->ref;
1221 $memberstatic->civility_code = $obj->civility;
1222 $memberstatic->login = $obj->login;
1223 $memberstatic->lastname = $obj->lastname;
1224 $memberstatic->firstname = $obj->firstname;
1225 $memberstatic->gender = $obj->gender;
1226 $memberstatic->status = $obj->status;
1227 $memberstatic->datefin = $datefin;
1228 $memberstatic->socid = $obj->fk_soc;
1229 $memberstatic->photo = $obj->photo;
1230 $memberstatic->email = $obj->email;
1231 $memberstatic->morphy = $obj->morphy;
1232 $memberstatic->note_public = $obj->note_public;
1233 $memberstatic->note_private = $obj->note_private;
1234 $memberstatic->need_subscription = $obj->subscription;
1236 if (!empty($obj->fk_soc)) {
1237 $memberstatic->fetch_thirdparty();
1238 if ($memberstatic->thirdparty->id > 0) {
1239 $companyname = $memberstatic->thirdparty->name;
1240 $companynametoshow = $memberstatic->thirdparty->getNomUrl(1);
1243 $companyname = $obj->company;
1244 $companynametoshow = $obj->company;
1246 $memberstatic->company = $companyname;
1250 if ($mode ==
'kanban') {
1252 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
1253 print
'<div class="box-flex-container kanban">';
1255 $membertypestatic->id = $obj->type_id;
1256 $membertypestatic->label = $obj->type;
1258 $memberstatic->type = $membertypestatic->label;
1259 $memberstatic->photo = $obj->photo;
1262 print $memberstatic->getKanbanView(
'', array(
'selected' => in_array(
$object->id, $arrayofselected)));
1263 if ($i == (min($num, $limit) - 1)) {
1270 print
'<tr data-rowid="'.$object->id.
'" class="oddeven">';
1274 print
'<td class="nowrap center">';
1275 if ($massactionbutton || $massaction) {
1277 if (in_array($obj->rowid, $arrayofselected)) {
1280 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1284 $totalarray[
'nbfield']++;
1288 if (!empty($arrayfields[
'd.rowid'][
'checked'])) {
1289 print
'<td class="center" data-key="id">'.$obj->rowid.
'</td>';
1291 $totalarray[
'nbfield']++;
1295 if (!empty($arrayfields[
'd.ref'][
'checked'])) {
1297 print $memberstatic->getNomUrl(-1, 0,
'card',
'ref',
'', -1, 0, 1);
1300 $totalarray[
'nbfield']++;
1304 if (!empty($arrayfields[
'd.civility'][
'checked'])) {
1309 $totalarray[
'nbfield']++;
1313 if (!empty($arrayfields[
'd.firstname'][
'checked'])) {
1314 print
'<td class="tdoverflowmax125" title="'.dol_escape_htmltag($obj->firstname).
'">';
1315 print $memberstatic->getNomUrl(0, 0,
'card',
'firstname');
1319 $totalarray[
'nbfield']++;
1323 if (!empty($arrayfields[
'd.lastname'][
'checked'])) {
1324 print
'<td class="tdoverflowmax125" title="'.dol_escape_htmltag($obj->lastname).
'">';
1325 print $memberstatic->getNomUrl(0, 0,
'card',
'lastname');
1329 $totalarray[
'nbfield']++;
1333 if (!empty($arrayfields[
'd.gender'][
'checked'])) {
1336 print $langs->trans(
"Gender".$obj->gender);
1340 $totalarray[
'nbfield']++;
1344 if (!empty($arrayfields[
'd.company'][
'checked'])) {
1345 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($companyname).
'">';
1346 print $companynametoshow;
1350 if (!empty($arrayfields[
'd.login'][
'checked'])) {
1351 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($obj->login).
'">'.$obj->login.
"</td>\n";
1353 $totalarray[
'nbfield']++;
1357 if (!empty($arrayfields[
'd.morphy'][
'checked'])) {
1358 print
'<td class="center">';
1359 print $memberstatic->getmorphylib(
'', 2);
1362 $totalarray[
'nbfield']++;
1366 if (!empty($arrayfields[
't.libelle'][
'checked'])) {
1367 $membertypestatic->id = $obj->type_id;
1368 $membertypestatic->label = $obj->type;
1369 print
'<td class="nowraponall">';
1370 print $membertypestatic->getNomUrl(1, 32);
1373 $totalarray[
'nbfield']++;
1377 if (!empty($arrayfields[
'd.address'][
'checked'])) {
1378 print
'<td class="nocellnopadd tdoverflowmax200" title="'.dol_escape_htmltag($obj->address).
'">';
1382 $totalarray[
'nbfield']++;
1386 if (!empty($arrayfields[
'd.zip'][
'checked'])) {
1387 print
'<td class="nocellnopadd">';
1391 $totalarray[
'nbfield']++;
1395 if (!empty($arrayfields[
'd.town'][
'checked'])) {
1396 print
'<td class="nocellnopadd">';
1400 $totalarray[
'nbfield']++;
1404 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1409 $totalarray[
'nbfield']++;
1413 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1414 $tmparray =
getCountry($obj->country,
'all');
1415 print
'<td class="center tdoverflowmax100" title="'.dol_escape_htmltag($tmparray[
'label']).
'">';
1419 $totalarray[
'nbfield']++;
1423 if (!empty($arrayfields[
'd.phone'][
'checked'])) {
1424 print
'<td class="nocellnopadd">';
1428 $totalarray[
'nbfield']++;
1432 if (!empty($arrayfields[
'd.phone_perso'][
'checked'])) {
1433 print
'<td class="nocellnopadd">';
1437 $totalarray[
'nbfield']++;
1441 if (!empty($arrayfields[
'd.phone_mobile'][
'checked'])) {
1442 print
'<td class="nocellnopadd">';
1446 $totalarray[
'nbfield']++;
1450 if (!empty($arrayfields[
'd.email'][
'checked'])) {
1451 print
'<td class="tdoverflowmax150" title="'.dol_escape_htmltag($obj->email).
'">';
1455 $totalarray[
'nbfield']++;
1459 $datefin = $db->jdate($obj->datefin);
1460 if (!empty($arrayfields[
'd.datefin'][
'checked'])) {
1464 if ($memberstatic->hasDelay()) {
1465 $textlate =
' ('.$langs->trans(
"DateReference").
' > '.$langs->trans(
"DateToday").
' '.(ceil($conf->adherent->subscription->warning_delay / 60 / 60 / 24) >= 0 ?
'+' :
'').ceil($conf->adherent->subscription->warning_delay / 60 / 60 / 24).
' '.$langs->trans(
"days").
')';
1466 $s .=
" ".img_warning($langs->trans(
"SubscriptionLate").$textlate);
1469 if (!empty($obj->subscription)) {
1470 $s .=
'<span class="opacitymedium">'.$langs->trans(
"SubscriptionNotReceived").
'</span>';
1471 if ($obj->status > 0) {
1472 $s .=
" ".img_warning();
1475 $s .=
'<span class="opacitymedium">'.$langs->trans(
"SubscriptionNotNeeded").
'</span>';
1478 print
'<td class="nowraponall center tdoverflowmax150" title="'.dolPrintHTMLForAttribute(
dol_string_nohtmltag($s)).
'">';
1482 $totalarray[
'nbfield']++;
1486 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1488 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &$totalarray);
1489 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
1490 print $hookmanager->resPrint;
1492 if (!empty($arrayfields[
'd.datec'][
'checked'])) {
1493 print
'<td class="nowrap center">';
1494 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuser');
1497 $totalarray[
'nbfield']++;
1501 if (!empty($arrayfields[
'd.birth'][
'checked'])) {
1502 print
'<td class="nowrap center">';
1506 $totalarray[
'nbfield']++;
1510 if (!empty($arrayfields[
'd.tms'][
'checked'])) {
1511 print
'<td class="nowrap center">';
1512 print
dol_print_date($db->jdate($obj->date_modification),
'dayhour',
'tzuser');
1515 $totalarray[
'nbfield']++;
1519 if (!empty($arrayfields[
'd.import_key'][
'checked'])) {
1520 print
'<td class="tdoverflowmax100 center" title="'.dol_escape_htmltag($obj->import_key).
'">';
1524 $totalarray[
'nbfield']++;
1528 if (!empty($arrayfields[
'd.statut'][
'checked'])) {
1529 print
'<td class="nowrap center">';
1530 print $memberstatic->LibStatut($obj->status, $obj->subscription, $datefin, 5);
1533 $totalarray[
'nbfield']++;
1538 print
'<td class="center">';
1539 if ($massactionbutton || $massaction) {
1541 if (in_array($obj->rowid, $arrayofselected)) {
1544 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1548 $totalarray[
'nbfield']++;
1558include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
1564 foreach ($arrayfields as $key => $val) {
1565 if (!empty($val[
'checked'])) {
1569 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
1574$parameters = array(
'arrayfields' => $arrayfields,
'sql' => $sql);
1575$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters, $object, $action);
1576print $hookmanager->resPrint;
1578print
'</table>'.
"\n";
1581print
'</form>'.
"\n";
1583if (in_array(
'builddoc', array_keys($arrayofmassactions)) && ($nbtotalofrecords ===
'' || $nbtotalofrecords)) {
1584 $hidegeneratedfilelistifempty = 1;
1585 if ($massaction ==
'builddoc' || $action ==
'remove_file' || $show_files) {
1586 $hidegeneratedfilelistifempty = 0;
1589 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
1593 $urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
1594 $urlsource .= str_replace(
'&',
'&', $param);
1596 $filedir = $diroutputmassaction;
1597 $genallowed = $permissiontoread;
1598 $delallowed = $permissiontoadd;
1600 print $formfile->showdocuments(
'massfilesarea_'.
$object->module,
'', $filedir, $urlsource, 0, $delallowed,
'', 1, 1, 0, 48, 1, $param, $title,
'',
'',
'',
null, $hidegeneratedfilelistifempty);
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Class to manage members of a foundation.
const STATUS_EXCLUDED
Excluded.
const STATUS_DRAFT
Draft status.
const STATUS_RESILIATED
Resiliated.
const STATUS_VALIDATED
Validated status.
Class to manage members type.
Class to manage Dolibarr users.
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
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...
dol_print_phone($phone, $countrycode='', $cid=0, $socid=0, $addlink='', $separ=" ", $withpicto='', $titlealt='', $adddivfloat=0, $morecss='')
Format phone numbers according to country.
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_string_nohtmltag($stringtoclean, $removelinefeed=1, $pagecodeto='UTF-8', $strip_tags=0, $removedoublespaces=1)
Clean a string from all HTML tags and entities.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
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.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
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.
dol_print_email($email, $cid=0, $socid=0, $addlink=0, $max=64, $showinvalid=1, $withpicto=0)
Show EMail link formatted for HTML output.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
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...
dol_clone($object, $native=0)
Create a clone of instance of object (new instance with same value for each properties) With native =...
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $hideselectlimit=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0)
Set event messages in dol_events session object.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.