method browseByGroup documentation in bbn\Appui\Medias
function(string $idGroup, array $cfg = [], int $limit = 20, int $start = 0)
{
$cf = $this->getClassCfg();
$t = $cf['tables']['medias_groups_medias'];
$cfg['join'] = [[
'table' => $t,
'on' => [
'conditions' => [[
'field' => $this->db->cfn('id_media', $t),
'exp' => $this->db->cfn('id', $cf['tables']['medias'])
], [
'field' => $this->db->cfn('id_group', $t),
'value' => $idGroup
]]
]
]];
if (empty($cfg['order']) || !\is_array($cfg['order'])) {
$cfg['order'] = [];
}
$cfg['order'][] = [
'field' => $this->db->cfn('position', $t),
'dir' => 'ASC'
];
if ($res = $this->browse($cfg, $limit, $start)) {
foreach ($res['data'] as $i => $d) {
$media_groups_media = $this->db->rselect(
$t,
[],
[
$cf['arch']['medias_groups_medias']['id_group'] => $idGroup,
$cf['arch']['medias_groups_medias']['id_media'] => $d[$cf['arch']['medias']['id']]
]
);
$res['data'][$i][$cf['arch']['medias_groups_medias']['position']] = $media_groups_media['position'];
$res['data'][$i][$cf['arch']['medias_groups_medias']['link']] = $media_groups_media['link'];
}
}
return $res;
}
BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way
This website uses cookies to ensure you get the best experience on our website.
© 2011-2023
BBN Solutions
