SubmissionQueryBuilder.inc.php

<?php
 
namespace APP\Services\QueryBuilders;
 
use Illuminate\Database\Capsule\Manager as Capsule;
 
class SubmissionQueryBuilder extends \PKP\Services\QueryBuilders\PKPSubmissionQueryBuilder {
 
   protected $issueIds = null;
 
   protected $sectionIds = null;
 
   public function filterByIssues($issueIds) {
      if (!is_null($issueIds) && !is_array($issueIds)) {
         $issueIds = [$issueIds];
      }
      $this->issueIds = $issueIds;
      return $this;
   }
 
   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->issueIds)) {
         $issueIds = $this->issueIds;
         $q->leftJoin('publications as issue_p', 'issue_p.submission_id', '=', 's.submission_id')
            ->leftJoin('publication_settings as issue_ps','issue_p.publication_id','=','issue_ps.publication_id')
            ->where(function($q) use ($issueIds) {
               $q->where('issue_ps.setting_name', '=', 'issueId');
               $q->whereIn('issue_ps.setting_value', $issueIds);
            });
      }
 
      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;
   }
}