222,7 → 222,7 |
} |
|
private function construireRequeteNbreObs() { |
$requete = 'SELECT COUNT(id_observation) AS nbre '. |
$requete = 'SELECT COUNT(id) AS nbre '. |
'FROM cel_obs '; |
|
if (count($this->parametres) != 0) { |
230,13 → 230,13 |
extract($this->parametres); |
|
if (isset($utilisateur)) { |
$filtres[] = "courriel_utilisateur = $utilisateur "; |
$filtres[] = "user_email = $utilisateur "; |
} |
if (isset($num_taxon)) { |
$filtres[] = "num_taxon = $num_taxon "; |
$filtres[] = "accepted_sci_name_id = $num_taxon "; |
} |
if (isset($taxon)) { |
$filtres[] = "nom_ret LIKE $taxon "; |
$filtres[] = "accepted_sci_name LIKE $taxon "; |
} |
|
$requete .= ((count($filtres) > 0) ? 'WHERE '.implode(' AND ', $filtres) : ''); |
246,9 → 246,9 |
} |
|
private function construireRequeteNbreObsPubliques() { |
$requete = 'SELECT COUNT(id_observation) AS nbre '. |
$requete = 'SELECT COUNT(id) AS nbre '. |
'FROM cel_obs '. |
"WHERE transmission = 1 "; |
"WHERE is_public = 1 "; |
|
if (count($this->parametres) != 0) { |
$filtres = array(); |
255,13 → 255,13 |
extract($this->parametres); |
|
if (isset($utilisateur)) { |
$filtres[] = "courriel_utilisateur = $utilisateur "; |
$filtres[] = "user_email = $utilisateur "; |
} |
if (isset($num_taxon)) { |
$filtres[] = "num_taxon = $num_taxon "; |
$filtres[] = "accepted_sci_name_id = $num_taxon "; |
} |
if (isset($taxon)) { |
$filtres[] = "nom_ret LIKE $taxon "; |
$filtres[] = "accepted_sci_name LIKE $taxon "; |
} |
|
$requete .= ((count($filtres) > 0) ? 'AND '.implode(' AND ', $filtres) : ''); |