3 require_once 'xnet.inc.php';
5 new_group_page('xnet/groupe/evt-detail.tpl');
7 if (!Env
::get("eid")) {
8 redirect("evenements.php");
11 $may_participate = !$members_only ||
is_member() ||
may_update();
12 $page->assign('may_participate', $may_participate);
14 if (Env
::get('ins')) {
16 for ($i=1; Env
::has('item_id'.$i); $i++
)
17 $total +
= (Env
::get('item_'.Env
::get('item_id'.$i)) > 0)?Env
::get('item_'.Env
::get('item_id'.$i)):0;
19 $participate = $total > 0;
20 $res = $globals->xdb
->query("SELECT paid FROM groupex.evenements_participants WHERE eid = {?} AND uid = {?}", Env
::get("eid"), Session
::get("uid"));
21 $paid = $res->fetchOneCell();
22 if (!$paid) $paid = 0;
24 // prevent desinscription if there is a manual paiement
25 if (!$participate && $paid) {
26 $page->trig("Impossible de te désinscrire complètement parce que tu as fait un paiement par chèque ou par liquide. Contacte un administrateur du groupe si tu es sûr de ne pas venir");
28 $page->assign('no_ins', true
);
30 for ($i=1; Env
::has('item_id'.$i); $i++
)
32 $j = Env
::get('item_id'.$i);
33 $nb = Env
::get('item_'.$j);
34 if ($nb == '+') $nb = Env
::get('itemnb_'.$j)+
1;
36 $globals->xdb
->execute(
37 "REPLACE INTO groupex.evenements_participants
38 VALUES ({?}, {?}, {?}, {?}, {?})",
39 Env
::get("eid"), Session
::get("uid"), $j, $nb, $paid);
41 $globals->xdb
->execute(
42 "DELETE FROM groupex.evenements_participants
43 WHERE eid = {?} AND uid = {?} AND item_id = {?}",
44 Env
::get("eid"), Session
::get("uid"), $j);
49 require_once('xnet/evenements.php');
50 $evt = get_event_detail(Env
::get('eid'));
53 redirect("evenements.php");
56 if (Env
::has('ins')) {
57 subscribe_lists_event($participate, Session
::get("uid"), $evt['participant_list'], $evt['absent_list']);
58 redirect("evenements.php?backfrom=".Env
::get('eid'));
61 $page->assign('participate', $participate);
62 $page->assign('evt', $evt);
64 $moments = $globals->xdb
->iterator(
65 "SELECT titre, i.item_id, details, montant, nb
66 FROM groupex.evenements_items AS i
67 LEFT JOIN groupex.evenements_participants AS p
68 ON(i.eid = p.eid AND i.item_id = p.item_id AND uid = {?})
70 Session
::get('uid'), Env
::get('eid'));
72 $page->assign('moments', $moments);
75 $res = $globals->xdb
->query("SELECT paid FROM groupex.evenements_participants WHERE eid = {?} AND uid = {?}", Env
::get("eid"), Session
::get("uid"));
76 $paid = $res->fetchOneCell();
77 $page->assign('paid_manual', $paid);
79 if ($evt['paiement_id']) {
80 $res = $globals->xdb
->query(
82 FROM {$globals->money->mpay_tprefix}transactions AS t
83 WHERE ref = {?} AND uid = {?}",
84 $evt['paiement_id'], Session
::getInt('uid', -1));
85 $montants = $res->fetchColumn();
86 foreach ($montants as $m) {
87 $p = strtr(substr($m, 0, strpos($m, "EUR")), ",", ".");
91 $page->assign('paid', $paid);