Subversion Repositories Sites.obs-saisons.fr

Rev

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

Rev 249 Rev 263
Line 40... Line 40...
40
40
41 
		$requete_selection_observations = 'SELECT * FROM ods_observations '.
 41 
		$requete_selection_observations = 'SELECT * FROM ods_observations '.
42 
									' LEFT JOIN ods_individus '.
42 
									' LEFT JOIN ods_individus '.
43 
									' ON oi_id_individu = oo_ce_individu'.
 43 
									' ON oi_id_individu = oo_ce_individu'.
44 
									' LEFT JOIN ods_stations '.
 44 
									' LEFT JOIN ods_stations '.
- 
 
 45 
									' ON oi_ce_station = os_id_station '.
- 
 
 46 
									' LEFT JOIN ods_communes '.
Line 45... Line 47...
45 
									' ON oi_ce_station = os_id_station ';
 47 
									'ON os_ce_commune = oc_code_insee ';
46
48
Line 47... Line 49...
47 
		$requete_selection_observations .= $this->construireConditionRequete();
 49 
		$requete_selection_observations .= $this->construireConditionRequete();
Line 48... Line 50...
48 
		$requete_selection_observations .= ' ORDER BY oo_date DESC';
 50 
		$requete_selection_observations .= ' ORDER BY oo_date DESC';
49
51
Line -... Line 52...
- 
 
 52 
		$res_selection_observations = $this->executerRequete($requete_selection_observations);
- 
 
 53
- 
 
 54 
		return $res_selection_observations;
- 
 
 55 
	}
- 
 
 56
- 
 
 57 
	private function creerFiltreIdZoneGeo($valeurMasque) {
- 
 
 58 
		$masque = '';
- 
 
 59 
		$dept = $valeurMasque;
- 
 
 60 
		$dept = sprintf('%02s', $dept);
50 
		$res_selection_observations = $this->executerRequete($requete_selection_observations);
 61 
		$dept = sprintf("%-'_5s", $dept);
Line 51... Line 62...
51
62 
		$masque = " oc_code_insee LIKE ".$this->proteger($dept);
Line 52... Line 63...
52 
		return $res_selection_observations;
 63 
		return $masque;
Line 92... Line 103...
92
103
93 
				case 'utilisateur':
 104 
				case 'utilisateur':
94 
					$condition .= 'oo_ce_participant = '.$this->proteger($valeur);
105 
					$condition .= 'oo_ce_participant = '.$this->proteger($valeur);
Line 95... Line 106...
95 
				break;
 106 
				break;
- 
 
 107
96
108 
				case 'dept' :
- 
 
 109 
					$condition .= $this->creerFiltreIdZoneGeo($valeur);
97 
				default:
 110 
				break;
Line 98... Line 111...
98 
				break;
 111 
				default:
99 
			}
 112 
			}