include/validations/medals.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2009 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 Validate
  25 {
  26     // {{{ properties
  27
  28     public $mid;
  29     public $gid;
  30
  31     // }}}
  32     // {{{ constructor
  33
  34     public function __construct(User &$_user, $_idmedal, $_subidmedal, $_stamp=0)
  35     {
  36         parent::__construct($_user, 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         //var_dump($this);
  78         $r = XDB::query("
  79             SELECT IF (g.text IS NOT NULL, CONCAT(m.text,' - ', g.text), m.text)
  80               FROM profile_medals AS m
  81          LEFT JOIN profile_medals_grades AS g ON(g.mid = m.id AND g.gid = {?})
  82              WHERE m.id = {?}", $this->gid, $this->mid);
  83         return $r->fetchOneCell();
  84     }
  85
  86     // }}}
  87     // {{{ function submit()
  88
  89     public function submit()
  90     {
  91         $res = XDB::query("SELECT  FIND_IN_SET('validation', flags)
  92                              FROM  profile_medals
  93                             WHERE  id = {?}", $this->mid);
  94         if ($res->fetchOneCell()) {
  95             parent::submit();
  96         } else {
  97             $this->commit();
  98         }
  99     }
 100
 101     // }}}
 102     // {{{ function commit()
 103
 104     public function commit ()
 105     {
 106         require_once 'notifs.inc.php';
 107         register_watch_op($this->user->id(), WATCH_FICHE, '', 'medals');
 108         return XDB::execute('REPLACE INTO  profile_medals_sub
 109                                    VALUES  ({?}, {?}, {?})',
 110                             $this->user->id(), $this->mid,
 111                             is_null($this->gid) ? 0 : $this->gid);
 112     }
 113
 114     // }}}
 115     // {{{ function get_request($medal)
 116
 117     static public function get_request($uid, $type)
 118     {
 119         $reqs = Validate::get_typed_requests($uid, 'medal');
 120         foreach ($reqs as &$req) {
 121             if ($req->mid == $type) {
 122                 return $req;
 123             }
 124         }
 125         return null;
 126     }
 127
 128     // }}}
 129 }
 130
 131 // }}}
 132
 133 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 134 ?>