Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F81605569
ConpherenceFulltextQuery.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
Sat, Sep 7, 00:14
Size
2 KB
Mime Type
text/x-php
Expires
Mon, Sep 9, 00:14 (2 d)
Engine
blob
Format
Raw Data
Handle
20599079
Attached To
rPH Phabricator
ConpherenceFulltextQuery.php
View Options
<?php
final
class
ConpherenceFulltextQuery
extends
PhabricatorOffsetPagedQuery
{
private
$threadPHIDs
;
private
$previousTransactionPHIDs
;
private
$fulltext
;
public
function
withThreadPHIDs
(
array
$phids
)
{
$this
->
threadPHIDs
=
$phids
;
return
$this
;
}
public
function
withPreviousTransactionPHIDs
(
array
$phids
)
{
$this
->
previousTransactionPHIDs
=
$phids
;
return
$this
;
}
public
function
withFulltext
(
$fulltext
)
{
$this
->
fulltext
=
$fulltext
;
return
$this
;
}
public
function
execute
()
{
$table
=
new
ConpherenceIndex
();
$conn_r
=
$table
->
establishConnection
(
'r'
);
$rows
=
queryfx_all
(
$conn_r
,
'SELECT threadPHID, transactionPHID, previousTransactionPHID
FROM %T i %Q %Q %Q'
,
$table
->
getTableName
(),
$this
->
buildWhereClause
(
$conn_r
),
$this
->
buildOrderByClause
(
$conn_r
),
$this
->
buildLimitClause
(
$conn_r
));
return
$rows
;
}
protected
function
buildWhereClause
(
AphrontDatabaseConnection
$conn_r
)
{
$where
=
array
();
if
(
$this
->
threadPHIDs
!==
null
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'i.threadPHID IN (%Ls)'
,
$this
->
threadPHIDs
);
}
if
(
$this
->
previousTransactionPHIDs
!==
null
)
{
$where
[]
=
qsprintf
(
$conn_r
,
'i.previousTransactionPHID IN (%Ls)'
,
$this
->
previousTransactionPHIDs
);
}
if
(
strlen
(
$this
->
fulltext
))
{
$compiler
=
PhabricatorSearchDocument
::
newQueryCompiler
();
$tokens
=
$compiler
->
newTokens
(
$this
->
fulltext
);
$compiled_query
=
$compiler
->
compileQuery
(
$tokens
);
$where
[]
=
qsprintf
(
$conn_r
,
'MATCH(i.corpus) AGAINST (%s IN BOOLEAN MODE)'
,
$compiled_query
);
}
return
$this
->
formatWhereClause
(
$where
);
}
private
function
buildOrderByClause
(
AphrontDatabaseConnection
$conn_r
)
{
if
(
strlen
(
$this
->
fulltext
))
{
return
qsprintf
(
$conn_r
,
'ORDER BY MATCH(i.corpus) AGAINST (%s IN BOOLEAN MODE) DESC'
,
$this
->
fulltext
);
}
else
{
return
qsprintf
(
$conn_r
,
'ORDER BY id DESC'
);
}
}
}
Event Timeline
Log In to Comment