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 |