Rev 303 | Rev 315 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<?php/*vim: set expandtab tabstop=4 shiftwidth=4: */// +------------------------------------------------------------------------------------------------------+// | PHP version 5.1.1 |// +------------------------------------------------------------------------------------------------------+// | Copyright (C) 2006 Tela Botanica (accueil@tela-botanica.org) |// +------------------------------------------------------------------------------------------------------+// | This file is part of eFlore-Fiche. |// | |// | Foobar is free software; you can redistribute it and/or modify |// | it under the terms of the GNU General Public License as published by |// | the Free Software Foundation; either version 2 of the License, or |// | (at your option) any later version. |// | |// | Foobar is distributed in the hope that it will be useful, |// | but WITHOUT ANY WARRANTY; without even the implied warranty of |// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |// | GNU General Public License for more details. |// | |// | You should have received a copy of the GNU General Public License |// | along with Foobar; if not, write to the Free Software |// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |// +------------------------------------------------------------------------------------------------------+// CVS : $Id: effi_cel.action.php,v 1.9 2007-11-06 10:54:03 jp_milcent Exp $/*** Fichier d'action du module eFlore-Fiche : Cel** Appel Carnet en ligne***@package eFlore*@subpackage ef_fiche//Auteur original :*@author David Delon <dd@clapas.net>//Autres auteurs :*@author aucun*@copyright Tela-Botanica 2000-2006*@version $Revision: 1.9 $ $Date: 2007-11-06 10:54:03 $// +------------------------------------------------------------------------------------------------------+*/// +------------------------------------------------------------------------------------------------------+// | ENTETE du PROGRAMME |// +------------------------------------------------------------------------------------------------------+// +------------------------------------------------------------------------------------------------------+// | CORPS du PROGRAMME |// +------------------------------------------------------------------------------------------------------+// TODO : CSS specifique (id)class Cartes {private $tab_code_insee = array();private $src_map;public function consulter($ressources, $param) {$this->ressources = $ressources;$this->param = $param;$this->traiterParametres();// Initialisation des variables$tab_retour = array();$tab_retour['contenu_page'] = $this->calculerRepartition($this->info);print_r($this->calculerRepartition($this->info));}private function traiterParametres() {if ($this->param['retour.format'] == 'min') {$this->src_map = 'france_utm_miniature.jpg';} else {$this->src_map = 'france_utm_600x564.jpg';}// +-----------------------------------------------------------------------------------------------------------+// Ajout du code du r�f�rentiel$this->info['referentiel'] = 'bdtfx';// +-----------------------------------------------------------------------------------------------------------+// R�cup�ration d'infos g�n�rales/*$this->info['nn'] = 141;$this->info['nt'] = 8522;$this->info['nom'] = 'Acer campestre L.';$this->info['nom_ss_auteur'] = 'Acer campestre';*/$this->info['nn'] = $this->param['masque.nn'];$this->info['nt'] = $this->param['masque.nt'];$this->info['nom'] = $this->param['masque.ns'].' '.$this->param['masque.au'];$this->info['nom_ss_auteur'] = $this->param['masque.ns'];$this->info['miniature'] = $this->param['retour.format'];}private function calculerRepartition($param) {$text = '';// Lecture commentaires embarqu�s dans la page$jpg_txt = file_get_contents(Config::get('Cartes.chemin').str_replace('jpg', 'txt', $this->src_map));parse_str($jpg_txt);// Rappel : Pixel : O,0 en haut gauche// X Coin inferieur gauche en Pixel//$Px_echelle_X1['31T'] = 0;$Px_echelle_X1['31T'] = $X131T;// Y Coin inferieur gauche en Pixel//$Px_echelle_Y1['31T'] = 539;$Px_echelle_Y1['31T'] = $Y131T;// Pour calcul Resolution// X Coin inferieur droit en Pixel//$Px_echelle_X2['31T'] = 805;$Px_echelle_X2['31T'] = $X231T;// Y Coin inferieur droit en Pixel//$Px_echelle_Y2['31T'] = 539;$Px_echelle_Y2['31T'] = $Y231T;// X Coin inferieur gauche en UTM//$M_UTM_X1['31T'] = 300092;$M_UTM_X1['31T'] = $X131TUTM;// Y Coin inferieur gauche en UTM//$M_UTM_Y1['31T'] = 4536867;$M_UTM_Y1['31T'] = $Y131TUTM;// Pour calcul "resolution"// X Coin inferieur droit en UTM//$M_UTM_X2['31T'] = 105371; //$M_UTM_X2['31T'] = $X231TUTM;// Y Coin inferieur droit en UTM//$M_UTM_Y2['31T'] = 5042332;$M_UTM_Y2['31T'] = $Y231TUTM;// "Resolution"$p['31T'] = ($Px_echelle_X2['31T'] - $Px_echelle_X1['31T']) / ($M_UTM_X2['31T'] - $M_UTM_X1['31T']);// Fuseau 32T :// Pixel : O,0 en haut gauche// X Coin inferieur gauche en Pixel//$Px_echelle_X1['32T'] = 483;$Px_echelle_X1['32T'] = $X132T;// Y Coin inferieur gauche en Pixel//$Px_echelle_Y1['32T'] = 536;$Px_echelle_Y1['32T'] = $Y132T;// X Coin inferieur droit en Pixel//$Px_echelle_X2['32T'] = 805;$Px_echelle_X2['32T'] = $X232T;// Y Coin inferieur droit en Pixel//$Px_echelle_Y2['32T'] = 536;$Px_echelle_Y2['32T'] = $Y232T;// X Coin inferieur gauche en UTM//$M_UTM_X1['32T'] = 247615;$M_UTM_X1['32T'] = $X132TUTM;// Y Coin inferieur gauche en UTM//$M_UTM_Y1['32T'] = 4540000;$M_UTM_Y1['32T'] = $Y132TUTM;//$angle3132;// "Resolution"$p['32T'] = ($Px_echelle_X2['31T'] - $Px_echelle_X1['31T'] ) / ($M_UTM_X2['31T'] - $M_UTM_X1['31T']);// Fuseau 30T :// X Coin inferieur gauche en Pixel//$Px_echelle_X1['30T'] = 483;$Px_echelle_X1['30T'] = $X130T;// Y Coin inferieur gauche en Pixel//$Px_echelle_Y1['30T'] = 536;$Px_echelle_Y1['30T'] = $Y130T;// X Coin inferieur droit en Pixel//$Px_echelle_X2['30T'] = 805;$Px_echelle_X2['30T'] = $X230T;// Y Coin inferieur droit en Pixel//$Px_echelle_Y2['30T'] = 536;$Px_echelle_Y2['30T'] = $Y230T;// X Coin inferieur gauche en UTM//$M_UTM_X1['30T'] = 247615;$M_UTM_X1['30T'] = $X130TUTM;// Y Coin inferieur gauche en UTM//$M_UTM_Y1['30T'] = 4540000;$M_UTM_Y1['30T'] = $Y130TUTM;// angle//$a = 356.0; // (-4 degre)// "Resolution"$p['30T'] = ($Px_echelle_X2['31T'] - $Px_echelle_X1['31T'] ) / ($M_UTM_X2['31T'] - $M_UTM_X1['31T']);// Nom du fichier image en sortie$this->cheminCartesBase = Config::get('Cartes.chemin');$dest_map = 'nt'.$this->info['nt'].'_'.$this->src_map;$dest_map_cel = 'cel_nt'.$this->info['nt'].'_'.$this->src_map;$dest_map_cenlr = 'cenlr_nt'.$this->info['nt'].'_'.$this->src_map;$dest_map_cbnmed = 'cbnmed_nt'.$this->info['nt'].'_'.$this->src_map;$dest_map_sophy = 'sophy_nt'.$this->info['nt'].'_'.$this->src_map;$img = imagecreatefromjpeg($this->cheminCartesBase.$this->src_map);$img_cel = imagecreatefromjpeg($this->cheminCartesBase.$this->src_map);$img_cenlr = imagecreatefromjpeg($this->cheminCartesBase.$this->src_map);$img_cbnmed = imagecreatefromjpeg($this->cheminCartesBase.$this->src_map);$img_sophy = imagecreatefromjpeg($this->cheminCartesBase.$this->src_map);$retour = '<a name="topmap"></a>';/** Les donnees issues du carnet en ligne sont recuperes directement, sans passer par le mecanisme de moissonage car :* - pour l'instant le service de moissonage n'est pas automatise et donc il y a un decalage dans l'affichage des donnees transmises* - la table contenant les donnees moissonees ne reprend pas tous les champs necessaires a l'exploitation par eflore (notamment pas de code localite, pas d'identifiant libre)** A terme, utilser vraiment le moissonage, y compris pour les donnees issues du CEL, en utilisant ABCD et en modifiant le programme d'harvesting.*/$inventories = $this->recupererDonnees();if (is_array($inventories)){// D�finition des couleurs des points// green$green = imagecolorallocate($img, 0, 255, 0);// red$red = imagecolorallocate($img, 255, 0, 0);// blue$blue = imagecolorallocate($img, 0, 0, 255);// purple$purple = imagecolorallocate($img, 255, 0, 255);// black$black = imagecolorallocate($img, 0, 0, 0);$i = 0;$text = array();$merge = array();// Connection referentiel communes$this->chargerVille();foreach ($inventories as $inventory){// On ne tient pas compte des coordonn�es x, y , positionnement en fonction de la commune uniquement$location_protege = $this->getBdd()->proteger($inventory['location']);$id_location_protege = $this->getBdd()->proteger($inventory['id_location']);if ($inventory['collection_code'] == 'FLORE - VAR') {if (isset($this->tab_code_insee[$location_protege])) {$utm = array(0 => $this->tab_code_insee[$location_protege]);}} elseif ($inventory['collection_code'] == 'sophy') {if (isset($this->tab_code_insee[$id_location_protege])) {$utm = array(0 => $this->tab_code_insee[$id_location_protege]);}} else {if ($inventory['id_location'] != 'null') {$requete = "SELECT * "."FROM tb_cel.locations "."WHERE name LIKE $location_protege "." AND code = $id_location_protege ";$utm = $this->getBdd()->recupererTous($requete);} else {$requete = "SELECT * FROM tb_cel.locations WHERE name LIKE $location_protege ";$utm = $this->getBdd()->recupererTous($requete);}}// Ultime tentativeif (!$utm) {$requete = "SELECT * FROM tb_cel.locations WHERE name LIKE $location_protege ";$utm = $this->getBdd()->recupererTous($requete);}// Si des doublons sur la commune : pas d'affichage , il vaut mieux ne rien afficher que d'afficher des erreurs.if (sizeof($utm) == 1) {$utm = $utm[0];// On centre le point au milieu de la maille 10x10 par defaut ...$pad = str_repeat ('0' ,(7 - strlen( $utm['x_utm'])));$utm['x_utm'] = $pad.$utm['x_utm'];$pad = str_repeat ('0' ,(7 - strlen( $utm['y_utm'])));$utm['y_utm'] = $pad.$utm['y_utm'];$utm['x_utm'] = substr($utm['x_utm'] ,0,3);$utm['x_utm'] = $utm['x_utm'].'5000';$utm['y_utm'] = substr($utm['y_utm'] ,0,3);$utm['y_utm'] = $utm['y_utm'].'5000';// Calcul coordonnes x, y sur l'image// Fuseau 31 Tif ($utm['sector']=='31T') {$x = (($utm['x_utm'] - $M_UTM_X1['31T']) * $p['31T'] ) + $Px_echelle_X1['31T'];$y = $Px_echelle_Y2['31T'] - (($utm['y_utm'] - $M_UTM_Y1['31T']) * $p['31T'] );} elseif ($utm['sector'] == '32T') {// Fuseau 32 T : une rotation + translation est appliqu�e$cosa = cos(deg2rad($angle3132));$sina = sin(deg2rad($angle3132));$xp = (($utm['x_utm'] - $M_UTM_X1['32T']) * $cosa) + (($utm['y_utm']- $M_UTM_Y1['32T']) * $sina);$yp = (-($utm['x_utm'] - $M_UTM_X1['32T'])* $sina) + (($utm['y_utm'] - $M_UTM_Y1['32T']) * $cosa);$x = ($xp * $p['32T'] ) + $Px_echelle_X1['32T'];$y = $Px_echelle_Y2['32T']-($yp * $p['32T'] );} elseif ($utm['sector'] == '30T') {// Fuseau 30 T : une rotation + translation est appliqu�e$cosa = cos(deg2rad($angle3031));$sina = sin(deg2rad($angle3031));$xp = (($utm['x_utm'] - $M_UTM_X1['30T']) * $cosa) + (($utm['y_utm'] - $M_UTM_Y1['30T']) * $sina);$yp = (-($utm['x_utm'] - $M_UTM_X1['30T']) * $sina) + (($utm['y_utm'] - $M_UTM_Y1['30T']) * $cosa);$x = ($xp * $p['30T'] ) + $Px_echelle_X1['30T'];$y = $Px_echelle_Y2['30T'] - ($yp * $p['30T'] );}$x = round($x);$y = round($y);$comment = '';if ($utm['name'] != null) {$name = utf8_decode($utm['name']);}if ($inventory['date_observation'] != '0000-00-00 00:00:00') {if ($inventory['collection_code'] == 'sophy') {$comment .= ', en '.$inventory['date_observation'];} else {list($year, $month, $day) = explode ('-',$inventory['date_observation']);list($day) = explode (' ',$day);if ($month == '00') {$comment .= ', en '.$year;} else {$comment .= ', le '.$day.'/'.$month.'/'.$year;}}}if ($inventory['collection_code'] == 'cel') {list($identifiant) = explode("@", $inventory['identifiant']);$comment .= " par ".$identifiant."@...";} else {$comment .= " par ".utf8_decode($inventory['identifiant']);}// On stocke les commentaires pour affichage dans les tooltips// Commentaire deja pr�sent ? : on ajoute � la suitelist($text, $merge) = $this->stockerCommentaire($text, $merge, $name, $comment, $inventory['collection_code'],$x,$y);}$i++;}//print_r($text);$usemap = '';$usemap_cel = '';$usemap_cenlr = '';$usemap_cbnmed = '';$usemap_sophy = '';if ($text) {foreach ($text as $coord => $origines ) {foreach ($origines as $origine => $maptext ) {$maptext = preg_replace("/\"/", "\'", $maptext);list($x,$y) = explode('|', $coord);$tpl_area = '<area shape="%s" alt="" class="tooltip" coords="%s" title="%s"/>';$rayon = 2;$type = 'circle';$coords = "$x,$y,5";$on_mouseover = "this.ttBgColor='#99C242';this.ttFontColor='#000000';this.T_OFFSETX=-200;this.T_OFFSETY=-50;this.T_STICKY=1;return escape('$maptext')";switch ($origine) {case 'FLORE - VAR': // cbnmedimagefilledellipse($img_cbnmed, $x, $y, 7, 7, $blue);$usemap_cbnmed = $usemap_cbnmed.sprintf($tpl_area, $type, $coords, $maptext);break;case 'cel':imagefilledrectangle($img_cel, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $green);$coords = ($x - $rayon).','.($y - $rayon).','.($x + $rayon).','.($y + $rayon);$usemap_cel = $usemap_cel.sprintf($tpl_area, 'rect', $coords, $maptext);break;case 'flore': // cenlrimagefilledellipse($img_cenlr, $x, $y, 7, 7, $red);$usemap_cenlr = $usemap_cenlr.sprintf($tpl_area, $type, $coords, $maptext);break;case 'sophy':imagefilledrectangle($img_sophy, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $purple);$coords = ($x - $rayon).','.($y - $rayon).','.($x + $rayon).','.($y + $rayon);$usemap_sophy = $usemap_sophy.sprintf($tpl_area, 'rect', $coords, $maptext);break;case 'tout':if (isset($merge[$coord]) && $merge[$coord]) {imagefilledrectangle($img, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $black);} elseif (isset ($text[$coord]['cel']) && ($text[$coord]['cel'])) {imagefilledrectangle($img, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $green);} elseif (isset ($text[$coord]['flore']) && ($text[$coord]['flore'])) {imagefilledrectangle($img, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $red);} elseif (isset ($text[$coord]['FLORE - VAR']) && ($text[$coord]['FLORE - VAR'])) {imagefilledrectangle($img, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $blue);} elseif (isset ($text[$coord]['sophy']) && ($text[$coord]['sophy'])) {imagefilledrectangle($img, ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $purple);}$usemap = $usemap.sprintf($tpl_area, $type, $coords, $maptext);break;}//imagestring($img, 1, $x, $y, 7, 7, "hello", $fill);// pas de double quote dans le texte}}}//imageinterlace($img,1);$qualite = 90;imagejpeg($img, Config::get('cache.stockageChemin').$dest_map, $qualite);imagejpeg($img_cel, Config::get('cache.stockageChemin').$dest_map_cel, $qualite);imagejpeg($img_cenlr, Config::get('cache.stockageChemin').$dest_map_cenlr, $qualite);imagejpeg($img_cbnmed, Config::get('cache.stockageChemin').$dest_map_cbnmed, $qualite);imagejpeg($img_sophy, Config::get('cache.stockageChemin').$dest_map_sophy, $qualite);//imagedestroy($img);$retour = '';if ($this->info['miniature'] !== 'min') {$retour.="<div id=\"descriptions\">";$retour.="<h2 id=\"titre_description_general\">Données disponibles : </h2>";$retour.= "<div id=\"description_defaut\" class=\"description\">";$retour.= "<h3 style='display:none'><span class=\"affichage\">Toutes observations</span></h3>";$retour.= "<div id =\"cartowikimap\" style=\"position:relative;\">";$retour.= "<img src=\"".(Config::get('Cartes.cel_dst').$dest_map)."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n";$retour.= "<map name=\"themap\" id=\"themap\">";$retour.= $usemap;$retour.= "</map>";$retour.= "</map>";$retour.= "</div>";$retour.= "</div>";$retour.= "<div id=\"description_1\" class=\"description\">";$retour.= "<h3 style='display:none;background-color:rgb(0,255,0);color:black;'><span class=\"affichage\">Observations issues du Carnet en ligne</span></h3>";$retour.= "<div id =\"cartowikimap\" style=\"position:relative;\">";$retour.= "<img src=\"".(Config::get('Cartes.cel_dst').$dest_map_cel)."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themapcel\"></img><br />\n";$retour.= "<map name=\"themapcel\" id=\"themapcel\">";$retour.= $usemap_cel;$retour.= "</map>";$retour.= "</div>";$retour.= "</div>";$retour.= "<div id=\"description_2\" class=\"description\">";$retour.= "<h3 style='display:none;background-color:rgb(255,0,0);color:white;'><span class=\"affichage\">Prospection flore du CEN LR</span></h3>";$retour.= "<div id =\"cartowikimapcenlr\" style=\"position:relative;\">";$retour.= "<img src=\"".(Config::get('Cartes.cel_dst').$dest_map_cenlr)."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themapcenlr\"></img><br />\n";$retour.= "<map name=\"themapcenlr\" id=\"themapcenlr\">";$retour.= $usemap_cenlr;$retour.= "</map>";$retour.= "</div>";$retour.= "</div>";$retour.= "<div id=\"description_3\" class=\"description\">";$retour.= "<h3 style='display:none;background-color:rgb(0,0,255);color:white;'><span class=\"affichage\">Flore Silene</span></h3>";$retour.= "<div id =\"cartowikimapcbnmed\" style=\"position:relative;\">";$retour.= "<img src=\"".(Config::get('Cartes.cel_dst').$dest_map_cbnmed)."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themapcbnmed\"></img><br />\n";$retour.= "<map name=\"themapcbnmed\" id=\"themapcbnmed\">";$retour.= $usemap_cbnmed;$retour.= "</map>";$retour.= "</div>";$retour.= "</div>";$retour.= "<div id=\"description_4\" class=\"description\">";$retour.= "<h3 style='display:none;background-color:rgb(255,0,255);color:white;'><span class=\"affichage\">Observations issues de la base SOPHY</span></h3>";$retour.= "<div id =\"cartowikimapsophy\" style=\"position:relative;\">";$retour.= "<img src=\"".(Config::get('Cartes.cel_dst').$dest_map_sophy)."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themapsophy\"></img><br />\n";$retour.= "<map name=\"themapsophy\" id=\"themapsophy\">";$retour.= $usemap_sophy;$retour.= "</map>";$retour.= "</div>";$retour.= "</div>";$retour.= "</div>";} else { // miniature$retour.= "<div id =\"cartowikimap\" style=\"position:relative;\">";//$retour.= "<a href=".$param['url_onglet_cel'].">"; //lien vers grande image$retour.= "<img src=\"".(Config::get('Cartes.cel_dst').$dest_map)."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themap\"></img><br />\n";//$retour.= "</a>";$retour.= "<map name=\"themap\" id=\"themap\">";$retour.= $usemap;$retour.= "</map>";$retour.= "</div>";}} else {$retour.= "<map name=\"themap\" id=\"themap\">";$retour.= "<img src=\"".Config.get('cartes.chemin').$this->src_map."\" style=\"border:none; cursor:crosshair\" alt=\"\" />\n";$retour.= "</map>";}return $retour;}/** Stockage commentaire associe a un point :** Param :* @text : texte cumule* @merge : indicateur de commentaire fusionne* @name : commune associee* @comment : commentaire* @origine : origine de la donnee*** TODO : rendre cette fonction independante des valeurs d'origine passee en parametre*/private function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y) {if ($origine == 'cel') {$prefix = 'CEL : ';} elseif ($origine == 'flore') {$prefix = 'CEN LR : ';} elseif ($origine == 'FLORE - VAR') {$prefix = 'CBN MED : ';} elseif ($origine == 'sophy') {$prefix = 'SOPHY : ';}// Cumul toute origine :if (isset($text[$x.'|'.$y]['tout']) && ($text[$x.'|'.$y])) {$text[$x.'|'.$y]['tout'] = $text[$x.'|'.$y]['tout'].'<br>'.$prefix.$name.$comment;} else {// Nouveau commentaire$text[$x.'|'.$y]['tout']=$prefix.$name.$comment;}// Deja present pour cette origine ? on ajouteif (isset ($text[$x.'|'.$y][$origine]) && ($text[$x.'|'.$y][$origine])) {$text[$x.'|'.$y][$origine] = $text[$x.'|'.$y][$origine].'<br>'.$name.$comment;} else { // Nouveau commentaire$text[$x.'|'.$y][$origine] = $name.$comment;}// Detection superposition de donneeif ($origine == 'cel') {if ((isset ($text[$x.'|'.$y]['sophy']) && ($text[$x.'|'.$y]['sophy'])) || (isset ($text[$x.'|'.$y]['flore']) && ($text[$x.'|'.$y]['flore']))|| (isset ($text[$x.'|'.$y]['FLORE - VAR']) && ($text[$x.'|'.$y]['FLORE - VAR']))) {$merge[$x.'|'.$y]=true;}} elseif ($origine == 'flore') {if ((isset ($text[$x.'|'.$y]['sophy']) && ($text[$x.'|'.$y]['sophy'])) ||(isset ($text[$x.'|'.$y]['cel']) && ($text[$x.'|'.$y]['cel'])) ||(isset ($text[$x.'|'.$y]['FLORE - VAR']) && ($text[$x.'|'.$y]['FLORE - VAR']))) {$merge[$x.'|'.$y]=true;}} elseif ($origine == 'FLORE - VAR') {if ((isset ($text[$x.'|'.$y]['sophy']) && ($text[$x.'|'.$y]['sophy'])) || (isset ($text[$x.'|'.$y]['cel']) && ($text[$x.'|'.$y]['cel'])) ||(isset ($text[$x.'|'.$y]['flore']) && ($text[$x.'|'.$y]['flore']))) {$merge[$x.'|'.$y]=true;}} elseif ($origine == 'sophy') {if ((isset ($text[$x.'|'.$y]['cel']) && ($text[$x.'|'.$y]['cel'])) || (isset ($text[$x.'|'.$y]['flore']) && ($text[$x.'|'.$y]['flore'])||(isset ($text[$x.'|'.$y]['FLORE - VAR']) && ($text[$x.'|'.$y]['FLORE - VAR'])))) {$merge[$x.'|'.$y]=true;}}return array($text, $merge);}//+------------------------------------------------------------------------------------------------------+// Méthodes d'accès aux objets du Framework/*** Méthode de connection à la base de données sur demande.* Tous les services web n'ont pas besoin de s'y connecter.*/protected function getBdd() {if (! isset($this->Bdd)) {$this->Bdd = new Bdd();}return $this->Bdd;}private function chargerVille() {$requete = "SELECT * FROM tb_cel.locations";$villes = $this->getBdd()->recupererTous($requete);foreach ($villes as $ville) {$this->tab_code_insee[$ville['insee_code']] = $ville;}}public function recupererDonnees() {// Recherche nom correspondant au numero nomenclatural en cours (pour etablir le lien avec les donnees moissonnes).// R�cuperation donn�e inventaire$queryCel = "SELECT 'cel' as collection_code, location, id_location, date_observation, "." coord_y as y_utm, coord_x as x_utm, ref_geo as sector, identifiant FROM tb_cel.cel_inventory "."WHERE num_taxon = '".$this->info['nt']."' "." AND transmission = 1";$inventoriesCel = $this->getBdd()->recupererTous($queryCel);// Recuperation des donnees de moissonage// Collection code = 'flore' (Cenlr)$queryCenlr = "SELECT collection_code, locality as location, county as id_location, "." STR_TO_DATE(concat(year, '/',month, '/',day), '%Y/%m/%d') as date_observation, latitude as y_utm , "." longitude as x_utm , max_altitude as sector, collector_name as identifiant "."FROM tb_hit_indexation.raw_occurrence_record "."WHERE scientific_name = ".$this->getBdd()->proteger($this->info['nom'])." AND collection_code = 'flore' "." AND deleted IS NULL";$inventoriesCenlr = $this->getBdd()->recupererTous($queryCenlr);// Collection code = 'FLORE - VAR' (Cbnmed)$queryCbnmed = "SELECT collection_code, locality as location, county as id_location, "." STR_TO_DATE(concat(ifnull(year,0),'/', ifnull(month,0), '/',ifnull(day,0)), '%Y/%m/%d') as date_observation, "." latitude as y_utm , longitude as x_utm , max_altitude as sector, collector_name as identifiant "."FROM tb_hit_indexation.raw_occurrence_record "."WHERE scientific_name = ".$this->getBdd()->proteger($this->info['nom'])." AND collection_code='FLORE - VAR' "." AND (deleted IS NULL OR deleted = '0000-00-00 00:00:00')";$inventoriesCbnmed = $this->getBdd()->recupererTous($queryCbnmed);// Collection code = 'sophy'$querySophy = "SELECT 'sophy' as collection_code, lieu_station_nom as location, lieu_commune_code_insee as id_location, "." observation_date as date_observation, lieu_station_utm_est as x_utm , "." lieu_station_utm_nord as y_utm , lieu_station_utm_zone as sector, observateur_nom_complet as identifiant "."FROM sophy_tapir "."WHERE nom_scientifique_complet = ".$this->getBdd()->proteger($this->info['nom_ss_auteur']);$inventoriesSophy = $this->getBdd()->recupererTous($querySophy);return array_merge($inventoriesCel, $inventoriesCenlr, $inventoriesCbnmed, $inventoriesSophy);}}?>