WebSVN – eFlore/Projets.eflore-projets – Diff – /trunk/services/modules/0.1/eflore/cartes/GeneralFormateur.php


<?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,  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)
		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 * ".
										"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);
	}
}
?>

Subversion Repositories eFlore/Projets.eflore-projets

(root)/trunk/services/modules/0.1/eflore/cartes/GeneralFormateur.php – Rev 320 → 362

Rev 320		Rev 362
1	`<?php`	1	`<?php`
2	`class GeneralFormateur implements Formateur {`	2	`class GeneralFormateur implements Formateur {`
3	`public $dest_map = array();`	3	`public $dest_map = array();`
4	`public $img = array();`	4	`public $img = array();`
5	`public function __construct($info) {`	5	`public function __construct($info) {`
6	`$this->info = $info;`	6	`$this->info = $info;`
7	`}`	7	`}`
8	`public function img() {`	8	`public function img() {`
9	`$qualite = 9;`	9	`$qualite = 9;`
10	`imagepng($this->img['general'], Config::get('cache.stockageChemin').$this->dest_map['general'], $qualite);`	10	`imagepng($this->img['general'], Config::get('cache.stockageChemin').$this->dest_map['general'], $qualite);`
11	`}`	11	`}`
12	`//+----------------------------------------------------------------------------------------------------------------+`	12	`//+----------------------------------------------------------------------------------------------------------------+`
13	`// Méthodes d'accès aux objets du Framework`	13	`// Méthodes d'accès aux objets du Framework`
14	`/**`	14	`/**`
15	`* Méthode de connection à la base de données sur demande.`	15	`* Méthode de connection à la base de données sur demande.`
16	`* Tous les services web n'ont pas besoin de s'y connecter.`	16	`* Tous les services web n'ont pas besoin de s'y connecter.`
17	`*/`	17	`*/`
18	`protected function getBdd() {`	18	`protected function getBdd() {`
19	`if (! isset($this->Bdd)) {`	19	`if (! isset($this->Bdd)) {`
20	`$this->Bdd = new Bdd();`	20	`$this->Bdd = new Bdd();`
21	`}`	21	`}`
22	`return $this->Bdd;`	22	`return $this->Bdd;`
23	`}`	23	`}`
24		24
25	`public function definirCouleurs() {`	25	`public function definirCouleurs() {`
26	`// green`	26	`// green`
27	`$couleur['green'] = imagecolorallocate($this->img['general'], 0, 255, 0);`	27	`$couleur['green'] = imagecolorallocate($this->img['general'], 0, 255, 0);`
28	`// red`	28	`// red`
29	`$couleur['red'] = imagecolorallocate($this->img['general'], 255, 0, 0);`	29	`$couleur['red'] = imagecolorallocate($this->img['general'], 255, 0, 0);`
30	`// blue`	30	`// blue`
31	`$couleur['blue'] = imagecolorallocate($this->img['general'], 0, 0, 255);`	31	`$couleur['blue'] = imagecolorallocate($this->img['general'], 0, 0, 255);`
32	`// purple`	32	`// purple`
33	`$couleur['purple'] = imagecolorallocate($this->img['general'], 255, 0, 255);`	33	`$couleur['purple'] = imagecolorallocate($this->img['general'], 255, 0, 255);`
34	`// black`	34	`// black`
35	`$couleur['black'] = imagecolorallocate($this->img['general'], 0, 0, 0);`	35	`$couleur['black'] = imagecolorallocate($this->img['general'], 0, 0, 0);`
36	`return $couleur;`	36	`return $couleur;`
37	`}`	37	`}`
38		38
39	`public function initialiserImage() {`	39	`public function initialiserImage() {`
40	`// Nom du fichier image en sortie`	40	`// Nom du fichier image en sortie`