This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for arWhere:

Collaboration diagram for arWhere:

Public Member Functions
	asSQLStatement (ActiveRecord $activeRecord, ilDBInterface $db)

	setFieldname (string $fieldname)

	getFieldname ()

	setOperator (string $operator)

	getOperator ()

	setValue (mixed $value)

	getValue ()

	setType (int $type)

	getType ()

	setStatement (string $statement)

	getStatement ()

	setLink (string $link)

	getLink ()

Public Member Functions inherited from arStatement
	asSQLStatement (ActiveRecord $activeRecord, ilDBInterface $db)

	getTableNameAs ()

	setTableNameAs (string $table_name_as)

Data Fields
const	TYPE_STRING = 1

const	TYPE_REGULAR = 2

Protected Attributes
int	$type = self::TYPE_REGULAR

string	$fieldname = ''

	$value

string	$operator = '='

string	$statement = ''

string	$link = 'AND'

Protected Attributes inherited from arStatement
string	$table_name_as = ''

Additional Inherited Members
Protected Member Functions inherited from arStatement
	wrapFields (array $fields, ilDBInterface $db)

	wrapField (string $field, ilDBInterface $db)

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning 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 24 of file class.arWhere.php.

Member Function Documentation

◆ asSQLStatement()

arWhere::asSQLStatement	(	ActiveRecord	$activeRecord,
		ilDBInterface	$db
	)

Parameters

ilDBInterface $db @description Build WHERE Statement

Exceptions

arException

Reimplemented from arStatement.

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

                                                                                 : string
    {
        $type = null;
        if ($this->getType() === self::TYPE_REGULAR) {
            $arField = $activeRecord->getArFieldList()->getFieldByName($this->getFieldname());
            $type = 'text';
            if ($arField instanceof arField) {
                $type = $arField->getFieldType();
                $statement = $activeRecord->getConnectorContainerName() . '.' . $this->getFieldname();
            } else {
                $statement = $this->getFieldname();
            }
 
            if (is_array($this->getValue())) {
                if (in_array($this->getOperator(), ['IN', 'NOT IN', 'NOTIN'])) {
                    $statement .= ' ' . $this->getOperator() . ' (';
                } else {
                    $statement .= ' IN (';
                }
                $values = [];
                foreach ($this->getValue() as $value) {
                    $values[] = $activeRecord->getArConnector()->quote($value, $type);
                }
                $statement .= implode(', ', $values);
                $statement .= ')';
            } else {
                if ($this->getValue() === null) {
                    $operator = 'IS';
                    if (in_array($this->getOperator(), ['IS', 'IS NOT'])) {
                        $operator = $this->getOperator();
                    }
                    $this->setOperator($operator);
                }
                $statement .= ' ' . $this->getOperator();
                $statement .= ' ' . $activeRecord->getArConnector()->quote($this->getValue(), $type);
            }
            $this->setStatement($statement);
        }
 
        return $this->getStatement();
    }

References $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 ( )

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

                                  : string
    {
        return $this->fieldname;
    }

References $fieldname.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getLink()

arWhere::getLink ( )

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

                             : string
    {
        return $this->link;
    }

References $link.

◆ getOperator()

arWhere::getOperator ( )

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

                                 : string
    {
        return $this->operator;
    }

References $operator.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getStatement()

arWhere::getStatement ( )

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

                                  : string
    {
        return $this->statement;
    }

References $statement.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getType()

arWhere::getType ( )

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

                             : int
    {
        return $this->type;
    }

References $type.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ getValue()

arWhere::getValue ( )

Returns: mixed|null

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

    {
        return $this->value;
    }

References $value.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ setFieldname()

arWhere::setFieldname ( string $fieldname )

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

                                                   : void
    {
        $this->fieldname = $fieldname;
    }

References $fieldname.

◆ setLink()

arWhere::setLink ( string $link )

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

                                         : void
    {
        $this->link = $link;
    }

References $link, and ILIAS\Repository\link().

Here is the call graph for this function:

◆ setOperator()

arWhere::setOperator ( string $operator )

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

                                                 : void
    {
        $this->operator = $operator;
    }

References $operator.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ setStatement()

arWhere::setStatement ( string $statement )

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

                                                   : void
    {
        $this->statement = $statement;
    }

References $statement.

Referenced by asSQLStatement().

Here is the caller graph for this function:

◆ setType()

arWhere::setType ( int $type )

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

                                      : void
    {
        $this->type = $type;
    }

References $type.

◆ setValue()

arWhere::setValue ( mixed $value )

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

                                          : void
    {
        $this->value = $value;
    }

References $value.

Field Documentation

◆ $fieldname

string arWhere::$fieldname = ''

protected

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

Referenced by getFieldname(), and setFieldname().

◆ $link

string arWhere::$link = 'AND'

protected

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

Referenced by getLink(), and setLink().

◆ $operator

string arWhere::$operator = '='

protected

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

Referenced by getOperator(), and setOperator().

◆ $statement

string arWhere::$statement = ''

protected

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

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

◆ $type

int arWhere::$type = self::TYPE_REGULAR

protected

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

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

◆ $value

arWhere::$value

protected

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

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

◆ TYPE_REGULAR

const arWhere::TYPE_REGULAR = 2

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

◆ TYPE_STRING

const arWhere::TYPE_STRING = 1

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

Referenced by ActiveRecordList\where().

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

components/ILIAS/ActiveRecord/Connector/Where/class.arWhere.php

Public Member Functions

Data Fields

Protected Attributes

Additional Inherited Members

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