[platal.git] / modules / xnetevents.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2006 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

define('NB_PER_PAGE', 25);

class XnetEventsModule extends PLModule
{
    function handlers()
    {
        return array(
            '%grp/events'       => $this->make_hook('events',  AUTH_MDP),
            '%grp/events/sub'   => $this->make_hook('sub',     AUTH_MDP),
            '%grp/events/csv'   => $this->make_hook('csv',     AUTH_MDP),
            '%grp/events/ical'  => $this->make_hook('ical',    AUTH_MDP),
            '%grp/events/edit'  => $this->make_hook('edit',    AUTH_MDP),
            '%grp/events/admin' => $this->make_hook('admin',   AUTH_MDP),
        );
    }

    function handler_events(&$page, $archive = null)
    {
        global $globals;

        if ($archive == 'archive') {
            $archive = true;
            new_groupadmin_page('xnetevents/index.tpl');
        } else {
            $archive = false;
            new_group_open_page('xnetevents/index.tpl');
        }

        $action = null;
        if (Post::has('del')) {
            $action = 'del';
            $eid = Post::v('del');
        } elseif (Post::has('archive')) {
            $action = 'archive';
            $eid = Post::v('archive');
        } elseif (Post::has('unarchive')) {
            $action = 'unarchive';
            $eid = Post::v('unarchive');
        }

        if (!is_null($action)) {
            if (!may_update()) {
                return PL_NOT_ALLOWED;
            }

            $res = XDB::query("SELECT asso_id, short_name FROM groupex.evenements
                                WHERE eid = {?} AND asso_id = {?}",
                              $eid, $globals->asso('id'));

            $tmp = $res->fetchOneRow();
            if (!$tmp) {
                return PL_NOT_ALLOWED;
            }
        }

        if ($action == 'del') {
            // deletes the event mailing aliases
            if ($tmp[1]) {
                XDB::execute(
                    "DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
                    $tmp[1].'-absents@%');
                XDB::execute(
                    "DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
                    $tmp[1].'-participants@%');
            }

            // deletes the event items
            XDB::execute("DELETE FROM groupex.evenements_items WHERE eid = {?}", $eid);

            // deletes the event participants
            XDB::execute("DELETE FROM groupex.evenements_participants
                                    WHERE eid = {?}", $eid);

            // deletes the event
            XDB::execute("DELETE FROM groupex.evenements
                                    WHERE eid = {?} AND asso_id = {?}",
                                   $eid, $globals->asso('id'));

            // delete the requests for payments
            require_once 'validations.inc.php';
            XDB::execute("DELETE FROM requests
                                    WHERE type = 'paiements' AND data LIKE {?}",
                                   PayReq::same_event($eid, $globals->asso('id')));
        }

        if ($action == 'archive') {
            XDB::execute("UPDATE groupex.evenements
                             SET archive = 1
                           WHERE eid = {?} AND asso_id = {?}",
                         $eid, $globals->asso('id'));
        }

        if ($action == 'unarchive') {
            XDB::execute("UPDATE groupex.evenements
                             SET archive = 0
                           WHERE eid = {?} AND asso_id = {?}",
                         $eid, $globals->asso('id'));
        }

        $page->assign('archive', $archive);
        $page->assign('admin', may_update());

        $evenements = XDB::iterator(
                "SELECT  e.*, LEFT(10, e.debut) AS debut_day, LEFT(10, e.fin) AS fin_day,
                         IF(e.deadline_inscription, e.deadline_inscription >= LEFT(NOW(), 10),
                            1) AS inscr_open, e.deadline_inscription,
                         u.nom, u.prenom, u.promo, a.alias,
                         MAX(ep.nb) AS inscrit, MAX(ep.paid) AS paid
                  FROM  groupex.evenements  AS e
            INNER JOIN  x4dat.auth_user_md5 AS u ON u.user_id = e.organisateur_uid
            INNER JOIN  x4dat.aliases       AS a ON (a.type = 'a_vie' AND a.id = u.user_id)
             LEFT JOIN  groupex.evenements_participants AS ep ON (ep.eid = e.eid AND ep.uid = {?})
                 WHERE  asso_id = {?}
                   AND  archive = " . ($archive ? "1 " : "0 ")
            . (is_member() || may_update() ? "" : " AND accept_nonmembre != 0 ")
              . "GROUP BY  e.eid
                 ORDER BY  inscr_open DESC, debut DESC", S::v('uid'), $globals->asso('id'));

        $evts = array();

        while ($e = $evenements->next()) {
            $e['show_participants'] = ($e['show_participants'] && (is_member() || may_update()));
            $res = XDB::query(
                "SELECT titre, details, montant, ei.item_id, nb
                   FROM groupex.evenements_items AS ei
              LEFT JOIN groupex.evenements_participants AS ep
                        ON (ep.eid = ei.eid AND ep.item_id = ei.item_id AND uid = {?})
                  WHERE ei.eid = {?}",
                    S::v('uid'), $e['eid']);
            $e['moments'] = $res->fetchAllAssoc();

            $e['topay'] = 0;
            foreach ($e['moments'] as $m) {
                $e['topay'] += $m['nb'] * $m['montant'];
            }

            $query = XDB::query(
                "SELECT montant
                   FROM {$globals->money->mpay_tprefix}transactions AS t
                 WHERE ref = {?} AND uid = {?}", $e['paiement_id'], S::v('uid'));
            $montants = $query->fetchColumn();

            foreach ($montants as $m) {
                $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
                $e['paid'] += trim($p);
            }

            $evts[] = $e;
        }

        $page->assign('evenements', $evts);
        $page->assign('is_member', is_member());
    }

    function handler_sub(&$page, $eid = null)
    {
        require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';

        new_group_open_page('xnetevents/subscribe.tpl');

        $evt = get_event_detail($eid);
        if (!$evt) {
            return PL_NOT_FOUND;
        }

        if (!$evt['inscr_open']) {
            $page->kill('Les inscriptions pour cet �v�nement sont closes');
        }
        if (!$evt['accept_nonmembre'] && !is_member() && !may_update()) {
            $page->kill('Cet �v�nement est ferm� aux non-membres du groupe');
        }

        $page->assign('event', $evt);

        if (!Post::has('submit')) {
            return;
        }

        $moments = Post::v('moment',    array());
        $pers    = Post::v('personnes', array());
        $subs    = array();

        foreach ($moments as $j => $v) {
            $subs[$j] = intval($v);

            // retreive ohter field when more than one person
            if ($subs[$j] == 2) {
                if (!isset($pers[$j]) || !is_numeric($pers[$j])
                ||  $pers[$j] < 0)
                {
                    $page->trig('Tu dois choisir un nombre d\'invit�s correct !');
                    return;
                }
                $subs[$j] = 1 + $pers[$j];
            }
        }

        // impossible to unsubscribe if you already paid sthing
        if (array_sum($subs) && $evt['paid'] != 0) {
            $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");
            return;
        }

        // update actual inscriptions
        foreach ($subs as $j => $nb) {
            if ($nb > 0) {
                XDB::execute(
                    "REPLACE INTO  groupex.evenements_participants
                           VALUES  ({?}, {?}, {?}, {?}, {?})",
                    $eid, S::v('uid'), $j, $nb, $evt['paid']);
                $page->assign('updated', true);
            } else {
                XDB::execute(
                    "DELETE FROM  groupex.evenements_participants
                           WHERE  eid = {?} AND uid = {?} AND item_id = {?}",
                    $eid, S::v("uid"), $j);		
                $page->assign('updated', true);
            }
        }

        $page->assign('event', get_event_detail($eid));
    }

    function handler_csv(&$page, $eid = null, $item_id = null)
    {
        require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';

        if (!is_numeric($item_id)) {
            $item_id = null;
        }

        $evt = get_event_detail($eid, $item_id);
        if (!$evt) {
            return PL_NOT_FOUND;
        }

        header('Content-type: text/x-csv; encoding=iso-8859-1');
        header('Pragma: ');
        header('Cache-Control: ');

        $page->changeTpl('xnetevents/csv.tpl', NO_SKIN);

        $admin = may_update();

        $tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');

        $page->assign('participants',
                      get_event_participants($evt, $item_id, $tri));

        $page->assign('admin', $admin);
        $page->assign('moments', $evt['moments']);
        $page->assign('money', $evt['money']);
        $page->assign('tout', !Env::v('item_id', false));
    }

    function handler_ical(&$page, $eid = null)
    {
        global $globals;

        require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
        $evt = get_event_detail($eid);
        if (!$evt) {
            return PL_NOT_FOUND;
        }
        $evt['debut'] = preg_replace('/(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)/', "\\1\\2\\3T\\4\\5\\6", $evt['debut']);
        $evt['fin'] = preg_replace('/(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)/', "\\1\\2\\3T\\4\\5\\6", $evt['fin']);

        $page->changeTpl('xnetevents/calendar.tpl', NO_SKIN);

        require_once(dirname(__FILE__).'/carnet/smarty.php');
        $page->assign('asso', $globals->asso());
        $page->assign('timestamp', time());
        $page->register_function('display_ical', 'display_ical');
        $page->assign_by_ref('e', $evt);
    
        header('Content-Type: text/calendar; charset=utf-8');
    }

    function handler_edit(&$page, $eid = null)
    {
        global $globals;

        // check the event is in our group
        if (!is_null($eid)) {
            $res = XDB::query("SELECT short_name, asso_id
                                           FROM groupex.evenements
                                          WHERE eid = {?}", $eid);
            $infos = $res->fetchOneAssoc();
            if ($infos['asso_id'] != $globals->asso('id')) {
                return PL_NOT_ALLOWED;
            }
        }

        new_groupadmin_page('xnetevents/edit.tpl');

        $moments = range(1, 4);
        $page->assign('moments', $moments);

        if (Post::v('intitule')) {
            require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
            $short_name = event_change_shortname($page, $infos['short_name'],
                                                 Env::v('short_name', ''));

            $evt = array(
                'eid'              => $eid,
                'asso_id'          => $globals->asso('id'),
                'organisateur_uid' => S::v('uid'),
                'paiement_id'      => Post::v('paiement_id') > 0 ? Post::v('paiement_id') : null,
                'debut'            => Post::v('deb_Year').'-'.Post::v('deb_Month')
                                      .'-'.Post::v('deb_Day').' '.Post::v('deb_Hour')
                                      .':'.Post::v('deb_Minute').':00',
                'fin'              => Post::v('fin_Year').'-'.Post::v('fin_Month')
                                      .'-'.Post::v('fin_Day').' '.Post::v('fin_Hour')
                                      .':'.Post::v('fin_Minute').':00',
                'short_name'       => $short_name,
            );

            $trivial = array('intitule', 'descriptif', 'noinvite',
                             'show_participants', 'accept_nonmembre');
            foreach ($trivial as $k) {
                $evt[$k] = Post::v($k);
            }

            if (Post::v('deadline')) {
                $evt['deadline_inscription'] = Post::v('inscr_Year').'-'
                                             . Post::v('inscr_Month').'-'
                                             . Post::v('inscr_Day');
            } else {
                $evt['deadline_inscription'] = null;
            }

            // Store the modifications in the database
            XDB::execute('REPLACE INTO groupex.evenements
                SET eid={?}, asso_id={?}, organisateur_uid={?}, intitule={?},
                    paiement_id = {?}, descriptif = {?}, debut = {?},
                    fin = {?}, show_participants = {?}, short_name = {?},
                    deadline_inscription = {?}, noinvite = {?},
                    accept_nonmembre = {?}',
                    $evt['eid'], $evt['asso_id'], $evt['organisateur_uid'],
                    $evt['intitule'], $evt['paiement_id'], $evt['descriptif'],
                    $evt['debut'], $evt['fin'], $evt['show_participants'],
                    $evt['short_name'], $evt['deadline_inscription'],
                    $evt['noinvite'], $evt['accept_nonmembre']);

            // if new event, get its id
            if (!$eid) {
                $eid = mysql_insert_id();
            }

            $nb_moments   = 0;
            $money_defaut = 0;

            foreach ($moments as $i) {
                if (Post::v('titre'.$i)) {
                    $nb_moments++;

                    $montant = strtr(Post::v('montant'.$i), ',', '.');
                    $money_defaut += (float)$montant;
                    XDB::execute("
                        REPLACE INTO groupex.evenements_items
                        VALUES ({?}, {?}, {?}, {?}, {?})",
                        $eid, $i, Post::v('titre'.$i),
                        Post::v('details'.$i), $montant);
                } else {
                    XDB::execute("DELETE FROM groupex.evenements_items 
                                            WHERE eid = {?} AND item_id = {?}", $eid, $i);
                }
            }

            // request for a new payment
            if (Post::v('paiement_id') == -1 && $money_defaut >= 0) {
                require_once 'validations.inc.php';
                $p = new PayReq(S::v('uid'),
                                Post::v('intitule')." - ".$globals->asso('nom'),
                                Post::v('site'), $money_defaut,
                                Post::v('confirmation'), 0, 999,
                                $globals->asso('id'), $eid);
                $p->submit();
            }

            // events with no sub-event: add a sub-event with no name
            if ($nb_moments == 0) {
                XDB::execute("INSERT INTO groupex.evenements_items
                                        VALUES ({?}, {?}, '', '', 0)", $eid, 1);
            }

            if (is_null($evt['eid'])) {
                pl_redirect('events/'.$eid);
            }
        }

        // get a list of all the payment for this asso
        $res = XDB::iterator("SELECT id, text
                                        FROM {$globals->money->mpay_tprefix}paiements
                                        WHERE asso_id = {?}", $globals->asso('id'));
        $paiements = array();
        while ($a = $res->next()) $paiements[$a['id']] = $a['text']; {
            $page->assign('paiements', $paiements);
        }

        // when modifying an old event retreive the old datas
        if ($eid) {
            $res = XDB::query(
                    "SELECT	eid, intitule, descriptif, debut, fin,
                                show_participants, paiement_id, short_name,
                                deadline_inscription, noinvite, accept_nonmembre
                       FROM	groupex.evenements
                      WHERE eid = {?}", $eid);
            $evt = $res->fetchOneAssoc();
            // find out if there is already a request for a payment for this event
            require_once 'validations.inc.php';
            $res = XDB::query("SELECT stamp FROM requests
                                         WHERE type = 'paiements' AND data LIKE {?}",
                                        PayReq::same_event($eid, $globals->asso('id')));
            $stamp = $res->fetchOneCell();
            if ($stamp) {
                $evt['paiement_id'] = -2;
                $evt['paiement_req'] = $stamp;
            }
            $page->assign('evt', $evt);
            // get all the different moments infos
            $res = XDB::iterator(
                    "SELECT item_id, titre, details, montant
                       FROM groupex.evenements_items AS ei
                 INNER JOIN groupex.evenements AS e ON(e.eid = ei.eid)
                      WHERE e.eid = {?}
                   ORDER BY item_id", $eid);
            $items = array();
            while ($item = $res->next()) {
                $items[$item['item_id']] = $item;
            }
            $page->assign('items', $items);
        }
    }

    function handler_admin(&$page, $eid = null, $item_id = null)
    {
        global $globals;

        require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';

        $evt = get_event_detail($eid, $item_id);
        if (!$evt) {
            return PL_NOT_FOUND;
        }

        if ($evt['show_participants']) {
            new_group_page('xnetevents/admin.tpl');
        } else {
            new_groupadmin_page('xnetevents/admin.tpl');
        }

        if (may_update() && Post::v('adm')) {
            $member = get_infos(Post::v('mail'));
            if (!$member) {
                $page->trig("Membre introuvable");
            }

            // change the price paid by a participant
            if (Env::v('adm') == 'prix' && $member) {
                XDB::execute("UPDATE groupex.evenements_participants
                                           SET paid = IF(paid + {?} > 0, paid + {?}, 0)
                                         WHERE uid = {?} AND eid = {?}",
                        strtr(Env::v('montant'), ',', '.'),
                        strtr(Env::v('montant'), ',', '.'),
                        $member['uid'], $eid);
            }

            // change the number of personns coming with a participant
            if (Env::v('adm') == 'nbs' && $member) {
                $res = XDB::query("SELECT paid
                                               FROM groupex.evenements_participants
                                              WHERE uid = {?} AND eid = {?}",
                                            $member['uid'], $eid);

                $paid = intval($res->fetchOneCell());
                $nbs  = Post::v('nb', array());

                foreach ($nbs as $id => $nb) {
                    $nb = max(intval($nb), 0);

                    if ($nb) {
                        XDB::execute("REPLACE INTO groupex.evenements_participants
                                               VALUES ({?}, {?}, {?}, {?}, {?})",
                                               $eid, $member['uid'], $id, $nb, $paid);
                    } else {
                        XDB::execute("DELETE FROM groupex.evenements_participants
                                               WHERE uid = {?} AND eid = {?} AND item_id = {?}",
                                               $member['uid'], $eid, $id);
                    }
                }

                $res = XDB::query("SELECT uid FROM groupex.evenements_participants
                                            WHERE uid = {?} AND eid = {?}",
                                            $member['uid'], $eid);
                $u = $res->fetchOneCell();
                subscribe_lists_event($u, $member['uid'], $evt);
            }

            $evt = get_event_detail($eid, $item_id);
        }

        $page->assign('admin', may_update());
        $page->assign('evt', $evt);
        $page->assign('tout', is_null($item_id));

        if (count($evt['moments'])) {
            $page->assign('moments', $evt['moments']);
        }

        $tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
        $whereitemid = is_null($item_id) ? '' : "AND ep.item_id = $item_id";
        $res = XDB::iterRow(
                    'SELECT  UPPER(SUBSTRING(IF(u.nom IS NULL, m.nom,
                                                IF(u.nom_usage<>"", u.nom_usage, u.nom)), 1, 1)),
                             COUNT(DISTINCT ep.uid)
                       FROM  groupex.evenements_participants AS ep
                 INNER JOIN  groupex.evenements AS e ON (ep.eid = e.eid)
                  LEFT JOIN  groupex.membres AS m ON ( ep.uid = m.uid AND e.asso_id = m.asso_id)
                  LEFT JOIN  auth_user_md5   AS u ON ( u.user_id = ep.uid )
                      WHERE  ep.eid = {?} '.$whereitemid.'
                   GROUP BY  UPPER(SUBSTRING(IF(u.nom IS NULL,m.nom,u.nom), 1, 1))', $eid);

        $alphabet = array();
        $nb_tot = 0;
        while (list($char, $nb) = $res->next()) {
            $alphabet[ord($char)] = $char;
            $nb_tot += $nb;
            if (Env::has('initiale') && $char == strtoupper(Env::v('initiale'))) {
                $tot = $nb;
            }
        }
        ksort($alphabet);
        $page->assign('alphabet', $alphabet);

        $ofs   = Env::i('offset');
        $tot   = Env::v('initiale') ? $tot : $nb_tot;
        $nbp   = intval(($tot-1)/NB_PER_PAGE);
        $links = array();
        if ($ofs) {
            $links['pr�c�dent'] = $ofs-1;
        }
        for ($i = 0; $i <= $nbp; $i++) {
            $links[(string)($i+1)] = $i;
        }
        if ($ofs < $nbp) {
            $links['suivant'] = $ofs+1;
        }
        if (count($links)>1) {
            $page->assign('links', $links);
        }

        if ($evt['paiement_id']) {
            $res = XDB::iterator(
                "SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom, u.prenom,
                        u.promo, a.alias AS email, t.montant
                   FROM {$globals->money->mpay_tprefix}transactions AS t
                 INNER JOIN auth_user_md5 AS u ON(t.uid = u.user_id)
                 INNER JOIN aliases AS a ON (a.id = t.uid AND a.type='a_vie' )
                  LEFT JOIN groupex.evenements_participants AS ep ON(ep.uid = t.uid AND ep.eid = {?})
                  WHERE t.ref = {?} AND ep.uid IS NULL",
                  $evt['eid'], $evt['paiement_id']);
            $page->assign('oublis', $res->total());
            $page->assign('oubliinscription', $res);
        }

        $page->assign('participants', 
                      get_event_participants($evt, $item_id, $tri,
                                             "LIMIT ".($ofs*NB_PER_PAGE).", ".NB_PER_PAGE));
    }
}

?>
Commit	Line	Data
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	22	define('NB_PER_PAGE', 25);
ed21e24a	23
4f10a058	24	class XnetEventsModule extends PLModule
	25	{
	26	function handlers()
	27	{
	28	return array(
d1ebc57a	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),
11d8a183	32	'%grp/events/ical' => $this->make_hook('ical', AUTH_MDP),
d1ebc57a	33	'%grp/events/edit' => $this->make_hook('edit', AUTH_MDP),
d1ebc57a	34	'%grp/events/admin' => $this->make_hook('admin', AUTH_MDP),
4f10a058	35	);
	36	}
	37
f02eefd4	38	function handler_events(&$page, $archive = null)
4f10a058	39	{
	40	global $globals;
	41
f02eefd4	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	}
4f10a058	49
f02eefd4	50	$action = null;
2b9e5fd3	51	if (Post::has('del')) {
f02eefd4	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)) {
2b9e5fd3	63	if (!may_update()) {
	64	return PL_NOT_ALLOWED;
	65	}
	66
08cce2ff	67	$res = XDB::query("SELECT asso_id, short_name FROM groupex.evenements
3cabafae	68	WHERE eid = {?} AND asso_id = {?}",
3cabafae	69	$eid, $globals->asso('id'));
2b9e5fd3	70
	71	$tmp = $res->fetchOneRow();
	72	if (!$tmp) {
	73	return PL_NOT_ALLOWED;
	74	}
f02eefd4	75	}
2b9e5fd3	76
f02eefd4	77	if ($action == 'del') {
2b9e5fd3	78	// deletes the event mailing aliases
2b9e5fd3	79	if ($tmp[1]) {
08cce2ff	80	XDB::execute(
5070a22d	81	"DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
5070a22d	82	$tmp[1].'-absents@%');
08cce2ff	83	XDB::execute(
5070a22d	84	"DELETE FROM virtual WHERE type = 'evt' AND alias LIKE {?}",
5070a22d	85	$tmp[1].'-participants@%');
2b9e5fd3	86	}
	87
	88	// deletes the event items
08cce2ff	89	XDB::execute("DELETE FROM groupex.evenements_items WHERE eid = {?}", $eid);
2b9e5fd3	90
2b9e5fd3	91	// deletes the event participants
08cce2ff	92	XDB::execute("DELETE FROM groupex.evenements_participants
2b9e5fd3	93	WHERE eid = {?}", $eid);
	94
	95	// deletes the event
08cce2ff	96	XDB::execute("DELETE FROM groupex.evenements
2b9e5fd3	97	WHERE eid = {?} AND asso_id = {?}",
	98	$eid, $globals->asso('id'));
	99
	100	// delete the requests for payments
	101	require_once 'validations.inc.php';
08cce2ff	102	XDB::execute("DELETE FROM requests
2b9e5fd3	103	WHERE type = 'paiements' AND data LIKE {?}",
	104	PayReq::same_event($eid, $globals->asso('id')));
	105	}
	106
f02eefd4	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);
4f10a058	122	$page->assign('admin', may_update());
4f10a058	123
08cce2ff	124	$evenements = XDB::iterator(
d6d580ec	125	"SELECT e.*, LEFT(10, e.debut) AS debut_day, LEFT(10, e.fin) AS fin_day,
bd46a8e4	126	IF(e.deadline_inscription, e.deadline_inscription >= LEFT(NOW(), 10),
d6d580ec	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
4f10a058	131	INNER JOIN x4dat.auth_user_md5 AS u ON u.user_id = e.organisateur_uid
d6d580ec	132	INNER JOIN x4dat.aliases AS a ON (a.type = 'a_vie' AND a.id = u.user_id)
4f10a058	133	LEFT JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND ep.uid = {?})
f02eefd4	134	WHERE asso_id = {?}
f02eefd4	135	AND archive = " . ($archive ? "1 " : "0 ")
3cabafae	136	. (is_member() \|\| may_update() ? "" : " AND accept_nonmembre != 0 ")
3cabafae	137	. "GROUP BY e.eid
cb24457f	138	ORDER BY inscr_open DESC, debut DESC", S::v('uid'), $globals->asso('id'));
4f10a058	139
4f10a058	140	$evts = array();
d6d580ec	141
4f10a058	142	while ($e = $evenements->next()) {
3cabafae	143	$e['show_participants'] = ($e['show_participants'] && (is_member() \|\| may_update()));
08cce2ff	144	$res = XDB::query(
4f10a058	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 = {?}",
cab08090	150	S::v('uid'), $e['eid']);
d6d580ec	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
08cce2ff	158	$query = XDB::query(
4f10a058	159	"SELECT montant
4f10a058	160	FROM {$globals->money->mpay_tprefix}transactions AS t
cab08090	161	WHERE ref = {?} AND uid = {?}", $e['paiement_id'], S::v('uid'));
4f10a058	162	$montants = $query->fetchColumn();
d6d580ec	163
4f10a058	164	foreach ($montants as $m) {
d6d580ec	165	$p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
4f10a058	166	$e['paid'] += trim($p);
4f10a058	167	}
d6d580ec	168
4f10a058	169	$evts[] = $e;
	170	}
	171
	172	$page->assign('evenements', $evts);
	173	$page->assign('is_member', is_member());
	174	}
	175
d6d580ec	176	function handler_sub(&$page, $eid = null)
d6d580ec	177	{
352fb101	178	require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
d6d580ec	179
3cabafae	180	new_group_open_page('xnetevents/subscribe.tpl');
d6d580ec	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	}
3cabafae	190	if (!$evt['accept_nonmembre'] && !is_member() && !may_update()) {
	191	$page->kill('Cet �v�nement est ferm� aux non-membres du groupe');
	192	}
d6d580ec	193
	194	$page->assign('event', $evt);
	195
	196	if (!Post::has('submit')) {
	197	return;
	198	}
	199
5e2307dc	200	$moments = Post::v('moment', array());
5e2307dc	201	$pers = Post::v('personnes', array());
d6d580ec	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) {
08cce2ff	232	XDB::execute(
d6d580ec	233	"REPLACE INTO groupex.evenements_participants
d6d580ec	234	VALUES ({?}, {?}, {?}, {?}, {?})",
cab08090	235	$eid, S::v('uid'), $j, $nb, $evt['paid']);
5070a22d	236	$page->assign('updated', true);
d6d580ec	237	} else {
08cce2ff	238	XDB::execute(
d6d580ec	239	"DELETE FROM groupex.evenements_participants
d6d580ec	240	WHERE eid = {?} AND uid = {?} AND item_id = {?}",
cab08090	241	$eid, S::v("uid"), $j);
5070a22d	242	$page->assign('updated', true);
d6d580ec	243	}
	244	}
	245
	246	$page->assign('event', get_event_detail($eid));
	247	}
	248
4f10a058	249	function handler_csv(&$page, $eid = null, $item_id = null)
4f10a058	250	{
352fb101	251	require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
4f10a058	252
bd46a8e4	253	if (!is_numeric($item_id)) {
	254	$item_id = null;
	255	}
	256
4f10a058	257	$evt = get_event_detail($eid, $item_id);
	258	if (!$evt) {
	259	return PL_NOT_FOUND;
	260	}
	261
dba106f6	262	header('Content-type: text/x-csv; encoding=iso-8859-1');
4f10a058	263	header('Pragma: ');
	264	header('Cache-Control: ');
	265
801fcad8	266	$page->changeTpl('xnetevents/csv.tpl', NO_SKIN);
4f10a058	267
	268	$admin = may_update();
	269
5e2307dc	270	$tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
4f10a058	271
ed21e24a	272	$page->assign('participants',
ed21e24a	273	get_event_participants($evt, $item_id, $tri));
4f10a058	274
4f10a058	275	$page->assign('admin', $admin);
	276	$page->assign('moments', $evt['moments']);
	277	$page->assign('money', $evt['money']);
5e2307dc	278	$page->assign('tout', !Env::v('item_id', false));
4f10a058	279	}
bd46a8e4	280
11d8a183	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
bd46a8e4	304	function handler_edit(&$page, $eid = null)
	305	{
	306	global $globals;
	307
5070a22d	308	// check the event is in our group
bd46a8e4	309	if (!is_null($eid)) {
08cce2ff	310	$res = XDB::query("SELECT short_name, asso_id
bd46a8e4	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
5070a22d	319	new_groupadmin_page('xnetevents/edit.tpl');
bd46a8e4	320
5070a22d	321	$moments = range(1, 4);
5070a22d	322	$page->assign('moments', $moments);
bd46a8e4	323
5e2307dc	324	if (Post::v('intitule')) {
5070a22d	325	require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
5070a22d	326	$short_name = event_change_shortname($page, $infos['short_name'],
5e2307dc	327	Env::v('short_name', ''));
5070a22d	328
	329	$evt = array(
	330	'eid' => $eid,
	331	'asso_id' => $globals->asso('id'),
cab08090	332	'organisateur_uid' => S::v('uid'),
5e2307dc	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',
5070a22d	340	'short_name' => $short_name,
	341	);
	342
	343	$trivial = array('intitule', 'descriptif', 'noinvite',
3cabafae	344	'show_participants', 'accept_nonmembre');
5070a22d	345	foreach ($trivial as $k) {
5e2307dc	346	$evt[$k] = Post::v($k);
bd46a8e4	347	}
bd46a8e4	348
5e2307dc	349	if (Post::v('deadline')) {
	350	$evt['deadline_inscription'] = Post::v('inscr_Year').'-'
	351	. Post::v('inscr_Month').'-'
	352	. Post::v('inscr_Day');
5070a22d	353	} else {
5070a22d	354	$evt['deadline_inscription'] = null;
9ece1588	355	}
bd46a8e4	356
bd46a8e4	357	// Store the modifications in the database
08cce2ff	358	XDB::execute('REPLACE INTO groupex.evenements
bd46a8e4	359	SET eid={?}, asso_id={?}, organisateur_uid={?}, intitule={?},
5070a22d	360	paiement_id = {?}, descriptif = {?}, debut = {?},
5070a22d	361	fin = {?}, show_participants = {?}, short_name = {?},
3cabafae	362	deadline_inscription = {?}, noinvite = {?},
3cabafae	363	accept_nonmembre = {?}',
5070a22d	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'],
3cabafae	368	$evt['noinvite'], $evt['accept_nonmembre']);
bd46a8e4	369
	370	// if new event, get its id
	371	if (!$eid) {
5070a22d	372	$eid = mysql_insert_id();
bd46a8e4	373	}
bd46a8e4	374
5070a22d	375	$nb_moments = 0;
bd46a8e4	376	$money_defaut = 0;
	377
	378	foreach ($moments as $i) {
5e2307dc	379	if (Post::v('titre'.$i)) {
bd46a8e4	380	$nb_moments++;
5070a22d	381
5e2307dc	382	$montant = strtr(Post::v('montant'.$i), ',', '.');
5070a22d	383	$money_defaut += (float)$montant;
08cce2ff	384	XDB::execute("
bd46a8e4	385	REPLACE INTO groupex.evenements_items
bd46a8e4	386	VALUES ({?}, {?}, {?}, {?}, {?})",
5e2307dc	387	$eid, $i, Post::v('titre'.$i),
5e2307dc	388	Post::v('details'.$i), $montant);
bd46a8e4	389	} else {
08cce2ff	390	XDB::execute("DELETE FROM groupex.evenements_items
bd46a8e4	391	WHERE eid = {?} AND item_id = {?}", $eid, $i);
	392	}
	393	}
	394
	395	// request for a new payment
5e2307dc	396	if (Post::v('paiement_id') == -1 && $money_defaut >= 0) {
bd46a8e4	397	require_once 'validations.inc.php';
cab08090	398	$p = new PayReq(S::v('uid'),
5e2307dc	399	Post::v('intitule')." - ".$globals->asso('nom'),
	400	Post::v('site'), $money_defaut,
	401	Post::v('confirmation'), 0, 999,
bd46a8e4	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) {
08cce2ff	408	XDB::execute("INSERT INTO groupex.evenements_items
bd46a8e4	409	VALUES ({?}, {?}, '', '', 0)", $eid, 1);
bd46a8e4	410	}
bd46a8e4	411
5070a22d	412	if (is_null($evt['eid'])) {
47e64118	413	pl_redirect('events/'.$eid);
5070a22d	414	}
bd46a8e4	415	}
	416
	417	// get a list of all the payment for this asso
08cce2ff	418	$res = XDB::iterator("SELECT id, text
bd46a8e4	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) {
08cce2ff	428	$res = XDB::query(
bd46a8e4	429	"SELECT eid, intitule, descriptif, debut, fin,
9ece1588	430	show_participants, paiement_id, short_name,
3cabafae	431	deadline_inscription, noinvite, accept_nonmembre
bd46a8e4	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';
08cce2ff	437	$res = XDB::query("SELECT stamp FROM requests
bd46a8e4	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
08cce2ff	447	$res = XDB::iterator(
bd46a8e4	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
352fb101	465	require_once dirname(__FILE__).'/xnetevents/xnetevents.inc.php';
bd46a8e4	466
bd46a8e4	467	$evt = get_event_detail($eid, $item_id);
bd46a8e4	468	if (!$evt) {
	469	return PL_NOT_FOUND;
	470	}
	471
	472	if ($evt['show_participants']) {
ed21e24a	473	new_group_page('xnetevents/admin.tpl');
bd46a8e4	474	} else {
ed21e24a	475	new_groupadmin_page('xnetevents/admin.tpl');
bd46a8e4	476	}
bd46a8e4	477
5e2307dc	478	if (may_update() && Post::v('adm')) {
5e2307dc	479	$member = get_infos(Post::v('mail'));
ed21e24a	480	if (!$member) {
ed21e24a	481	$page->trig("Membre introuvable");
bd46a8e4	482	}
bd46a8e4	483
ed21e24a	484	// change the price paid by a participant
5e2307dc	485	if (Env::v('adm') == 'prix' && $member) {
08cce2ff	486	XDB::execute("UPDATE groupex.evenements_participants
ed21e24a	487	SET paid = IF(paid + {?} > 0, paid + {?}, 0)
ed21e24a	488	WHERE uid = {?} AND eid = {?}",
5e2307dc	489	strtr(Env::v('montant'), ',', '.'),
5e2307dc	490	strtr(Env::v('montant'), ',', '.'),
ed21e24a	491	$member['uid'], $eid);
ed21e24a	492	}
bd46a8e4	493
ed21e24a	494	// change the number of personns coming with a participant
5e2307dc	495	if (Env::v('adm') == 'nbs' && $member) {
08cce2ff	496	$res = XDB::query("SELECT paid
ed21e24a	497	FROM groupex.evenements_participants
	498	WHERE uid = {?} AND eid = {?}",
	499	$member['uid'], $eid);
	500
	501	$paid = intval($res->fetchOneCell());
5e2307dc	502	$nbs = Post::v('nb', array());
ed21e24a	503
ed21e24a	504	foreach ($nbs as $id => $nb) {
5070a22d	505	$nb = max(intval($nb), 0);
ed21e24a	506
ed21e24a	507	if ($nb) {
08cce2ff	508	XDB::execute("REPLACE INTO groupex.evenements_participants
ed21e24a	509	VALUES ({?}, {?}, {?}, {?}, {?})",
	510	$eid, $member['uid'], $id, $nb, $paid);
	511	} else {
08cce2ff	512	XDB::execute("DELETE FROM groupex.evenements_participants
ed21e24a	513	WHERE uid = {?} AND eid = {?} AND item_id = {?}",
	514	$member['uid'], $eid, $id);
	515	}
bd46a8e4	516	}
ed21e24a	517
08cce2ff	518	$res = XDB::query("SELECT uid FROM groupex.evenements_participants
ed21e24a	519	WHERE uid = {?} AND eid = {?}",
ed21e24a	520	$member['uid'], $eid);
bd46a8e4	521	$u = $res->fetchOneCell();
ed21e24a	522	subscribe_lists_event($u, $member['uid'], $evt);
bd46a8e4	523	}
ed21e24a	524
bd46a8e4	525	$evt = get_event_detail($eid, $item_id);
	526	}
	527
ed21e24a	528	$page->assign('admin', may_update());
bd46a8e4	529	$page->assign('evt', $evt);
1f3362a3	530	$page->assign('tout', is_null($item_id));
bd46a8e4	531
ed21e24a	532	if (count($evt['moments'])) {
	533	$page->assign('moments', $evt['moments']);
	534	}
bd46a8e4	535
5e2307dc	536	$tri = (Env::v('order') == 'alpha' ? 'promo, nom, prenom' : 'nom, prenom, promo');
1f3362a3	537	$whereitemid = is_null($item_id) ? '' : "AND ep.item_id = $item_id";
08cce2ff	538	$res = XDB::iterRow(
ed21e24a	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)
bd46a8e4	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.'
ed21e24a	547	GROUP BY UPPER(SUBSTRING(IF(u.nom IS NULL,m.nom,u.nom), 1, 1))', $eid);
bd46a8e4	548
	549	$alphabet = array();
	550	$nb_tot = 0;
	551	while (list($char, $nb) = $res->next()) {
	552	$alphabet[ord($char)] = $char;
	553	$nb_tot += $nb;
5e2307dc	554	if (Env::has('initiale') && $char == strtoupper(Env::v('initiale'))) {
bd46a8e4	555	$tot = $nb;
	556	}
	557	}
	558	ksort($alphabet);
	559	$page->assign('alphabet', $alphabet);
	560
5e2307dc	561	$ofs = Env::i('offset');
5e2307dc	562	$tot = Env::v('initiale') ? $tot : $nb_tot;
bd46a8e4	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
bd46a8e4	578	if ($evt['paiement_id']) {
08cce2ff	579	$res = XDB::iterator(
bd46a8e4	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']);
ed21e24a	588	$page->assign('oublis', $res->total());
ed21e24a	589	$page->assign('oubliinscription', $res);
bd46a8e4	590	}
bd46a8e4	591
ed21e24a	592	$page->assign('participants',
	593	get_event_participants($evt, $item_id, $tri,
	594	"LIMIT ".($ofs*NB_PER_PAGE).", ".NB_PER_PAGE));
bd46a8e4	595	}
4f10a058	596	}
	597
	598	?>