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