279a105ccef4fee6482363f680ca4c2e0607ef93
2 /***************************************************************************
3 * Copyright (C) 2003-2011 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
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. *
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. *
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 *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 class ProfileSettingSkill
implements ProfileSetting
29 public function __construct($table, $id, $skill, $text)
31 $this->table
= $table;
33 $this->skill_field
= $skill;
34 $this->text_field
= $text;
37 public function value(ProfilePage
$page, $field, $value, &$success)
39 if (is_null($value)) {
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})
46 while (list($sid, $text, $level) = $res->next()) {
47 $value[$sid] = array('text' => $text, 'level' => $level);
50 if (!is_array($value)) {
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();
67 public function save(ProfilePage
$page, $field, $value)
69 XDB
::execute("DELETE FROM profile_{$this->table}s
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']);
82 public function getText($value) {
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'
94 foreach ($value as $skill) {
95 $skills[] = $skill['text'] . ' (' . $levels[$skill['level']] . ')';
98 foreach ($value as $skill) {
99 $skills[] = $skill['text'] . ' (' . $skill['level'] . ')';
103 return implode(', ' , $skills);
107 /** Terms associated to profile mentoring */
108 class ProfileSettingTerms
implements ProfileSetting
110 public function value(ProfilePage
$page, $field, $value, &$success)
113 if (is_null($value)) {
115 $res = XDB
::query('SELECT e.jtid, e.full_name
116 FROM profile_mentor_term AS m
117 INNER JOIN profile_job_term_enum AS e ON (m.jtid = e.jtid)
120 $value = $res->fetchAllAssoc();
121 } elseif (!is_array($value)) {
123 } elseif (count($value) > 20) {
124 Platal
::page()->trigError("Le nombre de mots clefs d'expertise est limité à 20.");
127 $missing_full_names = array();
128 foreach ($value as &$term) if (empty($term['full_name'])) {
129 $missing_full_names[] = $term['jtid'];
131 if (count($missing_full_names)) {
132 $res = XDB
::query('SELECT jtid, full_name
133 FROM profile_job_term_enum
135 $missing_full_names);
136 $term_id_to_name = $res->fetchAllAssoc('jtid', false
);
137 foreach ($value as &$term) {
138 if (empty($term['full_name'])) {
139 $term['full_name'] = $term_id_to_name[$term['jtid']];
145 foreach ($value as &$sss) {
151 public function save(ProfilePage
$page, $field, $value)
154 XDB
::execute("DELETE FROM profile_mentor_term
157 if (!count($value)) {
160 $mentor_term_values = array();
161 foreach ($value as &$term) {
162 $mentor_term_values[] = '('.XDB
::escape($page->pid()).', '.XDB
::escape($term['jtid']).')';
164 XDB
::execute('INSERT INTO profile_mentor_term (pid, jtid)
165 VALUES '.implode(',', $mentor_term_values));
169 public function getText($value) {
171 foreach ($value as &$term) {
172 $terms[] = $term['full_name'];
174 return implode(', ', $terms);
178 class ProfileSettingCountry
implements ProfileSetting
180 public function value(ProfilePage
$page, $field, $value, &$success)
183 if (is_null($value)) {
185 $res = XDB
::iterRow("SELECT m.country, gc.country
186 FROM profile_mentor_country AS m
187 INNER JOIN geoloc_countries AS gc ON (m.country = gc.iso_3166_1_a2)
190 while (list($id, $name) = $res->next()) {
193 } else if (!is_array($value)) {
195 } else if (count($value) > 10) {
196 Platal
::page()->trigError("Le nombre de secteurs d'expertise est limité à 10");
203 public function save(ProfilePage
$page, $field, $value)
205 XDB
::execute("DELETE FROM profile_mentor_country
208 foreach ($value as $id=>&$name) {
209 XDB
::execute("INSERT INTO profile_mentor_country (pid, country)
215 public function getText($value) {
216 return implode(', ', $value);
221 class ProfilePageMentor
extends ProfilePage
223 protected $pg_template = 'profile/mentor.tpl';
225 public function __construct(PlWizard
$wiz)
227 parent
::__construct($wiz);
228 $this->settings
['expertise'] = null
;
229 $this->settings
['terms'] = new ProfileSettingTerms();
230 $this->settings
['countries'] = new ProfileSettingCountry();
231 $this->settings
['competences'] = new ProfileSettingSkill('skill', 'id', 'cid', 'text_fr');
232 $this->settings
['langues'] = new ProfileSettingSkill('langskill', 'iso_639_2b', 'lid', 'language');
235 protected function _fetchData()
237 $res = XDB
::query("SELECT expertise
241 $this->values
['expertise'] = $res->fetchOneCell();
244 protected function _saveData()
246 if ($this->changed
['expertise']) {
247 $expertise = trim($this->values
['expertise']);
248 if (empty($expertise)) {
249 XDB
::execute("DELETE FROM profile_mentor
252 $this->values
['expertise'] = null
;
254 XDB
::execute('INSERT INTO profile_mentor (pid, expertise)
256 ON DUPLICATE KEY UPDATE expertise = VALUES(expertise)',
257 $this->pid(), $expertise);
258 $this->values
['expertise'] = $expertise;
263 public function _prepare(PlPage
$page, $id)
265 $page->assign('countryList', XDB
::iterator("SELECT iso_3166_1_a2, country
266 FROM geoloc_countries
268 $page->assign('hrpid', $this->profile
->hrpid
);
269 $page->assign('comp_list', XDB
::iterator("SELECT id, text_fr, FIND_IN_SET('titre',flags) AS title
270 FROM profile_skill_enum"));
271 $page->assign('comp_level', array('initié' => 'initié',
272 'bonne connaissance' => 'bonne connaissance',
273 'expert' => 'expert'));
274 $page->assign('lang_list', XDB
::iterator('SELECT iso_639_2b, language
275 FROM profile_langskill_enum
276 ORDER BY language'));
277 $page->assign('lang_level', array(1 => 'connaissance basique',
278 2 => 'maîtrise des bases',
279 3 => 'maîtrise limitée',
280 4 => 'maîtrise générale',
281 5 => 'bonne maîtrise',
282 6 => 'maîtrise complète'));
286 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: