#173: Select countries where there is somebody
[platal.git] / include / validations / paiements.inc.php
CommitLineData
0337d704 1<?php
2/***************************************************************************
5ddeb07c 3 * Copyright (C) 2003-2007 Polytechnique.org *
0337d704 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
24class PayReq extends Validate
25{
26 // {{{ properties
27
612a2d8a 28 public $titre;
29 public $site;
0337d704 30
612a2d8a 31 public $montant;
32 public $montant_min;
33 public $montant_max;
0337d704 34
612a2d8a 35 public $msg_reponse;
36 public $asso_id;
37 public $asso;
38 public $evt;
39 public $evt_intitule;
0337d704 40
612a2d8a 41 public $rules = "Laisser la validation à un trésorier";
0337d704 42 // }}}
43 // {{{ constructor
a3a049fc 44
612a2d8a 45 public function __construct($_uid, $_intitule, $_site, $_montant, $_msg,
46 $_montantmin=0, $_montantmax=999, $_asso_id = 0,
47 $_evt = 0, $_stamp=0)
0337d704 48 {
612a2d8a 49 parent::__construct($_uid, false, 'paiements', $_stamp);
a3a049fc 50
0337d704 51 $this->titre = $_intitule;
52 $this->site = $_site;
53 $this->msg_reponse = $_msg;
54 $this->asso_id = $_asso_id;
55 $this->evt = $_evt;
56 $this->montant = $_montant;
57 $this->montant_min = $_montantmin;
58 $this->montant_max = $_montantmax;
59
60 if ($_asso_id) {
08cce2ff 61 $res = XDB::query("SELECT nom FROM groupex.asso WHERE id = {?}", $_asso_id);
0337d704 62 $this->asso = $res->fetchOneCell();
63 }
64 if ($_asso_id && $_evt) {
08cce2ff 65 $res = XDB::query("SELECT intitule FROM groupex.evenements WHERE asso_id = {?} AND eid = {?}", $_asso_id, $_evt);
0337d704 66 $this->evt_intitule = $res->fetchOneCell();
67 }
68 }
69
70 // }}}
612a2d8a 71 // {{{ function same_event()
72
73 static public function same_event($evt, $asso_id)
b479e26b 74 {
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."%";
78 return $where;
79 }
612a2d8a 80
81 // }}}
82 // {{{ function submit()
83
84 // supprime les demandes de paiments pour le meme evenement
85 public function submit()
029e6327 86 {
029e6327 87 if ($this->evt)
88 {
08cce2ff 89 XDB::execute('DELETE FROM requests WHERE type={?} AND data LIKE {?}', 'paiements', PayReq::same_event($this->evt, $this->asso_id));
029e6327 90 }
612a2d8a 91 parent::submit();
029e6327 92 }
93 // }}}
94 // {{{ function formu()
0337d704 95
612a2d8a 96 public function formu()
97 {
98 return 'include/form.valid.paiements.tpl';
99 }
0337d704 100
101 // }}}
6aa01fed 102 // {{{ function editor()
103
612a2d8a 104 public function editor()
6aa01fed 105 {
106 return 'include/form.valid.edit-paiements.tpl';
107 }
108
109 // }}}
110 // {{{ function handle_editor()
111
612a2d8a 112 protected function handle_editor()
6aa01fed 113 {
114 $this->titre = Env::v('pay_titre');
115 $this->site = Env::v('pay_site');
116 $this->montant = Env::i('pay_montant');
117 $this->montant_min = Env::i('pay_montant_min');
118 $this->montant_max = Env::i('pay_montant_max');
119 $this->msg_reponse = Env::v('pay_msg_reponse');
120 return true;
121 }
122
123 // }}}
0337d704 124 // {{{ function _mail_subj
125
612a2d8a 126 protected function _mail_subj()
0337d704 127 {
a7de4ef7 128 return "[Polytechnique.org/Paiments] Demande de création de paiement {$this->titre}";
0337d704 129 }
130
131 // }}}
132 // {{{ function _mail_body
133
612a2d8a 134 protected function _mail_body($isok)
0337d704 135 {
136 if ($isok) {
a7de4ef7 137 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":"");
0337d704 138 } else {
a7de4ef7 139 return " La demande que tu avais faite pour le paiement de {$this->intitule} a été refusée.";
0337d704 140 }
141 }
142
143 // }}}
144 // {{{ function commit()
145
612a2d8a 146 public function commit()
0337d704 147 {
148 global $globals;
08cce2ff 149 $res = XDB::query("SELECT MAX(id) FROM paiement.paiements");
0337d704 150 $id = $res->fetchOneCell()+1;
08cce2ff 151 $ret = XDB::execute("INSERT INTO paiement.paiements VALUES
0337d704 152 ( {?}, {?}, {?}, '',
153 {?}, {?}, {?},
154 {?}, {?}, {?} )
155 ",
156 $id, $this->titre, $this->site,
157 $this->montant, $this->montant_min, $this->montant_max,
158 $this->bestalias."@".$globals->mail->domain, $this->msg_reponse, $this->asso_id);
159 if ($this->asso_id && $this->evt)
08cce2ff 160 $ret = XDB::execute("UPDATE groupex.evenements SET paiement_id = {?} WHERE asso_id = {?} AND eid = {?}", $id, $this->asso_id, $this->evt);
0337d704 161
162 return $ret;
163 }
164
165 // }}}
166}
167
168// }}}
169
a7de4ef7 170// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
0337d704 171?>