GalleyQueryBuilder.inc.php

<?php
namespace APP\Services\QueryBuilders;
 
use Illuminate\Database\Capsule\Manager as Capsule;
use PKP\Services\QueryBuilders\Interfaces\EntityQueryBuilderInterface;
 
class GalleyQueryBuilder implements EntityQueryBuilderInterface {
   public $columns;
 
   protected $publicationIds = [];
 
   public function filterByPublicationIds($publicationIds) {
      $this->publicationIds = is_array($publicationIds) ? $publicationIds : [$publicationIds];
      return $this;
   }
 
   public function getCount() {
      return $this
         ->getQuery()
         ->select('g.galley_id')
         ->get()
         ->count();
   }
 
   public function getIds() {
      return $this
         ->getQuery()
         ->select('g.galley_id')
         ->pluck('g.galley_id')
         ->toArray();
   }
 
   public function getQuery() {
      $this->columns = ['*'];
      $q = Capsule::table('publication_galleys as g');
 
      if (!empty($this->publicationIds)) {
         $q->whereIn('g.publication_id', $this->publicationIds);
      }
 
      // Add app-specific query statements
      \HookRegistry::call('Galley::getMany::queryObject', array(&$q, $this));
 
      $q->select($this->columns);
 
      return $q;
   }
}