[platal.git] / modules / payment.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2007 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

/* sort en affichant une erreur */
function cb_erreur($text) {
    $mymail = new PlMailer();
    $mymail->addTo("telepaiement@polytechnique.org");
    $mymail->setFrom("webmaster@polytechnique.org");
    $mymail->setSubject("erreur lors d'un télépaiement (CyberPaiement)");
    $mymail->setTxtBody("\n\n".var_export($_REQUEST,true));
    $mymail->send();
    exit;
}

/* sort en affichant une erreur */
function paypal_erreur($text, $send=true)
{
    global $page, $erreur;
    if ($erreur) return;
    $erreur = $text;
    if (!$send) return;

    $mymail = new PlMailer();
    $mymail->addTo("telepaiement@polytechnique.org");
    $mymail->setFrom("webmaster@polytechnique.org");
    $mymail->setSubject("erreur lors d'un télépaiement (PayPal)");
    $mymail->setTxtBody("\n\n".var_export($_REQUEST,true));
    $mymail->send();

    $page->trig($text);
}

/* http://fr.wikipedia.org/wiki/Formule_de_Luhn */
function luhn($nombre) {
    $s = strrev($nombre);
    $sum = 0;
    for ($i = 0; $i < strlen($s); $i++) {
	$dgt = $s{$i};
        $sum += ($i % 2) ? (2*$dgt) % 9 : $dgt;
    }
    return $sum % 10;
}

/* calcule la clé d'acceptation a partir de 5 champs */
function cle_accept($d1,$d2,$d3,$d4,$d5)
{
    $m1 = luhn($d1.$d5);
    $m2 = luhn($d2.$d5);
    $m3 = luhn($d3.$d5);
    $m4 = luhn($d4.$d5);
    $n = $m1 + $m2 + $m3 + $m4;
    $alpha = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
    return $alpha{$n-1}.$m1.$m2.$m3.$m4;
}


class PaymentModule extends PLModule
{
    function handlers()
    {
        return array(
            'payment'               => $this->make_hook('payment', AUTH_MDP),
            'payment/cyber_return'  => $this->make_hook('cyber_return',  AUTH_PUBLIC),
            'payment/paypal_return' => $this->make_hook('paypal_return',  AUTH_PUBLIC),
            '%grp/paiement'              => $this->make_hook('xnet_payment', AUTH_MDP),
            '%grp/payment'               => $this->make_hook('xnet_payment', AUTH_MDP),
            '%grp/payment/cyber_return'  => $this->make_hook('cyber_return', AUTH_PUBLIC),
            '%grp/payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC),
            'admin/payments'        => $this->make_hook('admin', AUTH_MDP, 'admin'),
        
        );
    }

    function handler_payment(&$page, $ref = -1)
    {
        global $globals;

        require_once 'profil.func.inc.php' ;
        require_once dirname(__FILE__).'/payment/money.inc.php' ;

        if (!empty($GLOBALS['IS_XNET_SITE'])) {
            if (!$globals->asso('id')) {
                return PL_NOT_FOUND;
            }
            $res = XDB::query("SELECT asso_id
                                 FROM paiement.paiements
                                WHERE asso_id = {?} AND id = {?}",
                              $globals->asso('id'), $ref);
            if (!$res->numRows()) {
                return PL_FORBIDDEN;
            }
            new_group_page('payment/index.tpl');
        } else {
            $page->changeTpl('payment/index.tpl');
            $page->assign('xorg_title','Polytechnique.org - Télépaiements');
        }

        // initialisation
        $op   = Env::v('op', 'select');
        $meth = new PayMethod(Env::i('methode', -1));
        $pay  = new Payment($ref);

        if($pay->flags->hasflag('old')){
            $page->trig("La transaction selectionnée est périmée.");
            $pay = new Payment();
        }
        $val = Env::v('montant') != 0 ? Env::v('montant') : $pay->montant_def;

        if (($e = $pay->check($val)) !== true) {
            $page->trig($e);
        }

        if ($op=='submit') {
            $pay->init($val, $meth);
            $pay->prepareform($pay);
        } else {
            $res = XDB::iterator("SELECT  timestamp, montant
                                    FROM  paiement.transactions
                                   WHERE  uid = {?} AND ref = {?}
                                ORDER BY  timestamp DESC",
                                 S::v('uid', -1), $ref);

            if ($res->total()) $page->assign('transactions', $res);
        }

        $val = floor($val).".".substr(floor(($val - floor($val))*100+100),1);
        $page->assign('montant',$val);
        $page->assign('comment',Env::v('comment'));

        $page->assign('meth', $meth);
        $page->assign('pay',  $pay);
        $page->assign('evtlink', $pay->event());

        $page->assign('prefix', $globals->money->mpay_tprefix);
    }

