modules/xnetevents.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2006 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 define('NB_PER_PAGE', 25);
  23
  24 class XnetEventsModule extends PLModule
  25 {
  26     function handlers()
  27     {
  28         return array(
  29             '%grp/events'       => $this->make_hook('events',  AUTH_MDP),
  30             '%grp/events/sub'   => $this->make_hook('sub',     AUTH_MDP),
  31             '%grp/events/csv'   => $this->make_hook('csv',     AUTH_MDP),
  32             '%grp/events/ical'  => $this->make_hook('ical',    AUTH_MDP),
  33             '%grp/events/edit'  => $this->make_hook('edit',    AUTH_MDP),
  34             '%grp/events/admin' => $this->make_hook('admin',   AUTH_MDP),
  35         );
  36     }
  37
  38     function handler_events(&$page, $archive = null)
  39     {
  40         global $globals;
  41
  42         if ($archive == 'archive') {
  43             $archive = true;
  44             new_groupadmin_page('xnetevents/index.tpl');
  45         } else {
  46             $archive = false;
  47             new_group_open_page('xnetevents/index.tpl');
  48         }
  49
  50         $action = null;
  51         if (Post::has('del')) {
  52             $action = 'del';
  53             $eid = Post::v('del');
  54         } elseif (Post::has('archive')) {
  55             $action = 'archive';
  56             $eid = Post::v('archive');
  57         } elseif (Post::has('unarchive')) {
  58             $action = 'unarchive';
  59             $eid = Post::v('unarchive');
  60         }
  61
  62         if (!is_null($action)) {
  63             if (!may_update()) {
  64                 return PL_FORBIDDEN;
  65             }
  66
  67             $res = XDB::query("SELECT asso_id, short_name FROM groupex.evenements
  68                                 WHERE eid = {?} AND asso_id = {?}",
  69                               $eid, $globals->asso('id'));
  70
  71             $tmp = $res->fetchOneRow();
  72             if (!$tmp) {
  73                 return PL_FORBIDDEN;
  74             }
  75         }
  76
  77         if ($action == 'del') {
  78             // deletes the event mailing aliases
  79             if ($tmp[1]) {
  80                 XDB::execute(
  81                     "DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
  82                     $tmp[1].'-absents@%');
  83                 XDB::execute(
  84                     "DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
  85                     $tmp[1].'-participants@%');
  86             }
  87
  88             // deletes the event items
  89             XDB::execute("DELETE FROM groupex.evenements_items WHERE eid = {?}", $eid);
  90
  91             // deletes the event participants
  92             XDB::execute("DELETE FROM groupex.evenements_participants
  93                                     WHERE eid = {?}", $eid);
  94
  95             // deletes the event
  96             XDB::execute("DELETE FROM groupex.evenements
  97                                     WHERE eid = {?} AND asso_id = {?}",
  98                                    $eid, $globals->asso('id'));
  99
 100             // delete the requests for payments
 101             require_once 'validations.inc.php';
 102             XDB::execute("DELETE FROM requests
 103                                     WHERE type = 'paiements' AND data LIKE {?}",
 104                                    PayReq::same_event($eid, $globals->asso('id')));
 105         }
 106
 107         if ($action == 'archive') {
 108             XDB::execute("UPDATE groupex.evenements
 109                              SET archive = 1
 110                            WHERE eid = {?} AND asso_id = {?}",
 111                          $eid, $globals->asso('id'));
 112         }
 113
 114         if ($action == 'unarchive') {
 115             XDB::execute("UPDATE groupex.evenements
 116                              SET archive = 0
 117                            WHERE eid = {?} AND asso_id = {?}",
 118                          $eid, $globals->asso('id'));
 119         }
 120
 121         $page->assign('archive', $archive);
 122         $page->assign('admin', may_update());
 123
 124         $evenements = XDB::iterator(
 125                 "SELECT  e.*, LEFT(10, e.debut) AS debut_day, LEFT(10, e.fin) AS fin_day,
 126                          IF(e.deadline_inscription, e.deadline_inscription >= LEFT(NOW(), 10),
 127                             1) AS inscr_open, e.deadline_inscription,
 128                          u.nom, u.prenom, u.promo, a.alias,
 129                          MAX(ep.nb) AS inscrit, MAX(ep.paid) AS paid
 130                   FROM  groupex.evenements  AS e
 131             INNER JOIN  x4dat.auth_user_md5 AS u ON u.user_id = e.organisateur_uid
 132             INNER JOIN  x4dat.aliases       AS a ON (a.type = 'a_vie' AND a.id = u.user_id)
 133              LEFT JOIN  groupex.evenements_participants AS ep ON (ep.eid = e.eid AND ep.uid = {?})
 134                  WHERE  asso_id = {?}
 135                    AND  archive = " . ($archive ? "1 " : "0 ")
 136             . (is_member() || may_update() ? "" : " AND accept_nonmembre != 0 ")
 137               . "GROUP BY  e.eid
 138                  ORDER BY  inscr_open DESC, debut DESC", S::v('uid'), $globals->asso('id'));
 139
 140         $evts = array();
 141
 142         while ($e = $evenements->next()) {
 143             $e['show_participants'] = ($e['show_participants'] && (is_member() || may_update()));
 144             $res = XDB::query(
 145                 "SELECT titre, details, montant, ei.item_id, nb
 146                    FROM groupex.evenements_items AS ei
 147               LEFT JOIN groupex.evenements_participants AS ep
 148                         ON (ep.eid = ei.eid AND ep.item_id = ei.item_id AND uid = {?})
 149                   WHERE ei.eid = {?}",
 150                     S::v('uid'), $e['eid']);
 151             $e['moments'] = $res->fetchAllAssoc();
 152
 153             $e['topay'] = 0;
 154             foreach ($e['moments'] as $m) {
 155                 $e['topay'] += $m['nb'] * $m['montant'];
 156             }
 157
 158             $query = XDB::query(
 159                 "SELECT montant
 160                    FROM {$globals->money->mpay_tprefix}transactions AS t
 161                  WHERE ref = {?} AND uid = {?}", $e['paiement_id'], S::v('uid'));
 162             $montants = $query->fetchColumn();
 163
 164             foreach ($montants as $m) {
 165                 $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
 166                 $e['paid'] += trim($p);
 167             }
 168
 169             if (Env::has('updated') && $e['eid'] == Env::i('updated')) {
 170                 $page->assign('updated', $e);
 171             }
 172             $evts[] = $e;
 173         }
 174
 175         $page->assign('evenements', $evts);
 176         $page->assign('is_member', is_member());
 177     }
 178
 179     function handler_sub(&$page, $eid = null)
 180     {
 181         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 182
 183         new_group_open_page('xnetevents/subscribe.tpl');
 184
 185         $evt = get_event_detail($eid);
 186         if (!$evt) {
 187             return PL_NOT_FOUND;
 188         }
 189
 190         if (!$evt['inscr_open']) {
 191             $page->kill('Les inscriptions pour cet événement sont closes');
 192         }
 193         if (!$evt['accept_nonmembre'] && !is_member() && !may_update()) {
 194             $page->kill('Cet événement est fermé aux non-membres du groupe');
 195         }
 196
 197         $page->assign('event', $evt);
 198
 199         if (!Post::has('submit')) {
 200             return;
 201         }
 202
 203         $moments = Post::v('moment',    array());
 204         $pers    = Post::v('personnes', array());
 205         $subs    = array();
 206
 207         foreach ($moments as $j => $v) {
 208             $subs[$j] = intval($v);
 209
 210             // retreive ohter field when more than one person
 211             if ($subs[$j] == 2) {
 212                 if (!isset($pers[$j]) || !is_numeric($pers[$j])
 213                 ||  $pers[$j] < 0)
 214                 {
 215                     $page->trig('Tu dois choisir un nombre d\'invités correct !');
 216                     return;
 217                 }
 218                 $subs[$j] = 1 + $pers[$j];
 219             }
 220         }
 221
 222         // impossible to unsubscribe if you already paid sthing
 223         if (array_sum($subs) && $evt['paid'] != 0) {
 224             $page->trig("Impossible de te désinscrire complètement ".
 225                         "parce que tu as fait un paiement par ".
 226                         "chèque ou par liquide. Contacte un ".
 227                         "administrateur du groupe si tu es sûr de ".
 228                         "ne pas venir");
 229             return;
 230         }
 231
 232         // update actual inscriptions
 233         $updated = false;
 234         foreach ($subs as $j => $nb) {
 235             if ($nb > 0) {
 236                 XDB::execute(
 237                     "REPLACE INTO  groupex.evenements_participants
 238                            VALUES  ({?}, {?}, {?}, {?}, {?})",
 239                     $eid, S::v('uid'), $j, $nb, $evt['paid']);
 240                 $updated = $eid;
 241             } else {
 242                 XDB::execute(
 243                     "DELETE FROM  groupex.evenements_participants
 244                            WHERE  eid = {?} AND uid = {?} AND item_id = {?}",
 245                     $eid, S::v("uid"), $j);
 246                 $updated = $eid;
 247             }
 248         }
 249         if ($updated !== false) {
 250                 pl_redirect('events?updated='.$updated);
 251         }
 252         $page->assign('event', get_event_detail($eid));
 253     }
 254
 255     function handler_csv(&$page, $eid = null, $item_id = null)
 256     {
 257         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 258
 259         if (!is_numeric($item_id)) {
 260             $item_id = null;
 261         }
 262
 263         $evt = get_event_detail($eid, $item_id);
 264         if (!$evt) {
 265             return PL_NOT_FOUND;
 266         }
 267
 268         header('Content-type: text/x-csv; encoding=iso-8859-1');
 269         header('Pragma: ');
 270         header('Cache-Control: ');
 271
 272         $page->changeTpl('xnetevents/csv.tpl', NO_SKIN);
 273
 274         $admin = may_update();
 275
 276         $tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
 277
 278         $page->assign('participants',
 279                       get_event_participants($evt, $item_id, $tri));
 280
 281         $page->assign('admin', $admin);
 282         $page->assign('moments', $evt['moments']);
 283         $page->assign('money', $evt['money']);
 284         $page->assign('tout', !Env::v('item_id', false));
 285     }
 286
 287     function handler_ical(&$page, $eid = null)
 288     {
 289         global $globals;
 290
 291         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 292         $evt = get_event_detail($eid);
 293         if (!$evt) {
 294             return PL_FORBIDDEN;
 295         }
 296         $evt['debut'] = preg_replace('/(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)/', "\\1\\2\\3T\\4\\5\\6", $evt['debut']);
 297         $evt['fin'] = preg_replace('/(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)/', "\\1\\2\\3T\\4\\5\\6", $evt['fin']);
 298
 299         foreach ($evt['moments'] as $m) {
 300             $evt['descriptif'] .= "\n\n** " . $m['titre'] . " **\n" . $m['details'];
 301         }
 302
 303         $page->changeTpl('xnetevents/calendar.tpl', NO_SKIN);
 304
 305         require_once('ical.inc.php');
 306         $page->assign('asso', $globals->asso());
 307         $page->assign('timestamp', time());
 308         $page->assign('admin', may_update());
 309
 310         if (may_update()) {
 311             $page->assign('participants', get_event_participants($evt, null, 'promo, nom, prenom'));
 312         }
 313         $page->register_function('display_ical', 'display_ical');
 314         $page->assign_by_ref('e', $evt);
 315
 316         header('Content-Type: text/calendar; charset=utf-8');
 317     }
 318
 319     function handler_edit(&$page, $eid = null)
 320     {
 321         global $globals;
 322
 323         // get eid if the the given one is a short name
 324         if (!is_null($eid) && !is_numeric($eid)) {
 325             $res = XDB::query("SELECT eid
 326                                  FROM groupex.evenements
 327                                 WHERE asso_id = {?} AND short_name = {?}",
 328                               $globals->asso('id'), $eid);
 329             if ($res->numRows()) {
 330                 $eid = (int)$res->fetchOneCell();
 331             }
 332         }
 333
 334         // check the event is in our group
 335         if (!is_null($eid)) {
 336             $res = XDB::query("SELECT short_name
 337                                  FROM groupex.evenements
 338                                 WHERE eid = {?} AND asso_id = {?}",
 339                               $eid, $globals->asso('id'));
 340             if ($res->numRows()) {
 341                 $infos = $res->fetchOneAssoc();
 342             } else {
 343                 return PL_FORBIDDEN;
 344             }
 345         }
 346
 347         new_groupadmin_page('xnetevents/edit.tpl');
 348
 349         $moments = range(1, 4);
 350         $page->assign('moments', $moments);
 351
 352         if (Post::v('intitule')) {
 353             require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 354             $short_name = event_change_shortname($page, $infos['short_name'],
 355                                                  Env::v('short_name', ''));
 356
 357             $evt = array(
 358                 'eid'              => $eid,
 359                 'asso_id'          => $globals->asso('id'),
 360                 'paiement_id'      => Post::v('paiement_id') > 0 ? Post::v('paiement_id') : null,
 361                 'debut'            => Post::v('deb_Year').'-'.Post::v('deb_Month')
 362                                       .'-'.Post::v('deb_Day').' '.Post::v('deb_Hour')
 363                                       .':'.Post::v('deb_Minute').':00',
 364                 'fin'              => Post::v('fin_Year').'-'.Post::v('fin_Month')
 365                                       .'-'.Post::v('fin_Day').' '.Post::v('fin_Hour')
 366                                       .':'.Post::v('fin_Minute').':00',
 367                 'short_name'       => $short_name,
 368             );
 369
 370             $trivial = array('intitule', 'descriptif', 'noinvite',
 371                              'show_participants', 'accept_nonmembre', 'organisateur_uid');
 372             foreach ($trivial as $k) {
 373                 $evt[$k] = Post::v($k);
 374             }
 375             if (!$eid) {
 376                 $evt['organisateur_uid'] = S::v('uid');
 377             }
 378
 379             if (Post::v('deadline')) {
 380                 $evt['deadline_inscription'] = Post::v('inscr_Year').'-'
 381                                              . Post::v('inscr_Month').'-'
 382                                              . Post::v('inscr_Day');
 383             } else {
 384                 $evt['deadline_inscription'] = null;
 385             }
 386
 387             // Store the modifications in the database
 388             XDB::execute('REPLACE INTO groupex.evenements
 389                 SET eid={?}, asso_id={?}, organisateur_uid={?}, intitule={?},
 390                     paiement_id = {?}, descriptif = {?}, debut = {?},
 391                     fin = {?}, show_participants = {?}, short_name = {?},
 392                     deadline_inscription = {?}, noinvite = {?},
 393                     accept_nonmembre = {?}',
 394                     $evt['eid'], $evt['asso_id'], $evt['organisateur_uid'],
 395                     $evt['intitule'], $evt['paiement_id'], $evt['descriptif'],
 396                     $evt['debut'], $evt['fin'], $evt['show_participants'],
 397                     $evt['short_name'], $evt['deadline_inscription'],
 398                     $evt['noinvite'], $evt['accept_nonmembre']);
 399
 400             // if new event, get its id
 401             if (!$eid) {
 402                 $eid = mysql_insert_id();
 403             }
 404
 405             $nb_moments   = 0;
 406             $money_defaut = 0;
 407
 408             foreach ($moments as $i) {
 409                 if (Post::v('titre'.$i)) {
 410                     $nb_moments++;
 411
 412                     $montant = strtr(Post::v('montant'.$i), ',', '.');
 413                     $money_defaut += (float)$montant;
 414                     XDB::execute("
 415                         REPLACE INTO groupex.evenements_items
 416                         VALUES ({?}, {?}, {?}, {?}, {?})",
 417                         $eid, $i, Post::v('titre'.$i),
 418                         Post::v('details'.$i), $montant);
 419                 } else {
 420                     XDB::execute("DELETE FROM groupex.evenements_items
 421                                             WHERE eid = {?} AND item_id = {?}", $eid, $i);
 422                 }
 423             }
 424
 425             // request for a new payment
 426             if (Post::v('paiement_id') == -1 && $money_defaut >= 0) {
 427                 require_once 'validations.inc.php';
 428                 $p = new PayReq(S::v('uid'),
 429                                 Post::v('intitule')." - ".$globals->asso('nom'),
 430                                 Post::v('site'), $money_defaut,
 431                                 Post::v('confirmation'), 0, 999,
 432                                 $globals->asso('id'), $eid);
 433                 $p->submit();
 434             }
 435
 436             // events with no sub-event: add a sub-event with no name
 437             if ($nb_moments == 0) {
 438                 XDB::execute("INSERT INTO groupex.evenements_items
 439                                         VALUES ({?}, {?}, '', '', 0)", $eid, 1);
 440             }
 441
 442             pl_redirect('events');
 443         }
 444
 445         // get a list of all the payment for this asso
 446         $res = XDB::iterator("SELECT id, text
 447                                 FROM {$globals->money->mpay_tprefix}paiements
 448                                WHERE asso_id = {?}", $globals->asso('id'));
 449         $paiements = array();
 450         while ($a = $res->next()) $paiements[$a['id']] = $a['text']; {
 451             $page->assign('paiements', $paiements);
 452         }
 453
 454         // when modifying an old event retreive the old datas
 455         if ($eid) {
 456             $res = XDB::query(
 457                     "SELECT     eid, intitule, descriptif, debut, fin, organisateur_uid,
 458                             show_participants, paiement_id, short_name,
 459                             deadline_inscription, noinvite, accept_nonmembre
 460                        FROM     groupex.evenements
 461                       WHERE eid = {?}", $eid);
 462             $evt = $res->fetchOneAssoc();
 463             // find out if there is already a request for a payment for this event
 464             require_once 'validations.inc.php';
 465             $res = XDB::query("SELECT stamp FROM requests
 466                                 WHERE type = 'paiements' AND data LIKE {?}",
 467                                PayReq::same_event($eid, $globals->asso('id')));
 468             $stamp = $res->fetchOneCell();
 469             if ($stamp) {
 470                 $evt['paiement_id'] = -2;
 471                 $evt['paiement_req'] = $stamp;
 472             }
 473             $page->assign('evt', $evt);
 474             // get all the different moments infos
 475             $res = XDB::iterator(
 476                     "SELECT item_id, titre, details, montant
 477                        FROM groupex.evenements_items AS ei
 478                  INNER JOIN groupex.evenements AS e ON(e.eid = ei.eid)
 479                       WHERE e.eid = {?}
 480                    ORDER BY item_id", $eid);
 481             $items = array();
 482             while ($item = $res->next()) {
 483                 $items[$item['item_id']] = $item;
 484             }
 485             $page->assign('items', $items);
 486         }
 487         $page->assign('url_ref', $eid);
 488     }
 489
 490     function handler_admin(&$page, $eid = null, $item_id = null)
 491     {
 492         global $globals;
 493
 494         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 495
 496         $evt = get_event_detail($eid, $item_id);
 497         if (!$evt) {
 498             return PL_NOT_FOUND;
 499         }
 500
 501         if ($evt['show_participants']) {
 502             new_group_page('xnetevents/admin.tpl');
 503         } else {
 504             new_groupadmin_page('xnetevents/admin.tpl');
 505         }
 506
 507         if (may_update() && Post::v('adm')) {
 508             $member = get_infos(Post::v('mail'));
 509             if (!$member) {
 510                 $page->trig("Membre introuvable");
 511             }
 512
 513             // change the price paid by a participant
 514             if (Env::v('adm') == 'prix' && $member) {
 515                 XDB::execute("UPDATE groupex.evenements_participants
 516                                  SET paid = IF(paid + {?} > 0, paid + {?}, 0)
 517                                WHERE uid = {?} AND eid = {?}",
 518                         strtr(Env::v('montant'), ',', '.'),
 519                         strtr(Env::v('montant'), ',', '.'),
 520                         $member['uid'], $evt['eid']);
 521             }
 522
 523             // change the number of personns coming with a participant
 524             if (Env::v('adm') == 'nbs' && $member) {
 525                 $res = XDB::query("SELECT paid
 526                                      FROM groupex.evenements_participants
 527                                     WHERE uid = {?} AND eid = {?}",
 528                                   $member['uid'], $evt['eid']);
 529
 530                 $paid = intval($res->fetchOneCell());
 531                 $nbs  = Post::v('nb', array());
 532
 533                 foreach ($nbs as $id => $nb) {
 534                     $nb = max(intval($nb), 0);
 535
 536                     if ($nb) {
 537                         XDB::execute("REPLACE INTO groupex.evenements_participants
 538                                             VALUES ({?}, {?}, {?}, {?}, {?})",
 539                                                $evt['eid'], $member['uid'], $id, $nb, $paid);
 540                     } else {
 541                         XDB::execute("DELETE FROM groupex.evenements_participants
 542                                             WHERE uid = {?} AND eid = {?} AND item_id = {?}",
 543                                                $member['uid'], $evt['eid'], $id);
 544                     }
 545                 }
 546
 547                 $res = XDB::query("SELECT uid
 548                                      FROM groupex.evenements_participants
 549                                     WHERE uid = {?} AND eid = {?}",
 550                                             $member['uid'], $evt['eid']);
 551                 $u = $res->fetchOneCell();
 552                 subscribe_lists_event($u, $member['uid'], $evt);
 553             }
 554
 555             $evt = get_event_detail($eid, $item_id);
 556         }
 557
 558         $page->assign('admin', may_update());
 559         $page->assign('evt', $evt);
 560         $page->assign('tout', is_null($item_id));
 561
 562         if (count($evt['moments'])) {
 563             $page->assign('moments', $evt['moments']);
 564         }
 565
 566         $tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
 567         $whereitemid = is_null($item_id) ? '' : "AND ep.item_id = $item_id";
 568         $res = XDB::iterRow(
 569                     'SELECT  UPPER(SUBSTRING(IF(u.nom IS NULL, m.nom,
 570                                                 IF(u.nom_usage<>"", u.nom_usage, u.nom)), 1, 1)),
 571                              COUNT(DISTINCT ep.uid)
 572                        FROM  groupex.evenements_participants AS ep
 573                  INNER JOIN  groupex.evenements AS e ON (ep.eid = e.eid)
 574                   LEFT JOIN  groupex.membres AS m ON ( ep.uid = m.uid AND e.asso_id = m.asso_id)
 575                   LEFT JOIN  auth_user_md5   AS u ON ( u.user_id = ep.uid )
 576                       WHERE  ep.eid = {?} '.$whereitemid.'
 577                    GROUP BY  UPPER(SUBSTRING(IF(u.nom IS NULL,m.nom,u.nom), 1, 1))', $evt['eid']);
 578
 579         $alphabet = array();
 580         $nb_tot = 0;
 581         while (list($char, $nb) = $res->next()) {
 582             $alphabet[ord($char)] = $char;
 583             $nb_tot += $nb;
 584             if (Env::has('initiale') && $char == strtoupper(Env::v('initiale'))) {
 585                 $tot = $nb;
 586             }
 587         }
 588         ksort($alphabet);
 589         $page->assign('alphabet', $alphabet);
 590
 591         $ofs   = Env::i('offset');
 592         $tot   = Env::v('initiale') ? $tot : $nb_tot;
 593         $nbp   = intval(($tot-1)/NB_PER_PAGE);
 594         $links = array();
 595         if ($ofs) {
 596             $links['précédent'] = $ofs-1;
 597         }
 598         for ($i = 0; $i <= $nbp; $i++) {
 599             $links[(string)($i+1)] = $i;
 600         }
 601         if ($ofs < $nbp) {
 602             $links['suivant'] = $ofs+1;
 603         }
 604         if (count($links)>1) {
 605             $page->assign('links', $links);
 606         }
 607
 608         if ($evt['paiement_id']) {
 609             $res = XDB::iterator(
 610                 "SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom, u.prenom,
 611                         u.promo, a.alias AS email, t.montant
 612                    FROM {$globals->money->mpay_tprefix}transactions AS t
 613              INNER JOIN auth_user_md5 AS u ON(t.uid = u.user_id)
 614              INNER JOIN aliases AS a ON (a.id = t.uid AND a.type='a_vie' )
 615               LEFT JOIN groupex.evenements_participants AS ep ON(ep.uid = t.uid AND ep.eid = {?})
 616                   WHERE t.ref = {?} AND ep.uid IS NULL",
 617                   $evt['eid'], $evt['paiement_id']);
 618             $page->assign('oublis', $res->total());
 619             $page->assign('oubliinscription', $res);
 620         }
 621
 622         $page->assign('participants',
 623                       get_event_participants($evt, $item_id, $tri,
 624                                              "LIMIT ".($ofs*NB_PER_PAGE).", ".NB_PER_PAGE));
 625     }
 626 }
 627
 628 ?>