| 30,11 → 30,10 |
|---|
| |
| // Construction de la requête |
| $requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT '). |
| ' ccapu.*, cpu.*, cs_nom '. |
| ' ccapu.*, cpu.* '. |
| 'FROM coel_collection_a_publication AS ccapu '. |
| ' 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) '. |
| ' LEFT JOIN coel_structure AS cs ON (cs_id_structure = cpu_ce_truk_editeur) '. |
| ((count($p) != 0) ? 'WHERE ' : ''). |
| (isset($p['id_collection']) ? "AND ccapu_id_collection = {$p['id_collection']} " : ''). |
| (isset($p['source']) ? "AND ccapu_source = {$p['source']} " : ''). |
| 51,19 → 50,7 |
|---|
| } |
| |
| $nbElements = $this->bdd->query($requeteCount)->rowCount(); |
| |
| // Bricolage crado pour remplacer les "ce_" éditeurs par la valeur jointe depuis coel_structure |
| foreach ($donnees as &$d) { |
| $ce_ed = $d['cpu_ce_truk_editeur']; |
| if (is_numeric($ce_ed)) { |
| $cs_nom = $d['cs_nom']; |
| if ($cs_nom === null) { |
| $cs_nom = ""; // c'est ça ou rien |
| } |
| $d['cpu_ce_truk_editeur'] = $cs_nom; |
| } |
| } |
| |
| |
| $info['nbElements'] = $nbElements; |
| $info['collectionsAPublication'] = $donnees; |
| |