X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fxnetevents%2Fxnetevents.inc.php;h=ed5794c52109a1ebf6277bf7a05580a7dba95b81;hb=1d10d3fd659fa8eb7c663d6bb599bc8bbc0feeb3;hp=1cc15cc5da6bcd175575dfb3e468ffbfc5721fc1;hpb=9193e8f787838f89112bc58bac49e3394569539d;p=platal.git diff --git a/modules/xnetevents/xnetevents.inc.php b/modules/xnetevents/xnetevents.inc.php index 1cc15cc..ed5794c 100644 --- a/modules/xnetevents/xnetevents.inc.php +++ b/modules/xnetevents/xnetevents.inc.php @@ -68,7 +68,7 @@ function get_event_detail($eid, $item_id = false) } $res = XDB::query( - "SELECT titre, details, montant, ei.item_id, nb + "SELECT titre, details, montant, ei.item_id, nb, ep.paid 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 = {?}) @@ -77,10 +77,13 @@ function get_event_detail($eid, $item_id = false) $evt['moments'] = $res->fetchAllAssoc(); $evt['topay'] = 0; + $evt['paid'] = 0; foreach ($evt['moments'] as $m) { $evt['topay'] += $m['nb'] * $m['montant']; - if ($m['montant']) + if ($m['montant']) { $evt['money'] = true; + } + $evt['paid'] = $m['paid']; } $req = XDB::query( @@ -89,7 +92,6 @@ function get_event_detail($eid, $item_id = false) WHERE ref = {?} AND uid = {?}", $evt['paiement_id'], S::v('uid')); $montants = $req->fetchColumn(); - $evt['paid'] = 0; foreach ($montants as $m) { $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.'); $evt['paid'] += trim($p); @@ -273,7 +275,7 @@ function event_change_shortname(&$page, $old, $new) XDB::execute("INSERT INTO virtual SET type = 'evt', alias = {?}", $new.'-participants@'.$globals->xnet->evts_domain); - $lastid = mysql_insert_id(); + $lastid = XDB::insertId(); XDB::execute( "INSERT INTO virtual_redirect ( SELECT {?} AS vid, IF(u.nom IS NULL, m.email, CONCAT(a.alias, {?})) AS redirect @@ -288,7 +290,7 @@ function event_change_shortname(&$page, $old, $new) XDB::execute("INSERT INTO virtual SET type = 'evt', alias = {?}", $new.'-absents@'.$globals->xnet->evts_domain); - $lastid = mysql_insert_id(); + $lastid = XDB::insertId(); XDB::execute("INSERT INTO virtual_redirect ( SELECT {?} AS vid, IF(u.nom IS NULL, m.email, CONCAT(a.alias, {?})) AS redirect FROM groupex.membres AS m