Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3487 Rev 3488
Line 238... Line 238...
238
	
238
	
239
	/**
239
	/**
240
	 * Renvoie le catalogue des champs étendus
240
	 * Renvoie le catalogue des champs étendus
241
	 */
241
	 */
242
	public function consulterCatalogueChampsEtendusPredefinis($ordonner_par_cle = false, $groupe = "") {
242
	public function consulterCatalogueChampsEtendusPredefinis($ordonner_par_cle = false, $groupe = "") {
243
	    $requete =  'SELECT cle, label, invisible, prive '.
243
	    $requete =  'SELECT ce.field_id as cle, cet.`label` as label, "0" as invisible, "0" as prive '.
-
 
244
	   	    "FROM {$this->table_champs_etendus} ce ".
244
	   	    'FROM cel_catalogue_champs_etendus AS cc ';
245
			"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ";
245
	    if ($groupe !== "") $requete .= " WHERE groupe = ".$groupe;
246
	    if ($groupe !== "") $requete .= " WHERE project = ".$groupe;
246
	    $requete .= ' -- '.__FILE__.':'.__LINE__;
247
	    $requete .= ' -- '.__FILE__.':'.__LINE__;
Line 247... Line 248...
247
	    $catalogue = Cel::db()->executerRequete($requete);
248
	    $catalogue = Cel::db()->executerRequete($requete);
248
	    
249