| Line 34... |
Line 34... |
| 34 |
// Pré traitement des paramêtres
|
34 |
// Pré traitement des paramêtres
|
| 35 |
$p = $this->traiterParametresUrl(array('id_publication', 'id_personne', 'id_role'), $param, false);
|
35 |
$p = $this->traiterParametresUrl(array('id_publication', 'id_personne', 'id_role'), $param, false);
|
| Line 36... |
Line 36... |
| 36 |
|
36 |
|
| 37 |
// Construction de la requête
|
37 |
// Construction de la requête
|
| 38 |
$requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT ').
|
38 |
$requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT ').
|
| 39 |
' cpu.*, cpuap.*, cp_id_personne, cp_ce_projet, cp_prenom, cp_nom, cp_fmt_nom_complet, cp_code_postal, cp_truk_courriel, cp_ville '.
|
39 |
' cpu.*, cpuap.*, cp_id_personne, cp_prenom, cp_nom, cp_fmt_nom_complet, cp_code_postal, cp_truk_courriel, cp_ville '.
|
| 40 |
'FROM coel_publication_a_personne AS cpuap '.
|
40 |
'FROM coel_publication_a_personne AS cpuap '.
|
| 41 |
' LEFT JOIN coel_meta_historique_ligne ON (cpuap_ce_meta = cmhl_id_historique_ligne) '.
|
41 |
' LEFT JOIN coel_meta_historique_ligne ON (cpuap_ce_meta = cmhl_id_historique_ligne) '.
|
| 42 |
' LEFT JOIN coel_personne AS cp ON (cpuap_id_personne = cp_id_personne) '.
|
42 |
' LEFT JOIN coel_personne AS cp ON (cpuap_id_personne = cp_id_personne) '.
|
| 43 |
' LEFT JOIN coel_publication AS cpu ON (cpuap_id_publication = cpu_id_publication) '.
|
43 |
' LEFT JOIN coel_publication AS cpu ON (cpuap_id_publication = cpu_id_publication) '.
|