protected function buildWhereClauseParts(AphrontDatabaseConnection $conn)
{
$where = parent::buildWhereClauseParts($conn);
if ($this->blueprintPHIDs !== null) {
$where[] = qsprintf($conn, 'blueprintPHID IN (%Ls)', $this->blueprintPHIDs);
}
if ($this->resourcePHIDs !== null) {
$where[] = qsprintf($conn, 'resourcePHID IN (%Ls)', $this->resourcePHIDs);
}
if ($this->leasePHIDs !== null) {
$where[] = qsprintf($conn, 'leasePHID IN (%Ls)', $this->leasePHIDs);
}
return $where;
}
protected function buildWhereClauseParts(AphrontDatabaseConnection $conn)
{
$where = parent::buildWhereClauseParts($conn);
if ($this->ids !== null) {
$where[] = qsprintf($conn, 'id IN (%Ld)', $this->ids);
}
if ($this->targetPHIDs !== null) {
$where[] = qsprintf($conn, 'targetPHID IN (%Ls)', $this->targetPHIDs);
}
if ($this->consumed !== null) {
$where[] = qsprintf($conn, 'isConsumed = %d', (int) $this->consumed);
}
return $where;
}
protected function buildWhereClauseParts(AphrontDatabaseConnection $conn)
{
$where = parent::buildWhereClauseParts($conn);
if ($this->resourceIDs !== null) {
$where[] = qsprintf($conn, 'resourceID IN (%Ld)', $this->resourceIDs);
}
if ($this->ids !== null) {
$where[] = qsprintf($conn, 'id IN (%Ld)', $this->ids);
}
if ($this->phids !== null) {
$where[] = qsprintf($conn, 'phid IN (%Ls)', $this->phids);
}
if ($this->statuses !== null) {
$where[] = qsprintf($conn, 'status IN (%Ld)', $this->statuses);
}
return $where;
}
protected function buildWhereClauseParts(AphrontDatabaseConnection $conn)
{
$where = parent::buildWhereClauseParts($conn);
if ($this->ids !== null) {
$where[] = qsprintf($conn, 'id IN (%Ld)', $this->ids);
}
if ($this->phids !== null) {
$where[] = qsprintf($conn, 'phid IN (%Ls)', $this->phids);
}
if ($this->datasourceQuery !== null) {
$where[] = qsprintf($conn, 'blueprintName LIKE %>', $this->datasourceQuery);
}
if ($this->blueprintClasses !== null) {
$where[] = qsprintf($conn, 'className IN (%Ls)', $this->blueprintClasses);
}
return $where;
}
protected function buildWhereClauseParts(AphrontDatabaseConnection $conn)
{
$where = parent::buildWhereClauseParts($conn);
if ($this->ids !== null) {
$where[] = qsprintf($conn, 'id IN (%Ld)', $this->ids);
}
if ($this->phids !== null) {
$where[] = qsprintf($conn, 'phid IN (%Ls)', $this->phids);
}
if ($this->blueprintPHIDs !== null) {
$where[] = qsprintf($conn, 'blueprintPHID IN (%Ls)', $this->blueprintPHIDs);
}
if ($this->objectPHIDs !== null) {
$where[] = qsprintf($conn, 'objectPHID IN (%Ls)', $this->objectPHIDs);
}
if ($this->blueprintStates !== null) {
$where[] = qsprintf($conn, 'blueprintAuthorizationState IN (%Ls)', $this->blueprintStates);
}
if ($this->objectStates !== null) {
$where[] = qsprintf($conn, 'objectAuthorizationState IN (%Ls)', $this->objectStates);
}
return $where;
}
protected function buildWhereClauseParts(AphrontDatabaseConnection $conn)
{
$where = parent::buildWhereClauseParts($conn);
if ($this->ids !== null) {
$where[] = qsprintf($conn, 'id IN (%Ld)', $this->ids);
}
if ($this->phids !== null) {
$where[] = qsprintf($conn, 'phid IN (%Ls)', $this->phids);
}
if ($this->objectPHIDs !== null) {
$where[] = qsprintf($conn, 'objectPHID IN (%Ls)', $this->objectPHIDs);
}
if ($this->repositoryPHIDs !== null) {
$where[] = qsprintf($conn, 'repositoryPHID IN (%Ls)', $this->repositoryPHIDs);
}
if ($this->operationStates !== null) {
$where[] = qsprintf($conn, 'operationState IN (%Ls)', $this->operationStates);
}
if ($this->operationTypes !== null) {
$where[] = qsprintf($conn, 'operationType IN (%Ls)', $this->operationTypes);
}
if ($this->isDismissed !== null) {
$where[] = qsprintf($conn, 'isDismissed = %d', (int) $this->isDismissed);
}
return $where;
}
protected function buildJoinClauseParts(AphrontDatabaseConnection $conn)
{
$joins = parent::buildJoinClauseParts($conn);
if ($this->authorizedPHIDs !== null) {
$joins[] = qsprintf($conn, 'JOIN %T authorization
ON authorization.blueprintPHID = blueprint.phid
AND authorization.objectPHID IN (%Ls)
AND authorization.objectAuthorizationState = %s
AND authorization.blueprintAuthorizationState = %s', id(new DrydockAuthorization())->getTableName(), $this->authorizedPHIDs, DrydockAuthorization::OBJECTAUTH_ACTIVE, DrydockAuthorization::BLUEPRINTAUTH_AUTHORIZED);
}
return $joins;
}
