Inheritance diagram for arWhere:

Collaboration diagram for arWhere:

Public Member Functions
	asSQLStatement (ActiveRecord $ar)
	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 )

Build WHERE Statement

Parameters

ActiveRecord $ar

Exceptions

arException

Returns: string

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

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

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

Here is the call graph for this function:

◆ getFieldname()

arWhere::getFieldname ( )

Returns: string

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

References $fieldname.

Referenced by asSQLStatement().

     {
         return $this->fieldname;
     }

Here is the caller graph for this function:

◆ getLink()

arWhere::getLink ( )

Returns: string

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

References $link.

     {
         return $this->link;
     }

◆ getOperator()

arWhere::getOperator ( )

Returns: string

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

Referenced by asSQLStatement().

     {
         return $this->operator;
     }

Here is the caller graph for this function:

◆ getStatement()

arWhere::getStatement ( )

Returns: string

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

References $statement.

Referenced by asSQLStatement().

     {
         return $this->statement;
     }

Here is the caller graph for this function:

◆ getType()

arWhere::getType ( )

Returns: int

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

References $type.

Referenced by asSQLStatement().

     {
         return $this->type;
     }

Here is the caller graph for this function:

◆ getValue()

arWhere::getValue ( )

Returns: mixed

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

References $value.

Referenced by asSQLStatement().

     {
         return $this->value;
     }

Here is the caller graph for this function:

◆ setFieldname()

arWhere::setFieldname ( $fieldname )

Parameters

string $fieldname

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

References $fieldname.

     {
         $this->fieldname = $fieldname;
     }

◆ setLink()

arWhere::setLink ( $link )

Parameters

string $link

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

References $link.

     {
         $this->link = $link;
     }

◆ setOperator()

arWhere::setOperator ( $operator )

Parameters

string $operator

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

Referenced by asSQLStatement().

     {
         $this->operator = $operator;
     }

Here is the caller graph for this function:

◆ setStatement()

arWhere::setStatement ( $statement )

Parameters

string $statement

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

References $statement.

Referenced by asSQLStatement().

     {
         $this->statement = $statement;
     }

Here is the caller graph for this function:

◆ setType()

arWhere::setType ( $type )

Parameters

int $type

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

References $type.

     {
         $this->type = $type;
     }

◆ setValue()

arWhere::setValue ( $value )

Parameters

mixed $value

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

References $value.

     {
         $this->value = $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.

◆ $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