dd/de9/public__list_8php_source.html

 <?php

 /* Copyright (C) 2001-2003  Rodolphe Quiedeville  <rodolphe@quiedeville.org>

  * Copyright (C) 2002-2003  Jean-Louis Bergamo    <jlb@j1b.org>

  * Copyright (C) 2004-2009  Laurent Destailleur   <eldy@users.sourceforge.net>

  * Copyright (C) 2012   Regis Houssin     <regis.houssin@inodbox.com>

  *

  * This program is free software; you can redistribute it and/or modify

  * it under the terms of the GNU General Public License as published by

  * the Free Software Foundation; either version 3 of the License, or

  * (at your option) any later version.

  *

  * This program is distributed in the hope that it will be useful,

  * but WITHOUT ANY WARRANTY; without even the implied warranty of

  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

  * GNU General Public License for more details.

  *

  * You should have received a copy of the GNU General Public License

  * along with this program. If not, see <https://www.gnu.org/licenses/>.

  */


 if (!defined('NOLOGIN')) {

   define("NOLOGIN", 1); // This means this output page does not require to be logged.

 }

 if (!defined('NOCSRFCHECK')) {

   define("NOCSRFCHECK", 1); // We accept to go on this page from external web site.

 }

 if (!defined('NOIPCHECK')) {

   define('NOIPCHECK', '1'); // Do not check IP defined into conf $dolibarr_main_restrict_ip

 }

 if (!defined('NOBROWSERNOTIF')) {

   define('NOBROWSERNOTIF', '1');

 }


 // For MultiCompany module.

 // Do not use GETPOST here, function is not defined and define must be done before including main.inc.php

 // TODO This should be useless. Because entity must be retrieve from object ref and not from url.

 $entity = (!empty($_GET['entity']) ? (int) $_GET['entity'] : (!empty($_POST['entity']) ? (int) $_POST['entity'] : 1));

 if (is_numeric($entity)) {

   define("DOLENTITY", $entity);

 }


 // Load Dolibarr environment

 require '../../main.inc.php';


 // Security check

 if (!isModEnabled('adherent')) {

   httponly_accessforbidden('Module Membership not enabled');

 }


 $langs->loadLangs(array("main", "members", "companies", "other"));


 function llxHeaderVierge($title, $head = "")

 {

   top_htmlhead($head, $title);


   print '<body class="public_body">'."\n";

 }


 function llxFooterVierge()

 {

   printCommonFooter('public');


   print "</body>\n";

   print "</html>\n";

 }


 $sortfield = GETPOST('sortfield', 'aZ09comma');

 $sortorder = GETPOST('sortorder', 'aZ09comma');

 $limit = GETPOST('limit', 'int') ?GETPOST('limit', 'int') : $conf->liste_limit;

 $page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');

 if (empty($page) || $page == -1) {

   $page = 0;

 }     // If $page is not defined, or '' or -1

 $offset = $limit * $page;

 $pageprev = $page - 1;

 $pagenext = $page + 1;


 $filter = GETPOST('filter');

 $statut = GETPOST('statut');


 if (!$sortorder) {

   $sortorder = "ASC";

 }

 if (!$sortfield) {

   $sortfield = "lastname";

 }


 /*

  * View

  */


 if (empty($conf->global->MEMBER_PUBLIC_ENABLED)) {

   httponly_accessforbidden('Public access of list of members is not enabled');

 }


 $form = new Form($db);


 $morehead = '';

 if (!empty($conf->global->MEMBER_PUBLIC_CSS)) {

   $morehead = '<link rel="stylesheet" type="text/css" href="'.$conf->global->MEMBER_PUBLIC_CSS.'">';

 } else {

   $morehead = '<link rel="stylesheet" type="text/css" href="'.DOL_URL_ROOT.'/theme/eldy/style.css.php">';

 }


 llxHeaderVierge($langs->trans("ListOfValidatedPublicMembers"), $morehead);


 $sql = "SELECT rowid, firstname, lastname, societe, zip, town, email, birth, photo";

 $sql .= " FROM ".MAIN_DB_PREFIX."adherent";

 $sql .= " WHERE entity = ".((int) $entity);

 $sql .= " AND statut = 1";

 $sql .= " AND public = 1";

 $sql .= $db->order($sortfield, $sortorder);

 $sql .= $db->plimit($conf->liste_limit + 1, $offset);

 //$sql = "SELECT d.rowid, d.firstname, d.lastname, d.societe, zip, town, d.email, t.libelle as type, d.morphy, d.statut, t.subscription";

 //$sql .= " FROM ".MAIN_DB_PREFIX."adherent as d, ".MAIN_DB_PREFIX."adherent_type as t";

 //$sql .= " WHERE d.fk_adherent_type = t.rowid AND d.statut = $statut";

 //$sql .= " ORDER BY $sortfield $sortorder " . $db->plimit($conf->liste_limit, $offset);


 $result = $db->query($sql);

 if ($result) {

   $num = $db->num_rows($result);

   $i = 0;


   $param = "&statut=$statut&sortorder=$sortorder&sortfield=$sortfield";

   print_barre_liste($langs->trans("ListOfValidatedPublicMembers"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, 0, '');

   print '<table class="public_border centpercent">';


   print '<tr class="public_liste_titre">';

   print '<th class="left"><a href="'.$_SERVER["PHP_SELF"].'?page='.$page.'&sortorder=ASC&sortfield=firstname">'.dolGetFirstLastname($langs->trans("Firstname"), $langs->trans("Lastname")).'</a></th>';

   print '<th class="left"><a href="'.$_SERVER["PHP_SELF"].'?page='.$page.'&sortorder=ASC&sortfield=societe">'.$langs->trans("Company").'</a></th>'."\n";

   //print_liste_field_titre("DateOfBirth", $_SERVER["PHP_SELF"],"birth",'',$param,$sortfield,$sortorder); // est-ce nécessaire ??

   print_liste_field_titre("EMail", $_SERVER["PHP_SELF"], "email", '', $param, '', $sortfield, $sortorder, 'left public_');

   print_liste_field_titre("Zip", $_SERVER["PHP_SELF"], "zip", "", $param, '', $sortfield, $sortorder, 'left public_');

   print_liste_field_titre("Town", $_SERVER["PHP_SELF"], "town", "", $param, '', $sortfield, $sortorder, 'left public_');

   print_liste_field_titre("Photo", $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'center public_');

   print "</tr>\n";


   while ($i < $num && $i < $conf->liste_limit) {

     $objp = $db->fetch_object($result);


     print '<tr class="oddeven">';

     print '<td><a href="public_card.php?id='.$objp->rowid.'">'.dolGetFirstLastname($objp->firstname, $objp->lastname).'</a></td>'."\n";

     print '<td>'.$objp->societe.'</td>'."\n";

     print '<td>'.$objp->email.'</td>'."\n";

     print '<td>'.$objp->zip.'</td>'."\n";

     print '<td>'.$objp->town.'</td>'."\n";

     if (isset($objp->photo) && $objp->photo != '') {

       print '<td class="center">';

       print $form->showphoto('memberphoto', $objp, 64);

       print '</td>'."\n";

     } else {

       print "<td>&nbsp;</td>\n";

     }

     print "</tr>";

     $i++;

   }

   print "</table>";

 } else {

   dol_print_error($db);

 }


 llxFooterVierge();


 $db->close();

Form
Class to manage generation of HTML components Only common components must be here.
Definition: html.form.class.php:54

$sql
if(isModEnabled('facture') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&empty($conf->global->MAIN_USE_NEW_SUPPLIERMOD) && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') &&!empty($user->rights->tax->charges->lire)) if(isModEnabled('facture') &&isModEnabled('commande') && $user->hasRight("commande", "lire") &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) $sql
Social contributions to pay.
Definition: index.php:746

$form
if($cancel &&! $id) if($action=='add' &&! $cancel) if($action=='delete') if($id) $form
Actions.
Definition: card.php:143

dol_print_error
dol_print_error($db='', $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
Definition: functions.lib.php:5107

printCommonFooter
printCommonFooter($zone='private')
Print common footer : conf->global->MAIN_HTML_FOOTER js for switch of menu hider js for conf->global-...
Definition: functions.lib.php:9740

dolGetFirstLastname
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.
Definition: functions.lib.php:8590

print_liste_field_titre
print_liste_field_titre($name, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
Definition: functions.lib.php:5295

GETPOST
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
Definition: functions.lib.php:609

print_barre_liste
print_barre_liste($titre, $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.
Definition: functions.lib.php:5530

GETPOSTISSET
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
Definition: functions.lib.php:509

isModEnabled
isModEnabled($module)
Is Dolibarr module enabled.
Definition: functions.lib.php:207

top_htmlhead
top_htmlhead($head, $title='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $disableforlogin=0, $disablenofollow=0, $disablenoindex=0)
Ouput html header of a page.
Definition: main.inc.php:1625

llxFooterVierge
llxFooterVierge()
Show footer for member list.
Definition: public_list.php:78

llxHeaderVierge
llxHeaderVierge($title, $head="")
Show header for member list.
Definition: public_list.php:66

httponly_accessforbidden
httponly_accessforbidden($message=1, $http_response_code=403, $stringalreadysanitized=0)
Show a message to say access is forbidden and stop program.
Definition: security.lib.php:1142