echo rex_warning($sql->getError());
}
$func = '';
}
if ($func == '') {
$list = new rex_list('
SELECT
`id`, `title`, `publishedAt`, `status`
FROM `' . rex_asd_news_config::getTable() . '`
WHERE `clang` = ' . $clang . '
ORDER BY CASE
WHEN `publishedAt` = "0000-00-00 00:00:00" THEN 1
ELSE 0
END DESC,
`publishedAt` DESC, `updatedAt` DESC');
$list->addParam('clang', $clang);
$list->addParam('subpage', $subpage);
$imgHeader = '
<a class="rex-i-element rex-i-generic-add" href="' . $list->getUrl(array('func' => 'add')) . '">
<span class="rex-i-element-text">add</span>
</a>';
$list->setColumnLabel('id', $imgHeader);
$list->setColumnLabel('title', $I18N->msg('asd_news_title'));
$list->setColumnLabel('publishedAt', $I18N->msg('asd_news_publishedAt'));
$list->removeColumn('status');
$list->addTableColumnGroup(array(40, '*', 120, 50, 50, 50, 50));
$list->setColumnParams('title', array('func' => 'edit', 'id' => '###id###'));
$list->setColumnFormat('publishedAt', 'custom', function ($params) use($list, $now, $clang, $I18N, $REX) {
$publishedAt = new DateTime($list->getValue('publishedAt'));
$value = $publishedAt->format('d.m.Y H:i');
if ($list->getValue('publishedAt') == '0000-00-00 00:00:00') {
