Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F78457840
DrydockLeaseQuery.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
Wed, Aug 21, 00:22
Size
2 KB
Mime Type
text/x-php
Expires
Fri, Aug 23, 00:22 (1 d, 23 h)
Engine
blob
Format
Raw Data
Handle
20047078
Attached To
rPH Phabricator
DrydockLeaseQuery.php
View Options
<?php
final
class
DrydockLeaseQuery
extends
PhabricatorCursorPagedPolicyAwareQuery
{
private
$ids
;
private
$phids
;
private
$resourceIDs
;
private
$statuses
;
public
function
withIDs
(
array
$ids
)
{
$this
->
ids
=
$ids
;
return
$this
;
}
public
function
withPHIDs
(
array
$phids
)
{
$this
->
phids
=
$phids
;
return
$this
;
}
public
function
withResourceIDs
(
array
$ids
)
{
$this
->
resourceIDs
=
$ids
;
return
$this
;
}
public
function
withStatuses
(
array
$statuses
)
{
$this
->
statuses
=
$statuses
;
return
$this
;
}
public
function
loadPage
()
{
$table
=
new
DrydockLease
();
$conn_r
=
$table
->
establishConnection
(
'r'
);
$data
=
queryfx_all
(
$conn_r
,
'SELECT lease.* FROM %T lease %Q %Q %Q'
,
$table
->
getTableName
(),
$this
->
buildWhereClause
(
$conn_r
),
$this
->
buildOrderClause
(
$conn_r
),
$this
->
buildLimitClause
(
$conn_r
));
return
$table
->
loadAllFromArray
(
$data
);
}
public
function
willFilterPage
(
array
$leases
)
{
$resources
=
id
(
new
DrydockResourceQuery
())
->
setParentQuery
(
$this
)
->
setViewer
(
$this
->
getViewer
())
->
withIDs
(
mpull
(
$leases
,
'getResourceID'
))
->
execute
();
foreach
(
$leases
as
$key
=>
$lease
)
{
$resource
=
idx
(
$resources
,
$lease
->
getResourceID
());
if
(!
$resource
)
{
unset
(
$leases
[
$key
]);
continue
;
}
$lease
->
attachResource
(
$resource
);
}
return
$leases
;
}
private
function
buildWhereClause
(
AphrontDatabaseConnection
$conn_r
)
{
$where
=
array
();
if
(
$this
->
resourceIDs
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'resourceID IN (%Ld)'
,
$this
->
resourceIDs
);
}
if
(
$this
->
ids
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'id IN (%Ld)'
,
$this
->
ids
);
}
if
(
$this
->
phids
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'phid IN (%Ls)'
,
$this
->
phids
);
}
if
(
$this
->
statuses
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'status IN (%Ld)'
,
$this
->
statuses
);
}
$where
[]
=
$this
->
buildPagingClause
(
$conn_r
);
return
$this
->
formatWhereClause
(
$where
);
}
public
function
getQueryApplicationClass
()
{
return
'PhabricatorApplicationDrydock'
;
}
}
Event Timeline
Log In to Comment