3 require 'xnet.inc.php';
5 new_group_page('xnet/groupe/telepaiement.tpl');
7 $res = $globals->xdb
->query("SELECT id, text FROM {$globals->money->mpay_tprefix}paiements
8 WHERE asso_id = {?} AND NOT FIND_IN_SET(flags, 'old')
10 $globals->asso('id'));
11 $tit = $res->fetchAllAssoc();
12 $page->assign('titres', $tit);
14 $order = Env
::get('order', 'timestamp');
15 $orders = array('timestamp', 'nom', 'promo', 'montant');
16 if (!in_array($order, $orders)) $order = 'timestamp';
17 $inv_order = Env
::get('order_inv', 0);
18 $page->assign('order', $order);
19 $page->assign('order_inv', !$inv_order);
20 if ($order == 'timestamp') $inv_order = !$inv_order;
22 if ($inv_order) $inv_order = ' DESC'; else $inv_order = '';
23 if ($order == 'montant') $order = 'LENGTH(montant) '.$inv_order.', montant';
25 $orderby = 'ORDER BY '.$order.$inv_order;
26 if ($order != 'nom') { $orderby .= ', nom'; $inv_order = ''; }
27 $orderby .= ', prenom'.$inv_order;
28 if ($order != 'timestamp') $orderby .= ', timestamp DESC';
32 foreach($tit as $foo) {
34 $res = $globals->xdb
->query(
35 "SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) as nom, u.prenom, u.promo, a.alias, timestamp AS `date`, montant
36 FROM {$globals->money->mpay_tprefix}transactions AS t
37 INNER JOIN auth_user_md5 AS u ON ( t.uid = u.user_id )
38 INNER JOIN aliases AS a ON ( t.uid = a.id AND a.type='a_vie' )
39 WHERE ref = {?} ".$orderby, $pid);
40 $trans[$pid] = $res->fetchAllAssoc();
42 foreach ($trans[$pid] as $i => $t)
43 $sum +
= strtr(substr($t['montant'], 0, strpos($t['montant'], "EUR")), ",", ".");
44 $trans[$pid][] = array("nom" => "somme totale", "montant" => strtr($sum, ".", ",")." EUR");
46 $page->assign('trans', $trans);