modules/profile/skills.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 ProfileSettingSkill implements ProfileSetting
  23 {
  24     private $table;
  25     private $id;
  26     private $skill_field;
  27     private $text_field;
  28
  29     public function __construct($table, $id, $skill, $text)
  30     {
  31         $this->table = $table;
  32         $this->id = $id;
  33         $this->skill_field = $skill;
  34         $this->text_field = $text;
  35     }
  36
  37     public function value(ProfilePage $page, $field, $value, &$success)
  38     {
  39         if (is_null($value)) {
  40             $value = array();
  41             $res = XDB::iterRow("SELECT  s.{$this->id}, s.{$this->text_field}, i.level
  42                                    FROM  profile_{$this->table}_enum AS s
  43                              INNER JOIN  profile_{$this->table}s     AS i ON (s.{$this->id} = i.{$this->skill_field})
  44                                   WHERE  i.pid = {?}",
  45                                 $page->pid());
  46             while (list($sid, $text, $level) = $res->next()) {
  47                 $value[$sid] = array('text' => $text, 'level' => $level);
  48             }
  49         }
  50         if (!is_array($value)) {
  51             $value = array();
  52         } else {
  53             foreach ($value as $id=>&$skill) {
  54                 if (!isset($skill['text']) || empty($skill['text'])) {
  55                     $res = XDB::query("SELECT  {$this->text_field}
  56                                          FROM  profile_{$this->table}_enum
  57                                         WHERE  {$this->id} = {?}", $id);
  58                     $skill['text'] = $res->fetchOneCell();
  59                 }
  60             }
  61         }
  62         ksort($value);
  63         $success = true;
  64         return $value;
  65     }
  66
  67     public function save(ProfilePage $page, $field, $value)
  68     {
  69         XDB::execute("DELETE FROM  profile_{$this->table}s
  70                             WHERE  pid = {?}",
  71                      $page->pid());
  72         if (!count($value)) {
  73             return;
  74         }
  75         foreach ($value as $id=>&$skill) {
  76             XDB::execute("INSERT INTO  profile_{$this->table}s (pid, {$this->skill_field}, level)
  77                                VALUES  ({?}, {?}, {?})",
  78                          $page->pid(), $id, $skill['level']);
  79         }
  80     }
  81
  82     public function getText($value) {
  83         $skills = array();
  84
  85         if ($this->table == 'langskill') {
  86             static $levels = array(
  87                 1 => 'connaissance basique',
  88                 2 => 'maîtrise des bases',
  89                 3 => 'maîtrise limitée',
  90                 4 => 'maîtrise générale',
  91                 5 => 'bonne maîtrise',
  92                 6 => 'maîtrise complète'
  93             );
  94             foreach ($value as $skill) {
  95                 $skills[] = $skill['text'] . ' (' . $levels[$skill['level']] . ')';
  96             }
  97         } else {
  98             foreach ($value as $skill) {
  99                 $skills[] = $skill['text'] . ' (' . $skill['level'] . ')';
 100             }
 101         }
 102
 103         return implode(', ' , $skills);
 104     }
 105 }
 106
 107 class ProfilePageSkills extends ProfilePage
 108 {
 109     protected $pg_template = 'profile/skill.tpl';
 110
 111     public function __construct(PlWizard $wiz)
 112     {
 113         parent::__construct($wiz);
 114         $this->settings['competences'] = new ProfileSettingSkill('skill', 'id', 'cid', 'text_fr');
 115         $this->settings['langues'] = new ProfileSettingSkill('langskill', 'iso_639_2b', 'lid', 'language');
 116     }
 117
 118     public function _prepare(PlPage $page, $id)
 119     {
 120         $page->assign('comp_list', XDB::iterator("SELECT  id, text_fr, FIND_IN_SET('titre',flags) AS title
 121                                                     FROM  profile_skill_enum"));
 122         $page->assign('comp_level', array('initié' => 'initié',
 123                                           'bonne connaissance' => 'bonne connaissance',
 124                                           'expert' => 'expert'));
 125         $page->assign('lang_list', XDB::iterator('SELECT  iso_639_2b, language
 126                                                     FROM  profile_langskill_enum
 127                                                 ORDER BY  language'));
 128         $page->assign('lang_level', array(1 => 'connaissance basique',
 129                                           2 => 'maîtrise des bases',
 130                                           3 => 'maîtrise limitée',
 131                                           4 => 'maîtrise générale',
 132                                           5 => 'bonne maîtrise',
 133                                           6 => 'maîtrise complète'));
 134     }
 135 }
 136
 137 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 138 ?>