Rev 795 | Blame | Last modification | View Log | RSS feed
<?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);
}
}
?>