class.arHaving.php

Go to the documentation of this file.

<?php
 
class arHaving extends arStatement
{
    protected string $table_name = '';
    protected string $fieldname = '';
    protected $value;
    protected string $operator = '=';
    protected string $statement = '';
    protected string $glue = 'AND';
 
    public function asSQLStatement(ActiveRecord $activeRecord, ilDBInterface $db): string
    {
        $statement = '';
        if ($this->getTableName() !== '' && $this->getTableName() !== '0') {
            $statement .= $this->getTableName() . '.';
        }
        $statement .= $db->quoteIdentifier($this->getFieldname()) . ' ' . $this->getOperator() . ' ' . $db->quote($this->getValue()) . '';
        $this->setStatement($statement);
 
        return $this->getStatement();
    }
 
    public function getFieldname(): string
    {
        return $this->fieldname;
    }
 
    public function setFieldname(string $fieldname): void
    {
        $this->fieldname = $fieldname;
    }
 
    public function getValue()
    {
        return $this->value;
    }
 
    public function setValue($value): void
    {
        $this->value = $value;
    }
 
    public function getOperator(): string
    {
        return $this->operator;
    }
 
    public function setOperator(string $operator): void
    {
        $this->operator = $operator;
    }
 
    public function getStatement(): string
    {
        return $this->statement;
    }
 
    public function setStatement(string $statement): void
    {
        $this->statement = $statement;
    }
 
    public function getGlue(): string
    {
        return $this->glue;
    }
 
    public function setGlue(string $glue): void
    {
        $this->glue = $glue;
    }
 
    public function getTableName(): string
    {
        return $this->table_name;
    }
 
    public function setTableName(string $table_name): void
    {
        $this->table_name = $table_name;
    }
}