public function getAllLabels($module)
{
// $labels = $this->connection->query('SELECT
// [l].*,
// [def].[ext_id] as [extensions],
// [def].[title] as [ext_title],
// [def].[identifier] as [ext_identifier],
// [def].[name] as [ext_name]
// FROM
// [:core:labels] [l]
// LEFT JOIN
// [:core:label_ext_definitions] [def]
// USING
// ([label_id])
// ')->fetchAssoc('label_id,=,extensions');
$labels = $this->connection->query('SELECT
[l].*,
[def].[ext_id] as [extensions],
[def].[title] as [ext_title],
[def].[identifier] as [ext_identifier],
[def].[name] as [ext_name]
FROM
[:core:labels] [l]
LEFT JOIN
[:core:label_ext_definitions] [def]
USING
([label_id])
WHERE
[l].[module] = %s
ORDER BY [l].[create_button] DESC
', $module)->fetchAssoc('label_id,=,extensions');
// dump($labels);
// die();
// unserialize
$uLabels = array();
foreach ($labels as $labelId => $label) {
$uLabels[$labelId] = \Utils\MultiValues::unserializeArray($label);
if ($uLabels[$labelId]['langs'] === NULL) {
$uLabels[$labelId]['langs'] = array();
}
// remove empty extensions
$keys = array_keys($label['extensions']);
if (reset($keys) == "") {
$uLabels[$labelId]['extensions'] = array();
}
}
return $uLabels;
}
