plugins/function.select_db_table.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2011 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 select_options($table, $value, $field, $pad, $where, $join, $group)
  23 {
  24     $fields = 't.id,' . $field;
  25     $order = $field;
  26     if ($group) {
  27         $fields .= ',' . $group;
  28         $order = $group . ',' . $order;
  29     } else {
  30         $fields .= ', NULL';
  31     }
  32     $sql = "SELECT $fields FROM $table AS t $join $where ORDER BY $order";
  33     $res = XDB::iterRow($sql);
  34     $sel = ' selected="selected"';
  35
  36     // An empty entry is added when $pad is true.
  37     $html = '';
  38     if ($pad) {
  39         $html .= '<option value="0"' . ($value == 0 ? $sel : '') . ">&nbsp;</option>\n";
  40     }
  41     $optgrp = null;
  42     while (list($my_id, $my_text, $my_grp) = $res->next()) {
  43         if ($my_grp != $optgrp) {
  44             if (!is_null($optgrp)) {
  45                 $html .= '</optgroup>';
  46             }
  47             $html .= '<optgroup label="' . pl_entities($my_grp, ENT_QUOTES) . '">';
  48             $optgrp = $my_grp;
  49         }
  50         $html .= sprintf("<option value=\"%s\" %s>%s</option>\n",
  51                          $my_id, $value == $my_id ? $sel : '', pl_entities($my_text));
  52     }
  53     if (!is_null($optgrp)) {
  54         $html .= '</optgroup>';
  55     }
  56     return $html;
  57 }
  58
  59 function smarty_function_select_db_table($params, $smarty) {
  60     if (empty($params['table']) || !array_key_exists('valeur', $params)) {
  61         return;
  62     }
  63     if (empty($params['champ'])) {
  64         $params['champ'] = 'text';
  65     }
  66     foreach (array('where', 'join', 'group') as $value) {
  67         if (empty($params[$value])) {
  68             $params[$value] = '';
  69         }
  70     }
  71     $pad = (!empty($params['pad']) && $params['pad']);
  72
  73     return select_options($params['table'], $params['valeur'], $params['champ'], $pad,
  74                           $params['where'], $params['join'], $params['group']);
  75 }
  76
  77 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
  78 ?>