20d7932b |
1 | <?php |
2 | /*************************************************************************** |
5ddeb07c |
3 | * Copyright (C) 2003-2007 Polytechnique.org * |
20d7932b |
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 MedalReq |
23 | |
24 | class MedalReq extends Validate |
25 | { |
26 | // {{{ properties |
27 | |
612a2d8a |
28 | public $mid; |
29 | public $gid; |
20d7932b |
30 | |
31 | // }}} |
32 | // {{{ constructor |
33 | |
612a2d8a |
34 | public function __construct($_uid, $_idmedal, $_subidmedal, $_stamp=0) |
20d7932b |
35 | { |
612a2d8a |
36 | parent::__construct($_uid, false, 'medal', $_stamp); |
20d7932b |
37 | $this->mid = $_idmedal; |
38 | $this->gid = $_subidmedal; |
39 | } |
40 | |
41 | // }}} |
42 | // {{{ function formu() |
43 | |
612a2d8a |
44 | public function formu() |
787bb3d7 |
45 | { |
612a2d8a |
46 | return 'include/form.valid.medals.tpl'; |
47 | } |
20d7932b |
48 | |
49 | // }}} |
50 | // {{{ function _mail_subj |
51 | |
612a2d8a |
52 | protected function _mail_subj() |
20d7932b |
53 | { |
a7de4ef7 |
54 | return "[Polytechnique.org/Décoration] Demande de décoration : ".$this->medal_name(); |
20d7932b |
55 | } |
56 | |
57 | // }}} |
58 | // {{{ function _mail_body |
59 | |
612a2d8a |
60 | protected function _mail_body($isok) |
20d7932b |
61 | { |
62 | if ($isok) { |
a7de4ef7 |
63 | return " La décoration ".$this->medal_name()." vient d'être ajoutée à ta fiche."; |
20d7932b |
64 | } else { |
a7de4ef7 |
65 | return " La demande que tu avais faite pour la décoration ".$this->medal_name()." a été refusée."; |
20d7932b |
66 | } |
67 | } |
68 | |
69 | // }}} |
70 | // {{{ function medal_name |
71 | |
612a2d8a |
72 | public function medal_name() |
20d7932b |
73 | { |
612a2d8a |
74 | //var_dump($this); |
75 | $r = XDB::query(" |
787bb3d7 |
76 | SELECT IF (g.text IS NOT NULL, CONCAT(m.text,' - ', g.text), m.text) |
612a2d8a |
77 | FROM profile_medals AS m |
78 | LEFT JOIN profile_medals_grades AS g ON(g.mid = m.id AND g.gid = {?}) |
79 | WHERE m.id = {?}", $this->gid, $this->mid); |
787bb3d7 |
80 | return $r->fetchOneCell(); |
20d7932b |
81 | } |
82 | |
83 | // }}} |
d02b8359 |
84 | // {{{ function submit() |
85 | |
612a2d8a |
86 | public function submit() |
d02b8359 |
87 | { |
010268b2 |
88 | $res = XDB::query("SELECT FIND_IN_SET('validation', flags) |
d02b8359 |
89 | FROM profile_medals |
90 | WHERE id = {?}", $this->mid); |
91 | if ($res->fetchOneCell()) { |
92 | parent::submit(); |
93 | } else { |
94 | $this->commit(); |
95 | } |
96 | } |
612a2d8a |
97 | |
d02b8359 |
98 | // }}} |
20d7932b |
99 | // {{{ function commit() |
100 | |
612a2d8a |
101 | public function commit () |
20d7932b |
102 | { |
612a2d8a |
103 | return XDB::execute('REPLACE INTO profile_medals_sub VALUES({?}, {?}, {?})', $this->uid, $this->mid, $this->gid); |
20d7932b |
104 | } |
105 | |
106 | // }}} |
107 | } |
108 | |
109 | // }}} |
110 | |
a7de4ef7 |
111 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
20d7932b |
112 | ?> |