[platal.git] / modules / payment.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2009 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) {
    global $globals;
    $mymail = new PlMailer();
    $mymail->addTo($globals->money->email);
    $mymail->setFrom("webmaster@" . $globals->mail->domain);
    $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 $erreur, $globals;
    if ($erreur) return;
    $erreur = $text;
    if (!$send) return;

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

    Platal::page()->trigError($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;
}

/* decode the comment */
function comment_decode($comment) {
    $comment = urldecode($comment);
    if (is_utf8($comment)) {
        return $comment;
    } else {
        return utf8_encode($comment);
    }
}


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, 'user', NO_HTTPS),
            'payment/paypal_return'      => $this->make_hook('paypal_return', AUTH_PUBLIC, 'user', NO_HTTPS),
            '%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, 'user', NO_HTTPS),
            '%grp/payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC, 'user', NO_HTTPS),
            'admin/payments'             => $this->make_hook('admin',         AUTH_MDP,    'admin'),

        );
    }

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

        require_once 'profil.func.inc.php' ;
        $this->load('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;
            }
        }
        $page->changeTpl('payment/index.tpl');
        $page->setTitle('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->trigError("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->trigError($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 = Env::s('CHAMP901');
        /* cle d'acceptation */
        $champ905 = Env::s('CHAMP905');
        /* code retour */
        $champ906 = Env::s('CHAMP906');
        /* email renvoye par la banque */
        $champ104 = Env::s('CHAMP104');
        /* reference complete de la commande */
        $champ200 = Env::s('CHAMP200');
        /* montant de la transaction */
        $champ201 = Env::s('CHAMP201');
        /* devise */
        $champ202 = Env::s('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('femme', a.flags)
              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'));

        // We check if it is an Xnet payment and then update the related ML.
        $res = XDB::query('SELECT  eid
                             FROM  groupex.evenements
                            WHERE  paiement_id = {?}', $ref);
        if ($eid = $res->fetchOneCell()) {
            $this->load('xnetevents.inc.php');
            $evt = get_event_detail($eid);
            subscribe_lists_event(0, $uid, $evt, $montant, true);
        }

        /* 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("<comment>", Env::v('comment'), $conf_text);
        $conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
        $conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);

        global $globals;
        $mymail = new PlMailer();
        $mymail->setFrom($conf_mail);
        $mymail->addTo("\"$prenom $nom\" <$forlife@" . $globals->mail->domain . '>');
        $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@" . $globals->mail->domain);
        $mymail->addTo($globals->money->email);
        $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)
    {
        $page->changeTpl('payment/retour_paypal.tpl');

        /* reference banque (numero de transaction) */
        $no_transaction = Env::s('tx');
        /* token a renvoyer pour avoir plus d'information */
        $clef = Env::s('sig');
        /* code retour */
        $status = Env::s('st');
        /* raison */
        $reason = ($status == 'Pending')? Env::s('pending_reason'): Env::s('reason_code');
        /* reference complete de la commande */
        $fullref = Env::s('cm');
        /* montant de la transaction */
        $montant_nb = Env::s('amt');
        /* devise */
        $montant_dev = Env::s('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('femme', a.flags)
              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'));

        // We check if it is an Xnet payment and then update the related ML.
        $res = XDB::query('SELECT  eid
                             FROM  groupex.evenements
                            WHERE  paiement_id = {?}', $ref);
        if ($eid = $res->fetchOneCell()) {
            $this->load('xnetevents.inc.php');
            $evt = get_event_detail($eid);
            subscribe_lists_event(0, $uid, $evt, $montant, true);
        }

        /* 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);

        global $globals;
        $mymail = new PlMailer();
        $mymail->setFrom($conf_mail);
        $mymail->addTo("\"$prenom $nom\" <$forlife@" . $globals->mail->domain . '>');
        $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@" . $globals->mail->domain);
        $mymail->addTo($globals->money->email);
        $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;

        $perms = S::v('perms');
        if (!$perms->hasFlag('groupmember')) {
            if (is_null($pid)) {
                return PL_FORBIDDEN;
            }
            $res = XDB::query("SELECT  1
                                 FROM  groupex.evenements AS e
                           INNER JOIN  groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?})
                                WHERE  e.paiement_id = {?} AND e.asso_id = {?}",
                              S::i('uid'), $pid, $globals->asso('id'));
            if ($res->numRows() == 0) {
                return PL_FORBIDDEN;
            }
        }

        if (!is_null($pid)) {
            return  $this->handler_payment($page, $pid);
        }
        $page->changeTpl('payment/xnet.tpl');

        $res = XDB::query(
                "SELECT  id, text, url
                   FROM  {$globals->money->mpay_tprefix}paiements
                  WHERE  asso_id = {?} AND NOT FIND_IN_SET('old', flags)
               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->register_modifier('decode_comment', 'decode_comment');
        $page->assign('trans', $trans);
        $page->assign('event', $event);
    }

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