| 110,7 → 110,7 |
|---|
| |
| $emplacements = null; |
| $concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) "; |
| $transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
| $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : ""; |
| $requete = 'SELECT ce_zone_geo, zone_geo, station, '. |
| "mots_cles_texte, ". |
| "latitude, ". |
| 156,7 → 156,7 |
|---|
| private $nb_obs = 0; |
| |
| private function compterObservations($params) { |
| $transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
| $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : ""; |
| $requete = 'SELECT COUNT(*) as nb '. |
| 'FROM '.$this->table_export.' AS co '. |
| "WHERE ".$transmission. |
| 343,7 → 343,7 |
|---|
| public function getObservations($params) { |
| $resultats = array(); |
| $total = 0; |
| $transmission = ( $this->standard = 0) ? "transmission = '1' " : " 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, '. |
| 494,7 → 494,7 |
|---|
| */ |
| public function getTaxons($params) { |
| $json = null; |
| $transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
| $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : ""; |
| $requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '. |
| 'FROM '.$this->table_export.' AS co '. |
| "WHERE ".$transmission. |
| 753,7 → 753,7 |
|---|
| * Retour sous forme de tableau : array[identifiant] = array(ordre, ordre...); |
| */ |
| private function obtenirObsLieesImg($type, $param) { |
| $transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
| $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : ""; |
| // Construction de la requête |
| $requete = 'SELECT DISTINCT co.id_obs, co.ce_utilisateur AS utilisateur '. |
| 'FROM '.$this->table_export.' AS co '. |
| 1138,7 → 1138,7 |
|---|
| */ |
| private function getSqlWhereObsAvecImagesTaguees($tag) { |
| $sql = null; |
| $transmission = ( $this->standard = 0) ? "co.transmission = '1' " : " 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 |