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); |
|