42,7 → 42,9 |
' LEFT JOIN ods_individus '. |
' ON oi_id_individu = oo_ce_individu'. |
' LEFT JOIN ods_stations '. |
' ON oi_ce_station = os_id_station '; |
' ON oi_ce_station = os_id_station '. |
' LEFT JOIN ods_communes '. |
'ON os_ce_commune = oc_code_insee '; |
|
$requete_selection_observations .= $this->construireConditionRequete(); |
$requete_selection_observations .= ' ORDER BY oo_date DESC'; |
52,6 → 54,15 |
return $res_selection_observations; |
} |
|
private function creerFiltreIdZoneGeo($valeurMasque) { |
$masque = ''; |
$dept = $valeurMasque; |
$dept = sprintf('%02s', $dept); |
$dept = sprintf("%-'_5s", $dept); |
$masque = " oc_code_insee LIKE ".$this->proteger($dept); |
return $masque; |
} |
|
public function construireConditionRequete() { |
|
$condition = ' WHERE oo_date != "0000-00-00" AND DAY(oo_date) != "00" AND '; |
94,8 → 105,10 |
$condition .= 'oo_ce_participant = '.$this->proteger($valeur); |
break; |
|
case 'dept' : |
$condition .= $this->creerFiltreIdZoneGeo($valeur); |
break; |
default: |
break; |
} |
|
$condition .= ' AND '; |