Subversion Repositories eFlore/Applications.cel

Rev

Rev 2533 | Rev 2545 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2533 Rev 2541
Line 12... Line 12...
12
			"FROM cel_obs ".
12
			"FROM cel_obs ".
13
			$where.
13
			$where.
14
			"GROUP BY longitude , latitude ";
14
			"GROUP BY longitude , latitude ";
Line 15... Line 15...
15
		
15
		
-
 
16
		$resultat = $this->recupererTous($requete);
16
		$resultat = $this->recupererTous($requete);
17
		echo $requete;exit;
17
		$this->reinitialiserTempsDerniereRequete();
18
		$this->reinitialiserTempsDerniereRequete();
18
		return $resultat;
19
		return $resultat;
Line 19... Line 20...
19
	}
20
	}
Line 110... Line 111...
110
	}
111
	}
Line 111... Line 112...
111
	
112
	
112
	private function getConditionCoordonneesValides() {
113
	private function getConditionCoordonneesValides() {
113
		$condition = '(latitude IS NOT NULL AND longitude IS NOT NULL '.
114
		$condition = '(latitude IS NOT NULL AND longitude IS NOT NULL '.
114
					 ' AND latitude != 0 AND latitude != "" '.
115
					 ' AND latitude != 0 AND latitude != "" '.
-
 
116
					 ' AND longitude != 0 AND longitude != "" '.
-
 
117
					 ' AND latitude >= -90 AND latitude <= 90 '.
115
					 ' AND longitude != 0 AND longitude != "" ) ';	
118
					 ' AND longitude >= -180 AND longitude <= 180) ';	
116
		return $condition;
119
		return $condition;
Line 117... Line 120...
117
	}
120
	}
118
 
121