| 346,7 → 346,7 |
|---|
| public function getObservations($params) { |
| $resultats = array(); |
| $total = 0; |
| $transmission = ( $this->standard = 0) ? "transmission = '1' " : ""; |
| $transmission = ( $this->standard = 0) ? "transmission = '1' " : " 1 "; |
| |
| if (isset($this->parametres['station']) && !$this->etreNull($this->parametres['station'])) { |
| $requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, pseudo_utilisateur as nom_utilisateur, "" as prenom_utilisateur, '. |
| 981,7 → 981,7 |
|---|
| private function construireWherePhotosSeulement() { |
| $sql = ''; |
| if (isset($this->parametres['photos']) && $this->parametres['photos'] == 1) { |
| $sql = 'AND co.id_observation IN (SELECT DISTINCT ce_observation FROM cel_images_export) '; |
| $sql = 'AND co.images is not null) '; |
| } |
| return $sql; |
| } |
| 1145,7 → 1145,7 |
|---|
| */ |
| private function getSqlWhereObsAvecImagesTaguees($tag) { |
| $sql = null; |
| $transmission = ( $this->standard = 0) ? "co.transmission = '1' " : ""; |
| $transmission = ( $this->standard = 0) ? "co.transmission = '1' " : " 1 "; |
| if (isset($tag) && !$this->etreNull($tag)) { |
| $tag_sql = $this->getSqlWhereMotsCles($tag); |
| // Construction de la requête |