SubmissionQueryBuilder.inc.php

<?php
 
namespace APP\Services\QueryBuilders;
 
use Illuminate\Database\Capsule\Manager as Capsule;
 
class SubmissionQueryBuilder extends \PKP\Services\QueryBuilders\PKPSubmissionQueryBuilder {
 
   protected $sectionIds = null;
 
   public function filterBySections($sectionIds) {
      if (!is_null($sectionIds) && !is_array($sectionIds)) {
         $sectionIds = [$sectionIds];
      }
      $this->sectionIds = $sectionIds;
      return $this;
   }
 
   public function appGet($q) {
 
      if (!empty($this->sectionIds)) {
         $sectionIds = $this->sectionIds;
         $q->leftJoin('publications as section_p', 'section_p.submission_id', '=', 's.submission_id')
            ->whereIn('section_p.section_id', $sectionIds);
      }
 
      return $q;
   }
}