Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. $dateTarget = $dateTarget ?: new \DateTime();
  2. $qb = $this->createQueryBuilder('ag');
  3.  
  4. $qb->leftJoin('ag.categories', 'ac', Expr\Join::ON)
  5. ->leftJoin('ag.usedBudget', 'aub', Expr\Join::ON)
  6. ->where(
  7. $qb->expr()->andX(
  8. $qb->expr()->lte('ag.fromDateTime', ':dateTarget'),
  9. $qb->expr()->gte('ag.toDateTime', ':dateTarget'),
  10. $qb->expr()->eq('ag.published', 1),
  11. $qb->expr()->gte('ag.totalBudget', 'aub.totalBudget'),
  12. $qb->expr()->orX(
  13. $qb->expr()->gte('ag.dailyBudget', 'aub.dailyBudget'),
  14. $qb->expr()->lt('DATEDIFF(aub.updateDateTime, NOW())', 0)
  15. ),
  16. $qb->expr()->orX(
  17. $qb->expr()->eq('ag.brand', ':brand'),
  18. $qb->expr()->eq('ac', ':category')
  19. )
  20. )
  21. )
  22. ;
  23. $qb->setParameter('brand', $tag->getBrand());
  24. $qb->setParameter('category', $tag->getCategory());
  25. $qb->setParameter('dateTarget', $dateTarget);
  26.  
  27. return $qb->getQuery()->getResult();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement