class.arWhere.php

Go to the documentation of this file.

<?php
 
class arWhere extends arStatement
{
    public const TYPE_STRING = 1;
    public const TYPE_REGULAR = 2;
    protected int $type = self::TYPE_REGULAR;
    protected string $fieldname = '';
    protected $value;
    protected string $operator = '=';
    protected string $statement = '';
    protected string $link = 'AND';
 
    public function asSQLStatement(ActiveRecord $activeRecord, ilDBInterface $db): string
    {
        $type = null;
        if ($this->getType() === self::TYPE_REGULAR) {
            $arField = $activeRecord->getArFieldList()->getFieldByName($this->getFieldname());
            $type = 'text';
            if ($arField instanceof arField) {
                $type = $arField->getFieldType();
                $statement = $activeRecord->getConnectorContainerName() . '.' . $this->getFieldname();
            } else {
                $statement = $this->getFieldname();
            }
 
            if (is_array($this->getValue())) {
                if (in_array($this->getOperator(), ['IN', 'NOT IN', 'NOTIN'])) {
                    $statement .= ' ' . $this->getOperator() . ' (';
                } else {
                    $statement .= ' IN (';
                }
                $values = [];
                foreach ($this->getValue() as $value) {
                    $values[] = $activeRecord->getArConnector()->quote($value, $type);
                }
                $statement .= implode(', ', $values);
                $statement .= ')';
            } else {
                if ($this->getValue() === null) {
                    $operator = 'IS';
                    if (in_array($this->getOperator(), ['IS', 'IS NOT'])) {
                        $operator = $this->getOperator();
                    }
                    $this->setOperator($operator);
                }
                $statement .= ' ' . $this->getOperator();
                $statement .= ' ' . $activeRecord->getArConnector()->quote($this->getValue(), $type);
            }
            $this->setStatement($statement);
        }
 
        return $this->getStatement();
    }
 
    public function setFieldname(string $fieldname): void
    {
        $this->fieldname = $fieldname;
    }
 
    public function getFieldname(): string
    {
        return $this->fieldname;
    }
 
    public function setOperator(string $operator): void
    {
        $this->operator = $operator;
    }
 
    public function getOperator(): string
    {
        return $this->operator;
    }
 
    public function setValue($value): void
    {
        $this->value = $value;
    }
 
    public function getValue()
    {
        return $this->value;
    }
 
    public function setType(int $type): void
    {
        $this->type = $type;
    }
 
    public function getType(): int
    {
        return $this->type;
    }
 
    public function setStatement(string $statement): void
    {
        $this->statement = $statement;
    }
 
    public function getStatement(): string
    {
        return $this->statement;
    }
 
    public function setLink(string $link): void
    {
        $this->link = $link;
    }
 
    public function getLink(): string
    {
        return $this->link;
    }
}