| 169,19 → 169,22 |
|---|
| |
| public function getExportObservation($start = null,$limit = null, $order_by = 'oo_date') { |
| |
| $requete_selection_observations = 'SELECT * FROM ods_observations '. |
| ' LEFT JOIN ods_individus '. |
| $requete_selection_observations = 'SELECT oo.*, oi.*, os.*, oc.* FROM ods_observations oo'. |
| ' LEFT JOIN ods_individus oi'. |
| ' ON oi_id_individu = oo_ce_individu'. |
| ' LEFT JOIN ods_stations '. |
| ' INNER JOIN ods_especes oe'. |
| ' ON oe.oe_espece_active = 1 '. |
| ' AND oe.oe_id_espece = oi_ce_espece '. |
| ' LEFT JOIN ods_stations os'. |
| ' ON oi_ce_station = os_id_station '. |
| ' LEFT JOIN ods_communes '. |
| 'ON os_ce_commune = oc_code_insee '; |
| |
| ' LEFT JOIN ods_communes oc'. |
| ' ON os_ce_commune = oc_code_insee '; |
| |
| $requete_selection_observations .= $this->construireConditionRequete(); |
| $requete_selection_observations .= ' ORDER BY oo_date DESC'; |
| |
| |
| $res_selection_observations = $this->executerRequete($requete_selection_observations); |
| |
| |
| return $res_selection_observations; |
| } |
| |
| 368,7 → 371,6 |
|---|
| $codes_insee_communes = array(); |
| |
| $resultats_formates = array(); |
| |
| foreach($tableau_observations_infos as $observations_infos) { |
| |
| $id_espece = $observations_infos['oi_ce_espece']; |