Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F82585208
FundInitiativeQuery.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
Thu, Sep 12, 06:43
Size
2 KB
Mime Type
text/x-php
Expires
Sat, Sep 14, 06:43 (1 d, 23 h)
Engine
blob
Format
Raw Data
Handle
20718531
Attached To
rPH Phabricator
FundInitiativeQuery.php
View Options
<?php
final
class
FundInitiativeQuery
extends
PhabricatorCursorPagedPolicyAwareQuery
{
private
$ids
;
private
$phids
;
private
$ownerPHIDs
;
private
$statuses
;
private
$needProjectPHIDs
;
public
function
withIDs
(
array
$ids
)
{
$this
->
ids
=
$ids
;
return
$this
;
}
public
function
withPHIDs
(
array
$phids
)
{
$this
->
phids
=
$phids
;
return
$this
;
}
public
function
withOwnerPHIDs
(
array
$phids
)
{
$this
->
ownerPHIDs
=
$phids
;
return
$this
;
}
public
function
withStatuses
(
array
$statuses
)
{
$this
->
statuses
=
$statuses
;
return
$this
;
}
public
function
needProjectPHIDs
(
$need
)
{
$this
->
needProjectPHIDs
=
$need
;
return
$this
;
}
protected
function
loadPage
()
{
$table
=
new
FundInitiative
();
$conn_r
=
$table
->
establishConnection
(
'r'
);
$rows
=
queryfx_all
(
$conn_r
,
'SELECT * FROM %T %Q %Q %Q'
,
$table
->
getTableName
(),
$this
->
buildWhereClause
(
$conn_r
),
$this
->
buildOrderClause
(
$conn_r
),
$this
->
buildLimitClause
(
$conn_r
));
return
$table
->
loadAllFromArray
(
$rows
);
}
protected
function
didFilterPage
(
array
$initiatives
)
{
if
(
$this
->
needProjectPHIDs
)
{
$edge_query
=
id
(
new
PhabricatorEdgeQuery
())
->
withSourcePHIDs
(
mpull
(
$initiatives
,
'getPHID'
))
->
withEdgeTypes
(
array
(
PhabricatorProjectObjectHasProjectEdgeType
::
EDGECONST
,
));
$edge_query
->
execute
();
foreach
(
$initiatives
as
$initiative
)
{
$phids
=
$edge_query
->
getDestinationPHIDs
(
array
(
$initiative
->
getPHID
(),
));
$initiative
->
attachProjectPHIDs
(
$phids
);
}
}
return
$initiatives
;
}
private
function
buildWhereClause
(
AphrontDatabaseConnection
$conn_r
)
{
$where
=
array
();
$where
[]
=
$this
->
buildPagingClause
(
$conn_r
);
if
(
$this
->
ids
!==
null
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'id IN (%Ld)'
,
$this
->
ids
);
}
if
(
$this
->
phids
!==
null
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'phid IN (%Ls)'
,
$this
->
phids
);
}
if
(
$this
->
ownerPHIDs
!==
null
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'ownerPHID IN (%Ls)'
,
$this
->
ownerPHIDs
);
}
if
(
$this
->
statuses
!==
null
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'status IN (%Ls)'
,
$this
->
statuses
);
}
return
$this
->
formatWhereClause
(
$where
);
}
public
function
getQueryApplicationClass
()
{
return
'PhabricatorFundApplication'
;
}
}
Event Timeline
Log In to Comment