X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fvalidations%2Fmedals.inc.php;h=df04da67ebfa5fb6ed2d957b3a0e3de0f39f875a;hb=c4b6b1f4989e57e80aa721028d8255a3800442f9;hp=599ba21d197da5b874c9da9402e1dd4b446cffcb;hpb=d508daebb9e5ef00235efaf5ab1fdd8ce5b622dc;p=platal.git diff --git a/include/validations/medals.inc.php b/include/validations/medals.inc.php index 599ba21..df04da6 100644 --- a/include/validations/medals.inc.php +++ b/include/validations/medals.inc.php @@ -1,6 +1,6 @@ mid = $_idmedal; + parent::__construct($_user, $_profile, false, 'medal', $_stamp); + $this->mid = $_idmedal; $this->gid = $_subidmedal; + if (is_null($this->gid)) { + $this->gid = 0; + } } // }}} @@ -51,7 +54,7 @@ class MedalReq extends Validate 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(); } // }}} @@ -60,9 +63,9 @@ class MedalReq extends Validate protected function _mail_body($isok) { if ($isok) { - return " La décoration ".$this->medal_name()." vient d'être ajoutée à ta fiche."; + 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.'; } } @@ -71,13 +74,10 @@ class MedalReq extends Validate 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(); + $res = XDB::query('SELECT m.text + FROM profile_medal_enum AS m + WHERE m.id = {?}', $this->mid); + return $res->fetchOneCell(); } // }}} @@ -86,7 +86,7 @@ class MedalReq extends Validate public function submit() { $res = XDB::query("SELECT FIND_IN_SET('validation', flags) - FROM profile_medals + FROM profile_medal_enum WHERE id = {?}", $this->mid); if ($res->fetchOneCell()) { parent::submit(); @@ -100,19 +100,18 @@ class MedalReq extends Validate public function commit () { - require_once 'notifs.inc.php'; - register_watch_op($this->uid, WATCH_FICHE, '', 'medals'); - return XDB::execute('REPLACE INTO profile_medals_sub + return XDB::execute('REPLACE INTO profile_medals VALUES ({?}, {?}, {?})', - $this->uid, $this->mid, $this->gid); + $this->profile->id(), $this->mid, + is_null($this->gid) ? 0 : $this->gid); } // }}} // {{{ function get_request($medal) - static public function get_request($uid, $type) + static public function get_request($pid, $type) { - $reqs = Validate::get_typed_requests($uid, 'medal'); + $reqs = parent::get_typed_requests($pid, 'medal'); foreach ($reqs as &$req) { if ($req->mid == $type) { return $req;