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

// Because 2 entities can have the same ref.

$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('member')) {

  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 = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;

$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");

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 (!getDolGlobalString('MEMBER_PUBLIC_ENABLED')) {

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

}


$form = new Form($db);


$morehead = '';

if (getDolGlobalString('MEMBER_PUBLIC_CSS')) {

  $morehead = '<link rel="stylesheet" type="text/css" href="' . getDolGlobalString('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";


$sqlfields = $sql;


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

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

$sql .= " AND statut = 1";

$sql .= " AND public = 1";


// Count total nb of records

$nbtotalofrecords = '';

if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {

  /* The fast and low memory method to get and count full list converts the sql into a sql count */

  $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);

  $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);


  $resql = $db->query($sqlforcount);

  if ($resql) {

    $objforcount = $db->fetch_object($resql);

    $nbtotalofrecords = $objforcount->nbtotalofrecords;

  } else {

    dol_print_error($db);

  }


  if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0

    $page = 0;

    $offset = 0;

  }

  $db->free($resql);

}


$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";

  $title = $langs->trans("ListOfValidatedPublicMembers");

  print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $nbtotalofrecords, '');

  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();

llxHeaderVierge
if(!defined( 'NOTOKENRENEWAL')) if(!defined('NOREQUIREMENU')) if(!defined( 'NOREQUIREHTML')) if(!defined('NOREQUIREAJAX')) if(!defined( 'NOLOGIN')) if(!defined('NOCSRFCHECK')) if(!defined( 'NOIPCHECK')) llxHeaderVierge()
Header function.
Definition agendaexport.php:62

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

GETPOSTINT
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
Definition functions.lib.php:1093

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:11096

getDolGlobalInt
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
Definition functions.lib.php:230

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

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:6142

print_barre_liste
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.
Definition functions.lib.php:6377

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:768

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

getDolGlobalString
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
Definition functions.lib.php:215

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

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

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:1184