Sirius\Orm\Helpers\QueryHelper

Complexity

Total Complexity

5

Size/Duplication

Total Lines	22
Duplicated Lines	0 %

Importance

Changes	2
Bugs	1	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	reference()	0	7	3
A	joinCondition()	0	11	2

<?php
declare(strict_types=1);

namespace Sirius\Orm\Helpers;

class QueryHelper
{
    public static function reference($table, $tableAlias)
    {
        if (! $tableAlias || $table == $tableAlias) {
            return $table;
        }

        return "{$table} as {$tableAlias}";
    }

    public static function joinCondition($firsTable, $firstColumns, $secondTable, $secondColumns)
    {
        $firstColumns = (array) $firstColumns;
        $secondColumns = (array) $secondColumns;

        $parts = [];
        foreach ($firstColumns as $k => $col) {
            $parts[] = "{$firsTable}.{$col} = {$secondTable}.{$secondColumns[$k]}";
        }

        return implode(' AND ', $parts);
    }
}