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