Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 1358 → Rev 1359

/trunk/jrest/services/CelStatistiqueTxt.php
57,11 → 57,10
$requete = $this->construireRequeteListeUtilisateurNbrePhoto();
if ($requete != null) {
$resultats = $this->executerRequete($requete);
$resultats = $this->executerRequete($requete);
if ($resultats != false) {
foreach ($resultats as $resultat) {
$liste[$resultat['identifiant']] = $resultat['nbre'];
$liste[$resultat['courriel_utilisateur']] = $resultat['nbre'];
}
}
}
69,17 → 68,16
}
private function construireRequeteListeUtilisateurNbrePhoto() {
$select = 'SELECT identifiant, COUNT(DISTINCT ci_id_image) AS nbre ';
$from = 'FROM cel_inventory '.
' LEFT JOIN cel_obs_images ON (coi_ce_observation = ordre AND coi_ce_utilisateur = identifiant) '.
' LEFT JOIN cel_images ON (coi_ce_image = ci_id_image) ';
$select = 'SELECT co.courriel_utilisateur, COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_obs co '.
' LEFT JOIN cel_obs_images coi ON (coi.id_observation = co.id_observation) '.
' LEFT JOIN cel_images ci ON (coi.id_image = ci.id_image) ';
$where = 'WHERE transmission = 1 ';
$groupBy = 'GROUP BY identifiant ';
$groupBy = 'GROUP BY co.courriel_utilisateur ';
$orderBy = 'ORDER BY nbre DESC ';
$limitSql = 'LIMIT 0,150 ';
$zero_images = false;
if (count($this->parametres) != 0) {
extract($this->parametres);
86,10 → 84,10
$filtres = array();
if (isset($utilisateur)) {
$filtres[] = "identifiant = $utilisateur ";
$filtres[] = "co.courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
$filtres[] = "nt = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "nom_ret LIKE $taxon ";
149,6 → 147,7
private function getListeTaxonsNbrePhotos() {
$requete = $this->construireRequeteListeTaxonNbrePhoto();
 
$resultats = $this->executerRequete($requete);
$liste = array();
if ($resultats != false) {
160,10 → 159,10
}
private function construireRequeteListeTaxonNbrePhoto() {
$select = 'SELECT nom_ret, COUNT(DISTINCT ci_id_image) AS nbre ';
$from = 'FROM cel_inventory '.
' LEFT JOIN cel_obs_images ON (coi_ce_observation = ordre AND coi_ce_utilisateur = identifiant) '.
' LEFT JOIN cel_images ON (coi_ce_image = ci_id_image) ';
$select = 'SELECT nom_ret, COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_obs co '.
' LEFT JOIN cel_obs_images coi ON (coi.id_observation = co.id_observation) '.
' LEFT JOIN cel_images ci ON (coi.id_image = ci.id_image) ';
$where = 'WHERE transmission = 1 '.
" AND nom_ret != '' ";
$groupBy = 'GROUP BY nom_ret ';
177,10 → 176,10
$filtres = array();
if (isset($utilisateur)) {
$filtres[] = "identifiant = $utilisateur ";
$filtres[] = "co.courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
$filtres[] = "nt = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "nom_ret LIKE $taxon ";
196,6 → 195,7
}
$requete = $select.$from.$where.$groupBy.$orderBy.$limitSql;
 
return $requete;
}
238,8 → 238,8
}
private function construireRequeteNbreObs() {
$requete = 'SELECT COUNT(id) AS nbre '.
'FROM cel_inventory ';
$requete = 'SELECT COUNT(id_observation) AS nbre '.
'FROM cel_obs ';
 
if (count($this->parametres) != 0) {
$filtres = array();
246,7 → 246,7
extract($this->parametres);
if (isset($utilisateur)) {
$filtres[] = "identifiant = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
257,13 → 257,13
$requete .= ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : '');
}
 
return $requete;
}
private function construireRequeteNbreObsPubliques() {
$requete = 'SELECT COUNT(id) AS nbre '.
'FROM cel_inventory '.
$requete = 'SELECT COUNT(id_observation) AS nbre '.
'FROM cel_obs '.
"WHERE transmission = 1 ";
 
if (count($this->parametres) != 0) {
271,7 → 271,7
extract($this->parametres);
if (isset($utilisateur)) {
$filtres[] = "identifiant = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
287,11 → 287,11
}
private function construireRequeteNbreObsParCommune() {
$requete = 'SELECT COUNT(id) AS nbre '.
'FROM cel_inventory '.
"WHERE location != '000null' ".
" AND id_location != '000null' ";
$groupBy = 'GROUP BY location, id_location';
$requete = 'SELECT COUNT(id_observation) AS nbre '.
'FROM cel_obs '.
"WHERE zone_geo IS NOT NULL ".
" AND ce_zone_geo IS NOT NULL ";
$groupBy = 'GROUP BY zone_geo, ce_zone_geo';
 
if (count($this->parametres) != 0) {
$filtres = array();
298,10 → 298,10
extract($this->parametres);
if (isset($utilisateur)) {
$filtres[] = "identifiant = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
$filtres[] = "nt = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "nom_ret LIKE $taxon ";
315,8 → 315,8
}
private function construireRequeteNbreImg() {
$select = 'SELECT COUNT(DISTINCT ci_id_image) AS nbre ';
$from = 'FROM cel_images ';
$select = 'SELECT COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_images ci ';
if (count($this->parametres) != 0) {
$filtres = array();
324,31 → 324,31
extract($this->parametres);
if (isset($utilisateur)) {
$filtres[] = "ci_ce_utilisateur = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
$filtres[] = "nt = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "nom_ret LIKE $taxon ";
}
if (isset($num_taxon) || isset($taxon)) {
$from .= 'LEFT JOIN cel_obs_images ON (coi_ce_image = ci_id_image) '.
'LEFT JOIN cel_inventory ON (coi_ce_observation = ordre AND coi_ce_utilisateur = identifiant) ';
$from .= 'LEFT JOIN cel_obs_images coi ON (coi.id_image = ci.id_image) '.
'LEFT JOIN cel_obs co ON (coi.id_observation = co.id_observation) ';
}
$where = ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : '');
}
$requete = $select.$from.$where;
 
return $requete;
}
private function construireRequeteNbreImgLiees() {
$select = 'SELECT COUNT(DISTINCT ci_id_image) AS nbre ';
$from = 'FROM cel_obs_images '.
' LEFT JOIN cel_images ON (coi_ce_image = ci_id_image) ';
$select = 'SELECT COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_obs_images coi '.
' LEFT JOIN cel_images ci ON (coi.id_image = ci.id_image) ';
if (count($this->parametres) != 0) {
$filtres = array();
356,10 → 356,10
extract($this->parametres);
if (isset($utilisateur)) {
$filtres[] = "coi_ce_utilisateur = $utilisateur ";
$filtres[] = "ci.courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
$filtres[] = "nt = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "nom_ret LIKE $taxon ";
366,7 → 366,7
}
if (isset($num_taxon) || isset($taxon)) {
$from .= 'LEFT JOIN cel_inventory ON (coi_ce_observation = ordre AND coi_ce_utilisateur = identifiant) ';
$from .= 'LEFT JOIN cel_obs ON (coi.id_observation = co.id_observation) ';
}
$where = ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : '');
377,9 → 377,9
}
private function construireRequeteNbreObsLiees() {
$select = 'SELECT COUNT(DISTINCT coi_ce_observation) AS nbre ';
$from = 'FROM cel_obs_images '.
' LEFT JOIN cel_inventory ON (coi_ce_observation = ordre AND coi_ce_utilisateur = identifiant) ';
$select = 'SELECT COUNT(DISTINCT coi.id_observation) AS nbre ';
$from = 'FROM cel_obs_images coi '.
' LEFT JOIN cel_obs co ON (coi.id_observation = co.id_observation) ';
if (count($this->parametres) != 0) {
$filtres = array();
387,10 → 387,10
extract($this->parametres);
if (isset($utilisateur)) {
$filtres[] = "identifiant = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "num_taxon = $num_taxon ";
$filtres[] = "nt = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "nom_ret LIKE $taxon ";