class.arWhere.php

Go to the documentation of this file.

<?php
require_once(dirname(__FILE__) . '/../Statement/class.arStatement.php');

class arWhere extends arStatement
{
    const TYPE_STRING = 1;
    const TYPE_REGULAR = 2;
    protected $type = self::TYPE_REGULAR;
    protected $fieldname = '';
    protected $value;
    protected $operator = '=';
    protected $statement = '';
    protected $link = 'AND';


    public function asSQLStatement(ActiveRecord $ar)
    {
        if ($this->getType() == self::TYPE_REGULAR) {
            $arField = $ar->getArFieldList()->getFieldByName($this->getFieldname());
            if ($arField instanceof arField) {
                $type = $arField->getFieldType();
                $statement = $ar->getConnectorContainerName() . '.' . $this->getFieldname();
            } else {
                $statement = $this->getFieldname();
            }

            if (is_array($this->getValue())) {
                if (in_array($this->getOperator(), array( 'IN', 'NOT IN', 'NOTIN' ))) {
                    $statement .= ' ' . $this->getOperator() . ' (';
                } else {
                    $statement .= ' IN (';
                }
                $values = array();
                foreach ($this->getValue() as $value) {
                    $values[] = $ar->getArConnector()->quote($value, $type);
                }
                $statement .= implode(', ', $values);
                $statement .= ')';
            } else {
                if ($this->getValue() === null) {
                    $operator = 'IS';
                    if (in_array($this->getOperator(), array('IS', 'IS NOT'))) {
                        $operator = $this->getOperator();
                    }
                    $this->setOperator($operator);
                }
                $statement .= ' ' . $this->getOperator();
                $statement .= ' ' . $ar->getArConnector()->quote($this->getValue(), $type);
            }
            $this->setStatement($statement);
        }

        return $this->getStatement();
    }


    public function setFieldname($fieldname)
    {
        $this->fieldname = $fieldname;
    }


    public function getFieldname()
    {
        return $this->fieldname;
    }


    public function setOperator($operator)
    {
        $this->operator = $operator;
    }


    public function getOperator()
    {
        return $this->operator;
    }


    public function setValue($value)
    {
        $this->value = $value;
    }


    public function getValue()
    {
        return $this->value;
    }


    public function setType($type)
    {
        $this->type = $type;
    }


    public function getType()
    {
        return $this->type;
    }


    public function setStatement($statement)
    {
        $this->statement = $statement;
    }


    public function getStatement()
    {
        return $this->statement;
    }


    public function setLink($link)
    {
        $this->link = $link;
    }


    public function getLink()
    {
        return $this->link;
    }
}