Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1743 Rev 1744
Line 79... Line 79...
79 
			"	LEFT JOIN del_utilisateur AS du ON do.ce_utilisateur = du.id_utilisateur AND do.ce_utilisateur != 0 ".
 79 
			"	LEFT JOIN del_utilisateur AS du ON do.ce_utilisateur = du.id_utilisateur AND do.ce_utilisateur != 0 ".
80 
			'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" '.
 80 
			'WHERE (do.mots_cles_texte LIKE "%aDeterminer%" '.
81 
			'		OR nom_sel IS NULL OR nom_sel = "" '.
 81 
			'		OR nom_sel IS NULL OR nom_sel = "" '.
82 
			'		OR nom_ret IS NULL OR nom_ret = "") '.
 82 
			'		OR nom_ret IS NULL OR nom_ret = "") '.
83 
			'	AND ('.
 83 
			'	AND ('.
84 
			"		do.date_transmission > DATE_SUB($date, INTERVAL 1 DAY) ".
 84 
			"		TO_DAYS($date) - TO_DAYS(do.date_transmission) IN (0, 1) ".
85 
			"		OR do.date_creation > DATE_SUB($date, INTERVAL 1 DAY) ".
 85 
			"		OR TO_DAYS($date) - TO_DAYS(do.date_creation) IN (0, 1) ".
86 
			"		OR do.date_modification > DATE_SUB($date, INTERVAL 1 DAY) ".
 86 
			"		OR TO_DAYS($date) - TO_DAYS(do.date_modification) IN (0, 1) ".
87 
			'	) '.
 87 
			'	) '.
88 
			"ORDER BY do.id_observation ";
 88 
			"ORDER BY do.id_observation ";
89 
		$obs = $this->conteneur->getBdd()->recupererTous($requete);
 89 
		$obs = $this->conteneur->getBdd()->recupererTous($requete);
90 
		return $obs;
 90 
		return $obs;
91 
	}
 91 
	}