WebSVN – eFlore/Projets.eflore-projets – Diff – /trunk/services/modules/0.1/chorodep/Noms.php


<?php
/**
* Retourne la liste des noms répertoriés par le projet chorodep
* 
* @package chorodep
* @author Mathias Chouet <mathias@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-2014 Tela Botanica (accueil@tela-botanica.org)
*/
 
class Noms extends Commun {
 
	protected $serviceNom = 'noms';
	protected $table;
	protected $masque;
	protected $depart;
	protected $limite;
	protected $tri;
	protected $tri_dir;
 
	protected function init() {
		$this->masque = array();
		$this->depart = 0;
		$this->limite = 20;
		$this->tri = 'nom_sci';
		$this->tri_dir = 'ASC';
		$this->traiterVersionProjet();
		$this->table = $this->table_version[0];
	}
 
	/**
	 * Récupère les paramètres de navigation
	 * @param type $parametres
	 */
	protected function setDepartLimite($parametres) {
		if(isset($parametres['navigation.depart']) && $parametres['navigation.depart'] != '') {
			$this->depart = max(0, intval($parametres['navigation.depart']));
		}
		if(isset($parametres['navigation.limite']) && $parametres['navigation.limite'] != '') {
			$this->limite = max(0, intval($parametres['navigation.limite']));
		}
	}
 
	/**
	 * Récupère les paramètres de filtrage
	 * @param type $parametres
	 */
	protected function setMasque($parametres) {
		if(isset($parametres['masque.nom']) && $parametres['masque.nom'] != '') {
			$this->masque['nom'] = $parametres['masque.nom'];
		}
		if(isset($parametres['masque.zone-geo']) && $parametres['masque.zone-geo'] != '') {
			$zg = $parametres['masque.zone-geo'];
			// Tango Corse
			if ($zg == '2A' || $zg == '2B') {
				$zg = '20';
			}
			$this->masque['zone-geo'] = $zg;
		}
	}
 
	/**
	 * Récupère les paramètres de tri
	 * @param type $parametres
	 */
	protected function setTri($parametres) {
		if(isset($parametres['retour.tri']) && $parametres['retour.tri'] != '') {
			$this->tri = $parametres['retour.tri'];
		}
		if(isset($parametres['retour.ordre']) && in_array($parametres['retour.ordre'], array('ASC', 'DESC'))) {
			$this->tri_dir = $parametres['retour.ordre'];
		}
	}
 
	public function consulter($ressources, $parametres) {
		$donnees = array();
 
		$this->setDepartLimite($parametres);
		$this->setMasque($parametres);
		$this->setTri($parametres);
		$noms = $this->listeNoms();
		$total = $this->compterNoms();
 
		$url_base = Config::get('url_service');
 
		$masqueEnParams = array();
		foreach ($this->masque as $k => $v) {
			$masqueEnParams[] = 'masque.' . $k . '=' . $v;
		}
		$masqueEnParams = implode('&', $masqueEnParams);
 
		$donnees['entete'] = array(
			'masque' => $masqueEnParams,
			'total' => $total,
			'depart' => $this->depart,
			'limite' => $this->limite
		);
		if ($this->depart > 0) {
			$donnees['entete']['href.precedent'] = $url_base . '/' . $this->serviceNom . '?'
					. 'navigation.depart=' . max(0, ($this->depart - $this->limite)) . '&navigation.limite=' . $this->limite
					. '&retour.tri=' . $this->tri . '&retour.ordre=' . $this->tri_dir
					. ($masqueEnParams ? '&' . $masqueEnParams : '');
		}
		if (($this->depart + $this->limite) < $total ) {
			$donnees['entete']['href.suivant'] = $url_base . '/' . $this->serviceNom . '?'
					. 'navigation.depart=' . ($this->depart + $this->limite) . '&navigation.limite=' . $this->limite
					. '&retour.tri=' . $this->tri . '&retour.ordre=' . $this->tri_dir
					. ($masqueEnParams ? '&' . $masqueEnParams : '');
		}
		$donnees['resultat'] = $noms;
 
		return $donnees;
	}
 
