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_NOT_ALLOWED;
  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_NOT_ALLOWED;
  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             $evts[] = $e;
 170         }
 171
 172         $page->assign('evenements', $evts);
 173         $page->assign('is_member', is_member());
 174     }
 175
 176     function handler_sub(&$page, $eid = null)
 177     {
 178         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 179
 180         new_group_open_page('xnetevents/subscribe.tpl');
 181
 182         $evt = get_event_detail($eid);
 183         if (!$evt) {
 184             return PL_NOT_FOUND;
 185         }
 186
 187         if (!$evt['inscr_open']) {
 188             $page->kill('Les inscriptions pour cet événement sont closes');
 189         }
 190         if (!$evt['accept_nonmembre'] && !is_member() && !may_update()) {
 191             $page->kill('Cet événement est fermé aux non-membres du groupe');
 192         }
 193
 194         $page->assign('event', $evt);
 195
 196         if (!Post::has('submit')) {
 197             return;
 198         }
 199
 200         $moments = Post::v('moment',    array());
 201         $pers    = Post::v('personnes', array());
 202         $subs    = array();
 203
 204         foreach ($moments as $j => $v) {
 205             $subs[$j] = intval($v);
 206
 207             // retreive ohter field when more than one person
 208             if ($subs[$j] == 2) {
 209                 if (!isset($pers[$j]) || !is_numeric($pers[$j])
 210                 ||  $pers[$j] < 0)
 211                 {
 212                     $page->trig('Tu dois choisir un nombre d\'invités correct !');
 213                     return;
 214                 }
 215                 $subs[$j] = 1 + $pers[$j];
 216             }
 217         }
 218
 219         // impossible to unsubscribe if you already paid sthing
 220         if (array_sum($subs) && $evt['paid'] != 0) {
 221             $page->trig("Impossible de te désinscrire complètement ".
 222                         "parce que tu as fait un paiement par ".
 223                         "chèque ou par liquide. Contacte un ".
 224                         "administrateur du groupe si tu es sûr de ".
 225                         "ne pas venir");
 226             return;
 227         }
 228
 229         // update actual inscriptions
 230         foreach ($subs as $j => $nb) {
 231             if ($nb > 0) {
 232                 XDB::execute(
 233                     "REPLACE INTO  groupex.evenements_participants
 234                            VALUES  ({?}, {?}, {?}, {?}, {?})",
 235                     $eid, S::v('uid'), $j, $nb, $evt['paid']);
 236                 $page->assign('updated', true);
 237             } else {
 238                 XDB::execute(
 239                     "DELETE FROM  groupex.evenements_participants
 240                            WHERE  eid = {?} AND uid = {?} AND item_id = {?}",
 241                     $eid, S::v("uid"), $j);
 242                 $page->assign('updated', true);
 243             }
 244         }
 245
 246         $page->assign('event', get_event_detail($eid));
 247     }
 248
 249     function handler_csv(&$page, $eid = null, $item_id = null)
 250     {
 251         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 252
 253         if (!is_numeric($item_id)) {
 254             $item_id = null;
 255         }
 256
 257         $evt = get_event_detail($eid, $item_id);
 258         if (!$evt) {
 259             return PL_NOT_FOUND;
 260         }
 261
 262         header('Content-type: text/x-csv; encoding=iso-8859-1');
 263         header('Pragma: ');
 264         header('Cache-Control: ');
 265
 266         $page->changeTpl('xnetevents/csv.tpl', NO_SKIN);
 267
 268         $admin = may_update();
 269
 270         $tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
 271
 272         $page->assign('participants',
 273                       get_event_participants($evt, $item_id, $tri));
 274
 275         $page->assign('admin', $admin);
 276         $page->assign('moments', $evt['moments']);
 277         $page->assign('money', $evt['money']);
 278         $page->assign('tout', !Env::v('item_id', false));
 279     }
 280
 281     function handler_ical(&$page, $eid = null)
 282     {
 283         global $globals;
 284
 285         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 286         $evt = get_event_detail($eid);
 287         if (!$evt) {
 288             return PL_NOT_FOUND;
 289         }
 290         $evt['debut'] = preg_replace('/(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)/', "\\1\\2\\3T\\4\\5\\6", $evt['debut']);
 291         $evt['fin'] = preg_replace('/(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)/', "\\1\\2\\3T\\4\\5\\6", $evt['fin']);
 292
 293         $page->changeTpl('xnetevents/calendar.tpl', NO_SKIN);
 294
 295         require_once(dirname(__FILE__).'/carnet/smarty.php');
 296         $page->assign('asso', $globals->asso());
 297         $page->assign('timestamp', time());
 298         $page->register_function('display_ical', 'display_ical');
 299         $page->assign_by_ref('e', $evt);
 300
 301         header('Content-Type: text/calendar; charset=utf-8');
 302     }
 303
 304     function handler_edit(&$page, $eid = null)
 305     {
 306         global $globals;
 307
 308         // check the event is in our group
 309         if (!is_null($eid)) {
 310             $res = XDB::query("SELECT short_name, asso_id
 311                                            FROM groupex.evenements
 312                                           WHERE eid = {?}", $eid);
 313             $infos = $res->fetchOneAssoc();
 314             if ($infos['asso_id'] != $globals->asso('id')) {
 315                 return PL_NOT_ALLOWED;
 316             }
 317         }
 318
 319         new_groupadmin_page('xnetevents/edit.tpl');
 320
 321         $moments = range(1, 4);
 322         $page->assign('moments', $moments);
 323
 324         if (Post::v('intitule')) {
 325             require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 326             $short_name = event_change_shortname($page, $infos['short_name'],
 327                                                  Env::v('short_name', ''));
 328
 329             $evt = array(
 330                 'eid'              => $eid,
 331                 'asso_id'          => $globals->asso('id'),
 332                 'organisateur_uid' => S::v('uid'),
 333                 'paiement_id'      => Post::v('paiement_id') > 0 ? Post::v('paiement_id') : null,
 334                 'debut'            => Post::v('deb_Year').'-'.Post::v('deb_Month')
 335                                       .'-'.Post::v('deb_Day').' '.Post::v('deb_Hour')
 336                                       .':'.Post::v('deb_Minute').':00',
 337                 'fin'              => Post::v('fin_Year').'-'.Post::v('fin_Month')
 338                                       .'-'.Post::v('fin_Day').' '.Post::v('fin_Hour')
 339                                       .':'.Post::v('fin_Minute').':00',
 340                 'short_name'       => $short_name,
 341             );
 342
 343             $trivial = array('intitule', 'descriptif', 'noinvite',
 344                              'show_participants', 'accept_nonmembre');
 345             foreach ($trivial as $k) {
 346                 $evt[$k] = Post::v($k);
 347             }
 348
 349             if (Post::v('deadline')) {
 350                 $evt['deadline_inscription'] = Post::v('inscr_Year').'-'
 351                                              . Post::v('inscr_Month').'-'
 352                                              . Post::v('inscr_Day');
 353             } else {
 354                 $evt['deadline_inscription'] = null;
 355             }
 356
 357             // Store the modifications in the database
 358             XDB::execute('REPLACE INTO groupex.evenements
 359                 SET eid={?}, asso_id={?}, organisateur_uid={?}, intitule={?},
 360                     paiement_id = {?}, descriptif = {?}, debut = {?},
 361                     fin = {?}, show_participants = {?}, short_name = {?},
 362                     deadline_inscription = {?}, noinvite = {?},
 363                     accept_nonmembre = {?}',
 364                     $evt['eid'], $evt['asso_id'], $evt['organisateur_uid'],
 365                     $evt['intitule'], $evt['paiement_id'], $evt['descriptif'],
 366                     $evt['debut'], $evt['fin'], $evt['show_participants'],
 367                     $evt['short_name'], $evt['deadline_inscription'],
 368                     $evt['noinvite'], $evt['accept_nonmembre']);
 369
 370             // if new event, get its id
 371             if (!$eid) {
 372                 $eid = mysql_insert_id();
 373             }
 374
 375             $nb_moments   = 0;
 376             $money_defaut = 0;
 377
 378             foreach ($moments as $i) {
 379                 if (Post::v('titre'.$i)) {
 380                     $nb_moments++;
 381
 382                     $montant = strtr(Post::v('montant'.$i), ',', '.');
 383                     $money_defaut += (float)$montant;
 384                     XDB::execute("
 385                         REPLACE INTO groupex.evenements_items
 386                         VALUES ({?}, {?}, {?}, {?}, {?})",
 387                         $eid, $i, Post::v('titre'.$i),
 388                         Post::v('details'.$i), $montant);
 389                 } else {
 390                     XDB::execute("DELETE FROM groupex.evenements_items
 391                                             WHERE eid = {?} AND item_id = {?}", $eid, $i);
 392                 }
 393             }
 394
 395             // request for a new payment
 396             if (Post::v('paiement_id') == -1 && $money_defaut >= 0) {
 397                 require_once 'validations.inc.php';
 398                 $p = new PayReq(S::v('uid'),
 399                                 Post::v('intitule')." - ".$globals->asso('nom'),
 400                                 Post::v('site'), $money_defaut,
 401                                 Post::v('confirmation'), 0, 999,
 402                                 $globals->asso('id'), $eid);
 403                 $p->submit();
 404             }
 405
 406             // events with no sub-event: add a sub-event with no name
 407             if ($nb_moments == 0) {
 408                 XDB::execute("INSERT INTO groupex.evenements_items
 409                                         VALUES ({?}, {?}, '', '', 0)", $eid, 1);
 410             }
 411
 412             if (is_null($evt['eid'])) {
 413                 pl_redirect('events/'.$eid);
 414             }
 415         }
 416
 417         // get a list of all the payment for this asso
 418         $res = XDB::iterator("SELECT id, text
 419                                         FROM {$globals->money->mpay_tprefix}paiements
 420                                         WHERE asso_id = {?}", $globals->asso('id'));
 421         $paiements = array();
 422         while ($a = $res->next()) $paiements[$a['id']] = $a['text']; {
 423             $page->assign('paiements', $paiements);
 424         }
 425
 426         // when modifying an old event retreive the old datas
 427         if ($eid) {
 428             $res = XDB::query(
 429                     "SELECT     eid, intitule, descriptif, debut, fin,
 430                                 show_participants, paiement_id, short_name,
 431                                 deadline_inscription, noinvite, accept_nonmembre
 432                        FROM     groupex.evenements
 433                       WHERE eid = {?}", $eid);
 434             $evt = $res->fetchOneAssoc();
 435             // find out if there is already a request for a payment for this event
 436             require_once 'validations.inc.php';
 437             $res = XDB::query("SELECT stamp FROM requests
 438                                          WHERE type = 'paiements' AND data LIKE {?}",
 439                                         PayReq::same_event($eid, $globals->asso('id')));
 440             $stamp = $res->fetchOneCell();
 441             if ($stamp) {
 442                 $evt['paiement_id'] = -2;
 443                 $evt['paiement_req'] = $stamp;
 444             }
 445             $page->assign('evt', $evt);
 446             // get all the different moments infos
 447             $res = XDB::iterator(
 448                     "SELECT item_id, titre, details, montant
 449                        FROM groupex.evenements_items AS ei
 450                  INNER JOIN groupex.evenements AS e ON(e.eid = ei.eid)
 451                       WHERE e.eid = {?}
 452                    ORDER BY item_id", $eid);
 453             $items = array();
 454             while ($item = $res->next()) {
 455                 $items[$item['item_id']] = $item;
 456             }
 457             $page->assign('items', $items);
 458         }
 459     }
 460
 461     function handler_admin(&$page, $eid = null, $item_id = null)
 462     {
 463         global $globals;
 464
 465         require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
 466
 467         $evt = get_event_detail($eid, $item_id);
 468         if (!$evt) {
 469             return PL_NOT_FOUND;
 470         }
 471
 472         if ($evt['show_participants']) {
 473             new_group_page('xnetevents/admin.tpl');
 474         } else {
 475             new_groupadmin_page('xnetevents/admin.tpl');
 476         }
 477
 478         if (may_update() && Post::v('adm')) {
 479             $member = get_infos(Post::v('mail'));
 480             if (!$member) {
 481                 $page->trig("Membre introuvable");
 482             }
 483
 484             // change the price paid by a participant
 485             if (Env::v('adm') == 'prix' && $member) {
 486                 XDB::execute("UPDATE groupex.evenements_participants
 487                                            SET paid = IF(paid + {?} > 0, paid + {?}, 0)
 488                                          WHERE uid = {?} AND eid = {?}",
 489                         strtr(Env::v('montant'), ',', '.'),
 490                         strtr(Env::v('montant'), ',', '.'),
 491                         $member['uid'], $eid);
 492             }
 493
 494             // change the number of personns coming with a participant
 495             if (Env::v('adm') == 'nbs' && $member) {
 496                 $res = XDB::query("SELECT paid
 497                                                FROM groupex.evenements_participants
 498                                               WHERE uid = {?} AND eid = {?}",
 499                                             $member['uid'], $eid);
 500
 501                 $paid = intval($res->fetchOneCell());
 502                 $nbs  = Post::v('nb', array());
 503
 504                 foreach ($nbs as $id => $nb) {
 505                     $nb = max(intval($nb), 0);
 506
 507                     if ($nb) {
 508                         XDB::execute("REPLACE INTO groupex.evenements_participants
 509                                                VALUES ({?}, {?}, {?}, {?}, {?})",
 510                                                $eid, $member['uid'], $id, $nb, $paid);
 511                     } else {
 512                         XDB::execute("DELETE FROM groupex.evenements_participants
 513                                                WHERE uid = {?} AND eid = {?} AND item_id = {?}",
 514                                                $member['uid'], $eid, $id);
 515                     }
 516                 }
 517
 518                 $res = XDB::query("SELECT uid FROM groupex.evenements_participants
 519                                             WHERE uid = {?} AND eid = {?}",
 520                                             $member['uid'], $eid);
 521                 $u = $res->fetchOneCell();
 522                 subscribe_lists_event($u, $member['uid'], $evt);
 523             }
 524
 525             $evt = get_event_detail($eid, $item_id);
 526         }
 527
 528         $page->assign('admin', may_update());
 529         $page->assign('evt', $evt);
 530         $page->assign('tout', is_null($item_id));
 531
 532         if (count($evt['moments'])) {
 533             $page->assign('moments', $evt['moments']);
 534         }
 535
 536         $tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
 537         $whereitemid = is_null($item_id) ? '' : "AND ep.item_id = $item_id";
 538         $res = XDB::iterRow(
 539                     'SELECT  UPPER(SUBSTRING(IF(u.nom IS NULL, m.nom,
 540                                                 IF(u.nom_usage<>"", u.nom_usage, u.nom)), 1, 1)),
 541                              COUNT(DISTINCT ep.uid)
 542                        FROM  groupex.evenements_participants AS ep
 543                  INNER JOIN  groupex.evenements AS e ON (ep.eid = e.eid)
 544                   LEFT JOIN  groupex.membres AS m ON ( ep.uid = m.uid AND e.asso_id = m.asso_id)
 545                   LEFT JOIN  auth_user_md5   AS u ON ( u.user_id = ep.uid )
 546                       WHERE  ep.eid = {?} '.$whereitemid.'
 547                    GROUP BY  UPPER(SUBSTRING(IF(u.nom IS NULL,m.nom,u.nom), 1, 1))', $eid);
 548
 549         $alphabet = array();
 550         $nb_tot = 0;
 551         while (list($char, $nb) = $res->next()) {
 552             $alphabet[ord($char)] = $char;
 553             $nb_tot += $nb;
 554             if (Env::has('initiale') && $char == strtoupper(Env::v('initiale'))) {
 555                 $tot = $nb;
 556             }
 557         }
 558         ksort($alphabet);
 559         $page->assign('alphabet', $alphabet);
 560
 561         $ofs   = Env::i('offset');
 562         $tot   = Env::v('initiale') ? $tot : $nb_tot;
 563         $nbp   = intval(($tot-1)/NB_PER_PAGE);
 564         $links = array();
 565         if ($ofs) {
 566             $links['précédent'] = $ofs-1;
 567         }
 568         for ($i = 0; $i <= $nbp; $i++) {
 569             $links[(string)($i+1)] = $i;
 570         }
 571         if ($ofs < $nbp) {
 572             $links['suivant'] = $ofs+1;
 573         }
 574         if (count($links)>1) {
 575             $page->assign('links', $links);
 576         }
 577
 578         if ($evt['paiement_id']) {
 579             $res = XDB::iterator(
 580                 "SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom, u.prenom,
 581                         u.promo, a.alias AS email, t.montant
 582                    FROM {$globals->money->mpay_tprefix}transactions AS t
 583                  INNER JOIN auth_user_md5 AS u ON(t.uid = u.user_id)
 584                  INNER JOIN aliases AS a ON (a.id = t.uid AND a.type='a_vie' )
 585                   LEFT JOIN groupex.evenements_participants AS ep ON(ep.uid = t.uid AND ep.eid = {?})
 586                   WHERE t.ref = {?} AND ep.uid IS NULL",
 587                   $evt['eid'], $evt['paiement_id']);
 588             $page->assign('oublis', $res->total());
 589             $page->assign('oubliinscription', $res);
 590         }
 591
 592         $page->assign('participants',
 593                       get_event_participants($evt, $item_id, $tri,
 594                                              "LIMIT ".($ofs*NB_PER_PAGE).", ".NB_PER_PAGE));
 595     }
 596 }
 597
 598 ?>