Subversion Repositories eFlore/Projets.eflore-projets

<?php

// declare(encoding='UTF-8');

/**

* Classe implémentant l'API d'eFlore Publications pour le projet Biblio bota.

*

* @see http://www.tela-botanica.org/wikini/eflore/wakka.php?wiki=EfloreApi01Publications

*

* @package eFlore/services

* @author Jean-Pascal MILCENT <jpm@tela-botanica.org>

* @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 1.0

* @copyright 1999-2011 Tela Botanica (accueil@tela-botanica.org)

*/

// TODO : Config et Outils sont des classes statiques qui doivent poser des pb pour les tests...

class Publications {

	private $parametres;

	private $ressources;

	private $Bdd;

	private $config;

	private $nbrePublications;

	private $masque_taxon;

	public function __construct(Bdd $bdd = null, Array $config = null, Utilisateurs $utilisateurs = null, Url $url = null) {

		$this->config = is_null($config) ? Config::get('Publications') : $config;

		$this->Bdd = is_null($bdd) ? new Bdd() : $bdd;

		$this->UrlNavigation = is_null($url) ? new Url($this->config['url_service']) : $url;

	}

	public function consulter($ressources, $parametres) {

		$resultat = new ResultatService();

		$this->parametres = $parametres;

		$this->ressources = $ressources;

		$this->definirValeurParDefautDesParametres();

		$this->verifierParametres();

		$this->recupererParametresMasque();

		$this->chargerNbrePublicationsTotal();

		$publications = $this->getPublications($this->masque_taxon);

		$resultat->corps = $this->formaterPublications($publications);

		return $resultat;

	}

	public function getPublications($cherche) {

		$depart = $this->parametres['navigation.depart'];

		$limite = $this->parametres['navigation.limite'];

		$tab_mots = preg_split('~ ~', $cherche, -1, PREG_SPLIT_NO_EMPTY);

		$sql = 	'SELECT DISTINCT B_C_CRAI, B_C_NOMCOMPLET, B_C_ABREGE, ' .

				'	B_F_NUMERO, B_F_TITRE, B_F_DATE, B_F_CRAICOLL, '.

				'	B_SER_SOUSTITRE, '.

				'	B_A_PAGEDEBUT, B_A_PAGEFIN, B_A_CRAIFASC, B_A_CRAISERIE, ' .

				'	B_D_ID, B_D_LABEL, ' .

				'	B_S_IDSTR, B_S_NOM, ' .

				'	B_AS_LIBELLE, '.

				'	biblio_serie.*, biblio_item.*, biblio_item_typlog.*, biblio_item_typphy.* '.

				'FROM biblio_item '.

				'	LEFT JOIN biblio_aut_saisie ON (b_i_auteursaisie = b_as_id) '.

				'	LEFT JOIN biblio_article ON (b_i_iditem = b_a_idart) '.

				'	LEFT JOIN biblio_fasc ON '.

				'		(B_F_CRAICOLL = B_A_CRAICOLL '.

				'		AND B_F_CRAISERIE = B_A_CRAISERIE '.

				'		AND B_F_NUMERO = B_A_CRAIFASC)' .

				'	LEFT JOIN biblio_serie ON ' .

				'		(b_f_craicoll = b_ser_craicoll ' .

				'		AND b_f_craiserie = b_ser_idserie) '.

				'	LEFT JOIN biblio_collection ON (b_ser_craicoll = b_c_crai) '.

				'	LEFT JOIN biblio_str ON (B_C_LKSTR = B_S_IDSTR) '.

				'	LEFT JOIN biblio_domaine_lier ON (b_i_iditem = b_dl_iditem) ' .

				'	LEFT JOIN biblio_domaine ON (b_dl_iddom = b_d_id) ' .

				'	LEFT JOIN biblio_item_typphy ON (b_i_typphy = b_ip_id) ' .

				'	LEFT JOIN biblio_item_typlog ON (b_i_typlog = b_il_id) ' .

				'	WHERE B_I_TYPLOG = 1 AND B_I_TYPPHY = 2  AND B_I_CACHER = 0 '.

				'	AND B_D_ID = 1 ';

		foreach ($tab_mots as $mot) {

			$sql .= "	AND (B_I_TITRE LIKE '%$mot%' ".

					"		OR B_I_RESUMCLE LIKE '%$mot%' ".

					"		OR B_I_COMMENT LIKE '%$mot%') ";

		}

		$sql .= 'ORDER BY B_I_AUTEURS LIMIT '.$depart.', '.$limite;

		$publications = $this->Bdd->recupererTous($sql);

		return $publications;

	}

