/**
* 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;
}
