58,10 → 58,9 |
$requete = $this->construireRequeteListeUtilisateurNbrePhoto(); |
if ($requete != null) { |
$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 "; |
262,8 → 262,8 |
} |
|
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; |
|
$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 "; |