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, 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 99 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 179 of file class.arWhere.php.

                                  {
                return $this->link;
        }

References $link.

◆ getOperator()

arWhere::getOperator ( )

Returns: string

Definition at line 115 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 163 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 147 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 131 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 91 of file class.arWhere.php.

                                                 {
                $this->fieldname = $fieldname;
        }

References $fieldname.

◆ setLink()

arWhere::setLink ( $link )

Parameters

string $link

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

                                       {
                $this->link = $link;
        }

References $link.

◆ setOperator()

arWhere::setOperator ( $operator )

Parameters

string $operator

Definition at line 107 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 155 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 139 of file class.arWhere.php.

                                       {
                $this->type = $type;
        }

References $type.

◆ setValue()

arWhere::setValue ( $value )

Parameters

mixed $value

Definition at line 123 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