| 44,9 → 44,9 |
|---|
| } |
| |
| private function analyserParametresUrl() { |
| $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['utilisateur'] = isset($_GET['utilisateur']) ? Cel::db()->quote($this->verifierSecuriteParametreUrl($_GET['utilisateur'])) : null; |
| $this->parametres['num_taxon'] = isset($_GET['num_taxon']) ? Cel::db()->quote($this->verifierSecuriteParametreUrl($_GET['num_taxon'])) : null; |
| $this->parametres['taxon'] = isset($_GET['taxon']) ? Cel::db()->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; |
| 57,7 → 57,7 |
|---|
| |
| $requete = $this->construireRequeteListeUtilisateurNbrePhoto(); |
| if ($requete != null) { |
| $resultats = $this->executerRequete($requete); |
| $resultats = Cel::db()->executerRequete($requete); |
| if ($resultats != false) { |
| foreach ($resultats as $resultat) { |
| $liste[$resultat['courriel_utilisateur']] = $resultat['nbre']; |
| 122,13 → 122,13 |
|---|
| $where = null; |
| if (isset($this->parametres['tag'])) { |
| $tag = $this->parametres['tag']; |
| $tag_encode = $this->bdd->quote($this->encoderMotCle(trim($tag))); |
| $tag_encode = Cel::db()->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); |
| $elements = Cel::db()->executerRequete($requete); |
| |
| if ($elements != false && count($elements) > 0) { |
| // Pré-construction du where de la requête |
| 135,7 → 135,7 |
|---|
| $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'])); |
| $requete_where[] = sprintf($tpl_where, $occurence['cmc_id_mot_cle_utilisateur'], Cel::db()->quote($occurence['cmc_id_proprietaire'])); |
| } |
| $where = ' ('.implode(" \nOR ", $requete_where).') '; |
| } else { |
| 148,7 → 148,7 |
|---|
| private function getListeTaxonsNbrePhotos() { |
| $requete = $this->construireRequeteListeTaxonNbrePhoto(); |
| |
| $resultats = $this->executerRequete($requete); |
| $resultats = Cel::db()->executerRequete($requete); |
| $liste = array(); |
| if ($resultats != false) { |
| foreach ($resultats as $resultat) { |
| 202,24 → 202,24 |
|---|
| private function getNombres() { |
| |
| $requete = $this->construireRequeteNbreObs(); |
| $info['observations'] = (int) $this->executerRequete($requete, 'Column'); |
| $info['observations'] = (int) Cel::db()->executerRequete($requete, 'Column'); |
| |
| $requete = $this->construireRequeteNbreObsPubliques(); |
| $info['observationsPubliques'] = (int) $this->executerRequete($requete, 'Column'); |
| $info['observationsPubliques'] = (int) Cel::db()->executerRequete($requete, 'Column'); |
| |
| $requete = $this->construireRequeteNbreImg(); |
| $info['images'] =(int) $this->executerRequete($requete, 'Column'); |
| $info['images'] =(int) Cel::db()->executerRequete($requete, 'Column'); |
| |
| $requete = $this->construireRequeteNbreImgLiees(); |
| $info['imagesLiees'] =(int) $this->executerRequete($requete, 'Column'); |
| $info['imagesLiees'] =(int) Cel::db()->executerRequete($requete, 'Column'); |
| |
| $requete = $this->construireRequeteNbreObsLiees(); |
| $info['observationsLiees'] = (int) $this->executerRequete($requete, 'Column'); |
| $info['observationsLiees'] = (int) Cel::db()->executerRequete($requete, 'Column'); |
| |
| $info['moyImagesParObs'] = ($info['observationsLiees'] > 0 ? round($info['imagesLiees']/$info['observationsLiees'], 2) : ''); |
| |
| $requete = $this->construireRequeteNbreObsParCommune(); |
| $info['communes'] = ($resultats = $this->executerRequete($requete)) ? count($resultats) : '' ; |
| $info['communes'] = ($resultats = Cel::db()->executerRequete($requete)) ? count($resultats) : '' ; |
| $info['observationsParCommunesMin'] = 1000; |
| $info['observationsParCommunesMax'] = 0; |
| $info['observationsParCommunesTotal'] = 0; |