Subversion Repositories Sites.obs-saisons.fr

Compare Revisions

Regard whitespace Rev 326 → Rev 327

/trunk/applications/jrest/services/OdsObservation.php
37,6 → 37,27
 
}
 
private function getAnneeMinimumObservation() {
$requete_annee_min_obs = 'SELECT MIN(YEAR(oo_date)) as min_annee FROM ods_observations '.
'WHERE oo_date != "0000-00-00"';
$resultat_min_annee_obs = $this->executerRequete($requete_annee_min_obs);
return !empty($resultat_min_annee_obs) ? $resultat_min_annee_obs[0]['min_annee'] : Date('Y');
}
 
private function getAnneesAyantObservations() {
$requete_annee_min_obs = 'SELECT DISTINCT YEAR(oo_date) as annee FROM ods_observations '.
'WHERE oo_date != "0000-00-00" AND YEAR(oo_date) <= "'.date('Y').'" '.
'ORDER BY annee DESC';
$resultat_annees_ayant_obs = $this->executerRequete($requete_annee_min_obs);
$annees_ayant_obs = [];
foreach($resultat_annees_ayant_obs as $res_annee_ayant_obs) {
$annees_ayant_obs[] = $res_annee_ayant_obs['annee'];
}
 
return $annees_ayant_obs;
}
 
private function getObservationsPourStation($params) {
 
$id_station = isset($params[0]) ? $params[0] : '';
/trunk/applications/jrest/services/OdsMarqueur.php
11,7 → 11,8
public function getElement() {
if(isset($_GET['couleurs'])) {
$couleurs = explode(',',$_GET['couleurs']);
$couleurs = strtoupper(urldecode($_GET['couleurs']));
$couleurs = explode(',', $couleurs);
}
$taille = 15;
/trunk/applications/jrest/services/OdsExport.php
240,7 → 240,7
break;
 
case 'region' :
$requete_association_region .= 'SELECT * FROM ods_triples WHERE ot_ce_parent = 36 AND ot_valeur = '.$valeur;
$requete_association_region = 'SELECT * FROM ods_triples WHERE ot_ce_parent = 36 AND ot_valeur = '.$valeur;
$listeAssociationRegions = $this->executerRequete($requete_association_region);
$departements = array();
foreach ($listeAssociationRegions as $associationRegion) {