# give/4.16.9/src/Framework/QueryBuilder/Clauses/Having.php

GiveWP – Donation Plugin and Fundraising Platform, version 4.16.9. 127 lines.

- Page: https://pluginprobe.com/plugins/give/4.16.9/code/src/Framework/QueryBuilder/Clauses/Having.php
- Raw: https://pluginprobe.com/plugins/give/4.16.9/raw/src/Framework/QueryBuilder/Clauses/Having.php
- Modified: 2022-02-25T01:33:58+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/give/4.16.9/code/src/Framework/QueryBuilder/Clauses/Having.php#L10-L20`.

```php
<?php

namespace Give\Framework\QueryBuilder\Clauses;

use Give\Framework\QueryBuilder\Types\Math;
use Give\Framework\QueryBuilder\Types\Operator;
use InvalidArgumentException;

/**
 * @since 2.19.0
 */
class Having
{
    /**
     * @var string
     */
    public $column;

    /**
     * @var string
     */
    public $comparisonOperator;

    /**
     * @var string|int
     */
    public $value;

    /**
     * @var string
     */
    public $logicalOperator;

    /**
     * @var string|null
     */
    public $mathFunction;

    /**
     * @param  string  $column
     * @param  string  $comparisonOperator
     * @param  string|int  $value
     * @param  string|null  $logicalOperator
     * @param  string  $mathFunction
     */
    public function __construct($column, $comparisonOperator, $value, $logicalOperator, $mathFunction = null)
    {
        $this->column             = trim($column);
        $this->comparisonOperator = $this->getComparisonOperator($comparisonOperator);
        $this->value              = $value;
        $this->logicalOperator    = $logicalOperator ? $this->getLogicalOperator($logicalOperator) : '';
        $this->mathFunction       = $this->getMathFunction($mathFunction);
    }

    /**
     * @param  string  $logicalOperator
     *
     * @return string
     */
    private function getLogicalOperator($logicalOperator)
    {
        $operators = [
            Operator::_AND,
            Operator::_OR
        ];

        $logicalOperator = strtoupper($logicalOperator);

        if ( ! in_array($logicalOperator, $operators, true)) {
            throw new InvalidArgumentException(
                sprintf(
                    'Unsupported logical operator %s. Please use one of the supported operators (%s)',
                    $logicalOperator,
                    implode(',', $operators)
                )
            );
        }

        return $logicalOperator;
    }

    /**
     * @param  string  $comparisonOperator
     *
     * @return string
     */
    private function getComparisonOperator($comparisonOperator)
    {
        $operators = [
            '<',
            '<=',
            '>',
            '>=',
            '<>',
            '!=',
            '='
        ];

        if ( ! in_array($comparisonOperator, $operators, true)) {
            throw new InvalidArgumentException(
                sprintf(
                    'Unsupported comparison operator %s. Please use one of the supported operators (%s)',
                    $comparisonOperator,
                    implode(',', $operators)
                )
            );
        }

        return $comparisonOperator;
    }


    /**
     * @param  string  $mathFunction
     *
     * @return string
     */
    private function getMathFunction($mathFunction)
    {
        if (array_key_exists($mathFunction, Math::getTypes())) {
            return $mathFunction;
        }

        return null;
    }
}

```