    function handler_cyber_return(&$page, $uid = null)
    {
        /* reference banque (numero de transaction) */
        $champ901 = clean_request('CHAMP901');
        /* cle d'acceptation */
        $champ905 = clean_request('CHAMP905');
        /* code retour */
        $champ906 = clean_request('CHAMP906');
        /* email renvoye par la banque */
        $champ104 = clean_request('CHAMP104');
        /* reference complete de la commande */
        $champ200 = clean_request('CHAMP200');
        /* montant de la transaction */
        $champ201 = clean_request('CHAMP201');
        /* devise */
        $champ202 = clean_request('CHAMP202');
        $montant = "$champ201 $champ202";

        /* on extrait les informations sur l'utilisateur */
        $res = XDB::query("
            SELECT  a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET(a.flags,'femme')
              FROM  auth_user_md5 AS a
        INNER JOIN  aliases       AS l ON (a.user_id=l.id AND type!='homonyme')
             WHERE  a.user_id={?}", $uid);
        if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) {
            cb_erreur("uid invalide");
        }


        /* on extrait la reference de la commande */
        if (!ereg('-xorg-([0-9]+)$',$champ200,$matches)) {
            cb_erreur("référence de commande invalide");
        }

        echo ($ref = $matches[1]);
        $res = XDB::query("SELECT  mail,text,confirmation
                             FROM  paiement.paiements
                            WHERE  id={?}", $ref);
        if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) {
            cb_erreur("référence de commande inconnue");
        }

        /* on extrait le code de retour */
        if ($champ906 != "0000") {
            $res = XDB::query("SELECT  rcb.text,c.id,c.text
                                 FROM  paiement.codeRCB AS rcb
                            LEFT JOIN  paiement.codeC   AS c ON rcb.codeC=c.id
                                WHERE  rcb.id='$champ906'");
            if (list($rcb_text, $c_id, $c_text) = $res->fetchOneRow()) {
                cb_erreur("erreur lors du paiement : $c_text ($c_id)");
            } else{ 
                cb_erreur("erreur inconnue lors du paiement");
            }
        }

        /* on fait l'insertion en base de donnees */
        XDB::execute("INSERT INTO  paiement.transactions (id,uid,ref,fullref,montant,cle,comment)
                           VALUES  ({?},{?},{?},{?},{?},{?},{?})",
                     $champ901, $uid, $ref, $champ200, $montant, $champ905,Env::v('comment'));

        /* on genere le mail de confirmation */
        $conf_text = str_replace("<prenom>",$prenom,$conf_text);
        $conf_text = str_replace("<nom>",$nom,$conf_text);
        $conf_text = str_replace("<promo>",$promo,$conf_text);
        $conf_text = str_replace("<montant>",$montant,$conf_text);
        $conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
        $conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);

        $mymail = new PlMailer();
        $mymail->setFrom($conf_mail);
        $mymail->addTo("\"$prenom $nom\" <$forlife@polytechnique.org>");
        $mymail->addCc($conf_mail);
        $mymail->setSubject($conf_title);
        $mymail->setWikiBody($conf_text);
        $mymail->send(S::v('mail_fmt') == 'html');

        /* on envoie les details de la transaction à telepaiement@ */
        $mymail = new PlMailer();
        $mymail->setFrom("webmaster@polytechnique.org");
        $mymail->addTo("telepaiement@staff.polytechnique.org");
        $mymail->setSubject($conf_title);
        $msg = "utilisateur : $prenom $nom ($uid)\n".
               "mail : $forlife@polytechnique.org\n\n".
               "paiement : $conf_title ($conf_mail)\n".
               "reference : $champ200\n".
               "montant : $montant\n\n".
               "dump de REQUEST:\n".
               var_export($_REQUEST,true);
        $mymail->setTxtBody($msg);
        $mymail->send();
        exit;
    }

