include/education.func.inc.php

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