2 /***************************************************************************
3 * Copyright (C) 2003-2006 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
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. *
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. *
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 *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 define('NB_PER_PAGE', 25);
24 class XnetEventsModule
extends PLModule
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
),
38 function handler_events(&$page, $archive = null
)
42 if ($archive == 'archive') {
44 new_groupadmin_page('xnetevents/index.tpl');
47 new_group_open_page('xnetevents/index.tpl');
51 if (Post
::has('del')) {
53 $eid = Post
::v('del');
54 } elseif (Post
::has('archive')) {
56 $eid = Post
::v('archive');
57 } elseif (Post
::has('unarchive')) {
58 $action = 'unarchive';
59 $eid = Post
::v('unarchive');
62 if (!is_null($action)) {
64 return PL_NOT_ALLOWED
;
67 $res = XDB
::query("SELECT asso_id, short_name FROM groupex.evenements
68 WHERE eid = {?} AND asso_id = {?}",
69 $eid, $globals->asso('id'));
71 $tmp = $res->fetchOneRow();
73 return PL_NOT_ALLOWED
;
77 if ($action == 'del') {
78 // deletes the event mailing aliases
81 "DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
82 $tmp[1].'-absents@%');
84 "DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
85 $tmp[1].'-participants@%');
88 // deletes the event items
89 XDB
::execute("DELETE FROM groupex.evenements_items WHERE eid = {?}", $eid);
91 // deletes the event participants
92 XDB
::execute("DELETE FROM groupex.evenements_participants
93 WHERE eid = {?}", $eid);
96 XDB
::execute("DELETE FROM groupex.evenements
97 WHERE eid = {?} AND asso_id = {?}",
98 $eid, $globals->asso('id'));
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')));
107 if ($action == 'archive') {
108 XDB
::execute("UPDATE groupex.evenements
110 WHERE eid = {?} AND asso_id = {?}",
111 $eid, $globals->asso('id'));
114 if ($action == 'unarchive') {
115 XDB
::execute("UPDATE groupex.evenements
117 WHERE eid = {?} AND asso_id = {?}",
118 $eid, $globals->asso('id'));
121 $page->assign('archive', $archive);
122 $page->assign('admin', may_update());
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 = {?})
135 AND archive = " . ($archive ?
"1 " : "0 ")
136 . (is_member() ||
may_update() ?
"" : " AND accept_nonmembre != 0 ")
138 ORDER BY inscr_open DESC, debut DESC", S
::v('uid'), $globals->asso('id'));
142 while ($e = $evenements->next()) {
143 $e['show_participants'] = ($e['show_participants'] && (is_member() ||
may_update()));
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 = {?})
150 S
::v('uid'), $e['eid']);
151 $e['moments'] = $res->fetchAllAssoc();
154 foreach ($e['moments'] as $m) {
155 $e['topay'] +
= $m['nb'] * $m['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();
164 foreach ($montants as $m) {
165 $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
166 $e['paid'] +
= trim($p);
169 if (Env
::has('updated') && $e['eid'] == Env
::i('updated')) {
170 $page->assign('updated', $e);
175 $page->assign('evenements', $evts);
176 $page->assign('is_member', is_member());
179 function handler_sub(&$page, $eid = null
)
181 require_once dirname(__FILE__
).'/xnetevents/xnetevents.inc.php';
183 new_group_open_page('xnetevents/subscribe.tpl');
185 $evt = get_event_detail($eid);
190 if (!$evt['inscr_open']) {
191 $page->kill('Les inscriptions pour cet événement sont closes');
193 if (!$evt['accept_nonmembre'] && !is_member() && !may_update()) {
194 $page->kill('Cet événement est fermé aux non-membres du groupe');
197 $page->assign('event', $evt);
199 if (!Post
::has('submit')) {
203 $moments = Post
::v('moment', array());
204 $pers = Post
::v('personnes', array());
207 foreach ($moments as $j => $v) {
208 $subs[$j] = intval($v);
210 // retreive ohter field when more than one person
211 if ($subs[$j] == 2) {
212 if (!isset($pers[$j]) ||
!is_numeric($pers[$j])
215 $page->trig('Tu dois choisir un nombre d\'invités correct !');
218 $subs[$j] = 1 +
$pers[$j];
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 ".
232 // update actual inscriptions
234 foreach ($subs as $j => $nb) {
237 "REPLACE INTO groupex.evenements_participants
238 VALUES ({?}, {?}, {?}, {?}, {?})",
239 $eid, S
::v('uid'), $j, $nb, $evt['paid']);
243 "DELETE FROM groupex.evenements_participants
244 WHERE eid = {?} AND uid = {?} AND item_id = {?}",
245 $eid, S
::v("uid"), $j);
249 if ($updated !== false
) {
250 pl_redirect('events?updated='.$updated);
252 $page->assign('event', get_event_detail($eid));
255 function handler_csv(&$page, $eid = null
, $item_id = null
)
257 require_once dirname(__FILE__
).'/xnetevents/xnetevents.inc.php';
259 if (!is_numeric($item_id)) {
263 $evt = get_event_detail($eid, $item_id);
268 header('Content-type: text/x-csv; encoding=iso-8859-1');
270 header('Cache-Control: ');
272 $page->changeTpl('xnetevents/csv.tpl', NO_SKIN
);
274 $admin = may_update();
276 $tri = (Env
::v('order') == 'alpha' ?
'promo, nom, prenom' : 'nom, prenom, promo');
278 $page->assign('participants',
279 get_event_participants($evt, $item_id, $tri));
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
));
287 function handler_ical(&$page, $eid = null
)
291 require_once dirname(__FILE__
).'/xnetevents/xnetevents.inc.php';
292 $evt = get_event_detail($eid);
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']);
299 foreach ($evt['moments'] as $m) {
300 $evt['descriptif'] .= "\n\n** " . $m['titre'] . " **\n" . $m['details'];
303 $page->changeTpl('xnetevents/calendar.tpl', NO_SKIN
);
305 require_once('ical.inc.php');
306 $page->assign('asso', $globals->asso());
307 $page->assign('timestamp', time());
308 $page->assign('admin', may_update());
311 $page->assign('participants', get_event_participants($evt, null
, 'promo, nom, prenom'));
313 $page->register_function('display_ical', 'display_ical');
314 $page->assign_by_ref('e', $evt);
316 header('Content-Type: text/calendar; charset=utf-8');
319 function handler_edit(&$page, $eid = null
)
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();
334 // check the event is in our group
335 if (!is_null($eid)) {
336 $res = XDB
::query("SELECT short_name, asso_id
337 FROM groupex.evenements
338 WHERE eid = {?}", $eid);
339 $infos = $res->fetchOneAssoc();
340 if ($infos['asso_id'] != $globals->asso('id')) {
341 return PL_NOT_ALLOWED
;
345 new_groupadmin_page('xnetevents/edit.tpl');
347 $moments = range(1, 4);
348 $page->assign('moments', $moments);
350 if (Post
::v('intitule')) {
351 require_once dirname(__FILE__
).'/xnetevents/xnetevents.inc.php';
352 $short_name = event_change_shortname($page, $infos['short_name'],
353 Env
::v('short_name', ''));
357 'asso_id' => $globals->asso('id'),
358 'paiement_id' => Post
::v('paiement_id') > 0 ? Post
::v('paiement_id') : null
,
359 'debut' => Post
::v('deb_Year').'-'.Post
::v('deb_Month')
360 .'-'.Post
::v('deb_Day').' '.Post
::v('deb_Hour')
361 .':'.Post
::v('deb_Minute').':00',
362 'fin' => Post
::v('fin_Year').'-'.Post
::v('fin_Month')
363 .'-'.Post
::v('fin_Day').' '.Post
::v('fin_Hour')
364 .':'.Post
::v('fin_Minute').':00',
365 'short_name' => $short_name,
368 $trivial = array('intitule', 'descriptif', 'noinvite',
369 'show_participants', 'accept_nonmembre', 'organisateur_uid');
370 foreach ($trivial as $k) {
371 $evt[$k] = Post
::v($k);
374 $evt['organisateur_uid'] = S
::v('uid');
377 if (Post
::v('deadline')) {
378 $evt['deadline_inscription'] = Post
::v('inscr_Year').'-'
379 . Post
::v('inscr_Month').'-'
380 . Post
::v('inscr_Day');
382 $evt['deadline_inscription'] = null
;
385 // Store the modifications in the database
386 XDB
::execute('REPLACE INTO groupex.evenements
387 SET eid={?}, asso_id={?}, organisateur_uid={?}, intitule={?},
388 paiement_id = {?}, descriptif = {?}, debut = {?},
389 fin = {?}, show_participants = {?}, short_name = {?},
390 deadline_inscription = {?}, noinvite = {?},
391 accept_nonmembre = {?}',
392 $evt['eid'], $evt['asso_id'], $evt['organisateur_uid'],
393 $evt['intitule'], $evt['paiement_id'], $evt['descriptif'],
394 $evt['debut'], $evt['fin'], $evt['show_participants'],
395 $evt['short_name'], $evt['deadline_inscription'],
396 $evt['noinvite'], $evt['accept_nonmembre']);
398 // if new event, get its id
400 $eid = mysql_insert_id();
406 foreach ($moments as $i) {
407 if (Post
::v('titre'.$i)) {
410 $montant = strtr(Post
::v('montant'.$i), ',', '.');
411 $money_defaut +
= (float)$montant;
413 REPLACE INTO groupex.evenements_items
414 VALUES ({?}, {?}, {?}, {?}, {?})",
415 $eid, $i, Post
::v('titre'.$i),
416 Post
::v('details'.$i), $montant);
418 XDB
::execute("DELETE FROM groupex.evenements_items
419 WHERE eid = {?} AND item_id = {?}", $eid, $i);
423 // request for a new payment
424 if (Post
::v('paiement_id') == -1 && $money_defaut >= 0) {
425 require_once 'validations.inc.php';
426 $p = new PayReq(S
::v('uid'),
427 Post
::v('intitule')." - ".$globals->asso('nom'),
428 Post
::v('site'), $money_defaut,
429 Post
::v('confirmation'), 0, 999,
430 $globals->asso('id'), $eid);
434 // events with no sub-event: add a sub-event with no name
435 if ($nb_moments == 0) {
436 XDB
::execute("INSERT INTO groupex.evenements_items
437 VALUES ({?}, {?}, '', '', 0)", $eid, 1);
440 pl_redirect('events');
443 // get a list of all the payment for this asso
444 $res = XDB
::iterator("SELECT id, text
445 FROM {$globals->money->mpay_tprefix}paiements
446 WHERE asso_id = {?}", $globals->asso('id'));
447 $paiements = array();
448 while ($a = $res->next()) $paiements[$a['id']] = $a['text']; {
449 $page->assign('paiements', $paiements);
452 // when modifying an old event retreive the old datas
455 "SELECT eid, intitule, descriptif, debut, fin, organisateur_uid,
456 show_participants, paiement_id, short_name,
457 deadline_inscription, noinvite, accept_nonmembre
458 FROM groupex.evenements
459 WHERE eid = {?}", $eid);
460 $evt = $res->fetchOneAssoc();
461 // find out if there is already a request for a payment for this event
462 require_once 'validations.inc.php';
463 $res = XDB
::query("SELECT stamp FROM requests
464 WHERE type = 'paiements' AND data LIKE {?}",
465 PayReq
::same_event($eid, $globals->asso('id')));
466 $stamp = $res->fetchOneCell();
468 $evt['paiement_id'] = -2;
469 $evt['paiement_req'] = $stamp;
471 $page->assign('evt', $evt);
472 // get all the different moments infos
473 $res = XDB
::iterator(
474 "SELECT item_id, titre, details, montant
475 FROM groupex.evenements_items AS ei
476 INNER JOIN groupex.evenements AS e ON(e.eid = ei.eid)
478 ORDER BY item_id", $eid);
480 while ($item = $res->next()) {
481 $items[$item['item_id']] = $item;
483 $page->assign('items', $items);
485 $page->assign('url_ref', $eid);
488 function handler_admin(&$page, $eid = null
, $item_id = null
)
492 require_once dirname(__FILE__
).'/xnetevents/xnetevents.inc.php';
494 $evt = get_event_detail($eid, $item_id);
499 if ($evt['show_participants']) {
500 new_group_page('xnetevents/admin.tpl');
502 new_groupadmin_page('xnetevents/admin.tpl');
505 if (may_update() && Post
::v('adm')) {
506 $member = get_infos(Post
::v('mail'));
508 $page->trig("Membre introuvable");
511 // change the price paid by a participant
512 if (Env
::v('adm') == 'prix' && $member) {
513 XDB
::execute("UPDATE groupex.evenements_participants
514 SET paid = IF(paid + {?} > 0, paid + {?}, 0)
515 WHERE uid = {?} AND eid = {?}",
516 strtr(Env
::v('montant'), ',', '.'),
517 strtr(Env
::v('montant'), ',', '.'),
518 $member['uid'], $evt['eid']);
521 // change the number of personns coming with a participant
522 if (Env
::v('adm') == 'nbs' && $member) {
523 $res = XDB
::query("SELECT paid
524 FROM groupex.evenements_participants
525 WHERE uid = {?} AND eid = {?}",
526 $member['uid'], $evt['eid']);
528 $paid = intval($res->fetchOneCell());
529 $nbs = Post
::v('nb', array());
531 foreach ($nbs as $id => $nb) {
532 $nb = max(intval($nb), 0);
535 XDB
::execute("REPLACE INTO groupex.evenements_participants
536 VALUES ({?}, {?}, {?}, {?}, {?})",
537 $evt['eid'], $member['uid'], $id, $nb, $paid);
539 XDB
::execute("DELETE FROM groupex.evenements_participants
540 WHERE uid = {?} AND eid = {?} AND item_id = {?}",
541 $member['uid'], $evt['eid'], $id);
545 $res = XDB
::query("SELECT uid
546 FROM groupex.evenements_participants
547 WHERE uid = {?} AND eid = {?}",
548 $member['uid'], $evt['eid']);
549 $u = $res->fetchOneCell();
550 subscribe_lists_event($u, $member['uid'], $evt);
553 $evt = get_event_detail($eid, $item_id);
556 $page->assign('admin', may_update());
557 $page->assign('evt', $evt);
558 $page->assign('tout', is_null($item_id));
560 if (count($evt['moments'])) {
561 $page->assign('moments', $evt['moments']);
564 $tri = (Env
::v('order') == 'alpha' ?
'promo, nom, prenom' : 'nom, prenom, promo');
565 $whereitemid = is_null($item_id) ?
'' : "AND ep.item_id = $item_id";
567 'SELECT UPPER(SUBSTRING(IF(u.nom IS NULL, m.nom,
568 IF(u.nom_usage<>"", u.nom_usage, u.nom)), 1, 1)),
569 COUNT(DISTINCT ep.uid)
570 FROM groupex.evenements_participants AS ep
571 INNER JOIN groupex.evenements AS e ON (ep.eid = e.eid)
572 LEFT JOIN groupex.membres AS m ON ( ep.uid = m.uid AND e.asso_id = m.asso_id)
573 LEFT JOIN auth_user_md5 AS u ON ( u.user_id = ep.uid )
574 WHERE ep.eid = {?} '.$whereitemid.'
575 GROUP BY UPPER(SUBSTRING(IF(u.nom IS NULL,m.nom,u.nom), 1, 1))', $evt['eid']);
579 while (list($char, $nb) = $res->next()) {
580 $alphabet[ord($char)] = $char;
582 if (Env
::has('initiale') && $char == strtoupper(Env
::v('initiale'))) {
587 $page->assign('alphabet', $alphabet);
589 $ofs = Env
::i('offset');
590 $tot = Env
::v('initiale') ?
$tot : $nb_tot;
591 $nbp = intval(($tot-1)/NB_PER_PAGE
);
594 $links['précédent'] = $ofs-1;
596 for ($i = 0; $i <= $nbp; $i++
) {
597 $links[(string)($i+
1)] = $i;
600 $links['suivant'] = $ofs+
1;
602 if (count($links)>1) {
603 $page->assign('links', $links);
606 if ($evt['paiement_id']) {
607 $res = XDB
::iterator(
608 "SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom, u.prenom,
609 u.promo, a.alias AS email, t.montant
610 FROM {$globals->money->mpay_tprefix}transactions AS t
611 INNER JOIN auth_user_md5 AS u ON(t.uid = u.user_id)
612 INNER JOIN aliases AS a ON (a.id = t.uid AND a.type='a_vie' )
613 LEFT JOIN groupex.evenements_participants AS ep ON(ep.uid = t.uid AND ep.eid = {?})
614 WHERE t.ref = {?} AND ep.uid IS NULL",
615 $evt['eid'], $evt['paiement_id']);
616 $page->assign('oublis', $res->total());
617 $page->assign('oubliinscription', $res);
620 $page->assign('participants',
621 get_event_participants($evt, $item_id, $tri,
622 "LIMIT ".($ofs*NB_PER_PAGE
).", ".NB_PER_PAGE
));