| Line 41... |
Line 41... |
| 41 |
$this->cheminCartesBase = Config::get('Cartes.chemin');
|
41 |
$this->cheminCartesBase = Config::get('Cartes.chemin');
|
| 42 |
$this->dest_map['general'] = 'nt'.$this->info['nt'].'_'.$this->info['src_map'];
|
42 |
$this->dest_map['general'] = 'nt'.$this->info['nt'].'_'.$this->info['src_map'];
|
| 43 |
$this->img['general'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']);
|
43 |
$this->img['general'] = imagecreatefrompng($this->cheminCartesBase.$this->info['src_map']);
|
| 44 |
}
|
44 |
}
|
| Line -... |
Line 45... |
| - |
|
45 |
|
| - |
|
46 |
public function testerParametresProjets() {
|
| - |
|
47 |
$test = true;
|
| - |
|
48 |
return $test;
|
| Line 45... |
Line 49... |
| 45 |
|
49 |
}
|
| 46 |
|
50 |
|
| Line 47... |
Line 51... |
| 47 |
public function chargerDonnees() {
|
51 |
public function chargerDonnees() {
|
| Line 53... |
Line 57... |
| 53 |
* - pour l'instant le service de moissonage n'est pas automatise et donc il y a un decalage dans l'affichage des donnees transmises
|
57 |
* - pour l'instant le service de moissonage n'est pas automatise et donc il y a un decalage dans l'affichage des donnees transmises
|
| 54 |
* - 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)
|
58 |
* - 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)
|
| 55 |
*
|
59 |
*
|
| 56 |
* A terme, utilser vraiment le moissonage, y compris pour les donnees issues du CEL, en utilisant ABCD et en modifiant le programme d'harvesting.
|
60 |
* A terme, utilser vraiment le moissonage, y compris pour les donnees issues du CEL, en utilisant ABCD et en modifiant le programme d'harvesting.
|
| 57 |
*/
|
61 |
*/
|
| - |
|
62 |
if ($this->info['nt'] == 0) {
|
| - |
|
63 |
$inventoriesCel = array();
|
| - |
|
64 |
} else {
|
| 58 |
$queryCel = "SELECT 'cel' as collection_code, location, id_location, date_observation, ".
|
65 |
$queryCel = "SELECT 'cel' as collection_code, location, id_location, date_observation, ".
|
| 59 |
" coord_y as y_utm, coord_x as x_utm, ref_geo as sector, identifiant FROM tb_cel.cel_inventory ".
|
66 |
" coord_y as y_utm, coord_x as x_utm, ref_geo as sector, identifiant FROM tb_cel.cel_inventory ".
|
| 60 |
"WHERE num_taxon = '".$this->info['nt']."' ".
|
67 |
"WHERE num_taxon = '".$this->info['nt']."' ".
|
| 61 |
" AND transmission = 1";
|
68 |
" AND transmission = 1";
|
| 62 |
$inventoriesCel = $this->getBdd()->recupererTous($queryCel);
|
69 |
$inventoriesCel = $this->getBdd()->recupererTous($queryCel);
|
| - |
|
70 |
}
|
| Line 63... |
Line 71... |
| 63 |
|
71 |
|
| 64 |
// Recuperation des donnees de moissonage
|
72 |
// Recuperation des donnees de moissonage
|
| - |
|
73 |
// Collection code = 'flore' (Cenlr)
|
| - |
|
74 |
if ($this->info['nom'] == '') {
|
| - |
|
75 |
$inventoriesCenlr = array();
|
| 65 |
// Collection code = 'flore' (Cenlr)
|
76 |
} else {
|
| 66 |
$queryCenlr = "SELECT collection_code, locality as location, county as id_location, ".
|
77 |
$queryCenlr = "SELECT collection_code, locality as location, county as id_location, ".
|
| 67 |
" STR_TO_DATE(concat(year, '/',month, '/',day), '%Y/%m/%d') as date_observation, latitude as y_utm , ".
|
78 |
" STR_TO_DATE(concat(year, '/',month, '/',day), '%Y/%m/%d') as date_observation, latitude as y_utm , ".
|
| 68 |
" longitude as x_utm , max_altitude as sector, collector_name as identifiant ".
|
79 |
" longitude as x_utm , max_altitude as sector, collector_name as identifiant ".
|
| 69 |
"FROM tb_hit_indexation.raw_occurrence_record ".
|
80 |
"FROM tb_hit_indexation.raw_occurrence_record ".
|
| 70 |
"WHERE scientific_name = ".$this->getBdd()->proteger($this->info['nom']).
|
81 |
"WHERE scientific_name = ".$this->getBdd()->proteger($this->info['nom']).
|
| 71 |
" AND collection_code = 'flore' ".
|
82 |
" AND collection_code = 'flore' ".
|
| 72 |
" AND (deleted IS NULL OR deleted = '0000-00-00 00:00:00')";
|
83 |
" AND (deleted IS NULL OR deleted = '0000-00-00 00:00:00')";
|
| 73 |
$inventoriesCenlr = $this->getBdd()->recupererTous($queryCenlr);
|
84 |
$inventoriesCenlr = $this->getBdd()->recupererTous($queryCenlr);
|
| Line 74... |
Line 85... |
| 74 |
|
85 |
}
|
| 75 |
|
86 |
|
| 76 |
// Collection code = 'FLORE - VAR' (Cbnmed)
|
87 |
// Collection code = 'FLORE - VAR' (Cbnmed)
|
| 77 |
/*$queryCbnmed = "SELECT collection_code, locality as location, county as id_location, ".
|
88 |
/*$queryCbnmed = "SELECT collection_code, locality as location, county as id_location, ".
|
| Line 82... |
Line 93... |
| 82 |
" AND collection_code='FLORE - VAR' ".
|
93 |
" AND collection_code='FLORE - VAR' ".
|
| 83 |
" AND (deleted IS NULL OR deleted = '0000-00-00 00:00:00')";
|
94 |
" AND (deleted IS NULL OR deleted = '0000-00-00 00:00:00')";
|
| 84 |
$inventoriesCbnmed = $this->getBdd()->recupererTous($queryCbnmed);*/
|
95 |
$inventoriesCbnmed = $this->getBdd()->recupererTous($queryCbnmed);*/
|
| Line 85... |
Line 96... |
| 85 |
|
96 |
|
| - |
|
97 |
// Collection code = 'sophy'
|
| - |
|
98 |
if ($this->info['nom_ss_auteur'] == '') {
|
| - |
|
99 |
$inventoriesSophy = array();
|
| 86 |
// Collection code = 'sophy'
|
100 |
} else {
|
| 87 |
$querySophy = "SELECT 'sophy' as collection_code, lieu_station_nom as location, lieu_commune_code_insee as id_location, ".
|
101 |
$querySophy = "SELECT 'sophy' as collection_code, lieu_station_nom as location, lieu_commune_code_insee as id_location, ".
|
| 88 |
" observation_date as date_observation, lieu_station_utm_est as x_utm , ".
|
102 |
" observation_date as date_observation, lieu_station_utm_est as x_utm , ".
|
| 89 |
" lieu_station_utm_nord as y_utm , lieu_station_utm_zone as sector, observateur_nom_complet as identifiant ".
|
103 |
" lieu_station_utm_nord as y_utm , lieu_station_utm_zone as sector, observateur_nom_complet as identifiant ".
|
| 90 |
"FROM sophy_tapir ".
|
104 |
"FROM sophy_tapir ".
|
| 91 |
"WHERE nom_scientifique_complet = ".$this->getBdd()->proteger($this->info['nom_ss_auteur']);
|
105 |
"WHERE nom_scientifique_complet = ".$this->getBdd()->proteger($this->info['nom_ss_auteur']);
|
| - |
|
106 |
$inventoriesSophy = $this->getBdd()->recupererTous($querySophy);
|
| Line 92... |
Line 107... |
| 92 |
$inventoriesSophy = $this->getBdd()->recupererTous($querySophy);
|
107 |
}
|
| 93 |
|
108 |
|