Commit | Line | Data |
---|---|---|
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 | // }}} | |
85cc366b FB |
107 | // {{{ function get_request($medal) |
108 | ||
109 | static public function get_request($uid, $type) | |
110 | { | |
111 | $reqs = Validate::get_typed_requests($uid, 'medal'); | |
112 | foreach ($reqs as &$req) { | |
113 | if ($req->mid == $type) { | |
114 | return $req; | |
115 | } | |
116 | } | |
117 | return null; | |
118 | } | |
119 | ||
120 | // }}} | |
20d7932b | 121 | } |
122 | ||
123 | // }}} | |
124 | ||
a7de4ef7 | 125 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
20d7932b | 126 | ?> |