Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 664 Rev 736
Line 239... Line 239...
239
	private function fabriquerSousRequeteRechercheDate($intervalle, $valeur) {
239
	private function fabriquerSousRequeteRechercheDate($intervalle, $valeur) {
Line 240... Line 240...
240
		
240
		
Line 241... Line 241...
241
		$correspondance_champ = array('annee' => 'YEAR','mois' => 'MONTH','jour' => 'DAY');
241
		$correspondance_champ = array('annee' => 'YEAR','mois' => 'MONTH','jour' => 'DAY');
242
		
242
		
-
 
243
		$requete_recherche_date = '';
243
		$requete_recherche_date = '';
244
 
-
 
245
		if(is_numeric($valeur) && $valeur != "00") { 
-
 
246
			$requete_recherche_date = $correspondance_champ[$intervalle].'(ci_meta_date) = "'.$valeur.'" ';
-
 
247
		} else {
Line 244... Line 248...
244
		
248
			$requete_recherche_date = '( ci_meta_date IS NULL OR ci_meta_date = "0000-00-00")';
245
		$requete_recherche_date = $correspondance_champ[$intervalle].'(ci_meta_date) = "'.$valeur.'" ';
249
		}
246
							
-
 
247
		return $requete_recherche_date;
250
							
248
	}
251
		return $requete_recherche_date;
249
 
252
	}