X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fxnetevents%2Fxnetevents.inc.php;h=dc31a1b4145f810266c6d76595ac4a85db5b91c9;hb=3424387cde6c635ff16c3b5459c4caa88bb76e2e;hp=ace99d91e4ef65b8e439b297ff079cc8b9385bc1;hpb=1eddb8dcd2185df6d81f04392063c45a298661b4;p=platal.git diff --git a/modules/xnetevents/xnetevents.inc.php b/modules/xnetevents/xnetevents.inc.php index ace99d9..dc31a1b 100644 --- a/modules/xnetevents/xnetevents.inc.php +++ b/modules/xnetevents/xnetevents.inc.php @@ -128,7 +128,7 @@ function get_event_telepaid($eid, $uid) $telepaid = XDB::fetchOneCell('SELECT SUM(pt.amount) FROM payment_transactions AS pt LEFT JOIN group_events as ge ON (ge.paiement_id = pt.ref) - WHERE ge.eid = {?} AND pt.uid = {?}', + WHERE pt.status = "confirmed" AND ge.eid = {?} AND pt.uid = {?}', $eid, $uid); return $telepaid; } @@ -205,7 +205,7 @@ function get_event_detail($eid, $item_id = false, $asso_id = null) $montant = XDB::fetchOneCell('SELECT SUM(amount) AS sum_amount FROM payment_transactions AS t - WHERE ref = {?} AND uid = {?}', + WHERE status = "confirmed" AND ref = {?} AND uid = {?}', $evt['paiement_id'], S::v('uid')); $evt['telepaid'] = $montant; $evt['paid'] += $montant; @@ -258,7 +258,7 @@ function get_event_participants(&$evt, $item_id, array $tri = array(), $limit = if ($money && $pay_id) { $montant = XDB::fetchOneCell('SELECT SUM(amount) FROM payment_transactions AS t - WHERE ref = {?} AND uid = {?}', + WHERE status = "confirmed" AND ref = {?} AND uid = {?}', $pay_id, $uid); $u['paid'] += $montant; }