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) : ''); |
247,8 → 247,8 |
|
private function construireRequeteNbreObsPubliques() { |
$requete = 'SELECT COUNT(id) AS nbre '. |
'FROM cel_obs '. |
"WHERE is_public = 1 "; |
'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 ". |