Germania\Websites\PdoAllWebsites

Complexity

Total Complexity

6

Size/Duplication

Total Lines	67
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Test Coverage

Coverage

68.18%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	__construct()	0	52	6

<?php
namespace Germania\Websites;

class PdoAllWebsites extends Websites implements WebsitesInterface
{

    /**
     * @var string
     */
    public $table = 'pages';

    /**
     * @param PDO             $pdo
     * @param string          $table    Websites table name
     * @param WebsiteAbstract $website  Optional: Website template object
     */
    public function __construct( \PDO $pdo, $table, WebsiteAbstract $website = null  )
    {
        $this->table = $table;

        // ID is listed twice here in order to use it with FETCH_UNIQUE as array key
        $sql = "SELECT
        id,
        id,
        title,
        via,
        route,
        route_name,
        content_file,
        middleware,
        controller,
        template,
        dom_id,
        javascripts,
        stylesheets,
        is_active

        FROM {$this->table}

        WHERE 1";

        $stmt = $pdo->prepare( $sql );

        $stmt->setFetchMode( \PDO::FETCH_CLASS, $website ? get_class($website) : Website::class );

        if (!$stmt->execute()):
            throw new \RuntimeException("Could not retrieve Websites from database");
        endif;

        $this->websites = array_map(function($row) {

            // Cast numeric is_active field to integer
            $row->is_active = (int) $row->is_active;

            // Split into array
            if (isset($row->javascripts)):
                $row->javascripts = preg_split("/[\s,]+/", trim($row->javascripts));
            endif;
            if (isset($row->stylesheets)):
                $row->stylesheets = preg_split("/[\s,]+/", trim($row->stylesheets));
            endif;
            if (isset($row->via)):
                $row->via = preg_split("/[\s,]+/", trim($row->via));
            endif;

            return $row;
        }, $stmt->fetchAll(\PDO::FETCH_UNIQUE));
    }

}