Line 17... |
Line 17... |
17 |
// | |
|
17 |
// | |
|
18 |
// | You should have received a copy of the GNU Lesser General Public |
|
18 |
// | You should have received a copy of the GNU Lesser General Public |
|
19 |
// | License along with this library; if not, write to the Free Software |
|
19 |
// | License along with this library; if not, write to the Free Software |
|
20 |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|
20 |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|
21 |
// +------------------------------------------------------------------------------------------------------+
|
21 |
// +------------------------------------------------------------------------------------------------------+
|
22 |
// CVS : $Id: liste.php,v 1.3 2008-11-19 09:28:46 aperonnet Exp $
|
22 |
// CVS : $Id: liste.php,v 1.2 2008-09-17 14:18:12 alexandre_tb Exp $
|
23 |
/**
|
23 |
/**
|
24 |
*
|
24 |
*
|
25 |
*@package bazar
|
25 |
*@package bazar
|
26 |
//Auteur original :
|
26 |
//Auteur original :
|
27 |
*@author Alexandre GRANIER <alexandre@tela-botanica.org>
|
27 |
*@author Alexandre GRANIER <alexandre@tela-botanica.org>
|
28 |
//Autres auteurs :
|
28 |
//Autres auteurs :
|
29 |
*@copyright Tela-Botanica 2000-2008
|
29 |
*@copyright Tela-Botanica 2000-2008
|
30 |
*@version $Revision: 1.3 $
|
30 |
*@version $Revision: 1.2 $
|
31 |
// +------------------------------------------------------------------------------------------------------+
|
31 |
// +------------------------------------------------------------------------------------------------------+
|
32 |
*/
|
32 |
*/
|
Line 33... |
Line -... |
33 |
|
- |
|
34 |
// TODO : Semble inutilise cf ; formulaire.fonct.inc
|
- |
|
35 |
|
- |
|
36 |
|
33 |
|
Line 37... |
Line 34... |
37 |
include_once PAP_CHEMIN_API_PEAR.'PEAR.php';
|
34 |
include_once PAP_CHEMIN_API_PEAR.'PEAR.php';
|
Line 44... |
Line 41... |
44 |
function Bazar_liste($options) {
|
41 |
function Bazar_liste($options) {
|
45 |
$this->options = $options;
|
42 |
$this->options = $options;
|
46 |
}
|
43 |
}
|
Line 47... |
Line 44... |
47 |
|
44 |
|
48 |
function toHTML($valeur) {
|
- |
|
49 |
|
45 |
function toHTML($valeur) {
|
50 |
$html = '';
|
46 |
$html = '';
|
51 |
$val = $this->options['nom_bdd'];
|
47 |
$val = $this->options['nom_bdd'];
|
52 |
//pour les champs renseignes par une liste, on va chercher le label de la liste, plutot que l'id
|
48 |
//pour les champs renseignes par une liste, on va chercher le label de la liste, plutot que l'id
|
53 |
$requete = 'SELECT blv_label FROM bazar_fiche_valeur_liste, bazar_liste_valeurs WHERE bfvl_ce_fiche='.
|
49 |
$requete = 'SELECT blv_label FROM bazar_fiche_valeur_liste, bazar_liste_valeurs WHERE bfvl_ce_fiche='.
|
54 |
$GLOBALS['_BAZAR_']['id_fiche'].' AND bfvl_ce_liste='.$this->options['nom_bdd'].
|
50 |
$GLOBALS['_BAZAR_']['id_fiche'].' AND bfvl_ce_liste='.$this->options['nom_bdd'].
|
55 |
' AND bfvl_valeur=blv_valeur AND blv_ce_liste='.$this->options['nom_bdd'].
|
51 |
' AND bfvl_valeur=blv_valeur AND blv_ce_liste='.$this->options['nom_bdd'].
|
56 |
' AND blv_ce_i18n="'.$GLOBALS['_BAZAR_']['langue'].'" ORDER by blv_valeur';
|
52 |
' AND blv_ce_i18n="'.$GLOBALS['_BAZAR_']['langue'].'"';
|
57 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
|
53 |
$resultat = $GLOBALS['_BAZAR_']['db']->query($requete) ;
|
58 |
if (DB::isError ($resultat)) {
|
54 |
if (DB::isError ($resultat)) {
|
59 |
return ($resultat->getMessage().'<br />'.$resultat->getDebugInfo()) ;
|
55 |
return ($resultat->getMessage().'<br />'.$resultat->getDebugInfo()) ;
|
60 |
}
|
56 |
}
|
Line 74... |
Line 70... |
74 |
}
|
70 |
}
|
75 |
}
|
71 |
}
|
Line 76... |
Line 72... |
76 |
|
72 |
|
77 |
/* +--Fin du code ----------------------------------------------------------------------------------------+
|
73 |
/* +--Fin du code ----------------------------------------------------------------------------------------+
|
78 |
*
|
74 |
*
|
79 |
* $Log: not supported by cvs2svn $
|
75 |
* $Log: liste.php,v $
|
80 |
* Revision 1.2 2008-09-17 14:18:12 alexandre_tb
|
76 |
* Revision 1.2 2008-09-17 14:18:12 alexandre_tb
|
81 |
* fusion avec aha
|
77 |
* fusion avec aha
|
82 |
*
|
78 |
*
|
83 |
* Revision 1.1.2.1 2008-04-16 12:35:25 alexandre_tb
|
79 |
* Revision 1.1.2.1 2008-04-16 12:35:25 alexandre_tb
|