include/validations/paiements.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2014 Polytechnique.org                              *
   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 // {{{ class PayReq
  23
  24 class PayReq extends Validate
  25 {
  26     // {{{ properties
  27
  28     public $titre;
  29     public $site;
  30
  31     public $montant;
  32     public $montant_min;
  33     public $montant_max;
  34
  35     public $msg_reponse;
  36     public $asso_id;
  37     public $asso;
  38     public $evt;
  39     public $evt_intitule;
  40     public $public;
  41     public $rib_id;
  42     public $rib_nom;
  43
  44     public $rules = "Vérifier la présence d'un montant, de la balise &lt;montant&gt;, et associer le RIB du groupe. Si le groupe n'a pas de RIB &quot;used&quot; ou en a plusieurs, laisser au trésorier.";
  45     // }}}
  46     // {{{ constructor
  47
  48     public function __construct(User $_user, $_intitule, $_site, $_montant, $_msg,
  49                                 $_montantmin=0, $_montantmax=999, $_asso_id = 0,
  50                                 $_evt = 0, $_public = false, $_stamp = 0)
  51     {
  52         parent::__construct($_user, false, 'paiements', $_stamp);
  53
  54         $this->titre        = $_intitule;
  55         $this->site         = $_site;
  56         $this->msg_reponse  = $_msg;
  57         $this->asso_id      = (string)$_asso_id;
  58         $this->evt          = (string)$_evt;
  59         $this->montant      = $_montant;
  60         $this->montant_min  = $_montantmin;
  61         $this->montant_max  = $_montantmax;
  62         $this->public       = $_public;
  63
  64         if ($_asso_id) {
  65             $res = XDB::query("SELECT nom FROM groups WHERE id = {?}", $_asso_id);
  66             $this->asso = $res->fetchOneCell();
  67         }
  68         if ($_asso_id && $_evt) {
  69             $res = XDB::query("SELECT intitule FROM group_events WHERE asso_id = {?} AND eid = {?}", $_asso_id, $_evt);
  70             $this->evt_intitule = $res->fetchOneCell();
  71         }
  72         // for future use, when anims can choose there bankaccounts
  73         if ($this->rib_id) {
  74             $res = XDB::query("SELECT owner FROM payment_bankaccounts WHERE id = {?}", $this->rib_id);
  75             $this->rib_nom = $res->fetchOneCell();
  76         }
  77     }
  78
  79     // }}}
  80     // {{{ function same_event()
  81
  82     static public function same_event($evt, $asso_id)
  83     {
  84         $wevt = 's:3:"evt";s:'.strlen($evt+"").':"'.$evt.'"';
  85         $wassoid = 's:7:"asso_id";s:'.strlen($asso_id + "").':"'.$asso_id.'"';
  86         $where = "%".$wassoid."%".$wevt."%";
  87         return $where;
  88     }
  89
  90     // }}}
  91     // {{{ function accept()
  92
  93     // check the message
  94     public function accept()
  95     {
  96         // no text [AI JMIAJM IJA MIJ]
  97         if (preg_match('/\[[-\'"a-zA-Z ]+\]/', replace_accent($this->msg_reponse))) {
  98             $this->trigError("La demande de paiement n'est pas valide. Merci de compléter le texte avant de la soumettre");
  99             return false;
 100         }
 101         if (!preg_match('/<montant>/', $this->msg_reponse)) {
 102             $this->trigError("Le demande de paiement ne contient pas la balise obligatoire &lt;montant&gt;");
 103             return false;
 104         }
 105         return true;
 106     }
 107
 108     // }}}
 109     // {{{ function submit()
 110
 111     // supprime les demandes de paiments pour le meme evenement
 112     public function submit()
 113     {
 114         if ($this->evt)
 115         {
 116             XDB::execute('DELETE FROM requests WHERE type={?} AND data LIKE {?}', 'paiements', PayReq::same_event($this->evt, $this->asso_id));
 117         }
 118         parent::submit();
 119     }
 120     // }}}
 121       // {{{ function formu()
 122
 123     public function formu()
 124     {
 125         return 'include/form.valid.paiements.tpl';
 126     }
 127
 128     // }}}
 129     // {{{ function editor()
 130
 131     public function editor()
 132     {
 133         return 'include/form.valid.edit-paiements.tpl';
 134     }
 135
 136     // }}}
 137     // {{{ function handle_editor()
 138
 139     protected function handle_editor()
 140     {
 141         $this->titre       = Env::v('pay_titre');
 142         $this->site        = Env::v('pay_site');
 143         $this->montant     = Env::t('pay_montant');
 144         $this->montant_min = Env::i('pay_montant_min');
 145         $this->montant_max = Env::i('pay_montant_max');
 146         $this->msg_reponse = Env::v('pay_msg_reponse');
 147         $this->public      = (Env::v('pay_public') == 'yes');
 148         $this->rib_id      = Env::v('pay_rib_id');
 149         if ($this->rib_id) {
 150             $res = XDB::query("SELECT owner FROM payment_bankaccounts WHERE id = {?}", $this->rib_id);
 151             $this->rib_nom = $res->fetchOneCell();
 152         } else {
 153             $this->rib_nom = null;
 154         }
 155         return true;
 156     }
 157
 158     // }}}
 159     // {{{ function _mail_subj
 160
 161     protected function _mail_subj()
 162     {
 163         return "[Polytechnique.org/Paiments] Demande de création de paiement {$this->titre}";
 164     }
 165
 166     // }}}
 167     // {{{ function _mail_body
 168
 169     protected function _mail_body($isok)
 170     {
 171         if ($isok) {
 172             return "  Le paiement demandé pour {$this->titre} vient d'être créé.".($this->evt?" Il a bien été associé à la gestion de l'événement du groupe":"");
 173         } else {
 174             return "  La demande faite pour le paiement de {$this->intitule} a été refusée.";
 175         }
 176     }
 177
 178     // }}}
 179     // {{{ function commit()
 180
 181     public function commit()
 182     {
 183         $res = XDB::query("SELECT MAX(id) FROM payments");
 184         $id = $res->fetchOneCell()+1;
 185         $ret = XDB::execute('INSERT INTO  payments (id, text, url, amount_def, amount_min, amount_max, mail, confirmation, asso_id, flags, rib_id)
 186                                   VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
 187                             $id, $this->titre, $this->site, $this->montant, $this->montant_min,
 188                             $this->montant_max, $this->user->bestEmail(), $this->msg_reponse, $this->asso_id,
 189                             ($this->public ? 'public' : ''), $this->rib_id);
 190         if ($this->asso_id && $this->evt) {
 191             XDB::execute("UPDATE  group_events
 192                              SET  paiement_id = {?}
 193                            WHERE  asso_id = {?} AND eid = {?}",
 194                          $id, $this->asso_id, $this->evt);
 195             $res = XDB::query("SELECT  a.nom, a.diminutif, e.intitule
 196                                  FROM  groups AS a
 197                            INNER JOIN  group_events AS e ON (a.id = e.asso_id)
 198                                 WHERE  e.eid = {?}",
 199                               $this->evt);
 200             list($nom, $diminutif, $evt) = $res->fetchOneRow();
 201             require_once dirname(__FILE__) . '/../../modules/xnetevents/xnetevents.inc.php';
 202             $participants = get_event_participants(get_event_detail($this->evt, false, $this->asso_id), null);
 203             foreach ($participants as $u) {
 204                 if (!$u['notify_payment']) {
 205                     continue;
 206                 }
 207                 $topay = $u['montant'] - $u['paid'];
 208                 if ($topay > 0) {
 209                     $mailer = new PlMailer('xnetevents/newpayment.mail.tpl');
 210                     $mailer->addTo($u['user']);
 211                     $mailer->assign('asso', $nom);
 212                     $mailer->assign('diminutif', $diminutif);
 213                     $mailer->assign('evt', $evt);
 214                     $mailer->assign('eid', $this->evt);
 215                     $mailer->assign('prenom', $u['user']->firstName());
 216                     $mailer->send();
 217                 }
 218             }
 219         }
 220         return $ret;
 221     }
 222
 223     // }}}
 224 }
 225
 226 // }}}
 227
 228 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
 229 ?>