/trunk/applications/jrest/services/OdsEspece.php |
---|
94,6 → 94,24 |
private function getElementParDefaut() { |
return $this->getEspecesParType(); |
} |
private function getEspece($params) { |
$id_espece = $params[0]; |
$requete_informations_espece = 'SELECT * FROM ods_especes '. |
'WHERE oe_id_espece = '.$this->proteger($id_espece); |
$informations_espece = $this->executerRequete($requete_informations_espece); |
$informations_espece_formatees = array(); |
if(!empty($informations_espece)) { |
$informations_espece_formatees = $this->formaterTableauEspecePourEnvoi($informations_espece[0]); |
} |
return $informations_espece_formatees; |
} |
private function getEspecesPourStation($params) { |
/trunk/applications/jrest/services/OdsEvenement.php |
---|
101,31 → 101,54 |
} |
private function getEvenementsPourEspece($id_espece) { |
return array( |
'1' => array( |
'id' => '1', |
'nom' => 'feuillaison', |
'stades' => array('6','12') |
), |
'2' => array( |
'id' => '2', |
'nom' => 'floraison', |
'stades' => array('22','33') |
), |
'3' => array( |
'id' => '3', |
'nom' => 'fructification', |
'stades' => array('85') |
), |
'4' => array( |
'id' => '4', |
'nom' => 'senescence', |
'stades' => array('90','95') |
) |
); |
private function getEvenementsPourEspece($params) { |
$id_espece = $params[0]; |
$requete_evenements_pour_espece = 'SELECT oe_ce_evenements FROM ods_especes '. |
'WHERE oe_id_espece = '.$this->proteger($id_espece); |
$evenements_pour_espece = $this->executerRequete($requete_evenements_pour_espece); |
$evenements_pour_espece = $evenements_pour_espece[0]['oe_ce_evenements']; |
$tableau_evenements_espece = split(',',$evenements_pour_espece); |
foreach($tableau_evenements_espece as &$evenement_espece) { |
$evenement_espece = $this->proteger($evenement_espece); |
} |
$evenements_espece_chaine_bdd = implode(',',$tableau_evenements_espece); |
$requete_liste_evenements_pour_espece = 'SELECT * FROM ods_triples '. |
'WHERE ot_id_triple IN '. |
'('.$evenements_espece_chaine_bdd.')'; |
$liste_evenements_pour_espece = $this->executerRequete($requete_liste_evenements_pour_espece); |
$liste_evenements_pour_espece_formatee = $this->formaterTableauEvenementPourEnvoi($liste_evenements_pour_espece); |
return $liste_evenements_pour_espece_formatee; |
} |
private function formaterTableauEvenementPourEnvoi($liste_evenements) { |
$tableau_evenements_formate = array(); |
foreach($liste_evenements as $evenement) { |
$stade_observation_complet = $evenement['ot_cle']; |
$infos_stades = split('_',$stade_observation_complet); |
$titre_stade = $infos_stades[1]; |
$numero_stade = $infos_stades[3]; |
$tableau_evenements_formate[$titre_stade]['id'] = $evenement['ot_id_triple']; |
$tableau_evenements_formate[$titre_stade]['nom'] = $titre_stade; |
$tableau_evenements_formate[$titre_stade]['stades'][] = $numero_stade; |
} |
return $tableau_evenements_formate; |
} |
} |
?> |
/trunk/applications/jrest/services/OdsIndividu.php |
---|
113,14 → 113,25 |
$this->envoyer(); |
} |
private function getElementParDefaut($params) { |
return $this->getInformationsIndividu($params); |
} |
private function getInformationsIndividu($params) { |
$id_individu = $params[0]; |
$requete_toute_espece = 'SELECT * FROM ods_individus '. |
$requete_informations_individu = 'SELECT * FROM ods_individus '. |
'WHERE oi_id_individu = '.$this->proteger($id_individu); |
$liste_espece = $this->executerRequete($requete_toute_espece); |
$informations_individu = $this->executerRequete($requete_informations_individu); |
if(!empty($informations_individu)) { |
$informations_individu_formatees = $this->formaterTableauIndividuPourEnvoi($informations_individu[0]); |
} |
return $informations_individu_formatees; |
} |
private function getIndividusPourStation($params) { |
161,7 → 172,7 |
private function formaterTableauIndividuPourEnvoi($individu) { |
return array( |
'id_espece' => $individu['oi_id_individu'], |
'id_individu' => $individu['oi_id_individu'], |
'id_espece' => $individu['oi_ce_espece'], |
'id_station' => $individu['oi_ce_station'], |
'nom' => $individu['oi_nom'] |
/trunk/applications/jrest/services/OdsObservation.php |
---|
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); |
} |
}*/ |
} |
?> |