Query.php

Go to the documentation of this file.

<?php
 
namespace Drupal\common\Storage;
 
use Contracts\SorterInterface;
use Contracts\ConditionerInterface;
use Contracts\OffsetterInterface;
use Contracts\LimiterInterface;
 
class Query implements
    SorterInterface,
    ConditionerInterface,
    OffsetterInterface,
    LimiterInterface {
 
  public $collection;
 
  public $properties = [];
 
  public $conditions = [];
 
 
  public $sorts = [];
 
  public $joins = [];
 
  public $limit = 500;
 
  public $offset = 0;
 
  public $count = FALSE;
 
  public $showDbColumns = FALSE;
 
  public function setCollectionToRetrieve($id) {
    $this->collection = $id;
  }
 
  public function filterByProperty($property) {
    $this->properties[] = $property;
  }
 
  public function conditionByIsEqualTo(string $property, string $value) {
    $this->conditions[] = (object) [
      'property' => $property,
      'value' => $value,
      'operator' => 'LIKE',
    ];
  }
 
  public function limitTo(int $number_of_items) {
    $this->limit = $number_of_items;
  }
 
  public function offsetBy(int $offset) {
    $this->offset = $offset;
  }
 
  public function sortByAscending(string $property) {
    $this->sorts[] = (object) [
      "property" => $property,
      "order" => "asc",
    ];
  }
 
  public function sortByDescending(string $property) {
    $this->sorts[] = (object) [
      "property" => $property,
      "order" => "desc",
    ];
  }
 
  public function count() {
    $this->count = TRUE;
    unset($this->limit);
  }
 
}