Subversion Repositories eFlore/Applications.coel

Rev

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

Rev 1518 Rev 1765
Line 30... Line 30...
30
30
31 
		// Construction de la requête
 31 
		// Construction de la requête
32 
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT ').
 32 
		$requete = 	(($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT ').
33 
					'	ccap.*, '.
 33 
					'	ccap.*, '.
34 
					(isset($p['id_personne'])	? '	cc_nom, ' : '').
 34 
					(isset($p['id_personne'])	? '	cc_nom, ' : '').
35 
					'	cp_ce_projet, cp_fmt_nom_complet, cp_prenom, cp_nom, cp_naissance_date, cp_naissance_lieu, cp_ce_deces, cp_deces_date, cp_deces_lieu '.
 35 
					'	cp_fmt_nom_complet, cp_prenom, cp_nom, cp_naissance_date, cp_naissance_lieu, cp_ce_deces, cp_deces_date, cp_deces_lieu '.
36 
					'FROM coel_collection_a_personne AS ccap '.
 36 
					'FROM coel_collection_a_personne AS ccap '.
37 
					'	LEFT JOIN coel_meta_historique_ligne ON (ccap_ce_meta = cmhl_id_historique_ligne) '.
 37 
					'	LEFT JOIN coel_meta_historique_ligne ON (ccap_ce_meta = cmhl_id_historique_ligne) '.
38 
					'	LEFT JOIN coel_personne ON (ccap_id_personne = cp_id_personne) '.
 38 
					'	LEFT JOIN coel_personne ON (ccap_id_personne = cp_id_personne) '.
39 
					(isset($p['id_personne'])	? '	LEFT JOIN coel_collection ON (ccap_id_collection = cc_id_collection) ' : '').
 39 
					(isset($p['id_personne'])	? '	LEFT JOIN coel_collection ON (ccap_id_collection = cc_id_collection) ' : '').