WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/CelSyndicationImage.php



			$this->format_image = $this->parametres[0];
		}

 
		// Construction de la requête
		$requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
			' ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
			' co.mots_cles_texte AS mots_cles_texte_images_obs, "" as commentaire, "" as note_qualite, nom_referentiel '.
			'FROM cel_export_total AS co LEFT JOIN cel_images_export AS ci ON (co.id_observation = ci.ce_observation) '.
			'WHERE co.transmission = 1 '.
			'	AND co.ce_utilisateur = ci.ce_utilisateur '.
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'ci.date_creation DESC').' '.

		// Construction de la requête
		$requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' co.*, '.
			'	ci.id_image, co.ce_utilisateur, nom_original, ci.date_creation, ci.mots_cles_texte AS mots_cles_texte_images, '.
			'	co.mots_cles_texte AS mots_cles_texte_obs, ci.commentaire AS commentaire_img, note_qualite, nom_referentiel, '.
			'	co.commentaire AS commentaire_obs '.
			'FROM cel_images_export AS ci '.
			'	LEFT JOIN cel_export_total AS co '.
			'		ON (ci.ce_observation = co.id_observation) '.
			(($this->etreFluxAdmin()) ? '' : 'WHERE co.transmission = 1 ').
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'ci.date_creation DESC').' '.
			"LIMIT $this->start, $this->limit ";

 
	private function creerRequeteSansParametres() {
		// Première sous requete pour que le limite se fasse d'abord sur les images
		// et pas la jointure de toutes les tables
		$sous_requete = 'SELECT c.* '.
			'FROM photo c '.
			(($this->etreFluxAdmin()) ? '' : 'INNER JOIN cel_export_total b ON c.ce_observation = b.id_observation AND b.transmission = 1 ');
		$sous_requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'c.date_creation DESC').' '.

			"LIMIT $this->start,$this->limit ";
 
		// Construction de la requête
		$requete = 'SELECT *, b.mots_cles_texte AS mots_cles_texte_obs, c.mots_cles_texte AS mots_cles_texte_images, '.
			' b.commentaire AS commentaire_obs, "" AS commentaire_img, nom_referentiel '.
			'FROM ('.$sous_requete.') AS c '.
			'	INNER JOIN cel_export_total AS b '.
			'		ON (c.ce_observation = b.id_observation) AND b.ce_utilisateur = c.ce_utilisateur ';
		//echo $requete;

		return $requete;
	}
 
	private function creerRequeteAvecParametres() {
		// Construction de la requête
		$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.
		    ' b.commentaire as commentaire_obs, "" as commentaire_img, nom_referentiel '.
			'FROM photo AS c '.
			'	INNER JOIN cel_export_total AS b '.
			'		ON (c.ce_observation = b.id_observation) '.

				' OR '.
				'b.ce_zone_geo LIKE "INSEE-C:'.$chaine_requete.'%" '.
				' OR '.
				'b.ce_zone_geo LIKE "'.$chaine_requete.'%" '.
				' OR '.
				'c.user_id LIKE "'.$chaine_requete.'%" '.
				' OR '.
				'c.user_mail LIKE "'.$chaine_requete.'%" '.
				' OR '.
				'b.mots_cles_texte LIKE "'.$chaine_requete.'%" '.
				' OR '.
				'c.mots_cles_texte LIKE "'.$chaine_requete.'%" '.
				') ';

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/CelSyndicationImage.php @ 3625 – Rev 3571 → 3624

Rev 3571		Rev 3624
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	`') ';`