src/applications/repository/query/PhabricatorRepositoryIdentityQuery.php

   1 <?php
   2
   3 final class PhabricatorRepositoryIdentityQuery
   4   extends PhabricatorCursorPagedPolicyAwareQuery {
   5
   6   private $ids;
   7   private $phids;
   8   private $identityNames;
   9   private $emailAddresses;
  10   private $assignedPHIDs;
  11   private $effectivePHIDs;
  12   private $identityNameLike;
  13   private $hasEffectivePHID;
  14   private $relatedPHIDs;
  15
  16   public function withIDs(array $ids) {
  17     $this->ids = $ids;
  18     return $this;
  19   }
  20
  21   public function withPHIDs(array $phids) {
  22     $this->phids = $phids;
  23     return $this;
  24   }
  25
  26   public function withIdentityNames(array $names) {
  27     $this->identityNames = $names;
  28     return $this;
  29   }
  30
  31   public function withIdentityNameLike($name_like) {
  32     $this->identityNameLike = $name_like;
  33     return $this;
  34   }
  35
  36   public function withEmailAddresses(array $addresses) {
  37     $this->emailAddresses = $addresses;
  38     return $this;
  39   }
  40
  41   public function withAssignedPHIDs(array $assigned) {
  42     $this->assignedPHIDs = $assigned;
  43     return $this;
  44   }
  45
  46   public function withEffectivePHIDs(array $effective) {
  47     $this->effectivePHIDs = $effective;
  48     return $this;
  49   }
  50
  51   public function withRelatedPHIDs(array $related) {
  52     $this->relatedPHIDs = $related;
  53     return $this;
  54   }
  55
  56   public function withHasEffectivePHID($has_effective_phid) {
  57     $this->hasEffectivePHID = $has_effective_phid;
  58     return $this;
  59   }
  60
  61   public function newResultObject() {
  62     return new PhabricatorRepositoryIdentity();
  63   }
  64
  65   protected function getPrimaryTableAlias() {
  66      return 'identity';
  67    }
  68
  69   protected function buildWhereClauseParts(AphrontDatabaseConnection $conn) {
  70     $where = parent::buildWhereClauseParts($conn);
  71
  72     if ($this->ids !== null) {
  73       $where[] = qsprintf(
  74         $conn,
  75         'identity.id IN (%Ld)',
  76         $this->ids);
  77     }
  78
  79     if ($this->phids !== null) {
  80       $where[] = qsprintf(
  81         $conn,
  82         'identity.phid IN (%Ls)',
  83         $this->phids);
  84     }
  85
  86     if ($this->assignedPHIDs !== null) {
  87       $where[] = qsprintf(
  88         $conn,
  89         'identity.manuallySetUserPHID IN (%Ls)',
  90         $this->assignedPHIDs);
  91     }
  92
  93     if ($this->effectivePHIDs !== null) {
  94       $where[] = qsprintf(
  95         $conn,
  96         'identity.currentEffectiveUserPHID IN (%Ls)',
  97         $this->effectivePHIDs);
  98     }
  99
 100     if ($this->hasEffectivePHID !== null) {
 101       if ($this->hasEffectivePHID) {
 102         $where[] = qsprintf(
 103           $conn,
 104           'identity.currentEffectiveUserPHID IS NOT NULL');
 105       } else {
 106         $where[] = qsprintf(
 107           $conn,
 108           'identity.currentEffectiveUserPHID IS NULL');
 109       }
 110     }
 111
 112     if ($this->identityNames !== null) {
 113       $name_hashes = array();
 114       foreach ($this->identityNames as $name) {
 115         $name_hashes[] = PhabricatorHash::digestForIndex($name);
 116       }
 117
 118       $where[] = qsprintf(
 119         $conn,
 120         'identity.identityNameHash IN (%Ls)',
 121         $name_hashes);
 122     }
 123
 124     if ($this->emailAddresses !== null) {
 125       $where[] = qsprintf(
 126         $conn,
 127         'identity.emailAddress IN (%Ls)',
 128         $this->emailAddresses);
 129     }
 130
 131     if ($this->identityNameLike != null) {
 132       $where[] = qsprintf(
 133         $conn,
 134         'identity.identityNameRaw LIKE %~',
 135         $this->identityNameLike);
 136     }
 137
 138     if ($this->relatedPHIDs !== null) {
 139       $where[] = qsprintf(
 140         $conn,
 141         '(identity.manuallySetUserPHID IN (%Ls) OR
 142           identity.currentEffectiveUserPHID IN (%Ls) OR
 143           identity.automaticGuessedUserPHID IN (%Ls))',
 144         $this->relatedPHIDs,
 145         $this->relatedPHIDs,
 146         $this->relatedPHIDs);
 147     }
 148
 149     return $where;
 150   }
 151
 152   public function getQueryApplicationClass() {
 153     return 'PhabricatorDiffusionApplication';
 154   }
 155
 156 }