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;
        }
}

?>