Subversion Repositories eFlore/Applications.cel

Rev

Rev 1359 | Rev 2143 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1359 Rev 1765
Line 42... Line 42...
42 
			$this->envoyerJson($stats);
 42 
			$this->envoyerJson($stats);
43 
		}
 43 
		}
44 
	}
 44 
	}
Line 45... Line 45...
45
45
46 
	private function analyserParametresUrl() {
 46 
	private function analyserParametresUrl() {
47 
		$this->parametres['utilisateur'] = isset($_GET['utilisateur']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['utilisateur'])) : null;
 47 
		$this->parametres['utilisateur'] = isset($_GET['utilisateur']) ? Cel::db()->quote($this->verifierSecuriteParametreUrl($_GET['utilisateur'])) : null;
48 
		$this->parametres['num_taxon'] = isset($_GET['num_taxon']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['num_taxon'])) : null;
 48 
		$this->parametres['num_taxon'] = isset($_GET['num_taxon']) ? Cel::db()->quote($this->verifierSecuriteParametreUrl($_GET['num_taxon'])) : null;
49 
		$this->parametres['taxon'] = isset($_GET['taxon']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['taxon'].'%')) : null;
 49 
		$this->parametres['taxon'] = isset($_GET['taxon']) ? Cel::db()->quote($this->verifierSecuriteParametreUrl($_GET['taxon'].'%')) : null;
50 
		$this->parametres['tag'] = isset($_GET['tag']) ? $this->verifierSecuriteParametreUrl($_GET['tag']) : null;
 50 
		$this->parametres['tag'] = isset($_GET['tag']) ? $this->verifierSecuriteParametreUrl($_GET['tag']) : null;
51 
		$this->parametres['start'] = isset($_GET['start']) ? $this->verifierSecuriteParametreUrl($_GET['start']) : null;
 51 
		$this->parametres['start'] = isset($_GET['start']) ? $this->verifierSecuriteParametreUrl($_GET['start']) : null;
52 
		$this->parametres['limit'] = isset($_GET['limit']) ? $this->verifierSecuriteParametreUrl($_GET['limit']) : null;
 52 
		$this->parametres['limit'] = isset($_GET['limit']) ? $this->verifierSecuriteParametreUrl($_GET['limit']) : null;
Line 53... Line 53...
53 
	}
 53 
	}
