/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/GeneralFormateur.php |
---|
New file |
0,0 → 1,309 |
<?php |
class GeneralFormateur implements Formateur { |
public $dest_map = array(); |
public $img = array(); |
public function __construct($info) { |
$this->info = $info; |
} |
public function img() { |
$qualite = 9; |
imagepng($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'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']); |
} |
public function testerParametresProjets() { |
$test = true; |
return $test; |
} |
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. |
*/ |
if ($this->info['nt'] == 0) { |
$inventoriesCel = array(); |
} else { |
$queryCel = "SELECT 'cel' as collection_code, zone_geo as location, REPLACE(ce_zone_geo,'INSEE-C:','') as id_location, date_observation, ". |
" longitude as y_utm, latitude as x_utm, geodatum as sector, courriel_utilisateur as identifiant FROM tb_cel.cel_obs ". |
"WHERE nt = '".$this->info['nt']."' ". |
" AND transmission = 1"; |
$inventoriesCel = $this->getBdd()->recupererTous($queryCel); |
} |
// Recuperation des donnees de moissonage |
// Collection code = 'flore' (Cenlr) |
if ($this->info['nom'] == '') { |
$inventoriesCenlr = array(); |
} else { |
$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' |
if ($this->info['nom_ss_auteur'] == '') { |
$inventoriesSophy = array(); |
} else { |
$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 = Config::get('Cartes.cel_dst').$this->dest_map['general']; |
if ($this->info['retour'] == self::MIME_MAP) { |
$retour = "<img src=\"".$retour."\" style=\"border:none; ". |
"cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n". |
"<map name=\"themap\" id=\"themap\">".utf8_encode($usemap['general'])."</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 nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector ". |
"FROM tb_cel.cel_zones_geo ". |
"WHERE nom LIKE $location_protege ". |
" AND code = $id_location_protege "; |
$resultat = $this->getBdd()->recupererTous($requete); |
if ($resultat != false) { |
$utm = $resultat; |
} |
} |
} else { |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector". |
" FROM tb_cel.cel_zones_geo WHERE nom 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) { |
$date = NULL; |
if ($inventory['collection_code'] == 'sophy') { |
$date = ', en '.$inventory['date_observation']; |
} |
elseif($inventory['date_observation']) { |
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); |
} |
} |
?> |
/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/Formateur.php |
---|
New file |
0,0 → 1,32 |
<?php |
interface Formateur { |
const MIME_MAP = 'text/html'; |
const MIME_PNG = 'image/png'; |
public function __construct($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); |
} |
?> |
/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/LegendeCartes.php |
---|
New file |
0,0 → 1,113 |
<?php |
// declare(encoding='UTF-8'); |
/** |
* Gère le sous-service Legende de Cartes. |
* |
* @see http://www.tela-botanica.org/wikini/eflore/wakka.php?wiki=EfloreApi01Cartes |
* |
* @package eFlore/services |
* @author Jean-Pascal MILCENT <jpm@tela-botanica.org> |
* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt> |
* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt> |
* @version 1.0 |
* @copyright 1999-2012 Tela Botanica (accueil@tela-botanica.org) |
*/ |
// TODO : Config et Outils sont des classes statiques qui doivent poser des pb pour les tests... |
class LegendeCartes { |
private $parametres = array(); |
private $ressources = array(); |
const MIME_JSON = 'application/json'; |
const LEGENDE = '10'; |
private $formatsSupportes = array(self::MIME_JSON); |
private $tableOntologie = ''; |
private $ontologies = ''; |
private $legende = array(); |
public function __construct(Conteneur $conteneur) { |
$this->Bdd = $conteneur->getBdd(); |
$this->tableOntologie = $conteneur->getParametre('bdd_table_ontologies'); |
} |
public function consulter($ressources, $parametres) { |
//$tpsDebut = microtime(true); |
$this->parametres = $parametres; |
$this->ressources = $ressources; |
$this->definirValeurParDefautDesParametres(); |
$this->verifierParametres(); |
$resultat = $this->obtenirResultat(); |
return $resultat; |
} |
private function definirValeurParDefautDesParametres() { |
if (isset($this->parametres['retour']) == false) { |
$this->parametres['retour'] = self::MIME_JSON; |
} |
} |
private function verifierParametres() { |
$erreurs = array(); |
if (isset($this->parametres['retour']) == false) { |
$erreurs[] = "Le paramètre type de retour 'retour' est obligatoire."; |
} |
if ($this->verifierValeurParametreRetour() == false) { |
$erreurs[] = "Le type de retour '{$this->parametres['retour']}' n'est pas supporté."; |
} |
if (count($erreurs) > 0) { |
$message = implode('<br />', $erreurs); |
$code = RestServeur::HTTP_CODE_MAUVAISE_REQUETE; |
throw new Exception($message, $code); |
} |
} |
private function verifierValeurParametreRetour() { |
return in_array($this->parametres['retour'], $this->formatsSupportes); |
} |
private function obtenirResultat() { |
$this->chargerOntologies(); |
$this->chargerLegende(); |
$resultat = new ResultatService(); |
$resultat->corps = $this->legende; |
$resultat->mime = $this->parametres['retour']; |
return $resultat; |
} |
private function chargerOntologies() { |
$requete = "SELECT * FROM {$this->tableOntologie} "; |
$resultats = $this->Bdd->recupererTous($requete); |
if (!is_array($resultats) || count($resultats) <= 0) { |
$message = "Les données d'ontologies n'ont pu être chargées pour la ressource demandée"; |
$code = RestServeur::HTTP_CODE_RESSOURCE_INTROUVABLE; |
throw new Exception($message, $code); |
} |
foreach ($resultats as $ontologie) { |
$this->ontologies[$ontologie['id']] = Commun::extraireComplementsOntologies($ontologie); |
} |
} |
private function chargerLegende() { |
foreach ($this->ontologies as $ontologie) { |
if ($ontologie['classe_id'] == self::LEGENDE) { |
$this->legende[] = array( |
'code' => $ontologie['code'], |
// TODO: cf story "uniformiser le séparateur de compléments d'ontologies" |
'couleur' => @$ontologie['legende'], |
'nom' => $ontologie['nom'], |
'description' => $ontologie['description']); |
} |
} |
} |
} |
?> |
/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/SophyFormateur.php |
---|
New file |
0,0 → 1,171 |
<?php |
class SophyFormateur implements Formateur { |
public $dest_map = array(); |
public $img = array(); |
public function __construct($info) { |
$this->info = $info; |
} |
public function img() { |
$qualite = 9; |
imagepng($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 testerParametresProjets() { |
$test = true; |
if ($this->info['nom_ss_auteur'] == '') { |
$test = false; |
} |
return $test; |
} |
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 = Config::get('Cartes.cel_dst').$this->dest_map['sophy']; |
if ($this->info['retour'] == self::MIME_MAP) { |
$retour = "<img src=\"".$retour."\" style=\"border:none; ". |
"cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n". |
"<map name=\"themap\" id=\"themap\">".utf8_encode($usemap['sophy'])."</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); |
} |
} |
?> |
/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/CelFormateur.php |
---|
New file |
0,0 → 1,192 |
<?php |
class CelFormateur implements Formateur { |
public $dest_map = array(); |
public $img = array(); |
public function __construct($info) { |
$this->info = $info; |
} |
public function img() { |
$qualite = 9; |
imagepng($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'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']); |
} |
public function testerParametresProjets() { |
$test = true; |
if ($this->info['nt'] == 0) { |
$test = false; |
} |
return $test; |
} |
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, zone_geo as location, REPLACE(ce_zone_geo,'INSEE-C:','') as id_location, date_observation, ". |
" longitude as y_utm, latitude as x_utm, geodatum as sector, courriel_utilisateur as identifiant FROM tb_cel.cel_obs ". |
"WHERE nt = '".$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 = Config::get('Cartes.cel_dst').$this->dest_map['cel']; |
if ($this->info['retour'] == self::MIME_MAP) { |
$retour = "<img src=\"".$retour."\" style=\"border:none; ". |
"cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n". |
"<map name=\"themap\" id=\"themap\">".utf8_encode($usemap['cel'])."</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 nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector ". |
"FROM cel.cel_zones_geo ". |
"WHERE nom LIKE $location_protege ". |
" AND code = $id_location_protege "; |
$resultat = $this->getBdd()->recupererTous($requete); |
$utm = $resultat; |
} |
} else { |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector". |
" FROM tb_cel.cel_zones_geo WHERE nom 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); |
} |
} |
?> |
/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/CenlrFormateur.php |
---|
New file |
0,0 → 1,150 |
<?php |
class CenlrFormateur implements Formateur { |
public $dest_map = array(); |
public $img = array(); |
public function __construct($info) { |
$this->info = $info; |
} |
public function img() { |
$qualite = 9; |
imagepng($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'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']); |
} |
public function testerParametresProjets() { |
$test = true; |
if ($this->info['nom'] == '') { |
$test = false; |
} |
return $test; |
} |
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 = Config::get('Cartes.cel_dst').$this->dest_map['cenlr']; |
if ($this->info['retour'] == self::MIME_MAP) { |
$retour = "<img src=\"".$retour."\" style=\"border:none; ". |
"cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n". |
"<map name=\"themap\" id=\"themap\">".utf8_encode($usemap['cenlr'])."</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); |
} |
} |
?> |
/branches/v5.5-arbousiere/services/modules/0.1/eflore/cartes/CbnmedFormateur.php |
---|
New file |
0,0 → 1,167 |
<?php |
class CbnmedFormateur implements Formateur { |
public $dest_map = array(); |
public $img = array(); |
public function __construct($info) { |
$this->info = $info; |
} |
public function img() { |
$qualite = 9; |
imagepng($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'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']); |
} |
public function testerParametresProjets() { |
$test = true; |
if ($this->info['nom'] == '') { |
$test = false; |
} |
return $test; |
} |
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 = Config::get('Cartes.cel_dst').$this->dest_map['cbnmed']; |
if ($this->info['retour'] == self::MIME_MAP) { |
$retour = "<img src=\"".$retour."\" style=\"border:none; ". |
"cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n". |
"<map name=\"themap\" id=\"themap\">".utf8_encode($usemap['cbnmed'])."</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); |
} |
} |
?> |