Merge commit 'origin/master' into fusionax
[platal.git] / plugins / function.select_nat.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
23 function select_nat($valeur, $pad=false) {
24 $sql = "SELECT a2 AS id, IF(nat='', pays, nat) AS text FROM geoloc_pays WHERE nat IS NOT NULL ORDER BY text";
25 $res = XDB::iterRow($sql);
26 $sel = ' selected="selected"';
27
28 // on ajoute une entree vide si $pad est vrai
29 $html = "";
30 if ($pad) {
31 $html .= sprintf("<option value=\"\"%s></option>\n", ($valeur ? $sel : ""));
32 }
33 while (list($my_id, $my_text) = $res->next()) {
34 $html .= sprintf("<option value=\"%s\"%s>%s</option>\n", $my_id, ($valeur==$my_id ? $sel : ""), $my_text);
35 }
36
37 return $html;
38 }
39
40 function smarty_function_select_nat($params, &$smarty) {
41 if (empty($params['pad']) || !($params['pad'])) {
42 $pad = false;
43 } else {
44 $pad = true;
45 }
46
47 return select_nat($params['valeur'], $pad);
48 }
49
50 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
51 ?>