<?php
namespace ElementorPro\Core\Database;
if ( ! defined( 'ABSPATH' ) ) {
exit; // Exit if accessed directly
}
/**
* JOIN clause builder.
*
* Essentially, it uses the regular Builder's capabilities while wrapping some method
* for syntactic sugar and better readability.
*/
class Join_Clause extends Query_Builder {
// JOIN types.
const TYPE_INNER = 'inner';
const TYPE_LEFT = 'left';
const TYPE_RIGHT = 'right';
/**
* JOIN type.
*
* @var string
*/
public $type;
/**
* Join_Clause constructor.
*
* @param string $type - JOIN type.
* @param \wpdb|null $connection - MySQL connection to use.
*
* @return void
*/
public function __construct( $type, \wpdb $connection = null ) {
parent::__construct( $connection );
$this->type = $type;
}
/**
* @uses `$this->where()`.
*
* @return Join_Clause
*/
public function on( $column, $operator, $value, $and_or = self::RELATION_AND ) {
return $this->where( $column, $operator, $value, $and_or );
}
/**
* @shortcut `$this->on()`.
*
* @return Join_Clause
*/
public function or_on( $first, $operator, $second ) {
return $this->on( $first, $operator, $second, self::RELATION_OR );
}
/**
* @uses `$this->where_column()`.
*
* @return Join_Clause
*/
public function on_column( $first, $operator, $second, $and_or = self::RELATION_AND ) {
return $this->where_column( $first, $operator, $second, $and_or );
}
/**
* @shortcut `$this->on_column()`.
*
* @return Join_Clause
*/
public function or_on_column( $first, $operator, $second ) {
return $this->on_column( $first, $operator, $second, self::RELATION_OR );
}
}