src\pdodatabase\elementos\Joins

Complexity

Total Complexity

6

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	campos()	0	10	2
A	__construct()	0	5	1
A	setCampos()	0	5	1
A	sql()	0	10	2

<?php
namespace src\pdodatabase\elementos;

use src\pdodatabase\elementos\Tabla;
use src\pdodatabase\elementos\Campos;

class Joins
{
    private $_joins;
    private $_tabla;
    private $_campos;

    public function __construct(Tabla $Tabla, Campos $Campos, array $Joins)
    {
        $this->_joins = array_reverse( (array) $Joins);
        $this->_tabla = $Tabla;
        $this->_campos = $this->setCampos($Campos->sql());
        
    }

    public function sql(): string
    {
        $sql = '';

        foreach ($this->_joins as $join)
        {
            $sql = $join->sql().' '.$sql;
        }

        return 'SELECT '.$this->_campos.','.$this->campos(). ' FROM '. $this->_tabla->sql().' '.$sql;
    }

    private function campos(): string
    {
        $campos = '';

        foreach ($this->_joins as $join)
        {
            $campos = $campos.$join->campos().',';
        }

        return trim($campos,',');
    }

    private function setCampos(string $campos): string
    {
        $campos = str_replace(',',','.$this->_tabla->sql().'.',$campos);

        return $this->_tabla->sql().'.'.$campos;
    }
}