<?php
/***************************************************************************
- * Copyright (C) 2003-2006 Polytechnique.org *
+ * Copyright (C) 2003-2008 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
***************************************************************************/
-global $page;
-
-function applis_options($current=0) {
- $html = '<option value="-1"></option>';
- $res = XDB::iterator("select * from applis_def order by text");
- while ($arr_appli = $res->next()) {
- $html .= '<option value="'.$arr_appli["id"].'"';
- if ($arr_appli["id"]==$current) $html .= " selected='selected'";
- $html .= '>'.htmlspecialchars($arr_appli["text"])."</option>\n";
+function applis_options($current=0)
+{
+ $html = '<option value = "-1"></option>';
+ $res = XDB::iterator("SELECT *
+ FROM profile_education_enum
+ ORDER BY name");
+ while ($arr_appli = $res->next()) {
+ $html .= '<option value="' . $arr_appli["id"] . '"';
+ if ($arr_appli["id"]==$current) {
+ $html .= " selected='selected'";
+ }
+ $html .= '>' . htmlspecialchars($arr_appli["name"]) . "</option>\n";
}
return $html;
}
+
/** pour appeller applis_options depuis smarty
*/
-function _applis_options_smarty($params){
- if(!isset($params['selected']))
- $params['selected'] = 0;
+function _applis_options_smarty($params)
+{
+ if(!isset($params['selected'])) {
+ $params['selected'] = 0;
+ }
return applis_options($params['selected']);
}
-$page->register_function('applis_options','_applis_options_smarty');
-
+Platal::page()->register_function('applis_options', '_applis_options_smarty');
/** affiche un Array javascript contenant les types de chaque appli
*/
-function applis_type(){
+function applis_type()
+{
$html = "";
- $res=XDB::iterRow("select type from applis_def order by text");
- if (list($appli_type) = $res->next()) {
- $html .= "new Array('".str_replace(",","','",$appli_type)."')";
+ $res = XDB::iterRow("SELECT eduid, degreeid
+ FROM profile_education_degree AS d
+ INNER JOIN profile_education_enum AS e ON (e.id = d.eduid)
+ ORDER BY e.name");
+ if ($appli_type = $res->next()) {
+ $eduid = $appli_type['0'];
+ $html .= "[";
+ $html .= $appli_type['1'];
+ $appli_type = $res->next();
+ while ($appli_type['0'] == $eduid) {
+ $html .= "," . $appli_type['1'];
+ $appli_type = $res->next();
+ }
+ $html .= "]";
}
- while (list($appli_type) = $res->next()) {
- $html .= ",\nnew Array('".str_replace(",","','",$appli_type)."')";
+ while ($appli_type) {
+ $eduid = $appli_type['0'];
+ $html .= ",\n[";
+ $html .= $appli_type['1'];
+ $appli_type = $res->next();
+ while ($appli_type['0'] == $eduid) {
+ $html .= "," . $appli_type['1'];
+ $appli_type = $res->next();
+ }
+ $html .= "]";
}
return $html;
}
-$page->register_function('applis_type','applis_type');
+Platal::page()->register_function('applis_type', 'applis_type');
/** affiche tous les types possibles d'applis
*/
-function applis_type_all(){
- $res = XDB::query("show columns from applis_def like 'type'");
- $arr_appli = $res->fetchOneAssoc();
- return str_replace(")","",str_replace("set(","",$arr_appli["Type"]));
+function applis_type_all()
+{
+ $html = "";
+ $res = XDB::query("SELECT id
+ FROM profile_education_degree_enum
+ ORDER BY id");
+ return implode(',', $res->fetchColumn());
+}
+Platal::page()->register_function('applis_type_all', 'applis_type_all');
+
+/** affiche les noms de tous les types possibles d'applis
+ */
+function applis_type_name()
+{
+ $html = "";
+ $res = XDB::query("SELECT degree
+ FROM profile_education_degree_enum
+ ORDER BY id");
+ return '\'' . implode('\',\'', $res->fetchColumn()) . '\'';
}
-$page->register_function('applis_type_all','applis_type_all');
+Platal::page()->register_function('applis_type_name', 'applis_type_name');
/** formatte une ecole d'appli pour l'affichage
*/
-function applis_fmt($type, $text, $url) {
- $txt="";
- if (($type!="Ingénieur")&&($type!="Diplôme"))
- $txt .= $type;
- if ($text!="Université") {
- if ($txt) $txt .= " ";
- if ($url)
- $txt .= "<a href=\"$url\" onclick=\"return popup(this)\">$text</a>";
- else
- $txt .= $text;
+function applis_fmt($name, $url, $degree, $grad_year, $field, $sexe, $long)
+{
+ $field = strtolower($field);
+ $txt = "";
+
+ if ($grad_year || $field) {
+ $txt .= "<span title=\"(";
+ if ($grad_year) {
+ if ($sexe) {
+ $txt .= "diplômée en $grad_year";
+ } else {
+ $txt .= "diplômé en $grad_year";
+ }
+ if ($field) {
+ $txt .= ", ";
+ }
+ }
+ if ($field) {
+ $txt .= "domaine : $field)\">";
+ }
}
+
+ if (($degree != "Licence") || ($long)) {
+ if (($degree != "Ingénieur") && ($degree != "Diplôme")) {
+ $txt .= $degree;
+ }
+ if ($name != "Université") {
+ if ($name) {
+ $txt .= ' ';
+ }
+ if ($url != ' ') {
+ $txt .= "<a href=\"$url\" onclick=\"return popup(this)\">$name</a>";
+ } else {
+ $txt .= $name;
+ }
+ }
+ }
+ $txt .= "</span>";
+
return $txt;
}
-function _applis_fmt($params, &$smarty) {
+
+function _applis_fmt($params, &$smarty)
+{
extract($params);
- return applis_fmt($type, $text, $url);
+ return applis_fmt($name, $url, $degree, $grad_year, $field, $sexe, $long);
}
-$page->register_function('applis_fmt','_applis_fmt');
+Platal::page()->register_function('applis_fmt', '_applis_fmt');
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>