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 | |
24 | class 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 | ?> |