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 education_options($current = 0)
24 $html = '<option value="-1"></option>';
25 $res = XDB
::iterator("SELECT e.id AS id, e.name AS name, g.pays AS country
26 FROM profile_education_enum AS e
27 INNER JOIN geoloc_pays AS g ON (e.country = g.a2)
28 ORDER BY g.pays, e.name");
30 while ($arr_edu = $res->next()) {
31 if ($arr_edu["country"] != $country) {
32 $country = $arr_edu["country"];
33 $html .= "<optgroup label=" . $country . ">";
35 $html .= '<option value="' . $arr_edu["id"] . '"';
36 if ($arr_edu["id"] == $current) {
37 $html .= " selected='selected'";
39 $html .= '>' . htmlspecialchars($arr_edu["name"]) . "</option>\n";
44 /** pour appeller education_options depuis smarty
46 function _education_options_smarty($params)
48 if(!isset($params['selected'])) {
49 $params['selected'] = 0;
51 return education_options($params['selected']);
53 Platal
::page()->register_function('education_options', '_education_options_smarty');
55 /** affiche un Array javascript contenant les diplômes de chaque formation
57 function education_degree()
60 $res = XDB
::iterRow("SELECT eduid, degreeid
61 FROM profile_education_degree AS d
62 INNER JOIN profile_education_enum AS e ON (e.id = d.eduid)
63 INNER JOIN geoloc_pays AS g ON (e.country = g.a2)
64 ORDER BY g.pays, e.name");
65 if ($edu_degree = $res->next()) {
66 $eduid = $edu_degree['0'];
68 $html .= $edu_degree['1'];
69 $edu_degree = $res->next();
70 while ($edu_degree['0'] == $eduid) {
71 $html .= "," . $edu_degree['1'];
72 $edu_degree = $res->next();
77 $eduid = $edu_degree['0'];
79 $html .= $edu_degree['1'];
80 $edu_degree = $res->next();
81 while ($edu_degree['0'] == $eduid) {
82 $html .= "," . $edu_degree['1'];
83 $edu_degree = $res->next();
89 Platal
::page()->register_function('education_degree', 'education_degree');
91 /** affiche tous les types possibles de diplômes
93 function education_degree_all()
96 $res = XDB
::query("SELECT id
97 FROM profile_education_degree_enum
99 return implode(',', $res->fetchColumn());
101 Platal
::page()->register_function('education_degree_all', 'education_degree_all');
103 /** affiche les noms de tous les diplômes possibles
105 function education_degree_name()
108 $res = XDB
::query("SELECT degree
109 FROM profile_education_degree_enum
111 return '\'' . implode('\',\'', $res->fetchColumn()) . '\'';
113 Platal
::page()->register_function('education_degree_name', 'education_degree_name');
115 /** formatte une formation pour l'affichage
117 function education_fmt($name, $url, $degree, $grad_year, $field, $program, $sexe, $long)
119 $field = strtolower($field);
122 if ($grad_year ||
$field ||
$program) {
123 $txt .= "<span title=\"(";
126 if ($grad_year ||
$field) {
132 $txt .= "diplômée en $grad_year";
134 $txt .= "diplômé en $grad_year";
141 $txt .= "domaine : $field)\">";
145 if (($degree != "Licence") ||
($long)) {
146 if (($degree != "Ingénieur") && ($degree != "Diplôme")) {
149 if ($name != "Université") {
154 $txt .= "<a href=\"$url\" onclick=\"return popup(this)\">$name</a>";
165 function _education_fmt($params, &$smarty)
168 return education_fmt($name, $url, $degree, $grad_year, $field, $program, $sexe, $long);
170 Platal
::page()->register_function('education_fmt', '_education_fmt');
172 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: