include/education.func.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2008 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   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.                                    *
  10  *                                                                         *
  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.                           *
  15  *                                                                         *
  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            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 function education_options($current=0)
  23 {
  24     $html = '<option value = "-1"></option>';
  25     $res  = XDB::iterator("SELECT  *
  26                              FROM  profile_education_enum
  27                          ORDER BY  name");
  28     while ($arr_edu = $res->next()) {
  29         $html .= '<option value="' . $arr_edu["id"] . '"';
  30         if ($arr_edu["id"]==$current) {
  31             $html .= " selected='selected'";
  32         }
  33         $html .= '>' . htmlspecialchars($arr_edu["name"]) . "</option>\n";
  34     }
  35     return $html;
  36 }
  37
  38 /** pour appeller education_options depuis smarty
  39  */
  40 function _education_options_smarty($params)
  41 {
  42     if(!isset($params['selected'])) {
  43         $params['selected'] = 0;
  44     }
  45     return education_options($params['selected']);
  46 }
  47 Platal::page()->register_function('education_options', '_education_options_smarty');
  48
  49 /** affiche un Array javascript contenant les diplômes de chaque formation
  50  */
  51 function education_degree()
  52 {
  53     $html = "";
  54     $res = XDB::iterRow("SELECT  eduid, degreeid
  55                            FROM  profile_education_degree AS d
  56                      INNER JOIN  profile_education_enum   AS e ON (e.id = d.eduid)
  57                        ORDER BY  e.name");
  58     if ($edu_degree = $res->next()) {
  59         $eduid = $edu_degree['0'];
  60         $html .= "[";
  61         $html .= $edu_degree['1'];
  62         $edu_degree = $res->next();
  63         while ($edu_degree['0'] == $eduid) {
  64             $html .= "," . $edu_degree['1'];
  65             $edu_degree = $res->next();
  66         }
  67         $html .= "]";
  68     }
  69     while ($edu_degree) {
  70         $eduid = $edu_degree['0'];
  71         $html .= ",\n[";
  72         $html .= $edu_degree['1'];
  73         $edu_degree = $res->next();
  74         while ($edu_degree['0'] == $eduid) {
  75             $html .= "," . $edu_degree['1'];
  76             $edu_degree = $res->next();
  77         }
  78         $html .= "]";
  79     }
  80     return $html;
  81 }
  82 Platal::page()->register_function('education_degree', 'education_degree');
  83
  84 /** affiche tous les types possibles de diplômes
  85  */
  86 function education_degree_all()
  87 {
  88     $html = "";
  89     $res = XDB::query("SELECT  id
  90                          FROM  profile_education_degree_enum
  91                      ORDER BY  id");
  92     return implode(',', $res->fetchColumn());
  93 }
  94 Platal::page()->register_function('education_degree_all', 'education_degree_all');
  95
  96 /** affiche les noms de tous les diplômes possibles
  97  */
  98 function education_degree_name()
  99 {
 100     $html = "";
 101     $res = XDB::query("SELECT  degree
 102                            FROM  profile_education_degree_enum
 103                        ORDER BY  id");
 104     return '\'' . implode('\',\'', $res->fetchColumn()) . '\'';
 105 }
 106 Platal::page()->register_function('education_degree_name', 'education_degree_name');
 107
 108 /** formatte une formation pour l'affichage
 109  */
 110 function education_fmt($name, $url, $degree, $grad_year, $field, $program, $sexe, $long)
 111 {
 112     $field = strtolower($field);
 113     $txt = "";
 114
 115     if ($grad_year || $field || $program) {
 116         $txt .= "<span  title=\"(";
 117         if ($program) {
 118             $txt .= $program;
 119             if ($grad_year || $field) {
 120                 $txt .= ", ";
 121             }
 122         }
 123         if ($grad_year) {
 124             if ($sexe) {
 125                 $txt .= "diplômée en $grad_year";
 126             } else {
 127                 $txt .= "diplômé en $grad_year";
 128             }
 129             if ($field) {
 130                 $txt .= ", ";
 131             }
 132         }
 133         if ($field) {
 134             $txt .= "domaine : $field)\">";
 135         }
 136     }
 137
 138     if (($degree != "Licence") || ($long)) {
 139         if (($degree != "Ingénieur") && ($degree != "Diplôme")) {
 140             $txt .= $degree;
 141         }
 142         if ($name != "Université") {
 143             if ($name) {
 144                 $txt .= ' ';
 145             }
 146             if ($url != ' ') {
 147                 $txt .= "<a href=\"$url\" onclick=\"return popup(this)\">$name</a>";
 148             } else {
 149                 $txt .= $name;
 150             }
 151         }
 152     }
 153     $txt .= "</span>";
 154
 155     return $txt;
 156 }
 157
 158 function _education_fmt($params, &$smarty)
 159 {
 160     extract($params);
 161     return education_fmt($name, $url, $degree, $grad_year, $field, $program, $sexe, $long);
 162 }
 163 Platal::page()->register_function('education_fmt', '_education_fmt');
 164
 165 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 166 ?>