| Line 304... |
Line 304... |
| 304 |
' ON (ci.ce_observation = co.id_observation) '.
|
304 |
' ON (ci.ce_observation = co.id_observation) '.
|
| 305 |
$this->formerRequeteConditions($numNomListe).' '.
|
305 |
$this->formerRequeteConditions($numNomListe).' '.
|
| 306 |
'GROUP BY id_img '.
|
306 |
'GROUP BY id_img '.
|
| 307 |
$this->formerRequeteTri().
|
307 |
$this->formerRequeteTri().
|
| 308 |
"LIMIT $depart,$limite " . ' -- ' . __FILE__ . ':' . __LINE__;
|
308 |
"LIMIT $depart,$limite " . ' -- ' . __FILE__ . ':' . __LINE__;
|
| 309 |
echo $requete;exit;
|
- |
|
| 310 |
$this->infosImages = $this->Bdd->recupererTous($requete);
|
309 |
$this->infosImages = $this->Bdd->recupererTous($requete);
|
| 311 |
}
|
310 |
}
|
| Line 312... |
Line 311... |
| 312 |
|
311 |
|
| 313 |
private function formerRequeteConditions($numNomListe) {
|
312 |
private function formerRequeteConditions($numNomListe) {
|
| 314 |
$refTax = $this->parametres['referentiel'];
|
313 |
$refTax = $this->parametres['referentiel'];
|
| 315 |
$where[] = " co.nom_ret_nn IN ($numNomListe) ";
|
314 |
$where[] = " co.nom_ret_nn IN ($numNomListe) ";
|
| 316 |
// exclusion des noms à déterminer, douteux ou plantnet-mobile
|
315 |
// exclusion des noms à déterminer, douteux ou plantnet-mobile
|
| 317 |
$where[] = " (co.certitude not in ('aDeterminer', 'douteux', 'douteuse') OR certitude IS NULL) ";
|
316 |
//$where[] = " (co.certitude not in ('aDeterminer', 'douteux', 'douteuse') OR certitude IS NULL) ";
|
| Line 318... |
Line 317... |
| 318 |
$where[] = " co.nom_referentiel LIKE ".$this->Bdd->proteger($refTax."%").' ';
|
317 |
$where[] = " co.nom_referentiel LIKE ".$this->Bdd->proteger($refTax."%").' ';
|
| 319 |
|
318 |
|