include/validations/medals.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2011 Polytechnique.org                              *
   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 ProfileValidate
  25 {
  26     // {{{ properties
  27
  28     public $mid;
  29     public $gid;
  30
  31     // }}}
  32     // {{{ constructor
  33
  34     public function __construct(User $_user, Profile $_profile, $_idmedal, $_subidmedal, $_stamp = 0)
  35     {
  36         parent::__construct($_user, $_profile, false, 'medal', $_stamp);
  37         $this->mid = $_idmedal;
  38         $this->gid = $_subidmedal;
  39         if (is_null($this->gid)) {
  40             $this->gid = 0;
  41         }
  42     }
  43
  44     // }}}
  45     // {{{ function formu()
  46
  47     public function formu()
  48     {
  49         return 'include/form.valid.medals.tpl';
  50     }
  51
  52     // }}}
  53     // {{{ function _mail_subj
  54
  55     protected function _mail_subj()
  56     {
  57         return '[Polytechnique.org/Décoration] Demande de décoration : ' . $this->medal_name();
  58     }
  59
  60     // }}}
  61     // {{{ function _mail_body
  62
  63     protected function _mail_body($isok)
  64     {
  65         if ($isok) {
  66             return '  La décoration ' . $this->medal_name() . ' vient d\'être ajoutée à ta fiche.';
  67         } else {
  68             return '  La demande que tu avais faite pour la décoration ' . $this->medal_name() . ' a été refusée.';
  69         }
  70     }
  71
  72     // }}}
  73     // {{{ function medal_name
  74
  75     public function medal_name()
  76     {
  77         $name = XDB::fetchOneCell('SELECT  text
  78                                      FROM  profile_medal_enum
  79                                     WHERE  id = {?}', $this->mid);
  80         $grade = XDB::fetchOneCell('SELECT  text
  81                                       FROM  profile_medal_grade_enum
  82                                      WHERE  mid = {?} AND gid = {?}',
  83                                    $this->mid, $this->gid);
  84         if (is_null($grade)) {
  85             return $name;
  86         }
  87         return $name . ' (' . $grade . ')';
  88     }
  89
  90     // }}}
  91     // {{{ function submit()
  92
  93     public function submit()
  94     {
  95         $res = XDB::query("SELECT  FIND_IN_SET('validation', flags)
  96                              FROM  profile_medal_enum
  97                             WHERE  id = {?}", $this->mid);
  98         if ($res->fetchOneCell()) {
  99             parent::submit();
 100         } else {
 101             $this->commit();
 102         }
 103     }
 104
 105     // }}}
 106     // {{{ function commit()
 107
 108     public function commit ()
 109     {
 110         return XDB::execute('INSERT INTO  profile_medals (pid, mid, gid)
 111                                   VALUES  ({?}, {?}, {?})
 112                  ON DUPLICATE KEY UPDATE  gid = VALUES(gid)',
 113                             $this->profile->id(), $this->mid,
 114                             is_null($this->gid) ? 0 : $this->gid);
 115     }
 116
 117     // }}}
 118     // {{{ function get_request($medal)
 119
 120     static public function get_request($pid, $type, $grade)
 121     {
 122         $reqs = parent::get_typed_requests($pid, 'medal');
 123         foreach ($reqs as &$req) {
 124             if ($req->mid == $type && $req->gid == $grade) {
 125                 return $req;
 126             }
 127         }
 128         return null;
 129     }
 130
 131     // }}}
 132 }
 133
 134 // }}}
 135
 136 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 137 ?>