| New file |
|---|
| 0,0 → 1,391 |
|---|
| <?php |
| |
| |
| class Images extends Commun { |
| |
| protected $limite_requete = array('depart' => 0, 'limite' => 100); |
| protected $requete_champ = '*'; |
| protected $requete_condition = null; |
| protected $requete_group_by = ' ORDER BY CAST( id_image AS DECIMAL )'; |
| protected $entete_http; |
| protected $corps_http; |
| protected $table_retour; |
| protected $retour_format = 'max'; |
| protected $format_reponse = 'images'; |
| protected $table_param = array(); |
| protected $total_resultat; |
| protected $table_ressources = array(); |
| protected $html = 'txt'; |
| protected $recherche = 'stricte'; |
| protected $service = 'images'; |
| |
| |
| public function consulter($ressources, $parametres) { |
| $resultat_formate = ''; |
| $this->table[] = Config::get("bdd_images"); //." t1,".Config::get("bdd_triples")." t2, ".Config::get("bdd_pages")." p"; |
| $this->traiterParametres($parametres); |
| $this->traiterRessources($ressources); |
| if ($this->corps_http == '' && $this->entete_http == '') { |
| $requete = $this->assemblerLaRequete(); |
| $resultat = $this->getBdd()->recupererTous($requete); |
| $this->testerResultat($resultat, $resultat_formate, $requete); |
| } |
| return $this->formerReponseHTTP($resultat_formate); |
| } |
| |
| public function testerResultat($resultat, &$resultat_formate, $requete) { |
| if ($resultat == '') { //cas ou coste/services/ ou la requete comporte des erreurs |
| $e = 'La requête SQL formée comporte une erreur!'; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE,$e); |
| Debug::printr($requete); |
| } elseif ($resultat) { |
| $resultat_formate = $this->retournerResultatFormate($resultat); |
| } else { |
| if ($this->format_reponse == 'images/relations') { |
| $resultat_formate = 'null'; |
| } else { |
| $m = 'Données introuvables dans la base'; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE,$m); |
| Debug::printr($requete); |
| } |
| } |
| } |
| |
| //-------------------------------------------------------TRAITER RESSOURCES---------------------------------------------- |
| |
| public function traiterRessources(&$ressources) { |
| if (isset($ressources) && !empty($ressources)) { |
| $this->table_ressources = $ressources; |
| //traiter ressources/id |
| if ($ressources[0] == 'relations') { |
| $this->traiterRelationsProjet($ressources); |
| $this->format_reponse .= '/relations'; |
| } elseif (isset($this->table_ressources[0]) && !empty($this->table_ressources[0])) { |
| $this->traiterRessourceId($this->table_ressources[0]); |
| //traiter ressources/id/champ |
| if (isset($this->table_ressources[1]) && !empty($this->table_ressources[1])) { |
| $this->format_reponse .= '/id/champ'; |
| } |
| } |
| } |
| } |
| |
| public function traiterRelationsProjet($tab_ress) { |
| $projet = $tab_ress[1]; |
| $num_nom = $tab_ress[2]; |
| if (isset($tab_ress[3])) { |
| $e = "Pas de type pour le service images"; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_MAUVAISE_REQUETE, $e); |
| } |
| $this->requete_condition[] = "num_nom = ".$this->getBdd()->proteger($num_nom); |
| } |
| |
| public function traiterRessourceId($id) { |
| $this->format_reponse .= '/id'; |
| $this->requete_condition[] = 'id_image LIKE '.$this->getBdd()->proteger($id.'.png'); |
| } |
| |
| |
| //-------------------------------------------------------TRAITER PARAMETRES---------------------------------------------- |
| |
| public function traiterParametres($parametres) { |
| if (isset($parametres) && !empty($parametres)) { |
| $this->table_param = $parametres; |
| //print_r($parametres); |
| if (isset($parametres['recherche']) && $parametres['recherche'] != '') { |
| $this->recherche = $parametres['recherche']; |
| } |
| foreach ($parametres as $param => $val) { |
| switch ($param) { |
| case 'retour_format' : $this->retour_format = $val; break; |
| case 'masque_nn' : $this->ajouterLeFiltreMasque('num_nom', $val); break; |
| case 'masque_no' : $this->ajouterLeFiltreMasque('nom_photographe', $val); break; |
| case 'masque_ns' : $this->ajouterLeFiltreMasque('nom_sci', $val); break; |
| case 'masque_date' : $this->ajouterLeFiltreMasque('date', $val); break; |
| case 'masque_station' : $this->ajouterLeFiltreMasque('station', $val); break; |
| case 'navigation_depart': $this->limite_requete['depart'] = $val; break; |
| case 'navigation_limite': $this->limite_requete['limite'] = $val; break; |
| case 'recherche' : break; |
| default : |
| $e = 'Erreur dans les paramètres de recherche de votre requête : </br> Le parametre " ' |
| .$param.' " n\'existe pas.'; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_MAUVAISE_REQUETE,$e); |
| break; |
| } |
| } |
| } |
| } |
| |
| public function ajouterLeFiltreMasque($masque, $valeur) { |
| if ($this->recherche == 'etendue') { |
| $valeur = '%'.str_replace(' ','%', $valeur).'%'; |
| } |
| //$this->table .= ', '.Config::get("bdd_table").'_v0_1 c'; |
| switch ($masque) { |
| case 'nom_sci' : |
| $this->requete_champ = 'cb.*'; |
| $this->table[] = ' cb , '.Config::get("bdd_table").'_v0_1 c'; |
| $this->requete_condition[] = 'c.nom_sci LIKE ' |
| .$this->getBdd()->proteger($valeur); |
| $this->requete_condition[] = 'c.num_nom_coste = CONCAT(cb.id_image,\',.png\')'; |
| $this->ajouterRechercheFloue('nom_sci', $valeur); |
| break; |
| case 'num_nom' : |
| $val = (strrpos($valeur, ',') !== false)? " IN (".str_replace(',', '.png,', $valeur).")" : " = ".$this->getBdd()->proteger($valeur.".png"); |
| $this->requete_condition[] = "id_image $val"; |
| break; |
| default : |
| break; |
| } |
| } |
| |
| public function ajouterRechercheFloue($nom_champ, $id) { |
| if ($this->recherche == 'floue') { |
| $id = $this->getBdd()->proteger($id); |
| $this->requete_condition[array_search("$nom_champ LIKE $id", |
| $this->requete_condition)] = |
| "($nom_champ LIKE $id)". |
| " OR ( SOUNDEX($nom_champ) = SOUNDEX($id))". |
| " OR SOUNDEX(REVERSE($nom_champ)) = SOUNDEX(REVERSE($id))))"; |
| } |
| } |
| |
| |
| |
| //-----------------------------FONCTIONS DASSEMBLAGE DE LA REQUETE----------------------------------------------------- |
| |
| public function assemblerLaRequete() { |
| $requete = ' SELECT '.$this->requete_champ. |
| ' FROM '.implode(', ', $this->table) |
| .$this->formerRequeteCondition() |
| .$this->requete_group_by |
| .$this->formerRequeteLimite(); |
| return $requete; |
| } |
| |
| public function formerRequeteCondition() { |
| $condition = ''; |
| if ($this->requete_condition !== null) { |
| $condition = ' WHERE '.implode(' AND ', $this->requete_condition); |
| } |
| return $condition; |
| } |
| |
| public function formerRequeteLimite() { |
| if (in_array($this->format_reponse , array('images/id', 'images/id/relations'))) { |
| $this->requete_limite = ''; |
| } elseif (($depart = $this->limite_requete['depart']) > ($this->total_resultat = $this->recupererTotalResultat())) { |
| $this->limite_requete['depart'] = |
| (($this->total_resultat - $this->limite_requete['limite']) < 0) ? 0 : ($this->total_resultat - $this->limite_requete['limite']); |
| $this->requete_limite = ' LIMIT '.$this->limite_requete['depart'].', '.$this->limite_requete['limite']; |
| } else { |
| $this->requete_limite = ' LIMIT '.$this->limite_requete['depart'].', '.$this->limite_requete['limite']; |
| } |
| return $this->requete_limite; |
| } |
| |
| /** |
| * Recupere le nombre total de résultat d'une requete lancée. |
| * Est utilisée lors de l'affichage du total dans le résultat retourné et pr déterminer les limites et départ |
| * @return nombre total de résultat |
| */ |
| public function recupererTotalResultat() { |
| $total = null; |
| $requete = 'SELECT count(*) as nombre FROM '.implode(', ', $this->table).$this->formerRequeteCondition().$this->requete_group_by; |
| $res = $this->getBdd()->recuperer($requete); |
| if ($res) { |
| $total = $res['nombre']; |
| } else { |
| $e = 'Données introuvables dans la base ou erreur dans la requête SQL'; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE, $e); |
| } |
| return $total; |
| } |
| |
| //-------------------FONCTIONS POUR LE FORMATAGE EN JSON---------------------------------------------------------------- |
| |
| public function retournerResultatFormate($resultat) { |
| $reponse = ''; |
| switch ($this->format_reponse) { |
| case 'images' : $reponse = $this->formaterImages($resultat); break; |
| case 'images/relations' : $reponse = $this->formaterImagesRelations($resultat[0]); break; |
| case 'images/id' : $reponse = $this->formaterImagesId($resultat[0]); break; |
| case 'images/id/champ' : $reponse = $this->formaterImagesIdChamp($resultat[0]); break; |
| default : break; |
| } |
| $reponse = json_encode($reponse); |
| return $reponse; |
| } |
| |
| public function formaterImages($resultat) { |
| //print_r($resultat); |
| $this->ajouterEnteteResultat($resultat); |
| $reponse['entete'] = $this->table_retour; |
| $this->table_retour = array(); |
| foreach ($resultat as $images) { |
| $id = str_replace('.png', '', $images['id_image']); |
| $id_coste = $this->recupererNumNom($id); |
| if ($id != '') { |
| $this->table_retour['url.image'] = Config::get('url_images').$images['id_image']; |
| $this->afficherDonnees('id', $id_coste); |
| $reponse['resultat'][$id] = $this->table_retour; |
| $this->table_retour = array(); |
| $reponse['resultat'][$id]['href'] = $this->ajouterHref('images', $id); |
| } |
| } |
| return $reponse; |
| } |
| |
| public function ajouterEnteteResultat($resultat) { |
| $this->table_retour['depart'] = $this->limite_requete['depart']; |
| $this->table_retour['limite'] = $this->limite_requete['limite']; |
| $this->table_retour['total'] = $this->total_resultat; |
| //formuler les urls |
| $url = $this->formulerUrl($this->total_resultat, '/'.$this->service); |
| if ($url['precedent'] != '') { $this->table_retour['href.precedent'] = $url['precedent']; } |
| if ($url['suivant'] != '') { $this->table_retour['href.suivant'] = $url['suivant']; } |
| } |
| |
| |
| public function formaterImagesRelations($resultat) { |
| $reponse['url.image'] = Config::get('url_images').$resultat['id_image']; |
| return $reponse; |
| } |
| |
| |
| public function formaterImagesId($resultat) { |
| $id = str_replace('.png', '', $resultat['id_image']); |
| $id_coste = $this->recupererNumNom($id); |
| $this->table_retour['url.image'] = Config::get('url_images').$resultat['id_image']; |
| $this->table_retour['id'] = $id; |
| $this->table_retour['auteur'] = $resultat['auteur']; |
| $this->table_retour['station.pays'] = "ISO-3166-1.FR"; |
| $this->afficherDonnees('id', $id_coste); |
| $res = $this->ajouterRelationBdnff($resultat['num_nom']); |
| return $res; |
| } |
| |
| |
| |
| public function recupererNumNom($num_nom_coste) { |
| $req = "SELECT num_nom FROM coste_v0_1 WHERE num_nom_coste = " |
| .$this->getBdd()->proteger($num_nom_coste)." AND num_nom = num_nom_retenu"; |
| $res = $this->getBdd()->recuperer($req); |
| if ($res) { |
| $num_nom = $res['num_nom']; |
| } |
| return $num_nom; |
| } |
| |
| public function ajouterRelationBdnff($num_nom) { |
| $res = $this->table_retour; |
| $this->table_retour = array(); |
| $this->afficherDonnees('id', $num_nom, 'bdtfx'); |
| $res['relations']['nom'] = $this->table_retour; |
| return $res; |
| } |
| |
| public function formaterImagesIdChamp($resultat) { |
| //on recupère tous les resultats possibles |
| $reponse_id = $this->formaterImagesId($resultat); |
| $this->table_retour = array(); |
| //on recupère les résultats demandés à partir du tableau de résultat complet |
| $this->table_retour['id'] = $resultat['tag']; |
| $champs = explode(' ', $this->table_ressources[1]); |
| foreach ($champs as $champ) { |
| if ($this->verifierValiditeChamp($champ, $reponse_id)) { |
| if (preg_match('/^[^.]+\.\*$/', $champ)) { |
| $this->afficherPointEtoile($champ, $reponse_id); |
| } else { |
| $this->table_retour[$champ] = $reponse_id[$champ]; |
| } |
| } |
| } |
| return $this->table_retour; |
| } |
| |
| public function afficherPointEtoile($champ, $reponse_id) { |
| preg_match('/^([^.]+\.)\*$/', $champ, $match); |
| foreach ($reponse_id as $chp => $valeur) { |
| if (strrpos($chp, $match[1]) !== false) { |
| $this->table_retour[$chp] = $valeur; |
| } |
| } |
| } |
| |
| public function verifierValiditeChamp($champ, $reponse_id) { |
| $validite = false; |
| preg_match('/^([^.]+)(:?\.([^.]+))?$/', $champ, $match); |
| if (array_key_exists($match[1], $reponse_id)) { |
| $validite = true; |
| if (isset($match[2]) && !empty($match[2])) { |
| if ($match[1] == 'type') { |
| $suffixes = array('.code', '.href', '.*'); |
| $validite = (in_array($match[2], $suffixes)) ? true : false; |
| } else { |
| $validite = false; |
| } |
| } |
| } |
| if (!$validite) { |
| $champs = implode('</li><li>', array_keys($reponse_id)); |
| $e = 'Erreur dans votre requête : </br> Le champ "'.$champ.'" n\'existe pas. Les champs disponibles |
| sont : <li>'.$champs.'</li>'; |
| $this->renvoyerErreur(RestServeur::HTTP_CODE_MAUVAISE_REQUETE, $e); |
| } |
| return $validite; |
| } |
| |
| |
| //------------------------------------------------Fonction d'affichage ------------------------------------------------ |
| |
| public function afficherDonnees($champ, $valeur, $projet = null) { |
| if ($this->retour_format == 'min') { |
| $champ = ($champ == 'type') ? $champ.'.code' : $champ; |
| $this->table_retour[$champ] = $valeur; |
| } else { |
| $this->afficherDonneesMax($champ, $valeur, $projet); |
| } |
| } |
| |
| public function afficherDonneesMax($champ, $valeur, $projet = null) { |
| if (!$projet) $projet = 'coste'; |
| if ($champ == 'id') { |
| $this->table_retour['nom_sci.id'] = $projet.'.'.$valeur; |
| $fct = "recupererNomSci".ucfirst($projet); |
| $this->table_retour['nom_sci'] = $this->$fct($valeur); |
| $this->table_retour['nom_sci.href'] = $this->ajouterHrefAutreProjet('noms', '', $valeur, $projet); |
| } elseif (in_array($champ, array('type'))) { |
| $this->table_retour[$champ.'.code'] = $valeur; |
| $this->table_retour[$champ] = $this->recupererSignificationCode($valeur); |
| $this->table_retour[$champ.'.href'] = $this->ajouterHrefAutreProjet($champ, '', $valeur, 'commun'); |
| } else { |
| $this->table_retour[$champ] = $valeur; |
| } |
| } |
| |
| public function recupererSignificationCode($code) { |
| $url = $this->ajouterHrefAutreProjet('ontologies', 'texteType:', $code.'/nom', 'commun'); |
| $res = $this->consulterHref($url); |
| return $res->nom; |
| } |
| |
| public function recupererNomSciCoste($id) { |
| $req = 'SELECT nom_sci FROM coste_v0_1 WHERE num_nom = '.$id; |
| if ($this->html == 'htm') { |
| $req = str_replace('nom_sci', 'nom_sci_html as nom_sci', $req); |
| } |
| $res = $this->getBdd()->recuperer($req); |
| return $res['nom_sci']; |
| } |
| |
| public function recupererNomSciBdtfx($id) { |
| $req = 'SELECT flore_bdnff_nom_sci FROM coste_v0_1 WHERE flore_bdnff_num = '.$id; |
| $res = $this->getBdd()->recuperer($req); |
| return $res['flore_bdnff_nom_sci']; |
| } |
| } |
| |
| |
| |
| ?> |