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 '.
|