New file |
0,0 → 1,146 |
<?php |
/** |
* Service fournissant des informations concernant les commentaire de DEL au format RSS1, RSS2 ou ATOM. |
* Encodage en entrée : utf8 |
* Encodage en sortie : utf8 |
* |
* @author Aurélien PERONNET <aurelien@tela-botanica.org> |
* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt> |
* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt> |
* @version $Id$ |
* @copyright 2010 |
*/ |
class SyndicationCommentaires { |
|
private $ressources = null; |
private $parametres = null; |
private $format = null; |
private $service = null; |
private $squelette = null; |
private $squelette_dossier = null; |
private $auteurs = array(); |
private $flux = array(); |
private $conteneur = null; |
private $gestionBdd = null; |
|
public function __construct(Conteneur $conteneur = null) { |
$this->conteneur = $conteneur == null ? new Conteneur() : $conteneur; |
$this->gestionBdd = $conteneur->getGestionBdd(); |
} |
|
public function consulter($params = array()) { |
$donnees_brutes = $this->getDerniersCommentaires(); |
$commentaires_formates = $this->formaterPourRss($donnees_brutes) ; |
return $commentaires_formates; |
} |
|
private function formaterPourRss($elements) { |
// Prétraitement des données |
$donnees = $this->construireDonneesCommunesAuFlux($elements); |
foreach ($elements as $element) { |
$identifiants[$element['id_commentaire']] = $element['id_commentaire']; |
} |
foreach ($elements as $element) { |
$donnees['items'][] = $this->construireDonneesCommunesAuxItems($element); |
} |
return $donnees; |
} |
|
private function creerCategorie($element) { |
$categorie = 'Commentaires'; |
$categorie = htmlentities($categorie); |
return $categorie; |
} |
|
private function creerUrlService() { |
$url_service = ''; |
if (count($_GET) > 0) { |
$parametres_get = array(); |
foreach ($_GET as $cle => $valeur) { |
$parametres_get[] = $cle.'='.$valeur; |
} |
$url_service .= '?'.implode('&', $parametres_get); |
} |
return $url_service; |
} |
|
private function construireDonneesCommunesAuFlux($infos) { |
$donnees = array(); |
$donnees['guid'] = ''; |
$donnees['titre'] = 'Dernières déterminations et commentaires de l\'application identiplante'; |
$donnees['description'] = 'Ce flux regroupe les dernières déterminations et commentaires rédigés dans l\'application identiplante'; |
$donnees['lien_service'] = $this->creerUrlService(); |
$donnees['lien_del'] = $this->conteneur->getParametre('delAppliLien'); |
$donnees['editeur'] = $this->conteneur->getParametre('editeur'); |
$derniere_info_en_date = reset($infos); |
$date_modification_timestamp = strtotime($derniere_info_en_date['date']); |
$donnees['date_maj_RSS'] = date(DATE_RSS, $date_modification_timestamp); |
$donnees['date_maj_ATOM'] = date(DATE_ATOM, $date_modification_timestamp); |
$donnees['date_maj_W3C'] = date(DATE_W3C, $date_modification_timestamp); |
$donnees['annee_courante'] = date('Y'); |
$donnees['generateur'] = 'DEL - SyndicationCommentaire'; |
$donnees['generateur_version'] = (preg_match('/([0-9]+)/', '$Revision$', $match)) ? $match[1] : '0'; |
return $donnees; |
} |
|
private function construireDonneesCommunesAuxItems($info) { |
$item = array(); |
$date_modification_timestamp = strtotime($info['date']); |
$item['date_maj_simple'] = strftime('%A %d %B %Y à %H:%M', $date_modification_timestamp); |
$item['date_maj_RSS'] = date(DATE_RSS, $date_modification_timestamp); |
$item['date_maj_ATOM'] = date(DATE_ATOM, $date_modification_timestamp); |
$item['date_maj_W3C'] = date(DATE_W3C, $date_modification_timestamp); |
$item['titre'] = $this->creerTitre($info); |
$item['guid'] = $this->creerGuidItem($info); |
$item['lien'] = $this->creerLienItem($info); |
$item['categorie'] = $this->creerCategorie($item); |
$item['description'] = $this->creerDescription($info, $item); |
$item['description_encodee'] = htmlspecialchars($this->creerDescription($info, $item)); |
$item['modifie_par'] = $this->creerAuteur($info); |
return $item; |
} |
|
private function creerGuidItem($element) { |
$guid = sprintf($this->conteneur->getParametre('guidObsTpl'), $element['id_commentaire']); |
return $guid; |
} |
|
private function creerLienItem($element) { |
$lien = sprintf($this->conteneur->getParametre('delFicheObsTpl'), $element['dob_id_observation']); |
return $lien; |
} |
|
private function creerTitre($element) { |
$titre = 'Observation '.$element['dob_id_observation'].' - '.htmlspecialchars($element['dob_nom_sel']).' à '.$element['dob_zone_geo'].' le '.$element['dob_date_observation']; |
return $titre; |
} |
|
private function creerDescription($donnees, $item) { |
$description = '<ul>'; |
|
if($donnees['nom_sel'] != '') { |
$description = '<li>Proposition : '.htmlspecialchars($donnees['nom_sel']).'</li>'; |
} |
$description .= '<li>Commentaire : <pre>'.htmlspecialchars($donnees['texte']).'</pre></li>'. |
'<li>Auteur : '.htmlspecialchars($this->creerAuteur($donnees)).'</li>'. |
'</ul>'; |
return $description; |
} |
|
private function creerAuteur($info) { |
return $info['utilisateur_prenom'].' '.$info['utilisateur_nom']; |
} |
|
private function getDerniersCommentaires() { |
$requete = "SELECT dc.*, dob.id_observation as dob_id_observation, dob.ce_zone_geo as dob_ce_zone_geo, ". |
"dob.zone_geo as dob_zone_geo, dob.date_observation as dob_date_observation, dob.nom_sel as dob_nom_sel ". |
"FROM del_commentaire dc ". |
"INNER JOIN del_observation dob ". |
"ON dob.id_observation = dc.ce_observation ". |
"AND dob.nom_sel != dc.nom_sel ". |
"ORDER BY dc.date DESC ". |
"LIMIT 0,50 "; |
$elements = $this->gestionBdd->getBdd()->recupererTous($requete); |
return $elements; |
} |
} |