27if (!defined(
'NOLOGIN')) {
30if (!defined(
'NOCSRFCHECK')) {
31 define(
"NOCSRFCHECK", 1);
33if (!defined(
'NOIPCHECK')) {
34 define(
'NOIPCHECK',
'1');
36if (!defined(
'NOBROWSERNOTIF')) {
37 define(
'NOBROWSERNOTIF',
'1');
43$entity = (!empty($_GET[
'entity']) ? (int) $_GET[
'entity'] : (!empty($_POST[
'entity']) ? (int) $_POST[
'entity'] : 1));
44if (is_numeric($entity)) {
45 define(
"DOLENTITY", $entity);
49require
'../../main.inc.php';
52if (!isModEnabled(
'member')) {
56$langs->loadLangs(array(
"main",
"members",
"companies",
"other"));
70 print
'<body class="public_body">'.
"\n";
87$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
88$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
91if (empty($page) || $page == -1) {
94$offset = $limit * $page;
105 $sortfield =
"lastname";
117$form =
new Form($db);
121 $morehead =
'<link rel="stylesheet" type="text/css" href="' .
getDolGlobalString(
'MEMBER_PUBLIC_CSS').
'">';
123 $morehead =
'<link rel="stylesheet" type="text/css" href="'.DOL_URL_ROOT.
'/theme/eldy/style.css.php">';
126llxHeaderVierge($langs->trans(
"ListOfValidatedPublicMembers"), $morehead);
128$sql =
"SELECT rowid, firstname, lastname, societe, zip, town, email, birth, photo";
132$sql .=
" FROM ".MAIN_DB_PREFIX.
"adherent";
133$sql .=
" WHERE entity = ".((int) $entity);
134$sql .=
" AND statut = 1";
135$sql .=
" AND public = 1";
138$nbtotalofrecords =
'';
141 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
142 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
144 $resql = $db->query($sqlforcount);
146 $objforcount = $db->fetch_object($resql);
147 $nbtotalofrecords = $objforcount->nbtotalofrecords;
152 if (($page * $limit) > $nbtotalofrecords) {
159$sql .= $db->order($sortfield, $sortorder);
160$sql .= $db->plimit($conf->liste_limit + 1, $offset);
167$result = $db->query($sql);
169 $num = $db->num_rows($result);
172 $param =
"&statut=$statut&sortorder=$sortorder&sortfield=$sortfield";
173 $title = $langs->trans(
"ListOfValidatedPublicMembers");
174 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder,
'', $num, $nbtotalofrecords,
'');
175 print
'<table class="public_border centpercent">';
177 print
'<tr class="public_liste_titre">';
178 print
'<th class="left"><a href="'.$_SERVER[
"PHP_SELF"].
'?page='.$page.
'&sortorder=ASC&sortfield=firstname">'.
dolGetFirstLastname($langs->trans(
"Firstname"), $langs->trans(
"Lastname")).
'</a></th>';
179 print
'<th class="left"><a href="'.$_SERVER[
"PHP_SELF"].
'?page='.$page.
'&sortorder=ASC&sortfield=societe">'.$langs->trans(
"Company").
'</a></th>'.
"\n";
181 print_liste_field_titre(
"EMail", $_SERVER[
"PHP_SELF"],
"email",
'', $param,
'', $sortfield, $sortorder,
'left public_');
182 print_liste_field_titre(
"Zip", $_SERVER[
"PHP_SELF"],
"zip",
"", $param,
'', $sortfield, $sortorder,
'left public_');
183 print_liste_field_titre(
"Town", $_SERVER[
"PHP_SELF"],
"town",
"", $param,
'', $sortfield, $sortorder,
'left public_');
184 print_liste_field_titre(
"Photo", $_SERVER[
"PHP_SELF"],
"",
"", $param,
'', $sortfield, $sortorder,
'center public_');
187 while ($i < $num && $i < $conf->liste_limit) {
188 $objp = $db->fetch_object($result);
190 print
'<tr class="oddeven">';
191 print
'<td><a href="public_card.php?id='.$objp->rowid.
'">'.
dolGetFirstLastname($objp->firstname, $objp->lastname).
'</a></td>'.
"\n";
192 print
'<td>'.$objp->societe.
'</td>'.
"\n";
193 print
'<td>'.$objp->email.
'</td>'.
"\n";
194 print
'<td>'.$objp->zip.
'</td>'.
"\n";
195 print
'<td>'.$objp->town.
'</td>'.
"\n";
196 if (isset($objp->photo) && $objp->photo !=
'') {
197 print
'<td class="center">';
198 print $form->showphoto(
'memberphoto', $objp, 64);
201 print
"<td> </td>\n";
if(!defined( 'NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined( 'NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) if(!defined( 'NOLOGIN')) if(!defined('NOCSRFCHECK')) if(!defined( 'NOIPCHECK')) llxHeaderVierge()
Header function.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
printCommonFooter($zone='private')
Print common footer : conf->global->MAIN_HTML_FOOTER js for switch of menu hider js for conf->global-...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
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.
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 a Dolibarr global constant string value.
top_htmlhead($head, $title='', $disablejs=0, $disablehead=0, $arrayofjs=array(), $arrayofcss=array(), $disableforlogin=0, $disablenofollow=0, $disablenoindex=0)
Output html header of a page.
llxFooterVierge()
Show footer for member list.
httponly_accessforbidden($message='1', $http_response_code=403, $stringalreadysanitized=0)
Show a message to say access is forbidden and stop program.