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

    protected function getSeriesLink(int $series, int $listOrder, string $which = 'curr') : string
    {
        $query = "\n            SELECT\n                *\n            FROM\n                hull_blog_series_items\n            WHERE\n                parent = ?\n            AND listorder";
        // Dynamic query:
        switch ($which) {
            case 'prev':
                $query .= ' < ? ORDER BY listorder DESC';
                break;
            case 'curr':
                $query .= ' = ?';
                break;
            case 'next':
                $query .= ' > ? ORDER BY listorder ASC';
                break;
            default:
                $query .= ' != ? ORDER BY listorder ASC';
        }
        $data = $this->db->row($query, $series, $listOrder);
        if (empty($data)) {
            return '';
        }
        if (!empty($data['series'])) {
            return '/blog/series/' . $this->db->cell('SELECT slug FROM hull_blog_series WHERE seriesid = ?', $data['series']);
        }
        if (!empty($data['post'])) {
            $b = $this->db->row('SELECT blogyear, blogmonth, slug FROM view_hull_blog_list WHERE postid = ?', $data['post']);
            return '/blog/' . $b['blogyear'] . '/' . \str_pad($b['blogmonth'], 2, '0', STR_PAD_LEFT) . '/' . $b['slug'];
        }
        return '';
    }