Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3833 → Rev 3834

/trunk/jrest/services/CelStatistiqueTxt.php
76,8 → 76,8
 
private function construireRequeteListeUtilisateurNbrePhoto() {
$select = 'SELECT co.courriel_utilisateur, COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_obs AS co '.
' LEFT JOIN cel_images AS ci ON (co.id_observation = ci.ce_observation) ';
$from = 'FROM cel_export_total AS co '.
' LEFT JOIN cel_images_export AS ci ON (co.id_observation = ci.ce_observation) ';
$where = 'WHERE co.transmission = 1 ';
$groupBy = 'GROUP BY co.courriel_utilisateur ';
$orderBy = 'ORDER BY nbre DESC ';
130,8 → 130,8
 
private function construireRequeteListeTaxonNbrePhoto() {
$select = 'SELECT nom_ret, COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_obs co '.
' LEFT JOIN cel_images ci ON (co.id_observation = ci.ce_observation) ';
$from = 'FROM cel_export_total co '.
' LEFT JOIN cel_images_export ci ON (co.id_observation = ci.ce_observation) ';
$where = 'WHERE co.transmission = 1 '.
" AND nom_ret != '' ";
$groupBy = 'GROUP BY nom_ret ';
222,8 → 222,8
}
 
private function construireRequeteNbreObs() {
$requete = 'SELECT COUNT(id) AS nbre '.
'FROM cel_obs ';
$requete = 'SELECT COUNT(*) AS nbre '.
'FROM cel_export_total ';
 
if (count($this->parametres) != 0) {
$filtres = array();
230,13 → 230,13
extract($this->parametres);
 
if (isset($utilisateur)) {
$filtres[] = "user_email = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "accepted_sci_name_id = $num_taxon ";
$filtres[] = "nom_ret_nn = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "accepted_sci_name LIKE $taxon ";
$filtres[] = "nom_ret LIKE $taxon ";
}
 
$requete .= ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : '');
246,9 → 246,9
}
 
private function construireRequeteNbreObsPubliques() {
$requete = 'SELECT COUNT(id) AS nbre '.
'FROM cel_obs '.
"WHERE is_public = 1 ";
$requete = 'SELECT COUNT(*) AS nbre '.
'FROM cel_export_total '.
"WHERE transmission = 1 ";
 
if (count($this->parametres) != 0) {
$filtres = array();
255,13 → 255,13
extract($this->parametres);
 
if (isset($utilisateur)) {
$filtres[] = "user_email = $utilisateur ";
$filtres[] = "courriel_utilisateur = $utilisateur ";
}
if (isset($num_taxon)) {
$filtres[] = "accepted_sci_name_id = $num_taxon ";
$filtres[] = "nom_ret_nn = $num_taxon ";
}
if (isset($taxon)) {
$filtres[] = "accepted_sci_name LIKE $taxon ";
$filtres[] = "nom_ret LIKE $taxon ";
}
 
$requete .= ((count($filtres) > 0) ? 'AND '.implode(' AND ', $filtres) : '');
272,7 → 272,7
 
private function construireRequeteNbreObsParCommune() {
$requete = 'SELECT COUNT(id_observation) AS nbre '.
'FROM cel_obs '.
'FROM cel_export_total '.
"WHERE zone_geo IS NOT NULL ".
" AND ce_zone_geo IS NOT NULL ";
$groupBy = 'GROUP BY zone_geo, ce_zone_geo';
300,7 → 300,7
 
private function construireRequeteNbreImg() {
$select = 'SELECT COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_images ci ';
$from = 'FROM cel_images_export ci ';
 
if (count($this->parametres) != 0) {
$filtres = array();
318,7 → 318,7
$filtres[] = "nom_ret LIKE $taxon ";
}
if (isset($num_taxon) || isset($taxon)) {
$from .= 'LEFT JOIN cel_obs co ON (ci.ce_observation = co.id_observation) ';
$from .= 'LEFT JOIN cel_export_total co ON (ci.ce_observation = co.id_observation) ';
}
 
$where = ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : '');
330,7 → 330,7
 
private function construireRequeteNbreImgLiees($publiquesSeulement=false) {
$select = 'SELECT COUNT(DISTINCT ci.id_image) AS nbre ';
$from = 'FROM cel_images ci ';
$from = 'FROM cel_images_export ci ';
 
if (count($this->parametres) != 0) {
$filtres = array();
351,7 → 351,7
}
 
if (isset($num_taxon) || isset($taxon)) {
$from .= 'LEFT JOIN cel_obs ON (ci.ce_observation = co.id_observation) ';
$from .= 'LEFT JOIN cel_export_total ON (ci.ce_observation = co.id_observation) ';
}
 
$where = ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : '');
363,8 → 363,8
 
private function construireRequeteNbreObsLiees() {
$select = 'SELECT COUNT(DISTINCT id_observation) AS nbre ';
$from = 'FROM cel_images ci '.
' LEFT JOIN cel_obs co ON (ci.ce_observation = co.id_observation) ';
$from = 'FROM cel_images_export ci '.
' LEFT JOIN cel_export_total co ON (ci.ce_observation = co.id_observation) ';
 
if (count($this->parametres) != 0) {
$filtres = array();
460,7 → 460,7
case 'obs':
$requete = "SELECT ce_utilisateur , prenom_utilisateur , nom_utilisateur , courriel_utilisateur , ".
" COUNT(*) AS nombreObs ".
"FROM cel_obs ".
"FROM cel_export_total ".
"WHERE transmission = 1 ".
"AND TO_DAYS(NOW()) - TO_DAYS(date_transmission) <= $jours ".
"GROUP BY ce_utilisateur ".
470,8 → 470,8
case 'img':
$requete = "SELECT co.ce_utilisateur , co.prenom_utilisateur , co.nom_utilisateur , ".
" co.courriel_utilisateur , COUNT(DISTINCT ci.id_image) AS nombreImg ".
"FROM cel_images ci ".
" RIGHT JOIN cel_obs co ON ci.ce_observation = co.id_observation ".
"FROM cel_images_export ci ".
" RIGHT JOIN cel_export_total co ON ci.ce_observation = co.id_observation ".
"WHERE co.transmission = 1 ".
"AND TO_DAYS(NOW()) - TO_DAYS(co.date_transmission) <= $jours ".
"GROUP BY co.ce_utilisateur ".
482,8 → 482,8
$requete = "SELECT co.ce_utilisateur, co.prenom_utilisateur, co.nom_utilisateur, co.courriel_utilisateur, ".
"COUNT(DISTINCT ci.id_image) AS nombreImg, COUNT(DISTINCT co.id_observation) AS nombreObs, ".
"COUNT(DISTINCT ci.id_image) + COUNT(DISTINCT co.id_observation) AS somme ".
"FROM cel_images ci ".
" RIGHT JOIN cel_obs co ON ci.ce_observation = co.id_observation ".
"FROM cel_images_export ci ".
" RIGHT JOIN cel_export_total co ON ci.ce_observation = co.id_observation ".
"WHERE co.transmission = 1 ".
"AND TO_DAYS(NOW()) - TO_DAYS(co.date_transmission) <= $jours ".
"GROUP BY co.ce_utilisateur ".