Inheritance diagram for arWhere:

Collaboration diagram for arWhere:

Public Member Functions
	asSQLStatement (ActiveRecord $ar)
	@description Build WHERE Statement More...

	setFieldname ($fieldname)

	getFieldname ()

	setOperator ($operator)

	getOperator ()

	setValue ($value)

	getValue ()

	setType ($type)

	getType ()

	setStatement ($statement)

	getStatement ()

	setLink ($link)

	getLink ()

Public Member Functions inherited from arStatement
	asSQLStatement (ActiveRecord $ar)

	getTableNameAs ()

	setTableNameAs ($table_name_as)

Data Fields
const	TYPE_STRING = 1

const	TYPE_REGULAR = 2

Protected Attributes
	$type = self::TYPE_REGULAR

	$fieldname = ''

	$value

	$operator = '='

	$statement = ''

	$link = 'AND'

Protected Attributes inherited from arStatement
	$table_name_as = ''

Detailed Description

Class arWhere.

Author: Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Version: 2.0.7

Definition at line 10 of file class.arWhere.php.

Member Function Documentation

◆ asSQLStatement()

arWhere::asSQLStatement ( ActiveRecord $ar )

@description Build WHERE Statement

Parameters

ActiveRecord $ar

Exceptions

arException

Returns: string

Reimplemented from arStatement.

Definition at line 48 of file class.arWhere.php.

    {
        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();
    }

References $operator, $statement, $type, $value, $values, ActiveRecord\getArConnector(), ActiveRecord\getArFieldList(), ActiveRecord\getConnectorContainerName(), getFieldname(), getOperator(), getStatement(), getType(), getValue(), setOperator(), and setStatement().

Here is the call graph for this function:

◆ getFieldname()

arWhere::getFieldname ( )

Returns: string

Definition at line 101 of file class.arWhere.php.

    {
        return $this->fieldname;
    }

References $fieldname.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getLink()

arWhere::getLink ( )

Returns: string

Definition at line 191 of file class.arWhere.php.

    {
        return $this->link;
    }

References $link.

◆ getOperator()

arWhere::getOperator ( )

Returns: string

Definition at line 119 of file class.arWhere.php.

    {
        return $this->operator;
    }

References $operator.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getStatement()

arWhere::getStatement ( )

Returns: string

Definition at line 173 of file class.arWhere.php.

    {
        return $this->statement;
    }

References $statement.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getType()

arWhere::getType ( )

Returns: int

Definition at line 155 of file class.arWhere.php.

    {
        return $this->type;
    }

References $type.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getValue()

arWhere::getValue ( )

Returns: mixed

Definition at line 137 of file class.arWhere.php.

    {
        return $this->value;
    }

References $value.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ setFieldname()

arWhere::setFieldname ( $fieldname )

Parameters

string $fieldname

Definition at line 92 of file class.arWhere.php.

    {
        $this->fieldname = $fieldname;
    }

References $fieldname.

◆ setLink()

arWhere::setLink ( $link )

Parameters

string $link

Definition at line 182 of file class.arWhere.php.

    {
        $this->link = $link;
    }

References $link.

◆ setOperator()

arWhere::setOperator ( $operator )

Parameters

string $operator

Definition at line 110 of file class.arWhere.php.

    {
        $this->operator = $operator;
    }

References $operator.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ setStatement()

arWhere::setStatement ( $statement )

Parameters

string $statement

Definition at line 164 of file class.arWhere.php.

    {
        $this->statement = $statement;
    }

References $statement.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ setType()

arWhere::setType ( $type )

Parameters

int $type

Definition at line 146 of file class.arWhere.php.

    {
        $this->type = $type;
    }

References $type.

◆ setValue()

arWhere::setValue ( $value )

Parameters

mixed $value

Definition at line 128 of file class.arWhere.php.

    {
        $this->value = $value;
    }

References $value.

Field Documentation

◆ $fieldname

arWhere::$fieldname = ''

protected

Definition at line 21 of file class.arWhere.php.

Referenced by getFieldname(), and setFieldname().

◆ $link

arWhere::$link = 'AND'

protected

Definition at line 37 of file class.arWhere.php.

Referenced by getLink(), and setLink().

◆ $operator

arWhere::$operator = '='

protected

Definition at line 29 of file class.arWhere.php.

Referenced by asSQLStatement(), getOperator(), and setOperator().

◆ $statement

arWhere::$statement = ''

protected

Definition at line 33 of file class.arWhere.php.

Referenced by asSQLStatement(), getStatement(), and setStatement().

◆ $type

arWhere::$type = self::TYPE_REGULAR

protected

Definition at line 17 of file class.arWhere.php.

Referenced by asSQLStatement(), getType(), and setType().

◆ $value

arWhere::$value

protected

Definition at line 25 of file class.arWhere.php.

Referenced by asSQLStatement(), getValue(), and setValue().

◆ TYPE_REGULAR

const arWhere::TYPE_REGULAR = 2

Definition at line 13 of file class.arWhere.php.

◆ TYPE_STRING

const arWhere::TYPE_STRING = 1

Definition at line 12 of file class.arWhere.php.

Referenced by ActiveRecordList\where().

The documentation for this class was generated from the following file:

Services/ActiveRecord/Connector/Where/class.arWhere.php

Public Member Functions

Data Fields

Protected Attributes

Detailed Description

Member Function Documentation

◆ asSQLStatement()

◆ getFieldname()

◆ getLink()

◆ getOperator()

◆ getStatement()

◆ getType()

◆ getValue()

◆ setFieldname()

◆ setLink()

◆ setOperator()

◆ setStatement()

◆ setType()

◆ setValue()

Field Documentation

◆ $fieldname

◆ $link

◆ $operator

◆ $statement

◆ $type

◆ $value

◆ TYPE_REGULAR

◆ TYPE_STRING