30,10 → 30,11 |
|
// Construction de la requête |
$requete = (($this->distinct) ? 'SELECT DISTINCT ' : 'SELECT '). |
' ccapu.*, cpu.* '. |
' ccapu.*, cpu.*, cs_nom '. |
'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,6 → 52,18 |
|
$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; |
|