<?php
namespace Concrete\Package\PagePickerPlus\Src\Page;
 
use \Concrete\Core\Page\PageList as Base;
use \Pagerfanta\Adapter\DoctrineDbalAdapter;
use \Concrete\Core\Search\Pagination\Pagination;
use \Concrete\Core\Search\Pagination\PagerPagination;
use \Concrete\Package\PagePickerPlus\Block\PagePickerPlus\Controller;
 
/**
 * This PageList returns pages for a PagePicker block.
 * @author Justin van Schaick
 */
class PageList extends Base {
 
   /**
    * The ID of the block to return the pages for
    * @var int
    */
   protected $blockID;
 
   /**
    * @param \Concrete\Core\Search\StickyRequest $req
    */
   public function __construct(\Concrete\Core\Search\StickyRequest $req = null) {
      parent::__construct($req);
 
      // Setup our join; only returns pages that are save to the page picker pages table
      $this->query->leftJoin('p', Controller::PAGES_TABLE, 'ppp', 'ppp.cID = p.cID')->orderBy('ppp.position', 'ASC');
   }
 
   /**
    * Sets the block ID for which to return the pages
    * @param int $blockID
    */
   public function setBlockID($blockID){
      $this->blockID = $blockID;
      $this->query->where('ppp.bID = '.$blockID);
   }
 
   /**
    * Create a namespace or our pagepicker
    * @return string
    */
   public function getQueryPaginationPageParameter() {
      $queryPaginationParameter = parent::getQueryPaginationPageParameter();
 
      return is_null($this->blockID) ? $queryPaginationParameter : 'b_'.$this->blockID;
   }
 
//   /**
//    * @inheritdoc
//    * Purpose of this override introduced in version 3.0 is because Concrete version 8.2 suddenly introduced a second
//    * pagination class called PagerPagination and this creates problems with pagination (duplicated pages). So this override always returns
//    * an instance of the Pagination cass which doesn't produce this error.
//    */
//   protected function createPaginationObject() {
//      $pagination = parent::createPaginationObject();
//
//      if($pagination instanceof PagerPagination) {
//         $adapter = new DoctrineDbalAdapter($this->deliverQueryObject(), function ($query) {
//            // We need to reset the potential custom order by here because otherwise, if we've added
//            // items to the select parts, and we're ordering by them, we get a SQL error
//            // when we get total results, because we're resetting the select
//            $query->resetQueryParts(['groupBy', 'orderBy'])->select('count(distinct p.cID)')->setMaxResults(1);
//         });
//
//         $pagination = new Pagination($this, $adapter);
//      }
//
//      return $pagination;
//   }
}