	function formaterPublications($publications) {

		$resultats = array();

		foreach($publications as $publication) {

			$id_a = $publication['B_I_IDITEM'];

			$titre = $publication['B_I_TITRE'];

			$auteurs = $publication['B_I_AUTEURS'];

			$geo = $publication['B_I_GEO'];

			$langue = $publication['B_I_LANGUE'];

			$resum = $publication['B_I_RESUMCLE'];

			$image = $publication['B_I_IMAGE'];

			$comment = $publication['B_I_COMMENT'];

			// Table Auteur Saisie

			$saisie = $publication['B_AS_LIBELLE'];

			// Table Domaine

			$domaine_id = $publication['B_D_ID'];

			$domaine_nom = $publication['B_D_LABEL'];

			// Table Collection

			$coll_nom = $publication['B_C_NOMCOMPLET'];

			$coll_abreviation = $publication['B_C_ABREGE'];

			// Table S�rie

			$serie_titre = $publication['B_SER_SOUSTITRE'];

			// Table Fascicule

			$craicoll = $publication['B_F_CRAICOLL'];

			$date = $publication['B_F_DATE'];

			$fascicule_titre = $publication['B_F_TITRE'];

			// Table Article

			$craifasc = $publication['B_A_CRAIFASC'];

			$craiserie = $publication['B_A_CRAISERIE'];

			$page_debut = $publication['B_A_PAGEDEBUT'];

			$page_fin = $publication['B_A_PAGEFIN'];

			// Table Structure

			$nomstr =  $publication['B_S_NOM'];

			// Formatage de la chaine de publication

			$chainePublication = "";

			if (isset($domaine_nom)) {

				$chainePublication .= '<span class="texte_inactif">['.$domaine_nom.']</span>';

			}

			if (isset($auteurs)) {

				$chainePublication .= $auteurs;

			}

			if (isset($titre)) {

				$chainePublication .= " - <strong>$titre</strong>";

			}

			if (isset($date)) {

				$chainePublication .= " - $date";

			}

			if (isset($mots_cles)) {

				$chainePublication .= " - <em>$mots_cles</em>";

			}

			if (isset($pages)) {

				$chainePublication .= ", p. $pages";

			}

			if (isset($geo)) {

				$chainePublication .= " - Départ./Région : <em>$geo</em>";

			}

			if (isset($structure)) {

				$chainePublication .= " - $structure";

			}

			if (isset($collection)) {

				$chainePublication .= ", $collection";

			}

			if (isset($serie)) {

				$chainePublication .= ", $serie";

			}

			if (isset($lien)) {

				$chainePublication .= ", <a class=\"lien_ext\" href=\"$lien_url\">$fascicule_titre</a>";

			} else {

				$chainePublication .= ", $fascicule_titre";

			}

			if (isset($saisie_auteur)) {

				$chainePublication .= " - <span class=\"texte_inactif\">Saisie : $saisie_auteur - Art. n°$article_id</span>";

			}

			$resultats[$id_a]['reference_html'] = $chainePublication;

		}

		$retour = array('entete' => $this->construireEntete(), 'resultats' => $resultats);

		return $retour;

	}

	private function definirValeurParDefautDesParametres() {

		if (isset($this->parametres['navigation.depart']) == false) {

			$this->parametres['navigation.depart'] = 0;

		}

		if (isset($this->parametres['navigation.limite']) == false) {

			$this->parametres['navigation.limite'] = 10;

		}

	}

	private function verifierParametres() {

		$erreurs = array();

		if ($this->verifierValeurParametreNavigationDepart() == false) {

			$erreurs[] = "Le paramètre 'navigation.depart' doit possèder un valeur numérique.";

		}

		if ($this->verifierValeurParametreNavigationLimite() == false) {

			$erreurs[] = "Le paramètre 'navigation.limite' doit possèder un valeur numérique supérieure à 0.";

		}

		if (count($erreurs) > 0) {

			$message = implode('<br />', $erreurs);

			$code = RestServeur::HTTP_CODE_MAUVAISE_REQUETE;

			throw new Exception($message, $code);

		}

	}

	private function verifierValeurParametreNavigationDepart() {

		$depart = $this->parametres['navigation.depart'];

		$ok = is_numeric($depart) ? true : false;

		return $ok;

	}

	private function verifierValeurParametreNavigationLimite() {

		$limite = $this->parametres['navigation.limite'];

		$ok = (is_numeric($limite) && $limite != 0) ? true : false;

		return $ok;

	}

