'; $res = XDB::iterator("SELECT e.id AS id, g.pays AS country, IF(CHAR_LENGTH(e.name) > 76, e.abbreviation, e.name) AS name FROM profile_education_enum AS e LEFT JOIN geoloc_pays AS g ON (e.country = g.a2) WHERE EXISTS (SELECT * FROM profile_education_degree AS d WHERE e.id = d.eduid) ORDER BY g.pays, 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 d.eduid, d.degreeid FROM profile_education_enum AS e INNER JOIN profile_education_degree AS d ON (e.id = d.eduid) LEFT JOIN geoloc_pays AS g ON (e.country = g.a2) ORDER BY g.pays, e.name"); if ($edu_degree = $res->next()) { $eduid = $edu_degree['0']; $html .= "["; $html .= $edu_degree['1']; $edu_degree = $res->next(); while ($edu_degree['0'] == $eduid) { $html .= "," . $edu_degree['1']; $edu_degree = $res->next(); } $html .= "]"; } while ($edu_degree) { $eduid = $edu_degree['0']; $html .= ",\n["; $html .= $edu_degree['1']; $edu_degree = $res->next(); while ($edu_degree['0'] == $eduid) { $html .= "," . $edu_degree['1']; $edu_degree = $res->next(); } $html .= "]"; } 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: ?>