Code
Explorer
You are a developer and looking for Shopware projects?
Apply Now!
getDqlFromTokens example
->
innerJoin
(
'detail.attribute', 'attr'
)
->
leftJoin
(
'detail.article', 'article'
)
;
foreach
(
$joinEntities
as
$entity
)
{
$join
=
$this
->
getDqlHelper
(
)
->
getAssociationForEntity
(
$entity
)
;
if
(
!\
is_string
(
$join
)
)
{
continue
;
}
$builder
->
leftJoin
(
$join
,
$this
->
getDqlHelper
(
)
->
getPrefixForEntity
(
$entity
)
)
;
}
list
(
$dql
,
$params
)
=
$this
->
getDqlHelper
(
)
->
getDqlFromTokens
(
$tokens
)
;
foreach
(
$params
as
$key
=>
$value
)
{
$builder
->
setParameter
(
$key
,
$value
)
;
}
$builder
->
andWhere
(
$dql
)
;
if
(
$orderByInfo
)
{
$direction
=
isset
(
$orderBy
[
'direction'
]
)
?
$orderBy
[
'direction'
]
: 'DESC';
$field
=
$orderByInfo
[
'field'
]
;
$builder
->
orderBy
(
strtolower
(
$orderByInfo
[
'entity'
]
)
. '.' .
$field
,
$direction
)
;
}
else
{