Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 211 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
208 jpm 1 
<?php
2 
class NomDAO {
3 
	private $bdd = null;
4 
	private $projet = null;
5 
	private $versions = null;
6 
 
7 
	public function __construct(Ressources $ressources, Parametres $parametres, Bdd $bdd, Projet $projet, Versions $versions) {
8 
		$this->ressources = $ressources;
9 
		$this->parametres = $parametres;
10 
		$this->bdd = $bdd;
11 
		$this->projet = $projet;
12 
		$this->versions = $versions;
13 
	}
14 
 
15 
	private function getTable() {
16 
		$versions = $this->versions->getVersions();
17 
		$derniereVersion = end($versions);
18 
		$projetNom = $this->projet->getNom();
19 
		return $projetNom.'_v'.$derniereVersion;
20 
	}
21 
 
22 
	public function rechercherInfosNom() {
23 
		$table = $this->getTable();
24 
		$detailsId = $this->ressources->getDetailsId();
25 
		$detailsId = $this->bdd->proteger($detailsId);
26 
		$requete =
27 
				'SELECT ns.*,  '.
28 
				'	nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
29 
				"FROM $table AS ns ".
30 
				"	LEFT JOIN $table AS nr ON (ns.num_nom_retenu = nr.num_nom) ".
31 
				"	LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
32 
				"WHERE ns.num_nom = $detailsId ";
33 
		$resultats = $this->bdd->recuperer($requete);
34 
		$nom = new NomDO($resultats);
35 
		return $nom;
36 
	}
37 
 
38 
	public function rechercherStricte() {
39 
		$table = $this->getTable();
40 
		$conditions = array();
41 
		if ($masque = $this->parametres->getMasquePourBdd()) {
42 
			$conditions[] = "ns.nom_sci = $masque";
43 
		}
44 
		if ($masqueSg = $this->parametres->getMasquePourBdd('sg')) {
45 
			$conditions[] = "ns.nom_supra_generique = $masqueSg";
46 
		}
47 
		if ($masqueGen = $this->parametres->getMasquePourBdd('gen')) {
48 
			$conditions[] = "ns.genre = $masqueGen";
49 
		}
50 
		if ($masqueSp = $this->parametres->getMasquePourBdd('sp')) {
51 
			$conditions[] = "ns.epithete_sp = $masqueSp";
52 
		}
209 jpm 53 
		$navigation = $this->getNavigation();
208 jpm 54 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS ns.*,  '.
209 jpm 55 
			'	nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
56 
			"FROM $table AS ns ".
57 
			"	LEFT JOIN $table AS nr ON (ns.num_nom_retenu = nr.num_nom) ".
58 
			"	LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
59 
			$this->getWhere($conditions).
60 
			implode(' AND ', $conditions).
61 
			'ORDER BY ns.nom_sci ASC '.
62 
			"LIMIT $navigation ";
211 jpm 63 
 
208 jpm 64 
		$resultats = $this->bdd->recupererTous($requete);
65 
 
66 
		return $resultats;
67 
	}
68 
 
69 
	public function rechercherEtendue() {
70 
		$table = $this->getTable();
71 
		$conditions = array();
72 
		if ($masque = $this->parametres->getMasquePourBdd()) {
73 
			$conditions[] = "ns.nom_sci LIKE $masque";
74 
		}
75 
		if ($masqueSg = $this->parametres->getMasquePourBdd('sg')) {
76 
			$conditions[] = "ns.nom_supra_generique LIKE $masqueSg";
77 
		}
78 
		if ($masqueGen = $this->parametres->getMasquePourBdd('gen')) {
79 
			$conditions[] = "ns.genre LIKE $masqueGen";
80 
		}
81 
		if ($masqueSp = $this->parametres->getMasquePourBdd('sp')) {
82 
			$conditions[] = "ns.epithete_sp LIKE $masqueSp";
83 
		}
209 jpm 84 
		$navigation = $this->getNavigation();
208 jpm 85 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS ns.*,  '.
209 jpm 86 
			'	nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
87 
			"FROM $table AS ns ".
88 
			"	LEFT JOIN $table AS nr ON (ns.num_nom_retenu = nr.num_nom) ".
89 
			"	LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
90 
			$this->getWhere($conditions).
91 
			implode(' AND ', $conditions).
92 
			'ORDER BY ns.nom_sci ASC '.
93 
			"LIMIT $navigation ";
208 jpm 94 
 
95 
		$resultats = $this->bdd->recupererTous($requete);
96 
		return $resultats;
97 
	}
98 
 
99 
	public function rechercherFloue() {
100 
		$table = $this->getTable();
101 
		$masque = $this->parametres->getMasquePourBdd();
212 jpm 102 
		$where = $this->getWhere();
209 jpm 103 
		$navigation = $this->getNavigation();
208 jpm 104 
		$requete = 'SELECT SQL_CALC_FOUND_ROWS ns.*,  '.
209 jpm 105 
			'	nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
106 
			"FROM $table AS ns ".
107 
			"	LEFT JOIN $table AS nr ON (ns.num_nom_retenu = nr.num_nom) ".
108 
			"	LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
212 jpm 109 
			$where .
110 
			($masque ? ($where ? ' AND ' : ' WHERE ').
111 
				"	(SOUNDEX(ns.nom_sci) = SOUNDEX($masque)) ".
112 
				"	OR (SOUNDEX(REVERSE(ns.nom_sci)) = SOUNDEX(REVERSE($masque))) " : '').
209 jpm 113 
			'ORDER BY ns.nom_sci ASC '.
114 
			"LIMIT $navigation ";
208 jpm 115 
		$resultats = $this->bdd->recupererTous($requete);
116 
		return $resultats;
117 
	}
118 
 
209 jpm 119 
	private function getNavigation() {
211 jpm 120 
		$debut = (int) $this->parametres->get('navigation.depart');
209 jpm 121 
		$nbre = $this->parametres->get('navigation.limite');
211 jpm 122 
		$navigation = "$debut,$nbre";
123 
		return $navigation;
209 jpm 124 
	}
125 
 
126 
	private function getWhere($conditions = array()) {
127 
		$where = '';
128 
		if ($this->ressources->getServiceNom() == 'taxons') {
129 
			$where = 'WHERE ns.num_nom = ns.num_nom_retenu ';
130 
		} else if (count($conditions) > 0) {
131 
			$where = 'WHERE ';
132 
		}
133 
		return $where;
134 
	}
135 
 
208 jpm 136 
	public function recupererNombreNomsTotal() {
137 
		$requete = 'SELECT FOUND_ROWS() AS nbre';
138 
		$nombre = $this->bdd->recuperer($requete);
139 
		return (int) $nombre['nbre'];
140 
	}
141 
}
142 
?>