    function handler_paypal_return(&$page, $uid = null)
    {
        if (!empty($GLOBALS['IS_XNET_SITE'])) {
            new_group_open_page('payment/retour_paypal.tpl');
        } else {
            $page->changeTpl('payment/retour_paypal.tpl');
        }

        /* reference banque (numero de transaction) */
        $no_transaction = clean_request('tx');
        /* token a renvoyer pour avoir plus d'information */
        $clef = clean_request('sig');
        /* code retour */
        $status = clean_request('st');
        /* raison */
        $reason = ($status == 'Pending')?clean_request('pending_reason'):clean_request('reason_code');
        /* reference complete de la commande */
        $fullref = clean_request('cm');
        /* montant de la transaction */
        $montant_nb = clean_request('amt');
        /* devise */
        $montant_dev = clean_request('cc');
        $montant = "$montant_nb $montant_dev";

        /* on extrait le code de retour */
        if ($status != "Completed") {
            if ($status)
                paypal_erreur("erreur lors du paiement : $status - $reason");
            else
                paypal_erreur("Paiement annulé", false);
        }

        /* on extrait les informations sur l'utilisateur */
        $res = XDB::query("
            SELECT  a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET(a.flags,'femme')
              FROM  auth_user_md5 AS a
        INNER JOIN  aliases       AS l ON (a.user_id=l.id AND type!='homonyme')
             WHERE  a.user_id={?}", $uid);
        if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) {
            paypal_erreur("uid invalide");
        }

        /* on extrait la reference de la commande */
        if (!ereg('-xorg-([0-9]+)$',$fullref,$matches)) {
            paypal_erreur("référence de commande invalide");
        }

        $ref = $matches[1];
        $res = XDB::query("SELECT  mail,text,confirmation
                             FROM  paiement.paiements
                            WHERE  id={?}", $ref);
        if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) {
            paypal_erreur("référence de commande inconnue");
        }

        /* on fait l'insertion en base de donnees */
        XDB::execute("INSERT INTO  paiement.transactions (id,uid,ref,fullref,montant,cle,comment)
                           VALUES  ({?},{?},{?},{?},{?},{?},{?})",
                    $no_transaction, $uid, $ref, $fullref, $montant, $clef, Env::v('comment'));

        /* on genere le mail de confirmation */
        $conf_text = str_replace("<prenom>",$prenom,$conf_text);
        $conf_text = str_replace("<nom>",$nom,$conf_text);
        $conf_text = str_replace("<promo>",$promo,$conf_text);
        $conf_text = str_replace("<montant>",$montant,$conf_text);
        $conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
        $conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);

        $mymail = new PlMailer();
        $mymail->setFrom($conf_mail);
        $mymail->addTo("\"$prenom $nom\" <$forlife@polytechnique.org>");
        $mymail->addCc($conf_mail);
        $mymail->setSubject($conf_title);
        $mymail->setWikiBody($conf_text);
        $mymail->send(S::v('mail_fmt') == 'html');

        /* on envoie les details de la transaction à telepaiement@ */
        $mymail = new PlMailer();
        $mymail->setFrom("webmaster@polytechnique.org");
        $mymail->addTo("telepaiement@polytechnique.org");
        $mymail->setSubject($conf_title);
        $msg = "utilisateur : $prenom $nom ($uid)\n".
               "mail : $forlife@polytechnique.org\n\n".
               "paiement : $conf_title ($conf_mail)\n".
               "reference : $no_transaction\n".
               "montant : $montant\n\n".
               "dump de REQUEST:\n".
               var_export($_REQUEST,true);
        $mymail->setTxtBody($msg);
        $mymail->send();

