/** * Get Query for All Entities * * @param Docgroupsyst $dg * * @return \Doctrine\ORM\Query */ public function getAllChildsQuery(Docgroupsyst $dg) { $c = $dg->getCompany(); $qb = $this->createQueryBuilder('d')->join('d.company', 'c')->where('c.id = :cid')->andWhere('d.pageUrlFull LIKE :url')->andWhere('d.id != :did')->orderBy('d.pageUrlFull', 'ASC')->setParameter('cid', $c->getId())->setParameter('url', $dg->getPageUrlFull() . '%')->setParameter('did', $dg->getId()); $query = $qb->getQuery(); return $query; }