Subversion Repositories eFlore/Applications.del

Rev

Rev 1892 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1892 Rev 1911
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
			'	) '.