        $page->assign('texte', $conf_text);
        $page->assign('erreur', $erreur);
    }

    function handler_xnet_payment(&$page, $pid = null)
    {
        global $globals;
        
        if (!is_null($pid)) {
            return  $this->handler_payment($page, $pid);
        }
        new_group_page('payment/xnet.tpl');
        
        $res = XDB::query(
                "SELECT  id, text, url
                   FROM  {$globals->money->mpay_tprefix}paiements
                  WHERE  asso_id = {?} AND NOT FIND_IN_SET(flags, 'old')
               ORDER BY  id DESC", $globals->asso('id'));
        $tit = $res->fetchAllAssoc();
        $page->assign('titres', $tit);

        $order = Env::v('order', 'timestamp');
        $orders = array('timestamp', 'nom', 'promo', 'montant', 'comment');
        if (!in_array($order, $orders)) {
            $order = 'timestamp';
        } elseif ($order == 'comment') {
            $order = 't.comment';
        }
        $inv_order = Env::v('order_inv', 0);
        $page->assign('order', $order);
        $page->assign('order_inv', !$inv_order);

        if ($order == 'timestamp') {
            $inv_order = !$inv_order;
        }

        if ($inv_order) {
            $inv_order = ' DESC';
        } else {
            $inv_order = '';
        }
        if ($order == 'montant') {
            $order = 'LENGTH(montant) '.$inv_order.', montant';
        }

        $orderby = 'ORDER BY '.$order.$inv_order;
        if ($order != 'nom') {
            $orderby .= ', nom'; $inv_order = '';
        }
        $orderby .= ', prenom'.$inv_order;
        if ($order != 'timestamp') {
            $orderby .= ', timestamp DESC';
        }

        $trans = array();
        $event = array();
        foreach($tit as $foo) {
            $pid = $foo['id'];
            if (may_update()) {
                $res = XDB::query("SELECT  IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom,
                                           u.prenom, u.promo, a.alias, timestamp AS `date`, t.comment, montant
                                     FROM  {$globals->money->mpay_tprefix}transactions AS t
                               INNER JOIN  auth_user_md5  AS u ON ( t.uid = u.user_id )
                               INNER JOIN  aliases        AS a ON ( t.uid = a.id AND a.type='a_vie' )
                                    WHERE  ref = {?} ".$orderby, $pid);
                    $trans[$pid] = $res->fetchAllAssoc();
                    $sum = 0;
                    foreach ($trans[$pid] as $i => $t) {
                        $sum += strtr(substr($t['montant'], 0, strpos($t['montant'], 'EUR')), ',', '.');
                        $trans[$pid][$i]['montant'] = str_replace('EUR', '€', $t['montant']);
                    }
                    $trans[$pid][] = array('nom' => 'somme totale',
                                           'montant' => strtr($sum, '.', ',').' €');
            }
            $res = XDB::iterRow("SELECT e.eid, e.short_name, e.intitule, ep.nb, ei.montant, ep.paid
                                   FROM groupex.evenements AS e
                              LEFT JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?})
                             INNER JOIN groupex.evenements_items AS ei ON (ep.eid = ei.eid AND ep.item_id = ei.item_id)
                                  WHERE e.paiement_id = {?}",
                                 S::v('uid'), $pid);
            $event[$pid] = array();
            $event[$pid]['paid'] = 0;
            if ($res->total()) {
                $event[$pid]['topay'] = 0;
                while(list($eid, $shortname, $title, $nb, $montant, $paid) = $res->next()) {
                    $event[$pid]['topay']     += ($nb * $montant);
                    $event[$pid]['eid']       = $eid;
                    $event[$pid]['shortname'] = $shortname;
                    $event[$pid]['title']     = $title;
                    $event[$pid]['ins']       = !is_null($nb);
                    $event[$pid]['paid']      = $paid;
                }
            }
            $res = XDB::query("SELECT montant
                                 FROM {$globals->money->mpay_tprefix}transactions AS t
                                WHERE ref = {?} AND uid = {?}", $pid, S::v('uid'));
            $montants = $res->fetchColumn();

            foreach ($montants as $m) {
                $p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
                $event[$pid]['paid'] += trim($p);
            }
        }
        $page->assign('trans', $trans);
        $page->assign('event', $event);
    }
    
    function handler_admin(&$page, $action = 'list', $id = null) {
        $page->assign('xorg_title','Polytechnique.org - Administration - Paiements');
        $page->assign('title', 'Gestion des télépaiements');
        $table_editor = new PLTableEditor('admin/payments','paiement.paiements','id');
        $table_editor->add_join_table('paiement.transactions','ref',true);
        $table_editor->add_sort_field('flags');
        $table_editor->add_sort_field('id', true, true);
        $table_editor->on_delete("UPDATE paiement.paiements SET flags = 'old' WHERE id = {?}", "Le paiement a été archivé");
        $table_editor->describe('text','intitulé',true);
        $table_editor->describe('url','site web',false);
        $table_editor->describe('montant_def','montant par défaut',false);
        $table_editor->describe('montant_min','montant minimum',false);
        $table_editor->describe('montant_max','montant maximum',false);
        $table_editor->describe('mail','email contact',true);
        $table_editor->describe('confirmation','message confirmation',false);
        $table_editor->apply($page, $action, $id);
    }  
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
a2558f2b	1	<?php
a2558f2b	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();
a2558f2b	25	$mymail->addTo("telepaiement@polytechnique.org");
a2558f2b	26	$mymail->setFrom("webmaster@polytechnique.org");
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)
88e3843c	35	{
a2558f2b	36	global $page, $erreur;
	37	if ($erreur) return;
	38	$erreur = $text;
	39	if (!$send) return;
	40
1e33266a	41	$mymail = new PlMailer();
a2558f2b	42	$mymail->addTo("telepaiement@polytechnique.org");
a2558f2b	43	$mymail->setFrom("webmaster@polytechnique.org");
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),
6995a9b9	82	'payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC),
98a7e9dc	83	'%grp/paiement' => $this->make_hook('xnet_payment', AUTH_MDP),
	84	'%grp/payment' => $this->make_hook('xnet_payment', AUTH_MDP),
	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'),
