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



	private function construireDonneesCommunesAuFlux($infos) {
		$donnees = $this->getFlux($this->service);
		$donnees['guid'] = $this->getUrlServiceBase();
		$donnees['lien_service'] = $this->creerUrlService();
		$donnees['lien_cel'] = (isset($infos['nom_sel_nn']) && $infos['nom_sel_nn'] != '' && $infos['nom_sel_nn'] != 0) ?
			$this->getUrlEflore($infos['nom_referentiel'], $infos['nom_sel_nn']) : '';	
		$donnees['editeur'] = $this->config['settings']['editeur'];
		$derniere_info_en_date = reset($infos);
		$date_modification_timestamp = strtotime($derniere_info_en_date['date_creation']);
		$donnees['date_maj_RSS'] = date(DATE_RSS, $date_modification_timestamp);
		$donnees['date_maj_ATOM'] = date(DATE_ATOM, $date_modification_timestamp);

		if ($this->etreNull($element['id_observation'])) {
			// Lien vers image grand format
			$lien = $this->getUrlImage($element['id_image'], $this->format_image);
		} else {
			// Lien vers fiche eFlore onglet Illustration
			$lien = $this->getUrlEflore($element['nom_referentiel'], $element['nom_sel_nn'], 'illustration');	
		}
		return $lien;
	}

 

		}

 
		// Construction de la requête
		$requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.
			' cim.id_image, cim.ce_utilisateur, nom_original, cim.date_creation, cim.mots_cles_texte as mots_cles_texte_images,
				 ci.mots_cles_texte as mots_cles_texte_images_obs, cim.commentaire, note_qualite, nom_referentiel  '.
			'FROM cel_obs_images AS coi '.
			'LEFT JOIN cel_obs AS ci '.
				'ON (coi.id_observation = ci.id_observation) '.
			'LEFT JOIN cel_images AS cim '.

		}
		return $titre;
	}

 
	private function creerDescriptionSimple($donnees, $item) {
		$description = $this->getUrlEflore($element['nom_referentiel'], $element['nom_sel_nn'], 'illustration');
		return $description;

	}

 
	private function getServiceComplet() {
 
		// Construction de la requête
		$requete = 	(isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.
			'	cim.id_image, ci.ce_utilisateur, nom_original, cim.date_creation, cim.mots_cles_texte as mots_cles_texte_images, '.
			'   ci.mots_cles_texte as mots_cles_texte_obs, cim.commentaire as commentaire_img, note_qualite, nom_referentiel, '.
			'	ci.commentaire as commentaire_obs '.
			'FROM cel_images AS cim '.

		$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, c.commentaire as commentaire_img, nom_referentiel '.
			'FROM ('.$sous_requete.') as c '.
			'	INNER JOIN cel_obs_images AS a '.
			'		ON (a.id_image = c.id_image) '.
			'	INNER JOIN cel_obs AS b '.

	}

 
	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, c.commentaire as commentaire_img, nom_referentiel '.
			'FROM cel_obs_images AS a '.
			'	INNER JOIN cel_obs AS b '.
			'		ON (a.id_observation = b.id_observation) '.
			'	INNER JOIN cel_images AS c '.

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/CelSyndicationImage.php @ 1765 – Rev 1550 → 1622

Rev 1550		Rev 1622
Line 236...		Line 236...
236	`private function construireDonneesCommunesAuFlux($infos) {`	236	`private function construireDonneesCommunesAuFlux($infos) {`
237	`$donnees = $this->getFlux($this->service);`	237	`$donnees = $this->getFlux($this->service);`
238	`$donnees['guid'] = $this->getUrlServiceBase();`	238	`$donnees['guid'] = $this->getUrlServiceBase();`
239	`$donnees['lien_service'] = $this->creerUrlService();`	239	`$donnees['lien_service'] = $this->creerUrlService();`
240	`$donnees['lien_cel'] = (isset($infos['nom_sel_nn']) && $infos['nom_sel_nn'] != '' && $infos['nom_sel_nn'] != 0) ?`	240	`$donnees['lien_cel'] = (isset($infos['nom_sel_nn']) && $infos['nom_sel_nn'] != '' && $infos['nom_sel_nn'] != 0) ?`
241	`sprintf($this->config['settings']['efloreUrlTpl'], $infos['nom_sel_nn'], 'illustration') : '';`	241	`$this->getUrlEflore($infos['nom_referentiel'], $infos['nom_sel_nn']) : '';`
242	`$donnees['editeur'] = $this->config['settings']['editeur'];`	242	`$donnees['editeur'] = $this->config['settings']['editeur'];`
243	`$derniere_info_en_date = reset($infos);`	243	`$derniere_info_en_date = reset($infos);`
244	`$date_modification_timestamp = strtotime($derniere_info_en_date['date_creation']);`	244	`$date_modification_timestamp = strtotime($derniere_info_en_date['date_creation']);`
245	`$donnees['date_maj_RSS'] = date(DATE_RSS, $date_modification_timestamp);`	245	`$donnees['date_maj_RSS'] = date(DATE_RSS, $date_modification_timestamp);`
246	`$donnees['date_maj_ATOM'] = date(DATE_ATOM, $date_modification_timestamp);`	246	`$donnees['date_maj_ATOM'] = date(DATE_ATOM, $date_modification_timestamp);`
Line 294...		Line 294...
294	`if ($this->etreNull($element['id_observation'])) {`	294	`if ($this->etreNull($element['id_observation'])) {`
295	`// Lien vers image grand format`	295	`// Lien vers image grand format`
296	`$lien = $this->getUrlImage($element['id_image'], $this->format_image);`	296	`$lien = $this->getUrlImage($element['id_image'], $this->format_image);`
297	`} else {`	297	`} else {`
298	`// Lien vers fiche eFlore onglet Illustration`	298	`// Lien vers fiche eFlore onglet Illustration`
299	`$lien = sprintf($this->config['settings']['efloreUrlTpl'], $element['nom_sel_nn'], 'illustration');`	299	`$lien = $this->getUrlEflore($element['nom_referentiel'], $element['nom_sel_nn'], 'illustration');`
300	`}`	300	`}`
301	`return $lien;`	301	`return $lien;`
302	`}`	302	`}`
Line 303...		Line 303...
303		303
Line 330...		Line 330...
330	`}`	330	`}`
Line 331...		Line 331...
331		331
332	`// Construction de la requête`	332	`// Construction de la requête`
333	`$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.`	333	`$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.`
334	`' cim.id_image, cim.ce_utilisateur, nom_original, cim.date_creation, cim.mots_cles_texte as mots_cles_texte_images,`	334	`' cim.id_image, cim.ce_utilisateur, nom_original, cim.date_creation, cim.mots_cles_texte as mots_cles_texte_images,`
335	`ci.mots_cles_texte as mots_cles_texte_images_obs, cim.commentaire, note_qualite '.`	335	`ci.mots_cles_texte as mots_cles_texte_images_obs, cim.commentaire, note_qualite, nom_referentiel '.`
336	`'FROM cel_obs_images AS coi '.`	336	`'FROM cel_obs_images AS coi '.`
337	`'LEFT JOIN cel_obs AS ci '.`	337	`'LEFT JOIN cel_obs AS ci '.`
338	`'ON (coi.id_observation = ci.id_observation) '.`	338	`'ON (coi.id_observation = ci.id_observation) '.`
339	`'LEFT JOIN cel_images AS cim '.`	339	`'LEFT JOIN cel_images AS cim '.`
Line 360...		Line 360...
360	`}`	360	`}`
361	`return $titre;`	361	`return $titre;`
362	`}`	362	`}`
Line 363...		Line 363...
363		363
364	`private function creerDescriptionSimple($donnees, $item) {`	364	`private function creerDescriptionSimple($donnees, $item) {`
365	`$description = sprintf($this->config['settings']['efloreUrlTpl'], urlencode($donnees['nom_sel_nn']), 'illustration');`	365	`$description = $this->getUrlEflore($element['nom_referentiel'], $element['nom_sel_nn'], 'illustration');`
366	`return $description;`	366	`return $description;`
Line 367...		Line 367...
367	`}`	367	`}`
Line 368...		Line 368...
368		368
369	`private function getServiceComplet() {`	369	`private function getServiceComplet() {`
370		370
371	`// Construction de la requête`	371	`// Construction de la requête`
372	`$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.`	372	`$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' ci.*, '.`
373	`' cim.id_image, ci.ce_utilisateur, nom_original, cim.date_creation, cim.mots_cles_texte as mots_cles_texte_images, '.`	373	`' cim.id_image, ci.ce_utilisateur, nom_original, cim.date_creation, cim.mots_cles_texte as mots_cles_texte_images, '.`
374	`' ci.mots_cles_texte as mots_cles_texte_obs, cim.commentaire as commentaire_img, note_qualite, '.`	374	`' ci.mots_cles_texte as mots_cles_texte_obs, cim.commentaire as commentaire_img, note_qualite, nom_referentiel, '.`
375	`' ci.commentaire as commentaire_obs '.`	375	`' ci.commentaire as commentaire_obs '.`
376	`'FROM cel_images AS cim '.`	376	`'FROM cel_images AS cim '.`
Line 436...		Line 436...
436	`$sous_requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'c.date_creation DESC').' '.`	436	`$sous_requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'c.date_creation DESC').' '.`
437	`"LIMIT $this->start,$this->limit ";`	437	`"LIMIT $this->start,$this->limit ";`
Line 438...		Line 438...
438		438
439	`// Construction de la requête`	439	`// Construction de la requête`
440	`$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.`	440	`$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.`
441	`' b.commentaire as commentaire_obs, c.commentaire as commentaire_img '.`	441	`' b.commentaire as commentaire_obs, c.commentaire as commentaire_img, nom_referentiel '.`
442	`'FROM ('.$sous_requete.') as c '.`	442	`'FROM ('.$sous_requete.') as c '.`
443	`' INNER JOIN cel_obs_images AS a '.`	443	`' INNER JOIN cel_obs_images AS a '.`
444	`' ON (a.id_image = c.id_image) '.`	444	`' ON (a.id_image = c.id_image) '.`
445	`' INNER JOIN cel_obs AS b '.`	445	`' INNER JOIN cel_obs AS b '.`
Line 449...		Line 449...
449	`}`	449	`}`
Line 450...		Line 450...
450		450
451	`private function creerRequeteAvecParametres() {`	451	`private function creerRequeteAvecParametres() {`
452	`// Construction de la requête`	452	`// Construction de la requête`
453	`$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.`	453	`$requete = 'SELECT *, b.mots_cles_texte as mots_cles_texte_obs, c.mots_cles_texte as mots_cles_texte_images, '.`
454	`' b.commentaire as commentaire_obs, c.commentaire as commentaire_img '.`	454	`' b.commentaire as commentaire_obs, c.commentaire as commentaire_img, nom_referentiel '.`
455	`'FROM cel_obs_images AS a '.`	455	`'FROM cel_obs_images AS a '.`
456	`' INNER JOIN cel_obs AS b '.`	456	`' INNER JOIN cel_obs AS b '.`
457	`' ON (a.id_observation = b.id_observation) '.`	457	`' ON (a.id_observation = b.id_observation) '.`
458	`' INNER JOIN cel_images AS c '.`	458	`' INNER JOIN cel_images AS c '.`