122,7 → 122,7 |
$this->construireWhereNombreDeJours(). |
' GROUP BY id_coord'; |
|
$resultats_emplacements = $this->executerRequete($requete); |
$resultats_emplacements = Cel::db()->executerRequete($requete); |
$emplacements = $this->traiterEmplacements($resultats_emplacements, $this->compterObservations($params)); |
return $emplacements; |
} |
158,7 → 158,7 |
$this->construireWhereTag(). |
$this->construireWhereNombreDeJours(); |
|
$resultats_nb_obs = $this->executerRequete($requete); |
$resultats_nb_obs = Cel::db()->executerRequete($requete); |
return $resultats_nb_obs[0]['nb']; |
} |
|
344,9 → 344,9 |
'ORDER BY nom_sel ASC '. |
"LIMIT {$this->start},{$this->limit} "; |
//echo $requete;exit; |
$resultats = $this->requeter($requete, self::SQL_RETOUR_COMPLET, self::SQL_MODE_OBJET); |
$resultats = Cel::db()->requeter($requete, self::SQL_RETOUR_COMPLET, self::SQL_MODE_OBJET); |
$requete = 'SELECT FOUND_ROWS()'; |
$total = (int) $this->requeter($requete, self::SQL_RETOUR_COLONNE); |
$total = (int) Cel::db()->requeter($requete, self::SQL_RETOUR_COLONNE); |
} |
|
// Post-traitement |
490,10 → 490,10 |
'ORDER BY nom_ret ASC '. |
"LIMIT {$this->start},{$this->limit} "; |
//$this->debug[] = $requete; |
$resultats = $this->requeter($requete, self::SQL_RETOUR_COMPLET, self::SQL_MODE_OBJET); |
$resultats = Cel::db()->requeter($requete, self::SQL_RETOUR_COMPLET, self::SQL_MODE_OBJET); |
//echo $requete;exit; |
$requete = 'SELECT FOUND_ROWS()'; |
$taxons['total'] = (int) $this->requeter($requete, self::SQL_RETOUR_COLONNE); |
$taxons['total'] = (int) Cel::db()->requeter($requete, self::SQL_RETOUR_COLONNE); |
|
// Post-traitement |
$taxons['taxons'] = $this->traiterTaxons($resultats); |
525,12 → 525,12 |
extract($this->decomposerParametreStation()); |
if (isset($type)) { |
if ($type == self::MARQUEUR_COMMUNE) { |
$lat = $this->proteger($lat.'%'); |
$lng = $this->proteger($lng.'%'); |
$lat = Cel::db()->proteger($lat.'%'); |
$lng = Cel::db()->proteger($lng.'%'); |
$sql = " AND wgs84_latitude LIKE $lat AND wgs84_longitude LIKE $lng "; |
} else if ($type == self::MARQUEUR_STATION) { |
$lat = $this->proteger($lat.'%'); |
$lng = $this->proteger($lng.'%'); |
$lat = Cel::db()->proteger($lat.'%'); |
$lng = Cel::db()->proteger($lng.'%'); |
$sql = " AND (latitude LIKE $lat AND longitude LIKE $lng) "; |
} |
} |
543,12 → 543,12 |
extract($this->decomposerParametreStation()); |
if (isset($type)) { |
if ($type == self::MARQUEUR_COMMUNE) { |
$lat = $this->proteger($lat); |
$lng = $this->proteger($lng); |
$lat = Cel::db()->proteger($lat); |
$lng = Cel::db()->proteger($lng); |
$sql = " AND wgs84_latitude LIKE $lat AND wgs84_longitude LIKE $lng "; |
} else if ($type == self::MARQUEUR_STATION) { |
$lat = $this->proteger($lat.'%'); |
$lng = $this->proteger($lng.'%'); |
$lat = Cel::db()->proteger($lat.'%'); |
$lng = Cel::db()->proteger($lng.'%'); |
$sql = " AND (latitude LIKE $lat AND longitude LIKE $lng) "; |
} |
} |
560,7 → 560,7 |
$sql = ''; |
list($type, $commentaire) = $this->decomposerParametreCommentaire(); |
if (!$this->etreNull($commentaire)) { |
$commentaire = $this->proteger('%'.$commentaire.'%'); |
$commentaire = Cel::db()->proteger('%'.$commentaire.'%'); |
switch ($type) { |
case '*' : |
$sql = $this->obtenirConditionPourCommentaires($commentaire); |
590,7 → 590,7 |
$sql = ''; |
list($type, $nom) = $this->decomposerParametreTaxon(); |
if (!$this->etreNull($nom)) { |
$nom = $this->proteger($nom.'%'); |
$nom = Cel::db()->proteger($nom.'%'); |
switch ($type) { |
case '*' : |
$sql = " AND (nom_ret LIKE $nom OR nom_sel LIKE $nom OR famille LIKE $nom) "; |
615,7 → 615,7 |
$sql = ''; |
extract($this->parametres); |
if (isset($referentiel) && !$this->etreNull($referentiel)) { |
$referentiel = $this->proteger($referentiel.'%'); |
$referentiel = Cel::db()->proteger($referentiel.'%'); |
$sql = ' AND co.nom_referentiel LIKE '.$referentiel.' '; |
} |
return $sql; |
627,7 → 627,7 |
list($type, $date) = $this->decomposerParametreDate(); |
|
if (!$this->etreNull($date)) { |
$date = $this->proteger($date.'%'); |
$date = Cel::db()->proteger($date.'%'); |
switch ($type) { |
case '*' : |
$sql = " AND ( |
754,7 → 754,7 |
'ORDER BY utilisateur ASC, ordre ASC'; |
//$this->debug[] = $requete; |
//die($requete); |
$resultats = $this->executerRequete($requete); |
$resultats = Cel::db()->executerRequete($requete); |
|
$observations = null; |
if ($resultats != false) { |
890,7 → 890,7 |
if (isset($dept) && !$this->etreNull($dept)) { |
$valeurs_a_proteger = explode(',',trim($dept)); |
foreach ($valeurs_a_proteger as $valeur) { |
$valeurs_protegees[] = '(ce_zone_geo LIKE '.$this->bdd->quote('INSEE-C:'.$valeur.'%').') '; |
$valeurs_protegees[] = '(ce_zone_geo LIKE '.Cel::db()->quote('INSEE-C:'.$valeur.'%').') '; |
} |
$valeurs = implode(' OR ', $valeurs_protegees); |
$sql = " AND ($valeurs) "; |
903,7 → 903,7 |
// Récupération des coordonnées depuis l'id station |
extract($this->parametres); |
if (isset($this->parametres['commune']) && !$this->etreNull($commune)) { |
$commune = $this->proteger($commune); |
$commune = Cel::db()->proteger($commune); |
$sql = " AND zone_geo LIKE $commune "; |
} |
return $sql; |
914,7 → 914,7 |
// Récupération des coordonnées depuis l'id station |
extract($this->parametres); |
if (isset($this->parametres['commune']) && !$this->etreNull($commune)) { |
$commune = $this->proteger($commune); |
$commune = Cel::db()->proteger($commune); |
$sql = " AND zone_geo LIKE $commune "; |
$sql .= " AND ( |
( |
943,7 → 943,7 |
// pour en faire une fonction polyvalente |
extract($this->parametres); |
if (isset($this->parametres['utilisateur']) && !$this->etreNull($utilisateur)) { |
$utilisateur = $this->proteger($utilisateur); |
$utilisateur = Cel::db()->proteger($utilisateur); |
$sql = " AND co.courriel_utilisateur = $utilisateur "; |
} |
return $sql; |
955,7 → 955,7 |
// Récupération des coordonnées depuis l'id station |
extract($this->parametres); |
if (isset($this->parametres['num_taxon']) && !$this->etreNull($num_taxon)) { |
$num_taxon = $this->proteger($num_taxon); |
$num_taxon = Cel::db()->proteger($num_taxon); |
$sql = " AND nt = $num_taxon "; |
} |
return $sql; |
967,7 → 967,7 |
extract($this->parametres); |
if (isset($this->parametres['num_taxon']) && !$this->etreNull($num_taxon)) { |
$sous_taxons = $this->obtenirSousTaxons($this->parametres['num_taxon']); |
$num_taxon = $this->proteger($num_taxon); |
$num_taxon = Cel::db()->proteger($num_taxon); |
if(!empty($sous_taxons)) { |
$sql_in_sous_tax = implode(',', $sous_taxons); |
$sql = " AND (nt = $num_taxon OR ". |
1012,7 → 1012,7 |
private function getSqlWhereProjet($projet) { |
$sql = null; |
if (isset($projet) && !$this->etreNull($projet)) { |
$sql = 'co.mots_cles_texte LIKE '.$this->proteger('%'.$projet.'%'); |
$sql = 'co.mots_cles_texte LIKE '.Cel::db()->proteger('%'.$projet.'%'); |
} |
return $sql; |
} |
1031,7 → 1031,7 |
$sql = null; |
extract($this->parametres); |
if (isset($nbjours) && !$this->etreNull($nbjours)) { |
$sql = ' AND DATEDIFF(CURDATE(),co.date_creation) <= '.$this->proteger($nbjours).' '; |
$sql = ' AND DATEDIFF(CURDATE(),co.date_creation) <= '.Cel::db()->proteger($nbjours).' '; |
} |
return $sql; |
} |
1063,7 → 1063,7 |
'ORDER BY utilisateur ASC, ci.ordre ASC'; |
//$this->debug[] = $requete; |
//die($requete); |
$elements_tag = $this->executerRequete($requete); |
$elements_tag = Cel::db()->executerRequete($requete); |
|
$requete_tag = array(); |
if ($elements_tag != false && count($elements_tag) > 0) { |
1134,7 → 1134,7 |
} |
|
foreach ($mots_cles['motsCles'] as $mot) { |
$mots_cles['motsClesEncodesProteges'][] = $this->bdd->quote('%'.$mot.'%'); |
$mots_cles['motsClesEncodesProteges'][] = Cel::db()->quote('%'.$mot.'%'); |
} |
$this->debug[] = $mots_cles; |
return $mots_cles; |