<?php

namespace rednaoeasycalculationforms\pr\QueryBuilder\AggregationBuilder;

use rednaoeasycalculationforms\core\Exception\FriendlyException;
use rednaoeasycalculationforms\DTO\FormulaOptionsDTO;
use rednaoeasycalculationforms\pr\QueryBuilder\QueryBuilder;

class AggregationQueryBuilder extends QueryBuilder
{
    /** @var FormulaOptionsDTO */
    public $Formula;
    public function __construct($Loader, $RootTable = null, $RootID = null, $rootConditions = [], $formula = null)
    {
        parent::__construct($Loader, $RootTable, $RootID, $rootConditions);
        $this->Formula = $formula;
    }

    protected function GenerateColumnsSectionQuery($isCounting = false)
    {
        if(!in_array($this->Formula->FormulaType, ['min', 'max', 'sum', 'count']))
            throw new FriendlyException('Invalid aggregation ' . $this->Formula->FormulaType . ' please check the formulas that you have and try again');

        if($this->Formula->FormulaType != 'count')
            return ' select ' . $this->Formula->FormulaType . '(aggregation.numericvalue)';
        else
            return ' select count(' . esc_sql($this->RootID) . '.entry_id)';
    }

}