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