| Line 55... |
Line 55... |
| 55 |
*
|
55 |
*
|
| 56 |
* @param int $id_element_lie
|
56 |
* @param int $id_element_lie
|
| 57 |
* @return array tableau associatif des champs de la table etendu
|
57 |
* @return array tableau associatif des champs de la table etendu
|
| 58 |
*/
|
58 |
*/
|
| 59 |
public function consulter($id_element_lie, $langue = "fr") {
|
59 |
public function consulter($id_element_lie, $langue = "fr") {
|
| 60 |
$id = Cel::db()->proteger($id_element_lie);
|
- |
|
| 61 |
$requete = 'SELECT {$this->liste_champs} '.
|
60 |
$requete = "SELECT $this->liste_champs} ".
|
| 62 |
"FROM {$this->table_champs_etendus} ce ".
|
61 |
"FROM {$this->table_champs_etendus} ce ".
|
| 63 |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ".
|
62 |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ".
|
| 64 |
"WHERE cet.language_iso_code = '".$langue."' AND ";
|
63 |
"WHERE cet.language_iso_code = '".$langue."' AND ";
|
| 65 |
($id_element_lie != "") ? $requete .= " {$this->champ_id} = $id " : "";
|
64 |
($id_element_lie != "") ? $requete .= " {$this->champ_id} = $id_element_lie " : "";
|
| 66 |
$requete .= ' -- '.__FILE__.':'.__LINE__;
|
65 |
$requete .= ' -- '.__FILE__.':'.__LINE__;
|
| 67 |
$resultat = Cel::db()->requeter($requete);
|
66 |
$resultat = Cel::db()->requeter($requete);
|
| 68 |
return $resultat;
|
67 |
return $resultat;
|
| 69 |
}
|
68 |
}
|