CountAggregateColumn.php

<?php
/**
 * (c) PSP UK Group Ltd. <[email protected]>
 *
 * For the full copyright and license information,
 * please view the LICENSE file that was distributed with this source code.
 */

namespace Psp\Query\Aggregate;

class CountAggregateColumn extends AbstractSqlFunctionAggregateColumn
{
  use PlatformAgnosticAggregateColumnTrait;

  # {{{ AbstractSqlFunctionAggregateColumn

  /**
   * {@inheritdoc}
   */
  protected function getSqlFunction()
  {
    return 'COUNT';
  }

  # }}}
}

DistinctPostgreSqlAggregateColumn.php

<?php
/**
 * (c) PSP UK Group Ltd. <[email protected]>
 *
 * For the full copyright and license information,
 * please view the LICENSE file that was distributed with this source code.
 */

namespace Psp\Query\Aggregate;

use Doctrine\DBAL\Platforms\PostgreSqlPlatform;

/**
 * A string aggregate PostgreSQL aggregate columns.
 */
class DistinctPostgreSqlAggregateColumn extends AbstractPostgreSqlAggregateColumn
{
  # {{{ AggregateColumnInterface

  /**
   * {@inheritdoc}
   */
  public function getName()
  {
    return 'DISTINCT';
  }

  # }}}

  # {{{ AbstractPostgreSqlAggregateColumn

  /**
   * {@inheritdoc}
   */
  protected function doApply($column, PostgreSqlPlatform $platform)
  {
    return sprintf(
      "string_agg(DISTINCT %s::text, ',')",
      $column
    );
  }

  # }}}
}