WebSVN – eFlore/Applications.cel – Diff – /branches/v3.00-serfouette/jrest/services/CelWidgetMapPoint.php



 

	public function getTout($params) { 
 
		$emplacements = null;
		$concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) ";
		$transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";
		$requete =  'SELECT ce_zone_geo, zone_geo, station, '.
								"mots_cles_texte, ".
								"latitude, ".

	}

 

	private $nb_obs = 0;
 
	private function compterObservations($params) {
	    $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";
		$requete =  'SELECT COUNT(*) as nb '.
					'FROM '.$this->table_export.' AS co '.
                    "WHERE ".$transmission.

	 * Données pour l'affichage des obs d'une station
	 */
	public function getObservations($params) {
		$resultats = array();
		$total = 0;
		$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, '.
						'	nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, "" as nt, famille, '.

	/**
	 * Liste des taxons présents sur la carte
	 */
	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 '.$this->table_export.' AS co '.
					"WHERE ".$transmission.
					"	nom_ret != '' ".
					$this->construireWhereDept().

	/**
	 * Récupération des identifiant d'utilisateur et des ordres des observations correspondant à une date.
	 * 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 '.$this->table_export.' AS co '.
			'	LEFT JOIN cel_zones_geo AS zg '.
			'		ON (zg.nom = co.zone_geo AND zg.code = co.ce_zone_geo) '.

	/**
	 * Traitement de $tag pour construction du filtre dans la requête
	 */
	private function getSqlWhereObsAvecImagesTaguees($tag) {
		$sql = null;
		$transmission = ( $this->standard == 0) ? "co.transmission = '1' " : " 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'.

Rev 3719	Rev 3736
Line 108...	Line 108...
108		108
Line 109...	Line 109...
109	`public function getTout($params) {`	109	`public function getTout($params) {`
110		110
111	`$emplacements = null;`	111	`$emplacements = null;`
112	`$concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) ";`	112	`$concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) ";`
113	`$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : "";`	113	`$transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";`
114	`$requete = 'SELECT ce_zone_geo, zone_geo, station, '.`	114	`$requete = 'SELECT ce_zone_geo, zone_geo, station, '.`
115	`"mots_cles_texte, ".`	115	`"mots_cles_texte, ".`
116	`"latitude, ".`	116	`"latitude, ".`
Line 154...	Line 154...
154	`}`	154	`}`
Line 155...	Line 155...
155		155
Line 156...	Line 156...
156	`private $nb_obs = 0;`	156	`private $nb_obs = 0;`
157		157
158	`private function compterObservations($params) {`	158	`private function compterObservations($params) {`
159	`$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : "";`	159	`$transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";`
160	`$requete = 'SELECT COUNT(*) as nb '.`	160	`$requete = 'SELECT COUNT(*) as nb '.`
161	`'FROM '.$this->table_export.' AS co '.`	161	`'FROM '.$this->table_export.' AS co '.`
162	`"WHERE ".$transmission.`	162	`"WHERE ".$transmission.`
Line 341...	Line 341...
341	`* Données pour l'affichage des obs d'une station`	341	`* Données pour l'affichage des obs d'une station`
342	`*/`	342	`*/`
343	`public function getObservations($params) {`	343	`public function getObservations($params) {`
344	`$resultats = array();`	344	`$resultats = array();`
345	`$total = 0;`	345	`$total = 0;`
346	`$transmission = ( $this->standard = 0) ? "transmission = '1' " : " 1 ";`	346	`$transmission = ( $this->standard == 0) ? "transmission = '1' " : " 1 ";`
Line 347...	Line 347...
347		347
348	`if (isset($this->parametres['station']) && !$this->etreNull($this->parametres['station'])) {`	348	`if (isset($this->parametres['station']) && !$this->etreNull($this->parametres['station'])) {`
349	`$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, pseudo_utilisateur as nom_utilisateur, "" as prenom_utilisateur, '.`	349	`$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, pseudo_utilisateur as nom_utilisateur, "" as prenom_utilisateur, '.`
350	`' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, "" as nt, famille, '.`	350	`' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, "" as nt, famille, '.`
Line 492...	Line 492...
492	`/**`	492	`/**`
493	`* Liste des taxons présents sur la carte`	493	`* Liste des taxons présents sur la carte`
494	`*/`	494	`*/`
495	`public function getTaxons($params) {`	495	`public function getTaxons($params) {`
496	`$json = null;`	496	`$json = null;`
497	`$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : "";`	497	`$transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";`
498	`$requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '.`	498	`$requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '.`
499	`'FROM '.$this->table_export.' AS co '.`	499	`'FROM '.$this->table_export.' AS co '.`
500	`"WHERE ".$transmission.`	500	`"WHERE ".$transmission.`
501	`" nom_ret != '' ".`	501	`" nom_ret != '' ".`
502	`$this->construireWhereDept().`	502	`$this->construireWhereDept().`
Line 751...	Line 751...
751	`/**`	751	`/**`
752	`* Récupération des identifiant d'utilisateur et des ordres des observations correspondant à une date.`	752	`* Récupération des identifiant d'utilisateur et des ordres des observations correspondant à une date.`
753	`* Retour sous forme de tableau : array[identifiant] = array(ordre, ordre...);`	753	`* Retour sous forme de tableau : array[identifiant] = array(ordre, ordre...);`
754	`*/`	754	`*/`
755	`private function obtenirObsLieesImg($type, $param) {`	755	`private function obtenirObsLieesImg($type, $param) {`
756	`$transmission = ( $this->standard = 0) ? "transmission = '1' AND " : "";`	756	`$transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";`
757	`// Construction de la requête`	757	`// Construction de la requête`
758	`$requete = 'SELECT DISTINCT co.id_obs, co.ce_utilisateur AS utilisateur '.`	758	`$requete = 'SELECT DISTINCT co.id_obs, co.ce_utilisateur AS utilisateur '.`
759	`'FROM '.$this->table_export.' AS co '.`	759	`'FROM '.$this->table_export.' AS co '.`
760	`' LEFT JOIN cel_zones_geo AS zg '.`	760	`' LEFT JOIN cel_zones_geo AS zg '.`
761	`' ON (zg.nom = co.zone_geo AND zg.code = co.ce_zone_geo) '.`	761	`' ON (zg.nom = co.zone_geo AND zg.code = co.ce_zone_geo) '.`
Line 1136...	Line 1136...
1136	`/**`	1136	`/**`
1137	`* Traitement de $tag pour construction du filtre dans la requête`	1137	`* Traitement de $tag pour construction du filtre dans la requête`
1138	`*/`	1138	`*/`
1139	`private function getSqlWhereObsAvecImagesTaguees($tag) {`	1139	`private function getSqlWhereObsAvecImagesTaguees($tag) {`
1140	`$sql = null;`	1140	`$sql = null;`
1141	`$transmission = ( $this->standard = 0) ? "co.transmission = '1' " : " 1 ";`	1141	`$transmission = ( $this->standard == 0) ? "co.transmission = '1' " : " 1 ";`
1142	`if (isset($tag) && !$this->etreNull($tag)) {`	1142	`if (isset($tag) && !$this->etreNull($tag)) {`
1143	`$tag_sql = $this->getSqlWhereMotsCles($tag);`	1143	`$tag_sql = $this->getSqlWhereMotsCles($tag);`
1144	`// Construction de la requête`	1144	`// Construction de la requête`
1145	`$requete = 'SELECT DISTINCT co.id_observation AS id_obs, co.ce_utilisateur AS utilisateur '.`	1145	`$requete = 'SELECT DISTINCT co.id_observation AS id_obs, co.ce_utilisateur AS utilisateur '.`
1146	`'FROM cel_images_export ci'.`	1146	`'FROM cel_images_export ci'.`

Subversion Repositories eFlore/Applications.cel

(root)/branches/v3.00-serfouette/jrest/services/CelWidgetMapPoint.php – Rev 3719 → 3736