src/applications/badges/query/PhabricatorBadgesQuery.php

   1 <?php
   2
   3 final class PhabricatorBadgesQuery
   4   extends PhabricatorCursorPagedPolicyAwareQuery {
   5
   6   private $ids;
   7   private $phids;
   8   private $qualities;
   9   private $statuses;
  10
  11   public function withIDs(array $ids) {
  12     $this->ids = $ids;
  13     return $this;
  14   }
  15
  16   public function withPHIDs(array $phids) {
  17     $this->phids = $phids;
  18     return $this;
  19   }
  20
  21   public function withQualities(array $qualities) {
  22     $this->qualities = $qualities;
  23     return $this;
  24   }
  25
  26   public function withStatuses(array $statuses) {
  27     $this->statuses = $statuses;
  28     return $this;
  29   }
  30
  31   public function withNameNgrams($ngrams) {
  32     return $this->withNgramsConstraint(
  33       id(new PhabricatorBadgesBadgeNameNgrams()),
  34       $ngrams);
  35   }
  36
  37   protected function loadPage() {
  38     return $this->loadStandardPage($this->newResultObject());
  39   }
  40
  41   protected function getPrimaryTableAlias() {
  42     return 'badges';
  43   }
  44
  45   public function newResultObject() {
  46     return new PhabricatorBadgesBadge();
  47   }
  48
  49   protected function buildWhereClauseParts(AphrontDatabaseConnection $conn) {
  50     $where = parent::buildWhereClauseParts($conn);
  51
  52     if ($this->ids !== null) {
  53       $where[] = qsprintf(
  54         $conn,
  55         'badges.id IN (%Ld)',
  56         $this->ids);
  57     }
  58
  59     if ($this->phids !== null) {
  60       $where[] = qsprintf(
  61         $conn,
  62         'badges.phid IN (%Ls)',
  63         $this->phids);
  64     }
  65
  66     if ($this->qualities !== null) {
  67       $where[] = qsprintf(
  68         $conn,
  69         'badges.quality IN (%Ls)',
  70         $this->qualities);
  71     }
  72
  73     if ($this->statuses !== null) {
  74       $where[] = qsprintf(
  75         $conn,
  76         'badges.status IN (%Ls)',
  77         $this->statuses);
  78     }
  79
  80     return $where;
  81   }
  82
  83   public function getQueryApplicationClass() {
  84     return 'PhabricatorBadgesApplication';
  85   }
  86
  87   public function getBuiltinOrders() {
  88     return array(
  89       'quality' => array(
  90         'vector' => array('quality', 'id'),
  91         'name' => pht('Rarity (Rarest First)'),
  92       ),
  93       'shoddiness' => array(
  94         'vector' => array('-quality', '-id'),
  95         'name' => pht('Rarity (Most Common First)'),
  96       ),
  97     ) + parent::getBuiltinOrders();
  98   }
  99
 100   public function getOrderableColumns() {
 101     return array(
 102       'quality' => array(
 103         'table' => $this->getPrimaryTableAlias(),
 104         'column' => 'quality',
 105         'reverse' => true,
 106         'type' => 'int',
 107       ),
 108     ) + parent::getOrderableColumns();
 109   }
 110
 111
 112   protected function newPagingMapFromPartialObject($object) {
 113     return array(
 114       'id' => (int)$object->getID(),
 115       'quality' => $object->getQuality(),
 116     );
 117   }
 118
 119 }