Airship\Cabin\Hull\Blueprint\Blog::getParentSeries PHP Method

getParentSeries() public method

Get all of the parent series that a series belongs to.
public getParentSeries ( integer $seriesId, array $seenIds = [], integer $depth ) : array
$seriesId integer
$seenIds array
$depth integer
return array
    public function getParentSeries(int $seriesId, array $seenIds = [], int $depth = 0) : array
    {
        $addendum = '';
        if (!empty($seenIds)) {
            $addendum = "AND i.series NOT IN " . $this->db->escapeValueSet($seenIds, 'int');
        }
        return $this->db->run("\n            SELECT\n                s.*,\n                i.listorder,\n                '" . $depth . "' as depth\n            FROM\n                hull_blog_series s\n            LEFT JOIN\n                hull_blog_series_items i\n                ON i.parent = s.seriesid\n            WHERE i.series = ?\n            " . $addendum, $seriesId);
    }