Commit | Line | Data |
---|---|---|
a2558f2b | 1 | <?php |
2 | /*************************************************************************** | |
5ddeb07c | 3 | * Copyright (C) 2003-2007 Polytechnique.org * |
a2558f2b | 4 | * http://opensource.polytechnique.org/ * |
5 | * * | |
6 | * This program is free software; you can redistribute it and/or modify * | |
7 | * it under the terms of the GNU General Public License as published by * | |
8 | * the Free Software Foundation; either version 2 of the License, or * | |
9 | * (at your option) any later version. * | |
10 | * * | |
11 | * This program is distributed in the hope that it will be useful, * | |
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of * | |
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * | |
14 | * GNU General Public License for more details. * | |
15 | * * | |
16 | * You should have received a copy of the GNU General Public License * | |
17 | * along with this program; if not, write to the Free Software * | |
18 | * Foundation, Inc., * | |
19 | * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * | |
20 | ***************************************************************************/ | |
21 | ||
22 | /* sort en affichant une erreur */ | |
23 | function cb_erreur($text) { | |
1e33266a | 24 | $mymail = new PlMailer(); |
d7dd70be | 25 | $mymail->addTo($globals->money->email); |
1d55fe45 | 26 | $mymail->setFrom("webmaster@" . $globals->mail->domain); |
a7de4ef7 | 27 | $mymail->setSubject("erreur lors d'un télépaiement (CyberPaiement)"); |
a2558f2b | 28 | $mymail->setTxtBody("\n\n".var_export($_REQUEST,true)); |
29 | $mymail->send(); | |
30 | exit; | |
31 | } | |
32 | ||
33 | /* sort en affichant une erreur */ | |
88e3843c | 34 | function paypal_erreur($text, $send=true) |
35 | { | |
a2558f2b | 36 | global $page, $erreur; |
37 | if ($erreur) return; | |
38 | $erreur = $text; | |
39 | if (!$send) return; | |
40 | ||
1e33266a | 41 | $mymail = new PlMailer(); |
d7dd70be | 42 | $mymail->addTo($globals->money->email); |
1d55fe45 | 43 | $mymail->setFrom("webmaster@" . $globals->mail->domain); |
a7de4ef7 | 44 | $mymail->setSubject("erreur lors d'un télépaiement (PayPal)"); |
a2558f2b | 45 | $mymail->setTxtBody("\n\n".var_export($_REQUEST,true)); |
46 | $mymail->send(); | |
47 | ||
48 | $page->trig($text); | |
49 | } | |
50 | ||
51 | /* http://fr.wikipedia.org/wiki/Formule_de_Luhn */ | |
52 | function luhn($nombre) { | |
53 | $s = strrev($nombre); | |
54 | $sum = 0; | |
55 | for ($i = 0; $i < strlen($s); $i++) { | |
56 | $dgt = $s{$i}; | |
57 | $sum += ($i % 2) ? (2*$dgt) % 9 : $dgt; | |
58 | } | |
59 | return $sum % 10; | |
60 | } | |
61 | ||
a7de4ef7 | 62 | /* calcule la clé d'acceptation a partir de 5 champs */ |
a2558f2b | 63 | function cle_accept($d1,$d2,$d3,$d4,$d5) |
64 | { | |
65 | $m1 = luhn($d1.$d5); | |
66 | $m2 = luhn($d2.$d5); | |
67 | $m3 = luhn($d3.$d5); | |
68 | $m4 = luhn($d4.$d5); | |
69 | $n = $m1 + $m2 + $m3 + $m4; | |
70 | $alpha = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; | |
71 | return $alpha{$n-1}.$m1.$m2.$m3.$m4; | |
72 | } | |
73 | ||
74 | ||
75 | class PaymentModule extends PLModule | |
76 | { | |
77 | function handlers() | |
78 | { | |
79 | return array( | |
80 | 'payment' => $this->make_hook('payment', AUTH_MDP), | |
6995a9b9 | 81 | 'payment/cyber_return' => $this->make_hook('cyber_return', AUTH_PUBLIC), |
82 | 'payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC), | |
45a5307b FB |
83 | '%grp/paiement' => $this->make_hook('xnet_payment', AUTH_MDP), |
84 | '%grp/payment' => $this->make_hook('xnet_payment', AUTH_MDP), | |
98a7e9dc | 85 | '%grp/payment/cyber_return' => $this->make_hook('cyber_return', AUTH_PUBLIC), |
86 | '%grp/payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC), | |
92423144 | 87 | 'admin/payments' => $this->make_hook('admin', AUTH_MDP, 'admin'), |
eaf30d86 | 88 | |
a2558f2b | 89 | ); |
90 | } | |
91 | ||
92 | function handler_payment(&$page, $ref = -1) | |
93 | { | |
94 | global $globals; | |
95 | ||
96 | require_once 'profil.func.inc.php' ; | |
2c784d41 | 97 | require_once dirname(__FILE__).'/payment/money.inc.php' ; |
a2558f2b | 98 | |
98a7e9dc | 99 | if (!empty($GLOBALS['IS_XNET_SITE'])) { |
100 | if (!$globals->asso('id')) { | |
101 | return PL_NOT_FOUND; | |
102 | } | |
103 | $res = XDB::query("SELECT asso_id | |
104 | FROM paiement.paiements | |
105 | WHERE asso_id = {?} AND id = {?}", | |
106 | $globals->asso('id'), $ref); | |
107 | if (!$res->numRows()) { | |
108 | return PL_FORBIDDEN; | |
109 | } | |
98a7e9dc | 110 | } |
1490093c | 111 | $page->changeTpl('payment/index.tpl'); |
112 | $page->assign('xorg_title','Polytechnique.org - Télépaiements'); | |
a2558f2b | 113 | |
114 | // initialisation | |
5e2307dc | 115 | $op = Env::v('op', 'select'); |
116 | $meth = new PayMethod(Env::i('methode', -1)); | |
a2558f2b | 117 | $pay = new Payment($ref); |
118 | ||
119 | if($pay->flags->hasflag('old')){ | |
a7de4ef7 | 120 | $page->trig("La transaction selectionnée est périmée."); |
a2558f2b | 121 | $pay = new Payment(); |
122 | } | |
5e2307dc | 123 | $val = Env::v('montant') != 0 ? Env::v('montant') : $pay->montant_def; |
a2558f2b | 124 | |
125 | if (($e = $pay->check($val)) !== true) { | |
126 | $page->trig($e); | |
127 | } | |
128 | ||
129 | if ($op=='submit') { | |
130 | $pay->init($val, $meth); | |
131 | $pay->prepareform($pay); | |
132 | } else { | |
08cce2ff | 133 | $res = XDB::iterator("SELECT timestamp, montant |
8a7fab54 | 134 | FROM paiement.transactions |
135 | WHERE uid = {?} AND ref = {?} | |
136 | ORDER BY timestamp DESC", | |
137 | S::v('uid', -1), $ref); | |
a2558f2b | 138 | |
139 | if ($res->total()) $page->assign('transactions', $res); | |
140 | } | |
141 | ||
142 | $val = floor($val).".".substr(floor(($val - floor($val))*100+100),1); | |
143 | $page->assign('montant',$val); | |
bff6d838 | 144 | $page->assign('comment',Env::v('comment')); |
a2558f2b | 145 | |
146 | $page->assign('meth', $meth); | |
147 | $page->assign('pay', $pay); | |
148 | $page->assign('evtlink', $pay->event()); | |
149 | ||
a3a049fc | 150 | $page->assign('prefix', $globals->money->mpay_tprefix); |
a2558f2b | 151 | } |
152 | ||
153 | function handler_cyber_return(&$page, $uid = null) | |
154 | { | |
a2558f2b | 155 | /* reference banque (numero de transaction) */ |
7280eb45 | 156 | $champ901 = Env::s('CHAMP901'); |
a2558f2b | 157 | /* cle d'acceptation */ |
7280eb45 | 158 | $champ905 = Env::s('CHAMP905'); |
a2558f2b | 159 | /* code retour */ |
7280eb45 | 160 | $champ906 = Env::s('CHAMP906'); |
a2558f2b | 161 | /* email renvoye par la banque */ |
7280eb45 | 162 | $champ104 = Env::s('CHAMP104'); |
a2558f2b | 163 | /* reference complete de la commande */ |
7280eb45 | 164 | $champ200 = Env::s('CHAMP200'); |
a2558f2b | 165 | /* montant de la transaction */ |
7280eb45 | 166 | $champ201 = Env::s('CHAMP201'); |
a2558f2b | 167 | /* devise */ |
7280eb45 | 168 | $champ202 = Env::s('CHAMP202'); |
a2558f2b | 169 | $montant = "$champ201 $champ202"; |
170 | ||
171 | /* on extrait les informations sur l'utilisateur */ | |
08cce2ff | 172 | $res = XDB::query(" |
010268b2 | 173 | SELECT a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET('femme', a.flags) |
a2558f2b | 174 | FROM auth_user_md5 AS a |
175 | INNER JOIN aliases AS l ON (a.user_id=l.id AND type!='homonyme') | |
176 | WHERE a.user_id={?}", $uid); | |
177 | if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) { | |
178 | cb_erreur("uid invalide"); | |
179 | } | |
180 | ||
181 | ||
182 | /* on extrait la reference de la commande */ | |
183 | if (!ereg('-xorg-([0-9]+)$',$champ200,$matches)) { | |
a7de4ef7 | 184 | cb_erreur("référence de commande invalide"); |
a2558f2b | 185 | } |
186 | ||
187 | echo ($ref = $matches[1]); | |
98a7e9dc | 188 | $res = XDB::query("SELECT mail,text,confirmation |
189 | FROM paiement.paiements | |
190 | WHERE id={?}", $ref); | |
a2558f2b | 191 | if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) { |
a7de4ef7 | 192 | cb_erreur("référence de commande inconnue"); |
a2558f2b | 193 | } |
194 | ||
195 | /* on extrait le code de retour */ | |
196 | if ($champ906 != "0000") { | |
08cce2ff | 197 | $res = XDB::query("SELECT rcb.text,c.id,c.text |
98a7e9dc | 198 | FROM paiement.codeRCB AS rcb |
199 | LEFT JOIN paiement.codeC AS c ON rcb.codeC=c.id | |
200 | WHERE rcb.id='$champ906'"); | |
a2558f2b | 201 | if (list($rcb_text, $c_id, $c_text) = $res->fetchOneRow()) { |
202 | cb_erreur("erreur lors du paiement : $c_text ($c_id)"); | |
eaf30d86 | 203 | } else{ |
a2558f2b | 204 | cb_erreur("erreur inconnue lors du paiement"); |
205 | } | |
206 | } | |
207 | ||
208 | /* on fait l'insertion en base de donnees */ | |
bff6d838 | 209 | XDB::execute("INSERT INTO paiement.transactions (id,uid,ref,fullref,montant,cle,comment) |
98a7e9dc | 210 | VALUES ({?},{?},{?},{?},{?},{?},{?})", |
211 | $champ901, $uid, $ref, $champ200, $montant, $champ905,Env::v('comment')); | |
a2558f2b | 212 | |
213 | /* on genere le mail de confirmation */ | |
214 | $conf_text = str_replace("<prenom>",$prenom,$conf_text); | |
215 | $conf_text = str_replace("<nom>",$nom,$conf_text); | |
216 | $conf_text = str_replace("<promo>",$promo,$conf_text); | |
217 | $conf_text = str_replace("<montant>",$montant,$conf_text); | |
a7de4ef7 | 218 | $conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text); |
219 | $conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text); | |
a2558f2b | 220 | |
1e33266a | 221 | $mymail = new PlMailer(); |
a2558f2b | 222 | $mymail->setFrom($conf_mail); |
1d55fe45 | 223 | $mymail->addTo("\"$prenom $nom\" <$forlife@" . $globals->mail->domain . '>'); |
a2558f2b | 224 | $mymail->addCc($conf_mail); |
225 | $mymail->setSubject($conf_title); | |
88e3843c | 226 | $mymail->setWikiBody($conf_text); |
227 | $mymail->send(S::v('mail_fmt') == 'html'); | |
a2558f2b | 228 | |
a7de4ef7 | 229 | /* on envoie les details de la transaction à telepaiement@ */ |
1e33266a | 230 | $mymail = new PlMailer(); |
1d55fe45 | 231 | $mymail->setFrom("webmaster@" . $globals->mail->domain); |
d7dd70be | 232 | $mymail->addTo($globals->money->email); |
a2558f2b | 233 | $mymail->setSubject($conf_title); |
234 | $msg = "utilisateur : $prenom $nom ($uid)\n". | |
235 | "mail : $forlife@polytechnique.org\n\n". | |
236 | "paiement : $conf_title ($conf_mail)\n". | |
237 | "reference : $champ200\n". | |
238 | "montant : $montant\n\n". | |
239 | "dump de REQUEST:\n". | |
240 | var_export($_REQUEST,true); | |
241 | $mymail->setTxtBody($msg); | |
242 | $mymail->send(); | |
243 | exit; | |
244 | } | |
245 | ||
246 | function handler_paypal_return(&$page, $uid = null) | |
247 | { | |
da157660 | 248 | $page->changeTpl('payment/retour_paypal.tpl'); |
a2558f2b | 249 | |
250 | /* reference banque (numero de transaction) */ | |
7280eb45 | 251 | $no_transaction = Env::s('tx'); |
a2558f2b | 252 | /* token a renvoyer pour avoir plus d'information */ |
7280eb45 | 253 | $clef = Env::s('sig'); |
a2558f2b | 254 | /* code retour */ |
7280eb45 | 255 | $status = Env::s('st'); |
a2558f2b | 256 | /* raison */ |
7280eb45 | 257 | $reason = ($status == 'Pending')? Env::s('pending_reason'): Env::s('reason_code'); |
a2558f2b | 258 | /* reference complete de la commande */ |
7280eb45 | 259 | $fullref = Env::s('cm'); |
a2558f2b | 260 | /* montant de la transaction */ |
7280eb45 | 261 | $montant_nb = Env::s('amt'); |
a2558f2b | 262 | /* devise */ |
7280eb45 | 263 | $montant_dev = Env::s('cc'); |
a2558f2b | 264 | $montant = "$montant_nb $montant_dev"; |
265 | ||
266 | /* on extrait le code de retour */ | |
267 | if ($status != "Completed") { | |
268 | if ($status) | |
269 | paypal_erreur("erreur lors du paiement : $status - $reason"); | |
270 | else | |
a7de4ef7 | 271 | paypal_erreur("Paiement annulé", false); |
a2558f2b | 272 | } |
273 | ||
274 | /* on extrait les informations sur l'utilisateur */ | |
08cce2ff | 275 | $res = XDB::query(" |
010268b2 | 276 | SELECT a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET('femme', a.flags) |
a2558f2b | 277 | FROM auth_user_md5 AS a |
278 | INNER JOIN aliases AS l ON (a.user_id=l.id AND type!='homonyme') | |
279 | WHERE a.user_id={?}", $uid); | |
280 | if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) { | |
281 | paypal_erreur("uid invalide"); | |
282 | } | |
283 | ||
284 | /* on extrait la reference de la commande */ | |
285 | if (!ereg('-xorg-([0-9]+)$',$fullref,$matches)) { | |
a7de4ef7 | 286 | paypal_erreur("référence de commande invalide"); |
a2558f2b | 287 | } |
288 | ||
289 | $ref = $matches[1]; | |
08cce2ff | 290 | $res = XDB::query("SELECT mail,text,confirmation |
98a7e9dc | 291 | FROM paiement.paiements |
292 | WHERE id={?}", $ref); | |
a2558f2b | 293 | if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) { |
a7de4ef7 | 294 | paypal_erreur("référence de commande inconnue"); |
a2558f2b | 295 | } |
296 | ||
297 | /* on fait l'insertion en base de donnees */ | |
bff6d838 | 298 | XDB::execute("INSERT INTO paiement.transactions (id,uid,ref,fullref,montant,cle,comment) |
98a7e9dc | 299 | VALUES ({?},{?},{?},{?},{?},{?},{?})", |
300 | $no_transaction, $uid, $ref, $fullref, $montant, $clef, Env::v('comment')); | |
a2558f2b | 301 | |
302 | /* on genere le mail de confirmation */ | |
303 | $conf_text = str_replace("<prenom>",$prenom,$conf_text); | |
304 | $conf_text = str_replace("<nom>",$nom,$conf_text); | |
305 | $conf_text = str_replace("<promo>",$promo,$conf_text); | |
306 | $conf_text = str_replace("<montant>",$montant,$conf_text); | |
a7de4ef7 | 307 | $conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text); |
308 | $conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text); | |
a2558f2b | 309 | |
1e33266a | 310 | $mymail = new PlMailer(); |
a2558f2b | 311 | $mymail->setFrom($conf_mail); |
1d55fe45 | 312 | $mymail->addTo("\"$prenom $nom\" <$forlife@" . $globals->mail->domain . '>'); |
a2558f2b | 313 | $mymail->addCc($conf_mail); |
314 | $mymail->setSubject($conf_title); | |
88e3843c | 315 | $mymail->setWikiBody($conf_text); |
316 | $mymail->send(S::v('mail_fmt') == 'html'); | |
a2558f2b | 317 | |
a7de4ef7 | 318 | /* on envoie les details de la transaction à telepaiement@ */ |
1e33266a | 319 | $mymail = new PlMailer(); |
1d55fe45 | 320 | $mymail->setFrom("webmaster@" . $globals->mail->domain); |
d7dd70be | 321 | $mymail->addTo($globals->money->email); |
a2558f2b | 322 | $mymail->setSubject($conf_title); |
323 | $msg = "utilisateur : $prenom $nom ($uid)\n". | |
324 | "mail : $forlife@polytechnique.org\n\n". | |
325 | "paiement : $conf_title ($conf_mail)\n". | |
326 | "reference : $no_transaction\n". | |
327 | "montant : $montant\n\n". | |
328 | "dump de REQUEST:\n". | |
329 | var_export($_REQUEST,true); | |
330 | $mymail->setTxtBody($msg); | |
331 | $mymail->send(); | |
332 | ||
333 | $page->assign('texte', $conf_text); | |
334 | $page->assign('erreur', $erreur); | |
a2558f2b | 335 | } |
98a7e9dc | 336 | |
337 | function handler_xnet_payment(&$page, $pid = null) | |
338 | { | |
339 | global $globals; | |
eaf30d86 | 340 | |
45a5307b FB |
341 | $perms = S::v('perms'); |
342 | if (!$perms->hasFlag('groupmember')) { | |
343 | if (is_null($pid)) { | |
344 | return PL_FORBIDDEN; | |
345 | } | |
346 | $res = XDB::query("SELECT 1 | |
347 | FROM groupex.evenements AS e | |
348 | INNER JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?}) | |
349 | WHERE e.paiement_id = {?} AND e.asso_id = {?}", | |
350 | S::i('uid'), $pid, $globals->asso('id')); | |
351 | if ($res->numRows() == 0) { | |
352 | return PL_FORBIDDEN; | |
353 | } | |
354 | } | |
355 | ||
98a7e9dc | 356 | if (!is_null($pid)) { |
357 | return $this->handler_payment($page, $pid); | |
358 | } | |
1490093c | 359 | $page->changeTpl('payment/xnet.tpl'); |
eaf30d86 | 360 | |
98a7e9dc | 361 | $res = XDB::query( |
362 | "SELECT id, text, url | |
363 | FROM {$globals->money->mpay_tprefix}paiements | |
010268b2 | 364 | WHERE asso_id = {?} AND NOT FIND_IN_SET('old', flags) |
98a7e9dc | 365 | ORDER BY id DESC", $globals->asso('id')); |
366 | $tit = $res->fetchAllAssoc(); | |
367 | $page->assign('titres', $tit); | |
368 | ||
369 | $order = Env::v('order', 'timestamp'); | |
de4b22cc | 370 | $orders = array('timestamp', 'nom', 'promo', 'montant', 'comment'); |
98a7e9dc | 371 | if (!in_array($order, $orders)) { |
372 | $order = 'timestamp'; | |
de4b22cc | 373 | } elseif ($order == 'comment') { |
374 | $order = 't.comment'; | |
98a7e9dc | 375 | } |
376 | $inv_order = Env::v('order_inv', 0); | |
377 | $page->assign('order', $order); | |
378 | $page->assign('order_inv', !$inv_order); | |
379 | ||
380 | if ($order == 'timestamp') { | |
381 | $inv_order = !$inv_order; | |
382 | } | |
383 | ||
384 | if ($inv_order) { | |
385 | $inv_order = ' DESC'; | |
386 | } else { | |
387 | $inv_order = ''; | |
388 | } | |
389 | if ($order == 'montant') { | |
390 | $order = 'LENGTH(montant) '.$inv_order.', montant'; | |
391 | } | |
392 | ||
393 | $orderby = 'ORDER BY '.$order.$inv_order; | |
394 | if ($order != 'nom') { | |
395 | $orderby .= ', nom'; $inv_order = ''; | |
396 | } | |
397 | $orderby .= ', prenom'.$inv_order; | |
398 | if ($order != 'timestamp') { | |
399 | $orderby .= ', timestamp DESC'; | |
400 | } | |
401 | ||
402 | $trans = array(); | |
403 | $event = array(); | |
404 | foreach($tit as $foo) { | |
405 | $pid = $foo['id']; | |
406 | if (may_update()) { | |
407 | $res = XDB::query("SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom, | |
de4b22cc | 408 | u.prenom, u.promo, a.alias, timestamp AS `date`, t.comment, montant |
98a7e9dc | 409 | FROM {$globals->money->mpay_tprefix}transactions AS t |
410 | INNER JOIN auth_user_md5 AS u ON ( t.uid = u.user_id ) | |
411 | INNER JOIN aliases AS a ON ( t.uid = a.id AND a.type='a_vie' ) | |
412 | WHERE ref = {?} ".$orderby, $pid); | |
413 | $trans[$pid] = $res->fetchAllAssoc(); | |
414 | $sum = 0; | |
415 | foreach ($trans[$pid] as $i => $t) { | |
416 | $sum += strtr(substr($t['montant'], 0, strpos($t['montant'], 'EUR')), ',', '.'); | |
a7de4ef7 | 417 | $trans[$pid][$i]['montant'] = str_replace('EUR', '€', $t['montant']); |
98a7e9dc | 418 | } |
419 | $trans[$pid][] = array('nom' => 'somme totale', | |
a7de4ef7 | 420 | 'montant' => strtr($sum, '.', ',').' €'); |
98a7e9dc | 421 | } |
422 | $res = XDB::iterRow("SELECT e.eid, e.short_name, e.intitule, ep.nb, ei.montant, ep.paid | |
423 | FROM groupex.evenements AS e | |
424 | LEFT JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?}) | |
425 | INNER JOIN groupex.evenements_items AS ei ON (ep.eid = ei.eid AND ep.item_id = ei.item_id) | |
426 | WHERE e.paiement_id = {?}", | |
427 | S::v('uid'), $pid); | |
428 | $event[$pid] = array(); | |
429 | $event[$pid]['paid'] = 0; | |
430 | if ($res->total()) { | |
431 | $event[$pid]['topay'] = 0; | |
432 | while(list($eid, $shortname, $title, $nb, $montant, $paid) = $res->next()) { | |
433 | $event[$pid]['topay'] += ($nb * $montant); | |
434 | $event[$pid]['eid'] = $eid; | |
435 | $event[$pid]['shortname'] = $shortname; | |
436 | $event[$pid]['title'] = $title; | |
437 | $event[$pid]['ins'] = !is_null($nb); | |
438 | $event[$pid]['paid'] = $paid; | |
439 | } | |
440 | } | |
441 | $res = XDB::query("SELECT montant | |
442 | FROM {$globals->money->mpay_tprefix}transactions AS t | |
443 | WHERE ref = {?} AND uid = {?}", $pid, S::v('uid')); | |
444 | $montants = $res->fetchColumn(); | |
445 | ||
446 | foreach ($montants as $m) { | |
447 | $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.'); | |
448 | $event[$pid]['paid'] += trim($p); | |
449 | } | |
450 | } | |
451 | $page->assign('trans', $trans); | |
452 | $page->assign('event', $event); | |
453 | } | |
eaf30d86 | 454 | |
92423144 | 455 | function handler_admin(&$page, $action = 'list', $id = null) { |
92423144 | 456 | $page->assign('xorg_title','Polytechnique.org - Administration - Paiements'); |
a7de4ef7 | 457 | $page->assign('title', 'Gestion des télépaiements'); |
92423144 | 458 | $table_editor = new PLTableEditor('admin/payments','paiement.paiements','id'); |
459 | $table_editor->add_join_table('paiement.transactions','ref',true); | |
2e7b5921 | 460 | $table_editor->add_sort_field('flags'); |
de61dbcf | 461 | $table_editor->add_sort_field('id', true, true); |
a7de4ef7 | 462 | $table_editor->on_delete("UPDATE paiement.paiements SET flags = 'old' WHERE id = {?}", "Le paiement a été archivé"); |
463 | $table_editor->describe('text','intitulé',true); | |
92423144 | 464 | $table_editor->describe('url','site web',false); |
a7de4ef7 | 465 | $table_editor->describe('montant_def','montant par défaut',false); |
92423144 | 466 | $table_editor->describe('montant_min','montant minimum',false); |
467 | $table_editor->describe('montant_max','montant maximum',false); | |
468 | $table_editor->describe('mail','email contact',true); | |
469 | $table_editor->describe('confirmation','message confirmation',false); | |
470 | $table_editor->apply($page, $action, $id); | |
eaf30d86 | 471 | } |
a2558f2b | 472 | } |
473 | ||
a7de4ef7 | 474 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
a2558f2b | 475 | ?> |