Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F78326994
AlmanacServiceQuery.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Mon, Aug 19, 20:37
Size
4 KB
Mime Type
text/x-php
Expires
Wed, Aug 21, 20:37 (2 d)
Engine
blob
Format
Raw Data
Handle
19980837
Attached To
rPH Phabricator
AlmanacServiceQuery.php
View Options
<?php
final
class
AlmanacServiceQuery
extends
AlmanacQuery
{
private
$ids
;
private
$phids
;
private
$names
;
private
$serviceClasses
;
private
$devicePHIDs
;
private
$locked
;
private
$namePrefix
;
private
$nameSuffix
;
private
$needBindings
;
public
function
withIDs
(
array
$ids
)
{
$this
->
ids
=
$ids
;
return
$this
;
}
public
function
withPHIDs
(
array
$phids
)
{
$this
->
phids
=
$phids
;
return
$this
;
}
public
function
withNames
(
array
$names
)
{
$this
->
names
=
$names
;
return
$this
;
}
public
function
withServiceClasses
(
array
$classes
)
{
$this
->
serviceClasses
=
$classes
;
return
$this
;
}
public
function
withDevicePHIDs
(
array
$phids
)
{
$this
->
devicePHIDs
=
$phids
;
return
$this
;
}
public
function
withLocked
(
$locked
)
{
$this
->
locked
=
$locked
;
return
$this
;
}
public
function
withNamePrefix
(
$prefix
)
{
$this
->
namePrefix
=
$prefix
;
return
$this
;
}
public
function
withNameSuffix
(
$suffix
)
{
$this
->
nameSuffix
=
$suffix
;
return
$this
;
}
public
function
needBindings
(
$need_bindings
)
{
$this
->
needBindings
=
$need_bindings
;
return
$this
;
}
protected
function
loadPage
()
{
return
$this
->
loadStandardPage
(
new
AlmanacService
());
}
protected
function
buildJoinClauseParts
(
AphrontDatabaseConnection
$conn
)
{
$joins
=
parent
::
buildJoinClauseParts
(
$conn
);
if
(
$this
->
devicePHIDs
!==
null
)
{
$joins
[]
=
qsprintf
(
$conn
,
'JOIN %T binding ON service.phid = binding.servicePHID'
,
id
(
new
AlmanacBinding
())->
getTableName
());
}
return
$joins
;
}
protected
function
buildWhereClauseParts
(
AphrontDatabaseConnection
$conn
)
{
$where
=
parent
::
buildWhereClauseParts
(
$conn
);
if
(
$this
->
ids
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'service.id IN (%Ld)'
,
$this
->
ids
);
}
if
(
$this
->
phids
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'service.phid IN (%Ls)'
,
$this
->
phids
);
}
if
(
$this
->
names
!==
null
)
{
$hashes
=
array
();
foreach
(
$this
->
names
as
$name
)
{
$hashes
[]
=
PhabricatorHash
::
digestForIndex
(
$name
);
}
$where
[]
=
qsprintf
(
$conn
,
'service.nameIndex IN (%Ls)'
,
$hashes
);
}
if
(
$this
->
serviceClasses
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'service.serviceClass IN (%Ls)'
,
$this
->
serviceClasses
);
}
if
(
$this
->
devicePHIDs
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'binding.devicePHID IN (%Ls)'
,
$this
->
devicePHIDs
);
}
if
(
$this
->
locked
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'service.isLocked = %d'
,
(
int
)
$this
->
locked
);
}
if
(
$this
->
namePrefix
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'service.name LIKE %>'
,
$this
->
namePrefix
);
}
if
(
$this
->
nameSuffix
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'service.name LIKE %<'
,
$this
->
nameSuffix
);
}
return
$where
;
}
protected
function
willFilterPage
(
array
$services
)
{
$service_types
=
AlmanacServiceType
::
getAllServiceTypes
();
foreach
(
$services
as
$key
=>
$service
)
{
$service_class
=
$service
->
getServiceClass
();
$service_type
=
idx
(
$service_types
,
$service_class
);
if
(!
$service_type
)
{
$this
->
didRejectResult
(
$service
);
unset
(
$services
[
$key
]);
continue
;
}
$service
->
attachServiceType
(
$service_type
);
}
return
$services
;
}
protected
function
didFilterPage
(
array
$services
)
{
if
(
$this
->
needBindings
)
{
$service_phids
=
mpull
(
$services
,
'getPHID'
);
$bindings
=
id
(
new
AlmanacBindingQuery
())
->
setViewer
(
$this
->
getViewer
())
->
withServicePHIDs
(
$service_phids
)
->
execute
();
$bindings
=
mgroup
(
$bindings
,
'getServicePHID'
);
foreach
(
$services
as
$service
)
{
$service_bindings
=
idx
(
$bindings
,
$service
->
getPHID
(),
array
());
$service
->
attachBindings
(
$service_bindings
);
}
}
return
parent
::
didFilterPage
(
$services
);
}
protected
function
getPrimaryTableAlias
()
{
return
'service'
;
}
public
function
getOrderableColumns
()
{
return
parent
::
getOrderableColumns
()
+
array
(
'name'
=>
array
(
'table'
=>
$this
->
getPrimaryTableAlias
(),
'column'
=>
'name'
,
'type'
=>
'string'
,
'unique'
=>
true
,
'reverse'
=>
true
,
),
);
}
protected
function
getPagingValueMap
(
$cursor
,
array
$keys
)
{
$service
=
$this
->
loadCursorObject
(
$cursor
);
return
array
(
'id'
=>
$service
->
getID
(),
'name'
=>
$service
->
getName
(),
);
}
public
function
getBuiltinOrders
()
{
return
array
(
'name'
=>
array
(
'vector'
=>
array
(
'name'
),
'name'
=>
pht
(
'Service Name'
),
),
)
+
parent
::
getBuiltinOrders
();
}
}
Event Timeline
Log In to Comment