2 /***************************************************************************
3 * Copyright (C) 2003-2007 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 ***************************************************************************/
23 if(Env
::has('langue_op')){
24 if(Env
::v('langue_op', '')=='retirer'){
25 XDB
::execute("DELETE FROM langues_ins WHERE uid = {?} AND lid = {?}", S
::v('uid', -1), Env
::v('langue_id', ''));
26 } elseif(Env
::v('langue_op', '') == 'ajouter'){
27 if(Env
::v('langue_id', '') != '')
28 XDB
::execute("INSERT INTO langues_ins (uid,lid,level) VALUES ({?}, {?}, {?})", S
::v('uid', -1), Env
::v('langue_id', ''), Env
::v('langue_level', ''));
32 if(Env
::has('comppros_op')){
33 if(Env
::v('comppros_op', '')=='retirer'){
34 XDB
::execute("DELETE FROM competences_ins WHERE uid = {?} AND cid = {?}", S
::v('uid', -1), Env
::v('comppros_id', ''));
35 } elseif(Env
::v('comppros_op', '') == 'ajouter') {
36 if(Env
::v('comppros_id', '') != '')
37 XDB
::execute("INSERT INTO competences_ins (uid,cid,level) VALUES({?}, {?}, {?})", S
::v('uid', -1), Env
::v('comppros_id', ''), Env
::v('comppros_level', ''));
41 // nombre maximum autorisé de langues
43 // nombre maximum autorisé de compétences professionnelles
46 $res = XDB
::iterRow("SELECT ld.id, ld.langue_fr, li.level FROM langues_ins AS li, langues_def AS ld "
47 ."WHERE (li.lid=ld.id AND li.uid= {?}) LIMIT $nb_lg_max", S
::v('uid', -1));
49 $nb_lg = $res->total();
51 for ($i = 1; $i <= $nb_lg; $i++
) {
52 list($langue_id[$i], $langue_name[$i], $langue_level[$i]) = $res->next();
55 $res = XDB
::iterRow("SELECT cd.id, cd.text_fr, ci.level FROM competences_ins AS ci, competences_def AS cd "
56 ."WHERE (ci.cid=cd.id AND ci.uid={?}) LIMIT $nb_cpro_max", S
::v('uid', -1));
58 $nb_cpro = $res->total();
60 for ($i = 1; $i <= $nb_cpro; $i++
) {
61 list($cpro_id[$i], $cpro_name[$i], $cpro_level[$i]) = $res->next();
63 //Definitions des tables de correspondances id => nom
65 $langues_levels = Array(
74 $res = XDB
::iterRow("SELECT id, langue_fr FROM langues_def");
76 while(list($tmp_lid, $tmp_lg_fr) = $res->next()){
77 $langues_def[$tmp_lid] = $tmp_lg_fr;
80 $comppros_levels = Array(
82 'bonne connaissance' => 'bonne connaissance',
86 $res = XDB
::iterRow("SELECT id, text_fr, FIND_IN_SET('titre',flags) FROM competences_def");
88 while(list($tmp_id, $tmp_text_fr, $tmp_title) = $res->next()){
89 $comppros_def[$tmp_id] = $tmp_text_fr;
90 $comppros_title[$tmp_id] = $tmp_title;
93 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: