include/education.func.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2010 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">&nbsp;</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
  31                                      WHERE  e.id = d.eduid)
  32                          ORDER BY  gc.countryFR, e.name");
  33     $country = "";
  34     while ($arr_edu = $res->next()) {
  35         if ($arr_edu["country"] != $country) {
  36             if ($country) {
  37                 $html .= '</optgroup>';
  38             }
  39             $country = $arr_edu["country"];
  40             $html .= '<optgroup label="' . $country . '">';
  41         }
  42         $html .= '<option value="' . $arr_edu["id"] . '"';
  43         if ($arr_edu["id"] == $current) {
  44             $html .= " selected='selected'";
  45         }
  46         $html .= '>' . htmlspecialchars($arr_edu["name"]) . "</option>\n";
  47     }
  48     if ($country) {
  49         $html .= '</optgroup>';
  50     }
  51     return $html;
  52 }
  53
  54 /** pour appeller education_options depuis smarty
  55  */
  56 function _education_options_smarty($params)
  57 {
  58     if(!isset($params['selected'])) {
  59         $params['selected'] = 0;
  60     }
  61     return education_options($params['selected']);
  62 }
  63 Platal::page()->register_function('education_options', '_education_options_smarty');
  64
  65 /** affiche un Array javascript contenant les diplômes de chaque formation
  66  */
  67 function education_degree()
  68 {
  69     $html  = '';
  70     $res = XDB::iterRow("SELECT  eduid, degreeid
  71                            FROM  profile_education_degree
  72                        ORDER BY  eduid");
  73     $edu_degree = $res->next();
  74     for ($eduid = 1; $edu_degree; ++$eduid) {
  75         $html .= '[';
  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();
  82             }
  83         }
  84         $html .= ']';
  85         if ($edu_degree) {
  86             $html .= ",\n";
  87         }
  88     }
  89     return $html;
  90 }
  91 Platal::page()->register_function('education_degree', 'education_degree');
  92
  93 /** affiche tous les types possibles de diplômes
  94  */
  95 function education_degree_all()
  96 {
  97     $res = XDB::query("SELECT  id
  98                          FROM  profile_education_degree_enum
  99                      ORDER BY  id");
 100     return implode(',', $res->fetchColumn());
 101 }
 102 Platal::page()->register_function('education_degree_all', 'education_degree_all');
 103
 104 /** affiche les noms de tous les diplômes possibles
 105  */
 106 function education_degree_name()
 107 {
 108     $res = XDB::query("SELECT  degree
 109                          FROM  profile_education_degree_enum
 110                      ORDER BY  id");
 111     return '"' . implode('","', $res->fetchColumn()) . '"';
 112 }
 113 Platal::page()->register_function('education_degree_name', 'education_degree_name');
 114
 115 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 116 ?>