2 /***************************************************************************
3 * Copyright (C) 2003-2008 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 function applis_options($current=0)
24 $html = '<option value = "-1"></option>';
25 $res = XDB
::iterator("SELECT *
26 FROM profile_education_enum
28 while ($arr_appli = $res->next()) {
29 $html .= '<option value="' . $arr_appli["id"] . '"';
30 if ($arr_appli["id"]==$current) {
31 $html .= " selected='selected'";
33 $html .= '>' . htmlspecialchars($arr_appli["name"]) . "</option>\n";
38 /** pour appeller applis_options depuis smarty
40 function _applis_options_smarty($params)
42 if(!isset($params['selected'])) {
43 $params['selected'] = 0;
45 return applis_options($params['selected']);
47 Platal
::page()->register_function('applis_options', '_applis_options_smarty');
49 /** affiche un Array javascript contenant les types de chaque appli
51 function applis_type()
54 $res = XDB
::iterRow("SELECT eduid, degreeid
55 FROM profile_education_degree AS d
56 INNER JOIN profile_education_enum AS e ON (e.id = d.eduid)
58 if ($appli_type = $res->next()) {
59 $eduid = $appli_type['0'];
61 $html .= $appli_type['1'];
62 $appli_type = $res->next();
63 while ($appli_type['0'] == $eduid) {
64 $html .= "," . $appli_type['1'];
65 $appli_type = $res->next();
70 $eduid = $appli_type['0'];
72 $html .= $appli_type['1'];
73 $appli_type = $res->next();
74 while ($appli_type['0'] == $eduid) {
75 $html .= "," . $appli_type['1'];
76 $appli_type = $res->next();
82 Platal
::page()->register_function('applis_type', 'applis_type');
84 /** affiche tous les types possibles d'applis
86 function applis_type_all()
89 $res = XDB
::query("SELECT id
90 FROM profile_education_degree_enum
92 return implode(',', $res->fetchColumn());
94 Platal
::page()->register_function('applis_type_all', 'applis_type_all');
96 /** affiche les noms de tous les types possibles d'applis
98 function applis_type_name()
101 $res = XDB
::query("SELECT degree
102 FROM profile_education_degree_enum
104 return '\'' . implode('\',\'', $res->fetchColumn()) . '\'';
106 Platal
::page()->register_function('applis_type_name', 'applis_type_name');
108 /** formatte une ecole d'appli pour l'affichage
110 function applis_fmt($name, $url, $degree, $grad_year, $field, $sexe, $long)
112 $field = strtolower($field);
115 if ($grad_year ||
$field) {
116 $txt .= "<span title=\"(";
119 $txt .= "diplômée en $grad_year";
121 $txt .= "diplômé en $grad_year";
128 $txt .= "domaine : $field)\">";
132 if (($degree != "Licence") ||
($long)) {
133 if (($degree != "Ingénieur") && ($degree != "Diplôme")) {
136 if ($name != "Université") {
141 $txt .= "<a href=\"$url\" onclick=\"return popup(this)\">$name</a>";
152 function _applis_fmt($params, &$smarty)
155 return applis_fmt($name, $url, $degree, $grad_year, $field, $sexe, $long);
157 Platal
::page()->register_function('applis_fmt', '_applis_fmt');
159 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: