Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3684 → Rev 3685

/branches/v3.00-serfouette/jrest/services/CelWidgetMapPoint.php
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().