/trunk/services/modules/0.1/moissonnage/cartes/SourceDonnees.php |
---|
102,7 → 102,7 |
"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage()." ". |
"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ". |
"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ". |
"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ".$_SERVER['REQUEST_URI']; |
"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI']; |
$stations = $this->bdd->recupererTous($requete); |
$this->rechercherInfosCommune($stations); |
return $stations; |
/trunk/services/modules/0.1/cel/Images.php |
---|
57,7 → 57,7 |
$resultat = new ResultatService(); |
if ($this->parametres['retour'] == self::MIME_JPEG) { |
if ($this->parametres['retour.tri'] == 'date') { // recherche la plus vieille image du CEL |
if (@$this->parametres['retour.tri'] == 'date') { // recherche la plus vieille image du CEL |
$id_image_a_renvoyer = $this->obtenirIdPremiereImage(); |
} else { |
$id_image_a_renvoyer = $this->obtenirIdImageAuHasard(); |
231,8 → 231,8 |
'FROM cel_obs_images AS coi '. |
' LEFT JOIN cel_obs AS co '. |
'ON (coi.id_observation = co.id_observation) '. |
'WHERE ci.transmission = 1 '. |
" AND ci.nom_ret_nn IN ($numNom)"; |
'WHERE co.transmission = 1 '. |
" AND co.nom_ret_nn IN ($numNom)"; |
" AND co.nom_referentiel = ".$this->Bdd->proteger($refTax) . ' -- ' . __FILE__ . ':' . __LINE__; |
$resultat = $this->Bdd->recupererTous($requete); |