Jacobemerick\Web\Domain\Blog\Series\MysqlSeriesRepository::getSeriesForPost()

Complexity

Conditions	1
Paths	1

Size

Total Lines	25
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public function getSeriesForPost($post)
    {
        $query = "
            SELECT `series`.`title` AS `series_title`, `series`.`description` AS `series_descriptions`,
                   `post.id` AS `post`, `post`.`title`, `post`.`category`, `post`.`path`
            FROM `jpemeric_blog`.`series`
            INNER JOIN `jpemeric_blog`.`series_post` ON `series_post`.`series` = `series.`id`
            INNER JOIN `jpemeric_blog`.`post` ON `post`.`id` = `series_post`.`post` AND
                                                 `post`.`display` = :is_active
            WHERE `series`.`id` = (
                SELECT `series`
                FROM `jpemeric_blog`.`series_post`
                WHERE `post` = :lookup_post
                LIMIT 1)
            ORDER BY `series_post`.`order`";
        $bindings = [
            'is_active'   => 1,
            'lookup_post' => $post,
        ];

        return $this
            ->connections
            ->getRead()
            ->fetchAll($query, $bindings);
    }
}