- } else {
- $order = XDB::fetchOneCell("SELECT event_order FROM groups
- WHERE id = {?}",
- $globals->asso('id'));
- }
- if ($order == 'desc') {
- $evenements = XDB::iterator('SELECT e.*, LEFT(e.debut, 10) AS first_day, LEFT(e.fin, 10) AS last_day,
- IF(e.deadline_inscription,
- e.deadline_inscription >= LEFT(NOW(), 10),
- 1) AS inscr_open,
- e.deadline_inscription,
- MAX(ep.nb) IS NOT NULL AS inscrit, MAX(ep.paid) AS paid
- FROM group_events AS e
- LEFT JOIN group_event_participants AS ep ON (ep.eid = e.eid AND ep.uid = {?})
- WHERE asso_id = {?} AND archive = {?}
- GROUP BY e.eid
- ORDER BY inscr_open DESC, debut DESC',
- S::i('uid'), $globals->asso('id'), $archive ? 1 : 0);
- } else {
- $evenements = XDB::iterator('SELECT e.*, LEFT(e.debut, 10) AS first_day, LEFT(e.fin, 10) AS last_day,
- IF(e.deadline_inscription,
- e.deadline_inscription >= LEFT(NOW(), 10),
- 1) AS inscr_open,
- e.deadline_inscription,
- MAX(ep.nb) IS NOT NULL AS inscrit, MAX(ep.paid) AS paid
- FROM group_events AS e
- LEFT JOIN group_event_participants AS ep ON (ep.eid = e.eid AND ep.uid = {?})
- WHERE asso_id = {?} AND archive = {?}
- GROUP BY e.eid
- ORDER BY inscr_open DESC, debut ASC',
- S::i('uid'), $globals->asso('id'), $archive ? 1 : 0);