2 /***************************************************************************
3 * Copyright (C) 2003-2010 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, gc.countryFR AS country,
26 IF(CHAR_LENGTH(e.name) > 76, e.abbreviation, e.name) AS name
27 FROM profile_education_enum AS e
28 LEFT JOIN geoloc_countries AS gc ON (e.country = gc.iso_3166_1_a2)
29 WHERE EXISTS (SELECT *
30 FROM profile_education_degree AS d
32 ORDER BY gc.countryFR, e.name");
34 while ($arr_edu = $res->next()) {
35 if ($arr_edu["country"] != $country) {
37 $html .= '</optgroup>';
39 $country = $arr_edu["country"];
40 $html .= '<optgroup label="' . $country . '">';
42 $html .= '<option value="' . $arr_edu["id"] . '"';
43 if ($arr_edu["id"] == $current) {
44 $html .= " selected='selected'";
46 $html .= '>' . htmlspecialchars($arr_edu["name"]) . "</option>\n";
49 $html .= '</optgroup>';
54 /** pour appeller education_options depuis smarty
56 function _education_options_smarty($params)
58 if(!isset($params['selected'])) {
59 $params['selected'] = 0;
61 return education_options($params['selected']);
63 Platal
::page()->register_function('education_options', '_education_options_smarty');
65 /** affiche un Array javascript contenant les diplômes de chaque formation
67 function education_degree()
70 $res = XDB
::iterRow("SELECT eduid, degreeid
71 FROM profile_education_degree
73 $edu_degree = $res->next();
74 for ($eduid = 1; $edu_degree; ++
$eduid) {
76 if ($edu_degree['0'] == $eduid) {
77 $html .= $edu_degree['1'];
78 $edu_degree = $res->next();
79 while ($edu_degree['0'] == $eduid) {
80 $html .= ',' . $edu_degree['1'];
81 $edu_degree = $res->next();
91 Platal
::page()->register_function('education_degree', 'education_degree');
93 /** affiche tous les types possibles de diplômes
95 function education_degree_all()
97 $res = XDB
::query("SELECT id
98 FROM profile_education_degree_enum
100 return implode(',', $res->fetchColumn());
102 Platal
::page()->register_function('education_degree_all', 'education_degree_all');
104 /** affiche les noms de tous les diplômes possibles
106 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 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: