PKPAnnouncementQueryBuilder.inc.php

<?php
namespace PKP\Services\QueryBuilders;
 
use Illuminate\Database\Capsule\Manager as Capsule;
use PKP\Services\QueryBuilders\Interfaces\EntityQueryBuilderInterface;
 
class PKPAnnouncementQueryBuilder implements EntityQueryBuilderInterface {
 
   protected $contextIds = [];
 
   protected $searchPhrase = '';
 
   protected $typeIds = [];
 
   public function filterByContextIds($contextIds) {
      $this->contextIds = is_array($contextIds) ? $contextIds : [$contextIds];
      return $this;
   }
 
   public function filterByTypeIds($typeIds) {
      $this->typeIds = is_array($typeIds) ? $typeIds : [$typeIds];
      return $this;
   }
 
   public function searchPhrase($phrase) {
      $this->searchPhrase = $phrase;
      return $this;
   }
 
   public function getCount() {
      return $this
         ->getQuery()
         ->select('a.announcement_id')
         ->get()
         ->count();
   }
 
   public function getIds() {
      return $this
         ->getQuery()
         ->select('a.announcement_id')
         ->pluck('a.announcement_id')
         ->toArray();
   }
 
   public function getQuery() {
      $this->columns = ['a.*'];
      $q = Capsule::table('announcements as a');
 
      if (!empty($this->contextIds)) {
         $q->whereIn('a.assoc_id', $this->contextIds);
      }
 
      if (!empty($this->typeIds)) {
         $q->whereIn('a.type_id', $this->typeIds);
      }
 
      // search phrase
      if (!empty($this->searchPhrase)) {
         $words = explode(' ', $this->searchPhrase);
         if (count($words)) {
            $q->leftJoin('announcement_settings as as','a.announcement_id','=','as.announcement_id');
            foreach ($words as $word) {
               $word = strtolower(addcslashes($word, '%_'));
               $q->where(function($q) use ($word)  {
                  $q->where(function($q) use ($word) {
                     $q->where('as.setting_name', 'title');
                     $q->where(Capsule::raw('lower(as.setting_value)'), 'LIKE', "%{$word}%");
                  })
                  ->orWhere(function($q) use ($word) {
                     $q->where('as.setting_name', 'descriptionShort');
                     $q->where(Capsule::raw('lower(as.setting_value)'), 'LIKE', "%{$word}%");
                  })
                  ->orWhere(function($q) use ($word) {
                     $q->where('as.setting_name', 'description');
                     $q->where(Capsule::raw('lower(as.setting_value)'), 'LIKE', "%{$word}%");
                  });
               });
            }
         }
      }
 
      $q->orderBy('a.date_posted', 'desc');
      $q->groupBy('a.announcement_id');
 
      // Add app-specific query statements
      \HookRegistry::call('Announcement::getMany::queryObject', array(&$q, $this));
 
      $q->select($this->columns);
 
      return $q;
   }
}