src/applications/tokens/query/PhabricatorTokenCountQuery.php

   1 <?php
   2
   3 final class PhabricatorTokenCountQuery
   4   extends PhabricatorOffsetPagedQuery {
   5
   6   private $objectPHIDs;
   7
   8   public function withObjectPHIDs(array $object_phids) {
   9     $this->objectPHIDs = $object_phids;
  10     return $this;
  11   }
  12
  13   public function execute() {
  14     $table = new PhabricatorTokenCount();
  15     $conn_r = $table->establishConnection('r');
  16
  17     $rows = queryfx_all(
  18       $conn_r,
  19       'SELECT objectPHID, tokenCount FROM %T %Q %Q',
  20       $table->getTableName(),
  21       $this->buildWhereClause($conn_r),
  22       $this->buildLimitClause($conn_r));
  23
  24     return ipull($rows, 'tokenCount', 'objectPHID');
  25   }
  26
  27   protected function buildWhereClause(AphrontDatabaseConnection $conn) {
  28     $where = array();
  29
  30     if ($this->objectPHIDs) {
  31       $where[] = qsprintf(
  32         $conn,
  33         'objectPHID IN (%Ls)',
  34         $this->objectPHIDs);
  35     }
  36
  37     return $this->formatWhereClause($conn, $where);
  38   }
  39
  40 }