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 |