Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 702 Rev 707
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']) ? $this->bdd->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']) ? $this->bdd->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']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['taxon'].'%')) : null;
 50 
		$this->parametres['tag'] = isset($_GET['tag']) ? $this->verifierSecuriteParametreUrl($_GET['tag']) : null;
50 
		$this->parametres['start'] = isset($_GET['start']) ? $this->verifierSecuriteParametreUrl($_GET['start']) : null;
 51 
		$this->parametres['start'] = isset($_GET['start']) ? $this->verifierSecuriteParametreUrl($_GET['start']) : null;
51 
		$this->parametres['limit'] = isset($_GET['limit']) ? $this->verifierSecuriteParametreUrl($_GET['limit']) : null;
 52 
		$this->parametres['limit'] = isset($_GET['limit']) ? $this->verifierSecuriteParametreUrl($_GET['limit']) : null;
Line 52... Line 53...
52 
	}
 53 
	}
53
- 
 
54 
	private function getListeUtilisateursNbrePhotos() {
 - 
 
55 
		$requete = $this->construireRequeteListeUtilisateurNbrePhoto();
 54
- 
 
 55 
	private function getListeUtilisateursNbrePhotos() {
- 
 
 56 
		$liste = array();
- 
 
 57
- 
 
 58 
		$requete = $this->construireRequeteListeUtilisateurNbrePhoto();
- 
 
 59 
		if ($requete != null) {
56 
		$resultats = $this->executerRequete($requete);
 60 
			$resultats = $this->executerRequete($requete);
57 
		$liste = array();
 61
58 
		if ($resultats != false) {
 62 
			if ($resultats != false) {
- 
 
 63 
				foreach ($resultats as $resultat) {
59 
			foreach ($resultats as $resultat) {
 64 
					$liste[$resultat['identifiant']] = $resultat['nbre'];
60 
				$liste[$resultat['identifiant']] = $resultat['nbre'];
 65 
				}
61 
			}
 66 
			}
62 
		}
 67 
		}
Line 71... Line 76...
71 
		$where = 	'WHERE transmission = 1 ';
 76 
		$where = 	'WHERE transmission = 1 ';
72 
		$groupBy = 	'GROUP BY identifiant ';
 77 
		$groupBy = 	'GROUP BY identifiant ';
73 
		$orderBy = 	'ORDER BY nbre DESC ';
 78 
		$orderBy = 	'ORDER BY nbre DESC ';
74 
		$limitSql =	'LIMIT 0,150 ';
 79 
		$limitSql =	'LIMIT 0,150 ';
Line 75... Line -...
75
- 
 
- 
 
 80
76
81 
		$zero_images = false;
77 
		if (count($this->parametres) != 0) {
 82 
		if (count($this->parametres) != 0) {
Line 78... Line 83...
78 
			extract($this->parametres);
 83 
			extract($this->parametres);
Line 86... Line 91...
86 
				$filtres[] = "num_taxon = $num_taxon ";
 91 
				$filtres[] = "num_taxon = $num_taxon ";
87 
			}
 92 
			}
88 
			if (isset($taxon)) {
 93 
			if (isset($taxon)) {
89 
				$filtres[] = "nom_ret LIKE $taxon ";
 94 
				$filtres[] = "nom_ret LIKE $taxon ";
90 
			}
 95 
			}
- 
 
 96 
			if (isset($tag)) {
- 
 
 97 
				$limitation = $this->construireWhereTags();
- 
 
 98 
				if ($limitation != null) {
- 
 
 99 
					$filtres[] = $limitation;
- 
 
 100 
				} else {
- 
 
 101 
					$zero_images = true;
- 
 
 102 
				}
- 
 
 103 
			}
91 
			$where .= ((count($filtres) > 0) ? 'AND '.implode(' AND ', $filtres) : '');
 104 
			$where .= ((count($filtres) > 0) ? 'AND '.implode(' AND ', $filtres) : '');
Line 92... Line 105...
92
105
93 
			if (isset($start)) {
 106 
			if (isset($start)) {
94 
				$limitSql = str_replace('0,', "$start,", $limitSql);
 107 
				$limitSql = str_replace('0,', "$start,", $limitSql);
95 
			}
 108 
			}
96 
			if (isset($limit)) {
 109 
			if (isset($limit)) {
97 
				$limitSql = str_replace('150', $limit, $limitSql);
 110 
				$limitSql = str_replace('150', $limit, $limitSql);
98 
			}
 111 
			}
- 
 
 112 
		}
- 
 
 113 
		if ($zero_images) {
99 
		}
 114 
			$requete = null;
100
115 
		} else {
- 
 
 116 
			$requete = $select.$from.$where.$groupBy.$orderBy.$limitSql;
101 
		$requete = $select.$from.$where.$groupBy.$orderBy.$limitSql;
 117 
			//echo $requete;
102
118 
		}
103 
		return $requete;
 119 
		return $requete;
Line -... Line 120...
- 
 
 120 
	}
- 
 
 121
- 
 
 122 
	private function construireWhereTags() {
- 
 
 123 
		$where = null;
- 
 
 124 
		if (isset($this->parametres['tag'])) {
- 
 
 125 
			$tag = $this->parametres['tag'];
- 
 
 126 
			$tag_encode = $this->bdd->quote($this->encoderMotCle(trim($tag)));
- 
 
 127 
 
- 
 
 128 
			// Construction de la requête
- 
 
 129 
			$requete = 	'SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire '.
- 
 
 130 
				'FROM cel_mots_cles_images '.
- 
 
 131 
				"WHERE cmc_id_mot_cle_general = $tag_encode ";
- 
 
 132 
			$elements = $this->executerRequete($requete);
- 
 
 133
- 
 
 134 
			if ($elements != false && count($elements) > 0) {
- 
 
 135 
				// Pré-construction du where de la requête
- 
 
 136 
				$tpl_where = '(ci_meta_mots_cles LIKE "%%%s%%" AND ci_ce_utilisateur = %s )';
- 
 
 137 
				$requete_where = array();
- 
 
 138 
				foreach ($elements as $occurence) {
- 
 
 139 
					$requete_where[] = sprintf($tpl_where, $occurence['cmc_id_mot_cle_utilisateur'], $this->bdd->quote($occurence['cmc_id_proprietaire']));
- 
 
 140 
				}
- 
 
 141 
				$where = ' ('.implode(" \nOR ", $requete_where).') ';
- 
 
 142 
			} else {
- 
 
 143 
				$this->debug[] = "Aucune image ne correspond à ce mot clé.";
- 
 
 144 
			}
- 
 
 145 
		}
- 
 
 146 
		return $where;
104 
	}
 147 
	}
105
148
106 
	private function getListeTaxonsNbrePhotos() {
 149 
	private function getListeTaxonsNbrePhotos() {
107 
		$requete = $this->construireRequeteListeTaxonNbrePhoto();
 150 
		$requete = $this->construireRequeteListeTaxonNbrePhoto();
108 
		$resultats = $this->executerRequete($requete);
 151 
		$resultats = $this->executerRequete($requete);