35,7 → 35,8 |
const MARQUEUR_GROUPE = 'GROUPE'; |
const MARQUEUR_COMMUNE = 'COMMUNE'; |
const MARQUEUR_STATION = 'STATION'; |
private $standard = "AND donnees_standard = 1"; |
private $standard = "1"; |
private $table_export = "cel_export"; |
|
/** |
* Méthode appelée avec une requête de type GET. |
48,7 → 49,9 |
extract($this->parametres); |
//Chronometre::chrono("Avant groupage"); |
if (isset($this->parametres['standard']) && $this->parametres['standard'] == 0) { |
$this->standard = ""; |
$this->standard = "0"; |
$this->table_export = "cel_export_total"; |
|
} |
|
$action = array_shift($ressources); |
107,7 → 110,7 |
|
$emplacements = null; |
$concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,''), IFNULL(wgs84_latitude,''),IFNULL(wgs84_longitude,'')) "; |
|
$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
$requete = 'SELECT ce_zone_geo, zone_geo, station, '. |
"mots_cles_texte, ". |
"latitude, ". |
115,12 → 118,11 |
"longitude, ". |
"wgs84_longitude, ". |
$concatenation_id." as id_coord ". |
'FROM cel_export_total AS co '. |
'FROM '.$this->table_export.' AS co '. |
' LEFT JOIN cel_zones_geo AS zg '. |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
"WHERE transmission = '1' ". |
$this->standard. |
" AND (". |
"WHERE ".$transmission. |
" (". |
$this->construireWhereRectangleStationOR()." OR ". |
$this->construireWhereRectangleCommuneOR().") ". |
$this->construireWhereDept(). |
155,13 → 157,13 |
private $nb_obs = 0; |
|
private function compterObservations($params) { |
$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
$requete = 'SELECT COUNT(*) as nb '. |
'FROM cel_export_total AS co '. |
'FROM '.$this->table_export.' AS co '. |
' LEFT JOIN cel_zones_geo AS zg '. |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
"WHERE transmission = '1' ". |
$this->standard. |
" AND (". |
"WHERE ".$transmission. |
" (". |
$this->construireWhereRectangleStationOR()." OR ". |
$this->construireWhereRectangleCommuneOR().") ". |
$this->construireWhereDept(). |
344,16 → 346,17 |
public function getObservations($params) { |
$resultats = array(); |
$total = 0; |
$transmission = ( $this->standard = 0) ? "transmission = '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, '. |
' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, "" as nt, famille, '. |
' lieudit, zone_geo, date_observation, milieu, commentaire, '. |
' utm_secteur, utm_x, utm_y, code, date_transmission, nom_referentiel '. |
'FROM cel_export_total AS co '. |
'FROM '.$this->table_export.' AS co '. |
' LEFT JOIN cel_zones_geo AS zg '. |
" ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ". |
"WHERE transmission = '1' ". |
$this->standard. |
"WHERE ".$transmission. |
(($this->communeEstDemandee()) ? $this->construireWhereCommuneSansCoordonneesAvecSensibles() : $this->construireWhereCoordonneesSansSensibles()). |
$this->construireWhereDept(). |
$this->construireWherePays(). |
496,14 → 499,13 |
*/ |
public function getTaxons($params) { |
$json = null; |
|
$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
$requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '. |
'FROM cel_export_total AS co '. |
'FROM '.$this->table_export.' AS co '. |
' LEFT JOIN cel_zones_geo AS zg '. |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
"WHERE transmission = '1' ". |
$this->standard. |
" AND nom_ret != '' ". |
"WHERE ".$transmission. |
" nom_ret != '' ". |
$this->construireWhereDept(). |
$this->construireWhereCommune(). |
$this->construireWherePays(). |
647,8 → 649,8 |
$sql = ''; |
extract($this->parametres); |
if (isset($referentiel) && !$this->etreNull($referentiel)) { |
$referentiel = Cel::db()->proteger($referentiel.'%'); |
$sql = ' AND co.nom_referentiel LIKE '.$referentiel.' '; |
$referentiel = Cel::db()->proteger($referentiel); |
$sql = ' AND co.nom_referentiel = '.$referentiel.' '; |
} |
return $sql; |
} |
758,13 → 760,13 |
* Retour sous forme de tableau : array[identifiant] = array(ordre, ordre...); |
*/ |
private function obtenirObsLieesImg($type, $param) { |
$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : ""; |
// Construction de la requête |
$requete = 'SELECT DISTINCT co.id_obs, co.ce_utilisateur AS utilisateur '. |
'FROM cel_export_total AS co '. |
'FROM '.$this->table_export.' AS co '. |
' LEFT JOIN cel_zones_geo AS zg '. |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
"WHERE co.transmission = '1' and co.images != null". |
$this->standard. |
"WHERE ".$transmission." co.images != null". |
($type == 'date.creation' ? " AND co.date_creation LIKE $param " : ''). |
($type == 'commentaire.obs' ? " AND co.commentaire LIKE $param " : ''). |
($type == 'commentaire.*' ? " AND co.commentaire LIKE $param " : ''). |
1143,17 → 1145,17 |
*/ |
private function getSqlWhereObsAvecImagesTaguees($tag) { |
$sql = null; |
$transmission = ( $this->standard = 0) ? "co.transmission = '1' " : ""; |
if (isset($tag) && !$this->etreNull($tag)) { |
$tag_sql = $this->getSqlWhereMotsCles($tag); |
// Construction de la requête |
$requete = 'SELECT DISTINCT co.id_observation AS id_obs, co.ce_utilisateur AS utilisateur '. |
'FROM cel_images_export ci'. |
' INNER JOIN cel_export_total AS co '. |
' INNER JOIN '.$this->table_export.' AS co '. |
' ON (ci.ce_observation = co.id_observation) '. |
' LEFT JOIN cel_zones_geo AS zg '. |
" ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ". |
"WHERE co.transmission = '1' ". |
$this->standard. |
"WHERE ". |
$this->construireWhereCoordonnees(). |
$this->construireWhereUtilisateur(). |
$this->construireWhereNumTaxon(). |