Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1311 Rev 1332
Line 63... Line 63...
63
63
Line 64... Line 64...
64 
		$requete_selection_observations .= ' ORDER BY ordre LIMIT '.$debut.','.$limite ;
 64 
		$requete_selection_observations .= ' ORDER BY ordre LIMIT '.$debut.','.$limite ;
65
65
66 
		$resultats_observations = array();
 66 
		$resultats_observations = array();
67 
		$resultats_observations = $this->requeter($requete_selection_observations);
 67 
		$resultats_observations = $this->requeter($requete_selection_observations);
68
68 
 
Line 69... Line 69...
69 
		return $resultats_observations;
 69 
		return $resultats_observations;
Line 102... Line 102...
102 
			foreach($ids_mots_cles as $id_mot_cle) {
 102 
			foreach($ids_mots_cles as $id_mot_cle) {
103 
				$mots_cles_chaine .= $id_mot_cle['id_mot_cle_obs'].';';
 103 
				$mots_cles_chaine .= $id_mot_cle['id_mot_cle_obs'].';';
104 
			}
 104 
			}
105 
			$mots_cles_chaine = rtrim($mots_cles_chaine,';');
 105 
			$mots_cles_chaine = rtrim($mots_cles_chaine,';');
106 
			$observation['mots_cles'] = $mots_cles_chaine;
 106 
			$observation['mots_cles'] = $mots_cles_chaine;
- 
 
 107
- 
 
 108 
			foreach($observation as $champ => $valeur) {
- 
 
 109 
				if($valeur == 'NULL') {
- 
 
 110 
					$observation[$champ] = "";
- 
 
 111 
				}
- 
 
 112 
			}
107 
		}
 113 
		}
Line 108... Line 114...
108
114
109 
		return $tableau_observations;
 115 
		return $tableau_observations;
Line 148... Line 154...
148 
				case "mots_cles";
 154 
				case "mots_cles";
149 
					$sous_requete .= 'mots_cles_texte LIKE '.$this->proteger('%'.$valeur.'%').' AND ';
 155 
					$sous_requete .= 'mots_cles_texte LIKE '.$this->proteger('%'.$valeur.'%').' AND ';
150 
				break;
 156 
				break;
Line 151... Line 157...
151
157
- 
 
 158 
				case 'annee':
- 
 
 159 
					if($valeur == "NULL") {
- 
 
 160 
						$sous_requete .= "date_observation IS NULL OR year(date_observation) = 0000" ;
152 
				case 'annee':
 161 
					} else {
- 
 
 162 
						$sous_requete .= "year(date_observation) = ".$this->proteger($valeur) ;
153 
					$sous_requete .= "year(date_observation) = ".$this->proteger($valeur) ;
 163 
					}
154 
					$sous_requete .= ' AND ' ;
 164 
					$sous_requete .= ' AND ' ;
Line 155... Line 165...
155 
				break;
 165 
				break;
- 
 
 166
- 
 
 167 
				case 'mois':
- 
 
 168 
					if($valeur == "NULL") {
156
169 
						$sous_requete .= "date_observation IS NULL OR month(date_observation) = 00" ;
- 
 
 170 
					} else {
157 
				case 'mois':
 171 
						$sous_requete .= "month(date_observation) = ".$this->proteger($valeur) ;
158 
					$sous_requete .= "month(date_observation) = ".$this->proteger($valeur) ;
 172 
					}
Line 159... Line 173...
159 
					$sous_requete .= ' AND ' ;
 173 
					$sous_requete .= ' AND ' ;
- 
 
 174 
				break;
- 
 
 175
- 
 
 176 
				case 'jour':
160 
				break;
 177 
					if($valeur == "NULL") {
- 
 
 178 
						$sous_requete .= "date_observation IS NULL OR day(date_observation) = 00" ;
161
179 
					} else {
162 
				case 'jour':
 180 
						$sous_requete .= "day(date_observation) = ".$this->proteger($valeur) ;
Line 163... Line 181...
163 
					$sous_requete .= "day(date_observation) = ".$this->proteger($valeur) ;
 181 
					}
- 
 
 182 
					$sous_requete .= ' AND ' ;
- 
 
 183 
				break;
- 
 
 184
164 
					$sous_requete .= ' AND ' ;
 185 
				case 'departement':
- 
 
 186 
					if($valeur == "NULL") {
165 
				break;
 187 
						$sous_requete .= "(ce_zone_geo IS NULL OR ce_zone_geo = '')";
166
188 
					} else {
Line 167... Line 189...
167 
				case 'departement':
 189 
						$sous_requete .= "ce_zone_geo LIKE ".$this->proteger('INSEE-C:'.$valeur.'___');
- 
 
 190 
					}
- 
 
 191 
					$sous_requete .= ' AND ' ;
- 
 
 192 
				break;
168 
					$sous_requete .= "ce_zone_geo LIKE ".$this->proteger('INSEE-C:'.$valeur.'___');
 193
- 
 
 194 
				case 'commune':
169 
					$sous_requete .= ' AND ' ;
 195 
					if($valeur == "NULL") {
170 
				break;
 196 
						$sous_requete .= "(zone_geo IS NULL OR zone_geo = '')";
Line 171... Line 197...
171
197 
					} else {
172 
				case 'commune':
 198 
						$sous_requete .= "zone_geo = ".$this->proteger($valeur);
Line 187... Line 213...
187 
				default:
 213 
				default:
188 
					if(trim($nom) != '')
 214 
					if(trim($nom) != '')
189 
					{
 215 
					{
190 
						$sous_requete .= $nom." = ".$this->proteger($valeur) ;
 216 
						$sous_requete .= $nom." = ".$this->proteger($valeur) ;
191 
						$sous_requete .= ' AND ' ;
 217 
						$sous_requete .= ' AND ' ;
- 
 
 218 
					}
- 
 
 219 
					if(trim($nom) == "NULL") {
- 
 
 220 
						$sous_requete .= "(".$nom." IS NULL OR ".$nom." = '')" ;
- 
 
 221 
						$sous_requete .= ' AND ' ;
192 
					}
 222 
					}
193 
				break;
 223 
				break;
194 
			}
 224 
			}
195 
		}
 225 
		}