Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F96620053
PhortunePurchaseQuery.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
Sun, Dec 29, 01:23
Size
2 KB
Mime Type
text/x-php
Expires
Tue, Dec 31, 01:23 (1 d, 23 h)
Engine
blob
Format
Raw Data
Handle
23201032
Attached To
rPH Phabricator
PhortunePurchaseQuery.php
View Options
<?php
final
class
PhortunePurchaseQuery
extends
PhabricatorCursorPagedPolicyAwareQuery
{
private
$ids
;
private
$phids
;
private
$cartPHIDs
;
public
function
withIDs
(
array
$ids
)
{
$this
->
ids
=
$ids
;
return
$this
;
}
public
function
withPHIDs
(
array
$phids
)
{
$this
->
phids
=
$phids
;
return
$this
;
}
public
function
withCartPHIDs
(
array
$cart_phids
)
{
$this
->
cartPHIDs
=
$cart_phids
;
return
$this
;
}
protected
function
loadPage
()
{
$table
=
new
PhortunePurchase
();
$conn
=
$table
->
establishConnection
(
'r'
);
$rows
=
queryfx_all
(
$conn
,
'SELECT purchase.* FROM %T purchase %Q %Q %Q'
,
$table
->
getTableName
(),
$this
->
buildWhereClause
(
$conn
),
$this
->
buildOrderClause
(
$conn
),
$this
->
buildLimitClause
(
$conn
));
return
$table
->
loadAllFromArray
(
$rows
);
}
protected
function
willFilterPage
(
array
$purchases
)
{
$carts
=
id
(
new
PhortuneCartQuery
())
->
setViewer
(
$this
->
getViewer
())
->
setParentQuery
(
$this
)
->
withPHIDs
(
mpull
(
$purchases
,
'getCartPHID'
))
->
execute
();
$carts
=
mpull
(
$carts
,
null
,
'getPHID'
);
foreach
(
$purchases
as
$key
=>
$purchase
)
{
$cart
=
idx
(
$carts
,
$purchase
->
getCartPHID
());
if
(!
$cart
)
{
unset
(
$purchases
[
$key
]);
continue
;
}
$purchase
->
attachCart
(
$cart
);
}
$products
=
id
(
new
PhortuneProductQuery
())
->
setViewer
(
$this
->
getViewer
())
->
setParentQuery
(
$this
)
->
withPHIDs
(
mpull
(
$purchases
,
'getProductPHID'
))
->
execute
();
$products
=
mpull
(
$products
,
null
,
'getPHID'
);
foreach
(
$purchases
as
$key
=>
$purchase
)
{
$product
=
idx
(
$products
,
$purchase
->
getProductPHID
());
if
(!
$product
)
{
unset
(
$purchases
[
$key
]);
continue
;
}
$purchase
->
attachProduct
(
$product
);
}
return
$purchases
;
}
protected
function
buildWhereClause
(
AphrontDatabaseConnection
$conn
)
{
$where
=
array
();
$where
[]
=
$this
->
buildPagingClause
(
$conn
);
if
(
$this
->
ids
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'purchase.id IN (%Ld)'
,
$this
->
ids
);
}
if
(
$this
->
phids
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'purchase.phid IN (%Ls)'
,
$this
->
phids
);
}
if
(
$this
->
cartPHIDs
!==
null
)
{
$where
[]
=
qsprintf
(
$conn
,
'purchase.cartPHID IN (%Ls)'
,
$this
->
cartPHIDs
);
}
return
$this
->
formatWhereClause
(
$conn
,
$where
);
}
public
function
getQueryApplicationClass
()
{
return
'PhabricatorPhortuneApplication'
;
}
}
Event Timeline
Log In to Comment