class.arJoin.php

Go to the documentation of this file.

<?php
require_once(dirname(__FILE__) . '/../Statement/class.arStatement.php');

class arJoin extends arStatement
{
    const TYPE_NORMAL = self::TYPE_INNER;
    const TYPE_LEFT = 'LEFT';
    const TYPE_RIGHT = 'RIGHT';
    const TYPE_INNER = 'INNER';
    protected $type = self::TYPE_NORMAL;
    protected $table_name = '';
    protected $fields = array( '*' );
    protected $operator = '=';
    protected $on_first_field = '';
    protected $on_second_field = '';
    protected $full_names = false;
    protected $both_external = false;
    protected $is_mapped = false;


    protected function asStatementText(ActiveRecord $ar, $as = ' AS ')
    {
        $return = ' ' . $this->getType() . ' ';
        $return .= ' JOIN ' . $this->getTableName() . $as . $this->getTableNameAs();
        if ($this->getBothExternal()) {
            $return .= ' ON ' . $this->getOnFirstField() . ' ' . $this->getOperator() . ' ';
        } else {
            $return .= ' ON ' . $ar->getConnectorContainerName() . '.' . $this->getOnFirstField() . ' ' . $this->getOperator() . ' ';
        }
        $return .= $this->getTableNameAs() . '.' . $this->getOnSecondField();

        return $return;
    }


    public function asSQLStatement(ActiveRecord $ar)
    {
        return $this->asStatementText($ar, ' AS ');
    }


    public function asORACLEStatement(ActiveRecord $ar)
    {
        return $this->asStatementText($ar, ' ');
    }


    public function setLeft()
    {
        $this->setType(self::TYPE_LEFT);
    }


    public function setRght()
    {
        $this->setType(self::TYPE_RIGHT);
    }


    public function setInner()
    {
        $this->setType(self::TYPE_INNER);
    }


    public function setFields($fields)
    {
        $this->fields = $fields;
    }


    public function getFields()
    {
        return $this->fields;
    }


    public function setOnFirstField($on_first_field)
    {
        $this->on_first_field = $on_first_field;
    }


    public function getOnFirstField()
    {
        return $this->on_first_field;
    }


    public function setOnSecondField($on_second_field)
    {
        $this->on_second_field = $on_second_field;
    }


    public function getOnSecondField()
    {
        return $this->on_second_field;
    }


    public function setOperator($operator)
    {
        $this->operator = $operator;
    }


    public function getOperator()
    {
        return $this->operator;
    }


    public function setTableName($table_name)
    {
        $this->table_name = $table_name;
    }


    public function getTableName()
    {
        return $this->table_name;
    }


    public function setType($type)
    {
        $this->type = $type;
    }


    public function getType()
    {
        return $this->type;
    }


    public function setBothExternal($both_external)
    {
        $this->both_external = $both_external;
    }


    public function getBothExternal()
    {
        return $this->both_external;
    }


    public function setFullNames($full_names)
    {
        $this->full_names = $full_names;
    }


    public function getFullNames()
    {
        return $this->full_names;
    }


    public function isIsMapped()
    {
        return $this->is_mapped;
    }


    public function setIsMapped($is_mapped)
    {
        $this->is_mapped = $is_mapped;
    }
}