| 1,8 → 1,9 |
|---|
| <?php |
| |
| class OdsObservation extends JRestService { |
| class OdsObservation extends GestionTriple { |
| |
| const PREFIXE = 'get'; |
| const ABBR_LISTE_EVENEMENTS = 'evenement'; |
| |
| /** |
| * Méthode appelée avec une requête de type GET. |
| 103,8 → 104,8 |
|---|
| |
| private function getObservationsPourStation($params) { |
| |
| $id_station = $param[0]; |
| $annee = $param[1]; |
| $id_station = $params[0]; |
| $annee = $params[1]; |
| |
| return ; |
| |
| 112,19 → 113,90 |
|---|
| |
| private function getObservationsPourIndividu($params) { |
| |
| $id_individu = $param[0]; |
| $annee = $param[1]; |
| $id_individu = $params[0]; |
| $annee = $params[1]; |
| |
| $requete_liste_observation_individu = 'SELECT * FROM ods_observations '. |
| 'WHERE oo_ce_individu ='.$this->proteger($id_individu).' '. |
| 'ORDER BY oo_date'; |
| |
| $liste_observation_individu = $this->executerRequete($requete_liste_observation_individu); |
| |
| $liste_observation_individu_formatees =array(); |
| |
| $requete_evenements_pour_espece_individu_1 = 'SELECT oe_ce_evenements FROM ods_especes '. |
| 'WHERE oe_id_espece = '. |
| '('. |
| 'SELECT oi_ce_espece FROM ods_individus '. |
| 'WHERE oi_id_individu = '.$this->proteger($id_individu).' '. |
| ')'; |
| |
| |
| $evenements_pour_espece_chaine = $this->executerRequete($requete_evenements_pour_espece_individu_1); |
| $evenements_pour_espece_chaine = $evenements_pour_espece[0]['oe_ce_evenements']; |
| |
| $tableau_evenements_espece = split(',',$evenements_pour_espece_chaine); |
| foreach($tableau_evenements_espece as &$evenement_espece) { |
| $evenement_espece = $this->proteger($evenement_espece); |
| } |
| |
| $evenements_espece_chaine_bdd = implode(',',$tableau_evenements_espece); |
| |
| $requete_liste_evenement_espece_individu = 'SELECT * FROM ods_triples '. |
| 'WHERE ot_id_triple IN '. |
| '('.$evenements_espece_chaine_bdd.')'; |
| |
| $liste_evenement_espece_individu = $this->executerRequete($requete_liste_evenement_espece_individu); |
| $liste_evenement_espece_individu = $liste_evenement_espece_individu[0]; |
| |
| foreach($liste_observation_individu as $observation_individu) { |
| |
| $annee_obs = date($observation_individu['oo_date'], "Y"); |
| $stade_observation_complet = $observation_individu['oo_ce_evenement']; |
| |
| $infos_stades = split('_',$stade_observation_complet); |
| |
| $titre_stade = $infos_stades[1]; |
| $numero_stade = $infos_stades[3]; |
| |
| $date_observation_formatee = date($observation_individu['oo_date'],$this->config['appli']['format_date']); |
| |
| $liste_observation_individu_formatees[$annee_obs][$titre_stade][$numero_stade] = $date_observation_formatee; |
| |
| } |
| |
| return array( |
| |
| '1' => '01/01/2010', |
| '2' => '13/01/2010', |
| '3' => '06/02/2010', |
| '4' => '08/05/2010', |
| '5' => '09/07/2010', |
| '6' => '08/08/2010', |
| '7' => '25/10/2010', |
| ); |
| return $liste_observation_individu_formatees; |
| } |
| |
| /*private function getMajEspece() { |
| $id_maj = '97,98,99,100,101,102,108,109,110,111'; |
| $stade_ajoute = '20'; |
| |
| $tab = explode(',',$id_maj); |
| |
| foreach($tab as $id) { |
| |
| $requete = 'SELECT oe_ce_evenements FROM ods_especes WHERE oe_id_espece = '.$id; |
| echo $requete.'<br />'; |
| $res = $this->executerRequete($requete); |
| |
| print_r($res); |
| |
| if($res[0]['oe_ce_evenements'] == 0) { |
| $evts = ''.$stade_ajoute; |
| } else { |
| $evts = $res[0]['oe_ce_evenements'].','.$stade_ajoute; |
| } |
| |
| $evts = $this->proteger($evts); |
| |
| $requete = 'UPDATE ods_especes SET oe_ce_evenements = '.$evts.' WHERE `oe_id_espece` = '.$id; |
| |
| |
| echo $requete.'<br />';; |
| $this->executerRequeteSimple($requete); |
| } |
| |
| }*/ |
| } |
| ?> |