static function createGroupBySQLStrings(&$outGroupBySelectText, &$outGroupByText, $groupBy) { if ($groupBy) { if (isset($groupBy['field']) and isset($groupBy['type'])) { $groupByField = $groupBy['field']; $groupByFieldType = $groupBy['type']; switch ($groupByField) { case 'published': $groupBySelect = eZContentObjectTreeNode::subTreeGroupByDateField("ezcontentobject." . $groupByField, $groupByFieldType); $groupBySelect['field'] = "ezcontentobject." . $groupByField; break; case 'modified': $groupBySelect = eZContentObjectTreeNode::subTreeGroupByDateField("ezcontentobject." . $groupByField, $groupByFieldType); $groupBySelect['field'] = "ezcontentobject." . $groupByField; break; } $outGroupBySelectText = ", " . $groupBySelect['select']; $outGroupByText = "GROUP BY " . $groupBySelect['group_field']; } } }