/** * 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; }