From 8c6e8c20e20ab905445fff5e332a504cd450a5e1 Mon Sep 17 00:00:00 2001 From: x2001corpet Date: Sat, 14 Jan 2006 09:25:23 +0000 Subject: [PATCH] prise en compte des paiements dans la page de tous les evenements git-svn-id: svn+ssh://murphy/home/svn/platal/branches/platal-0.9.9@213 839d8a87-29fc-0310-9880-83ba4fa771e5 --- htdocs.net/groupe/evenements.php | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/htdocs.net/groupe/evenements.php b/htdocs.net/groupe/evenements.php index edaf1f2..d35f1ed 100644 --- a/htdocs.net/groupe/evenements.php +++ b/htdocs.net/groupe/evenements.php @@ -117,6 +117,7 @@ $evenements = $globals->xdb->iterator( LEFT(10,e.fin) AS fin_day, e.paiement_id, e.membres_only, e.show_participants, u.nom, u.prenom, u.promo, a.alias, MAX(ep.nb) AS inscrit, + MAX(ep.paid) AS paid, e.short_name, IF(e.deadline_inscription,e.deadline_inscription >= LEFT(NOW(), 10), 1) AS inscr_open, e.deadline_inscription FROM groupex.evenements AS e @@ -136,7 +137,15 @@ while ($e = $evenements->next()) LEFT JOIN groupex.evenements_participants AS ep ON (ep.eid = ei.eid AND ep.item_id = ei.item_id AND uid = {?}) WHERE ei.eid = {?}", Session::get('uid'), $e['eid']); - $e['paid'] = 0; + $query = $globals->xdb->query( + "SELECT montant + FROM {$globals->money->mpay_tprefix}transactions AS t + WHERE ref = {?} AND uid = {?}", $e['paiement_id'], Session::get('uid')); + $montants = $query->fetchColumn(); + foreach ($montants as $m) { + $p = strtr(substr($m, 0, strpos($m, "EUR")), ",", "."); + $e['paid'] += trim($p); + } $evts[] = $e; } -- 2.1.4