2 /***************************************************************************
3 * Copyright (C) 2003-2007 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
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. *
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. *
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 *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
24 class PayReq
extends Validate
41 public $rules = "Laisser la validation à un trésorier";
45 public function __construct($_uid, $_intitule, $_site, $_montant, $_msg,
46 $_montantmin=0, $_montantmax=999, $_asso_id = 0,
49 parent
::__construct($_uid, false
, 'paiements', $_stamp);
51 $this->titre
= $_intitule;
53 $this->msg_reponse
= $_msg;
54 $this->asso_id
= (string)$_asso_id;
55 $this->evt
= (string)$_evt;
56 $this->montant
= $_montant;
57 $this->montant_min
= $_montantmin;
58 $this->montant_max
= $_montantmax;
61 $res = XDB
::query("SELECT nom FROM groupex.asso WHERE id = {?}", $_asso_id);
62 $this->asso
= $res->fetchOneCell();
64 if ($_asso_id && $_evt) {
65 $res = XDB
::query("SELECT intitule FROM groupex.evenements WHERE asso_id = {?} AND eid = {?}", $_asso_id, $_evt);
66 $this->evt_intitule
= $res->fetchOneCell();
71 // {{{ function same_event()
73 static public function same_event($evt, $asso_id)
75 $wevt = 's:3:"evt";s:'.strlen($evt+
"").':"'.$evt.'"';
76 $wassoid = 's:7:"asso_id";s:'.strlen($asso_id +
"").':"'.$asso_id.'"';
77 $where = "%".$wassoid."%".$wevt."%";
82 // {{{ function accept()
85 public function accept()
87 // no text [AI JMIAJM IJA MIJ]
88 if (preg_match('/\[[-\'"A-Z ]+\]/', $this->msg_reponse
)) {
89 $this->trig("La demande de paiement n'est pas valide. Merci de compléter le texte avant de la soumettre");
92 if (!preg_match('/<montant>/', $this->msg_reponse
)) {
93 $this->trig("Le demande de paiement ne contient pas la balise obligatoire <montant>");
100 // {{{ function submit()
102 // supprime les demandes de paiments pour le meme evenement
103 public function submit()
107 XDB
::execute('DELETE FROM requests WHERE type={?} AND data LIKE {?}', 'paiements', PayReq
::same_event($this->evt
, $this->asso_id
));
112 // {{{ function formu()
114 public function formu()
116 return 'include/form.valid.paiements.tpl';
120 // {{{ function editor()
122 public function editor()
124 return 'include/form.valid.edit-paiements.tpl';
128 // {{{ function handle_editor()
130 protected function handle_editor()
132 $this->titre
= Env
::v('pay_titre');
133 $this->site
= Env
::v('pay_site');
134 $this->montant
= Env
::i('pay_montant');
135 $this->montant_min
= Env
::i('pay_montant_min');
136 $this->montant_max
= Env
::i('pay_montant_max');
137 $this->msg_reponse
= Env
::v('pay_msg_reponse');
142 // {{{ function _mail_subj
144 protected function _mail_subj()
146 return "[Polytechnique.org/Paiments] Demande de création de paiement {$this->titre}";
150 // {{{ function _mail_body
152 protected function _mail_body($isok)
155 return " Le paiement que tu avais demandé pour {$this->titre} vient d'être créé.".($this->evt?
" Il a bien été associé à la gestion de l'événement du groupe":"");
157 return " La demande que tu avais faite pour le paiement de {$this->intitule} a été refusée.";
162 // {{{ function commit()
164 public function commit()
167 $res = XDB
::query("SELECT MAX(id) FROM paiement.paiements");
168 $id = $res->fetchOneCell()+
1;
169 $ret = XDB
::execute("INSERT INTO paiement.paiements VALUES
174 $id, $this->titre
, $this->site
,
175 $this->montant
, $this->montant_min
, $this->montant_max
,
176 $this->bestalias
."@".$globals->mail
->domain
, $this->msg_reponse
, $this->asso_id
);
177 if ($this->asso_id
&& $this->evt
) {
178 XDB
::execute("UPDATE groupex.evenements
179 SET paiement_id = {?}
180 WHERE asso_id = {?} AND eid = {?}",
181 $id, $this->asso_id
, $this->evt
);
182 $res = XDB
::query("SELECT a.nom, a.diminutif, e.intitule
183 FROM groupex.asso AS a
184 INNER JOIN groupex.evenements AS e ON (a.id = e.asso_id)
187 list($nom, $diminutif, $evt) = $res->fetchOneRow();
188 $mailer = new PlMailer('xnetevents/mail.new_payment.tpl');
189 $mailer->assign('asso', $nom);
190 $mailer->assign('diminutif', $diminutif);
191 $mailer->assign('evt', $evt);
192 $mailer->assign('payment', $id);
193 require_once dirname(__FILE__
) . '/../../modules/xnetevents/xnetevents.inc.php';
194 $participants = get_event_participants(get_event_detail($this->evt
, false
, $this->asso_id
), null
, 'nom');
195 foreach ($participants as &$u) {
196 if (!$u['notify_payment']) {
199 $topay = $u['montant'] - $u['paid'];
201 $mailer->assign('prenom', $u['prenom']);
202 $mailer->assign('topay', $topay);
203 $mailer->assign('to', $u['email']);
216 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: