Rev 315 | Rev 362 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<?phpclass 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 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 = 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épartitionpublic 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 ajouteif (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 donneeif ($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);}}?>