Line 336... |
Line 336... |
336 |
$this->format_image = $this->parametres[0];
|
336 |
$this->format_image = $this->parametres[0];
|
337 |
}
|
337 |
}
|
Line 338... |
Line 338... |
338 |
|
338 |
|
339 |
// Construction de la requête
|
339 |
// Construction de la requête
|
340 |
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
|
340 |
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
|
341 |
' ci.id_image, ci.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
|
341 |
' ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
|
342 |
' co.mots_cles_texte AS mots_cles_texte_images_obs, ci.commentaire, note_qualite, nom_referentiel '.
|
342 |
' co.mots_cles_texte AS mots_cles_texte_images_obs, "" as commentaire, "" as note_qualite, nom_referentiel '.
|
343 |
'FROM cel_export_total AS co LEFT JOIN photo AS ci ON (co.id_observation = ci.ce_observation) '.
|
343 |
'FROM cel_export_total AS co LEFT JOIN cel_images_export AS ci ON (co.id_observation = ci.ce_observation) '.
|
344 |
'WHERE co.transmission = 1 '.
|
344 |
'WHERE co.transmission = 1 '.
|
345 |
' AND co.ce_utilisateur = ci.ce_utilisateur '.
|
345 |
' AND co.ce_utilisateur = ci.ce_utilisateur '.
|
346 |
'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'ci.date_creation DESC').' '.
|
346 |
'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'ci.date_creation DESC').' '.
|
Line 378... |
Line 378... |
378 |
// Construction de la requête
|
378 |
// Construction de la requête
|
379 |
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
|
379 |
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
|
380 |
' ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
|
380 |
' ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
|
381 |
' co.mots_cles_texte AS mots_cles_texte_obs, ci.commentaire AS commentaire_img, note_qualite, nom_referentiel, '.
|
381 |
' co.mots_cles_texte AS mots_cles_texte_obs, ci.commentaire AS commentaire_img, note_qualite, nom_referentiel, '.
|
382 |
' co.commentaire AS commentaire_obs '.
|
382 |
' co.commentaire AS commentaire_obs '.
|
383 |
'FROM photo AS ci '.
|
383 |
'FROM cel_images_export AS ci '.
|
384 |
' LEFT JOIN cel_export_total AS co '.
|
384 |
' LEFT JOIN cel_export_total AS co '.
|
385 |
' ON (ci.ce_observation = co.id_observation) '.
|
385 |
' ON (ci.ce_observation = co.id_observation) '.
|
386 |
(($this->etreFluxAdmin()) ? '' : 'WHERE co.transmission = 1 ').
|
386 |
(($this->etreFluxAdmin()) ? '' : 'WHERE co.transmission = 1 ').
|
387 |
'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'ci.date_creation DESC').' '.
|
387 |
'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'ci.date_creation DESC').' '.
|
388 |
"LIMIT $this->start, $this->limit ";
|
388 |
"LIMIT $this->start, $this->limit ";
|
Line 433... |
Line 433... |
433 |
|
433 |
|
434 |
private function creerRequeteSansParametres() {
|
434 |
private function creerRequeteSansParametres() {
|
435 |
// Première sous requete pour que le limite se fasse d'abord sur les images
|
435 |
// Première sous requete pour que le limite se fasse d'abord sur les images
|
436 |
// et pas la jointure de toutes les tables
|
436 |
// et pas la jointure de toutes les tables
|
437 |
$sous_requete = 'SELECT c.* '.
|
437 |
$sous_requete = 'SELECT c.* '.
|
438 |
'FROM cel_images c '.
|
438 |
'FROM photo c '.
|
439 |
(($this->etreFluxAdmin()) ? '' : 'INNER JOIN cel_export_total b ON c.ce_observation = b.id_observation AND b.transmission = 1 ');
|
439 |
(($this->etreFluxAdmin()) ? '' : 'INNER JOIN cel_export_total b ON c.ce_observation = b.id_observation AND b.transmission = 1 ');
|
440 |
$sous_requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'c.date_creation DESC').' '.
|
440 |
$sous_requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'c.date_creation DESC').' '.
|
Line 441... |
Line 441... |
441 |
"LIMIT $this->start,$this->limit ";
|
441 |
"LIMIT $this->start,$this->limit ";
|
442 |
|
442 |
|
443 |
// Construction de la requête
|
443 |
// Construction de la requête
|
444 |
$requete = 'SELECT *, b.mots_cles_texte AS mots_cles_texte_obs, c.mots_cles_texte AS mots_cles_texte_images, '.
|
444 |
$requete = 'SELECT *, b.mots_cles_texte AS mots_cles_texte_obs, c.mots_cles_texte AS mots_cles_texte_images, '.
|
445 |
' b.commentaire AS commentaire_obs, c.commentaire AS commentaire_img, nom_referentiel '.
|
445 |
' b.commentaire AS commentaire_obs, "" AS commentaire_img, nom_referentiel '.
|
446 |
'FROM ('.$sous_requete.') AS c '.
|
446 |
'FROM ('.$sous_requete.') AS c '.
|
447 |
' INNER JOIN cel_export_total AS b '.
|
447 |
' INNER JOIN cel_export_total AS b '.
|
448 |
' ON (c.ce_observation = b.id_observation) AND b.ce_utilisateur = c.ce_utilisateur ';
|
448 |
' ON (c.ce_observation = b.id_observation) AND b.ce_utilisateur = c.ce_utilisateur ';
|
449 |
//echo $requete;
|
449 |
//echo $requete;
|
Line 450... |
Line 450... |
450 |
return $requete;
|
450 |
return $requete;
|
451 |
}
|
451 |
}
|
452 |
|
452 |
|
453 |
private function creerRequeteAvecParametres() {
|
453 |
private function creerRequeteAvecParametres() {
|
454 |
// Construction de la requête
|
454 |
// Construction de la requête
|
455 |
$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.
|
455 |
$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.
|
456 |
' b.commentaire as commentaire_obs, c.commentaire as commentaire_img, nom_referentiel '.
|
456 |
' b.commentaire as commentaire_obs, "" as commentaire_img, nom_referentiel '.
|
457 |
'FROM cel_images AS c '.
|
457 |
'FROM photo AS c '.
|
458 |
' INNER JOIN cel_export_total AS b '.
|
458 |
' INNER JOIN cel_export_total AS b '.
|
459 |
' ON (c.ce_observation = b.id_observation) '.
|
459 |
' ON (c.ce_observation = b.id_observation) '.
|
Line 586... |
Line 586... |
586 |
' OR '.
|
586 |
' OR '.
|
587 |
'b.ce_zone_geo LIKE "INSEE-C:'.$chaine_requete.'%" '.
|
587 |
'b.ce_zone_geo LIKE "INSEE-C:'.$chaine_requete.'%" '.
|
588 |
' OR '.
|
588 |
' OR '.
|
589 |
'b.ce_zone_geo LIKE "'.$chaine_requete.'%" '.
|
589 |
'b.ce_zone_geo LIKE "'.$chaine_requete.'%" '.
|
590 |
' OR '.
|
590 |
' OR '.
|
591 |
'c.ce_utilisateur LIKE "'.$chaine_requete.'%" '.
|
591 |
'c.user_id LIKE "'.$chaine_requete.'%" '.
|
592 |
' OR '.
|
592 |
' OR '.
|
593 |
'c.courriel_utilisateur LIKE "'.$chaine_requete.'%" '.
|
593 |
'c.user_mail LIKE "'.$chaine_requete.'%" '.
|
594 |
' OR '.
|
594 |
' OR '.
|
595 |
'b.mots_cles_texte LIKE "'.$chaine_requete.'%" '.
|
595 |
'b.mots_cles_texte LIKE "'.$chaine_requete.'%" '.
|
596 |
' OR '.
|
596 |
' OR '.
|
597 |
'c.mots_cles_texte LIKE "'.$chaine_requete.'%" '.
|
597 |
'c.mots_cles_texte LIKE "'.$chaine_requete.'%" '.
|
598 |
') ';
|
598 |
') ';
|