| Line 146... |
Line 146... |
| 146 |
} else {
|
146 |
} else {
|
| 147 |
$this->info['projet'] = 'general';
|
147 |
$this->info['projet'] = 'general';
|
| 148 |
}
|
148 |
}
|
| 149 |
// Récupération d'infos générales
|
149 |
// Récupération d'infos générales
|
| 150 |
// donnees exemple nn = 141; nt = 8522; nom = 'Acer campestre L.'; nom_ss_auteur = 'Acer campestre';
|
150 |
// donnees exemple nn = 141; nt = 8522; nom = 'Acer campestre L.'; nom_ss_auteur = 'Acer campestre';
|
| 151 |
$this->info['nn'] = $this->param['masque.nn'];
|
151 |
$this->info['nn'] = @$this->param['masque.nn'];
|
| 152 |
$this->info['nt'] = $this->param['masque.nt'];
|
152 |
$this->info['nt'] = @$this->param['masque.nt'];
|
| 153 |
$this->info['nom'] = $this->param['masque.ns'].' '.$this->param['masque.au'];
|
153 |
$this->info['nom'] = @$this->param['masque.ns'].' '.@$this->param['masque.au'];
|
| 154 |
$this->info['nom_ss_auteur'] = $this->param['masque.ns'];
|
154 |
$this->info['nom_ss_auteur'] = @$this->param['masque.ns'];
|
| 155 |
}
|
155 |
}
|
| Line 156... |
Line 156... |
| 156 |
|
156 |
|
| 157 |
private function chargerVille() {
|
157 |
private function chargerVille() {
|
| 158 |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector".
|
158 |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector".
|
| Line 178... |
Line 178... |
| 178 |
foreach ($inventories as $inventory){
|
178 |
foreach ($inventories as $inventory){
|
| 179 |
$utm = $this->cartesFormateur->chercherVille($inventory, $this->tab_code_insee);
|
179 |
$utm = $this->cartesFormateur->chercherVille($inventory, $this->tab_code_insee);
|
| 180 |
// Ultime tentative
|
180 |
// Ultime tentative
|
| 181 |
if (!$utm) {
|
181 |
if (!$utm) {
|
| 182 |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector".
|
182 |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector".
|
| 183 |
" FROM tb_cel.cel_zones_geo WHERE name LIKE ".$this->getBdd()->proteger($inventory['location']);
|
183 |
" FROM tb_cel.cel_zones_geo WHERE nom LIKE ".$this->getBdd()->proteger($inventory['location']);
|
| 184 |
$utm = $this->getBdd()->recupererTous($requete);
|
184 |
$utm = $this->getBdd()->recupererTous($requete);
|
| 185 |
}
|
185 |
}
|
| Line 186... |
Line 186... |
| 186 |
|
186 |
|
| 187 |
// Si des doublons sur la commune : pas d'affichage , il vaut mieux ne rien afficher que d'afficher des erreurs.
|
187 |
// Si des doublons sur la commune : pas d'affichage , il vaut mieux ne rien afficher que d'afficher des erreurs.
|