Subversion Repositories eFlore/Applications.cel

Rev

Rev 3124 | Rev 3473 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3124 Rev 3166
Line 261... Line 261...
261
	public function consulterGroupesChampsEtendusPredefinis($groupe = "", $langue = 'fr') {
261
	public function consulterGroupesChampsEtendusPredefinis($groupe = "", $langue = 'fr') {
262
		$groupes = array();
262
		$groupes = array();
263
		$requete =  "SELECT cc.cle as cle_groupe, cc.label as nom_groupe, ccc.cle as cle_champ, ccc.label as label_champ, ccc.type as type_champ, ccc.valeur as valeur_champ, ccc.invisible, ccc.prive ".
263
		$requete =  "SELECT cc.cle as cle_groupe, cc.label as nom_groupe, ccc.cle as cle_champ, ccc.label as label_champ, ccc.type as type_champ, ccc.valeur as valeur_champ, ccc.invisible, ccc.prive ".
264
			"FROM `cel_catalogue_champs_etendus` cc ".
264
			"FROM `cel_catalogue_champs_etendus` cc ".
265
			"INNER JOIN cel_catalogue_champs_etendus_liaison cl ON cc.cle = cl.groupe ".
265
			"INNER JOIN cel_catalogue_champs_etendus_liaison cl ON cc.cle = cl.groupe ".
266
			"INNER JOIN cel_catalogue_champs_etendus ccc ON ccc.cle = cl.champ ". 
266
			"INNER JOIN cel_catalogue_champs_etendus ccc ON ccc.cle = cl.champ ".
267
			"WHERE cc.langue = '".$langue."' ";
267
			"WHERE cc.langue = '".$langue."' ";
268
		if ($groupe !== "") $requete .= " AND cl.groupe = '".$groupe."'";
268
		if ($groupe !== "") $requete .= " AND cl.groupe = '".$groupe."'";
269
		$requete .= ' -- '.__FILE__.':'.__LINE__;
269
		$requete .= ' -- '.__FILE__.':'.__LINE__;
270
		$groupes_champs = Cel::db()->executerRequete($requete);
270
		$groupes_champs = Cel::db()->executerRequete($requete);
Line 379... Line 379...
379
		$cle = str_replace(' ', '', $cle);
379
		$cle = str_replace(' ', '', $cle);
380
		$cle{0} = strtolower($cle{0});
380
		$cle{0} = strtolower($cle{0});
Line 381... Line 381...
381
 
381
 
382
		return $cle;
382
		return $cle;
383
	}
-
 
384
}
383
	}
-
 
384
}