arWhere Class Reference

Class arWhere. More...

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

References $link.

                                  {
                return $this->link;
        }

getOperator()

arWhere::getOperator

(

)

Returns

string

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

References $fieldname.

                                                 {
                $this->fieldname = $fieldname;
        }

setLink()

arWhere::setLink

(

$link

)

Parameters

string

$link

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

References $link.

                                       {
                $this->link = $link;
        }

setOperator()

arWhere::setOperator

(

$operator

)

Parameters

string

$operator

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

References $type.

                                       {
                $this->type = $type;
        }

setValue()

arWhere::setValue

(

$value

)

Parameters

mixed

$value

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