| 26,17 → 26,21 |
|---|
| $info = array(); |
| |
| // Pré traitement des paramêtres |
| $p = $this->traiterParametresUrl(array('id_collection', 'id_role'), $param); |
| $p = $this->traiterParametresUrl(array('id_collection', 'id_role', 'id_personne'), $param); |
| |
| // Construction de la requête |
| $requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT '). |
| ' ccap.*, 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 '. |
| ' ccap.*, '. |
| (isset($p['id_personne']) ? ' cc_nom, ' : ''). |
| ' 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 '. |
| 'FROM coel_collection_a_personne AS ccap '. |
| ' LEFT JOIN coel_meta_historique_ligne ON (ccap_ce_meta = cmhl_id_historique_ligne) '. |
| ' LEFT JOIN coel_personne ON (ccap_id_personne = cp_id_personne) '. |
| (isset($p['id_personne']) ? ' LEFT JOIN coel_collection ON (ccap_id_collection = cc_id_collection) ' : ''). |
| ((count($p) != 0) ? 'WHERE ' : ''). |
| (isset($p['id_collection']) ? "AND ccap_id_collection = {$p['id_collection']} " : ''). |
| (isset($p['id_collection']) ? "AND ccap_id_collection = {$p['id_collection']} " : ''). |
| (isset($p['id_role']) ? "AND ccap_id_role = {$p['id_role']} " : ''). |
| (isset($p['id_personne']) ? "AND ccap_id_personne = {$p['id_personne']} " : ''). |
| 'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'ccap_ce_meta DESC').' '; |
| $requete = str_replace('WHERE AND', 'WHERE', $requete); |
| $requeteCount = $requete; |
| 44,14 → 48,14 |
|---|
| |
| // Récupération des résultats |
| try { |
| $donnees = $this->bdd->query($requete)->fetchAll(); |
| |
| $nbElements = 0; |
| $donnees = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC); |
| if ($donnees === false) { |
| $this->messages[] = "La requête a retourné aucun résultat."; |
| } else { |
| $nbElements = $this->bdd->query($requeteCount)->rowCount(); |
| } |
| |
| $nbElements = $this->bdd->query($requeteCount)->rowCount(); |
| |
| $info['nbElements'] = $nbElements; |
| $info['collectionsAPersonne'] = $donnees; |
| |