172,12 → 172,23 |
* Renvoie les champs étendus d'un projet |
*/ |
public function consulterProjetChampsEtendus($projet = "", $langue = 'fr') { |
if ($projet !== "") { |
$requeteProjetType = "SELECT type FROM `project_settings` WHERE `project` = '".$projet."';"; |
$resultat = Cel::db()->executerRequete($requeteProjetType); |
if ($resultat == array() || $resultat[0]['type'] == "") { |
$requeteProjet = " AND ce.project = '".$projet."' AND cet.project = '".$projet."' "; |
} else { |
$type = $resultat[0]['type']; |
$requeteProjet = " AND ce.project = '".$type."' AND cet.project = '".$type."' "; |
} |
} else { |
$requeteProjet = ""; |
} |
$groupes = array(); |
$requete = "SELECT {$this->liste_champs} ". |
"FROM {$this->table_champs_etendus} ce ". |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id AND ce.project = cet.project ". |
"WHERE cet.language_iso_code = '".$langue."' "; |
if ($projet !== "") $requete .= " AND ce.project = '".$projet."' AND cet.project = '".$projet."' "; |
"WHERE cet.language_iso_code = '".$langue."' ".$requeteProjet; |
$requete .= ' -- '.__FILE__.':'.__LINE__; //echo $requete;exit; |
$groupes_champs = Cel::db()->executerRequete($requete); |
|