54
54
Line 55... Line 55...
55 
	private function getListeUtilisateursNbrePhotos() {
 55 
	private function getListeUtilisateursNbrePhotos() {
56 
		$liste = array();
 56 
		$liste = array();
57
57
58 
		$requete = $this->construireRequeteListeUtilisateurNbrePhoto();
 58 
		$requete = $this->construireRequeteListeUtilisateurNbrePhoto();
59 
		if ($requete != null) {
 59 
		if ($requete != null) {
60 
			$resultats = $this->executerRequete($requete);
60 
			$resultats = Cel::db()->executerRequete($requete);
61 
			if ($resultats != false) {
 61 
			if ($resultats != false) {
62 
				foreach ($resultats as $resultat) {
 62 
				foreach ($resultats as $resultat) {
Line 120... Line 120...
120
120
121 
	private function construireWhereTags() {
 121 
	private function construireWhereTags() {
122 
		$where = null;
 122 
		$where = null;
123 
		if (isset($this->parametres['tag'])) {
 123 
		if (isset($this->parametres['tag'])) {
124 
			$tag = $this->parametres['tag'];
 124 
			$tag = $this->parametres['tag'];
Line 125... Line 125...
125 
			$tag_encode = $this->bdd->quote($this->encoderMotCle(trim($tag)));
 125 
			$tag_encode = Cel::db()->quote($this->encoderMotCle(trim($tag)));
126 
 
 126 
 
127 
			// Construction de la requête
 127 
			// Construction de la requête
128 
			$requete = 	'SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire '.
 128 
			$requete = 	'SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire '.
129 
				'FROM cel_mots_cles_images '.
 129 
				'FROM cel_mots_cles_images '.
Line 130... Line 130...
130 
				"WHERE cmc_id_mot_cle_general = $tag_encode ";
 130 
				"WHERE cmc_id_mot_cle_general = $tag_encode ";
131 
			$elements = $this->executerRequete($requete);
 131 
			$elements = Cel::db()->executerRequete($requete);
132
132
133 
			if ($elements != false && count($elements) > 0) {
 133 
			if ($elements != false && count($elements) > 0) {
134 
				// Pré-construction du where de la requête
 134 
				// Pré-construction du where de la requête
135 
				$tpl_where = '(ci_meta_mots_cles LIKE "%%%s%%" AND ci_ce_utilisateur = %s )';
 135 
				$tpl_where = '(ci_meta_mots_cles LIKE "%%%s%%" AND ci_ce_utilisateur = %s )';
136 
				$requete_where = array();
 136 
				$requete_where = array();
137 
				foreach ($elements as $occurence) {
 137 
				foreach ($elements as $occurence) {
138 
					$requete_where[] = sprintf($tpl_where, $occurence['cmc_id_mot_cle_utilisateur'], $this->bdd->quote($occurence['cmc_id_proprietaire']));
 138 
					$requete_where[] = sprintf($tpl_where, $occurence['cmc_id_mot_cle_utilisateur'], Cel::db()->quote($occurence['cmc_id_proprietaire']));
139 
				}
 139 
				}
140 
				$where = ' ('.implode(" \nOR ", $requete_where).') ';
 140 
				$where = ' ('.implode(" \nOR ", $requete_where).') ';
Line 146... Line 146...
146 
	}
 146 
	}
Line 147... Line 147...
147
147
148 
	private function getListeTaxonsNbrePhotos() {
 148 
	private function getListeTaxonsNbrePhotos() {
Line 149... Line 149...
149 
		$requete = $this->construireRequeteListeTaxonNbrePhoto();
 149 
		$requete = $this->construireRequeteListeTaxonNbrePhoto();
150 
 
 150 
 
151 
		$resultats = $this->executerRequete($requete);
 151 
		$resultats = Cel::db()->executerRequete($requete);
152 
		$liste = array();
 152 
		$liste = array();
153 
		if ($resultats != false) {
 153 
		if ($resultats != false) {
154 
			foreach ($resultats as $resultat) {
 154 
			foreach ($resultats as $resultat) {
Line 200... Line 200...
200 
	}
 200 
	}
Line 201... Line 201...
201
201
Line 202... Line 202...
202 
	private function getNombres() {
 202 
	private function getNombres() {
203 
 
 203 
 
Line 204... Line 204...
204 
		$requete = $this->construireRequeteNbreObs();
204 
		$requete = $this->construireRequeteNbreObs();
205 
		$info['observations'] = (int) $this->executerRequete($requete, 'Column');
 205 
		$info['observations'] = (int) Cel::db()->executerRequete($requete, 'Column');
Line 206... Line 206...
206
206
207 
		$requete = $this->construireRequeteNbreObsPubliques();
207 
		$requete = $this->construireRequeteNbreObsPubliques();
Line 208... Line 208...
208 
		$info['observationsPubliques'] = (int) $this->executerRequete($requete, 'Column');
 208 
		$info['observationsPubliques'] = (int) Cel::db()->executerRequete($requete, 'Column');
209
209
Line 210... Line 210...
210 
		$requete = $this->construireRequeteNbreImg();
 210 
		$requete = $this->construireRequeteNbreImg();
211 
		$info['images'] =(int) $this->executerRequete($requete, 'Column');
 211 
		$info['images'] =(int) Cel::db()->executerRequete($requete, 'Column');
Line 212... Line 212...
212
212
Line 213... Line 213...
213 
		$requete = $this->construireRequeteNbreImgLiees();
 213 
		$requete = $this->construireRequeteNbreImgLiees();
214 
		$info['imagesLiees'] =(int) $this->executerRequete($requete, 'Column');
 214 
		$info['imagesLiees'] =(int) Cel::db()->executerRequete($requete, 'Column');
215
215
216 
		$requete = $this->construireRequeteNbreObsLiees();
 216 
		$requete = $this->construireRequeteNbreObsLiees();
217 
		$info['observationsLiees'] = (int) $this->executerRequete($requete, 'Column');
 217 
		$info['observationsLiees'] = (int) Cel::db()->executerRequete($requete, 'Column');
218
218
219 
		$info['moyImagesParObs'] = ($info['observationsLiees'] > 0 ? round($info['imagesLiees']/$info['observationsLiees'], 2) : '');
 219 
		$info['moyImagesParObs'] = ($info['observationsLiees'] > 0 ? round($info['imagesLiees']/$info['observationsLiees'], 2) : '');