98a7e9dc	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	}
	110	new_group_page('payment/index.tpl');
	111	} else {
	112	$page->changeTpl('payment/index.tpl');
a7de4ef7	113	$page->assign('xorg_title','Polytechnique.org - Télépaiements');
98a7e9dc	114	}
a2558f2b	115
a2558f2b	116	// initialisation
5e2307dc	117	$op = Env::v('op', 'select');
5e2307dc	118	$meth = new PayMethod(Env::i('methode', -1));
a2558f2b	119	$pay = new Payment($ref);
	120
	121	if($pay->flags->hasflag('old')){
a7de4ef7	122	$page->trig("La transaction selectionnée est périmée.");
a2558f2b	123	$pay = new Payment();
a2558f2b	124	}
5e2307dc	125	$val = Env::v('montant') != 0 ? Env::v('montant') : $pay->montant_def;
a2558f2b	126
	127	if (($e = $pay->check($val)) !== true) {
	128	$page->trig($e);
	129	}
	130
	131	if ($op=='submit') {
	132	$pay->init($val, $meth);
	133	$pay->prepareform($pay);
	134	} else {
08cce2ff	135	$res = XDB::iterator("SELECT timestamp, montant
8a7fab54	136	FROM paiement.transactions
	137	WHERE uid = {?} AND ref = {?}
	138	ORDER BY timestamp DESC",
	139	S::v('uid', -1), $ref);
a2558f2b	140
	141	if ($res->total()) $page->assign('transactions', $res);
	142	}
	143
	144	$val = floor($val).".".substr(floor(($val - floor($val))*100+100),1);
	145	$page->assign('montant',$val);
bff6d838	146	$page->assign('comment',Env::v('comment'));
a2558f2b	147
	148	$page->assign('meth', $meth);
	149	$page->assign('pay', $pay);
	150	$page->assign('evtlink', $pay->event());
	151
