`mini\Table\Wrappers\LeftJoinTable` class

Show private and protected members

Documentation

Left join of two tables with ON condition

Yields all left rows, with matching right rows merged. Unmatched left rows have NULL for all right columns. Uses property-based binding: left table must have 'bind' property with Predicate.

// SELECT * FROM users u LEFT JOIN orders o ON u.id = o.user_id
new LeftJoinTable(
    $users->withAlias('u')->withProperty('__bind__', p->eqBind('u.id', ':o.user_id')),
    $orders->withAlias('o')
)

Inheritance

Extends: mini\Table\AbstractTable

Implements: mini\Table\Contracts\SetInterface IteratorAggregate Countable Traversable mini\Table\Contracts\TableInterface

Properties (8)

private mini\Table\Predicate $bindPredicate

private array $bindParams

private array $rightColNames

private mini\Table\Contracts\TableInterface $left

private mini\Table\Contracts\TableInterface $right

protected ?Closure $compareFn

protected ?int $limit

protected int $offset

Methods (40)

public `__construct()`

Documentation missing

protected `materialize()`

Documentation missing

private `extractBindings()`

Extract binding values from a right row

private `mergeRows()`

Merge two rows into a single object

private `mergeRowWithNulls()`

Merge left row with NULL values for right columns

public `order()`

Documentation missing

public `eq()`

Documentation missing

public `lt()`

Documentation missing

public `lte()`

Documentation missing

public `gt()`

Documentation missing

public `gte()`

Documentation missing

public `in()`

Documentation missing

public `like()`

Documentation missing

public `count()`

Documentation missing

private `pushFilter()`

Push a filter operation to the appropriate source table

private `withFilteredSources()`

Create new join with filtered source tables, preserving bind and limit/offset

public `__clone()`

inherited from Table\AbstractTable

Hook for subclasses to customize clone behavior

public `getRowKeyColumns()`

inherited from Table\AbstractTable

Get column name(s) that the row key represents

protected `getCompareFn()`

inherited from Table\AbstractTable

Get the string comparison function for sorting

public `limit()`

inherited from Table\AbstractTable

Documentation missing

public `offset()`

inherited from Table\AbstractTable

Documentation missing

public `getLimit()`

inherited from Table\AbstractTable

Documentation missing

public `getOffset()`

inherited from Table\AbstractTable

Documentation missing

public `withAlias()`

inherited from Table\AbstractTable

Documentation missing

public `getTableAlias()`

inherited from Table\AbstractTable

Get the current table alias (null if not set)

public `union()`

inherited from Table\AbstractTable

Documentation missing

public `except()`

inherited from Table\AbstractTable

Documentation missing

public `distinct()`

inherited from Table\AbstractTable

Documentation missing

public `or()`

inherited from Table\AbstractTable

Filter rows matching any of the given predicates (OR semantics)

public `exists()`

inherited from Table\AbstractTable

Documentation missing

public `has()`

inherited from Table\AbstractTable

Check if value(s) exist in the table's projected columns

protected `getPrimaryKeyColumn()`

inherited from Table\AbstractTable

Get the primary key column definition (cached)

public final `getIterator()`

inherited from Table\AbstractTable

Iterate over rows with visible columns only

public `getColumns()`

inherited from Table\AbstractTable

Get columns available for output

public `getAllColumns()`

inherited from Table\AbstractTable

Get all column definitions regardless of projection

public `columns()`

inherited from Table\AbstractTable

Narrow to specific columns

public `load()`

inherited from Table\AbstractTable

Load a single row by its row ID

public `getProperty()`

inherited from Table\AbstractTable

Get a property value

public `hasProperty()`

inherited from Table\AbstractTable

Check if a property exists (including null values)

public `withProperty()`

inherited from Table\AbstractTable

Return table with property set

Source

src/Table/Wrappers/LeftJoinTable.php:28-273