EngineWorks\Pivot\Aggregate

Complexity

Total Complexity

15

Size/Duplication

Total Lines	131
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

100%

Importance

Changes

0

11 Methods

Rating	Name	Duplication	Size	Complexity
B	__construct()	0	24	5
A	getFieldname()	0	4	1
A	getAsname()	0	4	1
A	getCaption()	0	4	1
A	getGroup()	0	4	1
A	getDecimals()	0	4	1
A	getOrder()	0	4	1
A	asArray()	0	11	1
A	getSQL()	0	6	1
A	groupTypes()	0	10	1
A	groupExists()	0	4	1

<?php
declare(strict_types = 1);
namespace EngineWorks\Pivot;

use EngineWorks\DBAL\DBAL;

class Aggregate
{
    const COUNT = 'COUNT';
    const SUM = 'SUM';
    const AVG = 'AVG';
    const MIN = 'MIN';
    const MAX = 'MAX';

    const ORDERNONE = '';
    const ORDERASC = 'ASC';
    const ORDERDESC = 'DESC';

    private $fieldname;
    private $asname;
    private $caption;
    private $group;
    private $decimals;
    private $order;

    public function __construct(
        string $fieldname,
        string $asname,
        string $caption,
        string $group,
        int $decimals,
        string $order
    ) {
        if (! $this->groupExists($group)) {
            throw new \InvalidArgumentException('Invalid value for group');
        }
        if ($decimals < 0 || $decimals > 8) {
            throw new \InvalidArgumentException('Invalid value for decimals');
        }
        if (! in_array($order, [static::ORDERNONE, static::ORDERASC, static::ORDERDESC])) {
            throw new \InvalidArgumentException('Invalid order value');
        }
        $this->fieldname = $fieldname;
        $this->asname = $asname;
        $this->caption = $caption;
        $this->group = $group;
        $this->decimals = $decimals;
        $this->order = $order;
    }

    /**
     * @return string
     */
    public function getFieldname(): string
    {
        return $this->fieldname;
    }

    /**
     * @return string
     */
    public function getAsname(): string
    {
        return $this->asname;
    }

    /**
     * @return string
     */
    public function getCaption(): string
    {
        return $this->caption;
    }

    /**
     * @return string
     */
    public function getGroup(): string
    {
        return $this->group;
    }

    /**
     * @return int
     */
    public function getDecimals(): int
    {
        return $this->decimals;
    }

    /**
     * @return string
     */
    public function getOrder(): string
    {
        return $this->order;
    }

    public function asArray() : array
    {
        return [
            'fieldname' => $this->fieldname,
            'caption' => $this->caption,
            'group' => $this->group,
            'asname' => $this->asname,
            'decimals' => $this->decimals,
            'order' => $this->order,
        ];
    }

    /**
     * @param DBAL $db
     * @return string
     */
    public function getSQL(DBAL $db) : string
    {
        return $this->group
            . '(' . $db->sqlFieldEscape($this->fieldname) . ')'
            . ' AS ' . $db->sqlFieldEscape($this->asname);
    }

    public static function groupTypes() : array
    {
        return [
            static::COUNT,
            static::SUM,
            static::AVG,
            static::MIN,
            static::MAX,
        ];
    }

    public static function groupExists(string $group) : bool
    {
        return in_array($group, static::groupTypes());
    }
}