public function getCounters(array $parameters = array())
{
$query = new Query(Internals\ContextCounterDayTable::getEntity());
if ($filter = $parameters['filter']) {
$query->setFilter($filter);
}
$i = 0;
foreach ($this->attributes as $name => $value) {
self::setAttributeFilter($query, '_conversion_attribute_' . ++$i . '_', $name, $value);
}
$query->registerRuntimeField(null, new ExpressionField('VALUE_SUM', 'SUM(%s)', array('VALUE')));
$splitNames = array();
if ($split = $parameters['split']) {
if (!is_array($split)) {
throw new ArgumentTypeException('parameters[split]', 'array');
}
foreach ($split as $name => $value) {
switch ($name) {
case 'ATTRIBUTE_NAME':
if (!is_string($value)) {
throw new ArgumentTypeException('parameters[split][ATTRIBUTE_NAME]', 'string');
}
self::setAttributeFilter($query, 'split_attribute', $value);
$query->addGroup('split_attribute.VALUE');
$query->addSelect('split_attribute.VALUE', 'ATTRIBUTE_VALUE');
$splitNames[] = 'ATTRIBUTE_VALUE';
break;
default:
throw new ArgumentTypeException('parameters[split][' . $name . ']', 'not implemented');
}
}
}
$query->addGroup('NAME');
$query->addSelect('NAME');
$query->addSelect('VALUE_SUM');
$result = $query->exec();
// return $result->fetchAll();
$counters = array();
while ($row = $result->fetch()) {
$level =& $counters;
foreach ($splitNames as $name) {
if (!($level =& $level[$row[$name]])) {
$level = array();
}
}
$level[$row['NAME']] = $row['VALUE_SUM'];
}
return $counters;
}
