| 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) : ''); |