	/**
	 * Renvoie la liste des noms répertoriés par chorodep; si un masque a été
	 * défini sur une zone géographique, retourne aussi la présence sur cette zone
	 */
	protected function listeNoms() {
		$req = "SELECT DISTINCT num_nom, nom_sci";
		if (isset($this->masque['zone-geo']) && $this->masque['zone-geo'] != null) {
			$req .= ", `" . $this->masque['zone-geo'] . "` as presence";
		}
		$req .= " FROM " . $this->table;
		$req .= $this->construireWhere();
		$req .= " ORDER BY ".$this->tri." ".$this->tri_dir." ";
		$req .= " LIMIT " . $this->depart . ", " . $this->limite;
 
		$resultat = $this->getBdd()->recupererTous($req);
 
		return $resultat;
	}
 
	protected function compterNoms() {
		$req = "SELECT count(DISTINCT num_nom, nom_sci) AS compte FROM " . $this->table;
		$req .= $this->construireWhere();
		$resultat = $this->getBdd()->recuperer($req);
 
		return $resultat['compte'];
	}
 
	protected function construireWhere() {
		$where = "";
		$conditions = array();
		// élimination des entrées sans nn valide
		$conditions[] = "CAST(num_nom AS decimal) != 0";
		// masque
		if(!empty($this->masque)) {
			if(isset($this->masque['nom'])) {
				$masqueNom = $this->getBdd()->proteger($this->masque['nom']);
				$conditions[] = "nom_sci LIKE $masqueNom";
			}
			if(isset($this->masque['zone-geo'])) {
				$masqueZg = $this->masque['zone-geo'];
				$conditions[] = "`$masqueZg` in ('1', '1?')";
			}
		}
		$where = " WHERE " . implode(' AND ', $conditions);
		return $where;
	}
}
?>

Subversion Repositories eFlore/Projets.eflore-projets

(root)/trunk/services/modules/0.1/chorodep/Noms.php – Rev 1111 → 1124

