| 26,7 → 26,7 |
|---|
| $info = array(); |
| |
| // Pré traitement des paramêtres |
| $p = $this->traiterParametresUrl(array('id_collection'), $param); |
| $p = $this->traiterParametresUrl(array('id_collection','source'), $param); |
| |
| // Construction de la requête |
| $requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT '). |
| 35,12 → 35,13 |
|---|
| ' LEFT JOIN coel_meta_historique_ligne ON (ccapu_ce_meta = cmhl_id_historique_ligne) '. |
| ' LEFT JOIN coel_publication AS cpu ON (ccapu_id_publication = cpu_id_publication) '. |
| ((count($p) != 0) ? 'WHERE ' : ''). |
| (isset($p['id_collection']) ? "AND ccapu_id_collection = {$p['id_collection']} " : ''). |
| (isset($p['id_collection']) ? "AND ccapu_id_collection = {$p['id_collection']} " : ''). |
| (isset($p['source']) ? "AND ccapu_source = {$p['source']} " : ''). |
| 'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'ccapu_ce_meta DESC').' '; |
| $requete = str_replace('WHERE AND', 'WHERE', $requete); |
| $requeteCount = $requete; |
| $requete .= "LIMIT $this->start, $this->limit "; |
| |
| //echo $requete;exit; |
| // Récupération des résultats |
| try { |
| $donnees = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC); |