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') { return ''; } return '<span>' . $value . '</span>'; }); $list->addColumn('publishCol', $I18N->msg('asd_news_publish'), -1, array('<th colspan="4">' . $I18N->msg('actions') . '</th>', '<td>###VALUE###</td>')); $list->setColumnFormat('publishCol', 'custom', function ($params) use($list, $clang, $now, $I18N) { $publishedAt = new DateTime($list->getValue('publishedAt')); if ($list->getValue('publishedAt') == '0000-00-00 00:00:00') { return '