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) : '');
|