HosipLan

Untitled

Mar 23rd, 2011
406
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. class NestedTreeRepository extends Gedmo\Tree\Entity\Repository\NestedTreeRepository
  2. {
  3.  
  4.     public function findTreeByRootId($id)
  5.     {
  6.         // unefectively retrieves all the entities in tree
  7.         // fuck it for now, better that query for each entity
  8.         $this->createQueryBuilder('n')
  9.                 ->select('n', 'ch')
  10.                 ->leftJoin('n.children', 'ch')
  11.                 ->where('n.nodeRoot = :id')
  12.                 ->setParameter('id', $id)
  13.                 ->getQuery()->getResult();
  14.  
  15.         // returns already managed entity
  16.         return $this->find($id);
  17.     }
  18.  
  19. }
Advertisement
Add Comment
Please, Sign In to add comment