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;


        public function asSQLStatement(ActiveRecord $ar) {
                $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 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;
        }
}

?>