Subversion Repositories Sites.obs-saisons.fr

Compare Revisions

Ignore whitespace Rev 40 → Rev 41

/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);
}
 
}*/
}
?>
/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;
}
}
?>