/**
* Prepare the list grouped data configuration.
*
* @param $chunks
*
* @return SQLListDataGroupedConfig
*/
protected function prepareListDataConfig($chunks)
{
$config = new SQLListDataGroupedConfig();
$config->setTable('tl_calendar_events');
$config->setKeyColumn('id');
$config->setColumns('DATE_FORMAT(FROM_UNIXTIME(startDate), \'%%m\') as month');
$config->setConditionExpr($this->prepareConditionExpression($chunks));
$config->setGroupByParameter('month');
$config->setLabelCallback($this->prepareLabelCallback());
$config->setIconCallback($this->prepareIconCallback());
return $config;
}
/**
* Prepare the list grouped data configuration.
*
* @return SQLAdjacencyTreeDataConfigWithItems
*/
protected function prepareListDataConfig($chunks)
{
$config = new SQLListDataGroupedConfig();
$config->setTable('tl_news');
$config->setKeyColumn('id');
$config->setColumns('DATE_FORMAT(FROM_UNIXTIME(date), \'%%Y\') as year');
$config->setConditionExpr('pid=' . $chunks[1]);
$config->setGroupByParameter('year');
$config->setLabelCallback($this->prepareLabelCallback($config));
$config->setIconCallback($this->prepareIconCallback());
return $config;
}
/**
* prepare the list data configuration.
*
* @return SQLAdjacencyTreeDataConfigWithItems
*/
protected function prepareListDataConfig($chunks = array())
{
$config = new SQLListDataGroupedConfig();
$config->setTable('tl_news');
$config->setKeyColumn('id');
$config->setColumns($this->getColumns());
$config->setOrderByExpr('time');
$config->setLabelCallback($this->prepareLabelCallback($config));
$config->setIconCallback($this->prepareIconCallback());
$config->setContentCallback($this->prepareContentCallback());
if (count($chunks) > 0) {
$config->setConditionExpr($this->prepareConditionExpression($chunks));
}
return $config;
}
