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