/trunk/jrest/bibliotheque/GestionChampsEtendus.php |
---|
137,14 → 137,14 |
if (! $champs_etendus) return TRUE; // le tableau ... vide à été inséré |
$ajout = false; |
$label_champs_etendus = new GestionChampsEtendus2($cel->config); |
$champs_etendus_id = $label_champs_etendus->consulterGroupesChampsEtendusPredefinis($projet); |
if ($champs_etendus_id !== null) { |
$lignes = array(); |
$lignes = array(); |
foreach ($champs_etendus as $champ_etendu) { |
if (isset($champs_etendus_id[$champ_etendu->cle])) { |
$champ_id = $label_champs_etendus->consulter($champ_etendu->cle); |
if ($champ_id != false) { |
$id = Cel::db()->proteger($champ_etendu->id); |
$cle = Cel::db()->proteger($champs_etendus_id[$champ_etendu->cle]['id']); |
$cle = Cel::db()->proteger($champ_id[0]['id']); |
$valeur = Cel::db()->proteger($champ_etendu->valeur); |
$lignes[] = "($id, $cle, $valeur)"; |
/trunk/jrest/bibliotheque/GestionChampsEtendus2.php |
---|
57,12 → 57,11 |
* @return array tableau associatif des champs de la table etendu |
*/ |
public function consulter($id_element_lie, $langue = "fr") { |
$id = Cel::db()->proteger($id_element_lie); |
$requete = 'SELECT {$this->liste_champs} '. |
$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 ". |
"WHERE cet.language_iso_code = '".$langue."' AND "; |
($id_element_lie != "") ? $requete .= " {$this->champ_id} = $id " : ""; |
($id_element_lie != "") ? $requete .= " {$this->champ_id} = $id_element_lie " : ""; |
$requete .= ' -- '.__FILE__.':'.__LINE__; |
$resultat = Cel::db()->requeter($requete); |
return $resultat; |