Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3487 → Rev 3488

/trunk/jrest/bibliotheque/GestionChampsEtendus2.php
240,9 → 240,10
* Renvoie le catalogue des champs étendus
*/
public function consulterCatalogueChampsEtendusPredefinis($ordonner_par_cle = false, $groupe = "") {
$requete = 'SELECT cle, label, invisible, prive '.
'FROM cel_catalogue_champs_etendus AS cc ';
if ($groupe !== "") $requete .= " WHERE groupe = ".$groupe;
$requete = 'SELECT ce.field_id as cle, cet.`label` as label, "0" as invisible, "0" as prive '.
"FROM {$this->table_champs_etendus} ce ".
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ";
if ($groupe !== "") $requete .= " WHERE project = ".$groupe;
$requete .= ' -- '.__FILE__.':'.__LINE__;
$catalogue = Cel::db()->executerRequete($requete);