Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $dateTarget = $dateTarget ?: new \DateTime();
- $qb = $this->createQueryBuilder('ag');
- $qb->leftJoin('ag.categories', 'ac', Expr\Join::ON)
- ->leftJoin('ag.usedBudget', 'aub', Expr\Join::ON)
- ->where(
- $qb->expr()->andX(
- $qb->expr()->lte('ag.fromDateTime', ':dateTarget'),
- $qb->expr()->gte('ag.toDateTime', ':dateTarget'),
- $qb->expr()->eq('ag.published', 1),
- $qb->expr()->gte('ag.totalBudget', 'aub.totalBudget'),
- $qb->expr()->orX(
- $qb->expr()->gte('ag.dailyBudget', 'aub.dailyBudget'),
- $qb->expr()->lt('DATEDIFF(aub.updateDateTime, NOW())', 0)
- ),
- $qb->expr()->orX(
- $qb->expr()->eq('ag.brand', ':brand'),
- $qb->expr()->eq('ac', ':category')
- )
- )
- )
- ;
- $qb->setParameter('brand', $tag->getBrand());
- $qb->setParameter('category', $tag->getCategory());
- $qb->setParameter('dateTarget', $dateTarget);
- return $qb->getQuery()->getResult();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement