Subversion Repositories eFlore/Projets.eflore-projets

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
314 delphine 1
<?php
2
class CbnmedFormateur implements Formateur {
3
	public $dest_map = array();
4
	public $img = array();
315 delphine 5
	public function __construct($info) {
314 delphine 6
		$this->info = $info;
7
	}
8
	public function img() {
320 aurelien 9
		$qualite = 9;
10
		imagepng($this->img['cbnmed'], Config::get('cache.stockageChemin').$this->dest_map['cbnmed'], $qualite);
314 delphine 11
	}
12
	//+----------------------------------------------------------------------------------------------------------------+
13
	// Méthodes d'accès aux objets du Framework
14
	/**
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.
17
	*/
18
	protected function getBdd() {
19
	if (! isset($this->Bdd)) {
20
	$this->Bdd = new Bdd();
21
	}
22
	return $this->Bdd;
23
	}
24
 
25
	public function definirCouleurs() {
26
	// green
27
	$couleur['green'] = imagecolorallocate($this->img['cbnmed'], 0, 255, 0);
28
	// red
29
	$couleur['red'] = imagecolorallocate($this->img['cbnmed'], 255, 0, 0);
30
	// blue
31
	$couleur['blue'] = imagecolorallocate($this->img['cbnmed'], 0, 0, 255);
32
	// purple
33
	$couleur['purple'] = imagecolorallocate($this->img['cbnmed'], 255, 0, 255);
34
	// black
35
	$couleur['black'] = imagecolorallocate($this->img['cbnmed'], 0, 0, 0);
36
	return $couleur;
37
	}
38
	public function initialiserImage() {
39
		// Nom du fichier image en sortie
40
		$this->cheminCartesBase = Config::get('Cartes.chemin');
41
		$this->dest_map['cbnmed'] = 'cbnmed_nt'.$this->info['nt'].'_'.$this->info['src_map'];
320 aurelien 42
		$this->img['cbnmed'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']);
314 delphine 43
	}
44
 
362 delphine 45
	public function testerParametresProjets() {
46
		$test = true;
47
		if ($this->info['nom'] == '') {
48
			$test = false;
49
		}
50
		return $test;
51
	}
52
 
314 delphine 53
	public function chargerDonnees() {
54
		// Recherche nom correspondant au numero nomenclatural en cours (pour etablir le lien avec les donnees moissonnes).
55
		// Collection code = 'FLORE - VAR' (Cbnmed)
56
		$queryCbnmed = "SELECT collection_code, locality as id_location, county as location, ".
57
							"	STR_TO_DATE(concat(ifnull(year,0),'/', ifnull(month,0), '/',ifnull(day,0)), '%Y/%m/%d') as date_observation, ".
58
							"	latitude as y_utm , longitude as x_utm , max_altitude as sector, collector_name as identifiant ".
59
							"FROM tb_hit_indexation.raw_occurrence_record ".
60
							"WHERE scientific_name = ".$this->getBdd()->proteger($this->info['nom']).
61
							"	AND collection_code='FLORE - VAR' ".
62
							"	AND  (deleted IS NULL OR deleted = '0000-00-00 00:00:00')";
63
		$inventoriesCbnmed = $this->getBdd()->recupererTous($queryCbnmed);
64
 
65
		return $inventoriesCbnmed;
66
	}
67
 
68
 
69
	public function dessinerPoint($text, $merge, $couleurs) {
70
		$usemap['cbnmed'] = '';
71
 
72
		foreach ($text as $coord => $origines ) {
73
			foreach ($origines as $origine => $maptext ) {
74
				$maptext = preg_replace("/\"/", "\'", $maptext);
75
 
76
				list($x,$y) = explode('|', $coord);
77
 
78
				$tpl_area = '<area shape="%s" alt="" class="tooltip" coords="%s" title="%s"/>';
79
				$rayon = 2;
80
				$type = 'circle';
81
				$coords = "$x,$y,5";
82
				$on_mouseover = "this.ttBgColor='#99C242';this.ttFontColor='#000000';this.T_OFFSETX=-200;this.T_OFFSETY=-50;this.T_STICKY=1;return escape('$maptext')";
83
 
84
				imagefilledellipse($this->img['cbnmed'], $x, $y, 7, 7, $couleurs['blue']);
85
				$usemap['cbnmed'] = $usemap['cbnmed'].sprintf($tpl_area, $type, $coords, $maptext);
86
			}
87
		}
88
		return $usemap;
89
	}
90
 
91
	public function formaterCartes($usemap) {
315 delphine 92
		$retour = Config::get('Cartes.cel_dst').$this->dest_map['cbnmed'];
93
		if ($this->info['retour'] == self::MIME_MAP) {
94
			$retour =  "<img src=\"".$retour."\" style=\"border:none; ".
95
					"cursor:crosshair\" alt=\"\" usemap=\"#themap\" /><br />\n".
96
					"<map name=\"themap\" id=\"themap\">".utf8_encode($usemap['cbnmed'])."</map>";
97
		}
314 delphine 98
		return $retour;
99
	}
100
 
101
 
102
 
103
 
104
	//+----------------------------------------------------------------------------------------------------------------+
105
	// sous fonction de calculer répartition
106
	public function chercherVille($inventory, $tab_code_insee = array()) {
107
		$location_protege = $this->getBdd()->proteger($inventory['location']);
108
		$id_location_protege = $this->getBdd()->proteger($inventory['id_location']);
109
		$utm = '';
110
 
111
		if (isset($tab_code_insee[$id_location_protege])) {
112
			$utm = array(0 => $tab_code_insee[$id_location_protege]);
113
		} else {
114
			$requete = "SELECT * ".
115
						"FROM tb_cel.locations ".
116
						"WHERE insee_code = $id_location_protege ";
117
			$utm = $this->getBdd()->recupererTous($requete);
118
		}
119
		return $utm;
120
	}
121
 
122
	public function formerCommentaire($utm, $inventory) {
123
		$comment = '';
124
 
125
		if ($inventory['date_observation'] != '0000-00-00 00:00:00') {
126
			$comment .= $this->formerDate($inventory);
127
		}
128
 
129
		$comment .= " par ".utf8_decode($inventory['identifiant']);
130
		return $comment;
131
	}
132
 
133
	public function formerDate($inventory) {
134
		list($year, $month, $day) = explode ('-',$inventory['date_observation']);
135
		list($day) = explode (' ',$day);
136
		if ($month == '00') {
137
			$date = ', en '.$year;
138
		} else {
139
			$date = ', le '.$day.'/'.$month.'/'.$year;
140
		}
141
		return $date;
142
	}
143
 
144
	public function stockerCommentaire($text, $merge, $name, $comment, $origine, $x, $y) {
145
		$prefix = 'CBN MED : ';
146
 
147
		// Deja present  pour cette origine ? on ajoute
148
		if (isset ($text[$x.'|'.$y][$origine]) && ($text[$x.'|'.$y][$origine])) {
149
			$text[$x.'|'.$y][$origine] = $text[$x.'|'.$y][$origine].'<br>'.$name.$comment;
150
		} else { // Nouveau commentaire
151
			$text[$x.'|'.$y][$origine] = $name.$comment;
152
		}
153
 
154
 
155
		// Detection superposition de donnee
156
		if ((isset ($text[$x.'|'.$y]['sophy']) && ($text[$x.'|'.$y]['sophy'])) || (isset ($text[$x.'|'.$y]['cel']) && ($text[$x.'|'.$y]['cel'])) ||
157
			(isset ($text[$x.'|'.$y]['flore']) && ($text[$x.'|'.$y]['flore']))) {
158
				$merge[$x.'|'.$y]=true;
159
		}
160
 
161
		return array($text, $merge);
162
	}
163
 
164
 
165
 
166
}
167
?>