Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1884 Rev 1910
Line 78... Line 78...
78 
			'	date_observation, nom_ret, nom_sel, '.
 78 
			'	date_observation, nom_ret, nom_sel, '.
79 
			'	ce_zone_geo, zone_geo, lieudit, station '.
 79 
			'	ce_zone_geo, zone_geo, lieudit, station '.
80 
			'FROM del_observation AS do '.
 80 
			'FROM del_observation AS do '.
81 
			'WHERE do.ce_utilisateur != 0 '.
 81 
			'WHERE do.ce_utilisateur != 0 '.
82 
			'	AND do.ce_utilisateur IS NOT NULL '.
 82 
			'	AND do.ce_utilisateur IS NOT NULL '.
83 
			'	AND (do.mots_cles_texte LIKE "%aDeterminer%" '.
 83 
			"	AND (do.mots_cles_texte LIKE '%aDeterminer%' ".
- 
 
 84 
			"		OR (do.certitude = 'aDeterminer' OR do.certitude = 'A déterminer' OR do.certitude = 'douteux') ".
84 
			'		OR nom_sel IS NULL OR nom_sel = "" '.
 85 
			"		OR nom_sel IS NULL OR nom_sel = '' ".
85 
			'		OR nom_ret IS NULL OR nom_ret = "") '.
 86 
			"		OR nom_ret IS NULL OR nom_ret = '') ".
86 
			'	AND ('.
 87 
			'	AND ('.
87 
			"		TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
 88 
			"		TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
88 
			"		OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ".
 89 
			"		OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ".
89 
			"		OR TO_DAYS($date) - TO_DAYS(do.date_modification) IN (0, 1) ".
 90 
			"		OR TO_DAYS($date) - TO_DAYS(do.date_modification) IN (0, 1) ".
90 
			'	) '.
 91 
			'	) '.