Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1636 Rev 1657
Line 38... Line 38...
38 
					'	LEFT JOIN coel_meta_historique_ligne ON (cp_ce_meta = cmhl_id_historique_ligne) '.
 38 
					'	LEFT JOIN coel_meta_historique_ligne ON (cp_ce_meta = cmhl_id_historique_ligne) '.
39 
					((count($p) != 0) ? 'WHERE ' : '').
 39 
					((count($p) != 0) ? 'WHERE ' : '').
40 
					(isset($p['id_personne']) 	? "AND cp_id_personne = {$p['id_personne']} " 				: '').
 40 
					(isset($p['id_personne']) 	? "AND cp_id_personne = {$p['id_personne']} " 				: '').
41 
					(isset($p['ce_projet']) 	? "AND cp_ce_projet = {$p['ce_projet']} " 					: '').
 41 
					(isset($p['ce_projet']) 	? "AND cp_ce_projet = {$p['ce_projet']} " 					: '').
42 
					(isset($p['recherche']) ? $this->construireWhereRecherche($p['recherche']) : '').
 42 
					(isset($p['recherche']) ? $this->construireWhereRecherche($p['recherche']) : '').
43 
					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'cp_fmt_nom_complet ASC').' ';
 43 
					'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'TRIM(cp_nom) ASC').' ';
Line 44... Line 44...
44
44
45 
		$requete = str_replace('WHERE AND', 'WHERE', $requete);
 45 
		$requete = str_replace('WHERE AND', 'WHERE', $requete);
46 
		$requeteCount = $requete;
 46 
		$requeteCount = $requete;