a3a049fc	152	$page->assign('prefix', $globals->money->mpay_tprefix);
a2558f2b	153	}
	154
	155	function handler_cyber_return(&$page, $uid = null)
	156	{
a2558f2b	157	/* reference banque (numero de transaction) */
	158	$champ901 = clean_request('CHAMP901');
	159	/* cle d'acceptation */
	160	$champ905 = clean_request('CHAMP905');
	161	/* code retour */
	162	$champ906 = clean_request('CHAMP906');
	163	/* email renvoye par la banque */
	164	$champ104 = clean_request('CHAMP104');
	165	/* reference complete de la commande */
	166	$champ200 = clean_request('CHAMP200');
	167	/* montant de la transaction */
	168	$champ201 = clean_request('CHAMP201');
	169	/* devise */
	170	$champ202 = clean_request('CHAMP202');
	171	$montant = "$champ201 $champ202";
	172
	173	/* on extrait les informations sur l'utilisateur */
08cce2ff	174	$res = XDB::query("
a2558f2b	175	SELECT a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET(a.flags,'femme')
	176	FROM auth_user_md5 AS a
	177	INNER JOIN aliases AS l ON (a.user_id=l.id AND type!='homonyme')
	178	WHERE a.user_id={?}", $uid);
	179	if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) {
	180	cb_erreur("uid invalide");
	181	}
	182
	183
	184	/* on extrait la reference de la commande */
	185	if (!ereg('-xorg-([0-9]+)$',$champ200,$matches)) {
a7de4ef7	186	cb_erreur("référence de commande invalide");
a2558f2b	187	}
	188
	189	echo ($ref = $matches[1]);
98a7e9dc	190	$res = XDB::query("SELECT mail,text,confirmation
	191	FROM paiement.paiements
	192	WHERE id={?}", $ref);
a2558f2b	193	if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) {
a7de4ef7	194	cb_erreur("référence de commande inconnue");
a2558f2b	195	}
	196
	197	/* on extrait le code de retour */
	198	if ($champ906 != "0000") {
08cce2ff	199	$res = XDB::query("SELECT rcb.text,c.id,c.text
98a7e9dc	200	FROM paiement.codeRCB AS rcb
	201	LEFT JOIN paiement.codeC AS c ON rcb.codeC=c.id
	202	WHERE rcb.id='$champ906'");
a2558f2b	203	if (list($rcb_text, $c_id, $c_text) = $res->fetchOneRow()) {
	204	cb_erreur("erreur lors du paiement : $c_text ($c_id)");
	205	} else{
	206	cb_erreur("erreur inconnue lors du paiement");
	207	}
	208	}
	209
	210	/* on fait l'insertion en base de donnees */
bff6d838	211	XDB::execute("INSERT INTO paiement.transactions (id,uid,ref,fullref,montant,cle,comment)
98a7e9dc	212	VALUES ({?},{?},{?},{?},{?},{?},{?})",
98a7e9dc	213	$champ901, $uid, $ref, $champ200, $montant, $champ905,Env::v('comment'));
a2558f2b	214
	215	/* on genere le mail de confirmation */
	216	$conf_text = str_replace("<prenom>",$prenom,$conf_text);
	217	$conf_text = str_replace("<nom>",$nom,$conf_text);
	218	$conf_text = str_replace("<promo>",$promo,$conf_text);
	219	$conf_text = str_replace("<montant>",$montant,$conf_text);
a7de4ef7	220	$conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
a7de4ef7	221	$conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);
a2558f2b	222
1e33266a	223	$mymail = new PlMailer();
a2558f2b	224	$mymail->setFrom($conf_mail);
	225	$mymail->addTo("\"$prenom $nom\" <$forlife@polytechnique.org>");
	226	$mymail->addCc($conf_mail);
	227	$mymail->setSubject($conf_title);
88e3843c	228	$mymail->setWikiBody($conf_text);
88e3843c	229	$mymail->send(S::v('mail_fmt') == 'html');
a2558f2b	230
a7de4ef7	231	/* on envoie les details de la transaction à telepaiement@ */
1e33266a	232	$mymail = new PlMailer();
a2558f2b	233	$mymail->setFrom("webmaster@polytechnique.org");
98a7e9dc	234	$mymail->addTo("telepaiement@staff.polytechnique.org");
a2558f2b	235	$mymail->setSubject($conf_title);
	236	$msg = "utilisateur : $prenom $nom ($uid)\n".
	237	"mail : $forlife@polytechnique.org\n\n".
	238	"paiement : $conf_title ($conf_mail)\n".
	239	"reference : $champ200\n".
	240	"montant : $montant\n\n".
	241	"dump de REQUEST:\n".
	242	var_export($_REQUEST,true);
	243	$mymail->setTxtBody($msg);
	244	$mymail->send();
	245	exit;
	246	}
	247
	248	function handler_paypal_return(&$page, $uid = null)
	249	{
98a7e9dc	250	if (!empty($GLOBALS['IS_XNET_SITE'])) {
	251	new_group_open_page('payment/retour_paypal.tpl');
	252	} else {
	253	$page->changeTpl('payment/retour_paypal.tpl');
	254	}
a2558f2b	255
	256	/* reference banque (numero de transaction) */
	257	$no_transaction = clean_request('tx');
	258	/* token a renvoyer pour avoir plus d'information */
	259	$clef = clean_request('sig');
	260	/* code retour */
	261	$status = clean_request('st');
	262	/* raison */
	263	$reason = ($status == 'Pending')?clean_request('pending_reason'):clean_request('reason_code');
	264	/* reference complete de la commande */
	265	$fullref = clean_request('cm');
	266	/* montant de la transaction */
	267	$montant_nb = clean_request('amt');
	268	/* devise */
	269	$montant_dev = clean_request('cc');
	270	$montant = "$montant_nb $montant_dev";
	271
	272	/* on extrait le code de retour */
	273	if ($status != "Completed") {
	274	if ($status)
	275	paypal_erreur("erreur lors du paiement : $status - $reason");
	276	else
a7de4ef7	277	paypal_erreur("Paiement annulé", false);
a2558f2b	278	}
	279
	280	/* on extrait les informations sur l'utilisateur */
08cce2ff	281	$res = XDB::query("
a2558f2b	282	SELECT a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET(a.flags,'femme')
	283	FROM auth_user_md5 AS a
	284	INNER JOIN aliases AS l ON (a.user_id=l.id AND type!='homonyme')
	285	WHERE a.user_id={?}", $uid);
	286	if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) {
	287	paypal_erreur("uid invalide");
	288	}
	289
	290	/* on extrait la reference de la commande */
	291	if (!ereg('-xorg-([0-9]+)$',$fullref,$matches)) {
a7de4ef7	292	paypal_erreur("référence de commande invalide");
a2558f2b	293	}
	294
	295	$ref = $matches[1];
08cce2ff	296	$res = XDB::query("SELECT mail,text,confirmation
98a7e9dc	297	FROM paiement.paiements
98a7e9dc	298	WHERE id={?}", $ref);
a2558f2b	299	if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) {
a7de4ef7	300	paypal_erreur("référence de commande inconnue");
a2558f2b	301	}
	302
	303	/* on fait l'insertion en base de donnees */
bff6d838	304	XDB::execute("INSERT INTO paiement.transactions (id,uid,ref,fullref,montant,cle,comment)
98a7e9dc	305	VALUES ({?},{?},{?},{?},{?},{?},{?})",
98a7e9dc	306	$no_transaction, $uid, $ref, $fullref, $montant, $clef, Env::v('comment'));
a2558f2b	307
	308	/* on genere le mail de confirmation */
	309	$conf_text = str_replace("<prenom>",$prenom,$conf_text);
	310	$conf_text = str_replace("<nom>",$nom,$conf_text);
	311	$conf_text = str_replace("<promo>",$promo,$conf_text);
	312	$conf_text = str_replace("<montant>",$montant,$conf_text);
a7de4ef7	313	$conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
a7de4ef7	314	$conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);
a2558f2b	315
1e33266a	316	$mymail = new PlMailer();
a2558f2b	317	$mymail->setFrom($conf_mail);
	318	$mymail->addTo("\"$prenom $nom\" <$forlife@polytechnique.org>");
	319	$mymail->addCc($conf_mail);
	320	$mymail->setSubject($conf_title);