	private function recupererParametresMasque() {

		if (isset($this->parametres['masque.taxon'])) {

			$this->masque_taxon = $this->parametres['masque.taxon'];

		} else {

			$this->masque_taxon = "";

		}

	}

	private function chargerNbrePublicationsTotal() {

		$tab_mots = preg_split('~ ~', $this->masque_taxon, -1, PREG_SPLIT_NO_EMPTY);

		$requete = 'SELECT COUNT(B_I_IDITEM) AS nbre '.

				'FROM biblio_item '.

				'	LEFT JOIN biblio_aut_saisie ON (b_i_auteursaisie = b_as_id) '.

				'	LEFT JOIN biblio_article ON (b_i_iditem = b_a_idart) '.

				'	LEFT JOIN biblio_fasc ON '.

				'		(B_F_CRAICOLL = B_A_CRAICOLL '.

				'		AND B_F_CRAISERIE = B_A_CRAISERIE '.

				'		AND B_F_NUMERO = B_A_CRAIFASC)' .

				'	LEFT JOIN biblio_serie ON ' .

				'		(b_f_craicoll = b_ser_craicoll ' .

				'		AND b_f_craiserie = b_ser_idserie) '.

				'	LEFT JOIN biblio_collection ON (b_ser_craicoll = b_c_crai) '.

				'	LEFT JOIN biblio_str ON (B_C_LKSTR = B_S_IDSTR) '.

				'	LEFT JOIN biblio_domaine_lier ON (b_i_iditem = b_dl_iditem) ' .

				'	LEFT JOIN biblio_domaine ON (b_dl_iddom = b_d_id) ' .

				'	LEFT JOIN biblio_item_typphy ON (b_i_typphy = b_ip_id) ' .

				'	LEFT JOIN biblio_item_typlog ON (b_i_typlog = b_il_id) ' .

				'	WHERE B_I_TYPLOG = 1 AND B_I_TYPPHY = 2  AND B_I_CACHER = 0 '.

				'	AND B_D_ID = 1 ';

		foreach ($tab_mots as $mot) {

			$requete .= "	AND (B_I_TITRE LIKE '%$mot%' ".

							"		OR B_I_RESUMCLE LIKE '%$mot%' ".

							"		OR B_I_COMMENT LIKE '%$mot%') ";

		}

		$resultats = $this->Bdd->recuperer($requete);

		$this->nbrePublications = (int) $resultats['nbre'];

	}

	private function construireEntete() {

		$entete = array('masque' => '', 'depart' => 0, 'limite' => 10, 'total' => 0);

		$entete['masque'] = $this->recupererMasque();

		$entete['depart'] = (int) $this->parametres['navigation.depart'];

		$entete['limite'] = (int) $this->parametres['navigation.limite'];

		$entete['total'] = $this->nbrePublications;

		if ($hrefPrecedent = $this->recupererHrefPrecedent()) {

			$entete['href.precedent'] = $hrefPrecedent;

		}

		if ($hrefSuivant = $this->recupererHrefSuivant()) {

			$entete['href.suivant'] = $hrefSuivant;

		}

		return $entete;

	}

	private function recupererMasque() {

		$masqueEntete = '';

		if ($this->masque_taxon) {

			$masqueEntete = "masque.taxon=$this->masque_taxon";

		}

		return $masqueEntete;

	}

	private function recupererHrefPrecedent() {

		$departActuel = $this->parametres['navigation.depart'];

		$limite = $this->parametres['navigation.limite'];

		$departPrecedent = $departActuel - $limite;

		$url = null;

		if ($departPrecedent >= 0) {

			$url = $this->obtenirUrlNavigation($departPrecedent, $limite, array('masque.taxon' => $this->masque_taxon));

		}

		return $url;

	}

	private function recupererHrefSuivant() {

		$departActuel = $this->parametres['navigation.depart'];

		$limite = $this->parametres['navigation.limite'];

		$departSuivant = $departActuel + $limite;

		$url = null;

		if ($departSuivant < $this->nbrePublications) {

			$url = $this->obtenirUrlNavigation($departSuivant, $limite, array('masque.taxon' => $this->masque_taxon));

		}

		return $url;

	}

	private function obtenirUrlNavigation($depart, $limite, $parametresAdditionnels) {

		$parametres = array(

			'navigation.depart' => $depart,

			'navigation.limite' => $limite);

		if ($parametresAdditionnels != null) {

			$parametres = array_merge($parametres, $parametresAdditionnels);

		}

		$this->UrlNavigation->setRequete($parametres);

		$url = $this->UrlNavigation->getURL();

		return $url;

	}

}

?>