ShittyDataLayer

class BlogPostMapper {

    function getBlogPostsForYear($year, $includeInactive) {
        $sqlQuery = $this->sqlQueryFactory->create();
        $sqlQuery->table($this->blogPostTextTable);
        if ($includeInactive == true) {
            $sqlQuery->table($this->blogPostTable);
        }
        else{
            $sqlQuery->table($this->blogPostTable)->whereColumn('isActive', 1);
        }

        $contentTableAlias = $sqlQuery->table($this->contentTable);
        $contentTableAlias->whereColumnFunction('YEAR', 'datestamp',  $year);
        $sqlQuery->order($contentTableAlias, 'datestamp', 'DESC');
        $blogList = $sqlQuery->fetch();

        return castArraysToObjects('BaseReality\Content\BlogPost', $blogList);
    }
}