| 47,17 → 47,22 |
|---|
| $this->parametres['utilisateur'] = isset($_GET['utilisateur']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['utilisateur'])) : null; |
| $this->parametres['num_taxon'] = isset($_GET['num_taxon']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['num_taxon'])) : null; |
| $this->parametres['taxon'] = isset($_GET['taxon']) ? $this->bdd->quote($this->verifierSecuriteParametreUrl($_GET['taxon'].'%')) : null; |
| $this->parametres['tag'] = isset($_GET['tag']) ? $this->verifierSecuriteParametreUrl($_GET['tag']) : null; |
| $this->parametres['start'] = isset($_GET['start']) ? $this->verifierSecuriteParametreUrl($_GET['start']) : null; |
| $this->parametres['limit'] = isset($_GET['limit']) ? $this->verifierSecuriteParametreUrl($_GET['limit']) : null; |
| } |
| |
| private function getListeUtilisateursNbrePhotos() { |
| $liste = array(); |
| |
| $requete = $this->construireRequeteListeUtilisateurNbrePhoto(); |
| $resultats = $this->executerRequete($requete); |
| $liste = array(); |
| if ($resultats != false) { |
| foreach ($resultats as $resultat) { |
| $liste[$resultat['identifiant']] = $resultat['nbre']; |
| if ($requete != null) { |
| $resultats = $this->executerRequete($requete); |
| |
| if ($resultats != false) { |
| foreach ($resultats as $resultat) { |
| $liste[$resultat['identifiant']] = $resultat['nbre']; |
| } |
| } |
| } |
| return $liste; |
| 73,7 → 78,7 |
|---|
| $orderBy = 'ORDER BY nbre DESC '; |
| $limitSql = 'LIMIT 0,150 '; |
| |
| |
| $zero_images = false; |
| if (count($this->parametres) != 0) { |
| extract($this->parametres); |
| |
| 88,6 → 93,14 |
|---|
| if (isset($taxon)) { |
| $filtres[] = "nom_ret LIKE $taxon "; |
| } |
| if (isset($tag)) { |
| $limitation = $this->construireWhereTags(); |
| if ($limitation != null) { |
| $filtres[] = $limitation; |
| } else { |
| $zero_images = true; |
| } |
| } |
| $where .= ((count($filtres) > 0) ? 'AND '.implode(' AND ', $filtres) : ''); |
| |
| if (isset($start)) { |
| 97,12 → 110,42 |
|---|
| $limitSql = str_replace('150', $limit, $limitSql); |
| } |
| } |
| |
| $requete = $select.$from.$where.$groupBy.$orderBy.$limitSql; |
| |
| if ($zero_images) { |
| $requete = null; |
| } else { |
| $requete = $select.$from.$where.$groupBy.$orderBy.$limitSql; |
| //echo $requete; |
| } |
| return $requete; |
| } |
| |
| private function construireWhereTags() { |
| $where = null; |
| if (isset($this->parametres['tag'])) { |
| $tag = $this->parametres['tag']; |
| $tag_encode = $this->bdd->quote($this->encoderMotCle(trim($tag))); |
| |
| // Construction de la requête |
| $requete = 'SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire '. |
| 'FROM cel_mots_cles_images '. |
| "WHERE cmc_id_mot_cle_general = $tag_encode "; |
| $elements = $this->executerRequete($requete); |
| |
| if ($elements != false && count($elements) > 0) { |
| // Pré-construction du where de la requête |
| $tpl_where = '(ci_meta_mots_cles LIKE "%%%s%%" AND ci_ce_utilisateur = %s )'; |
| $requete_where = array(); |
| foreach ($elements as $occurence) { |
| $requete_where[] = sprintf($tpl_where, $occurence['cmc_id_mot_cle_utilisateur'], $this->bdd->quote($occurence['cmc_id_proprietaire'])); |
| } |
| $where = ' ('.implode(" \nOR ", $requete_where).') '; |
| } else { |
| $this->debug[] = "Aucune image ne correspond à ce mot clé."; |
| } |
| } |
| return $where; |
| } |
| |
| private function getListeTaxonsNbrePhotos() { |
| $requete = $this->construireRequeteListeTaxonNbrePhoto(); |
| $resultats = $this->executerRequete($requete); |