X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Fmedals.inc.php;h=fc779185627abe50ccb285015dee6ac88b6d25d8;hb=6859200d482b72f9dc6483a3c27621d6e945736d;hp=14f0b87e750c8281e2b58f4f45839a9db7961601;hpb=20d7932b9db32f4dbf96312efc1981a5bebd9b7d;p=platal.git diff --git a/include/validations/medals.inc.php b/include/validations/medals.inc.php index 14f0b87..fc77918 100644 --- a/include/validations/medals.inc.php +++ b/include/validations/medals.inc.php @@ -1,6 +1,6 @@ Validate($_uid, false, 'medal', $_stamp); - $this->mid = $_idmedal; + parent::__construct($_user, $_profile, false, 'medal', $_stamp); + $this->mid = $_idmedal; $this->gid = $_subidmedal; + if (is_null($this->gid)) { + $this->gid = 0; + } } // }}} // {{{ function formu() - function formu() - { - return 'include/form.valid.medals.tpl'; - } + public function formu() + { + return 'include/form.valid.medals.tpl'; + } // }}} // {{{ function _mail_subj - function _mail_subj() + protected function _mail_subj() { - return "[Polytechnique.org/Décoration] Demande de décoration : ".$this->medal_name(); + return '[Polytechnique.org/Décoration] Demande de décoration : ' . $this->medal_name(); } // }}} // {{{ function _mail_body - function _mail_body($isok) + protected function _mail_body($isok) { if ($isok) { - return " La décoration ".$this->medal_name()." que tu avais demandée vient d'être acceptée."; + return ' La décoration ' . $this->medal_name() . ' vient d\'être ajoutée à ta fiche.'; } else { - return " La demande que tu avais faite pour la décoration ".$this->medal_name()." a été refusée."; + return ' La demande que tu avais faite pour la décoration ' . $this->medal_name() . ' a été refusée.'; } } // }}} // {{{ function medal_name - function medal_name() + public function medal_name() { - //var_dump($this); - $r = XDB::query(" - SELECT IF (g.text IS NOT NULL, CONCAT(m.text,' - ', g.text), m.text) - FROM profile_medals AS m - LEFT JOIN profile_medals_grades AS g ON(g.mid = m.id AND g.gid = {?}) - WHERE m.id = {?}", $this->gid, $this->mid); - return $r->fetchOneCell(); + $name = XDB::fetchOneCell('SELECT text + FROM profile_medal_enum + WHERE id = {?}', $this->mid); + $grade = XDB::fetchOneCell('SELECT text + FROM profile_medal_grade_enum + WHERE mid = {?} AND gid = {?}', + $this->mid, $this->gid); + if (is_null($grade)) { + return $name; + } + return $name . ' (' . $grade . ')'; + } + + // }}} + // {{{ function submit() + + public function submit() + { + $res = XDB::query("SELECT FIND_IN_SET('validation', flags) + FROM profile_medal_enum + WHERE id = {?}", $this->mid); + if ($res->fetchOneCell()) { + parent::submit(); + } else { + $this->commit(); + } } // }}} // {{{ function commit() - function commit () + public function commit () + { + return XDB::execute('INSERT INTO profile_medals (pid, mid, gid) + VALUES ({?}, {?}, {?}) + ON DUPLICATE KEY UPDATE gid = VALUES(gid)', + $this->profile->id(), $this->mid, + is_null($this->gid) ? 0 : $this->gid); + } + + // }}} + // {{{ function get_request($medal) + + static public function get_request($pid, $type, $grade) { - return XDB::execute('REPLACE INTO profile_medals_sub VALUES({?}, {?}, {?})', $this->uid, $this->mid, $this->gid); + $reqs = parent::get_typed_requests($pid, 'medal'); + foreach ($reqs as &$req) { + if ($req->mid == $type && $req->gid == $grade) { + return $req; + } + } + return null; } // }}} @@ -93,5 +133,5 @@ class MedalReq extends Validate // }}} -// vim:set et sw=4 sts=4 sws=4 foldmethod=marker: +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>