Subversion Repositories eFlore/Applications.cel

Rev

Rev 3494 | Rev 3537 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3494 Rev 3535
Line 80... Line 80...
80 
		$champs_etendus_par_element = array();
 80 
		$champs_etendus_par_element = array();
81 
		if (!empty($ids_element_lies)) {
 81 
		if (!empty($ids_element_lies)) {
82 
			$ids_element_lies = array_map(array(Cel::db(), 'proteger'),$ids_element_lies);
 82 
			$ids_element_lies = array_map(array(Cel::db(), 'proteger'),$ids_element_lies);
83 
			$ids = implode(',', $ids_element_lies);
 83 
			$ids = implode(',', $ids_element_lies);
Line 84... Line 84...
84 
 
 84 
 
85 
			$requete = "SELECT occurrence_id, value, `field_id`as cle FROM {$this->table_obs_etendus} o join extended_field f
 85 
			$requete = "SELECT occurrence_id, occurrence_id as id_observation, value as valeur, `field_id`as cle FROM {$this->table_obs_etendus} o join extended_field f
86 
			     on f.`id` =  extended_field_id WHERE {$this->champ_id} IN ($ids) ";
 86 
			     on f.`id` =  extended_field_id WHERE {$this->champ_id} IN ($ids) ";
Line 87... Line 87...
87 
			$resultats = Cel::db()->requeter($requete);
 87 
			$resultats = Cel::db()->requeter($requete);
88
88
Line 92... Line 92...
92 
					$champs_etendus_par_element[$id_element] = array();
 92 
					$champs_etendus_par_element[$id_element] = array();
93 
				}
 93 
				}
94 
				$champ_etendu = new ObsEtendue();
 94 
				$champ_etendu = new ObsEtendue();
95 
				$champ_etendu->id = $id_element;
 95 
				$champ_etendu->id = $id_element;
96 
				$champ_etendu->cle = $ligne['cle'];
 96 
				$champ_etendu->cle = $ligne['cle'];
97 
				$champ_etendu->valeur = $ligne['value'];
 97 
				$champ_etendu->valeur = $ligne['valeur'];
Line 98... Line 98...
98 
 
 98 
 
99 
				$champs_etendus_par_element[$id_element][] = $champ_etendu;
 99 
				$champs_etendus_par_element[$id_element][] = $champ_etendu;
100 
			}
 100 
			}
101 
		}
 101 
		}