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