PKPContextQueryBuilder.inc.php

<?php
namespace PKP\Services\QueryBuilders;
 
use Illuminate\Database\Capsule\Manager as Capsule;
use PKP\Services\QueryBuilders\Interfaces\EntityQueryBuilderInterface;
 
abstract class PKPContextQueryBuilder implements EntityQueryBuilderInterface {
 
   protected $db;
 
   protected $dbSettings;
 
   protected $dbIdColumn;
 
   protected $isEnabled = null;
 
   protected $userId;
 
   protected $searchPhrase = null;
 
   public function filterByIsEnabled($isEnabled) {
      $this->isEnabled = $isEnabled;
      return $this;
   }
 
   public function filterByUserId($userId) {
      $this->userId = $userId;
      return $this;
   }
 
   public function searchPhrase($phrase) {
      $this->searchPhrase = $phrase;
      return $this;
   }
 
   public function getCount() {
      return $this
         ->getQuery()
         ->select('c.' . $this->dbIdColumn)
         ->get()
         ->count();
   }
 
   public function getIds() {
      return $this
         ->getQuery()
         ->select('c.' . $this->dbIdColumn)
         ->pluck('c.' . $this->dbIdColumn)
         ->toArray();
   }
 
   public function getManySummary() {
      return $this
         ->getQuery()
         ->select([
            'c.' . $this->dbIdColumn . ' as id',
            'c.enabled',
            'cst.setting_value as name',
            'c.path as urlPath',
            'c.seq',
         ])
         ->leftJoin($this->dbSettings . ' as cst', function($q) {
            $q->where('cst.' . $this->dbIdColumn, '=', Capsule::raw('c.' . $this->dbIdColumn))
               ->where('cst.setting_name', '=', 'name')
               ->where('cst.locale', '=', Capsule::raw('c.primary_locale'));
         })
         ->groupBy([
            'c.' . $this->dbIdColumn,
            'cst.setting_value',
         ])
         ->get()
         ->toArray();
   }
 
   public function getQuery() {
      $this->columns[] = 'c.*';
      $q = Capsule::table($this->db . ' as c')
               ->leftJoin($this->dbSettings . ' as cs', 'cs.' . $this->dbIdColumn, '=', 'c.' . $this->dbIdColumn)
               ->groupBy('c.' . $this->dbIdColumn);
 
      if (!empty($this->isEnabled)) {
         $q->where('c.enabled', '=', 1);
      } elseif ($this->isEnabled === false) {
         $q->where('c.enabled', '!=', 1);
      }
 
      if (!empty($this->userId)) {
         $q->leftJoin('user_groups as ug', 'ug.context_id', '=', 'c.' . $this->dbIdColumn)
            ->leftJoin('user_user_groups as uug', 'uug.user_group_id', '=', 'ug.user_group_id')
            ->where(function($q) {
               $q->where('uug.user_id', '=', $this->userId)
                  ->where(function($q) {
                     $q->where('ug.role_id', '=', ROLE_ID_MANAGER)
                        ->orWhere('c.enabled', '=', 1);
                  });
            });
      }
 
      // search phrase
      if (!empty($this->searchPhrase)) {
         $words = explode(' ', $this->searchPhrase);
         if (count($words)) {
            foreach ($words as $word) {
               $q->where(function($q) use ($word) {
                  $q->where(function($q) use ($word) {
                        $q->where('cs.setting_name', 'name');
                        $q->where('cs.setting_value', 'LIKE', "%{$word}%");
                     })
                     ->orWhere(function($q) use ($word) {
                        $q->where('cs.setting_name', 'description');
                        $q->where('cs.setting_value', 'LIKE', "%{$word}%");
                     })
                     ->orWhere(function($q) use ($word) {
                        $q->where('cs.setting_name', 'acronym');
                        $q->where('cs.setting_value', 'LIKE', "%{$word}%");
                     })
                     ->orWhere(function($q) use ($word) {
                        $q->where('cs.setting_name', 'abbreviation');
                        $q->where('cs.setting_value', 'LIKE', "%{$word}%");
                     });
               });
            }
         }
      }
 
      // Add app-specific query statements
      \HookRegistry::call('Context::getContexts::queryObject', array(&$q, $this));
 
      $q->select($this->columns);
 
      return $q;
   }
}