88e3843c	321	$mymail->setWikiBody($conf_text);
88e3843c	322	$mymail->send(S::v('mail_fmt') == 'html');
a2558f2b	323
a7de4ef7	324	/* on envoie les details de la transaction à telepaiement@ */
1e33266a	325	$mymail = new PlMailer();
a2558f2b	326	$mymail->setFrom("webmaster@polytechnique.org");
	327	$mymail->addTo("telepaiement@polytechnique.org");
	328	$mymail->setSubject($conf_title);
	329	$msg = "utilisateur : $prenom $nom ($uid)\n".
	330	"mail : $forlife@polytechnique.org\n\n".
	331	"paiement : $conf_title ($conf_mail)\n".
	332	"reference : $no_transaction\n".
	333	"montant : $montant\n\n".
	334	"dump de REQUEST:\n".
	335	var_export($_REQUEST,true);
	336	$mymail->setTxtBody($msg);
	337	$mymail->send();
	338
	339	$page->assign('texte', $conf_text);
	340	$page->assign('erreur', $erreur);
a2558f2b	341	}
98a7e9dc	342
	343	function handler_xnet_payment(&$page, $pid = null)
	344	{
	345	global $globals;
	346
	347	if (!is_null($pid)) {
	348	return $this->handler_payment($page, $pid);
	349	}
	350	new_group_page('payment/xnet.tpl');
	351
	352	$res = XDB::query(
	353	"SELECT id, text, url
	354	FROM {$globals->money->mpay_tprefix}paiements
	355	WHERE asso_id = {?} AND NOT FIND_IN_SET(flags, 'old')
	356	ORDER BY id DESC", $globals->asso('id'));
	357	$tit = $res->fetchAllAssoc();
	358	$page->assign('titres', $tit);
	359
	360	$order = Env::v('order', 'timestamp');
de4b22cc	361	$orders = array('timestamp', 'nom', 'promo', 'montant', 'comment');
98a7e9dc	362	if (!in_array($order, $orders)) {
98a7e9dc	363	$order = 'timestamp';
de4b22cc	364	} elseif ($order == 'comment') {
de4b22cc	365	$order = 't.comment';
98a7e9dc	366	}
	367	$inv_order = Env::v('order_inv', 0);
	368	$page->assign('order', $order);
	369	$page->assign('order_inv', !$inv_order);
	370
	371	if ($order == 'timestamp') {
	372	$inv_order = !$inv_order;
	373	}
	374
	375	if ($inv_order) {
	376	$inv_order = ' DESC';
	377	} else {
	378	$inv_order = '';
	379	}
	380	if ($order == 'montant') {
	381	$order = 'LENGTH(montant) '.$inv_order.', montant';
	382	}
	383
	384	$orderby = 'ORDER BY '.$order.$inv_order;
	385	if ($order != 'nom') {
	386	$orderby .= ', nom'; $inv_order = '';
	387	}
	388	$orderby .= ', prenom'.$inv_order;
	389	if ($order != 'timestamp') {
	390	$orderby .= ', timestamp DESC';
	391	}
	392
	393	$trans = array();
	394	$event = array();
	395	foreach($tit as $foo) {
	396	$pid = $foo['id'];
	397	if (may_update()) {
	398	$res = XDB::query("SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom,
de4b22cc	399	u.prenom, u.promo, a.alias, timestamp AS `date`, t.comment, montant
98a7e9dc	400	FROM {$globals->money->mpay_tprefix}transactions AS t
	401	INNER JOIN auth_user_md5 AS u ON ( t.uid = u.user_id )
	402	INNER JOIN aliases AS a ON ( t.uid = a.id AND a.type='a_vie' )
	403	WHERE ref = {?} ".$orderby, $pid);
	404	$trans[$pid] = $res->fetchAllAssoc();
	405	$sum = 0;
	406	foreach ($trans[$pid] as $i => $t) {
	407	$sum += strtr(substr($t['montant'], 0, strpos($t['montant'], 'EUR')), ',', '.');
a7de4ef7	408	$trans[$pid][$i]['montant'] = str_replace('EUR', '€', $t['montant']);
98a7e9dc	409	}
98a7e9dc	410	$trans[$pid][] = array('nom' => 'somme totale',
a7de4ef7	411	'montant' => strtr($sum, '.', ',').' €');
98a7e9dc	412	}
	413	$res = XDB::iterRow("SELECT e.eid, e.short_name, e.intitule, ep.nb, ei.montant, ep.paid
	414	FROM groupex.evenements AS e
	415	LEFT JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?})
	416	INNER JOIN groupex.evenements_items AS ei ON (ep.eid = ei.eid AND ep.item_id = ei.item_id)
	417	WHERE e.paiement_id = {?}",
	418	S::v('uid'), $pid);
	419	$event[$pid] = array();
	420	$event[$pid]['paid'] = 0;
	421	if ($res->total()) {
	422	$event[$pid]['topay'] = 0;
	423	while(list($eid, $shortname, $title, $nb, $montant, $paid) = $res->next()) {
	424	$event[$pid]['topay'] += ($nb * $montant);
	425	$event[$pid]['eid'] = $eid;
	426	$event[$pid]['shortname'] = $shortname;
	427	$event[$pid]['title'] = $title;
	428	$event[$pid]['ins'] = !is_null($nb);
	429	$event[$pid]['paid'] = $paid;
	430	}
	431	}
	432	$res = XDB::query("SELECT montant
	433	FROM {$globals->money->mpay_tprefix}transactions AS t
	434	WHERE ref = {?} AND uid = {?}", $pid, S::v('uid'));
	435	$montants = $res->fetchColumn();
	436
	437	foreach ($montants as $m) {
	438	$p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
	439	$event[$pid]['paid'] += trim($p);
	440	}
	441	}
	442	$page->assign('trans', $trans);
	443	$page->assign('event', $event);
	444	}
	445
92423144	446	function handler_admin(&$page, $action = 'list', $id = null) {
92423144	447	$page->assign('xorg_title','Polytechnique.org - Administration - Paiements');
a7de4ef7	448	$page->assign('title', 'Gestion des télépaiements');
92423144	449	$table_editor = new PLTableEditor('admin/payments','paiement.paiements','id');
92423144	450	$table_editor->add_join_table('paiement.transactions','ref',true);
2e7b5921	451	$table_editor->add_sort_field('flags');
de61dbcf	452	$table_editor->add_sort_field('id', true, true);
a7de4ef7	453	$table_editor->on_delete("UPDATE paiement.paiements SET flags = 'old' WHERE id = {?}", "Le paiement a été archivé");
a7de4ef7	454	$table_editor->describe('text','intitulé',true);
92423144	455	$table_editor->describe('url','site web',false);
a7de4ef7	456	$table_editor->describe('montant_def','montant par défaut',false);
92423144	457	$table_editor->describe('montant_min','montant minimum',false);
	458	$table_editor->describe('montant_max','montant maximum',false);
	459	$table_editor->describe('mail','email contact',true);
	460	$table_editor->describe('confirmation','message confirmation',false);
	461	$table_editor->apply($page, $action, $id);
	462	}
a2558f2b	463	}
a2558f2b	464
a7de4ef7	465	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
a2558f2b	466	?>