[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'));

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

        /* 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(
	91	'payment' => $this->make_hook('payment', AUTH_MDP),
41cce805 FB	92	'payment/cyber_return' => $this->make_hook('cyber_return', AUTH_PUBLIC, 'user', NO_HTTPS),
41cce805 FB	93	'payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC, 'user', NO_HTTPS),
45a5307b FB	94	'%grp/paiement' => $this->make_hook('xnet_payment', AUTH_MDP),
45a5307b FB	95	'%grp/payment' => $this->make_hook('xnet_payment', AUTH_MDP),
41cce805 FB	96	'%grp/payment/cyber_return' => $this->make_hook('cyber_return', AUTH_PUBLIC, 'user', NO_HTTPS),
41cce805 FB	97	'%grp/payment/paypal_return' => $this->make_hook('paypal_return', AUTH_PUBLIC, 'user', NO_HTTPS),
92423144	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
	210	LEFT JOIN paiement.codeC AS c ON rcb.codeC=c.id
	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
	224	/* on genere le mail de confirmation */
	225	$conf_text = str_replace("<prenom>",$prenom,$conf_text);
	226	$conf_text = str_replace("<nom>",$nom,$conf_text);
	227	$conf_text = str_replace("<promo>",$promo,$conf_text);
	228	$conf_text = str_replace("<montant>",$montant,$conf_text);
a7de4ef7	229	$conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
a7de4ef7	230	$conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);
a2558f2b	231
7895f3c1	232	global $globals;
1e33266a	233	$mymail = new PlMailer();
a2558f2b	234	$mymail->setFrom($conf_mail);
1d55fe45	235	$mymail->addTo("\"$prenom $nom\" <$forlife@" . $globals->mail->domain . '>');
a2558f2b	236	$mymail->addCc($conf_mail);
a2558f2b	237	$mymail->setSubject($conf_title);
88e3843c	238	$mymail->setWikiBody($conf_text);
88e3843c	239	$mymail->send(S::v('mail_fmt') == 'html');
a2558f2b	240
a7de4ef7	241	/* on envoie les details de la transaction à telepaiement@ */
1e33266a	242	$mymail = new PlMailer();
1d55fe45	243	$mymail->setFrom("webmaster@" . $globals->mail->domain);
d7dd70be	244	$mymail->addTo($globals->money->email);
a2558f2b	245	$mymail->setSubject($conf_title);
	246	$msg = "utilisateur : $prenom $nom ($uid)\n".
	247	"mail : $forlife@polytechnique.org\n\n".
	248	"paiement : $conf_title ($conf_mail)\n".
	249	"reference : $champ200\n".
	250	"montant : $montant\n\n".
	251	"dump de REQUEST:\n".
	252	var_export($_REQUEST,true);
	253	$mymail->setTxtBody($msg);
	254	$mymail->send();
	255	exit;
	256	}
	257
	258	function handler_paypal_return(&$page, $uid = null)
	259	{
da157660	260	$page->changeTpl('payment/retour_paypal.tpl');
a2558f2b	261
a2558f2b	262	/* reference banque (numero de transaction) */
7280eb45	263	$no_transaction = Env::s('tx');
a2558f2b	264	/* token a renvoyer pour avoir plus d'information */
7280eb45	265	$clef = Env::s('sig');
a2558f2b	266	/* code retour */
7280eb45	267	$status = Env::s('st');
a2558f2b	268	/* raison */
7280eb45	269	$reason = ($status == 'Pending')? Env::s('pending_reason'): Env::s('reason_code');
a2558f2b	270	/* reference complete de la commande */
7280eb45	271	$fullref = Env::s('cm');
a2558f2b	272	/* montant de la transaction */
7280eb45	273	$montant_nb = Env::s('amt');
a2558f2b	274	/* devise */
7280eb45	275	$montant_dev = Env::s('cc');
a2558f2b	276	$montant = "$montant_nb $montant_dev";
	277
	278	/* on extrait le code de retour */
	279	if ($status != "Completed") {
	280	if ($status)
	281	paypal_erreur("erreur lors du paiement : $status - $reason");
	282	else
a7de4ef7	283	paypal_erreur("Paiement annulé", false);
a2558f2b	284	}
	285
	286	/* on extrait les informations sur l'utilisateur */
08cce2ff	287	$res = XDB::query("
010268b2	288	SELECT a.prenom,a.nom,a.promo,l.alias,FIND_IN_SET('femme', a.flags)
a2558f2b	289	FROM auth_user_md5 AS a
	290	INNER JOIN aliases AS l ON (a.user_id=l.id AND type!='homonyme')
	291	WHERE a.user_id={?}", $uid);
	292	if (!list($prenom,$nom,$promo,$forlife,$femme) = $res->fetchOneRow()) {
	293	paypal_erreur("uid invalide");
	294	}
	295
	296	/* on extrait la reference de la commande */
	297	if (!ereg('-xorg-([0-9]+)$',$fullref,$matches)) {
a7de4ef7	298	paypal_erreur("référence de commande invalide");
a2558f2b	299	}
	300
	301	$ref = $matches[1];
08cce2ff	302	$res = XDB::query("SELECT mail,text,confirmation
98a7e9dc	303	FROM paiement.paiements
98a7e9dc	304	WHERE id={?}", $ref);
a2558f2b	305	if (!list($conf_mail,$conf_title,$conf_text) = $res->fetchOneRow()) {
a7de4ef7	306	paypal_erreur("référence de commande inconnue");
a2558f2b	307	}
	308
	309	/* on fait l'insertion en base de donnees */
bff6d838	310	XDB::execute("INSERT INTO paiement.transactions (id,uid,ref,fullref,montant,cle,comment)
98a7e9dc	311	VALUES ({?},{?},{?},{?},{?},{?},{?})",
98a7e9dc	312	$no_transaction, $uid, $ref, $fullref, $montant, $clef, Env::v('comment'));
a2558f2b	313
	314	/* on genere le mail de confirmation */
	315	$conf_text = str_replace("<prenom>",$prenom,$conf_text);
	316	$conf_text = str_replace("<nom>",$nom,$conf_text);
	317	$conf_text = str_replace("<promo>",$promo,$conf_text);
	318	$conf_text = str_replace("<montant>",$montant,$conf_text);
a7de4ef7	319	$conf_text = str_replace("<salutation>",$femme ? "Chère" : "Cher",$conf_text);
a7de4ef7	320	$conf_text = str_replace("<cher>",$femme ? "Chère" : "Cher",$conf_text);
a2558f2b	321
7895f3c1	322	global $globals;
1e33266a	323	$mymail = new PlMailer();
a2558f2b	324	$mymail->setFrom($conf_mail);
1d55fe45	325	$mymail->addTo("\"$prenom $nom\" <$forlife@" . $globals->mail->domain . '>');
a2558f2b	326	$mymail->addCc($conf_mail);
a2558f2b	327	$mymail->setSubject($conf_title);
88e3843c	328	$mymail->setWikiBody($conf_text);
88e3843c	329	$mymail->send(S::v('mail_fmt') == 'html');
a2558f2b	330
a7de4ef7	331	/* on envoie les details de la transaction à telepaiement@ */
1e33266a	332	$mymail = new PlMailer();
1d55fe45	333	$mymail->setFrom("webmaster@" . $globals->mail->domain);
d7dd70be	334	$mymail->addTo($globals->money->email);
a2558f2b	335	$mymail->setSubject($conf_title);
	336	$msg = "utilisateur : $prenom $nom ($uid)\n".
	337	"mail : $forlife@polytechnique.org\n\n".
	338	"paiement : $conf_title ($conf_mail)\n".
	339	"reference : $no_transaction\n".
	340	"montant : $montant\n\n".
	341	"dump de REQUEST:\n".
	342	var_export($_REQUEST,true);
	343	$mymail->setTxtBody($msg);
	344	$mymail->send();
	345
	346	$page->assign('texte', $conf_text);
	347	$page->assign('erreur', $erreur);
a2558f2b	348	}
98a7e9dc	349
	350	function handler_xnet_payment(&$page, $pid = null)
	351	{
	352	global $globals;
eaf30d86	353
45a5307b FB	354	$perms = S::v('perms');
	355	if (!$perms->hasFlag('groupmember')) {
	356	if (is_null($pid)) {
	357	return PL_FORBIDDEN;
	358	}
	359	$res = XDB::query("SELECT 1
	360	FROM groupex.evenements AS e
	361	INNER JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?})
	362	WHERE e.paiement_id = {?} AND e.asso_id = {?}",
	363	S::i('uid'), $pid, $globals->asso('id'));
	364	if ($res->numRows() == 0) {
	365	return PL_FORBIDDEN;
	366	}
	367	}
	368
98a7e9dc	369	if (!is_null($pid)) {
	370	return $this->handler_payment($page, $pid);
	371	}
1490093c	372	$page->changeTpl('payment/xnet.tpl');
eaf30d86	373
98a7e9dc	374	$res = XDB::query(
	375	"SELECT id, text, url
	376	FROM {$globals->money->mpay_tprefix}paiements
010268b2	377	WHERE asso_id = {?} AND NOT FIND_IN_SET('old', flags)
98a7e9dc	378	ORDER BY id DESC", $globals->asso('id'));
	379	$tit = $res->fetchAllAssoc();
	380	$page->assign('titres', $tit);
	381
	382	$order = Env::v('order', 'timestamp');
de4b22cc	383	$orders = array('timestamp', 'nom', 'promo', 'montant', 'comment');
98a7e9dc	384	if (!in_array($order, $orders)) {
98a7e9dc	385	$order = 'timestamp';
de4b22cc	386	} elseif ($order == 'comment') {
de4b22cc	387	$order = 't.comment';
98a7e9dc	388	}
	389	$inv_order = Env::v('order_inv', 0);
	390	$page->assign('order', $order);
	391	$page->assign('order_inv', !$inv_order);
	392
	393	if ($order == 'timestamp') {
	394	$inv_order = !$inv_order;
	395	}
	396
	397	if ($inv_order) {
	398	$inv_order = ' DESC';
	399	} else {
	400	$inv_order = '';
	401	}
	402	if ($order == 'montant') {
	403	$order = 'LENGTH(montant) '.$inv_order.', montant';
	404	}
	405
	406	$orderby = 'ORDER BY '.$order.$inv_order;
	407	if ($order != 'nom') {
	408	$orderby .= ', nom'; $inv_order = '';
	409	}
	410	$orderby .= ', prenom'.$inv_order;
	411	if ($order != 'timestamp') {
	412	$orderby .= ', timestamp DESC';
	413	}
	414
	415	$trans = array();
	416	$event = array();
	417	foreach($tit as $foo) {
	418	$pid = $foo['id'];
	419	if (may_update()) {
	420	$res = XDB::query("SELECT IF(u.nom_usage<>'', u.nom_usage, u.nom) AS nom,
de4b22cc	421	u.prenom, u.promo, a.alias, timestamp AS `date`, t.comment, montant
98a7e9dc	422	FROM {$globals->money->mpay_tprefix}transactions AS t
	423	INNER JOIN auth_user_md5 AS u ON ( t.uid = u.user_id )
	424	INNER JOIN aliases AS a ON ( t.uid = a.id AND a.type='a_vie' )
	425	WHERE ref = {?} ".$orderby, $pid);
	426	$trans[$pid] = $res->fetchAllAssoc();
	427	$sum = 0;
	428	foreach ($trans[$pid] as $i => $t) {
	429	$sum += strtr(substr($t['montant'], 0, strpos($t['montant'], 'EUR')), ',', '.');
a7de4ef7	430	$trans[$pid][$i]['montant'] = str_replace('EUR', '€', $t['montant']);
98a7e9dc	431	}
98a7e9dc	432	$trans[$pid][] = array('nom' => 'somme totale',
a7de4ef7	433	'montant' => strtr($sum, '.', ',').' €');
98a7e9dc	434	}
	435	$res = XDB::iterRow("SELECT e.eid, e.short_name, e.intitule, ep.nb, ei.montant, ep.paid
	436	FROM groupex.evenements AS e
	437	LEFT JOIN groupex.evenements_participants AS ep ON (ep.eid = e.eid AND uid = {?})
	438	INNER JOIN groupex.evenements_items AS ei ON (ep.eid = ei.eid AND ep.item_id = ei.item_id)
	439	WHERE e.paiement_id = {?}",
	440	S::v('uid'), $pid);
	441	$event[$pid] = array();
	442	$event[$pid]['paid'] = 0;
	443	if ($res->total()) {
	444	$event[$pid]['topay'] = 0;
	445	while(list($eid, $shortname, $title, $nb, $montant, $paid) = $res->next()) {
	446	$event[$pid]['topay'] += ($nb * $montant);
	447	$event[$pid]['eid'] = $eid;
	448	$event[$pid]['shortname'] = $shortname;
	449	$event[$pid]['title'] = $title;
	450	$event[$pid]['ins'] = !is_null($nb);
	451	$event[$pid]['paid'] = $paid;
	452	}
	453	}
	454	$res = XDB::query("SELECT montant
	455	FROM {$globals->money->mpay_tprefix}transactions AS t
	456	WHERE ref = {?} AND uid = {?}", $pid, S::v('uid'));
	457	$montants = $res->fetchColumn();
	458
	459	foreach ($montants as $m) {
	460	$p = strtr(substr($m, 0, strpos($m, 'EUR')), ',', '.');
	461	$event[$pid]['paid'] += trim($p);
	462	}
	463	}
17793ccf	464	$page->register_modifier('decode_comment', 'decode_comment');
98a7e9dc	465	$page->assign('trans', $trans);
	466	$page->assign('event', $event);
	467	}
eaf30d86	468
92423144	469	function handler_admin(&$page, $action = 'list', $id = null) {
46f272fe	470	$page->setTitle('Administration - Paiements');
a7de4ef7	471	$page->assign('title', 'Gestion des télépaiements');
92423144	472	$table_editor = new PLTableEditor('admin/payments','paiement.paiements','id');
92423144	473	$table_editor->add_join_table('paiement.transactions','ref',true);
2e7b5921	474	$table_editor->add_sort_field('flags');
de61dbcf	475	$table_editor->add_sort_field('id', true, true);
a7de4ef7	476	$table_editor->on_delete("UPDATE paiement.paiements SET flags = 'old' WHERE id = {?}", "Le paiement a été archivé");
a7de4ef7	477	$table_editor->describe('text','intitulé',true);
92423144	478	$table_editor->describe('url','site web',false);
a7de4ef7	479	$table_editor->describe('montant_def','montant par défaut',false);
92423144	480	$table_editor->describe('montant_min','montant minimum',false);
	481	$table_editor->describe('montant_max','montant maximum',false);
	482	$table_editor->describe('mail','email contact',true);
	483	$table_editor->describe('confirmation','message confirmation',false);
	484	$table_editor->apply($page, $action, $id);
eaf30d86	485	}
a2558f2b	486	}
a2558f2b	487
a7de4ef7	488	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
a2558f2b	489	?>