| /trunk/services/modules/0.1/eflore/cartes/SophyFormateur.php |
|---|
| New file |
| 0,0 → 1,166 |
| <?php |
| class SophyFormateur implements Formateur { |
| public $dest_map = array(); |
| public $img = array(); |
| public function __construct($parametres, $info) { |
| $this->param = $parametres; |
| $this->info = $info; |
| } |
| public function img() { |
| $qualite = 90; |
| imagejpeg($this->img['sophy'], Config::get('cache.stockageChemin').$this->dest_map['sophy'], $qualite); |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // 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; |
| } |
| public function definirCouleurs() { |
| // purple |
| $couleur['purple'] = imagecolorallocate($this->img['sophy'], 255, 0, 255); |
| return $couleur; |
| } |
| public function initialiserImage() { |
| // Nom du fichier image en sortie |
| $this->cheminCartesBase = Config::get('Cartes.chemin'); |
| $this->dest_map['sophy'] = 'sophy_nt'.$this->info['nt'].'_'.$this->info['src_map']; |
| $this->img['sophy'] = imagecreatefromjpeg($this->cheminCartesBase.$this->info['src_map']); |
| } |
| public function chargerDonnees() { |
| // 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']). |
| " AND lieu_commune_code_insee != '' group by `nom_scientifique_complet`,`lieu_commune_code_insee`, `lieu_station_nom`"; |
| $inventoriesSophy = $this->getBdd()->recupererTous($querySophy); |
| return $inventoriesSophy; |
| } |
| public function dessinerPoint($text, $merge, $couleurs) { |
| $usemap['sophy'] = ''; |
| 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')"; |
| imagefilledrectangle($this->img['sophy'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['purple']); |
| $coords = ($x - $rayon).','.($y - $rayon).','.($x + $rayon).','.($y + $rayon); |
| $usemap['sophy'] = $usemap['sophy'].sprintf($tpl_area, 'rect', $coords, $maptext); |
| } |
| } |
| return $usemap; |
| } |
| public function formaterCartes($usemap) { |
| $retour= "<img src=\"".(Config::get('Cartes.cel_dst').$this->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>"; |
| return $retour; |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // sous fonction de calculer répartition |
| public function chercherVille($inventory, $tab_code_insee = array()) { |
| $utm = ''; |
| if (strpos($inventory['id_location'], '20') === 0) { |
| $a = str_replace('20', '2A', $inventory['id_location']); |
| if (isset($tab_code_insee[$a])) { |
| $utm = array(0 => $tab_code_insee[$a]); |
| } else { |
| $b = str_replace('20', '2B', $inventory['id_location']); |
| if (isset($tab_code_insee[$b])) { |
| $utm = array(0 => $tab_code_insee[$b]); |
| } |
| } |
| } elseif (isset($tab_code_insee[$inventory['id_location']])) { |
| $utm = array(0 => $tab_code_insee[$inventory['id_location']]); |
| } elseif (strpos($inventory['id_location'], '000') === 2) { |
| $code = $this->getBdd()->proteger(str_replace('000', '', $inventory['id_location'])); |
| $requete = "SELECT chef_lieu ". |
| "FROM tb_eflore.insee_d_v2011 ". |
| "WHERE dep = $code "; |
| $resultat = $this->getBdd()->recupererTous($requete); |
| if ($resultat != array() && isset($tab_code_insee[$resultat[0]['chef_lieu']])) { |
| $utm = $tab_code_insee[$resultat[0]['chef_lieu']]; |
| } |
| } |
| return $utm; |
| } |
| public function formerCommentaire($utm, $inventory) { |
| $comment = ''; |
| if ($inventory['date_observation'] != '0000-00-00 00:00:00') { |
| $comment .= $this->formerDate($inventory); |
| } |
| $comment .= " par ".utf8_decode($inventory['identifiant']); |
| return $comment; |
| } |
| public function formerDate($inventory) { |
| $date = ', en '.$inventory['date_observation']; |
| return $date; |
| } |
| /* |
| * 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 |
| */ |
| public function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y) { |
| $prefix = 'SOPHY : '; |
| // Deja present pour cette origine ? on ajoute |
| if (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; |
| } |
| 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); |
| } |
| } |
| ?> |
| /trunk/services/modules/0.1/eflore/cartes/CelFormateur.php |
|---|
| New file |
| 0,0 → 1,183 |
| <?php |
| class CelFormateur implements Formateur { |
| public $dest_map = array(); |
| public $img = array(); |
| public function __construct($parametres, $info) { |
| $this->param = $parametres; |
| $this->info = $info; |
| } |
| public function img() { |
| $qualite = 90; |
| imagejpeg($this->img['cel'], Config::get('cache.stockageChemin').$this->dest_map['cel'], $qualite); |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // 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; |
| } |
| public function definirCouleurs() { |
| // green |
| $couleurs['green'] = imagecolorallocate($this->img['cel'], 0, 255, 0); |
| return $couleurs; |
| } |
| public function initialiserImage() { |
| // Nom du fichier image en sortie |
| $this->cheminCartesBase = Config::get('Cartes.chemin'); |
| $this->dest_map['cel'] = 'cel_nt'.$this->info['nt'].'_'.$this->info['src_map']; |
| $this->img['cel'] = imagecreatefromjpeg($this->cheminCartesBase.$this->info['src_map']); |
| } |
| public function chargerDonnees() { |
| // Recherche nom correspondant au numero nomenclatural en cours (pour etablir le lien avec les donnees moissonnes). |
| // R�cuperation donn�e inventaire |
| /* |
| * 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. |
| */ |
| $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); |
| return $inventoriesCel; |
| } |
| public function dessinerPoint($text, $merge, $couleurs) { |
| $usemap['cel'] = ''; |
| 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')"; |
| imagefilledrectangle($this->img['cel'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['green']); |
| $coords = ($x - $rayon).','.($y - $rayon).','.($x + $rayon).','.($y + $rayon); |
| $usemap['cel'] = $usemap['cel'].sprintf($tpl_area, 'rect', $coords, $maptext); |
| } |
| } |
| return $usemap; |
| } |
| public function formaterCartes($usemap) { |
| $retour= "<img src=\"".(Config::get('Cartes.cel_dst').$this->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>"; |
| return $retour; |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // sous fonction de calculer répartition |
| public function chercherVille($inventory, $tab_code_insee = array()) { |
| $location_protege = $this->getBdd()->proteger($inventory['location']); |
| $id_location_protege = $this->getBdd()->proteger($inventory['id_location']); |
| $utm = array(); |
| if ($inventory['id_location'] != 'null') { |
| if (isset($tab_code_insee) & in_array($inventory['id_location'], $tab_code_insee)) { |
| $utm = array(0 => $this->tab_code_insee[$id_location_protege]); |
| } else { |
| $requete = "SELECT * ". |
| "FROM tb_cel.locations ". |
| "WHERE name LIKE $location_protege ". |
| " AND code = $id_location_protege "; |
| $resultat = $this->getBdd()->recupererTous($requete); |
| $utm = $resultat; |
| } |
| } else { |
| $requete = "SELECT * FROM tb_cel.locations WHERE name LIKE $location_protege "; |
| $utm = $this->getBdd()->recupererTous($requete); |
| } |
| return $utm; |
| } |
| public function formerCommentaire($utm, $inventory) { |
| $comment = ''; |
| if ($inventory['date_observation'] != '0000-00-00 00:00:00') { |
| $comment .= $this->formerDate($inventory); |
| } |
| list($identifiant) = explode("@", $inventory['identifiant']); |
| $comment .= " par ".$identifiant."@..."; |
| return $comment; |
| } |
| public function formerDate($inventory) { |
| list($year, $month, $day) = explode ('-',$inventory['date_observation']); |
| list($day) = explode (' ',$day); |
| if ($month == '00') { |
| $date = ', en '.$year; |
| } else { |
| $date = ', le '.$day.'/'.$month.'/'.$year; |
| } |
| return $date; |
| } |
| /* |
| * 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 |
| */ |
| public function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y) { |
| $prefix = 'CEL : '; |
| // 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 ajoute |
| if (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 donnee |
| 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; |
| } |
| return array($text, $merge); |
| } |
| } |
| ?> |
| /trunk/services/modules/0.1/eflore/cartes/CenlrFormateur.php |
|---|
| New file |
| 0,0 → 1,142 |
| <?php |
| class CenlrFormateur implements Formateur { |
| public $dest_map = array(); |
| public $img = array(); |
| public function __construct($parametres, $info) { |
| $this->param = $parametres; |
| $this->info = $info; |
| } |
| public function img() { |
| $qualite = 90; |
| imagejpeg($this->img['cenlr'], Config::get('cache.stockageChemin').$this->dest_map['cenlr'], $qualite); |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // 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; |
| } |
| public function definirCouleurs() { |
| // green |
| $couleur['green'] = imagecolorallocate($this->img['cenlr'], 0, 255, 0); |
| // red |
| $couleur['red'] = imagecolorallocate($this->img['cenlr'], 255, 0, 0); |
| // blue |
| $couleur['blue'] = imagecolorallocate($this->img['cenlr'], 0, 0, 255); |
| // purple |
| $couleur['purple'] = imagecolorallocate($this->img['cenlr'], 255, 0, 255); |
| // black |
| $couleur['black'] = imagecolorallocate($this->img['cenlr'], 0, 0, 0); |
| return $couleur; |
| } |
| public function initialiserImage() { |
| // Nom du fichier image en sortie |
| $this->cheminCartesBase = Config::get('Cartes.chemin'); |
| $this->dest_map['cenlr'] = 'cenlr_nt'.$this->info['nt'].'_'.$this->info['src_map']; |
| $this->img['cenlr'] = imagecreatefromjpeg($this->cheminCartesBase.$this->info['src_map']); |
| } |
| public function chargerDonnees() { |
| // 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 OR deleted = '0000-00-00 00:00:00')"; |
| $inventoriesCenlr = $this->getBdd()->recupererTous($queryCenlr); |
| return $inventoriesCenlr; |
| } |
| public function dessinerPoint($text, $merge, $couleurs) { |
| $usemap['cenlr'] = ''; |
| 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')"; |
| imagefilledellipse($this->img['cenlr'], $x, $y, 7, 7, $couleurs['red']); |
| $usemap['cenlr'] = $usemap['cenlr'].sprintf($tpl_area, $type, $coords, $maptext); |
| } |
| } |
| return $usemap; |
| } |
| public function formaterCartes($usemap) { |
| $retour = "<img src=\"".(Config::get('Cartes.cel_dst').$this->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>"; |
| return $retour; |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // sous fonction de calculer répartition |
| public function chercherVille($inventory, $tab_code_insee = array()) { |
| return $utm = ''; |
| } |
| public function formerCommentaire($utm, $inventory) { |
| $comment = ''; |
| if ($inventory['date_observation'] != '0000-00-00 00:00:00') { |
| $comment .= $this->formerDate($inventory); |
| } |
| $comment .= " par ".utf8_decode($inventory['identifiant']); |
| return $comment; |
| } |
| public function formerDate($inventory) { |
| list($year, $month, $day) = explode ('-',$inventory['date_observation']); |
| list($day) = explode (' ',$day); |
| if ($month == '00') { |
| $date = ', en '.$year; |
| } else { |
| $date = ', le '.$day.'/'.$month.'/'.$year; |
| } |
| return $date; |
| } |
| public function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y) { |
| $prefix = 'CEN LR : '; |
| // Deja present pour cette origine ? on ajoute |
| if (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 donnee |
| 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; |
| } |
| return array($text, $merge); |
| } |
| } |
| ?> |
| /trunk/services/modules/0.1/eflore/cartes/CbnmedFormateur.php |
|---|
| New file |
| 0,0 → 1,159 |
| <?php |
| class CbnmedFormateur implements Formateur { |
| public $dest_map = array(); |
| public $img = array(); |
| public function __construct($parametres, $info) { |
| $this->param = $parametres; |
| $this->info = $info; |
| } |
| public function img() { |
| $qualite = 90; |
| imagejpeg($this->img['cbnmed'], Config::get('cache.stockageChemin').$this->dest_map['cbnmed'], $qualite); |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // 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; |
| } |
| public function definirCouleurs() { |
| // green |
| $couleur['green'] = imagecolorallocate($this->img['cbnmed'], 0, 255, 0); |
| // red |
| $couleur['red'] = imagecolorallocate($this->img['cbnmed'], 255, 0, 0); |
| // blue |
| $couleur['blue'] = imagecolorallocate($this->img['cbnmed'], 0, 0, 255); |
| // purple |
| $couleur['purple'] = imagecolorallocate($this->img['cbnmed'], 255, 0, 255); |
| // black |
| $couleur['black'] = imagecolorallocate($this->img['cbnmed'], 0, 0, 0); |
| return $couleur; |
| } |
| public function initialiserImage() { |
| // Nom du fichier image en sortie |
| $this->cheminCartesBase = Config::get('Cartes.chemin'); |
| $this->dest_map['cbnmed'] = 'cbnmed_nt'.$this->info['nt'].'_'.$this->info['src_map']; |
| $this->img['cbnmed'] = imagecreatefromjpeg($this->cheminCartesBase.$this->info['src_map']); |
| } |
| public function chargerDonnees() { |
| // Recherche nom correspondant au numero nomenclatural en cours (pour etablir le lien avec les donnees moissonnes). |
| // Collection code = 'FLORE - VAR' (Cbnmed) |
| $queryCbnmed = "SELECT collection_code, locality as id_location, county as 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); |
| return $inventoriesCbnmed; |
| } |
| public function dessinerPoint($text, $merge, $couleurs) { |
| $usemap['cbnmed'] = ''; |
| 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')"; |
| imagefilledellipse($this->img['cbnmed'], $x, $y, 7, 7, $couleurs['blue']); |
| $usemap['cbnmed'] = $usemap['cbnmed'].sprintf($tpl_area, $type, $coords, $maptext); |
| } |
| } |
| return $usemap; |
| } |
| public function formaterCartes($usemap) { |
| $retour= "<img src=\"".(Config::get('Cartes.cel_dst').$this->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>"; |
| return $retour; |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // sous fonction de calculer répartition |
| public function chercherVille($inventory, $tab_code_insee = array()) { |
| $location_protege = $this->getBdd()->proteger($inventory['location']); |
| $id_location_protege = $this->getBdd()->proteger($inventory['id_location']); |
| $utm = ''; |
| if (isset($tab_code_insee[$id_location_protege])) { |
| $utm = array(0 => $tab_code_insee[$id_location_protege]); |
| } else { |
| $requete = "SELECT * ". |
| "FROM tb_cel.locations ". |
| "WHERE insee_code = $id_location_protege "; |
| $utm = $this->getBdd()->recupererTous($requete); |
| } |
| return $utm; |
| } |
| public function formerCommentaire($utm, $inventory) { |
| $comment = ''; |
| if ($inventory['date_observation'] != '0000-00-00 00:00:00') { |
| $comment .= $this->formerDate($inventory); |
| } |
| $comment .= " par ".utf8_decode($inventory['identifiant']); |
| return $comment; |
| } |
| public function formerDate($inventory) { |
| list($year, $month, $day) = explode ('-',$inventory['date_observation']); |
| list($day) = explode (' ',$day); |
| if ($month == '00') { |
| $date = ', en '.$year; |
| } else { |
| $date = ', le '.$day.'/'.$month.'/'.$year; |
| } |
| return $date; |
| } |
| public function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y) { |
| $prefix = 'CBN MED : '; |
| // Deja present pour cette origine ? on ajoute |
| if (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 donnee |
| 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; |
| } |
| return array($text, $merge); |
| } |
| } |
| ?> |
| /trunk/services/modules/0.1/eflore/cartes/GeneralFormateur.php |
|---|
| New file |
| 0,0 → 1,300 |
| <?php |
| class GeneralFormateur { |
| public $dest_map = array(); |
| public $img = array(); |
| public function __construct($parametres, $info) { |
| $this->param = $parametres; |
| $this->info = $info; |
| } |
| public function img() { |
| $qualite = 90; |
| imagejpeg($this->img['general'], Config::get('cache.stockageChemin').$this->dest_map['general'], $qualite); |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // 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; |
| } |
| public function definirCouleurs() { |
| // green |
| $couleur['green'] = imagecolorallocate($this->img['general'], 0, 255, 0); |
| // red |
| $couleur['red'] = imagecolorallocate($this->img['general'], 255, 0, 0); |
| // blue |
| $couleur['blue'] = imagecolorallocate($this->img['general'], 0, 0, 255); |
| // purple |
| $couleur['purple'] = imagecolorallocate($this->img['general'], 255, 0, 255); |
| // black |
| $couleur['black'] = imagecolorallocate($this->img['general'], 0, 0, 0); |
| return $couleur; |
| } |
| public function initialiserImage() { |
| // Nom du fichier image en sortie |
| $this->cheminCartesBase = Config::get('Cartes.chemin'); |
| $this->dest_map['general'] = 'nt'.$this->info['nt'].'_'.$this->info['src_map']; |
| $this->img['general'] = imagecreatefromjpeg($this->cheminCartesBase.$this->info['src_map']); |
| } |
| public function chargerDonnees() { |
| // Recherche nom correspondant au numero nomenclatural en cours (pour etablir le lien avec les donnees moissonnes). |
| // R�cuperation donn�e inventaire |
| /* |
| * 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. |
| */ |
| $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 OR deleted = '0000-00-00 00:00:00')"; |
| $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, $inventoriesSophy); //$inventoriesCbnmed, |
| } |
| public function dessinerPoint($text, $merge, $couleurs) { |
| $usemap['general'] = ''; |
| 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')"; |
| if (isset($merge[$coord]) && $merge[$coord]) { |
| imagefilledrectangle($this->img['general'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['black']); |
| } elseif (isset ($text[$coord]['cel']) && ($text[$coord]['cel'])) { |
| imagefilledrectangle($this->img['general'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['green']); |
| } elseif (isset ($text[$coord]['flore']) && ($text[$coord]['flore'])) { |
| imagefilledrectangle($this->img['general'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['red']); |
| }/* elseif (isset ($text[$coord]['FLORE - VAR']) && ($text[$coord]['FLORE - VAR'])) { |
| imagefilledrectangle($this->img['general'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['blue']); |
| }*/ elseif (isset ($text[$coord]['sophy']) && ($text[$coord]['sophy'])) { |
| imagefilledrectangle($this->img['general'], ($x - $rayon), ($y - $rayon), ($x + $rayon), ($y + $rayon), $couleurs['purple']); |
| } |
| $usemap['general'] = $usemap['general'].sprintf($tpl_area, $type, $coords, $maptext); |
| } |
| } |
| return $usemap; |
| } |
| public function formaterCartes($usemap) { |
| $retour = "<img src=\"".(Config::get('Cartes.cel_dst').$this->dest_map['general'])."\" style=\"border:none; cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n"; |
| $retour .= "<map name=\"themap\" id=\"themap\">"; |
| $retour .= $usemap['general']; |
| $retour .= "</map>"; |
| return $retour; |
| } |
| public function formaterCarteMiniature($retour, $usemap) { |
| $retour['image'] = Config::get('Cartes.cel_dst').$this->dest_map['general']; |
| $retour['map'] = $usemap['general']; |
| if (isset($this->param['retour']) && $this->param['retour'] == 'htm') { |
| $retour['image'] = "<img src=\"".$retour['image']."\" style=\"border:none; cursor:crosshair\"" |
| ."alt=\"\" usemap=\"#themap\"></img><br />\n"; |
| $retour['map'] = "<map name=\"themap\" id=\"themap\">".$retour['map']."</map>"; |
| } |
| return $retour; |
| } |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // sous fonction de calculer répartition |
| public function chercherVille($inventory, $tab_code_insee = array()) { |
| $location_protege = $this->getBdd()->proteger($inventory['location']); |
| $id_location_protege = '"'.$inventory['id_location'].'"'; |
| $utm = array(); |
| if ($inventory['collection_code'] == 'FLORE - VAR') { |
| if (isset($tab_code_insee[$location_protege])) { |
| $utm = array(0 => $tab_code_insee[$location_protege]); |
| } |
| } elseif ($inventory['collection_code'] == 'sophy') { |
| if (strpos($inventory['id_location'], '20') === 0) { |
| $a = str_replace('20', '2A', $inventory['id_location']); |
| if (isset($tab_code_insee[$a])) { |
| $utm = array(0 => $tab_code_insee[$a]); |
| } else { |
| $b = str_replace('20', '2B', $inventory['id_location']); |
| if (isset($tab_code_insee[$b])) { |
| $utm = array(0 => $tab_code_insee[$b]); |
| } |
| } |
| } elseif (isset($tab_code_insee[$inventory['id_location']])) { |
| $utm = array(0 => $tab_code_insee[$inventory['id_location']]); |
| } elseif (strpos($inventory['id_location'], '000') === 2) { |
| $code = $this->getBdd()->proteger(str_replace('000', '', $inventory['id_location'])); |
| $requete = "SELECT chef_lieu ". |
| "FROM tb_eflore.insee_d_v2011 ". |
| "WHERE dep = $code "; |
| $resultat = $this->getBdd()->recupererTous($requete); |
| if ($resultat != array() && isset($tab_code_insee[$resultat[0]['chef_lieu']])) { |
| $utm = $tab_code_insee[$resultat[0]['chef_lieu']]; |
| } |
| } |
| } else { |
| if ($inventory['id_location'] != 'null') { |
| if (isset($tab_code_insee[$id_location_protege])) { |
| $utm = array(0 => $tab_code_insee[$id_location_protege]); |
| } else { |
| $requete = "SELECT * ". |
| "FROM tb_cel.locations ". |
| "WHERE name LIKE $location_protege ". |
| " AND code = $id_location_protege "; |
| $resultat = $this->getBdd()->recupererTous($requete); |
| $utm = $resultat; |
| } |
| } else { |
| $requete = "SELECT * FROM tb_cel.locations WHERE name LIKE $location_protege "; |
| $utm = $this->getBdd()->recupererTous($requete); |
| } |
| } |
| return $utm; |
| } |
| public function formerCommentaire($utm, $inventory) { |
| $comment = ''; |
| if ($inventory['date_observation'] != '0000-00-00 00:00:00') { |
| $comment .= $this->formerDate($inventory); |
| } |
| if ($inventory['collection_code'] == 'cel') { |
| list($identifiant) = explode("@", $inventory['identifiant']); |
| $comment .= " par ".$identifiant."@..."; |
| } else { |
| $comment .= " par ".utf8_decode($inventory['identifiant']); |
| } |
| return $comment; |
| } |
| public function formerDate($inventory) { |
| if ($inventory['collection_code'] == 'sophy') { |
| $date = ', en '.$inventory['date_observation']; |
| } else { |
| list($year, $month, $day) = explode ('-',$inventory['date_observation']); |
| list($day) = explode (' ',$day); |
| if ($month == '00') { |
| $date = ', en '.$year; |
| } else { |
| $date = ', le '.$day.'/'.$month.'/'.$year; |
| } |
| } |
| return $date; |
| } |
| /* |
| * 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 |
| */ |
| public 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 ajoute |
| if (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 donnee |
| if ($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); |
| } |
| } |
| ?> |
| /trunk/services/modules/0.1/eflore/cartes/Formateur.php |
|---|
| New file |
| 0,0 → 1,30 |
| <?php |
| interface Formateur { |
| public function __construct($parametres, $info); |
| public function initialiserImage(); |
| public function chargerDonnees(); |
| public function dessinerPoint($text, $merge, $couleurs); |
| public function formaterCartes($usemap); |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // sous fonction de calculer répartition |
| public function chercherVille($inventory, $tab_code_insee = array()); |
| public function formerCommentaire($utm, $inventory); |
| public function formerDate($inventory); |
| /* |
| * 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 |
| */ |
| public function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y); |
| } |
| ?> |