Page Menu
Home
Phorge
Search
Configure Global Search
Log In
Files
F2990728
PhabricatorSlowvoteQuery.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Award Token
Flag For Later
Advanced/Developer...
View Handle
View Hovercard
Size
4 KB
Referenced Files
None
Subscribers
None
PhabricatorSlowvoteQuery.php
View Options
<?php
final
class
PhabricatorSlowvoteQuery
extends
PhabricatorCursorPagedPolicyAwareQuery
{
private
$ids
;
private
$phids
;
private
$authorPHIDs
;
private
$withVotesByViewer
;
private
$statuses
;
private
$needOptions
;
private
$needChoices
;
private
$needViewerChoices
;
public
function
withIDs
(
$ids
)
{
$this
->
ids
=
$ids
;
return
$this
;
}
public
function
withPHIDs
(
$phids
)
{
$this
->
phids
=
$phids
;
return
$this
;
}
public
function
withAuthorPHIDs
(
$author_phids
)
{
$this
->
authorPHIDs
=
$author_phids
;
return
$this
;
}
public
function
withVotesByViewer
(
$with_vote
)
{
$this
->
withVotesByViewer
=
$with_vote
;
return
$this
;
}
public
function
withStatuses
(
array
$statuses
)
{
$this
->
statuses
=
$statuses
;
return
$this
;
}
public
function
needOptions
(
$need_options
)
{
$this
->
needOptions
=
$need_options
;
return
$this
;
}
public
function
needChoices
(
$need_choices
)
{
$this
->
needChoices
=
$need_choices
;
return
$this
;
}
public
function
needViewerChoices
(
$need_viewer_choices
)
{
$this
->
needViewerChoices
=
$need_viewer_choices
;
return
$this
;
}
public
function
newResultObject
(
)
{
return
new
PhabricatorSlowvotePoll
(
)
;
}
protected
function
willFilterPage
(
array
$polls
)
{
assert_instances_of
(
$polls
,
'PhabricatorSlowvotePoll'
)
;
$ids
=
mpull
(
$polls
,
'getID'
)
;
$viewer
=
$this
->
getViewer
(
)
;
if
(
$this
->
needOptions
)
{
$options
=
id
(
new
PhabricatorSlowvoteOption
(
)
)
->
loadAllWhere
(
'pollID IN (%Ld)'
,
$ids
)
;
$options
=
mgroup
(
$options
,
'getPollID'
)
;
foreach
(
$polls
as
$poll
)
{
$poll
->
attachOptions
(
idx
(
$options
,
$poll
->
getID
(
)
,
array
(
)
)
)
;
}
}
if
(
$this
->
needChoices
)
{
$choices
=
id
(
new
PhabricatorSlowvoteChoice
(
)
)
->
loadAllWhere
(
'pollID IN (%Ld)'
,
$ids
)
;
$choices
=
mgroup
(
$choices
,
'getPollID'
)
;
foreach
(
$polls
as
$poll
)
{
$poll
->
attachChoices
(
idx
(
$choices
,
$poll
->
getID
(
)
,
array
(
)
)
)
;
}
// If we need the viewer's choices, we can just fill them from the data
// we already loaded.
if
(
$this
->
needViewerChoices
)
{
foreach
(
$polls
as
$poll
)
{
$poll
->
attachViewerChoices
(
$viewer
,
idx
(
mgroup
(
$poll
->
getChoices
(
)
,
'getAuthorPHID'
)
,
$viewer
->
getPHID
(
)
,
array
(
)
)
)
;
}
}
}
else
if
(
$this
->
needViewerChoices
)
{
$choices
=
id
(
new
PhabricatorSlowvoteChoice
(
)
)
->
loadAllWhere
(
'pollID IN (%Ld) AND authorPHID = %s'
,
$ids
,
$viewer
->
getPHID
(
)
)
;
$choices
=
mgroup
(
$choices
,
'getPollID'
)
;
foreach
(
$polls
as
$poll
)
{
$poll
->
attachViewerChoices
(
$viewer
,
idx
(
$choices
,
$poll
->
getID
(
)
,
array
(
)
)
)
;
}
}
return
$polls
;
}
protected
function
buildWhereClauseParts
(
AphrontDatabaseConnection
$conn
)
{
$where
=
parent
::
buildWhereClauseParts
(
$conn
)
;
if
(
$this
->
ids
!==
null
)
{
$where
[
]
=
qsprintf
(
$conn
,
'p.id IN (%Ld)'
,
$this
->
ids
)
;
}
if
(
$this
->
phids
!==
null
)
{
$where
[
]
=
qsprintf
(
$conn
,
'p.phid IN (%Ls)'
,
$this
->
phids
)
;
}
if
(
$this
->
authorPHIDs
!==
null
)
{
$where
[
]
=
qsprintf
(
$conn
,
'p.authorPHID IN (%Ls)'
,
$this
->
authorPHIDs
)
;
}
if
(
$this
->
statuses
!==
null
)
{
$where
[
]
=
qsprintf
(
$conn
,
'p.status IN (%Ls)'
,
$this
->
statuses
)
;
}
return
$where
;
}
protected
function
buildJoinClauseParts
(
AphrontDatabaseConnection
$conn
)
{
$joins
=
parent
::
buildJoinClauseParts
(
$conn
)
;
if
(
$this
->
withVotesByViewer
!==
null
)
{
$joins
[
]
=
qsprintf
(
$conn
,
'JOIN %T vv ON vv.pollID = p.id AND vv.authorPHID = %s'
,
id
(
new
PhabricatorSlowvoteChoice
(
)
)
->
getTableName
(
)
,
$this
->
getViewer
(
)
->
getPHID
(
)
)
;
}
return
$joins
;
}
protected
function
getPrimaryTableAlias
(
)
{
return
'p'
;
}
public
function
getQueryApplicationClass
(
)
{
return
PhabricatorSlowvoteApplication
::
class
;
}
}
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Sat, Feb 22, 23:45 (19 h, 37 m ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
1180307
Default Alt Text
PhabricatorSlowvoteQuery.php (4 KB)
Attached To
Mode
rP Phorge
Attached
Detach File
Event Timeline
Log In to Comment