'; $res = XDB::iterator("SELECT e.id AS id, gc.countryFR AS country, IF(CHAR_LENGTH(e.name) > 76, e.abbreviation, e.name) AS name FROM profile_education_enum AS e LEFT JOIN geoloc_countries AS gc ON (e.country = gc.iso_3166_1_a2) WHERE EXISTS (SELECT * FROM profile_education_degree AS d WHERE e.id = d.eduid) ORDER BY gc.countryFR, e.name"); $country = ""; while ($arr_edu = $res->next()) { if ($arr_edu["country"] != $country) { $country = $arr_edu["country"]; $html .= ""; } $html .= '\n"; } return $html; } /** pour appeller education_options depuis smarty */ function _education_options_smarty($params) { if(!isset($params['selected'])) { $params['selected'] = 0; } return education_options($params['selected']); } Platal::page()->register_function('education_options', '_education_options_smarty'); /** affiche un Array javascript contenant les diplômes de chaque formation */ function education_degree() { $html = ''; $res = XDB::iterRow("SELECT eduid, degreeid FROM profile_education_degree ORDER BY eduid"); $edu_degree = $res->next(); for ($eduid = 1; $edu_degree; ++$eduid) { $html .= '['; if ($edu_degree['0'] == $eduid) { $html .= $edu_degree['1']; $edu_degree = $res->next(); while ($edu_degree['0'] == $eduid) { $html .= ',' . $edu_degree['1']; $edu_degree = $res->next(); } } $html .= ']'; if ($edu_degree) { $html .= ",\n"; } } return $html; } Platal::page()->register_function('education_degree', 'education_degree'); /** affiche tous les types possibles de diplômes */ function education_degree_all() { $res = XDB::query("SELECT id FROM profile_education_degree_enum ORDER BY id"); return implode(',', $res->fetchColumn()); } Platal::page()->register_function('education_degree_all', 'education_degree_all'); /** affiche les noms de tous les diplômes possibles */ function education_degree_name() { $res = XDB::query("SELECT degree FROM profile_education_degree_enum ORDER BY id"); return '"' . implode('","', $res->fetchColumn()) . '"'; } Platal::page()->register_function('education_degree_name', 'education_degree_name'); /** formatte une formation pour l'affichage */ function education_fmt($name, $url, $degree, $grad_year, $field, $program, $sexe, $long) { $field = strtolower($field); $txt = ""; if ($grad_year || $field || $program) { $txt .= ""; } } if (($degree != "Lic.") || ($long)) { if (($degree != "Ing.") && ($degree != "Dipl.")) { $txt .= $degree; } if ($name) { $txt .= ' '; } if ($url != ' ') { $txt .= "$name"; } else { $txt .= $name; } } $txt .= ""; return $txt; } function _education_fmt($params, &$smarty) { extract($params); return education_fmt($name, $url, $degree, $grad_year, $field, $program, $sexe, $long); } Platal::page()->register_function('education_fmt', '_education_fmt'); // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>