Rev 1111		Rev 1124
1	`<?php`	1	`<?php`
2	`/**`	2	`/**`
3	`* Retourne la liste des noms répertoriés par le projet chorodep`	3	`* Retourne la liste des noms répertoriés par le projet chorodep`
4	`*`	4	`*`
5	`* @package chorodep`	5	`* @package chorodep`
6	`* @author Mathias Chouet <mathias@tela-botanica.org>`	6	`* @author Mathias Chouet <mathias@tela-botanica.org>`
7	`* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt>`	7	`* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt>`
8	`* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>`	8	`* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>`
9	`* @version 1.0`	9	`* @version 1.0`
10	`* @copyright 1999-2014 Tela Botanica (accueil@tela-botanica.org)`	10	`* @copyright 1999-2014 Tela Botanica (accueil@tela-botanica.org)`
11	`*/`	11	`*/`
12		12
13	`class Noms extends Commun {`	13	`class Noms extends Commun {`
14		14
15	`protected $serviceNom = 'noms';`	15	`protected $serviceNom = 'noms';`
16	`protected $table;`	16	`protected $table;`
17	`protected $masque;`	17	`protected $masque;`
18	`protected $depart;`	18	`protected $depart;`
19	`protected $limite;`	19	`protected $limite;`
20	`protected $tri;`	20	`protected $tri;`
21	`protected $tri_dir;`	21	`protected $tri_dir;`
22		22
23	`protected function init() {`	23	`protected function init() {`
24	`$this->masque = array();`	24	`$this->masque = array();`
25	`$this->depart = 0;`	25	`$this->depart = 0;`
26	`$this->limite = 20;`	26	`$this->limite = 20;`
27	`$this->tri = 'nom_sci';`	27	`$this->tri = 'nom_sci';`
28	`$this->tri_dir = 'ASC';`	28	`$this->tri_dir = 'ASC';`
29	`$this->traiterVersionProjet();`	29	`$this->traiterVersionProjet();`
30	`$this->table = $this->table_version[0];`	30	`$this->table = $this->table_version[0];`
31	`}`	31	`}`
32		32
33	`/**`	33	`/**`
34	`* Récupère les paramètres de navigation`	34	`* Récupère les paramètres de navigation`
35	`* @param type $parametres`	35	`* @param type $parametres`
36	`*/`	36	`*/`
37	`protected function setDepartLimite($parametres) {`	37	`protected function setDepartLimite($parametres) {`
38	`if(isset($parametres['navigation.depart']) && $parametres['navigation.depart'] != '') {`	38	`if(isset($parametres['navigation.depart']) && $parametres['navigation.depart'] != '') {`
39	`$this->depart = max(0, intval($parametres['navigation.depart']));`	39	`$this->depart = max(0, intval($parametres['navigation.depart']));`
40	`}`	40	`}`
41	`if(isset($parametres['navigation.limite']) && $parametres['navigation.limite'] != '') {`	41	`if(isset($parametres['navigation.limite']) && $parametres['navigation.limite'] != '') {`
42	`$this->limite = max(0, intval($parametres['navigation.limite']));`	42	`$this->limite = max(0, intval($parametres['navigation.limite']));`
43	`}`	43	`}`
44	`}`	44	`}`
45		45
46	`/**`	46	`/**`
47	`* Récupère les paramètres de filtrage`	47	`* Récupère les paramètres de filtrage`
48	`* @param type $parametres`	48	`* @param type $parametres`
49	`*/`	49	`*/`
50	`protected function setMasque($parametres) {`	50	`protected function setMasque($parametres) {`
51	`if(isset($parametres['masque.nom']) && $parametres['masque.nom'] != '') {`	51	`if(isset($parametres['masque.nom']) && $parametres['masque.nom'] != '') {`
52	`$this->masque['nom'] = $parametres['masque.nom'];`	52	`$this->masque['nom'] = $parametres['masque.nom'];`
53	`}`	53	`}`
54	`if(isset($parametres['masque.zone-geo']) && $parametres['masque.zone-geo'] != '') {`	54	`if(isset($parametres['masque.zone-geo']) && $parametres['masque.zone-geo'] != '') {`
55	`$zg = $parametres['masque.zone-geo'];`	55	`$zg = $parametres['masque.zone-geo'];`
56	`// Tango Corse`	56	`// Tango Corse`
57	`if ($zg == '2A' \|\| $zg == '2B') {`	57	`if ($zg == '2A' \|\| $zg == '2B') {`
58	`$zg = '20';`	58	`$zg = '20';`
59	`}`	59	`}`
60	`$this->masque['zone-geo'] = $zg;`	60	`$this->masque['zone-geo'] = $zg;`
61	`}`	61	`}`
62	`}`	62	`}`
63		63
64	`/**`	64	`/**`
65	`* Récupère les paramètres de tri`	65	`* Récupère les paramètres de tri`
66	`* @param type $parametres`	66	`* @param type $parametres`
67	`*/`	67	`*/`
68	`protected function setTri($parametres) {`	68	`protected function setTri($parametres) {`
69	`if(isset($parametres['retour.tri']) && $parametres['retour.tri'] != '') {`	69	`if(isset($parametres['retour.tri']) && $parametres['retour.tri'] != '') {`
70	`$this->tri = $parametres['retour.tri'];`	70	`$this->tri = $parametres['retour.tri'];`
71	`}`	71	`}`
72	`if(isset($parametres['retour.ordre']) && in_array($parametres['retour.ordre'], array('ASC', 'DESC'))) {`	72	`if(isset($parametres['retour.ordre']) && in_array($parametres['retour.ordre'], array('ASC', 'DESC'))) {`
73	`$this->tri_dir = $parametres['retour.ordre'];`	73	`$this->tri_dir = $parametres['retour.ordre'];`
74	`}`	74	`}`
75	`}`	75	`}`
76		76
77	`public function consulter($ressources, $parametres) {`	77	`public function consulter($ressources, $parametres) {`
78	`$donnees = array();`	78	`$donnees = array();`
79		79
80	`$this->setDepartLimite($parametres);`	80	`$this->setDepartLimite($parametres);`
81	`$this->setMasque($parametres);`	81	`$this->setMasque($parametres);`
82	`$this->setTri($parametres);`	82	`$this->setTri($parametres);`
83	`$noms = $this->listeNoms();`	83	`$noms = $this->listeNoms();`
84	`$total = $this->compterNoms();`	84	`$total = $this->compterNoms();`
85		85
86	`$url_base = Config::get('url_service');`	86	`$url_base = Config::get('url_service');`
87		87
88	`$masqueEnParams = array();`	88	`$masqueEnParams = array();`
89	`foreach ($this->masque as $k => $v) {`	89	`foreach ($this->masque as $k => $v) {`
90	`$masqueEnParams[] = 'masque.' . $k . '=' . $v;`	90	`$masqueEnParams[] = 'masque.' . $k . '=' . $v;`
91	`}`	91	`}`
92	`$masqueEnParams = implode('&', $masqueEnParams);`	92	`$masqueEnParams = implode('&', $masqueEnParams);`
93		93
94	`$donnees['entete'] = array(`	94	`$donnees['entete'] = array(`
95	`'masque' => $masqueEnParams,`	95	`'masque' => $masqueEnParams,`
96	`'total' => $total,`	96	`'total' => $total,`
97	`'depart' => $this->depart,`	97	`'depart' => $this->depart,`
98	`'limite' => $this->limite`	98	`'limite' => $this->limite`
99	`);`	99	`);`
100	`if ($this->depart > 0) {`	100	`if ($this->depart > 0) {`
101	`$donnees['entete']['href.precedent'] = $url_base . '/' . $this->serviceNom . '?'`	101	`$donnees['entete']['href.precedent'] = $url_base . '/' . $this->serviceNom . '?'`
102	`. 'navigation.depart=' . max(0, ($this->depart - $this->limite)) . '&navigation.limite=' . $this->limite`	102	`. 'navigation.depart=' . max(0, ($this->depart - $this->limite)) . '&navigation.limite=' . $this->limite`
103	`. '&retour.tri=' . $this->tri . '&retour.ordre=' . $this->tri_dir`	103	`. '&retour.tri=' . $this->tri . '&retour.ordre=' . $this->tri_dir`
104	`. '&' . $masqueEnParams;`	104	`. ($masqueEnParams ? '&' . $masqueEnParams : '');`
105	`}`	105	`}`
106	`if (($this->depart + $this->limite) < $total ) {`	106	`if (($this->depart + $this->limite) < $total ) {`
107	`$donnees['entete']['href.suivant'] = $url_base . '/' . $this->serviceNom . '?'`	107	`$donnees['entete']['href.suivant'] = $url_base . '/' . $this->serviceNom . '?'`
108	`. 'navigation.depart=' . ($this->depart + $this->limite) . '&navigation.limite=' . $this->limite`	108	`. 'navigation.depart=' . ($this->depart + $this->limite) . '&navigation.limite=' . $this->limite`
109	`. '&retour.tri=' . $this->tri . '&retour.ordre=' . $this->tri_dir`	109	`. '&retour.tri=' . $this->tri . '&retour.ordre=' . $this->tri_dir`
110	`. '&' . $masqueEnParams;`	110	`. ($masqueEnParams ? '&' . $masqueEnParams : '');`
111	`}`	111	`}`
112	`$donnees['resultat'] = $noms;`	112	`$donnees['resultat'] = $noms;`
113		113
114	`return $donnees;`	114	`return $donnees;`
115	`}`	115	`}`
116		116
117	`/**`	117	`/**`
118	`* Renvoie la liste des noms répertoriés par chorodep; si un masque a été`	118	`* Renvoie la liste des noms répertoriés par chorodep; si un masque a été`
119	`* défini sur une zone géographique, retourne aussi la présence sur cette zone`	119	`* défini sur une zone géographique, retourne aussi la présence sur cette zone`
120	`*/`	120	`*/`
121	`protected function listeNoms() {`	121	`protected function listeNoms() {`
122	`$req = "SELECT DISTINCT num_nom, nom_sci";`	122	`$req = "SELECT DISTINCT num_nom, nom_sci";`
123	`if (isset($this->masque['zone-geo']) && $this->masque['zone-geo'] != null) {`	123	`if (isset($this->masque['zone-geo']) && $this->masque['zone-geo'] != null) {`
124	$req .= ", `" . $this->masque['zone-geo'] . "` as presence";	124	$req .= ", `" . $this->masque['zone-geo'] . "` as presence";
125	`}`	125	`}`
126	`$req .= " FROM " . $this->table;`	126	`$req .= " FROM " . $this->table;`
127	`$req .= $this->construireWhere();`	127	`$req .= $this->construireWhere();`
128	`$req .= " ORDER BY ".$this->tri." ".$this->tri_dir." ";`	128	`$req .= " ORDER BY ".$this->tri." ".$this->tri_dir." ";`
129	`$req .= " LIMIT " . $this->depart . ", " . $this->limite;`	129	`$req .= " LIMIT " . $this->depart . ", " . $this->limite;`
130		130
131	`$resultat = $this->getBdd()->recupererTous($req);`	131	`$resultat = $this->getBdd()->recupererTous($req);`
132		132
133	`return $resultat;`	133	`return $resultat;`
134	`}`	134	`}`
135		135
136	`protected function compterNoms() {`	136	`protected function compterNoms() {`
137	`$req = "SELECT count(DISTINCT num_nom, nom_sci) AS compte FROM " . $this->table;`	137	`$req = "SELECT count(DISTINCT num_nom, nom_sci) AS compte FROM " . $this->table;`
138	`$req .= $this->construireWhere();`	138	`$req .= $this->construireWhere();`
139	`$resultat = $this->getBdd()->recuperer($req);`	139	`$resultat = $this->getBdd()->recuperer($req);`
140		140
141	`return $resultat['compte'];`	141	`return $resultat['compte'];`
142	`}`	142	`}`
143		143
144	`protected function construireWhere() {`	144	`protected function construireWhere() {`
145	`$where = "";`	145	`$where = "";`
146	`$conditions = array();`	146	`$conditions = array();`
147	`// élimination des entrées sans nn valide`	147	`// élimination des entrées sans nn valide`
148	`$conditions[] = "CAST(num_nom AS decimal) != 0";`	148	`$conditions[] = "CAST(num_nom AS decimal) != 0";`
149	`// masque`	149	`// masque`
150	`if(!empty($this->masque)) {`	150	`if(!empty($this->masque)) {`
151	`if(isset($this->masque['nom'])) {`	151	`if(isset($this->masque['nom'])) {`
152	`$masqueNom = $this->getBdd()->proteger($this->masque['nom']);`	152	`$masqueNom = $this->getBdd()->proteger($this->masque['nom']);`
153	`$conditions[] = "nom_sci LIKE $masqueNom";`	153	`$conditions[] = "nom_sci LIKE $masqueNom";`
154	`}`	154	`}`
155	`if(isset($this->masque['zone-geo'])) {`	155	`if(isset($this->masque['zone-geo'])) {`
156	`$masqueZg = $this->masque['zone-geo'];`	156	`$masqueZg = $this->masque['zone-geo'];`
157	$conditions[] = "`$masqueZg` in ('1', '1?')";	157	$conditions[] = "`$masqueZg` in ('1', '1?')";
158	`}`	158	`}`
159	`}`	159	`}`
160	`$where = " WHERE " . implode(' AND ', $conditions);`	160	`$where = " WHERE " . implode(' AND ', $conditions);`
161	`return $where;`	161	`return $where;`
162	`}`	162	`}`
163	`}`	163	`}`
164	`?>`	164	`?>`